USP_DATALIST_FEE

                    create procedure dbo.USP_DATALIST_FEE
                    (
                    @INCLUDEINACTIVE bit = 1
                    )
                    as
                        set nocount on;

                        select
                            ID,
                            NAME,
                            APPLIESTO,
                            case TYPECODE
                                when 0 then
                                    AMOUNT
                                else
                                    null
                            end AMOUNT,
                            case TYPECODE
                                when 1 then
                                    [PERCENT]
                                else
                                    null
                            end [PERCENT],
                            ISACTIVE,
                            [DESCRIPTION]
                        from
                            dbo.FEE
                        where
                            @INCLUDEINACTIVE = 1
                            or ISACTIVE = 1
                        order by
                            NAME;

                        return 0;