Budget Balance
The Budget Balance view object stores general ledger budget balances. The budget data is loaded to the balances cube from the table and used for variance reporting. If the cube needs to be rebuilt, the budget data is restored to the cube from this table. The combination of LedgerId, BudgetName, PeriodName, CurrencyCode, and CurrencyType forms the unique identifier of the Budget Balance view object.
Data Store Key : FscmTopModelAM.FinExtractAM.GlBiccExtractAM.BudgetBalanceExtractPVO
Primary Keys : BudgetName, ConcatAccount, CurrencyCode, PeriodName, CurrencyType, LedgerId
Initial Extract Date : GlBudBalCreationDate
Incremental Extract Date : GlBudBalLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| BudgetName | The name of the budget used to identify budget balances. This attribute is a part of the composite key of the Budget Balance view object. |
| ConcatAccount | The concatenated string of all the segments from segment 1 through segment 30. |
| CurrencyCode | 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 Budget Balance view object. |
| CurrencyType | Indicates types of currency in the budget balance. This attribute is a part of the composite key of the Budget Balance view object. A list of accepted values is defined in the lookup type GL_CURRENCY_TYPE. |
| GlBudBalCreatedBy | The user who created the budget balance. |
| GlBudBalCreationDate | The date and time when the budget balance was created. |
| GlBudBalLastUpdateDate | The date when the budget balance was last updated. |
| GlBudBalLastUpdateLogin | The session login associated with the user who last updated the budget balance. |
| GlBudBalLastUpdatedBy | The user who last updated the budget balance row. |
| GlBudBalObjectVersionNumber | The number of times the budget balance row has been updated. |
| GlBudBalPeriodNetCr | The credit balance of the accounting period in the ledger or entered currency. |
| GlBudBalPeriodNetDr | The debit balance of the accounting period in the ledger or entered currency. |
| GlBudBalSegment1 | The segment of the accounting flexfield structure. |
| GlBudBalSegment10 | The segment of the accounting flexfield structure. |
| GlBudBalSegment11 | The segment of the accounting flexfield structure. |
| GlBudBalSegment12 | The segment of the accounting flexfield structure. |
| GlBudBalSegment13 | The segment of the accounting flexfield structure. |
| GlBudBalSegment14 | The segment of the accounting flexfield structure. |
| GlBudBalSegment15 | The segment of the accounting flexfield structure. |
| GlBudBalSegment16 | The segment of the accounting flexfield structure. |
| GlBudBalSegment17 | The segment of the accounting flexfield structure. |
| GlBudBalSegment18 | The segment of the accounting flexfield structure. |
| GlBudBalSegment19 | The segment of the accounting flexfield structure. |
| GlBudBalSegment2 | The segment of the accounting flexfield structure. |
| GlBudBalSegment20 | The segment of the accounting flexfield structure. |
| GlBudBalSegment21 | The segment of the accounting flexfield structure. |
| GlBudBalSegment22 | The segment of the accounting flexfield structure. |
| GlBudBalSegment23 | The segment of the accounting flexfield structure. |
| GlBudBalSegment24 | The segment of the accounting flexfield structure. |
| GlBudBalSegment25 | The segment of the accounting flexfield structure. |
| GlBudBalSegment26 | The segment of the accounting flexfield structure. |
| GlBudBalSegment27 | The segment of the accounting flexfield structure. |
| GlBudBalSegment28 | The segment of the accounting flexfield structure. |
| GlBudBalSegment29 | The segment of the accounting flexfield structure. |
| GlBudBalSegment3 | The segment of the accounting flexfield structure. |
| GlBudBalSegment30 | The segment of the accounting flexfield structure. |
| GlBudBalSegment4 | The segment of the accounting flexfield structure. |
| GlBudBalSegment5 | The segment of the accounting flexfield structure. |
| GlBudBalSegment6 | The segment of the accounting flexfield structure. |
| GlBudBalSegment7 | The segment of the accounting flexfield structure. |
| GlBudBalSegment8 | The segment of the accounting flexfield structure. |
| GlBudBalSegment9 | The segment of the accounting flexfield structure. |
| LedgerId | 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 Budget Balance view object. |
| PeriodName | The accounting period associated with the budget balance. This is a foreign key of the Period view object. This attribute is a part of the composite key of the Budget Balance view object. |