UFN_REVENUE_DESCRIPTION_BULK

create function dbo.UFN_REVENUE_DESCRIPTION_BULK()
returns table
     return select
     FINANCIALTRANSACTION.ID
     ,cast('('+case FINANCIALTRANSACTION.TYPECODE when 0 then N'Payment' when 1 then N'Pledge' when 2 then N'Recurring gift' when 3 then N'Matching gift claim' when 4 then N'Planned gift' when 5 then N'Order' when 6 then N'Grant award' when 7 then N'Auction donation' when 8 then N'Donor challenge claim' when 9 then N'Pending gift' end+') '
            +convert(nvarchar(20),FINANCIALTRANSACTION.BASEAMOUNT)+' '+isnull(REVENUEPAYMENTMETHOD.PAYMENTMETHOD, 'None') 
            + ' - ' + CONSTITUENT.NAME as nvarchar(700)) as DESCRIPTION
     from 
            FINANCIALTRANSACTION
            left join dbo.CONSTITUENT on FINANCIALTRANSACTION.CONSTITUENTID = CONSTITUENT.ID
            left join dbo.REVENUEPAYMENTMETHOD on FINANCIALTRANSACTION.ID = REVENUEPAYMENTMETHOD.REVENUEID