UFN_PLANNEDGIFTREVENUE_GETCURRENCYIDFROMCODE

Returns the the planned gift revenue's currency ID if it exists, otherwise returns the planned gift's currency ID.

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode
@PLANNEDGIFTID	uniqueidentifier	IN
@CURRENCYCODE	int	IN
@DEFAULTCURRENCYID	uniqueidentifier	IN

Definition

Copy



          create function dbo.UFN_PLANNEDGIFTREVENUE_GETCURRENCYIDFROMCODE
          (
            @PLANNEDGIFTID uniqueidentifier,
            @CURRENCYCODE int = 2,
            @DEFAULTCURRENCYID uniqueidentifier = null
          )
          returns uniqueidentifier
          with execute as caller
          as begin
              declare @DISPLAYCURRENCYID uniqueidentifier;

              select @DISPLAYCURRENCYID = 
                case @CURRENCYCODE
                  when 2 then coalesce(REVENUE.TRANSACTIONCURRENCYID, PG.TRANSACTIONCURRENCYID)
                  when 0 then coalesce(REVENUE.BASECURRENCYID, PG.BASECURRENCYID)
                  else @DEFAULTCURRENCYID
                end
              from dbo.PLANNEDGIFT PG
              left join dbo.PLANNEDGIFTREVENUE PGR on PG.ID = PGR.ID
              left join dbo.REVENUE on PGR.REVENUEID = REVENUE.ID
              where PG.ID = @PLANNEDGIFTID

              return @DISPLAYCURRENCYID
          end