MuleSoft Connector for Blackbaud Financial Edge NXT

Build 20.0.7587

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.
For example, the following query is processed server side:
Select * FROM BudgetDetails 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.
ScenarioId String

Budgets.ScenarioId

The scenario id for this budget scenario.
BudgetType String The budget type for this budget.
Status String The status of this budget.
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 Double The total expense for this budget.
TotalRevenue Double 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.

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