Commitments

Receivables uses the following tables to store your commitment information:

Consider a sample guarantee:

Guarantee Number: G-101

Bill-To: ABC Inc

Guarantee Date: 20-May-94

Amount: $500

RA_CUSTOMER_TRX

Guarantee number G-101 is stored in this table as follows:

customer_trx_id trx_number bill_to_customer_id trx_date
122341 G-101 ABC Inc 20-May-94

RA_CUSTOMER_TRX_LINES

Guarantee number G-101 is stored in this table as follows:

customer_trx_line_id customer_trx_id link_to_cust_trx_line_id line_type extended_amount
108 122341   LINE 500

One record is inserted into the RA_CUSTOMER_TRX_LINES table with a line_type of 'LINE'. The extended_amount column will store the amount of the commitment. If there had been a sales credit for this commitment, records relating to the sales credit would be inserted in RA_CUST_TRX_LINE_SALESREPS, linked via the column customer_trx_line_id.

RA_CUST_TRX_LINE_GL_DIST

Guarantee number G-101 is stored in this table as follows:

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

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

Guarantee number G-101 is stored in this table as follows:

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

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.

Related Topics