BudgetaryControlBudgetEntryControlBudgetImpact
A budget entry control budget impact represents the budget balance of a control budget, budget period, and budget account that's updated by a budget entry line. A single budget entry line can update multiple control budgets. Multiple budget entry lines entered by month and detailed segment value can be aggregated and update a yearly period and a single parent budget account.
Business Views
** Available for extracting data- budgetaryControlBudgetEntryControlBudgetImpactsExtract**
A budget entry control budget impact represents the budget balance of a control budget, budget period, and budget account that's updated by a budget entry line. A single budget entry line can update multiple control budgets. Multiple budget entry lines entered by month and detailed segment value can be aggregated and update a yearly period and a single parent budget account.
Label, Plural Label
Budgetary Control Budget Entry Control Budget Impacts, Budgetary Control Budget Entry Control Budget Impacts
Data Source
Read-optimized data store
Fields
- amountChanged (big-decimal)
The budget amount changed by a budget entry line or the computed budget entry amount. 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.
Label
Amount Changed
Properties
- searchable
- sortable
- not nullable
- budgetCodeCombinationId (int64)
Identifier of the budget account of the budget entry.
Label
Budget Account Code Combination ID
Properties
- searchable
- sortable
- not nullable
- budgetEntryId (int64)
The unique identifier of the budget entry.
Label
Budget Entry ID
Properties
- searchable
- sortable
- not nullable
- budgetPeriod (string)
The budget period name of the budget entry.
Label
Budget Period
Properties
- searchable
- sortable
- not nullable
- budgetReleaseStatusCode (string)
The code indicating the status of the budget balance released for consumption. A list of accepted values are defined in the lookup type ORA_XCC_BGT_ACCTS_ACTION. The value pertaining to Essbase represents an extra record that doesn't update the budget balance.
Label
Budget Release Status Code
Properties
- searchable
- sortable
- not nullable
- budgetReleaseStatusDate (date-time)
The date on which the budget amount is released for consumption.
Label
Funds Released Date
Properties
- searchable
- sortable
- controlBudgetId (int64)
The unique identifier of the control budget of the budget entry.
Label
Control Budget ID
Properties
- searchable
- sortable
- not nullable
- createdBy (string)
The user who created the record.
Label
Created By
Properties
- searchable
- sortable
- not nullable
- lineNumber (int64)
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.
Label
Line Number
Properties
- searchable
- sortable
- not nullable
- processedForBudgetCubeFlag (boolean)
Indicates whether the budget entry has been transferred to the budgetary control balances cube. Valid values are Y and N.
Label
Transferred to Cube Indicator
- sourceAmount (big-decimal)
The user-entered budget entry amount, which can be different from the computed budget entry amount if it's expressed as replacement to the existing budget amount.
Label
Source Amount
Properties
- searchable
- sortable
- not nullable
- sourceBudgetPeriod (string)
The budget period of the source control budget.
Label
Source Budget Period
Properties
- searchable
- sortable
- not nullable
- timeCreated (date-time)
The date and time when the record was created.
Label
Creation Date
Properties
- searchable
- sortable
- not nullable
- timeUpdated (date-time)
The date and time when the record was last updated.
Label
Last Updated Date
Properties
- searchable
- sortable
- not nullable
- updatedBy (string)
The user who last updated the record.
Label
Last Updated By
Properties
- searchable
- sortable
- not nullable
Reference Object
- budgetAccount (ControlBudgetAccount)
A budget account is a combination of budget segment values for a budgeting flexfield structure. It's used to record budget and consumption balances for a control budget of a given structure, which can be based on applicable accounting segments or project attributes. Separate budgeting flexfield structures can have a different number of budget segments to control budget and consumption balances.
Business Object
ControlBudgetAccountFields
- budgetChartOfAccountsId (string)
The identifier of the key flexfield structure for the budget chart of accounts.
Label
Budget Chart of Accounts ID
Properties
- inherited
- searchable
- sortable
- budgetCodeCombinationId (int64)
The unique identifier of the budget account.
Label
Budget Account Code Combination ID
Properties
- inherited
- searchable
- sortable
- not nullable
- budgetChartOfAccountsId (string)
- budgetEntryLine (BudgetaryControlBudgetEntryLine)
A budget entry line represents the combination of budget segment values of a budget line.
Business Object
BudgetaryControlBudgetEntryLineFields
- budgetEntryId (int64)
The unique identifier of the budget entry.
Label
Budget Entry ID
Properties
- searchable
- sortable
- not nullable
- lineNumber (int64)
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.
Label
Line Number
Properties
- searchable
- sortable
- not nullable
- budgetEntryId (int64)
- budgetReleaseStatus (StandardLookupCode)
Indicates the status of the budget balance released for consumption. The status indicates whether the budget is unreleased, released at the time of budget entry, or at the time the budget period is opened. The status pertaining to Essbase represents an extra record that doesn't update the budget balance.
Business Object
StandardLookupCodeFields
- lookupCode (string)
The unique identifier of the Lookup Code.
Label
Lookup Code ID
Properties
- inherited
- searchable
- sortable
- not nullable
- lookupType (string)
The unique identifier of the Lookup Type.
Label
Lookup Type ID
Properties
- inherited
- searchable
- sortable
- not nullable
- lookupCode (string)
- budgetaryControlValidationRequest (BudgetaryControlValidationRequest)
A budgetary control validation request contains the information of each request, such as the type of transaction being validated and the validation result.
Business Object
BudgetaryControlValidationRequestFields
- validationRequestId (int64)
The unique identifier of the budgetary control validation request.
Label
Validation Request ID
Properties
- searchable
- sortable
- not nullable
- validationRequestId (int64)
- amountChanged (big-decimal)