Previous	Next		Contents	Index	Navigation	Glossary	Library

• RA_CUSTOMER_TRX

• RA_CUSTOMER_TRX_LINES

• RA_CUST_TRX_LINE_GL_DIST

• AR_PAYMENT_SCHEDULES

Invoice Number: I-101

Bill-To: ABC Inc

Invoice Date: 22-May-94

Invoice Lines:

Item	Amount	Tax	Total Amount
10 Chairs @ $200	$2000.00	$160.00	$2160.00
10 Tables @ $300	$3000.00	$240.00	$3240.00
		Sub-total:	$5400.00
		Freight Charges:	$1000.00
		Total:	$6400.00

Invoice number I-101 would be represented in Receivables tables as follows:

RA_CUSTOMER_TRX
customer_trx_id	trx_number	bill_to_customer_id	trx_date
101467	I-101	ABC Inc	22-May-94
Table 1 - 110. (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
100	101467		LINE	2000
101	101467	100	TAX	160
102	101467		LINE	3000
103	101467	102	TAX	240
104	101467		FREIGHT	1000
Table 1 - 111. (Page 1 of 1)

Since the example invoice had freight at the header-level, it is not linked to any line and the column, link_to_cust_trx_line_id is null.

RA_CUST_TRX_LINE_SALESREPS
140195	1492	100	1000	0	NULL
140196	1525	100	1000	0	NULL
140197	1492	101	0	80	NULL
140198	1525	101	0	80	NULL
140199	1624	102	3000	0	NULL
140200	1624	103	0	240	NULL
140201	1492	104	0	200	NULL
140202	1525	104	0	200	NULL
140203	1624	104	0	600	NULL
Table 1 - 112. (Page 1 of 1)

((vertical COM)) ?

The revenue and non-revenue amounts associated with the first line item of the invoice are split between salesperson 1492 and salesperson 1525. Salesperson 1624 gets the complete sales credit for the second line item of the invoice, while all three share the credit for the header level freight.

((vertical COM)) ?

The revenue and non-revenue amounts associated with the first line item of the invoice are split between agent 1492 and agent 1525. Agent 1624 gets the complete sales credit for the second line item of the invoice, while all three share the credit for the header level freight.

RA_CUST_TRX_LINE_GL_DIST
cust_trx_line_ gl_dist_id	code_combination_id	customer_ trx_line_id	account_class	amount
10866	01-1200-1000-3000		REC	64000
10867	01-8100-1000-3000	100	REV	2000
10868	01-4100-1000-3000	101	TAX	160
10869	01-8200-1000-3000	102	REV	3000
10870	01-4200-1000-3000	103	TAX	240
10871	01-4400-1000-3000	104	FREIGHT	1000
Table 1 - 113. (Page 1 of 1)

If you enter an invoice with rules (for example, Bill in Advance), the account distributions are not built when the invoice is initially created. Instead, RA_CUST_TRX_LINE_GL_DIST stores an account set, which represents how the actual distribution rows should be created and what percentage of the actual distribution should be allocated to each account. Account sets can be identified by a 'Y' in the account_set_flag column. The actual distribution records are built when the Revenue Recognition program is run.

AR_PAYMENT_SCHEDULES
payment _schedule _id	amount _due_ original	amount _due_ remaining	customer _trx_id	cash_ receipt_ id	trx_ number	status	amount_ applied	class
30191	6400	6400	101467	NULL	I-101	OP	NULL	INV
Table 1 - 114. (Page 1 of 1)

The example invoice has a status of OP (open) and an amount_applied of NULL because no payment has been applied against it. Once payment is received in full, the status will change to CL (closed), the amount_applied will be 6400 and the amount_due_remaining will be zero.

See Also

Commitments

Invoice Against a Deposit

Invoice Against a Guarantee

Chargebacks

About Adjustments