Search Results ap_invoices_all

Overview

The JAI_AP_TDS_F16_DTLS_ALL table resides in the JA schema and belongs to the Asia/Pacific Localizations product family within Oracle E-Business Suite (validated on 12.1.1 and 12.2.2). It stores the detail records of invoices that have been considered against a particular Tax Deducted at Source (TDS) certificate — specifically the Indian Form 16 / Form 16A withholding context. Each row represents a single invoice, or a portion of an invoice, that contributes to the certificate's deducted amount.

The table is most commonly encountered when querying the Payables subledger, because it references AP_INVOICES_ALL twice (the original invoice and its TDS counterpart) and therefore appears in searches originally motivated by the term "ap_invoices_all". Its relationship to Payables is by foreign key, not by inheritance: JAI_AP_TDS_F16_DTLS_ALL augments standard Payables data with localization-specific certification detail.

From a dimensional-modelling perspective, the mined Data Vault classification is link. This reflects the table's role as an associative construct joining an AP invoice, a TDS invoice, and an AP invoice payment across organizational context. Treating it as a link (rather than a hub or satellite) is a heuristic suggestion derived from the foreign-key structure, not a documented Oracle design statement.

Key Information Stored

The table is owned by JA and documents 22 columns. The surrogate primary key is a single column:

FORM16_DTL_ID — qualified by the unique index JAI_AP_TDS_F16_DTLS_ALL_PK, the sole documented business-key candidate and the table's surrogate identifier.

The most significant descriptive and foreign-key columns are:

INVOICE_ID — foreign key to AP_INVOICES_ALL; the Payables invoice whose TDS is being certified.
TDS_INVOICE_ID — a second foreign key to AP_INVOICES_ALL; the TDS withholding invoice raised against the original.
INVOICE_PAYMENT_ID — foreign key to AP_INVOICE_PAYMENTS_ALL, linking the detail to the payment that settled the invoice.
ORG_ID — foreign key to HR_ALL_ORGANIZATION_UNITS, providing the operating unit / organization context.
INVOICE_AMOUNT and TDS_INVOICE_AMT — the invoice value and the TDS amount withheld.
TDS_INVOICE_AMT_PAID — the portion of the withheld amount actually remitted, supporting reconciliation.
TDS_TAX_RATE and IT_CERTIFICATE_RATE — the deduction rate applied and the income-tax certificate rate applicable to the deduction.
CERTIFICATE_NUM and IT_CERTIFICATE_NUMBER — identifiers of the certificate under which the invoice is considered.
ORG_TAN_NUM and FIN_YR — the deductor's TAN number and the financial year of certification.
TDS_INV_DATE and LINE_NUM — the TDS invoice date and the sequential line within the certificate detail set.
OBJECT_VERSION_NUMBER — standard EBS optimistic-locking column.

Common Use Cases and Queries

Typical reporting and reconciliation scenarios include verifying which supplier invoices were captured on a Form 16 certificate, reconciling withheld versus remitted TDS, and validating certificate totals against invoice-level detail.

Certificate drill-down: join JAI_AP_TDS_F16_DTLS_ALL.INVOICE_ID to AP_INVOICES_ALL.INVOICE_ID to list invoice numbers, vendor, and amounts behind a given CERTIFICATE_NUM.
Withheld-to-paid reconciliation: compare TDS_INVOICE_AMT against TDS_INVOICE_AMT_PAID by FIN_YR and ORG_ID to expose remittance shortfalls.
Operating unit reporting: aggregate by ORG_ID via HR_ALL_ORGANIZATION_UNITS to produce TDS liability summaries per business unit.
Payment traceability: join INVOICE_PAYMENT_ID to AP_INVOICE_PAYMENTS_ALL to identify the checks or payments that triggered withholding.

A representative query pattern filters by financial year and certificate number and joins both AP invoice roles separately for original and TDS invoice context.

Related Objects

The following objects are directly referenced or reference this table through documented keys:

AP_INVOICES_ALL — joined twice, on INVOICE_ID and TDS_INVOICE_ID.
AP_INVOICE_PAYMENTS_ALL — joined on INVOICE_PAYMENT_ID.
HR_ALL_ORGANIZATION_UNITS — joined on ORG_ID.
JAI_AP_TDS_F16_ALL / certificate header objects — logical parent supplying CERTIFICATE_NUM context within the localization.
JAI_AP_TDS_F16_DTLS_ALL_PK — the unique index enforcing the surrogate key on FORM16_DTL_ID.

