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>