AR_PAYMENT_SCHEDULES table overview

AR_PAYMENT_SCHEDULES
payment_ schedule _id	amount_ due_ original	amount_ due_ remaining	customer _trx_id	cash_ receipt_ id	trx_ number	status	amount_ applied	class

This table stores all transactions except adjustments and miscellaneous cash receipts. AR_PAYMENT_SCHEDULES stores customer balance information at the transaction level. Oracle Receivables updates this table when activity occurs against an invoice, debit memo, chargeback, credit memo, on account credit, or receipt. Oracle Receivables groups different transactions by the column CLASS.

Each transaction's balance is stored as a unique record, based on the primary key, payment_schedule_id. The class column identifies the transaction type and determines which columns Receivables updates when a transaction is stored.

For billing transactions, the AR_PAYMENT_SCHEDULES table joins the RA_CUSTOMER_TRX table via the customer_trx_id column and stores NULL in the cash_receipt_id column. For payment transactions, the AR_PAYMENT_SCHEDULES table joins the AR_CASH_RECEIPTS table via the cash_receipt_id column and stores NULL in the customer_trx_id column.

TRANSACTION	CLASS	FOREIGN KEY	TABLE
Invoices	INV	customer_trx_id	RA_CUSTOMER_TRX
Debit Memos	DM	customer_trx_id	RA_CUSTOMER_TRX
Credit Memos	CM	customer_trx_id	RA_CUSTOMER_TRX
Deposits	DEP	customer_trx_id	RA_CUSTOMER_TRX
Guarantees	GUAR	customer_trx_id	RA_CUSTOMER_TRX
Chargebacks	CB	customer_trx_id	RA_CUSTOMER_TRX
Receipts	PMT	cash_receipts_id	AR_CASH_RECEIPTS

The status column identifies whether the transaction is open or closed, while the trx_number column stores the transaction number. The amount_applied column stores the sum of all transactions applied to the balance of the selected transaction. The amount_due_original column equals either the sum of the extended_amount column in the RA_CUSTOMER_TRX_LINES table for the given customer_trx_id or the sum of the amount column in the AR_CASH_RECEIPTS table for the given cash_receipts_id. The amount_due_remaining column represents the balance for the selected transaction.

For the amount_due_original and amount_due_remaining columns debit items, such as invoices, are stored as positive numbers and credit items, such as credit memos and payments, are stored as negative numbers. The current customer balance is reflected by the sum of the amount_due_remaining column for all confirmed payment schedules for a given customer.
When a receipt is applied, Oracle Receivables updates AMOUNT_APPLIED, STATUS and AMOUNT_DUE_REMAINING. STATUS changes from ’OP’ to ’CL’