USP_SIMPLEDATALIST_APPUSERTRANSACTIONCURRENCY

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

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



                create procedure dbo.USP_SIMPLEDATALIST_APPUSERTRANSACTIONCURRENCY
                (
                    @CURRENTAPPUSERID uniqueidentifier = null
                )
                as
                    set nocount on;

                    declare @CURRENCYSETID uniqueidentifier;
                    set @CURRENCYSETID = dbo.UFN_CURRENCYSET_GETAPPUSERCURRENCYSET(@CURRENTAPPUSERID);

                    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
                    where
                        CURRENCYSETTRANSACTIONCURRENCY.CURRENCYSETID = @CURRENCYSETID
                    order by LABEL