ODBC Driver for Blackbaud Financial Edge NXT

Build 20.0.7587

PeriodSummaries

Once the summarization process is complete, this is how you get data returned.

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

  • FiscalYear, FiscalPeriod, AccountNumber and UiProjectId support the '=' operator. A blank search is not supported.
For example, the following query is processed server side:
SELECT * FROM PeriodSummaries WHERE FiscalYear = 'year' AND FiscalPeriod = 'period' AND  AccountNumber = 'abc' AND UiProjectId = 'def' 
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
FiscalYear String

FiscalYears.Year

The summarized fiscal year.
FiscalPeriod String

FiscalYears.FiscalPeriod

The summarized fiscal period.
AccountNumber String

Accounts.AccountNumber

The account number of summarized transactions.
UiProjectId String The project identifier of summarized transactions.
PeriodStartDate Datetime The start date of the summarized period.
PeriodEndDate Datetime The end date of the summarized period.
TransactionCodes String The transaction code values of summarized transactions.
BeginningBalance Double The total transaction balance at the beginning of the summarized period.
Debit Double The sum of transaction debits int he summarized period.
Credit Double The sum of transaction credits int he summarized period.
EncumberedBeginningBalance Double The encumbered transaction balance at the beginning of the summarized period.
EncumberedCredit Double The sum of encumbered transaction credits int he summarized period.
EncumberedDebit Double The sum of encumbered transaction debits int he summarized period.

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