UFN_PLANNEDGIFT_GETBALANCE

Returns the remaining balance on a planned gift.

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CURRENCYID	uniqueidentifier	IN
@CURRENCYCODE	tinyint	IN

Definition

Copy



          CREATE function dbo.UFN_PLANNEDGIFT_GETBALANCE
          (
            @ID uniqueidentifier,
            @CURRENCYID uniqueidentifier,
            @CURRENCYCODE tinyint = 2
          )
          returns money
          with execute as caller
          as begin
              declare @BALANCE money = 0;
              declare @PLANNEDGIFTREVENUEID uniqueidentifier;
              declare @DISPLAYCURRENCYID uniqueidentifier;

              select @PLANNEDGIFTREVENUEID = REVENUEID
              from dbo.PLANNEDGIFTREVENUE
              where PLANNEDGIFTREVENUE.ID = @ID

              if @PLANNEDGIFTREVENUEID is null
                return null;

              select @DISPLAYCURRENCYID = dbo.UFN_PLANNEDGIFTREVENUE_GETCURRENCYIDFROMCODE(@ID, @CURRENCYCODE, @CURRENCYID)

              set @BALANCE = dbo.UFN_PLEDGE_GETREVALUEDBALANCEASOFINCURRENCY
              (
                  @PLANNEDGIFTREVENUEID,
                  getdate(),
                  0,
                  @DISPLAYCURRENCYID
              )

              return @BALANCE
          end