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