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. |