UFN_REVENUETRANSACTION_GETDESCRIPTION

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

                select 
                    @DESCRIPTION = Cast(FINANCIALTRANSACTION.TRANSACTIONAMOUNT as nvarchar(20)) + ' ' + 
                                    case when FINANCIALTRANSACTION.TYPECODE = 2 then (case when (select top 1 REVENUESPLIT_EXT.TYPECODE from dbo.FINANCIALTRANSACTIONLINEITEM inner join dbo.REVENUESPLIT_EXT on FINANCIALTRANSACTIONLINEITEM.ID = REVENUESPLIT_EXT.ID where FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = @ID and FINANCIALTRANSACTIONLINEITEM.DELETEDON is null and FINANCIALTRANSACTION.TYPECODE <> 1) = 9 then 'Sponsorship recurring gift' 
                                    else (case when (select top 1 REVENUESPLIT_EXT.TYPECODE from dbo.FINANCIALTRANSACTIONLINEITEM inner join dbo.REVENUESPLIT_EXT on FINANCIALTRANSACTIONLINEITEM.ID = REVENUESPLIT_EXT.ID where FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = @ID and FINANCIALTRANSACTIONLINEITEM.DELETEDON is null and FINANCIALTRANSACTIONLINEITEM.TYPECODE <> 1) = 17 then 'Sponsorship recurring additional gift' else FINANCIALTRANSACTION.TYPE end) end)
                                    else FINANCIALTRANSACTION.TYPE end +
                                    ' - ' + ltrim(rtrim(NF.NAME))
                from dbo.FINANCIALTRANSACTION
                inner join dbo.REVENUE_EXT on FINANCIALTRANSACTION.ID = REVENUE_EXT.ID
                    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(FINANCIALTRANSACTION.CONSTITUENTID) NF
                where FINANCIALTRANSACTION.ID = @ID
                    and FINANCIALTRANSACTION.DELETEDON is null;

                return @DESCRIPTION;
            end