Advertisement
Guest User

Untitled

a guest
Dec 10th, 2019
142
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.55 KB | None | 0 0
  1. INSERT INTO WAREHOUSE_ORDERS VALUES ( '6', '12/09/19', '11/09/19', '11/15/19', 'REPLENISHMENT', '1', 'DELIVERED', '4', '6', '11/16/19'),
  2. ( '7', '12/10/19', '11/10/19', '11/16/19', 'PURCHASE_ORDER', '2', 'SHIPPED', '5', '7', '11/17/19'),
  3. ( '8', '12/11/19', '11/11/19', '11/17/19', 'PURCHASE_ORDER', '3', 'READY_TO_SHIP', '6', '8', '11/18/19'),
  4. ( '9', '12/12/19', '11/12/19', '11/18/19', 'CUSTOMER_ORDER', '4', 'CANCELLED', '7', '9', '11/19/19'),
  5. ( '10', '12/13/19', '11/13/19', '11/19/19', 'CUSTOMER_ORDER', '4', 'ORDERED', '7', '10', '11/20/19')
  6.  
  7.  
  8. INSERT INTO ORDER_LINES VALUES ( '6', '6', '200', null),
  9. ( '7', '7', '50', null),
  10. ( '8', '8', '50', null),
  11. ( '9', '9', '11', null),
  12. ( '10', '10', '5', null)
  13.  
  14.  
  15. INSERT INTO PALLETS VALUES ( '4', 'INCOMING', '500', '12/04/19', '250', '12/09/19', '1', '3', '5', '4'),
  16. ( '5', 'OUTGOING', '100', '12/05/19', '150', '12/10/19', '2', '5', '3', '2'),
  17. ( '6', 'OUTGOING', '150', '12/06/19', '200', '12/11/19', '3', '1', '1', '3')
  18.  
  19.  
  20. INSERT INTO INVENTORY VALUES ('11', '50', '4.99', '11/01/19', '10', '1', '3', '1'),
  21. ('12', '50', '149.99', '11/01/19', '9', '2', '3', '1'),
  22. ('13', '75', '99.99', '11/01/19', '1', '1', '2', '2'),
  23. ('14', '100', '19.99', '11/03/19', '4', '3', '2', '3'),
  24. ('15', '100', '9.99', '11/03/19', '7', '3', '4', '4')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement