UFN_TAXGLMAPPING_GETMAPPING

            create function dbo.UFN_TAXGLMAPPING_GETMAPPING(@CURRENTAPPUSERID uniqueidentifier = null) 
            returns table
            as return
                select 
                    row_number() over (order by TAX.NAME) as ROWNUMBER,
                    TAX.ID,
                    TAX.NAME as TAX,
                    MAP.ACCOUNTNUMBER,
                    MAP.PROJECTCODE
                from dbo.TAX
                left join dbo.TAXGLMAPPING as MAP on TAX.ID = MAP.ID;