UFN_GIFTAIDREVENUESPLIT_CALCULATEGROSSAMOUNT_2

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

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@ACTUALONLY	bit	IN
@CURRENCYTYPE	tinyint	IN

Definition

Copy



            CREATE function dbo.UFN_GIFTAIDREVENUESPLIT_CALCULATEGROSSAMOUNT_2(
                @ID uniqueidentifier,
                @ACTUALONLY bit,
                @CURRENCYTYPE tinyint -- 0 = Base, 1 = Transaction, 2 = Organization

            )
              returns money
              with execute as caller
              as begin
                declare @GROSSAMOUNT money;

                select    
                    @GROSSAMOUNT = case @CURRENCYTYPE 
                                     when 0 then FINANCIALTRANSACTION.BASEAMOUNT
                                     when 1 then FINANCIALTRANSACTION.TRANSACTIONAMOUNT
                                     when 2 then FINANCIALTRANSACTION.ORGAMOUNT
                                   end
                from
                    dbo.FINANCIALTRANSACTION
                where 
                    ID = @ID;

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

                return @GROSSAMOUNT;
              end