UFN_REVENUESOLICITOR_VALIDAMOUNT

Validates whether the solicitor amount is valid for the revenue detail.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUESPLITID	uniqueidentifier	IN
@AMOUNT	numeric(20, 4)	IN

Definition

Copy



            CREATE function dbo.UFN_REVENUESOLICITOR_VALIDAMOUNT(@REVENUESPLITID as uniqueidentifier, @AMOUNT as numeric(20,4))
            returns bit
            with execute as caller
            as
            begin

                declare @REVENUEAMOUNT as numeric(20,4)

                select @REVENUEAMOUNT = AMOUNT from dbo.REVENUESPLIT where ID = @REVENUESPLITID

                if (@REVENUEAMOUNT >= @AMOUNT)
                    return 1
                else
                    return 0

                return 0
            end