BudgetDetails
Returns the specified budget details.
The connector will use the Blackbaud Financial Edge NXT API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.
- BudgetScenarioId supports the '=' operator. This the only supported column.
SELECT * FROM BudgetDetails WHERE BudgetScenarioId = 123
Columns
| Name | Type | References | Description |
| BudgetScenarioId [KEY] | Integer |
Budgets.BudgetScenarioId | The scenario id for this budget. |
| ScenarioId | String | The scenario id for this budget scenario. | |
| BudgetType | String | The budget type for this budget.
The allowed values are FiscalYear, PeriodRange. | |
| Status | String | The status of this budget.
The allowed values are Active, Inactive. | |
| Description | String | The description for this budget. | |
| Locked | Boolean | The status of the lock for this budget. | |
| StartFiscalYear | String | The start fiscal year for this budget. | |
| EndFiscalYear | String | The end fiscal year for this budget. | |
| StartFiscalPeriod | Integer | The start fiscal period for this budget. | |
| EndFiscalPeriod | Integer | The end fiscal period for this budget. | |
| TotalExpense | Decimal | The total expense for this budget. | |
| TotalRevenue | Decimal | The total revenue for this budget. | |
| DateAdded | Datetime | The date this budget was added. | |
| AddedBy | String | The name of who added this budget. | |
| DateModified | Datetime | The date this budget was modified. | |
| ModifiedBy | String | The name of who modified this budget. |