Results for “allow_exemptions_flag”

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

Overview

ZX_STATUS_B is the base table of the Oracle E-Business Tax (E-Business Tax / ZX) module that stores the definition of tax statuses for multiple configuration owners. Each row represents one tax status belonging to a specific tax and configuration owner, and it is the authoritative source from which transactional tax determination, reporting, and reconciliation logic draw status values. Because it is a base (_B) table, translated and descriptive attributes are held in the companion table ZX_STATUS_TL, while ZX_STATUS_B itself carries the operational and control columns that drive tax engine behavior.

The table serves as a foundational reference within the tax configuration model. Regime, tax, and status hierarchies are governed through it, and downstream transaction lines, distributions, and reporting extracts reference its primary key value. Its ETRM classification as hub-leaning is a modeling suggestion only: from a Data Vault perspective, the surrogate key and the surrounding foreign-key structure imply that ZX_STATUS_B behaves more like a hub, with descriptive and translatable attributes naturally belonging to satellite tables such as ZX_STATUS_TL.

Key Information Stored

The most significant columns fall into identification, business-key, and behavioral-control groups.

• TAX_STATUS_ID — Surrogate primary key, enforced by the unique index ZX_STATUS_B_PK and also by ZX_STATUS_B_U1. This value is the one propagated to transaction and distribution tables.
• TAX_STATUS_CODE, TAX, TAX_REGIME_CODE, CONTENT_OWNER_ID — The business-key combination forming unique index ZX_STATUS_B_U2. Together they define a status in the context of a tax regime, a tax, and a configuration owner.
• TAX_STATUS_CODE — The user-facing identifier of the tax status.
• EFFECTIVE_FROM, EFFECTIVE_TO — Date range within which the status definition is valid.
• DEFAULT_STATUS_FLAG, DEFAULT_FLG_EFFECTIVE_FROM, DEFAULT_FLG_EFFECTIVE_TO — Determine whether the status acts as the default and the period over which that default applies.
• ALLOW_RATE_OVERRIDE_FLAG, ALLOW_EXEMPTIONS_FLAG, ALLOW_EXCEPTIONS_FLAG, RULE_BASED_RATE_FLAG — Behavior flags that control what tax engine operations are permitted for the status.
• DEF_REC_SETTLEMENT_OPTION_CODE — Default recovery settlement option associated with the status.
• RECORD_TYPE_CODE — Distinguishes record handling characteristics of the row.
• CONTENT_OWNER_ID — Identifies the configuration owner and is a foreign key to ZX_PARTY_TAX_PROFILE.
• TAX_REGIME_CODE — Foreign key to ZX_REGIMES_B, tying the status to a regime.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the Oracle Applications framework.
• ATTRIBUTE1–ATTRIBUTE15, ATTRIBUTE_CATEGORY — Descriptive flexfield storage for client-specific extensions.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_LOGIN_ID.

Common Use Cases and Queries

Typical usage includes validating a status chosen on a transaction, listing active statuses by regime and tax, and resolving the default status for a configuration owner. Because transactional tables store TAX_STATUS_ID, joins to ZX_STATUS_B are the standard route to reach status codes and regime context.

• Retrieve all statuses for a regime and tax:
  SELECT s.tax_status_id, s.tax_status_code, s.tax, s.tax_regime_code
FROM zx_status_b s
WHERE s.tax_regime_code = :regime AND s.tax = :tax
AND TRUNC(SYSDATE) BETWEEN s.effective_from AND NVL(s.effective_to, TRUNC(SYSDATE));
• Resolve status descriptions for transaction lines using the translation table:
  SELECT l.tax_status_id, t.tax_status_name
FROM zx_lines l
JOIN zx_status_b b ON b.tax_status_id = l.tax_status_id
JOIN zx_status_tl t ON t.tax_status_id = b.tax_status_id
WHERE t.language = USERENV('LANG');
• Identify the default status per configuration owner:
  SELECT content_owner_id, tax_regime_code, tax, tax_status_code
FROM zx_status_b
WHERE default_status_flag = 'Y';

Related Objects

ZX_STATUS_B participates in a broad web of foreign-key relationships across tax configuration and transaction processing.

• ZX_STATUS_TL — Translation table joined on TAX_STATUS_ID; stores language-specific status names and descriptions.
• ZX_REGIMES_B — Referenced via TAX_REGIME_CODE.
• ZX_PARTY_TAX_PROFILE — Referenced via CONTENT_OWNER_ID to identify the configuration owner.
• ZX_LINES — Transaction tax lines referencing TAX_STATUS_ID and ORIG_TAX_STATUS_ID.
• ZX_REC_NREC_DIST — Recoverable and non-recoverable distributions keyed to TAX_STATUS_ID.
• ZX_REP_TRX_DETAIL_T and ZX_TRANSACTION_LINES — Reporting and transaction detail tables referencing the status.
• OKL_TAX_TRX_DETAILS and OKL_TAX_TRX_DETAILS_T — Lease management tax detail tables depending on the status.
• JG_ZZ_VAT_TRX_DETAILS — Regional VAT transaction detail table referencing TAX_STATUS_ID.
• ZX_DETAIL_TAX_LINES_GT and ZX_REC_NREC_DIST_GT — Global temporary tables used during tax processing and distribution recalculation.