Order ID Order Date Ship Date Aging Order Priority

0 AU-2015-1 2015-11-092015-11-17 8 Medium

1 AU-2015-2 2015-06-302015-07-02 2 Medium
2 AU-2015-3 2015-12-052015-12-13 8 Critical
3 AU-2015-4 2015-05-092015-05-16 7 High
4 AU-2015-5 2015-07-092015-07-18 9 Critical
5 AU-2015-6 2015-02-252015-03-05 8 Critical
6 AU-2015-7 2015-04-092015-04-10 1 High
7 AU-2015-8 2015-03-302015-04-06 7 Critical
8 AU-2015-9 2015-02-092015-02-16 7 Critical
9 AU-2015-1 2015-04-212015-05-01 10 Critical
10 AU-2015-1 2015-11-162015-11-26 10 Critical
11 AU-2015-1 2015-09-012015-09-02 1 High
12 AU-2015-1 2015-07-092015-07-16 7 Critical
13 AU-2015-1 2015-07-222015-07-27 5 High
14 AU-2015-1 2015-10-122015-10-21 9 Medium
15 AU-2015-1 2015-02-232015-03-05 10 Critical
16 AU-2015-1 2015-05-042015-05-08 4 High
17 AU-2015-1 2015-06-122015-06-19 7 High
18 AU-2015-1 2015-05-132015-05-20 7 Critical
19 AU-2015-2 2015-07-272015-08-02 6 Critical
20 AU-2015-2 2015-12-092015-12-13 4 Critical
21 AU-2015-2 2015-02-092015-02-16 7 High
22 AU-2015-2 2015-07-202015-07-26 6 High
23 AU-2015-2 2015-11-222015-11-24 2 Critical
24 AU-2015-2 2015-02-222015-03-02 8 High
25 AU-2015-2 2015-04-062015-04-10 4 Critical
26 AU-2015-2 2015-07-272015-08-04 8 Critical
27 AU-2015-2 2015-09-292015-10-05 5 High
28 AU-2015-2 2015-04-112015-04-18 7 Medium
29 AU-2015-3 2015-01-232015-01-27 4 High
30 AU-2015-3 2015-03-312015-04-09 9 Critical
31 AU-2015-3 2015-11-242015-11-29 5 Medium
32 AU-2015-3 2015-08-242015-09-03 10 High
33 AU-2015-3 2015-05-042015-05-09 5 Critical
34 AU-2015-3 2015-07-152015-07-16 1 High
35 AU-2015-3 2015-10-032015-10-07 4 High
36 AU-2015-3 2015-06-282015-07-04 6 Medium
37 AU-2015-3 2015-08-012015-08-04 3 Critical
38 AU-2015-3 2015-06-072015-06-09 2 High
39 AU-2015-4 2015-08-162015-08-22 6 Critical
40 AU-2015-4 2015-07-092015-07-13 4 Critical
41 AU-2015-4 2015-02-252015-03-05 8 Critical
42 AU-2015-4 2015-10-262015-10-27 1 High
43 AU-2015-4 2015-12-222015-12-27 5 Critical
44 AU-2015-4 2015-04-242015-05-01 7 High
45 AU-2015-4 2015-09-202015-09-28 8 Critical
46 AU-2015-4 2015-03-122015-03-18 6 Critical
47 AU-2015-4 2015-03-302015-03-31 1 Critical
48 AU-2015-4 2015-07-232015-07-29 6 Critical
49 AU-2015-5 2015-01-252015-01-30 5 Medium
50 AU-2015-5 2015-06-052015-06-08 3 Critical
51 AU-2015-5 2015-11-272015-12-03 6 High
52 AU-2015-5 2015-06-192015-06-23 4 High
53 AU-2015-5 2015-10-142015-10-16 2 High
54 AU-2015-5 2015-07-012015-07-07 6 High
55 AU-2015-5 2015-08-112015-08-16 5 Critical
56 AU-2015-5 2015-09-012015-09-09 8 High
57 AU-2015-5 2015-02-162015-02-21 5 Critical
58 AU-2015-5 2015-01-062015-01-12 6 Medium
59 AU-2015-6 2015-09-042015-09-07 3 High
60 AU-2015-6 2015-12-272016-01-05 9 High
61 AU-2015-6 2015-03-272015-04-05 9 High
62 AU-2015-6 2015-08-272015-09-04 8 Medium
63 AU-2015-6 2015-08-242015-08-26 2 Critical
64 AU-2015-6 2015-04-092015-04-13 4 Medium
65 AU-2015-6 2015-08-202015-08-22 2 High
66 AU-2015-6 2015-02-082015-02-11 3 High
67 AU-2015-6 2015-11-262015-11-27 1 High
68 AU-2015-6 2015-05-192015-05-21 2 High
69 AU-2015-7 2015-07-232015-07-27 4 Critical
70 AU-2015-7 2015-03-062015-03-08 2 Medium
71 AU-2015-7 2015-09-202015-09-23 3 Medium
72 AU-2015-7 2015-10-072015-10-13 6 High
73 AU-2015-7 2015-05-302015-05-31 1 Critical
74 AU-2015-7 2015-12-192015-12-23 4 High
75 AU-2015-7 2015-12-032015-12-05 2 High
76 AU-2015-7 2015-04-282015-05-07 9 Critical
77 AU-2015-7 2015-12-122015-12-22 10 Critical
78 AU-2015-7 2015-09-192015-09-23 4 High
79 AU-2015-8 2015-06-252015-07-03 8 Critical
80 AU-2015-8 2015-01-192015-01-27 8 High
81 AU-2015-8 2015-06-172015-06-25 8 High
82 AU-2015-8 2015-04-112015-04-21 10 High
83 AU-2015-8 2015-06-032015-06-04 1 Critical
84 AU-2015-8 2015-05-232015-05-24 1 High
85 AU-2015-8 2015-06-292015-07-02 3 Critical
86 AU-2015-8 2015-03-282015-04-04 7 High
87 AU-2015-8 2015-05-122015-05-19 7 Critical
88 AU-2015-8 2015-03-242015-03-25 1 High
89 AU-2015-9 2015-12-282016-01-01 4 Critical
90 AU-2015-9 2015-06-012015-06-03 2 High
91 AU-2015-9 2015-09-072015-09-12 5 Critical
92 AU-2015-9 2015-11-252015-12-05 10 Critical
93 AU-2015-9 2015-07-042015-07-06 2 Critical
94 AU-2015-9 2015-07-312015-08-08 8 High
95 AU-2015-9 2015-04-102015-04-15 5 Critical
96 AU-2015-9 2015-01-242015-01-31 7 High
97 AU-2015-9 2015-03-052015-03-13 8 High
98 AU-2015-9 2015-02-152015-02-20 5 Critical
 Order ID
