UFN_CORPORATION_GETCONSTITUENTGIFTSINCURRENCY_2

Returns the gifts 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
@ORGANIZATIONCURRENCYID	uniqueidentifier	IN
@DECIMALDIGITS	tinyint	IN
@ROUNDINGTYPECODE	tinyint	IN
@SECURITYFEATUREID	uniqueidentifier	IN
@SECURITYFEATURETYPE	tinyint	IN

Definition

Copy



                CREATE function [dbo].[UFN_CORPORATION_GETCONSTITUENTGIFTSINCURRENCY_2]
                (  
                    @CURRENTAPPUSERID uniqueidentifier,   
                    @ROOTID uniqueidentifier,   
                    @CURRENCYID uniqueidentifier,  
                    @ORGANIZATIONCURRENCYID uniqueidentifier,  
                    @DECIMALDIGITS tinyint,  
                    @ROUNDINGTYPECODE tinyint,
                    @SECURITYFEATUREID uniqueidentifier,
                    @SECURITYFEATURETYPE tinyint
                )                 
                returns table
                as return

                select
                    GIFTS.CONSTITUENTID,
                    GIFTS.REVENUEID,
                    GIFTS.REVENUESPLITID,
                    GIFTS.AMOUNT,
                    GIFTS.TRANSACTIONTYPECODE,
                    GIFTS.APPLICATIONCODE,
                    GIFTS.TYPECODE,
                    GIFTS.DESIGNATIONID
                from
                    dbo.UFN_CORPORATION_GETCONSTITUENTGIFTSINCURRENCY_NOSITE(@CURRENTAPPUSERID, @ROOTID, @CURRENCYID, @ORGANIZATIONCURRENCYID, @DECIMALDIGITS, @ROUNDINGTYPECODE, @SECURITYFEATUREID, @SECURITYFEATURETYPE) GIFTS
                    -- Site security check

                    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 = GIFTS.REVENUESPLITID