Home | Previous Page | Next Page   Appendix A. The stores_demo Database > Data in the stores_demo Database >

orders Table

order_num order_date customer_num ship_instruct backlog po_num ship_date ship_weight ship_charge paid_date
1001 05/20/1998 104 express n B77836 06/01/1998 20.40 10.00 07/22/1998
1002 05/21/1998 101 PO on box; deliver back door only n 9270 05/26/1998 50.60 15.30 06/03/1998
1003 05/22/1998 104 express n B77890 05/23/1998 35.60 10.80 06/14/1998
1004 05/22/1998 106 ring bell twice y 8006 05/30/1998 95.80 19.20
1005 05/24/1998 116 call before delivery n 2865 06/09/1998 80.80 16.20 06/21/1998
1006 05/30/1998 112 after 10AM y Q13557 70.80 14.20
1007 05/31/1998 117 n 278693 06/05/1998 125.90 25.20
1008 06/07/1998 110 closed Monday y LZ230 07/06/1998 45.60 13.80 07/21/1998
1009 06/14/1998 111 door next to grocery n 4745 06/21/1998 20.40 10.00 08/21/1998
1010 06/17/1998 115 deliver 776 King St. if no answer n 429Q 06/29/1998 40.60 12.30 08/22/1998
1011 06/18/1998 104 express n B77897 07/03/1998 10.40 5.00 08/29/1998
1012 06/18/1998 117 n 278701 06/29/1998 70.80 14.20
1013 06/22/1998 104 express n B77930 07/10/1998 60.80 12.20 07/31/1998
1014 06/25/1998 106 ring bell, kick door loudly n 8052 07/03/1998 40.60 12.30 07/10/1998
1015 06/27/1998 110 closed Mondays n MA003 07/16/1998 20.60 6.30 08/31/1998
1016 06/29/1998 119 delivery entrance off Camp St. n PC6782 07/12/1998 35.00 11.80
1017 07/09/1998 120 North side of clubhouse n DM3543
31
07/13/1998 60.00 18.00
1018 07/10/1998 121 SW corner of Biltmore Mall n S22942 07/13/1998 70.50 20.00 08/06/1998
1019 07/11/1998 122 closed til noon Mondays n Z55709 07/16/1998 90.00 23.00 08/06/1998
1020 07/11/1998 123 express n W2286 07/16/1998 14.00 8.50 09/20/1998
1021 07/23/1998 124 ask for Elaine n C3288 07/25/1998 40.00 12.00 08/22/1998
1022 07/24/1998 126 express n W9925 07/30/1998 15.00 13.00 09/02/1998
1023 07/24/1998 127 no deliveries after 3 p.m. n KF2961 07/30/1998 60.00 18.00 08/22/1998
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]