JE Tables (99)

JE - European Localizations — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

TableColumnsDescription
JE_BE_ANNUAL_VAT 12 Receivables information required for VAT Annual Return preparation
JE_BE_ESL_SUMMARIES 10 Quarterly VAT summaries information
JE_BE_LINE_TYPE_MAP 3 Mappings for financial document line types to VAT rules line types
JE_BE_LOGS 13 VAT declarations
JE_BE_REPORTERS 22 Declarer information to be printed on report header of VAT reports
JE_BE_VAT_ALLOCATIONS 13 Transacations that have been allocated to VAT reporting boxes
JE_BE_VAT_ALLOC_ERRORS 14 Allocation/reallocation errors
JE_BE_VAT_REP_RULES 17 Reporting rules for allocating/reallocating amounts to VAT boxes
JE_CH_PAYMENT_REF 13 Payment batch information for Swiss EFT payments
JE_CH_SAD_SEQUENCES 4 Table of sequences for Swiss SAD payments
JE_CZ_CONT_ALLOC_ALL 30 This table is used to associate a bank account with a Compatible Media contract. A contract can relate to one or more bank accounts.
JE_CZ_EFT_CONTRACTS_ALL 45 This table will store all the relevant details of a Compatible Media contract between a company and its Bank. This table will contain the ra
JE_CZ_EFT_DATA_TMP 4 This is a temporary table used to facilitate validation and the build of the EFT Payment file before printing. This table is emptied before
JE_DE_AP_BATCHES 1 Checkrun names for which German separate payment letters have been printed
JE_DE_AR_BATCHES 2 Information on Receivables payment batches for which separate letters have been printed
JE_DE_CHECKRUN_RESULTS 17 Results of the German Payables EFT Format payments processed
JE_DE_FA_SUMMARY 18 Summary information on fixed assets
JE_DE_REMITTANCE_RESULTS 15 Results of the German Direct Debit Format program in Receivables
JE_DK_EDI_TMP 2 Table to store error messages when updating Danish EFT invoices to use EDI flexfields
JE_DK_PAY_CATEGORIES 17 Stores payment categories and their attributes
JE_DOC_SEQUENCE_AUDIT 5 Provides audit information for the Greek Accounting Sequence
JE_ES_MESSAGES_ALL 3 Temporary messages table used by Spanish reports
JE_ES_MODELO_190_ALL 45 Information for Spanish Withholding Tax processing
JE_ES_MODELO_347_ALL 18 Information for Spanish Payables Third Party Operations reporting
JE_ES_MODELO_349_ALL 15 Information for Spanish Payables Third Party Operations reporting
JE_ES_MODELO_415_ALL 10 Information for Spanish Payables Third Party Operations reporting
JE_FI_NUMBER_VALIDATION 1 Table of values for Finnish validation
JE_FR_DAS2_DETAILS_T 65 All data extracted from the core tables will be inserted into this table initially.
JE_FR_DAS2_ETB_HEADERS_T 35 This table will be used to store the header information for an establishment.
JE_FR_DAS2_LE_ETB_SUMM_T 88 This table will hold data from the JE_FR_DAS2_VEN_SUMMARY table as well as data summarized by the legal_entity_id (type 310 records) and dat
JE_FR_DAS2_LE_HEADERS_T 37 This table will be used to store the header information for a Legal Entity.
JE_FR_DAS2_VEN_SUMMARY_T 65 The data from the JE_FR_DAS2_DETAILS_T table will be mainly grouped by legal_entity_id+establishment_id+vendor_id+vendor_Site_id and inserte
JE_FR_DAS_010 31 Record 010 information for French DAS2 reports
JE_FR_DAS_010_NEW 36 New version of JE_FR_DAS_010 table
JE_FR_DAS_020 28 Record 020 information for French DAS2 reports
JE_FR_DAS_020_NEW 33 New version of JE_FR_DAS_020 table
JE_FR_DAS_210 58 Record 210 information for French DAS2 reports
JE_FR_DAS_210_NEW 63 New version of JE_FR_DAS_210 table
JE_FR_DAS_300 41 Record 300 information for French DAS2 reports
JE_FR_DAS_300_NEW 47 New version of JE_FR_DAS_300 table
JE_FR_DAS_310 33 Record 310 information for French DAS2 reports
JE_FR_DAS_310_NEW 38 New version of JE_FR_DAS_310 table
JE_GR_AR_AP_TRNOVR_ITF 28 Customer/Supplier's Transaction/Invoice data will be populated by data extract process based on turnover data exclusion rules.
JE_GR_CUTOFF_RULES 28 Stores accounting cutoff rules for Greece
JE_GR_JE_HEADER_SEQUENCE 5 This table stores the Greek Accounting sequence and value for each journal entry whose journal
JE_GR_TRNOVR_RULES 27 Turnover data exclusion rules
JE_GR_TRNOVR_RULE_LINES 27 Turnover data exclusion rule lines
JE_HU_BALANCES_REPORT 7 Hungarian Fixed Assets balance information
JE_IL_VAT_LIMITS 13 This table is used to capture the VAT limits for each tax period
JE_IT_ABOVE_THR_HDR_ALL 21 This table stores the parameter details of Italian Invoice Above Threshold Data extract Run
JE_IT_COUNTRY_REP_CODES 9 This table stores Italian Country Codes defined in Italian Tax Reporting Country Codes form
JE_IT_EXEMPT_LETTERS 19 Italian exemption letter information for suppliers
JE_IT_EXLET_SEQS 3 Table based sequencing for exemption letters
JE_IT_INV_PACKSLIPS 3 Information on Italian Inventory Packing Slips
JE_IT_LIST_HDR_ALL 10 JE_IT_LIST_HDR_ALL table contains Italian Annual Supplier and Customer listing extract header data
JE_IT_LIST_LINES_ALL 34 JE_IT_LIST_LINES_ALL table contains Italian Annual Supplier and Customer listing extract detail data
JE_IT_LIST_PARTIES_ALL 27 JE_IT_LIST_PARTIES_ALL table contains Italian Annual Supplier and Customer listing extract summary data
JE_IT_LIST_TRX_GT 2
JE_IT_PACKSLIPS 3 Information on Italian Order Entry Packing Slips
JE_IT_PO_PACKSLIPS 3 Information on Italian Purchasing Packing Slips
JE_IT_REPORT_PARAMETERS 15 Italian report parameters
JE_IT_SETUP_DOC_SEQS_ALL 10 A table to store document sequence setup done in Italian Invoices Reporting Setup form
JE_IT_SETUP_HDR_ALL 11 JE_IT_SETUP_HDR_ALL table contains Italian Annual Supplier and Customer listing setup header data
JE_IT_SETUP_HEADER_ALL 10 JE_IT_SETUP_HEADER_ALL stores the Italian Invoice Above Threshold Enhancement setup header data.
JE_IT_SETUP_LINES_ALL 13 JE_IT_SETUP_LINES_ALL table contains Italian Annual Supplier and Customer listing setup lines data
JE_IT_TMP_RPT_HEADERS 1 Page numbers for printing generic report headers
JE_IT_TRX_ABOVE_THR_ALL 43 A table to store the detailed information of transactions which are eligible for Data Extraction
JE_IT_TRX_LINES_ALL 46 This table stores the detailed information of transactions which are eligible for Italian Invoices Above Threshold Data Extraction
JE_IT_VAT_REGISTERS_B 9 Italian VAT Registers.
JE_IT_VAT_REGISTERS_TL 9 Translated information about Italian VAT Registers.
JE_IT_VAT_REG_DOCS 7 Document sequence information for Italian VAT registers
JE_IT_VAT_REPORT_INV 9 Invoices reported on submitted Italian VAT Register
JE_IT_YEAR_EX_LIMIT 12 The JE_IT_YEAR_EX_LIMIT table stores yearly exemption limits and their monthly adjustments. This table is populated by the Italian Payables
JE_NL_EFT_BATCHES 19 Dutch EFT payment batches
JE_NL_EFT_CONTENTS 8 Dutch EFT payments
JE_NL_EFT_MEDIA 15 Media information for creating Dutch EFT documents
JE_NL_EFT_SPECS 7 Information for Dutch EFT Payment formatting
JE_NO_BANK_AVSTEM_TEMP 14 Bank transactions
JE_NO_BBS 4 Information for Norwegian BBS Payment formatting
JE_NO_BBS_MESSAGE 2 Error messages related Norwegian BBS Payment formatting
JE_NO_DATADIALOG 6 Information for Norwegian Datadialog Payment formatting
JE_NO_GEI_AREPORTS 3 Table used to hold A-report data from FIN
JE_NO_GEI_ASCIIS_T 2 This table stores data temporarily that are to be sent to FIN.
JE_NO_GEI_CONTROLAS 15 Table Stores info about ordering and recieving files related to A-Report. The Order nummber for the sent file and also the ones that is reci
JE_NO_GEI_CONTROLS 8 Table Stores info about ordering and recieving files related to S-Report.
JE_NO_GEI_MESSAGES 13 Table Stores messages recieved from FIN
JE_NO_GL_VAT_REP 16 Stores transactions reported to the Norwegians Tax Authorities
JE_NO_INVEST_LINES 117 Copy of AP_INVOICE_DISTRIBUTIONS and two more columns for investment tax
JE_NO_INVEST_SETUP_B 14 Setup information for Norwegian Investment Tax
JE_NO_INVEST_SETUP_TL 11 Translated setup information for Norwegian Investment Tax
JE_NO_REPORT_PARAMETERS 22 stores the request parameters for the Norwegian VAT Reconciliation repor
JE_NO_TELEPAY 16 Information on Norwegian Telepay sessions
JE_NO_TELEPAY_RETUR1 3 Return information from the bank on Telepay payments
JE_PT_BANK_TRANSFER_TEXT 5 Information for Portuguese Payables EFT and Receivables Direct Debit formatting
JE_PT_CERTIFICATES 12 Portuguese Software Billing Certification ER - Table to store certification information
JE_PT_JEPTVATR 4 Information for Payables and Receivables VAT Recapitulative reporting
JE_PT_RA_CUST_TRX_EXTS 10 Portuguese Software Billing Certification ER - 1:1 Extension table to ra_customer_trx_all
JE_SE_EFT 6 Information for Swedish EFT formatting
JE_UK_SALES_TRX_GT 35