BudgetProjects
Returns details for every fiscal period and project in scenario.
The driver 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 driver.
- BudgetScenarioId, UiProjectId support the '=' operator. A blank search is not supported.
SELECT * FROM BudgetProjects WHERE BudgetScenarioId = 123 SELECT * FROM BudgetProjects WHERE BudgetScenarioId = 123 AND UiProjectId = 'abc'
Columns
| Name | Type | References | Description |
| BudgetScenarioId [KEY] | Integer |
Budgets.BudgetScenarioId | The scenario id for this budget. |
| UiProjectId [KEY] | String | The user-visible identifier of the project. | |
| BudgetCategory | String | The budget category for this period. | |
| FiscalYear | String |
FiscalYears.Year | The fiscal year for this period. |
| FiscalPeriodId | Integer |
FiscalYears.FiscalPeriodId | The fiscal period. |
| AccountNumber | String |
Accounts.AccountNumber | The account number for this period. |
| PeriodAmount | Decimal | The amount for this period. | |
| TotalAmount | Decimal | The total amount for this period. | |
| PeriodPercent | Double | The percent for this period. |