You are browsing the archive for JE.

Oracle European Localizations Tables

Oracle European Localizations module – List of database tables

  • JE_BE_ANNUAL_VAT
  • JE_BE_ESL_SUMMARIES
  • JE_BE_LINE_TYPE_MAP
  • JE_BE_LOGS
  • JE_BE_REPORTERS
  • JE_BE_VAT_ALLOCATIONS
  • JE_BE_VAT_ALLOC_ERRORS
  • JE_BE_VAT_REP_RULES
  • JE_CH_PAYMENT_REF
  • JE_CH_SAD_SEQUENCES
  • JE_CZ_CONT_ALLOC_ALL
  • JE_CZ_EFT_CONTRACTS_ALL
  • JE_CZ_EFT_DATA_TMP
  • JE_DE_AP_BATCHES
  • JE_DE_AR_BATCHES
  • JE_DE_CHECKRUN_RESULTS
  • JE_DE_FA_SUMMARY
  • JE_DE_REMITTANCE_RESULTS
  • JE_DK_EDI_TMP
  • JE_DK_PAY_CATEGORIES
  • JE_DOC_SEQUENCE_AUDIT
  • JE_ES_MESSAGES_ALL
  • JE_ES_MODELO_190_ALL
  • JE_ES_MODELO_347_ALL
  • JE_ES_MODELO_349_ALL
  • JE_ES_MODELO_415_ALL
  • JE_FI_NUMBER_VALIDATION
  • JE_FR_DAS2_DETAILS_T
  • JE_FR_DAS2_ETB_HEADERS_T
  • JE_FR_DAS2_LE_ETB_SUMM_T
  • JE_FR_DAS2_LE_HEADERS_T
  • JE_FR_DAS2_VEN_SUMMARY_T
  • JE_FR_DAS_010
  • JE_FR_DAS_010_NEW
  • JE_FR_DAS_020
  • JE_FR_DAS_020_NEW
  • JE_FR_DAS_210
  • JE_FR_DAS_210_NEW
  • JE_FR_DAS_300
  • JE_FR_DAS_300_NEW
  • JE_FR_DAS_310
  • JE_FR_DAS_310_NEW
  • JE_GR_AR_AP_TRNOVR_ITF
  • JE_GR_CUTOFF_RULES
  • JE_GR_JE_HEADER_SEQUENCE
  • JE_GR_TRNOVR_RULES
  • JE_GR_TRNOVR_RULE_LINES
  • JE_HU_BALANCES_REPORT
  • JE_IT_EXEMPT_LETTERS
  • JE_IT_EXLET_SEQS
  • JE_IT_INV_PACKSLIPS
  • JE_IT_PACKSLIPS
  • JE_IT_PO_PACKSLIPS
  • JE_IT_REPORT_PARAMETERS
  • JE_IT_TMP_RPT_HEADERS
  • JE_IT_VAT_REGISTERS_B
  • JE_IT_VAT_REGISTERS_TL
  • JE_IT_VAT_REG_DOCS
  • JE_IT_VAT_REPORT_INV
  • JE_IT_YEAR_EX_LIMIT
  • JE_NL_EFT_BATCHES
  • JE_NL_EFT_CONTENTS
  • JE_NL_EFT_MEDIA
  • JE_NL_EFT_SPECS
  • JE_NO_BANK_AVSTEM_TEMP
  • JE_NO_BBS
  • JE_NO_BBS_MESSAGE
  • JE_NO_DATADIALOG
  • JE_NO_GEI_AREPORTS
  • JE_NO_GEI_ASCIIS_T
  • JE_NO_GEI_CONTROLAS
  • JE_NO_GEI_CONTROLS
  • JE_NO_GEI_MESSAGES
  • JE_NO_GL_VAT_REP
  • JE_NO_INVEST_LINES
  • JE_NO_INVEST_SETUP_B
  • JE_NO_INVEST_SETUP_TL
  • JE_NO_REPORT_PARAMETERS
  • JE_NO_TELEPAY
  • JE_NO_TELEPAY_RETUR1
  • JE_PT_BANK_TRANSFER_TEXT
  • JE_PT_JEPTVATR
  • JE_SE_EFT

