Mandates Migration
In the Import menu, click the Migration to SDD Mandates tab.
Click Select a File, and then Migrate.
This feature is used to create SDD Mandates based on local format files for Direct Debits.
For France, the format is AFB160.
As the native content of this format does not provide enough information to create SDD Mandates, additional records are required (see the list below).
AFB 160 enriched format
| Record 05A - Mandatory | ||||
|---|---|---|---|---|
|
|
Length |
Start |
End |
Value, Format |
|
Type |
2 |
1 |
2 |
05 |
|
Record Sequence |
1 |
3 |
3 |
To |
|
UMR |
35 |
4 |
38 |
|
|
SCHEMA |
1 |
39 |
39 |
0=CORE, 1=B2B |
|
SDD Type |
1 |
40 |
40 |
0=OOFF, 1=RECUR |
|
Signature Date |
6 |
41 |
46 |
DDMMYY |
|
Place of Signature |
35 |
47 |
81 |
|
|
Mandate Type |
1 |
82 |
82 |
0=NEW, 1=MIGRATE |
|
Migration Date |
6 |
83 |
88 |
DDMMYY |
|
Contract ID |
35 |
89 |
123 |
|
|
Contract Description |
35 |
124 |
158 |
|
|
Form Language |
2 |
159 |
160 |
DE, GB, ES, FR, IT, RO |
|
Record 05B - Optional |
||||
|---|---|---|---|---|
|
|
Length |
Start |
End |
Value, Format |
|
Type |
2 |
1 |
2 |
05 |
|
Record Sequence |
1 |
3 |
3 |
B |
|
Contract - Debtor ID |
35 |
4 |
38 |
|
|
Contract - Payment OBO - Name |
30 |
39 |
68 |
|
|
Contract - Payment OBO - ID |
30 |
69 |
98 |
|
|
Contract - Remittance OBO - Name |
30 |
99 |
128 |
|
|
Contract - Remittance OBO - ID |
30 |
129 |
158 |
|
|
Filler |
2 |
159 |
160 |
|
|
Record 05C - Optional |
||||
|---|---|---|---|---|
|
|
Length |
Start |
End |
Value, Format |
|
Type |
2 |
1 |
2 |
05 |
|
Record Sequence |
1 |
3 |
3 |
C |
|
To be returned to |
140 |
4 |
143 |
|
|
Filler |
17 |
144 |
160 |
|
| Record 05D - Optional | ||||
|---|---|---|---|---|
|
|
Length |
Start |
End |
Value, Format |
|
Type |
2 |
1 |
2 |
05 |
|
Sequence |
1 |
3 |
3 |
D |
|
Other Information |
140 |
4 |
143 |
|
|
Filler |
17 |
144 |
160 |
|
| Record 07A - Optional | ||||
|---|---|---|---|---|
|
|
Length |
Start |
End |
Value, Format |
|
Type |
2 |
1 |
2 |
07 |
|
Sequence |
1 |
3 |
3 |
To |
|
Mandate Modification Flag |
1 |
4 |
4 |
0 = no / 1 = yes |
|
UMR Modification Flag |
1 |
5 |
5 |
0 = no / 1 = yes |
|
UMR before modification |
35 |
6 |
40 |
|
|
Flag for Creditor Name modification |
1 |
41 |
41 |
0 = no / 1 = yes |
|
Creditor Name modification |
35 |
42 |
76 |
|
|
ICS Modification Flag |
1 |
77 |
77 |
0 = no / 1 = yes |
|
ICS before modification |
35 |
78 |
112 |
|
|
Flag for Debtor Bank modification |
1 |
113 |
113 |
0 = no / 1 = yes |
|
Flag for Debtor IBAN modification |
1 |
114 |
114 |
0 = no / 1 = yes |
|
IBAN before modification |
34 |
115 |
148 |
|
|
SDD Sequence |
4 |
149 |
152 |
FRST / OOFF / RCUR / FNAL |
|
Filler |
8 |
153 |
160 |
|
