Subledger Journal Entry Lines
The subledger journal entry line view object contains information for the subledger journal entry lines. Each row of this object stores the associated subledger journal entry header identifier, line number, and associated account information and related debits or credits. The combination of JournalEntryLineApplicationId, JournalEntryLineAeHeaderId, and JournalEntryLineAeLineNum forms the unique identifier of the Subledger Journal Entry Lines view object.
Data Store Key : FscmTopModelAM.FinExtractAM.XlaBiccExtractAM.SubledgerJournalLineExtractPVO
Primary Keys : JournalEntryLineAeHeaderId, JournalEntryLineAeLineNum, JournalEntryLineApplicationId
Initial Extract Date : JournalEntryLineCreationDate
Incremental Extract Date : JournalEntryLineLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| JournalEntryLineAccountedCr | The subledger journal line credit amount in the accounting currency. |
| JournalEntryLineAccountedDr | The subledger journal line debit amount in the accounting currency. |
| JournalEntryLineAccountingClassCode | The short name of a lookup type that's shared across applications to classify journal entry lines. A list of accepted values is defined in the lookup type XLA_ACCOUNTING_CLASS. |
| JournalEntryLineAccountingDate | The date that's referenced from General Ledger and used to determine the accounting period for transactions. |
| JournalEntryLineAeHeaderId | The identifier of the subledger journal entry. This attribute is a part of the composite key of the Subledger Journal Entry Lines view object. This is a foreign key of the Subledger Journal Entry Headers view object. |
| JournalEntryLineAeLineNum | The number associated with each subledger journal entry line.This attribute is a part of the composite key of the Subledger Journal Entry Lines view object. |
| JournalEntryLineAnalyticalBalanceFlag | Indicates the balance of the supporting reference. It has three values: NULL, P, and Y. NULL indicates not eligible for balance calculation, P indicates balance calculation is pending, and Y indicates balance calculation is complete. |
| JournalEntryLineAnchorLineFlag | Indicates anchor line for PeopleSoft integration. A list of accepted values is defined in the lookup type YES_NO. |
| JournalEntryLineApplicationId | The unique identifier of the source application. This is a primary key of the Application view object. This attribute is a part of the composite key of the Subledger Journal Entry Lines view object. |
| JournalEntryLineAttribute1 | A segment for the Subledger Journal Entry Lines descriptive flexfield. |
| JournalEntryLineAttribute10 | A segment for the Subledger Journal Entry Lines descriptive flexfield. |
| JournalEntryLineAttribute11 | A segment for the Subledger Journal Entry Lines descriptive flexfield. |
| JournalEntryLineAttribute12 | A segment for the Subledger Journal Entry Lines descriptive flexfield. |
| JournalEntryLineAttribute13 | A segment for the Subledger Journal Entry Lines descriptive flexfield. |
| JournalEntryLineAttribute14 | A segment for the Subledger Journal Entry Lines descriptive flexfield. |
| JournalEntryLineAttribute15 | A segment for the Subledger Journal Entry Lines descriptive flexfield. |
| JournalEntryLineAttribute2 | A segment for the Subledger Journal Entry Lines descriptive flexfield. |
| JournalEntryLineAttribute3 | A segment for the Subledger Journal Entry Lines descriptive flexfield. |
| JournalEntryLineAttribute4 | A segment for the Subledger Journal Entry Lines descriptive flexfield. |
| JournalEntryLineAttribute5 | A segment for the Subledger Journal Entry Lines descriptive flexfield. |
| JournalEntryLineAttribute6 | A segment for the Subledger Journal Entry Lines descriptive flexfield. |
| JournalEntryLineAttribute7 | A segment for the Subledger Journal Entry Lines descriptive flexfield. |
| JournalEntryLineAttribute8 | A segment for the Subledger Journal Entry Lines descriptive flexfield. |
| JournalEntryLineAttribute9 | A segment for the Subledger Journal Entry Lines descriptive flexfield. |
| JournalEntryLineAttributeCategory | The descriptive flexfield context name for the Subledger Journal Entry Lines descriptive flexfield. |
| JournalEntryLineBusinessClassCode | Indicates the classification assigned to a business class that's used for reporting or in reference to an option. A list of accepted values is defined in the lookup type XLA_BUSINESS_FLOW_CLASS. |
| JournalEntryLineCodeCombinationId | |
| JournalEntryLineControlBalanceFlag | Indicates the third party control balance. It has three values: NULL, P, and Y. Null indicates not eligible for balance calculation, P indicates balance calculation pending, and Y indicates balance calculation done. |
| JournalEntryLineCreatedBy | The user who created the subledger journal entry line. |
| JournalEntryLineCreationDate | The date and time when the subledger journal entry line was created. |
| JournalEntryLineCurrencyCode | The currency in which the subledger journal entry line is entered. This is a foreign key of the Currencies view object. |
| JournalEntryLineCurrencyConversionDate | The date that's used to determine the effective rate and calculate accounted amounts when the entered currency isn't the same as the ledger currency. |
| JournalEntryLineCurrencyConversionRate | The exchange rate used in the subledger journal entry line when the entered currency isn't the same as the ledger currency. |
| JournalEntryLineCurrencyConversionType | The exchange rate type used in the subledger journal entry line when the entered currency isn't the same as the ledger currency. This is a foreign key to the Daily Conversion Type view object. |
| JournalEntryLineDescription | The description of the subledger journal entry line provided by the user or source application. |
| JournalEntryLineDisplayedLineNumber | The line number associated with the subledger journal entry line. |
| JournalEntryLineEncumbranceTypeId | The identifier of encumbrance type assigned to a subledger journal entry in the encumbrance accounting. |
| JournalEntryLineEnteredCr | The subledger journal line credit amount in the transaction currency. |
| JournalEntryLineEnteredDr | The subledger journal line debit amount in the transaction currency. |
| JournalEntryLineFundsStatusCode | Indicates the status resulting from a fund check performed on a journal entry. A list of accepted values is defined in the lookup type XLA_FUNDS_STATUS. |
| JournalEntryLineGainOrLossFlag | Indicates whether the subledger journal entry line is a gain or a loss line. A list of accepted values is defined in the lookup type YES_NO. |
| JournalEntryLineGlSlLinkId | The identifier used to link and maintain audit trail from a subledger application to general ledger. |
| JournalEntryLineGlSlLinkTable | The subledger link table name.This column is used to link general ledger journal lines with subledger journal entry lines. |
| JournalEntryLineIntercompanyReversalFlag | Indicates whether the subledger journal entry line is an intercompany reversal line. A list of accepted values is defined in the lookup type YES_NO. |
| JournalEntryLineJgzzReconRef | The system assigned identifier used for reconciliation matching. |
| JournalEntryLineJobDefinitionName | The name of the job that created or last updated the row. |
| JournalEntryLineJobDefinitionPackage | The package name of the job that created or last updated the row. |
| JournalEntryLineLastUpdateDate | The date when the subledger journal entry line row was last updated. |
| JournalEntryLineLastUpdateLogin | The session login associated with the user who last updated the subledger journal entry line. |
| JournalEntryLineLastUpdatedBy | The user who last updated the subledger journal entry line row. |
| JournalEntryLineLedgerId | The unique identifier of the Ledgers view object. This is a foreign key of the Ledgers view object. |
| JournalEntryLineMergeCodeCombinationId | The account combination of the line being reversed on booking the entry again. This column is populated when the Create Third Party Merge Accounting process reverses a journal line for old party and site and books the entry again with new party and site. |
| JournalEntryLineMergePartyId | The old party ID for the entry which was booked again. This column is populated when the Create Third Party Merge Accounting process reverses a journal line for old party and site, and books the entry again with new party and site. |
| JournalEntryLineMergePartySiteId | The old party site ID for the entry which was booked again. This column is populated when the Create Third Party Merge Accounting process reverses a journal line for old party and site and books the entry again with new party and site. |
| JournalEntryLineMpaAccrualEntryFlag | Indicates whether the subledger journal entry line is a multiperiod accounting entry or an accrual entry. |
| JournalEntryLineObjectVersionNumber | The number of times the subledger journal entry line row has been updated. |
| JournalEntryLineOverriddenCodeCombinationId | The code combination identifier of the account that this line overrides. This is a foreign key of the General Ledger Accounts view object. |
| JournalEntryLineOverrideReason | The reason to override a journal entry line. |
| JournalEntryLinePartyId | The identifier of the additional party that participates in a business relationship. |
| JournalEntryLinePartySiteId | The identifier of the additional party site that participates in a business relationship. This is a foreign key of the Party Sites view object. |
| JournalEntryLinePartyTypeCode | Indicates the type of third party. A list of accepted values is defined in the lookup type XLA_PARTY_TYPE. |
| JournalEntryLinePeriodName | The accounting period associated with the subledger journal entry line. This is a foreign key of the Period view object. |
| JournalEntryLineRequestId | The unique identifier of the job that created or last updated the row. |
| JournalEntryLineSourceId | The system transaction identifier of the entry to which the transaction is applied using the business flow feature. |
| JournalEntryLineSr1 | The supporting reference source value. |
| JournalEntryLineSr10 | The supporting reference source value. |
| JournalEntryLineSr11 | The supporting reference source value. |
| JournalEntryLineSr12 | The supporting reference source value. |
| JournalEntryLineSr13 | The supporting reference source value. |
| JournalEntryLineSr14 | The supporting reference source value. |
| JournalEntryLineSr15 | The supporting reference source value. |
| JournalEntryLineSr16 | The supporting reference source value. |
| JournalEntryLineSr17 | The supporting reference source value. |
| JournalEntryLineSr18 | The supporting reference source value. |
| JournalEntryLineSr19 | The supporting reference source value. |
| JournalEntryLineSr2 | The supporting reference source value. |
| JournalEntryLineSr20 | The supporting reference source value. |
| JournalEntryLineSr21 | The supporting reference source value. |
| JournalEntryLineSr22 | The supporting reference source value. |
| JournalEntryLineSr23 | The supporting reference source value. |
| JournalEntryLineSr24 | The supporting reference source value. |
| JournalEntryLineSr25 | The supporting reference source value. |
| JournalEntryLineSr26 | The supporting reference source value. |
| JournalEntryLineSr27 | The supporting reference source value. |
| JournalEntryLineSr28 | The supporting reference source value. |
| JournalEntryLineSr29 | The supporting reference source value. |
| JournalEntryLineSr3 | The supporting reference source value. |
| JournalEntryLineSr30 | The supporting reference source value. |
| JournalEntryLineSr31 | The supporting reference source value. |
| JournalEntryLineSr32 | The supporting reference source value. |
| JournalEntryLineSr33 | The supporting reference source value. |
| JournalEntryLineSr34 | The supporting reference source value. |
| JournalEntryLineSr35 | The supporting reference source value. |
| JournalEntryLineSr36 | The supporting reference source value. |
| JournalEntryLineSr37 | The supporting reference source value. |
| JournalEntryLineSr38 | The supporting reference source value. |
| JournalEntryLineSr39 | The supporting reference source value. |
| JournalEntryLineSr4 | The supporting reference source value. |
| JournalEntryLineSr40 | The supporting reference source value. |
| JournalEntryLineSr41 | The supporting reference source value. |
| JournalEntryLineSr42 | The supporting reference source value. |
| JournalEntryLineSr43 | The supporting reference source value. |
| JournalEntryLineSr44 | The supporting reference source value. |
| JournalEntryLineSr45 | The supporting reference source value. |
| JournalEntryLineSr46 | The supporting reference source value. |
| JournalEntryLineSr47 | The supporting reference source value. |
| JournalEntryLineSr48 | The supporting reference source value. |
| JournalEntryLineSr49 | The supporting reference source value. |
| JournalEntryLineSr5 | The supporting reference source value. |
| JournalEntryLineSr50 | The supporting reference source value. |
| JournalEntryLineSr51 | The supporting reference source value. |
| JournalEntryLineSr52 | The supporting reference source value. |
| JournalEntryLineSr53 | The supporting reference source value. |
| JournalEntryLineSr54 | The supporting reference source value. |
| JournalEntryLineSr55 | The supporting reference source value. |
| JournalEntryLineSr56 | The supporting reference source value. |
| JournalEntryLineSr57 | The supporting reference source value. |
| JournalEntryLineSr58 | The supporting reference source value. |
| JournalEntryLineSr59 | The supporting reference source value. |
| JournalEntryLineSr6 | The supporting reference source value. |
| JournalEntryLineSr60 | The supporting reference source value. |
| JournalEntryLineSr7 | The supporting reference source value. |
| JournalEntryLineSr8 | The supporting reference source value. |
| JournalEntryLineSr9 | The supporting reference source value. |
| JournalEntryLineStatisticalAmount | The statistical amount used in reporting analysis and allocation journal entries. Examples of statistical units of measure are headcount, copies, and labor hours. |
| JournalEntryLineSubledgerXccCompleteStatus | Indicates whether the budgetary control is performed on general ledger entries. A list of accepted values is defined in the lookup type YES_NO. |
| JournalEntryLineSubstitutedCcid | The code combination identifier of the account that was substituted for this subledger journal entry line. This is a foreign key of the General Ledger Accounts view object. |
| JournalEntryLineSuppRefCombinationId | The Identifier of the combination of additional transactional information on a subledger journal entry line. This is a foreign key of the Supporting Reference Combinations view object |
| JournalEntryLineSuppRefValues | The concatenated value of attributes from JournalEntryLineSr 1 to JournalEntryLineSr 30 used for grouping the similar records in balance calculation. |
| JournalEntryLineUnroundedAccountedCr | The subledger journal entry line unrounded credit amount in the ledger currency. |
| JournalEntryLineUnroundedAccountedDr | The subledger journal entry line unrounded debit amount in the ledger currency. |
| JournalEntryLineUnroundedEnteredCr | The subledger journal entry line unrounded credit amount in the entered currency. |
| JournalEntryLineUnroundedEnteredDr | The subledger journal entry line unrounded debit amount in the entered currency. |