UFN_REVENUESPLIT_DESCRIPTION_BULK

create function dbo.UFN_REVENUESPLIT_DESCRIPTION_BULK()
returns table
   return select
   FINANCIALTRANSACTIONLINEITEM.ID
  ,case when FINANCIALTRANSACTIONLINEITEM.DELETEDON is null then 
        cast('(' +  case REVENUESPLIT_EXT.APPLICATIONCODE 
        when 0 then N'Donation' 
        when 1 then N'Event registration' 
        when 2 then N'Pledge' 
        when 3 then N'Recurring gift' 
        when 4 then N'Other' 
        when 5 then N'Membership' 
        when 6 then N'Planned gift' 
        when 7 then N'Matching gift' 
        when 8 then N'Grant award' 
        when 9 then N'Admission' 
        when 10 then N'Order' 
        when 11 then N'Miscellaneous' 
        when 12 then N'Auction purchase' 
        when 13 then N'Donor challenge' 
        when 15 then N'Event sponsorship' 
        when 16 then N'Merchandise'  
        when 17 then N'Pending gift'
        when 18 then N'Membership add-on'
        end + ') ' 
        + cast(FINANCIALTRANSACTIONLINEITEM.TRANSACTIONAMOUNT as nvarchar(20)) + ' ' + coalesce(REVENUEPAYMENTMETHOD.PAYMENTMETHOD, 'None') + ' - ' + ltrim(rtrim(CONSTITUENT.NAME)) as nvarchar(700))
        else null end as DESCRIPTION   
from 
  dbo.FINANCIALTRANSACTIONLINEITEM 
inner join dbo.REVENUESPLIT_EXT on FINANCIALTRANSACTIONLINEITEM.ID = REVENUESPLIT_EXT.ID
inner join dbo.FINANCIALTRANSACTION as FT on FT.ID = FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID
left join dbo.REVENUEPAYMENTMETHOD on REVENUEPAYMENTMETHOD.REVENUEID = FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID
left outer join dbo.CONSTITUENT on FT.CONSTITUENTID = CONSTITUENT.ID