USP_DATALIST_CONSTITUENTPROFILECURRENCY

Retrieves currency information for the constituent profile using the given currency ID.

Parameters

Parameter	Parameter Type	Mode	Description
@SELECTEDCURRENCYID	uniqueidentifier	IN	Selected currency ID

Definition

Copy



                create procedure dbo.USP_DATALIST_CONSTITUENTPROFILECURRENCY
                (
                    @SELECTEDCURRENCYID uniqueidentifier
                )
                as
                    set nocount on;

                    select ISO4217 as ISOCODE,
                           DECIMALDIGITS,
                           CURRENCYSYMBOL,
                           SYMBOLDISPLAYSETTINGCODE as CURRENCYSYMBOLDISPLAYSETTINGCODE
                    from dbo.CURRENCY
                    where ID = @SELECTEDCURRENCYID