Product Category
Product Quantity Discount
0 AU-2015-1 Auto & AcceCar Media P 2 0.05
1 AU-2015-2 Auto & AcceCar Speake 3 0.03
2 AU-2015-3 Auto & AcceCar Body C 5 0.01
3 AU-2015-4 Auto & AcceCar & Bike 2 0.05
4 AU-2015-5 Auto & AcceTyre 1 0.04
5 AU-2015-6 Auto & AcceBike Tyres 3 0.04
6 AU-2015-7 Auto & AcceCar Mat 1 0.05
7 AU-2015-8 Auto & AcceCar Seat Co 5 0.02
8 AU-2015-9 Auto & AcceCar Pillow 5 0.03
9 AU-2015-1 Auto & AcceCar Media P 2 0.02
10 AU-2015-1 Auto & AcceCar Speake 4 0.01
11 AU-2015-1 Auto & AcceCar Body C 4 0.04
12 AU-2015-1 Auto & AcceCar & Bike 1 0.02
13 AU-2015-1 Auto & AcceTyre 3 0.04
14 AU-2015-1 Auto & AcceBike Tyres 4 0.01
15 AU-2015-1 Auto & AcceCar Mat 2 0.01
16 AU-2015-1 Auto & AcceCar Seat Co 2 0.05
17 AU-2015-1 Auto & AcceCar Pillow 5 0.05
18 AU-2015-1 Auto & AcceCar Media P 2 0.05
19 AU-2015-2 Auto & AcceCar Speake 2 0.02
20 AU-2015-2 Auto & AcceCar Body C 5 0.01
21 AU-2015-2 Auto & AcceCar & Bike 2 0.03
22 AU-2015-2 Auto & AcceTyre 4 0.02
23 AU-2015-2 Auto & AcceBike Tyres 4 0.02
24 AU-2015-2 Auto & AcceCar Mat 1 0.05
25 AU-2015-2 Auto & AcceCar Seat Co 4 0.02
26 AU-2015-2 Auto & AcceCar Pillow 1 0.03
27 AU-2015-2 Auto & AcceCar Media P 1 0.03
28 AU-2015-2 Auto & AcceCar Speake 3 0.03
29 AU-2015-3 Auto & AcceCar Body C 1 0.02
30 AU-2015-3 Auto & AcceCar & Bike 3 0.03
31 AU-2015-3 Auto & AcceTyre 1 0.02
32 AU-2015-3 Auto & AcceBike Tyres 4 0.05
33 AU-2015-3 Auto & AcceCar Mat 4 0.05
34 AU-2015-3 Auto & AcceCar Seat Co 4 0.01
35 AU-2015-3 Auto & AcceCar Pillow 2 0.05
36 AU-2015-3 Auto & AcceCar Media P 5 0.04
37 AU-2015-3 Auto & AcceCar Speake 4 0.01
38 AU-2015-3 Auto & AcceCar Body C 1 0.04
39 AU-2015-4 Auto & AcceCar & Bike 5 0.04
40 AU-2015-4 Auto & AcceTyre 5 0.03
41 AU-2015-4 Auto & AcceBike Tyres 5 0.02
42 AU-2015-4 Auto & AcceCar Mat 5 0.01
43 AU-2015-4 Auto & AcceCar Seat Co 4 0.04
44 AU-2015-4 Auto & AcceCar Pillow 4 0.04
45 AU-2015-4 Auto & AcceCar Media P 2 0.05
46 AU-2015-4 Auto & AcceCar Speake 1 0
47 AU-2015-4 Auto & AcceCar Body C 4 0.05
48 AU-2015-4 Auto & AcceCar & Bike 5 0.04
49 AU-2015-5 Auto & AcceTyre 2 0.01
50 AU-2015-5 Auto & AcceBike Tyres 2 0.01
51 AU-2015-5 Auto & AcceCar Mat 5 0.03
52 AU-2015-5 Auto & AcceCar Seat Co 4 0
53 AU-2015-5 Auto & AcceCar Pillow 2 0.04
54 AU-2015-5 Auto & AcceCar Media P 2 0.03
55 AU-2015-5 Auto & AcceCar Speake 1 0.01
56 AU-2015-5 Auto & AcceCar Body C 4 0.02
57 AU-2015-5 Auto & AcceCar & Bike 3 0.05
58 AU-2015-5 Auto & AcceTyre 1 0
59 AU-2015-6 Auto & AcceBike Tyres 2 0.03
60 AU-2015-6 Auto & AcceCar Mat 5 0.01
61 AU-2015-6 Auto & AcceCar Seat Co 3 0.01
62 AU-2015-6 Auto & AcceCar Pillow 5 0.02
63 AU-2015-6 Auto & AcceCar Media P 1 0.05
64 AU-2015-6 Auto & AcceCar Speake 2 0.05
65 AU-2015-6 Auto & AcceCar Body C 1 0.02
66 AU-2015-6 Auto & AcceCar & Bike 1 0.01
67 AU-2015-6 Auto & AcceTyre 1 0.01
68 AU-2015-6 Auto & AcceBike Tyres 1 0.02
69 AU-2015-7 Auto & AcceCar Mat 1 0
70 AU-2015-7 Auto & AcceCar Seat Co 4 0.03
71 AU-2015-7 Auto & AcceCar Pillow 3 0.05
72 AU-2015-7 Auto & AcceCar Media P 4 0.05
73 AU-2015-7 Auto & AcceCar Speake 5 0.01
74 AU-2015-7 Auto & AcceCar Body C 4 0.01
75 AU-2015-7 Auto & AcceCar & Bike 1 0.01
76 AU-2015-7 Auto & AcceTyre 4 0.03
77 AU-2015-7 Auto & AcceBike Tyres 4 0.04
78 AU-2015-7 Auto & AcceCar Mat 5 0.03
79 AU-2015-8 Auto & AcceCar Seat Co 1 0.05
80 AU-2015-8 Auto & AcceCar Pillow 1 0.03
81 AU-2015-8 Auto & AcceCar Media P 1 0.01
82 AU-2015-8 Auto & AcceCar Speake 5 0.03
83 AU-2015-8 Auto & AcceCar Body C 3 0
84 AU-2015-8 Auto & AcceCar & Bike 2 0
85 AU-2015-8 Auto & AcceTyre 4 0
86 AU-2015-8 Auto & AcceBike Tyres 2 0
87 AU-2015-8 Auto & AcceCar Mat 2 0
88 AU-2015-8 Auto & AcceCar Seat Co 2 0.04
89 AU-2015-9 Auto & AcceCar Pillow 5 0.04
90 AU-2015-9 Auto & AcceCar Media P 1 0.04
91 AU-2015-9 Auto & AcceCar Speake 3 0.01
92 AU-2015-9 Auto & AcceCar Body C 2 0.02
93 AU-2015-9 Auto & AcceCar & Bike 4 0.04
94 AU-2015-9 Auto & AcceTyre 4 0.03
95 AU-2015-9 Auto & AcceBike Tyres 2 0.05
96 AU-2015-9 Auto & AcceCar Mat 5 0.02
97 AU-2015-9 Auto & AcceCar Seat Co 3 0.04
98 AU-2015-9 Auto & AcceCar Pillow 2 0
 Customer
