Search Results jai_cmn_taxes_all

The JAI_CMN_TAXES_ALL table is a critical component in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2, specifically within the context of the Oracle India Localization (JAI - JAIN) module. This table serves as a repository for tax-related information, enabling businesses operating in India to comply with local tax regulations, including Goods and Services Tax (GST), Value Added Tax (VAT), and other statutory requirements. Below is a detailed summary of its structure, purpose, and key attributes. ### **Purpose and Functional Overview** The JAI_CMN_TAXES_ALL table stores master tax definitions applicable to transactions processed in Oracle EBS. It acts as a reference for tax rates, tax types, and jurisdictional details, ensuring accurate tax calculations during invoicing, purchasing, and other financial operations. This table integrates with core EBS modules like Accounts Payable (AP), Accounts Receivable (AR), and General Ledger (GL) to facilitate tax compliance. ### **Key Columns and Descriptions** 1. **TAX_ID** – Primary key, uniquely identifying each tax record. 2. **TAX_NAME** – Descriptive name of the tax (e.g., "GST 18%," "VAT 5%"). 3. **TAX_TYPE** – Classifies the tax (e.g., GST, VAT, CESS). 4. **TAX_RATE** – The applicable tax rate (percentage or fixed amount). 5. **START_DATE** and **END_DATE** – Define the validity period of the tax rate. 6. **ORG_ID** – Associates the tax with a specific operating unit (multi-org support). 7. **JURISDICTION_CODE** – Specifies the geographical jurisdiction (state, union territory). 8. **INPUT_TAX_ACCOUNT** and **OUTPUT_TAX_ACCOUNT** – GL accounts for tax postings. 9. **ACTIVE_FLAG** – Indicates whether the tax is currently active (Y/N). 10. **CREATED_BY**, **CREATION_DATE**, **LAST_UPDATED_BY**, **LAST_UPDATE_DATE** – Audit columns for tracking changes. ### **Integration with Other Modules** - **Procurement & Payables (PO/AP):** Tax calculations on supplier invoices. - **Order Management & Receivables (OM/AR):** Tax application on customer invoices. - **General Ledger (GL):** Automatic tax accounting entries. - **India-Specific Localization:** Supports GST returns, e-invoicing, and e-way bills. ### **Technical Considerations** - **Multi-Org Enabled:** Data is partitioned by ORG_ID for multi-organization deployments. - **Indexing:** Typically indexed on TAX_ID, TAX_TYPE, and JURISDICTION_CODE for performance. - **Flexfields:** May integrate with Descriptive Flexfields (DFFs) for additional attributes. ### **Customization and Extensions** The table can be extended via custom columns or DFFs to accommodate unique business requirements. However, direct modifications should be avoided to prevent upgrade conflicts. ### **Data Maintenance** Tax records are typically maintained via the Oracle EBS tax setup forms (e.g., India Tax Manager), ensuring validation and audit trails. Manual SQL updates are discouraged. ### **Conclusion** The JAI_CMN_TAXES_ALL table is foundational for India-specific tax compliance in Oracle EBS. Its structured design ensures accurate tax determination, reporting, and seamless integration with financial processes. Proper configuration and maintenance are essential to avoid compliance risks and ensure smooth operations.

