Previous	Next		Contents	Index	Navigation	Glossary	Library

• AR_CASH_RECEIPTS

• AR_CASH_RECEIPT_HISTORY

• AR_PAYMENT_SCHEDULES

• AR_RECEIVABLE_APPLICATIONS

Receipt Number: R-101

Received From: ABC Inc

Transaction Date: 05-Jul-94

Receipt Amount: 4000

Receipt number R-101 would be represented in Receivables tables as follows:

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

AR_CASH_RECEIPT_HISTORY
cash_receipt_history_id	amount	status
457890	4000	CLEARED
Table 1 - 142. (Page 1 of 1)

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	-4000	338700	NULL	R-101	OP	0	PMT
Table 1 - 143. (Page 1 of 1)

The example receipt has a status of OP (open) and an amount_applied of NULL because the receipt has not been applied to a customer balance. The amount_due_original column equals the sum of the amount column in the AR_CASH_RECEIPTS table for the given cash_receipts_id. The class is PMT because this is a receipt related to a receivable activity. The amount_due_original and amount_due_remaining columns equal the inverse amount of the receipt.

AR_RECEIVABLE_APPLICATIONS
payment_ schedule_ id	amount_ applied	status	payment_ schedule_id	code_ combination_id	cash_ receipt_ id	applied_ payment_ schedule_ id	applied_ customer_ trx_id
408289	4000	UNAPP	400100	01-1100-1000	338700	NULL	NULL
Table 1 - 144. (Page 1 of 1)

The columns applied_payment_schedule_id and applied_customer_trx_id are NULL because the receipt has not been applied to a specific transaction. The amount_applied column equals the amount of the receipt. The code_combination_id column stores the general ledger account associated with unapplied cash receipts.

See Also

Reverse Receipts

Miscellaneous Receipts