USP_DELIVERYMETHOD_INFO_BYSALESMETHODID

Returns delivery information with respect to selling via a sales method.

Parameters

Parameter	Parameter Type	Mode
@SALESMETHODID	uniqueidentifier	IN
@HASDELIVERYMETHOD	bit	INOUT
@HASUNRESTRICTEDDELIVERY	bit	INOUT
@EARLIESTVALIDEVENTTIMEWITHOFFSET	datetimeoffset	INOUT

Definition

Copy



            CREATE procedure dbo.USP_DELIVERYMETHOD_INFO_BYSALESMETHODID (
                @SALESMETHODID uniqueidentifier,
                @HASDELIVERYMETHOD bit = 0 output,
                --The sales method has an associated delivery method that does not BLOCKDELIVERY

                @HASUNRESTRICTEDDELIVERY bit = 0 output,
                --Earliest time of an event that could be sold 'now' through this sales method with a valid delivery method

                @EARLIESTVALIDEVENTTIMEWITHOFFSET datetimeoffset = null output 
            )
            as begin
                select
                    @HASDELIVERYMETHOD = [HASDELIVERYMETHOD],
                    @HASUNRESTRICTEDDELIVERY = [HASUNRESTRICTEDDELIVERY], 
                    @EARLIESTVALIDEVENTTIMEWITHOFFSET = [EARLIESTVALIDEVENTDATETIMEWITHOFFSET]
                from dbo.UFN_DELIVERYMETHOD_INFO_BYSALESMETHODID(@SALESMETHODID)

                return 0;
            end