Results for “form16_hdr_id”

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

Overview

The JAI_AP_TDS_F16_HDRS_ALL table, owned by the JA schema within the Asia/Pacific Localizations product family, stores header-level information for Tax Deducted at Source (TDS) certificates. Specifically, it captures the Form 16 / Form 16A certificate headers generated against vendor payments for Indian statutory compliance. Each row represents a distinct certificate issued to a supplier, spanning a defined financial period and tax section, tying together the vendor, the deductee's tax authority, and the tax type under which TDS was withheld.

Because the table is keyed on a single surrogate identifier while holding descriptive attributes about a certificate event, its heuristic Data Vault classification is satellite-leaning. This suggests the table is best modeled as a satellite (or source of one) describing a certificate business key rather than as a hub or link in its own right. In an EBS operational context, it functions as the controlling parent of certificate issuance and printing activity, driving remittance reporting and vendor-facing TDS documentation.

Key Information Stored

The primary key is FORM16_HDR_ID (JAI_AP_TDS_F16_HDRS_ALL_PK), a surrogate sequence-generated identifier. The documented unique index is limited to this primary key, so natural business identifiers are not enforced by a separate unique constraint in the metadata; candidate business keys would logically combine CERTIFICATE_NUM, FIN_YR, and tax section context. The most significant columns include:

• VENDOR_ID and VENDOR_SITE_ID — reference HZ_PARTIES and HZ_PARTY_SITES respectively, identifying the deductee supplier and the specific site receiving the certificate.
• TDS_TAX_ID and TDS_TAX_SECTION — link to JAI_CMN_TAXES_ALL and identify the withholding tax type and statutory section (e.g., 194C, 194J) under which tax was deducted.
• TAX_AUTHORITY_ID — references HZ_PARTIES, capturing the government authority receiving remittances.
• ORG_ID — references HR_ALL_ORGANIZATION_UNITS, enforcing multi-org (Operating Unit) security.
• CERTIFICATE_NUM and CERTIFICATE_DATE / ISSUE_DATE — the certificate's human-readable number and issue timeline.
• FROM_DATE, TO_DATE, and FIN_YR — the financial period and fiscal year over which deductions are aggregated.
• ORG_TAN_NUM — the deductor's Tax Account Number, printed on the certificate.
• PRINT_FLAG — indicates whether the certificate has been printed.
• WHO-style auditing columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, and OBJECT_VERSION_NUMBER for optimistic locking.
• Concurrent program tracking: REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, and PROGRAM_LOGIN_ID.

Common Use Cases and Queries

Typical use cases include generating annual Form 16A certificates per vendor, reconciling deducted TDS against remittances, and reporting outstanding print status. A representative query retrieves certificate headers for a given fiscal year and operating unit:

• SELECT f.CERTIFICATE_NUM, f.VENDOR_ID, f.TDS_TAX_SECTION, f.FIN_YR, f.PRINT_FLAG FROM JA.JAI_AP_TDS_F16_HDRS_ALL f WHERE f.ORG_ID = :p_org_id AND f.FIN_YR = :p_fin_yr;
• Joining to payments for certificate detail: SELECT h.CERTIFICATE_NUM, p.INVOICE_ID FROM JA.JAI_AP_TDS_F16_HDRS_ALL h, JA.JAI_AP_TDS_PAYMENTS p WHERE h.FORM16_HDR_ID = p.FORM16_HDR_ID;
• Reporting unprinted certificates: filter on PRINT_FLAG = 'N' scoped by ORG_ID and FIN_YR.

Because multi-org security applies, all operational queries should filter on ORG_ID.

Related Objects

• JAI_AP_TDS_PAYMENTS — child table linked on FORM16_HDR_ID; holds payment-level deduction lines belonging to each certificate header.
• JAI_AP_TDS_INV_PAYMENTS — child table linked on FORM16_HDR_ID; holds invoice-payment TDS associations feeding certificate generation.
• HZ_PARTIES — referenced twice: via VENDOR_ID (deductee) and TAX_AUTHORITY_ID (tax authority).
• HZ_PARTY_SITES — referenced via VENDOR_SITE_ID for the supplier site.
• JAI_CMN_TAXES_ALL — referenced via TDS_TAX_ID, supplying the withholding tax definition.
• HR_ALL_ORGANIZATION_UNITS — referenced via ORG_ID, providing operating unit context.