Use this import template for importing direct debit mandates.

The controls are the same as those used in transactional mode. These controls are described in the documentation of the Direct debit mandates function (GESMDT).

Prerequisites

Mandatory fields in the template

Mandatory fields

  • CPY – Company
  • CPYADD - Company address code
  • BPCNUM - Customer code
  • BPCADD - Customer address code
  • IBACOD - IBAN code

Specifications on the NDAIMPFLG field - SMDNA or IBAN

In import, use the NDAIMPFLG - SMDNA or IBAN field to answer to the question: "Does this IBAN change correspond to a bank change?".

Value = 1

If the value specified in the import file is '1', the answer to the question is 'No'.

Value = 2

If the value specified in the import file is '2', the answer to the question is 'Yes'.

The NDAIMPFLG - SMDNA or IBAN field is only taken into account:

  • if the creation date of the mandate is equal or greater than the optional BIC start date,
  • and if the mandate is validated ('Validated' status).

SEEINFOThe date entered in the parameterOPTBICSTR - Optional BIC start date(TC chapter, SDD group) determines if the field BIC code can be left empty in the mandate, based on the mandate creation date.

Error messages

The only error messages are the generic ones.

Tables used

This template can be used in import and export modes. The data is updated in the following tables :

Table

Table description

BPCUSTOMER [BPC]

Customers

COMPANY [CPY]

Company

MANDATE [MDT]

Mandates