USP_DATALIST_SALESMETHODDISCOUNT

List all discounts associated with a sales method.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_SALESMETHODDISCOUNT
(
    @ID uniqueidentifier
)
as
    set nocount on;

    select SALESMETHODDISCOUNT.ID,
        DISCOUNT.NAME,
        DISCOUNT.APPLIESTO,
        case when DISCOUNT.[CALCULATIONTYPECODE] = 1 then null else DISCOUNT.AMOUNT end,
        case when DISCOUNT.[CALCULATIONTYPECODE] = 0 then null else DISCOUNT.[PERCENT] end,
        DISCOUNT.ISACTIVE,
        DISCOUNT.[DESCRIPTION]
    from dbo.SALESMETHODDISCOUNT
    inner join dbo.DISCOUNT on SALESMETHODDISCOUNT.DISCOUNTID = DISCOUNT.ID
    where SALESMETHODDISCOUNT.SALESMETHODID = @ID
        and DISCOUNT.SUPERSEDEDBYID is null

    return 0;