UFN_RECURRINGGIFT_GETREVALUEDORGANIZATIONBALANCEASOF

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

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

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

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

                set @RESULT =   dbo.UFN_CURRENCY_CONVERTTOORGANIZATIONCURRENCY(
                                    @BASEBALANCE,
                                    @ORGANIZATIONEXCHANGERATEID,
                                    @TRANSACTIONBALANCE
                                );

                return @RESULT;
            end