USP_DATALIST_MERCHANDISEITEMDISCOUNTS

Returns a list of discounts available for a merchandise item.

Parameters

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

Definition

Copy



create procedure dbo.USP_DATALIST_MERCHANDISEITEMDISCOUNTS(@MERCHANDISEPRODUCTID uniqueidentifier)
as
    set nocount on;

    select
        ID,
        NAME,
        CALCULATIONTYPE,
        case CALCULATIONTYPECODE
            when 1 then MERCHANDISEPERCENT
            else MERCHANDISEAMOUNT
        end [VALUE]
    from
        dbo.UFN_MERCHANDISEITEM_GETDISCOUNTS(@MERCHANDISEPRODUCTID, 0)
    order by
        NAME;

    return 0;