UFN_REVENUE_ISFIRSTGIFTDATE

Determines whether the given revenue is the first gift for the constituent based on revenue date.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN
@REVENUEDATE	datetime	IN

Definition

Copy



            CREATE function dbo.UFN_REVENUE_ISFIRSTGIFTDATE
            (
                @CONSTITUENTID uniqueidentifier,
                @REVENUEDATE datetime
            )
            returns bit
            with execute as caller
            as
            begin                                  
                if exists(select FINANCIALTRANSACTION.ID from dbo.FINANCIALTRANSACTION where FINANCIALTRANSACTION.CONSTITUENTID = @CONSTITUENTID and FINANCIALTRANSACTION.DATE < @REVENUEDATE and (FINANCIALTRANSACTION.TYPECODE < 10 or FINANCIALTRANSACTION.TYPECODE = 15) and FINANCIALTRANSACTION.DELETEDON is null)
        begin
                    return 0
                end;

                return 1;
            end