USP_DATALIST_DELIVERYMETHODFEE

Displays a list of fees for a delivery method.
Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@INCLUDEINACTIVE	bit	IN	Include inactive
Definition

Copy


                    create procedure dbo.USP_DATALIST_DELIVERYMETHODFEE
                    ( 
                        @CONTEXTID uniqueidentifier,
                        @INCLUDEINACTIVE bit = 0
                    )
                    as
                        set nocount on;

                        select
                            DELIVERYMETHODFEE.ID,
                            FEE.NAME,
                            APPLIESTO,
                            case TYPECODE
                                when 0 then
                                    AMOUNT
                                else
                                    null
                            end AMOUNT,
                            case TYPECODE
                                when 1 then
                                    [PERCENT]
                                else
                                    null
                            end [PERCENT],
                            FEE.ISACTIVE,
                            FEE.[DESCRIPTION]
                        from
                            dbo.FEE
                        inner join dbo.DELIVERYMETHODFEE on
                            DELIVERYMETHODFEE.FEEID = FEE.ID
                        where 
                            DELIVERYMETHODFEE.DELIVERYMETHODID = @CONTEXTID and
                            (@INCLUDEINACTIVE = 1 or FEE.ISACTIVE = 1)
                        order by
                            NAME;

                        return 0;