USP_SIMPLEDATALIST_ORDERVALIDMANUALDISCOUNT

Lists the manual discounts valid for a given order

Parameters

Parameter	Parameter Type	Mode	Description
@SALESORDERID	uniqueidentifier	IN	SALESORDERID

Definition

Copy



create procedure dbo.USP_SIMPLEDATALIST_ORDERVALIDMANUALDISCOUNT
(
    @SALESORDERID uniqueidentifier
) as
    select 
        ID as VALUE, 
        NAME as LABEL
    from dbo.UFN_SALESORDER_GETAVAILABLEMANUALDISCOUNTS(@SALESORDERID)
    order by NAME