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

AR_ADJUSTMENTS_ALL

Receivables adjustments — write-offs and manual changes to an invoice's outstanding balance.

Key Columns

ADJUSTMENT_IDCUSTOMER_TRX_IDPAYMENT_SCHEDULE_IDTYPESTATUSAMOUNTCODE_COMBINATION_ID

Used In

AR

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.