ODBC Driver for Blackbaud Financial Edge NXT

Build 20.0.7587

TransactionDistributions

Returns a list of transactions matching the search criteria

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, AccountNumber , UiProjectId , TypeCode , Encumbrance, Journal, and PostStatus support the '=' operator. A blank search is not supported.
  • PostDate supports the following operators : <,<=,=,>=,>.
  • DateModified supports the following operators : >,>=.
For example, the following queries are processed server side:
SELECT * FROM TransactionDistributions WHERE BatchId = 123 AND PostDate < '2010-01-01 10:10:10'
SELECT * FROM TransactionDistributions WHERE AccountNumber = 'abc' AND Journal = 'def' AND PostDate <= '2010-01-01 10:10:10'
SELECT * FROM TransactionDistributions WHERE UiProjectId = 'abc' AND PostStatus = 'def' AND PostDate = '2010-01-01 10:10:10'
SELECT * FROM TransactionDistributions WHERE TypeCode = 'abc' AND DateModified > '2010-01-01 08:10:10' AND PostDate >= '2010-01-01 10:10:10'
SELECT * FROM TransactionDistributions WHERE Encumbrance = 'abc' AND PostDate > '2010-01-01 10:10:10'
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
DistributionId [KEY] Integer The distribution identifier.
TransactionId [KEY] Integer The transaction identifier.
TransactionAmount Double The transaction amount.
BatchId Integer

JournalEntryBatches.BatchId

The batch identifier
DistributionAmount Double The distribution amount.
AccountNumber String

Accounts.AccountNumber

The account number.
AccountClass String The account class.
UiProjectId String The project user-visible identifier.
PostDate Datetime The transaction post date.
TypeCode String The transaction type (debit or credit).

The allowed values are Debit, Credit.

Reference String The transaction reference.
Encumbrance String The transaction encumbrance type.
Journal String The full name of the journal.
TransactionCodeValues String The distribution transaction codes.
DateAdded Datetime The created date of the transaction distribution.
AddedBy String The creator of the transaction distribution.
DateModified Datetime The modified date of the transaction distribution.
ModifiedBy String The modifier of the transaction distribution.
PostStatus String The post status of the transaction distribution.

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