UFN_SALESMETHODDELIVERYMETHOD_VALIDDELIVERYMETHODPRINTCODE

            create function dbo.UFN_SALESMETHODDELIVERYMETHOD_VALIDDELIVERYMETHODPRINTCODE (
                @SALESMETHODID uniqueidentifier,
                @DELIVERYMETHODID uniqueidentifier
            )
            returns bit
            with execute as caller
            as begin
                declare @DELIVERYMETHODPRINTCODE tinyint
                select @DELIVERYMETHODPRINTCODE = PRINTCODE
                from dbo.DELIVERYMETHOD
                where ID = @DELIVERYMETHODID

                declare @SALESMETHODTYPECODE tinyint
                select @SALESMETHODTYPECODE = TYPECODE
                from dbo.SALESMETHOD
                where ID = @SALESMETHODID

                --Only online sales supports print at home currently

                if @DELIVERYMETHODPRINTCODE <> 2 or @SALESMETHODTYPECODE = 2
                    return 1;

                return 0;
            end