Results for “ward_no”

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

Overview

JAI_AP_TDS_VENDOR_HDRS is a table owned by the JA schema (Asia/Pacific Localizations) within Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. It stores Tax Deducted at Source (TDS) information at the vendor and vendor-site level, capturing the default TDS section and the default tax applicable to a supplier. In the Indian localization context, this table functions as the vendor-facing configuration point that drives withholding-tax determination during Payables invoice entry, payment processing, and TDS reporting.

From a heuristic Data Vault modeling perspective, the FK topology suggests this object behaves as a link table. Its primary key combines VENDOR_ID and VENDOR_SITE_ID, placing it at the intersection of party and party-site references while it also carries descriptive attributes and points to JAI_CMN_TAXES_ALL. The minimal hub-like behavior, combined with dependency on HZ_PARTIES and HZ_PARTY_SITES, supports treating it as a relationship/link construct rather than a standalone hub or pure satellite.

Key Information Stored

The table contains 17 documented columns. The primary key, JAI_AP_TDS_VENDOR_HDRS_PK, is defined on (VENDOR_ID, VENDOR_SITE_ID), establishing the composite business-key candidate unique to each vendor-site combination.

• VENDOR_ID — References HZ_PARTIES; identifies the supplier party for whom TDS defaults are configured.
• VENDOR_SITE_ID — References HZ_PARTY_SITES; scopes the TDS configuration to a specific supplier site.
• TAX_ID — References JAI_CMN_TAXES_ALL; the default withholding tax linked to the vendor site.
• SECTION_TYPE — Classifies the TDS section type applicable to the vendor.
• SECTION_CODE — The TDS section code (e.g., income-tax section) applied by default.
• PAN_NO — Permanent Account Number of the vendor, used for statutory TDS reporting.
• TAN_NO — Tax Deduction and Collection Account Number associated with the deduction context.
• WARD_NO — Ward or circle reference used in Indian tax administration.
• CONFIRM_PAN_FLAG — Indicates whether the vendor PAN has been verified or confirmed.
• TDS_VENDOR_TYPE_LOOKUP_CODE — Lookup-driven classification of the vendor for TDS purposes.
• TDS_VENDOR_CLASSIFICATION — Additional categorization of the vendor under TDS rules.
• OBJECT_VERSION_NUMBER — Optimistic locking column supporting concurrent updates.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns tracking record provenance.

Common Use Cases and Queries

Typical applications include verifying a vendor's default TDS section and tax before invoice validation, reconciling PAN/TAN details against statutory filings, and reporting withholding defaults across supplier sites. A common query joins the header to party and tax tables:

• SELECT h.vendor_id, h.vendor_site_id, h.section_code, t.tax_name FROM ja.jai_ap_tds_vendor_hdrs h, ja.jai_cmn_taxes_all t WHERE h.tax_id = t.tax_id AND h.vendor_id = :vendor_id;
• Retrieve PAN/TAN and confirmation status for compliance extracts: SELECT pan_no, tan_no, confirm_pan_flag FROM ja.jai_ap_tds_vendor_hdrs WHERE vendor_id = :p_vendor_id.
• Audit recently changed configurations using LAST_UPDATE_DATE and LAST_UPDATED_BY.

Related Objects

• HZ_PARTIES — Joined on VENDOR_ID; supplier master.
• HZ_PARTY_SITES — Joined on VENDOR_SITE_ID; supplier site master.
• JAI_CMN_TAXES_ALL — Joined on TAX_ID; defines default TDS tax.
• JAI_AP_TDS_VENDOR_LINES / related JA TDS tables — Detail-level TDS configuration held against the header.
• AP_SUPPLIERS / AP_SUPPLIER_SITES_ALL — Supplier and site entities indirectly linked through the HZ FK chain.
• AP_INVOICES_ALL / AP_INVOICE_LINES_ALL — Invoice and line data where TDS defaults are applied.