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
- THRESHOLD_GRP_ID — surrogate primary key (JAI_AP_TDS_THHOLD_GRPS_PK) uniquely identifying each threshold group row. This is the join key referenced by all dependent tables.
- VENDOR_ID — foreign key to HZ_PARTIES, identifying the supplier whose threshold position is tracked. Along with ORG_TAN_NUM, VENDOR_PAN_NUM, SECTION_TYPE, SECTION_CODE, and FIN_YEAR, this forms the unique business key (JAI_AP_TDS_THHOLD_GRPS_UK1).
- ORG_TAN_NUM / VENDOR_PAN_NUM — the organization's Tax Deduction Account Number and the vendor's Permanent Account Number, both required for India statutory TDS reporting.
- SECTION_TYPE / SECTION_CODE — the TDS section category and its specific code (for example, 194C, 194J), which determine applicable rates, slabs, and threshold limits.
- FIN_YEAR — the financial year against which cumulative amounts are measured and reset.
- CURRENT_THRESHOLD_SLAB_ID — foreign key to JAI_AP_TDS_THHOLD_SLABS, indicating the slab the group currently sits in.
- TOTAL_INVOICE_AMOUNT, TOTAL_INVOICE_CANCEL_AMOUNT, TOTAL_INVOICE_APPLY_AMOUNT, TOTAL_INVOICE_UNAPPLY_AMOUNT — running totals that build the taxable base.
- TOTAL_TAX_PAID, TOTAL_CALC_TAX_PAID, TOTAL_THHOLD_CHANGE_TAX_PAID — cumulative TDS withheld, calculated, and slab-transition adjustments.
- REGIME_ID — foreign key to JAI_RGM_DEFINITIONS, tying the group to the applicable tax regime.
- OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit and optimistic locking columns.
- CUSTOMER_TYPE_LOOKUP_CODE and THRESHOLD_HDR_ID — classification lookup and reference to the threshold header definition.
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.
-
Stores the details current threshold position for a threshold group.
-
Stores the details current threshold position for a threshold group.
-
This table tracks the changes that happens to the table JAI_AP_TDS_THHOLD_GRPS.
-
This table tracks the changes that happens to the table JAI_AP_TDS_THHOLD_GRPS.
-
eTRM - JA Tables and Views 12.1.1
The 'JA_CN_SYSTEM_PARAMETERS_ALL' table stores information defined by 'System Options' form, 'Electronic Accounting Book Export' program will get most data from data in the table. A legal entity can only have one record in the table.
-
eTRM - JA Tables and Views 12.2.2
The 'JA_CN_VOUCHER_NUMBER' table stores the voucher number of GL journal lines.