USP_DATALIST_REVENUEDEFAULTRECOGNITION

Returns a list of default recognition credits.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@GIVENANONYMOUSLY	bit	IN
@AMOUNT	money	IN
@DATE	datetime	IN

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_REVENUEDEFAULTRECOGNITION
                (
                    @CONSTITUENTID uniqueidentifier,
                    @GIVENANONYMOUSLY bit = null,
                    @AMOUNT money = null,
                    @DATE datetime = null
                )
                as

                select
                    CONSTITUENTID,
                    isnull(CONSTITUENTNAME.NAME, MKTFINDERNUMBERCONSTITUENT.NAME) as NAME,
                    REVENUERECOGNITIONTYPECODEID,
                    REVENUERECOGNITIONTYPECODE.DESCRIPTION,
                    AMOUNT
                from dbo.UFN_REVENUEDETAIL_GETDEFAULTRECOGNITIONS(@GIVENANONYMOUSLY, @CONSTITUENTID, @AMOUNT, @DATE, null) as RECOGNITIONS
                outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(RECOGNITIONS.CONSTITUENTID) as CONSTITUENTNAME
                left join dbo.MKTFINDERNUMBERCONSTITUENT on MKTFINDERNUMBERCONSTITUENT.ID = RECOGNITIONS.CONSTITUENTID
                left outer join dbo.REVENUERECOGNITIONTYPECODE on RECOGNITIONS.REVENUERECOGNITIONTYPECODEID = REVENUERECOGNITIONTYPECODE.ID
                where RECOGNITIONS.CONSTITUENTID is not null;