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 - JE Tables and Views

TABLE - GL.JE_BE_ANNUAL_VAT
TABLE - GL.JE_BE_ESL_SUMMARIES
TABLE - GL.JE_BE_LINE_TYPE_MAP
TABLE - GL.JE_BE_LOGS
TABLE - GL.JE_BE_REPORTERS
TABLE - GL.JE_BE_VAT_ALLOCATIONS
TABLE - GL.JE_BE_VAT_ALLOC_ERRORS
TABLE - GL.JE_BE_VAT_REP_RULES
TABLE - AP.JE_CH_PAYMENT_REF
TABLE - AP.JE_CH_SAD_SEQUENCES
TABLE - AP.JE_CZ_CONT_ALLOC_ALL
TABLE - AP.JE_CZ_EFT_CONTRACTS_ALL
TABLE - AP.JE_CZ_EFT_DATA_TMP
TABLE - AP.JE_DE_AP_BATCHES
TABLE - AR.JE_DE_AR_BATCHES
TABLE - AP.JE_DE_CHECKRUN_RESULTS
TABLE - FA.JE_DE_FA_SUMMARY
TABLE - AR.JE_DE_REMITTANCE_RESULTS
TABLE - AP.JE_DK_EDI_TMP
TABLE - AP.JE_DK_PAY_CATEGORIES
TABLE - GL.JE_DOC_SEQUENCE_AUDIT
TABLE - JE.JE_ES_MESSAGES_ALL
TABLE - JE.JE_ES_MODELO_190_ALL
TABLE - JE.JE_ES_MODELO_347_ALL
TABLE - JE.JE_ES_MODELO_349_ALL
TABLE - JE.JE_ES_MODELO_415_ALL
TABLE - AP.JE_FI_NUMBER_VALIDATION
TABLE - AP.JE_FR_DAS2_DETAILS_T
TABLE - AP.JE_FR_DAS2_ETB_HEADERS_T
TABLE - AP.JE_FR_DAS2_LE_ETB_SUMM_T
TABLE - AP.JE_FR_DAS2_LE_HEADERS_T
TABLE - AP.JE_FR_DAS2_VEN_SUMMARY_T
TABLE - AP.JE_FR_DAS_010
TABLE - AP.JE_FR_DAS_010_NEW
TABLE - AP.JE_FR_DAS_020
TABLE - AP.JE_FR_DAS_020_NEW
TABLE - AP.JE_FR_DAS_210
TABLE - AP.JE_FR_DAS_210_NEW
TABLE - AP.JE_FR_DAS_300
TABLE - AP.JE_FR_DAS_300_NEW
TABLE - AP.JE_FR_DAS_310
TABLE - AP.JE_FR_DAS_310_NEW
TABLE - JE.JE_GR_AR_AP_TRNOVR_ITF
TABLE - GL.JE_GR_CUTOFF_RULES
TABLE - GL.JE_GR_JE_HEADER_SEQUENCE
TABLE - JE.JE_GR_TRNOVR_RULES
TABLE - JE.JE_GR_TRNOVR_RULE_LINES
TABLE - FA.JE_HU_BALANCES_REPORT
TABLE - JE.JE_IL_VAT_LIMITS
TABLE - JE.JE_IT_ABOVE_THR_HDR_ALL
TABLE - JE.JE_IT_COUNTRY_REP_CODES
TABLE - AP.JE_IT_EXEMPT_LETTERS
TABLE - AP.JE_IT_EXLET_SEQS
TABLE - INV.JE_IT_INV_PACKSLIPS
TABLE - JE.JE_IT_LIST_HDR_ALL
TABLE - JE.JE_IT_LIST_LINES_ALL
TABLE - JE.JE_IT_LIST_PARTIES_ALL
TABLE - JE.JE_IT_LIST_TRX_GT
TABLE - OE.JE_IT_PACKSLIPS
TABLE - JE.JE_IT_PO_PACKSLIPS
TABLE - GL.JE_IT_REPORT_PARAMETERS
TABLE - JE.JE_IT_SETUP_DOC_SEQS_ALL
TABLE - JE.JE_IT_SETUP_HDR_ALL
TABLE - JE.JE_IT_SETUP_HEADER_ALL
TABLE - JE.JE_IT_SETUP_LINES_ALL
TABLE - GL.JE_IT_TMP_RPT_HEADERS
TABLE - JE.JE_IT_TRX_ABOVE_THR_ALL
TABLE - JE.JE_IT_TRX_LINES_ALL
TABLE - AP.JE_IT_VAT_REGISTERS_B
TABLE - AP.JE_IT_VAT_REGISTERS_TL
TABLE - AP.JE_IT_VAT_REG_DOCS
TABLE - JE.JE_IT_VAT_REPORT_INV
TABLE - AP.JE_IT_YEAR_EX_LIMIT
TABLE - AP.JE_NL_EFT_BATCHES
TABLE - AP.JE_NL_EFT_CONTENTS
TABLE - AP.JE_NL_EFT_MEDIA
TABLE - AP.JE_NL_EFT_SPECS
TABLE - AP.JE_NO_BANK_AVSTEM_TEMP
TABLE - AP.JE_NO_BBS
TABLE - AP.JE_NO_BBS_MESSAGE
TABLE - AP.JE_NO_DATADIALOG
TABLE - JE.JE_NO_GEI_AREPORTS
TABLE - JE.JE_NO_GEI_ASCIIS_T
TABLE - JE.JE_NO_GEI_CONTROLAS
TABLE - JE.JE_NO_GEI_CONTROLS
TABLE - JE.JE_NO_GEI_MESSAGES
TABLE - JE.JE_NO_GL_VAT_REP
TABLE - AP.JE_NO_INVEST_LINES
TABLE - AP.JE_NO_INVEST_SETUP_B
TABLE - AP.JE_NO_INVEST_SETUP_TL
TABLE - JE.JE_NO_REPORT_PARAMETERS
TABLE - AP.JE_NO_TELEPAY
TABLE - AP.JE_NO_TELEPAY_RETUR1
TABLE - JE.JE_PT_BANK_TRANSFER_TEXT
TABLE - JE.JE_PT_CERTIFICATES
TABLE - JE.JE_PT_JEPTVATR
TABLE - JE.JE_PT_RA_CUST_TRX_EXTS
TABLE - AP.JE_SE_EFT
TABLE - JE.JE_UK_SALES_TRX_GT
VIEW - APPS.JE_BE_VAT_REP_RULES_V
VIEW - APPS.JE_ES_MESSAGES
VIEW - APPS.JE_ES_MODELO_347
VIEW - APPS.JE_ES_MODELO_349
VIEW - APPS.JE_ES_MODELO_415
VIEW - APPS.JE_ES_TAX_TYPE_V
VIEW - APPS.JE_GR_TRNOVR_RULE_LINES_V
VIEW - APPS.JE_IT_EXEMPT_LETTERS_V
VIEW - APPS.JE_IT_VAT_REGISTERS_VL
VIEW - APPS.JE_IT_VAT_REG_DOCS_V
VIEW - APPS.JE_NO_GEI_SREPORT_V
VIEW - APPS.JE_PT_RA_TRX_REQUEST_IDS_V

Table: JE_BE_ANNUAL_VAT

Description: Receivables information required for VAT Annual Return preparation
Comments
Columns
Name Datatype Length Mandatory Comments
COLUMN1 NUMBER

COLUMN2 VARCHAR2 (32)
COLUMN3 VARCHAR2 (24)
COLUMN4 VARCHAR2 (4)
COLUMN5 VARCHAR2 (22)
COLUMN6 VARCHAR2 (1)
COLUMN7 VARCHAR2 (15)
COLUMN8 VARCHAR2 (10)
COLUMN9 VARCHAR2 (10)
COLUMN10 VARCHAR2 (8)
CUSTOMER_ID NUMBER (15)
SET_OF_BOOKS_ID NUMBER (15) Y

[top of page]

GL.JE_BE_ANNUAL_VAT does not reference any database object

GL.JE_BE_ANNUAL_VAT is referenced by following:

GL
VIEW - JE_BE_ANNUAL_VAT#

[top of page]

Table: JE_BE_ESL_SUMMARIES

Description: Quarterly VAT summaries information
Primary Key: JE_BE_ESL_SUMMARIES_PK
  1. ESL_SUMMARY_ID
Comments
Indexes
Index Type Tablespace Column
JE_BE_ESL_SUMMARIES_U1 UNIQUE APPS_TS_ARCHIVE ESL_SUMMARY_ID
Columns
Name Datatype Length Mandatory Comments
ESL_SUMMARY_ID NUMBER (15) Y
DECLARATION_ID NUMBER (15) Y
LINE_NUMBER NUMBER (15) Y
CUSTOMER_NAME VARCHAR2 (50) Y
SET_OF_BOOKS_ID NUMBER (15) Y
ESL_PERIOD_NAME VARCHAR2 (15) Y
SITE_USE_ID NUMBER
Y
ESL_CODE VARCHAR2 (1)
AMOUNT NUMBER (38) Y
CORRECTION_PERIOD_NAME VARCHAR2 (15)

[top of page]

GL.JE_BE_ESL_SUMMARIES does not reference any database object

GL.JE_BE_ESL_SUMMARIES is referenced by following:

GL
VIEW - JE_BE_ESL_SUMMARIES#

[top of page]

Table: JE_BE_LINE_TYPE_MAP

Description: Mappings for financial document line types to VAT rules line types
Primary Key: JE_BE_LINE_TYPE_MAP_PK
  1. SOURCE
  2. DOCUMENT_LINE_TYPE
Comments
Indexes
Index Type Tablespace Column
JE_BE_LINE_TYPE_MAP_U1 UNIQUE APPS_TS_TX_IDX SOURCE
DOCUMENT_LINE_TYPE
Columns
Name Datatype Length Mandatory Comments
SOURCE VARCHAR2 (10) Y
DOCUMENT_LINE_TYPE VARCHAR2 (20) Y
VAT_RULE_LINE_TYPE VARCHAR2 (10) Y

[top of page]

GL.JE_BE_LINE_TYPE_MAP does not reference any database object

GL.JE_BE_LINE_TYPE_MAP is referenced by following:

GL
VIEW - JE_BE_LINE_TYPE_MAP#

[top of page]

Table: JE_BE_LOGS

Description: VAT declarations
Primary Key: JE_BE_LOGS_PK
  1. DECLARATION_ID
  2. DECLARATION_TYPE_CODE
  3. SET_OF_BOOKS_ID
Comments
Indexes
Index Type Tablespace Column
JE_BE_LOGS_U1 UNIQUE APPS_TS_TX_IDX DECLARATION_ID
DECLARATION_TYPE_CODE
SET_OF_BOOKS_ID
Columns
Name Datatype Length Mandatory Comments
DECLARATION_ID NUMBER (15) Y
DECLARATION_TYPE_CODE VARCHAR2 (30) Y
SET_OF_BOOKS_ID NUMBER (15) Y
START_DATE DATE

END_DATE DATE

PERIOD_NAME VARCHAR2 (15) Y
DECLARATION_STATUS_CODE VARCHAR2 (30) Y
REGIME_CODE VARCHAR2 (30)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y

[top of page]

GL.JE_BE_LOGS does not reference any database object

GL.JE_BE_LOGS is referenced by following:

GL
VIEW - JE_BE_LOGS#

[top of page]

Table: JE_BE_REPORTERS

Description: Declarer information to be printed on report header of VAT reports
Primary Key: JE_BE_REPORTERS_PK
  1. SET_OF_BOOKS_ID
Comments
Indexes
Index Type Tablespace Column
JE_BE_REPORTERS_U1 UNIQUE APPS_TS_TX_IDX SET_OF_BOOKS_ID
Columns
Name Datatype Length Mandatory Comments
REPORTER_ID NUMBER (15) Y
NAME VARCHAR2 (80) Y
ADDRESS VARCHAR2 (80) Y
POSTAL_CODE VARCHAR2 (12) Y
CITY VARCHAR2 (40) Y
COUNTRY_CODE VARCHAR2 (3) Y
CONTACT VARCHAR2 (80) Y
TELEPHONE VARCHAR2 (20) Y
VAT_NUMBER VARCHAR2 (20) Y
ESTABLISHMENT_NUMBER VARCHAR2 (2)
PROCESSING_UNIT_NUMBER VARCHAR2 (1)
SET_OF_BOOKS_ID NUMBER (15) Y
REGIME VARCHAR2 (1)
AP_REPORT_TO_INTRASTAT_FLAG VARCHAR2 (30)
AR_REPORT_TO_INTRASTAT_FLAG VARCHAR2 (30)
AP_DEFAULT_INTRASTAT_INFO VARCHAR2 (30)
AR_DEFAULT_INTRASTAT_INFO VARCHAR2 (30)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

[top of page]

GL.JE_BE_REPORTERS does not reference any database object

GL.JE_BE_REPORTERS is referenced by following:

GL
VIEW - JE_BE_REPORTERS#

[top of page]

Table: JE_BE_VAT_ALLOCATIONS

Description: Transacations that have been allocated to VAT reporting boxes
Primary Key: JE_BE_VAT_ALLOCATIONS_PK
  1. ALLOCATION_ID
Comments
Indexes
Index Type Tablespace Column
JE_BE_VAT_ALLOCATIONS_U1 UNIQUE APPS_TS_TX_IDX ALLOCATION_ID
JE_BE_VAT_ALLOCATIONS_N1 NONUNIQUE APPS_TS_TX_IDX TRANS_ID
TRANS_LINE_ID
SET_OF_BOOKS_ID
JE_BE_VAT_ALLOCATIONS_N2 NONUNIQUE APPS_TS_TX_IDX TRANS_DATE
Columns
Name Datatype Length Mandatory Comments
ALLOCATION_ID NUMBER (15) Y
SOURCE VARCHAR2 (10) Y
SET_OF_BOOKS_ID NUMBER (15) Y
TRANS_ID NUMBER (15) Y
TRANS_LINE_ID NUMBER (15) Y
OF_TRANS_TYPE VARCHAR2 (20) Y
VAT_TRANS_TYPE VARCHAR2 (30) Y
LINE_TYPE VARCHAR2 (20) Y
TAX_NAME VARCHAR2 (50) Y
AMOUNT NUMBER
Y
TRANS_DATE DATE
Y
VAT_REPORT_BOX VARCHAR2 (2) Y
DECLARATION_ID NUMBER (15)

[top of page]

GL.JE_BE_VAT_ALLOCATIONS does not reference any database object

GL.JE_BE_VAT_ALLOCATIONS is referenced by following:

GL
VIEW - JE_BE_VAT_ALLOCATIONS#

[top of page]

Table: JE_BE_VAT_ALLOC_ERRORS

Description: Allocation/reallocation errors
Comments
Indexes
Index Type Tablespace Column
JE_BE_VAT_ALLOC_ERRORS_N1 NONUNIQUE APPS_TS_TX_IDX TRANS_LINE_ID
Columns
Name Datatype Length Mandatory Comments
SOURCE VARCHAR2 (10) Y
SET_OF_BOOKS_ID NUMBER (15) Y
TRANS_ID NUMBER (15) Y
TRANS_LINE_ID NUMBER (15) Y
OF_TRANS_TYPE VARCHAR2 (20)
VAT_TRANS_TYPE VARCHAR2 (30)
LINE_TYPE VARCHAR2 (20)
TAX_NAME VARCHAR2 (50)
AMOUNT NUMBER
Y
TRANS_DATE DATE
Y
ERROR_NUMBER NUMBER (15) Y
ERROR_DESCRIPTION VARCHAR2 (150) Y
POSTED_FLAG VARCHAR2 (1) Y
PERIOD_NAME VARCHAR2 (15) Y

[top of page]

GL.JE_BE_VAT_ALLOC_ERRORS does not reference any database object

GL.JE_BE_VAT_ALLOC_ERRORS is referenced by following:

GL
VIEW - JE_BE_VAT_ALLOC_ERRORS#

[top of page]

Table: JE_BE_VAT_REP_RULES

Description: Reporting rules for allocating/reallocating amounts to VAT boxes
Primary Key: JE_BE_VAT_REP_RULES_PK
  1. SET_OF_BOOKS_ID
  2. SOURCE
  3. OF_TRANS_TYPE
  4. VAT_TRANS_TYPE
  5. LINE_TYPE
  6. TAX_NAME
Comments
Indexes
Index Type Tablespace Column
JE_BE_VAT_REP_RULES_U1 UNIQUE APPS_TS_TX_IDX SET_OF_BOOKS_ID
SOURCE
OF_TRANS_TYPE
VAT_TRANS_TYPE
LINE_TYPE
TAX_NAME
VAT_REPORT_BOX
NOREC_VAT_REP_BOX
Columns
Name Datatype Length Mandatory Comments
SOURCE VARCHAR2 (10) Y
OF_TRANS_TYPE VARCHAR2 (20) Y
VAT_TRANS_TYPE VARCHAR2 (30) Y
LINE_TYPE VARCHAR2 (20) Y
TAX_NAME VARCHAR2 (50) Y
VAT_REPORT_BOX VARCHAR2 (2)
NOREC_VAT_REP_BOX VARCHAR2 (30)
SIGN_FLAG VARCHAR2 (1)
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

ENABLED_FLAG VARCHAR2 (1) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
SET_OF_BOOKS_ID NUMBER (15) Y

[top of page]

GL.JE_BE_VAT_REP_RULES does not reference any database object

GL.JE_BE_VAT_REP_RULES is referenced by following:

GL
VIEW - JE_BE_VAT_REP_RULES#

[top of page]

Table: JE_CH_PAYMENT_REF

Description: Payment batch information for Swiss EFT payments
Primary Key: JE_CH_PAYMENT_REF_PK
  1. PAYMENT_TYPE
  2. CHECKRUN_NAME
  3. CHECK_NUMBER
Comments
Indexes
Index Type Tablespace Column
JE_CH_PAYMENT_REF_U1 UNIQUE APPS_TS_TX_IDX PAYMENT_TYPE
CHECKRUN_NAME
CHECK_NUMBER
Columns
Name Datatype Length Mandatory Comments
PAYMENT_TYPE VARCHAR2 (3) Y
CHECKRUN_NAME VARCHAR2 (50) Y
CHECK_NUMBER NUMBER (15) Y
REF1 VARCHAR2 (240)
REF2 VARCHAR2 (240)
REF3 VARCHAR2 (240)
REF4 VARCHAR2 (240)
REF5 VARCHAR2 (240)
REF6 VARCHAR2 (240)
REF7 VARCHAR2 (240)
REF8 VARCHAR2 (240)
REF9 VARCHAR2 (240)
REF10 VARCHAR2 (240)

[top of page]

AP.JE_CH_PAYMENT_REF does not reference any database object

AP.JE_CH_PAYMENT_REF is referenced by following:

AP
VIEW - JE_CH_PAYMENT_REF#

[top of page]

Table: JE_CH_SAD_SEQUENCES

Description: Table of sequences for Swiss SAD payments
Primary Key: JE_CH_SAD_SEQUENCES_PK
  1. SAD_ID
Comments
Indexes
Index Type Tablespace Column
JE_CH_SAD_SEQUENCES_U1 UNIQUE APPS_TS_TX_IDX SAD_ID
JE_CH_SAD_SEQUENCES_U2 UNIQUE APPS_TS_TX_IDX MONTH
SA_NR
Columns
Name Datatype Length Mandatory Comments
DUE_DATE VARCHAR2 (6)
MONTH VARCHAR2 (4)
SA_NR VARCHAR2 (2)
SAD_ID NUMBER (15)

[top of page]

AP.JE_CH_SAD_SEQUENCES does not reference any database object

AP.JE_CH_SAD_SEQUENCES is referenced by following:

AP
VIEW - JE_CH_SAD_SEQUENCES#

[top of page]

Table: JE_CZ_CONT_ALLOC_ALL

Description: This table is used to associate a bank account with a Compatible Media contract. A contract can relate to one or more bank accounts.
Primary Key: JE_CZ_CONT_ALLOC_ALL_PK
  1. BANK_ACCOUNT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JE_CZ_CONT_ALLOC_ALL.CONTRACT_ID JE_CZ_EFT_CONTRACTS_ALL
Comments
Columns
Name Datatype Length Mandatory Comments
CONTRACT_ID NUMBER (15) Y
BANK_ACCOUNT_ID NUMBER (15) Y
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
ORG_ID NUMBER (15)
INACTIVE_DATE DATE

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE16 VARCHAR2 (150)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)

[top of page]

AP.JE_CZ_CONT_ALLOC_ALL does not reference any database object

AP.JE_CZ_CONT_ALLOC_ALL is referenced by following:

AP
VIEW - JE_CZ_CONT_ALLOC_ALL#

[top of page]

Table: JE_CZ_EFT_CONTRACTS_ALL

Description: This table will store all the relevant details of a Compatible Media contract between a company and its Bank. This table will contain the range of Interval Numbers allocated to the Accounting files used within the Payment file.
Primary Key: JE_CZ_EFT_CONTRACTS_ALL_PK
  1. CONTRACT_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
