Results for “taxauth_code”

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

Overview

TX_TAXA_MST is the master table of tax authorities within the Oracle E-Business Suite Process Manufacturing Logistics (GML) module. It resides in the GML schema and holds one row per tax authority recognized by the application, functioning as the central reference point for parties to whom tax is reported or remitted. The table carries a status of VALID in the ETRM 12.2.2 physical schema, where it is documented with 45 columns. Under an ETRM 12.1.1 implementation the same object is exposed through the GML schema with an equivalent core structure.

Because the table stores descriptive master data keyed by a surrogate identifier and referenced by many downstream transactional and setup tables, the heuristic Data Vault classification derived from its foreign key topology is that of a hub. This classification is offered as a modeling suggestion: TAXAUTH_ID acts as the hub key, while the surrounding foreign keys fan out to dependent tables that behave as link and satellite structures.

Key Information Stored

The table is anchored by a surrogate primary key, TAXAUTH_ID, generated through the TX_TAXA_MST_PK index. A second unique index, TX_TAXA_MST_U1, enforces uniqueness on TAXAUTH_CODE, making the code the natural business-key candidate for the tax authority. The most significant columns include:

• TAXAUTH_ID — surrogate primary key identifying each tax authority; the column carried as a foreign key by dependent tables.
• TAXAUTH_CODE — user-facing unique code, enforced by the TX_TAXA_MST_U1 unique index.
• TAXAUTH_DESC — descriptive name of the tax authority.
• ADDR_ID — foreign key to SY_ADDR_MST, supplying the authority's address record.
• TAXRPT_CLASS — foreign key to TX_TXRP_CLS, classifying the authority for tax reporting purposes.
• TEXT_CODE — foreign key to TX_TEXT_HDR, linking supplemental descriptive text.
• ACTIVE_IND / IN_USE — status flags governing whether the authority is active and currently selectable.
• DELETE_MARK — soft-delete indicator used by the Process Manufacturing data model.
• AUDIT columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN provide standard WHO tracking.
• ATTRIBUTE1–ATTRIBUTE30 and ATTRIBUTE_CATEGORY — the DFF (descriptive flexfield) segments reserved for client-specific extensions.

Common Use Cases and Queries

TX_TAXA_MST is most often queried to resolve a code or description to the surrogate TAXAUTH_ID used throughout tax transactions. A common reporting pattern joins the master to its address and reporting class:

• Listing active tax authorities with their reporting class for configuration validation.
• Resolving TAXAUTH_ID values returned by transaction tables such as OP_INVC_CHG back to TAXAUTH_CODE and TAXAUTH_DESC.
• Auditing soft-deleted or inactive records prior to cleanup.

A representative query joins the authority to its address record and filters on the active flag, and a secondary lookup by code is satisfied directly by the TX_TAXA_MST_U1 unique index. Reporting against the DFF attributes is common where statutory reporting requires client-specific authority attributes.

Related Objects

The following objects are the most significant dependencies derived from the documented foreign key relationships:

• SY_ADDR_MST — joined on TX_TAXA_MST.ADDR_ID; supplies address data.
• TX_TEXT_HDR — joined on TX_TAXA_MST.TEXT_CODE; supplies descriptive text.
• TX_TXRP_CLS — joined on TX_TAXA_MST.TAXRPT_CLASS; supplies the reporting classification.
• TX_TAXA_DTL — detail table referencing TAXAUTH_ID, holding the operational tax authority details.
• TX_HIST_TAX — historical tax records referencing TAXAUTH_ID.
• TX_TLOC_ASC — location association referencing TAXAUTH_ID.
• OP_TXCU_ASC — customer association referencing TAXAUTH_ID.
• GL_ACCT_MAP — accounting map referencing TAXAUTH_ID for GL posting.
• OP_INVC_CHG — invoice charge lines referencing TAXAUTH_ID.

Together these relationships confirm TX_TAXA_MST as the authoritative hub for tax authority identity across GML processing and financial integration flows.