Archived Supporting Reference Balances
The Archived Supporting Reference Balances view object contains the archived supporting reference balances.
Data Store Key : FscmTopModelAM.FinExtractAM.FinArchiveBiccExtractAM.ArchiveXlaBalanceExtractPVO
Primary Keys : LedgerId
Initial Extract Date : CreationDate
Incremental Extract Date :
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AcBalanceId | The unique identifier of the supporting reference balances. |
| AmbContextCode | The accounting methods builder context. |
| AnalyticalCriterionCode | The short name of the supporting reference. |
| AnalyticalCriterionTypeCode | Indicates whether the journal line rule is seeded. A list of accepted values is defined in the lookup type XLA_OWNER_TYPE. |
| ApplicationId | The unique identifier of the application for which the supporting reference balance is maintained. |
| BeginningBalanceCr | The credit balance of the supporting references in the ledger currency at the beginning of the accounting period. |
| BeginningBalanceDr | The debit balance of the supporting references in the ledger currency at the beginning of the accounting period. |
| CodeCombinationId | The unique identifier of the general ledger account combination for which the supporting reference balance is maintained. |
| CreatedBy | The user who created the supporting reference balance. |
| CreationDate | The date and time when the supporting reference balance was created. |
| EnteredCurBeginBalCr | The credit balance of the supporting references in the entered currency at the beginning of the accounting period. |
| EnteredCurBeginBalDr | The debit balance of the supporting references in the entered currency at the beginning of the accounting period. |
| EnteredCurrencyCode | The code representing the entered currency in which the supporting reference balance is maintained. |
| FirstPeriodFlag | Indicates whether the period is the first accounting period in a fiscal year. A list of accepted values is defined in the lookup type YES_NO. |
| InitialBalanceFlag | Indicates whether the balance is the initial balance for the supporting references. A list of accepted values is defined in the lookup type YES_NO. |
| 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 and time when the supporting reference balance row was last updated. |
| LastUpdateLogin | The session login associated with the user who last updated the supporting reference balance row. |
| LastUpdatedBy | The user who last updated the supporting reference balance. |
| LedgerId | The unique identifier of the ledger for which the supporting reference balance is maintained. |
| ObjectVersionNumber | The number of times the supporting reference balance row has been updated. |
| PartitionGroupCode | The code that identifies the partition group. The partition grouping information, when combined with the period, determines the database partition where the journal will be stored. |
| PeriodBalanceCr | The period-to-date credit balance of the supporting references in the ledger currency. |
| PeriodBalanceDr | The period-to-date debit balance of the supporting references in the ledger currency. |
| PeriodEnteredBalanceCr | The period-to-date credit balance of the supporting references in the entered currency. |
| PeriodEnteredBalanceDr | The period-to-date debit balance of the supporting references in the entered currency. |
| PeriodName | The accounting period name of the supporting reference balance. |
| PeriodYear | The fiscal year of the accounting period for the supporting reference balance. |
| RequestId | The unique identifier of the job that created or last updated the row. |
| Sr1 | The source value of the supporting reference. |
| Sr10 | The source value of the supporting reference. |
| Sr11 | The source value of the supporting reference. |
| Sr12 | The source value of the supporting reference. |
| Sr13 | The source value of the supporting reference. |
| Sr14 | The source value of the supporting reference. |
| Sr15 | The source value of the supporting reference. |
| Sr16 | The source value of the supporting reference. |
| Sr17 | The source value of the supporting reference. |
| Sr18 | The source value of the supporting reference. |
| Sr19 | The source value of the supporting reference. |
| Sr2 | The source value of the supporting reference. |
| Sr20 | The source value of the supporting reference. |
| Sr21 | The source value of the supporting reference. |
| Sr22 | The source value of the supporting reference. |
| Sr23 | The source value of the supporting reference. |
| Sr24 | The source value of the supporting reference. |
| Sr25 | The source value of the supporting reference. |
| Sr26 | The source value of the supporting reference. |
| Sr27 | The source value of the supporting reference. |
| Sr28 | The source value of the supporting reference. |
| Sr29 | The source value of the supporting reference. |
| Sr3 | The source value of the supporting reference. |
| Sr30 | The source value of the supporting reference. |
| Sr4 | The source value of the supporting reference. |
| Sr5 | The source value of the supporting reference. |
| Sr6 | The source value of the supporting reference. |
| Sr7 | The source value of the supporting reference. |
| Sr8 | The source value of the supporting reference. |
| Sr9 | The source value of the supporting reference. |
| SuppRefCombinationId | The unique identifier of the combination of the supporting references. |
| SuppRefValues | The concatenated value of all the supporting references. |
| TransferredToEssbase | Indicates whether the balance entry is transferred to Essbase. |