V_SIMPLEDATALIST_CURRENCYSETTRANSACTIONCURRENCY

Generates the list of transaction currencies available by currency set.

Fields

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

Definition

Copy

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



                select
                    CURRENCYSETTRANSACTIONCURRENCY.CURRENCYID as VALUE,
                    dbo.UFN_CURRENCY_GETDESCRIPTION(CURRENCYSETTRANSACTIONCURRENCY.CURRENCYID) as LABEL
                from
                    dbo.CURRENCYSETTRANSACTIONCURRENCY;