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