SSIS Components for Blackbaud Raisers Edge NXT

Build 21.0.7930

UpdateGiftReceipt

Edits a gift receipt

Stored Procedures Specific Information

Process of Update Gift Receipt

BlackBaud Raiser's Edge NXT allows only a small subset of columns to be used in the Exec query. These columns can typically be used with only = comparison. The available columns for UpdateGiftReceipt are ReceiptId, Amount, Date, Number and Status. For example:

EXECUTE UpdateGiftReceipt ReceiptId = '372', Amount = 0.0, Date = '2018-12-31T00:00:00', Number = 123456, Status = 'Receipted'

Input

Name Type Required Description
ReceiptId String True The immutable system record ID of the gift receipt to edit. It uses the parent gift's ID as its value.
Amount Double True The amount of the receipt.
Date String True The date on the receipt
Number Integer True The number of the receipt.
Status String True The receipt status of the gift. Available values are: RECEIPTED, NEEDSRECEIPT, and DONOTRECEIPT. When receipt_status is set to NEEDSRECEIPT or DONOTRECEIPT, receipt_date should be null.

Result Set Columns

Name Type Description
Success String Execution status of the stored procedure

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930