V_SIMPLEDATALIST_BASECURRENCY

Generates the list of currencies that should be available when assigning a record a new base currency.

Fields

Field	Field Type	Null	Description
LABEL	nvarchar(106)

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  4/29/2010 7:34:55 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.6.1444.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SIMPLEDATALIST_BASECURRENCY AS



                select distinct
                    CURRENCY.NAME + ' (' + CURRENCY.ISO4217 + ')' as LABEL
                from dbo.CURRENCY
                    inner join (
                        select 
                            BASECURRENCYID as CURRENCYID
                        from dbo.CURRENCYSET

                        union all

                        select dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY() as CURRENCYID

                    ) AVAILABLEBASECURRENCY on AVAILABLEBASECURRENCY.CURRENCYID = CURRENCY.ID