JE_CZ_CONT_ALLOC_ALL.CONTRACT_ID JE_CZ_EFT_CONTRACTS_ALL
Comments
Indexes
Index Type Tablespace Column
JE_CZ_EFT_CONTRACTS_U1 UNIQUE APPS_TS_TX_IDX CONTRACT_ID
Columns
Name Datatype Length Mandatory Comments
CONTRACT_ID NUMBER (15) Y
BRANCH_ID NUMBER (15) Y
CLIENT_NAME VARCHAR2 (20) Y
CLIENT_NUMBER NUMBER (10) Y
SECURITY_FIXED_CODE NUMBER (6) Y
AP_INTERVAL_START NUMBER (15) Y
AP_INTERVAL_END NUMBER (15) Y
INTERVAL_START NUMBER (15) Y
INTERVAL_END NUMBER (15) Y
LAST_USED_INTERVAL NUMBER (15)
LAST_USED_TIMESTAMP DATE

LAST_BATCH_FORMATTED VARCHAR2 (50)
PREVIOUS_INTERVAL NUMBER (15)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

ORG_ID NUMBER (15)
INACTIVE_DATE DATE

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE16 VARCHAR2 (150)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)

[top of page]

AP.JE_CZ_EFT_CONTRACTS_ALL does not reference any database object

AP.JE_CZ_EFT_CONTRACTS_ALL is referenced by following:

AP
VIEW - JE_CZ_EFT_CONTRACTS_ALL#

[top of page]

Table: JE_CZ_EFT_DATA_TMP

Description: This is a temporary table used to facilitate validation and the build of the EFT Payment file before printing. This table is emptied before each run and then populated by the report JECZPEFT
Comments
Columns
Name Datatype Length Mandatory Comments
RECORD_SEQUENCE NUMBER (15) Y
LINE_TYPE VARCHAR2 (3) Y
DATA_LINE VARCHAR2 (240) Y
BATCH_ID NUMBER (15) Y

[top of page]

AP.JE_CZ_EFT_DATA_TMP does not reference any database object

AP.JE_CZ_EFT_DATA_TMP is referenced by following:

AP
VIEW - JE_CZ_EFT_DATA_TMP#

[top of page]

Table: JE_DE_AP_BATCHES

Description: Checkrun names for which German separate payment letters have been printed
Primary Key: JE_DE_AP_BATCHES_PK
  1. CHECKRUN_NAME
Comments
Indexes
Index Type Tablespace Column
JE_DE_AP_BATCHES_U1 UNIQUE APPS_TS_TX_IDX CHECKRUN_NAME
Columns
Name Datatype Length Mandatory Comments
CHECKRUN_NAME VARCHAR2 (50) Y

[top of page]

AP.JE_DE_AP_BATCHES does not reference any database object

AP.JE_DE_AP_BATCHES is referenced by following:

AP
VIEW - JE_DE_AP_BATCHES#

[top of page]

Table: JE_DE_AR_BATCHES

Description: Information on Receivables payment batches for which separate letters have been printed
Primary Key: JE_DE_AR_BATCHES_PK
  1. REMIT_BATCH_ID
Comments
Indexes
Index Type Tablespace Column
JE_DE_AR_BATCHES_U1 UNIQUE APPS_TS_TX_IDX REMIT_BATCH_ID
Columns
Name Datatype Length Mandatory Comments
REMIT_BATCH_ID NUMBER (15) Y
REMIT_BATCH_NAME VARCHAR2 (30) Y

[top of page]

AR.JE_DE_AR_BATCHES does not reference any database object

AR.JE_DE_AR_BATCHES is referenced by following:

AR
VIEW - JE_DE_AR_BATCHES#

[top of page]

Table: JE_DE_CHECKRUN_RESULTS

Description: Results of the German Payables EFT Format payments processed
Primary Key: JE_DE_CHECKRUN_RESULTS_PK
  1. JEDE_CHECKRUN_NAME
Comments
Indexes
Index Type Tablespace Column
JE_DE_CHECKRUN_RESULTS_U1 UNIQUE APPS_TS_TX_IDX JEDE_CHECKRUN_NAME
Columns
Name Datatype Length Mandatory Comments
JEDE_CHECKRUN_NAME VARCHAR2 (50) Y
JEDE_NUMBER_OF_PAYMENTS NUMBER

JEDE_CONTRA_AMOUNT NUMBER

JEDE_ACCOUNT_SUM NUMBER

JEDE_BLZ_SUM NUMBER

JEDE_CREATION_DATE DATE

JEDE_COMPANY_NAME VARCHAR2 (60)
JEDE_ADDRESS_LINE_1 VARCHAR2 (60)
JEDE_ADDRESS_LINE_2 VARCHAR2 (60)
JEDE_ADDRESS_LINE_3 VARCHAR2 (60)
JEDE_CITY VARCHAR2 (30)
JEDE_POSTAL_CODE VARCHAR2 (30)
JEDE_BANK_BLZ VARCHAR2 (20)
JEDE_BANK_ACCOUNT_NUMBER VARCHAR2 (20)
JEDE_BANK_NAME VARCHAR2 (60)
JEDE_CURRENCY_CODE VARCHAR2 (3)
JEDE_DISKETTE_NUMBER NUMBER

[top of page]

AP.JE_DE_CHECKRUN_RESULTS does not reference any database object

AP.JE_DE_CHECKRUN_RESULTS is referenced by following:

AP
VIEW - JE_DE_CHECKRUN_RESULTS#

[top of page]

Table: JE_DE_FA_SUMMARY

Description: Summary information on fixed assets
Comments
Columns
Name Datatype Length Mandatory Comments
ASSET_ID NUMBER

TYPE VARCHAR2 (3)
DATE_RUN DATE

YEAR VARCHAR2 (4)
MAJOR_CATEGORY VARCHAR2 (40)
CAPITALIZED_ACCOUNT VARCHAR2 (25)
CIP_ACCOUNT VARCHAR2 (25)
ASSET_COST NUMBER

ADDITIONS NUMBER

RETIREMENTS NUMBER

TRANSFERS NUMBER

APPRECIATIONS NUMBER

DEPR_RESRV NUMBER

DEPR_CURRENT NUMBER

NBV_BEGIN NUMBER

NBV_END NUMBER

BOOK_TYPE_CODE VARCHAR2 (30)
CONC_REQUEST_ID NUMBER (15)

[top of page]

FA.JE_DE_FA_SUMMARY does not reference any database object

FA.JE_DE_FA_SUMMARY is referenced by following:

FA
VIEW - JE_DE_FA_SUMMARY#

[top of page]

Table: JE_DE_REMITTANCE_RESULTS

Description: Results of the German Direct Debit Format program in Receivables
Primary Key: JE_DE_REMITTANCE_RESULTS_PK
  1. JEDE_REMIT_BATCH_ID
Comments
Indexes
Index Type Tablespace Column
JE_DE_REMITTANCE_RESULTS_U1 UNIQUE APPS_TS_TX_IDX JEDE_REMIT_BATCH_ID
Columns
Name Datatype Length Mandatory Comments
JEDE_REMIT_BATCH_ID VARCHAR2 (30) Y
JEDE_NUMBER_OF_RECEIPTS NUMBER

JEDE_CONTRA_AMOUNT NUMBER

JEDE_ACCOUNT_SUM NUMBER

JEDE_BLZ_SUM NUMBER

JEDE_CREATION_DATE DATE

JEDE_COMPANY_NAME VARCHAR2 (240)
JEDE_ADDRESS_LINE_1 VARCHAR2 (240)
JEDE_ADDRESS_LINE_2 VARCHAR2 (240)
JEDE_ADDRESS_LINE_3 VARCHAR2 (240)
JEDE_CITY VARCHAR2 (30)
JEDE_POSTAL_CODE VARCHAR2 (30)
JEDE_BANK_BLZ VARCHAR2 (30)
JEDE_BANK_ACCOUNT_NUMBER VARCHAR2 (20)
JEDE_BANK_NAME VARCHAR2 (60)

[top of page]

AR.JE_DE_REMITTANCE_RESULTS does not reference any database object

AR.JE_DE_REMITTANCE_RESULTS is referenced by following:

AR
VIEW - JE_DE_REMITTANCE_RESULTS#

[top of page]

Table: JE_DK_EDI_TMP

Description: Table to store error messages when updating Danish EFT invoices to use EDI flexfields
Comments
Columns
Name Datatype Length Mandatory Comments
RECORD_ID NUMBER

BUFFER VARCHAR2 (2000)

[top of page]

AP.JE_DK_EDI_TMP does not reference any database object

AP.JE_DK_EDI_TMP is referenced by following:

AP
VIEW - JE_DK_EDI_TMP#

[top of page]

Table: JE_DK_PAY_CATEGORIES

Description: Stores payment categories and their attributes
Primary Key: JE_DK_PAY_CATEGORIES_PK
  1. PAYMENT_CATEGORY_ID
Comments
Indexes
Index Type Tablespace Column
JE_DK_PAY_CATEGORIES_U1 UNIQUE APPS_TS_TX_IDX PAYMENT_CATEGORY_ID
Columns
Name Datatype Length Mandatory Comments
PAYMENT_CATEGORY_ID NUMBER (15) Y
PAYMENT_CATEGORY VARCHAR2 (80) Y
PAYMENT_MEANS VARCHAR2 (30)
PAYMENT_CHANNEL VARCHAR2 (30)
AGREEMENT_TYPE VARCHAR2 (1)
PARTY_ID VARCHAR2 (1)
SETTLEMENT_CODE VARCHAR2 (1)
IMPORT_CODE VARCHAR2 (1)
IMPORT_MONTH VARCHAR2 (1)
BANK_CODE VARCHAR2 (1)
FOREIGN_PAYMENT_FLAG VARCHAR2 (1)
SUPPLIER_MESSAGE VARCHAR2 (1)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

AP.JE_DK_PAY_CATEGORIES does not reference any database object

AP.JE_DK_PAY_CATEGORIES is referenced by following:

AP
VIEW - JE_DK_PAY_CATEGORIES#

[top of page]

Table: JE_DOC_SEQUENCE_AUDIT

Description: Provides audit information for the Greek Accounting Sequence
Primary Key: JE_DOC_SEQUENCE_AUDIT_PK
  1. DOC_SEQUENCE_ID
  2. DOC_SEQUENCE_VALUE
Comments
Indexes
Index Type Tablespace Column
JE_DOC_SEQUENCE_AUDIT_U1 UNIQUE APPS_TS_TX_IDX DOC_SEQUENCE_ID
DOC_SEQUENCE_VALUE
Columns
Name Datatype Length Mandatory Comments
DOC_SEQUENCE_ID NUMBER
Y
DOC_SEQUENCE_ASSIGNMENT_ID NUMBER
Y
DOC_SEQUENCE_VALUE NUMBER
Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

GL.JE_DOC_SEQUENCE_AUDIT does not reference any database object

GL.JE_DOC_SEQUENCE_AUDIT is referenced by following:

GL
VIEW - JE_DOC_SEQUENCE_AUDIT#

[top of page]

Table: JE_ES_MESSAGES_ALL

Description: Temporary messages table used by Spanish reports
Primary Key: JE_ES_MESSAGES_ALL_UK
  1. STEP
  2. ORG_ID
Comments

The Temporary Messages table is used during Spanish Withholding
Tax processing in Oracle Payables and Oracle Receivables.
Beginning in Release 11, this table is now partitioned by
ORG_ID, so that Withholding Tax can be run simultaneously by users
utilizing different operating units.
During each processing, records from previous processing are first
deleted before new ones are inserted.

Indexes
Index Type Tablespace Column
JE_ES_MESSAGES_U1 UNIQUE APPS_TS_TX_IDX STEP
ORG_ID
Columns
Name Datatype Length Mandatory Comments
STEP NUMBER

Processing step
MESSAGE VARCHAR2 (60)
Message text
ORG_ID NUMBER (15)
Organization identifier

[top of page]

JE.JE_ES_MESSAGES_ALL does not reference any database object

JE.JE_ES_MESSAGES_ALL is referenced by following:

JE
VIEW - JE_ES_MESSAGES_ALL#

[top of page]

Table: JE_ES_MODELO_190_ALL

Description: Information for Spanish Withholding Tax processing
Primary Key: JE_ES_MODELO_190_ALL_PK
  1. CONC_REQ_ID
  2. ORG_ID
Comments

JE_ES_MODELO_190_ALL contains information relating to Spanish
Withholding Tax processing.
During each processing, records from previous processing are first
deleted before new records are inserted.
Scope: public
Product: JE
Lifecycle: active
Display Name: Spanish Withholding Tax Interface
Category: BUSINESS_ENTITY JE_ES_WHT

Indexes
Index Type Tablespace Column
JE_ES_MODELO_190_N1 NONUNIQUE APPS_TS_TX_IDX CONC_REQ_ID
ORG_ID
Columns
Name Datatype Length Mandatory Comments
ORG_ID NUMBER

Organization identifier
CONC_REQ_ID NUMBER

Concurrent request identifier
FIN_IND VARCHAR2 (1) Y Record source ("S" is for Payables)
REMUN_TYPE VARCHAR2 (1) Y Remuneration type
VENDOR_NIF VARCHAR2 (9) Y Supplier taxpayer identifier
VENDOR_NAME VARCHAR2 (240) Y Supplier name
INVOICE_ID NUMBER

Invoice identifier
INVOICE_NUM VARCHAR2 (50)
Invoice number
INV_DOC_SEQ_NUM VARCHAR2 (100)
Invoice document sequence number
INVOICE_DATE DATE

Invoice date
GL_DATE DATE

General Ledger date
INVOICE_PAYMENT_ID NUMBER

Invoice payment identifier
DATE_PAID DATE

Date invoice paid
NET_AMOUNT NUMBER
Y Net amount
WITHHOLDING_TAX_AMOUNT NUMBER
Y Withholding tax amount
ZIP_ELECTRONIC VARCHAR2 (5)
Postal code/country
ZIP_LEGAL VARCHAR2 (5)
Postal code
CITY_LEGAL VARCHAR2 (25)
City
NUM_CHILDREN NUMBER

Number of children
SIGN VARCHAR2 (1)
Sign of net amount
TAX_RATE NUMBER

Tax rate
TAX_NAME VARCHAR2 (15)
Tax name
YEAR_DUE NUMBER

Year withholding tax is due
SUB_REMUN_TYPE VARCHAR2 (2)
Subtype of remuneration
WITHHOLDABLE_AMT_IN_KIND NUMBER

Withholdable amount in kind
WITHHOLDABLE_AMT_IN_KIND_SIGN VARCHAR2 (1)
Withholding tax amount sign
WITHHELD_AMT_IN_KIND NUMBER

Withheld amount in kind
WITHHELD_PYMT_AMT_IN_KIND NUMBER

Withheld amount for payments in kind
EARNED_AMOUNTS NUMBER

Amounts earned in Ceuta or Melilla
CONTRACT_TYPE NUMBER

Type of contract
BIRTH_YEAR NUMBER

Year of birth
DISABLED NUMBER

Disabled
FAMILY_SITUATION NUMBER

Family situation
PARTNER_FISCAL_CODE VARCHAR2 (15)
Partner's fiscal code
DESCENDANT_LT_3 NUMBER

Descendants less than 3 years old
DESCENDANT_BT_3_16 NUMBER

Descendants between 3 and 16 years old
DESCENDANT_BT_16_25 NUMBER

Descendants between 16 and 25 years old
DISABLE_DESC_BT_33_65 NUMBER

Disabled descendants between 33% and 65%
DISABLE_DESC_GT_65 NUMBER

Disabled descendants more than 65%
DESCENDANT_TOTAL NUMBER

Total number of descendants
DEDUCTIONS NUMBER

Deductions
EXPENSES NUMBER

Expenses
SPOUSE_MAINTENANCE_AMT NUMBER

Maintenance of spouse
CHILDREN_MAINTENANCE_AMT NUMBER

Maintenance of children
LEGAL_ENTITY_ID NUMBER

Legal Entity Identifier

[top of page]

JE.JE_ES_MODELO_190_ALL does not reference any database object

JE.JE_ES_MODELO_190_ALL is referenced by following:

JE
VIEW - JE_ES_MODELO_190_ALL#

[top of page]

Table: JE_ES_MODELO_347_ALL

Description: Information for Spanish Payables Third Party Operations reporting
Primary Key: JE_ES_MODELO_347_ALL_PK
  1. TIPO
  2. FIN_IND
  3. SET_OF_BOOKS_ID
Comments

JE_ES_MODELO_347_ALL is a partitioned table that contains information
from Third Party Operations processing. The NOMBRE column stores the following information:
For a person, the first surname, a space, the second surname,
a space, and the whole first name
For a company, the registered name or title with no
acronyms.
The TIPO column stores one of the following:
A - Purchases (also populated by Oracle Payables)
C - Mediations
D - Non Business Purchases by Public Bodies
E - Grants or Subsidies
The CODIGO_POSTAL column stores one of the following:
For domestic third parties, the first two characters of the postal
code (such as the numeric code for the province) followed by
three zeros (000).
For third parties whose registered office is outside Spain,
ninety-nine (99) followed by the 3-digit numeric code for the
country as defined by the Spanish Government in the B.O.E. 31-Dec-1992.
During each processing, records from previous processing are first
deleted before new ones are inserted.

Columns
Name Datatype Length Mandatory Comments
IMPORTE NUMBER
Y Amount in Spanish pesetas (without decimals)
SET_OF_BOOKS_ID NUMBER (15) Y Set of Books identifier
ORG_ID NUMBER (15)
Organization identifier
TIPO VARCHAR2 (1) Y Type of operation (A for Payables or B for Receivables)
NOMBRE VARCHAR2 (60)
Surnames, first name or registered name of declaree
NIF VARCHAR2 (9)
Taxpayer identifier of declaree
SIGLA VARCHAR2 (4)
Not currently used
MUNICIPIO VARCHAR2 (50)
Not currently used
CODIGO_POSTAL VARCHAR2 (5)
Postal code of declaree's registered office address
FIN_IND VARCHAR2 (1)
Source (S for system created)
VIA_PUBLICA VARCHAR2 (50)
Not currently used
NUMERO NUMBER (5)
Not currently used
COMENTARIO VARCHAR2 (130)
Not currently used
FLAG_ARRENDA VARCHAR2 (1)
'Y' means property rental
ESCALERA VARCHAR2 (2)
Staircase number of rental property
PISO VARCHAR2 (2)
Floor number of rental property
PUERTA VARCHAR2 (2)
Door number of rental property
REF_CATASTRAL VARCHAR2 (25)
Rates reference for rental property

[top of page]

JE.JE_ES_MODELO_347_ALL does not reference any database object

JE.JE_ES_MODELO_347_ALL is referenced by following:

JE
VIEW - JE_ES_MODELO_347_ALL#

[top of page]

Table: JE_ES_MODELO_349_ALL

Description: Information for Spanish Payables Third Party Operations reporting
Primary Key: JE_ES_MODELO_349_ALL_PK
  1. CLAVE_OPERACION
  2. FIN_IND
  3. SET_OF_BOOKS_ID
Comments

JE_ES_MODELO_349_ALL is a temporary table cleared and populated in each data extraction run. This table contains data used for the creation of Spanish Payables and Spanish Receivables Inter-EU Operations Summary Magnetic Formats (Modelo 349) that provide electronic reports for submission to the Spanish government.

Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Y Set of Books ID
CLAVE_OPERACION VARCHAR2 (1) Y Operation type
ORG_ID NUMBER (15)
Organization
NIF_COMUNITARIO VARCHAR2 (14)
VAT registration number
NOMBRE VARCHAR2 (40)
Name of the declared
BASE_IMPONIBLE NUMBER

Amount of the operations
OPERACION_TRIANGULAR VARCHAR2 (1)
Triangulation
EJERCICIO VARCHAR2 (2)
Year corrected
PERIODO VARCHAR2 (2)
Period corrected
FIN_IND VARCHAR2 (1) Y 'Y' means created by the system
RUNNING_TOTAL NUMBER

Running total for the report
FORMERLY_DECLARED_AMOUNT NUMBER

Formerly declared amount of the Spanish Inter-EU operations
PRINT_PERIOD VARCHAR2 (2)
The period that report is printed for
PRINT_YEAR VARCHAR2 (4)
The year that the report is printed for
PRINT_MODE VARCHAR2 (1)
Printing mode

[top of page]

JE.JE_ES_MODELO_349_ALL does not reference any database object

JE.JE_ES_MODELO_349_ALL is referenced by following:

JE
VIEW - JE_ES_MODELO_349_ALL#

[top of page]

Table: JE_ES_MODELO_415_ALL

Description: Information for Spanish Payables Third Party Operations reporting
Primary Key: JE_ES_MODELO_415_ALL_PK
  1. CLAVE_OPERACION
  2. FIN_IND
  3. SET_OF_BOOKS_ID
Comments

This table contains invoice information used by the Spanish Canary Islands Annual Operations Magnetic Format. It is populated temporarily during each run.

Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Y Set of Books identifier
ORG_ID NUMBER (15)
Operating unit identifier
CLAVE_OPERACION VARCHAR2 (1) Y Operation key
NIF VARCHAR2 (9)
Declared's taxpayer identifiler
NOMBRE VARCHAR2 (40)
Declared's name
IMPORTE NUMBER

Turnover amount
DIRECCION VARCHAR2 (32)
Declared's address
CODIGO_POSTAL VARCHAR2 (5)
Postal code of the declared's address
MUNICIPIO VARCHAR2 (24)
Town or city of the declared's address
FIN_IND VARCHAR2 (1) Y 'Y' if inserted by the program

[top of page]

JE.JE_ES_MODELO_415_ALL does not reference any database object

JE.JE_ES_MODELO_415_ALL is referenced by following:

JE
VIEW - JE_ES_MODELO_415_ALL#

[top of page]

Table: JE_FI_NUMBER_VALIDATION

