Results for “item_tariff”

42 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

JAI_INV_ITM_SETUPS is a localization table owned by the JA (Asia/Pacific Localizations) schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its purpose is to store localization-specific item attributes that are defined for an inventory item at the inventory organization level. Unlike the core item master, which holds globally defined attributes in MTL_SYSTEM_ITEMS_B, this table captures the country- or region-specific compliance and reporting attributes required by Asia/Pacific localizations, such as excise, MODVAT, and tariff-related flags. The table is documented as VALID with 15 columns and is a critical extension point for localizations that must reconcile item-level statutory attributes with transactional tax and shipping data.

From a modeling perspective, the mined Data Vault classification for this table is hub-leaning. This suggests treating the composite key (INVENTORY_ITEM_ID, ORGANIZATION_ID) as a business key hub, with the remaining descriptive columns considered satellite attributes. This classification is heuristic and should be validated against the actual item attribute model in the target implementation.

Key Information Stored

The table is anchored by its primary key, JAI_INV_ITM_SETUPS_PK, defined on the composite of INVENTORY_ITEM_ID and ORGANIZATION_ID. These two columns form the business-key candidate and together uniquely identify a localization setup record for a given item within a given organization.

  • INVENTORY_ITEM_ID — Surrogate identifier of the inventory item, joined to MTL_SYSTEM_ITEMS_B.
  • ORGANIZATION_ID — Identifier of the inventory organization for which the localization attributes are defined.
  • ITEM_CLASS — Localization classification of the item, used to drive statutory treatment.
  • MODVAT_FLAG — Indicator of MODVAT (modified value-added tax) applicability for the item.
  • EXCISE_FLAG — Indicator of excise applicability.
  • ITEM_TRADING_FLAG — Indicates whether the item is treated as a trading item under localization rules.
  • ITEM_TARIFF — Tariff classification or rate code associated with the item.
  • ITEM_FOLIO — Folio or reference value used in localization reporting.
  • SYNCHRONIZATION_NUMBER — Identifier used to track synchronization of setup records across localization processes.
  • OBJECT_VERSION_NUMBER — Optimistic locking column supporting concurrent updates.
  • CREATION_DATE / CREATED_BY / LAST_UPDATE_DATE / LAST_UPDATED_BY / LAST_UPDATE_LOGIN — Standard audit columns recording who created and last modified each setup record.

Common Use Cases and Queries

Typical use cases include localization reporting on excise and MODVAT applicability, reconciliation of item-level statutory attributes against transactional records, and validation that every item in a localization organization has the required setup. A common query joins the table to the item master to retrieve localization attributes for a specific organization:

  • SELECT jis.inventory_item_id, jis.organization_id, jis.item_class, jis.modvat_flag, jis.excise_flag, jis.item_tariff FROM jai_inv_itm_setups jis WHERE jis.organization_id = :org_id;
  • Joining to MTL_SYSTEM_ITEMS_B to resolve item names and descriptions for reporting.
  • Identifying items missing localization setup by outer-joining from MTL_SYSTEM_ITEMS_B to JAI_INV_ITM_SETUPS.
  • Extracting trap flag combinations for audit and statutory filing.

Related Objects

JAI_INV_ITM_SETUPS references MTL_SYSTEM_ITEMS_B via INVENTORY_ITEM_ID and is referenced by numerous localization transaction tables through the composite of INVENTORY_ITEM_ID and ORGANIZATION_ID.