Results for “from_amount”

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

Overview

JAI_AP_TDS_THHOLD_SLABS is a JA (Asia/Pacific Localizations) schema table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the individual slabs (band definitions) and the tax rate applicable within each slab for Withholding Tax (TDS) threshold configurations used by Payables and related localization flows. Each row represents one slab under a threshold definition, capturing the lower and upper monetary boundaries and the tax rate applied to amounts falling inside that band. This object is the granular component of the withholding threshold model: while the parent header defines the overall threshold rule, the slabs define the tiered rate structure that drives computation.

The ETRM metadata classifies this object heuristically as hub-leaning in Data Vault terms. It carries a single-column surrogate primary key and a compact set of descriptive attributes anchored to parent references, making it suitable as a reference or dimension-like structure rather than a transactional fact.

Key Information Stored

The table contains 12 documented columns. The most significant are:

• THRESHOLD_SLAB_ID — Surrogate primary key (JAI_AP_TDS_THHOLD_SLABS_PK); uniquely identifies each slab row and is the unique index / business-key candidate referenced by all downstream foreign keys.
• THRESHOLD_HDR_ID — Foreign key to JAI_AP_TDS_THHOLD_HDRS; identifies the parent threshold definition to which this slab belongs.
• THRESHOLD_TYPE_ID — Foreign key to JAI_AP_TDS_THHOLD_TYPES; identifies the threshold type governing how the slab is interpreted and applied.
• FROM_AMOUNT — Lower boundary of the slab (inclusive threshold amount).
• TO_AMOUNT — Upper boundary of the slab; together with FROM_AMOUNT defines the band.
• TAX_RATE — The withholding tax rate applied to taxable amounts that fall within the slab’s band.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS WHO (audit) columns.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the EBS framework.

Common Use Cases and Queries

Slab data is read during withholding tax computation to resolve the applicable rate for a given taxable base, and during configuration and audit reporting to display the tier structure. Typical query patterns join the slab to its header and type, ordered by FROM_AMOUNT, to reconstruct the band ladder for a threshold definition:

• Rate lookup by amount: SELECT TAX_RATE FROM JAI_AP_TDS_THHOLD_SLABS WHERE THRESHOLD_HDR_ID = :hdr_id AND :amount BETWEEN FROM_AMOUNT AND TO_AMOUNT;
• Configuration report: Join JAI_AP_TDS_THHOLD_HDRS and JAI_AP_TDS_THHOLD_TYPES on the respective FKs to list all slabs, their boundaries, and rates per threshold definition.
• Referential integrity audit: Query JAI_AP_TDS_INV_TAXES or JAI_AP_TDS_THHOLD_TAXES against this table on THRESHOLD_SLAB_ID to detect orphaned or misconfigured assignments.
• Change tracking: Use CREATION_DATE and LAST_UPDATE_DATE to report slab changes over time for compliance evidence.

Related Objects

The table participates in a well-defined referential network. Parent references (this table references) are:

• JAI_AP_TDS_THHOLD_HDRS via THRESHOLD_HDR_ID.
• JAI_AP_TDS_THHOLD_TYPES via THRESHOLD_TYPE_ID.

Significant dependent objects (referencing this table) include:

• JAI_AP_TDS_INV_TAXES via THRESHOLD_SLAB_ID, THRESHOLD_SLAB_ID_SINGLE, DEFAULT_CUM_THRESHOLD_SLAB_ID, and DEFAULT_SIN_THRESHOLD_SLAB_ID.
• JAI_AP_TDS_THHOLD_TAXES via THRESHOLD_SLAB_ID.
• JAI_AP_TDS_THHOLD_GRPS via CURRENT_THRESHOLD_SLAB_ID.
• JAI_AP_TDS_THGRP_AUDITS via TRX_THRESHOLD_SLAB_ID, NEW_THRESHOLD_SLAB_ID, and OLD_THRESHOLD_SLAB_ID.
• JAI_RGM_THRESHOLDS via THRESHOLD_SLAB_ID.
• JAI_RGM_REFS_ALL via THRESHOLD_SLAB_ID.

Because THRESHOLD_SLAB_ID is referenced by eleven foreign-key relationships, deletion or renumbering of slab rows has broad impact across withholding tax setup, threshold group assignment, and audit history. DML should therefore be performed through the supported localization forms or concurrent programs rather than direct SQL.