Cash Management SWIFT940 statement format mappings
Our bank statement file is in SWIFT940 format. Record ID is being extracted from our bank's system as follows
:25:201071-43315991
where 201071 is the sort code & 43315991 is the account number
In order to get it into the interface at present I have to manually take out the sort code and hyphen leaving only the account number so the record becomes
:25:43315991
And the mapping template becomes
BANK_ACCOUNT_NUMBER 25 1
To get the file into the Oracle interface what is the format required in the statement mapping template form without having to manually remove the sort code and hyphen?