Returns the list of cash management distribution sets and their line items.
The connector 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 connector.
- SetId supports the '=' operator. This the only supported column.
Select * FROM CashManagementDistributionSets WHERE SetId = 123You 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.
|SetId [KEY]||Integer||The identifier of the cash management distribution set.|
|Name||String||The name of the cash management distribution set.|
|LineItemPercent||Double||The percentage of the total distribution set the line item represents.|
|LineItemRowNumber||Integer||The row number for the line item.|
|LineItemAccountId||String||The identifier of the account for the line item.|