Skip to main content
OracleOps AI
← All tables
Oracle Fusion/Financials/AR

AR_PAYMENT_SCHEDULES_ALL

Open receivables balances — one row per transaction or receipt with original and remaining amount due.

Key Columns

PAYMENT_SCHEDULE_IDCUSTOMER_TRX_IDCASH_RECEIPT_IDCLASSSTATUSAMOUNT_DUE_ORIGINALAMOUNT_DUE_REMAININGDUE_DATE

Common Joins

RA_CUSTOMER_TRX_ALLvia CUSTOMER_TRX_ID

The invoice / credit memo this schedule tracks (CLASS = 'INV' / 'CM').

AR_CASH_RECEIPTS_ALLvia CASH_RECEIPT_ID

The receipt this schedule tracks (CLASS = 'PMT').

Used In

ARCollections

Notes

STATUS 'OP' = open, 'CL' = closed; aging and DSO reporting is built on AMOUNT_DUE_REMAINING and DUE_DATE.

Related

Where the open receivables balance lives

AR_PAYMENT_SCHEDULES_ALL carries one row per invoice, credit memo and receipt with AMOUNT_DUE_ORIGINAL / AMOUNT_DUE_REMAINING — the basis for aging and DSO. Adjustments (AR_ADJUSTMENTS_ALL) and receipt applications change the remaining amount; receipt state changes are in AR_CASH_RECEIPT_HISTORY_ALL.

Ask Oracle AI about AR_PAYMENT_SCHEDULES_ALL