Search Results jai_rgm_taxes




Overview
Explore in AI Chat

Overview

The JAI_RGM_TAXES table is a core data object within the Asia/Pacific Localizations (JA) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It functions as the primary repository for storing detailed tax information specifically for transactions subject to Tax Collected at Source (TCS). TCS is a critical statutory requirement in several jurisdictions, including India, where a seller must collect tax from a buyer at the point of sale and subsequently remit it to the government. This table is integral to the EBS localization, ensuring compliance with regional tax laws by persistently recording all TCS-related tax calculations and liabilities generated from business transactions such as sales orders and invoices.

Key Information Stored

The table's structure is designed to capture the essential elements of a TCS tax record. While the full column list is not detailed in the provided metadata, the documented primary and foreign keys reveal its critical components. The primary key, TAX_DET_ID, uniquely identifies each TCS tax detail record. The table maintains a fundamental relationship with the transaction header via the TRX_REF_ID column, which is a foreign key to JAI_RGM_REFS_ALL. This links the tax detail to its source transaction. Furthermore, the TAX_ID column is a foreign key to JAI_CMN_TAXES_ALL, associating the record with the specific TCS tax rate and rules defined in the system's master tax setup. Typical data stored would include the calculated TCS amount, the applicable tax rate base, the transaction line identifier, and the associated invoice or order reference.

Common Use Cases and Queries

The primary use case for JAI_RGM_TAXES is the generation of statutory TCS reports and the reconciliation of collected tax amounts. Finance and tax teams query this table to audit TCS liabilities, prepare periodic filings, and ensure accurate remittance to tax authorities. A common reporting pattern involves joining this table to its parent transaction and tax master tables. For example, to analyze TCS applied to invoices within a specific period, a query might join JAI_RGM_TAXES to JAI_RGM_REFS_ALL on TRX_REF_ID and to JAI_CMN_TAXES_ALL on TAX_ID to retrieve the tax name and rate. Data from this table is also critical for the generation of TCS certificates (Form 27D) that must be issued to the buyers from whom the tax was collected.

Related Objects

  • JAI_RGM_REFS_ALL: This is the primary parent table, linked via the foreign key JAI_RGM_TAXES.TRX_REF_ID. It stores the reference information for the underlying transaction (e.g., invoice, receipt) for which the TCS tax is calculated.
  • JAI_CMN_TAXES_ALL: This master table, linked via JAI_RGM_TAXES.TAX_ID, defines the tax regime, tax, and tax rate applicable for the TCS calculation. It provides the governing rules for the tax detail recorded.
  • JAI_RGM_TAXES_PK: The primary key constraint on the TAX_DET_ID column, ensuring the uniqueness of each TCS tax record.