ODBC Driver for Blackbaud Raisers Edge NXT

Build 24.0.9062

GiftPayments

Returns payments for a gift.

Table Specific Information

Select

The 本製品 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 本製品.

  • GiftId supports the '=' operator.
For example:
	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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062