Previous | Next | Contents | Index | Navigation | Glossary | Library |
Guarantee Number: G-101
Bill-To: ABC Inc
Guarantee Date: 20-May-94
Amount: $500
Guarantee number G-101 would be represented in Receivables tables as follows:
RA_CUSTOMER_TRX | |||
---|---|---|---|
customer_trx_id | trx_number | bill_to_customer_id | trx_date |
122341 | G-101 | ABC Inc | 20-May-94 |
Table 1 - 115. (Page 1 of 1) |
RA_CUSTOMER_TRX_LINES | ||||
customer_ trx_line_id | customer_trx_id | link_to_cust_ trx_line_id | line_type | extended_ amount |
108 | 122341 | LINE | 500 | |
Table 1 - 116. (Page 1 of 1) |
RA_CUST_TRX_LINE_GL_DIST | ||||
---|---|---|---|---|
cust_trx_line gl_dist_id | code_combination_id | customer_ trx_line_id | account_class | amount |
12345 | 01-1100-1000-3000 | REC | 500 | |
12346 | 01-6200-1000-3000 | 108 | REV | 500 |
Table 1 - 117. (Page 1 of 1) |
Two records are inserted into the RA_CUST_TRX_LINE_GL_DIST table. One contains the (unbilled) receivable account, which is linked to the record created in ra_customer_trx via the customer_trx_id. The second contains the (unearned) revenue account, which is linked to the record created in ra_customer_trx_lines via the customer_trx_line_id.
AR_PAYMENT_SCHEDULES | ||||||||
---|---|---|---|---|---|---|---|---|
payment _schedule _id | amount _due_ original | amount_ due_ remaining | customer _trx_id | cash_ receipt_ id | trx_ number | status | amount_ applied | class |
81194 | 500 | 500 | 122341 | NULL | G-101 | OP | NULL | GUAR |
Table 1 - 118. (Page 1 of 1) |
A record is created in AR_PAYMENT_SCHEDULES with class set to either DEP or GUAR depending on whether the commitment is a deposit or a guarantee. The amount_due_original and amount_due_remaining will initially be equal to the amount on the commitment.
Previous | Next | Contents | Index | Navigation | Glossary | Library |