Results for “displayed_flag”

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

Overview

AR_VAT_TAX_ALL_B is the Receivables (AR) base table that stores the VAT and tax code definitions maintained through the Tax Codes and Rates window in Oracle E-Business Suite 12.1.1 and 12.2.2. It is the authoritative repository for tax codes that drive tax calculation, validation, and posting on Receivables transactions, and it is referenced across a wide range of AR, Projects (PA), and E-Business Tax (ZX) objects.

From a Data Vault modeling perspective, AR_VAT_TAX_ALL_B behaves as a hub. Its primary key — AR_VAT_TAX_ALL_B_PK on (TAX_CODE, START_DATE) — provides the business key identity for a tax code, while a unique index AR_VAT_TAX_ALL_B_U1 on VAT_TAX_ID exposes the surrogate identifier used by downstream foreign keys. The table carries a substantial descriptive payload of attributes and global attributes, but it also supplies the stable tax-code key consumed by referencing tables, which is characteristic of hub behavior.

Key Information Stored

The most operationally significant columns in this table are:

• VAT_TAX_ID — surrogate identifier; the target of the U1 unique index and the dominant foreign-key link pointed at by other tables.
• TAX_CODE — the user-facing tax code defined in the Tax Codes and Rates window; part of the composite primary key.
• START_DATE — effective start date of the tax code definition; part of the composite primary key.
• END_DATE — effective end date controlling validity of the tax code record.
• TAX_RATE and TAX_TYPE — the rate and classification applied during tax calculation.
• TAX_ACCOUNT_ID — references GL_CODE_COMBINATIONS and identifies the accounting flexfield used for tax posting.
• SET_OF_BOOKS_ID — references GL_SETS_OF_BOOKS_11I, tying the tax code to a specific ledger.
• ORG_ID — operating unit context for multi-org security.
• TAX_REGIME_CODE, TAX, and TAX_STATUS_CODE — attributes that bridge the legacy AR tax setup to E-Business Tax regime and tax status configuration.
• ENABLED_FLAG, DISPLAYED_FLAG, and VALIDATE_FLAG — status drivers controlling whether the tax code is active, visible, and validated on transactions.
• AMOUNT_INCLUDES_TAX_FLAG and TAXABLE_BASIS — determine whether amounts are tax-inclusive and how the taxable base is computed.
• TAX_CLASS and VAT_TRANSACTION_TYPE — refine the type of tax and the transaction category it applies to.
• TAX_CALCULATION_PLSQL_BLOCK — a stored logic reference used for custom or legacy tax computation.
• INTERIM_TAX_CCID, ADJ_CCID, EDISC_CCID, and related CCID columns — account identifiers used for interim tax and various non-recoverable tax postings.

Common Use Cases and Queries

A frequent requirement is reporting all enabled tax codes for a given ledger and operating unit, filtering on the effective date range. A representative query pattern is:

• Select TAX_CODE, TAX_RATE, TAX_TYPE, and ORG_ID from AR_VAT_TAX_ALL_B where ENABLED_FLAG = 'Y' and trunc(SYSDATE) between START_DATE and nvl(END_DATE, trunc(SYSDATE)).
• Resolve the GL account behind a tax code by joining TAX_ACCOUNT_ID to GL_CODE_COMBINATIONS.
• Convert a VAT_TAX_ID back to its TAX_CODE by joining on the U1 key, which is the most common lookup performed by E-Business Tax, Projects, and Receivables transaction queries.
• Investigate tax posting behavior by examining the ADJ_CCID, EDISC_CCID, UNEDISC_CCID, and FINCHRG_CCID columns alongside their NON_REC counterparts.

Because the table also exposes TAX_REGIME_CODE, TAX, and TAX_STATUS_CODE, reconciliation reports commonly compare AR tax code configuration to E-Business Tax setup for upgrade and localization verification.

Related Objects

The relationship graph is dense. The most significant referencing and referenced objects with their documented join columns are:

• RA_CUSTOMER_TRX_LINES_ALL — joins on VAT_TAX_ID; the primary transaction line reference.
• AR_CASH_RECEIPTS_ALL — joins on VAT_TAX_ID.
• AR_TAX_GROUP_CODES_ALL — joins on both TAX_GROUP_ID and TAX_CODE_ID.
• ZX_ID_TCC_MAPPING_ALL — joins on TAX_RATE_CODE_ID; the mapping object referenced in the originating search.
• ZX_LINES_DET_FACTORS — joins on HISTORICAL_TAX_CODE_ID.
• GL_CODE_COMBINATIONS — referenced via TAX_ACCOUNT_ID.
• GL_SETS_OF_BOOKS_11I — referenced via SET_OF_BOOKS_ID.
• PA_CUST_EVENT_RDL_ALL, PA_CUST_REV_DIST_LINES_ALL, and PA_DRAFT_INVOICE_DETAILS_ALL — all join on OUTPUT_VAT_TAX_ID.
• JL_BR_AR_TX_GROUP_ALL and JL_ZZ_AR_TX_GROUPS_ALL — join on GROUP_TAX_ID for Latin American localizations.

Together these relationships confirm AR_VAT_TAX_ALL_B as a central configuration hub whose VAT_TAX_ID propagates tax identity throughout Receivables, Projects, and E-Business Tax processing.