Archived General Ledger Balances

The Archived General Ledger Balances view object contains archived information of the general ledger balances, such as actuals, budget, and encumbrance balances for detail and summary accounts.

Data Store Key : FscmTopModelAM.FinExtractAM.FinArchiveBiccExtractAM.ArchiveGlBalanceExtractPVO

Primary Keys : LedgerId

Initial Extract Date : LastUpdateDate

Incremental Extract Date :

Attributes

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

Name	Description
ActualFlag	Identifies whether the balance is an actual or encumbrance. A list of accepted values is defined in the lookup type BATCH_TYPE. This attribute is a part of the composite key of the Ledger Balance view object.
BeginBalanceCr	The credit balance at the beginning of the period in the entered currency.
BeginBalanceCrBeq	The credit balance at the beginning of the period in the ledger currency.
BeginBalanceDr	The debit balance at the beginning of the period in the entered currency.
BeginBalanceDrBeq	The debit balance at the beginning of the period in the ledger currency.
CodeCombinationId	The unique identifier of the general ledger account. This is a foreign key of the General Ledger Account view object. This attribute is a part of the composite key of the Ledger Balance view object.
CurrencyCode	The code associated with the ledger currency. This is a foreign key of the Currencies view object. This attribute is a part of the composite key of the Ledger Balance view object.
EncumbranceTypeId	The unique identifier of the journal encumbrance type posted to the ledger. This attribute is a part of the composite key of the Ledger Balance view object.
LastUpdateDate	The date when the ledger balance row was last updated.
LastUpdatedBy	The user who last updated the ledger balance row..
LedgerId	The unique identifier of the balance row ledger. This is a foreign key of the Ledger view object. This attribute is a part of the composite key of the Ledger Balance view object.
ObjectVersionNumber	The number of times the ledger balance 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 balance will be stored.
PeriodName	The accounting period associated with the balance. This is a foreign key of the Period view object. This attribute is a part of the composite key of the Ledger Balance view object.
PeriodNetCrBeq	The credit balance of the accounting period in the ledger currency.
PeriodNetDr	The debit balance of the accounting period in the entered currency.
PeriodNetDrBeq	The debit balance of the accounting period in the ledger currency.
PeriodNum	The accounting period number of the ledger balance.
PeriodType	The accounting period type code of the Oracle General Ledger balance.
PeriodYear	The accounting period year of the ledger balance.
ProjectToDateCr	The accumulated or life-to-date credit balance of the project in the entered currency.
ProjectToDateCrBeq	The accumulated or life-to-date credit balance of the project in the ledger currency.
ProjectToDateDr	The accumulated or life-to-date debit balance of the project in the entered currency.
ProjectToDateDrBeq	The accumulated or life-to-date debit balance of the project in the ledger currency.
QuarterToDateCr	The credit balance of the quarter-to-date period in the entered currency.
QuarterToDateCrBeq	The credit balance of the quarter-to-date period in the ledger currency.
QuarterToDateDr	The debit balance of the quarter-to-date period in the entered currency.
QuarterToDateDrBeq	The debit balance of the quarter-to-date period in the ledger currency.
TemplateId	The unique identifier of the template.
TranslatedFlag	Indicates the translation status of the ledger balance. A list of accepted values is defined in the lookup type GL_BALANCES_TRANSLATION_STATUS. This attribute is a part of the composite key of the Ledger Balance view object.