Customer
ID First
Customer
Name Last Name
0 LS-001 Lane Daniels
1 IZ-002 Alvarado Kriz
2 EN-003 Moon Weien
3 AN-004 Sanchez Bergman
4 ON-005 Rowe Jackson
5 TO-006 Carter Barreto
6 OM-007 Mcconnell Tom
7 AN-008 Dennis Holloman
8 EN-009 Wall Olsen
9 TT-0010 Shepard Witt
10 ED-0011 Johns Reed
11 ON-0012 Doyle Knutson
12 WN-0013 Butler Brown
13 AN-0014 Johnson Abelman
14 EY-0015 Greene Decherney
15 RN-0016 Bentley Zypern
16 CK-0017 Rivera Black
17 RE-0018 Wong Macintyre
18 ON-0019 Hendricks Wilson
19 ED-0020 Johns Reed
20 AM-0021 Barr Sundaresam
21 KE-0022 Holt Glocke
22 LL-0023 Gaines O'Carroll
23 CO-0024 Copeland Lomonaco
24 NA-0025 Vasquez Dona
25 LL-0026 Freeman Castell
26 LE-0027 Reid Engle
27 NG-0028 Harris Armstrong
28 ED-0029 Everett Sweed
29 AS-0030 Poole Lucas
30 WN-0031 Gonzales Brown
31 AN-0032 Perry Brennan
32 KI-0033 Garner Hirasaki
33 EE-0034 Norton Magee
34 ON-0035 Bean Thompson
35 SH-0036 Bond Overcash
36 KE-0037 Holt Glocke
37 YD-0038 Moran Lloyd
38 MS-0039 Jones Adams
39 RE-0040 Wong Macintyre
40 ER-0041 Strong Schoenberger
41 IN-0042 Terrell Zeldin
42 EN-0043 Reyes Christensen
43 DI-0044 Dean Etezadi
44 TT-0045 Hess Prescott
45 ER-0046 Russo Webber
46 CH-0047 Kerr Toch
47 CK-0048 Anthony Myrick
48 TT-0049 Fuller Eplett
49 RS-0050 Hernandez Badders
50 AN-0051 Smith Abelman
51 LE-0052 Mcdowell Roelle
52 IS-0053 Humphrey Preis
53 LY-0054 Winters Shonely
54 NT-0055 Heath O'Briant
55 IE-0056 Clayton Marie
56 SS-0057 Steele Gross
57 ON-0058 Trujillo Sheldon
58 EN-0059 Kelly Braden
59 ON-0060 Yates Johnson
60 KS-0061 Flores Brooks
61 ON-0062 Sellers Stevenson
62 EY-0063 Carpenter Decherney
63 ED-0064 Johns Reed
64 RE-0065 Knox Sayre
65 LL-0066 Leblanc Spruell
66 SS-0067 Berg Weiss
67 EN-0068 Kelly Braden
68 LO-0069 Sanford Zydlo
69 ER-0070 Russo Webber
70 NT-0071 Ferguson Conant
71 ON-0072 Santiago Grayson
72 RT-0073 Foley Stewart
73 EP-0074 Dorsey Prichep
74 AN-0075 Miranda Ryan
75 CH-0076 Parsons Leinenbach
76 NN-0077 Bruce Nunn
77 ON-0078 Sherman Knutson
78 LL-0079 Gibson Carroll
79 NS-0080 Perkins Cousins
80 NA-0081 Vasquez Dona
81 SH-0082 Mann Hirsh
82 ER-0083 Golden Ritter
83 ON-0084 Walton Jackson
84 NI-0085 Blanchard Vittorini
85 LE-0086 Tucker Caudle
86 EN-0087 Hodge Moren
87 EN-0088 Duncan Dahlen
88 ER-0089 Estrada Kiefer
89 EN-0090 Miller Allen
90 IS-0091 Riley Davis
91 LL-0092 Mcclain O'Donnell
92 EN-0093 Gardner Craven
93 DE-0094 Fletcher Gnade
94 ER-0095 Elliott Deggeller
95 ON-0096 Stokes Knudson
96 ON-0097 Hatfield Trafton
97 ND-0098 Henry Chand
98 ND-0099 York Redmond
 Customer ID City Country Region
