Results for “current_threshold_slab_id”

32 results




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

Overview

JAI_AP_TDS_THHOLD_GRPS is a transaction and configuration table in the JA (Asia/Pacific Localizations) product, owned by the JA schema. It stores the current threshold position for a threshold group, which is the mechanism Oracle EBS uses to enforce Tax Deducted at Source (TDS) cumulative thresholds for a vendor across a financial year. Each row represents a single threshold group instance, tracking the aggregated invoice, cancellation, apply, unapply, and tax amounts accumulated against a vendor, organization TAN, and vendor PAN within a section, section code, and financial year. Downstream TDS calculation logic reads this row to determine whether the cumulative base has crossed the applicable slab boundary and which slab (via CURRENT_THRESHOLD_SLAB_ID) now governs further withholding.

From a Data Vault modeling perspective, the FK structure classifies this object as hub-leaning. It behaves principally as a hub for the threshold group business entity, carrying descriptive and mutable cumulative attributes that in a formal model would conventionally be split into a satellite keyed on THRESHOLD_GRP_ID. The accumulating amount columns are non-historical and are updated in place as transactions are processed.

Key Information Stored

Common Use Cases and Queries

Typical reporting includes current-year threshold status per vendor, projected slab transitions, and reconciliation of amounts withheld against invoice activity. A representative query retrieves threshold position for a given vendor and section:

  • SELECT g.threshold_grp_id, g.vendor_id, g.section_code, g.fin_year, g.total_invoice_amount, g.total_tax_paid, g.current_threshold_slab_id FROM ja.jai_ap_tds_thhold_grps g WHERE g.vendor_id = :vendor_id AND g.section_code = :section_code AND g.fin_year = :fin_year;
  • Join to JAI_AP_TDS_THHOLD_SLABS to display the current slab range and rate.
  • Aggregate across vendors to report total TDS liability by section for statutory returns.
  • Audit queries joining JAI_AP_TDS_THGRP_AUDITS for changes to threshold position over time.
  • Driver reconciliation joining JAI_AP_TDS_THHOLD_TRXS to confirm cumulative balances match transaction detail.

Related Objects

  • HZ_PARTIES — joined on JAI_AP_TDS_THHOLD_GRPS.VENDOR_ID to resolve supplier identity.
  • JAI_AP_TDS_THHOLD_SLABS — joined on CURRENT_THRESHOLD_SLAB_ID to resolve the active slab.
  • JAI_RGM_DEFINITIONS — joined on REGIME_ID to resolve the tax regime.
  • JAI_AP_TDS_THHOLD_TRXS — references THRESHOLD_GRP_ID; holds the transaction detail underlying the cumulative totals.
  • JAI_AP_TDS_THGRP_AUDITS — references THRESHOLD_GRP_ID; records audit history of threshold group changes.
  • JAI_AP_TDS_INV_TAXES — references THRESHOLD_GRP_ID and DEFAULT_THRESHOLD_GRP_ID; ties withholding lines to their threshold group.
  • JAI_AP_TDS_INV_CANCELS — references THRESHOLD_GRP_ID; cancellation entries affecting the threshold base.
  • JAI_AP_TDS_PREPAYMENTS — references THRESHOLD_GRP_ID via TDS_TAX_ID_PREPAY; prepayment adjustments to threshold position.