Results for “bill_from_location_id”

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

Overview

ZX_REP_TRX_DETAIL_T is a reporting and tax-line detail table within the ZX (E-Business Tax) product schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores tax line information extracted from Payables, Receivables, and General Ledger, providing a denormalized, reporting-oriented view of tax determination results for downstream tax reporting, reconciliation, and regulatory filings. Unlike the operational ZX_LINES table, which is transactional in nature, ZX_REP_TRX_DETAIL_T is designed to support reporting extracts, aggregations, and audit trails where each row represents a single tax line enriched with transaction, party, product, and jurisdiction context.

From a Data Vault modeling perspective, the FK-based heuristic suggests this object behaves as a standalone entity rather than a strict hub, link, or satellite, though its structure — a single business-key with extensive foreign-key references and descriptive columns — most closely resembles a satellite-like detail record. The presence of a stable unique index on DETAIL_TAX_LINE_ID combined with dozens of descriptive columns supports this interpretation. In practice, the table is populated by E-Business Tax reporting extract processes and serves as the primary source for tax data warehouses and compliance reporting in both 12.1.1 and 12.2.2 environments.

Key Information Stored

The table contains 327 documented columns in the 12.2.2 schema, capturing tax lines across multiple dimensions. The most significant columns include:

• DETAIL_TAX_LINE_ID — the surrogate primary key, populated by sequence, uniquely identifying each tax line record.
• REP_CONTEXT_ID — foreign key to ZX_REP_CONTEXT_T, linking the tax line to its reporting context.
• TAX_LINE_ID — foreign key to ZX_LINES, the operational tax line from which the reporting record derives.
• TRX_ID, TRX_NUMBER — identifying the source transaction in Payables, Receivables, or General Ledger.
• TRX_LINE_ID, TRX_LINE_NUMBER — the specific transaction line associated with the tax line.
• TAX_AMT, TAXABLE_AMT, TAX_RATE — the calculated tax amount, taxable base, and applied rate.
• TAX_AMT_FUNCL_CURR, TAXABLE_AMT_FUNCL_CURR — functional-currency equivalents for reporting consistency.
• TAX_REGIME_CODE, TAX_JURISDICTION_CODE, TAX_RATE_CODE — the tax regime, jurisdiction, and rate code context.
• TRX_DATE, TAX_DATE, TAX_DETERMINE_DATE — key dates for period-based reporting and audit.
• LEDGER_ID, LEDGER_NAME, CHART_OF_ACCOUNTS_ID — the ledger and chart of accounts context.
• APPLICATION_ID, EVENT_CLASS_CODE, ENTITY_CODE — identifying the source application and event class.
• ESTABLISHMENT_ID — foreign key to PER_ESTABLISHMENTS, identifying the legal establishment.
• TAX_STATUS_ID, TAX_EXCEPTION_ID — foreign keys to ZX_STATUS_B and ZX_EXCEPTIONS, capturing status and exception context.
• HISTORICAL_FLAG, CANCELLED_DATE, CANCEL_FLAG, POSTED_FLAG — lifecycle and reporting-state indicators.
• TAX_LINE_USER_ATTRIBUTE1–15 — extensibility attributes for user-defined reporting.

The unique index ZX_REP_TRX_DETAIL_T_U1 on DETAIL_TAX_LINE_ID confirms that this column serves as both the primary key and the principal business-key candidate, while the many foreign keys position the table as a rich detail entity integrating tax, transaction, party, and ledger information.

Common Use Cases and Queries

ZX_REP_TRX_DETAIL_T is primarily queried for tax reporting, reconciliation between E-Business Tax and source subledgers, and preparation of statutory tax returns. A common query pattern joins to ZX_REP_CONTEXT_T to constrain a reporting period and to ZX_LINES for operational detail:

• Tax liability by regime and jurisdiction for a given period: SELECT TAX_REGIME_CODE, TAX_JURISDICTION_CODE, SUM(TAX_AMT_FUNCL_CURR) FROM ZX_REP_TRX_DETAIL_T WHERE TRX_DATE BETWEEN :p_start AND :p_end GROUP BY TAX_REGIME_CODE, TAX_JURISDICTION_CODE;
• Reconciliation of Payables or Receivables tax to GL: join to ZX_REP_CONTEXT_T on REP_CONTEXT_ID and aggregate TAX_AMT_FUNCL_CURR by LEDGER_ID and EVENT_CLASS_CODE.
• Exception and exemption reporting: filter on TAX_EXCEPTION_ID, TAX_STATUS_ID, or SELF_ASSESSED_FLAG to identify non-standard tax lines.
• Party and place-of-supply analysis using BILL_TO_PARTY_TAX_PROF_ID, SHIP_TO_PARTY_TAX_PROF_ID, and PLACE_OF_SUPPLY_TYPE_CODE for indirect tax returns.
• Historical trend analysis using HISTORICAL_FLAG and CANCELLED_DATE to distinguish active versus superseded records.
• Extensibility reporting via TAX_LINE_USER_ATTRIBUTE1–15 when clients store additional tax reporting attributes.

Because the table is populated by reporting extract processes, queries should account for REQUEST_ID and PROGRAM_ID to identify the specific extract run that produced a given result set.

Related Objects

Several objects are tightly coupled to ZX_REP_TRX_DETAIL_T through foreign-key relationships, and these represent the most significant dependencies:

• ZX_LINES — joined on TAX_LINE_ID; the operational tax line serving as the source of most reporting detail.
• ZX_REP_CONTEXT_T — joined on REP_CONTEXT_ID; defines the reporting context and period for the extract.
• PER_ESTABLISHMENTS — joined on ESTABLISHMENT_ID; provides legal establishment context for tax reporting.
• ZX_STATUS_B — joined on TAX_STATUS_ID; supplies tax status codes.
• ZX_EXCEPTIONS — joined on TAX_EXCEPTION_ID; supplies exception reason and certificate context.
• ZX_EVNT_CLS_MAPPINGS — joined on EVENT_CLASS_MAPPING_ID; maps event classes to tax determination rules.
• ZX_REP_TRX_JX_EXT_T — references DETAIL_TAX_LINE_ID; stores journal or tax journal extension attributes.
• ZX_REP_MATRIX_EXT_T — references DETAIL_TAX_LINE_ID; stores tax matrix extension data.
• ZX_REP_ACTG_EXT_T — references DETAIL_TAX_LINE_ID; stores accounting extension data for the tax line.
• GL_MGT_SEG_UPGRADE_H and FND_DM_PRODUCTS — joined on CHART_OF_ACCOUNTS_ID and PRODUCT_ID respectively, providing ledger and product context.

These relationships confirm that ZX_REP_TRX_DETAIL_T functions as a central detail hub for tax reporting, with the extension tables ZX_REP_TRX_JX_EXT_T, ZX_REP_MATRIX_EXT_T, and ZX_REP_ACTG_EXT_T providing specialized supplementary attributes keyed to the same DETAIL_TAX_LINE_ID.