Ledger Balance

The ledger balance view object contains information about actual, budget and encumbrance balances for detail and summary accounts. The combination of BalanceCodeCombinationId, BalanceCurrencyCode, BalancePeriodName, BalanceActualFlag, BalanceEncumbranceTypeId and BalanceTranslatedFlag forms the unique identifier of the Ledger Balance view object.

Data Store Key : FscmTopModelAM.FinExtractAM.GlBiccExtractAM.BalanceExtractPVO

Primary Keys : BalanceActualFlag, BalanceCodeCombinationId, BalanceCurrencyCode, BalanceTranslatedFlag, BalanceEncumbranceTypeId, BalanceLedgerId, BalancePeriodName

Initial Extract Date :

Incremental Extract Date : BalanceLastUpdateDate

Attributes

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

Name	Description
BalanceActualFlag	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.
BalanceBeginBalanceCr	The credit balance at the beginning of the period in the entered currency.
BalanceBeginBalanceCrBeq	The credit balance at the beginning of the period in the ledger currency.
BalanceBeginBalanceDr	The debit balance at the beginning of the period in the entered currency.
BalanceBeginBalanceDrBeq	The debit balance at the beginning of the period in the ledger currency.
BalanceCodeCombinationId	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.
BalanceCurrencyCode	The currency of the ledger balance. 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.
BalanceEncumbranceTypeId	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.
BalanceLastUpdateDate	The date when the ledger balance row was last updated.
BalanceLastUpdatedBy	The user who last updated the ledger balance row.
BalanceLedgerId	The unique identifier of the ledger of the balance row. 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.
BalanceObjectVersionNumber	The number of times the ledger balance has been updated.
BalancePeriodName	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.
BalancePeriodNetCr	The credit balance of the accounting period in the entered currency.
BalancePeriodNetCrBeq	The credit balance of the accounting period in the ledger currency.
BalancePeriodNetDr	The debit balance of the accounting period in the entered currency.
BalancePeriodNetDrBeq	The debit balance of the accounting period in the ledger currency.
BalancePeriodNum	The accounting period number of the ledger balance.
BalancePeriodYear	The accounting period year of the ledger balance.
BalanceProjectToDateCr	The accumulated or life-to-date credit balance of the project in the entered currency.
BalanceProjectToDateCrBeq	The accumulated or life-to-date credit balance of the project in the ledger currency.
BalanceProjectToDateDr	The accumulated or life-to-date debit balance of the project in the entered currency.
BalanceProjectToDateDrBeq	The accumulated or life-to-date debit balance of the project in the ledger currency.
BalanceQuarterToDateCr	The credit balance of the quarter-to-date period in the entered currency.
BalanceQuarterToDateCrBeq	The credit balance of the quarter-to-date period in the ledger currency.
BalanceQuarterToDateDr	The debit balance of the quarter-to-date period in the entered currency.
BalanceQuarterToDateDrBeq	The debit balance of the quarter-to-date period in the ledger currency.
BalanceTranslatedFlag	Indicates 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.
JournalEncumbranceTypeTLDescription	The description of the encumbrance provided by the user or source application.
JournalEncumbranceTypeTLEncumbranceType	The alternate unique identifier of the journal encumbrance type. This is an alternate primary key of the Journal Encumbrance Type entity object.
JournalEncumbranceTypeTLEncumbranceTypeId	The unique identifier of the journal encumbrance type. This is a primary key of the Journal Encumbrance Type entity object.
JournalEncumbranceTypeTLLanguage	The code for the language into which the contents of translatable columns are translated.