USP_SIMPLEDATALIST_ORDERVALIDMANUALDISCOUNTMEMBERSHIPPROMO

Lists available manual discounts and membership promotions

Parameters

Parameter	Parameter Type	Mode	Description
@SALESORDERID	uniqueidentifier	IN	SALESORDERID

Definition

Copy



CREATE procedure dbo.USP_SIMPLEDATALIST_ORDERVALIDMANUALDISCOUNTMEMBERSHIPPROMO
(
    @SALESORDERID uniqueidentifier
) as

    if exists (select 1 from dbo.SALESORDER where @SALESORDERID = ID and SALESMETHODTYPECODE = 3)
        select
            ID as VALUE,
            NAME as LABEL
        from dbo.UFN_SALESORDER_GETAVAILABLEMANUALDISCOUNTSMEMBERSHIPPROMOS(@SALESORDERID)
        where APPLIESTOCODE <> -1
        order by NAME
    else
        select 
            ID as VALUE, 
            NAME as LABEL
        from dbo.UFN_SALESORDER_GETAVAILABLEMANUALDISCOUNTSMEMBERSHIPPROMOS(@SALESORDERID)
        order by NAME