Creation de E-Mandats (MEV) par fichier CSV

Creation de E-Mandats (MEV) par fichier CSV

eMandateImport

Name Mandatory? Type Format Size Comments
Request type M FRST : First line 4
requestorId M Uniquely identify the requestor (Demat partner or Creditor SI or Bank) String 35
creationDate M Timestamp of the data creation dd/MM/YYYY 10
fileId M identifies the file of the data String 35
Remise
requestType M REC : Record 5
requestOperation M CR: create Mandate 2
certificationType M [ORG] 3
Main information of the mandate
umr O Unique mandate reference \\A([a-zA-Z\\+\\?\\’\\(\\)\\:\\/\\.\\,\\-\\_0-9]{1,35})\\z 35 Either the UMR or the UIR must be provided
uir O Unique internal reference \\A([a-zA-Z\\+\\?\\’\\(\\)\\:\\/\\.\\,\\-\\_0-9]{1,35})\\z 35
sci M Sepa Creditor Identifier \A([A-Z]{2})(\\d{2})([0-9A-Z]{3})([0-9A-Z]{1,28})\\z 35
sequenceType M sequence type RCUR for Recurent mandate , OOFF for One Off mandate 4
mandateType M Mandate scheme Must be either: CORE (B2C) or B2B 4
communicationLanguage M Mandate Language [A-Z]{2,2} 2 Generated PDF Mandate Language
Main information of the debtor
debtorCivility M Debtor name [Mr, Mrs, Miss] [2-4]
debtorFirstName M Debtor firstname String 70
debtorLastName M Debtor lastname String 70
debtorBic O Debtor BIC [A-Z]{6,6}[A-Z2-9][A-NP-Z0-9]([A-Z0-9]{3,3}){0,1} 11
debtorIban O Debtor IBAN [a-zA-Z]{2,2}[0-9]{2,2}[a-zA-Z0-9]{1,30} 34
OTPmethod M Chanel to use for the OTP code [SMS, EMAIL] [3-5]
debtoreMail M Debtor e-mail \w+([-+.’]\w+)@\w+([-.]\w+).\w+([-.]\w+)* 30
debtorPhoneNumber O Debtor PhoneNumber [[^a-zA-Z"?!#$%&()*/<>=@[]\^{}\ ~]+]{2,32} 34
debtorAddressStreet M Debtor Address: Street String 140
debtorAddressBuildingNumber M Debtor Address: Bulding number String 16
debtorAddressPostCode M Debtor Address: PostCode String 16
debtorAddressCity M Debtor Address:City String 35
debtorAddressCountry M Debtor Address:Country [A-Z]{2,2} 2
socialReason O Debteor Social Reason String 70
SIRETnumber O SIRET number of the debtor Long 14
End
Request type M END : End line 3
nbRecord M nb records in file Long 10 End line

O: Optionnel
M:Mandatory