USP_DATALIST_SALESMETHODDELIVERYMETHOD

List all delivery methods available to a sales method

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@INCLUDEINACTIVE	bit	IN	Include inactive

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_SALESMETHODDELIVERYMETHOD
            (
                @ID uniqueidentifier,
                @INCLUDEINACTIVE bit = 0
            )
            as
                set nocount on;

                select
                    SALESMETHODDELIVERYMETHOD.ID,
                    DELIVERYMETHOD.NAME,
          SALESMETHODDELIVERYMETHOD.ISDEFAULT,
                    DELIVERYMETHOD.ISACTIVE
                from
                    dbo.SALESMETHODDELIVERYMETHOD
                inner join dbo.DELIVERYMETHOD on 
                    SALESMETHODDELIVERYMETHOD.DELIVERYMETHODID = DELIVERYMETHOD.ID
                where
                    SALESMETHODDELIVERYMETHOD.SALESMETHODID = @ID and
                    (@INCLUDEINACTIVE = 1 or DELIVERYMETHOD.ISACTIVE = 1)
                order by
                    SALESMETHODDELIVERYMETHOD.SEQUENCE asc

                return 0;