GiftAcknowledgements
Returns a list of acknowledgements for a gift
Table Specific Information
Select
The connector will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.
- GiftId supports the '=' operator.
SELECT * FROM GiftAcknowledgements SELECT * FROM GiftAcknowledgements WHERE GiftId = '476'
Columns
| Name | Type | References | Description |
| GiftId | String |
Gifts.Id | The immutable system record ID of the gift associated with the acknowledgement. |
| Date | Datetime | The date associated with the acknowledgement. | |
| Letter | String | The letter associated with the acknowledgement. | |
| Status | String | The status of the acknowledgement. Available values are: ACKNOWLEDGED, NEEDSACKNOWLEDGEMENT, and DONOTACKNOWLEDGE. |