UFN_REVENUECOMMITMENT_GETDESCRIPTION

            CREATE function dbo.UFN_REVENUECOMMITMENT_GETDESCRIPTION
            (
                @ID uniqueidentifier
            ) 
            returns nvarchar(500) 
            with execute as caller
            as
            begin
                declare @DESCRIPTION nvarchar(500);

                select 
                    @DESCRIPTION = Cast(FINANCIALTRANSACTION.BASEAMOUNT as nvarchar(20)) + ' ' + 
                                    FINANCIALTRANSACTION.TYPE +
                                    ' - ' + 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
                where FINANCIALTRANSACTION.ID = @ID and FINANCIALTRANSACTION.DELETEDON is null;

                return @DESCRIPTION;
            end