Mandate management by CSV file

Mandate management by CSV file

MandateManagement

Name Mandatory? Type Format Size Comments
Request type M FRST : First line 4
requestorId O 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 Start of REC and RECV2 and RECV3,RECV4,RECV5,RECV6
Request type M REC : Record (or RECV2 or RECV3 or RECV4 or RECV5 or RECV6 for New Fields Added for Mandate and New Fields Added for Mandate Action ) 5 The case must be respected, in exemple if Recv4 is set, it is not possible to detect the lines that are not properly prefixed. So the processor will sayy that it finds 0 transactions in the file.
request operation M CR: create Mandate UP: update Mandate AC: Mandate Action MG: Mandate specific migration with amendment management 2
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
new_umr O New Unique mandate reference (for update only) \\A([a-zA-Z\\+\\?\\’\\(\\)\\:\\/\\.\\,\\-\\_0-9]{1,35})\\z 35
uir O Unique internal reference \\A([a-zA-Z\\+\\?\\’\\(\\)\\:\\/\\.\\,\\-\\_0-9]{1,35})\\z 35
new_uir O New Unique internal reference (for update only) \\A([a-zA-Z\\+\\?\\’\\(\\)\\:\\/\\.\\,\\-\\_0-9]{1,35})\\z 35
sci O Sepa Creditor Identifier \A([A-Z]{2})(\d{2})([0-9A-Z]{3})([0-9A-Z]{1,28})\z 35 Either the SCI or the NCI with a correct association defined in the organization must be provided
new_sci O New Sepa Creditor Identifier (for update only) \A([A-Z]{2})(\d{2})([0-9A-Z]{3})([0-9A-Z]{1,28})\z 35
migrationCountry O [A-Z]{2,2} 2 Migration country
nci M String 35 National creditor identifer
toBeMigrated O T: indicates the mandate is migrated E: indicates the mandate is an existing SEPA mandate 1 T:To indicate the mandate is migrated. If the field is not provided or if there are other things means the mandate is not migrated E: To indicate the mandate is existing in an other system. If the mandate is not an existing mandate, the lastSDDSentDueDate will not be taken in account even if it has been set.
signatureDate O Signature date dd/MM/YYYY 10 Format dd/MM/YYYY
signatureCity O Signature city String 80
sequenceType O sequence type RCUR for Recurent mandate , OOFF for One Off mandate 4 If nothing is provided, the sequence type will be set with the default sequence type of the organisation
mandateType O Mandate scheme Must be either: CORE (B2C) or B2B 4 If no scheme is provided the default one for the organisation will be take
contractId O Contract identifier String 35
Main information of the creditor
creditorName DEPRECATED Creditor Name String 70 If not provided the name matching with the SCI in database will be set
creditorBic O Creditor BIC [A-Z]{6,6}[A-Z2-9][A-NP-Z0-9]([A-Z0-9]{3,3}){0,1} 11
creditorIban O Creditor IBAN [a-zA-Z]{2,2}[0-9]{2,2}[a-zA-Z0-9]{1,30} 34
ultimateCreditorName O Ultimate creditor name String 70
ultimateCreditorId O Ultimate creditor identifier String 35
creditorAddressStreet DEPRECATED Creditor Address: Street String 70
creditorAddressBuildingNumber DEPRECATED Creditor Address: Bulding number String 16
creditorAddressPostCode DEPRECATED Creditor Address: Address Post Code String 16
creditorAddressCity DEPRECATED Creditor Address: City String 35
creditorAddressRegion DEPRECATED Creditor Address: Region String 35
creditorAddressCountry DEPRECATED Creditor Address:Country String 2
Main information of the debtor
debtorName O Debtor name 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 EMD² checks IBAN according to EMD²
debtorBBAN O National debtor account [a-zA-Z0-9]{1,30} 30 If the debtor BIC/IBAN are provided the information will not be read, the migration country will be used to determinate the country of the account
debtorlExternalId O Debtor Identifier String 35
debtoreMail O Debtor e-mail String 70 \w+([-+.’]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*
ultimateDebtorName O Ultimate debtor name String 70
ultimateDebtorId O Ultimate debtor identifier String 35
debtorAddressStreet O Debtor Address: Street String 140
debtorAddressBuildingNumber O Debtor Address: Bulding number String 16
debtorAddressPostCode O Debtor Address: PostCode String 16
debtorAddressCity O Debtor Address:City String 35
debtorAddressRegion O Debtor Address: Region String 35
debtorAddressCountry O Debtor Address:Country [A-Z]{2,2} 2
debtorPhoneNumber O Debtor PhoneNumber String 34 [[^a-zA-Z\"\?\!\#\$\%\&(\)\*\/\<\>\=\@[\]\\^\{\}\ \~]+]{2,32}
Main information of the storage
physicalStorageId O Storage identifier filename1\ phyArchKey1\ fileDesc1&filename2\ phyArchKey2\
mandateImageFileId O mandate file storage identifier String 140 C End of REC
New Fields Added For mandate
Contract Description O Contract Description String 35
New Fields Added For mandate Action
Mandate Action M (if request operation = AC) Mandate Action [SUSPEND, ACTIVATE, CANCEL, MERGE, ERASE, BIC_UPDATE] 8 This field is mandatory when the request operation is AC. Cancel command can be used to revoke active mandate.
Cancel Date O Effective Date Date 10 dd/MM/YYYY
Comment O Comment String 1025
FinalizedReason M Finalized Reason [RECEIVED_FINAL, USER_ACTION, OBSCOLESCENCE, REFUSED, REVOCATION_ASKED_BY_DEBTOR, REVOCATION_ASKED_BY_CREDITOR, DELETION_ASKED_BY_DEBTOR, DELETION_ASKED_BY_CREDITOR] 28
transactionIdx O Internal Transaction Id String 255
docsLang O Mandate Language [A-Z]{2,2} 2 Generated PDF Mandate Language End of RECV2
lastSddSentDate O Send Date of the last SDD sent to the bank in the previous system dd/MM/YYYY 10 If the field is empty, the date will be set to the current date (in case of an existing SEPA mandate)
planDate O Date at which the update of the mandate will be realized dd/MM/YYYY 10 Only applied when is “UP” End of RECV3
signatoryName O Signatory Name String 255 Name of the signatory of the mandate (if different from debtor name)
debtorFiscalCode O Debtor Fiscal Code String 255 Fiscal code of the debtor (mandatory for SEDA)
signatoryFiscalCode O Signatory Fiscal Code String 255 Fiscal code of the signatory (if different from debtor) (mandatory for SEDA if signatory name is filled out)
isSedaMandate O Is mandate to create SEDA or not true/false 5 true or false to say whether the mandate should be created as SEDA. Useful only for mandate creation
organizationExtId O Original external ID of the organization String 10 Original external ID of the organization
targetOrganizationExtId O New external ID of the organization String 10 New external ID of the organization End of RECV4
createAsActiveSEDA O Create SEDA mandate as active or not true/false 5 true or false to say whether the SEDA mandate should be created as ACTIVE or not. Useful only for mandate creation End of RECV5
lastModifyDebtorBicIbanDate O Date of the last modification of the debtor account dd/MM/YYYY Mandatory for amendment management
oldIbanForAmendment O Old iban used before debtor account modification [a-zA-Z]{2,2}[0-9]{2,2}[a-zA-Z0-9]{1,30} 34 Mandatory for amendment management. SPS checks IBAN according to SWIFT
oldBicForAmendment O Old bic used before debtor account modification [A-Z]{6,6}[A-Z2-9][A-NP-Z0-9]([A-Z0-9]{3,3}){0,1} 11 Mandatory for amendment management. SPS checks BIC according to SWIFT End of RECV6
Fin
Request type M END : End line 3
nbRecord M nb records in file 10 End line
O: Optionnel
M:Mandatory 3895
*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
Mandate language can be updated by adding at the end of each record (field 45 for REC or field 51 for RECV2) a “;” and an iso language code managed by SPS (“FR”, “DE”, “ES”, …)
Core B2B
FR FR N Y
BE BE N Y
NL NL N Y
ES ES N Y
DE DE Y Y
Others (to be detailed) Others (to be detailed) N Y