UFN_CURRENCYEXCHANGERATE_GETDESCRIPTION

Function used get the information required to display exchange rate descriptions.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BASEEXCHANGERATEID	uniqueidentifier	IN

Definition

Copy



      create function dbo.UFN_CURRENCYEXCHANGERATE_GETDESCRIPTION
      (
        @BASEEXCHANGERATEID uniqueidentifier
      )
      returns table
                as return (
              select
                    CURRENCYEXCHANGERATE.SOURCECODEID,
                                  convert(datetime,CURRENCYEXCHANGERATE.ASOFDATE) as ASOFDATE,
                                  CURRENCYEXCHANGERATESOURCECODE.[DESCRIPTION] SOURCECODEDESCRIPTION,
                                  TIMEZONEENTRY.NAME TIMEZONEDISPLAYNAME
                              from
                                  dbo.CURRENCYEXCHANGERATE
                                  left join dbo.CURRENCYEXCHANGERATESOURCECODE on CURRENCYEXCHANGERATESOURCECODE.ID = CURRENCYEXCHANGERATE.SOURCECODEID
                                  left join dbo.TIMEZONEENTRY on TIMEZONEENTRY.ID = CURRENCYEXCHANGERATE.TIMEZONEENTRYID
                              where
                                  CURRENCYEXCHANGERATE.ID = @BASEEXCHANGERATEID 
        )