Query to get Payroll costing details to match with EFT payments

Summary:

Need query to fetch the Costing of payments - Accounts, Account Type, Cost amount (Debit & Credit), Accounting date and prepayment details. It needs to be matched with the EFT payment values to reconcile the data.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):