BudgetaryControlResultsBudgetTransactions
Supports internal budget adjustments by displaying validation info on transactions affecting Enterprise Performance Management budgets.
Columns
| Name | Type | Description |
| TransactionNumber [KEY] | String | The unique identifier for the transaction in the BudgetaryControlResultsBudgetTransactions table, used to track specific transactions within the system. |
| LineNumber | String | The line number associated with the transaction, providing further detail about the specific entry within the budgetary control results. |
| ControlBudget | String | The budget control code that this transaction is associated with, indicating the specific budget being monitored. |
| ControlBudgetPeriod | String | The period of the control budget to which the transaction belongs, used for time-based budget control in the system. |
| BudgetAccount | String | The account within the budget to which this transaction is attributed, providing a financial classification for the transaction. |
| TransactionAmount | Decimal | The amount of the transaction, expressed in the appropriate currency, representing the financial impact on the budget. |
| ControlBudgetAmount | Decimal | The allocated amount for the control budget, showing the total sum assigned for monitoring and control during the specified period. |
| ReservedBudgetAmount | Decimal | The amount of the control budget that has been reserved for use, but not yet consumed, within the system. |
| BudgetTransactionType | String | The type of budget transaction, indicating whether the entry is a debit, credit, adjustment, or another type of financial transaction. |
| FundsAction | String | The action associated with the funds, such as allocation, reallocation, or adjustment, applied to the budget transaction. |
| BatchResult | String | The outcome of the batch process for the transaction, indicating whether the batch has been successfully processed or encountered issues. |
| BatchFatalErrorMessage | String | A message detailing any fatal errors encountered during the batch process, helping to diagnose issues preventing successful processing. |
| HeaderStatus | String | The status of the transaction's header, indicating whether the overall transaction has been approved, pending, or has encountered issues. |
| HeaderResult | String | The result of processing the transaction's header, including the outcome or error code from the header-level validation. |
| LineStatus | String | The status of the specific line item within the transaction, indicating whether it is pending, processed, or contains errors. |
| LineResult | String | The result of the line item processing, providing information on whether the line item was successfully processed or encountered an issue. |
| ActivityStatus | String | The status of any activity related to the transaction, which could include approval, completion, or waiting for further actions. |
| ActivityResult | String | The result of the activity tied to the transaction, indicating the outcome or errors associated with specific actions. |
| InitialBudgetBalance | Decimal | The starting balance for the budget before any transactions or adjustments have been applied, representing the original allocated budget amount. |
| BudgetAdjustmentBalance | Decimal | The balance reflecting any adjustments made to the budget, such as increases or decreases, over the course of the period. |
| TotalBudgetBalance | Decimal | The total budget balance after all adjustments, showing the final available amount after considering both initial balances and adjustments. |
| TotalConsumptionBalance | Decimal | The total amount of the budget that has been consumed by transactions, representing expenditures or usage against the available budget. |
| FundsAvailableBalance | Decimal | The remaining balance of funds available in the budget after accounting for both consumption and reservations. |
| BudgetManager | String | The identifier for the individual or role responsible for managing and overseeing the budget's use and monitoring within the organization. |
| ControlBudgetCurrency | String | The currency of the control budget, ensuring transactions are monitored and tracked in the appropriate monetary units. |
| TransactionCurrency | String | The currency in which the transaction is denominated, which could differ from the control budget's currency. |
| ConversionDate | Date | The date on which the currency conversion occurred, used to ensure accurate conversion rates are applied for multi-currency transactions. |
| ConversionRate | Decimal | The rate applied to convert the transaction amount from one currency to another, ensuring accurate financial calculations. |
| UserConversionType | String | The type of conversion applied to the transaction, such as manual or system-generated, providing clarity on the conversion process used. |
| Finder | String | A reference or search term associated with the transaction, used for tracking and identifying specific entries in the system. |
| SourceBudget | String | The original or source budget from which funds are being allocated or transferred, helping to trace the origin of the transaction within the budgetary framework. |