Results for “stform_type”

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

Overview

JAI_CMN_TAXES_ALL is the master reference table for Localization Taxes within the Oracle E-Business Suite Asia/Pacific Localizations (JA) product family. It is owned by the JA schema and is valid in EBS 12.1.1 and 12.2.2. The table serves as the central definition point for tax types used across the regional tax engines, including Withholding Tax (TDS), Value Added Tax (VAT), Service Tax, Cess, and related statutory levies applicable in Asia/Pacific countries.

The table stores the tax identifier, descriptive attributes, rate information, accounting references, and vendor-related attributes needed to calculate, apply, and account for localized taxes during transaction processing. It is referenced extensively by both Payables-side tables (TDS invoices, prepayments, threshold tax entries, ETDS records) and Receivables, Purchasing, Order Management, and Receiving tax line tables, indicating that it functions as a shared reference across multiple Oracle sub-ledgers.

The ETRM relationship classification for this object is hub-leaning. This is consistent with the fact that its primary key (TAX_ID) is referenced by a large number of foreign keys from dependent transactional tables. In a Data Vault model, this table would most naturally map to a hub entity for tax definitions, with dependent tax-line and invoice tables acting as links or satellites.

Key Information Stored

The table is documented with 57 physical columns. The most significant columns and their roles are listed below.

• TAX_ID — Surrogate primary key of the table (JAI_CMN_TAXES_ALL_PK). It is the value propagated to all dependent tax-line and TDS tables.
• TAX_NAME — Business-key candidate and part of the unique index JAI_CMN_TAXES_ALL_UK1. This is the user-facing name of the tax definition and is usually the primary navigation key for end users.
• TAX_DESCR — Descriptive text providing additional detail about the tax.
• TAX_TYPE and TAX_TYPE_ID — Classification of the tax (for example, VAT, TDS, Cess, Service Tax) and its internal type identifier.
• TAX_RATE — Numeric rate applied to the taxable base when the tax is calculated.
• TAX_AMOUNT — Fixed monetary tax amount, used where the tax is defined as a flat amount rather than a percentage.
• TAX_ACCOUNT_ID — Foreign key to GL_CODE_COMBINATIONS, defining the accounting flexfield code combination used when tax is posted to the General Ledger.
• VENDOR_ID and VENDOR_SITE_ID — Foreign keys to HZ_PARTIES and HZ_PARTY_SITES respectively, used where the tax is associated with a tax authority or vendor site.
• START_DATE and END_DATE — Effective dating for the tax definition.
• ORG_ID — Multi-org operating unit context for the tax definition.
• INCLUSIVE_TAX_FLAG, VAT_FLAG, REVERSE_CHARGE_FLAG — Flags controlling whether tax is treated as inclusive, as VAT, or under a reverse-charge mechanism.
• TDS_SECTION, SECTION_TYPE, SECTION_CODE — Statutory section references used in withholding and TDS reporting.
• CESS_RATE, SH_CESS_RATE, SURCHARGE_RATE — Additional levy rates used for Cess, secondary Cess, and surcharge calculations.
• ATTRIBUTE1 through ATTRIBUTE15 and ATTRIBUTE_CATEGORY — Descriptive flexfield columns for user-defined extensions.
• OBJECT_VERSION_NUMBER, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY — Standard EBS audit columns.

Common Use Cases and Queries

Typical use cases for JAI_CMN_TAXES_ALL include tax setup verification, TDS rate validation, VAT configuration reporting, and reconciliation of tax amounts posted to the General Ledger. Because TAX_ID is referenced broadly, this table is often the anchor for joining tax definitions to their downstream applications.

• Listing all active VAT tax definitions for an operating unit: SELECT tax_id, tax_name, tax_rate FROM jai_cmn_taxes_all WHERE vat_flag = 'Y' AND org_id = :org_id AND sysdate BETWEEN start_date AND NVL(end_date, sysdate);
• Retrieving the GL account tied to a tax for accounting reports: SELECT t.tax_name, gcc.concatenated_segments FROM jai_cmn_taxes_all t, gl_code_combinations_kfv gcc WHERE t.tax_account_id = gcc.code_combination_id;
• Reviewing TDS tax definitions by statutory section: SELECT tax_name, tds_section, section_code, tax_rate FROM jai_cmn_taxes_all WHERE tax_type = 'TDS';
• Reconciling taxes applied on Payables invoices by joining to JAI_AP_TDS_INVOICES on TDS_TAX_ID.
• Reporting vendor-linked tax authorities by joining to HZ_PARTIES on VENDOR_ID.
• Identifying taxes with effective-dated expiry by filtering on END_DATE.

Related Objects

JAI_CMN_TAXES_ALL maintains foreign-key relationships to GL_CODE_COMBINATIONS (TAX_ACCOUNT_ID), HZ_PARTIES (VENDOR_ID), and HZ_PARTY_SITES (VENDOR_SITE_ID). It is itself referenced by a large set of dependent tables; the following are among the most significant for routine query and integration work.

• JAI_AP_TDS_INVOICES — Via TDS_TAX_ID; links withholding tax definitions to Payables invoices.
• JAI_AP_TDS_PREPAYMENTS — Via multiple FKs including TDS_TAX_ID_PREPAY, ESSI_TAX_ID_PREPAY, WCT_TAX_ID_PREPAY, and others; stores prepayment-level tax references.
• JAI_AP_TDS_INV_TAXES — Via ACTUAL_TAX_ID and DEFAULT_TAX_ID; records both applied and default tax identifiers on invoice tax lines.
• JAI_AR_TRX_TAX_LINES — Via TAX_ID; links tax definitions to Receivables transaction tax lines.
• JAI_PO_TAXES — Via TAX_ID; associates tax definitions with Purchasing documents.
• JAI_RCV_LINE_TAXES — Via TAX_ID; applies tax definitions to Receiving lines.
• JAI_OM_WSH_LINE_TAXES — Via TAX_ID; applies tax definitions to Order Management and shipping lines.
• JAI_CMN_DOCUMENT_TAXES and JAI_CMN_MATCH_TAXES — Via TAX_ID; common tax association tables used in document and matching flows.
• JAI_RGM_TAXES and JAI_RETRO_TAX_CHANGES — Via TAX_ID; used in return goods management and retroactive tax adjustment processing.