UFN_FEEGLMAPPING_GETMAPPING

            create function dbo.UFN_FEEGLMAPPING_GETMAPPING() 
            returns table
            as return
                select 
                    row_number() over (order by FEE.NAME) as ROWNUMBER,
                    FEE.ID,
                    FEE.NAME as FEE,
                    MAP.ACCOUNTNUMBER,
                    MAP.PROJECTCODE
                from dbo.FEE
                left join dbo.FEEGLMAPPING as MAP on FEE.ID = MAP.ID;