GL_IMPORT_REFERENCES
GL_IMPORT_REFERENCES contains individual transactions from subledgers that have been summarized into Oracle General Ledger journal entry lines through the Journal Import process. You can specify the journal entry sources for which you want to maintain your transaction's origin by entering 'Yes' in the Import Journal References field of the Journal Sources definition. For each source that has Import Journal References set to 'Yes', Oracle General Ledger will populate GL_IMPORT_REFERENCES with one record for each transaction in your feeder system.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| JE_BATCH_ID | NUMBER | 18 | Yes | Journal entry batch identifier. | |
| JE_HEADER_ID | NUMBER | 18 | Yes | Journal entry header identifier. | |
| JE_LINE_NUM | NUMBER | 18 | Yes | Line number of the imported journal. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| REFERENCE_1 | VARCHAR2 | 240 | Journal import reference column. | ||
| REFERENCE_2 | VARCHAR2 | 240 | Journal import reference column. | ||
| REFERENCE_3 | VARCHAR2 | 240 | Journal import reference column. | ||
| REFERENCE_4 | VARCHAR2 | 240 | Journal import reference column. | ||
| REFERENCE_5 | VARCHAR2 | 240 | Journal import reference column. | ||
| REFERENCE_6 | VARCHAR2 | 240 | Journal import reference column. | ||
| REFERENCE_7 | VARCHAR2 | 240 | Journal import reference column. | ||
| REFERENCE_8 | VARCHAR2 | 240 | Journal import reference column. | ||
| REFERENCE_9 | VARCHAR2 | 240 | Journal import reference column. | ||
| REFERENCE_10 | VARCHAR2 | 240 | Journal import reference column. | ||
| SUBLEDGER_DOC_SEQUENCE_ID | NUMBER | Document sequence identifier for the journal to be imported. | |||
| SUBLEDGER_DOC_SEQUENCE_VALUE | NUMBER | Document sequence value for the journal to be imported. | |||
| GL_SL_LINK_ID | NUMBER | 18 | Link to associated subledger data. | ||
| GL_SL_LINK_TABLE | VARCHAR2 | 30 | Table containing associated subledger data. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | 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. | |
| PARTITION_GROUP_CODE | VARCHAR2 | 15 | Partition grouping information which when combined with the period, determines the database partition in which this journal reference information will be stored. | ||
| PERIOD_NAME | VARCHAR2 | 15 | Accounting period for the reference information. | ||
| IMPORT_REFERENCE_ID | NUMBER | 18 | Journal import reference identifier. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| GL_IMPORT_REFERENCES | gl_je_batches | JE_BATCH_ID |
| GL_IMPORT_REFERENCES | gl_je_headers | JE_HEADER_ID |
| GL_IMPORT_REFERENCES | gl_je_lines | JE_HEADER_ID, JE_LINE_NUM |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| GL_IMPORT_REFERENCES_N1 | Non Unique | Default | JE_HEADER_ID, JE_LINE_NUM |
| GL_IMPORT_REFERENCES_N2 | Non Unique | Default | SUBLEDGER_DOC_SEQUENCE_VALUE, SUBLEDGER_DOC_SEQUENCE_ID |
| GL_IMPORT_REFERENCES_N3 | Non Unique | Default | REFERENCE_6, REFERENCE_2, REFERENCE_3 |
| GL_IMPORT_REFERENCES_N4 | Non Unique | Default | GL_SL_LINK_ID, GL_SL_LINK_TABLE |
| GL_IMPORT_REFERENCES_U1 | Unique | Default | IMPORT_REFERENCE_ID |