USP_SIMPLEDATALIST_PRICELIST_ACTIVE

Lists active price lists by name

Definition

Copy


            create procedure dbo.USP_SIMPLEDATALIST_PRICELIST_ACTIVE as
                select 
                    ID as VALUE
                    NAME as LABEL
                from dbo.PRICELIST
                where ISACTIVE = 1
                order by NAME