Budgetary Control Transactions

The budgetary control transactions view object contains information related to budgetary control transactions and budget entries that updated the budgetary control balances.

Data Store Key : FscmTopModelAM.FinExtractAM.XccBiccExtractAM.BalanceActivityExtractPVO

Primary Keys : BalanceLineOrder, HeaderNum, LineNum

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
ActivityTypeCode	The code for the type of budgetary control transaction. A list of accepted values are defined in the lookup type XCC_BALANCE_ACTIVITY_TYPES.
ActualAmount	Sum of initial budget and budget adjustment amounts.
AllocHeaderNum	The unique identifier of the original budgetary control validation transaction that's liquidated.
AllocLineNum	The line number of the original budgetary control validation transaction that's liquidated.
Amount	The transaction amount in the budget currency.
BackoutHeaderNum	The unique identifier of the original budgetary control validation transaction that's backed out.
BackoutLineNum	The line number of the original budgetary control validation transaction that's backed out.
BalanceLineOrder	Number assigned to the budgetary control validation impact on a control budget by a transaction line.
BalanceTypeCode	The code for the type of budgetary control balances. Valid values are BUDGET, COMMITMENT, OBLIGATION, OTHER, and ACTUAL.
BudgetAdjustmentAmount	Changes made to the initial budget amount.
BudgetAmount	The total budget balance amount.
BudgetCcid	The budget account identifier for the transaction.
BudgetDate	The budget date of the source transaction line for the budgetary control validation attempt.
BurdenLineFlag	Indicates whether the budgetary control validation attempt impact is for the burdened cost of a project.
CodeCombinationId	The unique identifier of the account of the budgetary control validation transaction line.
CommitmentAmount	Consumption amount expected to be spent without a legal obligation.
ControlBudgetId	The identifier of the control budget for which the balance is tracked.
ControlLevelCode	Code that identifies the degree of enforcement in controlling consumption against budget, such as ABSOLUTE, ADVISORY, TRACK, and NONE. TRACK indicates that no enforcement in place to control the consumption. NONE indicates that no enforcement is in place and no tracking of the consumption.
ConversionRate	The currency conversion rate used to convert the entered transaction amount to the budget currency amount.
ConversionTypeCode	The source of a currency conversion rate, such as, user defined or corporate, that's used to convert the transactions.
CreatedBy	The user who created the budgetary control transaction.
CreationDate	The date and time when the budgetary control transaction was created.
EnteredAmount	The entered transaction amount in the transaction currency.
EnteredCurrency	The transaction currency.
EstimatedOverrideAmount	The estimated override amount needed for funds reservation.
EstimatedToleranceAmount	The estimated tolerance amount needed for funds reservation.
FundsAvailableAmount	Funds available amount for consumption.
HeaderNum	The unique identifier of the budgetary control transaction.
LastUpdateDate	The date and time when the budgetary control transaction was last updated.
LastUpdateLogin	The session login associated with the user who last updated the budgetary control transaction.
LastUpdatedBy	The user who last updated the budgetary control transaction.
LedgerAmount	The transaction amount in the ledger currency for the burdened cost from Project Management.
LineNum	The line number of the budgetary control transaction.
NetToleranceAmount	The computed tolerance amount allowed for the control budget, budget period and budget account based on control budget setup. The lesser of the tolerance amount and percentage of total budget is allowed.
ObligationAmount	Consumption amount with a legal obligation to pay in the future.
OtherAmount	Consumption amount for encumbrances excluding commitments or obligations.
OtherLinesAmount	Total pending reservations for other lines in this budgetary control validation attempt for the same control budget, budget period and budget account.
OverrideClosedPeriodFlag	Indicates whether the budgetary control transaction requires an override for reserving funds from a closed budget period.
OverrideFundsFlag	Indicates whether the budgetary control transaction requires an override for insufficient funds.
PendingAmount	The total pending amount from transactions processed earlier in the same or different data set reserved against the same control budget, budget account, and budget period.
PendingHeaderGroupAmount	The total pending amount from transactions processed earlier in the same data set under the same header group reserved against the same control budget, budget account, and budget period.
PeriodChangeForUndoFlag	Indicates when the reversal for this line by a later budgetary control validation attempt is in a different budget period for the control budget and budget account.
PeriodName	The budget period for which the balance is tracked.
PjcExpenditureTypeId	The identifier of the expenditure type of the Project Management transaction line.
PjcResourceId	The identifier of the resource of the Project Management transaction line.
ProcessedForEssbaseFlag	Indicates whether the reserved amount has been transferred to the budgetary control balances cube.
ResultCode	Header Result Code
SubBalanceTypeCode	The code for the budgetary control balance reservation category of the transaction. A list of accepted values are defined in the lookup type XCC_RESERV_CATEGORY_BUCKETS.
ToleranceAmount	The tolerance amount by which the budgetary control transaction can exceed budget.
TolerancePercent	The tolerance percentage of budget by which the budgetary control transaction can exceed budget.