Which Receivables fusion tables store due amounts and receipts info for a AR Invoice?
I wrote a query to join following tables to retrieve transaction details as well as its payment schedule as well as Receipts applied to this transaction.
Using these two tables still didn't give me data (no rows found though I see receipts applied in the fusion front-end page.
ar_payment_schedules_all
AR_CASH_RECEIPTS_ALL