TR_REVENUE_DELETE_BBNCREVENUEIDMAP

        CREATE trigger TR_REVENUE_DELETE_BBNCREVENUEIDMAP on dbo.REVENUE after delete not for replication
        as begin
          delete from dbo.BBNCREVENUEIDMAP
            where REVENUEID in (select ID from deleted)
        end