How to get the reciprocal account to appear in the GL journal line extract?

Hi

Wondering if anyone has a readily available sql that allows me to extract Payables Line details based on a parameter e.g. AP Control Account.

I have linked up the xla tables and I am able to extract the necessary info and the balance tie with the GL balances for that control account; but I am hoping I can then link up to get the reciprocal GL account for that control account.

e.g. AP Invoice has accounting entries Dr Exp ZZZZ and Cr Liability AAAA

I can get the listing of the transaction based on the Liability account AAAA but how can I also include the Dr side as an additional column to show as the reciprocal account