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.
THRESHOLD_HDR_ID— The surrogate primary key, enforced byJAI_AP_TDS_THHOLD_HDRS_PK. It is the single unique index and the column all child tables join on.THRESHOLD_SETUP_NAMEandDESCRIPTION— The user-facing identifier and descriptive text for the threshold configuration.REGIME_ID— Foreign key toJAI_RGM_DEFINITIONS, linking the threshold to the applicable tax regime.SECTION_TYPEandSECTION_CODE— The statutory TDS section classification the threshold applies under.VENDOR_TYPE_LOOKUP_CODE— Distinguishes the vendor category (for example, company, individual) for which the threshold is defined.CUSTOMER_TYPE_LOOKUP_CODE— Parallel classification on the customer side where applicable.EXCEPTION_SETUP_FLAG— Indicates whether the setup represents an exception to a standard rule.MULTIPLE_RATE_SETUP— Signals that more than one rate applies to the threshold.OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN— Standard Oracle EBS WHO columns supporting concurrency control and auditability.
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:
JAI_RGM_DEFINITIONS— referenced viaREGIME_ID; the parent regimen definition.JAI_AP_TDS_THHOLD_SLABS— holds threshold slab bands.JAI_AP_TDS_THHOLD_TAXES— holds the tax/rate details for the threshold.JAI_AP_TDS_THHOLD_TYPESandJAI_AP_TDS_THHOLD_GRPS— vendor type and grouping associations.JAI_AP_TDS_THHOLD_XCEPSandJAI_AP_TDS_THHOLD_ACCOUNT— exception and accounting setups.JAI_AP_TDS_THHOLD_TRXS— transaction-level linkage.JAI_AP_TDS_INV_TAXESandJAI_AP_TDS_REPOSITORY— invoice tax and repository references.
-
Stores details of threshold applicable for a TDS vendor vendor type.
-
Stores details of threshold applicable for a TDS vendor vendor type.
-
Stores the details current threshold position for a threshold group.
-
Stores the details current threshold position for a threshold group.
-
APPS.JERX_TO SQL Statements 12.1.1
-
APPS.JERX_TO SQL Statements 12.2.2
-
PACKAGE BODY: APPS.JERX_TO 12.1.1
-
PACKAGE BODY: APPS.JERX_TO 12.2.2
-
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.