UFN_PAYMENT_GETDESCRIPTION

            CREATE function dbo.UFN_PAYMENT_GETDESCRIPTION
            (
                @ID uniqueidentifier
            ) 
            returns nvarchar(700) 
            with execute as caller
            as
            begin
                declare @DESCRIPTION nvarchar(700);
                declare @AMOUNT money;

                select 
                    @DESCRIPTION = '(' + ltrim(rtrim(FINANCIALTRANSACTION.TYPE)) + ') ' + Cast(FINANCIALTRANSACTION.BASEAMOUNT as nvarchar(20)) + ' ' + coalesce(REVENUEPAYMENTMETHOD.PAYMENTMETHOD, 'None') + ' - ' + ltrim(rtrim(CONSTITUENT.NAME))
                from dbo.FINANCIALTRANSACTION
                inner join dbo.REVENUE_EXT
                    on FINANCIALTRANSACTION.ID = REVENUE_EXT.ID
                inner join dbo.CONSTITUENT
                    on CONSTITUENT.ID = FINANCIALTRANSACTION.CONSTITUENTID
                left join dbo.REVENUEPAYMENTMETHOD
                    on REVENUEPAYMENTMETHOD.REVENUEID = FINANCIALTRANSACTION.ID
                where FINANCIALTRANSACTION.ID = @ID
                    and FINANCIALTRANSACTION.DELETEDON is null;

                return @DESCRIPTION;
            end