TR_REVENUE_INSERT_BBNCREVENUEIDMAP

        CREATE trigger TR_REVENUE_INSERT_BBNCREVENUEIDMAP on dbo.REVENUE after insert not for replication
        as begin
          insert into dbo.BBNCREVENUEIDMAP (REVENUEID)
            select ID from inserted
        end