Search Results je_be_vat_allocations

Overview

The JE_BE_VAT_ALLOCATIONS table is a transaction-level staging and audit object within the Oracle E-Business Suite JE — European Localizations product, owned by the GL schema. It records individual source transactions that have been allocated to Belgian VAT reporting boxes, forming the bridge between subledger or general ledger activity and the statutory VAT declaration output. Each row represents one allocation event — the assignment of a specific transaction line amount to a designated VAT report box for a given reporting declaration.

From a dimensional modeling perspective, the mined Data Vault classification for this object is standalone. This heuristic suggests the table behaves chiefly as a descriptive satellite attached to declaration and transaction hubs, rather than acting as a pure hub or link. Because the only documented foreign key points to PAY_TRIGGER_DECLARATIONS, the table is best modeled as a detail satellite that carries measurable amounts and classification attributes tied to both a declaration and a source transaction.

Key Information Stored

The table contains 13 documented columns. The most significant are summarized below, distinguishing the surrogate primary key from the business-key candidate.

• ALLOCATION_ID — The surrogate primary key, enforced by JE_BE_VAT_ALLOCATIONS_PK. A unique index JE_BE_VAT_ALLOCATIONS_U1 is also documented on this column, making it the business-key candidate as well as the technical row identifier.
• DECLARATION_ID — Foreign key referencing PAY_TRIGGER_DECLARATIONS; identifies the VAT declaration to which the allocation belongs.
• SET_OF_BOOKS_ID — The ledger context for the transaction, essential for multi-organization and multi-ledger reporting.
• TRANS_ID and TRANS_LINE_ID — Pointers to the originating transaction header and line, preserving drill-back capability.
• OF_TRANS_TYPE and VAT_TRANS_TYPE — Classify the originating transaction and the resulting VAT transaction type for box assignment logic.
• LINE_TYPE — Describes the nature of the line (e.g., base, tax, adjustment) driving allocation behavior.
• TAX_NAME — The tax or tax regime name associated with the transaction.
• AMOUNT — The allocated monetary value assigned to the report box.
• TRANS_DATE — The accounting or transaction date governing the reporting period.
• VAT_REPORT_BOX — The target Belgian VAT reporting box to which the amount is allocated; the central business attribute of the table.
• SOURCE — Indicates the origin system or module of the recorded transaction.

Common Use Cases and Queries

Typical usage centers on VAT reporting reconciliation, box-level analysis, and audit traceability. A common query retrieves all allocations for a specific declaration and boxes:

• Summarizing amounts by VAT_REPORT_BOX for a declaration: SELECT VAT_REPORT_BOX, SUM(AMOUNT) FROM GL.JE_BE_VAT_ALLOCATIONS WHERE DECLARATION_ID = :id GROUP BY VAT_REPORT_BOX;
• Drilling from a declaration to source transactions using TRANS_ID and TRANS_LINE_ID.
• Reconciling ledger activity by SET_OF_BOOKS_ID and TRANS_DATE against declared box totals.
• Auditing allocation completeness by comparing transaction populations against SOURCE and OF_TRANS_TYPE.

Related Objects

• PAY_TRIGGER_DECLARATIONS — Parent reference via DECLARATION_ID; defines the declaration to which allocations belong.
• JE_BE_VAT_ALLOCATIONS_PK / JE_BE_VAT_ALLOCATIONS_U1 — Primary key and unique index on ALLOCATION_ID.
• Source transaction tables referenced conceptually through TRANS_ID and TRANS_LINE_ID, enabling drill-back to origin detail.
• Belgian VAT reporting and declaration extraction programs that consume this table to populate statutory boxes.

Because the documented schema is relatively compact and its only hard FK is to the declaration table, integrity and reporting accuracy depend heavily on disciplined population of the transaction pointers and box assignments.