Description: Table of values for Finnish validation
Primary Key: JE_FI_NUMBER_VALIDATION_PK
  1. VALUE
Comments
Columns
Name Datatype Length Mandatory Comments
VALUE VARCHAR2 (1)

[top of page]

AP.JE_FI_NUMBER_VALIDATION does not reference any database object

AP.JE_FI_NUMBER_VALIDATION is referenced by following:

AP
VIEW - JE_FI_NUMBER_VALIDATION#

[top of page]

Table: JE_FR_DAS2_DETAILS_T

Description: All data extracted from the core tables will be inserted into this table initially.
Comments
Indexes
Index Type Tablespace Column
JE_FR_DAS2_DETAILS_T_N1 NONUNIQUE APPS_TS_TX_IDX LEGAL_ENTITY_ID
ESTABLISHMENT_ID
Columns
Name Datatype Length Mandatory Comments
LEGAL_ENTITY_ID NUMBER (15) Y
ESTABLISHMENT_ID NUMBER (15) Y
SIREN_ETAB NUMBER (9)
NIC_ETAB NUMBER (5)
SECTION_DAS VARCHAR2 (2)
VALIDITE NUMBER (4)
TYPE_DAS VARCHAR2 (1)
TYPE_ENREG VARCHAR2 (3)
SIRET_BENEF VARCHAR2 (14)
NOM VARCHAR2 (30)
PRENOM VARCHAR2 (20)
RAISON_SOCIALE VARCHAR2 (50)
PROFESSION VARCHAR2 (30)
ADR_COMPL VARCHAR2 (32)
Z1 VARCHAR2 (1)
ADR_NUM VARCHAR2 (4)
ADR_TYPE VARCHAR2 (1)
Z2 VARCHAR2 (1)
ADR_VOIE VARCHAR2 (26)
ADR_INSEE VARCHAR2 (5)
Z3 VARCHAR2 (1)
ADR_COMMUNE VARCHAR2 (26)
ADR_CPOSTAL VARCHAR2 (5)
Z4 VARCHAR2 (1)
ADR_BUR_DIST VARCHAR2 (26)
DHON_H NUMBER (10)
DCOM_C NUMBER (10)
DCO_CO NUMBER (10)
DRIS_R NUMBER (10)
DJE_JP NUMBER (10)
DDA_DA NUMBER (10)
DDI_I NUMBER (10)
DAU_AR NUMBER (10)
INDE NUMBER (10)
AVAN NUMBER (10)
RETE NUMBER (10)
NAT_AVAN_NOUR VARCHAR2 (1)
NAT_AVAN_LOGE VARCHAR2 (1)
NAT_AVAN_VOIT VARCHAR2 (1)
NAT_AVAN_AUTR VARCHAR2 (1)
Z5 VARCHAR2 (1)
NAT_RETE_ALLO VARCHAR2 (1)
NAT_RETE_REMB VARCHAR2 (1)
NAT_RETE_PRIS VARCHAR2 (1)
NAT_TVA_REDUI VARCHAR2 (1)
NAT_TVA_DISPE VARCHAR2 (1)
TVA_NETTE NUMBER (10)
Z6 VARCHAR2 (240)
SEGMENT1 VARCHAR2 (30)
AGE_11 NUMBER (11)
SET_OF_BOOKS_ID NUMBER (15) Y
VENDOR_SITE_ID NUMBER
Y
CHECK_NUMBER NUMBER (15) Y
INVOICE_NUM VARCHAR2 (50) Y
VENDOR_SITE_CODE VARCHAR2 (15) Y
TAX_IDENTIFICATION_NUM VARCHAR2 (20) Y
VENDOR_NAME VARCHAR2 (80) Y
TYPE_1099 VARCHAR2 (10)
INVOICE_DATE DATE

INVOICE_AMOUNT NUMBER

CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

AP.JE_FR_DAS2_DETAILS_T does not reference any database object

AP.JE_FR_DAS2_DETAILS_T is referenced by following:

AP
VIEW - JE_FR_DAS2_DETAILS_T#

[top of page]

Table: JE_FR_DAS2_ETB_HEADERS_T

Description: This table will be used to store the header information for an establishment.
Comments
Indexes
Index Type Tablespace Column
J_FR_DAS2_ETB_HEADERS_T_N1 NONUNIQUE APPS_TS_TX_IDX LEGAL_ENTITY_ID
ESTABLISHMENT_ID
Columns
Name Datatype Length Mandatory Comments
LEGAL_ENTITY_ID NUMBER (15) Y
ESTABLISHMENT_ID NUMBER (15) Y
SET_OF_BOOKS_ID NUMBER (15) Y
SIREN_ETAB NUMBER (9)
NIC_ETAB NUMBER (5)
SECTION_DAS VARCHAR2 (2)
VALIDITE NUMBER (4)
TYPE_DAS VARCHAR2 (1)
TYPE_ENREG VARCHAR2 (3)
Z01_94_1 VARCHAR2 (14)
CODE_APE VARCHAR2 (5)
Z01_94_2 VARCHAR2 (1)
SIRET_01_JAN NUMBER (9)
NIC_01_JAN NUMBER (5)
Z02 VARCHAR2 (41)
RAISON_SOCIALE VARCHAR2 (50)
ADR_COMPL VARCHAR2 (32)
Z1 VARCHAR2 (1)
ADR_CONCAT VARCHAR2 (64)
ADR_INSEE VARCHAR2 (5)
Z3 VARCHAR2 (1)
ADR_COMMUNE VARCHAR2 (26)
ADR_CPOSTAL VARCHAR2 (5)
Z4 VARCHAR2 (1)
ADR_BUR_DIST VARCHAR2 (26)
PROFESSION VARCHAR2 (40)
Z5 VARCHAR2 (53)
CODE_TAXE_SAL VARCHAR2 (1)
Z6 VARCHAR2 (301)
NUM_ENR NUMBER (6)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

AP.JE_FR_DAS2_ETB_HEADERS_T does not reference any database object

AP.JE_FR_DAS2_ETB_HEADERS_T is referenced by following:

AP
VIEW - JE_FR_DAS2_ETB_HEADERS_T#

[top of page]

Table: JE_FR_DAS2_LE_ETB_SUMM_T

Description: 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 data summarized by establisment_id (type 300) records.
Comments
Indexes
Index Type Tablespace Column
JE_FR_DAS2_LE_ETB_SUMM_T_N1 NONUNIQUE APPS_TS_TX_IDX LEGAL_ENTITY_ID
ESTABLISHMENT_ID
Columns
Name Datatype Length Mandatory Comments
LEGAL_ENTITY_ID NUMBER (15) Y
ESTABLISHMENT_ID NUMBER (15) Y
SIREN_ETAB NUMBER (9)
SIREN_ENT NUMBER (9)
NIC_ETAB NUMBER (5)
Z0 VARCHAR2 (12)
SECTION_DAS VARCHAR2 (2)
VALIDITE NUMBER (4)
TYPE_DAS VARCHAR2 (1)
TYPE_ENREG VARCHAR2 (3)
SIRET_BENEF VARCHAR2 (14)
NOM VARCHAR2 (30)
PRENOM VARCHAR2 (20)
RAISON_SOCIALE VARCHAR2 (50)
PROFESSION VARCHAR2 (30)
ADR_COMPL VARCHAR2 (32)
Z1 VARCHAR2 (1)
ADR_NUM VARCHAR2 (4)
ADR_TYPE VARCHAR2 (1)
Z2 VARCHAR2 (1)
ADR_VOIE VARCHAR2 (26)
ADR_INSEE VARCHAR2 (5)
Z3 VARCHAR2 (1)
ADR_COMMUNE VARCHAR2 (26)
ADR_CPOSTAL VARCHAR2 (5)
Z4 VARCHAR2 (1)
ADR_BUR_DIST VARCHAR2 (26)
DHON_H NUMBER (10)
DCOM_C NUMBER (10)
DCO_CO NUMBER (10)
DRIS_R NUMBER (10)
DJE_JP NUMBER (10)
DDA_DA NUMBER (10)
DDI_I NUMBER (10)
DAU_AR NUMBER (10)
INDE NUMBER (10)
AVAN NUMBER (10)
RETE NUMBER (10)
NAT_AVAN_NOUR VARCHAR2 (1)
NAT_AVAN_LOGE VARCHAR2 (1)
NAT_AVAN_VOIT VARCHAR2 (1)
NAT_AVAN_AUTR VARCHAR2 (1)
Z5 VARCHAR2 (1)
NAT_RETE_ALLO VARCHAR2 (1)
NAT_RETE_REMB VARCHAR2 (1)
NAT_RETE_PRIS VARCHAR2 (1)
NAT_TVA_REDUI VARCHAR2 (1)
NAT_TVA_DISPE VARCHAR2 (1)
TVA_NETTE NUMBER (10)
Z6 VARCHAR2 (240)
SEGMENT1 VARCHAR2 (30)
AGE_11 NUMBER (11)
SET_OF_BOOKS_ID NUMBER (15) Y
VENDOR_SITE_ID NUMBER
Y
CHECK_NUMBER NUMBER (15) Y
INVOICE_NUM VARCHAR2 (50) Y
VENDOR_SITE_CODE VARCHAR2 (15) Y
TAX_IDENTIFICATION_NUM VARCHAR2 (20) Y
VENDOR_NAME VARCHAR2 (80) Y
TYPE_1099 VARCHAR2 (10)
INVOICE_DATE DATE

INVOICE_AMOUNT NUMBER

BASE_BRUTE_FISC NUMBER (12)
REMUNERATIONS_NET NUMBER (12)
AVANTAGES_NAT NUMBER (12)
FRAIS_PROF NUMBER (12)
CHEQUE_VAC NUMBER (12)
TOTAL_IMPOS NUMBER (12)
TOTAL_BASE_IMPOS1 NUMBER (12)
TOTAL_BASE_IMPOS2 NUMBER (12)
TOTAL_RET NUMBER (12)
TAXE_SAL NUMBER (12)
EFFECTIF_ENT NUMBER (6)
EFFECTIF_ETAB NUMBER (6)
NOM_RESP VARCHAR2 (30)
PRENOM_RESP VARCHAR2 (30)
TPH_FONC_RESP VARCHAR2 (30)
CONTACTE_NOM VARCHAR2 (30)
CONTACTE_PRENOM VARCHAR2 (30)
CONTACTE_TPH VARCHAR2 (30)
NBRE_ETAB NUMBER (5)
NBRE_200 NUMBER (6)
NBRE_210 NUMBER (6)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

AP.JE_FR_DAS2_LE_ETB_SUMM_T does not reference any database object

AP.JE_FR_DAS2_LE_ETB_SUMM_T is referenced by following:

AP
VIEW - JE_FR_DAS2_LE_ETB_SUMM_T#

[top of page]

Table: JE_FR_DAS2_LE_HEADERS_T

Description: This table will be used to store the header information for a Legal Entity.
Comments
Indexes
Index Type Tablespace Column
JE_FR_DAS2_LE_HEADERS_T_N1 NONUNIQUE APPS_TS_TX_IDX LEGAL_ENTITY_ID
SIRET_ENTR
Columns
Name Datatype Length Mandatory Comments
LEGAL_ENTITY_ID NUMBER (15) Y
SIRET_ENTR NUMBER (9)
SET_OF_BOOKS_ID NUMBER (15) Y
Z01 VARCHAR2 (12)
TYPE_ENREG VARCHAR2 (3) Y
RAISON_SOCIALE VARCHAR2 (50)
Z0_94_1 VARCHAR2 (4)
CODE_APE VARCHAR2 (5)
Z0_94_2 VARCHAR2 (50)
ADR_COMPL VARCHAR2 (32)
Z1 VARCHAR2 (1)
ADR_CONCAT VARCHAR2 (64)
ADR_INSEE VARCHAR2 (5)
Z3 VARCHAR2 (1)
ADR_COMMUNE VARCHAR2 (26)
ADR_CPOSTAL VARCHAR2 (5)
Z4 VARCHAR2 (1)
ADR_BUR_DIST VARCHAR2 (26)
Z5 VARCHAR2 (8)
TYPE_FICHIER VARCHAR2 (1)
SIRET_ETAB NUMBER (14)
Z6 VARCHAR2 (5)
ADR_COMPL_ET VARCHAR2 (32)
Z7 VARCHAR2 (1)
ADR_CONCAT_ET VARCHAR2 (64)
ADR_INSEE_ET VARCHAR2 (5)
Z9 VARCHAR2 (1)
ADR_COMMUNE_ET VARCHAR2 (26)
ADR_CPOSTAL_ET VARCHAR2 (5)
Z10 VARCHAR2 (1)
ADR_BUR_DIST_ET VARCHAR2 (26)
Z11 VARCHAR2 (240)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

AP.JE_FR_DAS2_LE_HEADERS_T does not reference any database object

AP.JE_FR_DAS2_LE_HEADERS_T is referenced by following:

AP
VIEW - JE_FR_DAS2_LE_HEADERS_T#

[top of page]

Table: JE_FR_DAS2_VEN_SUMMARY_T

Description: 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 inserted into this table.
Comments
Indexes
Index Type Tablespace Column
JE_FR_DAS2_VEN_SUMM_T_N1 NONUNIQUE APPS_TS_TX_IDX LEGAL_ENTITY_ID
ESTABLISHMENT_ID
VENDOR_SITE_ID
Columns
Name Datatype Length Mandatory Comments
LEGAL_ENTITY_ID NUMBER (15) Y
ESTABLISHMENT_ID NUMBER (15) Y
SIREN_ETAB NUMBER (9)
NIC_ETAB NUMBER (5)
SECTION_DAS VARCHAR2 (2)
VALIDITE NUMBER (4)
TYPE_DAS VARCHAR2 (1)
TYPE_ENREG VARCHAR2 (3)
SIRET_BENEF VARCHAR2 (14)
NOM VARCHAR2 (30)
PRENOM VARCHAR2 (20)
RAISON_SOCIALE VARCHAR2 (50)
PROFESSION VARCHAR2 (30)
ADR_COMPL VARCHAR2 (32)
Z1 VARCHAR2 (1)
ADR_NUM VARCHAR2 (4)
ADR_TYPE VARCHAR2 (1)
Z2 VARCHAR2 (1)
ADR_VOIE VARCHAR2 (26)
ADR_INSEE VARCHAR2 (5)
Z3 VARCHAR2 (1)
ADR_COMMUNE VARCHAR2 (26)
ADR_CPOSTAL VARCHAR2 (5)
Z4 VARCHAR2 (1)
ADR_BUR_DIST VARCHAR2 (26)
DHON_H NUMBER (10)
DCOM_C NUMBER (10)
DCO_CO NUMBER (10)
DRIS_R NUMBER (10)
DJE_JP NUMBER (10)
DDA_DA NUMBER (10)
DDI_I NUMBER (10)
DAU_AR NUMBER (10)
INDE NUMBER (10)
AVAN NUMBER (10)
RETE NUMBER (10)
NAT_AVAN_NOUR VARCHAR2 (1)
NAT_AVAN_LOGE VARCHAR2 (1)
NAT_AVAN_VOIT VARCHAR2 (1)
NAT_AVAN_AUTR VARCHAR2 (1)
Z5 VARCHAR2 (1)
NAT_RETE_ALLO VARCHAR2 (1)
NAT_RETE_REMB VARCHAR2 (1)
NAT_RETE_PRIS VARCHAR2 (1)
NAT_TVA_REDUI VARCHAR2 (1)
NAT_TVA_DISPE VARCHAR2 (1)
TVA_NETTE NUMBER (10)
Z6 VARCHAR2 (240)
SEGMENT1 VARCHAR2 (30)
AGE_11 NUMBER (11)
SET_OF_BOOKS_ID NUMBER (15) Y
VENDOR_SITE_ID NUMBER
Y
CHECK_NUMBER NUMBER (15) Y
INVOICE_NUM VARCHAR2 (50) Y
VENDOR_SITE_CODE VARCHAR2 (15) Y
TAX_IDENTIFICATION_NUM VARCHAR2 (20) Y
VENDOR_NAME VARCHAR2 (80) Y
TYPE_1099 VARCHAR2 (10)
INVOICE_DATE DATE

INVOICE_AMOUNT NUMBER

CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

AP.JE_FR_DAS2_VEN_SUMMARY_T does not reference any database object

AP.JE_FR_DAS2_VEN_SUMMARY_T is referenced by following:

AP
VIEW - JE_FR_DAS2_VEN_SUMMARY_T#

[top of page]

Table: JE_FR_DAS_010

Description: Record 010 information for French DAS2 reports
Primary Key: JE_FR_DAS_010_PK
  1. SET_OF_BOOKS_ID
  2. TYPE_ENREG
Comments
Indexes
Index Type Tablespace Column
JE_FR_DAS_010_U1 UNIQUE APPS_TS_TX_IDX SET_OF_BOOKS_ID
TYPE_ENREG
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Y
TYPE_ENREG VARCHAR2 (3) Y
SIRET_ENTR NUMBER (9)
Z01 VARCHAR2 (12)
Z0_94_1 VARCHAR2 (14)
CODE_APE VARCHAR2 (4)
Z0_94_2 VARCHAR2 (5)
RAISON_SOCIALE VARCHAR2 (50)
ADR_COMPL VARCHAR2 (32)
Z1 VARCHAR2 (1)
ADR_CONCAT VARCHAR2 (64)
ADR_INSEE VARCHAR2 (5)
Z3 VARCHAR2 (1)
ADR_COMMUNE VARCHAR2 (26)
ADR_CPOSTAL VARCHAR2 (5)
Z4 VARCHAR2 (1)
ADR_BUR_DIST VARCHAR2 (26)
Z5 VARCHAR2 (8)
TYPE_FICHIER VARCHAR2 (1)
SIRET_ETAB NUMBER (14)
Z6 VARCHAR2 (5)
ADR_COMPL_ET VARCHAR2 (32)
Z7 VARCHAR2 (1)
ADR_CONCAT_ET VARCHAR2 (64)
ADR_INSEE_ET VARCHAR2 (5)
Z9 VARCHAR2 (1)
ADR_COMMUNE_ET VARCHAR2 (26)
ADR_CPOSTAL_ET VARCHAR2 (5)
Z10 VARCHAR2 (1)
ADR_BUR_DIST_ET VARCHAR2 (26)
Z11 VARCHAR2 (288)

[top of page]

AP.JE_FR_DAS_010 does not reference any database object

AP.JE_FR_DAS_010 is referenced by following:

AP
VIEW - JE_FR_DAS_010#

[top of page]

Table: JE_FR_DAS_010_NEW

Description: New version of JE_FR_DAS_010 table
Primary Key: JE_FR_DAS_010_NEW_PK
  1. SET_OF_BOOKS_ID
  2. TYPE_ENREG
Comments
Indexes
Index Type Tablespace Column
JE_FR_DAS_010_NEW_U1 UNIQUE APPS_TS_TX_IDX SET_OF_BOOKS_ID
TYPE_ENREG
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Y
TYPE_ENREG VARCHAR2 (3) Y
SIRET_ENTR NUMBER (9)
Z01 VARCHAR2 (12)
Z0_94_1 VARCHAR2 (14)
CODE_APE VARCHAR2 (4)
Z0_94_2 VARCHAR2 (5)
RAISON_SOCIALE VARCHAR2 (50)
ADR_COMPL VARCHAR2 (32)
Z1 VARCHAR2 (1)
ADR_CONCAT VARCHAR2 (64)
ADR_INSEE VARCHAR2 (5)
Z3 VARCHAR2 (1)
ADR_COMMUNE VARCHAR2 (26)
ADR_CPOSTAL VARCHAR2 (5)
Z4 VARCHAR2 (1)
ADR_BUR_DIST VARCHAR2 (26)
Z5 VARCHAR2 (8)
TYPE_FICHIER VARCHAR2 (1)
SIRET_ETAB NUMBER (14)
Z6 VARCHAR2 (5)
ADR_COMPL_ET VARCHAR2 (32)
Z7 VARCHAR2 (1)
ADR_CONCAT_ET VARCHAR2 (64)
ADR_INSEE_ET VARCHAR2 (5)
Z9 VARCHAR2 (1)
ADR_COMMUNE_ET VARCHAR2 (26)
ADR_CPOSTAL_ET VARCHAR2 (5)
Z10 VARCHAR2 (1)
ADR_BUR_DIST_ET VARCHAR2 (26)
Z11 VARCHAR2 (288)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)

[top of page]

AP.JE_FR_DAS_010_NEW does not reference any database object

AP.JE_FR_DAS_010_NEW is referenced by following:

AP
VIEW - JE_FR_DAS_010_NEW#

[top of page]

Table: JE_FR_DAS_020

Description: Record 020 information for French DAS2 reports
Comments
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Y
SIREN_ETAB NUMBER (9)
NIC_ETAB NUMBER (5)
SECTION VARCHAR2 (2)
VALIDITE NUMBER (4)
TYPE_DAS VARCHAR2 (1)
TYPE_ENREG VARCHAR2 (3)
Z01_94_1 VARCHAR2 (14)
CODE_APE VARCHAR2 (4)
Z01_94_2 VARCHAR2 (1)
SIRET_01_JAN NUMBER (9)
NIC_01_JAN NUMBER (5)
Z02 VARCHAR2 (41)
RAISON_SOCIALE VARCHAR2 (50)
ADR_COMPL VARCHAR2 (32)
Z1 VARCHAR2 (1)
ADR_CONCAT VARCHAR2 (64)
ADR_INSEE VARCHAR2 (5)
Z3 VARCHAR2 (1)
ADR_COMMUNE VARCHAR2 (26)
ADR_CPOSTAL VARCHAR2 (5)
Z4 VARCHAR2 (1)
ADR_BUR_DIST VARCHAR2 (26)
PROFESSION VARCHAR2 (40)
Z5 VARCHAR2 (53)
CODE_TAXE_SAL VARCHAR2 (1)
Z6 VARCHAR2 (301)
NUM_ENR NUMBER (6)

