IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
#Supplychain
 View Only
  • 1.  Split a MT940 File based on File Size

    Posted 03/11/14 10:55 AM

    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


  • 2.  Re: Split a MT940 File based on File Size

    Posted 05/14/14 06:33 AM

    Originally posted by: GKearney


    There is an example in the WTX Swift Pack of how to split the MT950 message which maybe of help to you.

    The WTX Swift Pack is an additional add on to WTX. If you do not have the WTX Swift Pack then you would need to speak to your IBM WebSphere Software Sales representative.


    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 3.  Re: Split a MT940 File based on File Size

    Posted 10/07/15 01:59 PM

    Originally posted by: Anthony@Regions


    I have this same issue. MT940 message needs to be split based on SWIFT 2000 byte message limit.  Has anyone solved for this issue?


    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 4.  Re: Split a MT940 File based on File Size

    Posted 10/08/15 02:40 AM

    Originally posted by: paul.brett


    If you do not have access to the SWIFT Pack, or you were hoping for a completed solution (without having to do any additional work) I recommend you either:

    1.  Open a new developerWorks post, and hope that somebody is feeling generous.

    or

    2.  Engage a WTX developer to code the solution for you.  Perhaps IBM Global Services?

    Thank-you.

    Paul

    Follow me on Twitter


    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange