Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - JA Tables and Views

TABLE - JA.JAI_AP_ETDS_ERRORS_T

TABLE - JA.JAI_AP_ETDS_REQUESTS

TABLE - JA.JAI_AP_ETDS_T

TABLE - JA.JAI_AP_INVOICE_LINES

TABLE - JA.JAI_AP_MATCH_ERS_T

TABLE - JA.JAI_AP_MATCH_INV_TAXES

TABLE - JA.JAI_AP_RGM_PAYMENTS

TABLE - JA.JAI_AP_TDS_CERT_NUMS

TABLE - JA.JAI_AP_TDS_DEFAULT

TABLE - JA.JAI_AP_TDS_F16_DTLS_ALL

TABLE - JA.JAI_AP_TDS_F16_HDRS_ALL

TABLE - JA.JAI_AP_TDS_INVOICES

TABLE - JA.JAI_AP_TDS_INV_CANCELS

TABLE - JA.JAI_AP_TDS_INV_PAYMENTS

TABLE - JA.JAI_AP_TDS_INV_TAXES

TABLE - JA.JAI_AP_TDS_PAN_CHANGES

TABLE - JA.JAI_AP_TDS_PAYMENTS

TABLE - JA.JAI_AP_TDS_PREPAYMENTS

TABLE - JA.JAI_AP_TDS_REPOSITORY

TABLE - JA.JAI_AP_TDS_REPO_LINES

TABLE - JA.JAI_AP_TDS_SEC_MAP

TABLE - JA.JAI_AP_TDS_THGRP_AUDITS

TABLE - JA.JAI_AP_TDS_THHOLD_ACCOUNT

TABLE - JA.JAI_AP_TDS_THHOLD_GRPS

TABLE - JA.JAI_AP_TDS_THHOLD_HDRS

TABLE - JA.JAI_AP_TDS_THHOLD_SLABS

TABLE - JA.JAI_AP_TDS_THHOLD_TAXES

TABLE - JA.JAI_AP_TDS_THHOLD_TRXS

TABLE - JA.JAI_AP_TDS_THHOLD_TYPES

TABLE - JA.JAI_AP_TDS_THHOLD_XCEPS

TABLE - JA.JAI_AP_TDS_VENDOR_HDRS

TABLE - JA.JAI_AP_TDS_YEARS

TABLE - JA.JAI_AP_TOL_SETUPS_ALL

TABLE - JA.JAI_AR_CASH_RECEIPTS_ALL

TABLE - JA.JAI_AR_DRB_CLAIMS

TABLE - JA.JAI_AR_ETCS_T

TABLE - JA.JAI_AR_EXCISE_UOM

TABLE - JA.JAI_AR_PAYMENT_AUDITS

TABLE - JA.JAI_AR_REC_APPL_AUDITS

TABLE - JA.JAI_AR_SUP_CHANGES_ALL

TABLE - JA.JAI_AR_SUP_HDRS_ALL

TABLE - JA.JAI_AR_SUP_INV_T

TABLE - JA.JAI_AR_SUP_LINES

TABLE - JA.JAI_AR_SUP_TAXES

TABLE - JA.JAI_AR_TDS_CERTIFICATES

TABLE - JA.JAI_AR_TRXS

TABLE - JA.JAI_AR_TRX_CM_T

TABLE - JA.JAI_AR_TRX_COPY_HDR_T

TABLE - JA.JAI_AR_TRX_INS_HDRS_T

TABLE - JA.JAI_AR_TRX_INS_LINES_T

TABLE - JA.JAI_AR_TRX_LINES

TABLE - JA.JAI_AR_TRX_POE_DTLS

TABLE - JA.JAI_AR_TRX_SUP_INV_T

TABLE - JA.JAI_AR_TRX_TAX_CALC_T

TABLE - JA.JAI_AR_TRX_TAX_LINES

TABLE - JA.JAI_AR_TRX_UPDATE_T

TABLE - JA.JAI_BOE_DETAILS

TABLE - JA.JAI_BOE_DETAIL_TAXES

TABLE - JA.JAI_BOE_DOCUMENTS

TABLE - JA.JAI_BOE_MATCHING_TAXES

TABLE - JA.JAI_BOE_MIGRATION_TEMP

TABLE - JA.JAI_BOE_ROUNDINGS

TABLE - JA.JAI_BOE_WRITEOFF_TAXES

TABLE - JA.JAI_BOM_FINISHED_GOODS

TABLE - JA.JAI_BOM_RAW_MATERIALS

TABLE - JA.JAI_CMN_BOE_AGENTS

TABLE - JA.JAI_CMN_BOE_DTLS

TABLE - JA.JAI_CMN_BOE_HDRS_ALL

TABLE - JA.JAI_CMN_BOE_MATCHINGS

TABLE - JA.JAI_CMN_BOE_WRITEOFFS

TABLE - JA.JAI_CMN_CUS_ADDRESSES

TABLE - JA.JAI_CMN_DEBUG_CONTEXTS

TABLE - JA.JAI_CMN_DOCUMENT_TAXES

TABLE - JA.JAI_CMN_ERRORS_T

TABLE - JA.JAI_CMN_FIN_YEARS

TABLE - JA.JAI_CMN_INVENTORY_ORGS

TABLE - JA.JAI_CMN_JOURNAL_ENTRIES

TABLE - JA.JAI_CMN_LINES

TABLE - JA.JAI_CMN_MATCH_RECEIPTS

TABLE - JA.JAI_CMN_MATCH_TAXES

TABLE - JA.JAI_CMN_MTAX_HDRS_ALL

TABLE - JA.JAI_CMN_MTAX_UPD_DTLS

TABLE - JA.JAI_CMN_OM_AR_AR3_FORMS

TABLE - JA.JAI_CMN_RG_23AC_II_TRXS

TABLE - JA.JAI_CMN_RG_23AC_I_TRXS

TABLE - JA.JAI_CMN_RG_23D_TRXS

TABLE - JA.JAI_CMN_RG_BALANCES

TABLE - JA.JAI_CMN_RG_COMP_BALS

TABLE - JA.JAI_CMN_RG_COMP_DTLS

TABLE - JA.JAI_CMN_RG_CONSLDATIONS

TABLE - JA.JAI_CMN_RG_EXC_INV_NOS

TABLE - JA.JAI_CMN_RG_I_TRXS

TABLE - JA.JAI_CMN_RG_OTHERS

TABLE - JA.JAI_CMN_RG_OTH_BALANCES

TABLE - JA.JAI_CMN_RG_PERIOD_BALS

TABLE - JA.JAI_CMN_RG_PLA_CMP_DTLS

TABLE - JA.JAI_CMN_RG_PLA_DTLS

TABLE - JA.JAI_CMN_RG_PLA_HDRS

TABLE - JA.JAI_CMN_RG_PLA_TRXS

TABLE - JA.JAI_CMN_RG_ROUND_HDRS

TABLE - JA.JAI_CMN_RG_ROUND_LINES

TABLE - JA.JAI_CMN_RG_SLNOS

TABLE - JA.JAI_CMN_RG_TRANSFERS

TABLE - JA.JAI_CMN_STFORM_HDRS_ALL

TABLE - JA.JAI_CMN_ST_FORMS

TABLE - JA.JAI_CMN_ST_FORM_DTLS

TABLE - JA.JAI_CMN_ST_MATCH_DTLS

TABLE - JA.JAI_CMN_TAXCTG_UPDATES

TABLE - JA.JAI_CMN_TAXES_ALL

TABLE - JA.JAI_CMN_TAX_CTGS_ALL

TABLE - JA.JAI_CMN_TAX_CTG_LINES

TABLE - JA.JAI_CMN_TAX_TYPES_ALL

TABLE - JA.JAI_CMN_TRANSACTIONS_T

TABLE - JA.JAI_CMN_VENDOR_SITES

TABLE - JA.JAI_CMN_WRITEOFFS_T

TABLE - JA.JAI_CRM_QUOTE_TAXES

TABLE - JA.JAI_CR_OPEN_BALANCES_GT

TABLE - JA.JAI_DIST_TAX_TYPE

TABLE - JA.JAI_DTC_ROUNDING_SETUPS

TABLE - JA.JAI_DTC_SCTN_ACCOUNT_MAPPING

TABLE - JA.JAI_ENCUM_TAX_DETAILS

TABLE - JA.JAI_ENCUM_TAX_RVRSL_DTLS

TABLE - JA.JAI_FA_AST_BLOCKS

TABLE - JA.JAI_FA_AST_BLOCK_DTLS

TABLE - JA.JAI_FA_AST_BLOCK_H

TABLE - JA.JAI_FA_AST_PERIOD_RATES

TABLE - JA.JAI_FA_AST_YEARS

TABLE - JA.JAI_FA_DEP_BLOCKS

TABLE - JA.JAI_FA_DEP_BLOCKS_T

TABLE - JA.JAI_FA_EXEMPTIONS

TABLE - JA.JAI_FA_MASS_ADDITIONS

TABLE - JA.JAI_FBT_PAYMENT

TABLE - JA.JAI_FBT_PROCESS_DATE

TABLE - JA.JAI_FBT_REPOSITORY

TABLE - JA.JAI_FBT_SETTLEMENT

TABLE - JA.JAI_FBT_SETUP

TABLE - JA.JAI_FBT_SETUP_HEADERS

TABLE - JA.JAI_FBT_SETUP_LINES

TABLE - JA.JAI_FORM27_AMT_REC_DEBIT

TABLE - JA.JAI_GST_YEARS

TABLE - JA.JAI_IM_TAX_MAPPING

TABLE - JA.JAI_INTERFACE_ERR_LINES

TABLE - JA.JAI_INTERFACE_LINES_ALL

TABLE - JA.JAI_INTERFACE_TAX_LINES_ALL

TABLE - JA.JAI_INV_ITM_SETUPS

TABLE - JA.JAI_INV_ITM_TAXCTG_DTLS

TABLE - JA.JAI_INV_ITM_TAXCTG_HDRS

TABLE - JA.JAI_INV_SUBINV_DTLS

TABLE - JA.JAI_INV_SUBINV_HDRS

TABLE - JA.JAI_INV_TXN_EXT_DTLS

TABLE - JA.JAI_INV_TXN_EXT_HDRS

TABLE - JA.JAI_MTL_MATCH_RECEIPTS

TABLE - JA.JAI_MTL_TRXS

TABLE - JA.JAI_MTL_TRX_JRNLS

TABLE - JA.JAI_MTL_TXN_CST_DTL_T

TABLE - JA.JAI_MTL_TXN_CST_HDR_T

TABLE - JA.JAI_OM_LC_AMENDMENTS

TABLE - JA.JAI_OM_LC_HDRS

TABLE - JA.JAI_OM_LC_MATCHINGS

TABLE - JA.JAI_OM_OE_BOND_REG_DTLS

TABLE - JA.JAI_OM_OE_BOND_REG_HDRS

TABLE - JA.JAI_OM_OE_BOND_TRXS

TABLE - JA.JAI_OM_OE_GEN_TAXINV_T

TABLE - JA.JAI_OM_OE_RMA_LINES

TABLE - JA.JAI_OM_OE_RMA_TAXES

TABLE - JA.JAI_OM_OE_SO_LINES

TABLE - JA.JAI_OM_OE_SO_TAXES

TABLE - JA.JAI_OM_REP_JAINEXFR_T

TABLE - JA.JAI_OM_WSH_LINES_ALL

TABLE - JA.JAI_OM_WSH_LINE_TAXES

TABLE - JA.JAI_OPM_CM_ADJS_DTL

TABLE - JA.JAI_OPM_OSP_DTLS

TABLE - JA.JAI_OPM_OSP_EXC_RATES

TABLE - JA.JAI_OPM_OSP_HDRS

TABLE - JA.JAI_OPM_OSP_REG_SELS

TABLE - JA.JAI_OPM_TXN_EXTN_DTLS

TABLE - JA.JAI_OPM_TXN_EXTN_HDRS

TABLE - JA.JAI_PA_DRAFT_INVOICES

TABLE - JA.JAI_PA_DRAFT_INVOICE_LINES

TABLE - JA.JAI_PA_SETUP_CONTEXTS

TABLE - JA.JAI_PA_SETUP_PREFERENCES

TABLE - JA.JAI_PA_SETUP_VALUES

TABLE - JA.JAI_PA_TAX_TRXS

TABLE - JA.JAI_PO_COPYDOC_T

TABLE - JA.JAI_PO_COPY_T

TABLE - JA.JAI_PO_LINE_LOCATIONS

TABLE - JA.JAI_PO_OSP_BOM_T

TABLE - JA.JAI_PO_OSP_CENVAT_DTLS

TABLE - JA.JAI_PO_OSP_CENVAT_HDRS

TABLE - JA.JAI_PO_OSP_FORM_NUMBERS

TABLE - JA.JAI_PO_OSP_HDRS

TABLE - JA.JAI_PO_OSP_ITM_DTLS

TABLE - JA.JAI_PO_OSP_ITM_HDRS

TABLE - JA.JAI_PO_OSP_LINES

TABLE - JA.JAI_PO_OSP_LINE_DTLS

TABLE - JA.JAI_PO_QUOT_LINES_T

TABLE - JA.JAI_PO_REP_PRRG_T

TABLE - JA.JAI_PO_REQUEST_T

TABLE - JA.JAI_PO_REQ_LINES

TABLE - JA.JAI_PO_REQ_LINE_TAXES

TABLE - JA.JAI_PO_RMA_RTN_LINES

TABLE - JA.JAI_PO_RMA_RTN_TX_LNS

TABLE - JA.JAI_PO_TAXES

TABLE - JA.JAI_RCV_CENVAT_CLAIMS

TABLE - JA.JAI_RCV_CENVAT_CLAIM_T

TABLE - JA.JAI_RCV_HEADERS

TABLE - JA.JAI_RCV_INTERFACE_TRXS

TABLE - JA.JAI_RCV_JOURNAL_ENTRIES

TABLE - JA.JAI_RCV_LINES

TABLE - JA.JAI_RCV_LINE_TAXES

TABLE - JA.JAI_RCV_REP_ACCRUAL_T

TABLE - JA.JAI_RCV_RGM_CLAIMS

TABLE - JA.JAI_RCV_RGM_LINES

TABLE - JA.JAI_RCV_RTV_BATCH_GRPS

TABLE - JA.JAI_RCV_RTV_BATCH_TRXS

TABLE - JA.JAI_RCV_RTV_DTLS

TABLE - JA.JAI_RCV_SUBLED_ENTRIES

TABLE - JA.JAI_RCV_TP_BATCHES

TABLE - JA.JAI_RCV_TP_INVOICES

TABLE - JA.JAI_RCV_TP_INV_DETAILS

TABLE - JA.JAI_RCV_TRANSACTIONS

TABLE - JA.JAI_RETRO_LINE_CHANGES

TABLE - JA.JAI_RETRO_TAX_CHANGES

TABLE - JA.JAI_RGM_BALANCE_T

TABLE - JA.JAI_RGM_CERTIFICATES

TABLE - JA.JAI_RGM_CONC_REQUESTS

TABLE - JA.JAI_RGM_DEFINITIONS

TABLE - JA.JAI_RGM_DIS_DES_HDRS

TABLE - JA.JAI_RGM_DIS_DES_TAXES

TABLE - JA.JAI_RGM_DIS_SRC_HDRS

TABLE - JA.JAI_RGM_DIS_SRC_TAXES

TABLE - JA.JAI_RGM_DOC_SEQ_DTLS

TABLE - JA.JAI_RGM_DOC_SEQ_HDRS

TABLE - JA.JAI_RGM_GST_INVOICE_GEN_T

TABLE - JA.JAI_RGM_INVOICE_GEN_T

TABLE - JA.JAI_RGM_ITEM_GEN_DOCS

TABLE - JA.JAI_RGM_ITM_REGNS

TABLE - JA.JAI_RGM_ITM_TEMPLATES

TABLE - JA.JAI_RGM_ITM_TMPL_ATTRS

TABLE - JA.JAI_RGM_LOOKUPS

TABLE - JA.JAI_RGM_MANUAL_TRXS

TABLE - JA.JAI_RGM_PARTIES

TABLE - JA.JAI_RGM_PARTY_REGNS

TABLE - JA.JAI_RGM_REFS_ALL

TABLE - JA.JAI_RGM_REGISTRATIONS

TABLE - JA.JAI_RGM_SETTLEMENTS

TABLE - JA.JAI_RGM_STL_BALANCES

TABLE - JA.JAI_RGM_TAXES

TABLE - JA.JAI_RGM_TERMS

TABLE - JA.JAI_RGM_TERM_ASSIGNS

TABLE - JA.JAI_RGM_TERM_INSTALLMENTS

TABLE - JA.JAI_RGM_THRESHOLDS

TABLE - JA.JAI_RGM_THRESHOLD_DTLS

TABLE - JA.JAI_RGM_TMPL_ITM_REGNS

TABLE - JA.JAI_RGM_TMPL_ORG_REGNS

TABLE - JA.JAI_RGM_TRM_SCHEDULES_T

TABLE - JA.JAI_RGM_TRX_RECORDS

TABLE - JA.JAI_RGM_TRX_REFS

TABLE - JA.JAI_RTP_POPULATE_T

TABLE - JA.JAI_RTP_TRANS_T

TABLE - JA.JAI_ST_INVOICE_REVERSAL

TABLE - JA.JAI_ST_INVOICE_REVERSAL_GT

TABLE - JA.JAI_TDS_SECTION_MAPPING

TABLE - JA.JAI_TRX_GT

TABLE - JA.JAI_TRX_REPO_EXTRACT_GT

TABLE - JA.JAI_WSH_DEL_DETAILS_GT

TABLE - JA.JAI_WSH_EXCEPTIONS_T

TABLE - JA.JAI_XLA_TRIAL_BALANCES_GT

TABLE - JA.JA_AU_ACCOUNT_DEFAULTS

TABLE - JA.JA_AU_ACCT_DEFAULT_SEGS

TABLE - JA.JA_AU_BAL_CHG_APPLIED

TABLE - JA.JA_AU_BAL_CHG_INTERFACE

TABLE - JA.JA_AU_BAL_CHG_SOURCE

TABLE - JA.JA_AU_CAPITAL_VALUE

TABLE - JA.JA_AU_FA_BOOK_CONTROLS

TABLE - JA.JA_AU_SRW_TAX_DEPRN_TMP

TABLE - JA.JA_AU_SUBINV_LOC_ASSOCS

TABLE - JA.JA_CN_ACCOUNTING_CLASSES_ALL

TABLE - JA.JA_CN_ACCOUNT_BALANCES

TABLE - JA.JA_CN_ACCOUNT_BALANCES_GT

TABLE - JA.JA_CN_ACCOUNT_BALANCES_POST_GT

TABLE - JA.JA_CN_ACCOUNT_CHILDREN_GT

TABLE - JA.JA_CN_ACCOUNT_STRUCTURES

TABLE - JA.JA_CN_BANK_AVG_BAL_GT

TABLE - JA.JA_CN_BANK_BALANCE_GT

TABLE - JA.JA_CN_BANK_JOURNAL

TABLE - JA.JA_CN_BANK_LE_GT

TABLE - JA.JA_CN_CASH_ACCOUNTS_ALL

TABLE - JA.JA_CN_CASH_VALUESETS_ALL

TABLE - JA.JA_CN_CFS_ACTIVITIES_ALL

TABLE - JA.JA_CN_CFS_ACTIVITIES_INTERFACE

TABLE - JA.JA_CN_CFS_ASSIGNMENTS_ALL

TABLE - JA.JA_CN_CFS_ASSIGN_SUP_ALL

TABLE - JA.JA_CN_CFS_CALCULATIONS_GT

TABLE - JA.JA_CN_CFS_ITEM_MAPPING_HDRS

TABLE - JA.JA_CN_CFS_ITEM_MAPPING_LINES

TABLE - JA.JA_CN_CFS_ROW_CGS_GT

TABLE - JA.JA_CN_COA_NA_EXCEPTIONS

TABLE - JA.JA_CN_DEP_METH_ASSIGNMENT

TABLE - JA.JA_CN_DFF_ASSIGNMENTS

TABLE - JA.JA_CN_ERROR_ACCOUNTS

TABLE - JA.JA_CN_FA_CATEGORY_GT

TABLE - JA.JA_CN_ITEM_INTERFACE

TABLE - JA.JA_CN_JOURNALS_OF_PERIOD

TABLE - JA.JA_CN_JOURNAL_LINES

TABLE - JA.JA_CN_JOURNAL_LINES_GT

TABLE - JA.JA_CN_JOURNAL_LINES_REQ

TABLE - JA.JA_CN_JOURNAL_NUMBERING

TABLE - JA.JA_CN_LEDGER_LE_BSV_GT

TABLE - JA.JA_CN_PERIODS

TABLE - JA.JA_CN_SI_CURRENCIES_GT

TABLE - JA.JA_CN_SOURCES_ALL

TABLE - JA.JA_CN_SUBSIDIARY_GT

TABLE - JA.JA_CN_SUB_ACC_MAPPING

TABLE - JA.JA_CN_SUB_ACC_SOURCES_ALL

TABLE - JA.JA_CN_SYSTEM_BANK_PARAMS_ALL

TABLE - JA.JA_CN_SYSTEM_PARAMETERS_ALL

TABLE - JA.JA_CN_VOUCHER_BANK_NUM

TABLE - JA.JA_CN_VOUCHER_NUMBER

VIEW - APPS.JAI_57F4_PO_V

VIEW - APPS.JAI_AEL_GL_V

VIEW - APPS.JAI_AEL_SL_V

VIEW - APPS.JAI_AP_BOE_AEL_GL_V

VIEW - APPS.JAI_AP_BOE_AEL_SL_V

VIEW - APPS.JAI_AP_BOE_AEL_V

VIEW - APPS.JAI_AP_MANUAL_AEL_GL_V

VIEW - APPS.JAI_AP_MANUAL_AEL_SL_V

VIEW - APPS.JAI_AP_MANUAL_AEL_V

VIEW - APPS.JAI_AP_MATCH_INV_TAX_V

VIEW - APPS.JAI_AP_MATCH_TAXES_V

VIEW - APPS.JAI_AP_ORG_TAN_V

VIEW - APPS.JAI_AP_SET_AEL_GL_V

VIEW - APPS.JAI_AP_SET_AEL_SL_V

VIEW - APPS.JAI_AP_SET_AEL_V

VIEW - APPS.JAI_AP_STANDALONE_TAXES_V

VIEW - APPS.JAI_AP_STDIST_AEL_GL_V

VIEW - APPS.JAI_AP_STDIST_AEL_SL_V

VIEW - APPS.JAI_AP_STDIST_AEL_V

VIEW - APPS.JAI_AP_STREVIEW_AEL_GL_V

VIEW - APPS.JAI_AP_STREVIEW_AEL_SL_V

VIEW - APPS.JAI_AP_STREVIEW_AEL_V

VIEW - APPS.JAI_AP_ST_FORMS_DTL_GRPRCPT_V

VIEW - APPS.JAI_AP_ST_MATCH_DTL_GRPRCPT_V

VIEW - APPS.JAI_AP_TAXES_V

VIEW - APPS.JAI_AP_TDS_DEFAULT_SECTION_V

VIEW - APPS.JAI_AP_TDS_DISTRIBUTION_V

VIEW - APPS.JAI_AP_TDS_F16_DTLS_V

VIEW - APPS.JAI_AP_TDS_LE_NAME_V

VIEW - APPS.JAI_AP_TDS_NULLSITE_THHOLD_V

VIEW - APPS.JAI_AP_TDS_ORG_TAN_V

VIEW - APPS.JAI_AP_TDS_SECTION_TAX_V

VIEW - APPS.JAI_AP_TDS_SITE_V

VIEW - APPS.JAI_AP_TDS_THHOLD_EXCEPTION_V

VIEW - APPS.JAI_AP_TDS_THHOLD_LE_V

VIEW - APPS.JAI_AP_TDS_THHOLD_VENDOR_V

VIEW - APPS.JAI_AP_TDS_TH_PAN_TAN_V

VIEW - APPS.JAI_AP_TDS_TH_VSITE_V

VIEW - APPS.JAI_AP_TDS_VNDR_TYPE_V

VIEW - APPS.JAI_AR_RG_BAL_V

VIEW - APPS.JAI_AR_ST_MATCH_DTL_GRPISS_V

VIEW - APPS.JAI_AR_TRX_AEL_GL_V

VIEW - APPS.JAI_AR_TRX_AEL_SL_V

VIEW - APPS.JAI_AR_TRX_AEL_V

VIEW - APPS.JAI_AR_TRX_DETAILS_V

VIEW - APPS.JAI_AR_TRX_DTLS_V

VIEW - APPS.JAI_AR_TRX_TMP_E_LINE_V

VIEW - APPS.JAI_BOE_ASBN_V

VIEW - APPS.JAI_BOE_DETAILS_V

VIEW - APPS.JAI_BOE_HEADERS_V

VIEW - APPS.JAI_BOE_MATCHINGS_V

VIEW - APPS.JAI_BOE_WRITEOFF_TAXES_V

VIEW - APPS.JAI_CMN_BASE_CURRENCY_V

VIEW - APPS.JAI_CMN_BOE_APPLIED_V

VIEW - APPS.JAI_CMN_CESS_TRXS_V

VIEW - APPS.JAI_CMN_CUSTOMERS_V

VIEW - APPS.JAI_CMN_CUSTOMER_DTLS_V

VIEW - APPS.JAI_CMN_CUSTOMER_SITES_V

VIEW - APPS.JAI_CMN_CUST_ADDRESS_V

VIEW - APPS.JAI_CMN_HR_LOCATIONS_V

VIEW - APPS.JAI_CMN_ORG_DTLS_V

VIEW - APPS.JAI_CMN_PLA_REGISTER_V

VIEW - APPS.JAI_CMN_RG_23_II_V

VIEW - APPS.JAI_CMN_RG_BALANCES_V

VIEW - APPS.JAI_CMN_UOM_DTLS_V

VIEW - APPS.JAI_CMN_VENDOR_ADDRESS_V

VIEW - APPS.JAI_CMN_VENDOR_CUST_NAME_V

VIEW - APPS.JAI_CMN_VENDOR_NAME_V

VIEW - APPS.JAI_CUSTOMERS_V

VIEW - APPS.JAI_DTC_SCTN_ACCOUNT_MAPPING_V

VIEW - APPS.JAI_EXCISE_INVNO_V

VIEW - APPS.JAI_FA_ASSETS_V

VIEW - APPS.JAI_FA_AST_RETIR_INAYR_V

VIEW - APPS.JAI_FBT_SETUP_HEADER_V

VIEW - APPS.JAI_FBT_TAX_TYPE_V

VIEW - APPS.JAI_FINYR_QUARTER_V

VIEW - APPS.JAI_IM_TAX_MAPPING_V

VIEW - APPS.JAI_INV_INTERORG_AEL_GL_V

VIEW - APPS.JAI_INV_INTERORG_AEL_SL_V

VIEW - APPS.JAI_INV_INTERORG_AEL_V

VIEW - APPS.JAI_INV_RG1_AEL_GL_V

VIEW - APPS.JAI_INV_RG1_AEL_SL_V

VIEW - APPS.JAI_INV_RG1_AEL_V

VIEW - APPS.JAI_INV_RG23_AEL_GL_V

VIEW - APPS.JAI_INV_RG23_AEL_SL_V

VIEW - APPS.JAI_INV_RG23_AEL_V

VIEW - APPS.JAI_INV_RGCO_AEL_GL_V

VIEW - APPS.JAI_INV_RGCO_AEL_SL_V

VIEW - APPS.JAI_INV_RGCO_AEL_V

VIEW - APPS.JAI_MASSTAXCHG_DOCNOS_V

VIEW - APPS.JAI_MTL_CVAT_V

VIEW - APPS.JAI_OE_MATCH_LINES_V

VIEW - APPS.JAI_OM_CUST_ADDRESS_V

VIEW - APPS.JAI_OM_LC_MATCHING_V

VIEW - APPS.JAI_OM_SHIP_AEL_GL_V

VIEW - APPS.JAI_OM_SHIP_AEL_SL_V

VIEW - APPS.JAI_OM_SHIP_AEL_V

VIEW - APPS.JAI_OM_WSH_DELIVERIES_V

VIEW - APPS.JAI_OM_WSH_DELIVERY_NAME_V

VIEW - APPS.JAI_PLA_ENTRY_AEL_GL_V

VIEW - APPS.JAI_PLA_ENTRY_AEL_SL_V

VIEW - APPS.JAI_PLA_ENTRY_AEL_V

VIEW - APPS.JAI_PO_CURRENCY_CODE_V

VIEW - APPS.JAI_PO_OSPM_AEL_GL_V

VIEW - APPS.JAI_PO_OSPM_AEL_SL_V

VIEW - APPS.JAI_PO_OSPM_AEL_V

VIEW - APPS.JAI_PO_OSP_DISP_AEL_GL_V

VIEW - APPS.JAI_PO_OSP_DISP_AEL_SL_V

VIEW - APPS.JAI_PO_OSP_DISP_AEL_V

VIEW - APPS.JAI_PO_RCV_TAXES_V

VIEW - APPS.JAI_PO_REC_AEL_GL_V

VIEW - APPS.JAI_PO_REC_AEL_SL_V

VIEW - APPS.JAI_PO_REC_AEL_V

VIEW - APPS.JAI_PO_REC_CENVAT_AEL_GL_V

VIEW - APPS.JAI_PO_REC_CENVAT_AEL_SL_V

VIEW - APPS.JAI_PO_REC_CENVAT_AEL_V

VIEW - APPS.JAI_PO_REC_MTL_AEL_GL_V

VIEW - APPS.JAI_PO_REC_MTL_AEL_SL_V

VIEW - APPS.JAI_PO_REC_MTL_AEL_V

VIEW - APPS.JAI_PO_REC_RMA_AEL_GL_V

