UFN_GIFTAIDREVENUESPLIT_CALCULATESPLITGROSSAMOUNT

Calculates the gross amount of a single payment application, 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_CALCULATESPLITGROSSAMOUNT
      (
      @ID uniqueidentifier,
      @ACTUALONLY bit
      )
      returns money
      with execute as caller
      as begin
        declare @GROSSAMOUNT money;

        select @GROSSAMOUNT = FINANCIALTRANSACTIONLINEITEM.BASEAMOUNT
        from dbo.FINANCIALTRANSACTIONLINEITEM
        inner join dbo.REVENUESPLIT_EXT on FINANCIALTRANSACTIONLINEITEM.ID = REVENUESPLIT_EXT.ID
        where FINANCIALTRANSACTIONLINEITEM.ID = @ID
            and FINANCIALTRANSACTIONLINEITEM.TYPECODE != 1
            and FINANCIALTRANSACTIONLINEITEM.DELETEDON is null;

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

        return @GROSSAMOUNT;
      end