Previous	Next		Contents	Index	Navigation	Glossary	Library

• AR_CASH_RECEIPTS

• AR_CASH_RECEIPT_HISTORY

• AR_PAYMENT_SCHEDULES

• AR_RECEIVABLE_APPLICATIONS

AR_CASH_RECEIPTS
credit_receipt_id	amount	status	receipt_number	type
338700	4000	REV	R-101	CASH
Table 1 - 151. (Page 1 of 1)

Receivables updates the status column of the original receipt from APP, applied, to REV, reversed.

AR_CASH_RECEIPT_HISTORY
cash_receipt_history_id	amount	status
545352	4000	REVERSED
Table 1 - 152. (Page 1 of 1)

A new record, which is not postable, will be inserted into AR_CASH_RECEIPT_HISTORY to record the reverse receipt. Additionally, the current_record_flag of the original cash receipt record will be updated to null, while the reverse_gl_date column of the original receipt record will be set.

AR_PAYMENT_SCHEDULES
payment_ schedule_ id	amount _due_ original	amount_ due_ remaining	cash_ receipt_id	customer_ trx_id	trx_ number	status	amount_ applied	class
510555	-4000	0	338700	NULL	R-101	CL	0	PMT
30191	6400	6400	NULL	101467	I-101	OP	0	INV
Table 1 - 153. (Page 1 of 1)

The payment schedule of the invoice has a class of INV, while the payment schedule of the receipt has a class of PMT. Because the receipt has been reversed, the amount_due_remaining and amount_applied columns are zero and the status column is CL, closed.

Receivables updates the payment schedule record of the invoice to increase the amount_due_remaining by the amount of the reverse receipt. The status is still OP because the entire balance has not been paid. The amount_applied column is zero because no transactions have been applied to the invoice.

AR_RECEIVABLE_APPLICATIONS
receivable_ application _id	amount_ applied	status	payment_ schedule_ id	code_ combination_ id	cash_ receipt _id	applied_ payment_ schedule_ id	applied_ customer_ trx_id
408292	-4000	APP	400100	01-1200-1100	338700	30191	101467
408293	4000	UNAPP	400100	01-1100-1000	338700	NULL	NULL
408294	-4000	UNAPP	400100	01-1100-1000	338700	NULL	NULL
Table 1 - 154. (Page 1 of 1)

Receivables inserts three records into AR_RECEIVABLE_APPLICATIONS. The first record, with a status of APP, offsets the original application of the receipt, including a reference to the applied invoice, via the applied_payment_schedule_id and applied_customer_trx_id columns. The second and third records, with a status of UNAPP, offset the original unapplied transactions. The code_combination_id for the APP record is the receivable account associated with the invoice to which this receipt was originally applied. The code_combination_id for the two UNAPP records is the general ledger account associated with unapplied receipts.

See Also

Unapplied Receipts

Miscellaneous Receipts