Search Results tx_taxa_mst_pk




Overview
Explore in AI Chat

Overview

The TX_TAXA_MST table is a master data object within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) module. It serves as the central repository for defining and managing Tax Authorities. A tax authority is a governing body, such as a federal, state, or municipal agency, that imposes and collects taxes. This table is foundational to the EBS tax engine, as it establishes the entities to which tax liabilities are reported and remitted. Its integrity and proper configuration are critical for accurate tax calculation, reporting, and compliance across financial and supply chain transactions.

Key Information Stored

The table's primary identifier is the TAXAUTH_ID (Primary Key: TX_TAXA_MST_PK), a system-generated unique internal ID. A second unique key constraint (TX_TAXA_MST_U1) is enforced on the TAXAUTH_CODE, which is the user-defined, business-friendly identifier for the authority. Other significant columns, inferred from the foreign key relationships, include ADDR_ID (linking to SY_ADDR_MST for the authority's address), TEXT_CODE (linking to TX_TEXT_HDR for descriptive text), and TAXRPT_CLASS (linking to TX_TXRP_CLS, likely defining a tax reporting classification). These columns collectively store the core administrative and operational details necessary for tax processing.

Common Use Cases and Queries

This table is primarily referenced for setup, validation, and reporting. Common operational scenarios include configuring a new tax jurisdiction, validating tax authority codes during transaction entry, and generating regulatory tax reports. A typical query to list all active tax authorities with their codes and associated addresses would join TX_TAXA_MST with SY_ADDR_MST. For troubleshooting, one might query the relationships between a tax authority and its detailed tax rules (TX_TAXA_DTL) or its assigned tax locations (TX_TLOC_ASC). A fundamental reporting use case is aggregating tax liabilities by authority for remittance, often involving joins to transaction tax tables like TX_HIST_TAX.

Related Objects

As indicated by the foreign key metadata, TX_TAXA_MST has extensive relationships within the GML and financials tax infrastructure. Key dependent child tables include TX_TAXA_DTL (for detailed tax rate rules), TX_TLOC_ASC (for associating authorities with geographic locations), and TX_HIST_TAX (for historical tax transaction records). It is referenced by other modules, such as GL_ACCT_MAP for accounting mappings and OP_TXCU_ASC within Order Management. Parent tables it references for descriptive data are SY_ADDR_MST (addresses), TX_TEXT_HDR (text), and TX_TXRP_CLS (reporting class).