Originally posted by: PARTHA@IBM
Please advice how to split MT940 message if the message size is more than some 2000 characters and need to take care of opening and closing balances.
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:C100512AUD 137264,29
:61:1005120511CD 4,90 NFUT0E1104381054620//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:C100512AUD 137241,19
-}{5:{CHK:31A770DE476E}}
Split Message 1:
{1:F01CFSMAU2SAXXX3651408634}{2:O9401128CITIHKHXBXXX05357820131002071010191128N}{3:{108:COTS}}{4:
:20:2010101923
:25:EQF51056 - AUD
:28C:940/23
:60F:C100512AUD 137264,29
:61:1005120511CD 4,90 NFUT0E1104381054620//AXPJM0
Exchange Fee
:86:/CXL JUN 10 ASX S&P PRPTY
:62F:C100512AUD 137269,19 -}{5:{CHK:31A770DE476E}}
Split Message 2:
{1:F01CFSMAU2SAXXX3651408634}{2:O9401128CITIHKHXBXXX05357820131002071010191128N}{3:{108:COTS}}{4:
:20:2010101923
:25:EQF51056 - AUD
:28C:940/23
:60F:C100512AUD 137269,19
:61:1005120511DD 28,00 NFUT0E1104381054620//AXPJM0
Floor Brokerage
:86:/CXL JUN 10 ASX S&P PRPTY
:62F:C100512AUD 137241,19
-}{5:{CHK:31A770DE476E}}
Regards,
Partha
#IBMSterlingTransformationExtender#IBM-Websphere-Transformation-Extender#DataExchange