Search Results jai_ap_tds_thhold_taxes_uk1




Overview
Explore in AI Chat

Overview

The table JAI_AP_TDS_THHOLD_TAXES is a core data repository within the JA (Asia/Pacific Localizations) product of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It is specifically designed to support Tax Deducted at Source (TDS) functionality, which is a critical statutory requirement in several Asia/Pacific jurisdictions, most notably India. The table's primary role is to store the detailed mapping of specific tax codes to defined income slabs and threshold rules, configured on a per-operating-unit basis. It acts as the central junction table that links threshold header definitions, threshold types, slab rates, and the applicable tax codes from the system's master tax repository, thereby enabling the accurate calculation and withholding of TDS during invoice and payment processing.

Key Information Stored

The table stores the relationship between a TDS threshold configuration and the specific taxes to apply. Its key columns, as defined by its primary and unique keys, include the surrogate primary key THRESHOLD_TAX_ID. The unique constraint (JAI_AP_TDS_THHOLD_TAXES_UK1) enforces business rule integrity across the combination of THRESHOLD_HDR_ID (link to the main threshold rule), THRESHOLD_TYPE_ID (link to the threshold type, e.g., vendor-based), THRESHOLD_SLAB_ID (link to the specific income/amount slab), OPERATING_UNIT_ID (identifying the legal entity), TAX_ID (foreign key to the master tax definition in JAI_CMN_TAXES_ALL), and TAX_CATEGORY_ID (foreign key to the tax category in JAI_CMN_TAX_CTGS_ALL). This structure ensures that for a given operating unit's specific threshold rule and slab, the correct tax code and its category are definitively assigned.

Common Use Cases and Queries

This table is primarily accessed during the TDS calculation engine's runtime and for configuration reporting. A common operational query involves retrieving all applicable tax codes for a given vendor payment within a specific operating unit to perform withholding. A typical diagnostic or setup validation query would join to related header and slab tables to list the complete TDS rule setup.

  • Sample Query to List Configured TDS Tax Rules:
    SELECT hdr.THRESHOLD_NAME, slab.MIN_AMOUNT, slab.MAX_AMOUNT, tax.TAX_CODE, taxcat.CATEGORY_NAME
    FROM JAI_AP_TDS_THHOLD_TAXES tt
    JOIN JAI_AP_TDS_THHOLD_HDRS hdr ON tt.THRESHOLD_HDR_ID = hdr.THRESHOLD_HDR_ID
    JOIN JAI_AP_TDS_THHOLD_SLABS slab ON tt.THRESHOLD_SLAB_ID = slab.THRESHOLD_SLAB_ID
    JOIN JAI_CMN_TAXES_ALL tax ON tt.TAX_ID = tax.TAX_ID
    JOIN JAI_CMN_TAX_CTGS_ALL taxcat ON tt.TAX_CATEGORY_ID = taxcat.TAX_CATEGORY_ID
    WHERE tt.OPERATING_UNIT_ID = :org_id
    ORDER BY hdr.THRESHOLD_NAME, slab.MIN_AMOUNT;

Related Objects

JAI_AP_TDS_THHOLD_TAXES is a central node in the TDS configuration schema, with documented foreign key relationships to several key tables. These relationships are fundamental to maintaining data integrity and enabling joins for comprehensive reporting.

  • JAI_AP_TDS_THHOLD_HDRS: Links via THRESHOLD_HDR_ID to the master threshold rule definition.
  • JAI_AP_TDS_THHOLD_TYPES: Links via THRESHOLD_TYPE_ID to categorize the threshold rule (e.g., by vendor type, transaction type).
  • JAI_AP_TDS_THHOLD_SLABS: Links via THRESHOLD_SLAB_ID to the specific income or amount range slabs defined for the rule.
  • JAI_CMN_TAXES_ALL: Links via TAX_ID to the master table of all defined tax codes within the localization.
  • HR_ALL_ORGANIZATION_UNITS: Links via OPERATING_UNIT_ID to the EBS organization master, scoping the rule to a specific legal entity.
  • JAI_CMN_TAX_CTGS_ALL: Links via TAX_CATEGORY_ID to the tax category master, providing further classification for the tax code.