Help required in Mapping template - cash management

Mar 20, 2016 10:49AM

Hi Everyone

I am Faisal , Implementing Auto-Reconciliation with Swift MT940 mappings for auto reconciliation process.

The below is the file given to me MT940

{1:F01BARCZMLXXXX2626891354}

{2:O9400408010726SCBLINBBAXXX41686101990107252345N}

{3:{010726AB24403BC1}}

{4:

:20:243791

:25:ZMK:016:1117910

:28C:78735/1

:60F:C150506ZMW14,00

:61:1505060506CW1,00FTRF0958129356//1

:86:TRANSFER:1

:61:1505060506CW1,00FTRF0957808470//1

:86:TRANSFER:1

:61:1505060506CW2,00FTRF0951244212//1

:86:TRANSFER:1

:61:1505060506CW2,50FTRF0953312886//1

:86:TRANSFER:1

:62F:C150506ZMW20,50

:64:C150506ZMW20,50

:65:C150506ZMW20,50

:86:0953312886

095780847009581293560951244212

-}

I have takes below line for example ,my query is line number :61: indicates the transaction line details with the transaction reference.

Position 1 starts gives date and position 11 is C which is credit

and position 13 is the line amount.

The amount can be be anything cannot predict the number of digits then how can I map TRX_TEXT in the mapping template (line level) which is

Payables and Cash Management - EBS (MOSC)