Search Results jai_ap_etds_t




Overview
Explore in AI Chat

Overview

The JAI_AP_ETDS_T table is a core data repository within the Oracle E-Business Suite Asia/Pacific Localizations module (JA). Its primary function is to store transactional details mandated for compliance with the Electronic Tax Deducted at Source (eTDS) reporting specifications, primarily for the Indian market. This table acts as the central ledger for TDS (Tax Deducted at Source) processing on accounts payable transactions, capturing the complete lifecycle from invoice creation to payment and subsequent statutory reporting. Its existence is critical for generating accurate quarterly eTDS returns (such as Form 26Q and 27Q) as required by Indian tax authorities.

Key Information Stored

While specific column details are not fully enumerated in the provided metadata, the foreign key relationships clearly define the key entities tracked. The table stores identifiers that link TDS transactions to their source documents and parties. This includes references to the original supplier invoice (BASE_INVOICE_ID) and the specific TDS invoice line (TDS_INVOICE_ID) within AP_INVOICES_ALL. It holds the applied TDS tax rule (TDS_TAX_ID) from JAI_CMN_TAXES_ALL and the payment details for both the TDS component (TDS_CHECK_ID) and the net invoice payment (BASE_INVOICE_CHECK_ID) from AP_CHECKS_ALL. Furthermore, it records the vendor (BASE_VENDOR_ID) and vendor site (BASE_VENDOR_SITE_ID) involved. A critical piece of information is the BATCH_ID, which links the transaction to a specific eTDS reporting batch or request in the JAI_AP_ETDS_REQUESTS table, facilitating organized statutory submission.

Common Use Cases and Queries

The primary use case is the generation and reconciliation of eTDS reports. Functional users run the "India - AP - Create eTDS Invoices" and subsequent reporting processes, which populate and read from this table. Common technical queries involve extracting data for a specific reporting period or vendor, or troubleshooting TDS application. A sample query to fetch TDS details for a paid invoice batch would be:

  • SELECT etds.*, ai.invoice_num, hp.party_name FROM jai_ap_etds_t etds, ap_invoices_all ai, hz_parties hp WHERE etds.base_invoice_id = ai.invoice_id AND etds.base_vendor_id = hp.party_id AND etds.batch_id = :p_batch_id;

Another critical use case is auditing: verifying that the TDS deducted per this table matches the amounts reported in the AP payment accounting entries and the final eTDS challan.

Related Objects

JAI_AP_ETDS_T is a central hub with documented foreign key relationships to several fundamental EBS tables:

  • AP_INVOICES_ALL: Linked via BASE_INVOICE_ID and TDS_INVOICE_ID to associate with the base invoice and the specific TDS invoice line.
  • JAI_CMN_TAXES_ALL: Linked via TDS_TAX_ID to identify the exact TDS tax rate and rule applied.
  • AP_CHECKS_ALL: Linked via TDS_CHECK_ID (payment for the TDS amount to the government) and BASE_INVOICE_CHECK_ID (payment of the net invoice to the vendor).
  • HZ_PARTIES & HZ_PARTY_SITES: Linked via BASE_VENDOR_ID and BASE_VENDOR_SITE_ID for vendor and site details essential for reporting.
  • JAI_AP_ETDS_REQUESTS: Linked via BATCH_ID to group transactions under a specific reporting request or submission batch.