USP_SIMPLEDATALIST_DELIVERYMETHOD

CREATE procedure dbo.USP_SIMPLEDATALIST_DELIVERYMETHOD (
    @PRINTCODE tinyint = null,
    @SALESMETHODTYPECODE tinyint = null,
    @ONLYSALESDOCUMENTMETHODS bit = 0
)
as
    set nocount on;

    select
        DELIVERYMETHOD.ID as VALUE,
        DELIVERYMETHOD.NAME as LABEL
    from dbo.DELIVERYMETHOD
    inner join dbo.UFN_SALESMETHOD_COMPATIBLEDELIVERYMETHODS(@SALESMETHODTYPECODE, 1) SMD on
        DELIVERYMETHOD.ID = SMD.ID
    where
        DELIVERYMETHOD.ISACTIVE = 1
        and (
            @PRINTCODE is null or
            DELIVERYMETHOD.PRINTCODE = @PRINTCODE
        ) and
        (@ONLYSALESDOCUMENTMETHODS = 0 or DELIVERYMETHOD.PRINTCODE in (0,1));

    return 0;