Results for “in_tofd_mst”

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

Overview

IN_TOFD_MST is a reference master table owned by the GMI schema, which supports the Oracle Process Manufacturing (OPM) Inventory module within Oracle E-Business Suite 12.1.1 and 12.2.2. The table stores EC (European Community) Terms of Delivery codes used specifically for Intrastat statutory reporting. Intrastat requires that intra-community movements of goods between EU member states be reported with standardized delivery terms, and IN_TOFD_MST provides the controlled vocabulary of those delivery codes and their descriptions. Because the table exists primarily to supply valid code values to transactional records rather than to capture business events itself, it functions as a lightweight lookup master.

From a Data Vault modeling perspective, the metadata's heuristic classification lists this object as standalone. In practice, this suggests the table is best modeled as a small reference or hub-like structure keyed on the delivery code, with no documented foreign-key parents or dependents. Its descriptive attributes could alternatively be treated as satellite content attached to that business key, but because no parent link tables are documented, the simplest faithful representation is a standalone reference set. The table is marked VALID and is part of the Oracle Proprietary, Confidential Information designation.

Key Information Stored

The documented physical schema for 12.2.2 contains ten columns. The single-column primary key, IN_TOFD_MST_PK, is defined on EC_DELIVERY_CODE, which also serves as the business-key candidate via the unique index of the same name. This code is the value that downstream Intrastat and delivery transactions reference.

• EC_DELIVERY_CODE — the primary key and business key; the Intrastat delivery term code itself.
• EC_DELIVERY_DESC — the human-readable description of the delivery term, used in reports and validation lists.
• TEXT_CODE — an auxiliary code field, typically used for language or text-reference handling of the description.
• TRANS_CNT — a transaction counter commonly used in OPM tables for concurrency and record-version tracking.
• DELETE_MARK — the soft-delete flag; a value of 1 indicates a logically deleted row without physical removal.
• CREATION_DATE, CREATED_BY — audit columns recording insert timestamp and the user or process that created the row.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — audit columns capturing the most recent modification timestamp, user, and login session.

The surrogate key here is effectively the same as the business key, since EC_DELIVERY_CODE is both the primary key and the unique business identifier. There is no separate system-generated numeric surrogate documented.

Common Use Cases and Queries

A common requirement is to resolve or validate a delivery code captured on an Intrastat or shipment record. The user's search fragment "Itmcode =" suggests code-based lookup patterns, though for this table the operative key is EC_DELIVERY_CODE rather than an item code. A typical validation query is:

• Lookup by code: SELECT EC_DELIVERY_CODE, EC_DELIVERY_DESC FROM GMI.IN_TOFD_MST WHERE EC_DELIVERY_CODE = :code AND DELETE_MARK = 0;
• Populate an LOV: SELECT EC_DELIVERY_CODE, EC_DELIVERY_DESC FROM GMI.IN_TOFD_MST WHERE DELETE_MARK = 0 ORDER BY EC_DELIVERY_CODE;
• Audit recently changed terms: filter on LAST_UPDATE_DATE for a reporting period.
• Join to Intrastat reporting extracts to translate stored codes into printable descriptions.

Because the table is small and static, it is frequently joined to transactional Intrastat lines to enrich statutory EU trade reports with delivery-term text.

Related Objects

The metadata documents no foreign-key relationships, supporting the standalone classification. Related objects therefore consist of the transactional and setup tables that logically consume EC delivery codes:

• Intrastat reporting tables and views in the GMI/OPM inventory and order modules that store an EC delivery code and join on EC_DELIVERY_CODE.
• Shipment and delivery transaction tables that capture Intrastat delivery terms for EU movements.
• OPM Inventory setup and validation views that surface IN_TOFD_MST as a value list for user entry.
• Concurrent program and report definitions that produce Intrastat declarations, translating codes via EC_DELIVERY_DESC.

No PL/SQL APIs or dependent child tables are documented for this object, consistent with its role as a standalone reference master.