UFN_DESIGNATION_GETPLEDGEBALANCE

Returns the unpaid pledge balance 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_GETPLEDGEBALANCE
            (
                @DESIGNATIONID uniqueidentifier,
                @STARTDATE datetime = null,
                @ENDDATE datetime = null,
                @ROLLUPTOTAL bit = 0
            ) 
            returns money
            with execute as caller
            as begin                
                declare @RESULT money = 0;

                select @RESULT =  dbo.UFN_DESIGNATION_GETPLEDGEBALANCE_INCURRENCY(
                        @DESIGNATIONID,
                        @STARTDATE,
                        @ENDDATE,
                        @ROLLUPTOTAL,
                        dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY())

                return @RESULT

            end