GiftPayments
Returns payments for a gift.
Table Specific Information
Select
The add-in 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 add-in.
- GiftId supports the '=' operator.
SELECT * FROM GiftPayments SELECT * FROM GiftPayments WHERE GiftId = '476'
Columns
| Name | Type | References | Description |
| GiftId | String |
Gifts.Id | The immutable system record ID of the gift associated with the payment. |
| AccountToken | String | The tokenized account information (e.g. credit card) from the external payment provider. Only applies to payment methods of CreditCard and DirectDebit. | |
| BbpsConfigurationId | String | The bbps configuration ID. Only applies to payment methods of CreditCard and DirectDebit. | |
| BbpsTransactionId | String | The bbps transaction ID. Only applies to payment methods of CreditCard and DirectDebit. | |
| CheckDateD | Integer | The day of the check date. Only applies to payment method of PersonalCheck. | |
| CheckDateM | Integer | The month of the check date. Only applies to payment method of PersonalCheck. | |
| CheckDateY | Integer | The year of the check date. Only applies to payment method of PersonalCheck. | |
| CheckNumber | String | The check number. Only applies to payment method of PersonalCheck. | |
| CheckoutTransactionId | String | The checkout transaction ID. Only applies to payment methods of CreditCard and DirectDebit. | |
| PaymentMethod | String | The payment method. | |
| Reference | String | The reference. | |
| ReferenceDateD | Integer | The day of the reference date. | |
| ReferenceDateM | Integer | The month of the reference date. | |
| ReferenceDateY | Integer | The year of the reference date. |