List of Tables In Oracle Financials for India Payables

Following is the list of Tables used to get all the information about India Localization Payables Transactions.

1. AP_INVOICES_ALL
AP Invoice Details for the given Invoice

2. AP_INVOICE_LINES_ALL
AP Invoice Lines Details for Passed AP invoice

3. AP_INVOICE_DISTRIBUTIONS_ALL
AP Invoice Distributions Details for Passed invoice

4. JAI_AP_INVOICE_LINES
India Local AP invoice lines with tax details

5. JAI_AP_TDS_INVOICES
- Details of Supplier Credit memo and Standard Invoice on Tax Authority generated on Validation of Invoice
- Details of amount of prepayment applied and amount reversed through RTN generated.
- Details of Source Attribute used for tax type identification TDS/WCT: TDS-Attribute1,WCT-Attribute 2,ESI-Attribute 3

6. JAI_AP_TDS_PAYMENTS
Invoice will get updated to this table only if Challan Details are filled for the Invoice

7. JAI_AP_TDS_INV_PAYMENTS
Invoice will get updated to this table only if India Process TDS Payments got run

8. JAI_AP_TDS_F16_DTLS_ALL
Invoice will get updated to this table only if India Generate TDS concurrent got run

9. JAI_AP_TDS_YEARS
Setups pertaining to tds year definition

10. JAI_RGM_DEFINITIONS
Shows details of various regimes Registrations.(vat,service tax, tds,tcs,excise)

11. JAI_RGM_REGISTRATIONS
Shows details of tan and pan Table shows details of various regimes.(vat,service tax, tds,tcs,excise)

12. JAI_RGM_PARTIES
Shows details various regimes.(vat,service tax, tds,tcs,excise) Assigned at Organization (header level details)

13. JAI_CMN_VENDOR_SITES
Supplier addtional information details

14. JAI_AP_TDS_VENDOR_HDRS
Supplier addtional information TDS details

15. JAI_CMN_TAXES_ALL
JAI_cmn_taxes_all for TDS Tax attached in the Inv Dist Tax definition details, for the tax id attached at invoice distribution

16. JAI_AP_TDS_THHOLD_HDRS
TDS Thresholds Setup

17. JAI_AP_TDS_THHOLD_TYPES
TDS Thresholds Types Setup

18. JAI_AP_TDS_THHOLD_SLABS
TDS Thresholds Slabs Setup

19. JAI_AP_TDS_THHOLD_TAXES
TDS Thresholds Taxes Setup

20. JAI_AP_TDS_THHOLD_XCEPS
TDS Thresholds Exception Setup

21. JAI_AP_TDS_THHOLD_GRPS
TDS Thresholds Groups Information

22. JAI_AP_TDS_THHOLD_TRXS
TDS Thresholds Transactions

23. JAI_AP_TDS_INV_TAXES
TDS Thresholds Transactions Taxes

24. JAI_AP_TDS_PREPAYMENTS
Table we can get Prepayment application details (details of SI and Prepayemnt tax id should exist for both and section code should be same)

25. JAI_AP_TDS_INV_CANCELS
TDS Cancellations

26. JAI_AP_TDS_THGRP_AUDITS
TDS Threshold Audits,(details of transaction group id, in this we can get details of threshold calculation)

27. JAI_RGM_TRX_REFS
This table will be populated only when the invoice is accounted and the concurrent program India Service Tax Processing is run

28. JAI_RGM_TRX_RECORDS
This table will be populated when the invoice is paid and the concurrent program India Service Tax Processing is run

29. JAI_AP_MATCH_ERS_T
Stores Invoice details of ERS invoices, so that taxes can be carried from Purchasing to Payables. This table is used for bulk propagation of taxes by concurrent India - to insert taxes by pay on receipt.

30. JAI_RCV_LINES
Get RCV lines of the receipt from the ap invoice

31. JAI_RCV_LINE_TAXES
This Table holds the Information of the Receipt Taxes.

32. JAI_RCV_TRANSACTIONS
Gets IL transactionslines for the receipt

33. JAI_PO_LINE_LOCATIONS
Po details FROM AP DISTRIBUTIONS

34. JAI_PO_TAXES
Gets PO taxes Details for AP Invoice

35. JAI_CMN_JOURNAL_ENTRIES
Stores Accounting Entries Details

36. JAI_CMN_DOCUMENT_TAXES
This table stores the taxes for various India Localization transactions

37. JAI_AP_MATCH_INV_TAXES
This table stores the details of all the TDS taxes that are applicable on an invoice distribution line. This includes, TDS, WCT and ESSI taxes, attached to the 3 segments of the invoice distribution DFF