Search Results custtax_id

Overview

The OP_TXCU_ASC table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) module. It serves as the central repository for storing and managing customer-specific tax exemption information. Its primary role is to define and maintain the tax status of customers for specific tax authorities, enabling accurate and compliant tax calculations during the order-to-cash process. By linking customers, tax authorities, and applicable tax statuses, this table ensures that tax rules are correctly applied to transactions based on validated customer exemptions, which is critical for financial reporting and regulatory adherence.

Key Information Stored

The table's structure is designed to capture the essential elements of a tax exemption certificate or status. The primary unique identifier for each exemption record is the CUSTTAX_ID column. Each record associates a specific customer (CUST_ID) with a particular tax authority (TAXAUTH_ID) and defines the applicable TAX_STATUS for that relationship. A critical piece of evidence, the EXEMPTCERT_NO, stores the official certificate number provided by the customer. Additionally, the table can reference a TEXT_CODE, which typically points to a free-form text block in the system (OP_TEXT_HDR) for storing detailed notes or the full text of the exemption certificate.

Common Use Cases and Queries

The primary use case is determining the correct taxability of a sales transaction for a given customer and ship-to location. During order entry or invoice creation, the system queries this table to ascertain if an exemption applies. A common reporting need is to audit all active tax exemptions by customer. A sample query for this would be:

SELECT c.customer_name, a.taxauth_code, asc.tax_status, asc.exemptcert_no
FROM gml.op_txcu_asc asc,
ap.tx_taxa_mst a,
gml.op_cust_mst c
WHERE asc.taxauth_id = a.taxauth_id
AND asc.cust_id = c.cust_id
AND asc.effective_to_date IS NULL OR asc.effective_to_date >= SYSDATE;

Another critical operational query involves validating the existence of a specific exemption certificate number for a customer-tax authority combination before applying a tax override during transaction processing.

Related Objects

OP_TXCU_ASC is integrally connected to several master and transactional tables via foreign key relationships, as documented in the ETRM metadata. The key dependencies are:

• OP_CUST_MST: Linked via OP_TXCU_ASC.CUST_ID. This is the master customer table, ensuring exemptions are tied to valid customer records.
• TX_TAXA_MST: Linked via OP_TXCU_ASC.TAXAUTH_ID. This table defines the tax authorities, providing context for which governing body the exemption applies to.
• TX_TAXA_STS: Linked via OP_TXCU_ASC.TAX_STATUS. This reference table contains the valid tax status codes (e.g., 'Taxable', 'Exempt'), defining the specific condition of the exemption.
• OP_TEXT_HDR: Linked via OP_TXCU_ASC.TEXT_CODE. This relationship allows for the attachment of extensive descriptive text or legal documentation to the exemption record.