UFN_DESIGNATION_GETTOTALRECEIVED

Returns the total amount received for a given designation.

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode
@DESIGNATIONID	uniqueidentifier	IN
@STARTDATE	datetime	IN
@ENDDATE	datetime	IN
@ROLLUPTOTAL	bit	IN

Definition

Copy



            CREATE function dbo.UFN_DESIGNATION_GETTOTALRECEIVED
            (
                @DESIGNATIONID uniqueidentifier,
                @STARTDATE datetime = null,
                @ENDDATE datetime = null,
                @ROLLUPTOTAL bit = 0
            ) 
            returns money
            with execute as caller
            as begin
                declare @RESULT money = 0;
                declare @DESIGNATIONLEVEL1ID uniqueidentifier = null;
                set @DESIGNATIONLEVEL1ID = (select DESIGNATIONLEVEL1ID from dbo.DESIGNATION where ID = @DESIGNATIONID);

                select @RESULT = dbo.UFN_DESIGNATION_GETTOTALRECEIVED_INCURRENCY(
                        case when @ROLLUPTOTAL = 1 then @DESIGNATIONLEVEL1ID else @DESIGNATIONID end,
                        @STARTDATE,
                        @ENDDATE,
                        @ROLLUPTOTAL,
                        dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY())

                return @RESULT

            end