Archived Control Balances

The Archived Control Balances view object contains the archived control balances.

Data Store Key : FscmTopModelAM.FinExtractAM.FinArchiveBiccExtractAM.ArchiveXlaControlBalanceExtractPVO

Primary Keys : LedgerId

Initial Extract Date : CreationDate

Incremental Extract Date :

Attributes

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

Name	Description
ApplicationId	The unique identifier of the application for which the control balance is maintained.
BeginningBalanceCr	The debit balance at the beginning of the accounting period.
BeginningBalanceDr	The credit balance at the beginning of the accounting period.
CodeCombinationId	The identifier of the account code combination for which the control balance is maintained.
CreatedBy	The user who created the control balance record.
CreationDate	The date and time when the control balance record was created.
DraftBeginningBalanceCr	The draft credit balance at the beginning of the accounting period.
DraftBeginningBalanceDr	The draft debit balance at the beginning of the accounting period.
FirstPeriodFlag	Indicates whether the period is the first period in a fiscal year for which balances have been calculated.
InitialBalanceFlag	Indicates whether the balance is the beginning account balance for the general ledger account and ledger.
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 of the last update of the row.
LastUpdateLogin	The session login associated to the user who last updated the row.
LastUpdatedBy	The user who last updated the row.
LedgerId	The unique identifier of the ledger for which the control balance is maintained.
ObjectVersionNumber	The number of times the supporting reference balance row has been updated.
PartyId	The unique identifier that refers to any business unit or organization representing both sides of a contract, whether internal or external.
PartySiteId	The unique identifier that refers to the name given to represent the location where a person or organization can be reached.
PartyTypeCode	The classification used to categorize a party.
PeriodBalanceCr	The credit balance for the current accounting period.
PeriodBalanceDr	The debit balance for the current accounting period.
PeriodDraftBalanceCr	The draft credit balance for the current accounting period.
PeriodDraftBalanceDr	The draft debit balance for the current accounting period.
PeriodName	The fiscal period that reports financial results, such as a calendar month or fiscal period.
PeriodYear	The fiscal year a company uses to report financial results.
RequestId	The unique identifier of the job request that created or last updated the row.