USP_SIMPLEDATALIST_DISCOUNTAPPLICATIONMETHOD

Returns discount application typecode as value and corresponding name as label

Definition

Copy 


      CREATE procedure dbo.USP_SIMPLEDATALIST_DISCOUNTAPPLICATIONMETHOD as
          select distinct
              [APPLICATIONTYPECODE] as VALUE, 
              [APPLICATIONTYPE] as LABEL
          from dbo.[DISCOUNT]
          order by LABEL