Previous	Next		Contents	Index	Navigation	Glossary	Library

• RA_CUSTOMER_TRX

• RA_CUSTOMER_TRX_LINES

• RA_CUST_TRX_LINE_GL_DIST

• AR_PAYMENT_SCHEDULES

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)

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
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.

See Also

Invoice Against a Guarantee