UFN_WRITEOFFREASONCODE_TRANSLATE

            create function dbo.UFN_WRITEOFFREASONCODE_TRANSLATE
            (
                @ID uniqueidentifier
            )
            returns nvarchar(63)
            as
            begin
                declare @TRANSLATION nvarchar(63)

                select @TRANSLATION = CODE + ' - ' + DESCRIPTION
                from dbo.WRITEOFFREASONCODE
                where ID = @ID

                return coalesce(@TRANSLATION, '')
            end