UFN_DISCOUNTGLMAPPING_GETMAPPING

            CREATE function dbo.UFN_DISCOUNTGLMAPPING_GETMAPPING() 
            returns table
            as return
                select 
                    row_number() over (order by DISCOUNT.NAME) as ROWNUMBER,
                    DISCOUNT.ID,
                    DISCOUNT.NAME as DISCOUNT,
                    MAP.ACCOUNTNUMBER,
                    MAP.PROJECTCODE
                from dbo.DISCOUNT
                left join dbo.DISCOUNTGLMAPPING as MAP on DISCOUNT.ID = MAP.ID
                where DISCOUNT.SUPERSEDEDBYID is null;