UFN_TRANSLATIONFUNCTION_CREDITMEMO

                create function dbo.UFN_TRANSLATIONFUNCTION_CREDITMEMO(@ID uniqueidentifier) returns nvarchar(20) 
                as
                begin
                    declare @s nvarchar(100);
                    select 
                    @s = [TYPE] + ' ' + [USERDEFINEDID] 
                    from dbo.FINANCIALTRANSACTION where ID = @ID;
                    return @s;
                end