USP_SIMPLEDATALIST_ADDRESSPROCESSINGOPTION

A list of saved address processing option sets.

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_ADDRESSPROCESSINGOPTION(@CURRENTAPPUSERID uniqueidentifier) as
                select 
                    [ID] as VALUE, 
                    [NAME] as LABEL,
                    [ISDEFAULT] as DESCRIPTION
                from dbo.[ADDRESSPROCESSINGOPTION]
                where
                    SITEID is null or
                    dbo.UFN_SITEALLOWEDFORUSER(@CURRENTAPPUSERID, SITEID) = 1
                order by [DESCRIPTION] desc, [NAME]