Search Results jai_cmn_document_taxes




Overview
Explore in AI Chat

Overview

JAI_CMN_DOCUMENT_TAXES is a transactional table owned by the JA schema within the Asia/Pacific Localizations product (JA). It stores the individual tax lines associated with a wide range of India Localization transactions, including payables invoices, receivables transactions, and cash receipts. Each row represents one tax component applied to a source document line, capturing both the tax definition (type, rate, category) and the calculated result (tax amount in entered and functional currency). The table therefore acts as the central audit and reporting repository for India-specific tax computation across multiple EBS sub-ledgers.

From a Data Vault modeling perspective, the metadata heuristic classifies JAI_CMN_DOCUMENT_TAXES as a link table. This is consistent with its structure: it sits at the intersection of independent business entities — tax definitions, tax categories, source documents, and trading partners — and records the association (and monetary outcome) of those relationships at a point in time. It is not a pure hub, since it carries no natural business key of its own beyond the surrogate DOC_TAX_ID, nor a pure satellite, since it references multiple parent hubs.

Key Information Stored

The table contains 36 documented columns. The most operationally significant are listed below; the remainder are primarily audit, precedence, and versioning fields.

  • DOC_TAX_ID — Surrogate primary key, generated by sequence and enforced by the unique index JAI_CMN_DOCUMENT_TAXES_U1. This is the only documented unique business-key candidate; there is no separate natural key.
  • TAX_ID — Foreign key to JAI_CMN_TAXES_ALL, identifying the tax definition applied.
  • TAX_CATEGORY_ID — Foreign key to JAI_CMN_TAX_CTGS_ALL, indicating the tax category (for example, excise, VAT, CST, or service tax grouping).
  • TAX_TYPE — The classification of the tax component (e.g., rate-based, fixed, or percentage).
  • TAX_RATE and QTY_RATE — The applied percentage rate and the per-unit rate, with UOM qualifying the unit of measure for quantity-based taxes.
  • TAX_AMT and FUNC_TAX_AMT — The tax amount in the transaction (entered) currency and in the functional currency of the ledger.
  • CURRENCY_CODE — The currency in which TAX_AMT is expressed.
  • SOURCE_DOC_TYPE, SOURCE_DOC_ID, SOURCE_DOC_LINE_ID, and SOURCE_DOC_PARENT_LINE_NO — Identify the originating document and line. SOURCE_DOC_ID carries a foreign key to AR_CASH_RECEIPTS_ALL for cash receipt transactions.
  • SOURCE_TABLE_NAME — Records the base table from which the source document originates, allowing polymorphic document tracing.
  • VENDOR_ID — Foreign key to HZ_PARTIES, identifying the supplier or party on the transaction.
  • TAX_LINE_NO — The sequencing of tax lines within a document.
  • MODVAT_FLAG and ADHOC_FLAG — Indicators for MODVAT-eligible taxes and for taxes applied ad hoc outside standard setup.
  • PRECEDENCE_1 through PRECEDENCE_10 — Ordered tax precedence values controlling the sequence in which taxes are computed and compounded.
  • TAX_MODIFIED_BY — Records whether and by whom a computed tax was manually overridden.

Common Use Cases and Queries

Typical usage centers on tax reconciliation and statutory reporting. A common query joins tax lines to the tax master to produce a tax-wise summary for a document range:

SELECT dt.SOURCE_DOC_TYPE, dt.SOURCE_DOC_ID, t.TAX_NAME, dt.TAX_RATE, dt.TAX_AMT, dt.FUNC_TAX_AMT FROM JA.JAI_CMN_DOCUMENT_TAXES dt, JA.JAI_CMN_TAXES_ALL t WHERE dt.TAX_ID = t.TAX_ID AND dt.SOURCE_DOC_ID = :doc_id;

Other frequent scenarios include: reconciling functional versus entered tax amounts for exchange-rate variance analysis; aggregating MODVAT_FLAG = 'Y' rows for input-credit claims; tracing a cash receipt's taxes through the SOURCE_DOC_ID foreign key to AR_CASH_RECEIPTS_ALL; and extracting vendor-wise tax accumulations by joining VENDOR_ID to HZ_PARTIES for supplier tax certificates. Ad hoc tax audits rely on ADHOC_FLAG and TAX_MODIFIED_BY to isolate manually adjusted lines.

Related Objects

  • JAI_CMN_TAXES_ALL — Joined via TAX_ID; supplies the tax name, type, and default rate.
  • JAI_CMN_TAX_CTGS_ALL — Joined via TAX_CATEGORY_ID; defines the tax category grouping.
  • AR_CASH_RECEIPTS_ALL — Joined via SOURCE_DOC_ID; the source receipt document for cash receipt tax lines.
  • HZ_PARTIES — Joined via VENDOR_ID; provides party, supplier, or customer details.
  • JAI_CMN_DOCUMENT_TAXES_PK / JAI_CMN_DOCUMENT_TAXES_U1 — The primary key constraint and its backing unique index on DOC_TAX_ID.
  • JAI_CMN_DOC_TAXES_TRG / associated India Localization APIs — Programmatic interfaces that populate and maintain document tax lines during transaction processing.