[top of page]

AP.JE_FR_DAS_020 does not reference any database object

AP.JE_FR_DAS_020 is referenced by following:

AP
VIEW - JE_FR_DAS_020#

[top of page]

Table: JE_FR_DAS_020_NEW

Description: New version of JE_FR_DAS_020 table
Comments
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Y
SIREN_ETAB NUMBER (9)
NIC_ETAB NUMBER (5)
SECTION VARCHAR2 (2)
VALIDITE NUMBER (4)
TYPE_DAS VARCHAR2 (1)
TYPE_ENREG VARCHAR2 (3)
Z01_94_1 VARCHAR2 (14)
CODE_APE VARCHAR2 (4)
Z01_94_2 VARCHAR2 (1)
SIRET_01_JAN NUMBER (9)
NIC_01_JAN NUMBER (5)
Z02 VARCHAR2 (41)
RAISON_SOCIALE VARCHAR2 (50)
ADR_COMPL VARCHAR2 (32)
Z1 VARCHAR2 (1)
ADR_CONCAT VARCHAR2 (64)
ADR_INSEE VARCHAR2 (5)
Z3 VARCHAR2 (1)
ADR_COMMUNE VARCHAR2 (26)
ADR_CPOSTAL VARCHAR2 (5)
Z4 VARCHAR2 (1)
ADR_BUR_DIST VARCHAR2 (26)
PROFESSION VARCHAR2 (40)
Z5 VARCHAR2 (53)
CODE_TAXE_SAL VARCHAR2 (1)
Z6 VARCHAR2 (301)
NUM_ENR NUMBER (6)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)

[top of page]

AP.JE_FR_DAS_020_NEW does not reference any database object

AP.JE_FR_DAS_020_NEW is referenced by following:

AP
VIEW - JE_FR_DAS_020_NEW#

[top of page]

Table: JE_FR_DAS_210

Description: Record 210 information for French DAS2 reports
Comments
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Y
VENDOR_SITE_ID NUMBER
Y
CHECK_NUMBER NUMBER (15) Y
INVOICE_NUM VARCHAR2 (50) Y
VENDOR_SITE_CODE VARCHAR2 (15) Y
TAX_IDENTIFICATION_NUM VARCHAR2 (20) Y
VENDOR_NAME VARCHAR2 (80) Y
SIREN_ETAB NUMBER (9)
NIC_ETAB NUMBER (5)
SECTION VARCHAR2 (2)
VALIDITE NUMBER (4)
TYPE_DAS VARCHAR2 (1)
TYPE_ENREG VARCHAR2 (3)
SIRET_BENEF VARCHAR2 (14)
NOM VARCHAR2 (30)
PRENOM VARCHAR2 (20)
RAISON_SOCIALE VARCHAR2 (50)
PROFESSION VARCHAR2 (30)
ADR_COMPL VARCHAR2 (32)
Z1 VARCHAR2 (1)
ADR_NUM VARCHAR2 (4)
ADR_TYPE VARCHAR2 (1)
Z2 VARCHAR2 (1)
ADR_VOIE VARCHAR2 (26)
ADR_INSEE VARCHAR2 (5)
Z3 VARCHAR2 (1)
ADR_COMMUNE VARCHAR2 (26)
ADR_CPOSTAL VARCHAR2 (5)
Z4 VARCHAR2 (1)
ADR_BUR_DIST VARCHAR2 (26)
DHON_H NUMBER (10)
DCOM_C NUMBER (10)
DCO_CO NUMBER (10)
DRIS_R NUMBER (10)
DJE_JP NUMBER (10)
DDA_DA NUMBER (10)
DDI_I NUMBER (10)
DAU_AR NUMBER (10)
INDE NUMBER (10)
AVAN NUMBER (10)
RETE NUMBER (10)
NAT_AVAN_NOUR VARCHAR2 (1)
NAT_AVAN_LOGE VARCHAR2 (1)
NAT_AVAN_VOIT VARCHAR2 (1)
NAT_AVAN_AUTR VARCHAR2 (1)
Z5 VARCHAR2 (1)
NAT_RETE_ALLO VARCHAR2 (1)
NAT_RETE_REMB VARCHAR2 (1)
NAT_RETE_PRIS VARCHAR2 (1)
NAT_TVA_REDUI VARCHAR2 (1)
NAT_TVA_DISPE VARCHAR2 (1)
TVA_NETTE NUMBER (10)
Z6 VARCHAR2 (245)
SEGMENT1 VARCHAR2 (30)
AGE_11 NUMBER (12)
TYPE_1099 VARCHAR2 (10)
INVOICE_DATE DATE

INVOICE_AMOUNT NUMBER

[top of page]

AP.JE_FR_DAS_210 does not reference any database object

AP.JE_FR_DAS_210 is referenced by following:

AP
VIEW - JE_FR_DAS_210#

[top of page]

Table: JE_FR_DAS_210_NEW

Description: New version of JE_FR_DAS_210 table
Comments
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Y
VENDOR_SITE_ID NUMBER
Y
CHECK_NUMBER NUMBER (15) Y
VENDOR_SITE_CODE VARCHAR2 (15) Y
INVOICE_NUM VARCHAR2 (50) Y
VENDOR_NAME VARCHAR2 (80) Y
TAX_IDENTIFICATION_NUM VARCHAR2 (20) Y
INVOICE_AMOUNT NUMBER

TYPE_1099 VARCHAR2 (10)
INVOICE_DATE DATE

SIREN_ETAB NUMBER (9)
NIC_ETAB NUMBER (5)
SECTION VARCHAR2 (2)
VALIDITE NUMBER (4)
TYPE_DAS VARCHAR2 (1)
TYPE_ENREG VARCHAR2 (3)
SIRET_BENEF VARCHAR2 (14)
NOM VARCHAR2 (30)
PRENOM VARCHAR2 (20)
RAISON_SOCIALE VARCHAR2 (50)
PROFESSION VARCHAR2 (30)
ADR_COMPL VARCHAR2 (32)
Z1 VARCHAR2 (1)
ADR_NUM VARCHAR2 (4)
ADR_TYPE VARCHAR2 (1)
Z2 VARCHAR2 (1)
ADR_VOIE VARCHAR2 (26)
ADR_INSEE VARCHAR2 (5)
Z3 VARCHAR2 (1)
ADR_COMMUNE VARCHAR2 (26)
ADR_CPOSTAL VARCHAR2 (5)
Z4 VARCHAR2 (1)
ADR_BUR_DIST VARCHAR2 (26)
DHON_H NUMBER (10)
DCOM_C NUMBER (10)
DCO_CO NUMBER (10)
DRIS_R NUMBER (10)
DJE_JP NUMBER (10)
DDA_DA NUMBER (10)
DDI_I NUMBER (10)
DAU_AR NUMBER (10)
INDE NUMBER (10)
AVAN NUMBER (10)
RETE NUMBER (10)
NAT_AVAN_NOUR VARCHAR2 (1)
NAT_AVAN_LOGE VARCHAR2 (1)
NAT_AVAN_VOIT VARCHAR2 (1)
NAT_AVAN_AUTR VARCHAR2 (1)
Z5 VARCHAR2 (1)
NAT_RETE_ALLO VARCHAR2 (1)
NAT_RETE_REMB VARCHAR2 (1)
NAT_RETE_PRIS VARCHAR2 (1)
NAT_TVA_REDUI VARCHAR2 (1)
NAT_TVA_DISPE VARCHAR2 (1)
TVA_NETTE NUMBER (10)
Z6 VARCHAR2 (245)
SEGMENT1 VARCHAR2 (30)
AGE_11 NUMBER (12)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)

[top of page]

AP.JE_FR_DAS_210_NEW does not reference any database object

AP.JE_FR_DAS_210_NEW is referenced by following:

AP
VIEW - JE_FR_DAS_210_NEW#

[top of page]

Table: JE_FR_DAS_300

Description: Record 300 information for French DAS2 reports
Comments
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Y
TAX_IDENTIFICATION_NUM VARCHAR2 (20) Y
SIREN_ETAB NUMBER (9)
NIC_ETAB NUMBER (5)
SECTION VARCHAR2 (2)
VALIDITE NUMBER (4)
TYPE_DAS VARCHAR2 (1)
TYPE_ENREG VARCHAR2 (3)
Z1 VARCHAR2 (36)
BASE_BRUTE_FISC NUMBER (12)
REMUNERATIONS_NET NUMBER (12)
AVANTAGES_NAT NUMBER (12)
FRAIS_PROF NUMBER (12)
CHEQUE_VAC NUMBER (12)
TOTAL_IMPOS NUMBER (12)
TOTAL_BASE_IMPOS1 NUMBER (12)
TOTAL_BASE_IMPOS2 NUMBER (12)
TOTAL_RET NUMBER (12)
DHON_H NUMBER (12)
DCOM_C NUMBER (12)
DCO_CO NUMBER (12)
DRIS_R NUMBER (12)
DJE_JP NUMBER (12)
DDA_DA NUMBER (12)
DDI_I NUMBER (12)
DAU_AR NUMBER (12)
INDE NUMBER (12)
AVAN NUMBER (12)
RETE NUMBER (12)
Z2 VARCHAR2 (12)
TAXE_SAL NUMBER (12)
Z3 VARCHAR2 (12)
EFFECTIF_ETAB NUMBER (6)
Z4 VARCHAR2 (134)
NOM_RESP VARCHAR2 (30)
PRENOM_RESP VARCHAR2 (20)
TPH_FONC_RESP VARCHAR2 (40)
CONTACTE_NOM VARCHAR2 (30)
CONTACTE_PRENOM VARCHAR2 (20)
CONTACTE_TPH VARCHAR2 (40)
Z5 VARCHAR2 (107)

[top of page]

AP.JE_FR_DAS_300 does not reference any database object

AP.JE_FR_DAS_300 is referenced by following:

AP
VIEW - JE_FR_DAS_300#

[top of page]

Table: JE_FR_DAS_300_NEW

Description: New version of JE_FR_DAS_300 table
Comments
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Y
TAX_IDENTIFICATION_NUM VARCHAR2 (20) Y
SIREN_ETAB NUMBER (9)
NIC_ETAB NUMBER (5)
SECTION VARCHAR2 (2)
VALIDITE NUMBER (4)
TYPE_DAS VARCHAR2 (1)
TYPE_ENREG VARCHAR2 (3)
Z1 VARCHAR2 (36)
BASE_BRUTE_FISC NUMBER (12)
REMUNERATIONS_NET NUMBER (12)
AVANTAGES_NAT NUMBER (12)
FRAIS_PROF NUMBER (12)
CHEQUE_VAC NUMBER (12)
TOTAL_IMPOS NUMBER (12)
TOTAL_BASE_IMPOS1 NUMBER (12)
TOTAL_BASE_IMPOS2 NUMBER (12)
TOTAL_RET NUMBER (12)
DHON_H NUMBER (12)
DCOM_C NUMBER (12)
DCO_CO NUMBER (12)
DRIS_R NUMBER (12)
DJE_JP NUMBER (12)
DDA_DA NUMBER (12)
DDI_I NUMBER (12)
DAU_AR NUMBER (12)
INDE NUMBER (12)
AVAN NUMBER (12)
RETE NUMBER (12)
Z2 VARCHAR2 (12)
TAXE_SAL NUMBER (12)
Z3 VARCHAR2 (12)
EFFECTIF_ETAB NUMBER (6)
Z4 VARCHAR2 (134)
NOM_RESP VARCHAR2 (30)
PRENOM_RESP VARCHAR2 (20)
TPH_FONC_RESP VARCHAR2 (40)
CONTACTE_NOM VARCHAR2 (30)
CONTACTE_PRENOM VARCHAR2 (20)
CONTACTE_TPH VARCHAR2 (40)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
MONTANTS_CALCULES VARCHAR2 (1)
Z5 VARCHAR2 (107)

[top of page]

AP.JE_FR_DAS_300_NEW does not reference any database object

AP.JE_FR_DAS_300_NEW is referenced by following:

AP
VIEW - JE_FR_DAS_300_NEW#

[top of page]

Table: JE_FR_DAS_310

Description: Record 310 information for French DAS2 reports
Comments
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Y
SIREN_ENT NUMBER (9)
Z0 VARCHAR2 (12)
TYPE_ENREG VARCHAR2 (3)
NBRE_ETAB NUMBER (5)
NBRE_200 NUMBER (6)
NBRE_210 NUMBER (6)
Z1 VARCHAR2 (36)
BASE_BRUTE_FISC NUMBER (12)
REMUNERATIONS_NET NUMBER (12)
AVANTAGES_NAT NUMBER (12)
FRAIS_PROF NUMBER (12)
CHEQUE_VAC NUMBER (12)
TOTAL_IMPOS NUMBER (12)
TOTAL_BASE_IMPOS1 NUMBER (12)
TOTAL_BASE_IMPOS2 NUMBER (12)
TOTAL_RET NUMBER (12)
DHON_H NUMBER (12)
DCOM_C NUMBER (12)
DCO_CO NUMBER (12)
DRIS_R NUMBER (12)
DJE_JP NUMBER (12)
DDA_DA NUMBER (12)
DDI_I NUMBER (12)
DAU_AR NUMBER (12)
INDE NUMBER (12)
AVAN NUMBER (12)
RETE NUMBER (12)
Z2 VARCHAR2 (12)
TAXE_SAL NUMBER (12)
Z3 VARCHAR2 (12)
EFFECTIF_ENT NUMBER (6)
Z4 VARCHAR2 (313)

[top of page]

AP.JE_FR_DAS_310 does not reference any database object

AP.JE_FR_DAS_310 is referenced by following:

AP
VIEW - JE_FR_DAS_310#

[top of page]

Table: JE_FR_DAS_310_NEW

Description: New version of JE_FR_DAS_310 table
Comments
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Y
SIREN_ENT NUMBER (9)
Z0 VARCHAR2 (12)
TYPE_ENREG VARCHAR2 (3)
NBRE_ETAB NUMBER (5)
NBRE_200 NUMBER (6)
NBRE_210 NUMBER (6)
Z1 VARCHAR2 (36)
BASE_BRUTE_FISC NUMBER (12)
REMUNERATIONS_NET NUMBER (12)
AVANTAGES_NAT NUMBER (12)
FRAIS_PROF NUMBER (12)
CHEQUE_VAC NUMBER (12)
TOTAL_IMPOS NUMBER (12)
TOTAL_BASE_IMPOS1 NUMBER (12)
TOTAL_BASE_IMPOS2 NUMBER (12)
TOTAL_RET NUMBER (12)
DHON_H NUMBER (12)
DCOM_C NUMBER (12)
DCO_CO NUMBER (12)
DRIS_R NUMBER (12)
DJE_JP NUMBER (12)
DDA_DA NUMBER (12)
DDI_I NUMBER (12)
DAU_AR NUMBER (12)
INDE NUMBER (12)
AVAN NUMBER (12)
RETE NUMBER (12)
Z2 VARCHAR2 (12)
TAXE_SAL NUMBER (12)
Z3 VARCHAR2 (12)
EFFECTIF_ENT NUMBER (6)
Z4 VARCHAR2 (313)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)

[top of page]

AP.JE_FR_DAS_310_NEW does not reference any database object

AP.JE_FR_DAS_310_NEW is referenced by following:

AP
VIEW - JE_FR_DAS_310_NEW#

[top of page]

Table: JE_GR_AR_AP_TRNOVR_ITF

Description: Customer/Supplier's Transaction/Invoice data will be populated by data extract process based on turnover data exclusion rules.
Primary Key: JE_GR_AR_AP_TRNOVR_ITF_PK
  1. REQUEST_ID
  2. CUST_SUP_NUMBER
  3. INV_TRX_ID
Comments

JE_GR_AR_AP_TURNOVER_ITF is a temporary table that stores customer/supplier transaction/invoice data extracted from Oracle Payables and Oracle Receivables. This interface table contains all the columns that are to be displayed by the two reports. The Customer/Supplier Turnover Report List and Customer/Supplier Turnover Report File Format programs uses this data to generate the reports in the required format. There is no primary key. This table is used only from release 11i onward.

Indexes
Index Type Tablespace Column
JE_GR_AR_AP_TRNOVR_ITF_U1 UNIQUE APPS_TS_TX_IDX REQUEST_ID
CUST_SUP_NUMBER
INV_TRX_ID
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER
Y Parent concurrent request ID of the report set
INV_TRX_ID NUMBER
Y Invoice/transaction identifier
CUST_SUP_TYPE_CODE VARCHAR2 (30)
Customer/supplier type code
CUST_SUP_NAME VARCHAR2 (80) Y Customer/supplier name
CUST_SUP_NUMBER VARCHAR2 (30) Y Customer/supplier number
TAX_PAYER_ID VARCHAR2 (50)
Customer tax payer ID
VAT_REGISTRATION_NUMBER VARCHAR2 (20)
Supplier VAT registration number
SUPPLIER_SITE_CODE VARCHAR2 (15)
Supplier site code
PROFESSION VARCHAR2 (30)
Customer/supplier profession
ADDRESS_LINE1 VARCHAR2 (240)
Customer/supplier address line1
ADDRESS_LINE2 VARCHAR2 (240)
Customer/supplier address line2
ADDRESS_LINE3 VARCHAR2 (240)
Customer/supplier address line3
CITY VARCHAR2 (60)
Customer/supplier city
STATE VARCHAR2 (60)
Customer/supplier state
ZIP VARCHAR2 (60)
Customer/supplier ZIP
PROVINCE VARCHAR2 (60)
Customer/supplier province
COUNTRY VARCHAR2 (60)
Customer/supplier country
INV_TRX_NUMBER VARCHAR2 (50) Y Invoice/transaction number
INV_TRX_DATE DATE
Y Invoice/transaction date
INV_TRX_CURRENCY_CODE VARCHAR2 (15)
Invoice/transaction currency code
INV_TRX_AMOUNT NUMBER

Invoice/transaction amount in invoice currency
INV_TRX_TYPE VARCHAR2 (25) Y Invoice/transaction type
ACCTD_INV_TRX_AMOUNT NUMBER

Invoice/transaction functional amount. It is null if the functional currency and invoice currency are the same.
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

JE.JE_GR_AR_AP_TRNOVR_ITF does not reference any database object

JE.JE_GR_AR_AP_TRNOVR_ITF is referenced by following:

JE
VIEW - JE_GR_AR_AP_TRNOVR_ITF#

[top of page]

Table: JE_GR_CUTOFF_RULES

Description: Stores accounting cutoff rules for Greece
Primary Key: JE_GR_CUTOFF_RULES_PK
  1. RULE_ID
Comments
Indexes
Index Type Tablespace Column
JE_GR_CUTOFF_RULES_U1 UNIQUE APPS_TS_TX_IDX RULE_ID
JE_GR_CUTOFF_RULES_U2 UNIQUE APPS_TS_TX_IDX SET_OF_BOOKS_ID
CATEGORY_CODE
CAT_APPLICATION_ID
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Y
RULE_ID NUMBER (15) Y
CATEGORY_CODE VARCHAR2 (30) Y
CAT_APPLICATION_ID NUMBER (15) Y
DAYS NUMBER (15) Y
VIOLATION_RESPONSE VARCHAR2 (10) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
ENABLED_FLAG VARCHAR2 (1)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)

[top of page]

GL.JE_GR_CUTOFF_RULES does not reference any database object

GL.JE_GR_CUTOFF_RULES is referenced by following:

GL
VIEW - JE_GR_CUTOFF_RULES#

[top of page]

Table: JE_GR_JE_HEADER_SEQUENCE

Description: This table stores the Greek Accounting sequence and value for each journal entry whose journal
Primary Key: JE_GR_JE_HEADER_SEQUENCE_PK
  1. JE_HEADER_ID
Comments
Indexes
Index Type Tablespace Column
JE_GR_JE_HEADER_SEQUENCE_U1 UNIQUE APPS_TS_TX_IDX JE_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
JE_HEADER_ID NUMBER (15) Y
DOC_SEQUENCE_ID NUMBER
Y
DOC_SEQUENCE_VALUE NUMBER
Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

GL.JE_GR_JE_HEADER_SEQUENCE does not reference any database object

GL.JE_GR_JE_HEADER_SEQUENCE is referenced by following:

GL
VIEW - JE_GR_JE_HEADER_SEQUENCE#

[top of page]

Table: JE_GR_TRNOVR_RULES

Description: Turnover data exclusion rules
Primary Key: JE_GR_TRNOVR_RULES_PK
  1. TRNOVR_RULE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
JE_GR_TRNOVR_RULE_LINES.TRNOVR_RULE_ID JE_GR_TRNOVR_RULES
Comments

This table stores data for each exclusion rule created. Each row includes the application ID, rule name, rule ID, enabled flag, description and other information. The primary key for this table is TRNOVR_RULE_ID. The rule rame is also unique. Each rule will have a list of customer/supplier type codes, invoice/transaction type codes and invoice/transaction line type codes. The rule ID will be passed as a parameter in selecting the records to be listed in the report.

