1. Tables and Views for Financials
  2. GL_JE_LINES

GL_JE_LINES

GL_JE_LINES contains the journal entry lines that you enter in the Enter Journals form. There is a one-to-many relationship between journal entries and journal entry lines. Each row in this table stores the associated journal entry header ID, the line number, the associated code combination ID, and the debits or credits associated with the journal line. STATUS is 'U' for unposted or 'P' for posted.

Details

  • Schema: FUSION

  • Object owner: GL

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

GL_JE_LINES_PK

JE_HEADER_ID, JE_LINE_NUM

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping
JE_HEADER_ID NUMBER 18 Yes Journal entry header defining column.
JE_LINE_NUM NUMBER 18 Yes Line on the supplier's response.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LEDGER_ID NUMBER 18 Yes Ledger identifier. Foreign key to GL_LEDGERS.
CODE_COMBINATION_ID NUMBER 18 Yes Key flexfield combination defining column.
PERIOD_NAME VARCHAR2 15 Yes Accounting period. Foreign key to GL_PERIODS.
EFFECTIVE_DATE DATE Yes Journal entry line effective date.
STATUS VARCHAR2 1 Yes Journal entry line status code.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
ENTERED_DR NUMBER Journal entry line debit amount in entered currency.
ENTERED_CR NUMBER Journal entry line credit amount in entered currency.
ACCOUNTED_DR NUMBER Journal entry line debit amount in base currency.
ACCOUNTED_CR NUMBER Journal entry line credit amount in base currency.
DESCRIPTION VARCHAR2 240 Journal entry line description.
REFERENCE_1 VARCHAR2 240 Journal entry line reference column.
REFERENCE_2 VARCHAR2 240 Journal entry line reference column.
REFERENCE_3 VARCHAR2 240 Journal entry line reference column.
REFERENCE_4 VARCHAR2 240 Journal entry line reference column.
REFERENCE_5 VARCHAR2 240 Journal entry line reference column.
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Journal Lines (GL_JE_LINES)
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Journal Lines (GL_JE_LINES)
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Journal Lines (GL_JE_LINES)
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Journal Lines (GL_JE_LINES)
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Journal Lines (GL_JE_LINES)
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Journal Lines (GL_JE_LINES)
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Journal Lines (GL_JE_LINES)
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Journal Lines (GL_JE_LINES)
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Journal Lines (GL_JE_LINES)
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Journal Lines (GL_JE_LINES)
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Journals Captured Information (GL_CAPTURED_INFO)
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Journals Captured Information (GL_CAPTURED_INFO)
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Journals Captured Information (GL_CAPTURED_INFO)
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Journals Captured Information (GL_CAPTURED_INFO)
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Journals Captured Information (GL_CAPTURED_INFO)
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Journals Captured Information (GL_CAPTURED_INFO)
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Journals Captured Information (GL_CAPTURED_INFO)
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Journals Captured Information (GL_CAPTURED_INFO)
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Journals Captured Information (GL_CAPTURED_INFO)
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Journals Captured Information (GL_CAPTURED_INFO)
ATTRIBUTE_CATEGORY VARCHAR2 150 Descriptive Flexfield: structure definition of the user descriptive flexfield. Journal Lines (GL_JE_LINES)
ATTRIBUTE_CATEGORY2 VARCHAR2 150 Descriptive flexfield context column. Journal Value Added Tax (GL_TAX_CODES)
INVOICE_DATE DATE Value added tax descriptive flexfield column. Journal Value Added Tax (GL_TAX_CODES)
TAX_CODE VARCHAR2 15 Value added tax descriptive flexfield column. Journal Value Added Tax (GL_TAX_CODES)
INVOICE_IDENTIFIER VARCHAR2 20 Value added tax descriptive flexfield column. Journal Value Added Tax (GL_TAX_CODES)
INVOICE_AMOUNT NUMBER Value added tax descriptive flexfield column. Journal Value Added Tax (GL_TAX_CODES)
NO1 VARCHAR2 150 Value added tax descriptive flexfield column. Journal Value Added Tax (GL_TAX_CODES)
STAT_AMOUNT NUMBER Journal line statistical amount.
IGNORE_RATE_FLAG VARCHAR2 1 Modify amounts if exchange rate changes.
ATTRIBUTE_CATEGORY3 VARCHAR2 150 Descriptive flexfield context column. Journals Captured Information (GL_CAPTURED_INFO)
USSGL_TRANSACTION_CODE VARCHAR2 30 Oracle internal use only
SUBLEDGER_DOC_SEQUENCE_ID NUMBER Sequential numbering sequence defining column.
ATTRIBUTE_CATEGORY4 VARCHAR2 150 Descriptive flexfield structure defining column.
SUBLEDGER_DOC_SEQUENCE_VALUE NUMBER Sequential numbering sequence value.
REFERENCE_6 VARCHAR2 240 Journal entry line reference column.
REFERENCE_7 VARCHAR2 240 Journal entry line reference column.
REFERENCE_8 VARCHAR2 240 Journal entry line reference column.
REFERENCE_9 VARCHAR2 240 Journal entry line reference column.
REFERENCE_10 VARCHAR2 240 Journal entry line reference column.
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 30 Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE2 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE3 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE4 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE5 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE6 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE7 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE8 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE9 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE10 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE11 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE12 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE13 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE14 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE15 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER1 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER2 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER3 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER4 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER5 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE1 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE2 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE3 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE4 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE5 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GL_SL_LINK_ID NUMBER Link to associated subledger data.
GL_SL_LINK_TABLE VARCHAR2 30 Table containing associated subledger data.
TAXABLE_LINE_FLAG VARCHAR2 1 Taxable line flag for automatic tax calculations.
TAX_TYPE_CODE VARCHAR2 1 Tax type (Input or Output) for automatic tax calculations.
TAX_CODE_ID NUMBER 18 Tax code defining column for automatic tax calculations.
TAX_ROUNDING_RULE_CODE VARCHAR2 1 Rounding rule used for automatic tax calculations.
AMOUNT_INCLUDES_TAX_FLAG VARCHAR2 1 Amount includes tax flag for automatic tax calculations.
TAX_DOCUMENT_IDENTIFIER VARCHAR2 50 Unique identifier of the tax document.
TAX_DOCUMENT_DATE DATE Date of the tax document on the journal line.
TAX_CUSTOMER_NAME VARCHAR2 240 Name of the tax customer on the journal line.
TAX_CUSTOMER_REFERENCE VARCHAR2 240 Reference of the tax customer on the journal line.
TAX_REGISTRATION_NUMBER VARCHAR2 50 Number of the tax registration.
TAX_LINE_FLAG VARCHAR2 1 Automatically generated tax line flag.
TAX_GROUP_ID NUMBER 18 Tax group identifier for automatic tax calculations.
LINE_TYPE_CODE VARCHAR2 20 Line type code on the journal line.
CO_THIRD_PARTY VARCHAR2 14 Columbian third party on the journal line.
CO_PROCESSED_FLAG VARCHAR2 1 Columbian third party processed flag.
CURRENCY_CODE VARCHAR2 15 Yes Entered currency of the journal line.
CURRENCY_CONVERSION_DATE DATE Yes Journal line currency conversion date.
CURRENCY_CONVERSION_TYPE VARCHAR2 30 Yes Journal line currency conversion type.
CURRENCY_CONVERSION_RATE NUMBER Yes Journal line currency conversion rate.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
GLOBAL_ATTRIBUTE16 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE17 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE18 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE19 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE20 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
JGZZ_RECON_REF VARCHAR2 240 Additional Information
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE6 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE7 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE8 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE9 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE10 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
PARTITION_GROUP_CODE VARCHAR2 15 Partition grouping information which when combined with the period, determines the database partition in which this journal line will be stored.

Foreign Keys

Table Foreign Table Foreign Key Column
GL_JE_LINES gl_je_headers JE_HEADER_ID
GL_JE_LINES gl_ledgers LEDGER_ID
GL_JE_LINES gl_code_combinations CODE_COMBINATION_ID
GL_JE_LINES gl_daily_conversion_types CURRENCY_CONVERSION_TYPE
gl_je_lines_recon gl_je_lines JE_HEADER_ID, JE_LINE_NUM
gl_interface gl_je_lines JE_HEADER_ID, JE_LINE_NUM
gl_import_references gl_je_lines JE_HEADER_ID, JE_LINE_NUM
gl_interface_history gl_je_lines JE_HEADER_ID, JE_LINE_NUM

Indexes

Index Uniqueness Tablespace Columns
GL_JE_LINES_N1 Non Unique Default CODE_COMBINATION_ID, PERIOD_NAME
GL_JE_LINES_N3 Non Unique Default SUBLEDGER_DOC_SEQUENCE_VALUE, SUBLEDGER_DOC_SEQUENCE_ID
GL_JE_LINES_U1 Unique Default JE_HEADER_ID, JE_LINE_NUM