UFN_TRANSLATIONFUNCTION_INTEGRATIONACCOUNTSYSTEM

                create function dbo.UFN_TRANSLATIONFUNCTION_INTEGRATIONACCOUNTSYSTEM
                (
                @ID uniqueidentifier
                ) 
                returns nvarchar(50) 
                as
                begin
                    declare @s nvarchar(50);

                    select @s = PDACCOUNTSYSTEM.NAME
                    from dbo.PDACCOUNTSYSTEM
                    inner join dbo.FENXTINTEGRATION on PDACCOUNTSYSTEM.ID = FENXTINTEGRATION.PDACCOUNTSYSTEMID where FENXTINTEGRATION.ID = @ID;

                    return @s;
                end