Indexes
Index Type Tablespace Column
JE_GR_TRNOVR_RULES_U1 UNIQUE APPS_TS_TX_IDX TRNOVR_RULE_ID
JE_GR_TRNOVR_RULES_U2 UNIQUE APPS_TS_TX_IDX TRNOVR_RULE_NAME
Columns
Name Datatype Length Mandatory Comments
TRNOVR_RULE_ID NUMBER (15) Y Unique identifier for each exclusion rule created
APPLICATION_ID NUMBER (15) Y Identifier which indicates the application to which the groups belong
TRNOVR_RULE_NAME VARCHAR2 (100) Y Exclusion name
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
ENABLED_FLAG VARCHAR2 (1)
Flag which indicates if the Inclusion/Exclusion Rule is enabled
DESCRIPTION VARCHAR2 (240)
Description
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive Flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
LEGAL_ENTITY_ID NUMBER (15)
Legal entity identifier

[top of page]

JE.JE_GR_TRNOVR_RULES does not reference any database object

JE.JE_GR_TRNOVR_RULES is referenced by following:

JE
VIEW - JE_GR_TRNOVR_RULES#

[top of page]

Table: JE_GR_TRNOVR_RULE_LINES

Description: Turnover data exclusion rule lines
Primary Key: JE_GR_TRNOVR_RULE_LINES_PK
  1. TRNOVR_RULE_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JE_GR_TRNOVR_RULE_LINES.TRNOVR_RULE_ID JE_GR_TRNOVR_RULES
Comments

This table stores data for each exclusion rule line created. Each row includes the application ID, rule ID, rule line ID, lookup type, lookup code, excluded flag, description and other information. The primary key for this table is TRNOVR_ RULE_LINE_ID. Each rule line correspond to a lookup type and a lookup code. Each rule line associated with a rule name. The rule lines have exclude flags which specify whether the records fetched should be included or excluded from the listing the type of supplier/customer associated at the customer or supplier level, the type of invoice associated at the invoice level and based on the line type associated at transaction lines level.

Indexes
Index Type Tablespace Column
JE_GR_TRNOVR_RULE_LINES_U1 UNIQUE APPS_TS_TX_IDX TRNOVR_RULE_LINE_ID
Columns
Name Datatype Length Mandatory Comments
TRNOVR_RULE_LINE_ID NUMBER (15) Y Unique identifier for each exclusion rule line created
APPLICATION_ID NUMBER (15) Y Identifier which indicates the application to which the groups belong
TRNOVR_RULE_ID NUMBER (15) Y Unique ID for each exclusion rule created
LOOKUP_TYPE VARCHAR2 (30) Y Type of the turnover group
LOOKUP_CODE VARCHAR2 (30) Y Group identifier of the parent group being included
EXCLUDE_FLAG VARCHAR2 (1) Y Flag which indicates if the group is included or excluded
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive Flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment

[top of page]

JE.JE_GR_TRNOVR_RULE_LINES does not reference any database object

JE.JE_GR_TRNOVR_RULE_LINES is referenced by following:

JE
VIEW - JE_GR_TRNOVR_RULE_LINES#

[top of page]

Table: JE_HU_BALANCES_REPORT

Description: Hungarian Fixed Assets balance information
Comments
Columns
Name Datatype Length Mandatory Comments
CATEGORY_ID NUMBER (15) Y
ASSET_ID NUMBER (15) Y
DISTRIBUTION_CCID NUMBER (15) Y
ADJUSTMENT_CCID NUMBER (15)
CATEGORY_BOOKS_ACCOUNT VARCHAR2 (25)
SOURCE_TYPE_CODE VARCHAR2 (15) Y
AMOUNT NUMBER

[top of page]

FA.JE_HU_BALANCES_REPORT does not reference any database object

FA.JE_HU_BALANCES_REPORT is referenced by following:

FA
VIEW - JE_HU_BALANCES_REPORT#

[top of page]

Table: JE_IL_VAT_LIMITS

Description: This table is used to capture the VAT limits for each tax period
Primary Key: JE_IL_VAT_LIMIT_PK
  1. PERIOD_SET_NAME
  2. PERIOD_NAME
Comments

This table is used to capture the VAT limits for each tax period

Columns
Name Datatype Length Mandatory Comments
PERIOD_SET_NAME VARCHAR2 (15) Y Tax Calendar Name
PERIOD_NAME VARCHAR2 (15) Y Tax Period Name
PERIOD_NUM NUMBER (15) Y Period Number
PERIOD_YEAR NUMBER (15) Y Period Year
MAX_RECOVERABLE_PERCENTAGE NUMBER (15)
Max Recoverable Percentage
MAX_RECOVERABLE_AMT NUMBER

Max Recoverable Amount
MIN_RECOVERABLE_AMT NUMBER
Y Min Recoverable Amount
VAT_AGGREGATE_LIMIT_AMT NUMBER
Y VAT Aggregation Limit
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column - Date when this row was created
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who updated this row FK to FND_USER.USER_ID
LAST_UPDATE_DATE DATE
Y Standard who column - date when the user last updated this row
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row FK FND_LOIGNS.LOGIN_ID

[top of page]

JE.JE_IL_VAT_LIMITS does not reference any database object

JE.JE_IL_VAT_LIMITS is referenced by following:

JE
VIEW - JE_IL_VAT_LIMITS#

[top of page]

Table: JE_IT_ABOVE_THR_HDR_ALL

Description: This table stores the parameter details of Italian Invoice Above Threshold Data extract Run
Comments

This table stores the parameter details of Italian Invoice Above Threshold Data extract Run

Indexes
Index Type Tablespace Column
JE_IT_ABOVE_THR_HDR_U1 UNIQUE APPS_TS_TX_IDX REQUEST_ID#1
Columns
Name Datatype Length Mandatory Comments
VAT_REPORTING_ENTITY_ID NUMBER (15) Y Vat Reporting Entity Id
YEAR_OF_DECLARATION NUMBER (4) Y Year Of Declaration
ORG_ID NUMBER (15)
Org Id
REPORT_MODE VARCHAR2 (1)
Report Mode
TYPE_OF_UPLOAD VARCHAR2 (1)
Type Of Upload
TRANSMISSION_CODE NUMBER (17)
Electronic Transmission code to be Substituted or Canceled
PROVINCE_CODE VARCHAR2 (2)
Province Code
DECLR_OF_INCORP_COMP NUMBER (1)
Declaration of an Incorporated Company
TRX_ACCOUNTING_STATUS VARCHAR2 (15)
Transaction Accounting Status
END_DATE_TO_EXTR_CM_DM DATE

End Date to extract Credit Memos and Debit Memos
B2C_INVOICE_THRESHOLD NUMBER (10)
B2C Invoice Threshold Amount
B2B_INVOICE_THRESHOLD NUMBER (10)
B2B Invoice Threshold Amount
START_DATE_TO_EXTR_B2C_TRX DATE

Start Date to Extract B2C Transactions
NO_OF_DETAILED_RECORDS NUMBER (5)
Maximum Number of Detail Records per EFT File.
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
PROTOCOL_NUM NUMBER (10)
Protocol Number
REQUEST_ID#1 NUMBER (15)
Italian Invoices Above Threshold Data Extract Request ID

[top of page]

JE.JE_IT_ABOVE_THR_HDR_ALL does not reference any database object

JE.JE_IT_ABOVE_THR_HDR_ALL is referenced by following:

JE
VIEW - JE_IT_ABOVE_THR_HDR_ALL#

[top of page]

Table: JE_IT_COUNTRY_REP_CODES

Description: This table stores Italian Country Codes defined in Italian Tax Reporting Country Codes form
Comments

This table stores Italian Country Codes defined in Italian Tax Reporting Country Codes form

Indexes
Index Type Tablespace Column
JE_IT_COUNTRY_REP_CODES_U1 UNIQUE APPS_TS_TX_IDX COUNTRY_CODE
ITALIAN_COUNTRY_CODE
REP_EXCLUSION_DATE_FROM
REP_EXCLUSION_DATE_TO
Columns
Name Datatype Length Mandatory Comments
COUNTRY_CODE VARCHAR2 (5) Y Country Code
ITALIAN_COUNTRY_CODE NUMBER (10) Y Italian Country Code
REP_EXCLUSION_DATE_FROM DATE

Reporting Exclusion Date From
REP_EXCLUSION_DATE_TO DATE

Reporting Exclusion Date To
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column

[top of page]

JE.JE_IT_COUNTRY_REP_CODES does not reference any database object

JE.JE_IT_COUNTRY_REP_CODES is referenced by following:

JE
VIEW - JE_IT_COUNTRY_REP_CODES#

[top of page]

Table: JE_IT_EXEMPT_LETTERS

Description: Italian exemption letter information for suppliers
Primary Key: JE_IT_EXEMPT_LETTERS_PK
  1. SET_OF_BOOKS_ID
  2. LEGAL_ENTITY_ID
  3. VENDOR_ID
  4. EFFECTIVE_FROM
  5. EFFECTIVE_TO
Comments
Indexes
Index Type Tablespace Column
JE_IT_EXEMPT_LETTERS_U1 UNIQUE APPS_TS_TX_IDX SET_OF_BOOKS_ID
LEGAL_ENTITY_ID
VENDOR_ID
EFFECTIVE_FROM
EFFECTIVE_TO
Columns
Name Datatype Length Mandatory Comments
VENDOR_ID NUMBER
Y
EFFECTIVE_FROM DATE
Y
EFFECTIVE_TO DATE
Y
YEAR NUMBER (4) Y
EXEMPTION_LETTER_ID NUMBER
Y
PRINT_FLAG VARCHAR2 (1) Y
ISSUE_FLAG VARCHAR2 (1) Y
CUSTOM_FLAG VARCHAR2 (1) Y
CLAUSE_REF VARCHAR2 (5) Y
ISSUE_DATE DATE

LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
SET_OF_BOOKS_ID NUMBER (15) Y
LETTER_TYPE VARCHAR2 (30) Y
LIMIT_AMOUNT NUMBER (15)
LEGAL_ENTITY_ID NUMBER (15) Y

[top of page]

AP.JE_IT_EXEMPT_LETTERS does not reference any database object

AP.JE_IT_EXEMPT_LETTERS is referenced by following:

AP
VIEW - JE_IT_EXEMPT_LETTERS#

[top of page]

Table: JE_IT_EXLET_SEQS

Description: Table based sequencing for exemption letters
Primary Key: JE_IT_EXLET_SEQS_PK
  1. YEAR
Comments
Indexes
Index Type Tablespace Column
JE_IT_EXLET_SEQS_U1 UNIQUE APPS_TS_TX_IDX YEAR
LEGAL_ENTITY_ID
Columns
Name Datatype Length Mandatory Comments
YEAR NUMBER (4) Y
SEQ_NO NUMBER
Y
LEGAL_ENTITY_ID NUMBER (15)

[top of page]

AP.JE_IT_EXLET_SEQS does not reference any database object

AP.JE_IT_EXLET_SEQS is referenced by following:

AP
VIEW - JE_IT_EXLET_SEQS#

[top of page]

Table: JE_IT_INV_PACKSLIPS

Description: Information on Italian Inventory Packing Slips
Primary Key: JE_IT_INV_PSLIP_PK
  1. SHIPMENT_HEADER_ID
Comments
Indexes
Index Type Tablespace Column
JE_IT_INV_PSLIP_U1 UNIQUE APPS_TS_TX_IDX SHIPMENT_HEADER_ID
JE_IT_INV_PSLIP_N1 NONUNIQUE APPS_TS_TX_IDX PACKSLIP_NUMBER
Columns
Name Datatype Length Mandatory Comments
PACKSLIP_NUMBER NUMBER (22) Y
PACKSLIP_DATE DATE
Y
SHIPMENT_HEADER_ID NUMBER (22) Y

[top of page]

INV.JE_IT_INV_PACKSLIPS does not reference any database object

INV.JE_IT_INV_PACKSLIPS is referenced by following:

INV
VIEW - JE_IT_INV_PACKSLIPS#

[top of page]

Table: JE_IT_LIST_HDR_ALL

Description: JE_IT_LIST_HDR_ALL table contains Italian Annual Supplier and Customer listing extract header data
Comments
Indexes
Index Type Tablespace Column
JE_IT_LIST_HDR_U1 NONUNIQUE APPS_TS_TX_IDX VAT_REPORTING_ENTITY_ID
YEAR_OF_DECLARATION
Columns
Name Datatype Length Mandatory Comments
PERIOD_NAME VARCHAR2 (15)
ORG_ID NUMBER (15)
STATUS_CODE VARCHAR2 (30)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
VAT_REPORTING_ENTITY_ID NUMBER (15)
YEAR_OF_DECLARATION NUMBER (4)

[top of page]

JE.JE_IT_LIST_HDR_ALL does not reference any database object

JE.JE_IT_LIST_HDR_ALL is referenced by following:

JE
VIEW - JE_IT_LIST_HDR_ALL#

[top of page]

Table: JE_IT_LIST_LINES_ALL

Description: JE_IT_LIST_LINES_ALL table contains Italian Annual Supplier and Customer listing extract detail data
Comments
Columns
Name Datatype Length Mandatory Comments
PERIOD_NAME VARCHAR2 (15)
ORG_ID NUMBER (15)
APPLICATION_ID NUMBER (15) Y
PARTY_ID NUMBER (15) Y
TRX_TYPE_CODE VARCHAR2 (25)
TRX_TYPE_ID NUMBER (15)
DOC_SEQ_ID NUMBER

DOC_SEQ_NUM NUMBER

TRX_DATE DATE

TRX_ID NUMBER

TRX_NUM VARCHAR2 (50)
TRX_DIST_ID NUMBER

TRX_LINE_TYPE_CODE VARCHAR2 (25)
TRX_LINE_TAX_CODE_ID NUMBER (15)
TAXABLE_AMT NUMBER

VAT_AMT NUMBER

NON_TAXABLE_AMT NUMBER

EXEMPT_AMT NUMBER

TAXABLE_VAT_AMT NUMBER

TAXABLE_VAT_INV_AMT NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
VAT_REPORTING_ENTITY_ID NUMBER (15)
YEAR_OF_DECLARATION NUMBER (4)
CM_TAXABLE_AMT NUMBER

CM_VAT_AMT NUMBER

CM_NON_TAXABLE_AMT NUMBER

CM_EXEMPT_AMT NUMBER

CM_TAXABLE_VAT_AMT NUMBER

CM_TAXABLE_VAT_INV_AMT NUMBER

TAX_RATE_ID NUMBER (15)

[top of page]

JE.JE_IT_LIST_LINES_ALL does not reference any database object

JE.JE_IT_LIST_LINES_ALL is referenced by following:

JE
VIEW - JE_IT_LIST_LINES_ALL#

[top of page]

Table: JE_IT_LIST_PARTIES_ALL

Description: JE_IT_LIST_PARTIES_ALL table contains Italian Annual Supplier and Customer listing extract summary data
Comments
Indexes
Index Type Tablespace Column
JE_IT_LIST_PARTIES_N1 NONUNIQUE APPS_TS_TX_IDX VAT_REPORTING_ENTITY_ID
YEAR_OF_DECLARATION
PARTY_ID
Columns
Name Datatype Length Mandatory Comments
PERIOD_NAME VARCHAR2 (15)
ORG_ID NUMBER (15)
TRANSMISSION_NUM NUMBER (15) Y
APPLICATION_ID NUMBER (15) Y
PARTY_ID NUMBER (15) Y
TAXABLE_AMT NUMBER

VAT_AMT NUMBER

NON_TAXABLE_AMT NUMBER

EXEMPT_AMT NUMBER

TAXABLE_VAT_AMT NUMBER

TAXABLE_VAT_INV_AMT NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
PARTY_SEQUENCE_NUM NUMBER

VAT_REPORTING_ENTITY_ID NUMBER (15)
YEAR_OF_DECLARATION NUMBER (4)
CM_TAXABLE_AMT NUMBER

CM_VAT_AMT NUMBER

CM_NON_TAXABLE_AMT NUMBER

CM_EXEMPT_AMT NUMBER

CM_TAXABLE_VAT_AMT NUMBER

CM_TAXABLE_VAT_INV_AMT NUMBER

VAT_REGISTRATION_NUM VARCHAR2 (60)
FISCAL_ID_NUM VARCHAR2 (30)

[top of page]

JE.JE_IT_LIST_PARTIES_ALL does not reference any database object

JE.JE_IT_LIST_PARTIES_ALL is referenced by following:

JE
VIEW - JE_IT_LIST_PARTIES_ALL#

[top of page]

Table: JE_IT_LIST_TRX_GT

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
JE_INFO_N1 NUMBER

JE_INFO_V1 VARCHAR2 (1680)

[top of page]

JE.JE_IT_LIST_TRX_GT does not reference any database object

JE.JE_IT_LIST_TRX_GT is referenced by following:

APPS
SYNONYM - JE_IT_LIST_TRX_GT

[top of page]

Table: JE_IT_PACKSLIPS

Description: Information on Italian Order Entry Packing Slips
Primary Key: JE_IT_PACKSLIPS_PK
  1. PICKING_HEADER_ID
Comments
Indexes
Index Type Tablespace Column
JE_IT_PACKSLIPS_U1 UNIQUE APPS_TS_ARCHIVE PICKING_HEADER_ID
JE_IT_PACKSLIPS_N1 NONUNIQUE APPS_TS_ARCHIVE PACKSLIP_NUMBER
Columns
Name Datatype Length Mandatory Comments
PACKSLIP_NUMBER NUMBER
Y
PACKSLIP_DATE DATE
Y
PICKING_HEADER_ID NUMBER
Y

[top of page]

OE.JE_IT_PACKSLIPS does not reference any database object

OE.JE_IT_PACKSLIPS is referenced by following:

OE
VIEW - JE_IT_PACKSLIPS#

[top of page]

Table: JE_IT_PO_PACKSLIPS

Description: Information on Italian Purchasing Packing Slips
Primary Key: JE_IT_PO_PACKSLIPS_PK
  1. TRANSACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JE_IT_PO_PACKSLIPS.TRANSACTION_ID RCV_TRANSACTIONS
Comments
Indexes
Index Type Tablespace Column
JE_IT_PO_PACKSLIPS_U1 UNIQUE APPS_TS_TX_IDX TRANSACTION_ID
JE_IT_PO_PACKSLIPS_N1 NONUNIQUE APPS_TS_TX_IDX PACKSLIP_NUMBER
Columns
Name Datatype Length Mandatory Comments
PACKSLIP_NUMBER NUMBER (15) Y
PACKSLIP_DATE DATE
Y
TRANSACTION_ID NUMBER
Y

[top of page]

JE.JE_IT_PO_PACKSLIPS does not reference any database object

JE.JE_IT_PO_PACKSLIPS is referenced by following:

JE
VIEW - JE_IT_PO_PACKSLIPS#

[top of page]

Table: JE_IT_REPORT_PARAMETERS

Description: Italian report parameters
Primary Key: JE_IT_REPORT_PARAMETERS_PK
  1. REQUEST_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
JE_IT_VAT_REPORT_INV.REQUEST_ID JE_IT_REPORT_PARAMETERS
Comments
Indexes
Index Type Tablespace Column
JE_IT_REPORT_PARAMETERS_U1 UNIQUE APPS_TS_TX_IDX REQUEST_ID
JE_IT_REPORT_PARAMETERS_N1 NONUNIQUE APPS_TS_TX_IDX CONCURRENT_PROGRAM_ID
SET_OF_BOOKS_ID
Columns
Name Datatype Length Mandatory Comments
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER
Y
CONCURRENT_PROGRAM_ID NUMBER (15) Y
SET_OF_BOOKS_ID NUMBER (15) Y
REQUEST_ID NUMBER (15) Y
RUN_DATE DATE

PARAMETER_1 VARCHAR2 (50)
PARAMETER_2 VARCHAR2 (50)
PARAMETER_3 VARCHAR2 (50)
PARAMETER_4 VARCHAR2 (50)
PARAMETER_5 VARCHAR2 (50)
REPORT_STATUS VARCHAR2 (1)

[top of page]

GL.JE_IT_REPORT_PARAMETERS does not reference any database object

GL.JE_IT_REPORT_PARAMETERS is referenced by following:

GL
VIEW - JE_IT_REPORT_PARAMETERS#

[top of page]

Table: JE_IT_SETUP_DOC_SEQS_ALL

Description: A table to store document sequence setup done in Italian Invoices Reporting Setup form
Comments

A table to store document sequence setup done in Italian Invoices Reporting Setup form

Indexes
Index Type Tablespace Column
JE_IT_SETUP_DOC_SEQS_U1 UNIQUE APPS_TS_TX_IDX VAT_REPORTING_ENTITY_ID
YEAR_OF_DECLARATION
APPLICATION_ID
DOCUMENT_SEQUENCE_ID
Columns
Name Datatype Length Mandatory Comments
YEAR_OF_DECLARATION NUMBER (4) Y Year Of Declaration
VAT_REPORTING_ENTITY_ID NUMBER (15) Y Vat Reporting Entity Id
ORG_ID NUMBER (15)
Org Id
APPLICATION_ID NUMBER (15) Y Application Id
DOCUMENT_SEQUENCE_ID NUMBER (15) Y Document Sequence Id
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column

[top of page]

JE.JE_IT_SETUP_DOC_SEQS_ALL does not reference any database object

JE.JE_IT_SETUP_DOC_SEQS_ALL is referenced by following:

JE
VIEW - JE_IT_SETUP_DOC_SEQS_ALL#

