ODBC Driver for Blackbaud Financial Edge NXT

Build 24.0.9062

BudgetAccounts

Returns details for every fiscal period and account in scenario.

The 本製品 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 本製品.

  • BudgetScenarioId, AccountNumber support the '=' operator. A blank search is not supported.
For example, the following queries are processed server side:
SELECT * FROM BudgetAccounts WHERE BudgetScenarioId = 123
SELECT * FROM BudgetAccounts WHERE BudgetScenarioId = 123 AND AccountNumber = 'abc' 

Columns

Name Type References Description
BudgetScenarioId [KEY] Integer

Budgets.BudgetScenarioId

The scenario id for this budget.
AccountNumber [KEY] String

Accounts.AccountNumber

The account number for this period.
BudgetCategory String The budget category for this period.
FiscalYear String

FiscalYears.Year

The fiscal year for this period.
FiscalPeriodId Integer

FiscalYears.FiscalPeriodId

The fiscal period.
PeriodPercent Double The percent for this period.
PeriodAmount Decimal The amount for this period.
TotalAmount Decimal The total amount for this period.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062