Results for “fin_yr”

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

Overview

JAI_AP_TDS_F16_DTLS_V is a reporting view owned by the APPS schema within the JA (Asia/Pacific Localizations) product family of Oracle E-Business Suite, applicable to releases 12.1.1 and 12.2.2. It presents the detail (line-level) contents of Indian Tax Deducted at Source (TDS) Form 16 certificates, which are issued to vendors and suppliers as evidence of tax withheld on their behalf. The view is the detail counterpart to the Form 16 header entity and is keyed principally by FORM16_HDR_ID, the identifier that links every detail row back to its parent certificate in JAI_AP_TDS_F16_HDRS_ALL. In practice, the view is consumed by localization reporting, statutory Form 16 generation processes, and any custom integration that must reconcile withheld tax amounts against the source invoices and payments that produced them.

Underlying Base Objects

The view is defined over four documented base objects, all referenced as synonyms in the APPS schema:

• JAI_AP_TDS_INV_PAYMENTS — the driving table (aliased TDS_PAYMENTS), supplying the withholding line details such as taxable basis, tax rate, tax amount, and the invoice payment linkage.
• JAI_AP_TDS_F16_HDRS_ALL — the Form 16 header/certificate table (aliased TDS_CERT), joined on FORM16_HDR_ID to provide certificate number, financial year, organization TAN, and audit columns.
• AP_INVOICES_ALL — the standard Payables invoice table (aliased BASE_INVOICES), joined on PARENT_INVOICE_ID to INVOICE_ID to retrieve the operating unit context via ORG_ID.
• JAI_CMN_TAXES_ALL — the common taxes setup table (aliased TAX), joined on TDS_TAX_ID to TAX_ID to supply statutory certificate type, surcharge rate, and cess rate.

The join topology is a straightforward inner-join chain: header to detail via FORM16_HDR_ID, detail to invoice via PARENT_INVOICE_ID, and detail to tax setup via TDS_TAX_ID.

Key Columns

• FORM16_HDR_ID — primary linkage to the Form 16 header row; the most frequently filtered column.
• CERTIFICATE_NUM / FIN_YR / ORG_TAN_NUM — statutory certificate identity, financial year, and the deductor's TAN.
• LINE_NUM — the certificate line number within the header.
• INVOICE_ID / TDS_INVOICE_ID / INVOICE_PAYMENT_ID — the parent invoice, the TDS-bearing invoice, and the payment application respectively.
• INVOICE_AMOUNT, TAXABLE_BASIS, TDS_TAX_RATE, TDS_INVOICE_AMT — monetary and rate attributes of the withholding line.
• IT_CERTIFICATE_NUMBER — derived from TAX.STFORM_TYPE, indicating the certificate type used for income-tax reporting.
• SURCHARGE_RATE / CESS_RATE — statutory levies applied in addition to the base TDS rate.
• ORG_ID — operating unit, sourced from the base invoice, supporting multi-org reporting.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, inherited from the header record.

Common Use Cases and Queries

The view is most often queried to reproduce or audit the detail lines of a Form 16 certificate, to validate withheld amounts against invoiced values, and to feed custom extracts. A typical query retrieving all lines for a given certificate is:

• SELECT certificate_num, line_num, invoice_id, taxable_basis, tds_tax_rate, tds_invoice_amt FROM apps.jai_ap_tds_f16_dtls_v WHERE form16_hdr_id = :p_form16_hdr_id ORDER BY line_num;
• SELECT fin_yr, org_tan_num, SUM(tds_invoice_amt) FROM apps.jai_ap_tds_f16_dtls_v WHERE org_id = :p_org_id GROUP BY fin_yr, org_tan_num;

Because the view does not expose a certificate status column, consumers requiring status should join back to JAI_AP_TDS_F16_HDRS_ALL. The view is read-only and, per the ETRM metadata, carries VALID status in the APPS schema.