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


TABLE: GL.GL_INTERFACE

Object Details
Object Name: GL_INTERFACE
Object Type: TABLE
Owner: GL
FND Design Data: TableSQLGL.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: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnUSER_JE_SOURCE_NAME
ColumnLEDGER_ID
ColumnSET_OF_BOOKS_ID
ColumnGROUP_ID
GL_INTERFACE_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnREQUEST_ID
ColumnJE_HEADER_ID
ColumnSTATUS
ColumnCODE_COMBINATION_ID
GL_INTERFACE_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnSUBLEDGER_DOC_SEQUENCE_VALUE
ColumnSUBLEDGER_DOC_SEQUENCE_ID
GL_INTERFACE_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnREFERENCE26
ColumnREFERENCE22
ColumnREFERENCE23
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:

SchemaAPPS
SynonymGL_INTERFACE