Search Results ra_customer_trx_lines_uk1

Overview

RA_CUSTOMER_TRX_LINES_ALL is the core transactional line table in the Oracle Receivables (AR) module. It stores the individual invoice, debit memo, chargeback, credit memo, and commitment lines that make up the header records held in RA_CUSTOMER_TRX_ALL. Every receivable document created in Oracle E-Business Suite, whether entered manually, imported through AutoInvoice, or generated by an external source such as Order Management, decomposes into one or more rows in this table. The table is owned by the AR schema and is classified as VALID in the ETRM repository for both Release 12.1.1 and 12.2.2, where it is documented with 158 columns.

The heuristic Data Vault classification mined from the foreign key structure is hub-leaning. This suggests that, in a dimensional or Data Vault style model, RA_CUSTOMER_TRX_LINES_ALL is best treated as the central hub for transaction line events, with satellites capturing descriptive, tax, revenue, and accounting attributes that change over time. The table participates in a dense network of relationships, both as a child of RA_CUSTOMER_TRX_ALL and as a parent to numerous downstream AR, subledger accounting, and external application tables.

Key Information Stored

The surrogate primary key is CUSTOMER_TRX_LINE_ID, enforced by the RA_CUSTOMER_TRX_LINES_PK constraint and the unique index RA_CUSTOMER_TRX_LINES_U1. This column uniquely identifies each line and is the join key used across nearly every dependent table. The business-key candidate is the composite of CUSTOMER_TRX_ID and LINE_NUMBER, enforced by the RA_CUSTOMER_TRX_LINES_UK1 unique index, which ties the line to its parent transaction in document-number sequence.

• CUSTOMER_TRX_ID – foreign key to RA_CUSTOMER_TRX_ALL, identifying the parent invoice or memo header.
• LINE_NUMBER – sequence of the line within the transaction, forming the business key with CUSTOMER_TRX_ID.
• LINE_TYPE – classifies the line as LINE, TAX, FREIGHT, or CHARGES, driving downstream accounting and reporting behavior.
• INVENTORY_ITEM_ID – the item being billed, where applicable.
• DESCRIPTION – free-text description printed on the transaction line.
• QUANTITY_ORDERED, QUANTITY_INVOICED, QUANTITY_CREDITED – quantity metrics used for revenue, returns, and credit memo processing.
• UNIT_SELLING_PRICE, EXTENDED_AMOUNT, REVENUE_AMOUNT – the core monetary values for the line.
• UNIT_STANDARD_PRICE – the standard cost or list price reference.
• TAXABLE_FLAG, TAX_RATE, TAX_EXEMPT_FLAG, TAX_EXEMPT_NUMBER – tax determination attributes.
• ACCOUNTING_RULE_ID, ACCOUNTING_RULE_DURATION, RULE_START_DATE, RULE_END_DATE – revenue recognition scheduling references from RA_RULES.
• SET_OF_BOOKS_ID, ORG_ID – the ledger and operating unit context for Multi-Org and subledger accounting.
• PREVIOUS_CUSTOMER_TRX_LINE_ID, LINK_TO_CUST_TRX_LINE_ID, INITIAL_CUSTOMER_TRX_LINE_ID – self-referencing lineage columns that trace credits, chargebacks, and adjustments back to original lines.

Common Use Cases and Queries

The table is central to receivables reporting, revenue analysis, tax reconciliation, and integration reconciliation. A typical pattern joins the line table back to the transaction header to obtain customer and document context:

• Transaction detail reporting: join RA_CUSTOMER_TRX_LINES_ALL to RA_CUSTOMER_TRX_ALL on CUSTOMER_TRX_ID to retrieve invoice number, customer, and line amounts for a given period.
• Revenue recognition review: join to RA_RULES on ACCOUNTING_RULE_ID and to the distribution table RA_CUST_TRX_LINE_GL_DIST_ALL on CUSTOMER_TRX_LINE_ID to analyze deferred versus recognized revenue.
• Credit and adjustment lineage: self-joins on PREVIOUS_CUSTOMER_TRX_LINE_ID or LINK_TO_CUST_TRX_LINE_ID trace credit memos and chargebacks to the original invoice line, essential for returns analysis.
• Tax reconciliation: join to ZX_LINES on TAX_LINE_ID and to AR_SALES_TAX on SALES_TAX_ID to reconcile calculated tax against recorded tax.
• AutoInvoice validation: compare lines staged in RA_INTERFACE_LINES_ALL against inserted RA_CUSTOMER_TRX_LINES_ALL rows to detect import failures.

Related Objects

• RA_CUSTOMER_TRX_ALL – parent header table, joined on CUSTOMER_TRX_ID.
• RA_CUST_TRX_LINE_GL_DIST_ALL – distributions per line, joined on CUSTOMER_TRX_LINE_ID.
• RA_CUST_TRX_LINE_SALESREPS_ALL – sales credit assignments per line, joined on CUSTOMER_TRX_LINE_ID.
• AR_ADJUSTMENTS_ALL – adjustments referencing CUSTOMER_TRX_LINE_ID.
• AR_RECEIVABLE_APPLICATIONS_ALL – cash applications referencing APPLIED_CUSTOMER_TRX_LINE_ID.
• AR_REVENUE_ADJUSTMENTS_ALL – revenue adjustments via FROM_CUST_TRX_LINE_ID and TO_CUST_TRX_LINE_ID.
• OE_ORDER_LINES_ALL – order lines referencing REFERENCE_CUSTOMER_TRX_LINE_ID.
• RA_CM_REQUEST_LINES_ALL – credit memo request lines joined on CUSTOMER_TRX_LINE_ID.
• AR_INTERFACE_LINES_ALL / RA_INTERFACE_LINES_ALL – AutoInvoice staging tables that feed this table.