UFN_GLREVENUECATEGORYMAPPING_GETNAME

                create function dbo.UFN_GLREVENUECATEGORYMAPPING_GETNAME
                (
                    @ID uniqueidentifier
                )
                returns nvarchar(100)
                with execute as caller
                as
                begin
                    declare @NAME nvarchar(100);

                    select @NAME = REVENUECATEGORYNAME from dbo.GLREVENUECATEGORYMAPPING where ID = @ID;

                    return coalesce(@NAME,'');
                end