UFN_RESERVATION_VALIDSALESORDER

Determines if the sales order of the reservation is of type group sales.

Return

Return Type
bit

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


            create function dbo.UFN_RESERVATION_VALIDSALESORDER
            (
                @ID uniqueidentifier
            )
            returns bit as
            begin
                if exists(select 1 from dbo.SALESORDER where ID = @ID and SALESMETHODTYPECODE = 3)
                    return 1;

                return 0;
            end