USP_SAVE_GIFTFEEADJUSTMENT

Stored procedure to log adjustments to gift fees.

Parameters

Parameter	Parameter Type	Mode
@REVENUEID	uniqueidentifier	IN
@ADJUSTMENTID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN
@DATE	datetime	IN
@POSTDATE	datetime	IN
@ADJUSTMENTREASON	nvarchar(300)	IN
@ISNEWREVENUE	bit	IN
@ADJUSTMENTREASONCODEID	uniqueidentifier	IN
@POSTSTATUSCODE	tinyint	IN

Definition

Copy



CREATE procedure dbo.USP_SAVE_GIFTFEEADJUSTMENT
(
    @REVENUEID uniqueidentifier = null,
    @ADJUSTMENTID uniqueidentifier = null output,
    @CHANGEAGENTID uniqueidentifier = null,
    @CHANGEDATE datetime = null,
    @DATE datetime = null,
    @POSTDATE datetime = null,
    @ADJUSTMENTREASON nvarchar(300) = null,
    @ISNEWREVENUE bit = 0,
    @ADJUSTMENTREASONCODEID uniqueidentifier = null,
    @POSTSTATUSCODE tinyint = 1
)
with execute as owner
as
/*call this procedure before making changes to the revenue tables.*/

set nocount on;

    exec dbo.USP_SAVE_GIFTFEEADJUSTMENT_2
        @REVENUEID,
        @ADJUSTMENTID,
        @CHANGEAGENTID,
        @CHANGEDATE,
        @DATE,
        @POSTDATE,
        @ADJUSTMENTREASON,
        @ISNEWREVENUE,
        @ADJUSTMENTREASONCODEID,
        @POSTSTATUSCODE