Previous	Next		Contents	Index	Navigation	Glossary	Library

• RA_CUSTOMER_TRX

• RA_CUSTOMER_TRX_LINES

• RA_CUST_TRX_LINE_GL_DIST.

Transaction Number: OC-101

Bill-To: ABC Inc

Transaction Date: 05-Jun-94

Credit Amount: -1000

On-Account Credit transaction number OC-101 would be represented in Receivables tables as follows:

RA_CUSTOMER_TRX
customer_ trx_id	trx_number	bill_to_ customer_id	trx_date	previous_ customer_ trx_id
660108	OC-101	ABC Inc	05-Jun-94	NULL
Table 1 - 138. (Page 1 of 1)

The previous_customer_trx_id column is NULL because the credit does not apply to a specific invoice.

RA_CUSTOMER_TRX_LINES
customer_ trx_line_id	customer_ trx_id	link_to_ cust_trx_ line_id	line_type	extended_ amount	previous_ customer_ trx_id	previous_ customer_ trx_line_id
170	660108		LINE	-1000
Table 1 - 139. (Page 1 of 1)

((vertical COM)) ?

If there had been a sales credit for this invoice, records relating to the revenue credit would be inserted in RA_CUST_TRX_LINE_SALESREPS, linked via the column customer_trx_line_id.

For on account credits Receivables inserts one record into RA_CUSTOMER_TRX_LINES. The total value of the credit is stored in the extended_amount column. The previous_customer_trx_line_id and previous_customer_trx_id columns are null because the credit does not apply to a specific invoice.

RA_CUST_TRX_LINE_GL_DIST
cust_trx_line_ gl_dist_id	code_combination_id	customer_ trx_line_id	account_class	amount
210220	01-1200-1000-3000		REC	-1000
210221	01-8100-1000-3000	170	REV	-1000
Table 1 - 140. (Page 1 of 1)

Because this is an on-account credit, the revenue account will be debited and the receivable will be credited.

See Also