UFN_CORPORATION_GETCONSTITUENTRECOGNITIONINCURRENCY_2

Returns the recognition for the given constituent based on the currently selected organizations in a given currency

Return

Return Type
table

Parameters

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

Definition

Copy




            CREATE function [dbo].[UFN_CORPORATION_GETCONSTITUENTRECOGNITIONINCURRENCY_2]
            (
                @CURRENTAPPUSERID uniqueidentifier, 
                @ROOTID uniqueidentifier, 
                @CURRENCYID uniqueidentifier,
                @SECURITYFEATUREID uniqueidentifier,
                @SECURITYFEATURETYPE tinyint
            )
            returns table
            as return
            select
                RR.CONSTITUENTID,
                RR.RECOGNITIONID,
                RR.REVENUEID,
                RR.AMOUNT,
                RR.REVENUESPLITID,
                RR.TRANSACTIONTYPECODE,
                RR.APPLICATIONCODE,
                RR.TYPECODE
            from dbo.UFN_CORPORATION_GETCONSTITUENTRECOGNITIONINCURRENCY_NOSITE(@CURRENTAPPUSERID, @ROOTID, @CURRENCYID, @SECURITYFEATUREID, @SECURITYFEATURETYPE) RR
                inner join
                (
                    select distinct SPLITMAP.ID [REVENUESPLITID]
                    from dbo.UFN_SITEID_MAPFROM_REVENUESPLITID_BULK() SPLITMAP
                    inner join dbo.UFN_SITEID_MAPFROM_APPUSERID(@CURRENTAPPUSERID) USERMAP on isnull(SPLITMAP.SITEID, '00000000-0000-0000-0000-000000000000') = isnull(USERMAP.SITEID, '00000000-0000-0000-0000-000000000000')
                    inner join dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID, @SECURITYFEATUREID, @SECURITYFEATURETYPE) SITEONFEATURE on isnull(SPLITMAP.SITEID, '00000000-0000-0000-0000-000000000000') = isnull(SITEONFEATURE.SITEID, '00000000-0000-0000-0000-000000000000')
                ) SITEFILTER on SITEFILTER.REVENUESPLITID = RR.REVENUESPLITID;