Archived Subledger Journal Entry Lines
The Archived Subledger Journal Entry Lines view object contains the archived subledger journal entry lines.
Data Store Key : FscmTopModelAM.FinExtractAM.FinArchiveBiccExtractAM.ArchiveXlaLineExtractPVO
Primary Keys : AeHeaderId
Initial Extract Date : CreationDate
Incremental Extract Date :
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AccountOverlaySourceId | The unique identifier of the account overlay source. |
| AccountedCr | The subledger journal line credit amount in the accounting currency. |
| AccountedDr | The subledger journal line debit amount in the accounting currency. |
| AccountingClassCode | The code representing the accounting class of the journal entry line. A list of accepted values is defined in the lookup type XLA_ACCOUNTING_CLASS. |
| AccountingDate | The date referenced from General Ledger and used to determine the accounting period for transactions. |
| AeHeaderId | The unique identifier of the subledger journal entry. |
| AeLineNum | The number associated with each subledger journal entry line. |
| AnalyticalBalanceFlag | Indicates the status of the balance calculation for supporting reference. Valid values are NULL, P, and Y. The value NULL indicates not eligible for balance calculation, the value P indicates balance calculation is pending, and the value Y indicates balance calculation is complete. |
| AnchorLineFlag | Indicates whether the line is an anchor line for PeopleSoft integration. A list of accepted values is defined in the lookup type YES_NO. |
| ApplicationId | The unique identifier of the source application. |
| Attribute1 | A segment for the Subledger Journal Entry Lines descriptive flexfield. |
| Attribute10 | A segment for the Subledger Journal Entry Lines descriptive flexfield. |
| Attribute11 | A segment for the Subledger Journal Entry Lines descriptive flexfield. |
| Attribute12 | A segment for the Subledger Journal Entry Lines descriptive flexfield. |
| Attribute13 | A segment for the Subledger Journal Entry Lines descriptive flexfield. |
| Attribute14 | A segment for the Subledger Journal Entry Lines descriptive flexfield. |
| Attribute15 | A segment for the Subledger Journal Entry Lines descriptive flexfield. |
| Attribute2 | A segment for the Subledger Journal Entry Lines descriptive flexfield. |
| Attribute3 | A segment for the Subledger Journal Entry Lines descriptive flexfield. |
| Attribute4 | A segment for the Subledger Journal Entry Lines descriptive flexfield. |
| Attribute5 | A segment for the Subledger Journal Entry Lines descriptive flexfield. |
| Attribute6 | A segment for the Subledger Journal Entry Lines descriptive flexfield. |
| Attribute7 | A segment for the Subledger Journal Entry Lines descriptive flexfield. |
| Attribute8 | A segment for the Subledger Journal Entry Lines descriptive flexfield. |
| Attribute9 | A segment for the Subledger Journal Entry Lines descriptive flexfield. |
| AttributeCategory | The context name for the Subledger Journal Entry Lines descriptive flexfield. |
| AttributeDate1 | A date segment for the Subledger Journal Entry Lines descriptive flexfield. |
| AttributeDate10 | A date segment for the Subledger Journal Entry Lines descriptive flexfield. |
| AttributeDate2 | A date segment for the Subledger Journal Entry Lines descriptive flexfield. |
| AttributeDate3 | A date segment for the Subledger Journal Entry Lines descriptive flexfield. |
| AttributeDate4 | A date segment for the Subledger Journal Entry Lines descriptive flexfield. |
| AttributeDate5 | A date segment for the Subledger Journal Entry Lines descriptive flexfield. |
| AttributeDate6 | A date segment for the Subledger Journal Entry Lines descriptive flexfield. |
| AttributeDate7 | A date segment for the Subledger Journal Entry Lines descriptive flexfield. |
| AttributeDate8 | A date segment for the Subledger Journal Entry Lines descriptive flexfield. |
| AttributeDate9 | A date segment for the Subledger Journal Entry Lines descriptive flexfield. |
| AttributeNumber1 | A number segment for the Subledger Journal Entry Lines descriptive flexfield. |
| AttributeNumber10 | A number segment for the Subledger Journal Entry Lines descriptive flexfield. |
| AttributeNumber2 | A number segment for the Subledger Journal Entry Lines descriptive flexfield. |
| AttributeNumber3 | A number segment for the Subledger Journal Entry Lines descriptive flexfield. |
| AttributeNumber4 | A number segment for the Subledger Journal Entry Lines descriptive flexfield. |
| AttributeNumber5 | A number segment for the Subledger Journal Entry Lines descriptive flexfield. |
| AttributeNumber6 | A number segment for the Subledger Journal Entry Lines descriptive flexfield. |
| AttributeNumber7 | A number segment for the Subledger Journal Entry Lines descriptive flexfield. |
| AttributeNumber8 | A number segment for the Subledger Journal Entry Lines descriptive flexfield. |
| AttributeNumber9 | A number segment for the Subledger Journal Entry Lines descriptive flexfield. |
| BusinessClassCode | 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. |
| CodeCombinationId | The unique identifier of the account code combination used on the journal entry line. |
| ControlBalanceFlag | Indicates the status of the control balance calculation. Valid values are NULL, P, and Y. The value Null indicates not eligible for balance calculation, the value P indicates balance calculation pending, and the value Y indicates balance calculation done. |
| CreatedBy | The user who created the subledger journal entry line. |
| CreationDate | The date and time when the subledger journal entry line was created. |
| CurrencyCode | The code representing the currency in which the subledger journal entry line is entered. |
| CurrencyConversionDate | 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. |
| CurrencyConversionRate | The exchange rate used in the subledger journal entry line when the entered currency isn't the same as the ledger currency. |
| CurrencyConversionType | The exchange rate type used in the subledger journal entry line when the entered currency isn't the same as the ledger currency. |
| Description | The description of the subledger journal entry line provided by the user or source application. |
| DisplayedLineNumber | The line number associated with the subledger journal entry line. |
| EncumbranceTypeId | The unique identifier of the encumbrance type assigned to a subledger journal entry in the encumbrance accounting. |
| EnteredCr | The subledger journal line credit amount in the transaction currency. |
| EnteredDr | The subledger journal line debit amount in the transaction currency. |
| FundsStatusCode | 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. |
| GainOrLossFlag | 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. |
| GlSlLinkId | The unique identifier used to link and maintain audit trail from a subledger application to general ledger. |
| GlSlLinkTable | The subledger link table name. This column is used to link general ledger journal lines with subledger journal entry lines. |
| GlTransferModeCode | The code representing the general ledger transfer mode. A list of accepted values is defined in the lookup type XLA_ACCT_TRANSFER_MODE. |
| IntercompanyReversalFlag | 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. |
| JgzzReconRef | The unique identifier assigned by the system for reconciliation matching. |
| JobDefinitionName | The name of the job that created or last updated the row. |
| JobDefinitionPackage | The package name of the job that created or last updated the row. |
| LastUpdateDate | The date when the subledger journal entry line row was last updated. |
| LastUpdateLogin | The session login associated with the user who last updated the subledger journal entry line. |
| LastUpdatedBy | The user who last updated the subledger journal entry line row. |
| LedgerId | The unique identifier of the Ledgers view object. |
| MpaAccrualEntryFlag | Indicates whether the subledger journal entry line is a multiperiod accounting entry or an accrual entry. |
| MultiperiodClassCode | The multiperiod accounting class associated with the journal line rule that was used to create the accounting line. |
| ObjectVersionNumber | The number of times the subledger journal entry line row has been updated. |
| OverriddenCodeCombinationId | The code combination identifier of the account that this line overrides. This is a foreign key of the General Ledger Accounts view object. |
| OverrideReason | The reason to override a journal entry line. |
| PartyId | The unique identifier of the additional party that participates in a business relationship. |
| PartySiteId | The unique identifier of the additional party site that participates in a business relationship. |
| PartyTypeCode | The code representing the third party type. A list of accepted values is defined in the lookup type XLA_PARTY_TYPE. |
| PeriodName | The accounting period associated with the subledger journal entry line. |
| RequestId | The unique identifier of the job that created or last updated the row. |
| Sr1 | The supporting reference source value. |
| Sr10 | The supporting reference source value. |
| Sr11 | The supporting reference source value. |
| Sr12 | The supporting reference source value. |
| Sr13 | The supporting reference source value. |
| Sr14 | The supporting reference source value. |
| Sr15 | The supporting reference source value. |
| Sr16 | The supporting reference source value. |
| Sr17 | The supporting reference source value. |
| Sr18 | The supporting reference source value. |
| Sr19 | The supporting reference source value. |
| Sr2 | The supporting reference source value. |
| Sr20 | The supporting reference source value. |
| Sr21 | The supporting reference source value. |
| Sr22 | The supporting reference source value. |
| Sr23 | The supporting reference source value. |
| Sr24 | The supporting reference source value. |
| Sr25 | The supporting reference source value. |
| Sr26 | The supporting reference source value. |
| Sr27 | The supporting reference source value. |
| Sr28 | The supporting reference source value. |
| Sr29 | The supporting reference source value. |
| Sr3 | The supporting reference source value. |
| Sr30 | The supporting reference source value. |
| Sr31 | The supporting reference source value. |
| Sr32 | The supporting reference source value. |
| Sr33 | The supporting reference source value. |
| Sr34 | The supporting reference source value. |
| Sr35 | The supporting reference source value. |
| Sr36 | The supporting reference source value. |
| Sr37 | The supporting reference source value. |
| Sr38 | The supporting reference source value. |
| Sr39 | The supporting reference source value. |
| Sr4 | The supporting reference source value. |
| Sr40 | The supporting reference source value. |
| Sr41 | The supporting reference source value. |
| Sr42 | The supporting reference source value. |
| Sr43 | The supporting reference source value. |
| Sr44 | The supporting reference source value. |
| Sr45 | The supporting reference source value. |
| Sr46 | The supporting reference source value. |
| Sr47 | The supporting reference source value. |
| Sr48 | The supporting reference source value. |
| Sr49 | The supporting reference source value. |
| Sr5 | The supporting reference source value. |
| Sr50 | The supporting reference source value. |
| Sr51 | The supporting reference source value. |
| Sr52 | The supporting reference source value. |
| Sr53 | The supporting reference source value. |
| Sr54 | The supporting reference source value. |
| Sr55 | The supporting reference source value. |
| Sr56 | The supporting reference source value. |
| Sr57 | The supporting reference source value. |
| Sr58 | The supporting reference source value. |
| Sr59 | The supporting reference source value. |
| Sr6 | The supporting reference source value. |
| Sr60 | The supporting reference source value. |
| Sr7 | The supporting reference source value. |
| Sr8 | The supporting reference source value. |
| Sr9 | The supporting reference source value. |
| StatisticalAmount | The statistical amount used in reporting analysis and allocation journal entries. Examples of statistical units of measure are headcount, copies, and labor hours. |
| SubledgerXccCompleteStatus | Indicates whether the budgetary control is performed on general ledger entries. A list of accepted values is defined in the lookup type YES_NO. |
| SubstitutedCcid | The code combination identifier of the account that was substituted for this subledger journal entry line. |
| SuppRefCombinationId | The unique Identifier of the additional transactional information combination on a subledger journal entry line. |
| SuppRefValues | The concatenated value of attributes from JournalEntryLineSr 1 to JournalEntryLineSr 30 used for grouping the similar records in balance calculation. |
| UnroundedAccountedCr | The unrounded subledger journal line credit amount in the ledger currency. |
| UnroundedAccountedDr | The unrounded subledger journal line debit amount in the ledger currency. |
| UnroundedEnteredCr | The unrounded subledger journal line credit amount in the entered currency. |
| UnroundedEnteredDr | The unrounded subledger journal line debit amount in the entered currency. |