0 LS-001 Brisbane Australia Oceania
1 IZ-002 Berlin Germany Central
2 EN-003 Porirua New ZealanOceania
3 AN-004 Kabul Afghanista Central Asia
4 ON-005 Townsville Australia Oceania
5 TO-006 Bytom Poland EMEA
6 OM-007 Chicago United StatCentral
7 AN-008 Suzhou China North Asia
8 EN-009 Juárez Mexico North
9 TT-0010 SoyapangoEl SalvadorCentral
10 ED-0011 Taipei Taiwan North Asia
11 ON-0012 Los AngelesUnited StatWest
12 WN-0013 Saint-BrieuFrance Central
13 AN-0014 Kamina DemocraticAfrica
14 EY-0015 Brisbane Australia Oceania
15 RN-0016 Berlin Germany Central
16 CK-0017 ShouguangChina North Asia
17 RE-0018 New York CUnited StatEast
18 ON-0019 Behshahr Iran EMEA
19 ED-0020 Taipei Taiwan North Asia
20 AM-0021 Bhopal India Central Asia
21 KE-0022 Seattle United StatWest
22 LL-0023 Geraldton Australia Oceania
23 CO-0024 Celle Germany Central
24 NA-0025 Seville Spain South
25 LL-0026 Raipur India Central Asia
26 LE-0027 Kharkiv Ukraine EMEA
27 NG-0028 Jinan China North Asia
28 ED-0029 ChinandegaNicaragua Central
29 AS-0030 PalembangIndonesia Southeast Asia
30 WN-0031 Duisburg Germany Central
31 AN-0032 Tongi BangladeshCentral Asia
32 KI-0033 Suzhou China North Asia
33 EE-0034 HendersonUnited StatWest
34 ON-0035 Manila Philippines Southeast Asia
35 SH-0036 Graz Austria Central
36 KE-0037 Puebla Mexico North
37 YD-0038 Augsburg Germany Central
38 MS-0039 Medellín Colombia South
39 RE-0040 Sydney Australia Oceania
40 ER-0041 Los AngelesUnited StatWest
41 IN-0042 Zigong China North Asia
42 EN-0043 Adelaide Australia Oceania
43 DI-0044 Kuantan Malaysia Southeast Asia
44 TT-0045 HarrisonbuUnited StatSouth
45 ER-0046 Everett United StatEast
46 CH-0047 Vadodara India Central Asia
47 CK-0048 Sanya China North Asia
48 TT-0049 San Diego United StatWest
49 RS-0050 Guaymas Mexico North
50 AN-0051 Wuhan China North Asia
51 LE-0052 Madison United StatCentral
52 IS-0053 Salto Brazil South
53 LY-0054 Hargeysa Somalia Africa
54 NT-0055 Perth Australia Oceania
55 IE-0056 Anshan China North Asia
56 SS-0057 AmsterdamNetherlandCentral
57 ON-0058 Le Petit-Que
France Central
58 EN-0059 Detroit United StatCentral
59 ON-0060 Hamburg Germany Central
60 KS-0061 Morelia Mexico North
61 ON-0062 ChangchunChina North Asia
62 EY-0063 Madrid Spain South
63 ED-0064 Taipei Taiwan North Asia
64 RE-0065 Newcastle Australia Oceania
65 LL-0066 Surakarta Indonesia Southeast Asia
66 SS-0067 New York CUnited StatEast
67 EN-0068 Beijing China North Asia
68 LO-0069 London United Kin North
69 ER-0070 Talence France Central
70 NT-0071 Aurangaba India Central Asia
71 ON-0072 Los AngelesUnited StatWest
72 RT-0073 Marikina Philippines Southeast Asia
73 EP-0074 JohannesbuSouth AfricAfrica
74 AN-0075 ProvidenceUnited StatEast
75 CH-0076 Qingdao China North Asia
76 NN-0077 Kozhikode India Central Asia
77 ON-0078 Adelaide Australia Oceania
78 LL-0079 Kuala LumpMalaysia Southeast Asia
79 NS-0080 Columbus United StatEast
80 NA-0081 Xiangtan China North Asia
81 SH-0082 Marikina Philippines Southeast Asia
82 ER-0083 Dijon France Central
83 ON-0084 Cairo Egypt Africa
84 NI-0085 Detroit United StatCentral
85 LE-0086 New York CUnited StatEast
86 EN-0087 Burnley United Kin North
87 EN-0088 Laval France Central
88 ER-0089 Buenos Air Argentina South
89 EN-0090 Kochi India Central Asia
90 IS-0091 Maseru Lesotho Africa
91 LL-0092 Matagalpa Nicaragua Central
92 EN-0093 Managua Nicaragua Central
93 DE-0094 Strasbourg France Central
94 ER-0095 Surabaya Indonesia Southeast Asia
95 ON-0096 Tupã Brazil South
96 ON-0097 Vienna Austria Central
97 ND-0098 Hirakata Japan North Asia
98 ND-0099 Granollers Spain South