Search Results jai_ar_sup_lines_pk

Overview

JAI_AR_SUP_LINES is a transactional table owned by the JA (Asia/Pacific Localizations) schema in Oracle E-Business Suite, available in both 12.1.1 and 12.2.2. It stores supplementary transaction details for individual receivable line items together with the original invoice details that those lines originated from. The table is central to the JA localization requirement for capturing excise, tax, and pricing adjustments raised against specific invoice lines, most notably for India and other Asia/Pacific legislative regimes where a supplementary invoice must reference the original invoice line it corrects or supplements.

Within the ETRM metadata, the heuristic Data Vault classification for JAI_AR_SUP_LINES is a link. This classification reflects the fact that the table is primarily composed of foreign key relationships to customer transactions, customer transaction lines, tax categories, and supplementary change records. In a Data Vault model it would function as a link table connecting these business entities, with its measurable amounts and dates handled as link-level attributes or moved to a satellite.

Key Information Stored

The table contains 31 documented columns. Its surrogate primary key is defined by JAI_AR_SUP_LINES_PK on CUSTOMER_TRX_LINE_ID, which uniquely identifies each supplementary line record and is also a foreign key to RA_CUSTOMER_TRX_LINES_ALL. The most significant columns include:

CUSTOMER_TRX_LINE_ID – primary key and link to the original receivable line in RA_CUSTOMER_TRX_LINES_ALL.
CUSTOMER_TRX_ID – foreign key to RA_CUSTOMER_TRX_ALL, identifying the header of the supplementary transaction.
LINE_NUMBER – the line sequence within the supplementary transaction.
SUP_INV_TYPE – supplementary invoice type indicator.
INVENTORY_ITEM_ID and DESCRIPTION – the inventory item and its description on the line.
QUANTITY and UNIT_CODE – quantity and unit of measure for the supplementary line.
TAX_CATEGORY_ID – foreign key to the tax category definition (JAI_CMN_TAX_CTGS_ALL).
OLD_SELLING_PRICE / NEW_SELLING_PRICE – original and revised selling prices.
OLD_ASSESSABLE_VALUE / NEW_ASSESSABLE_VALUE – original and revised assessable values used for excise determination.
EXIST_LINE_AMT, EXIST_EXCISE_AMT, EXIST_OTHER_AMT – existing amounts before adjustment.
NEW_LINE_AMT, NEW_EXCISE_AMT, NEW_OTHER_AMT – new amounts after adjustment.
LINE_DIFF_AMT, EXCISE_DIFF_AMT, OTHER_DIFF_AMT – calculated differences between old and new values.
PL_MAPPING_ID / AL_MAPPING_ID – foreign keys to JAI_AR_SUP_CHANGES_ALL, linking to the price list and adjustment list change records.

Standard audit columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY, OBJECT_VERSION_NUMBER, INTERFACE_LINE_ATTRIBUTE2) are also present for concurrency control and interface traceability. CUSTOMER_TRX_LINE_ID serves as the natural business key in practice, since it corresponds one-to-one with the original invoice line.

Common Use Cases and Queries

JAI_AR_SUP_LINES supports supplementary invoice reporting, excise reconciliation, and audit of price or tax corrections on previously invoiced lines. A typical query joins the table to its parent lines and headers:

Listing all supplementary lines for a given supplementary transaction, returning LINE_NUMBER, INVENTORY_ITEM_ID, QUANTITY, OLD_SELLING_PRICE, NEW_SELLING_PRICE, and the three difference columns.
Reconciling excise liability by comparing EXIST_EXCISE_AMT against NEW_EXCISE_AMT and grouping by TAX_CATEGORY_ID.
Auditing mapping changes through PL_MAPPING_ID and AL_MAPPING_ID against JAI_AR_SUP_CHANGES_ALL.
Reporting original versus revised assessable values for statutory submissions using OLD_ASSESSABLE_VALUE and NEW_ASSESSABLE_VALUE.

Standard joins are JAI_AR_SUP_LINES.CUSTOMER_TRX_ID = RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID and JAI_AR_SUP_LINES.CUSTOMER_TRX_LINE_ID = RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID.

Related Objects

RA_CUSTOMER_TRX_ALL – parent header; joined on CUSTOMER_TRX_ID.
RA_CUSTOMER_TRX_LINES_ALL – parent line; joined on CUSTOMER_TRX_LINE_ID.
JAI_CMN_TAX_CTGS_ALL – tax category definitions; joined on TAX_CATEGORY_ID.
JAI_AR_SUP_CHANGES_ALL – supplementary change records; referenced twice via PL_MAPPING_ID and AL_MAPPING_ID.
JAI_AR_SUP_HEADERS (related JA supplementary header table) – header context for the supplementary transaction.
JAI_AR_TRX_LINES and related JA localization views that consume these line-level excise details.
AR interface and concurrent programs that populate supplementary invoices from original transaction data.

INDEX: JA.JAI_AR_SUP_LINES_PK 12.2.2
owner:JA, object_type:INDEX, object_name:JAI_AR_SUP_LINES_PK, status:VALID,
Table: JAI_AR_SUP_LINES 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AR_SUP_LINES, object_name:JAI_AR_SUP_LINES, status:VALID, product: JA - Asia/Pacific Localizations , description: Table stores SuppTransaction dtls of the individual items with the Orig Inv dtls , implementation_dba_data: JA.JAI_AR_SUP_LINES ,
INDEX: JA.JAI_AR_SUP_LINES_PK 12.1.1
owner:JA, object_type:INDEX, object_name:JAI_AR_SUP_LINES_PK, status:VALID,
Table: JAI_AR_SUP_LINES 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AR_SUP_LINES, object_name:JAI_AR_SUP_LINES, status:VALID, product: JA - Asia/Pacific Localizations , description: Table stores SuppTransaction dtls of the individual items with the Orig Inv dtls , implementation_dba_data: JA.JAI_AR_SUP_LINES ,
TABLE: JA.JAI_AR_SUP_LINES 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AR_SUP_LINES, object_name:JAI_AR_SUP_LINES, status:VALID,
TABLE: JA.JAI_AR_SUP_LINES 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AR_SUP_LINES, object_name:JAI_AR_SUP_LINES, status:VALID,
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
eTRM - JA Tables and Views 12.1.1
description: The 'JA_CN_SYSTEM_PARAMETERS_ALL' table stores information defined by 'System Options' form, 'Electronic Accounting Book Export' program will get most data from data in the table. A legal entity can only have one record in the table. ,
eTRM - JA Tables and Views 12.2.2
description: The 'JA_CN_VOUCHER_NUMBER' table stores the voucher number of GL journal lines. ,
eTRM - JA Tables and Views 12.1.1
description: The 'JA_CN_SYSTEM_PARAMETERS_ALL' table stores information defined by 'System Options' form, 'Electronic Accounting Book Export' program will get most data from data in the table. A legal entity can only have one record in the table. ,
eTRM - JA Tables and Views 12.2.2
description: The 'JA_CN_VOUCHER_NUMBER' table stores the voucher number of GL journal lines. ,