creating views for orders and stock records