UFN_REVENUE_SUPPORTSSPLITS

Returns 1 if the REVENUEID is allowed to have designations.

Return

Return Type
bit

Parameters

Parameter Parameter Type Mode Description
@REVENUEID uniqueidentifier IN

Definition

Copy


            create function dbo.UFN_REVENUE_SUPPORTSSPLITS
            (
                @REVENUEID uniqueidentifier
            )
            returns bit
            as 
            begin
                if (select TYPECODE from dbo.REVENUE where ID = @REVENUEID) = 6
                    return 0;

                return 1;
            end