query for receivables receipts
I wrote the query of receipts, but I need the receipt date, I think it's in the table AR_CASH_RECEIPT_ALL but I don't know how to join with the others. Can anyone help me complete it with the "receipt_date"?
select
CTL.REVENUE_AMOUNT,
APS.AMOUNT_DUE_REMAINING,
APS.AMOUNT_APPLIED AS Incassato,
APS.GL_DATE,
APS.TAX_ORIGINAL,
RCTA.TRX_NUMBER,
(CTL.REVENUE_AMOUNT - APS.TAX_ORIGINAL) AS imponibile
FROM
AR_PAYMENT_SCHEDULES_ALL APS,
ra_customer_trx_all RCTA,
ra_customer_trx_lines_all CTL
WHERE 1=1
AND
RCTA.CUSTOMER_TRX_ID=CTL.CUSTOMER_TRX_ID
Tagged:
0