JA Tables (319)

JA - Asia/Pacific Localizations — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

TableColumnsDescription
JAI_AP_ETDS_ERRORS_T 4
JAI_AP_ETDS_REQUESTS 29 This table stores the details with which each request of eTds was run.
JAI_AP_ETDS_T 39 Stores the details as required by the eTDS specifications for reporting.
JAI_AP_INVOICE_LINES 20 This table is used to store the taxes related with standalone payables invoices
JAI_AP_MATCH_ERS_T 22 Used for bulk propagation of taxes by India - to insert taxes by pay on receipt.
JAI_AP_MATCH_INV_TAXES 46 Stores details of all MISCELLANEOUS distributions added for tax in AP invoice.
JAI_AP_RGM_PAYMENTS 24 This table stores the payment information about payment made to TCS authority.
JAI_AP_TDS_CERT_NUMS 14 Stores the certificate ids by org anization tan where TDS year info is defined.
JAI_AP_TDS_DEFAULT 20 This is an intermediate table that is used to derive the TDS Section Code and Tax category based on Defaultation Setup before populating int
JAI_AP_TDS_F16_DTLS_ALL 22 Stores invoices that have been considered against a particular TDS certificate.
JAI_AP_TDS_F16_HDRS_ALL 25 Header information for TDS certificates.
JAI_AP_TDS_INVOICES 25 Stores all TDS invoices generated at invoice validate against parent invoice.
JAI_AP_TDS_INV_CANCELS 19 Stores details of TDS Cancel processing when an invoice having TDS is cancelled.
JAI_AP_TDS_INV_PAYMENTS 39 This will have the details of all TDS invoices which has been paid
JAI_AP_TDS_INV_TAXES 59 Stores details of all the TDS taxes that are applicable on an invoice.
JAI_AP_TDS_PAN_CHANGES 15 History related to Pan Changes of the Vendors
JAI_AP_TDS_PAYMENTS 30 Stores the details of TDS challan for payments to TDS authority.
JAI_AP_TDS_PREPAYMENTS 37 Stores details of TDS processing for prepayment application and unapplication
JAI_AP_TDS_REPOSITORY 66 This table stores TDS repository information
JAI_AP_TDS_REPO_LINES 11 This table stores TDS repository details lines.
JAI_AP_TDS_SEC_MAP 12
JAI_AP_TDS_THGRP_AUDITS 37 This table tracks the changes that happens to the table JAI_AP_TDS_THHOLD_GRPS.
JAI_AP_TDS_THHOLD_ACCOUNT 11 This table stores Natural Accounts mapped to TDS Threshold Setup Types in case of Multi Rate Setup.
JAI_AP_TDS_THHOLD_GRPS 24 Stores the details current threshold position for a threshold group.
JAI_AP_TDS_THHOLD_HDRS 16 Stores details of threshold applicable for a TDS vendor vendor type.
JAI_AP_TDS_THHOLD_SLABS 12 Stores details of various slabs and the applicable tax rate in the slab.
JAI_AP_TDS_THHOLD_TAXES 13 Stores details of taxes applicable for a particular slabrate by operating unit.
JAI_AP_TDS_THHOLD_TRXS 39 Storesdetails of all transactions where TDS invoices have been generated.
JAI_AP_TDS_THHOLD_TYPES 12 Stores the details of TDS threshold type agsinst a TDS threshold header.
JAI_AP_TDS_THHOLD_XCEPS 12 Stores details of all exception TDS thresholds.
JAI_AP_TDS_VENDOR_HDRS 17 Stores TDS info against a vendor including the default section and tax.
JAI_AP_TDS_YEARS 14 This table holds setup information of Financial Periods.
JAI_AP_TOL_SETUPS_ALL 13 This table stores the tolerance setup by organization.
JAI_AR_CASH_RECEIPTS_ALL 42 This table stores the payment information about payment made to TCS authority.
JAI_AR_DRB_CLAIMS 20 Holds the details of the duty drawbacks.
JAI_AR_ETCS_T 30 This is a temporary table used for e-tcs filing
JAI_AR_EXCISE_UOM 11 This table maps the Primary UOM Codes with the Excise UOM Codes
JAI_AR_PAYMENT_AUDITS 39 This is the Audit/History table for ar_payment_schedules_all
JAI_AR_REC_APPL_AUDITS 21 This is the Audit/History table for ar_receivable_applications_all
JAI_AR_SUP_CHANGES_ALL 19 Table stores mapping info with the Cust/CustSite considered for supp inv process
JAI_AR_SUP_HDRS_ALL 28 This table stores the Supplementary Transaction details.
JAI_AR_SUP_INV_T 18 Table stores TempInfo of Suppl INV used by India Gen. Suggestive Suppl Report.
JAI_AR_SUP_LINES 31 Table stores SuppTransaction dtls of the individual items with the Orig Inv dtls
JAI_AR_SUP_TAXES 36 Stores SuppTransaction details of the individual taxes with the Orig INV dtls.
JAI_AR_TDS_CERTIFICATES 17 Table stores details of TDScredit memo generated for creation of ARcredit memo.
JAI_AR_TRXS 34 Stores information about the receivables invoices.
JAI_AR_TRX_CM_T 16 This table holds the details of the st forms details for an AR credit memo.
JAI_AR_TRX_COPY_HDR_T 11 This table is used whenever an invoice is copied from a source transaction.
JAI_AR_TRX_INS_HDRS_T 17 Table stores values pass'g RGentry when manual ARtransaction done for 1st time
JAI_AR_TRX_INS_LINES_T 28 Table holds tax records after auto invoice, manual invoice is saved.
JAI_AR_TRX_LINES 58 Stores information about the transaction lines.
JAI_AR_TRX_POE_DTLS 15 This table holds the details of the proof of exports details.
JAI_AR_TRX_SUP_INV_T 23 TempTable stores Supp Invoices and used by India Gen Suggestive Supp Report.
JAI_AR_TRX_TAX_CALC_T 27 TempTable used for tax calc of the new price,new assessable price for suppl inv.
JAI_AR_TRX_TAX_LINES 27 Stores information about the actual taxes applicable for the invoice line.
JAI_AR_TRX_UPDATE_T 8 Stored after update on Stand.Orders and Inv in OE and AR resp to query the rec.
JAI_BOE_DETAILS 44 This table contains the BOE detail info related to the specific BOE document line including quantity, goods, customs duty and package info
JAI_BOE_DETAIL_TAXES 32 This table contains the BOE tax line info about the specific BOE line.
JAI_BOE_DOCUMENTS 12 This table contains the document line info such as PO/Release/ASBN for the specific BOE header.
JAI_BOE_MATCHING_TAXES 10 This table is used to match BOE with Receipt
JAI_BOE_MIGRATION_TEMP 2 This table is used for BOE migration
JAI_BOE_ROUNDINGS 12 This table is used for BOE Rounding
JAI_BOE_WRITEOFF_TAXES 10 This table is used for BOE writeoff
JAI_BOM_FINISHED_GOODS 14
JAI_BOM_RAW_MATERIALS 12
JAI_CMN_BOE_AGENTS 15 Setup table for Agent information used for BOE Invoices
JAI_CMN_BOE_DTLS 45 Detail table for BOE Invoices
JAI_CMN_BOE_HDRS_ALL 72 Stores BOE header info when a BOE Invoice is created through IL
JAI_CMN_BOE_MATCHINGS 14 Stores BOE Matchings with Receipts Information.
JAI_CMN_BOE_WRITEOFFS 11 Stores the writeoff entries for BOEs
JAI_CMN_CUS_ADDRESSES 44 Stores customer india information for excise and sales regimes
JAI_CMN_DEBUG_CONTEXTS 6 This table stores debug context information ( used for debugging ).
JAI_CMN_DOCUMENT_TAXES 36 This table stores the taxes for various India Localization transactions
JAI_CMN_ERRORS_T 9 Stores the localization exceptions generated through various objects
JAI_CMN_FIN_YEARS 11 Stores information financial year information of organizations
JAI_CMN_INVENTORY_ORGS 104 Setup table for India Org and Locations to store EC Code and accounting info.
JAI_CMN_JOURNAL_ENTRIES 24 Records GL Entries made by IL into GL Interface. Except for IL Receiving func.
JAI_CMN_LINES 25 Stores the ASBN information
JAI_CMN_MATCH_RECEIPTS 16 Stores matching details of issues against the receipts in trading organization
JAI_CMN_MATCH_TAXES 30 Stores recomputed excise tax based on Receipt matching with Sales shipments
JAI_CMN_MTAX_HDRS_ALL 29 Stores Mass Tax Changes requests with all inputs submitted
JAI_CMN_MTAX_UPD_DTLS 21 Stores the lines processed by Mass Tax Changes with details along with errors
JAI_CMN_OM_AR_AR3_FORMS 23 This table stores the AR3 forms and the details. This is used in both AR and OM.
JAI_CMN_RG_23AC_II_TRXS 48 Stores Information of RG23A/C Part II Details. Also known as Amount Register
JAI_CMN_RG_23AC_I_TRXS 79 Stores Information of RG23A/C records and known as Quantity Register.
JAI_CMN_RG_23D_TRXS 69 Quantity register for Trading Organizations
JAI_CMN_RG_BALANCES 15 Store the current balances of RG23A, RG23C and PLA Registers.
JAI_CMN_RG_COMP_BALS 18 Stores running balances of each excise component for Organization and location
JAI_CMN_RG_COMP_DTLS 27 Stores detailed balances of each excise component for every RG23A/C record
JAI_CMN_RG_CONSLDATIONS 66 Stores Transaction information of RG Consolidation.
JAI_CMN_RG_EXC_INV_NOS 19 Stores setup information to generate excise invoice numbers
JAI_CMN_RG_I_TRXS 61 Stores Information required for RG 1 Register. It is a Quantity Register.
JAI_CMN_RG_OTHERS 15 Extension to existing RG tables to store information by tax type
JAI_CMN_RG_OTH_BALANCES 10 Stores the current balances for organization, location, register and tax type
JAI_CMN_RG_PERIOD_BALS 31 Stores RG Balances for each period, for different types of RegisterS
JAI_CMN_RG_PLA_CMP_DTLS 25 Stores detailed balances of each excise component for every PLA record
JAI_CMN_RG_PLA_DTLS 16 Stores PLA Detail Information when a PLA Invoice is created in AP Module
JAI_CMN_RG_PLA_HDRS 19 Stores PLA header Infomation when a PLA invoice is created in AP module
JAI_CMN_RG_PLA_TRXS 69 Stores the Transaction Information of PLA Register.
JAI_CMN_RG_ROUND_HDRS 36 Stores the excise amount, which is rounded for each excise invoice
JAI_CMN_RG_ROUND_LINES 24 Stores line details considered for tax rounding
JAI_CMN_RG_SLNOS 12 This table stores the running balance for the RG and PLA registers
JAI_CMN_RG_TRANSFERS 16 Stores transfers of funds between registers of same/different organizations
JAI_CMN_STFORM_HDRS_ALL 13 Stores header info of sales tax discount forms for both vendors and customers
JAI_CMN_ST_FORMS 13 Stores information pertaining to the ST Forms
JAI_CMN_ST_FORM_DTLS 30 Stores details of ST Forms tracking in Payables and Receivables transactions
JAI_CMN_ST_MATCH_DTLS 10 Stores information pertaining to the Sales Tax Matched Details.
JAI_CMN_TAXCTG_UPDATES 11 This table stores details of tax updates in tax categories
JAI_CMN_TAXES_ALL 57 Master table for Localization Taxes
JAI_CMN_TAX_CTGS_ALL 16 Stores tax categories and their link to excise ITEM classes.
JAI_CMN_TAX_CTG_LINES 19 Stores the tax lines for defined tax categories
JAI_CMN_TAX_TYPES_ALL 15 This table is used for storing the tax type definition for the GST
JAI_CMN_TRANSACTIONS_T 15 Stores transaction data temporarily during sub inventory and move orders
JAI_CMN_VENDOR_SITES 44 Stores excise account related information about vendors.
JAI_CMN_WRITEOFFS_T 21 Temporary table, which stores the write offs corresponding to the a BOE
JAI_CRM_QUOTE_TAXES 24 Stores the quote tax information.
JAI_CR_OPEN_BALANCES_GT 5 The table 'JAI_CR_OPEN_BALANCES_GT' is a global temporary table. It is used for India - Creditors Ledger report of calculating the opening b
JAI_DIST_TAX_TYPE 11 This table stores details of tax types that can be set off against each other
JAI_DTC_ROUNDING_SETUPS 13 This table stores the rounding setup for Taxable Basis and Tax by Legal Entity
JAI_DTC_SCTN_ACCOUNT_MAPPING 12 This table stores the mapping between TDS Section Code and Natural Accounts by Legal Entity.
JAI_ENCUM_TAX_DETAILS 15 This table is used to capture the tax amount used for encumbrance
JAI_ENCUM_TAX_RVRSL_DTLS 12 Contains the details of the tax used for Encumbrance Reversal
JAI_FA_AST_BLOCKS 18 This table stores the information regarding the Block of Asset classification.
JAI_FA_AST_BLOCK_DTLS 16 Created for India B of Assets DFF Elimination
JAI_FA_AST_BLOCK_H 12 Stores the Asset block transaction history information.
JAI_FA_AST_PERIOD_RATES 14 Table gives periodwise classification of depreciation applicability, write off.
JAI_FA_AST_YEARS 9 Table stores the year startdate and the enddate. The period rates are defined.
JAI_FA_DEP_BLOCKS 13 Stores depreciation fordifferent blocks for specifc year identified by year end
JAI_FA_DEP_BLOCKS_T 14 This is a temporary table that stores the value of the depreciation.
JAI_FA_EXEMPTIONS 9 Stores the Exemptions corresponding to the FA Asset Blocks
JAI_FA_MASS_ADDITIONS 24 Stores payable invoicedetails for assets,which added as a part of bulk import.
JAI_FBT_PAYMENT 23 This table stores the payment information of FBT tax. Its data is mainly populated by the 'India - Fringe Benefit Tax Payment Process'
JAI_FBT_PROCESS_DATE 13 The table is storing the information of last running date of the concurrent 'India-Fringe Benefit Tax Processing'. There will be an only rec
JAI_FBT_REPOSITORY 39 This table is used to store all the transactions that attract Fringe Benefit Tax
JAI_FBT_SETTLEMENT 20 This table is used to store the quarterly settlements for Fringe Benefit Tax
JAI_FBT_SETUP 16 This table is used to store the Setup information related with Fringe Benefit Tax
JAI_FBT_SETUP_HEADERS 16 The table stores the FBT setup information in header level, including Legal entity, FBT year, and tax rate of each tax type.
JAI_FBT_SETUP_LINES 10 This table is storing the FBT setup line information, such as FBT type code, natural account and taxable basis. The combination of legal_ent
JAI_FORM27_AMT_REC_DEBIT 6 Stores TCS Amount Received/Debited
JAI_GST_YEARS 11 This table is used for storing the information of GST tax calendar
JAI_IM_TAX_MAPPING 12 This is a mapping table to store the mapping relation between the external customer tax code and system tax code supported in Oracle Financi
JAI_INTERFACE_ERR_LINES 28 This is an error logging table to log the errors during the validation of OFI tax import concurrent, India Interface Tax Import
JAI_INTERFACE_LINES_ALL 48 This is an interface table to store the transaction data which are populated by customers program.
JAI_INTERFACE_TAX_LINES_ALL 33 This is a tax table to store taxes attached to transactions, and these taxes are populated by the customers program or manual input.
JAI_INV_ITM_SETUPS 15 Table stores about localization item attributes defined for item at org level.
JAI_INV_ITM_TAXCTG_DTLS 9 This table stores info about the items and the tax category attached to it.
JAI_INV_ITM_TAXCTG_HDRS 9 This table stores information about the item tax category list.
JAI_INV_SUBINV_DTLS 11 Stores information of sub inventories belonging to an organization and location.
JAI_INV_SUBINV_HDRS 8 Setup table that associates sub inventories with organization and location
JAI_INV_TXN_EXT_DTLS 12 Table stores detailed info corresponding to Info in JAI_INV_TXN_EXT_HDRS
JAI_INV_TXN_EXT_HDRS 13 This table stores the Extensions for the different Customers/Vendors
JAI_MTL_MATCH_RECEIPTS 23 This table stores information related to receipts matched for claiming excise and VAT for capital goods during inter organization transfer
JAI_MTL_TRXS 30 This table holds India tax related data pertaining to inter organization transfers done
JAI_MTL_TRX_JRNLS 28 This table holds the accounting information related to inter organization transfers done
JAI_MTL_TXN_CST_DTL_T 10 Replica for the Data inserted by IL into the MTL_TXN_COST_DET_INTERFACE
JAI_MTL_TXN_CST_HDR_T 31 Replica of the data inserted by IL into the Table MTL_TRANSACTIONS_INTERFACE
JAI_OM_LC_AMENDMENTS 30 This table holds the details of the Quantity or date amendments made to the LC.
JAI_OM_LC_HDRS 42 Table contains Letter of credit details regarding Customer,Balance etc
JAI_OM_LC_MATCHINGS 20 Contains Order Header Identifier for LC matched orders
JAI_OM_OE_BOND_REG_DTLS 9 Hold Information about Order/Invoice types
JAI_OM_OE_BOND_REG_HDRS 14 This table holds the details of register types for an organization and location.
JAI_OM_OE_BOND_TRXS 21 Contains information regarding bond transactions like bond amount etc.
JAI_OM_OE_GEN_TAXINV_T 16 Holds delivery identifier for which excise invoice no. to be generated
JAI_OM_OE_RMA_LINES 43 This table holds the line details of the return orders.
JAI_OM_OE_RMA_TAXES 26 This table holds the tax details associated with a return order.
JAI_OM_OE_SO_LINES 52 Stores localization information for the sales orders.
JAI_OM_OE_SO_TAXES 27 Stores tax lines corresponding to the order lineidentifier.
JAI_OM_REP_JAINEXFR_T 28 Intermediate table used in transaction processing to hold balance and tax record
JAI_OM_WSH_LINES_ALL 70 Capture localization information picking line wise.
JAI_OM_WSH_LINE_TAXES 27 Stores information for the tax lines corresponding to the picking line.
JAI_OPM_CM_ADJS_DTL 20 This table stores the cost adjustment details as part of OPM Costing
JAI_OPM_OSP_DTLS 21 This table stores the OSP details against an OSP header.
JAI_OPM_OSP_EXC_RATES 9 This table stores the details of OSP rates.
JAI_OPM_OSP_HDRS 28 This is the header table for storing OSP information
JAI_OPM_OSP_REG_SELS 11 This table stores the Excise tax type breakup for an OSP transaction.
JAI_OPM_TXN_EXTN_DTLS 12 Stores the Information about time extension for transactions
JAI_OPM_TXN_EXTN_HDRS 13 Stores the header information of time extenstion given to transaction
JAI_PA_DRAFT_INVOICES 25 This table stores draft invoice header attributes related to india localization
JAI_PA_DRAFT_INVOICE_LINES 19 This table stores draft invoice line attributes related to india localization
JAI_PA_SETUP_CONTEXTS 19 This table is responsible for Setup Context Types and Attribute Description
JAI_PA_SETUP_PREFERENCES 11 This table is stored the preferences of Context Type based on distribution Rule
JAI_PA_SETUP_VALUES 20 This table is Responsible for Attachemnt of Tax Category with Context Types
JAI_PA_TAX_TRXS 114 This Table is used to store Tax Records interfaced to Projects Costing
JAI_PO_COPYDOC_T 15 Temporary table used to store data of Purchase orders during Copy functionality.
JAI_PO_COPY_T 15 This is a temporary table which will get populated for copy document
JAI_PO_LINE_LOCATIONS 37 This table stores the localization information at PO line shipment level.
JAI_PO_OSP_BOM_T 11 This table holds outside processing Bill of material temporary information
JAI_PO_OSP_CENVAT_DTLS 22 Holds outside processing cenvat detail information
JAI_PO_OSP_CENVAT_HDRS 27 This table holds outside processing cenvat header information
JAI_PO_OSP_FORM_NUMBERS 11 Holds unique combination of OrganizationID, LocationID, Fin_Year as 57F4 Form No
JAI_PO_OSP_HDRS 36 Stores 57F4 Header Information for Purchase Orders of type OSP.
JAI_PO_OSP_ITM_DTLS 12 Stores the OSP Assembly components information from which the assembly is made.
JAI_PO_OSP_ITM_HDRS 10 Stores the India Localization OSP Item Assembly details for an organization.
JAI_PO_OSP_LINES 31 Stores Line Level Information of the 57F4 Form.
JAI_PO_OSP_LINE_DTLS 14 Stores the information of the 57F4 Line Details.
JAI_PO_QUOT_LINES_T 17 Holds data for Concurrent Request to default tax when linked with Quotation
JAI_PO_REP_PRRG_T 40 Used as a intermediate table for holding the purchase register report details
JAI_PO_REQUEST_T 32 Used by JAINPOCR concurrent for defaulting taxes
JAI_PO_REQ_LINES 15 Stores the localization information of requisition lines and tax amounts
JAI_PO_REQ_LINE_TAXES 30 Stores the data pertaining to the Taxes in the Requisition.
JAI_PO_RMA_RTN_LINES 21 Holds details about RMA Receipts created by trigger on mtl_material_transactions
JAI_PO_RMA_RTN_TX_LNS 24 Holds RMA Return lines Tax Information
JAI_PO_TAXES 32 Stores the information of localization tax lines at a PO line location level.
JAI_RCV_CENVAT_CLAIMS 26 Holds details about cenvat % claimed for a receipt for Manufacturing Org.
JAI_RCV_CENVAT_CLAIM_T 18 Contains information about modvat claim. Source is Claim Modvat on receipt
JAI_RCV_HEADERS 38 India Localization Receipts Header Table same as RCV_SHIPMENT_HEADERS
JAI_RCV_INTERFACE_TRXS 13 India Localization Receipt Transaction Interface table
JAI_RCV_JOURNAL_ENTRIES 27 Stores journal Entry information
JAI_RCV_LINES 50 Stores localization related info for the receipt line.
JAI_RCV_LINE_TAXES 45 This Table holds the Information of the Receipt Taxes.
JAI_RCV_REP_ACCRUAL_T 8 Contains details of Tax for all Receiving-RTV Transactions
JAI_RCV_RGM_CLAIMS 26 Stores the details of receipt claims by regime.
JAI_RCV_RGM_LINES 47 Stores the Line information of receipt claims.
JAI_RCV_RTV_BATCH_GRPS 15 Stores Invoice Lines created as part of Third Party Receipt Taxes
JAI_RCV_RTV_BATCH_TRXS 19 RTV Batch Transactions
JAI_RCV_RTV_DTLS 12 Stores the parent transaction identifier for the return to vendor transaction
JAI_RCV_SUBLED_ENTRIES 69 Localization table similar to Base Apps rcv_receiving_sub_ledger.
JAI_RCV_TP_BATCHES 15 Holds details of receipts processed against run of third party invoices batch.
JAI_RCV_TP_INVOICES 19 Holds all the third party invoices generated by India Local third party batch.
JAI_RCV_TP_INV_DETAILS 15 Stores Invoice Lines created as part of Third Party Receipt Taxes
JAI_RCV_TRANSACTIONS 79 Holds receiving transaction records information.
JAI_RETRO_LINE_CHANGES 31 This table is used to store the Retroactive changes made for documents
JAI_RETRO_TAX_CHANGES 18 This table is used to store the Retroactive changes made for document taxes
JAI_RGM_BALANCE_T 23 Stores Debit and credit balances for every org and location for every tax type
JAI_RGM_CERTIFICATES 26 This table stores the certificate information of Customers.
JAI_RGM_CONC_REQUESTS 16 Stores the Requests information submitted for India - Service Tax Processing
JAI_RGM_DEFINITIONS 12 Stores regime information.
JAI_RGM_DIS_DES_HDRS 14 Stores details of destination organization which will receive the transfer
JAI_RGM_DIS_DES_TAXES 13 This table has the details of the destination taxes and transfer amounts.
JAI_RGM_DIS_SRC_HDRS 15 Stores details of the source organization where distribution transaction is done
JAI_RGM_DIS_SRC_TAXES 14 Stores taxes and amounts transferred from the source organization.
JAI_RGM_DOC_SEQ_DTLS 14 Stores Doc details to generate the VAT invoice number for Document Setup
JAI_RGM_DOC_SEQ_HDRS 15 Stores regimeidentifier, party_id and party_site_id info for Document Seq Setup
JAI_RGM_GST_INVOICE_GEN_T 27
JAI_RGM_INVOICE_GEN_T 29 Stores VAT accounted or VAT invoice number to be generated records
JAI_RGM_ITEM_GEN_DOCS 14 This table stores the information regarding documents generated for TCS Processing
JAI_RGM_ITM_REGNS 10 Item specific attribute regisation header table
JAI_RGM_ITM_TEMPLATES 10 Template definitions for item attributes for regime are stored in this table
JAI_RGM_ITM_TMPL_ATTRS 11 Item or Template specific attributes are stored in this table.
JAI_RGM_LOOKUPS 14 Lookup values for regime
JAI_RGM_MANUAL_TRXS 20 Captures manual transactions made for Service Tax and VAT.
JAI_RGM_PARTIES 14 Organization association with regime is stored in this table
JAI_RGM_PARTY_REGNS 10 Only Organization specific registrations for regime are stored in this table
JAI_RGM_REFS_ALL 36 This table stores transactions with TCS type of Tax. This is a TCS repository
JAI_RGM_REGISTRATIONS 15 Stores the regime attribute information
JAI_RGM_SETTLEMENTS 24 Stores the settlement information by tax regime
JAI_RGM_STL_BALANCES 17 Stores the Settlement details by settlement of regime for each period
JAI_RGM_TAXES 16 This table stores tax details for transactions having TCS tax type.
JAI_RGM_TERMS 18 Stores Term definitions
JAI_RGM_TERM_ASSIGNS 14 Stores the term assignments to default at various hierarchial levels
JAI_RGM_TERM_INSTALLMENTS 14
JAI_RGM_THRESHOLDS 16 This table stores threshold amount for ORG_TAN_NUM ,PARTY_PAN_NUM and FIN_YEAR
JAI_RGM_THRESHOLD_DTLS 19 This table stores classification details for each threshold header
JAI_RGM_TMPL_ITM_REGNS 9 Item association with template organization association is stored in this table
JAI_RGM_TMPL_ORG_REGNS 9 Organization association with template is stored in this table
JAI_RGM_TRM_SCHEDULES_T 10 Temporary table to store installment details and populated by jai_rgm_terms_pkg
JAI_RGM_TRX_RECORDS 62 Repository to store recovery and liabilities due to taxes of different regimes
JAI_RGM_TRX_REFS 32 Stores the tax information of AP and AR invoices for Service Tax
JAI_RTP_POPULATE_T 9
JAI_RTP_TRANS_T 10
JAI_ST_INVOICE_REVERSAL 46 This table contains the reversal transactions after reversal for service tax.
JAI_ST_INVOICE_REVERSAL_GT 18
JAI_TDS_SECTION_MAPPING 3
JAI_TRX_GT 90
JAI_TRX_REPO_EXTRACT_GT 31
JAI_WSH_DEL_DETAILS_GT 9 This is temporary table to store the shipped quantity
JAI_WSH_EXCEPTIONS_T 12 Table to store the exceptions occurred on shipping
JAI_XLA_TRIAL_BALANCES_GT 15 The table 'JAI_XLA_TRIAL_BALANCES_GT' is a global temporary table. It is used of India - Creditors Trial Balance Report
JA_AU_ACCOUNT_DEFAULTS 9 AutoAccounting setup information
JA_AU_ACCT_DEFAULT_SEGS 11 AutoAccounting segment setup
JA_AU_BAL_CHG_APPLIED 26 Balancing charge applications
JA_AU_BAL_CHG_INTERFACE 28 Balancing charges information imported from external systems
JA_AU_BAL_CHG_SOURCE 29 Balancing charge source information
JA_AU_CAPITAL_VALUE 26 Capital Gains Tax information
JA_AU_FA_BOOK_CONTROLS 7 Balancing charge book controls
JA_AU_SRW_TAX_DEPRN_TMP 25 Australian Schedule 32 report temporary table
JA_AU_SUBINV_LOC_ASSOCS 8 Subinventory and location associations
JA_CN_ACCOUNTING_CLASSES_ALL 7 The 'JA_CN_ACCOUNTING_CLASSES_ALL' stores information to indicate cash related accounting classes for the Chart of Accounts.
JA_CN_ACCOUNT_BALANCES 61 The table 'JA_CN_ACCOUNT_BALANCES_GT' is a global temporary table used by posting journal to balance.
JA_CN_ACCOUNT_BALANCES_GT 55 JA_CN_ACCOUNT_BALANCES_GT is a session level global temporary table which stores combined account balances before they are exported to flat
JA_CN_ACCOUNT_BALANCES_POST_GT 62 The table 'JA_CN_ACCOUNT_BALANCES' stores beginning balance, period net DR amount, period net CR amount and ending balance for nature accoun
JA_CN_ACCOUNT_CHILDREN_GT 4 The 'JA_CN_ACCOUNT_CHILDREN_GT' table is a global temporary table on session level, which is to store the relationship of parent account and
JA_CN_ACCOUNT_STRUCTURES 27 The table 'JA_CN_ACCOUNT_STRUCTURES' is a combination table to implement Key Flexfield for the field 'ACCOUNT_STRUCTURE' on 'Subsidiary Acco
JA_CN_BANK_AVG_BAL_GT 9
JA_CN_BANK_BALANCE_GT 12
JA_CN_BANK_JOURNAL 8
JA_CN_BANK_LE_GT 3
JA_CN_CASH_ACCOUNTS_ALL 25 The 'JA_CN_CASH_ACCOUNTS_ALL' stores information to indicate cash related account for the Chart of Accounts, all account segment values in t
JA_CN_CASH_VALUESETS_ALL 7 The 'JA_CN_CASH_VALUESETS_ALL' stores information to indicate cash related value sets for the Chart of Accounts.
JA_CN_CFS_ACTIVITIES_ALL 47 The 'JA_CN_CFS_ACTIVITIES_ALL' table stores transaction information related to detailed cash flow items, data in the table are based on deta
JA_CN_CFS_ACTIVITIES_INTERFACE 36 The 'JA_CN_CFS_ACTIVITIES_INTERFACE' table is the interface table that stores transaction information related to detailed cash flow items, d
JA_CN_CFS_ASSIGNMENTS_ALL 10 The 'JA_CN_CFS_ASSIGNMENTS_ALL' table stores information about detailed cash flow item assignments for cash flow items that are displayed in
JA_CN_CFS_ASSIGN_SUP_ALL 10 The 'JA_CN_CFS_ASSIGN_SUP_ALL' table stores the information of Cash Flow Statement in/out flow and the source, in other words this table sto
JA_CN_CFS_CALCULATIONS_GT 8 The 'JA_CN_CFS_CALCULATIONS_GT' table is a global temporary table on session level, which is to store calculation lines for items that have
JA_CN_CFS_ITEM_MAPPING_HDRS 14 The table stores the header information for cash flow item mapping. Each row includes Chart of Account ID, application id, event class code,
JA_CN_CFS_ITEM_MAPPING_LINES 11 This table stores the mapping relationship between cash flow item and the value of source. There is a one-to-many relationship between the c
JA_CN_CFS_ROW_CGS_GT 13 The 'JA_CN_CFS_ROW_CGS_GT' table is a global temporary table on session level, which is to store category and amount information for rows in
JA_CN_COA_NA_EXCEPTIONS 11 The table 'JA_CN_COA_NA_EXCEPTIONS' stores natural accounts with invalid length. Each row includes column ACCOUNT_SEGMENT, which can identif
JA_CN_DEP_METH_ASSIGNMENT 11 This table 'JA_CN_DEP_METH_ASSIGNMENT' stores information to indicate the depreciation method for CNAOv2 .
JA_CN_DFF_ASSIGNMENTS 11 The table 'JA_CN_DFF_ASSIGNMENTS' stores context codes and column names for all Descriptive Flexfield used by programs of the Solution for C
JA_CN_ERROR_ACCOUNTS 26 JA_CN_ERROR_ACCOUNTS stores error accounts, which have abnormal balances. The XML data template 'Account Balance Export Exception Report' wi
JA_CN_FA_CATEGORY_GT 7 The 'JA_CN_FA_CATEGORY_GP' table stores fixed asset category code and fixed asset category name to filter the same asset category.
JA_CN_ITEM_INTERFACE 54 The 'JA_CN_ITEM_INTERFACE' table is the interface table. It will store the journals that user imported by manual. Data in this table will be
JA_CN_JOURNALS_OF_PERIOD 8 The 'JA_CN_JOURNALS_OF_PERIOD' table temporarily stores journals that are not itemized by possible subsidiary of current legal entity.
JA_CN_JOURNAL_LINES 71 The 'JA_CN_JOURNAL_LINES' table stores GL journal lines with information of related subsidiary accounts if any.
JA_CN_JOURNAL_LINES_GT 59 JA_CN_JOURNAL_LINES_GT is a session level global temporary table which stores combined journal lines before they are exported to flat file.
JA_CN_JOURNAL_LINES_REQ 74 The 'JA_CN_JOURNAL_LINES_REQ' table stores temporarily journal lines of current session, which itemized with information of related subsidia
JA_CN_JOURNAL_NUMBERING 9 The 'JA_CN_JOURNAL_NUMBERING' table store next available numbers by Legal Entities and GL periods, the 'Account and Journal Itemization Prog
JA_CN_LEDGER_LE_BSV_GT 9 JA_CN_LEDGER_LE_BSV_GT is a global temporary table. This table is used to populate Balance Segment Values for current Legal Entity and Ledge
JA_CN_PERIODS 14 The 'JA_CN_PERIODS' table stores information about the accounting period. The journals itemized by subsidiary are in these accounting period
JA_CN_SI_CURRENCIES_GT 3
JA_CN_SOURCES_ALL 18 The 'JA_CN_SOURCES_ALL' table stores information of the project accounting, supplier, customer and third party, including the project accoun
JA_CN_SUBSIDIARY_GT 8 JA_CN_SUBSIDIARY_GT is a session level global temporary table, which stores subsidiary info for each natural account. These data will be use
JA_CN_SUB_ACC_MAPPING 9 The 'JA_CN_SUB_ACC_MAPPING' table stores information defined by 'Subsidiary Account Source' form, this is the previous setting of Data Expor
JA_CN_SUB_ACC_SOURCES_ALL 15 The 'JA_CN_SUB_ACC_SOURCES_ALL' table stores subsidiary source information about project, third party and personnel, and which Key Flexfield
JA_CN_SYSTEM_BANK_PARAMS_ALL 21
JA_CN_SYSTEM_PARAMETERS_ALL 22 The 'JA_CN_SYSTEM_PARAMETERS_ALL' table stores information defined by 'System Options' form, 'Electronic Accounting Book Export' program wil
JA_CN_VOUCHER_BANK_NUM 10
JA_CN_VOUCHER_NUMBER 13 The 'JA_CN_VOUCHER_NUMBER' table stores the voucher number of GL journal lines.