Budgetary Control Budget Entry Details
The budgetary control budget entry details view object contains information related to budget line distributions for each budget import, including the control budget, budget account, and budget period updated by each budget line.
Data Store Key : FscmTopModelAM.FinExtractAM.XccBiccExtractAM.BudgetDistAcctExtractPVO
Primary Keys : BudgetAction, BudgetCcid, ControlBudgetId, HeaderId, MasterPeriodName, PeriodName, LineNumber
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| Amount | The budget amount changed by a budget entry line. For example, if a budget entry line of 11 dollars replaces the existing budget of 10 dollars, the amount changed is 1 dollar. If a budget entry line of 1 dollar is added to the existing budget of 10 dollars, the amount changed is also 1 dollar. |
| BudgetAction | The code for the indicator that determines when the unreleased, initial or adjustment budget balance is updated. The code pertaining to Essbase represents an extra record that doesn't update the budget balance. |
| BudgetCcid | The unique identifier of the budget account of the budget entry. |
| ControlBudgetId | The unique identifier of the control budget of the budget entry. |
| CreatedBy | The user who created the budget entry. |
| CreationDate | The date and time when the budget entry was created. |
| DataSetId | The unique identifier of the budgetary control validation attempt. |
| FundsReleasedDate | The date on which the budget amount is released for consumption. |
| HeaderId | The unique identifier of the budget entry. |
| LastUpdateDate | The date and time when the budget entry was last updated. |
| LastUpdateLogin | The session login associated with the user who last updated the budget entry. |
| LastUpdatedBy | The user who last updated the budget entry. |
| LineNumber | The number assigned to each row of record within a budget entry, such as 1, 2, 3 and so on, for record identification and reference purposes. |
| MasterPeriodName | The budget period of the source control budget. |
| ObjectVersionNumber | The number of times the budget entry has been updated. |
| OriginalAmount | The user-entered budget entry amount, which can be different from the computed budget entry amount if it's expressed as an addition or subtraction to the current budget amount. |
| PeriodName | The budget period name of the budget entry. |
| ProcessedForEssbaseFlag | Indicates whether the budget entry has been transferred to the budgetary control balances cube. Valid values are Y and N. |