Previous	Next		Contents	Index	Navigation	Glossary	Library

• RA_CUSTOMER_TRX

• RA_CUSTOMER_TRX_LINES

• RA_CUST_TRX_LINE_GL_DIST

• AR_PAYMENT_SCHEDULES

• AR_ADJUSTMENTS

Invoice Number: I-103

Bill-To: ABC Inc

Invoice Date: 22-May-94

Invoice Lines:

	Amount	Tax	Total Amount
1 Table @ $1000	1000.00	100.00	$1100.00

with a sample guarantee:

Guarantee Number: G-102

Bill-To: ABC Inc

Deposit Date: 20-May-94

Amount: $500

Invoice I-103 applied against guarantee G-102 would be stored in Receivables tables as follows:

RA_CUSTOMER_TRX
customer_trx_id	trx_number	bill_to_customer_id	trx_date
110120	I-103	ABC Inc	22-May-94
Table 1 - 125. (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
120	110120		LINE	1000
121	110120	120	TAX	100
Table 1 - 126. (Page 1 of 1)

If there had been a sales credit for this invoice, records relating to the revenue credit would be inserted in the table 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
200101	01-1200-1000-3000		REC	1100
200102	01-8100-1000-3000	120	REV	1000
200103	01-4100-1000-3000	121	TAX	100
Table 1 - 127. (Page 1 of 1)

AR_PAYMENT_SCHEDULES
payment _schedule _id	amount _due_ original	amount_ due_ remaining	customer _trx_id	cash_ receipt_ id	trx_ number	status	amount_ applied	class
401100	1100	1100	110120	NULL	I-103	OP	NULL	INV
Table 1 - 128. (Page 1 of 1)

The payment schedule for the invoice originally shows an amount_due_remaining of 1100.

AR_ADJUSTMENTS
adjustment _id	amount	customer _trx_id	type	payment_ schedule_id	code_ combination_id
56789	-500	110120	INVOICE	302302	01-6200-1000-3000
Table 1 - 129. (Page 1 of 1)

When the invoice is applied to the guarantee, Receivables inserts a record into AR_ADJUSTMENTS to record an adjustment against the invoice. The amount column equals the inverse of the amount_due_remaining from the AR_PAYMENT_SCHEDULES table for the guarantee or the total value of the invoice lines, whichever is smaller. Receivables uses the customer_trx_id and payment_schedule_id to link the adjustment to the guarantee payment schedule in the AR_PAYMENT_SCHEDULES table.

The code_combination_id column stores the unearned revenue account of the guarantee. Receivables will use this account to reverse the unearned revenue distribution, originally created by the guarantee, and will use the unbilled receivable account, originally created by the guarantee, to reverse the unbilled receivable balance.

AR_PAYMENT_SCHEDULES
payment _schedule _id	amount _due_ original	amount_ due_ remaining	customer _trx_id	trx_ number	status	amount_ applied	class	amount_ adjusted
302302	500	0	110120	G-102	CL	NULL	GUAR	-500
Table 1 - 130. (Page 1 of 1)

The payment schedule record of the guarantee is updated to reflect the application of the invoice against the guarantee. The amount_due_remaining column is zero and the amount_adjusted column becomes -500. The payment schedule record for the invoice will not be impacted by the adjustment.

See Also

Invoice Against a Deposit