VIEW - APPS.JAI_PO_REC_RMA_AEL_SL_V

VIEW - APPS.JAI_PO_REC_RMA_AEL_V

VIEW - APPS.JAI_PO_REC_VAT_AEL_GL_V

VIEW - APPS.JAI_PO_REC_VAT_AEL_SL_V

VIEW - APPS.JAI_PO_REC_VAT_AEL_V

VIEW - APPS.JAI_PO_REC_VENDOR_AEL_GL_V

VIEW - APPS.JAI_PO_REC_VENDOR_AEL_SL_V

VIEW - APPS.JAI_PO_REC_VENDOR_AEL_V

VIEW - APPS.JAI_PO_RFQQT_V

VIEW - APPS.JAI_PO_SHIPMENT_DTLS_V

VIEW - APPS.JAI_PO_SUMMARY_V

VIEW - APPS.JAI_PO_VENDOR_NAMES_V

VIEW - APPS.JAI_PROJECT_INV_AEL_GL_V

VIEW - APPS.JAI_PROJECT_INV_AEL_SL_V

VIEW - APPS.JAI_PROJECT_INV_AEL_V

VIEW - APPS.JAI_RCV_ACCNT_HDR_V

VIEW - APPS.JAI_RCV_ACCOUNTING_V

VIEW - APPS.JAI_RCV_ACCT_DIST_V

VIEW - APPS.JAI_RCV_CLAIM_MODVAT_V

VIEW - APPS.JAI_RCV_COSTING_V

VIEW - APPS.JAI_RCV_RECEIVE_LINES_V

VIEW - APPS.JAI_RCV_RGM_HEADERS_V

VIEW - APPS.JAI_RCV_RGM_INSTALLMENT_V

VIEW - APPS.JAI_RCV_RGM_TAX_V

VIEW - APPS.JAI_RCV_RGM_TXNS_V

VIEW - APPS.JAI_RCV_RG_AMOUNT_V

VIEW - APPS.JAI_RCV_RG_QUANTITY_V

VIEW - APPS.JAI_RCV_RTV_LINES_V

VIEW - APPS.JAI_RCV_TAX_V

VIEW - APPS.JAI_REGIME_TAX_TYPES_V

VIEW - APPS.JAI_REPOEXT_V

VIEW - APPS.JAI_RGM_ITEM_ATTRIB_V

VIEW - APPS.JAI_RGM_ORGANIZATIONS_V

VIEW - APPS.JAI_RGM_ORG_REGNS_V

VIEW - APPS.JAI_RGM_PARTY_REGNS_V

VIEW - APPS.JAI_RGM_STL_BALANCES_V

VIEW - APPS.JAI_RGM_THHOLD_REGIMES_V

VIEW - APPS.JAI_RGM_VAT_ORGANIZATIONS_V

VIEW - APPS.JAI_RG_FUND_TRF_AEL_GL_V

VIEW - APPS.JAI_RG_FUND_TRF_AEL_SL_V

VIEW - APPS.JAI_RG_FUND_TRF_AEL_V

VIEW - APPS.JAI_ST_FORMS_DTL_GRPISS_V

VIEW - APPS.JAI_WCT_CERT_DTLS_V

VIEW - APPS.JA_AU_ADDITIONS_ALLOCATIONS_V

VIEW - APPS.JA_AU_ADDITIONS_BOOKS_V

VIEW - APPS.JA_AU_BAL_CHG_DETAILS_V

VIEW - APPS.JA_AU_CAPITAL_VALUE_V

VIEW - APPS.JA_AU_FA_ADD_ADJ_V

VIEW - APPS.JA_AU_FA_BOOK_CONTROLS_V

VIEW - APPS.JA_AU_SOURCE_ADDITIONS_BOOKS_V

VIEW - APPS.JA_AU_SOURCE_ADDITIONS_V

VIEW - APPS.JA_AU_SUBINV_LOC_ASSOCS_V

VIEW - APPS.JA_CN_ACCOUNT_BALANCES_V

VIEW - APPS.JA_CN_CFSBSV_V

VIEW - APPS.JA_CN_LEDGER_LE_BANK_V

VIEW - APPS.JA_CN_SYSTEM_BANK_PARAMS_ALL_V

VIEW - APPS.JA_IN_RCV_JOURNALS

VIEW - APPS.JA_LOOKUPS

VIEW - APPS.JA_LOOKUP_TYPES

VIEW - APPS.PA_COMMITMENTS_V

VIEW - APPS.PA_COMMITMENT_TXNS_V

Table: JAI_AP_ETDS_ERRORS_T

Comments

Columns

[top of page]

JA.JAI_AP_ETDS_ERRORS_T does not reference any database object

JA.JAI_AP_ETDS_ERRORS_T is referenced by following:

APPS

SYNONYM - JAI_AP_ETDS_ERRORS_T

[top of page]

Table: JAI_AP_ETDS_REQUESTS

Primary Key: JAI_AP_ETDS_REQUESTS_PK

1. BATCH_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

This table stores the details with which each request of eTds was run. Request id, generated by the concurrent manager is also stored. This is for validating the output at a later point if required.

Indexes

Columns

[top of page]

JA.JAI_AP_ETDS_REQUESTS does not reference any database object

JA.JAI_AP_ETDS_REQUESTS is referenced by following:

JA

VIEW - JAI_AP_ETDS_REQUESTS#

[top of page]

Table: JAI_AP_ETDS_T

Foreign Keys from this table:

Comments

This table stores the details as required by the eTDS specifications. After processing the details are stored in this table and is later used for reporting.

Indexes

Columns

[top of page]

JA.JAI_AP_ETDS_T does not reference any database object

JA.JAI_AP_ETDS_T is referenced by following:

JA

VIEW - JAI_AP_ETDS_T#

[top of page]

Table: JAI_AP_INVOICE_LINES

Primary Key: JAI_AP_INVOICE_LINES_PK

1. JAI_AP_INVOICE_LINES_ID

Foreign Keys from this table:

Comments

This table is used to store the taxes related with standalone payables invoices

Indexes

Columns

[top of page]

JA.JAI_AP_INVOICE_LINES does not reference any database object

