GL_INTERFACE
GL_INTERFACE contains journal entry batches through Journal Import. You insert rows in this table and then use the Import Journals window to create journal batches. You must supply values for all NOT NULL columns. For a complete description of how to load this table, see the Oracle General Ledger User Guide.
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. Use: NEW. | |
| JOURNAL_ATTACHMENTS | VARCHAR2 | 4000 | Add attachments using URLs to General Ledger journal batches when creating single journals in the ADFdi Create Journal spreadsheet | ||
| GL_INTERFACE_ID | NUMBER | 18 | Interface Identifier. Oracle internal use only. Populated by the journal import program. | ||
| CREATION_DATE | TIMESTAMP | Who column: date and time of the creation of the row. | |||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: date and time of the last update of the row. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: session login associated to the user who last updated the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Used to implement optimistic locking. Incremented every time the row is updated. Compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| LEDGER_ID | NUMBER | 18 | Ledger identifier. Use the Manage Primary Ledgers task to find valid values. | ||
| JE_SOURCE_NAME | VARCHAR2 | 25 | Oracle internal use only. Use column USER_JE_SOURCE_NAME to populate journal source. | ||
| JE_CATEGORY_NAME | VARCHAR2 | 25 | Oracle internal use only. Use column USER_JE_CATEGORY_NAME to populate journal category. | ||
| ACCOUNTING_DATE | DATE | Yes | Effective date of the journal entry. Used to assign the accounting period. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Yes | Entered currency of the transaction. Use the Manage Currencies task to find valid values. Use the three character ISO currency code. Example: US Dollars is USD. | |
| DATE_CREATED | DATE | Yes | Who column: date the row was created. | ||
| CREATED_BY | VARCHAR2 | 64 | Who column: user who created the row. | ||
| ACTUAL_FLAG | VARCHAR2 | 1 | Yes | Balance type of the journal. Use: A. Meaning: Actual. | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: request ID of the job that created or last updated the row. | ||
| ENCUMBRANCE_TYPE_ID | NUMBER | Oracle internal use only. | |||
| BUDGET_VERSION_ID | NUMBER | Oracle internal use only. | |||
| CURRENCY_CONVERSION_DATE | DATE | Date of exchange rate. Date format: YYYY/MM/DD. Required if CURRENCY_CONVERSION_TYPE is not User. | |||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Currency conversion type. Use Manage Currency Conversion Types task to identify valid values. For Fusion ERP in the Cloud, use USER_CURRENCY_CONVERSION_TYPE instead. | ||
| CURRENCY_CONVERSION_RATE | NUMBER | Foreign currency exchange rate. Mandatory if CURRENCY_CONVERSION_TYPE is User. | |||
| SEGMENT1 | VARCHAR2 | 25 | Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts. | ||
| SEGMENT2 | VARCHAR2 | 25 | Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts. | ||
| SEGMENT3 | VARCHAR2 | 25 | Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts. | ||
| SEGMENT4 | VARCHAR2 | 25 | Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts. | ||
| SEGMENT5 | VARCHAR2 | 25 | Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts. | ||
| SEGMENT6 | VARCHAR2 | 25 | Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts. | ||
| SEGMENT7 | VARCHAR2 | 25 | Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts. | ||
| SEGMENT8 | VARCHAR2 | 25 | Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts. | ||
| SEGMENT9 | VARCHAR2 | 25 | Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts. | ||
| SEGMENT10 | VARCHAR2 | 25 | Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts. | ||
| SEGMENT11 | VARCHAR2 | 25 | Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts. | ||
| SEGMENT12 | VARCHAR2 | 25 | Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts. | ||
| SEGMENT13 | VARCHAR2 | 25 | Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts. | ||
| SEGMENT14 | VARCHAR2 | 25 | Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts. | ||
| SEGMENT15 | VARCHAR2 | 25 | Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts. | ||
| SEGMENT16 | VARCHAR2 | 25 | Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts. | ||
| SEGMENT17 | VARCHAR2 | 25 | Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts. | ||
| SEGMENT18 | VARCHAR2 | 25 | Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts. | ||
| SEGMENT19 | VARCHAR2 | 25 | Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts. | ||
| SEGMENT20 | VARCHAR2 | 25 | Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts. | ||
| SEGMENT21 | VARCHAR2 | 25 | Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts. | ||
| SEGMENT22 | VARCHAR2 | 25 | Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts. | ||
| SEGMENT23 | VARCHAR2 | 25 | Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts. | ||
| SEGMENT24 | VARCHAR2 | 25 | Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts. | ||
| SEGMENT25 | VARCHAR2 | 25 | Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts. | ||
| SEGMENT26 | VARCHAR2 | 25 | Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts. | ||
| SEGMENT27 | VARCHAR2 | 25 | Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts. | ||
| SEGMENT28 | VARCHAR2 | 25 | Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts. | ||
| SEGMENT29 | VARCHAR2 | 25 | Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts. | ||
| SEGMENT30 | VARCHAR2 | 25 | Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts. | ||
| ENTERED_DR | NUMBER | Transaction debit amount in the entered currency. | |||
| ENTERED_CR | NUMBER | Transaction credit amount in the entered currency. | |||
| ACCOUNTED_DR | NUMBER | Journal debit amount in the ledger currency. | |||
| ACCOUNTED_CR | NUMBER | Journal credit amount in the ledger currency. | |||
| TRANSACTION_DATE | DATE | Oracle internal use only. Date of transaction. | |||
| REFERENCE1 | VARCHAR2 | 100 | Reference column: batch name. Free text field. Not validated. | ||
| REFERENCE2 | VARCHAR2 | 240 | Reference column: batch description. Free text field. Not validated. | ||
| REFERENCE3 | VARCHAR2 | 100 | Oracle internal use only. | ||
| REFERENCE4 | VARCHAR2 | 100 | Reference column: journal entry name. Free text field. Not validated. | ||
| REFERENCE5 | VARCHAR2 | 240 | Reference column: journal entry description. Free text field. Not validated. | ||
| REFERENCE6 | VARCHAR2 | 100 | Reference column: journal entry reference. Free text field. Not validated. | ||
| REFERENCE7 | VARCHAR2 | 100 | Reference column: journal entry reversal flag. Valid values: Y, N. | ||
| REFERENCE8 | VARCHAR2 | 100 | Reference column: journal entry reversal period. Validation: mandatory if REFERENCE7, journal entry reversal flag, is Y. If average balance processing is enabled, enter effective date for reversal. This will be used to determine the GL period. | ||
| REFERENCE9 | VARCHAR2 | 100 | Reference column: journal reversal method. Valid values: Y, N. Meanings: Y changes sign, N switches debits/credits. | ||
| REFERENCE10 | VARCHAR2 | 240 | Reference column: journal entry line description. Free text field. Not validated. | ||
| REFERENCE11 | VARCHAR2 | 240 | Oracle internal use only. | ||
| REFERENCE12 | VARCHAR2 | 100 | Oracle internal use only. | ||
| REFERENCE13 | VARCHAR2 | 100 | Oracle internal use only. | ||
| REFERENCE14 | VARCHAR2 | 100 | Oracle internal use only. | ||
| REFERENCE15 | VARCHAR2 | 100 | Oracle internal use only. | ||
| REFERENCE16 | VARCHAR2 | 100 | Oracle internal use only. | ||
| REFERENCE17 | VARCHAR2 | 100 | Oracle internal use only. | ||
| REFERENCE18 | VARCHAR2 | 100 | Oracle internal use only. | ||
| REFERENCE19 | VARCHAR2 | 100 | Oracle internal use only. | ||
| REFERENCE20 | VARCHAR2 | 100 | Oracle internal use only. | ||
| REFERENCE21 | VARCHAR2 | 240 | Reference column: journal line. Free text field. Not validated. | ||
| REFERENCE22 | VARCHAR2 | 240 | Reference column: journal line. Free text field. Not validated. | ||
| REFERENCE23 | VARCHAR2 | 240 | Reference column: journal line. Free text field. Not validated. | ||
| REFERENCE24 | VARCHAR2 | 240 | Reference column: journal line. Free text field. Not validated. | ||
| REFERENCE25 | VARCHAR2 | 240 | Reference column: journal line. Free text field. Not validated. | ||
| REFERENCE26 | VARCHAR2 | 240 | Reference column: journal line. Free text field. Not validated. | ||
| REFERENCE27 | VARCHAR2 | 240 | Reference column: journal line. Free text field. Not validated. | ||
| REFERENCE28 | VARCHAR2 | 240 | Reference column: journal line. Free text field. Not validated. | ||
| REFERENCE29 | VARCHAR2 | 240 | Reference column: journal line. Free text field. Not validated. | ||
| REFERENCE30 | VARCHAR2 | 240 | Reference column: journal line. Free text field. Not validated. | ||
| INTERFACE_RUN_ID | NUMBER | 18 | Oracle internal use only. | ||
| JE_BATCH_ID | NUMBER | 18 | Oracle internal use only. | ||
| PERIOD_NAME | VARCHAR2 | 15 | Period name. Use the Manage Accounting Calendars task to identify valid values. | ||
| JE_HEADER_ID | NUMBER | 18 | Oracle internal use only. | ||
| JE_LINE_NUM | NUMBER | 18 | Oracle internal use only. | ||
| CHART_OF_ACCOUNTS_ID | NUMBER | 18 | Oracle internal use only. Chart of accounts identifier. | ||
| FUNCTIONAL_CURRENCY_CODE | VARCHAR2 | 15 | Oracle internal use only. Ledger base currency. | ||
| CODE_COMBINATION_ID | NUMBER | 18 | Use the Manage Account Combinations task, column Account ID, to find valid values. Can be used instead of populating the SEGMENT columns individually. If CODE_COMBINATION_ID and the columns beginning with SEGMENT are populated, the SEGMENT column values take precedence. | ||
| DATE_CREATED_IN_GL | DATE | Oracle internal use only. Date journal import created batch. Populated by the journal import program. | |||
| WARNING_CODE | VARCHAR2 | 4 | Oracle internal use only. | ||
| STATUS_DESCRIPTION | VARCHAR2 | 240 | Oracle internal use only. Journal import status description. Populated by the journal import program. | ||
| STAT_AMOUNT | NUMBER | Statistical amount. | |||
| USER_JE_CATEGORY_NAME | VARCHAR2 | 25 | Yes | Journal entry category. Use the Manage Journal Categories task to find valid values. | |
| USER_JE_SOURCE_NAME | VARCHAR2 | 25 | Yes | Journal entry source user defined name. Use the Manage Journal Sources page to find valid values. | |
| USER_CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Type of exchange rate. Use the Manage Conversion Rate Types task to find valid values. Translated value for CONVERSION_TYPE. Use either CURRENCY_CONVERSION_TYPE or USER_CURRENCY_CONVERSION_TYPE, but not both. | ||
| GROUP_ID | NUMBER | 18 | Groups lines for journals. Use positive integers. Lines with the same GROUP_ID are grouped into the same journal. | ||
| SUBLEDGER_DOC_SEQUENCE_ID | NUMBER | Oracle internal use only. Sequential numbering sequence defining column. Populated by journal import program when journal is sequenced. | |||
| SUBLEDGER_DOC_SEQUENCE_VALUE | NUMBER | Oracle internal use only. Sequential numbering sequence value. Populated by journal import program when journal is sequenced. | |||
| ATTRIBUTE1 | VARCHAR2 | 150 | Segment value for Journals Lines descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Segment value for Journals Lines descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Segment value for Journals Lines descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Segment value for Journals Lines descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Segment value for Journals Lines descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Segment value for Journals Lines descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Segment value for Journals Lines descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Segment value for Journals Lines descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Segment value for Journals Lines descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Segment value for Journals Lines descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Segment value for Journals Captured Information descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Segment value for Journals Captured Information descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Segment value for Journals Captured Information descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Segment value for Journals Captured Information descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Segment value for Journals Captured Information descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Segment value for Journals Captured Information descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Segment value for Journals Captured Information descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Segment value for Journals Captured Information descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Segment value for Journals Captured Information descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Segment value for Journals Captured Information descriptive flexfield. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Context code for Journals Lines descriptive flexfield. Use the Manage General Ledger Descriptive Flexfields task to identify valid values. Use ATTRIBUTE1 to ATTRIBUTE10 for the segment values. | ||
| ATTRIBUTE_CATEGORY2 | VARCHAR2 | 150 | Context code for Journals Captured Information descriptive flexfield. Use the Manage General Ledger Descriptive Flexfields task to identify valid values. Use ATTRIBUTE11 to ATTRIBUTE20 for the segment values. | ||
| INVOICE_DATE | DATE | Oracle internal use only. | |||
| TAX_CODE | VARCHAR2 | 15 | Oracle internal use only. | ||
| INVOICE_IDENTIFIER | VARCHAR2 | 20 | Oracle internal use only. | ||
| INVOICE_AMOUNT | NUMBER | Oracle internal use only. | |||
| ATTRIBUTE_CATEGORY3 | VARCHAR2 | 150 | Oracle internal use only. | ||
| USSGL_TRANSACTION_CODE | VARCHAR2 | 30 | Government transaction code. Oracle internal use only. Only applicable if Oracle Federal Financials is used. | ||
| DESCR_FLEX_ERROR_MESSAGE | VARCHAR2 | 240 | Oracle internal use only. | ||
| JGZZ_RECON_REF | VARCHAR2 | 240 | Oracle internal use only. | ||
| AVERAGE_JOURNAL_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| GL_SL_LINK_ID | NUMBER | Link to associated subledger data. Oracle internal use only. | |||
| GL_SL_LINK_TABLE | VARCHAR2 | 30 | Table containing associated subledger data. Oracle internal use only. | ||
| ORIGINATING_BAL_SEG_VALUE | VARCHAR2 | 25 | Originating balancing segment value for intercompany transaction. Overrides default balancing segment value. Should be a valid value for value set used for intercompany. | ||
| REFERENCE_DATE | DATE | Reference Date for sequencing to meet statutory requirements in Italy. Date format: YYYY/MM/DD. | |||
| SET_OF_BOOKS_ID | NUMBER | 18 | Oracle internal use only. | ||
| BALANCING_SEGMENT_VALUE | VARCHAR2 | 25 | Oracle internal use only. | ||
| MANAGEMENT_SEGMENT_VALUE | VARCHAR2 | 25 | Oracle internal use only. | ||
| FUNDS_RESERVED_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| CODE_COMBINATION_ID_INTERIM | NUMBER | 18 | Oracle internal use only. | ||
| CURRENCY_CONV_DATE_INTER | DATE | Oracle internal use only. | |||
| CURRENCY_CONV_TYPE_INTER | VARCHAR2 | 30 | Oracle internal use only. | ||
| CURRENCY_CONV_RATE_INTER | NUMBER | 18 | Oracle internal use only. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: request ID of the interface load job that created the row. | ||
| 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. | ||
| LEDGER_NAME | VARCHAR2 | 30 | Ledger name for the journal to be imported. Used in file based data import. | ||
| 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_INTERFACE | gl_ledgers | LEDGER_ID |
| GL_INTERFACE | gl_je_batches | JE_BATCH_ID |
| GL_INTERFACE | gl_je_headers | JE_HEADER_ID |
| GL_INTERFACE | gl_je_lines | JE_HEADER_ID, JE_LINE_NUM |
| GL_INTERFACE | gl_code_combinations | CODE_COMBINATION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| GL_INTERFACE_N1 | Non Unique | Default | USER_JE_SOURCE_NAME, LEDGER_ID, SET_OF_BOOKS_ID, GROUP_ID |
| GL_INTERFACE_N2 | Non Unique | Default | REQUEST_ID, JE_HEADER_ID, STATUS, CODE_COMBINATION_ID |
| GL_INTERFACE_N3 | Non Unique | Default | SUBLEDGER_DOC_SEQUENCE_VALUE, SUBLEDGER_DOC_SEQUENCE_ID |
| GL_INTERFACE_N4 | Non Unique | Default | REFERENCE26, REFERENCE22, REFERENCE23 |
| GL_INTERFACE_N5 | Non Unique | Default | GL_INTERFACE_ID |