Previous | Next | Contents | Index | Navigation | Glossary | Library |
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) |
Previous | Next | Contents | Index | Navigation | Glossary | Library |