UFN_FINANCIALTRANSACTION_GETFIRSTGIFTS

create function dbo.[UFN_FINANCIALTRANSACTION_GETFIRSTGIFTS]()
returns table
as
return (
  select
    [FINANCIALOUTER].[ID]
  from dbo.[FINANCIALTRANSACTION] as [FINANCIALOUTER]
  where 
    -- mimic functionality in the UFN_REVENUE_ISFIRSTGIFTDATE scalar function

    ([FINANCIALOUTER].[TYPECODE] < 10 or [FINANCIALOUTER].[TYPECODE] = 15) 
    and [FINANCIALOUTER].[DELETEDON] is null
    and [FINANCIALOUTER].[DATE] = (select min([FINANCIALTRANSACTION].[DATE])
                                   from dbo.[FINANCIALTRANSACTION] 
                                   where [FINANCIALTRANSACTION].[CONSTITUENTID] = [FINANCIALOUTER].[CONSTITUENTID])
      )