JA.JAI_AP_INVOICE_LINES is referenced by following:

JA

VIEW - JAI_AP_INVOICE_LINES#

[top of page]

Table: JAI_AP_MATCH_ERS_T

Foreign Keys from this table:

Comments

Stores Invoice details of ERS invoices, so that taxes can be carried from Purchasing to Payables. This table is used for bulk propagation of taxes by concurrent India - to insert taxes by pay on receipt.

Indexes

Columns

[top of page]

JA.JAI_AP_MATCH_ERS_T does not reference any database object

JA.JAI_AP_MATCH_ERS_T is referenced by following:

JA

VIEW - JAI_AP_MATCH_ERS_T#

[top of page]

Table: JAI_AP_MATCH_INV_TAXES

Primary Key: JAI_AP_MATCH_INV_TAXES_PK

1. TAX_DISTRIBUTION_ID

Foreign Keys from this table:

Comments

This table stores the details of all the TDS taxes that are applicable on an invoice distribution line. This includes, TDS, WCT and ESSI taxes, attached to the 3 segments of the invoice distribution DFF.

Indexes

Columns

[top of page]

JA.JAI_AP_MATCH_INV_TAXES does not reference any database object

JA.JAI_AP_MATCH_INV_TAXES is referenced by following:

JA

VIEW - JAI_AP_MATCH_INV_TAXES#

[top of page]

Table: JAI_AP_RGM_PAYMENTS

Primary Key: JAI_AP_RGM_PAYMENTS_PK

1. PAYMENT_ID

Foreign Keys from this table:

Comments

This table stores the payment information about payment made to TCS authority.

Indexes

Columns

[top of page]

JA.JAI_AP_RGM_PAYMENTS does not reference any database object

JA.JAI_AP_RGM_PAYMENTS is referenced by following:

JA

VIEW - JAI_AP_RGM_PAYMENTS#

[top of page]

Table: JAI_AP_TDS_CERT_NUMS

Primary Key: JAI_AP_TDS_CERT_NUMS_PK

1. FIN_YR_CERT_ID

Primary Key: JAI_AP_TDS_CERT_NUMS_UK1

1. ORGANIZATION_ID
2. LEGAL_ENTITY
3. FIN_YR

Foreign Keys from this table:

Comments

Stores the combination of Legal entity, financial year, Operating Unit, Org_tan_num and certificate_id whenever TDS year info is defined.

Indexes

Columns

[top of page]

JA.JAI_AP_TDS_CERT_NUMS does not reference any database object

JA.JAI_AP_TDS_CERT_NUMS is referenced by following:

JA

VIEW - JAI_AP_TDS_CERT_NUMS#

[top of page]

Table: JAI_AP_TDS_DEFAULT

Comments

This is an intermediate table that is used to derive the TDS Section Code and Tax category based on Defaultation Setup before populating into JAI_AP_TDS_INV_TAXES

Columns

[top of page]

JA.JAI_AP_TDS_DEFAULT does not reference any database object

JA.JAI_AP_TDS_DEFAULT is referenced by following:

JA

VIEW - JAI_AP_TDS_DEFAULT#

[top of page]

Table: JAI_AP_TDS_F16_DTLS_ALL

Primary Key: JAI_AP_TDS_F16_DTLS_ALL_PK

1. FORM16_DTL_ID

Foreign Keys from this table:

Comments

Stores the invoice information of invoices that have been considered against a particular TDS certificate.

Indexes

Columns

[top of page]

JA.JAI_AP_TDS_F16_DTLS_ALL does not reference any database object

JA.JAI_AP_TDS_F16_DTLS_ALL is referenced by following:

JA

VIEW - JAI_AP_TDS_F16_DTLS_ALL#

[top of page]

Table: JAI_AP_TDS_F16_HDRS_ALL

Primary Key: JAI_AP_TDS_F16_HDRS_ALL_PK

1. FORM16_HDR_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

Header information for TDS certificates.

Indexes

Columns

[top of page]

JA.JAI_AP_TDS_F16_HDRS_ALL does not reference any database object

JA.JAI_AP_TDS_F16_HDRS_ALL is referenced by following:

JA

VIEW - JAI_AP_TDS_F16_HDRS_ALL#

[top of page]

Table: JAI_AP_TDS_INVOICES

Primary Key: JAI_AP_TDS_INVOICES_PK

1. TDS_INVOICE_ID

Foreign Keys from this table:

Comments

This table holds the history of all the TDS related invoice generated against invoices. It has the link of both the TDS invoice and the credit memo.

Indexes

Columns

[top of page]

JA.JAI_AP_TDS_INVOICES does not reference any database object

JA.JAI_AP_TDS_INVOICES is referenced by following:

JA

VIEW - JAI_AP_TDS_INVOICES#

[top of page]

Table: JAI_AP_TDS_INV_CANCELS

Primary Key: JAI_AP_TDS_INV_CANCELS_PK

1. TDS_INV_CANCEL_ID

Foreign Keys from this table:

Comments

This table stores the details of TDS Cancel processing when a parent invoice having TDS is cancelled.

Indexes

Columns

[top of page]

JA.JAI_AP_TDS_INV_CANCELS does not reference any database object

JA.JAI_AP_TDS_INV_CANCELS is referenced by following:

JA

VIEW - JAI_AP_TDS_INV_CANCELS#

[top of page]

Table: JAI_AP_TDS_INV_PAYMENTS

Primary Key: JAI_AP_TDS_INV_PAYMENTS_PK

1. TDS_PAYMENT_ID

Foreign Keys from this table:

Comments

This will have the details of all TDS invoices which has been paid

Indexes

Columns

[top of page]

JA.JAI_AP_TDS_INV_PAYMENTS does not reference any database object

JA.JAI_AP_TDS_INV_PAYMENTS is referenced by following:

JA

VIEW - JAI_AP_TDS_INV_PAYMENTS#

[top of page]

Table: JAI_AP_TDS_INV_TAXES

Primary Key: JAI_AP_TDS_INV_TAXES_PK

1. TDS_INV_TAX_ID

Foreign Keys from this table:

Comments

