TR_FINANCIALTRANSACTIONLINEITEM_REVENUESPLIT_I (Trigger)

          
          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