Search Results ra_customer_trx_lines_all




The RA_CUSTOMER_TRX_LINES_ALL table is a fundamental component of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically within the Receivables (AR) module. It stores detailed line-level information for customer transactions, including invoices, debit memos, credit memos, and chargebacks. This table is critical for financial reporting, reconciliation, and downstream processing in Oracle EBS. Below is a detailed summary of its structure, key columns, relationships, and functional significance.

Table Structure and Key Columns

The RA_CUSTOMER_TRX_LINES_ALL table contains columns that capture transactional details at the line level. Some of the most important columns include:
  • CUSTOMER_TRX_LINE_ID: Primary key identifier for each transaction line.
  • CUSTOMER_TRX_ID: Foreign key linking to the parent transaction in RA_CUSTOMER_TRX_ALL.
  • LINE_TYPE: Indicates the type of line (e.g., 'LINE', 'TAX', 'FREIGHT').
  • LINE_NUMBER: Sequential number identifying the line within a transaction.
  • QUANTITY: The quantity of items or services billed.
  • UNIT_SELLING_PRICE: The unit price of the item or service.
  • EXTENDED_AMOUNT: Calculated as QUANTITY * UNIT_SELLING_PRICE.
  • REVENUE_AMOUNT: The recognized revenue amount for the line.
  • GL_DATE: The accounting date posted to the General Ledger.
  • ACCOUNTING_RULE_ID: Links to revenue recognition rules if applicable.
  • TAX_CODE: Identifier for tax calculations.
  • INVENTORY_ITEM_ID: Links to the item in MTL_SYSTEM_ITEMS_B if the line represents a product.

Functional Significance

The RA_CUSTOMER_TRX_LINES_ALL table plays a pivotal role in Oracle Receivables by:
  • Supporting Line-Level Accounting: Each line can have distinct GL accounts, enabling detailed financial tracking.
  • Enabling Revenue Recognition: Lines with accounting rules defer revenue and recognize it over time.
  • Facilitating Tax Calculations: Tax lines (LINE_TYPE = 'TAX') store tax amounts and rates.
  • Integrating with Inventory: For product-based transactions, the INVENTORY_ITEM_ID links to inventory data.

Relationships with Other Tables

The table is part of a broader data model in Oracle Receivables:
  • RA_CUSTOMER_TRX_ALL: Parent table containing header-level transaction data.
  • RA_CUST_TRX_LINE_GL_DIST_ALL: Stores GL distributions for each transaction line.
  • AR_CASH_RECEIPTS: Links to payments applied to transaction lines.
  • MTL_SYSTEM_ITEMS_B: For product-related lines, links to inventory items.

Technical Considerations

  • Multi-Org Structure: The _ALL suffix indicates it stores data for all operating units, filtered by ORG_ID.
  • Indexing: Key indexes include CUSTOMER_TRX_LINE_ID, CUSTOMER_TRX_ID, and ORG_ID for performance.
  • Audit Columns: Includes CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY for tracking changes.

Common Use Cases

  • Financial Reporting: Extracting line-level details for revenue and tax reporting.
  • Data Migration: Populating this table during invoice imports.
  • Custom Integrations: Feeding transactional data to downstream systems.
In summary, the RA_CUSTOMER_TRX_LINES_ALL table is a cornerstone of Oracle Receivables, providing granular transactional data essential for accounting, reporting, and integration processes in Oracle EBS 12.1.1 and 12.2.2.