USP_DATALIST_ADJUSTMENTREASONCODES

                    CREATE procedure dbo.USP_DATALIST_ADJUSTMENTREASONCODES
                    (
                        @INCLUDEINACTIVE bit = 0
                    )
                    as
                        set nocount on

                        select
                            ADJUSTMENTREASONCODE.ID,
                            ADJUSTMENTREASONCODE.CODE,
                            ADJUSTMENTREASONCODE.DESCRIPTION,
                            ADJUSTMENTREASONCODE.ACTIVE,
                            ADJUSTMENTREASONCODE.ISDIRECTDEBITREJECTEDDEFAULT,
              ADJUSTMENTREASONCODE.ISAUCTIONIMPORTDEFAULT
                        from 
              dbo.ADJUSTMENTREASONCODE
                        where
                            ACTIVE = 1 
              or @INCLUDEINACTIVE = 1
            order by 
              ISDIRECTDEBITREJECTEDDEFAULT desc, CODE asc