UFN_MERCHANTACCOUNT_SITESECURELISTFORFEATURE

Retrieves merchant accounts available for the application user.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@CURRENTAPPUSERID	uniqueidentifier	IN
@SECURITYFEATUREID	uniqueidentifier	IN
@SECURITYFEATURETYPE	tinyint	IN

Definition

Copy



            CREATE function dbo.UFN_MERCHANTACCOUNT_SITESECURELISTFORFEATURE
            (
                @CURRENTAPPUSERID uniqueidentifier,
                @SECURITYFEATUREID uniqueidentifier = null,
                @SECURITYFEATURETYPE tinyint = null
            )
            returns table
            as
            return
            (
                select
                    MERCHANTACCOUNT.ID as MERCHANTACCOUNTID,
                    case
                        when (dbo.UFN_MERCHANTACCOUNT_USERHASSITEACCESS(MERCHANTACCOUNT.ID, @CURRENTAPPUSERID, @SECURITYFEATUREID, @SECURITYFEATURETYPE) = 1) then 
                            1
                        else
                            0
                    end as ACCESSGRANTED
                from
                    dbo.MERCHANTACCOUNT
            )