Results for “basis_result_id”

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

Overview

ZX_LINES is the central detail table in the Oracle E-Business Tax (ZX) module. It stores individual tax lines calculated for transactions across multiple event classes, including Payables invoices, Receivables transactions, and purchasing documents. Each row represents a distinct tax determination outcome — a specific tax, tax status, tax rate, and jurisdiction applied to a transaction line, together with the calculated taxable and tax amounts in transaction, tax, and functional currencies. In Oracle EBS 12.1.1 and 12.2.2, ZX_LINES is the primary source for tax reporting, tax reconciliation, and downstream accounting entries generated through Subledger Accounting.

The heuristic Data Vault classification of ZX_LINES is satellite-leaning. This reflects its structure: it holds descriptive, transactional, and largely additive attributes keyed to a business transaction context, with numerous foreign keys to reference and lookup tables. It should be modeled as a satellite attached to the transaction and tax-determination hubs rather than as a pure hub or link.

Key Information Stored

The table contains 310 documented columns. The surrogate primary key is TAX_LINE_ID (index ZX_LINES_U2). Two unique business-key candidates are documented. ZX_LINES_U1 spans APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LEVEL_TYPE, TRX_LINE_ID, TAX_REGIME_CODE, TAX, and TAX_APPORTIONMENT_LINE_NUMBER, uniquely identifying a tax line within its transaction context.

• TAX_LINE_ID — surrogate primary key and the value referenced by virtually all downstream tax and accounting tables.
• APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE — identify the source application, entity, and event class of the originating transaction.
• TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE — link the tax line to its transaction header and line; TRX_LEVEL_TYPE distinguishes header-, line-, or tax-only-level records.
• TAX_REGIME_CODE, TAX_ID, TAX, TAX_STATUS_CODE, TAX_RATE_CODE — the tax determination result: regime, tax, tax name, status, and rate.
• TAX_JURISDICTION_CODE, PLACE_OF_SUPPLY — jurisdiction and place-of-supply information used for reporting and compliance.
• TRX_CURRENCY_CODE, TAX_CURRENCY_CODE, TAX_AMT, TAXABLE_AMT, TAX_AMT_FUNCL_CURR — monetary amounts in transaction, tax, and functional currencies.
• TAX_EXEMPTION_ID, TAX_EXCEPTION_ID — links to exemption and exception records where applicable.
• LEGAL_ENTITY_ID, LEDGER_ID, TAX_REGISTRATION_ID — legal entity, ledger, and registration context for the tax line.
• SUMMARY_TAX_LINE_ID, REVERSED_TAX_LINE_ID, ADJUSTED_DOC_TAX_LINE_ID — self-referencing links for summarization, reversal, and adjustment.
• CALC_RESULT_ID and the various *_RESULT_ID columns — point to ZX_PROCESS_RESULTS rows capturing the rule-evaluation trace behind the determination.

Common Use Cases and Queries

ZX_LINES is queried for tax reconciliation, audit, GST/VAT reporting, and debugging tax determination. Typical patterns join it to ZX_LINES_SUMMARY or RA_CUSTOMER_TRX_LINES_ALL. For example, to retrieve taxes for a given Receivables transaction:

• SELECT tax_line_id, tax_regime_code, tax, tax_rate_code, taxable_amt, tax_amt FROM zx.zx_lines WHERE application_id = 222 AND entity_code = 'TRANSACTIONS' AND trx_id = :p_trx_id;
• Reconciliation to subledger distributions uses ZX_REC_NREC_DIST.TAX_LINE_ID = ZX_LINES.TAX_LINE_ID.
• Reporting joins TAX_LINE_ID to RA_CUSTOMER_TRX_LINES_ALL.TAX_LINE_ID and ZX_REP_TRX_DETAIL_T.TAX_LINE_ID.

Related Objects

• ZX_LINES_SUMMARY — joined via SUMMARY_TAX_LINE_ID.
• ZX_PROCESS_RESULTS — joined via CALC_RESULT_ID and other *_RESULT_ID columns; supplies determination trace.
• ZX_REC_NREC_DIST — recoverable/non-recoverable distributions referencing TAX_LINE_ID.
• RA_CUSTOMER_TRX_LINES_ALL — Receivables lines referencing TAX_LINE_ID.
• ZX_LINES_DET_FACTORS — detail factors referencing SOURCE_TAX_LINE_ID.
• ZX_LINES (self) — OFFSET_LINK_TO_TAX_LINE_ID, REVERSED_TAX_LINE_ID, ADJUSTED_DOC_TAX_LINE_ID.
• ZX_REGIMES_B, ZX_TAXES_B, ZX_RATES_B, ZX_STATUS_B — reference definitions via TAX_REGIME_CODE, TAX_ID, TAX_RATE_ID, TAX_STATUS_ID.
• ZX_PARTY_TAX_PROFILE — joined via CONTENT_OWNER_ID, TAX_PROVIDER_ID, and rounding profile columns.
• ZX_REP_TRX_DETAIL_T, ZX_ERRORS_GT, ZX_DETAIL_TAX_LINES_GT — reporting and interface tables keyed on TAX_LINE_ID.