Journal Line

The journal line view object contains information for the journal line. Each row of this object stores the associated journal entry header identifier, line number, and associated account information and related debits or credits. The combination of jeHeaderId and jeLineNum forms the unique identifier of the Journal Line view object.

Data Store Key : FscmTopModelAM.FinExtractAM.GlBiccExtractAM.JournalLineExtractPVO

Primary Keys : JeHeaderId, JeLineNum

Initial Extract Date : GlJeLinesCreationDate

Incremental Extract Date : GlJeLinesLastUpdateDate

Attributes

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

Name Description
GlJeLinesAccountedCr The journal line credit amount in the ledger currency.
GlJeLinesAccountedDr The journal line debit amount in the ledger currency.
GlJeLinesAttribute1 A segment for the Journal Lines descriptive flexfield.
GlJeLinesAttribute10 A segment for the Journal Lines descriptive flexfield.
GlJeLinesAttribute11 A segment for the Journal Lines descriptive flexfield.
GlJeLinesAttribute12 A segment for the Journal Lines descriptive flexfield.
GlJeLinesAttribute13 A segment for the Journal Lines descriptive flexfield.
GlJeLinesAttribute14 A segment for the Journal Lines descriptive flexfield.
GlJeLinesAttribute15 A segment for the Journal Lines descriptive flexfield.
GlJeLinesAttribute16 A segment for the Journal Lines descriptive flexfield.
GlJeLinesAttribute17 A segment for the Journal Lines descriptive flexfield.
GlJeLinesAttribute18 A segment for the Journal Lines descriptive flexfield.
GlJeLinesAttribute19 A segment for the Journal Lines descriptive flexfield.
GlJeLinesAttribute2 A segment for the Journal Lines descriptive flexfield.
GlJeLinesAttribute20 A segment for the Journal Lines descriptive flexfield.
GlJeLinesAttribute3 A segment for the Journal Lines descriptive flexfield.
GlJeLinesAttribute4 A segment for the Journal Lines descriptive flexfield.
GlJeLinesAttribute5 A segment for the Journal Lines descriptive flexfield.
GlJeLinesAttribute6 A segment for the Journal Lines descriptive flexfield.
GlJeLinesAttribute7 A segment for the Journal Lines descriptive flexfield.
GlJeLinesAttribute8 A segment for the Journal Lines descriptive flexfield.
GlJeLinesAttribute9 A segment for the Journal Lines descriptive flexfield.
GlJeLinesAttributeCategory The descriptive flexfield context name for the Journal Lines descriptive flexfield.
GlJeLinesAttributeCategory3
GlJeLinesCodeCombinationId The unique identifier of the account combination. This is a foreign key of the Code Combination view object.
GlJeLinesCreatedBy The user who created the journal line.
GlJeLinesCreationDate The date and time when the journal line was created.
GlJeLinesCurrencyCode The currency in which the journal line is entered. This is a foreign key of the Currencies view object.
GlJeLinesCurrencyConversionDate The date when the currency on the journal was converted.
GlJeLinesCurrencyConversionRate The currency conversion rate for a journal entry where the entered currency isn't the same as the ledger currency.
GlJeLinesCurrencyConversionType The currency conversion rate type of the journal. This is a foreign key to the Daily Conversion Type view object.
GlJeLinesDescription The description of the journal line provided by the user or source application.
GlJeLinesEffectiveDate The accounting date of the journal line.
GlJeLinesEnteredCr The journal line credit amount in the entered currency.
GlJeLinesEnteredDr The journal line debit amount in the entered currency.
GlJeLinesGlSlLinkId The identifier to link to the associated subledger transaction.
GlJeLinesGlSlLinkTable The name of the table containing the associated subledger data.
GlJeLinesGlobalAttribute1 A segment for the General Ledger Journal Line Regional Information global descriptive flexfield.
GlJeLinesGlobalAttribute10 A segment for the General Ledger Journal Line Regional Information global descriptive flexfield.
GlJeLinesGlobalAttribute11 A segment for the General Ledger Journal Line Regional Information global descriptive flexfield.
GlJeLinesGlobalAttribute12 A segment for the General Ledger Journal Line Regional Information global descriptive flexfield.
GlJeLinesGlobalAttribute13 A segment for the General Ledger Journal Line Regional Information global descriptive flexfield.
GlJeLinesGlobalAttribute14 A segment for the General Ledger Journal Line Regional Information global descriptive flexfield.
GlJeLinesGlobalAttribute15 A segment for the General Ledger Journal Line Regional Information global descriptive flexfield.
GlJeLinesGlobalAttribute16 A segment for the General Ledger Journal Line Regional Information global descriptive flexfield.
GlJeLinesGlobalAttribute17 A segment for the General Ledger Journal Line Regional Information global descriptive flexfield.
GlJeLinesGlobalAttribute18 A segment for the General Ledger Journal Line Regional Information global descriptive flexfield.
GlJeLinesGlobalAttribute19 A segment for the General Ledger Journal Line Regional Information global descriptive flexfield.
GlJeLinesGlobalAttribute2 A segment for the General Ledger Journal Line Regional Information global descriptive flexfield.
GlJeLinesGlobalAttribute20 A segment for the General Ledger Journal Line Regional Information global descriptive flexfield.
GlJeLinesGlobalAttribute3 A segment for the General Ledger Journal Line Regional Information global descriptive flexfield.
GlJeLinesGlobalAttribute4 A segment for the General Ledger Journal Line Regional Information global descriptive flexfield.
GlJeLinesGlobalAttribute5 A segment for the General Ledger Journal Line Regional Information global descriptive flexfield.
GlJeLinesGlobalAttribute6 A segment for the General Ledger Journal Line Regional Information global descriptive flexfield.
GlJeLinesGlobalAttribute7 A segment for the General Ledger Journal Line Regional Information global descriptive flexfield.
GlJeLinesGlobalAttribute8 A segment for the General Ledger Journal Line Regional Information global descriptive flexfield.
GlJeLinesGlobalAttribute9 A segment for the General Ledger Journal Line Regional Information global descriptive flexfield.
GlJeLinesGlobalAttributeCategory The descriptive flexfield context name for the General Ledger Journal Line Regional Information global descriptive flexfield.
GlJeLinesGlobalAttributeDate1 A segment for the General Ledger Journal Line Regional Information global descriptive flexfield.
GlJeLinesGlobalAttributeDate2 A segment for the General Ledger Journal Line Regional Information global descriptive flexfield.
GlJeLinesGlobalAttributeDate3 A segment for the General Ledger Journal Line Regional Information global descriptive flexfield.
GlJeLinesGlobalAttributeDate4 A segment for the General Ledger Journal Line Regional Information global descriptive flexfield.
GlJeLinesGlobalAttributeDate5 A segment for the General Ledger Journal Line Regional Information global descriptive flexfield.
GlJeLinesGlobalAttributeNumber1 A segment for the General Ledger Journal Line Regional Information global descriptive flexfield.
GlJeLinesGlobalAttributeNumber2 A segment for the General Ledger Journal Line Regional Information global descriptive flexfield.
GlJeLinesGlobalAttributeNumber3 A segment for the General Ledger Journal Line Regional Information global descriptive flexfield.
GlJeLinesGlobalAttributeNumber4 A segment for the General Ledger Journal Line Regional Information global descriptive flexfield.
GlJeLinesGlobalAttributeNumber5 A segment for the General Ledger Journal Line Regional Information global descriptive flexfield.
GlJeLinesIgnoreRateFlag Indicates whether accounted amounts are recalculated when the currency conversion rate changes. Valid values are Null, Y, or N.
GlJeLinesLastUpdateDate The date when the journal line row was last updated.
GlJeLinesLastUpdateLogin The session login associated with the user who last updated the journal line.
GlJeLinesLastUpdatedBy The user who last updated the journal line row.
GlJeLinesLedgerId The unique identifier of the ledger of the journal line. This is a foreign key of the Ledger view object.
GlJeLinesLineTypeCode Identifies the type of line such as suspense, rounding, intercompany. Valid values are Null, INTRA, INTER, ENTERED_CURR_BALANCE, SUSPENSE, ROUNDING, or GAIN_LOSS.
GlJeLinesObjectVersionNumber The number of times the journal entry line row has been updated.
GlJeLinesPeriodName The accounting period associated with the journal. This is a foreign key of the Period view object.
GlJeLinesReference1 The batch name the user entered while submitting the Post Subledger Journal Entries process.
GlJeLinesReference10 The batch name the user entered while submitting the Post Subledger Journal Entries process.
GlJeLinesReference2 The batch name the user entered while submitting the Post Subledger Journal Entries process.
GlJeLinesReference3 The batch name the user entered while submitting the Post Subledger Journal Entries process.
GlJeLinesReference4 The batch name the user entered while submitting the Post Subledger Journal Entries process.
GlJeLinesReference5 The batch name the user entered while submitting the Post Subledger Journal Entries process.
GlJeLinesReference6 The batch name the user entered while submitting the Post Subledger Journal Entries process.
GlJeLinesReference7 The batch name the user entered while submitting the Post Subledger Journal Entries process.
GlJeLinesReference8 The batch name the user entered while submitting the Post Subledger Journal Entries process.
GlJeLinesReference9 The batch name the user entered while submitting the Post Subledger Journal Entries process.
GlJeLinesStatAmount The amount entered in a journal that's based on the unit of measure.
GlJeLinesStatus The posting status for the journal. A list of accepted values is defined in the lookup type MJE_BATCH_STATUS.
GlJeLinesSubledgerDocSequenceId The document sequence used to uniquely number documents.
GlJeLinesSubledgerDocSequenceValue The document sequence value generated by the subledger.
JeHeaderId The unique identifier of the journal entry header. This attribute is a part of the composite key of the Journal Line view object.
JeLineNum The identifier of a line in a journal for a particular header. This attribute is a part of the composite key of the Journal Line view object.