GiftReceipts
Returns receipts 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 GiftReceipts.
- GiftId supports the '=' operator.
SELECT * FROM GiftReceipts WHERE GiftId = '476'
Columns
| Name | Type | References | Description |
| GiftId | String |
Gifts.Id | The immutable system record ID of the gift associated with the receipt. |
| AmountValue | Integer | The amount of the receipt. | |
| Date | Datetime | The date on the receipt. | |
| Number | Integer | The number of the receipt. | |
| Status | String | The status of the receipt. Available values are: RECEIPTED, NEEDSRECEIPT, and DONOTRECEIPT. |