Search Results jai_mtl_trxs




Overview
Explore in AI Chat

Overview

JAI_MTL_TRXS is an Oracle E-Business Suite table owned by the JA (Asia/Pacific Localizations) schema that stores India-specific tax data associated with inter-organization inventory transfers. The table captures the fiscal attributes required by Indian excise, VAT, and GST legislation whenever material moves between inventory organizations, ensuring that statutory documents such as excise invoices, VAT invoices, and GST invoices can be generated and reconciled against the underlying material transaction. Because inter-org transfers are treated as taxable events in the Indian localization, this table acts as the bridge between standard Oracle Inventory transactions and the India tax reporting engine.

From a dimensional modeling perspective, the ETRM metadata assigns a heuristic Data Vault classification of link. This suggests that JAI_MTL_TRXS functions primarily as an associative structure that connects a source organization, a destination organization, an inventory item, a transaction type, and a tax category. In a Data Vault 2.0 implementation it would most naturally be modeled as a link table with references to the underlying hubs for organization, item, and transaction type, rather than as a standalone hub or satellite.

Key Information Stored

The table contains 30 documented columns. The most significant are the following:

Common Use Cases and Queries

Typical use cases include reconciling inter-org transfers against excise and GST registers, regenerating missing tax invoices, and auditing tax amounts by organization or item. A representative query joins the table to the item master and tax category to report GST liability:

  • Reporting total GST assessable value and tax amount by FROM_ORGANIZATION and transaction date.
  • Identifying transfers missing a GST_INVOICE_NO for statutory compliance follow-up.
  • Reconciling QTY_REGISTER against MTL_MATERIAL_TRANSACTIONS quantities for the same period.
  • Extracting EXCISE_INVOICE_NO and ASSESSABLE_VALUE feeds for excise return preparation.

A typical join pattern is:

SELECT t.TRANSACTION_ID, i.SEGMENT1, t.FROM_ORGANIZATION, t.TAX_AMOUNT, t.GST_INVOICE_NO FROM JA.JAI_MTL_TRXS t, MTL_SYSTEM_ITEMS_B i WHERE t.INVENTORY_ITEM_ID = i.INVENTORY_ITEM_ID AND t.TRANSACTION_DATE BETWEEN :p_from AND :p_to;

Related Objects

The following objects are the most significant related to JAI_MTL_TRXS, based on documented foreign key relationships and localization dependencies:

  • MTL_SYSTEM_ITEMS_B — joined on INVENTORY_ITEM_ID to resolve item attributes.
  • JAI_CMN_TAX_CTGS_ALL — joined on TAXCATEGORY_ID to retrieve tax category definitions.
  • MTL_TRANSACTION_TYPES — joined on TRANSACTION_TYPE_ID to identify the movement type.
  • MTL_MATERIAL_TRANSACTIONS — the parent inventory transaction table, used for quantity and cost reconciliation.
  • JAI_CMN_TAX_RATES — provides the rate definitions applied to the tax category.
  • JAI_AR_TRXS — the India localization table for AR-related tax transactions, sharing a similar structure for reporting integration.
  • ORG_ORGANIZATION_DEFINITIONS — resolves FROM_ORGANIZATION and TO_ORGANIZATION to organization names.