[top of page]

Table: JE_IT_SETUP_HDR_ALL

Description: JE_IT_SETUP_HDR_ALL table contains Italian Annual Supplier and Customer listing setup header data
Comments
Indexes
Index Type Tablespace Column
JE_IT_SETUP_HDR_U1 UNIQUE APPS_TS_TX_IDX VAT_REPORTING_ENTITY_ID
YEAR_OF_DECLARATION
Columns
Name Datatype Length Mandatory Comments
PERIOD_NAME VARCHAR2 (15)
ORG_ID NUMBER (15)
FREEZE_INDICATOR_FLAG VARCHAR2 (1) Y
EFT_PARTY_LIMIT_NUM NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
VAT_REPORTING_ENTITY_ID NUMBER (15)
YEAR_OF_DECLARATION NUMBER (4)

[top of page]

JE.JE_IT_SETUP_HDR_ALL does not reference any database object

JE.JE_IT_SETUP_HDR_ALL is referenced by following:

JE
VIEW - JE_IT_SETUP_HDR_ALL#

[top of page]

Table: JE_IT_SETUP_HEADER_ALL

Description: JE_IT_SETUP_HEADER_ALL stores the Italian Invoice Above Threshold Enhancement setup header data.
Comments

JE_IT_SETUP_HEADER_ALL stores the Italian Invoice Above Threshold Enhancement setup header data.

Indexes
Index Type Tablespace Column
JE_IT_SETUP_HEADER_ALL_U1 UNIQUE APPS_TS_TX_IDX VAT_REPORTING_ENTITY_ID
YEAR_OF_DECLARATION
Columns
Name Datatype Length Mandatory Comments
YEAR_OF_DECLARATION NUMBER (4) Y Year Of Declaration
VAT_REPORTING_ENTITY_ID NUMBER (15) Y Vat Reporting Entity Id
ORG_ID NUMBER (15)
Org Id
FREEZE_INDICATOR_FLAG VARCHAR2 (1)
Freeze Indicator Flag. Y or N
DEFAULT_PAYMENT_MODE NUMBER (1)
Default Payment Mode
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column

[top of page]

JE.JE_IT_SETUP_HEADER_ALL does not reference any database object

JE.JE_IT_SETUP_HEADER_ALL is referenced by following:

JE
VIEW - JE_IT_SETUP_HEADER_ALL#

[top of page]

Table: JE_IT_SETUP_LINES_ALL

Description: JE_IT_SETUP_LINES_ALL table contains Italian Annual Supplier and Customer listing setup lines data
Comments
Indexes
Index Type Tablespace Column
JE_IT_SETUP_LINES_U1 UNIQUE APPS_TS_TX_IDX VAT_REPORTING_ENTITY_ID
YEAR_OF_DECLARATION
APPLICATION_ID
TAX_RATE_ID
LISTING_COLUMN_CODE
Columns
Name Datatype Length Mandatory Comments
PERIOD_NAME VARCHAR2 (15)
ORG_ID NUMBER (15)
APPLICATION_ID NUMBER (15) Y
LISTING_COLUMN_CODE VARCHAR2 (30) Y
TAX_ID NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
VAT_REPORTING_ENTITY_ID NUMBER (15)
YEAR_OF_DECLARATION NUMBER (4)
TAX_RATE_ID NUMBER (15)

[top of page]

JE.JE_IT_SETUP_LINES_ALL does not reference any database object

JE.JE_IT_SETUP_LINES_ALL is referenced by following:

JE
VIEW - JE_IT_SETUP_LINES_ALL#

[top of page]

Table: JE_IT_TMP_RPT_HEADERS

Description: Page numbers for printing generic report headers
Comments
Columns
Name Datatype Length Mandatory Comments
NUM_OF_PAGE NUMBER (15)

[top of page]

GL.JE_IT_TMP_RPT_HEADERS does not reference any database object

GL.JE_IT_TMP_RPT_HEADERS is referenced by following:

GL
VIEW - JE_IT_TMP_RPT_HEADERS#

[top of page]

Table: JE_IT_TRX_ABOVE_THR_ALL

Description: A table to store the detailed information of transactions which are eligible for Data Extraction
Comments

A table to store the detailed information of transactions which are eligible for Data Extraction

Indexes
Index Type Tablespace Column
JE_IT_TRX_ABOVE_THR_N1 NONUNIQUE APPS_TS_TX_IDX REQUEST_ID#1
Columns
Name Datatype Length Mandatory Comments
VAT_REPORTING_ENTITY_ID NUMBER (15) Y Vat Reporting Entity Id
ORG_ID NUMBER (15)
Org ID
APPLICATION_ID NUMBER (15) Y Application ID
RECORD_TYPE NUMBER (1)
Data Extract Concurrent Request ID
EFT_PROGRESSION_NUM NUMBER (5)
Org ID
EFT_SEQUENTIAL_NUM NUMBER (5)
Application ID
PARTY_ID NUMBER (15)
Third Party ID
PARTY_NAME VARCHAR2 (240)
Third Party Name
VAT_REGISTRATION_NUM VARCHAR2 (30)
Third Party VAT Registration Number
TAX_PAYER_ID VARCHAR2 (30)
Third Party Taxpayer ID
COUNTRY VARCHAR2 (3)
Country
TRX_ID NUMBER (15)
Transaction ID
TRX_NUM VARCHAR2 (50)
Transaction Number
TRX_DATE DATE

Transaction Date
TRX_GL_DATE DATE

Transaction GL Date
TRX_TYPE VARCHAR2 (25)
Transaction Type
PAYMENT_METHOD VARCHAR2 (50)
Transaction Payment Method
TRX_ACCOUNTING_STATUS VARCHAR2 (15)
Transaction Accounting Status
ASSESSABLE_AMT NUMBER (20)
Assessable Amount
VAT_AMT NUMBER (20)
VAT Amount
PAYMENT_MODE VARCHAR2 (2)
Payment Mode
BELOW_THRESHOLD_FLAG VARCHAR2 (1)
Below Threshold Flag
CONTRACT_IDENTIFICATION VARCHAR2 (30)
Contract Identification
ORIG_TRX_ID NUMBER (15)
Original Transaction ID. Populated if the Transaction Type is either Credit memo or Debit memo
ORIG_TRX_NUM VARCHAR2 (50)
Original Transaction Number. Populated if the Transaction Type is either Credit memo or Debit memo
ORIG_TRX_DATE DATE

Original Transaction Date. Populated if the Transaction Type is either Credit memo or Debit memo
ORIG_TRX_GL_DATE DATE

Original Transaction GL Date. Populated if the Transaction Type is either Credit memo or Debit memo
ORIG_TRX_ACCTG_STATUS VARCHAR2 (15)
Original Transaction Accounting Status. Populated if the Transaction Type is either Credit memo or Debit memo
ORIG_TRX_PAYMENT_METHOD VARCHAR2 (50)
Original Transaction Payment Method. Populated if the Transaction Type is either Credit memo or Debit memo
PARTY_TYPE VARCHAR2 (20)
Third Party Type
INDV_PARTY_DOB DATE

Individual Party Date Of Birth. Populated if the Third party is an individual
INDV_PARTY_PROVINCE VARCHAR2 (3)
Individual Party Province code. Populated if the Third party is an individual
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
REQUEST_ID#1 NUMBER (15) Y Data Extract Concurrent Request ID
INDV_PARTY_LAST_NAME#1 VARCHAR2 (150)
Individual Party Last Name. Populated if the Third party is an individual
INDV_PARTY_FIRST_NAME#1 VARCHAR2 (150)
Individual Party First Name. Populated if the Third party is an individual
INDV_PARTY_CITY#1 VARCHAR2 (120)
Individual Party City Name. Populated if the Third party is an individual
COMPANY_CITY#1 VARCHAR2 (60)
Company City Name.Populated if the Third party is a company
COMPANY_ADDRESS#1 VARCHAR2 (240)
Company Address.Populated if the Third party is a company

[top of page]

JE.JE_IT_TRX_ABOVE_THR_ALL does not reference any database object

JE.JE_IT_TRX_ABOVE_THR_ALL is referenced by following:

JE
VIEW - JE_IT_TRX_ABOVE_THR_ALL#

[top of page]

Table: JE_IT_TRX_LINES_ALL

Description: This table stores the detailed information of transactions which are eligible for Italian Invoices Above Threshold Data Extraction
Comments

This table stores the detailed information of transactions which are eligible for Italian Invoices Above Threshold Data Extraction

Indexes
Index Type Tablespace Column
JE_IT_TRX_LINES_N1 NONUNIQUE APPS_TS_TX_IDX REQUEST_ID#1
JE_IT_TRX_LINES_N2 NONUNIQUE APPS_TS_TX_IDX ORIG_TRX_ID
JE_IT_TRX_LINES_N3 NONUNIQUE APPS_TS_TX_IDX TRX_LINE_ID
JE_IT_TRX_LINES_N4 NONUNIQUE APPS_TS_TX_IDX REQUEST_ID#1
TRX_ID
Columns
Name Datatype Length Mandatory Comments
VAT_REPORTING_ENTITY_ID NUMBER (15) Y Vat Reporting Entity Id
ORG_ID NUMBER (15)
Org ID
APPLICATION_ID NUMBER (15) Y Application ID
PARTY_ID NUMBER (15)
Third Party ID
PARTY_NAME VARCHAR2 (240)
Third Party Name
VAT_REGISTRATION_NUM VARCHAR2 (30)
Third Party VAT Registration Number
TAX_PAYER_ID VARCHAR2 (30)
Third Party Taxpayer ID
COUNTRY VARCHAR2 (3)
Country
TRX_ID NUMBER (15)
Transaction ID
TRX_NUM VARCHAR2 (50)
Transaction Number
TRX_DATE DATE

Transaction Date
TRX_GL_DATE DATE

Transaction GL Date
TRX_TYPE VARCHAR2 (25)
Transaction Type
PAYMENT_METHOD VARCHAR2 (50)
Transaction Payment Method
TRX_ACCOUNTING_STATUS VARCHAR2 (15)
Transaction Accounting Status
TRX_LINE_ID NUMBER (15)
Transaction Line ID
TRX_LINE_NUM NUMBER (5)
Trasnction Line Number
TRX_LINE_TYPE VARCHAR2 (20)
Transaction Line Type
ASSESSABLE_AMT NUMBER

Assessable Amount
VAT_AMT NUMBER

VAT Amount
PAYMENT_MODE VARCHAR2 (2)
Payment Mode
BELOW_THRESHOLD_FLAG VARCHAR2 (1)
Below Threshold Flag
REPORT_EXCLUSION_FLAG VARCHAR2 (1)
Report Exclusion Flag
CONTRACT_IDENTIFICATION VARCHAR2 (30)
Contract Identification
ADJ_INV_FLAG VARCHAR2 (1)
Adjustment Invoice Flag. Y or N
ORIG_TRX_ID NUMBER (15)
Original Transaction ID. Populated if the Transaction Type is either Credit memo or Debit memo
RECORD_TYPE NUMBER (1)
Record Type
PARTY_TYPE VARCHAR2 (20)
Third Party Type
INDV_PARTY_DOB DATE

Individual Party Date Of Birth. Populated if the Third party is an individual
INDV_PARTY_PROVINCE VARCHAR2 (3)
Individual Party Province code. Populated if the Third party is an individual
INCONST_CM_DM_APPL_FLAG VARCHAR2 (1)
Inconsistent Credit/Debit memo application
ORIG_TRX_MISSING_FLAG VARCHAR2 (1)
Original Transaction Missing Flag
PAYMENT_MODE_ERR_FLAG VARCHAR2 (1)
Payment Mode Error Flag
PARTIAL_ADJ_INV_FLAG VARCHAR2 (1)
Partial Adjustment Invoice Flag. This column will be populated with 'Y' if the 'Adjustment Invoice Flag' of the GDF is populated only for some invoice lines.
IS_ABOVE_THRESHOLD VARCHAR2 (1)
Is Above Threshold Flag
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
REQUEST_ID#1 NUMBER (15) Y commnet Data Extract Concurrent Request ID
INDV_PARTY_LAST_NAME#1 VARCHAR2 (150)
Individual Party Last Name. Populated if the Third party is an individual
INDV_PARTY_FIRST_NAME#1 VARCHAR2 (150)
Individual Party First Name. Populated if the Third party is an individual
INDV_PARTY_CITY#1 VARCHAR2 (120)
Individual Party City Name. Populated if the Third party is an individual
COMPANY_CITY#1 VARCHAR2 (60)
Company City Name.Populated if the Third party is a company
COMPANY_ADDRESS#1 VARCHAR2 (240)
Company Address.Populated if the Third party is a company

[top of page]

JE.JE_IT_TRX_LINES_ALL does not reference any database object

JE.JE_IT_TRX_LINES_ALL is referenced by following:

JE
VIEW - JE_IT_TRX_LINES_ALL#

[top of page]

Table: JE_IT_VAT_REGISTERS_B

Description: Italian VAT Registers.
Primary Key: JE_IT_VAT_REGISTERS_B_PK
  1. VAT_REGISTER_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
JE_IT_VAT_REG_DOCS.VAT_REGISTER_ID JE_IT_VAT_REGISTERS_B
JE_IT_VAT_REPORT_INV.VAT_REGISTER_ID JE_IT_VAT_REGISTERS_B
Comments
Indexes
Index Type Tablespace Column
JE_IT_VAT_REGISTERS_B_U1 UNIQUE APPS_TS_TX_IDX VAT_REGISTER_ID
Columns
Name Datatype Length Mandatory Comments
VAT_REGISTER_ID NUMBER
Y
VAT_REGISTER_TYPE VARCHAR2 (30)
START_DATE DATE

END_DATE DATE

LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

AP.JE_IT_VAT_REGISTERS_B does not reference any database object

AP.JE_IT_VAT_REGISTERS_B is referenced by following:

AP
VIEW - JE_IT_VAT_REGISTERS_B#

[top of page]

Table: JE_IT_VAT_REGISTERS_TL

Description: Translated information about Italian VAT Registers.
Primary Key: JE_IT_VAT_REGISTERS_TL_PK
  1. VAT_REGISTER_ID
  2. LANGUAGE
Comments
Indexes
Index Type Tablespace Column
JE_IT_VAT_REGISTERS_TL_U1 UNIQUE APPS_TS_TX_IDX VAT_REGISTER_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
VAT_REGISTER_ID NUMBER
Y
VAT_REGISTER_NAME VARCHAR2 (50)
LANGUAGE VARCHAR2 (4) Y
SOURCE_LANG VARCHAR2 (4) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

AP.JE_IT_VAT_REGISTERS_TL does not reference any database object

AP.JE_IT_VAT_REGISTERS_TL is referenced by following:

AP
VIEW - JE_IT_VAT_REGISTERS_TL#

[top of page]

Table: JE_IT_VAT_REG_DOCS

Description: Document sequence information for Italian VAT registers
Primary Key: JE_IT_VAT_REG_DOCS_PK
  1. VAT_REGISTER_ID
  2. DOCUMENT
Foreign Keys from this table:
Foreign Key Column Foreign Table
JE_IT_VAT_REG_DOCS.VAT_REGISTER_ID JE_IT_VAT_REGISTERS_B
Comments
Indexes
Index Type Tablespace Column
JE_IT_VAT_REG_DOCS_U1 UNIQUE APPS_TS_TX_IDX VAT_REGISTER_ID
DOCUMENT
Columns
Name Datatype Length Mandatory Comments
VAT_REGISTER_ID NUMBER
Y
DOCUMENT VARCHAR2 (30) Y
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

AP.JE_IT_VAT_REG_DOCS does not reference any database object

AP.JE_IT_VAT_REG_DOCS is referenced by following:

AP
VIEW - JE_IT_VAT_REG_DOCS#

[top of page]

Table: JE_IT_VAT_REPORT_INV

Description: Invoices reported on submitted Italian VAT Register
Primary Key: JE_IT_VAT_REPORT_INV_PK
  1. TRX_ID
  2. VAT_REGISTER_ID
  3. REQUEST_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JE_IT_VAT_REPORT_INV.TRX_ID AP_INVOICES_ALL
JE_IT_VAT_REPORT_INV.TRX_ID RA_CUSTOMER_TRX_ALL
JE_IT_VAT_REPORT_INV.VAT_REGISTER_ID JE_IT_VAT_REGISTERS_B
JE_IT_VAT_REPORT_INV.REQUEST_ID JE_IT_REPORT_PARAMETERS
Comments

JE_IT_VAT_REPORT_INV contains invoices reported on submitted Italian VAT registers. This table stores all transactions included in an Italian register reports; the transaction is inserted in the table once for each register name that it is included in.

Indexes
Index Type Tablespace Column
JE_IT_VAT_REPORT_N1 NONUNIQUE APPS_TS_TX_IDX VAT_REGISTER_ID
SET_OF_BOOKS_ID
TRX_ID
Columns
Name Datatype Length Mandatory Comments
TRX_ID NUMBER
Y Transaction identifier
VAT_REGISTER_ID NUMBER
Y VAT register identifier
REQUEST_ID NUMBER (15) Y Request identifier
SET_OF_BOOKS_ID NUMBER (15) Y Set of Books identifier
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column

[top of page]

JE.JE_IT_VAT_REPORT_INV does not reference any database object

JE.JE_IT_VAT_REPORT_INV is referenced by following:

JE
VIEW - JE_IT_VAT_REPORT_INV#

[top of page]

Table: JE_IT_YEAR_EX_LIMIT

Description: The JE_IT_YEAR_EX_LIMIT table stores yearly exemption limits and their monthly adjustments. This table is populated by the Italian Payables Exemption Limit Manager. When you enter a new year through this program, twelve records, one for ea
Primary Key: JE_IT_YEAR_EX_LIMIT_PK
  1. SET_OF_BOOKS_ID
  2. YEAR
  3. MONTH
Comments
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Y
YEAR NUMBER (4) Y
MONTH NUMBER (3) Y
ORIGINAL_LIMIT_AMOUNT NUMBER
Y
ADJUSTMENT_AMOUNT NUMBER
Y
ADJUSTED_LIMIT_AMOUNT NUMBER
Y
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LEGAL_ENTITY_ID NUMBER (15)

[top of page]

AP.JE_IT_YEAR_EX_LIMIT does not reference any database object

AP.JE_IT_YEAR_EX_LIMIT is referenced by following:

AP
VIEW - JE_IT_YEAR_EX_LIMIT#

[top of page]

Table: JE_NL_EFT_BATCHES

Description: Dutch EFT payment batches
Primary Key: JE_NL_EFT_BATCHES_PK
  1. BATCH_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
JE_NL_EFT_MEDIA.JE_NL_EFT_MEDIA_BATCH_ID JE_NL_EFT_BATCHES
Comments
Indexes
Index Type Tablespace Column
JE_NL_EFT_BATCHES_U1 UNIQUE APPS_TS_TX_IDX BATCH_ID
JE_NL_EFT_BATCHES_U2 UNIQUE APPS_TS_TX_IDX CHECKRUN_NAME
JE_NL_EFT_BATCHES_U3 UNIQUE APPS_TS_TX_IDX MEDIUM_ID
MEDIUM_SEQNO
Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CHECKRUN_NAME VARCHAR2 (50) Y
DATE_CREATED DATE
Y
BATCH_FORMAT VARCHAR2 (30) Y
MEDIUM_ID NUMBER (15)
MEDIUM_SEQNO NUMBER (4)
PAYER_BANK_ACCOUNT VARCHAR2 (30)
TOT_BANK_ACCOUNTS NUMBER (19)
TOT_PAYMENT_AMOUNT NUMBER

TOT_PAYMENTS NUMBER (6)
TOT_RECORDS NUMBER (6)
NO_OF_CANCELLATIONS NUMBER (6)
FIRST_PAYMENT_NUMBER NUMBER (15)
LAST_PAYMENT_NUMBER NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

AP.JE_NL_EFT_BATCHES does not reference any database object

AP.JE_NL_EFT_BATCHES is referenced by following:

AP
VIEW - JE_NL_EFT_BATCHES#

[top of page]

Table: JE_NL_EFT_CONTENTS

Description: Dutch EFT payments
Primary Key: JE_NL_EFT_CONTENTS_PK
  1. BATCH_ID
  2. ROW_SEQNO
Comments
Indexes
Index Type Tablespace Column
JE_NL_EFT_CONTENTS_U1 UNIQUE APPS_TS_TX_IDX BATCH_ID
ROW_SEQNO
Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (15) Y
ROW_SEQNO NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
INFO_RECORD VARCHAR2 (296)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (38)

[top of page]

AP.JE_NL_EFT_CONTENTS does not reference any database object

AP.JE_NL_EFT_CONTENTS is referenced by following:

AP
VIEW - JE_NL_EFT_CONTENTS#

[top of page]

Table: JE_NL_EFT_MEDIA

Description: Media information for creating Dutch EFT documents
Primary Key: JE_NL_EFT_MEDIA_PK
  1. MEDIUM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
JE_NL_EFT_MEDIA.JE_NL_EFT_MEDIA_BATCH_ID JE_NL_EFT_BATCHES
Comments
Indexes
Index Type Tablespace Column
JE_NL_EFT_MEDIA_U1 UNIQUE APPS_TS_TX_IDX MEDIUM_ID
JE_NL_EFT_MEDIA_U2 UNIQUE APPS_TS_TX_IDX MEDIUM_IDENTIFICATION
JE_NL_EFT_MEDIA_N1 NONUNIQUE APPS_TS_TX_IDX MEDIUM_NUMBER
Columns
Name Datatype Length Mandatory Comments
MEDIUM_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
MEDIUM_TYPE VARCHAR2 (25) Y
BATCH_FORMAT VARCHAR2 (30) Y
MEDIUM_IDENTIFICATION VARCHAR2 (6)
MEDIUM_NUMBER VARCHAR2 (4)
EFT_USER_NUMBER VARCHAR2 (5)
DATE_GENERATED DATE

