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