V_SIMPLEDATALIST_PDACCOUNTSYSTEMBASECURRENCYEXCHANGERATES

Returns a list of exchange rates for converted from the given currency to the base currency of the given account system.

Fields

Field	Field Type	Null	Description
VALUE	uniqueidentifier
LABEL	nvarchar(133)	yes

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  11/30/2010 11:25:56 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.8.2022.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SIMPLEDATALIST_PDACCOUNTSYSTEMBASECURRENCYEXCHANGERATES AS



                select
                    CURRENCYEXCHANGERATE.ID as VALUE,
                    case
                        when CURRENCYEXCHANGERATE.SOURCECODEID is null
                            then convert(nvarchar,CURRENCYEXCHANGERATE.ASOFDATE)
                        else 
                            CURRENCYEXCHANGERATESOURCECODE.DESCRIPTION + ' (' + convert(nvarchar,CURRENCYEXCHANGERATE.ASOFDATE) + ')'
                    end as LABEL
                from
                    dbo.CURRENCYEXCHANGERATE
                    left join dbo.CURRENCYEXCHANGERATESOURCECODE on CURRENCYEXCHANGERATESOURCECODE.ID = CURRENCYEXCHANGERATE.SOURCECODEID

                union all

                select
                    N'00000000-0000-0000-0000-000000000001',
                    N'Spot rate';