SSIS Components for Blackbaud Raisers Edge NXT

Build 21.0.7930

GiftPayments

Returns payments for a gift.

Table Specific Information

Select

The component 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 component.
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) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930