Hi all,
Please advice how to split MT940 message if the message size is more than some 1000 characters and need to take care of opening and closing balaces.
Tag:60F: Opening balance
Tag:62F: closing balance
Tag61: will have the Transaction Amount
Caliculation is: Opening Blance + or - Transaction amount = closing balance
EX: Amount under tag 61 is CD4,90N then it Credit amount
then 137264,29+4,90=137269,19
if it's DD28,00 then it is debit amount.
Original Message:
{1:F01CFSMAU2SAXXX3651408634}{2:O9401128CITIHKHXBXXX05357820131002071010191128N}{3:{108:COTS}}{4:
:20:2010101923
:25:EQF51056 - AUD
:28C:940/23
:60F:C100512AUD137264,29
:61:1005120511CD4,90NFUT0E1104381054620//AXPJM0
Exchange Fee
:86:/CXL JUN 10 ASX S&P PRPTY
:61:1005120511DD28,00NFUT0E1104381054620//AXPJM0
Floor Brokerage
:86:/CXL JUN 10 ASX S&P PRPTY
:62F:C100512AUD137241,19
-}{5:{CHK:31A770DE476E}}
Split Message 1:
{1:F01CFSMAU2SAXXX3651408634}{2:O9401128CITIHKHXBXXX05357820131002071010191128N}{3:{108:COTS}}{4:
:20:2010101923
:25:EQF51056 - AUD
:28C:940/23
:60F:C100512AUD137264,29
:61:1005120511CD4,90NFUT0E1104381054620//AXPJM0
Exchange Fee
:86:/CXL JUN 10 ASX S&P PRPTY
:62F:C100512AUD137269,19-}{5:{CHK:31A770DE476E}}
Split Message 2:
{1:F01CFSMAU2SAXXX3651408634}{2:O9401128CITIHKHXBXXX05357820131002071010191128N}{3:{108:COTS}}{4:
:20:2010101923
:25:EQF51056 - AUD
:28C:940/23
:60F:C100512AUD137269,19
:61:1005120511DD28,00NFUT0E1104381054620//AXPJM0
Floor Brokerage
:86:/CXL JUN 10 ASX S&P PRPTY
:62F:C100512AUD137241,19
-}{5:{CHK:31A770DE476E}}
Thanks In Advance.
Usha.
Split a MT940 File
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 15
- Joined: Fri Nov 21, 2008 12:41 am