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