UFN_INSTALLMENTSPLIT_REVENUESPLITIDVALID

Return

Return Type
bit

Parameters

Parameter Parameter Type Mode Description
@REVENUESPLITID uniqueidentifier IN

Definition

Copy


            create function dbo.UFN_INSTALLMENTSPLIT_REVENUESPLITIDVALID
            (
                @REVENUESPLITID uniqueidentifier
            )
            returns bit
            with execute as caller
            as begin
                if @REVENUESPLITID is null
                    return 1

                if exists(select ID from dbo.FINANCIALTRANSACTIONLINEITEM where ID = @REVENUESPLITID)
                    return 1

                return 0
            end