Journal Import References

The journal import references view object contains individual transactions from subledgers that have been summarized into Oracle Fusion General Ledger journal entry lines through the Import Journals process.

Data Store Key : FscmTopModelAM.FinExtractAM.GlBiccExtractAM.JournalImportReferenceExtractPVO

Primary Keys : GlImportReferencesGlSlLinkId, GlImportReferencesReference8, GlImportReferencesReference9, GlImportReferencesGlSlLinkTable, GlImportReferencesJeHeaderId, GlImportReferencesJeLineNum, GlImportReferencesReference1, GlImportReferencesReference10, GlImportReferencesReference2, GlImportReferencesReference3, GlImportReferencesReference4, GlImportReferencesReference5, GlImportReferencesReference6, GlImportReferencesReference7

Initial Extract Date : GlImportReferencesCreationDate

Incremental Extract Date : GlImportReferencesLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
GlImportReferencesCreatedBy	The user who submitted the journal import creating the references.
GlImportReferencesCreationDate	The date and time when the journal import reference was submitted.
GlImportReferencesGlSlLinkId	The identifier to link to the associated subledger transaction.
GlImportReferencesGlSlLinkTable	The name of the table containing the associated subledger data.
GlImportReferencesJeBatchId	The unique identifier of the journal batch. This is a foreign key of the Journal Batches view object.
GlImportReferencesJeHeaderId	The unique identifier of the journal. This is a foreign key of the Journals view object.
GlImportReferencesJeLineNum	The unique identifier of the journal Line. This is a foreign key of the Journal Lines view object.
GlImportReferencesLastUpdateDate	The date when the journal import reference row was last updated.
GlImportReferencesLastUpdateLogin	The session login associated with the user who last updated the journal import reference.
GlImportReferencesLastUpdatedBy	The user who last updated the journal import reference.
GlImportReferencesObjectVersionNumber	The number of times the journal import reference row has been updated.
GlImportReferencesReference1	The journal import reference column. It's used by respective subledgers to store specific values related to the source transaction.
GlImportReferencesReference10	The journal import reference column. It's used by respective subledgers to store specific values related to the source transaction.
GlImportReferencesReference2	The journal import reference column. It's used by respective subledgers to store specific values related to the source transaction.
GlImportReferencesReference3	The journal import reference column. It's used by respective subledgers to store specific values related to the source transaction.
GlImportReferencesReference4	The journal import reference column. It's used by respective subledgers to store specific values related to the source transaction.
GlImportReferencesReference5	The journal import reference column. It's used by respective subledgers to store specific values related to the source transaction.
GlImportReferencesReference6	The journal import reference column. It's used by respective subledgers to store specific values related to the source transaction.
GlImportReferencesReference7	The journal import reference column. It's used by respective subledgers to store specific values related to the source transaction.
GlImportReferencesReference8	The journal import reference column. It's used by respective subledgers to store specific values related to the source transaction.
GlImportReferencesReference9	The journal import reference column. It's used by respective subledgers to store specific values related to the source transaction.
GlImportReferencesSubledgerDocSequenceId	The document sequence identifier of the imported journal.
GlImportReferencesSubledgerDocSequenceValue	The document sequence value for the journal to be imported.