USP_SIMPLEDATALIST_REVENUEBATCHTRANSACTIONCURRENCIES

Returns a list of transaction currencies for an enhanced revenue batch row with given parameters.

Parameters

Parameter	Parameter Type	Mode	Description
@PDACCOUNTSYSTEMID	uniqueidentifier	IN	Account system ID
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@REVENUETYPECODE	tinyint	IN	Revenue type code
@CURRENTCURRENCYID	uniqueidentifier	IN	Current currency

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_REVENUEBATCHTRANSACTIONCURRENCIES
                (
                    @PDACCOUNTSYSTEMID uniqueidentifier = null,
                    @CURRENTAPPUSERID uniqueidentifier = null,
                    @REVENUETYPECODE tinyint = null,    -- Matches enhanced revenue batch TYPECODE field

                    @CURRENTCURRENCYID uniqueidentifier = null
                )
                as
                    set nocount on;

                    if @PDACCOUNTSYSTEMID is null
                      set @PDACCOUNTSYSTEMID = dbo.UFN_PDACCOUNTSYSTEM_GETDEFAULTSYSTEMIDSFORUSER(@CURRENTAPPUSERID);

                    declare @CURRENCYSETID uniqueidentifier;

                    if @REVENUETYPECODE = 3
                        select @CURRENCYSETID = dbo.UFN_CURRENCYSET_GETAPPUSERCURRENCYSET(@CURRENTAPPUSERID);
                    else
                        select @CURRENCYSETID = CURRENCYSETID from dbo.PDACCOUNTSYSTEM where ID = @PDACCOUNTSYSTEMID;                        

                    select
                        CURRENCY.ID as VALUE,
                        dbo.UFN_CURRENCY_GETDESCRIPTION(CURRENCY.ID) as LABEL
                    from 
                        dbo.CURRENCY
                        inner join dbo.CURRENCYSETTRANSACTIONCURRENCY on CURRENCYSETTRANSACTIONCURRENCY.CURRENCYID = CURRENCY.ID
                    where
                        CURRENCYSETTRANSACTIONCURRENCY.CURRENCYSETID = coalesce(@CURRENCYSETID,dbo.UFN_CURRENCYSET_GETAPPUSERCURRENCYSET(@CURRENTAPPUSERID))
                        and CURRENCY.INACTIVE = 0

                    union

                    select
                        CURRENCY.ID as VALUE,
                        dbo.UFN_CURRENCY_GETDESCRIPTION(CURRENCY.ID) as LABEL
                    from 
                        dbo.CURRENCY
                    where
                        CURRENCY.ID = @CURRENTCURRENCYID;