Search Results jai_ap_tds_thhold_hdrs




Overview
Explore in AI Chat

Overview

The table JAI_AP_TDS_THHOLD_HDRS is a core data object within the Oracle E-Business Suite Asia/Pacific Localizations module (JA). It functions as the master definition table for Tax Deducted at Source (TDS) thresholds. In the context of Indian localization, TDS thresholds represent the monetary limits below which tax is not required to be deducted from a payment made to a vendor. This table stores the header-level configuration that determines the applicability of these thresholds based on specific vendor types and tax regimes. Its primary role is to serve as a central reference point for the TDS calculation engine, enabling the system to determine whether a given invoice transaction is subject to TDS withholding based on predefined criteria.

Key Information Stored

While the provided metadata does not list individual column names, the structure and relationships define the key information stored. The primary identifier, THRESHOLD_HDR_ID, uniquely defines each threshold rule. A critical foreign key, REGIME_ID, links the threshold to a specific tax regime defined in JAI_RGM_DEFINITIONS, ensuring the rule is applied within the correct legislative framework. The table's description indicates it stores details applicable for a "TDS vendor vendor type," implying it likely contains columns to specify the vendor type or category to which the threshold rule applies. Collectively, a record in this header table establishes a rule set that is further detailed through its related child tables, defining slabs, tax types, exceptions, and transaction applicability.

Common Use Cases and Queries

The primary use case is the automated evaluation of TDS applicability during invoice validation and payment processing. The system queries this table, joined with its related detail tables, to find a matching threshold rule for the invoice's vendor type, regime, and transaction characteristics. Common reporting and audit queries involve listing all configured threshold rules or investigating specific TDS calculations. A sample SQL pattern to retrieve active threshold headers with their associated regime code would be:

SELECT hdr.threshold_hdr_id, rgm.regime_code, hdr.vendor_type
FROM jai_ap_tds_thhold_hdrs hdr,
     jai_rgm_definitions rgm
WHERE hdr.regime_id = rgm.regime_id
AND SYSDATE BETWEEN hdr.start_date AND NVL(hdr.end_date, SYSDATE);

Another critical query joins the header to its detail slabs (JAI_AP_TDS_THHOLD_SLABS) to analyze the financial ranges defined for the threshold.

Related Objects

JAI_AP_TDS_THHOLD_HDRS is a central node in the TDS threshold data model, with defined relationships to one parent and six child tables.

  • Parent Reference: It references JAI_RGM_DEFINITIONS via REGIME_ID to inherit the governing tax regime.
  • Child Dependencies (Referencing this table via THRESHOLD_HDR_ID):

This relational structure allows a single header definition to govern a comprehensive and detailed set of TDS withholding conditions.