Excel Add-In for Blackbaud Financial Edge NXT

Build 24.0.9060

JournalEntryBatches

Returns the list of journal entry batches.

The add-in 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 add-in.

  • 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

Columns

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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060