BudgetLines
Returns the specified budget lines.
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 BudgetLines WHERE BudgetScenarioId = 123
Columns
| Name | Type | References | Description |
| BudgetScenarioId [KEY] | Integer |
Budgets.BudgetScenarioId | The scenario id for this budget. |
| BudgetLineId [KEY] | Integer | The budget line ID. | |
| AccountNumber | String |
Accounts.AccountNumber | The number for an account on this budget. |
| AccountDescription | String | The description for an account on this budget. | |
| UiProjectId | String | The user defined project id for this budget line. | |
| ProjectDescription | String | The description for a project on this budget line. | |
| Notes | String | The note for this budget line. | |
| GrantDescription | String | The description of the {Grant} t-code. | |
| Total | Decimal | The total amount for this budget line. | |
| Periods | String | The period distributions for this budget line. |