Hi ,
Can anyone please help me to find out the solution for my issue.
Currently I am getting CAMT ouput messages in XML.OUTPUT.MSG table where I need the transaction details to my multivalued for an account.
I mean the Entry details and Party tags should come only once for the account where as the transaction details should populate multiple times with respect to number of transaction(statement Entries) the account has on the day.
A sample output has been attached where I need the highlighted part to come multiple times not the entry details and all.
I am trying to achieve this as below, but its not working I need these tags should be populated multiple times with respect to number of credit or debit transactions.
Y.I ='-1'
IF SYS.ID EQ 'FT' AND STE.REV.MARK EQ 'R' THEN
IF ARCHIV THEN
OUTPUT.DETAILS<TxnDet.RefAcctServref,Y.I> = ARCHIV
END ELSE
OUTPUT.DETAILS<TxnDet.RefAcctServref,Y.I> = FT.ID
END
END ELSE
IF REV.CD THEN
OUTPUT.DETAILS<TxnDet.RefAcctServref,Y.I> = REC.VD
END ELSE
OUTPUT.DETAILS<TxnDet.RefAcctServref,Y.I> = FT.ID:'R'
END
END
OUTPUT.DETAILS<TxnDet.Txnamt,Y.I> = "EUR":STE.AMT
OUTPUT.DETAILS<TxnDet.RelDebtrName,Y.I> = TXN.NAME
OUTPUT.DETAILS<TxnDet.RefAcctServref,Y.I> = TXN.NAME
IF STE.REV.MARK EQ 'R' THEN
OUTPUT.DETAILS<TxnDet.RelDtsAcceptDate,Y.I> = R.FT<FT.LOCAL.REF,DAT.POS>
END