UFN_REVENUE_USERHASSITEACCESS

Returns whether user has site access to a revenue record.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_REVENUE_USERHASSITEACCESS
            (
                @REVENUEID uniqueidentifier,
                @CURRENTAPPUSERID uniqueidentifier
            )
            returns bit
            as
            begin
                declare @USERHASACCESS bit

                if exists (    select 1 from dbo.UFN_SITEID_MAPFROM_REVENUEID(@REVENUEID) REVENUESITE
                            where dbo.UFN_SITEALLOWEDFORUSER(@CURRENTAPPUSERID, REVENUESITE.SITEID) = 1
                          )
                    set @USERHASACCESS = 1
                else
                    set @USERHASACCESS = 0

                return @USERHASACCESS
            end