Order ID Employee Order Date Shipped Date Ship Name Ship Address Ship City Ship State Ship ZIP/Postal Code
30 Anne Hellung-Larsen 1/15/2006 1/22/2006 Karen Toh 789 27th Street Las Vegas NV 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
27 30 Northwind Traders Beer 100 $14.00 0 96 83
28 30 Northwind Traders Dried Plums 30 $3.50 0   63
31 Jan Kotas 1/20/2006 1/22/2006 Christina Lee 123 4th Street New York NY 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
29 31 Northwind Traders Dried Pears 10 $30.00 0   64
30 31 Northwind Traders Dried Apples 10 $53.00 0   65
31 31 Northwind Traders Dried Plums 10 $3.50 0   66
32 Mariya Sergienko 1/22/2006 1/22/2006 John Edwards 123 12th Street Las Vegas NV 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
32 32 Northwind Traders Chai 15 $18.00 0   67
33 32 Northwind Traders Coffee 20 $46.00 0   68
33 Michael Neipper 1/30/2006 1/31/2006 Elizabeth Andersen 123 8th Street Portland OR 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
34 33 Northwind Traders Chocolate Biscuits Mix 30 $9.20 0 97 81
34 Anne Hellung-Larsen 2/6/2006 2/7/2006 Christina Lee 123 4th Street New York NY 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
35 34 Northwind Traders Chocolate Biscuits Mix 20 $9.20 0   69
35 Jan Kotas 2/10/2006 2/12/2006 Soo Jung Lee 789 29th Street Denver CO 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
36 35 Northwind Traders Chocolate 10 $11,112.75 0   70
36 Mariya Sergienko 2/23/2006 2/25/2006 Thomas Axen 123 3rd Street Los Angelas CA 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
37 36 Northwind Traders Clam Chowder 200 $9.65 0 98 79
37 Laura Giussani 3/6/2006 3/9/2006 Francisco Pérez-Olaeta 123 6th Street Milwaukee WI 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
38 37 Northwind Traders Curry Sauce 17 $40.00 0   71
38 Anne Hellung-Larsen 3/10/2006 3/11/2006 Amritansh Raghav 789 28th Street Memphis TN 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
39 38 Northwind Traders Coffee 300 $46.00 0 99 77
39 Jan Kotas 3/22/2006 3/24/2006 Elizabeth Andersen 123 8th Street Portland OR 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
40 39 Northwind Traders Chocolate 100 $12.75 0 100 75
40 Mariya Sergienko 3/24/2006 3/24/2006 Roland Wacker 123 10th Street Chicago IL 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
41 40 Northwind Traders Green Tea 200 $2.99 0 101 73
41 Nancy Freehafer 3/24/2006   Ming-Yang Xie 123 7th Street Boise ID 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
42 41 Northwind Traders Coffee 300 $46.00 0 102 104
42 Nancy Freehafer 3/24/2006 4/7/2006 Roland Wacker 123 10th Street Chicago IL 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
43 42 Northwind Traders Boysenberry Spread 10 $25.00 0   84
44 42 Northwind Traders Cajun Seasoning 10 $22.00 0   85
45 42 Northwind Traders Chocolate Biscuits Mix 10 $9.20 0 103 110
43 Nancy Freehafer 3/24/2006   Peter Krschne 123 11th Street Miami FL 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
46 43 Northwind Traders Dried Plums 20 $3.50 0   86
47 43 Northwind Traders Green Tea 50 $2.99 0   87
44 Nancy Freehafer 3/24/2006   Anna Bedecs 123 1st Street Seattle WA 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
48 44 Northwind Traders Chai 25 $18.00 0   88
49 44 Northwind Traders Coffee 25 $46.00 0   89
50 44 Northwind Traders Green Tea 25 $2.99 0   90
45 Nancy Freehafer 4/7/2006 4/7/2006 Amritansh Raghav 789 28th Street Memphis TN 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
51 45 Northwind Traders Clam Chowder 50 $9.65 0 104 116
52 45 Northwind Traders Crab Meat 50 $18.40 0   91
46 Robert Zare 4/5/2006 4/5/2006 Sven Mortensen 123 9th Street Salt Lake City UT 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
53 46 Northwind Traders Ravioli 100 $19.50 0 105 101
54 46 Northwind Traders Mozzarella 50 $34.80 0 106 114
47 Michael Neipper 4/8/2006 4/8/2006 Francisco Pérez-Olaeta 123 6th Street Milwaukee WI 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
55 47 Northwind Traders Beer 300 $14.00 0 107 108
48 Mariya Sergienko 4/5/2006 4/5/2006 Elizabeth Andersen 123 8th Street Portland OR 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
56 48 Northwind Traders Curry Sauce 25 $40.00 0 108 106
57 48 Northwind Traders Chocolate Biscuits Mix 25 $9.20 0 109 112
50 Anne Hellung-Larsen 4/5/2006 4/5/2006 John Rodman 789 25th Street Chicago IL 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
59 50 Northwind Traders Scones 20 $10.00 0   92
51 Anne Hellung-Larsen 4/5/2006 4/5/2006 Run Liu 789 26th Street Miami FL 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
60 51 Northwind Traders Olive Oil 25 $21.35 0   93
61 51 Northwind Traders Clam Chowder 30 $9.65 0   94
62 51 Northwind Traders Crab Meat 30 $18.40 0   95
55 Nancy Freehafer 4/5/2006 4/5/2006 Soo Jung Lee 789 29th Street Denver CO 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
67 55 Northwind Traders Beer 87 $14.00 0   117
56 Andrew Cencini 4/3/2006 4/3/2006 Francisco Pérez-Olaeta 123 6th Street Milwaukee WI 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
66 56 Northwind Traders Chocolate 10 $12.75 0 111 99
57 Anne Hellung-Larsen 4/22/2006 4/22/2006 Karen Toh 789 27th Street Las Vegas NV 99999
58 Jan Kotas 4/22/2006 4/22/2006 Christina Lee 123 4th Street New York NY 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
84 58 Northwind Traders Marmalade 40 $81.00 0   134
85 58 Northwind Traders Long Grain Rice 40 $7.00 0   135
59 Mariya Sergienko 4/22/2006 4/22/2006 John Edwards 123 12th Street Las Vegas NV 99999
60 Michael Neipper 4/30/2006 4/30/2006 Elizabeth Andersen 123 8th Street Portland OR 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
81 60 Northwind Traders Mozzarella 40 $34.80 0   131
61 Anne Hellung-Larsen 4/7/2006 4/7/2006 Christina Lee 123 4th Street New York NY 99999
62 Jan Kotas 4/12/2006 4/12/2006 Soo Jung Lee 789 29th Street Denver CO 99999
63 Mariya Sergienko 4/25/2006 4/25/2006 Thomas Axen 123 3rd Street Los Angelas CA 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
82 63 Northwind Traders Syrup 50 $10.00 0   132
83 63 Northwind Traders Curry Sauce 3 $40.00 0   133
64 Laura Giussani 5/9/2006 5/9/2006 Francisco Pérez-Olaeta 123 6th Street Milwaukee WI 99999
65 Anne Hellung-Larsen 5/11/2006 5/11/2006 Amritansh Raghav 789 28th Street Memphis TN 99999
66 Jan Kotas 5/24/2006 5/24/2006 Elizabeth Andersen 123 8th Street Portland OR 99999
67 Mariya Sergienko 5/24/2006 5/24/2006 Roland Wacker 123 10th Street Chicago IL 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
80 67 Northwind Traders Almonds 20 $10.00 0   130
68 Nancy Freehafer 5/24/2006   Ming-Yang Xie 123 7th Street Boise ID 99999
69 Nancy Freehafer 5/24/2006   Roland Wacker 123 10th Street Chicago IL 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
79 69 Northwind Traders Dried Plums 15 $3.50 0   129
70 Nancy Freehafer 5/24/2006   Peter Krschne 123 11th Street Miami FL 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
78 70 Northwind Traders Curry Sauce 20 $40.00 0   128
71 Nancy Freehafer 5/24/2006   Anna Bedecs 123 1st Street Seattle WA 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
77 71 Northwind Traders Crab Meat 40 $18.40 0   127
72 Nancy Freehafer 6/7/2006 6/7/2006 Amritansh Raghav 789 28th Street Memphis TN 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
76 72 Northwind Traders Coffee 5 $46.00 0   126
73 Robert Zare 6/5/2006 6/5/2006 Sven Mortensen 123 9th Street Salt Lake City UT 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
75 73 Northwind Traders Clam Chowder 10 $9.65 0   125
74 Michael Neipper 6/8/2006 6/8/2006 Francisco Pérez-Olaeta 123 6th Street Milwaukee WI 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
74 74 Northwind Traders Chocolate 40 $12.75 0   124
75 Mariya Sergienko 6/5/2006 6/5/2006 Elizabeth Andersen 123 8th Street Portland OR 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
73 75 Northwind Traders Chocolate 40 $12.75 0   123
76 Anne Hellung-Larsen 6/5/2006 6/5/2006 John Rodman 789 25th Street Chicago IL 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
72 76 Northwind Traders Cajun Seasoning 30 $22.00 0   122
77 Anne Hellung-Larsen 6/5/2006 6/5/2006 Run Liu 789 26th Street Miami FL 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
71 77 Northwind Traders Boysenberry Spread 90 $25.00 0   121
78 Nancy Freehafer 6/5/2006 6/5/2006 Soo Jung Lee 789 29th Street Denver CO 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
70 78 Northwind Traders Fruit Cocktail 40 $39.00 0   120
79 Andrew Cencini 6/23/2006 6/23/2006 Francisco Pérez-Olaeta 123 6th Street Milwaukee WI 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
68 79 Northwind Traders Dried Pears 30 $30.00 0   119
69 79 Northwind Traders Dried Apples 30 $53.00 0   118
80 Andrew Cencini 4/25/2006 17:03   Christina Lee 123 4th Street New York NY 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
86 80 Northwind Traders Gnocchi 10 $38.00 0   136
81 Andrew Cencini 4/25/2006 17:26   Thomas Axen 123 3rd Street Los Angelas CA 99999
ID Order ID Product Quantity Unit Price Discount Purchase Order ID Inventory ID
90 81 Northwind Traders Green Tea 0 $2.99 0    
91 81 Northwind Traders Gnocchi 0 $38.00 0