Thanks for the reply.

Please find below the sample and expected output -

CompanyCustomer IDAccount IDAmountTransaction Date

100 C001 ...