Search Results tds_payment_id

Overview

The JAI_AP_TDS_INV_PAYMENTS table is a core data repository within the Oracle E-Business Suite (EBS) Asia/Pacific Localizations module (product JA). Specifically designed for versions 12.1.1 and 12.2.2, it serves as the central transactional table for recording Tax Deducted at Source (TDS) payments on supplier invoices. Its primary role is to maintain a detailed, auditable link between a paid invoice, the payment instrument (such as a check), and the associated TDS tax calculations and statutory reporting forms. This table is essential for compliance with TDS regulations in countries like India, enabling accurate tracking, reporting, and reconciliation of tax deductions made during the accounts payable payment process.

Key Information Stored

The table's structure is defined by its foreign key relationships, which indicate the critical data points it stores. Each record is uniquely identified by a TDS_PAYMENT_ID (the primary key). The table acts as a junction, storing references to key transactional entities: the specific invoice paid (INVOICE_ID), the payment transaction against that invoice (INVOICE_PAYMENT_ID), and the payment instrument details (CHECK_ID). Crucially, it links these payment details to the applicable TDS tax rate (TDS_TAX_ID) and the tax authority or supplier from whom the tax is withheld (TAX_AUTHORITY_ID). For statutory reporting, it associates payments with specific Form 16 or equivalent records (FORM16_HDR_ID). Vendor and vendor site identifiers (VENDOR_ID, VENDOR_SITE_ID) provide the complete supplier context for the transaction.

Common Use Cases and Queries

This table is central to TDS reporting and inquiry processes. A common use case is generating a report of all TDS deductions for a financial period, linking payment details to vendor and tax information. Support and audit queries often trace the TDS treatment of a specific invoice payment. Sample SQL patterns include joining to core AP tables to retrieve comprehensive payment details:

• Payment Reconciliation: Query to list all TDS payments for a vendor, showing invoice, payment, check, and deducted tax amount details by joining with AP_INVOICES_ALL, AP_INVOICE_PAYMENTS_ALL, and AP_CHECKS_ALL.
• Form 16 Generation Support: Selecting records linked to a specific FORM16_HDR_ID to validate the payments summarized in a statutory TDS certificate.
• Tax Authority Reporting: Aggregating TDS amounts by TDS_TAX_ID and TAX_AUTHORITY_ID for periodic tax remittance and filing.

Related Objects

As evidenced by its foreign keys, JAI_AP_TDS_INV_PAYMENTS has extensive dependencies within both the localization and core EBS schemas. It is a child table to several key transactional headers:

• Core AP Tables: AP_INVOICES_ALL, AP_INVOICE_PAYMENTS_ALL, AP_CHECKS_ALL, AP_SUPPLIERS, and AP_SUPPLIER_SITES_ALL.
• Localization Tax Tables: JAI_CMN_TAXES_ALL (for the TDS tax definition) and JAI_CMN_VENDOR_SITES.
• Statutory Reporting Table: JAI_AP_TDS_F16_HDRS_ALL (Form 16 headers), which is a primary parent table for generating TDS certificates.

This network of relationships positions JAI_AP_TDS_INV_PAYMENTS as a critical integration point between the standard payment cycle and localized TDS compliance logic.