Results for “jg_zz_vat_box_allocs”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The JG_ZZ_VAT_BOX_ALLOCS table resides in the JG schema, which supports Oracle E-Business Suite Regional Localizations for countries that mandate country-specific VAT reporting. Its documented purpose is to store VAT box allocation information, splitting tax and taxable amounts across reporting boxes by period type. In practice, this table records the outcome of applying allocation rules to individual VAT transactions so that the corresponding tax and taxable amounts can be reported within the correct statutory boxes on a periodic VAT return.
The table operates as a link between three principal entities: the VAT transaction detail record, the allocation rule that governs the split, and the concurrent request that generated the allocation. Under a Data Vault modeling heuristic, the metadata classifies JG_ZZ_VAT_BOX_ALLOCS as a link, since it resolves relationships between distinct business keys rather than acting as a standalone hub or descriptive satellite. This classification is a modeling suggestion derived from the foreign key structure, not a physical implementation constraint.
Key Information Stored
The table is documented with 17 columns. The most significant are:
- VAT_BOX_ALLOCATION_ID — the surrogate primary key, enforced by the unique index JG_ZZ_VAT_BOX_ALLOCS_PK.
- VAT_TRANSACTION_ID — foreign key to JG_ZZ_VAT_TRX_DETAILS, linking the allocation to the underlying VAT transaction line.
- ALLOCATION_RULE_ID — foreign key to JG_ZZ_VAT_ALLOC_RULES, identifying the rule that determined the box split.
- PERIOD_TYPE — the period classification under which the allocation applies.
- TAX_RECOVERABLE_FLAG — indicates whether the tax amount is recoverable.
- TAX_BOX — the reporting box to which the tax amount is allocated.
- TAXABLE_BOX — the reporting box to which the taxable amount is allocated.
- REQUEST_ID — foreign key to FND_CONCURRENT_REQUESTS, identifying the concurrent program run that produced the row.
- PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, PROGRAM_LOGIN_ID — concurrent program context columns.
- CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns.
Two unique indexes are documented. JG_ZZ_VAT_BOX_ALLOCS_U1 covers VAT_BOX_ALLOCATION_ID, confirming it as the surrogate key. JG_ZZ_VAT_BOX_ALLOCS_U2 covers the combination of VAT_TRANSACTION_ID and ALLOCATION_RULE_ID, which represents the documented business-key candidate: a single transaction may not be allocated more than once by the same rule.
Common Use Cases and Queries
The primary use case is VAT return preparation, where allocated tax and taxable amounts are aggregated into statutory boxes. A typical reporting query joins the allocation to the transaction detail and groups by box:
- Summing TAX_BOX and TAXABLE_BOX amounts for a given period and period type.
- Reconciling allocations back to their source concurrent request to confirm completeness of a run.
- Tracing which ALLOCATION_RULE_ID produced a particular box assignment, useful when auditing rule changes.
- Filtering on TAX_RECOVERABLE_FLAG to separate recoverable from non-recoverable tax.
A representative pattern joins JG_ZZ_VAT_BOX_ALLOCS to JG_ZZ_VAT_TRX_DETAILS on VAT_TRANSACTION_ID and to JG_ZZ_VAT_ALLOC_RULES on ALLOCATION_RULE_ID, restricting by PERIOD_TYPE and REQUEST_ID.
Related Objects
- JG_ZZ_VAT_TRX_DETAILS — referenced via VAT_TRANSACTION_ID; the source VAT transaction detail.
- JG_ZZ_VAT_ALLOC_RULES — referenced via ALLOCATION_RULE_ID; defines the allocation logic.
- FND_CONCURRENT_REQUESTS — referenced via REQUEST_ID; the concurrent request that generated the rows.
- FND_CONCURRENT_PROGRAMS — joins through PROGRAM_APPLICATION_ID and PROGRAM_ID for program identification.
- JG_ZZ_VAT_BOXES and related JG VAT reporting objects — consume the box assignments for return output.
-
Stores VAT box allocation information for tax and taxable amounts by period type
-
Stores VAT box allocation information for tax and taxable amounts by period type
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 FND Design Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
eTRM - JG Tables and Views 12.2.2
Additional country-specific information for vendor sites