Results for “taxable_box”

22 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:

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.