未核销收款
应收款管理系统使用以下表格来存储收款信息:
- AR_CASH_RECEIPTS
- AR_CASH_RECEIPT_HISTORY
- AR_PAYMENT_SCHEDULES
- AR_RECEIVABLE_APPLICATIONS
考虑下面这个最初未核销的收款实例:
收款编号:R-101
付款人:ABC Inc
事务处理日期:05-07-94
收款额:4000
收款编号 R-101 在应收款管理系统表中说明如下:
AR_CASH_RECEIPTS | ||||
|
|
|
|
|
credit_receipt_id | amount | status | receipt_number | type |
338700 | 4000 | UNAPP | R-101 | CASH |
|
|
|
|
|
表 1-141.(第 1 页,共 1 页) |
AR_CASH_RECEIPT_HISTORY | ||
|
|
|
cash_receipt_history_id | amount | status |
457890 | 4000 | CLEARED |
|
|
|
表 1-142.(第 1 页,共 1 页) |
AR_PAYMENT_SCHEDULES | ||||||||
|
|
|
|
|
|
|
|
|
payment_ | amount_ | amount_ | cash_ | customer | trx_ | status | amount_ | class |
510555 | -4000 | -4000 | 338700 | NULL | R-101 | OP | 0 | PMT |
表 1-143.(第 1 页,共 1 页) |
由于未对客户余额核销收款,因此此收款实例的状态为 OP(打开),而 amount_applied 的状态为 NULL。amount_due_original 栏等于给定 cash_receipts_id 的 AR_CASH_RECEIPTS 表中的金额栏总额。分类为 PMT(付款),因为此收款与应收款活动相关。amount_due_original 和 amount_due_remaining 栏等于收款额的相反数。
AR_RECEIVABLE_APPLICATIONS | |||||||
|
|
|
|
|
|
|
|
payment_ | amount_ | status | payment_ | code_ | cash_ | applied_ | applied_ |
408289 | 4000 | UNAPP | 400100 | 01-1100-1000 | 338700 | NULL | NULL |
表 1-144.(第 1 页,共 1 页) |
由于未对特定事务处理核销收款,栏 applied_payment_schedule_id 和 applied_customer_trx_id 为 NULL。amount_applied 栏与收款额相等。Status为UNAPP(未核销),code_combination_id 栏存储与未核销现金收款关联的总帐帐户。