BizTalk Adapter for Blackbaud Financial Edge NXT

Build 20.0.7587

TransactionDistributionSets

Returns the list of transaction distribution sets.

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

  • SetId supports the '=' operator. This column is the only supported filter.
For example, the following query is processed server side:
SELECT * FROM TransactionDistributionSets WHERE SetId = 1 
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
SetId [KEY] Integer The identifier for the transaction distribution set.
Name String The name of the transaction distribution set.
LineNumber [KEY] Integer The line item number.
LineItemPercent Double The percentage of the total distribution set the line item represents.
LineItemProjectId Integer The identifier of the project for the line item.
LineItemAccountClass String The class of the account for the line item.
LineItemTransactionCodeValues String The transaction code values for the line item.

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