Search Results jai_ar_trx_ins_lines_t




Overview
Explore in AI Chat

Overview

The JAI_AR_TRX_INS_LINES_T table is a core transactional data object within the Asia/Pacific Localizations (JA) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as the primary repository for detailed tax records generated for invoice transactions. As documented, its specific role is to hold tax records after an invoice is saved, whether created via the AutoInvoice process or manually entered through the Receivables interface. This table is critical for compliance with regional tax regulations, capturing the calculated tax amounts, rates, and associated accounting flexfields for each invoice line.

Key Information Stored

The table stores a granular breakdown of tax applied to invoice lines. While the full column list is not provided in the excerpt, the documented foreign key relationships reveal its essential data components. Key stored information includes the link to the main invoice header (CUSTOMER_TRX_ID) and its specific lines (CUSTOMER_TRX_LINE_ID and LINK_TO_CUST_TRX_LINE_ID). It holds the identifier for the applied tax rule (VAT_TAX_ID) and the vital accounting information, specifically the General Ledger code combination (CODE_COMBINATION_ID) and the ledger or set of books identifier (SET_OF_BOOKS_ID). The ORG_ID column ensures data is partitioned by operating unit. The table's design implies it also stores calculated tax amounts and potentially the taxable basis, forming the complete audit trail for invoice-related taxation.

Common Use Cases and Queries

This table is central to tax reporting, reconciliation, and troubleshooting within localized implementations. Common use cases include generating statutory tax reports, reconciling the tax posted to the General Ledger with transactional tax calculations, and analyzing tax applied to specific invoices or customers. A typical query would join this table to the core Receivables transaction tables to retrieve a full tax breakdown.

  • Sample Query for Invoice Tax Details:
    SELECT trx.customer_trx_id, trx.trx_number, lines.tax_amount, lines.vat_tax_id, tax.name tax_name
    FROM jai_ar_trx_ins_lines_t lines,
         ra_customer_trx_all trx,
         jai_cmn_taxes_all tax
    WHERE lines.customer_trx_id = trx.customer_trx_id
    AND lines.vat_tax_id = tax.vat_tax_id
    AND trx.trx_number = 'INV12345';
  • Reconciliation Use Case: Comparing the sum of TAX_AMOUNT (assumed column) per CODE_COMBINATION_ID and period against GL account balances.

Related Objects

The table has integral relationships with several core EBS objects, as defined by its foreign keys. Its primary parent is the JAI_AR_TRXS table, which likely holds header-level tax information. It is directly linked to the standard Receivables transaction lines table (RA_CUSTOMER_TRX_LINES_ALL) via two columns, anchoring it to the core invoice data. The tax rules are referenced from JAI_CMN_TAXES_ALL. For financial posting, it is linked to GL_CODE_COMBINATIONS and GL_LEDGERS. The HR_ALL_ORGANIZATION_UNITS link enforces multi-org security. This network of relationships positions JAI_AR_TRX_INS_LINES_T as the crucial junction between Oracle Receivables transactions, the localized tax engine, and the General Ledger.