This table stores the details of all the TDS taxes that are applicable on an invoice distribution line. This includes, TDS, WCT and ESSI taxes, attached to the 3 segments of the invoice distribution DFF.

Indexes

Columns

[top of page]

JA.JAI_AP_TDS_INV_TAXES does not reference any database object

JA.JAI_AP_TDS_INV_TAXES is referenced by following:

JA

VIEW - JAI_AP_TDS_INV_TAXES#

[top of page]

Table: JAI_AP_TDS_PAN_CHANGES

Foreign Keys from this table:

Comments

History related to Pan Changes of the Vendors

Indexes

Columns

[top of page]

JA.JAI_AP_TDS_PAN_CHANGES does not reference any database object

JA.JAI_AP_TDS_PAN_CHANGES is referenced by following:

JA

VIEW - JAI_AP_TDS_PAN_CHANGES#

[top of page]

Table: JAI_AP_TDS_PAYMENTS

Foreign Keys from this table:

Comments

Stores the details of TDS challan for payments to TDS authority.

Indexes

Columns

[top of page]

JA.JAI_AP_TDS_PAYMENTS does not reference any database object

JA.JAI_AP_TDS_PAYMENTS is referenced by following:

JA

VIEW - JAI_AP_TDS_PAYMENTS#

[top of page]

Table: JAI_AP_TDS_PREPAYMENTS

Primary Key: JAI_AP_TDS_PREPAYMENTS_PK

1. TDS_PREPAYMENT_ID

Primary Key: JAI_AP_TDS_PREPAYMENTS_UK1

1. INVOICE_ID
2. INVOICE_DISTRIBUTION_ID_PREPAY
3. INVOICE_DISTRIBUTION_ID

Foreign Keys from this table:

Comments

This table stores the details of TDS processing for prepayment application and unapplication. This also includes allocation of a prepayment line to non-prepay distributions of the invoice.

Indexes

Columns

[top of page]

JA.JAI_AP_TDS_PREPAYMENTS does not reference any database object

JA.JAI_AP_TDS_PREPAYMENTS is referenced by following:

JA

VIEW - JAI_AP_TDS_PREPAYMENTS#

[top of page]

Table: JAI_AP_TDS_REPOSITORY

Comments

This table stores TDS repository information

Indexes

Columns

[top of page]

JA.JAI_AP_TDS_REPOSITORY does not reference any database object

JA.JAI_AP_TDS_REPOSITORY is referenced by following:

JA

VIEW - JAI_AP_TDS_REPOSITORY#

[top of page]

Table: JAI_AP_TDS_REPO_LINES

Comments

This table stores TDS repository details lines.

Indexes

Columns

[top of page]

JA.JAI_AP_TDS_REPO_LINES does not reference any database object

JA.JAI_AP_TDS_REPO_LINES is referenced by following:

JA

VIEW - JAI_AP_TDS_REPO_LINES#

[top of page]

Table: JAI_AP_TDS_SEC_MAP

Comments

Indexes

Columns

[top of page]

JA.JAI_AP_TDS_SEC_MAP does not reference any database object

JA.JAI_AP_TDS_SEC_MAP is referenced by following:

JA

VIEW - JAI_AP_TDS_SEC_MAP#

[top of page]

Table: JAI_AP_TDS_THGRP_AUDITS

Primary Key: JAI_AP_TDS_THGRP_AUDITS_PK

1. THRESHOLD_GRP_AUDIT_ID

Foreign Keys from this table:

Comments

This table tracks the changes that happens to the table JAI_AP_TDS_THHOLD_GRPS. This table is very important for Threshold calculation and hence is tracked for all changes.

Indexes

Columns

[top of page]

JA.JAI_AP_TDS_THGRP_AUDITS does not reference any database object

JA.JAI_AP_TDS_THGRP_AUDITS is referenced by following:

JA

VIEW - JAI_AP_TDS_THGRP_AUDITS#

[top of page]

Table: JAI_AP_TDS_THHOLD_ACCOUNT

Comments

This table stores Natural Accounts mapped to TDS Threshold Setup Types in case of Multi Rate Setup.

Indexes

Columns

[top of page]

JA.JAI_AP_TDS_THHOLD_ACCOUNT does not reference any database object

JA.JAI_AP_TDS_THHOLD_ACCOUNT is referenced by following:

JA

VIEW - JAI_AP_TDS_THHOLD_ACCOUNT#

[top of page]

Table: JAI_AP_TDS_THHOLD_GRPS

Primary Key: JAI_AP_TDS_THHOLD_GRPS_PK

1. THRESHOLD_GRP_ID

Primary Key: JAI_AP_TDS_THHOLD_GRPS_UK1

1. VENDOR_ID
2. ORG_TAN_NUM
3. VENDOR_PAN_NUM
4. SECTION_TYPE
5. SECTION_CODE
6. FIN_YEAR

Foreign Keys from this table:

Foreign Keys to this table:

Comments

This table stores the details of Threshold position for a unique combination of vendor, vendor pan and supplier tan for a fin year, section type and section code.

Indexes

Columns

[top of page]

JA.JAI_AP_TDS_THHOLD_GRPS does not reference any database object

JA.JAI_AP_TDS_THHOLD_GRPS is referenced by following:

JA

VIEW - JAI_AP_TDS_THHOLD_GRPS#

[top of page]

Table: JAI_AP_TDS_THHOLD_HDRS

Primary Key: JAI_AP_TDS_THHOLD_HDRS_PK

1. THRESHOLD_HDR_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

This table stores the details of threshold that is applicable for a TDS vendor type, section type and section code. Currently only TDS section is being supported. Exception setups are also defined here.

Indexes

Columns

[top of page]

JA.JAI_AP_TDS_THHOLD_HDRS does not reference any database object

JA.JAI_AP_TDS_THHOLD_HDRS is referenced by following:

JA

VIEW - JAI_AP_TDS_THHOLD_HDRS#

[top of page]

Table: JAI_AP_TDS_THHOLD_SLABS

Primary Key: JAI_AP_TDS_THHOLD_SLABS_PK

1. THRESHOLD_SLAB_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

This table stores the details of various slabs and the applicable tax rate in the slab.

Indexes

Columns