RA_CUSTOMER_TRX_ALL and AR_RECEIPT_METHOD_ACCOUNTS_ALL
Hi,
I'd like to create a BI report to extract transaction information.
When I create a transaction, I can choose Receipt Method with associated bank account:
How can I extract account information from RA_CUSTOMER_TRX_ALL?
There I can extract receipt method, but not the related bank account.
Receipt methods and bank accounts are stored in AR_RECEIPT_METHOD_ACCOUNTS_ALL table, but I'm not able to find the join between these two.
Any suggestion?
Thanks
Martina