UFN_REVENUE_USERHASDESIGNATIONSITEACCESS
Returns 1 is the given user has site access to any of the given revenue's split designations.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @REVENUEID | uniqueidentifier | IN | |
| @CURRENTAPPUSERID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_REVENUE_USERHASDESIGNATIONSITEACCESS
(
@REVENUEID uniqueidentifier,
@CURRENTAPPUSERID uniqueidentifier
)
returns bit
as
begin
declare @ACCESSGRANTED bit
if exists(
select
LI.ID
from dbo.FINANCIALTRANSACTIONLINEITEM LI
inner join dbo.REVENUESPLIT_EXT RSE on RSE.ID = LI.ID
where LI.FINANCIALTRANSACTIONID=@REVENUEID and LI.TYPECODE != 1 and LI.DELETEDON is null
and dbo.UFN_DESIGNATION_USERHASSITEACCESS(RSE.DESIGNATIONID,@CURRENTAPPUSERID) = 1
)
begin
set @ACCESSGRANTED = 1
end
else
begin
set @ACCESSGRANTED = 0
end
return @ACCESSGRANTED
end