Table: JAI_CMN_TAXES_ALL 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_CMN_TAXES_ALL, object_name:JAI_CMN_TAXES_ALL, status:VALID, product: JA - Asia/Pacific Localizations , description: Master table for Localization Taxes , implementation_dba_data: JA.JAI_CMN_TAXES_ALL ,
Table: JAI_CMN_TAXES_ALL 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_CMN_TAXES_ALL, object_name:JAI_CMN_TAXES_ALL, status:VALID, product: JA - Asia/Pacific Localizations , description: Master table for Localization Taxes , implementation_dba_data: JA.JAI_CMN_TAXES_ALL ,
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 ,
Table: JAI_RCV_RGM_CLAIMS 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_RCV_RGM_CLAIMS, object_name:JAI_RCV_RGM_CLAIMS, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores the details of receipt claims by regime. , implementation_dba_data: JA.JAI_RCV_RGM_CLAIMS ,
Table: JAI_AR_SUP_TAXES 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AR_SUP_TAXES, object_name:JAI_AR_SUP_TAXES, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores SuppTransaction details of the individual taxes with the Orig INV dtls. , implementation_dba_data: JA.JAI_AR_SUP_TAXES ,
Table: JAI_RCV_RGM_CLAIMS 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_RCV_RGM_CLAIMS, object_name:JAI_RCV_RGM_CLAIMS, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores the details of receipt claims by regime. , implementation_dba_data: JA.JAI_RCV_RGM_CLAIMS ,
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_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_PO_RCV_TAXES_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:JA.JAI_PO_RCV_TAXES_V, object_name:JAI_PO_RCV_TAXES_V, status:VALID, product: JA - Asia/Pacific Localizations , description: View for PO RCV taxes , implementation_dba_data: APPS.JAI_PO_RCV_TAXES_V ,
View: JAI_CMN_CESS_TRXS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:JA.JAI_CMN_CESS_TRXS_V, object_name:JAI_CMN_CESS_TRXS_V, status:VALID, product: JA - Asia/Pacific Localizations , implementation_dba_data: APPS.JAI_CMN_CESS_TRXS_V ,
View: JAI_CMN_CESS_TRXS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:JA.JAI_CMN_CESS_TRXS_V, object_name:JAI_CMN_CESS_TRXS_V, status:VALID, product: JA - Asia/Pacific Localizations , implementation_dba_data: APPS.JAI_CMN_CESS_TRXS_V ,
Table: JAI_CMN_TAX_CTG_LINES 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_CMN_TAX_CTG_LINES, object_name:JAI_CMN_TAX_CTG_LINES, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores the tax lines for defined tax categories , implementation_dba_data: JA.JAI_CMN_TAX_CTG_LINES ,
Table: JAI_RCV_TP_INV_DETAILS 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_RCV_TP_INV_DETAILS, object_name:JAI_RCV_TP_INV_DETAILS, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores Invoice Lines created as part of Third Party Receipt Taxes , implementation_dba_data: JA.JAI_RCV_TP_INV_DETAILS ,
Table: JAI_CRM_QUOTE_TAXES 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_CRM_QUOTE_TAXES, object_name:JAI_CRM_QUOTE_TAXES, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores the quote tax information. , implementation_dba_data: JA.JAI_CRM_QUOTE_TAXES ,
Table: JAI_RETRO_TAX_CHANGES 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_RETRO_TAX_CHANGES, object_name:JAI_RETRO_TAX_CHANGES, status:VALID, product: JA - Asia/Pacific Localizations , description: This table is used to store the Retroactive changes made for document taxes , implementation_dba_data: JA.JAI_RETRO_TAX_CHANGES ,
Table: JAI_CRM_QUOTE_TAXES 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_CRM_QUOTE_TAXES, object_name:JAI_CRM_QUOTE_TAXES, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores the quote tax information. , implementation_dba_data: JA.JAI_CRM_QUOTE_TAXES ,
Table: JAI_CMN_TAX_CTG_LINES 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_CMN_TAX_CTG_LINES, object_name:JAI_CMN_TAX_CTG_LINES, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores the tax lines for defined tax categories , implementation_dba_data: JA.JAI_CMN_TAX_CTG_LINES ,
Table: JAI_OM_WSH_LINE_TAXES 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_OM_WSH_LINE_TAXES, object_name:JAI_OM_WSH_LINE_TAXES, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores information for the tax lines corresponding to the picking line. , implementation_dba_data: JA.JAI_OM_WSH_LINE_TAXES ,
Table: JAI_OM_OE_RMA_TAXES 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_OM_OE_RMA_TAXES, object_name:JAI_OM_OE_RMA_TAXES, status:VALID, product: JA - Asia/Pacific Localizations , description: This table holds the tax details associated with a return order. , implementation_dba_data: JA.JAI_OM_OE_RMA_TAXES ,
Table: JAI_RGM_TAXES 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_RGM_TAXES, object_name:JAI_RGM_TAXES, status:VALID, product: JA - Asia/Pacific Localizations , description: This table stores tax details for transactions having TCS tax type. , implementation_dba_data: JA.JAI_RGM_TAXES ,
Table: JAI_RGM_TAXES 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_RGM_TAXES, object_name:JAI_RGM_TAXES, status:VALID, product: JA - Asia/Pacific Localizations , description: This table stores tax details for transactions having TCS tax type. , implementation_dba_data: JA.JAI_RGM_TAXES ,
Table: JAI_PO_REQUEST_T 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_PO_REQUEST_T, object_name:JAI_PO_REQUEST_T, status:VALID, product: JA - Asia/Pacific Localizations , description: Used by JAINPOCR concurrent for defaulting taxes , implementation_dba_data: JA.JAI_PO_REQUEST_T ,
Table: JAI_CMN_DOCUMENT_TAXES 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_CMN_DOCUMENT_TAXES, object_name:JAI_CMN_DOCUMENT_TAXES, status:VALID, product: JA - Asia/Pacific Localizations , description: This table stores the taxes for various India Localization transactions , implementation_dba_data: JA.JAI_CMN_DOCUMENT_TAXES ,
Table: JAI_RETRO_TAX_CHANGES 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_RETRO_TAX_CHANGES, object_name:JAI_RETRO_TAX_CHANGES, status:VALID, product: JA - Asia/Pacific Localizations , description: This table is used to store the Retroactive changes made for document taxes , implementation_dba_data: JA.JAI_RETRO_TAX_CHANGES ,
Table: JAI_AR_TRX_TAX_CALC_T 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AR_TRX_TAX_CALC_T, object_name:JAI_AR_TRX_TAX_CALC_T, status:VALID, product: JA - Asia/Pacific Localizations , description: TempTable used for tax calc of the new price,new assessable price for suppl inv. , implementation_dba_data: JA.JAI_AR_TRX_TAX_CALC_T ,
Table: JAI_OM_WSH_LINE_TAXES 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_OM_WSH_LINE_TAXES, object_name:JAI_OM_WSH_LINE_TAXES, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores information for the tax lines corresponding to the picking line. , implementation_dba_data: JA.JAI_OM_WSH_LINE_TAXES ,
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_CMN_MATCH_TAXES 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_CMN_MATCH_TAXES, object_name:JAI_CMN_MATCH_TAXES, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores recomputed excise tax based on Receipt matching with Sales shipments , implementation_dba_data: JA.JAI_CMN_MATCH_TAXES ,
Table: JAI_OM_OE_RMA_TAXES 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_OM_OE_RMA_TAXES, object_name:JAI_OM_OE_RMA_TAXES, status:VALID, product: JA - Asia/Pacific Localizations , description: This table holds the tax details associated with a return order. , implementation_dba_data: JA.JAI_OM_OE_RMA_TAXES ,
Table: JAI_AP_TDS_VENDOR_HDRS 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AP_TDS_VENDOR_HDRS, object_name:JAI_AP_TDS_VENDOR_HDRS, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores TDS info against a vendor including the default section and tax. , implementation_dba_data: JA.JAI_AP_TDS_VENDOR_HDRS ,
Table: JAI_CMN_DOCUMENT_TAXES 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_CMN_DOCUMENT_TAXES, object_name:JAI_CMN_DOCUMENT_TAXES, status:VALID, product: JA - Asia/Pacific Localizations , description: This table stores the taxes for various India Localization transactions , implementation_dba_data: JA.JAI_CMN_DOCUMENT_TAXES ,
Table: JAI_AP_TDS_VENDOR_HDRS 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AP_TDS_VENDOR_HDRS, object_name:JAI_AP_TDS_VENDOR_HDRS, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores TDS info against a vendor including the default section and tax. , implementation_dba_data: JA.JAI_AP_TDS_VENDOR_HDRS ,
Table: JAI_PO_REQ_LINE_TAXES 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_PO_REQ_LINE_TAXES, object_name:JAI_PO_REQ_LINE_TAXES, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores the data pertaining to the Taxes in the Requisition. , implementation_dba_data: JA.JAI_PO_REQ_LINE_TAXES ,
Table: JAI_AR_TRX_TAX_LINES 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AR_TRX_TAX_LINES, object_name:JAI_AR_TRX_TAX_LINES, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores information about the actual taxes applicable for the invoice line. , implementation_dba_data: JA.JAI_AR_TRX_TAX_LINES ,
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_RCV_TP_INV_DETAILS 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_RCV_TP_INV_DETAILS, object_name:JAI_RCV_TP_INV_DETAILS, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores Invoice Lines created as part of Third Party Receipt Taxes , implementation_dba_data: JA.JAI_RCV_TP_INV_DETAILS ,
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_CMN_MATCH_TAXES 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_CMN_MATCH_TAXES, object_name:JAI_CMN_MATCH_TAXES, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores recomputed excise tax based on Receipt matching with Sales shipments , implementation_dba_data: JA.JAI_CMN_MATCH_TAXES ,
View: JAI_RCV_RGM_TAX_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:JA.JAI_RCV_RGM_TAX_V, object_name:JAI_RCV_RGM_TAX_V, status:VALID, product: JA - Asia/Pacific Localizations , implementation_dba_data: APPS.JAI_RCV_RGM_TAX_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_PO_REQUEST_T 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_PO_REQUEST_T, object_name:JAI_PO_REQUEST_T, status:VALID, product: JA - Asia/Pacific Localizations , description: Used by JAINPOCR concurrent for defaulting taxes , implementation_dba_data: JA.JAI_PO_REQUEST_T ,
Table: JAI_AR_TRX_INS_LINES_T 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AR_TRX_INS_LINES_T, object_name:JAI_AR_TRX_INS_LINES_T, status:VALID, product: JA - Asia/Pacific Localizations , description: Table holds tax records after auto invoice, manual invoice is saved. , implementation_dba_data: JA.JAI_AR_TRX_INS_LINES_T ,
Table: JAI_PO_REQ_LINE_TAXES 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_PO_REQ_LINE_TAXES, object_name:JAI_PO_REQ_LINE_TAXES, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores the data pertaining to the Taxes in the Requisition. , implementation_dba_data: JA.JAI_PO_REQ_LINE_TAXES ,
Table: JAI_AR_TRX_TAX_LINES 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AR_TRX_TAX_LINES, object_name:JAI_AR_TRX_TAX_LINES, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores information about the actual taxes applicable for the invoice line. , implementation_dba_data: JA.JAI_AR_TRX_TAX_LINES ,
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_AP_TDS_F16_HDRS_ALL 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AP_TDS_F16_HDRS_ALL, object_name:JAI_AP_TDS_F16_HDRS_ALL, status:VALID, product: JA - Asia/Pacific Localizations , description: Header information for TDS certificates. , implementation_dba_data: JA.JAI_AP_TDS_F16_HDRS_ALL ,
Table: JAI_AR_TRX_INS_LINES_T 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AR_TRX_INS_LINES_T, object_name:JAI_AR_TRX_INS_LINES_T, status:VALID, product: JA - Asia/Pacific Localizations , description: Table holds tax records after auto invoice, manual invoice is saved. , implementation_dba_data: JA.JAI_AR_TRX_INS_LINES_T ,
Table: JAI_RCV_LINE_TAXES 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_RCV_LINE_TAXES, object_name:JAI_RCV_LINE_TAXES, status:VALID, product: JA - Asia/Pacific Localizations , description: This Table holds the Information of the Receipt Taxes. , implementation_dba_data: JA.JAI_RCV_LINE_TAXES ,
Table: JAI_AP_TDS_F16_HDRS_ALL 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AP_TDS_F16_HDRS_ALL, object_name:JAI_AP_TDS_F16_HDRS_ALL, status:VALID, product: JA - Asia/Pacific Localizations , description: Header information for TDS certificates. , implementation_dba_data: JA.JAI_AP_TDS_F16_HDRS_ALL ,