GL_XFR_PSFT_INTERFACE
GL_XFR_PSFT_INTERFACE is a version of GL_INTERFACE used by the Peoplesoft Transform and Import program. The Peoplesoft Transform and Import program takes raw data from GL_XFR_PSFT_RAW_INT, processes it, and moves any successfully processed data into GL_XFR_PSFT_INTERFACE. It then launches Journal Import.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| STATUS | VARCHAR2 | 50 | Yes | Journal Import status | |
| GL_INTERFACE_ID | NUMBER | 18 | Interface id. Used as a dummy primary key in some cases | ||
| LEDGER_ID | NUMBER | 18 | Ledger defining column | ||
| USER_JE_SOURCE_NAME | VARCHAR2 | 25 | Yes | Journal entry source user defined name | |
| USER_JE_CATEGORY_NAME | VARCHAR2 | 25 | Yes | Journal entry category user defined name | |
| JE_SOURCE_NAME | VARCHAR2 | 25 | Journal entry source defining column | ||
| JE_CATEGORY_NAME | VARCHAR2 | 25 | Journal entry category defining column | ||
| ACCOUNTING_DATE | DATE | Yes | Effective date of the transaction | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Yes | Currency | |
| DATE_CREATED | DATE | Yes | Standard Who column | ||
| ACTUAL_FLAG | VARCHAR2 | 1 | Yes | Balance type (actual, budget, or encumbrance) | |
| BUDGET_VERSION_ID | NUMBER | Budget version defining column | |||
| ENCUMBRANCE_TYPE_ID | NUMBER | Encumbrance type defining column | |||
| CURRENCY_CONVERSION_DATE | DATE | Date of exchange rate | |||
| USER_CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Type of exchange rate | ||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Type of exchange rate | ||
| CURRENCY_CONVERSION_RATE | NUMBER | Foreign currency exchange rate | |||
| 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 | |||
| 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 | Journal import run id | ||
| JE_BATCH_ID | NUMBER | 18 | Journal entry batch defining column | ||
| PERIOD_NAME | VARCHAR2 | 15 | Accounting period | ||
| JE_HEADER_ID | NUMBER | 18 | Journal entry header defining column | ||
| JE_LINE_NUM | NUMBER | 18 | Journal entry line number | ||
| CHART_OF_ACCOUNTS_ID | NUMBER | 18 | Key flexfield structure defining column | ||
| FUNCTIONAL_CURRENCY_CODE | VARCHAR2 | 15 | Ledger base currency | ||
| 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 | |||
| GROUP_ID | NUMBER | 18 | Yes | Interface group defining column | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| 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 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: structure definition of the user descriptive flexfield. | ||
| 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: structure definition of the user descriptive flexfield. | ||
| 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 | ||
| AVERAGE_JOURNAL_FLAG | VARCHAR2 | 1 | Average journal flag | ||
| GL_SL_LINK_ID | NUMBER | Link to associated subledger data | |||
| GL_SL_LINK_TABLE | VARCHAR2 | 30 | Table containing associated subledger data | ||
| ORIGINATING_BAL_SEG_VALUE | VARCHAR2 | 25 | Originating balancing segment value | ||
| REFERENCE_DATE | DATE | Reference date | |||
| SET_OF_BOOKS_ID | NUMBER | 18 | 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 | ||
| CODE_COMBINATION_ID_INTERIM | NUMBER | 18 | Column is reserved for Oracle internal use in Journal Import | ||
| 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 | Column is reserved for Oracle internal use in Journal Import | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | 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. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| GL_XFR_PSFT_INTERFACE | gl_ledgers | LEDGER_ID |
| GL_XFR_PSFT_INTERFACE | gl_code_combinations | CODE_COMBINATION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| GL_XFR_PSFT_INTERFACE_N1 | Non Unique | Default | USER_JE_SOURCE_NAME, LEDGER_ID, SET_OF_BOOKS_ID, GROUP_ID |
| GL_XFR_PSFT_INTERFACE_N2 | Non Unique | Default | REQUEST_ID, JE_HEADER_ID, STATUS, CODE_COMBINATION_ID |