eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: GL.GL_INTERFACE

Object Details

Object Name:	GL_INTERFACE
Object Type:	TABLE
Owner:	GL
FND Design Data:	SQLGL.GL_INTERFACE
Subobject Name:
Status:	VALID

GL_INTERFACE is used to import journal entry batches through Journal Import. You insert rows in this table and then use the Import Journals window to create journal batches. You must supply values for all NOT NULL columns. For a complete description of how to load this table, see the Oracle General Ledger User Guide.
Scope: public
Product: GL
Lifecycle: active
Display Name: Journal Interface
Category: BUSINESS_ENTITY GL_JOURNAL

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	USER_JE_SOURCE_NAME LEDGER_ID SET_OF_BOOKS_ID GROUP_ID
GL_INTERFACE_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	REQUEST_ID JE_HEADER_ID STATUS CODE_COMBINATION_ID
GL_INTERFACE_N3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	SUBLEDGER_DOC_SEQUENCE_VALUE SUBLEDGER_DOC_SEQUENCE_ID
GL_INTERFACE_N4	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	REFERENCE26 REFERENCE22 REFERENCE23

Columns

Name	Datatype	Length	Mandatory	Comments
STATUS	VARCHAR2	(50)	Yes	Journal Import status
LEDGER_ID	NUMBER	(15)		Ledger defining column
ACCOUNTING_DATE	DATE		Yes	Effective date of the transaction
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency
DATE_CREATED	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
ACTUAL_FLAG	VARCHAR2	(1)	Yes	Balance type (actual, budget, or encumbrance)
USER_JE_CATEGORY_NAME	VARCHAR2	(25)	Yes	Journal entry category user defined name
USER_JE_SOURCE_NAME	VARCHAR2	(25)	Yes	Journal entry source user defined name
CURRENCY_CONVERSION_DATE	DATE			Date of exchange rate
ENCUMBRANCE_TYPE_ID	NUMBER			Encumbrance type defining column
BUDGET_VERSION_ID	NUMBER			Budget version defining column
USER_CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Type of exchange rate
CURRENCY_CONVERSION_RATE	NUMBER			Foreign currency exchange rate
AVERAGE_JOURNAL_FLAG	VARCHAR2	(1)		Average journal flag
ORIGINATING_BAL_SEG_VALUE	VARCHAR2	(25)		Originating balancing segment value
SEGMENT1	VARCHAR2	(25)		Key flexfield segment
SEGMENT2	VARCHAR2	(25)		Key flexfield segment
SEGMENT3	VARCHAR2	(25)		Key flexfield segment
SEGMENT4	VARCHAR2	(25)		Key flexfield segment
SEGMENT5	VARCHAR2	(25)		Key flexfield segment
SEGMENT6	VARCHAR2	(25)		Key flexfield segment
SEGMENT7	VARCHAR2	(25)		Key flexfield segment
SEGMENT8	VARCHAR2	(25)		Key flexfield segment
SEGMENT9	VARCHAR2	(25)		Key flexfield segment
SEGMENT10	VARCHAR2	(25)		Key flexfield segment
SEGMENT11	VARCHAR2	(25)		Key flexfield segment
SEGMENT12	VARCHAR2	(25)		Key flexfield segment
SEGMENT13	VARCHAR2	(25)		Key flexfield segment
SEGMENT14	VARCHAR2	(25)		Key flexfield segment
SEGMENT15	VARCHAR2	(25)		Key flexfield segment
SEGMENT16	VARCHAR2	(25)		Key flexfield segment
SEGMENT17	VARCHAR2	(25)		Key flexfield segment
SEGMENT18	VARCHAR2	(25)		Key flexfield segment
SEGMENT19	VARCHAR2	(25)		Key flexfield segment
SEGMENT20	VARCHAR2	(25)		Key flexfield segment
SEGMENT21	VARCHAR2	(25)		Key flexfield segment
SEGMENT22	VARCHAR2	(25)		Key flexfield segment
SEGMENT23	VARCHAR2	(25)		Key flexfield segment
SEGMENT24	VARCHAR2	(25)		Key flexfield segment
SEGMENT25	VARCHAR2	(25)		Key flexfield segment
SEGMENT26	VARCHAR2	(25)		Key flexfield segment
SEGMENT27	VARCHAR2	(25)		Key flexfield segment
SEGMENT28	VARCHAR2	(25)		Key flexfield segment
SEGMENT29	VARCHAR2	(25)		Key flexfield segment
SEGMENT30	VARCHAR2	(25)		Key flexfield segment
ENTERED_DR	NUMBER			Transaction debit amount, entered currency
ENTERED_CR	NUMBER			Transaction credit amount, entered currency
ACCOUNTED_DR	NUMBER			Transaction debit amount, base currency
ACCOUNTED_CR	NUMBER			Transaction credit amount, base currency
TRANSACTION_DATE	DATE			Date of transaction
REFERENCE1	VARCHAR2	(100)		Journal Import reference column
REFERENCE2	VARCHAR2	(240)		Journal Import reference column
REFERENCE3	VARCHAR2	(100)		Journal Import reference column
REFERENCE4	VARCHAR2	(100)		Journal Import reference column
REFERENCE5	VARCHAR2	(240)		Journal Import reference column
REFERENCE6	VARCHAR2	(100)		Journal Import reference column
REFERENCE7	VARCHAR2	(100)		Journal Import reference column
REFERENCE8	VARCHAR2	(100)		Journal Import reference column
REFERENCE9	VARCHAR2	(100)		Journal Import reference column
REFERENCE10	VARCHAR2	(240)		Journal Import reference column
REFERENCE11	VARCHAR2	(240)		Journal Import reference column
REFERENCE12	VARCHAR2	(100)		Journal Import reference column
REFERENCE13	VARCHAR2	(100)		Journal Import reference column
REFERENCE14	VARCHAR2	(100)		Journal Import reference column
REFERENCE15	VARCHAR2	(100)		Journal Import reference column
REFERENCE16	VARCHAR2	(100)		Journal Import reference column
REFERENCE17	VARCHAR2	(100)		Journal Import reference column
REFERENCE18	VARCHAR2	(100)		Journal Import reference column
REFERENCE19	VARCHAR2	(100)		Journal Import reference column
REFERENCE20	VARCHAR2	(100)		Journal Import reference column
REFERENCE21	VARCHAR2	(240)		Journal Import reference column
REFERENCE22	VARCHAR2	(240)		Journal Import reference column
REFERENCE23	VARCHAR2	(240)		Journal Import reference column
REFERENCE24	VARCHAR2	(240)		Journal Import reference column
REFERENCE25	VARCHAR2	(240)		Journal Import reference column
REFERENCE26	VARCHAR2	(240)		Journal Import reference column
REFERENCE27	VARCHAR2	(240)		Journal Import reference column
REFERENCE28	VARCHAR2	(240)		Journal Import reference column
REFERENCE29	VARCHAR2	(240)		Journal Import reference column
REFERENCE30	VARCHAR2	(240)		Journal Import reference column
JE_BATCH_ID	NUMBER	(15)		Journal entry batch defining column
PERIOD_NAME	VARCHAR2	(15)		Accounting period
JE_HEADER_ID	NUMBER	(15)		Journal entry header defining column
JE_LINE_NUM	NUMBER	(15)		Journal entry line number
CHART_OF_ACCOUNTS_ID	NUMBER	(15)		Key flexfield structure defining column
FUNCTIONAL_CURRENCY_CODE	VARCHAR2	(15)		Ledger base currency
CODE_COMBINATION_ID	NUMBER	(15)		Key flexfield combination defining column
DATE_CREATED_IN_GL	DATE			Date Journal Import created batch
WARNING_CODE	VARCHAR2	(4)		Not currently used
STATUS_DESCRIPTION	VARCHAR2	(240)		Journal import status description
STAT_AMOUNT	NUMBER			Statistical amount
GROUP_ID	NUMBER	(15)		Interface group defining column
REQUEST_ID	NUMBER	(15)		Concurrent program request id
SUBLEDGER_DOC_SEQUENCE_ID	NUMBER			Sequential numbering sequence defining column
SUBLEDGER_DOC_SEQUENCE_VALUE	NUMBER			Sequential numbering sequence value
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
GL_SL_LINK_ID	NUMBER			Link to associated subledger data
GL_SL_LINK_TABLE	VARCHAR2	(30)		Table containing associated subledger data
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
ATTRIBUTE16	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE17	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE18	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE19	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE20	VARCHAR2	(150)		Descriptive flexfield segment
CONTEXT	VARCHAR2	(150)		Descriptive flexfield context column
CONTEXT2	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
CONTEXT3	VARCHAR2	(150)		Descriptive flexfield context column
USSGL_TRANSACTION_CODE	VARCHAR2	(30)		Government transaction code
DESCR_FLEX_ERROR_MESSAGE	VARCHAR2	(240)		Descriptive flexfield error message
JGZZ_RECON_REF	VARCHAR2	(240)		Global reconciliation reference
REFERENCE_DATE	DATE			Reference Date
SET_OF_BOOKS_ID	NUMBER	(15)		Ledger defining column
BALANCING_SEGMENT_VALUE	VARCHAR2	(25)		Balancing segment value
MANAGEMENT_SEGMENT_VALUE	VARCHAR2	(25)		Management segment value
FUNDS_RESERVED_FLAG	VARCHAR2	(1)		Reserved for Oracle internal use

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT STATUS
,      LEDGER_ID
,      ACCOUNTING_DATE
,      CURRENCY_CODE
,      DATE_CREATED
,      CREATED_BY
,      ACTUAL_FLAG
,      USER_JE_CATEGORY_NAME
,      USER_JE_SOURCE_NAME
,      CURRENCY_CONVERSION_DATE
,      ENCUMBRANCE_TYPE_ID
,      BUDGET_VERSION_ID
,      USER_CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      AVERAGE_JOURNAL_FLAG
,      ORIGINATING_BAL_SEG_VALUE
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
,      ENTERED_DR
,      ENTERED_CR
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      TRANSACTION_DATE
,      REFERENCE1
,      REFERENCE2
,      REFERENCE3
,      REFERENCE4
,      REFERENCE5
,      REFERENCE6
,      REFERENCE7
,      REFERENCE8
,      REFERENCE9
,      REFERENCE10
,      REFERENCE11
,      REFERENCE12
,      REFERENCE13
,      REFERENCE14
,      REFERENCE15
,      REFERENCE16
,      REFERENCE17
,      REFERENCE18
,      REFERENCE19
,      REFERENCE20
,      REFERENCE21
,      REFERENCE22
,      REFERENCE23
,      REFERENCE24
,      REFERENCE25
,      REFERENCE26
,      REFERENCE27
,      REFERENCE28
,      REFERENCE29
,      REFERENCE30
,      JE_BATCH_ID
,      PERIOD_NAME
,      JE_HEADER_ID
,      JE_LINE_NUM
,      CHART_OF_ACCOUNTS_ID
,      FUNCTIONAL_CURRENCY_CODE
,      CODE_COMBINATION_ID
,      DATE_CREATED_IN_GL
,      WARNING_CODE
,      STATUS_DESCRIPTION
,      STAT_AMOUNT
,      GROUP_ID
,      REQUEST_ID
,      SUBLEDGER_DOC_SEQUENCE_ID
,      SUBLEDGER_DOC_SEQUENCE_VALUE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      GL_SL_LINK_ID
,      GL_SL_LINK_TABLE
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      CONTEXT
,      CONTEXT2
,      INVOICE_DATE
,      TAX_CODE
,      INVOICE_IDENTIFIER
,      INVOICE_AMOUNT
,      CONTEXT3
,      USSGL_TRANSACTION_CODE
,      DESCR_FLEX_ERROR_MESSAGE
,      JGZZ_RECON_REF
,      REFERENCE_DATE
,      SET_OF_BOOKS_ID
,      BALANCING_SEGMENT_VALUE
,      MANAGEMENT_SEGMENT_VALUE
,      FUNDS_RESERVED_FLAG
FROM GL.GL_INTERFACE;

Dependencies

[top of page]

GL.GL_INTERFACE does not reference any database object

GL.GL_INTERFACE is referenced by following:

APPS: GL_INTERFACE