India localization tables in oracle apps r12

India localization tables in oracle apps r12

In this post , we will be discuss about Oracle India localization tables in oracle apps r12. Oracle india localization is separate module provided by Oracle to meet the India tax requirements for an organization. From 2017 , India location quite changed after the implementation of GST tax in india. In India Localization tables , i will share the GST and the TDS tables in oracle apps r12. Please find below the detail explanation of India Location tables in oracle.

India Localization oracle apps tables divided in two parts

1. GST Tables.

2. TDS Tables. 

ALL tables about GST tax tables in oracle apps

JAI_PARTY_REGS :- This table stores information's about Party registrations. Both the Parties Supplier and Customer GST number and other information's stores in this Table. Primary Registration Number, Secondary Registration Name, Secondary Registration Number stores in this table

JAI_PARTY_REG_LINES :-This table stores information's about Party registrations lines. Both the Parties Supplier and Customer GST number and other information's stores in this Table. Primary Registration Name, Secondary Registration Number stores in this table

JAI_TAX_LINES_ALL:-  In this table , All the Transactions Taxes information's stores. PO , Invoice and Sale Order taxes Information stores in this  table.

 

JAI_TAX_CATEGORIES:- This table stores Tax Categories Information's.

 

jai_tax_types :- This table Stores all the GST Taxes names , rates and codes information's.

JAI_TAX_DET_FCT_LINES_V :- This Table Stores Tax Category Code, Tax Names , HSC and SCN code information's associated with each transactions in Oracle apps.

TDS Tables in Oracle Apps r12

These are the below TDS tables in oracle apps r12. If you want to refer the TDS report using these tables you can refer this below post Oracle Apps SQL Query to Fetch GST TDS Calculation Report

 1.jai_ap_tds_invoices

 2.ap_invoices_all

 3jai_tax_categories

 4.jai_cmn_taxes_all 

 5.jai_ap_tds_vendor_hdrs

 6.jai_tax_rates

 7.jai_tax_rate_details