USP_RECURRINGPAYMENT_EDIT

Stored proc to update the recurring gift payment specific information.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@AMOUNT	money	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN

Definition

Copy



            create procedure dbo.USP_RECURRINGPAYMENT_EDIT
            (
                @ID uniqueidentifier,
                @AMOUNT money = 0,
                @CHANGEAGENTID uniqueidentifier,
                @CHANGEDATE datetime
            )
            as 
            set nocount on;

            update dbo.RECURRINGGIFTACTIVITY
                set AMOUNT = @AMOUNT,
                [CHANGEDBYID] = @CHANGEAGENTID,
                [DATECHANGED] = @CHANGEDATE
            where PAYMENTREVENUEID = @ID;