GiftAcknowledgements
Returns a list of acknowledgements for a gift
Table Specific Information
Select
The driver 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 driver.
Note: GiftId are required in order to query GiftAcknowledgements.
- GiftId supports the '=' operator.
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. |