JDBC Driver for Blackbaud Raisers Edge NXT

Build 22.0.8462

GiftPayments

Returns payments 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 GiftPayments.

  • GiftId supports the '=' operator.
For example:
	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 String The day of the check date. Only applies to payment method of PersonalCheck.
CheckDateM String The month of the check date. Only applies to payment method of PersonalCheck.
CheckDateY String 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 String The day of the reference date.
ReferenceDateM String The month of the reference date.
ReferenceDateY String The year of the reference date.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462