UFN_PRICELIST_GETPRICES

This function returns a pricelist's prices given its ID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PRICELISTID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_PRICELIST_GETPRICES
        (
            @PRICELISTID uniqueidentifier
        )
        returns table
        as return
            select
                PRICE.ID,
                PRICETYPECODEID,
                FACEPRICE,
                PRICE.SEQUENCE
            from
                dbo.PRICE
            left join dbo.PRICETYPECODE on 
                PRICETYPECODE.ID = PRICE.PRICETYPECODEID
            where
                PRICELISTID=@PRICELISTID and
                PRICETYPECODE.ACTIVE = 1;