Previous | Next | Contents | Index | Navigation | Glossary | Library |
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) |
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) |
Previous | Next | Contents | Index | Navigation | Glossary | Library |