Results for “customer_type_lookup_code”

18 results




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

Overview

JAI_AP_TDS_THHOLD_HDRS is a table owned by the JA schema within the Oracle E-Business Suite Asia/Pacific Localizations product family. It stores the header-level definition of withholding tax thresholds applicable to a Tax Deducted at Source (TDS) vendor or vendor type. In practical terms, it acts as the master (header) record that groups the rules governing when and how withholding tax is applied once cumulative transaction values cross configured limits.

The object is central to Indian and broader Asia/Pacific TDS configurations, where statute requires deductors to withhold tax only after a payee breaches a defined monetary threshold. Each row in this table represents one threshold setup, tied back to a tax regime definition via REGIME_ID. The metadata classifies this object as hub-leaning in a Data Vault heuristic. In modeling terms, it is best treated as a hub in a Data Vault design, with its dependent detail tables acting as satellites and links attached to the THRESHOLD_HDR_ID business key.

Key Information Stored

The table is documented with 16 physical columns. The most significant are listed below.

Common Use Cases and Queries

Typical reporting and configuration queries resolve a threshold setup together with its regime and dependent slabs, taxes, or exceptions. A common pattern joins the header to JAI_RGM_DEFINITIONS to display the regime name alongside the threshold:

  • Listing active threshold setups by regime and section for a given tax regime configuration.
  • Resolving the threshold header for a payee before determining whether withholding is triggered.
  • Auditing setups that are flagged as exceptions (EXCEPTION_SETUP_FLAG = 'Y') or that use multiple rates.
  • Reconciling the header against its detail tables to ensure completeness of slab and tax definitions.

Sample join:

SELECT h.THRESHOLD_SETUP_NAME, h.SECTION_CODE, r.REGIME_NAME
FROM JA.JAI_AP_TDS_THHOLD_HDRS h, JA.JAI_RGM_DEFINITIONS r
WHERE h.REGIME_ID = r.REGIME_ID;

Related Objects

This header is the parent of several dependent objects that reference THRESHOLD_HDR_ID. The most significant include: