BudgetaryControlResultsBudgetImpacts
Provides budget impact data associated with labor schedules, including any reductions in available funds due to transactions.
Columns
| Name | Type | Description |
| BudgetCcid [KEY] | Long | The unique identifier for the budget control record in the BudgetaryControlResultsBudgetImpacts table, used to link budget-related impacts to a specific budget control. |
| ControlBudgetId [KEY] | Long | The unique identifier for the control budget in the BudgetaryControlResultsBudgetImpacts table, used to associate the budget impacts with the respective control budget. |
| PeriodName [KEY] | String | The name or identifier of the financial period for the budgetary control results, used to track the specific time frame of the budget impacts. |
| TransactionNumber | String | The transaction number associated with a budgetary control impact, used to uniquely identify the financial transaction in the system. |
| Amount | Decimal | The monetary value of the budgetary impact recorded, representing the total amount of the transaction or budget adjustment. |
| EnteredAmount | Decimal | The amount entered manually or through a system integration, indicating the recorded value before any adjustments or calculations. |
| ResultCode | String | A code representing the result of the budgetary control process, indicating whether the transaction was approved, rejected, or pending. |
| CurrencyCode | String | The code representing the currency used for the budgetary control results, allowing for multi-currency support in financial transactions. |
| Name | String | The name or description of the budgetary control record, used to provide a clear label for the budget impact. |
| AccountedProjectAmount | Decimal | The amount of the budgetary impact that has been accounted for within the specific project, typically used in project-based financial reporting. |
| AccountedPayablesAmount | Decimal | The amount of the budgetary control impact attributed to accounts payable, indicating funds allocated for payments to vendors or suppliers. |
| AccountedReceiptsAmount | Decimal | The amount of the budgetary control impact attributed to accounts receivable, reflecting expected funds from customers or other sources. |
| ActualAmount | Decimal | The actual amount recorded for a transaction or budget adjustment, reflecting the real financial impact as opposed to estimated or budgeted figures. |
| ApprovedAuthorizationAmount | Decimal | The amount that has been authorized for expenditure, subject to approval within the budgetary control process. |
| ApprovedCommitmentAmount | Decimal | The amount that has been committed for future spending, typically for ongoing contracts or planned expenditures. |
| ApprovedObligationAmount | Decimal | The amount of funds that have been obligated for a specific purpose, indicating a legal or financial responsibility to spend. |
| BudgetAdjustmentAmount | Decimal | The amount by which the original budget has been adjusted, either through increases or decreases based on financial needs or decisions. |
| BudgetAmount | Decimal | The total approved budget amount, representing the allocated funds for a particular budget line or category. |
| CommitmentAmount | Decimal | The total amount of funds that have been committed but not yet spent, typically covering outstanding obligations or agreements. |
| DetailOtherAmount | Decimal | Any additional amounts related to other budgetary impacts that are not directly categorized under standard budget categories. |
| FundsAvailableAmount | Decimal | The amount of funds remaining available for expenditure within the current budget, reflecting unspent or remaining funds after commitments. |
| MiscExpendituresAmount | Decimal | The amount of miscellaneous expenditures that are outside of the predefined categories, often used for one-off or unforeseen expenses. |
| ObligationAmount | Decimal | The amount of funds that have been legally obligated for spending, including contracted expenses and financial commitments. |
| OtherAmount | Decimal | Any other amounts related to the budgetary control results that do not fit into the standard categories, representing additional financial factors. |
| UnreleasedBudgetAmount | Decimal | The portion of the budget that has not yet been released for spending, often due to approval processes or restrictions. |
| TotalConsumption | Decimal | The total amount of funds consumed or used from the budget, indicating how much of the budget has been spent or allocated. |
| BudgetAccount | String | The identifier for the specific budget account, used to track financial transactions within a given account in the budgetary system. |
| FundsConsumed | Decimal | The amount of funds that have been consumed or utilized from the available budget, contributing to the total consumption. |
| Status | String | The current status of the budgetary control results, such as active, completed, or pending, to indicate the stage of the financial process. |
| BudgetManager | String | The name or identifier of the budget manager responsible for overseeing and controlling the budgetary impacts and financial allocations. |
| AdditionalRequired | Decimal | The amount of additional funding required to meet the budgetary needs or resolve any shortfalls in the current budget. |
| DataSetId | Long | The unique identifier for the dataset that contains the budgetary control results, used for grouping and managing related financial data. |
| DraftFlag | String | A flag indicating whether the budgetary control results are in draft status, meaning they are not yet finalized or approved. |
| Finder | String | An identifier or code used to locate or search for specific budgetary control results within the database or financial system. |
| SourceHeaderId1 | String | The unique identifier for the first source header associated with the budgetary control impact, used for linking the record to its originating source. |
| SourceHeaderId2 | String | The unique identifier for the second source header, which may be used for additional linkage to another related financial source. |
| SourceLineId1 | String | The unique identifier for the first source line, allowing further specification of the source transaction or document related to the budgetary impact. |
| SourceLineId2 | String | The unique identifier for the second source line, providing additional detail for tracing the transaction or document origin. |
| SourceLineId3 | String | The unique identifier for the third source line, offering even further specificity for tracing the financial source of the impact. |
| SourceLineId4 | String | The unique identifier for the fourth source line, helping further detail the origin of the transaction or budgetary impact. |
| SourceLineId5 | String | The unique identifier for the fifth source line, providing additional granularity in identifying the source of financial impacts. |
| TransactionTypeCode | String | The code representing the type of financial transaction being recorded, such as a payment, adjustment, or allocation, providing context to the budgetary impact. |