DSXchange

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.

Please confirm whether you are using WebSphere Transformation Extender or DataStage and, in either case, the exact version number.

yes i am using the websphere Transformation extender and the vesion is 8.2.

Thanks a lot.