GL_INTERFACE_HISTORY
GL_INTERFACE_HISTORY contains the rows that are successfully imported from the GL_INTERFACE table through Journal Import. You use this information for historical reference only. Your Oracle Fusion 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.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| STATUS | VARCHAR2 | 50 | Yes | Journal import status code of the interface history record. | |
| JOURNAL_ATTACHMENTS | VARCHAR2 | 4000 | Add attachments using URLs to General Ledger journal batches when creating single journals in the ADFdi Create Journal spreadsheet | ||
| SET_OF_BOOKS_ID | NUMBER | 18 | Ledger identifier of the imported journal. | ||
| JE_SOURCE_NAME | VARCHAR2 | 25 | This column is used for internal processing only | ||
| JE_CATEGORY_NAME | VARCHAR2 | 25 | This column is used for internal processing only | ||
| ACCOUNTING_DATE | DATE | Yes | Effective date of the transaction. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Yes | Currency code of the imported journal. | |
| DATE_CREATED | DATE | Yes | Who column: indicates the date and time of the creation of the row. | ||
| ACTUAL_FLAG | VARCHAR2 | 1 | Yes | Balance type (actual, budget, or encumbrance). | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| ENCUMBRANCE_TYPE_ID | NUMBER | Encumbrance type identifier. | |||
| BUDGET_VERSION_ID | NUMBER | Not currently used. | |||
| CURRENCY_CONVERSION_DATE | DATE | Currency conversion date of interface record. | |||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 10 | This column is used for internal processing only | ||
| CURRENCY_CONVERSION_RATE | NUMBER | Currency conversion rate of interface record. | |||
| SEGMENT1 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT2 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT3 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT4 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT5 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT6 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT7 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT8 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT9 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT10 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT11 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT12 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT13 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT14 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT15 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT16 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT17 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT18 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT19 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT20 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT21 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT22 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT23 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT24 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT25 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT26 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT27 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT28 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT29 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT30 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| 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 of the imported journal. | |||
| 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. | ||
| INTERFACE_RUN_ID | NUMBER | 18 | This column is used for internal processing only | ||
| JE_BATCH_ID | NUMBER | 18 | Journal entry batch defining column. | ||
| PERIOD_NAME | VARCHAR2 | 15 | Accounting period of the imported journal. | ||
| JE_HEADER_ID | NUMBER | 18 | Journal entry header defining column. | ||
| JE_LINE_NUM | NUMBER | 18 | Line number of the imported journal. | ||
| CHART_OF_ACCOUNTS_ID | NUMBER | 18 | Key flexfield structure defining column. | ||
| FUNCTIONAL_CURRENCY_CODE | VARCHAR2 | 15 | Ledger currency code of the imported journal. | ||
| CODE_COMBINATION_ID | NUMBER | 18 | 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 of the imported journal. | |||
| 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. | |
| USER_CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | User currency conversion type code. | ||
| GROUP_ID | NUMBER | 18 | Interface group identifier. | ||
| SUBLEDGER_DOC_SEQUENCE_ID | NUMBER | Document sequence identifier of the imported journal. | |||
| SUBLEDGER_DOC_SEQUENCE_VALUE | NUMBER | Document sequence value of the imported journal. | |||
| 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. | |||
| ATTRIBUTE_CATEGORY3 | VARCHAR2 | 150 | Descriptive flexfield context column. | ||
| USSGL_TRANSACTION_CODE | VARCHAR2 | 30 | Not currently used. | ||
| DESCR_FLEX_ERROR_MESSAGE | VARCHAR2 | 240 | Descriptive flexfield error message. | ||
| AVERAGE_JOURNAL_FLAG | VARCHAR2 | 1 | Average journal flag of the imported journal. | ||
| ORIGINATING_BAL_SEG_VALUE | VARCHAR2 | 25 | Originating balancing segment value. | ||
| LEDGER_ID | NUMBER | 18 | Ledger identifier of the imported journal. | ||
| REFERENCE_DATE | DATE | Reference date of the imported journal. | |||
| 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. | ||
| LEGAL_ENTITY_ID | NUMBER | 18 | Legal Entity Identifier. Foreign key to XLE_ENTITY_PROFILES | ||
| LEGAL_ENTITY_IDENTIFIER | VARCHAR2 | 30 | Unique number used to identify a legal entity. Foreign key to XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER. | ||
| 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. | |||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Global Descriptive Flexfield: structure definition 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. | |||
| 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_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_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. | ||
| ACCOUNT_SEGMENT_VALUE | VARCHAR2 | 25 | Natural Account segment value for the journal to be imported. Oracle internal use only. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| GL_INTERFACE_HISTORY | gl_je_batches | JE_BATCH_ID |
| GL_INTERFACE_HISTORY | gl_je_headers | JE_HEADER_ID |
| GL_INTERFACE_HISTORY | gl_code_combinations | CODE_COMBINATION_ID |
| GL_INTERFACE_HISTORY | gl_je_lines | JE_HEADER_ID, JE_LINE_NUM |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| GL_INTERFACE_HISTORY_N1 | Non Unique | Default | USER_JE_SOURCE_NAME, SET_OF_BOOKS_ID, GROUP_ID |
| GL_INTERFACE_HISTORY_N2 | Non Unique | Default | REQUEST_ID, STATUS, JE_HEADER_ID |
| GL_INTERFACE_HISTORY_N3 | Non Unique | Default | SUBLEDGER_DOC_SEQUENCE_VALUE, SUBLEDGER_DOC_SEQUENCE_ID |