USP_SIMPLEDATALIST_DISCOUNT_MANUALDISCOUNTS

Returns all manually applied discounts.

Definition

Copy


            create procedure dbo.USP_SIMPLEDATALIST_DISCOUNT_MANUALDISCOUNTS as
                select distinct
                    APPLICATIONTYPECODE as VALUE
                    APPLICATIONTYPE as LABEL
                from dbo.DISCOUNT
                where APPLICATIONTYPECODE > 0
                order by APPLICATIONTYPECODE