USP_GIFTAIDDISQUALIFICATION_BY_ATTRIBUTE_ADD

Adds a revenue attribute that is disqualified for Gift Aid.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CODETABLEVALUE	uniqueidentifier	IN
@CURRENCYVALUE	money	IN
@CONSTITUENTID	uniqueidentifier	IN
@DATEVALUE	datetime	IN
@FUZZYDATEVALUE	UDT_FUZZYDATE	IN
@MEMOVALUE	nvarchar(max)	IN
@NUMBERVALUE	int	IN
@TEXTVALUE	nvarchar(255)	IN
@HOURMINUTEVALUE	UDT_HOURMINUTE	IN
@BOOLEANVALUE	tinyint	IN
@ATTRIBUTECATEGORYID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@DATATYPE	smallint	IN

Definition

Copy



        CREATE procedure dbo.USP_GIFTAIDDISQUALIFICATION_BY_ATTRIBUTE_ADD
        (
        @ID uniqueidentifier = null,
        @CODETABLEVALUE uniqueidentifier = null,
        @CURRENCYVALUE money = 0,
        @CONSTITUENTID uniqueidentifier = null,
        @DATEVALUE datetime = null,
        @FUZZYDATEVALUE dbo.UDT_FUZZYDATE = '00000000',
        @MEMOVALUE nvarchar(max) = '',
        @NUMBERVALUE int = 0,
        @TEXTVALUE nvarchar(255) = '',
        @HOURMINUTEVALUE dbo.UDT_HOURMINUTE = '',
        @BOOLEANVALUE tinyint = 0,
        @ATTRIBUTECATEGORYID uniqueidentifier = null,
        @CHANGEAGENTID uniqueidentifier = null,
        @DATATYPE smallint = 0
        )
        as

        set nocount on;

        declare @CURRENTDATE datetime;

        if @ID is null
          set @ID = newid();

        if @CHANGEAGENTID is null
          exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

        set @CURRENTDATE = getdate();

        begin try
          insert into dbo.GIFTAIDDISQUALIFIEDBYATTRIBUTE
            (ID,CODETABLEVALUE,CURRENCYVALUE,CONSTITUENTID,DATEVALUE,FUZZYDATEVALUE,MEMOVALUE,NUMBERVALUE,TEXTVALUE,HOURMINUTEVALUE,BOOLEANVALUE,ATTRIBUTECATEGORYID,DATATYPE,CHANGEDBYID,ADDEDBYID,DATEADDED,DATECHANGED)
          values
            (@ID,@CODETABLEVALUE,@CURRENCYVALUE,@CONSTITUENTID,@DATEVALUE,@FUZZYDATEVALUE,@MEMOVALUE,@NUMBERVALUE,@TEXTVALUE,@HOURMINUTEVALUE,@BOOLEANVALUE,@ATTRIBUTECATEGORYID,@DATATYPE,@CHANGEAGENTID,@CHANGEAGENTID,@CURRENTDATE,@CURRENTDATE)
        end try

          begin catch
              exec dbo.USP_RAISE_ERROR;
              return 1;

          end catch

        return 0;