V_SIMPLEDATALIST_APPUSERTRANSACTIONCURRENCY

Generates the list of transaction currencies available to a user through their currency set.

Fields

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

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  8/2/2010 7:06:48 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.7.1654.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SIMPLEDATALIST_APPUSERTRANSACTIONCURRENCY AS



                select distinct
                    CURRENCY.ID as VALUE,
                    dbo.UFN_CURRENCY_GETDESCRIPTION(CURRENCY.ID) as LABEL
                from
                    dbo.CURRENCYSETTRANSACTIONCURRENCY
                    inner join dbo.CURRENCY on CURRENCYSETTRANSACTIONCURRENCY.CURRENCYID = CURRENCY.ID