Copy Code Trigger Definition 

                
                CREATE trigger TR_REVENUERECOGNITION_INSERT_BBNCREVENUERECOGNITIONIDMAP on dbo.REVENUERECOGNITION after insert not for replication
                as begin
                    insert into dbo.BBNCREVENUERECOGNITIONIDMAP (REVENUERECOGNITIONID)
                        select ID from inserted
                end