UFN_RECOGNITIONPROGRAM_GETREVENUERECOGNITION

Returns all valid revenue recognitions, for the supplied recognition program.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@PROGRAMID	uniqueidentifier	IN
@STARTDATE	datetime	IN
@PROCESSDATE	datetime	IN
@PLANNEDGIFTCODE	tinyint	IN
@REVENUESELECTIONID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_RECOGNITIONPROGRAM_GETREVENUERECOGNITION
            (
                @PROGRAMID uniqueidentifier,
                @STARTDATE datetime,
                @PROCESSDATE datetime,
                @PLANNEDGIFTCODE tinyint,
                @REVENUESELECTIONID uniqueidentifier
            )
            returns table
            as
                return
                (
                    select 
                        CONSTITUENTID,
                        AMOUNT,
                        EFFECTIVEDATE,
                        PLANNEDGIFTAMOUNT,
                        YEARSTART,
                        YEAREND,
                        REVENUERECOGNITIONID
                    from
                        dbo.CURRENCY
                        cross apply dbo.UFN_RECOGNITIONPROGRAM_GETREVENUERECOGNITION_INCURRENCY (
                            @PROGRAMID,
                            @STARTDATE,
                            @PROCESSDATE,
                            @PLANNEDGIFTCODE,
                            @REVENUESELECTIONID,
                            CURRENCY.ID,
                            CURRENCY.ID,
                            CURRENCY.DECIMALDIGITS,
                            CURRENCY.ROUNDINGTYPECODE)
                    where
                        CURRENCY.ID = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY()
                )