Importing Mandates
Import Options
Open the Import Options tab from the Procedures menu to display the Option List, then click Add Template.
Options enable you to define specific rules to be automatically applied during import process.
- Unknow ICS creation
- Debtor Creation
- Workgroup Databases Update
- Debtor Bank BIC Definition
- Actions if UMR is provided or not
- Import and potential activation of signed mandates
- Data modification for imported mandates
Manual Import
In the Import menu, click the SDD Mandates tab.
Click Choose file, and then Import.
The imported XML file must comply with the structure specified below.
Automatic Import
You can automatically import authorized Third Parties using IMPVIR.exe with the argument /F: MANDATMTEC.
PDF files for imported mandates are generated through a scheduled task which is different from the control task.
When you try to view a PDF which has not been generated, the following message is displayed: PDF file is being created.
The reject file has the same structure as the file that contains the mandates to import. Only one additional tag makes it different: <reject_reason> under the <mandate> tag to specify the reject reason.
The file can be re-imported without deleting the <reject_reason> tag.
XML Structure
In the mandate import structure, the <default_data> node under the <mandate> tag enables the specification of some default info:
- Schema
- Recurrence Type
- Signature Date
- Mandate Type
- Email
During Import, if the element under the <data> tag is void, then the element under <default_data> is used before the reject.
Information |
XML Tag |
Values / Data Type / Comments |
Mandate List |
<mandate_list> |
|
|
|
|
|
|
Mandate Details |
|
<mandate> |
|
|
|
|
|
Key
|
|
|
<key>
|
|
|
|
|
ICS |
|
|
|
<ics> |
|
|
|
Creditor |
|
|
|
|
<creditor> |
|
SXBE MMI Alias |
Country Code |
|
|
|
|
<country> |
|
ISO Code |
ICS Key |
|
|
|
|
<key> |
|
Checked depending on option |
Activity Code |
|
|
|
|
<business_code> |
|
If empty, value assigned: ZZZ |
ID before migration |
|
|
|
|
<id_beforemigration> |
|
NNE, 6 char. for FR |
Creditor ID |
|
|
|
|
<id_ics> |
|
On 28 Maximum |
Default ID Flag |
|
|
|
|
<default_entity_ics> |
|
TRUE/FALSE |
Logo |
|
|
|
|
<logo> |
|
Base64 character string for the image
Size < 9kb
|
Unique Mandate Reference |
|
|
|
<umr> |
|
|
35 max. |
Type of Change |
|
|
|
<typemodif> |
|
|
FREE / DEBTOR / CREDITOR |
Data
|
|
|
<data>
|
|
|
|
|
Debtor |
|
|
|
<debtor> |
|
|
|
ID Code |
|
|
|
|
<code> |
|
PY Third Party Code |
Name |
|
|
|
|
<name> |
|
Name |
Address |
|
|
|
|
<address><line> |
|
Address |
ZIP Code |
|
|
|
|
<postalcode> |
|
ZIP Code |
City |
|
|
|
|
<town> |
|
City |
Country |
|
|
|
|
<country> |
|
Country Code |
IBAN Account |
|
|
|
|
<account_IBAN> |
|
IBAN |
Bank BIC |
|
|
|
|
<bank_BIC_code> |
|
Bank BIC (8 or 11) |
Unique Mandate Reference |
|
|
|
<umr> |
|
|
35 max. |
Schema |
|
|
|
<scheme> |
|
|
CORE/B2B |
Creditor |
|
|
|
<creditor> |
|
|
SXBE MMI Alias |
Characteristics |
|
|
|
<characteristics> |
|
|
|
Signature |
|
|
|
|
<signature> |
|
|
Date |
|
|
|
|
|
<date> |
Format: MM/DD/YYYY |
Location |
|
|
|
|
|
<place> |
|
Recurrence Type |
|
|
|
|
<dd_type> |
|
RECUR / OOFF |
Mandate Type |
|
|
|
|
<mandate_type> |
|
NEW / MIGRATE |
|
|
|
|
|
<migration_date> |
|
Format: MM/DD/YYYY |
|
|
|
|
<contract> |
|
|
|
|
|
|
|
|
<contract_id> |
|
35 max. |
|
|
|
|
|
<description> |
|
35 max. |
|
|
|
|
|
<id_debtor> |
|
35 max. |
|
|
|
|
|
<payment_onbehalfof> |
|
|
|
|
|
|
|
|
<name> |
70 max. |
|
|
|
|
|
|
<id> |
35 max. |
|
|
|
|
|
<remittance_onbehalfof> |
|
|
|
|
|
|
|
|
<name> |
70 max. |
|
|
|
|
|
|
<id> |
35 max. |
|
|
|
|
<additional_information> |
|
|
|
|
|
|
|
|
<to_be_returned_to> |
|
140 max. |
|
|
|
|
|
<other_information> |
|
700 max. |
|
|
|
|
<form_langage> |
|
|
DE / GB / ES / FR / IT / gl-ES / ca-ES / eu-ES |
|
|
|
|
<urlpdf> |
|
|
|
|
|
|
|
<mailpdf> |
|
|
|
|
|
|
<default_data>
|
|
|
|
|
|
|
|
|
<mailpdf> |
|
|
|
|
|
|
|
<scheme> |
|
|
CORE / B2B |
|
|
|
|
<characteristics> |
|
|
|
|
|
|
|
|
<dd_type> |
|
RECUR / OOFF |
|
|
|
|
|
<mandate_type> |
|
NEW / MIGRATE |
|
|
|
|
|
<migration_date> |
|
Format: MM/DD/YYYY |
|
|
|
|
|
<signature> |
|
|
|
|
|
|
|
|
<date> |
MIG for migration date
D for today's date
-X for X days before today’s date
+Y for Y days after today’s date
|
|
|
|
|
|
|
<place> |
|