[Home] [Help] [Dependency Information]
Object Name: | GL_INTERFACE_HISTORY |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | SQLGL.GL_INTERFACE_HISTORY |
Subobject Name: | |
Status: | VALID |
GL_INTERFACE_HISTORY stores the rows that are successfully imported from the GL_INTERFACE table through Journal Import. You use this information for historical reference only. Your Oracle General Ledger application adds rows to this table every time you successfully run Journal Import with the Archive Journal Import Data option enabled. Your Oracle General Ledger application does not use the information stored in this table.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STATUS | VARCHAR2 | (50) | Yes | Journal import status |
SET_OF_BOOKS_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 |
ENCUMBRANCE_TYPE_ID | NUMBER | Encumbrance type defining column | ||
BUDGET_VERSION_ID | NUMBER | Budget version defining column | ||
CURRENCY_CONVERSION_DATE | DATE | Date of exchange rate | ||
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 | (100) | 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 | Sequence defining column | ||
SUBLEDGER_DOC_SEQUENCE_VALUE | NUMBER | Sequence value | ||
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 | |
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 | |
LEDGER_ID | NUMBER | (15) | Ledger defining column | |
REFERENCE_DATE | DATE | Reference date | ||
GL_SL_LINK_ID | NUMBER | Link to associated subledger defining column | ||
GL_SL_LINK_TABLE | VARCHAR2 | (30) | Table containing associated subledger data | |
JGZZ_RECON_REF | VARCHAR2 | (240) | Global reconciliation reference |
Cut, paste (and edit) the following text to query this object:
SELECT STATUS
, SET_OF_BOOKS_ID
, ACCOUNTING_DATE
, CURRENCY_CODE
, DATE_CREATED
, CREATED_BY
, ACTUAL_FLAG
, USER_JE_CATEGORY_NAME
, USER_JE_SOURCE_NAME
, ENCUMBRANCE_TYPE_ID
, BUDGET_VERSION_ID
, CURRENCY_CONVERSION_DATE
, 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
, 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
, LEDGER_ID
, REFERENCE_DATE
, GL_SL_LINK_ID
, GL_SL_LINK_TABLE
, JGZZ_RECON_REF
FROM GL.GL_INTERFACE_HISTORY;
GL.GL_INTERFACE_HISTORY does not reference any database object
GL.GL_INTERFACE_HISTORY is referenced by following:
|
|
|