ODBC Driver for Blackbaud Financial Edge NXT

Build 20.0.7587

JournalEntries

Retrieve and query journal entries.

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 the only supported column.
For example, the following query is processed server side:
Select * FROM JournalEntries 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.

Columns

Name Type References Description
JournalEntryId [KEY] Integer The journal entry identifier.
BatchId Integer The batch identifier.
AccountNumber String The journal entry account number.
TypeCode String The journal entry transaction type (debit or credit).
Journal String The full name of the journal.
LineNumber Integer The journal entry line number.
Reference String The journal entry reference.
PostDate Datetime The journal entry post date, in ISO 8601 format: 2016-03-14.
Amount Double The journal entry amount.
Notes String The journal entry notes.
Encumbrance String The journal entry encumbrance type.
Distributions String The journal entry distributions.
CustomFields String Custom field : The list of custom fields supported as distict columns.

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