USP_SIMPLEDATALIST_CURRENCYSETTRANSACTIONCURRENCY

Generates the list of transaction currencies available by currency set.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENCYSETID	uniqueidentifier	IN	Currency set

Definition

Copy



    CREATE procedure dbo.USP_SIMPLEDATALIST_CURRENCYSETTRANSACTIONCURRENCY
    (
        @CURRENCYSETID uniqueidentifier
    )
    as
        set nocount on;

        select
            CURRENCYSETTRANSACTIONCURRENCY.CURRENCYID as VALUE,
            dbo.UFN_CURRENCY_GETDESCRIPTION(CURRENCYSETTRANSACTIONCURRENCY.CURRENCYID) as LABEL
        from
            dbo.CURRENCYSETTRANSACTIONCURRENCY
        where
            CURRENCYSETTRANSACTIONCURRENCY.CURRENCYSETID = @CURRENCYSETID
        order by
            LABEL;