USP_DATALIST_FEEGLMAPPING

                create procedure dbo.USP_DATALIST_FEEGLMAPPING
                as                 
                    set nocount on;

                    select 
                        FEE.ID, 
                        FEE.[NAME] as FEENAME,
                        MAP.ACCOUNTNUMBER,
                        MAP.PROJECTCODE,
                        'IMAGEKEY' = case when (MAP.ACCOUNTNUMBER is null or MAP.ACCOUNTNUMBER = '' 
                                        or MAP.PROJECTCODE is null or MAP.PROJECTCODE = '') then 'RES:warning' else '' end
                    from dbo.FEE
                    left join dbo.FEEGLMAPPING as MAP on FEE.ID = MAP.ID
                    order by FEE.NAME;