Payments and Batch details should pull into single row with eText template

Summary

Payments and Batch details should pull into single row with eText template

Content

Hi Friends,

eText payment template file using different groups where always have one to many relation ( ex: 1 payment batch has 10 invoices) , I see some challenge to handle it. 

Hope someone might gone through, so could you please review and help. 

Use case :- 

1) Few columns from PaymentInstructionInfo/InstructionReferenceNumber

2) Other columns from OutboundPayment/DocumentPayable

Actual Data :- 

ACCOUNT_NUMBER; PAYMENT_TYPE; TRANSACTION_DATE; CURRENCY; AMOUNT; PAYMENT_BATCH_ID

      1291475270;        TRF;                      11/26/2019;              USD;                    500.01;

      1291475270;           TRF;                   11/26/2019;               USD;                    2000;

       1291475270;        TRF;                      11/26/2019;              USD;                     20000;

       ;699003

 

 

Expected Data :- 

        ACCOUNT_NUMBER; PAYMENT_TYPE; TRANSACTION_DATE; CURRENCY; AMOUNT; PAYMENT_BATCH_ID