UFN_GLACCOUNT_GETACCOUNTNUMBER

                CREATE function dbo.UFN_GLACCOUNT_GETACCOUNTNUMBER
                (
                    @ID uniqueidentifier
                )
                returns nvarchar(100)
                with execute as caller
                as
                begin
                    declare @ACCOUNTNUMBER nvarchar(100);

                    select 
                        @ACCOUNTNUMBER = ACCOUNTNUMBER
                    from
                        dbo.GLACCOUNT
                    where
                        ID = @ID;

                    return isnull(@ACCOUNTNUMBER, '');
                end