DATE_DUPLICATE DATE

DATE_SENT DATE

NOTES VARCHAR2 (240)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

AP.JE_NL_EFT_MEDIA does not reference any database object

AP.JE_NL_EFT_MEDIA is referenced by following:

AP
VIEW - JE_NL_EFT_MEDIA#

[top of page]

Table: JE_NL_EFT_SPECS

Description: Information for Dutch EFT Payment formatting
Primary Key: JE_NL_EFT_SPECS_PK
  1. CHECKRUN_NAME
  2. CHECK_NUMBER
Comments
Indexes
Index Type Tablespace Column
JE_NL_EFT_SPECS_N1 NONUNIQUE APPS_TS_TX_IDX CHECKRUN_NAME
Columns
Name Datatype Length Mandatory Comments
CHECKRUN_NAME VARCHAR2 (60) Y
CHECK_NUMBER NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

AP.JE_NL_EFT_SPECS does not reference any database object

AP.JE_NL_EFT_SPECS is referenced by following:

AP
VIEW - JE_NL_EFT_SPECS#

[top of page]

Table: JE_NO_BANK_AVSTEM_TEMP

Description: Bank transactions
Comments
Columns
Name Datatype Length Mandatory Comments
SORTKONTO VARCHAR2 (240)
KONTO VARCHAR2 (240)
HOVEDDATO DATE

BANKDATO VARCHAR2 (9)
POSTERTDATO DATE

KILDE VARCHAR2 (11)
KUNDE_LEV VARCHAR2 (20)
BET_TYPE VARCHAR2 (10)
BET_BUNKE VARCHAR2 (10)
BILAGNR VARCHAR2 (10)
AMOUNT NUMBER

BESKRIV VARCHAR2 (20)
W_SESSIONID NUMBER

W_ENTRYID NUMBER

[top of page]

AP.JE_NO_BANK_AVSTEM_TEMP does not reference any database object

AP.JE_NO_BANK_AVSTEM_TEMP is referenced by following:

AP
VIEW - JE_NO_BANK_AVSTEM_TEMP#

[top of page]

Table: JE_NO_BBS

Description: Information for Norwegian BBS Payment formatting
Comments
Columns
Name Datatype Length Mandatory Comments
REC_TYPE VARCHAR2 (1)
BUFFER VARCHAR2 (80)
W_SESSIONID NUMBER

W_ENTRYID NUMBER

[top of page]

AP.JE_NO_BBS does not reference any database object

AP.JE_NO_BBS is referenced by following:

AP
VIEW - JE_NO_BBS#

[top of page]

Table: JE_NO_BBS_MESSAGE

Description: Error messages related Norwegian BBS Payment formatting
Comments
Columns
Name Datatype Length Mandatory Comments
MELDING_NR NUMBER (8)
MELDING VARCHAR2 (75)

[top of page]

AP.JE_NO_BBS_MESSAGE does not reference any database object

AP.JE_NO_BBS_MESSAGE is referenced by following:

AP
VIEW - JE_NO_BBS_MESSAGE#

[top of page]

Table: JE_NO_DATADIALOG

Description: Information for Norwegian Datadialog Payment formatting
Comments
Columns
Name Datatype Length Mandatory Comments
REC_TYPE VARCHAR2 (1)
PAYMENT_NUM NUMBER (15)
CHECK_NUMBER VARCHAR2 (14)
BUFFER VARCHAR2 (121)
W_SESSIONID NUMBER

W_ENTRYID NUMBER

[top of page]

AP.JE_NO_DATADIALOG does not reference any database object

AP.JE_NO_DATADIALOG is referenced by following:

AP
VIEW - JE_NO_DATADIALOG#

[top of page]

Table: JE_NO_GEI_AREPORTS

Description: Table used to hold A-report data from FIN
Comments

Table holds A-report data recieved from FIN.

Columns
Name Datatype Length Mandatory Comments
RECORD_ID VARCHAR2 (6)
Record identifier
ACCOUNT VARCHAR2 (70)
Account number
AMOUNT VARCHAR2 (50)
Amount

[top of page]

JE.JE_NO_GEI_AREPORTS does not reference any database object

JE.JE_NO_GEI_AREPORTS is referenced by following:

JE
VIEW - JE_NO_GEI_AREPORTS#

[top of page]

Table: JE_NO_GEI_ASCIIS_T

Description: This table stores data temporarily that are to be sent to FIN.
Comments

This table stores data temporarily that are to be sent to FIN. Data is retrieved through procedure in report JENGEIS. This contains the data for sending S-Report.

Columns
Name Datatype Length Mandatory Comments
LINE_NUMBER NUMBER (3) Y Line number
TEXT VARCHAR2 (200) Y Text

[top of page]

JE.JE_NO_GEI_ASCIIS_T does not reference any database object

JE.JE_NO_GEI_ASCIIS_T is referenced by following:

JE
VIEW - JE_NO_GEI_ASCIIS_T#

[top of page]

Table: JE_NO_GEI_CONTROLAS

Description: 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 recieved from FIN
Primary Key: JE_NO_GEI_CONTROLAS_PK
  1. ORDER_NUMBER
Foreign Keys to this table:
Foreign Key Column Foreign Table
JE_NO_GEI_MESSAGES.ORDER_NUMBER JE_NO_GEI_CONTROLAS
Comments

Table Stores info about ordering and recieving files related to A-Report.

Columns
Name Datatype Length Mandatory Comments
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15)
Standard who column
LAST_UPDATE_DATE DATE

Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
ORDER_NUMBER NUMBER (35) Y Order number
D_DATE DATE

The date for when the A-Report was ordered
COORDINATOR VARCHAR2 (35)
The person who can be referred to on matters concerning the order
PHONE VARCHAR2 (10)
Phone number
FAX VARCHAR2 (10)
Fax number
PERIOD_START VARCHAR2 (15)
Period start
PERIOD_END VARCHAR2 (15)
Period end
MSG_PERIOD_START VARCHAR2 (6)
Start period for the order
MSG_PERIOD_END VARCHAR2 (6)
End period for the order
MSG_RECEIPT_TYPE VARCHAR2 (2)
Type of receipt recieved from FIN

[top of page]

JE.JE_NO_GEI_CONTROLAS does not reference any database object

JE.JE_NO_GEI_CONTROLAS is referenced by following:

JE
VIEW - JE_NO_GEI_CONTROLAS#

[top of page]

Table: JE_NO_GEI_CONTROLS

Description: Table Stores info about ordering and recieving files related to S-Report.
Primary Key: JE_NO_GEI_CONTROLS_PK
  1. ORDER_NUMBER
Foreign Keys to this table:
Foreign Key Column Foreign Table
JE_NO_GEI_MESSAGES.ORDER_NUMBER JE_NO_GEI_CONTROLS
Comments

Table Stores info about ordering and recieving files related to S-Report.

Columns
Name Datatype Length Mandatory Comments
ORDER_NUMBER NUMBER (35) Y Order number
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15)
Standard who column
LAST_UPDATE_DATE DATE

Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
MSG_PERIOD VARCHAR2 (6)
The Period for which the S-Report is submitted
MSG_RECEIPT_TYPE VARCHAR2 (2)
Type of receipt recieved from FIN

[top of page]

JE.JE_NO_GEI_CONTROLS does not reference any database object

JE.JE_NO_GEI_CONTROLS is referenced by following:

JE
VIEW - JE_NO_GEI_CONTROLS#

[top of page]

Table: JE_NO_GEI_MESSAGES

Description: Table Stores messages recieved from FIN
Foreign Keys from this table:
Foreign Key Column Foreign Table
JE_NO_GEI_MESSAGES.ORDER_NUMBER JE_NO_GEI_CONTROLAS
JE_NO_GEI_MESSAGES.ORDER_NUMBER JE_NO_GEI_CONTROLS
Comments

Table Stores info about ordering and recieving files related to A-Report.

Columns
Name Datatype Length Mandatory Comments
RECORD_ID VARCHAR2 (2)
Record identifier
ORDER_NUMBER NUMBER (35)
Order number
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15)
Standard who column
LAST_UPDATE_DATE DATE

Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
PERIOD DATE

Period
PERIOD_START VARCHAR2 (6)
Period start
PERIOD_END VARCHAR2 (6)
Period end
RECEIPT_TYPE VARCHAR2 (2)
Receipt type
ERROR_CODE NUMBER (3)
Error code
ERROR_MESSAGE VARCHAR2 (100)
Error message

[top of page]

JE.JE_NO_GEI_MESSAGES does not reference any database object

JE.JE_NO_GEI_MESSAGES is referenced by following:

JE
VIEW - JE_NO_GEI_MESSAGES#

[top of page]

Table: JE_NO_GL_VAT_REP

Description: Stores transactions reported to the Norwegians Tax Authorities
Comments

This table stores information about transactions which have been reported to the Norwegians Tax Authorities.
When the Norwegian VAT Reconciliation Report is running in final mode, all transactions have to be inserted to this table so the report should not be able to select them again. REQUEST_ID stores the request Id when anyone runs the report in final mode. The REQUEST_ID makes it possible to reprint the previous final report.

Indexes
Index Type Tablespace Column
JE_NO_GL_VAT_REP_U1 UNIQUE APPS_TS_TX_IDX REQUEST_ID
SET_OF_BOOKS_ID
TRX_ID
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Y Set of Books Id
TRX_ID NUMBER
Y Trx Id
DISTRIBUTION_ID NUMBER
Y Distribution Id
REQUEST_ID NUMBER (15) Y Request Id
GL_DATE DATE
Y GL Date
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
LAST_UPDATE_BY NUMBER (15)
LAST_UPDATE_DATE DATE
Y Standard who column
ATTRIBUTE1 VARCHAR2 (150)
Optional Column
ATTRIBUTE2 VARCHAR2 (150)
Optional Column
ATTRIBUTE3 VARCHAR2 (150)
Optional Column
ATTRIBUTE4 VARCHAR2 (150)
Optional Column
ATTRIBUTE5 VARCHAR2 (150)
Optional Column
LAST_UPDATED_BY NUMBER (15) Y Standard who column

[top of page]

JE.JE_NO_GL_VAT_REP does not reference any database object

JE.JE_NO_GL_VAT_REP is referenced by following:

JE
VIEW - JE_NO_GL_VAT_REP#

[top of page]

Table: JE_NO_INVEST_LINES

Description: Copy of AP_INVOICE_DISTRIBUTIONS and two more columns for investment tax
Foreign Keys from this table:
Foreign Key Column Foreign Table
JE_NO_INVEST_LINES.PROGRAM_APPLICATION_ID
JE_NO_INVEST_LINES.PROGRAM_ID 		FND_CONCURRENT_PROGRAMS
Comments
Indexes
Index Type Tablespace Column
JE_NO_INVEST_LINES_N1 NONUNIQUE APPS_TS_TX_IDX PROGRAM_APPLICATION_ID
PROGRAM_ID
Columns
Name Datatype Length Mandatory Comments
INVOICE_DISTRIBUTION_ID NUMBER (15) Y
ACCOUNTING_DATE DATE
Y
ACCRUAL_POSTED_FLAG VARCHAR2 (1)
ASSETS_ADDITION_FLAG VARCHAR2 (1)
ASSETS_TRACKING_FLAG VARCHAR2 (1)
CASH_POSTED_FLAG VARCHAR2 (1)
DISTRIBUTION_LINE_NUMBER NUMBER (15)
DIST_CODE_COMBINATION_ID NUMBER (15)
INVOICE_ID NUMBER (15)
LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LINE_TYPE_LOOKUP_CODE VARCHAR2 (25)
PERIOD_NAME VARCHAR2 (15)
SET_OF_BOOKS_ID NUMBER (15)
ACCTS_PAY_CODE_COMBINATION_ID NUMBER (15)
AMOUNT NUMBER

BASE_AMOUNT NUMBER

BASE_INVOICE_PRICE_VARIANCE NUMBER

BATCH_ID NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

DESCRIPTION VARCHAR2 (240)
EXCHANGE_RATE_VARIANCE NUMBER

FINAL_MATCH_FLAG VARCHAR2 (1)
INCOME_TAX_REGION VARCHAR2 (10)
INVOICE_PRICE_VARIANCE NUMBER

LAST_UPDATE_LOGIN NUMBER

MATCH_STATUS_FLAG VARCHAR2 (1)
POSTED_FLAG VARCHAR2 (1)
PO_DISTRIBUTION_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

QUANTITY_INVOICED NUMBER

RATE_VAR_CODE_COMBINATION_ID NUMBER (15)
REQUEST_ID NUMBER (15)
REVERSAL_FLAG VARCHAR2 (1)
TYPE_1099 VARCHAR2 (10)
UNIT_PRICE NUMBER

VAT_CODE VARCHAR2 (15)
AMOUNT_ENCUMBERED VARCHAR2 (15)
BASE_AMOUNT_ENCUMBERED NUMBER

ENCUMBERED_FLAG VARCHAR2 (1)
EXCHANGE_DATE DATE

EXCHANGE_RATE NUMBER

EXCHANGE_RATE_TYPE VARCHAR2 (30)
PRICE_ADJUSTMENT_FLAG VARCHAR2 (1)
PRICE_VAR_CODE_COMBINATION_ID NUMBER (15)
QUANTITY_UNENCUMBERED NUMBER

STAT_AMOUNT NUMBER

AMOUNT_TO_POST NUMBER

ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE_CATEGORY VARCHAR2 (150)
BASE_AMOUNT_TO_POST NUMBER

CASH_JE_BATCH_ID NUMBER (15)
EXPENDITURE_ITEM_DATE DATE

EXPENDITURE_ORGANIZATION_ID NUMBER (15)
EXPENDITURE_TYPE VARCHAR2 (30)
JE_BATCH_ID NUMBER (15)
PARENT_INVOICE_ID NUMBER (15)
PA_ADDITION_FLAG VARCHAR2 (1)
PA_QUANTITY NUMBER (22)
POSTED_AMOUNT NUMBER

POSTED_BASE_AMOUNT NUMBER

PREPAY_AMOUNT_REMAINING NUMBER

PROJECT_ACCOUNTING_CONTEXT VARCHAR2 (30)
PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
USSGL_TRANSACTION_CODE VARCHAR2 (30)
USSGL_TRX_CODE_CONTEXT VARCHAR2 (30)
EARLIEST_SETTLEMENT_DATE DATE

REQ_DISTRIBUTION_ID NUMBER (15)
QUANTITY_VARIANCE NUMBER

BASE_QUANTITY_VARIANCE NUMBER

PACKET_ID NUMBER (15)
W_SESSIONID NUMBER

W_ENTRYID NUMBER

ACCOUNTING_EVENT_ID NUMBER (15)
PREPAY_DISTRIBUTION_ID NUMBER (15)
TAX_CODE_ID NUMBER (15)
AWARD_ID NUMBER (15)
GMS_BURDENABLE_RAW_COST NUMBER

DIST_MATCH_TYPE VARCHAR2 (30)
RCV_TRANSACTION_ID NUMBER (15)
PARENT_REVERSAL_ID NUMBER (15)
MATCHED_UOM_LOOKUP_CODE VARCHAR2 (30)
AR_INVOICE_ID NUMBER (15)
AR_INVOICE_LINE_NUM NUMBER (15)
PA_IC_PROCESSED_FLAG VARCHAR2 (1)
TAX_RECOVERY_RATE NUMBER

TAX_RECOVERY_OVERRIDE_FLAG VARCHAR2 (1)
TAX_RECOVERABLE_FLAG VARCHAR2 (1)
TAX_CODE_OVERRIDE_FLAG VARCHAR2 (80)
MERCHANT_DOCUMENT_NUMBER VARCHAR2 (80)
MERCHANT_NAME VARCHAR2 (80)
MERCHANT_REFERENCE VARCHAR2 (240)
MERCHANT_TAX_REG_NUMBER VARCHAR2 (80)
MERCHANT_TAXPAYER_ID VARCHAR2 (80)
COUNTRY_OF_SUPPLY VARCHAR2 (5)
PA_CC_AR_INVOICE_ID NUMBER (15)
PA_CC_AR_INVOICE_LINE_NUM NUMBER (15)
PA_CC_PROCESSED_CODE VARCHAR2 (1)
CREDIT_CARD_TRX_ID NUMBER (15)

[top of page]

AP.JE_NO_INVEST_LINES does not reference any database object

AP.JE_NO_INVEST_LINES is referenced by following:

AP
VIEW - JE_NO_INVEST_LINES#

[top of page]

Table: JE_NO_INVEST_SETUP_B

Description: Setup information for Norwegian Investment Tax
Primary Key: JE_NO_INVEST_SETUP_B_PK
  1. SEGMENT_NAME
  2. FOR_SEGMENT_VALUE
  3. TAX_CODE_ALLOWED
Foreign Keys to this table:
Foreign Key Column Foreign Table
JE_NO_INVEST_SETUP_TL.SEGMENT_NAME
JE_NO_INVEST_SETUP_TL.FOR_SEGMENT_VALUE
JE_NO_INVEST_SETUP_TL.TAX_CODE_ALLOWED 		JE_NO_INVEST_SETUP_B
Comments
Indexes
Index Type Tablespace Column
JE_NO_INVEST_SETUP_B_U1 UNIQUE APPS_TS_TX_IDX SEGMENT_NAME
FOR_SEGMENT_VALUE
TAX_CODE_ALLOWED
Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER
Y
APPLICATION_COLUMN_NAME VARCHAR2 (25) Y
SEGMENT_NAME VARCHAR2 (25) Y
FOR_SEGMENT_VALUE VARCHAR2 (25) Y
TAX_CODE_ALLOWED VARCHAR2 (15) Y
ID_FLEX_NUM NUMBER (15)
INV_CODE_COMBINATION_ID NUMBER

TAX_RATE NUMBER

INACTIVE_DATE DATE

LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

AP.JE_NO_INVEST_SETUP_B does not reference any database object

AP.JE_NO_INVEST_SETUP_B is referenced by following:

AP
VIEW - JE_NO_INVEST_SETUP_B#

[top of page]

Table: JE_NO_INVEST_SETUP_TL

Description: Translated setup information for Norwegian Investment Tax
Primary Key: JE_NO_INVEST_SETUP_TL_PK
  1. SEGMENT_NAME
  2. FOR_SEGMENT_VALUE
  3. TAX_CODE_ALLOWED
  4. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
JE_NO_INVEST_SETUP_TL.SEGMENT_NAME
JE_NO_INVEST_SETUP_TL.FOR_SEGMENT_VALUE
JE_NO_INVEST_SETUP_TL.TAX_CODE_ALLOWED 		JE_NO_INVEST_SETUP_B
Comments
Indexes
Index Type Tablespace Column
JE_NO_INVEST_SETUP_TL_U1 UNIQUE APPS_TS_TX_IDX SEGMENT_NAME
FOR_SEGMENT_VALUE
TAX_CODE_ALLOWED
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
SEGMENT_NAME VARCHAR2 (25) Y
FOR_SEGMENT_VALUE VARCHAR2 (25) Y
TAX_CODE_ALLOWED VARCHAR2 (15) Y
LANGUAGE VARCHAR2 (4) Y
SOURCE_LANG VARCHAR2 (4) Y
DESCRIPTION VARCHAR2 (240)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

AP.JE_NO_INVEST_SETUP_TL does not reference any database object

AP.JE_NO_INVEST_SETUP_TL is referenced by following:

AP
VIEW - JE_NO_INVEST_SETUP_TL#

[top of page]

Table: JE_NO_REPORT_PARAMETERS

Description: stores the request parameters for the Norwegian VAT Reconciliation repor
Comments

This table stores the request parameters for the Norwegian VAT Reconciliation report submitted in final mode.
To be able to reprint a report submitted in final mode, fill in the parameter values so that the comparison can be made to parameter values entered in previous report submissions. Through the REQUEST_ID the report is able to find the correct data stored in JE_NO_GL_VAT_REP table.

Indexes
Index Type Tablespace Column
JE_NO_REPORT_PARAMETERS_U1 UNIQUE APPS_TS_TX_IDX REQUEST_ID
JE_NO_REPORT_PARAMETERS_N1 NONUNIQUE APPS_TS_TX_IDX SET_OF_BOOKS_ID
CONCURRENT_PROGRAM_ID
Columns
Name Datatype Length Mandatory Comments
CONCURRENT_PROGRAM_ID NUMBER (15) Y Concurrent program Id
SET_OF_BOOKS_ID NUMBER (15) Y Set of books id
REQUEST_ID NUMBER (15) Y Request Id
RUN_DATE DATE

Run Date
PARAMETER_1 VARCHAR2 (50)
Parameter 1
PARAMETER_2 VARCHAR2 (50)
Parameter 2
PARAMETER_3 VARCHAR2 (50)
Parameter 3
PARAMETER_4 VARCHAR2 (50)
Parameter 4
PARAMETER_5 VARCHAR2 (50)
Parameter 5
PARAMETER_6 VARCHAR2 (50)
Parameter 6
PARAMETER_7 VARCHAR2 (50)
Parameter 7
PARAMETER_8 VARCHAR2 (50)
Parameter 8
PARAMETER_9 VARCHAR2 (50)
Parameter 9
PARAMETER_10 VARCHAR2 (50)
Parameter 10
PARAMETER_11 VARCHAR2 (50)
Parameter 11
REPORT_STATUS VARCHAR2 (1)
Report Status
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
LAST_UPDATE_BY NUMBER (15)
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column

