TransactionDistributionSets
Returns the list of transaction distribution sets.
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 column is the only supported filter.
SELECT * FROM TransactionDistributionSets WHERE SetId = 1
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. |