ODBC Driver for Blackbaud Financial Edge NXT

Build 20.0.7587

CashManagementDistributionSetLineItemProjects

The project distribution for the line items in the cash management distribution sets .

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.

  • SetId supports the '=' operator. This the only supported column.
For example, the following query is processed server side:
Select * FROM CashManagementDistributionSetLineItemProjects WHERE SetId = 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
SetId [KEY] Integer

CashManagementDistributionSets.SetId

The identifier of the cash management distribution set.
ProjectId [KEY] Integer The identifier of the project for the line item.
LineNumber Integer The line number for the line item.
Percent Double The pecentage the distribution the line item represents.
AccountClass String The class of the account for the line item.

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