Oracle General Ledger Tables

Oracle General Ledger Module – List of database tables:

  • GL_ACCESS_SETS
  • GL_ACCESS_SET_ASSIGNMENTS
  • GL_ACCESS_SET_NORM_ASSIGN
  • GL_ACCOUNT_HIERARCHIES
  • GL_ALLOC_BATCHES
  • GL_ALLOC_FORMULAS
  • GL_ALLOC_FORMULA_LINES
  • GL_ALLOC_HISTORY
  • GL_ALLOC_INTERIM_1
  • GL_ALLOC_INTERIM_2
  • GL_ALLOC_INTERIM_3
  • GL_ALLOC_TARGETS
  • GL_APPLICATION_GROUPS
  • GL_ARCHIVE_BALANCES
  • GL_ARCHIVE_BATCHES
  • GL_ARCHIVE_DAILY_BALANCES
  • GL_ARCHIVE_HEADERS
  • GL_ARCHIVE_HISTORY
  • GL_ARCHIVE_LINES
  • GL_ARCHIVE_REFERENCES
  • GL_AUTHORIZATION_LIMITS
  • GL_AUTOMATIC_POSTING_OPTIONS
  • GL_AUTOMATIC_POSTING_SETS
  • GL_AUTOREVERSE_OPTIONS
  • GL_AUTOREV_CRITERIA_SETS
  • GL_AUTO_ALLOC_BATCHES
  • GL_AUTO_ALLOC_BATCH_HISTORY
  • GL_AUTO_ALLOC_BAT_HIST_DET
  • GL_AUTO_ALLOC_REV_BATCHES
  • GL_AUTO_ALLOC_SETS
  • GL_AUTO_ALLOC_SET_HISTORY
  • GL_BALANCES
  • GL_BALANCES_DELTA
  • GL_BALANCES_DELTA_INTERIM
  • GL_BC_DUAL
  • GL_BC_DUAL2
  • GL_BC_EVENT_TIMESTAMPS
  • GL_BC_OPTIONS
  • GL_BC_OPTION_DETAILS
  • GL_BC_PACKETS
  • GL_BC_PACKETS_HISTS
  • GL_BC_PACKET_ARRIVAL_ORDER
  • GL_BC_PERIOD_MAP
  • GL_BUDGETS
  • GL_BUDGET_ASSIGNMENTS
  • GL_BUDGET_ASSIGNMENT_RANGES
  • GL_BUDGET_BATCHES
  • GL_BUDGET_ENTITIES
  • GL_BUDGET_FROZEN_RANGES
  • GL_BUDGET_INTERFACE
  • GL_BUDGET_INTERIM
  • GL_BUDGET_PERIOD_RANGES
  • GL_BUDGET_RANGE_INTERIM
  • GL_BUDGET_TYPES
  • GL_BUDGET_VERSIONS
  • GL_BUDORG_BC_OPTIONS
  • GL_CAPTURED_INFO
  • GL_CARRYFORWARD_RANGES
  • GL_COA_MAPPINGS
  • GL_CODE_COMBINATIONS
  • GL_CONCURRENCY_CONTROL
  • GL_CONCURRENT_SCHEDULES
  • GL_CONSOLIDATION
  • GL_CONSOLIDATION_ACCOUNTS
  • GL_CONSOLIDATION_AUDIT
  • GL_CONSOLIDATION_HISTORY
  • GL_CONSOLIDATION_SETS
  • GL_CONS_BATCHES
  • GL_CONS_FLEXFIELD_MAP
  • GL_CONS_FLEX_HIERARCHIES
  • GL_CONS_SEGMENT_MAP
  • GL_CONS_SET_ASSIGNMENTS
  • GL_CROSS_RATE_RULES
  • GL_CROSS_RATE_RULE_DTLS
  • GL_DAILY_BALANCES
  • GL_DAILY_CONVERSION_RATES
  • GL_DAILY_CONVERSION_TYPES
  • GL_DAILY_RATES
  • GL_DAILY_RATES_INTERFACE
  • GL_DATE_PERIOD_MAP
  • GL_DEFAS_ACCESS_SETS
  • GL_DEFAS_ASSIGNMENTS
  • GL_DEFAS_RESP_ASSIGN
  • GL_DOC_SEQUENCE_AUDIT
  • GL_DYNAMIC_SUMM_COMBINATIONS
  • GL_EFC_BUDGET_MAPPING
  • GL_EFC_CHANGED_TRX
  • GL_EFC_DISABLED_TRIGGERS
  • GL_EFC_RUN_HISTORY
  • GL_ELIMINATION_HISTORY
  • GL_ELIMINATION_JOURNALS
  • GL_ELIMINATION_SETS
  • GL_ELIM_ACCOUNTS_MAP
  • GL_ELIM_BAL_OPTIONS
  • GL_ENCUMBRANCE_TYPES
  • GL_ENTITY_BUDGETS
  • GL_EXTRACT_HISTORY
  • GL_FIXED_CONV_RATES
  • GL_HISTORICAL_RATES
  • GL_HISTORICAL_RATE_RANGES
  • GL_IEA_AUTOGEN_MAP
  • GL_IEA_CLEARING_ACCOUNTS
  • GL_IEA_IMPORT_REGISTRY
  • GL_IEA_INTERFACE
  • GL_IEA_RECUR_BATCHES
  • GL_IEA_RECUR_HISTORY
  • GL_IEA_RECUR_LINES
  • GL_IEA_RECUR_TRANSACTIONS
  • GL_IEA_SEGMENT_MAP
  • GL_IEA_SEGMENT_RULE_MAP
  • GL_IEA_SUBSIDIARIES
  • GL_IEA_TRANSACTIONS
  • GL_IEA_TRANSACTION_LINES
  • GL_IEA_TRANSACTION_TYPES
  • GL_IMPORT_REFERENCES
  • GL_INTERCOMPANY_ACCOUNTS
  • GL_INTERCOMPANY_ACC_SETS
  • GL_INTERFACE
  • GL_INTERFACE_CONTROL
  • GL_INTERFACE_HISTORY
  • GL_ISPEED_COA_SEGMENTS
  • GL_ISPEED_COA_TEMPLATES
  • GL_JE_BATCHES
  • GL_JE_CATEGORIES_TL
  • GL_JE_HEADERS
  • GL_JE_INCLUSION_RULES
  • GL_JE_LINES
  • GL_JE_LINES_RECON
  • GL_JE_SEGMENT_VALUES
  • GL_JE_SEGVALS_UPGRADE
  • GL_JE_SOURCES_TL
  • GL_JOURNAL_REPORTS_ITF
  • GL_LEDGERS
  • GL_LEDGER_BSV_GT
  • GL_LEDGER_CONFIGURATIONS
  • GL_LEDGER_CONFIG_DETAILS
  • GL_LEDGER_LE_BSV_GT
  • GL_LEDGER_NORM_SEG_VALS
  • GL_LEDGER_RELATIONSHIPS
  • GL_LEDGER_SEGMENT_VALUES
  • GL_LEDGER_SETS
  • GL_LEDGER_SET_ASSIGNMENTS
  • GL_LEDGER_SET_NORM_ASSIGN
  • GL_LEDGER_SET_REQUESTS
  • GL_LEGAL_ENTITIES_BSVS
  • GL_LE_VALUE_SETS
  • GL_LOOKUPS_OLD
  • GL_MC_BOOK_ASSIGNMENTS
  • GL_MC_BOOK_ASSIGNMENTS_11I
  • GL_MC_CONVERSION_RULES
  • GL_MC_CONVERSION_RULES_11I
  • GL_MC_REPORTING_OPTIONS
  • GL_MC_REPORTING_OPTIONS_11I
  • GL_MC_UPGRADE_HISTORY
  • GL_MC_UPGRADE_RATES
  • GL_MGT_SEG_UPGRADE
  • GL_MGT_SEG_UPGRADE_H
  • GL_MOVEMERGE_ACCOUNTS
  • GL_MOVEMERGE_REQUESTS
  • GL_NET_INCOME_ACCOUNTS
  • GL_OASIS_FIN_ASSIGNMENTS
  • GL_OASIS_FIN_ASSIGNMENTS_11I
  • GL_OASIS_FIN_ITEMS
  • GL_OASIS_FIN_ITEMS_11I
  • GL_OASIS_FIN_METRICS
  • GL_OASIS_FIN_METRICS_11I
  • GL_OASIS_SUMMARY_DATA
  • GL_PERIODS
  • GL_PERIOD_SETS
  • GL_PERIOD_STATUSES
  • GL_PERIOD_TYPES
  • GL_POSTING_INTERIM
  • GL_RECURRING_BATCHES
  • GL_RECURRING_HEADERS
  • GL_RECURRING_LINES
  • GL_RECURRING_LINE_CALC_RULES
  • GL_REVALUATION
  • GL_REVALUATIONS
  • GL_REVALUATION_ACCOUNTS
  • GL_REVAL_ACCOUNT_RANGES
  • GL_ROLLUP_GROUP_SCORES
  • GL_ROW_MULTIPLIERS
  • GL_RX_TRIAL_BALANCE_ITF
  • GL_SEGMENT_FREQUENCIES
  • GL_SEGVAL_INHERIT_HISTORY
  • GL_SEG_VAL_HIERARCHIES
  • GL_SEG_VAL_NORM_HIERARCHY
  • GL_SETS_OF_BOOKS
  • GL_SETS_OF_BOOKS_11I
  • GL_SHARES_ACTIVITY
  • GL_SHARES_OUTSTANDING
  • GL_STAT_ACCOUNT_UOM
  • GL_STORAGE_PARAMETERS
  • GL_SUMMARY_BC_OPTIONS
  • GL_SUMMARY_HIERARCHIES
  • GL_SUMMARY_HIERARCHY_INT
  • GL_SUMMARY_INTERIM
  • GL_SUMMARY_TEMPLATES
  • GL_SUSPENSE_ACCOUNTS
  • GL_SYSTEM_SETUP
  • GL_SYSTEM_SETUP_11I
  • GL_SYSTEM_USAGES
  • GL_TAX_CODES
  • GL_TAX_OPTIONS
  • GL_TAX_OPTION_ACCOUNTS
  • GL_TEMPORARY_COMBINATIONS
  • GL_TRACK_DELTA_BALANCES
  • GL_TRANSACTION_CALENDAR
  • GL_TRANSACTION_DATES
  • GL_TRANSACTION_RATE_EXCEPTIONS
  • GL_TRANSLATION_INTERIM
  • GL_TRANSLATION_RATES
  • GL_TRANSLATION_RATES_11I
  • GL_TRANSLATION_STATUSES
  • GL_TRANSLATION_TRACKING
  • GL_UPDATE_RECOVERY_H
  • GL_UPGRADE_STATUS
  • GL_USSGL_ACCOUNT_PAIRS
  • GL_USSGL_TRANSACTION_CODES
  • GL_WEIGHTED_AVG_DETAILS

Views in European Localizations Module

List of views in Oracle European Localizations Module

JE_BE_VAT_REP_RULES_V
JE_ES_MESSAGES
JE_ES_MODELO_347
JE_ES_MODELO_349
JE_ES_MODELO_415
JE_GR_CUTOFF_RULES_DFV
JE_GR_TRNOVR_RULE_LINES_V
JE_IT_EXEMPT_LETTERS_V
JE_IT_VAT_REG_DOCS_V
JE_IT_VAT_REGISTERS_VL
JE_NO_GEI_SREPORT_V