USP_SIMPLEDATALIST_BASECURRENCY

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

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTBASECURRENCYID	uniqueidentifier	IN	Current base currency

Definition

Copy



                create procedure dbo.USP_SIMPLEDATALIST_BASECURRENCY
                (
                    @CURRENTBASECURRENCYID uniqueidentifier = null
                )as
                    select distinct
                        CURRENCY.ID as VALUE,
                        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

                            union all

                            select @CURRENTBASECURRENCYID as CURRENCYID

                        ) AVAILABLEBASECURRENCY on AVAILABLEBASECURRENCY.CURRENCYID = CURRENCY.ID
                    order by LABEL