JDBC Driver for Blackbaud Financial Edge NXT

Build 21.0.7930


Returns the list of journal entry batches.

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.

  • BatchId supports the '=' operator. This column is filtered serverside when it is the only specified filter in the criteria.
For example, the following query is processed server side:
Select * FROM JournalEntryBatches WHERE BatchId = 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.


Name Type References Description
BatchId [KEY] Integer The batch identifier.
UiBatchId String The batch user-visible identifier.
Description String The batch description.
BatchStatus String The batch status.
CreateInterfundSets Boolean Indicates if or not the batch should create interfund entries when posted.
CreateBankAccountAdjustments Boolean Indicates if or not the batch should create bank account admustments when posted.
DateAdded Datetime The created date of the batch.
AddedBy String The creator of the batch.
DateModified Datetime The modified date of the batch.
ModifiedBy String The modifier of the batch.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930