TR_FINANCIALTRANSACTIONLINEITEM_REVENUESPLIT_I

          CREATE trigger dbo.TR_FINANCIALTRANSACTIONLINEITEM_REVENUESPLIT_I on dbo.FINANCIALTRANSACTIONLINEITEM for insert not for replication
          as
          begin
          set nocount on

          insert into dbo.BBNCREVENUESPLITIDMAP (REVENUESPLITID)
          select I.ID from inserted as I 
          inner join dbo.FINANCIALTRANSACTION as FT
            on I.FINANCIALTRANSACTIONID = FT.ID
          where
            FT.TYPECODE between 0 and 9

          ;
          end