Because the table is a localization extension of Payables, direct DML is discouraged; certification data is normally maintained through the JA TDS certificate concurrent programs and forms. Financial-year and TAN columns make it a primary source for Indian statutory withholding returns (Form 26Q/27Q) reconciliation.

Table: JAI_AP_TDS_F16_DTLS_ALL 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AP_TDS_F16_DTLS_ALL, object_name:JAI_AP_TDS_F16_DTLS_ALL, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores invoices that have been considered against a particular TDS certificate. , implementation_dba_data: JA.JAI_AP_TDS_F16_DTLS_ALL ,
Table: JAI_AP_TDS_F16_DTLS_ALL 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AP_TDS_F16_DTLS_ALL, object_name:JAI_AP_TDS_F16_DTLS_ALL, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores invoices that have been considered against a particular TDS certificate. , implementation_dba_data: JA.JAI_AP_TDS_F16_DTLS_ALL ,
Table: JAI_AP_ETDS_T 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AP_ETDS_T, object_name:JAI_AP_ETDS_T, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores the details as required by the eTDS specifications for reporting. , implementation_dba_data: JA.JAI_AP_ETDS_T ,
Table: JAI_AP_ETDS_T 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AP_ETDS_T, object_name:JAI_AP_ETDS_T, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores the details as required by the eTDS specifications for reporting. , implementation_dba_data: JA.JAI_AP_ETDS_T ,
Table: JAI_AP_MATCH_INV_TAXES 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AP_MATCH_INV_TAXES, object_name:JAI_AP_MATCH_INV_TAXES, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores details of all MISCELLANEOUS distributions added for tax in AP invoice. , implementation_dba_data: JA.JAI_AP_MATCH_INV_TAXES ,
Table: JAI_AP_TDS_THHOLD_TRXS 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AP_TDS_THHOLD_TRXS, object_name:JAI_AP_TDS_THHOLD_TRXS, status:VALID, product: JA - Asia/Pacific Localizations , description: Storesdetails of all transactions where TDS invoices have been generated. , implementation_dba_data: JA.JAI_AP_TDS_THHOLD_TRXS ,
Table: JAI_AP_MATCH_INV_TAXES 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AP_MATCH_INV_TAXES, object_name:JAI_AP_MATCH_INV_TAXES, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores details of all MISCELLANEOUS distributions added for tax in AP invoice. , implementation_dba_data: JA.JAI_AP_MATCH_INV_TAXES ,
Table: JAI_AP_TDS_THHOLD_TRXS 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AP_TDS_THHOLD_TRXS, object_name:JAI_AP_TDS_THHOLD_TRXS, status:VALID, product: JA - Asia/Pacific Localizations , description: Storesdetails of all transactions where TDS invoices have been generated. , implementation_dba_data: JA.JAI_AP_TDS_THHOLD_TRXS ,
View: JAI_AP_TDS_DISTRIBUTION_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:JA.JAI_AP_TDS_DISTRIBUTION_V, object_name:JAI_AP_TDS_DISTRIBUTION_V, status:VALID, product: JA - Asia/Pacific Localizations , description: View for TDS Distributions , implementation_dba_data: APPS.JAI_AP_TDS_DISTRIBUTION_V ,
Table: JAI_AP_TDS_INV_CANCELS 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AP_TDS_INV_CANCELS, object_name:JAI_AP_TDS_INV_CANCELS, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores details of TDS Cancel processing when an invoice having TDS is cancelled. , implementation_dba_data: JA.JAI_AP_TDS_INV_CANCELS ,
Table: JAI_AP_TDS_INV_CANCELS 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AP_TDS_INV_CANCELS, object_name:JAI_AP_TDS_INV_CANCELS, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores details of TDS Cancel processing when an invoice having TDS is cancelled. , implementation_dba_data: JA.JAI_AP_TDS_INV_CANCELS ,
Table: JAI_AP_TDS_THGRP_AUDITS 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AP_TDS_THGRP_AUDITS, object_name:JAI_AP_TDS_THGRP_AUDITS, status:VALID, product: JA - Asia/Pacific Localizations , description: This table tracks the changes that happens to the table JAI_AP_TDS_THHOLD_GRPS. , implementation_dba_data: JA.JAI_AP_TDS_THGRP_AUDITS ,
Table: JAI_AP_MATCH_ERS_T 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AP_MATCH_ERS_T, object_name:JAI_AP_MATCH_ERS_T, status:VALID, product: JA - Asia/Pacific Localizations , description: Used for bulk propagation of taxes by India - to insert taxes by pay on receipt. , implementation_dba_data: JA.JAI_AP_MATCH_ERS_T ,
Table: JAI_OPM_CM_ADJS_DTL 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_OPM_CM_ADJS_DTL, object_name:JAI_OPM_CM_ADJS_DTL, status:VALID, product: JA - Asia/Pacific Localizations , description: This table stores the cost adjustment details as part of OPM Costing , implementation_dba_data: JA.JAI_OPM_CM_ADJS_DTL ,
Table: JAI_OPM_CM_ADJS_DTL 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_OPM_CM_ADJS_DTL, object_name:JAI_OPM_CM_ADJS_DTL, status:VALID, product: JA - Asia/Pacific Localizations , description: This table stores the cost adjustment details as part of OPM Costing , implementation_dba_data: JA.JAI_OPM_CM_ADJS_DTL ,
Table: JAI_AP_TDS_INVOICES 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AP_TDS_INVOICES, object_name:JAI_AP_TDS_INVOICES, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores all TDS invoices generated at invoice validate against parent invoice. , implementation_dba_data: JA.JAI_AP_TDS_INVOICES ,
Table: JAI_AP_TDS_INVOICES 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AP_TDS_INVOICES, object_name:JAI_AP_TDS_INVOICES, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores all TDS invoices generated at invoice validate against parent invoice. , implementation_dba_data: JA.JAI_AP_TDS_INVOICES ,
Table: JAI_AP_TDS_PAYMENTS 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AP_TDS_PAYMENTS, object_name:JAI_AP_TDS_PAYMENTS, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores the details of TDS challan for payments to TDS authority. , implementation_dba_data: JA.JAI_AP_TDS_PAYMENTS ,
Table: JAI_RGM_SETTLEMENTS 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_RGM_SETTLEMENTS, object_name:JAI_RGM_SETTLEMENTS, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores the settlement information by tax regime , implementation_dba_data: JA.JAI_RGM_SETTLEMENTS ,
Table: JAI_CMN_ST_FORM_DTLS 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_CMN_ST_FORM_DTLS, object_name:JAI_CMN_ST_FORM_DTLS, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores details of ST Forms tracking in Payables and Receivables transactions , implementation_dba_data: JA.JAI_CMN_ST_FORM_DTLS ,
Table: JAI_AP_MATCH_ERS_T 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AP_MATCH_ERS_T, object_name:JAI_AP_MATCH_ERS_T, status:VALID, product: JA - Asia/Pacific Localizations , description: Used for bulk propagation of taxes by India - to insert taxes by pay on receipt. , implementation_dba_data: JA.JAI_AP_MATCH_ERS_T ,
Table: JAI_AP_TDS_THGRP_AUDITS 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AP_TDS_THGRP_AUDITS, object_name:JAI_AP_TDS_THGRP_AUDITS, status:VALID, product: JA - Asia/Pacific Localizations , description: This table tracks the changes that happens to the table JAI_AP_TDS_THHOLD_GRPS. , implementation_dba_data: JA.JAI_AP_TDS_THGRP_AUDITS ,
Table: JAI_PO_REP_PRRG_T 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_PO_REP_PRRG_T, object_name:JAI_PO_REP_PRRG_T, status:VALID, product: JA - Asia/Pacific Localizations , description: Used as a intermediate table for holding the purchase register report details , implementation_dba_data: JA.JAI_PO_REP_PRRG_T ,
Table: JAI_AP_TDS_INV_PAYMENTS 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AP_TDS_INV_PAYMENTS, object_name:JAI_AP_TDS_INV_PAYMENTS, status:VALID, product: JA - Asia/Pacific Localizations , description: This will have the details of all TDS invoices which has been paid , implementation_dba_data: JA.JAI_AP_TDS_INV_PAYMENTS ,
Table: JAI_RCV_TP_INVOICES 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_RCV_TP_INVOICES, object_name:JAI_RCV_TP_INVOICES, status:VALID, product: JA - Asia/Pacific Localizations , description: Holds all the third party invoices generated by India Local third party batch. , implementation_dba_data: JA.JAI_RCV_TP_INVOICES ,
Table: JAI_AP_TDS_PAYMENTS 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AP_TDS_PAYMENTS, object_name:JAI_AP_TDS_PAYMENTS, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores the details of TDS challan for payments to TDS authority. , implementation_dba_data: JA.JAI_AP_TDS_PAYMENTS ,
Table: JAI_CMN_ST_FORM_DTLS 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_CMN_ST_FORM_DTLS, object_name:JAI_CMN_ST_FORM_DTLS, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores details of ST Forms tracking in Payables and Receivables transactions , implementation_dba_data: JA.JAI_CMN_ST_FORM_DTLS ,
Table: JAI_RGM_SETTLEMENTS 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_RGM_SETTLEMENTS, object_name:JAI_RGM_SETTLEMENTS, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores the settlement information by tax regime , implementation_dba_data: JA.JAI_RGM_SETTLEMENTS ,
Table: JAI_AP_TDS_INV_TAXES 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AP_TDS_INV_TAXES, object_name:JAI_AP_TDS_INV_TAXES, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores details of all the TDS taxes that are applicable on an invoice. , implementation_dba_data: JA.JAI_AP_TDS_INV_TAXES ,
Table: JAI_PO_REP_PRRG_T 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_PO_REP_PRRG_T, object_name:JAI_PO_REP_PRRG_T, status:VALID, product: JA - Asia/Pacific Localizations , description: Used as a intermediate table for holding the purchase register report details , implementation_dba_data: JA.JAI_PO_REP_PRRG_T ,
Table: JAI_AP_TDS_INV_PAYMENTS 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AP_TDS_INV_PAYMENTS, object_name:JAI_AP_TDS_INV_PAYMENTS, status:VALID, product: JA - Asia/Pacific Localizations , description: This will have the details of all TDS invoices which has been paid , implementation_dba_data: JA.JAI_AP_TDS_INV_PAYMENTS ,
Table: JAI_RCV_TP_INVOICES 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_RCV_TP_INVOICES, object_name:JAI_RCV_TP_INVOICES, status:VALID, product: JA - Asia/Pacific Localizations , description: Holds all the third party invoices generated by India Local third party batch. , implementation_dba_data: JA.JAI_RCV_TP_INVOICES ,
Table: JAI_AP_TDS_INV_TAXES 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AP_TDS_INV_TAXES, object_name:JAI_AP_TDS_INV_TAXES, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores details of all the TDS taxes that are applicable on an invoice. , implementation_dba_data: JA.JAI_AP_TDS_INV_TAXES ,
View: JAI_AP_MATCH_TAXES_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:JA.JAI_AP_MATCH_TAXES_V, object_name:JAI_AP_MATCH_TAXES_V, status:VALID, product: JA - Asia/Pacific Localizations , implementation_dba_data: APPS.JAI_AP_MATCH_TAXES_V ,
View: JAI_AP_MATCH_TAXES_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:JA.JAI_AP_MATCH_TAXES_V, object_name:JAI_AP_MATCH_TAXES_V, status:VALID, product: JA - Asia/Pacific Localizations , implementation_dba_data: APPS.JAI_AP_MATCH_TAXES_V ,
Table: JAI_AP_TDS_PREPAYMENTS 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AP_TDS_PREPAYMENTS, object_name:JAI_AP_TDS_PREPAYMENTS, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores details of TDS processing for prepayment application and unapplication , implementation_dba_data: JA.JAI_AP_TDS_PREPAYMENTS ,
Table: JAI_AP_TDS_PREPAYMENTS 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AP_TDS_PREPAYMENTS, object_name:JAI_AP_TDS_PREPAYMENTS, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores details of TDS processing for prepayment application and unapplication , implementation_dba_data: JA.JAI_AP_TDS_PREPAYMENTS ,
View: JAI_AP_TDS_F16_DTLS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:JA.JAI_AP_TDS_F16_DTLS_V, object_name:JAI_AP_TDS_F16_DTLS_V, status:VALID, product: JA - Asia/Pacific Localizations , implementation_dba_data: APPS.JAI_AP_TDS_F16_DTLS_V ,
View: JAI_AP_TDS_F16_DTLS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:JA.JAI_AP_TDS_F16_DTLS_V, object_name:JAI_AP_TDS_F16_DTLS_V, status:VALID, product: JA - Asia/Pacific Localizations , implementation_dba_data: APPS.JAI_AP_TDS_F16_DTLS_V ,
View: JAI_ST_FORMS_DTL_GRPISS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:JA.JAI_ST_FORMS_DTL_GRPISS_V, object_name:JAI_ST_FORMS_DTL_GRPISS_V, status:VALID, product: JA - Asia/Pacific Localizations , implementation_dba_data: APPS.JAI_ST_FORMS_DTL_GRPISS_V ,
View: JAI_ST_FORMS_DTL_GRPISS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:JA.JAI_ST_FORMS_DTL_GRPISS_V, object_name:JAI_ST_FORMS_DTL_GRPISS_V, status:VALID, product: JA - Asia/Pacific Localizations , implementation_dba_data: APPS.JAI_ST_FORMS_DTL_GRPISS_V ,