Results for “header_ext_varchar_attribute1”
26 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
ZX_PTNR_NEG_LINE_GT is a global temporary table owned by the ZX schema within the E-Business Tax (E-Business Suite 12.1.1 and 12.2.2) module. It serves a narrowly scoped but important purpose: caching a copy of transaction lines before a user modifies them. This copy operation is performed only for upgraded tax partner integration scenarios, meaning the table exists to preserve the pre-modification state of line-level tax data so that the integrated tax partner can correctly reconcile what changed. Because the table is a global temporary table (GTT), its rows are session- or transaction-scoped, and the data is automatically purged based on the GTT definition, preventing long-term accumulation of transient records.
In terms of heuristic Data Vault modeling, the FK relationships show this table references EVENT_CLASS_MAPPING_ID, TRX_LINE_ID, and PRODUCT_ID, yet the table itself is classified as standalone (no other table is documented as referencing it). This suggests the object chiefly functions as a staging or temporary satellite-per-line construct, holding descriptive line snapshots rather than acting as a persistent hub or link. It should be treated as transient working data rather than an authoritative source of record.
Key Information Stored
The table contains 219 documented columns, most of which are repeated geography and descriptive attribute sets (ship-to, ship-from, bill-to, bill-from type/value pairs, and generic EXT attribute columns). The most operationally significant columns include:
- TRX_LINE_ID – Foreign key to CN_TRX_LINES_ALL; identifies the transaction line being cached.
- EVENT_CLASS_MAPPING_ID – Foreign key to ZX_EVNT_CLS_MAPPINGS; links the line to its event class mapping used by the tax engine.
- PRODUCT_ID – Foreign key to FND_DM_PRODUCTS; the product associated with the cached line.
- TRX_ID and TRX_NUMBER – Transaction identifier and human-readable transaction number.
- ENTITY_CODE and EVENT_CLASS_CODE – Identify the business entity and event class driving tax determination.
- TRX_DATE and TRX_LINE_DATE – Transaction and line dates, critical to date-effective tax rules.
- LINE_AMT, TRX_LINE_QUANTITY, UNIT_PRICE – The monetary and quantity values that are most likely to change and therefore must be preserved.
- RECORD_TYPE_CODE, TRX_LINE_TYPE, LINE_LEVEL_ACTION – Classification codes indicating the nature and action on the line.
- TAX_REGIME_CODE and TAX_PROVIDER_ID – Tax regime and provider context for the line.
- APPLIED_FROM_TRX_ID / LINE_ID and ADJUSTED_DOC_* columns – Reference the originating or adjusted documents when the line results from an applied or adjusted transaction.
- EXEMPT_CERTIFICATE_NUMBER, EXEMPT_REASON, EXEMPTION_CONTROL_FLAG – Exemption details relevant to tax calculation.
The surrogate primary key is not explicitly segregated in the documented metadata; business-key candidates are effectively the combination of TRX_LINE_ID with EVENT_CLASS_MAPPING_ID, which uniquely positions a cached line within its tax computation context.
Common Use Cases and Queries
Typical scenarios for this table revolve around tax partner integration upgrades, reconciliation, and troubleshooting. Because it is a global temporary table, queries only succeed within the session that populated it, so diagnostic queries are usually run immediately after a transaction modification.
- Reconciling pre- and post-modification lines: Compare cached values with current CN_TRX_LINES_ALL values to identify what changed and drive correct tax recalculation.
- Verifying exemption handling: Confirm EXEMPT_CERTIFICATE_NUMBER and EXEMPTION_CONTROL_FLAG were captured before edits.
- Tracing applied and adjusted documents: Use APPLIED_FROM_TRX_ID, APPLIED_FROM_LINE_ID, and the ADJUSTED_DOC_* columns to reconstruct document lineage.
A representative query joins the GTT to its transaction line and event class mapping:
SELECT g.TRX_LINE_ID, g.LINE_AMT, g.TAX_REGIME_CODE, c.LINE_AMOUNT, m.EVENT_CLASS_CODE FROM ZX.ZX_PTNR_NEG_LINE_GT g, CN_TRX_LINES_ALL c, ZX_EVNT_CLS_MAPPINGS m WHERE g.TRX_LINE_ID = c.LINE_ID AND g.EVENT_CLASS_MAPPING_ID = m.EVENT_CLASS_MAPPING_ID;
Related Objects
The foreign keys documented for ZX_PTNR_NEG_LINE_GT establish the following significant related objects:
- CN_TRX_LINES_ALL – joined via TRX_LINE_ID; the authoritative transaction line table.
- ZX_EVNT_CLS_MAPPINGS – joined via EVENT_CLASS_MAPPING_ID; defines the event class mapping for tax.
- FND_DM_PRODUCTS – joined via PRODUCT_ID; the product definition used to resolve line product context.
Related E-Business Tax objects typically consulted alongside this table include ZX_LINES, ZX_LINES_DET_FACTORS, and ZX_TRX_LINES for tax line results, plus the tax partner integration APIs that populate and consume the cached negative lines during upgrade processing. Because the table is standalone in the FK graph, dependent objects are generally program units and integration routines rather than other tables referencing it.
-
This global temporary table is used to cache copy of the transaction lines before user modifies them. This copying is carried only for upgraded tax partner integration.
-
This table stores the user extensible attributes that need to be passed to the partner service at the transaction level for the purpose of tax processing/reporting.
-
This table stores the user extensible attributes that need to be passed to the partner service at the transaction level for the purpose of tax processing/reporting.
-
This global temporary table is used to cache copy of the transaction lines before user modifies them. This copying is carried only for upgraded tax partner integration.
-
eTRM - ZX Tables and Views 12.2.2
This global temporary table is used to return validation errors for imported transactions from tax perspective.
-
eTRM - ZX Tables and Views 12.1.1
This global temporary table is used to return validation errors for imported transactions from tax perspective.