MuleSoft Connector for Blackbaud Financial Edge NXT

Build 20.0.7587

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.
For example, the following query is processed server side:
Select * FROM BudgetLines WHERE BudgetScenarioId = 123 
You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will result in unfiltered data being pushed.

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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587