[top of page]

JE.JE_NO_REPORT_PARAMETERS does not reference any database object

JE.JE_NO_REPORT_PARAMETERS is referenced by following:

JE
VIEW - JE_NO_REPORT_PARAMETERS#

[top of page]

Table: JE_NO_TELEPAY

Description: Information on Norwegian Telepay sessions
Comments
Columns
Name Datatype Length Mandatory Comments
CHECKRUN_NAME VARCHAR2 (30)
VENDOR_SITE_ID NUMBER (15)
TRANSTYPE VARCHAR2 (2)
PRINTED_STATUS VARCHAR2 (10)
KJOREDATO DATE

DUE_DATE VARCHAR2 (6)
INVOICE_ID NUMBER (15)
KID VARCHAR2 (1)
BUFFER_1 VARCHAR2 (13)
AH_TRANS_SEKVNR VARCHAR2 (6)
BUFFER_2 VARCHAR2 (51)
SEKVENSKONTROLLFELT VARCHAR2 (4)
BUFFER_3 VARCHAR2 (6)
BUFFER_4 VARCHAR2 (240)
W_SESSIONID NUMBER

W_ENTRYID NUMBER

[top of page]

AP.JE_NO_TELEPAY does not reference any database object

AP.JE_NO_TELEPAY is referenced by following:

AP
VIEW - JE_NO_TELEPAY#

[top of page]

Table: JE_NO_TELEPAY_RETUR1

Description: Return information from the bank on Telepay payments
Comments
Columns
Name Datatype Length Mandatory Comments
BUFFER VARCHAR2 (240)
BUFFER2 VARCHAR2 (80)
SEQ NUMBER

[top of page]

AP.JE_NO_TELEPAY_RETUR1 does not reference any database object

AP.JE_NO_TELEPAY_RETUR1 is referenced by following:

AP
VIEW - JE_NO_TELEPAY_RETUR1#

[top of page]

Table: JE_PT_BANK_TRANSFER_TEXT

Description: Information for Portuguese Payables EFT and Receivables Direct Debit formatting
Comments
Columns
Name Datatype Length Mandatory Comments
TEXT_STRING VARCHAR2 (255) Y
TYPE VARCHAR2 (1) Y
REQUEST_ID VARCHAR2 (40) Y
REQUEST_TYPE VARCHAR2 (3) Y
PRINT_SEQUENCE_NUM NUMBER (15)

[top of page]

JE.JE_PT_BANK_TRANSFER_TEXT does not reference any database object

JE.JE_PT_BANK_TRANSFER_TEXT is referenced by following:

JE
VIEW - JE_PT_BANK_TRANSFER_TEXT#

[top of page]

Table: JE_PT_CERTIFICATES

Description: Portuguese Software Billing Certification ER - Table to store certification information
Comments

Portuguese Software Billing Certification ER - Table to store certification information

Indexes
Index Type Tablespace Column
JE_PT_CERTIFICATES_U1 UNIQUE APPS_TS_TX_IDX APPS_VERSION
KEY_VERSION
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPS_VERSION VARCHAR2 (15) Y Certificiation Release Version
KEY_VERSION NUMBER (15) Y Key Version
PRIVATE_KEY VARCHAR2 (4000)
Private Key
CERTIFICATION_APPLICATION_DATE DATE

Certification Application Date
CERTIFICATION_ISSUE_DATE DATE

Certification Issue Date
CERTIFICATION_NUMBER VARCHAR2 (80)
Certification Number
CREATION_DATE DATE
Y Standard WHO Column
CREATED_BY NUMBER (15) Y Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO Column
LAST_UPDATE_DATE DATE
Y Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

JE.JE_PT_CERTIFICATES does not reference any database object

JE.JE_PT_CERTIFICATES is referenced by following:

JE
VIEW - JE_PT_CERTIFICATES#

[top of page]

Table: JE_PT_JEPTVATR

Description: Information for Payables and Receivables VAT Recapitulative reporting
Primary Key: JE_PT_JEPTVATR_PK
  1. SEQUENCE_NUM
Comments

JE_PT_JEPTVATR contains information for Portuguese Payables and Receivables VAT
Recapitulative reporting. Oracle Payables and Oracle Receivables delete records from previous
processing before inserting new ones into this table, and then create a formatted output file from the stored information when you run the Portuguese Suppliers Recapitulative Extract File program or the Portuguese Customers Recapitulative Extract File program. There are one header record, one trailer record, and multiple detail records. The SEQUENCE_NUM column holds the numbering sequence for the records. The header record has the number "0" and the trailer record has the
number "999999". Detail records are numbered from "1" to "999998". The FI_NUM column holds the taxpayer identification number. Forheader and trailer records, this column holds the reporting
entity's taxpayer identification number. For detail records, FI_NUM
is the customer taxpayer identification number in Oracle
Receivables and the supplier taxpayer identification number in Oracle
Payables. The NET_INV_AMOUNTS column is null in the header record. For detail
records, this column is the sum of ACCTD_AMOUNT from
the RA_CUST_TRX_LINE_GL_DIST table in Oracle Receivables. This column is the sum of BASE_AMOUNT (AMOUNT if the BASE_AMOUNT is null) from the AP_INVOICE_DISTRIBUTIONS
table in Oracle Payables. NET_INV_AMOUNTS for the trailer
record is the sum of NET_INV_AMOUNTS in the detail records.
The COUNT column is null in the header record and detail records. For
the trailer record, COUNT is the total number of detail records.

Columns
Name Datatype Length Mandatory Comments
SEQUENCE_NUM NUMBER (6) Y Sequence number
FI_NUM VARCHAR2 (10)
Taxpayer identification number
NET_INV_AMOUNTS NUMBER (22)
Amount in thousands
COUNT NUMBER (22)
Total number of detail records

[top of page]

JE.JE_PT_JEPTVATR does not reference any database object

JE.JE_PT_JEPTVATR is referenced by following:

JE
VIEW - JE_PT_JEPTVATR#

[top of page]

Table: JE_PT_RA_CUST_TRX_EXTS

Description: Portuguese Software Billing Certification ER - 1:1 Extension table to ra_customer_trx_all
Primary Key: JE_PT_RA_CUST_TRX_EXTS_PK
  1. CUSTOMER_TRX_ID
Comments

Portuguese Software Billing Certification ER - 1:1 Extension table to ra_customer_trx_all

Indexes
Index Type Tablespace Column
JE_PT_RA_CUST_TRX_EXTS_U1 UNIQUE APPS_TS_TX_IDX CUSTOMER_TRX_ID
Columns
Name Datatype Length Mandatory Comments
CUSTOMER_TRX_ID NUMBER (15) Y Customer Transaciton Id
KEY_VERSION NUMBER (15) Y Key Version
CERTIFICATION_NUMBER VARCHAR2 (80)
Certification Number
SIGNATURE VARCHAR2 (240)
Digital Signature
SYSTEM_ENTRY_DATE DATE

System Entry Date
CREATION_DATE DATE
Y Standard WHO Column
CREATED_BY NUMBER (15) Y Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO Column
LAST_UPDATE_DATE DATE
Y Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column

[top of page]

JE.JE_PT_RA_CUST_TRX_EXTS does not reference any database object

JE.JE_PT_RA_CUST_TRX_EXTS is referenced by following:

JE
VIEW - JE_PT_RA_CUST_TRX_EXTS#

[top of page]

Table: JE_SE_EFT

Description: Information for Swedish EFT formatting
Comments
Columns
Name Datatype Length Mandatory Comments
REC_TYPE VARCHAR2 (30)
CHECK_NUMBER VARCHAR2 (14)
BUFFER VARCHAR2 (240)
W_SESSIONID NUMBER

W_ENTRYID NUMBER

EFT_PROGRAM VARCHAR2 (30)

[top of page]

AP.JE_SE_EFT does not reference any database object

AP.JE_SE_EFT is referenced by following:

AP
VIEW - JE_SE_EFT#

[top of page]

Table: JE_UK_SALES_TRX_GT

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
JE_INFO_V1 VARCHAR2 (4000)
JE_INFO_V2 VARCHAR2 (4000)
JE_INFO_V3 VARCHAR2 (4000)
JE_INFO_V4 VARCHAR2 (4000)
JE_INFO_V5 VARCHAR2 (4000)
JE_INFO_V6 VARCHAR2 (4000)
JE_INFO_V7 VARCHAR2 (4000)
JE_INFO_V8 VARCHAR2 (4000)
JE_INFO_V9 VARCHAR2 (4000)
JE_INFO_V10 VARCHAR2 (4000)
JE_INFO_V11 VARCHAR2 (4000)
JE_INFO_V12 VARCHAR2 (4000)
JE_INFO_V13 VARCHAR2 (4000)
JE_INFO_V14 VARCHAR2 (4000)
JE_INFO_V15 VARCHAR2 (4000)
JE_INFO_N1 NUMBER

JE_INFO_N2 NUMBER

JE_INFO_N3 NUMBER

JE_INFO_N4 NUMBER

JE_INFO_N5 NUMBER

JE_INFO_N6 NUMBER

JE_INFO_N7 NUMBER

JE_INFO_N8 NUMBER

JE_INFO_N9 NUMBER

JE_INFO_N10 NUMBER

JE_INFO_D1 DATE

JE_INFO_D2 DATE

JE_INFO_D3 DATE

JE_INFO_D4 DATE

JE_INFO_D5 DATE

JE_INFO_D6 DATE

JE_INFO_D7 DATE

JE_INFO_D8 DATE

JE_INFO_D9 DATE

JE_INFO_D10 DATE

[top of page]

JE.JE_UK_SALES_TRX_GT does not reference any database object

JE.JE_UK_SALES_TRX_GT is referenced by following:

APPS
SYNONYM - JE_UK_SALES_TRX_GT

[top of page]

View: JE_BE_VAT_REP_RULES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
SET_OF_BOOKS_ID NUMBER (15) Y
SOURCE VARCHAR2 (30) Y
SOURCE_DSP VARCHAR2 (80) Y
OF_TRANS_TYPE VARCHAR2 (30) Y
OF_TRANS_TYPE_DSP VARCHAR2 (80) Y
VAT_TRANS_TYPE VARCHAR2 (30) Y
VAT_TRANS_TYPE_DSP VARCHAR2 (80) Y
VAT_TRANS_TYPE_DESC VARCHAR2 (240)
TAX_NAME VARCHAR2 (50) Y
LINE_TYPE VARCHAR2 (30) Y
LINE_TYPE_DSP VARCHAR2 (80) Y
VAT_REPORT_BOX VARCHAR2 (30)
VAT_REPORT_BOX_DSP VARCHAR2 (80)
NOREC_VAT_REP_BOX VARCHAR2 (30)
NOREC_VAT_REP_BOX_DSP VARCHAR2 (80)
SIGN_FLAG VARCHAR2 (30) Y
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

ENABLED_FLAG VARCHAR2 (30) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

APPS.JE_BE_VAT_REP_RULES_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - JE_BE_VAT_REP_RULES

APPS.JE_BE_VAT_REP_RULES_V is not referenced by any database object

[top of page]

View: JE_ES_MESSAGES

Comments
View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

JE_ES_MESSAGES is a view of all the information in
JE_ES_MESSAGES_ALL specific to the organization identifier of the
client.

Columns
Name Datatype Length Mandatory Comments
STEP NUMBER

Processing step
MESSAGE VARCHAR2 (60)
Message text
ORG_ID NUMBER (15)
Organization identifier

[top of page]

APPS.JE_ES_MESSAGES references the following:

APPS
SYNONYM - JE_ES_MESSAGES_ALL

APPS.JE_ES_MESSAGES is not referenced by any database object

[top of page]

View: JE_ES_MODELO_347

Comments
View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

Multi-Org Partitioning View for JE_ES_MODELO_347_ALL:
Used for temporary storage of information prior to running JEESAPOP.

Columns
Name Datatype Length Mandatory Comments
TIPO VARCHAR2 (1) Y
IMPORTE NUMBER
Y
NOMBRE VARCHAR2 (60)
NIF VARCHAR2 (9)
SIGLA VARCHAR2 (4)
MUNICIPIO VARCHAR2 (50)
CODIGO_POSTAL VARCHAR2 (5)
FIN_IND VARCHAR2 (1)
VIA_PUBLICA VARCHAR2 (50)
NUMERO NUMBER (5)
COMENTARIO VARCHAR2 (130)
SET_OF_BOOKS_ID NUMBER (15) Y
ORG_ID NUMBER (15)
FLAG_ARRENDA VARCHAR2 (1)
ESCALERA VARCHAR2 (2)
PISO VARCHAR2 (2)
PUERTA VARCHAR2 (2)
REF_CATASTRAL VARCHAR2 (25)

[top of page]

APPS.JE_ES_MODELO_347 references the following:

APPS
SYNONYM - JE_ES_MODELO_347_ALL

APPS.JE_ES_MODELO_347 is not referenced by any database object

[top of page]

View: JE_ES_MODELO_349

Comments
View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

JE_ES_MODELO_349 is a multi-org view that retrieves data for your current operating unit and ignores data in other operating units. The multi-org partitioning view for JE_ES_MODELO_349_ALL is used for temporary storage of information prior to running the Spanish Modelo 349 data extracts for Oracle Payables (JEESAPOP) and Oracle Receivables (JEESRRVC) concurrent programs.

Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Y
CLAVE_OPERACION VARCHAR2 (1) Y
ORG_ID NUMBER (15)
NIF_COMUNITARIO VARCHAR2 (14)
NOMBRE VARCHAR2 (40)
BASE_IMPONIBLE NUMBER

OPERACION_TRIANGULAR VARCHAR2 (1)
EJERCICIO VARCHAR2 (2)
PERIODO VARCHAR2 (2)
FIN_IND VARCHAR2 (1) Y
RUNNING_TOTAL NUMBER

FORMERLY_DECLARED_AMOUNT NUMBER

PRINT_PERIOD VARCHAR2 (2)
PRINT_YEAR VARCHAR2 (4)
PRINT_MODE VARCHAR2 (1)

[top of page]

APPS.JE_ES_MODELO_349 references the following:

APPS
SYNONYM - JE_ES_MODELO_349_ALL

APPS.JE_ES_MODELO_349 is not referenced by any database object

[top of page]

View: JE_ES_MODELO_415

Comments
View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Y
CLAVE_OPERACION VARCHAR2 (1) Y
ORG_ID NUMBER (15)
NIF VARCHAR2 (9)
NOMBRE VARCHAR2 (40)
IMPORTE NUMBER

DIRECCION VARCHAR2 (32)
CODIGO_POSTAL VARCHAR2 (5)
MUNICIPIO VARCHAR2 (24)
FIN_IND VARCHAR2 (1) Y

[top of page]

APPS.JE_ES_MODELO_415 references the following:

APPS
SYNONYM - JE_ES_MODELO_415_ALL

APPS.JE_ES_MODELO_415 is not referenced by any database object

[top of page]

View: JE_ES_TAX_TYPE_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
REPORTING_CODE_CHAR_VALUE VARCHAR2 (60)
Column to store alphanumeric value for the reporting code
REPORTING_CODE_NAME VARCHAR2 (240)
Description of the reporting codeDescription of the reporting code
VAT_REPORTING_ENTITY_ID NUMBER

VAT Reporting Entity dentifier
MAPPING_VAT_REP_ENTITY_ID NUMBER

Mapping VAT Reporting Entity Identifier
TAX_REGIME_CODE VARCHAR2 (30)
Tax Regime Code
TAX VARCHAR2 (30)
Tax

[top of page]

APPS.JE_ES_TAX_TYPE_V references the following:

APPS
VIEW - AR_LOOKUPS
SYNONYM - JG_ZZ_VAT_REP_ENTITIES
SYNONYM - ZX_REPORTING_CODES_B
SYNONYM - ZX_REPORTING_CODES_TL
SYNONYM - ZX_REPORTING_TYPES_B

APPS.JE_ES_TAX_TYPE_V is not referenced by any database object

[top of page]

View: JE_GR_TRNOVR_RULE_LINES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
TRNOVR_RULE_LINE_ID NUMBER (15)
TRNOVR_RULE_ID NUMBER (15)
APPLICATION_ID NUMBER (15)
LOOKUP_TYPE VARCHAR2 (30)
GROUP_TYPE VARCHAR2 (80)
LOOKUP_CODE VARCHAR2 (30)
GROUP_NAME VARCHAR2 (80)
DESCRIPTION VARCHAR2 (240)
EXCLUDE_FLAG VARCHAR2 (1)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)
ATTRIBUTE_CATEGORY VARCHAR2 (150)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)

[top of page]

APPS.JE_GR_TRNOVR_RULE_LINES_V references the following:

APPS
VIEW - FND_LOOKUP_TYPES_VL
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - JE_GR_TRNOVR_RULE_LINES

APPS.JE_GR_TRNOVR_RULE_LINES_V is not referenced by any database object

[top of page]

View: JE_IT_EXEMPT_LETTERS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
LEGAL_ENTITY_ID NUMBER (15) Y
VENDOR_ID NUMBER
Y
EFFECTIVE_FROM DATE
Y
EFFECTIVE_TO DATE
Y
YEAR NUMBER (4) Y
EXEMPTION_LETTER_ID NUMBER
Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CLAUSE_REF VARCHAR2 (5) Y
PRINT_FLAG VARCHAR2 (1) Y
CUSTOM_FLAG VARCHAR2 (1) Y
ISSUE_FLAG VARCHAR2 (1) Y
ISSUE_DATE DATE

CLAUSE_REF_DSP VARCHAR2 (80) Y
LAST_UPDATE_LOGIN NUMBER (15)
SET_OF_BOOKS_ID NUMBER (15) Y
LETTER_TYPE VARCHAR2 (30) Y
LETTER_TYPE_DSP VARCHAR2 (80) Y
LIMIT_AMOUNT NUMBER (15)

[top of page]

APPS.JE_IT_EXEMPT_LETTERS_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - JE_IT_EXEMPT_LETTERS

APPS.JE_IT_EXEMPT_LETTERS_V is not referenced by any database object

[top of page]

View: JE_IT_VAT_REGISTERS_VL

Comments
Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
VAT_REGISTER_ID NUMBER
Y
VAT_REGISTER_TYPE VARCHAR2 (30)
START_DATE DATE

END_DATE DATE

LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
VAT_REGISTER_NAME VARCHAR2 (50)

[top of page]

APPS.JE_IT_VAT_REGISTERS_VL references the following:

APPS
SYNONYM - JE_IT_VAT_REGISTERS_B
SYNONYM - JE_IT_VAT_REGISTERS_TL
APPS.JE_IT_VAT_REGISTERS_VL is referenced by following:

APPS
SYNONYM - JE_IT_VAT_REGISTERS

[top of page]

View: JE_IT_VAT_REG_DOCS_V

Comments
Columns
Name Datatype Length Mandatory Comments
VAT_REGISTER_ID NUMBER
Y
DOCUMENT VARCHAR2 (30) Y
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

DOCUMENT_DSP VARCHAR2 (30) Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

APPS.JE_IT_VAT_REG_DOCS_V references the following:

APPS
SYNONYM - FND_DOCUMENT_SEQUENCES
SYNONYM - JE_IT_VAT_REG_DOCS

APPS.JE_IT_VAT_REG_DOCS_V is not referenced by any database object

[top of page]

View: JE_NO_GEI_SREPORT_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

View contains accounting info based on GL_CODE_COMBINATIONS and GL_BALANCES.
View is recreated at runtime by procedure P_GEI_VIEW in report JENOGEIS. When recreated it is based on profile values set by Cst.

Columns
Name Datatype Length Mandatory Comments
AUTHORITY_TYPE VARCHAR2 (25)
Authority type
PERIOD VARCHAR2 (15) Y Period
ACTUAL_FLAG VARCHAR2 (1) Y Actual flag
ACCOUNT_NUMBER VARCHAR2 (25)
Account number
BALANCE NUMBER

Balance
TEMPLATE_ID NUMBER (15)
Template identifier
PERIOD_NUM NUMBER (15)
Period number
PERIOD_YEAR NUMBER (15)
Period year

[top of page]

APPS.JE_NO_GEI_SREPORT_V references the following:

APPS
SYNONYM - GL_BALANCES
SYNONYM - GL_CODE_COMBINATIONS
- GL_SETS_OF_BOOKS

APPS.JE_NO_GEI_SREPORT_V is not referenced by any database object

[top of page]

View: JE_PT_RA_TRX_REQUEST_IDS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER (15)
Concurrent program who column. Identifier of the concurrent request that last updated the transaction
CREATED_FROM VARCHAR2 (30) Y Form name or program name that created the transaction
BATCH_SOURCE_ID NUMBER (15)
Batch source Identifier of the transaction

[top of page]

APPS.JE_PT_RA_TRX_REQUEST_IDS_V references the following:

APPS
SYNONYM - FND_DOCUMENT_SEQUENCES
SYNONYM - JE_PT_RA_CUST_TRX_EXTS
SYNONYM - RA_CUSTOMER_TRX
SYNONYM - RA_CUST_TRX_TYPES_ALL

APPS.JE_PT_RA_TRX_REQUEST_IDS_V is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract