Results for “excise_invoice_date”

50+ results




Overview
Explore in AI Chat

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

Overview

The JAI_CMN_RG_23AC_II_TRXS table is a core transactional data object within the JA – Asia/Pacific Localizations product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores RG23A and RG23C Part II details, commonly referred to as the Amount Register, which records the monetary implications of excise movements for goods held in a manufacturing or trading location under the Indian excise regime. The table resides in the JA schema and is classified as VALID in the ETRM inventory. Its primary purpose is to capture debit and credit amounts for basic excise duty, additional excise duty, additional CVD, and other tax components, cross-referenced to the Part I quantity register. Under a heuristic Data Vault classification, the table is satellite-leaning: it is dense with descriptive and measure attributes, is keyed by a surrogate primary key, and is surrounded by foreign key relationships to configuration, party, accounting, and balance hubs.

Key Information Stored

The table is uniquely identified by the surrogate primary key REGISTER_ID, enforced by JAI_CMN_RG_23AC_II_TRXS_PK. This column is a system-generated identifier and serves as the technical unique index; it is not a natural business key of the underlying excise transaction.

Common Use Cases and Queries

Typical reporting uses include reconstructing the excise amount register for audit, reconciling open and closing balances by financial year, and tracing a Part II amount back to its Part I quantity movement. A common query joins the amount register to the quantity register on REGISTER_ID_PART_I to reconcile quantity and value. Balance reconciliation queries aggregate CR_* and DR_* columns grouped by ORGANIZATION_ID, FIN_YEAR, and REGISTER_TYPE. Utilization reports filter on POSTED_FLAG and MASTER_FLAG to separate posted entries from provisional ones. Exceptions queries compare OPENING_BALANCE to the prior period's CLOSING_BALANCE and highlight mismatches.

Related Objects