UFN_RECURRINGGIFT_GETREVALUEDBASEBALANCEASOF

Returns the balance of total payments made to a recurring gift, as a revalued base currency amount, 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_GETREVALUEDBASEBALANCEASOF
            (
                @RECURRINGID uniqueidentifier,
                @ASOFDATE datetime
            ) 
            returns money
            with execute as caller
            as begin
                declare @RESULT money;
                declare @REVALUATIONID uniqueidentifier;
                declare @BASEEXCHANGERATEID uniqueidentifier;

                set @REVALUATIONID = dbo.UFN_REVENUE_GETREVALUATIONASOF(@RECURRINGID, @ASOFDATE);

                select @BASEEXCHANGERATEID = BASEEXCHANGERATEID
                from dbo.COMMITMENTREVALUATION
                where ID = @REVALUATIONID;

                set @RESULT =   dbo.UFN_CURRENCY_CONVERT(
                                    dbo.UFN_RECURRINGGIFT_GETBALANCEASOF(@RECURRINGID, @ASOFDATE),
                                    @BASEEXCHANGERATEID
                                );

                return @RESULT;
            end