UFN_GIFTAIDREVENUESPLIT_GETSPLITTAXCLAIMAMOUNT

Returns the tax claim amount from the REVENUESPLITGIFTAID record with the given ID.

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN
@ACTUALONLY	bit	IN

Definition

Copy



            CREATE function dbo.UFN_GIFTAIDREVENUESPLIT_GETSPLITTAXCLAIMAMOUNT
      (
      @ID uniqueidentifier,
      @ACTUALONLY bit
      )
      returns money
      with execute as caller
      as begin
        declare @TAXCLAIMAMOUNT money;

        select @TAXCLAIMAMOUNT = TAXCLAIMAMOUNT
        from dbo.UFN_REVENUESPLITGIFTAID_GETELIGIBLE(@ACTUALONLY) REVENUESPLITGIFTAID
        where REVENUESPLITGIFTAID.ID = @ID

        if @TAXCLAIMAMOUNT is null
          return 0;

        return @TAXCLAIMAMOUNT;
      end