Journal Source

The journal source view object contains information about the source name assigned to each journal entry in the general ledger during journal header creation.

Data Store Key : FscmTopModelAM.FinExtractAM.GlBiccExtractAM.JournalSourceExtractPVO

Primary Keys : JournalSourceJeSourceName

Initial Extract Date : JournalSourceCreationDate

Incremental Extract Date : JournalSourceLastUpdateDate

Attributes

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

Name Description
JournalSourceAttribute1 A segment for the Journal Sources descriptive flexfield.
JournalSourceAttribute2 A segment for the Journal Sources descriptive flexfield.
JournalSourceAttribute3 A segment for the Journal Sources descriptive flexfield.
JournalSourceAttribute4 A segment for the Journal Sources descriptive flexfield.
JournalSourceAttribute5 A segment for the Journal Sources descriptive flexfield.
JournalSourceAttributeCategory The descriptive flexfield context name for the Journal Sources descriptive flexfield.
JournalSourceCreatedBy The user who created the journal source.
JournalSourceCreationDate The date and time when the journal source was created.
JournalSourceEffDateRuleCode The nonbusiness day rule of the journal source. A list of accepted values is defined in the lookup type GL_JE_SOURCE_ACC_DATE_RULE.
JournalSourceImpUsingKeyFlag Indicates whether the journals can be imported using the journal source key attribute. If enabled, users need to load journals with a journal source key value. A list of accepted values is defined in the lookup type YES_NO.
JournalSourceJeSourceKey The unique identifier of the journal source key.
JournalSourceJeSourceName The unique identifier of the journal source name. This is a primary key to the Journal Source view object.
JournalSourceJournalApprvlFlag Indicates whether journals with this source require approval. A list of accepted values is defined in the lookup type YES_NO.
JournalSourceJournalRefFlag Indicates whether the references can be loaded during import. If enabled, journal import populates the Journal Import view object with reference information from subledger transactions. A list of accepted values is defined in the lookup type YES_NO.
JournalSourceLastUpdateDate The date when the journal source row was last updated.
JournalSourceLastUpdateLogin The session login associated with the user who last updated the journal source.
JournalSourceLastUpdatedBy The user who last updated the journal source.
JournalSourceObjectVersionNum The number of times the journal source row has been updated.
JournalSourceOverrideEditsFlag Indicates whether a journal sources is enabled. Transactions can be created only for enabled journal sources. A list of accepted values is defined in the lookup type YES_NO.
JournalSourceUserLanguage The code representing the user-configured language into which the content of the translatable attributes is translated for the Journal Source.
JournalSourceXlaApprovalFlag Indicates whether the subledger accounting entry approvals should be enabled for the specified Journal Source.
JrnlSrcTransLangCreatedBy The user who created the translated journal source.
JrnlSrcTransLangCreationDate The date and time when the translated journal source was created.
JrnlSrcTransLangDescription The translated description of the journal source provided by the user or source application.
JrnlSrcTransLangJeSourceName The identifier of the translated journal source. This is a foreign key of the Translated Journal Sources view object.
JrnlSrcTransLangLanguage Indicates the code of the language into which the contents of the translatable attributes are translated. This is a foreign key of the Translated Journal Sources view object.
JrnlSrcTransLangLastUpdateDate The date when the translated journal source row was last updated.
JrnlSrcTransLangLastUpdateLog The session login associated with the user who last updated the translated journal source.
JrnlSrcTransLangLastUpdatedBy The user who last updated the translated journal source.
JrnlSrcTransLangSourceLang Indicates the code of the language in which the contents of the translatable attributes were originally created.
JrnlSrcTransLangUserJeSrcName The translated name of the journal source defined by the user.