UFN_PLANNEDGIFTADDITION_GETBALANCE

Returns the remaining balance on a planned gift addition.

Return

Return Type
money

Parameters

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

Definition

Copy



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

              select @PLANNEDGIFTADDITIONREVENUEID = REVENUEID
              from dbo.PLANNEDGIFTADDITIONREVENUE
              where PLANNEDGIFTADDITIONREVENUE.ID = @ID

              if @PLANNEDGIFTADDITIONREVENUEID is null
                return null;

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

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

              return @BALANCE
          end