UFN_GIFTAIDREVENUESPLIT_CALCULATEGROSSAMOUNT

Calculates the gross amount of all applications of a payment, which includes gift aid.

Return

Return Type
money

Parameters

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

Definition

Copy



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

        select @GROSSAMOUNT = AMOUNT
        from dbo.REVENUE
        where ID = @ID;

        set @GROSSAMOUNT = @GROSSAMOUNT + dbo.UFN_GIFTAIDREVENUESPLIT_GETTAXCLAIMAMOUNT(@ID, @ACTUALONLY);

        return @GROSSAMOUNT;
      end