BizTalk Adapter for Blackbaud Financial Edge NXT

Build 20.0.7587

BudgetFiscalPeriods

Returns details for every fiscal period in a budget scenario.

The adapter 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 adapter.

  • BudgetScenarioId supports the '=' operator. This the only supported column.
For example, the following query is processed server side:
Select * FROM BudgetFiscalPeriods 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.
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.

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