BudgetFiscalPeriods
Returns details for every fiscal period in a budget 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 supports the '=' operator. This the only supported column.
SELECT * FROM BudgetFiscalPeriods WHERE BudgetScenarioId = 123
Columns
| Name | Type | References | Description |
| BudgetScenarioId [KEY] | Integer |
Budgets.BudgetScenarioId | The scenario id for this budget. |
| Category [KEY] | String | The budget category for this period. | |
| FiscalYear | String |
FiscalYears.Year | The fiscal year of this period. |
| FiscalPeriodId [KEY] | Integer |
FiscalYears.FiscalPeriodId | The fiscal period. |
| PeriodAmount | Decimal | The amount for this period. | |
| TotalAmount | Decimal | The total amount for this period. |