Amazon

Tuesday, November 25, 2014

India Localization Taxes and customer and supplier Tables

PO Taxes Table:-

jai_po_taxes                              /*table for puchase order taxes */ join is po_line_id

GRN Taxes Table:-
JAI_RCV_LINE_TAXES             /*table for GRN taxes */ join is shipment_line_id

Payable Invoice Invoice Tax Table:-

jai_ap_match_inv_taxes               /*table for Payable invoice  taxes */ 
JAI_AP_INVOICE_LINES         /* Table for payable invoice for non po related taxes*/

when we deduct TDS invoice against Supplier Invoice that time we create credit memo so to link between main invoice, tds credit memo and invoice of Tax authority to whom we pay that tax all this link is availbale in following table:-

jai_ap_tds_thhold_trxs                /* TDS tax invoice table */


Tax Creation Table and Tax Categories tables :-

jai_cmn_taxes_all                      /*table for taxes type deatiles */
JAI_CMN_TAX_CTGS_ALL         /* tax categories header table */
JAI_CMN_TAX_CTG_LINES     /* tax categories line table */



Supplier,customer and inventory org additional Information Tables:-

jai_cmn_vendor_sites                         /*table india lovalization vendor sites */
jai_cmn_inventory_orgs                    /*table india lovalization inventory organizations */
jai_cmn_cus_addresses                                   /*table for customer  information Details */
        
 Order Taxes Table:-     

JAI_OM_OE_SO_LINES                         /*India Localization Order lines table* /

JAI_OM_OE_SO_TAXES                           /* table for order taxes */


AR Invoice Taxes Tables:-

jai_ar_trxs                                                  /*table for AR invoice india localization header */
jai_ar_trx_lines                                    /*table for AR invoice india localization lines */
jai_ar_trx_tax_lines                             /*table for AR invoice taxes */

BOE Related Table:-


JAI_CMN_BOE_HDRS                                    Stores BOE header info when a BOE Invoice is created through IL
JAI_CMN_BOE_DTLS                                     Detail table for BOE Invoices


Regime Related Tables:-

JAI_RGM_DEFINITIONS                                Stores regime information.
JAI_RGM_TAXES                                           This table stores tax details for transactions having TCS tax type. 


RG23 Related tables:-
JAI_CMN_RG_23AC_I_TRXS             Stores Information of RG23A/C records and known as Quantity Register.
JAI_CMN_RG_23AC_II_TRXS       Stores Information of RG23A/C Part II Details. Also known as Amount Register
JAI_CMN_RG_23D_TRXS                       Quantity register for Trading Organizations
JAI_CMN_RG_BALANCES                 Store the current balances of RG23A, RG23C and PLA Registers 


PLA register Tables:-
JAI_CMN_RG_PLA_TRXS                Stores the Transaction Information of PLA Register.
JAI_CMN_RG_PLA_HDRS             Stores PLA header Infomation when a PLA invoice is created in AP module
JAI_CMN_RG_PLA_DTLS             Stores PLA Detail Information when a PLA Invoice is created in AP Module

No comments:

Post a Comment