UFN_RECURRINGGIFT_GETBALANCEASOF

Returns the balance of total payments made to a recurring gift as of a given date.

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode	Description
@RECURRINGID	uniqueidentifier	IN
@ASOFDATE	datetime	IN

Definition

Copy



            CREATE function dbo.UFN_RECURRINGGIFT_GETBALANCEASOF
            (
                @RECURRINGID uniqueidentifier,
                @ASOFDATE datetime
            ) 
            returns money
            with execute as caller
            as begin
                declare @RESULT money;

                select 
                    @RESULT = sum(RECURRINGGIFTACTIVITY.AMOUNT)
                from 
                    dbo.RECURRINGGIFTACTIVITY
                inner join dbo.REVENUESPLIT
                    on REVENUESPLIT.ID = RECURRINGGIFTACTIVITY.PAYMENTREVENUEID
                inner join dbo.REVENUE
                    on REVENUE.ID = REVENUESPLIT.REVENUEID
                where 
                    RECURRINGGIFTACTIVITY.SOURCEREVENUEID = @RECURRINGID
                    and REVENUE.DATE <= @ASOFDATE

                return @RESULT;
            end