UFN_SITEACCESSABLE_REVENUESPLITID_FORUSER
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @APPUSERID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_SITEACCESSABLE_REVENUESPLITID_FORUSER
(
@APPUSERID uniqueidentifier
)
returns table as
return
(
select distinct
LI.ID [REVENUESPLITID]
,LI.FINANCIALTRANSACTIONID [REVENUEID]
from dbo.UFN_SITEID_MAPFROM_REVENUESPLITID_BULK() SPLITMAP
inner join dbo.UFN_SITEID_MAPFROM_APPUSERID(@APPUSERID) USERMAP on isnull(SPLITMAP.SITEID, '00000000-0000-0000-0000-000000000000') = isnull(USERMAP.SITEID, '00000000-0000-0000-0000-000000000000')
inner join dbo.FINANCIALTRANSACTIONLINEITEM LI on LI.ID = SPLITMAP.ID
)