MANDT |
X |
MANDT |
CLNT |
0 |
3 |
0 |
T000 |
Mandant |
MGUID |
X |
SEPA_MGUID |
CHAR |
3 |
1 |
0 |
|
Mandat SEPA : GUID du mandat |
MNDID |
|
SEPA_MNDID |
CHAR |
19 |
35 |
0 |
|
Mandat SEPA : référence unique sur le mandat par fournisseur |
MVERS |
|
SEPA_MVERS |
|
54 |
|
|
|
|
SIGN_CITY |
|
SEPA_SIGN_CITY |
|
58 |
|
|
|
|
SIGN_DATE |
|
SEPA_SIGN_DATE |
|
98 |
|
|
|
|
PAY_TYPE |
|
SEPA_PAY_TYPE |
|
106 |
|
|
|
|
VAL_FROM_DATE |
|
SEPA_VAL_FROM_DATE |
|
107 |
|
|
|
|
VAL_TO_DATE |
|
SEPA_VAL_TO_DATE |
|
115 |
|
|
|
|
STATUS |
|
SEPA_STATUS |
|
123 |
|
|
|
|
B2B |
|
SEPA_B2B |
|
124 |
|
|
|
|
ERNAM |
|
SEPA_ERNAM |
|
125 |
|
|
|
|
ERDAT |
|
SEPA_ERDAT |
|
137 |
|
|
|
|
ERTIM |
|
SEPA_ERTIM |
|
145 |
|
|
|
|
CHG_REASON |
|
SEPA_CHG_REASON |
|
151 |
|
|
|
|
ORIGIN |
|
CHAR1 |
CHAR |
156 |
1 |
0 |
|
Code à 1 caractère |
ORIGIN_REC_CRDID |
|
SEPA_CRDID_ORIGIN |
|
157 |
|
|
|
|
ORIGIN_MNDID |
|
SEPA_MNDID_ORIGIN |
|
192 |
|
|
|
|
GLOCK |
|
SEPA_GLOCK |
|
227 |
|
|
|
|
GLOCK_VAL_FROM |
|
SEPA_GLOCK_VAL_FROM_DATE |
|
228 |
|
|
|
|
GLOCK_VAL_TO |
|
SEPA_GLOCK_VAL_TO_DATE |
|
236 |
|
|
|
|
ANWND |
|
SEPA_ANWND |
|
244 |
|
|
|
|
ORI_ERNAM |
|
SEPA_ORI_ERNAM |
|
245 |
|
|
|
|
ORI_ERDAT |
|
SEPA_ORI_ERDAT |
|
257 |
|
|
|
|
ORI_ERTIM |
|
SEPA_ORI_ERTIM |
|
265 |
|
|
|
|
REF_TYPE |
|
SEPA_REF_TYPE |
|
271 |
|
|
|
|
REF_ID |
|
SEPA_REF_ID |
|
281 |
|
|
|
|
REF_DESC |
|
TEXT50 |
CHAR |
351 |
50 |
0 |
|
Zone de texte |
SND_TYPE |
|
SEPA_SND_TYPE |
|
401 |
|
|
|
|
SND_ID |
|
SEPA_SND_ID |
|
411 |
|
|
|
|
SND_NAME1 |
|
BU_NAMEP_L |
CHAR |
481 |
40 |
0 |
|
Nom du partenaire (personne) |
SND_NAME2 |
|
BU_NAMEP_F |
CHAR |
521 |
40 |
0 |
|
Prénom du partenaire (personne) |
SND_STREET |
|
AD_STREET |
CHAR |
561 |
60 |
0 |
|
Rue |
SND_HOUSENUM |
|
AD_HSNM1 |
CHAR |
621 |
10 |
0 |
|
Nº de rue |
SND_POSTAL |
|
AD_PSTCD1 |
CHAR |
631 |
10 |
0 |
|
Code postal de la localité |
SND_CITY |
|
AD_CITY1 |
CHAR |
641 |
40 |
0 |
|
Localité |
SND_COUNTRY |
|
LAND1 |
CHAR |
681 |
3 |
0 |
T005 |
Clé de pays |
SND_IBAN |
|
IBAN |
CHAR |
684 |
34 |
0 |
|
IBAN (International Bank Account Number) |
SND_BIC |
|
SWIFT |
CHAR |
718 |
11 |
0 |
|
Code SWIFT pour paiements internationaux |
SND_DIR_NAME |
|
SEPA_PAYMENT_FOR |
|
729 |
|
|
|
|
SND_LANGUAGE |
|
LANGU |
LANG |
769 |
1 |
0 |
T002 |
Code langue |
SND_DIR_ID |
|
SEPA_SND_DIR_ID |
|
770 |
|
|
|
|
SND_DEBTOR_ID |
|
SEPA_SND_DEBTOR_ID |
|
840 |
|
|
|
|
REC_TYPE |
|
SEPA_REC_TYPE |
|
875 |
|
|
|
|
REC_ID |
|
SEPA_REC_ID |
|
885 |
|
|
|
|
REC_NAME1 |
|
BU_NAMEOR1 |
CHAR |
955 |
40 |
0 |
|
Nom 1 de l'organisation |
REC_NAME2 |
|
BU_NAMEOR2 |
CHAR |
995 |
40 |
0 |
|
Nom 2 de l'organisation |
REC_CRDID |
|
SEPA_CRDID |
CHAR |
1035 |
35 |
0 |
|
Code fournisseur (unique et inter-pays) |
REC_STREET |
|
AD_STREET |
CHAR |
1070 |
60 |
0 |
|
Rue |
REC_HOUSENUM |
|
AD_HSNM1 |
CHAR |
1130 |
10 |
0 |
|
Nº de rue |
REC_POSTAL |
|
AD_PSTCD1 |
CHAR |
1140 |
10 |
0 |
|
Code postal de la localité |
REC_CITY |
|
AD_CITY1 |
CHAR |
1150 |
40 |
0 |
|
Localité |
REC_COUNTRY |
|
LAND1 |
CHAR |
1190 |
3 |
0 |
T005 |
Clé de pays |
REC_DIR_NAME |
|
SEPA_REC_DIR_NAME |
|
1193 |
|
|
|
|
REC_DIR_ID |
|
SEPA_REC_DIR_ID |
|
1233 |
|
|
|
|
FIRSTUSE_DATE |
|
SEPA_FIRSTUSE_DATE |
|
1303 |
|
|
|
|
FIRSTUSE_DOCTYPE |
|
SEPA_FIRSTUSE_DOCTYPE |
|
1311 |
|
|
|
|
FIRSTUSE_DOCID |
|
SEPA_FIRSTUSE_DOCID |
|
1321 |
|
|
|
|
LASTUSE_DATE |
|
SEPA_LASTUSE_DATE |
|
1391 |
|
|
|
|
LASTUSE_DOCTYPE |
|
SEPA_LASTUSE_DOCTYPE |
|
1399 |
|
|
|
|
LASTUSE_DOCID |
|
SEPA_LASTUSE_DOCID |
|
1409 |
|
|
|
|
FIRSTUSE_PAYRUN |
|
SEPA_FIRSTUSE_PAYRUNID |
|
1479 |
|
|
|
|
ORGF1 |
|
SEPA_ORG_ID |
|
1495 |
|
|
|
|
ORGF2 |
|
SEPA_ORG_ID |
|
1515 |
|
|
|
|
ORGF3 |
|
SEPA_ORG_ID_LONG |
|
1535 |
|
|
|
|
ORGF4 |
|
SEPA_ORG_ID_LONG |
|
1570 |
|
|
|
|
LAUFD |
|
LAUFD_KK |
DATS |
1605 |
8 |
0 |
|
ID date |
LAUFI |
|
LAUFI_KK |
CHAR |
1613 |
6 |
0 |
|
Caractéristique supplémentaire d'identification |