Search Results jai_ap_tds_invoices




Overview
Explore in AI Chat

Overview

The JAI_AP_TDS_INVOICES table is a core data object within the Asia/Pacific Localizations (JA) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It is designed to support Tax Deducted at Source (TDS) functionality, a critical statutory requirement in countries like India. The table's primary role is to store and manage the transactional relationship between a standard supplier invoice and its corresponding TDS invoice. Specifically, it records all TDS invoices that are automatically generated and validated by the system against a parent invoice, thereby maintaining a clear audit trail for TDS compliance and reconciliation.

Key Information Stored

The table's structure is centered around linking a TDS invoice to its source document and associated tax details. While a full column list is not provided in the metadata, the defined constraints reveal its most critical data points. The primary key, TDS_INVOICE_ID, uniquely identifies each TDS invoice record. The INVOICE_ID column holds a foreign key reference to the AP_INVOICES_ALL table, linking to the parent supplier invoice. The TDS_TAX_ID column references JAI_CMN_TAXES_ALL, identifying the specific TDS tax rate applied. Finally, the ORGANIZATION_ID links to HR_ALL_ORGANIZATION_UNITS, scoping the transaction to a specific operating unit or legal entity within the EBS instance.

Common Use Cases and Queries

This table is essential for TDS reporting, payment reconciliation, and audit inquiries. A common operational need is to retrieve all TDS invoices generated for a specific parent invoice or vendor within a period for verification. For reporting, one might join this table to AP and tax tables to summarize TDS liabilities by organization or tax type. A typical query pattern would be:

  • Identifying TDS Invoices for a Parent Invoice: SELECT tds_invoice_id FROM ja.jai_ap_tds_invoices WHERE invoice_id = <parent_invoice_id>;
  • Reporting on TDS Transactions: SELECT hou.name org, aia.invoice_num, jai.tds_invoice_id, jcta.tax_name FROM ja.jai_ap_tds_invoices jai JOIN ap.ap_invoices_all aia ON jai.invoice_id = aia.invoice_id JOIN hr.hr_all_organization_units hou ON jai.organization_id = hou.organization_id JOIN ja.jai_cmn_taxes_all jcta ON jai.tds_tax_id = jcta.tax_id WHERE aia.invoice_date BETWEEN :p_start_date AND :p_end_date;

Related Objects

As indicated by its foreign key constraints, JAI_AP_TDS_INVOICES has direct and integral relationships with several key EBS tables. Its primary dependency is on AP_INVOICES_ALL, the central Accounts Payable invoices table. It also relies on JAI_CMN_TAXES_ALL for TDS tax master data and HR_ALL_ORGANIZATION_UNITS for organizational context. This table is likely referenced by various JA localization-specific packages, forms, and reports that process TDS calculations, generate statutory forms (like India's Form 26Q), and facilitate TDS payment and settlement workflows within the Payables module.