BudgetaryControlResults
Shows results of budgetary control checks, helping users identify whether labor schedules or requisitions exceed set budgets.
Columns
| Name | Type | Description |
| TransactionNumber | String | The unique identifier for the transaction within the BudgetaryControlResults table, used for tracking and referencing specific financial transactions. |
| EnteredAmount | Decimal | The amount of the transaction as entered by the user, representing the original monetary value before any currency conversion or adjustments. |
| EnteredCurrency | String | The currency in which the entered amount is denominated, indicating the original currency used for the transaction. |
| Amount | Decimal | The adjusted amount of the transaction after currency conversion, representing the final value in the system's base currency. |
| CurrencyCode | String | The code of the currency used for the transaction, which helps identify the currency type (for example, USD, EUR). |
| ControlBudgetId | Long | The unique identifier for the control budget associated with the transaction, used to track budget limits and allocations. |
| Name | String | The descriptive name or title associated with the BudgetaryControlResults entry, often representing the financial item or transaction. |
| PeriodName | String | The name of the period (for example, fiscal quarter or year) to which the transaction pertains, allowing for financial reporting by time. |
| BudgetCcid | Long | The unique identifier for the budget control center (CCID) linked to the transaction, which helps define the financial responsibility area. |
| ConversionDate | Date | The date on which currency conversion took place, used to determine the exchange rate applied to the transaction at that time. |
| ConversionRate | Decimal | The rate at which the entered amount was converted into the system's base currency, reflecting the exchange rate used during the conversion. |
| UserConversionType | String | The type of currency conversion applied by the user, providing context for how the conversion rate was selected or applied. |
| SourceHeaderId1 | String | The first identifier for the source header of the transaction, used to link the entry to the originating document or transaction source. |
| SourceHeaderId2 | String | The second identifier for the source header of the transaction, providing additional context or linkage to the original source. |
| SourceLineId1 | String | The first identifier for the source line of the transaction, connecting the entry to a specific line item in the source document. |
| SourceLineId2 | String | The second identifier for the source line of the transaction, further identifying a specific line item or part of the source document. |
| SourceLineId3 | String | The third identifier for the source line of the transaction, providing additional granularity for referencing detailed components of the source document. |
| SourceLineId4 | String | The fourth identifier for the source line of the transaction, offering further segmentation of the source document's line items. |
| SourceLineId5 | String | The fifth identifier for the source line of the transaction, adding further specificity when referencing detailed components of the source document. |
| DataSetId | Long | The unique identifier for the dataset associated with the transaction, used for grouping and organizing financial records within the system. |
| TransactionTypeCode | String | A code that identifies the type of transaction (for example, budget adjustment, allocation, or commitment), providing context for its purpose within the budgetary system. |
| DraftFlag | Bool | A flag indicating whether the transaction is in a draft status, allowing users to track entries before finalizing them for official processing. |
| ResultCode | String | The code that represents the outcome or status of the transaction, indicating whether it was successful, failed, or requires further review. |
| BudgetAccount | String | The identifier for the specific budget account involved in the transaction, used to assign the transaction to the correct budget category. |
| FundsConsumed | String | The amount of funds that have been consumed from the budget, showing how much of the allocated funds have been used by the transaction. |
| Status | String | The current status of the transaction (for example, pending, completed, or rejected), providing insight into its processing stage or approval state. |
| BalanceType | String | The type of balance associated with the transaction (for example, actual, forecasted, or budgeted), used to differentiate between various financial calculations. |
| ProjectBurden | String | The burden or cost associated with the project linked to the transaction, often used in the context of project-based financial tracking. |
| BudgetManager | String | The name or identifier of the person responsible for managing the budget associated with the transaction, providing accountability for budget oversight. |
| Finder | String | A unique identifier or reference used for searching or locating specific BudgetaryControlResults entries, typically used in query or reporting tools. |