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_

LAST_UPDATE_DATE, LAST_UPDATED_BY, JE_HEADER_ID, JE_LINE_NUM

Columns

Name Datatype Length Precision Not-null Comments
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 Ledger identifier. Foreign key to GL_LEDGERS.
CODE_COMBINATION_ID NUMBER 18 Key flexfield combination defining column.
PERIOD_NAME VARCHAR2 15 Accounting period. Foreign key to GL_PERIODS.
EFFECTIVE_DATE DATE Journal entry line effective date.
STATUS VARCHAR2 1 Journal entry line status code.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 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.
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CATEGORY VARCHAR2 150 Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE_CATEGORY2 VARCHAR2 150 Descriptive flexfield context column.
INVOICE_DATE DATE Value added tax descriptive flexfield column.
TAX_CODE VARCHAR2 15 Value added tax descriptive flexfield column.
INVOICE_IDENTIFIER VARCHAR2 20 Value added tax descriptive flexfield column.
INVOICE_AMOUNT NUMBER Value added tax descriptive flexfield column.
NO1 VARCHAR2 150 Value added tax descriptive flexfield column.
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.
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 for 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 Entered currency of the journal line.
CURRENCY_CONVERSION_DATE DATE Journal line currency conversion date.
CURRENCY_CONVERSION_TYPE VARCHAR2 30 Journal line currency conversion type.
CURRENCY_CONVERSION_RATE NUMBER Journal line currency conversion rate.
OBJECT_VERSION_NUMBER NUMBER 9 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 for journal line.
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.
AUDIT_ACTION_TYPE_ VARCHAR2 10 Action Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP_ VARCHAR2 1000 Used to store a bit map of 1s and 0s for each column in the table.
AUDIT_IMPERSONATOR_ VARCHAR2 64 Original Impersonator User.

Indexes

Index Uniqueness Tablespace Columns
GL_JE_LINES_N1_ Non Unique Default JE_HEADER_ID, JE_LINE_NUM, LAST_UPDATE_DATE
GL_JE_LINES_U1_ Unique Default LAST_UPDATE_DATE, LAST_UPDATED_BY, JE_HEADER_ID, JE_LINE_NUM