GL_XFR_INTERFACE
GL_XFR_INTERFACE is similar to the GL_INTERFACE table and is used as an interface table for balance transfer program.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
Name | Columns |
---|---|
GL_XFR_INTERFACE_PK |
SYSTEM_ID, GROUP_ID, ROW_NUMBER |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
STATUS | VARCHAR2 | 50 | Yes | Status code of the interface record. | |
LEDGER_ID | NUMBER | 15 | Ledger identifier for the journal to be imported. | ||
JE_SOURCE_NAME | VARCHAR2 | 25 | Source code for the imported journal. | ||
JE_CATEGORY_NAME | VARCHAR2 | 25 | Category code for the imported journal. | ||
ACCOUNTING_DATE | DATE | Yes | Effective date of the transaction. | ||
CURRENCY_CODE | VARCHAR2 | 15 | Yes | Currency code for the journal to be imported. | |
DATE_CREATED | DATE | Yes | Who column: indicates the date and time of the creation of the row. | ||
CREATED_BY | NUMBER | 15 | Yes | Who column: indicates the user who created the row. | |
ACTUAL_FLAG | VARCHAR2 | 1 | Yes | Balance type (actual, budget, or encumbrance). | |
USER_JE_CATEGORY_NAME | VARCHAR2 | 25 | Yes | User defined name of the journal entry category. | |
USER_JE_SOURCE_NAME | VARCHAR2 | 25 | Yes | User defined name of the journal entry source. | |
CURRENCY_CONVERSION_DATE | DATE | Currency conversion date of interface record. | |||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Conversion type used on the interface record. | ||
ENCUMBRANCE_TYPE_ID | NUMBER | Encumbrance type identifier. | |||
BUDGET_VERSION_ID | NUMBER | Not currently used. | |||
USER_CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | User currency conversion type code. | ||
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 inentered currency. | |||
ENTERED_CR | NUMBER | Transaction credit amount in entered currency. | |||
ACCOUNTED_DR | NUMBER | Transaction debit amount in base currency. | |||
ACCOUNTED_CR | NUMBER | Transaction credit amount in base currency. | |||
TRANSACTION_DATE | DATE | Date of transaction for the journal to be imported. | |||
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. | ||
INTERFACE_RUN_ID | NUMBER | 18 | Unique identifier for the run of the journal import process. | ||
JE_BATCH_ID | NUMBER | 15 | Journal entry batch defining column. | ||
PERIOD_NAME | VARCHAR2 | 15 | Accounting period for the journal to be imported. | ||
JE_HEADER_ID | NUMBER | 15 | Journal entry header defining column. | ||
JE_LINE_NUM | NUMBER | 15 | Line number of the imported journal. | ||
CHART_OF_ACCOUNTS_ID | NUMBER | 15 | Key flexfield structure defining column. | ||
FUNCTIONAL_CURRENCY_CODE | VARCHAR2 | 15 | Ledger currency code for the journal to be imported. | ||
CODE_COMBINATION_ID | NUMBER | 15 | Key flexfield combination defining column. | ||
DATE_CREATED_IN_GL | DATE | Date when the journal import batch is created. | |||
WARNING_CODE | VARCHAR2 | 4 | Not currently used. | ||
STATUS_DESCRIPTION | VARCHAR2 | 240 | Journal import status description. | ||
STAT_AMOUNT | NUMBER | Statistical amount for the journal to be imported. | |||
GROUP_ID | NUMBER | 15 | Yes | Interface group identifier. | |
REQUEST_ID | NUMBER | 15 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
SUBLEDGER_DOC_SEQUENCE_ID | NUMBER | Identifier that identifies the sequential numbering sequence. | |||
SUBLEDGER_DOC_SEQUENCE_VALUE | NUMBER | Sequential numbering sequence value. | |||
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. | ||
CONTEXT | VARCHAR2 | 150 | Descriptive flexfield context column. | ||
CONTEXT2 | VARCHAR2 | 150 | Descriptive flexfield context column. | ||
INVOICE_DATE | DATE | Value added tax descriptive flexfield column. | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
ATTRIBUTE_CATEGORY2 | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
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. | ||
ATTRIBUTE_CATEGORY3 | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
USSGL_TRANSACTION_CODE | VARCHAR2 | 30 | Not currently used. | ||
DESCR_FLEX_ERROR_MESSAGE | VARCHAR2 | 240 | Descriptive flexfield error message. | ||
JGZZ_RECON_REF | VARCHAR2 | 240 | Global reconciliation reference. | ||
AVERAGE_JOURNAL_FLAG | VARCHAR2 | 1 | Average journal flag for the journal to be imported. | ||
ORIGINATING_BAL_SEG_VALUE | VARCHAR2 | 25 | Originating balancing segment value. | ||
GL_SL_LINK_ID | NUMBER | Link to associated subledger data. | |||
GL_SL_LINK_TABLE | VARCHAR2 | 30 | Table containing associated subledger data. | ||
REFERENCE_DATE | DATE | Reference date for the journal to be imported. | |||
SET_OF_BOOKS_ID | NUMBER | 15 | Ledger identifier for the journal to be imported. | ||
BALANCING_SEGMENT_VALUE | VARCHAR2 | 25 | Balancing segment value for the journal to be imported. | ||
MANAGEMENT_SEGMENT_VALUE | VARCHAR2 | 25 | Management segment value for the journal to be imported. | ||
CODE_COMBINATION_ID_INTERIM | NUMBER | 15 | Column is reserved for Oracle internal use in Journal Import | ||
FUNDS_RESERVED_FLAG | VARCHAR2 | 1 | Reserved for Oracle internal use | ||
CURRENCY_CONV_DATE_INTER | DATE | Column is reserved for Oracle internal use in Journal Import | |||
CURRENCY_CONV_TYPE_INTER | VARCHAR2 | 30 | Column is reserved for Oracle internal use in Journal Import | ||
CURRENCY_CONV_RATE_INTER | NUMBER | 15 | Column is reserved for Oracle internal use in Journal Import | ||
LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row. | ||
LEGAL_ENTITY_ID | NUMBER | 18 | Unique identifier for a legal entity. | ||
LEGAL_ENTITY_IDENTIFIER | VARCHAR2 | 30 | Unique number for a legal entity. | ||
ROW_NUMBER | NUMBER | 15 | Yes | Unique row number to identify the record. | |
SYSTEM_ID | NUMBER | 15 | Yes | Transfer system identifier to identify the record. | |
GL_INTERFACE_ID | NUMBER | 15 | Interface record unique identifier. | ||
CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
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. | ||
PARTITION_GROUP_CODE | VARCHAR2 | 15 | Oracle internal use only. | ||
PERIOD_NAME_INTERIM | VARCHAR2 | 15 | Oracle internal use only. | ||
ACCOUNT_SEGMENT_VALUE | VARCHAR2 | 25 | Natural Account segment value for the journal to be imported. Oracle internal use only. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
GL_XFR_INTERFACE_N1 | Non Unique | Default | USER_JE_SOURCE_NAME, GROUP_ID |
GL_XFR_INTERFACE_N2 | Non Unique | Default | REQUEST_ID, JE_HEADER_ID, STATUS, CODE_COMBINATION_ID |
GL_XFR_INTERFACE_U1 | Unique | Default | SYSTEM_ID, GROUP_ID, ROW_NUMBER |