|
In the original file, amounts are in integers including decimal places, so they must be divided by 100 to get the actual values.
In addition to CFONB file basic information, we will have four additional columns. Banking information will be used to reconstruct the IBAN of the account to be debited (assuming that it is a French account).
This IBAN will help finding the UMR in the list of mandates.
The Types of DDs column is completed by inserting RCUR if the mandate is found and FRST otherwise.
The Currency column contains EUR.
If one IBAN is used for 2 mandates, the UMR is manually inserted.
If the IBAN is not found, the mandate must be created and the UMR manually inserted.
|
Retour