UFN_REVENUEBATCH_GETRECOGNITIONDEFAULTS

Returns the default recognitions for a constituent in a batch.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@GIVENANONYMOUSLY	bit	IN
@CONSTITUENTID	uniqueidentifier	IN
@RECOGNITIONAMOUNT	money	IN
@DATE	datetime	IN
@SOURCERECURRINGGIFTREVENUEID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_REVENUEBATCH_GETRECOGNITIONDEFAULTS
            (
                @GIVENANONYMOUSLY bit, 
                @CONSTITUENTID uniqueidentifier,
                @RECOGNITIONAMOUNT money,
                @DATE datetime,
                @SOURCERECURRINGGIFTREVENUEID uniqueidentifier = null

            )
            returns @R table
            (
                CONSTITUENTID uniqueidentifier,
                REVENUERECOGNITIONTYPECODEID uniqueidentifier,
                AMOUNT money
            )
            as
            begin

        insert into @R 
        select
                RECOGNITIONS.CONSTITUENTID,
                RECOGNITIONS.REVENUERECOGNITIONTYPECODEID,
                RECOGNITIONS.AMOUNT
            from
                dbo.UFN_REVENUEBATCH_GETRECOGNITIONDEFAULTS_2(@GIVENANONYMOUSLY, @CONSTITUENTID, @RECOGNITIONAMOUNT, @DATE, @SOURCERECURRINGGIFTREVENUEID, null, null) as RECOGNITIONS

                return;
            end