Results for “tax_group_record_id”

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

Overview

The JL_ZZ_AR_TX_GROUPS_ALL table is a Latin America Localizations (JL) object that stores Latin tax group information. It is owned by the JL schema and resides primarily in the E-Business Tax (formerly Oracle Financials for Latin America) architecture supporting tax determination for the Oracle Receivables (AR) application. Each row defines a tax group configuration — an association of contributing taxes, tax categories, establishment types, contributor types, and transaction natures — that determines how compound or group taxes are calculated for a given transaction scenario.

The object carries ORG_ID and is therefore an Operating Unit–partitioned (multi-org) table. It also includes the standard ATTRIBUTE1–ATTRIBUTE15 descriptive flexfield columns, START_DATE_ACTIVE/END_DATE_ACTIVE date-effective controls, and WHO audit columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN). Under the heuristic Data Vault classification mined from the foreign-key structure, this table is satellite-leaning, suggesting it is best modeled as a descriptive satellite attached to a parent tax hub rather than as an independent transaction hub or link.

Key Information Stored

The surrogate primary key is JL_ZZ_AR_TX_GROUPS_ALL_PK, defined over END_DATE_ACTIVE, TRANSACTION_NATURE, CONTRIBUTOR_TYPE, ESTABLISHMENT_TYPE, TAX_CATEGORY_ID, and GROUP_TAX_ID. A complementary unique index, JL_ZZ_AR_TX_GROUPS_U1, spans GROUP_TAX_ID, CONTRIBUTOR_TYPE, ESTABLISHMENT_TYPE, TRANSACTION_NATURE, TAX_CATEGORY_ID, END_DATE_ACTIVE, and ORG_ID, making it the stronger business-key candidate because it includes the multi-org partition column.

The most important columns include:

• TAX_GROUP_RECORD_ID — internal record identifier.
• GROUP_TAX_ID — foreign key to AR_VAT_TAX_ALL_B, identifying the grouping tax definition.
• TAX_CATEGORY_ID and TAX_CATEGORY_TO_REDUCE_ID — tax category and the category eligible for reduction.
• ESTABLISHMENT_TYPE — establishment classification driving applicability.
• CONTRIBUTOR_TYPE — the tax contributor (vendor, customer, etc.).
• TRANSACTION_NATURE — nature of the transaction the group applies to.
• COMPOUND_PRECEDENCE — ordering used when compound taxes are computed.
• MIN_AMOUNT, MIN_TAXABLE_BASIS, MIN_PERCENTAGE — thresholds for application.
• BASE_RATE — rate applied at the group level.
• USE_TX_CATEG_THRESHOLDS, TAX_INCLUSIVE, TRIBUTARY_SUBSTITUTION, USED_TO_REDUCE, CALCULATE_IN_OE — calculation flags and behaviors.
• TAX_CODE, START_DATE_ACTIVE, END_DATE_ACTIVE, ORG_ID — code designation, effective dating, and Operating Unit.

Common Use Cases and Queries

This table is typically queried to resolve which contributing taxes belong to a grouping tax, and how those contributors should be calculated. A representative join to the tax definition is:

• SELECT g.GROUP_TAX_ID, g.TAX_CATEGORY_ID, g.CONTRIBUTOR_TYPE, g.COMPOUND_PRECEDENCE, g.BASE_RATE, g.TAX_INCLUSIVE, g.ORG_ID FROM JL.JL_ZZ_AR_TX_GROUPS_ALL g, AR_VAT_TAX_ALL_B t WHERE g.GROUP_TAX_ID = t.TAX_ID AND g.TRX_DATE BETWEEN g.START_DATE_ACTIVE AND NVL(g.END_DATE_ACTIVE, SYSDATE+1);

Typical reporting scenarios include reconciling Latin American group tax configurations, auditing effective-dated changes to compound tax precedence, validating threshold setups against statutory requirements, and diagnosing tax calculation discrepancies by contributor and establishment type.

Related Objects

• AR_VAT_TAX_ALL_B — joined via JL_ZZ_AR_TX_GROUPS_ALL.GROUP_TAX_ID = AR_VAT_TAX_ALL_B.TAX_ID; primary parent definition of the grouping tax.
• AR_VAT_TAX_ALL_TL — translated name/description of the tax referenced by GROUP_TAX_ID.
• ZX_TAXES_B / ZX_TAXES_VL — E-Business Tax representations of contributing taxes.
• JL_ZZ_AR_TX_CATEGORIES — tax category definitions referenced by TAX_CATEGORY_ID.
• JL_ZZ_AR_TX_RULES — group tax calculation rules that consume the precedence and threshold columns.
• JL_ZZ_SYS_TAX_TYPES — supporting localization tax type setup.