USP_DATALIST_PRICELISTPRICE

Returns a list of price types and face prices for a price list.

Parameters

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

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_PRICELISTPRICE(@PRICELISTID uniqueidentifier)
            as
                set nocount on;

            select
                PRICE.ID,
                PRICETYPECODEID,
                FACEPRICE,
                PRICE.SEQUENCE
            from
                dbo.PRICE
            inner join dbo.PRICETYPECODE on
                PRICETYPECODE.ID = PRICE.PRICETYPECODEID
            where
                PRICELISTID=@PRICELISTID and
                PRICETYPECODE.ACTIVE = 1;