Mdtdigitalization001

Mdtdigitalization001

Name Mandatory? Type Format Comments
Header
Type de la requete M FRST : First line
requestorId O Uniquely identify the requestor (Demat partner or Creditor SI or Bank)
creationDate M Timestamp of the data creation
fileId M identifies the file of the data
Discount
Type de la requete M REC : Record
Principal mandate informations
umr M Unique mandate reference \\A([a-zA-Z\\+\\?\\’\\(\\)\\:\\/\\.\\,\\-\\_0-9]{1,35})\\z
sci M Sepa Creditor Identifier \A([A-Z]{2})(\d{2})([0-9A-Z]{3})([0-9A-Z]{1,28})\z
signatureDate O Signature date Format dd/MM/YYYY
signatureCity O Signature city
sequenceType O Sequence type Must be “RCUR”(Recurent) or “OOFF”(fponctuel). If the field is empty, it will be recurrent.
mandateType O Mandate Type Must be “CORE”(B2C) or “B2B”(for B2B).if the field is empty, it will be CORE.
contractId O Contract identifier
Creditor informations
creditorName M Creditor name If empty, the name found in database will be set.
ultimateCreditorName O Ultimate creditor name
ultimateCreditorId O Ultimate creditor identifier
creditorAddressStreet O Creditor Address: Street
creditorAddressBuildingNumber O Creditor Address: Bulding number
creditorAddressPostCode O Creditor Address: Address Post Code
creditorAddressCity O Creditor Address: City
creditorAddressRegion O Creditor Address: Region
creditorAddressCountry O Creditor Address:Country
Debtor informations
debtorName O Debtor name
debtorBic O Debtor BIC [A-Z]{6,6}[A-Z2-9][A-NP-Z0-9]([A-Z0-9]{3,3}){0,1}
debtorIban O Debtor IBAN [a-zA-Z]{2,2}[0-9]{2,2}[a-zA-Z0-9]{1,30} EMD² checks IBAN according to EMD²
debtoreMail O Debtor e-mail
ultimateDebtorName O Ultimate debtor name
ultimateDebtorId O Ultimate debtor identifier
debtorAddressStreet O Debtor Address: Street
debtorAddressBuildingNumber O Debtor Address: Bulding number
debtorAddressPostCode O Debtor Address: PostCode
debtorAddressCity O Debtor Address:Country
debtorAddressRegion O Debtor Address: Region
debtorAddressCountry O Debtor Address:Country
debtorPhoneNumber O Debtor PhoneNumber
Dematérialization informations
physicalStorageId O Mandate ID
mandateImageFileId O Mandate ID file
processDate M Timestamp where the mandate was treated by the partner of dematerialization
processState M Mandate status
END
Type de la requete M END : End line
nbRecord M Number of mandate in the file

O: Optionnel
M: Mandatory

*Rules of migration:
For countries FR,BE,ESP,NLD: IF CORE: No SIGNATURE NEEDED, IF BUSINESS: a signature is needed
For country DE: signature always mandatory
For other countries: no signature is mandatory
Core B2B
FR N Y
BE N Y
NL N Y
ES N Y
DE Y Y
Others (to be detailed) N Y