Journals
The journals view object consolidates common information for the journal header, such as batch name and description, ledger identifier, accounting period, journal source, and so on.
Data Store Key : FscmTopModelAM.FinExtractAM.GlBiccExtractAM.JournalHeaderExtractPVO
Primary Keys : JeHeaderId
Initial Extract Date : GlJeHeadersCreationDate
Incremental Extract Date : GlJeHeadersLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| CloseAcctSeqVersionsHeaderName | The name of the reporting sequence assigned to a ledger. |
| CloseAcctSeqVersionsSeqVersionId | The unique identifier of the reporting sequence version associated with the journal. This is a primary key of the CloseAcctSeqVersions entity object. |
| CloseAcctSeqVersionsVersionName | The name of the reporting sequence version associated with the journal. |
| GlJeBatchesDescription | The description of the journal batch provided by the user or source application. |
| GlJeBatchesJeBatchId | The unique identifier of the journal batch. This is a primary key of the GlJeBatches entity object. |
| GlJeBatchesName | The name of the journal batch. |
| GlJeHeadersAccrualRevChangeSignFlag | The type of journal reversal. A list of accepted values is defined in the lookup type YES_NO. The value is passed as a parameter to attribute GlJeHeadersAccrualRevChangeSignFlagTransient. |
| GlJeHeadersAccrualRevChangeSignFlagTransient | The type of journal reversal. A list of accepted values is defined in the lookup type REVERSAL_OPTION_CODE. |
| GlJeHeadersAccrualRevEffectiveDate | The accounting date of the journal created from a reversal. |
| GlJeHeadersAccrualRevFlag | Indicates whether the journal is an average balances journal. A list of accepted values is defined in the lookup type YES_NO. |
| GlJeHeadersAccrualRevJeHeaderId | The unique identifier of the journal created from a reversal. |
| GlJeHeadersAccrualRevPeriodName | The accounting period of the journal created from a reversal. This is a foreign key to the Fiscal Period view object. |
| GlJeHeadersAccrualRevStatus | The indicator for whether the journal has been reversed. A list of accepted values is defined in the lookup type JE_REVERSAL_STATUS. |
| GlJeHeadersActualFlag | The balance type that helps identify whether the journal is an actual or encumbrance journal. A list of accepted values is defined in the lookup type BATCH_TYPE. |
| GlJeHeadersAttribute1 | A segment for the General Ledger Journal descriptive flexfield. |
| GlJeHeadersAttribute10 | A segment for the General Ledger Journal descriptive flexfield. |
| GlJeHeadersAttribute2 | A segment for the General Ledger Journal descriptive flexfield. |
| GlJeHeadersAttribute3 | A segment for the General Ledger Journal descriptive flexfield. |
| GlJeHeadersAttribute4 | A segment for the General Ledger Journal descriptive flexfield. |
| GlJeHeadersAttribute5 | A segment for the General Ledger Journal descriptive flexfield. |
| GlJeHeadersAttribute6 | A segment for the General Ledger Journal descriptive flexfield. |
| GlJeHeadersAttribute7 | A segment for the General Ledger Journal descriptive flexfield. |
| GlJeHeadersAttribute8 | A segment for the General Ledger Journal descriptive flexfield. |
| GlJeHeadersAttribute9 | A segment for the General Ledger Journal descriptive flexfield. |
| GlJeHeadersAttributeCategory | The context name for the Journals descriptive flexfield. |
| GlJeHeadersAttributeCategory2 | The context name for the Journals descriptive flexfield. |
| GlJeHeadersAttributeDate1 | A date segment for the General Ledger Journal descriptive flexfield. |
| GlJeHeadersAttributeDate2 | A date segment for the General Ledger Journal descriptive flexfield. |
| GlJeHeadersAttributeDate3 | A date segment for the General Ledger Journal descriptive flexfield. |
| GlJeHeadersAttributeDate4 | A date segment for the General Ledger Journal descriptive flexfield. |
| GlJeHeadersAttributeDate5 | A date segment for the General Ledger Journal descriptive flexfield. |
| GlJeHeadersAttributeNumber1 | A number segment for the General Ledger Journal descriptive flexfield. |
| GlJeHeadersAttributeNumber2 | A number segment for the General Ledger Journal descriptive flexfield. |
| GlJeHeadersAttributeNumber3 | A number segment for the General Ledger Journal descriptive flexfield. |
| GlJeHeadersAttributeNumber4 | A number segment for the General Ledger Journal descriptive flexfield. |
| GlJeHeadersAttributeNumber5 | A number segment for the General Ledger Journal descriptive flexfield. |
| GlJeHeadersBalancedJeFlag | Indicates whether the journal is balanced. A list of accepted values is defined in the lookup type YES_NO. |
| GlJeHeadersCloseAcctSeqAssignId | The identifier of the sequence assignment used when closing a period. |
| GlJeHeadersCloseAcctSeqValue | A sequence value assigned during the period close. |
| GlJeHeadersCloseAcctSeqVersionId | The identifier of the sequence version used during the period close. This is a foreign key to the CloseAcctSeqVersions entity object. |
| GlJeHeadersControlTotal | The control amount of the journal. |
| GlJeHeadersCreatedBy | The user who created the journal. |
| GlJeHeadersCreationDate | The date and time when the journal was created. |
| GlJeHeadersCurrencyCode | The currency of the journal entry header. This is a foreign key to the Currencies view object. |
| GlJeHeadersCurrencyConversionDate | The date when the currency on the journal was converted. |
| GlJeHeadersCurrencyConversionRate | The currency conversion rate for a journal entry where the entered currency isn't the same as the ledger currency. |
| GlJeHeadersCurrencyConversionType | The currency conversion rate type of the journal. This is a foreign key to the Daily Conversion Type view object. |
| GlJeHeadersDateCreated | The date and time when the journal header was created. |
| GlJeHeadersDefaultEffectiveDate | The accounting date of the journal. |
| GlJeHeadersDescription | The description of the journal header provided by the user or source application. |
| GlJeHeadersDisplayAlcJournalFlag | Indicates whether the journal is posted in the reporting currency. A list of accepted values is defined in the lookup type YES_NO. |
| GlJeHeadersEncumbranceTypeId | The unique identifier of the journal encumbrance type. This is a foreign key to the Journal Encumbrance Type entity object. |
| GlJeHeadersExternalReference | The external reference provided for the journal. |
| GlJeHeadersGlobalAttribute1 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlJeHeadersGlobalAttribute10 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlJeHeadersGlobalAttribute11 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlJeHeadersGlobalAttribute12 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlJeHeadersGlobalAttribute13 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlJeHeadersGlobalAttribute14 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlJeHeadersGlobalAttribute15 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlJeHeadersGlobalAttribute16 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlJeHeadersGlobalAttribute17 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlJeHeadersGlobalAttribute18 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlJeHeadersGlobalAttribute19 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlJeHeadersGlobalAttribute2 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlJeHeadersGlobalAttribute20 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlJeHeadersGlobalAttribute3 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlJeHeadersGlobalAttribute4 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlJeHeadersGlobalAttribute5 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlJeHeadersGlobalAttribute6 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlJeHeadersGlobalAttribute7 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlJeHeadersGlobalAttribute8 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlJeHeadersGlobalAttribute9 | A segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlJeHeadersGlobalAttributeCategory | The context name for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlJeHeadersGlobalAttributeDate1 | A date segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlJeHeadersGlobalAttributeDate2 | A date segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlJeHeadersGlobalAttributeDate3 | A date segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlJeHeadersGlobalAttributeDate4 | A date segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlJeHeadersGlobalAttributeDate5 | A date segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlJeHeadersGlobalAttributeNumber1 | A number segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlJeHeadersGlobalAttributeNumber2 | A number segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlJeHeadersGlobalAttributeNumber3 | A number segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlJeHeadersGlobalAttributeNumber4 | A number segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlJeHeadersGlobalAttributeNumber5 | A number segment for the General Ledger Journal Regional Information global descriptive flexfield. |
| GlJeHeadersIntercompanyMode | Indicates the intercompany mode of the journal. Valid values are 1 through 4. |
| GlJeHeadersJeBatchId | The unique identifier of the journal batch. This is a foreign key to the Journal Batch view object. |
| GlJeHeadersJeCategory | The category of the journal. This is a foreign key to the Journal Category view object. |
| GlJeHeadersJeFromSlaFlag | Indicates whether the journal originated from the subledger accounting process instead of being directly created in General Ledger. A list of accepted values is defined in the lookup type YES_NO. |
| GlJeHeadersJeSource | The source of the journal. This is a foreign key to the Journal Source view object. |
| GlJeHeadersLastUpdateDate | The date when the journal row was last updated. |
| GlJeHeadersLastUpdateLogin | The session login associated with the user who last updated the journal. |
| GlJeHeadersLastUpdatedBy | The user who last updated the journal row. |
| GlJeHeadersLedgerId | The unique identifier of the ledger of the journal entry header. This is a foreign key to the Ledger view object. |
| GlJeHeadersLegalEntityId | The unique identifier of the legal entity associated with the journal. This is a foreign key to the Entity Profile view object. |
| GlJeHeadersMultiBalSegFlag | Indicates whether multiple balancing segments apply to the journal. A list of accepted values is defined in the lookup type YES_NO. |
| GlJeHeadersMultiCurrencyFlag | Indicates whether the journal is multicurrency. A list of accepted values is defined in the lookup type YES_NO. The default value is N. |
| GlJeHeadersName | The name of the journal header provided by the user or source application. |
| GlJeHeadersObjectVersionNumber | The number of times the journal row has been updated. |
| GlJeHeadersOriginatingBalSegValue | A balancing segment value used in a journal to balance many-to-many intercompany journals. |
| GlJeHeadersParentJeHeaderId | The unique identifier of the parent journal entry in the source primary ledger. |
| GlJeHeadersPeriodName | The accounting period associated with the journal. This is a foreign key of the Period view object. |
| GlJeHeadersPostCurrencyCode | The currency used for posting multicurrency journals. |
| GlJeHeadersPostMultiCurrencyFlag | Indicates whether the posted journal is multicurrency. A list of accepted values is defined in the lookup type YES_NO. |
| GlJeHeadersPostedDate | The date when the journal was posted. |
| GlJeHeadersPostedDateTime | The date and time when the journal was posted. |
| GlJeHeadersPostingAcctSeqAssignId | The identifier of the sequence assignment used when posting the journal. |
| GlJeHeadersPostingAcctSeqValue | The sequence value assigned when posting. |
| GlJeHeadersPostingAcctSeqVersionId | The identifier of the sequence version used when posting. This is a foreign key to the PostAcctSeqVersions entity object. |
| GlJeHeadersReferenceDate | An additional date entered by the user or source application. |
| GlJeHeadersReversedJeHeaderId | The unique identifier of the reversed journal header. This is a foreign key to the ReversedJournalHeader entity object. |
| GlJeHeadersRunningTotalAccountedCr | The running total credits of a journal entry in the ledger currency. |
| GlJeHeadersRunningTotalAccountedDr | The running total debits of a journal entry in the ledger currency. |
| GlJeHeadersRunningTotalCr | The running total credits of a journal entry in the entered currency. |
| GlJeHeadersRunningTotalDr | The running total debits of a journal entry in the entered currency. |
| GlJeHeadersStatus | The posting status for the journal. A list of accepted values is defined in the lookup type MJE_BATCH_STATUS. |
| JeHeaderId | The unique identifier of the journal entry header. This is a primary key of the Journal Entry Header view object. |
| JournalEncumbranceTLDescription | The description of the encumbrance provided by the user or source application. |
| JournalEncumbranceTLEncumbranceType | The alternate unique identifier of the journal encumbrance type. This is an alternate primary key of the Journal Encumbrance Type entity object. |
| JournalEncumbranceTLEncumbranceTypeId | The unique identifier of the journal encumbrance type. This is a primary key of the Journal Encumbrance Type entity object. |
| JournalEncumbranceTLLanguage | The code for the language into which the contents of translatable columns are translated. |
| PostAcctSeqVersionsHeaderName | The name of the accounting sequence assigned to a ledger. |
| PostAcctSeqVersionsSeqVersionId | The unique identifier of the reporting sequence version associated with the journal. This is a primary key of the PostAcctSeqVersions entity object. |
| PostAcctSeqVersionsVersionName | The version name of the accounting sequence. |
| ReversalJournalHeaderJeHeaderId | The unique identifier of the reversed journal header. This is a primary key of the ReversalJournalHeader entity object. |
| ReversalJournalHeaderName | The name of the reversed journal. |