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
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
