USP_SIMPLEDATALIST_LETTERCODE

Returns a list of revenue letters.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SECURITYFEATUREID	uniqueidentifier	IN
@SECURITYFEATURETYPE	tinyint	IN
@REQUIRESELECTION	bit	IN	Require selection

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_LETTERCODE
                (
                    @CURRENTAPPUSERID uniqueidentifier,
                    @SECURITYFEATUREID uniqueidentifier = null,
                    @SECURITYFEATURETYPE tinyint = null,
                    @REQUIRESELECTION bit = 1
                )
                as
                    set nocount on;

                    select distinct
                        LETTERCODE.ID as VALUE,
                        LETTERCODE.NAME as LABEL
                    from
                        dbo.LETTERCODE
                    left join 
                        dbo.LETTERCODESITE on LETTERCODE.ID = LETTERCODESITE.LETTERCODEID
                    where
                        ISACTIVE = 1
                        and
                        (
                            @REQUIRESELECTION = 0 or
                            IDSETREGISTERID is not null
                        )
                        and ISSYSTEM = 0
                        and (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[LETTERCODESITE].[SITEID] or (SITEID is null and [LETTERCODESITE].[SITEID] is null)))
                    order by
                        NAME;