USP_SIMPLEDATALIST_SALESMETHODWITHDISCOUNTS

      create procedure dbo.USP_SIMPLEDATALIST_SALESMETHODWITHDISCOUNTS as
          select 
              ID as VALUE, 
              TYPE as LABEL
          from dbo.SALESMETHOD
          where TYPECODE <> 3 and
        ISACTIVE = 1
          order by TYPE