-
Notifications
You must be signed in to change notification settings - Fork 0
/
databaseData.sql
430 lines (374 loc) · 171 KB
/
databaseData.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
CREATE DATABASE IF NOT EXISTS `northwind` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `northwind`;
-- MySQL dump 10.13 Distrib 8.0.27, for Win64 (x86_64)
--
-- Host: 127.0.0.1 Database: northwind
-- ------------------------------------------------------
-- Server version 8.0.27
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `category`
--
DROP TABLE IF EXISTS `category`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `category` (
`categoryId` int NOT NULL AUTO_INCREMENT,
`categoryName` varchar(15) COLLATE utf8_bin NOT NULL,
`description` text COLLATE utf8_bin,
`picture` blob,
PRIMARY KEY (`categoryId`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `category`
--
LOCK TABLES `category` WRITE;
/*!40000 ALTER TABLE `category` DISABLE KEYS */;
INSERT INTO `category` VALUES (1,'Beverages','Soft drinks, coffees, teas, beers, and ales',NULL),(2,'Condiments','Sweet and savory sauces, relishes, spreads, and seasonings',NULL),(3,'Confections','Desserts, candies, and sweet breads',NULL),(4,'Dairy Products','Cheeses',NULL),(5,'Grains/Cereals','Breads, crackers, pasta, and cereal',NULL),(6,'Meat/Poultry','Prepared meats',NULL),(7,'Produce','Dried fruit and bean curd',NULL),(8,'Seafood','Seaweed and fish',NULL),(9,'Seafood','tasty',NULL),(10,'Seafood','tasty',NULL),(13,'Seafood','tasty',NULL),(14,'Seafood','tasty',NULL),(15,'Seafood','tasty',NULL),(16,'Seafood','tasty',NULL),(17,'Seafood','tasty',NULL),(18,'Seafood','tasty',NULL),(19,'Seafood','tasty',NULL),(20,'Seafood','tasty',NULL),(21,'Seafood','tasty',NULL),(22,'Seafood','tasty',NULL),(23,'Seafood','tasty',NULL),(24,'Seafood','tasty',NULL);
/*!40000 ALTER TABLE `category` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `custcustdemographics`
--
DROP TABLE IF EXISTS `custcustdemographics`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `custcustdemographics` (
`custId` int NOT NULL,
`customerTypeId` int NOT NULL,
PRIMARY KEY (`custId`,`customerTypeId`),
KEY `customerTypeId` (`customerTypeId`),
CONSTRAINT `custcustdemographics_ibfk_1` FOREIGN KEY (`custId`) REFERENCES `customer` (`custId`),
CONSTRAINT `custcustdemographics_ibfk_2` FOREIGN KEY (`customerTypeId`) REFERENCES `customerdemographics` (`customerTypeId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `custcustdemographics`
--
LOCK TABLES `custcustdemographics` WRITE;
/*!40000 ALTER TABLE `custcustdemographics` DISABLE KEYS */;
/*!40000 ALTER TABLE `custcustdemographics` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `customer`
--
DROP TABLE IF EXISTS `customer`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `customer` (
`custId` int NOT NULL AUTO_INCREMENT,
`companyName` varchar(40) COLLATE utf8_bin NOT NULL,
`contactName` varchar(30) COLLATE utf8_bin DEFAULT NULL,
`contactTitle` varchar(30) COLLATE utf8_bin DEFAULT NULL,
`address` varchar(60) COLLATE utf8_bin DEFAULT NULL,
`city` varchar(15) COLLATE utf8_bin DEFAULT NULL,
`region` varchar(15) COLLATE utf8_bin DEFAULT NULL,
`postalCode` varchar(10) COLLATE utf8_bin DEFAULT NULL,
`country` varchar(15) COLLATE utf8_bin DEFAULT NULL,
`phone` varchar(24) COLLATE utf8_bin DEFAULT NULL,
`mobile` varchar(24) COLLATE utf8_bin DEFAULT NULL,
`email` varchar(225) COLLATE utf8_bin DEFAULT NULL,
`fax` varchar(24) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`custId`)
) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `customer`
--
LOCK TABLES `customer` WRITE;
/*!40000 ALTER TABLE `customer` DISABLE KEYS */;
INSERT INTO `customer` VALUES (1,'Customer NRZBB','Allen, Michael','Sales Representative','Obere Str. 0123','Berlin',NULL,'10092','Germany','030-3456789',NULL,NULL,'030-0123456'),(2,'Customer MLTDN','Hassall, Mark','Owner','Avda. de la Constitución 5678','México D.F.',NULL,'10077','Mexico','(5) 789-0123',NULL,NULL,'(5) 456-7890'),(3,'Customer KBUDE','Peoples, John','Owner','Mataderos 7890','México D.F.',NULL,'10097','Mexico','(5) 123-4567',NULL,NULL,NULL),(4,'Customer HFBZG','Arndt, Torsten','Sales Representative','7890 Hanover Sq.','London',NULL,'10046','UK','(171) 456-7890',NULL,NULL,'(171) 456-7891'),(5,'Customer HGVLZ','Higginbotham, Tom','Order Administrator','Berguvsvägen 5678','Luleå',NULL,'10112','Sweden','0921-67 89 01',NULL,NULL,'0921-23 45 67'),(6,'Customer XHXJV','Poland, Carole','Sales Representative','Forsterstr. 7890','Mannheim',NULL,'10117','Germany','0621-67890',NULL,NULL,'0621-12345'),(7,'Customer QXVLA','Bansal, Dushyant','Marketing Manager','2345, place Kléber','Strasbourg',NULL,'10089','France','67.89.01.23',NULL,NULL,'67.89.01.24'),(8,'Customer QUHWH','Ilyina, Julia','Owner','C/ Araquil, 0123','Madrid',NULL,'10104','Spain','(91) 345 67 89',NULL,NULL,'(91) 012 34 56'),(9,'Customer RTXGC','Raghav, Amritansh','Owner','6789, rue des Bouchers','Marseille',NULL,'10105','France','23.45.67.89',NULL,NULL,'23.45.67.80'),(10,'Customer EEALV','Bassols, Pilar Colome','Accounting Manager','8901 Tsawassen Blvd.','Tsawassen','BC','10111','Canada','(604) 901-2345',NULL,NULL,'(604) 678-9012'),(11,'Customer UBHAU','Jaffe, David','Sales Representative','Fauntleroy Circus 4567','London',NULL,'10064','UK','(171) 789-0123',NULL,NULL,NULL),(12,'Customer PSNMQ','Ray, Mike','Sales Agent','Cerrito 3456','Buenos Aires',NULL,'10057','Argentina','(1) 890-1234',NULL,NULL,'(1) 567-8901'),(13,'Customer VMLOG','Benito, Almudena','Marketing Manager','Sierras de Granada 7890','México D.F.',NULL,'10056','Mexico','(5) 456-7890',NULL,NULL,'(5) 123-4567'),(14,'Customer WNMAF','Jelitto, Jacek','Owner','Hauptstr. 0123','Bern',NULL,'10065','Switzerland','0452-678901',NULL,NULL,NULL),(15,'Customer JUWXK','Richardson, Shawn','Sales Associate','Av. dos Lusíadas, 6789','Sao Paulo','SP','10087','Brazil','(11) 012-3456',NULL,NULL,NULL),(16,'Customer GYBBY','Birkby, Dana','Sales Representative','Berkeley Gardens 0123 Brewery','London',NULL,'10039','UK','(171) 234-5678',NULL,NULL,'(171) 234-5679'),(17,'Customer FEVNN','Jones, TiAnna','Order Administrator','Walserweg 4567','Aachen',NULL,'10067','Germany','0241-789012',NULL,NULL,'0241-345678'),(18,'Customer BSVAR','Rizaldy, Arif','Owner','3456, rue des Cinquante Otages','Nantes',NULL,'10041','France','89.01.23.45',NULL,NULL,'89.01.23.46'),(19,'Customer RFNQC','Boseman, Randall','Sales Agent','5678 King George','London',NULL,'10110','UK','(171) 345-6789',NULL,NULL,'(171) 345-6780'),(20,'Customer THHDP','Kane, John','Sales Manager','Kirchgasse 9012','Graz',NULL,'10059','Austria','1234-5678',NULL,NULL,'9012-3456'),(21,'Customer KIdPX','Russo, Giuseppe','Marketing Assistant','Rua Orós, 3456','Sao Paulo','SP','10096','Brazil','(11) 456-7890',NULL,NULL,NULL),(22,'Customer DTDMN','Bueno, Janaina Burdan, Neville','Accounting Manager','C/ Moralzarzal, 5678','Madrid',NULL,'10080','Spain','(91) 890 12 34',NULL,NULL,'(91) 567 89 01'),(23,'Customer WVFAF','Khanna, Karan','Assistant Sales Agent','4567, chaussée de Tournai','Lille',NULL,'10048','France','45.67.89.01',NULL,NULL,'45.67.89.02'),(24,'Customer CYZTN','San Juan, Patricia','Owner','Åkergatan 5678','Bräcke',NULL,'10114','Sweden','0695-67 89 01',NULL,NULL,NULL),(25,'Customer AZJED','Carlson, Jason','Marketing Manager','Berliner Platz 9012','München',NULL,'10091','Germany','089-8901234',NULL,NULL,'089-5678901'),(26,'Customer USDBG','Koch, Paul','Marketing Manager','9012, rue Royale','Nantes',NULL,'10101','France','34.56.78.90',NULL,NULL,'34.56.78.91'),(27,'Customer WMFEA','Schmöllerl, Martin','Sales Representative','Via Monte Bianco 4567','Torino',NULL,'10099','Italy','011-2345678',NULL,NULL,'011-9012345'),(28,'Customer XYUFB','Cavaglieri, Giorgio','Sales Manager','Jardim das rosas n. 8901','Lisboa',NULL,'10054','Portugal','(1) 456-7890',NULL,NULL,'(1) 123-4567'),(29,'Customer MDLWA','Kolesnikova, Katerina','Marketing Manager','Rambla de Cataluña, 8901','Barcelona',NULL,'10081','Spain','(93) 789 0123',NULL,NULL,'(93) 456 7890'),(30,'Customer KSLQF','Shabalin, Rostislav','Sales Manager','C/ Romero, 1234','Sevilla',NULL,'10075','Spain','(95) 901 23 45',NULL,NULL,NULL),(31,'Customer YJCBX','Cheng, Yao-Qiang','Sales Associate','Av. Brasil, 5678','Campinas','SP','10128','Brazil','(11) 567-8901',NULL,NULL,NULL),(32,'Customer YSIQX','Krishnan, Venky','Marketing Manager','6789 Baker Blvd.','Eugene','OR','10070','USA','(503) 555-0122',NULL,NULL,NULL),(33,'Customer FVXPQ','Sigurdarson, Hallur ','Owner','5ª Ave. Los Palos Grandes 3456','Caracas','DF','10043','Venezuela','(2) 789-0123',NULL,NULL,'(2) 456-7890'),(34,'Customer IBVRG','Cohen, Shy','Accounting Manager','Rua do Paço, 7890','Rio de Janeiro','RJ','10076','Brazil','(21) 789-0123',NULL,NULL,'(21) 789-0124'),(35,'Customer UMTLM','Langohr, Kris','Sales Representative','Carrera 1234 con Ave. Carlos Soublette #8-35','San Cristóbal','Táchira','10066','Venezuela','(5) 567-8901',NULL,NULL,'(5) 234-5678'),(36,'Customer LVJSO','Smith, Denise','Sales Representative','City Center Plaza 2345 Main St.','Elgin','OR','10103','USA','(503) 555-0126',NULL,NULL,'(503) 555-0135'),(37,'Customer FRXZL','Crăciun, Ovidiu V.','Sales Associate','9012 Johnstown Road','Cork','Co. Cork','10051','Ireland','8901 234',NULL,NULL,'5678 9012'),(38,'Customer LJUCA','Lee, Frank','Marketing Manager','Garden House Crowther Way 3456','Cowes','Isle of Wight','10063','UK','(198) 567-8901',NULL,NULL,NULL),(39,'Customer GLLAG','Song, Lolan','Sales Associate','Maubelstr. 8901','Brandenburg',NULL,'10060','Germany','0555-34567',NULL,NULL,NULL),(40,'Customer EFFTC','De Oliveira, Jose','Sales Representative','2345, avenue de l\'Europe','Versailles',NULL,'10108','France','12.34.56.78',NULL,NULL,'12.34.56.79'),(41,'Customer XIIWM','Litton, Tim','Sales Manager','3456 rue Alsace-Lorraine','Toulouse',NULL,'10053','France','90.12.34.56',NULL,NULL,'90.12.34.57'),(42,'Customer IAIJK','Steiner, Dominik','Marketing Assistant','2345 Oak St.','Vancouver','BC','10098','Canada','(604) 567-8901',NULL,NULL,'(604) 234-5678'),(43,'Customer UISOJ','Deshpande, Anu','Marketing Manager','8901 Orchestra Terrace','Walla Walla','WA','10069','USA','(509) 555-0119',NULL,NULL,'(509) 555-0130'),(44,'Customer OXFRU','Louverdis, George','Sales Representative','Magazinweg 8901','Frankfurt a.M.',NULL,'10095','Germany','069-7890123',NULL,NULL,'069-4567890'),(45,'Customer QXPPT','Sunkammurali, Krishna','Owner','1234 Polk St. Suite 5','San Francisco','CA','10062','USA','(415) 555-0118',NULL,NULL,NULL),(46,'Customer XPNIK','Dressler, Marlies','Accounting Manager','Carrera 7890 con Ave. Bolívar #65-98 Llano Largo','Barquisimeto','Lara','10093','Venezuela','(9) 789-0123',NULL,NULL,'(9) 456-7890'),(47,'Customer PSQUZ','Lupu, Cornel','Owner','Ave. 5 de Mayo Porlamar 5678','I. de Margarita','Nueva Esparta','10121','Venezuela','(8) 01-23-45',NULL,NULL,'(8) 67-89-01'),(48,'Customer DVFMB','Szymczak, Radosław','Sales Manager','9012 Chiaroscuro Rd.','Portland','OR','10073','USA','(503) 555-0117',NULL,NULL,'(503) 555-0129'),(49,'Customer CQRAA','Duerr, Bernard','Marketing Manager','Via Ludovico il Moro 6789','Bergamo',NULL,'10106','Italy','035-345678',NULL,NULL,'035-901234'),(50,'Customer JYPSC','Mace, Donald','Sales Agent','Rue Joseph-Bens 0123','Bruxelles',NULL,'10074','Belgium','(02) 890 12 34',NULL,NULL,'(02) 567 89 01'),(51,'Customer PVDZC','Taylor, Maurice','Marketing Assistant','8901 rue St. Laurent','Montréal','Québec','10040','Canada','(514) 345-6789',NULL,NULL,'(514) 012-3456'),(52,'Customer PZNLA','Dupont-Roc, Patrice','Marketing Assistant','Heerstr. 4567','Leipzig',NULL,'10125','Germany','0342-12345',NULL,NULL,NULL),(53,'Customer GCJSG','Mallit, Ken','Sales Associate','South House 1234 Queensbridge','London',NULL,'10061','UK','(171) 890-1234',NULL,NULL,'(171) 890-1235'),(54,'Customer TDKEG','Tiano, Mike','Sales Agent','Ing. Gustavo Moncada 0123 Piso 20-A','Buenos Aires',NULL,'10094','Argentina','(1) 123-4567',NULL,NULL,'(1) 890-1234'),(55,'Customer KZQZT','Egelund-Muller, Anja','Sales Representative','7890 Bering St.','Anchorage','AK','10050','USA','(907) 555-0115',NULL,NULL,'(907) 555-0128'),(56,'Customer QNIVZ','Marinova, Nadejda','Owner','Mehrheimerstr. 9012','Köln',NULL,'10047','Germany','0221-0123456',NULL,NULL,'0221-7890123'),(57,'Customer WVAXS','Tollevsen, Bjørn','Owner','5678, boulevard Charonne','Paris',NULL,'10085','France','(1) 89.01.23.45',NULL,NULL,'(1) 89.01.23.46'),(58,'Customer AHXHT','Fakhouri, Fadi','Sales Representative','Calle Dr. Jorge Cash 8901','México D.F.',NULL,'10116','Mexico','(5) 890-1234',NULL,NULL,'(5) 567-8901'),(59,'Customer LOLJO','Meston, Tosh','Sales Manager','Geislweg 2345','Salzburg',NULL,'10127','Austria','4567-8901',NULL,NULL,'2345-6789'),(60,'Customer QZURI','Uppal, Sunil','Sales Representative','Estrada da saúde n. 6789','Lisboa',NULL,'10083','Portugal','(1) 789-0123',NULL,NULL,NULL),(61,'Customer WULWD','Florczyk, Krzysztof','Accounting Manager','Rua da Panificadora, 1234','Rio de Janeiro','RJ','10115','Brazil','(21) 678-9012',NULL,NULL,'(21) 678-9013'),(62,'Customer WFIZJ','Misiec, Anna','Marketing Assistant','Alameda dos Canàrios, 1234','Sao Paulo','SP','10102','Brazil','(11) 901-2345',NULL,NULL,NULL),(63,'Customer IRRVL','Veronesi, Giorgio','Accounting Manager','Taucherstraße 1234','Cunewalde',NULL,'10126','Germany','0372-12345',NULL,NULL,NULL),(64,'Customer LWGMD','Gaffney, Lawrie','Sales Representative','Av. del Libertador 3456','Buenos Aires',NULL,'10124','Argentina','(1) 234-5678',NULL,NULL,'(1) 901-2345'),(65,'Customer NYUHS','Moore, Michael','Assistant Sales Representative','6789 Milton Dr.','Albuquerque','NM','10109','USA','(505) 555-0125',NULL,NULL,'(505) 555-0134'),(66,'Customer LHANT','Voss, Florian','Sales Associate','Strada Provinciale 7890','Reggio Emilia',NULL,'10038','Italy','0522-012345',NULL,NULL,'0522-678901'),(67,'Customer QVEPD','Garden, Euan','Assistant Sales Agent','Av. Copacabana, 6789','Rio de Janeiro','RJ','10052','Brazil','(21) 345-6789',NULL,NULL,NULL),(68,'Customer CCKOT','Myrcha, Jacek','Sales Manager','Grenzacherweg 0123','Genève',NULL,'10122','Switzerland','0897-012345',NULL,NULL,NULL),(69,'Customer SIUIH','Watters, Jason M.','Accounting Manager','Gran Vía, 4567','Madrid',NULL,'10071','Spain','(91) 567 8901',NULL,NULL,'(91) 234 5678'),(70,'Customer TMXGN','Ginters, Kaspars','Owner','Erling Skakkes gate 2345','Stavern',NULL,'10123','Norway','07-89 01 23',NULL,NULL,'07-45 67 89'),(71,'Customer LCOUJ','Navarro, Tomás','Sales Representative','9012 Suffolk Ln.','Boise','Id','10078','USA','(208) 555-0116',NULL,NULL,NULL),(72,'Customer AHPOP','Welcker, Brian','Sales Manager','4567 Wadhurst Rd.','London',NULL,'10088','UK','(171) 901-2345',NULL,NULL,'(171) 901-2346'),(73,'Customer JMIKW','Gonzalez, Nuria','Owner','Vinbæltet 3456','Kobenhavn',NULL,'10079','Denmark','12 34 56 78',NULL,NULL,'90 12 34 56'),(74,'Customer YSHXL','O’Brien, Dave','Marketing Manager','9012, rue Lauriston','Paris',NULL,'10058','France','(1) 23.45.67.89',NULL,NULL,'(1) 23.45.67.80'),(75,'Customer XOJYP','Wojciechowska, Agnieszka','Sales Manager','P.O. Box 1234','Lander','WY','10113','USA','(307) 555-0114',NULL,NULL,'(307) 555-0127'),(76,'Customer SFOGW','Gulbis, Katrin','Accounting Manager','Boulevard Tirou, 2345','Charleroi',NULL,'10100','Belgium','(071) 56 78 90 12',NULL,NULL,'(071) 34 56 78 90'),(77,'Customer LCYBZ','Osorio, Cristian','Marketing Manager','2345 Jefferson Way Suite 2','Portland','OR','10042','USA','(503) 555-0120',NULL,NULL,NULL),(78,'Customer NLTYP','Young, Robin','Marketing Assistant','0123 Grizzly Peak Rd.','Butte','MT','10107','USA','(406) 555-0121',NULL,NULL,'(406) 555-0131'),(79,'Customer FAPSM','Wickham, Jim','Marketing Manager','Luisenstr. 0123','Münster',NULL,'10118','Germany','0251-456789',NULL,NULL,'0251-012345'),(80,'Customer VONTK','Geschwandtner, Jens','Owner','Avda. Azteca 4567','México D.F.',NULL,'10044','Mexico','(5) 678-9012',NULL,NULL,NULL),(81,'Customer YQQWW','Nagel, Jean-Philippe','Sales Representative','Av. Inês de Castro, 1234','Sao Paulo','SP','10120','Brazil','(11) 123-4567',NULL,NULL,'(11) 234-5678'),(82,'Customer EYHKM','Veninga, Tjeerd','Sales Associate','1234 DaVinci Blvd.','Kirkland','WA','10119','USA','(206) 555-0124',NULL,NULL,'(206) 555-0133'),(83,'Customer ZRNDE','Fonteneau, Karl','Sales Manager','Smagsloget 3456','Århus',NULL,'10090','Denmark','23 45 67 89',NULL,NULL,'01 23 45 67'),(84,'Customer NRCSK','Tuntisangaroon, Sittichai','Sales Agent','6789, rue du Commerce','Lyon',NULL,'10072','France','78.90.12.34',NULL,NULL,'78.90.12.35'),(85,'Customer ENQZT','McLin, Nkenge','Accounting Manager','5678 rue de l\'Abbaye','Reims',NULL,'10082','France','56.78.90.12',NULL,NULL,'56.78.90.13'),(86,'Customer SNXOJ','Syamala, Manoj','Sales Representative','Adenauerallee 7890','Stuttgart',NULL,'10086','Germany','0711-345678',NULL,NULL,'0711-901234'),(87,'Customer ZHYOS','Ludwig, Michael','Accounting Manager','Torikatu 9012','Oulu',NULL,'10045','Finland','981-123456',NULL,NULL,'981-789012'),(88,'Customer SRQVM','Li, Yan','Sales Manager','Rua do Mercado, 4567','Resende','SP','10084','Brazil','(14) 234-5678',NULL,NULL,NULL),(89,'Customer YBQTI','Smith Jr., Ronaldo','Owner','8901 - 14th Ave. S. Suite 3B','Seattle','WA','10049','USA','(206) 555-0123',NULL,NULL,'(206) 555-0132'),(90,'Customer XBBVR','Larsson, Katarina','Owner/Marketing Assistant','Keskuskatu 2345','Helsinki',NULL,'10055','Finland','90-012 3456',NULL,NULL,'90-789 0123'),(91,'Customer CCFIZ','Conn, Steve','Owner','ul. Filtrowa 6789','Warszawa',NULL,'10068','Poland','(26) 234-5678',NULL,NULL,'(26) 901-2345');
/*!40000 ALTER TABLE `customer` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `customerdemographics`
--
DROP TABLE IF EXISTS `customerdemographics`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `customerdemographics` (
`customerTypeId` int NOT NULL AUTO_INCREMENT,
`customerDesc` text COLLATE utf8_bin,
PRIMARY KEY (`customerTypeId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `customerdemographics`
--
LOCK TABLES `customerdemographics` WRITE;
/*!40000 ALTER TABLE `customerdemographics` DISABLE KEYS */;
/*!40000 ALTER TABLE `customerdemographics` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `employee`
--
DROP TABLE IF EXISTS `employee`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `employee` (
`employeeId` int NOT NULL AUTO_INCREMENT,
`lastname` varchar(20) COLLATE utf8_bin NOT NULL,
`firstname` varchar(10) COLLATE utf8_bin NOT NULL,
`title` varchar(30) COLLATE utf8_bin DEFAULT NULL,
`titleOfCourtesy` varchar(25) COLLATE utf8_bin DEFAULT NULL,
`birthDate` datetime DEFAULT NULL,
`hireDate` datetime DEFAULT NULL,
`address` varchar(60) COLLATE utf8_bin DEFAULT NULL,
`city` varchar(15) COLLATE utf8_bin DEFAULT NULL,
`region` varchar(15) COLLATE utf8_bin DEFAULT NULL,
`postalCode` varchar(10) COLLATE utf8_bin DEFAULT NULL,
`country` varchar(15) COLLATE utf8_bin DEFAULT NULL,
`phone` varchar(24) COLLATE utf8_bin DEFAULT NULL,
`extension` varchar(4) COLLATE utf8_bin DEFAULT NULL,
`mobile` varchar(24) COLLATE utf8_bin DEFAULT NULL,
`email` varchar(225) COLLATE utf8_bin DEFAULT NULL,
`photo` blob,
`notes` blob,
`mgrId` int DEFAULT NULL,
`photoPath` varchar(255) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`employeeId`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `employee`
--
LOCK TABLES `employee` WRITE;
/*!40000 ALTER TABLE `employee` DISABLE KEYS */;
INSERT INTO `employee` VALUES (1,'Davis','Sara','CEO','Ms.','1958-12-08 00:00:00','2002-05-01 00:00:00','7890 - 20th Ave. E., Apt. 2A','Seattle','WA','10003','USA','(206) 555-0101',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'Funk','Don','Vice President, Sales','Dr.','1962-02-19 00:00:00','2002-08-14 00:00:00','9012 W. Capital Way','Tacoma','WA','10001','USA','(206) 555-0100',NULL,NULL,NULL,NULL,NULL,1,NULL),(3,'Lew','Judy','Sales Manager','Ms.','1973-08-30 00:00:00','2002-04-01 00:00:00','2345 Moss Bay Blvd.','Kirkland','WA','10007','USA','(206) 555-0103',NULL,NULL,NULL,NULL,NULL,2,NULL),(4,'Peled','Yael','Sales Representative','Mrs.','1947-09-19 00:00:00','2003-05-03 00:00:00','5678 Old Redmond Rd.','Redmond','WA','10009','USA','(206) 555-0104',NULL,NULL,NULL,NULL,NULL,3,NULL),(5,'Buck','Sven','Sales Manager','Mr.','1965-03-04 00:00:00','2003-10-17 00:00:00','8901 Garrett Hill','London',NULL,'10004','UK','(71) 234-5678',NULL,NULL,NULL,NULL,NULL,2,NULL),(6,'Suurs','Paul','Sales Representative','Mr.','1973-07-02 00:00:00','2003-10-17 00:00:00','3456 Coventry House, Miner Rd.','London',NULL,'10005','UK','(71) 345-6789',NULL,NULL,NULL,NULL,NULL,5,NULL),(7,'King','Russell','Sales Representative','Mr.','1970-05-29 00:00:00','2004-01-02 00:00:00','6789 Edgeham Hollow, Winchester Way','London',NULL,'10002','UK','(71) 123-4567',NULL,NULL,NULL,NULL,NULL,5,NULL),(8,'Cameron','Maria','Sales Representative','Ms.','1968-01-09 00:00:00','2004-03-05 00:00:00','4567 - 11th Ave. N.E.','Seattle','WA','10006','USA','(206) 555-0102',NULL,NULL,NULL,NULL,NULL,3,NULL),(9,'Dolgopyatova','Zoya','Sales Representative','Ms.','1976-01-27 00:00:00','2004-11-15 00:00:00','1234 Houndstooth Rd.','London',NULL,'10008','UK','(71) 456-7890',NULL,NULL,NULL,NULL,NULL,5,NULL);
/*!40000 ALTER TABLE `employee` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `employeeterritory`
--
DROP TABLE IF EXISTS `employeeterritory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `employeeterritory` (
`employeeId` int NOT NULL AUTO_INCREMENT,
`territoryId` varchar(20) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`employeeId`,`territoryId`),
KEY `territoryId` (`territoryId`),
CONSTRAINT `employeeterritory_ibfk_1` FOREIGN KEY (`employeeId`) REFERENCES `employee` (`employeeId`),
CONSTRAINT `employeeterritory_ibfk_2` FOREIGN KEY (`territoryId`) REFERENCES `territory` (`territoryId`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `employeeterritory`
--
LOCK TABLES `employeeterritory` WRITE;
/*!40000 ALTER TABLE `employeeterritory` DISABLE KEYS */;
INSERT INTO `employeeterritory` VALUES (2,'01581'),(2,'01730'),(2,'01833'),(2,'02116'),(2,'02139'),(2,'02184'),(5,'02903'),(9,'03049'),(9,'03801'),(1,'06897'),(5,'07960'),(5,'08837'),(5,'10019'),(5,'10038'),(5,'11747'),(5,'14450'),(8,'19428'),(1,'19713'),(4,'20852'),(4,'27403'),(4,'27511'),(3,'30346'),(3,'31406'),(3,'32859'),(3,'33607'),(2,'40222'),(8,'44122'),(8,'45839'),(9,'48075'),(9,'48084'),(9,'48304'),(8,'53404'),(9,'55113'),(9,'55439'),(7,'60179'),(7,'60601'),(7,'80202'),(7,'80909'),(6,'85014'),(6,'85251'),(7,'90405'),(7,'94025'),(7,'94105'),(7,'95008'),(7,'95054'),(7,'95060'),(6,'98004'),(6,'98052'),(6,'98104');
/*!40000 ALTER TABLE `employeeterritory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `orderdetail`
--
DROP TABLE IF EXISTS `orderdetail`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `orderdetail` (
`orderDetailId` int NOT NULL AUTO_INCREMENT,
`orderId` int NOT NULL,
`productId` int NOT NULL,
`unitPrice` decimal(10,2) NOT NULL,
`quantity` smallint NOT NULL,
`discount` decimal(10,2) NOT NULL,
PRIMARY KEY (`orderDetailId`),
KEY `orderId` (`orderId`),
KEY `productId` (`productId`),
CONSTRAINT `orderdetail_ibfk_1` FOREIGN KEY (`orderId`) REFERENCES `salesorder` (`orderId`),
CONSTRAINT `orderdetail_ibfk_2` FOREIGN KEY (`productId`) REFERENCES `product` (`productId`)
) ENGINE=InnoDB AUTO_INCREMENT=2156 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `orderdetail`
--
LOCK TABLES `orderdetail` WRITE;
/*!40000 ALTER TABLE `orderdetail` DISABLE KEYS */;
/*!40000 ALTER TABLE `orderdetail` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `product`
--
DROP TABLE IF EXISTS `product`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `product` (
`productId` int NOT NULL AUTO_INCREMENT,
`productName` varchar(40) COLLATE utf8_bin NOT NULL,
`supplierId` int DEFAULT NULL,
`categoryId` int DEFAULT NULL,
`quantityPerUnit` varchar(20) COLLATE utf8_bin DEFAULT NULL,
`unitPrice` decimal(10,2) DEFAULT NULL,
`unitsInStock` smallint DEFAULT NULL,
`unitsOnOrder` smallint DEFAULT NULL,
`reorderLevel` smallint DEFAULT NULL,
`discontinued` char(1) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`productId`),
KEY `supplierId` (`supplierId`),
KEY `categoryId` (`categoryId`),
CONSTRAINT `product_ibfk_1` FOREIGN KEY (`supplierId`) REFERENCES `supplier` (`supplierId`),
CONSTRAINT `product_ibfk_2` FOREIGN KEY (`categoryId`) REFERENCES `category` (`categoryId`)
) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `product`
--
LOCK TABLES `product` WRITE;
/*!40000 ALTER TABLE `product` DISABLE KEYS */;
INSERT INTO `product` VALUES (1,'Product HHYDP',1,1,NULL,18.00,NULL,NULL,NULL,'0'),(2,'Product RECZE',1,1,NULL,19.00,NULL,NULL,NULL,'0'),(3,'Product IMEHJ',1,2,NULL,10.00,NULL,NULL,NULL,'0'),(4,'Product KSBRM',2,2,NULL,22.00,NULL,NULL,NULL,'0'),(5,'Product EPEIM',2,2,NULL,21.35,NULL,NULL,NULL,'1'),(6,'Product VAIIV',3,2,NULL,25.00,NULL,NULL,NULL,'0'),(7,'Product HMLNI',3,7,NULL,30.00,NULL,NULL,NULL,'0'),(8,'Product WVJFP',3,2,NULL,40.00,NULL,NULL,NULL,'0'),(9,'Product AOZBW',4,6,NULL,97.00,NULL,NULL,NULL,'1'),(10,'Product YHXGE',4,8,NULL,31.00,NULL,NULL,NULL,'0'),(11,'Product QMVUN',5,4,NULL,21.00,NULL,NULL,NULL,'0'),(12,'Product OSFNS',5,4,NULL,38.00,NULL,NULL,NULL,'0'),(13,'Product POXFU',6,8,NULL,6.00,NULL,NULL,NULL,'0'),(14,'Product PWCJB',6,7,NULL,23.25,NULL,NULL,NULL,'0'),(15,'Product KSZOI',6,2,NULL,15.50,NULL,NULL,NULL,'0'),(16,'Product PAFRH',7,3,NULL,17.45,NULL,NULL,NULL,'0'),(17,'Product BLCAX',7,6,NULL,39.00,NULL,NULL,NULL,'1'),(18,'Product CKEDC',7,8,NULL,62.50,NULL,NULL,NULL,'0'),(19,'Product XKXDO',8,3,NULL,9.20,NULL,NULL,NULL,'0'),(20,'Product QHFFP',8,3,NULL,81.00,NULL,NULL,NULL,'0'),(21,'Product VJZZH',8,3,NULL,10.00,NULL,NULL,NULL,'0'),(22,'Product CPHFY',9,5,NULL,21.00,NULL,NULL,NULL,'0'),(23,'Product JLUDZ',9,5,NULL,9.00,NULL,NULL,NULL,'0'),(24,'Product QOGNU',10,1,NULL,4.50,NULL,NULL,NULL,'1'),(25,'Product LYLNI',11,3,NULL,14.00,NULL,NULL,NULL,'0'),(26,'Product HLGZA',11,3,NULL,31.23,NULL,NULL,NULL,'0'),(27,'Product SMIOH',11,3,NULL,43.90,NULL,NULL,NULL,'0'),(28,'Product OFBNT',12,7,NULL,45.60,NULL,NULL,NULL,'1'),(29,'Product VJXYN',12,6,NULL,123.79,NULL,NULL,NULL,'1'),(30,'Product LYERX',13,8,NULL,25.89,NULL,NULL,NULL,'0'),(31,'Product XWOXC',14,4,NULL,12.50,NULL,NULL,NULL,'0'),(32,'Product NUNAW',14,4,NULL,32.00,NULL,NULL,NULL,'0'),(33,'Product ASTMN',15,4,NULL,2.50,NULL,NULL,NULL,'0'),(34,'Product SWNJY',16,1,NULL,14.00,NULL,NULL,NULL,'0'),(35,'Product NEVTJ',16,1,NULL,18.00,NULL,NULL,NULL,'0'),(36,'Product GMKIJ',17,8,NULL,19.00,NULL,NULL,NULL,'0'),(37,'Product EVFFA',17,8,NULL,26.00,NULL,NULL,NULL,'0'),(38,'Product QDOMO',18,1,NULL,263.50,NULL,NULL,NULL,'0'),(39,'Product LSOFL',18,1,NULL,18.00,NULL,NULL,NULL,'0'),(40,'Product YZIXQ',19,8,NULL,18.40,NULL,NULL,NULL,'0'),(41,'Product TTEEX',19,8,NULL,9.65,NULL,NULL,NULL,'0'),(42,'Product RJVNM',20,5,NULL,14.00,NULL,NULL,NULL,'1'),(43,'Product ZZZHR',20,1,NULL,46.00,NULL,NULL,NULL,'0'),(44,'Product VJIEO',20,2,NULL,19.45,NULL,NULL,NULL,'0'),(45,'Product AQOKR',21,8,NULL,9.50,NULL,NULL,NULL,'0'),(46,'Product CBRRL',21,8,NULL,12.00,NULL,NULL,NULL,'0'),(47,'Product EZZPR',22,3,NULL,9.50,NULL,NULL,NULL,'0'),(48,'Product MYNXN',22,3,NULL,12.75,NULL,NULL,NULL,'0'),(49,'Product FPYPN',23,3,NULL,20.00,NULL,NULL,NULL,'0'),(50,'Product BIUDV',23,3,NULL,16.25,NULL,NULL,NULL,'0'),(51,'Product APITJ',24,7,NULL,53.00,NULL,NULL,NULL,'0'),(52,'Product QSRXF',24,5,NULL,7.00,NULL,NULL,NULL,'0'),(53,'Product BKGEA',24,6,NULL,32.80,NULL,NULL,NULL,'1'),(54,'Product QAQRL',25,6,NULL,7.45,NULL,NULL,NULL,'0'),(55,'Product 1',25,6,NULL,24.00,NULL,NULL,NULL,'0'),(56,'Product VKCMF',26,5,NULL,38.00,NULL,NULL,NULL,'0'),(57,'Product OVLQI',26,5,NULL,19.50,NULL,NULL,NULL,'0'),(58,'Product ACRVI',27,8,NULL,13.25,NULL,NULL,NULL,'0'),(59,'Product UKXRI',28,4,NULL,55.00,NULL,NULL,NULL,'0'),(60,'Product WHBYK',28,4,NULL,34.00,NULL,NULL,NULL,'0'),(61,'Product XYZPE',29,2,NULL,28.50,NULL,NULL,NULL,'0'),(62,'Product WUXYK',29,3,NULL,49.30,NULL,NULL,NULL,'0'),(63,'Product ICKNK',7,2,NULL,43.90,NULL,NULL,NULL,'0'),(64,'Product HCQDE',12,5,NULL,33.25,NULL,NULL,NULL,'0'),(65,'Product XYWBZ',2,2,NULL,21.05,NULL,NULL,NULL,'0'),(66,'Product LQMGN',2,2,NULL,17.00,NULL,NULL,NULL,'0'),(67,'Product XLXQF',16,1,NULL,14.00,NULL,NULL,NULL,'0'),(68,'Product TBTBL',8,3,NULL,12.50,NULL,NULL,NULL,'0'),(69,'Product COAXA',15,4,NULL,36.00,NULL,NULL,NULL,'0'),(70,'Product TOONT',7,1,NULL,15.00,NULL,NULL,NULL,'0'),(71,'Product MYMOI',15,4,NULL,21.50,NULL,NULL,NULL,'0'),(72,'Product GEEOO',14,4,NULL,34.80,NULL,NULL,NULL,'0'),(73,'Product WEUJZ',17,8,NULL,15.00,NULL,NULL,NULL,'0'),(74,'Product BKAZJ',4,7,NULL,10.00,NULL,NULL,NULL,'0'),(75,'Product BWRLG',12,1,NULL,7.75,NULL,NULL,NULL,'0'),(76,'Product JYGFE',23,1,NULL,18.00,NULL,NULL,NULL,'0'),(77,'Product LUNZZ',12,2,NULL,13.00,NULL,NULL,NULL,'0');
/*!40000 ALTER TABLE `product` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `region`
--
DROP TABLE IF EXISTS `region`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `region` (
`regionId` int NOT NULL,
`regiondescription` varchar(50) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`regionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `region`
--
LOCK TABLES `region` WRITE;
/*!40000 ALTER TABLE `region` DISABLE KEYS */;
INSERT INTO `region` VALUES (1,'Eastern'),(2,'Western'),(3,'Northern'),(4,'Southern');
/*!40000 ALTER TABLE `region` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `salesorder`
--
DROP TABLE IF EXISTS `salesorder`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `salesorder` (
`orderId` int NOT NULL AUTO_INCREMENT,
`custId` int NOT NULL,
`employeeId` int DEFAULT NULL,
`orderDate` datetime DEFAULT NULL,
`requiredDate` datetime DEFAULT NULL,
`shippedDate` datetime DEFAULT NULL,
`shipperid` int NOT NULL,
`freight` decimal(10,2) DEFAULT NULL,
`shipName` varchar(40) COLLATE utf8_bin DEFAULT NULL,
`shipAddress` varchar(60) COLLATE utf8_bin DEFAULT NULL,
`shipCity` varchar(15) COLLATE utf8_bin DEFAULT NULL,
`shipRegion` varchar(15) COLLATE utf8_bin DEFAULT NULL,
`shipPostalCode` varchar(10) COLLATE utf8_bin DEFAULT NULL,
`shipCountry` varchar(15) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`orderId`,`custId`),
KEY `shipperid` (`shipperid`),
KEY `custId` (`custId`),
CONSTRAINT `salesorder_ibfk_1` FOREIGN KEY (`shipperid`) REFERENCES `shipper` (`shipperId`),
CONSTRAINT `salesorder_ibfk_2` FOREIGN KEY (`custId`) REFERENCES `customer` (`custId`)
) ENGINE=InnoDB AUTO_INCREMENT=11078 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `salesorder`
--
LOCK TABLES `salesorder` WRITE;
/*!40000 ALTER TABLE `salesorder` DISABLE KEYS */;
INSERT INTO `salesorder` VALUES (10248,85,5,'2006-07-04 00:00:00','2006-08-01 00:00:00','2006-07-16 00:00:00',3,32.38,'Ship to 85-B','6789 rue de l\'Abbaye','Reims',NULL,'10345','France'),(10249,79,6,'2006-07-05 00:00:00','2006-08-16 00:00:00','2006-07-10 00:00:00',1,11.61,'Ship to 79-C','Luisenstr. 9012','Münster',NULL,'10328','Germany'),(10250,34,4,'2006-07-08 00:00:00','2006-08-05 00:00:00','2006-07-12 00:00:00',2,65.83,'Destination SCQXA','Rua do Paço, 7890','Rio de Janeiro','RJ','10195','Brazil'),(10251,84,3,'2006-07-08 00:00:00','2006-08-05 00:00:00','2006-07-15 00:00:00',1,41.34,'Ship to 84-A','3456, rue du Commerce','Lyon',NULL,'10342','France'),(10252,76,4,'2006-07-09 00:00:00','2006-08-06 00:00:00','2006-07-11 00:00:00',2,51.30,'Ship to 76-B','Boulevard Tirou, 9012','Charleroi',NULL,'10318','Belgium'),(10253,34,3,'2006-07-10 00:00:00','2006-07-24 00:00:00','2006-07-16 00:00:00',2,58.17,'Destination JPAIY','Rua do Paço, 8901','Rio de Janeiro','RJ','10196','Brazil'),(10254,14,5,'2006-07-11 00:00:00','2006-08-08 00:00:00','2006-07-23 00:00:00',2,22.98,'Destination YUJRD','Hauptstr. 1234','Bern',NULL,'10139','Switzerland'),(10255,68,9,'2006-07-12 00:00:00','2006-08-09 00:00:00','2006-07-15 00:00:00',3,148.33,'Ship to 68-A','Starenweg 6789','Genève',NULL,'10294','Switzerland'),(10256,88,3,'2006-07-15 00:00:00','2006-08-12 00:00:00','2006-07-17 00:00:00',2,13.97,'Ship to 88-B','Rua do Mercado, 5678','Resende','SP','10354','Brazil'),(10257,35,4,'2006-07-16 00:00:00','2006-08-13 00:00:00','2006-07-22 00:00:00',3,81.91,'Destination JYDLM','Carrera1234 con Ave. Carlos Soublette #8-35','San Cristóbal','Táchira','10199','Venezuela'),(10258,20,1,'2006-07-17 00:00:00','2006-08-14 00:00:00','2006-07-23 00:00:00',1,140.51,'Destination RVDMF','Kirchgasse 9012','Graz',NULL,'10157','Austria'),(10259,13,4,'2006-07-18 00:00:00','2006-08-15 00:00:00','2006-07-25 00:00:00',3,3.25,'Destination LGGCH','Sierras de Granada 9012','México D.F.',NULL,'10137','Mexico'),(10260,56,4,'2006-07-19 00:00:00','2006-08-16 00:00:00','2006-07-29 00:00:00',1,55.09,'Ship to 56-A','Mehrheimerstr. 0123','Köln',NULL,'10258','Germany'),(10261,61,4,'2006-07-19 00:00:00','2006-08-16 00:00:00','2006-07-30 00:00:00',2,3.05,'Ship to 61-B','Rua da Panificadora, 6789','Rio de Janeiro','RJ','10274','Brazil'),(10262,65,8,'2006-07-22 00:00:00','2006-08-19 00:00:00','2006-07-25 00:00:00',3,48.29,'Ship to 65-B','8901 Milton Dr.','Albuquerque','NM','10286','USA'),(10263,20,9,'2006-07-23 00:00:00','2006-08-20 00:00:00','2006-07-31 00:00:00',3,146.06,'Destination FFXKT','Kirchgasse 0123','Graz',NULL,'10158','Austria'),(10264,24,6,'2006-07-24 00:00:00','2006-08-21 00:00:00','2006-08-23 00:00:00',3,3.67,'Destination KBSBN','Åkergatan 9012','Bräcke',NULL,'10167','Sweden'),(10265,7,2,'2006-07-25 00:00:00','2006-08-22 00:00:00','2006-08-12 00:00:00',1,55.28,'Ship to 7-A','0123, place Kléber','Strasbourg',NULL,'10329','France'),(10266,87,3,'2006-07-26 00:00:00','2006-09-06 00:00:00','2006-07-31 00:00:00',3,25.73,'Ship to 87-B','Torikatu 2345','Oulu',NULL,'10351','Finland'),(10267,25,4,'2006-07-29 00:00:00','2006-08-26 00:00:00','2006-08-06 00:00:00',1,208.58,'Destination VAPXU','Berliner Platz 0123','München',NULL,'10168','Germany'),(10268,33,8,'2006-07-30 00:00:00','2006-08-27 00:00:00','2006-08-02 00:00:00',3,66.29,'Destination QJVQH','5ª Ave. Los Palos Grandes 5678','Caracas','DF','10193','Venezuela'),(10269,89,5,'2006-07-31 00:00:00','2006-08-14 00:00:00','2006-08-09 00:00:00',1,4.56,'Ship to 89-B','8901 - 12th Ave. S.','Seattle','WA','10357','USA'),(10270,87,1,'2006-08-01 00:00:00','2006-08-29 00:00:00','2006-08-02 00:00:00',1,136.54,'Ship to 87-B','Torikatu 2345','Oulu',NULL,'10351','Finland'),(10271,75,6,'2006-08-01 00:00:00','2006-08-29 00:00:00','2006-08-30 00:00:00',2,4.54,'Ship to 75-C','P.O. Box 7890','Lander','WY','10316','USA'),(10272,65,6,'2006-08-02 00:00:00','2006-08-30 00:00:00','2006-08-06 00:00:00',2,98.03,'Ship to 65-A','7890 Milton Dr.','Albuquerque','NM','10285','USA'),(10273,63,3,'2006-08-05 00:00:00','2006-09-02 00:00:00','2006-08-12 00:00:00',3,76.07,'Ship to 63-A','Taucherstraße 1234','Cunewalde',NULL,'10279','Germany'),(10274,85,6,'2006-08-06 00:00:00','2006-09-03 00:00:00','2006-08-16 00:00:00',1,6.01,'Ship to 85-B','6789 rue de l\'Abbaye','Reims',NULL,'10345','France'),(10275,49,1,'2006-08-07 00:00:00','2006-09-04 00:00:00','2006-08-09 00:00:00',1,26.93,'Ship to 49-A','Via Ludovico il Moro 8901','Bergamo',NULL,'10235','Italy'),(10276,80,8,'2006-08-08 00:00:00','2006-08-22 00:00:00','2006-08-14 00:00:00',3,13.84,'Ship to 80-C','Avda. Azteca 5678','México D.F.',NULL,'10334','Mexico'),(10277,52,2,'2006-08-09 00:00:00','2006-09-06 00:00:00','2006-08-13 00:00:00',3,125.77,'Ship to 52-A','Heerstr. 9012','Leipzig',NULL,'10247','Germany'),(10278,5,8,'2006-08-12 00:00:00','2006-09-09 00:00:00','2006-08-16 00:00:00',2,92.69,'Ship to 5-C','Berguvsvägen 1234','Luleå',NULL,'10269','Sweden'),(10279,44,8,'2006-08-13 00:00:00','2006-09-10 00:00:00','2006-08-16 00:00:00',2,25.83,'Ship to 44-A','Magazinweg 4567','Frankfurt a.M.',NULL,'10222','Germany'),(10280,5,2,'2006-08-14 00:00:00','2006-09-11 00:00:00','2006-09-12 00:00:00',1,8.98,'Ship to 5-B','Berguvsvägen 0123','Luleå',NULL,'10268','Sweden'),(10281,69,4,'2006-08-14 00:00:00','2006-08-28 00:00:00','2006-08-21 00:00:00',1,2.94,'Ship to 69-A','Gran Vía, 9012','Madrid',NULL,'10297','Spain'),(10282,69,4,'2006-08-15 00:00:00','2006-09-12 00:00:00','2006-08-21 00:00:00',1,12.69,'Ship to 69-B','Gran Vía, 0123','Madrid',NULL,'10298','Spain'),(10283,46,3,'2006-08-16 00:00:00','2006-09-13 00:00:00','2006-08-23 00:00:00',3,84.81,'Ship to 46-A','Carrera 0123 con Ave. Bolívar #65-98 Llano Largo','Barquisimeto','Lara','10227','Venezuela'),(10284,44,4,'2006-08-19 00:00:00','2006-09-16 00:00:00','2006-08-27 00:00:00',1,76.56,'Ship to 44-A','Magazinweg 4567','Frankfurt a.M.',NULL,'10222','Germany'),(10285,63,1,'2006-08-20 00:00:00','2006-09-17 00:00:00','2006-08-26 00:00:00',2,76.83,'Ship to 63-B','Taucherstraße 2345','Cunewalde',NULL,'10280','Germany'),(10286,63,8,'2006-08-21 00:00:00','2006-09-18 00:00:00','2006-08-30 00:00:00',3,229.24,'Ship to 63-B','Taucherstraße 2345','Cunewalde',NULL,'10280','Germany'),(10287,67,8,'2006-08-22 00:00:00','2006-09-19 00:00:00','2006-08-28 00:00:00',3,12.76,'Ship to 67-A','Av. Copacabana, 3456','Rio de Janeiro','RJ','10291','Brazil'),(10288,66,4,'2006-08-23 00:00:00','2006-09-20 00:00:00','2006-09-03 00:00:00',1,7.45,'Ship to 66-C','Strada Provinciale 2345','Reggio Emilia',NULL,'10290','Italy'),(10289,11,7,'2006-08-26 00:00:00','2006-09-23 00:00:00','2006-08-28 00:00:00',3,22.77,'Destination DLEUN','Fauntleroy Circus 4567','London',NULL,'10132','UK'),(10290,15,8,'2006-08-27 00:00:00','2006-09-24 00:00:00','2006-09-03 00:00:00',1,79.70,'Destination HQZHO','Av. dos Lusíadas, 4567','Sao Paulo','SP','10142','Brazil'),(10291,61,6,'2006-08-27 00:00:00','2006-09-24 00:00:00','2006-09-04 00:00:00',2,6.40,'Ship to 61-A','Rua da Panificadora, 5678','Rio de Janeiro','RJ','10273','Brazil'),(10292,81,1,'2006-08-28 00:00:00','2006-09-25 00:00:00','2006-09-02 00:00:00',2,1.35,'Ship to 81-A','Av. Inês de Castro, 6789','Sao Paulo','SP','10335','Brazil'),(10293,80,1,'2006-08-29 00:00:00','2006-09-26 00:00:00','2006-09-11 00:00:00',3,21.18,'Ship to 80-B','Avda. Azteca 4567','México D.F.',NULL,'10333','Mexico'),(10294,65,4,'2006-08-30 00:00:00','2006-09-27 00:00:00','2006-09-05 00:00:00',2,147.26,'Ship to 65-A','7890 Milton Dr.','Albuquerque','NM','10285','USA'),(10295,85,2,'2006-09-02 00:00:00','2006-09-30 00:00:00','2006-09-10 00:00:00',2,1.15,'Ship to 85-C','7890 rue de l\'Abbaye','Reims',NULL,'10346','France'),(10296,46,6,'2006-09-03 00:00:00','2006-10-01 00:00:00','2006-09-11 00:00:00',1,0.12,'Ship to 46-C','Carrera 2345 con Ave. Bolívar #65-98 Llano Largo','Barquisimeto','Lara','10229','Venezuela'),(10297,7,5,'2006-09-04 00:00:00','2006-10-16 00:00:00','2006-09-10 00:00:00',2,5.74,'Ship to 7-C','2345, place Kléber','Strasbourg',NULL,'10331','France'),(10298,37,6,'2006-09-05 00:00:00','2006-10-03 00:00:00','2006-09-11 00:00:00',2,168.22,'Destination ATSOA','4567 Johnstown Road','Cork','Co. Cork','10202','Ireland'),(10299,67,4,'2006-09-06 00:00:00','2006-10-04 00:00:00','2006-09-13 00:00:00',2,29.76,'Ship to 67-A','Av. Copacabana, 3456','Rio de Janeiro','RJ','10291','Brazil'),(10300,49,2,'2006-09-09 00:00:00','2006-10-07 00:00:00','2006-09-18 00:00:00',2,17.68,'Ship to 49-A','Via Ludovico il Moro 8901','Bergamo',NULL,'10235','Italy'),(10301,86,8,'2006-09-09 00:00:00','2006-10-07 00:00:00','2006-09-17 00:00:00',2,45.08,'Ship to 86-A','Adenauerallee 8901','Stuttgart',NULL,'10347','Germany'),(10302,76,4,'2006-09-10 00:00:00','2006-10-08 00:00:00','2006-10-09 00:00:00',2,6.27,'Ship to 76-B','Boulevard Tirou, 9012','Charleroi',NULL,'10318','Belgium'),(10303,30,7,'2006-09-11 00:00:00','2006-10-09 00:00:00','2006-09-18 00:00:00',2,107.83,'Destination IIYDD','C/ Romero, 5678','Sevilla',NULL,'10183','Spain'),(10304,80,1,'2006-09-12 00:00:00','2006-10-10 00:00:00','2006-09-17 00:00:00',2,63.79,'Ship to 80-C','Avda. Azteca 5678','México D.F.',NULL,'10334','Mexico'),(10305,55,8,'2006-09-13 00:00:00','2006-10-11 00:00:00','2006-10-09 00:00:00',3,257.62,'Ship to 55-B','8901 Bering St.','Anchorage','AK','10256','USA'),(10306,69,1,'2006-09-16 00:00:00','2006-10-14 00:00:00','2006-09-23 00:00:00',3,7.56,'Ship to 69-B','Gran Vía, 0123','Madrid',NULL,'10298','Spain'),(10307,48,2,'2006-09-17 00:00:00','2006-10-15 00:00:00','2006-09-25 00:00:00',2,0.56,'Ship to 48-B','6789 Chiaroscuro Rd.','Portland','OR','10233','USA'),(10308,2,7,'2006-09-18 00:00:00','2006-10-16 00:00:00','2006-09-24 00:00:00',3,1.61,'Destination QMVCI','Avda. de la Constitución 2345','México D.F.',NULL,'10180','Mexico'),(10309,37,3,'2006-09-19 00:00:00','2006-10-17 00:00:00','2006-10-23 00:00:00',1,47.30,'Destination ATSOA','4567 Johnstown Road','Cork','Co. Cork','10202','Ireland'),(10310,77,8,'2006-09-20 00:00:00','2006-10-18 00:00:00','2006-09-27 00:00:00',2,17.52,'Ship to 77-B','2345 Jefferson Way Suite 2','Portland','OR','10321','USA'),(10311,18,1,'2006-09-20 00:00:00','2006-10-04 00:00:00','2006-09-26 00:00:00',3,24.69,'Destination SNPXM','0123, rue des Cinquante Otages','Nantes',NULL,'10148','France'),(10312,86,2,'2006-09-23 00:00:00','2006-10-21 00:00:00','2006-10-03 00:00:00',2,40.26,'Ship to 86-B','Adenauerallee 9012','Stuttgart',NULL,'10348','Germany'),(10313,63,2,'2006-09-24 00:00:00','2006-10-22 00:00:00','2006-10-04 00:00:00',2,1.96,'Ship to 63-A','Taucherstraße 1234','Cunewalde',NULL,'10279','Germany'),(10314,65,1,'2006-09-25 00:00:00','2006-10-23 00:00:00','2006-10-04 00:00:00',2,74.16,'Ship to 65-A','7890 Milton Dr.','Albuquerque','NM','10285','USA'),(10315,38,4,'2006-09-26 00:00:00','2006-10-24 00:00:00','2006-10-03 00:00:00',2,41.76,'Destination AXVHD','Garden House Crowther Way 9012','Cowes','Isle of Wight','10207','UK'),(10316,65,1,'2006-09-27 00:00:00','2006-10-25 00:00:00','2006-10-08 00:00:00',3,150.15,'Ship to 65-B','8901 Milton Dr.','Albuquerque','NM','10286','USA'),(10317,48,6,'2006-09-30 00:00:00','2006-10-28 00:00:00','2006-10-10 00:00:00',1,12.69,'Ship to 48-B','6789 Chiaroscuro Rd.','Portland','OR','10233','USA'),(10318,38,8,'2006-10-01 00:00:00','2006-10-29 00:00:00','2006-10-04 00:00:00',2,4.73,'Destination AXVHD','Garden House Crowther Way 9012','Cowes','Isle of Wight','10207','UK'),(10319,80,7,'2006-10-02 00:00:00','2006-10-30 00:00:00','2006-10-11 00:00:00',3,64.50,'Ship to 80-B','Avda. Azteca 4567','México D.F.',NULL,'10333','Mexico'),(10320,87,5,'2006-10-03 00:00:00','2006-10-17 00:00:00','2006-10-18 00:00:00',3,34.57,'Ship to 87-A','Torikatu 1234','Oulu',NULL,'10350','Finland'),(10321,38,3,'2006-10-03 00:00:00','2006-10-31 00:00:00','2006-10-11 00:00:00',2,3.43,'Destination LMVGS','Garden House Crowther Way 8901','Cowes','Isle of Wight','10206','UK'),(10322,58,7,'2006-10-04 00:00:00','2006-11-01 00:00:00','2006-10-23 00:00:00',3,0.40,'Ship to 58-A','Calle Dr. Jorge Cash 3456','México D.F.',NULL,'10261','Mexico'),(10323,39,4,'2006-10-07 00:00:00','2006-11-04 00:00:00','2006-10-14 00:00:00',1,4.88,'Destination RMBHM','Maubelstr. 1234','Brandenburg',NULL,'10209','Germany'),(10324,71,9,'2006-10-08 00:00:00','2006-11-05 00:00:00','2006-10-10 00:00:00',1,214.27,'Ship to 71-C','9012 Suffolk Ln.','Boise','Id','10307','USA'),(10325,39,1,'2006-10-09 00:00:00','2006-10-23 00:00:00','2006-10-14 00:00:00',3,64.86,'Destination RMBHM','Maubelstr. 1234','Brandenburg',NULL,'10209','Germany'),(10326,8,4,'2006-10-10 00:00:00','2006-11-07 00:00:00','2006-10-14 00:00:00',2,77.92,'Ship to 8-A','C/ Araquil, 0123','Madrid',NULL,'10359','Spain'),(10327,24,2,'2006-10-11 00:00:00','2006-11-08 00:00:00','2006-10-14 00:00:00',1,63.36,'Destination NCKKO','Åkergatan 7890','Bräcke',NULL,'10165','Sweden'),(10328,28,4,'2006-10-14 00:00:00','2006-11-11 00:00:00','2006-10-17 00:00:00',3,87.03,'Destination CIRQO','Jardim das rosas n. 8901','Lisboa',NULL,'10176','Portugal'),(10329,75,4,'2006-10-15 00:00:00','2006-11-26 00:00:00','2006-10-23 00:00:00',2,191.67,'Ship to 75-C','P.O. Box 7890','Lander','WY','10316','USA'),(10330,46,3,'2006-10-16 00:00:00','2006-11-13 00:00:00','2006-10-28 00:00:00',1,12.75,'Ship to 46-A','Carrera 0123 con Ave. Bolívar #65-98 Llano Largo','Barquisimeto','Lara','10227','Venezuela'),(10331,9,9,'2006-10-16 00:00:00','2006-11-27 00:00:00','2006-10-21 00:00:00',1,10.19,'Ship to 9-C','0123, rue des Bouchers','Marseille',NULL,'10369','France'),(10332,51,3,'2006-10-17 00:00:00','2006-11-28 00:00:00','2006-10-21 00:00:00',2,52.84,'Ship to 51-B','7890 rue St. Laurent','Montréal','Québec','10245','Canada'),(10333,87,5,'2006-10-18 00:00:00','2006-11-15 00:00:00','2006-10-25 00:00:00',3,0.59,'Ship to 87-C','Torikatu 3456','Oulu',NULL,'10352','Finland'),(10334,84,8,'2006-10-21 00:00:00','2006-11-18 00:00:00','2006-10-28 00:00:00',2,8.56,'Ship to 84-B','4567, rue du Commerce','Lyon',NULL,'10343','France'),(10335,37,7,'2006-10-22 00:00:00','2006-11-19 00:00:00','2006-10-24 00:00:00',2,42.11,'Destination ATSOA','4567 Johnstown Road','Cork','Co. Cork','10202','Ireland'),(10336,60,7,'2006-10-23 00:00:00','2006-11-20 00:00:00','2006-10-25 00:00:00',2,15.51,'Ship to 60-B','Estrada da saúde n. 3456','Lisboa',NULL,'10271','Portugal'),(10337,25,4,'2006-10-24 00:00:00','2006-11-21 00:00:00','2006-10-29 00:00:00',3,108.26,'Destination QOCBL','Berliner Platz 1234','München',NULL,'10169','Germany'),(10338,55,4,'2006-10-25 00:00:00','2006-11-22 00:00:00','2006-10-29 00:00:00',3,84.21,'Ship to 55-C','9012 Bering St.','Anchorage','AK','10257','USA'),(10339,51,2,'2006-10-28 00:00:00','2006-11-25 00:00:00','2006-11-04 00:00:00',2,15.66,'Ship to 51-C','8901 rue St. Laurent','Montréal','Québec','10246','Canada'),(10340,9,1,'2006-10-29 00:00:00','2006-11-26 00:00:00','2006-11-08 00:00:00',3,166.31,'Ship to 9-A','8901, rue des Bouchers','Marseille',NULL,'10367','France'),(10341,73,7,'2006-10-29 00:00:00','2006-11-26 00:00:00','2006-11-05 00:00:00',3,26.78,'Ship to 73-A','Vinbæltet 1234','Kobenhavn',NULL,'10310','Denmark'),(10342,25,4,'2006-10-30 00:00:00','2006-11-13 00:00:00','2006-11-04 00:00:00',2,54.83,'Destination VAPXU','Berliner Platz 0123','München',NULL,'10168','Germany'),(10343,44,4,'2006-10-31 00:00:00','2006-11-28 00:00:00','2006-11-06 00:00:00',1,110.37,'Ship to 44-A','Magazinweg 4567','Frankfurt a.M.',NULL,'10222','Germany'),(10344,89,4,'2006-11-01 00:00:00','2006-11-29 00:00:00','2006-11-05 00:00:00',2,23.29,'Ship to 89-A','7890 - 12th Ave. S.','Seattle','WA','10356','USA'),(10345,63,2,'2006-11-04 00:00:00','2006-12-02 00:00:00','2006-11-11 00:00:00',2,249.06,'Ship to 63-B','Taucherstraße 2345','Cunewalde',NULL,'10280','Germany'),(10346,65,3,'2006-11-05 00:00:00','2006-12-17 00:00:00','2006-11-08 00:00:00',3,142.08,'Ship to 65-A','7890 Milton Dr.','Albuquerque','NM','10285','USA'),(10347,21,4,'2006-11-06 00:00:00','2006-12-04 00:00:00','2006-11-08 00:00:00',3,3.10,'Destination KKELL','Rua Orós, 4567','Sao Paulo','SP','10162','Brazil'),(10348,86,4,'2006-11-07 00:00:00','2006-12-05 00:00:00','2006-11-15 00:00:00',2,0.78,'Ship to 86-B','Adenauerallee 9012','Stuttgart',NULL,'10348','Germany'),(10349,75,7,'2006-11-08 00:00:00','2006-12-06 00:00:00','2006-11-15 00:00:00',1,8.63,'Ship to 75-C','P.O. Box 7890','Lander','WY','10316','USA'),(10350,41,6,'2006-11-11 00:00:00','2006-12-09 00:00:00','2006-12-03 00:00:00',2,64.19,'Destination DWJIO','9012 rue Alsace-Lorraine','Toulouse',NULL,'10217','France'),(10351,20,1,'2006-11-11 00:00:00','2006-12-09 00:00:00','2006-11-20 00:00:00',1,162.33,'Destination RVDMF','Kirchgasse 9012','Graz',NULL,'10157','Austria'),(10352,28,3,'2006-11-12 00:00:00','2006-11-26 00:00:00','2006-11-18 00:00:00',3,1.30,'Destination OTSWR','Jardim das rosas n. 9012','Lisboa',NULL,'10177','Portugal'),(10353,59,7,'2006-11-13 00:00:00','2006-12-11 00:00:00','2006-11-25 00:00:00',3,360.63,'Ship to 59-B','Geislweg 7890','Salzburg',NULL,'10265','Austria'),(10354,58,8,'2006-11-14 00:00:00','2006-12-12 00:00:00','2006-11-20 00:00:00',3,53.80,'Ship to 58-C','Calle Dr. Jorge Cash 5678','México D.F.',NULL,'10263','Mexico'),(10355,4,6,'2006-11-15 00:00:00','2006-12-13 00:00:00','2006-11-20 00:00:00',1,41.95,'Ship to 4-A','Brook Farm Stratford St. Mary 0123','Colchester','Essex','10238','UK'),(10356,86,6,'2006-11-18 00:00:00','2006-12-16 00:00:00','2006-11-27 00:00:00',2,36.71,'Ship to 86-A','Adenauerallee 8901','Stuttgart',NULL,'10347','Germany'),(10357,46,1,'2006-11-19 00:00:00','2006-12-17 00:00:00','2006-12-02 00:00:00',3,34.88,'Ship to 46-B','Carrera 1234 con Ave. Bolívar #65-98 Llano Largo','Barquisimeto','Lara','10228','Venezuela'),(10358,41,5,'2006-11-20 00:00:00','2006-12-18 00:00:00','2006-11-27 00:00:00',1,19.64,'Ship to 41-C','0123 rue Alsace-Lorraine','Toulouse',NULL,'10218','France'),(10359,72,5,'2006-11-21 00:00:00','2006-12-19 00:00:00','2006-11-26 00:00:00',3,288.43,'Ship to 72-C','1234 Wadhurst Rd.','London',NULL,'10309','UK'),(10360,7,4,'2006-11-22 00:00:00','2006-12-20 00:00:00','2006-12-02 00:00:00',3,131.70,'Ship to 7-C','2345, place Kléber','Strasbourg',NULL,'10331','France'),(10361,63,1,'2006-11-22 00:00:00','2006-12-20 00:00:00','2006-12-03 00:00:00',2,183.17,'Ship to 63-C','Taucherstraße 3456','Cunewalde',NULL,'10281','Germany'),(10362,9,3,'2006-11-25 00:00:00','2006-12-23 00:00:00','2006-11-28 00:00:00',1,96.04,'Ship to 9-B','9012, rue des Bouchers','Marseille',NULL,'10368','France'),(10363,17,4,'2006-11-26 00:00:00','2006-12-24 00:00:00','2006-12-04 00:00:00',3,30.54,'Destination BJCXA','Walserweg 7890','Aachen',NULL,'10145','Germany'),(10364,19,1,'2006-11-26 00:00:00','2007-01-07 00:00:00','2006-12-04 00:00:00',1,71.97,'Destination QTKCU','3456 King George','London',NULL,'10151','UK'),(10365,3,3,'2006-11-27 00:00:00','2006-12-25 00:00:00','2006-12-02 00:00:00',2,22.00,'Destination FQFLS','Mataderos 3456','México D.F.',NULL,'10211','Mexico'),(10366,29,8,'2006-11-28 00:00:00','2007-01-09 00:00:00','2006-12-30 00:00:00',2,10.14,'Destination VPNNG','Rambla de Cataluña, 0123','Barcelona',NULL,'10178','Spain'),(10367,83,7,'2006-11-28 00:00:00','2006-12-26 00:00:00','2006-12-02 00:00:00',3,13.55,'Ship to 83-B','Smagsloget 1234','Århus',NULL,'10340','Denmark'),(10368,20,2,'2006-11-29 00:00:00','2006-12-27 00:00:00','2006-12-02 00:00:00',2,101.95,'Destination RVDMF','Kirchgasse 9012','Graz',NULL,'10157','Austria'),(10369,75,8,'2006-12-02 00:00:00','2006-12-30 00:00:00','2006-12-09 00:00:00',2,195.68,'Ship to 75-C','P.O. Box 7890','Lander','WY','10316','USA'),(10370,14,6,'2006-12-03 00:00:00','2006-12-31 00:00:00','2006-12-27 00:00:00',2,1.17,'Destination YUJRD','Hauptstr. 1234','Bern',NULL,'10139','Switzerland'),(10371,41,1,'2006-12-03 00:00:00','2006-12-31 00:00:00','2006-12-24 00:00:00',1,0.45,'Ship to 41-C','0123 rue Alsace-Lorraine','Toulouse',NULL,'10218','France'),(10372,62,5,'2006-12-04 00:00:00','2007-01-01 00:00:00','2006-12-09 00:00:00',2,890.78,'Ship to 62-A','Alameda dos Canàrios, 8901','Sao Paulo','SP','10276','Brazil'),(10373,37,4,'2006-12-05 00:00:00','2007-01-02 00:00:00','2006-12-11 00:00:00',3,124.12,'Destination KPVYJ','5678 Johnstown Road','Cork','Co. Cork','10203','Ireland'),(10374,91,1,'2006-12-05 00:00:00','2007-01-02 00:00:00','2006-12-09 00:00:00',3,3.94,'Ship to 91-A','ul. Filtrowa 5678','Warszawa',NULL,'10364','Poland'),(10375,36,3,'2006-12-06 00:00:00','2007-01-03 00:00:00','2006-12-09 00:00:00',2,20.12,'Destination HOHCR','City Center Plaza 3456 Main St.','Elgin','OR','10201','USA'),(10376,51,1,'2006-12-09 00:00:00','2007-01-06 00:00:00','2006-12-13 00:00:00',2,20.39,'Ship to 51-B','7890 rue St. Laurent','Montréal','Québec','10245','Canada'),(10377,72,1,'2006-12-09 00:00:00','2007-01-06 00:00:00','2006-12-13 00:00:00',3,22.21,'Ship to 72-C','1234 Wadhurst Rd.','London',NULL,'10309','UK'),(10378,24,5,'2006-12-10 00:00:00','2007-01-07 00:00:00','2006-12-19 00:00:00',3,5.44,'Destination KBSBN','Åkergatan 9012','Bräcke',NULL,'10167','Sweden'),(10379,61,2,'2006-12-11 00:00:00','2007-01-08 00:00:00','2006-12-13 00:00:00',1,45.03,'Ship to 61-B','Rua da Panificadora, 6789','Rio de Janeiro','RJ','10274','Brazil'),(10380,37,8,'2006-12-12 00:00:00','2007-01-09 00:00:00','2007-01-16 00:00:00',3,35.03,'Destination KPVYJ','5678 Johnstown Road','Cork','Co. Cork','10203','Ireland'),(10381,46,3,'2006-12-12 00:00:00','2007-01-09 00:00:00','2006-12-13 00:00:00',3,7.99,'Ship to 46-C','Carrera 2345 con Ave. Bolívar #65-98 Llano Largo','Barquisimeto','Lara','10229','Venezuela'),(10382,20,4,'2006-12-13 00:00:00','2007-01-10 00:00:00','2006-12-16 00:00:00',1,94.77,'Destination FFXKT','Kirchgasse 0123','Graz',NULL,'10158','Austria'),(10383,4,8,'2006-12-16 00:00:00','2007-01-13 00:00:00','2006-12-18 00:00:00',3,34.24,'Ship to 4-B','Brook Farm Stratford St. Mary 1234','Colchester','Essex','10239','UK'),(10384,5,3,'2006-12-16 00:00:00','2007-01-13 00:00:00','2006-12-20 00:00:00',3,168.64,'Ship to 5-C','Berguvsvägen 1234','Luleå',NULL,'10269','Sweden'),(10385,75,1,'2006-12-17 00:00:00','2007-01-14 00:00:00','2006-12-23 00:00:00',2,30.96,'Ship to 75-B','P.O. Box 6789','Lander','WY','10315','USA'),(10386,21,9,'2006-12-18 00:00:00','2007-01-01 00:00:00','2006-12-25 00:00:00',3,13.99,'Destination RNSMS','Rua Orós, 2345','Sao Paulo','SP','10160','Brazil'),(10387,70,1,'2006-12-18 00:00:00','2007-01-15 00:00:00','2006-12-20 00:00:00',2,93.63,'Ship to 70-B','Erling Skakkes gate 5678','Stavern',NULL,'10303','Norway'),(10388,72,2,'2006-12-19 00:00:00','2007-01-16 00:00:00','2006-12-20 00:00:00',1,34.86,'Ship to 72-C','1234 Wadhurst Rd.','London',NULL,'10309','UK'),(10389,10,4,'2006-12-20 00:00:00','2007-01-17 00:00:00','2006-12-24 00:00:00',2,47.42,'Destination OLSSJ','2345 Tsawassen Blvd.','Tsawassen','BC','10130','Canada'),(10390,20,6,'2006-12-23 00:00:00','2007-01-20 00:00:00','2006-12-26 00:00:00',1,126.38,'Destination RVDMF','Kirchgasse 9012','Graz',NULL,'10157','Austria'),(10391,17,3,'2006-12-23 00:00:00','2007-01-20 00:00:00','2006-12-31 00:00:00',3,5.45,'Destination AJTHX','Walserweg 9012','Aachen',NULL,'10147','Germany'),(10392,59,2,'2006-12-24 00:00:00','2007-01-21 00:00:00','2007-01-01 00:00:00',3,122.46,'Ship to 59-A','Geislweg 6789','Salzburg',NULL,'10264','Austria'),(10393,71,1,'2006-12-25 00:00:00','2007-01-22 00:00:00','2007-01-03 00:00:00',3,126.56,'Ship to 71-B','8901 Suffolk Ln.','Boise','Id','10306','USA'),(10394,36,1,'2006-12-25 00:00:00','2007-01-22 00:00:00','2007-01-03 00:00:00',3,30.34,'Destination AWPJG','City Center Plaza 2345 Main St.','Elgin','OR','10200','USA'),(10395,35,6,'2006-12-26 00:00:00','2007-01-23 00:00:00','2007-01-03 00:00:00',1,184.41,'Destination JYDLM','Carrera1234 con Ave. Carlos Soublette #8-35','San Cristóbal','Táchira','10199','Venezuela'),(10396,25,1,'2006-12-27 00:00:00','2007-01-10 00:00:00','2007-01-06 00:00:00',3,135.35,'Destination VAPXU','Berliner Platz 0123','München',NULL,'10168','Germany'),(10397,60,5,'2006-12-27 00:00:00','2007-01-24 00:00:00','2007-01-02 00:00:00',1,60.26,'Ship to 60-A','Estrada da saúde n. 2345','Lisboa',NULL,'10270','Portugal'),(10398,71,2,'2006-12-30 00:00:00','2007-01-27 00:00:00','2007-01-09 00:00:00',3,89.16,'Ship to 71-C','9012 Suffolk Ln.','Boise','Id','10307','USA'),(10399,83,8,'2006-12-31 00:00:00','2007-01-14 00:00:00','2007-01-08 00:00:00',3,27.36,'Ship to 83-C','Smagsloget 2345','Århus',NULL,'10341','Denmark'),(10400,19,1,'2007-01-01 00:00:00','2007-01-29 00:00:00','2007-01-16 00:00:00',3,83.93,'Destination BBMRT','4567 King George','London',NULL,'10152','UK'),(10401,65,1,'2007-01-01 00:00:00','2007-01-29 00:00:00','2007-01-10 00:00:00',1,12.51,'Ship to 65-A','7890 Milton Dr.','Albuquerque','NM','10285','USA'),(10402,20,8,'2007-01-02 00:00:00','2007-02-13 00:00:00','2007-01-10 00:00:00',2,67.88,'Destination FFXKT','Kirchgasse 0123','Graz',NULL,'10158','Austria'),(10403,20,4,'2007-01-03 00:00:00','2007-01-31 00:00:00','2007-01-09 00:00:00',3,73.79,'Destination RVDMF','Kirchgasse 9012','Graz',NULL,'10157','Austria'),(10404,49,2,'2007-01-03 00:00:00','2007-01-31 00:00:00','2007-01-08 00:00:00',1,155.97,'Ship to 49-B','Via Ludovico il Moro 9012','Bergamo',NULL,'10236','Italy'),(10405,47,1,'2007-01-06 00:00:00','2007-02-03 00:00:00','2007-01-22 00:00:00',1,34.82,'Ship to 47-B','Ave. 5 de Mayo Porlamar 4567','I. de Margarita','Nueva Esparta','10231','Venezuela'),(10406,62,7,'2007-01-07 00:00:00','2007-02-18 00:00:00','2007-01-13 00:00:00',1,108.04,'Ship to 62-A','Alameda dos Canàrios, 8901','Sao Paulo','SP','10276','Brazil'),(10407,56,2,'2007-01-07 00:00:00','2007-02-04 00:00:00','2007-01-30 00:00:00',2,91.48,'Ship to 56-B','Mehrheimerstr. 1234','Köln',NULL,'10259','Germany'),(10408,23,8,'2007-01-08 00:00:00','2007-02-05 00:00:00','2007-01-14 00:00:00',1,11.26,'Destination PXQRR','5678, chaussée de Tournai','Lille',NULL,'10163','France'),(10409,54,3,'2007-01-09 00:00:00','2007-02-06 00:00:00','2007-01-14 00:00:00',1,29.83,'Ship to 54-C','Ing. Gustavo Moncada 6789 Piso 20-A','Buenos Aires',NULL,'10254','Argentina'),(10410,10,3,'2007-01-10 00:00:00','2007-02-07 00:00:00','2007-01-15 00:00:00',3,2.40,'Destination OLSSJ','2345 Tsawassen Blvd.','Tsawassen','BC','10130','Canada'),(10411,10,9,'2007-01-10 00:00:00','2007-02-07 00:00:00','2007-01-21 00:00:00',3,23.65,'Destination XJIBQ','1234 Tsawassen Blvd.','Tsawassen','BC','10129','Canada'),(10412,87,8,'2007-01-13 00:00:00','2007-02-10 00:00:00','2007-01-15 00:00:00',2,3.77,'Ship to 87-C','Torikatu 3456','Oulu',NULL,'10352','Finland'),(10413,41,3,'2007-01-14 00:00:00','2007-02-11 00:00:00','2007-01-16 00:00:00',2,95.66,'Destination DWJIO','9012 rue Alsace-Lorraine','Toulouse',NULL,'10217','France'),(10414,21,2,'2007-01-14 00:00:00','2007-02-11 00:00:00','2007-01-17 00:00:00',3,21.48,'Destination SSYXZ','Rua Orós, 3456','Sao Paulo','SP','10161','Brazil'),(10415,36,3,'2007-01-15 00:00:00','2007-02-12 00:00:00','2007-01-24 00:00:00',1,0.20,'Destination AWPJG','City Center Plaza 2345 Main St.','Elgin','OR','10200','USA'),(10416,87,8,'2007-01-16 00:00:00','2007-02-13 00:00:00','2007-01-27 00:00:00',3,22.72,'Ship to 87-A','Torikatu 1234','Oulu',NULL,'10350','Finland'),(10417,73,4,'2007-01-16 00:00:00','2007-02-13 00:00:00','2007-01-28 00:00:00',3,70.29,'Ship to 73-C','Vinbæltet 2345','Kobenhavn',NULL,'10311','Denmark'),(10418,63,4,'2007-01-17 00:00:00','2007-02-14 00:00:00','2007-01-24 00:00:00',1,17.55,'Ship to 63-B','Taucherstraße 2345','Cunewalde',NULL,'10280','Germany'),(10419,68,4,'2007-01-20 00:00:00','2007-02-17 00:00:00','2007-01-30 00:00:00',2,137.35,'Ship to 68-A','Starenweg 6789','Genève',NULL,'10294','Switzerland'),(10420,88,3,'2007-01-21 00:00:00','2007-02-18 00:00:00','2007-01-27 00:00:00',1,44.12,'Ship to 88-C','Rua do Mercado, 6789','Resende','SP','10355','Brazil'),(10421,61,8,'2007-01-21 00:00:00','2007-03-04 00:00:00','2007-01-27 00:00:00',1,99.23,'Ship to 61-C','Rua da Panificadora, 7890','Rio de Janeiro','RJ','10275','Brazil'),(10422,27,2,'2007-01-22 00:00:00','2007-02-19 00:00:00','2007-01-31 00:00:00',1,3.02,'Destination FFLQT','Via Monte Bianco 6789','Torino',NULL,'10174','Italy'),(10423,31,6,'2007-01-23 00:00:00','2007-02-06 00:00:00','2007-02-24 00:00:00',3,24.50,'Destination VNIAG','Av. Brasil, 9012','Campinas','SP','10187','Brazil'),(10424,51,7,'2007-01-23 00:00:00','2007-02-20 00:00:00','2007-01-27 00:00:00',2,370.61,'Ship to 51-C','8901 rue St. Laurent','Montréal','Québec','10246','Canada'),(10425,41,6,'2007-01-24 00:00:00','2007-02-21 00:00:00','2007-02-14 00:00:00',2,7.93,'Destination DWJIO','9012 rue Alsace-Lorraine','Toulouse',NULL,'10217','France'),(10426,29,4,'2007-01-27 00:00:00','2007-02-24 00:00:00','2007-02-06 00:00:00',1,18.69,'Destination WOFLH','Rambla de Cataluña, 1234','Barcelona',NULL,'10179','Spain'),(10427,59,4,'2007-01-27 00:00:00','2007-02-24 00:00:00','2007-03-03 00:00:00',2,31.29,'Ship to 59-C','Geislweg 8901','Salzburg',NULL,'10266','Austria'),(10428,66,7,'2007-01-28 00:00:00','2007-02-25 00:00:00','2007-02-04 00:00:00',1,11.09,'Ship to 66-C','Strada Provinciale 2345','Reggio Emilia',NULL,'10290','Italy'),(10429,37,3,'2007-01-29 00:00:00','2007-03-12 00:00:00','2007-02-07 00:00:00',2,56.63,'Destination DGKOU','6789 Johnstown Road','Cork','Co. Cork','10204','Ireland'),(10430,20,4,'2007-01-30 00:00:00','2007-02-13 00:00:00','2007-02-03 00:00:00',1,458.78,'Destination CUVPF','Kirchgasse 1234','Graz',NULL,'10159','Austria'),(10431,10,4,'2007-01-30 00:00:00','2007-02-13 00:00:00','2007-02-07 00:00:00',2,44.17,'Destination OLSSJ','2345 Tsawassen Blvd.','Tsawassen','BC','10130','Canada'),(10432,75,3,'2007-01-31 00:00:00','2007-02-14 00:00:00','2007-02-07 00:00:00',2,4.34,'Ship to 75-A','P.O. Box 5678','Lander','WY','10314','USA'),(10433,60,3,'2007-02-03 00:00:00','2007-03-03 00:00:00','2007-03-04 00:00:00',3,73.83,'Ship to 60-A','Estrada da saúde n. 2345','Lisboa',NULL,'10270','Portugal'),(10434,24,3,'2007-02-03 00:00:00','2007-03-03 00:00:00','2007-02-13 00:00:00',2,17.92,'Destination NCKKO','Åkergatan 7890','Bräcke',NULL,'10165','Sweden'),(10435,16,8,'2007-02-04 00:00:00','2007-03-18 00:00:00','2007-02-07 00:00:00',2,9.21,'Destination QKQNB','Berkeley Gardens 5678 Brewery','London',NULL,'10143','UK'),(10436,7,3,'2007-02-05 00:00:00','2007-03-05 00:00:00','2007-02-11 00:00:00',2,156.66,'Ship to 7-C','2345, place Kléber','Strasbourg',NULL,'10331','France'),(10437,87,8,'2007-02-05 00:00:00','2007-03-05 00:00:00','2007-02-12 00:00:00',1,19.97,'Ship to 87-A','Torikatu 1234','Oulu',NULL,'10350','Finland'),(10438,79,3,'2007-02-06 00:00:00','2007-03-06 00:00:00','2007-02-14 00:00:00',2,8.24,'Ship to 79-A','Luisenstr. 7890','Münster',NULL,'10326','Germany'),(10439,51,6,'2007-02-07 00:00:00','2007-03-07 00:00:00','2007-02-10 00:00:00',3,4.07,'Ship to 51-C','8901 rue St. Laurent','Montréal','Québec','10246','Canada'),(10440,71,4,'2007-02-10 00:00:00','2007-03-10 00:00:00','2007-02-28 00:00:00',2,86.53,'Ship to 71-B','8901 Suffolk Ln.','Boise','Id','10306','USA'),(10441,55,3,'2007-02-10 00:00:00','2007-03-24 00:00:00','2007-03-14 00:00:00',2,73.02,'Ship to 55-C','9012 Bering St.','Anchorage','AK','10257','USA'),(10442,20,3,'2007-02-11 00:00:00','2007-03-11 00:00:00','2007-02-18 00:00:00',2,47.94,'Destination RVDMF','Kirchgasse 9012','Graz',NULL,'10157','Austria'),(10443,66,8,'2007-02-12 00:00:00','2007-03-12 00:00:00','2007-02-14 00:00:00',1,13.95,'Ship to 66-C','Strada Provinciale 2345','Reggio Emilia',NULL,'10290','Italy'),(10444,5,3,'2007-02-12 00:00:00','2007-03-12 00:00:00','2007-02-21 00:00:00',3,3.50,'Ship to 5-B','Berguvsvägen 0123','Luleå',NULL,'10268','Sweden'),(10445,5,3,'2007-02-13 00:00:00','2007-03-13 00:00:00','2007-02-20 00:00:00',1,9.30,'Ship to 5-A','Berguvsvägen 9012','Luleå',NULL,'10267','Sweden'),(10446,79,6,'2007-02-14 00:00:00','2007-03-14 00:00:00','2007-02-19 00:00:00',1,14.68,'Ship to 79-C','Luisenstr. 9012','Münster',NULL,'10328','Germany'),(10447,67,4,'2007-02-14 00:00:00','2007-03-14 00:00:00','2007-03-07 00:00:00',2,68.66,'Ship to 67-C','Av. Copacabana, 5678','Rio de Janeiro','RJ','10293','Brazil'),(10448,64,4,'2007-02-17 00:00:00','2007-03-17 00:00:00','2007-02-24 00:00:00',2,38.82,'Ship to 64-A','Av. del Libertador 4567','Buenos Aires',NULL,'10282','Argentina'),(10449,7,3,'2007-02-18 00:00:00','2007-03-18 00:00:00','2007-02-27 00:00:00',2,53.30,'Ship to 7-C','2345, place Kléber','Strasbourg',NULL,'10331','France'),(10450,84,8,'2007-02-19 00:00:00','2007-03-19 00:00:00','2007-03-11 00:00:00',2,7.23,'Ship to 84-C','5678, rue du Commerce','Lyon',NULL,'10344','France'),(10451,63,4,'2007-02-19 00:00:00','2007-03-05 00:00:00','2007-03-12 00:00:00',3,189.09,'Ship to 63-C','Taucherstraße 3456','Cunewalde',NULL,'10281','Germany'),(10452,71,8,'2007-02-20 00:00:00','2007-03-20 00:00:00','2007-02-26 00:00:00',1,140.26,'Ship to 71-B','8901 Suffolk Ln.','Boise','Id','10306','USA'),(10453,4,1,'2007-02-21 00:00:00','2007-03-21 00:00:00','2007-02-26 00:00:00',2,25.36,'Ship to 4-C','Brook Farm Stratford St. Mary 2345','Colchester','Essex','10240','UK'),(10454,41,4,'2007-02-21 00:00:00','2007-03-21 00:00:00','2007-02-25 00:00:00',3,2.74,'Ship to 41-C','0123 rue Alsace-Lorraine','Toulouse',NULL,'10218','France'),(10455,87,8,'2007-02-24 00:00:00','2007-04-07 00:00:00','2007-03-03 00:00:00',2,180.45,'Ship to 87-B','Torikatu 2345','Oulu',NULL,'10351','Finland'),(10456,39,8,'2007-02-25 00:00:00','2007-04-08 00:00:00','2007-02-28 00:00:00',2,8.12,'Destination DKMQA','Maubelstr. 0123','Brandenburg',NULL,'10208','Germany'),(10457,39,2,'2007-02-25 00:00:00','2007-03-25 00:00:00','2007-03-03 00:00:00',1,11.57,'Destination RMBHM','Maubelstr. 1234','Brandenburg',NULL,'10209','Germany'),(10458,76,7,'2007-02-26 00:00:00','2007-03-26 00:00:00','2007-03-04 00:00:00',3,147.06,'Ship to 76-A','Boulevard Tirou, 8901','Charleroi',NULL,'10317','Belgium'),(10459,84,4,'2007-02-27 00:00:00','2007-03-27 00:00:00','2007-02-28 00:00:00',2,25.09,'Ship to 84-B','4567, rue du Commerce','Lyon',NULL,'10343','France'),(10460,24,8,'2007-02-28 00:00:00','2007-03-28 00:00:00','2007-03-03 00:00:00',1,16.27,'Destination YCMPK','Åkergatan 8901','Bräcke',NULL,'10166','Sweden'),(10461,46,1,'2007-02-28 00:00:00','2007-03-28 00:00:00','2007-03-05 00:00:00',3,148.61,'Ship to 46-A','Carrera 0123 con Ave. Bolívar #65-98 Llano Largo','Barquisimeto','Lara','10227','Venezuela'),(10462,16,2,'2007-03-03 00:00:00','2007-03-31 00:00:00','2007-03-18 00:00:00',1,6.17,'Destination ARRMM','Berkeley Gardens 6789 Brewery','London',NULL,'10144','UK'),(10463,76,5,'2007-03-04 00:00:00','2007-04-01 00:00:00','2007-03-06 00:00:00',3,14.78,'Ship to 76-B','Boulevard Tirou, 9012','Charleroi',NULL,'10318','Belgium'),(10464,28,4,'2007-03-04 00:00:00','2007-04-01 00:00:00','2007-03-14 00:00:00',2,89.00,'Destination OTSWR','Jardim das rosas n. 9012','Lisboa',NULL,'10177','Portugal'),(10465,83,1,'2007-03-05 00:00:00','2007-04-02 00:00:00','2007-03-14 00:00:00',3,145.04,'Ship to 83-A','Smagsloget 0123','Århus',NULL,'10339','Denmark'),(10466,15,4,'2007-03-06 00:00:00','2007-04-03 00:00:00','2007-03-13 00:00:00',1,11.93,'Destination GGSQD','Av. dos Lusíadas, 2345','Sao Paulo','SP','10140','Brazil'),(10467,49,8,'2007-03-06 00:00:00','2007-04-03 00:00:00','2007-03-11 00:00:00',2,4.93,'Ship to 49-C','Via Ludovico il Moro 0123','Bergamo',NULL,'10237','Italy'),(10468,39,3,'2007-03-07 00:00:00','2007-04-04 00:00:00','2007-03-12 00:00:00',3,44.12,'Destination RMBHM','Maubelstr. 1234','Brandenburg',NULL,'10209','Germany'),(10469,89,1,'2007-03-10 00:00:00','2007-04-07 00:00:00','2007-03-14 00:00:00',1,60.18,'Ship to 89-C','9012 - 12th Ave. S.','Seattle','WA','10358','USA'),(10470,9,4,'2007-03-11 00:00:00','2007-04-08 00:00:00','2007-03-14 00:00:00',2,64.56,'Ship to 9-C','0123, rue des Bouchers','Marseille',NULL,'10369','France'),(10471,11,2,'2007-03-11 00:00:00','2007-04-08 00:00:00','2007-03-18 00:00:00',3,45.59,'Destination NZASL','Fauntleroy Circus 5678','London',NULL,'10133','UK'),(10472,72,8,'2007-03-12 00:00:00','2007-04-09 00:00:00','2007-03-19 00:00:00',1,4.20,'Ship to 72-A','0123 Wadhurst Rd.','London',NULL,'10308','UK'),(10473,38,1,'2007-03-13 00:00:00','2007-03-27 00:00:00','2007-03-21 00:00:00',3,16.37,'Destination AXVHD','Garden House Crowther Way 9012','Cowes','Isle of Wight','10207','UK'),(10474,58,5,'2007-03-13 00:00:00','2007-04-10 00:00:00','2007-03-21 00:00:00',2,83.49,'Ship to 58-C','Calle Dr. Jorge Cash 5678','México D.F.',NULL,'10263','Mexico'),(10475,76,9,'2007-03-14 00:00:00','2007-04-11 00:00:00','2007-04-04 00:00:00',1,68.52,'Ship to 76-C','Boulevard Tirou, 0123','Charleroi',NULL,'10319','Belgium'),(10476,35,8,'2007-03-17 00:00:00','2007-04-14 00:00:00','2007-03-24 00:00:00',3,4.41,'Destination SXYQX','Carrera 0123 con Ave. Carlos Soublette #8-35','San Cristóbal','Táchira','10198','Venezuela'),(10477,60,5,'2007-03-17 00:00:00','2007-04-14 00:00:00','2007-03-25 00:00:00',2,13.02,'Ship to 60-A','Estrada da saúde n. 2345','Lisboa',NULL,'10270','Portugal'),(10478,84,2,'2007-03-18 00:00:00','2007-04-01 00:00:00','2007-03-26 00:00:00',3,4.81,'Ship to 84-C','5678, rue du Commerce','Lyon',NULL,'10344','France'),(10479,65,3,'2007-03-19 00:00:00','2007-04-16 00:00:00','2007-03-21 00:00:00',3,708.95,'Ship to 65-C','9012 Milton Dr.','Albuquerque','NM','10287','USA'),(10480,23,6,'2007-03-20 00:00:00','2007-04-17 00:00:00','2007-03-24 00:00:00',2,1.35,'Destination AGPCO','6789, chaussée de Tournai','Lille',NULL,'10164','France'),(10481,67,8,'2007-03-20 00:00:00','2007-04-17 00:00:00','2007-03-25 00:00:00',2,64.33,'Ship to 67-A','Av. Copacabana, 3456','Rio de Janeiro','RJ','10291','Brazil'),(10482,43,1,'2007-03-21 00:00:00','2007-04-18 00:00:00','2007-04-10 00:00:00',3,7.48,'Ship to 43-B','3456 Orchestra Terrace','Walla Walla','WA','10221','USA'),(10483,89,7,'2007-03-24 00:00:00','2007-04-21 00:00:00','2007-04-25 00:00:00',2,15.28,'Ship to 89-A','7890 - 12th Ave. S.','Seattle','WA','10356','USA'),(10484,11,3,'2007-03-24 00:00:00','2007-04-21 00:00:00','2007-04-01 00:00:00',3,6.88,'Destination DLEUN','Fauntleroy Circus 4567','London',NULL,'10132','UK'),(10485,47,4,'2007-03-25 00:00:00','2007-04-08 00:00:00','2007-03-31 00:00:00',2,64.45,'Ship to 47-B','Ave. 5 de Mayo Porlamar 4567','I. de Margarita','Nueva Esparta','10231','Venezuela'),(10486,35,1,'2007-03-26 00:00:00','2007-04-23 00:00:00','2007-04-02 00:00:00',2,30.53,'Destination UOUWK','Carrera 9012 con Ave. Carlos Soublette #8-35','San Cristóbal','Táchira','10197','Venezuela'),(10487,62,2,'2007-03-26 00:00:00','2007-04-23 00:00:00','2007-03-28 00:00:00',2,71.07,'Ship to 62-B','Alameda dos Canàrios, 9012','Sao Paulo','SP','10277','Brazil'),(10488,25,8,'2007-03-27 00:00:00','2007-04-24 00:00:00','2007-04-02 00:00:00',2,4.93,'Destination VAPXU','Berliner Platz 0123','München',NULL,'10168','Germany'),(10489,59,6,'2007-03-28 00:00:00','2007-04-25 00:00:00','2007-04-09 00:00:00',2,5.29,'Ship to 59-C','Geislweg 8901','Salzburg',NULL,'10266','Austria'),(10490,35,7,'2007-03-31 00:00:00','2007-04-28 00:00:00','2007-04-03 00:00:00',2,210.19,'Destination JYDLM','Carrera1234 con Ave. Carlos Soublette #8-35','San Cristóbal','Táchira','10199','Venezuela'),(10491,28,8,'2007-03-31 00:00:00','2007-04-28 00:00:00','2007-04-08 00:00:00',3,16.96,'Destination OTSWR','Jardim das rosas n. 9012','Lisboa',NULL,'10177','Portugal'),(10492,10,3,'2007-04-01 00:00:00','2007-04-29 00:00:00','2007-04-11 00:00:00',1,62.89,'Destination XJIBQ','1234 Tsawassen Blvd.','Tsawassen','BC','10129','Canada'),(10493,41,4,'2007-04-02 00:00:00','2007-04-30 00:00:00','2007-04-10 00:00:00',3,10.64,'Destination OLJND','8901 rue Alsace-Lorraine','Toulouse',NULL,'10216','France'),(10494,15,4,'2007-04-02 00:00:00','2007-04-30 00:00:00','2007-04-09 00:00:00',2,65.99,'Destination EVHYA','Av. dos Lusíadas, 3456','Sao Paulo','SP','10141','Brazil'),(10495,42,3,'2007-04-03 00:00:00','2007-05-01 00:00:00','2007-04-11 00:00:00',3,4.65,'Ship to 42-C','2345 Elm St.','Vancouver','BC','10220','Canada'),(10496,81,7,'2007-04-04 00:00:00','2007-05-02 00:00:00','2007-04-07 00:00:00',2,46.77,'Ship to 81-C','Av. Inês de Castro, 7890','Sao Paulo','SP','10336','Brazil'),(10497,44,7,'2007-04-04 00:00:00','2007-05-02 00:00:00','2007-04-07 00:00:00',1,36.21,'Ship to 44-A','Magazinweg 4567','Frankfurt a.M.',NULL,'10222','Germany'),(10498,35,8,'2007-04-07 00:00:00','2007-05-05 00:00:00','2007-04-11 00:00:00',2,29.75,'Destination SXYQX','Carrera 0123 con Ave. Carlos Soublette #8-35','San Cristóbal','Táchira','10198','Venezuela'),(10499,46,4,'2007-04-08 00:00:00','2007-05-06 00:00:00','2007-04-16 00:00:00',2,102.02,'Ship to 46-C','Carrera 2345 con Ave. Bolívar #65-98 Llano Largo','Barquisimeto','Lara','10229','Venezuela'),(10500,41,6,'2007-04-09 00:00:00','2007-05-07 00:00:00','2007-04-17 00:00:00',1,42.68,'Destination OLJND','8901 rue Alsace-Lorraine','Toulouse',NULL,'10216','France'),(10501,6,9,'2007-04-09 00:00:00','2007-05-07 00:00:00','2007-04-16 00:00:00',3,8.85,'Ship to 6-C','Forsterstr. 4567','Mannheim',NULL,'10302','Germany'),(10502,58,2,'2007-04-10 00:00:00','2007-05-08 00:00:00','2007-04-29 00:00:00',1,69.32,'Ship to 58-B','Calle Dr. Jorge Cash 4567','México D.F.',NULL,'10262','Mexico'),(10503,37,6,'2007-04-11 00:00:00','2007-05-09 00:00:00','2007-04-16 00:00:00',2,16.74,'Destination ATSOA','4567 Johnstown Road','Cork','Co. Cork','10202','Ireland'),(10504,89,4,'2007-04-11 00:00:00','2007-05-09 00:00:00','2007-04-18 00:00:00',3,59.13,'Ship to 89-B','8901 - 12th Ave. S.','Seattle','WA','10357','USA'),(10505,51,3,'2007-04-14 00:00:00','2007-05-12 00:00:00','2007-04-21 00:00:00',3,7.13,'Ship to 51-B','7890 rue St. Laurent','Montréal','Québec','10245','Canada'),(10506,39,9,'2007-04-15 00:00:00','2007-05-13 00:00:00','2007-05-02 00:00:00',2,21.19,'Destination DKMQA','Maubelstr. 0123','Brandenburg',NULL,'10208','Germany'),(10507,3,7,'2007-04-15 00:00:00','2007-05-13 00:00:00','2007-04-22 00:00:00',1,47.45,'Destination FQFLS','Mataderos 3456','México D.F.',NULL,'10211','Mexico'),(10508,56,1,'2007-04-16 00:00:00','2007-05-14 00:00:00','2007-05-13 00:00:00',2,4.99,'Ship to 56-C','Mehrheimerstr. 2345','Köln',NULL,'10260','Germany'),(10509,6,4,'2007-04-17 00:00:00','2007-05-15 00:00:00','2007-04-29 00:00:00',1,0.15,'Ship to 6-A','Forsterstr. 2345','Mannheim',NULL,'10300','Germany'),(10510,71,6,'2007-04-18 00:00:00','2007-05-16 00:00:00','2007-04-28 00:00:00',3,367.63,'Ship to 71-A','7890 Suffolk Ln.','Boise','Id','10305','USA'),(10511,9,4,'2007-04-18 00:00:00','2007-05-16 00:00:00','2007-04-21 00:00:00',3,350.64,'Ship to 9-B','9012, rue des Bouchers','Marseille',NULL,'10368','France'),(10512,21,7,'2007-04-21 00:00:00','2007-05-19 00:00:00','2007-04-24 00:00:00',2,3.53,'Destination RNSMS','Rua Orós, 2345','Sao Paulo','SP','10160','Brazil'),(10513,86,7,'2007-04-22 00:00:00','2007-06-03 00:00:00','2007-04-28 00:00:00',1,105.65,'Ship to 86-A','Adenauerallee 8901','Stuttgart',NULL,'10347','Germany'),(10514,20,3,'2007-04-22 00:00:00','2007-05-20 00:00:00','2007-05-16 00:00:00',2,789.95,'Destination CUVPF','Kirchgasse 1234','Graz',NULL,'10159','Austria'),(10515,63,2,'2007-04-23 00:00:00','2007-05-07 00:00:00','2007-05-23 00:00:00',1,204.47,'Ship to 63-B','Taucherstraße 2345','Cunewalde',NULL,'10280','Germany'),(10516,37,2,'2007-04-24 00:00:00','2007-05-22 00:00:00','2007-05-01 00:00:00',3,62.78,'Destination DGKOU','6789 Johnstown Road','Cork','Co. Cork','10204','Ireland'),(10517,53,3,'2007-04-24 00:00:00','2007-05-22 00:00:00','2007-04-29 00:00:00',3,32.07,'Ship to 53-A','South House 2345 Queensbridge','London',NULL,'10250','UK'),(10518,80,4,'2007-04-25 00:00:00','2007-05-09 00:00:00','2007-05-05 00:00:00',2,218.15,'Ship to 80-B','Avda. Azteca 4567','México D.F.',NULL,'10333','Mexico'),(10519,14,6,'2007-04-28 00:00:00','2007-05-26 00:00:00','2007-05-01 00:00:00',3,91.76,'Destination NRTZZ','Hauptstr. 0123','Bern',NULL,'10138','Switzerland'),(10520,70,7,'2007-04-29 00:00:00','2007-05-27 00:00:00','2007-05-01 00:00:00',1,13.37,'Ship to 70-B','Erling Skakkes gate 5678','Stavern',NULL,'10303','Norway'),(10521,12,8,'2007-04-29 00:00:00','2007-05-27 00:00:00','2007-05-02 00:00:00',2,17.22,'Destination QTHBC','Cerrito 6789','Buenos Aires',NULL,'10134','Argentina'),(10522,44,4,'2007-04-30 00:00:00','2007-05-28 00:00:00','2007-05-06 00:00:00',1,45.33,'Ship to 44-A','Magazinweg 4567','Frankfurt a.M.',NULL,'10222','Germany'),(10523,72,7,'2007-05-01 00:00:00','2007-05-29 00:00:00','2007-05-30 00:00:00',2,77.63,'Ship to 72-C','1234 Wadhurst Rd.','London',NULL,'10309','UK'),(10524,5,1,'2007-05-01 00:00:00','2007-05-29 00:00:00','2007-05-07 00:00:00',2,244.79,'Ship to 5-A','Berguvsvägen 9012','Luleå',NULL,'10267','Sweden'),(10525,9,1,'2007-05-02 00:00:00','2007-05-30 00:00:00','2007-05-23 00:00:00',2,11.06,'Ship to 9-B','9012, rue des Bouchers','Marseille',NULL,'10368','France'),(10526,87,4,'2007-05-05 00:00:00','2007-06-02 00:00:00','2007-05-15 00:00:00',2,58.59,'Ship to 87-C','Torikatu 3456','Oulu',NULL,'10352','Finland'),(10527,63,7,'2007-05-05 00:00:00','2007-06-02 00:00:00','2007-05-07 00:00:00',1,41.90,'Ship to 63-B','Taucherstraße 2345','Cunewalde',NULL,'10280','Germany'),(10528,32,6,'2007-05-06 00:00:00','2007-05-20 00:00:00','2007-05-09 00:00:00',2,3.35,'Destination LLUXZ','1234 Baker Blvd.','Eugene','OR','10189','USA'),(10529,50,5,'2007-05-07 00:00:00','2007-06-04 00:00:00','2007-05-09 00:00:00',2,66.69,'Ship to 50-B','Rue Joseph-Bens 4567','Bruxelles',NULL,'10242','Belgium'),(10530,59,3,'2007-05-08 00:00:00','2007-06-05 00:00:00','2007-05-12 00:00:00',2,339.22,'Ship to 59-C','Geislweg 8901','Salzburg',NULL,'10266','Austria'),(10531,54,7,'2007-05-08 00:00:00','2007-06-05 00:00:00','2007-05-19 00:00:00',1,8.12,'Ship to 54-A','Ing. Gustavo Moncada 4567 Piso 20-A','Buenos Aires',NULL,'10252','Argentina'),(10532,19,7,'2007-05-09 00:00:00','2007-06-06 00:00:00','2007-05-12 00:00:00',3,74.46,'Destination QTKCU','3456 King George','London',NULL,'10151','UK'),(10533,24,8,'2007-05-12 00:00:00','2007-06-09 00:00:00','2007-05-22 00:00:00',1,188.04,'Destination KBSBN','Åkergatan 9012','Bräcke',NULL,'10167','Sweden'),(10534,44,8,'2007-05-12 00:00:00','2007-06-09 00:00:00','2007-05-14 00:00:00',2,27.94,'Ship to 44-A','Magazinweg 4567','Frankfurt a.M.',NULL,'10222','Germany'),(10535,3,4,'2007-05-13 00:00:00','2007-06-10 00:00:00','2007-05-21 00:00:00',1,15.64,'Destination FQFLS','Mataderos 3456','México D.F.',NULL,'10211','Mexico'),(10536,44,3,'2007-05-14 00:00:00','2007-06-11 00:00:00','2007-06-06 00:00:00',2,58.88,'Ship to 44-B','Magazinweg 5678','Frankfurt a.M.',NULL,'10223','Germany'),(10537,68,1,'2007-05-14 00:00:00','2007-05-28 00:00:00','2007-05-19 00:00:00',1,78.85,'Ship to 68-B','Starenweg 7890','Genève',NULL,'10295','Switzerland'),(10538,11,9,'2007-05-15 00:00:00','2007-06-12 00:00:00','2007-05-16 00:00:00',3,4.87,'Destination DLEUN','Fauntleroy Circus 4567','London',NULL,'10132','UK'),(10539,11,6,'2007-05-16 00:00:00','2007-06-13 00:00:00','2007-05-23 00:00:00',3,12.36,'Destination DLEUN','Fauntleroy Circus 4567','London',NULL,'10132','UK'),(10540,63,3,'2007-05-19 00:00:00','2007-06-16 00:00:00','2007-06-13 00:00:00',3,1007.64,'Ship to 63-C','Taucherstraße 3456','Cunewalde',NULL,'10281','Germany'),(10541,34,2,'2007-05-19 00:00:00','2007-06-16 00:00:00','2007-05-29 00:00:00',1,68.65,'Destination SCQXA','Rua do Paço, 7890','Rio de Janeiro','RJ','10195','Brazil'),(10542,39,1,'2007-05-20 00:00:00','2007-06-17 00:00:00','2007-05-26 00:00:00',3,10.95,'Destination DKMQA','Maubelstr. 0123','Brandenburg',NULL,'10208','Germany'),(10543,46,8,'2007-05-21 00:00:00','2007-06-18 00:00:00','2007-05-23 00:00:00',2,48.17,'Ship to 46-B','Carrera 1234 con Ave. Bolívar #65-98 Llano Largo','Barquisimeto','Lara','10228','Venezuela'),(10544,48,4,'2007-05-21 00:00:00','2007-06-18 00:00:00','2007-05-30 00:00:00',1,24.91,'Ship to 48-C','7890 Chiaroscuro Rd.','Portland','OR','10234','USA'),(10545,43,8,'2007-05-22 00:00:00','2007-06-19 00:00:00','2007-06-26 00:00:00',2,11.92,'Ship to 43-B','3456 Orchestra Terrace','Walla Walla','WA','10221','USA'),(10546,84,1,'2007-05-23 00:00:00','2007-06-20 00:00:00','2007-05-27 00:00:00',3,194.72,'Ship to 84-C','5678, rue du Commerce','Lyon',NULL,'10344','France'),(10547,72,3,'2007-05-23 00:00:00','2007-06-20 00:00:00','2007-06-02 00:00:00',2,178.43,'Ship to 72-C','1234 Wadhurst Rd.','London',NULL,'10309','UK'),(10548,79,3,'2007-05-26 00:00:00','2007-06-23 00:00:00','2007-06-02 00:00:00',2,1.43,'Ship to 79-A','Luisenstr. 7890','Münster',NULL,'10326','Germany'),(10549,63,5,'2007-05-27 00:00:00','2007-06-10 00:00:00','2007-05-30 00:00:00',1,171.24,'Ship to 63-C','Taucherstraße 3456','Cunewalde',NULL,'10281','Germany'),(10550,30,7,'2007-05-28 00:00:00','2007-06-25 00:00:00','2007-06-06 00:00:00',3,4.32,'Destination GGQIR','C/ Romero, 6789','Sevilla',NULL,'10184','Spain'),(10551,28,4,'2007-05-28 00:00:00','2007-07-09 00:00:00','2007-06-06 00:00:00',3,72.95,'Destination OTSWR','Jardim das rosas n. 9012','Lisboa',NULL,'10177','Portugal'),(10552,35,2,'2007-05-29 00:00:00','2007-06-26 00:00:00','2007-06-05 00:00:00',1,83.22,'Destination UOUWK','Carrera 9012 con Ave. Carlos Soublette #8-35','San Cristóbal','Táchira','10197','Venezuela'),(10553,87,2,'2007-05-30 00:00:00','2007-06-27 00:00:00','2007-06-03 00:00:00',2,149.49,'Ship to 87-B','Torikatu 2345','Oulu',NULL,'10351','Finland'),(10554,56,4,'2007-05-30 00:00:00','2007-06-27 00:00:00','2007-06-05 00:00:00',3,120.97,'Ship to 56-C','Mehrheimerstr. 2345','Köln',NULL,'10260','Germany'),(10555,71,6,'2007-06-02 00:00:00','2007-06-30 00:00:00','2007-06-04 00:00:00',3,252.49,'Ship to 71-B','8901 Suffolk Ln.','Boise','Id','10306','USA'),(10556,73,2,'2007-06-03 00:00:00','2007-07-15 00:00:00','2007-06-13 00:00:00',1,9.80,'Ship to 73-A','Vinbæltet 1234','Kobenhavn',NULL,'10310','Denmark'),(10557,44,9,'2007-06-03 00:00:00','2007-06-17 00:00:00','2007-06-06 00:00:00',2,96.72,'Ship to 44-C','Magazinweg 6789','Frankfurt a.M.',NULL,'10224','Germany'),(10558,4,1,'2007-06-04 00:00:00','2007-07-02 00:00:00','2007-06-10 00:00:00',2,72.97,'Ship to 4-B','Brook Farm Stratford St. Mary 1234','Colchester','Essex','10239','UK'),(10559,7,6,'2007-06-05 00:00:00','2007-07-03 00:00:00','2007-06-13 00:00:00',1,8.05,'Ship to 7-B','1234, place Kléber','Strasbourg',NULL,'10330','France'),(10560,25,8,'2007-06-06 00:00:00','2007-07-04 00:00:00','2007-06-09 00:00:00',1,36.65,'Destination QOCBL','Berliner Platz 1234','München',NULL,'10169','Germany'),(10561,24,2,'2007-06-06 00:00:00','2007-07-04 00:00:00','2007-06-09 00:00:00',2,242.21,'Destination YCMPK','Åkergatan 8901','Bräcke',NULL,'10166','Sweden'),(10562,66,1,'2007-06-09 00:00:00','2007-07-07 00:00:00','2007-06-12 00:00:00',1,22.95,'Ship to 66-B','Strada Provinciale 1234','Reggio Emilia',NULL,'10289','Italy'),(10563,67,2,'2007-06-10 00:00:00','2007-07-22 00:00:00','2007-06-24 00:00:00',2,60.43,'Ship to 67-B','Av. Copacabana, 4567','Rio de Janeiro','RJ','10292','Brazil'),(10564,65,4,'2007-06-10 00:00:00','2007-07-08 00:00:00','2007-06-16 00:00:00',3,13.75,'Ship to 65-B','8901 Milton Dr.','Albuquerque','NM','10286','USA'),(10565,51,8,'2007-06-11 00:00:00','2007-07-09 00:00:00','2007-06-18 00:00:00',2,7.15,'Ship to 51-C','8901 rue St. Laurent','Montréal','Québec','10246','Canada'),(10566,7,9,'2007-06-12 00:00:00','2007-07-10 00:00:00','2007-06-18 00:00:00',1,88.40,'Ship to 7-C','2345, place Kléber','Strasbourg',NULL,'10331','France'),(10567,37,1,'2007-06-12 00:00:00','2007-07-10 00:00:00','2007-06-17 00:00:00',1,33.97,'Destination DGKOU','6789 Johnstown Road','Cork','Co. Cork','10204','Ireland'),(10568,29,3,'2007-06-13 00:00:00','2007-07-11 00:00:00','2007-07-09 00:00:00',3,6.54,'Destination VPNNG','Rambla de Cataluña, 0123','Barcelona',NULL,'10178','Spain'),(10569,65,5,'2007-06-16 00:00:00','2007-07-14 00:00:00','2007-07-11 00:00:00',1,58.98,'Ship to 65-B','8901 Milton Dr.','Albuquerque','NM','10286','USA'),(10570,51,3,'2007-06-17 00:00:00','2007-07-15 00:00:00','2007-06-19 00:00:00',3,188.99,'Ship to 51-C','8901 rue St. Laurent','Montréal','Québec','10246','Canada'),(10571,20,8,'2007-06-17 00:00:00','2007-07-29 00:00:00','2007-07-04 00:00:00',3,26.06,'Destination RVDMF','Kirchgasse 9012','Graz',NULL,'10157','Austria'),(10572,5,3,'2007-06-18 00:00:00','2007-07-16 00:00:00','2007-06-25 00:00:00',2,116.43,'Ship to 5-B','Berguvsvägen 0123','Luleå',NULL,'10268','Sweden'),(10573,3,7,'2007-06-19 00:00:00','2007-07-17 00:00:00','2007-06-20 00:00:00',3,84.84,'Destination LANNN','Mataderos 4567','México D.F.',NULL,'10212','Mexico'),(10574,82,4,'2007-06-19 00:00:00','2007-07-17 00:00:00','2007-06-30 00:00:00',2,37.60,'Ship to 82-A','8901 DaVinci Blvd.','Kirkland','WA','10337','USA'),(10575,52,5,'2007-06-20 00:00:00','2007-07-04 00:00:00','2007-06-30 00:00:00',1,127.34,'Ship to 52-C','Heerstr. 1234','Leipzig',NULL,'10249','Germany'),(10576,80,3,'2007-06-23 00:00:00','2007-07-07 00:00:00','2007-06-30 00:00:00',3,18.56,'Ship to 80-C','Avda. Azteca 5678','México D.F.',NULL,'10334','Mexico'),(10577,82,9,'2007-06-23 00:00:00','2007-08-04 00:00:00','2007-06-30 00:00:00',2,25.41,'Ship to 82-B','9012 DaVinci Blvd.','Kirkland','WA','10338','USA'),(10578,11,4,'2007-06-24 00:00:00','2007-07-22 00:00:00','2007-07-25 00:00:00',3,29.60,'Destination NZASL','Fauntleroy Circus 5678','London',NULL,'10133','UK'),(10579,45,1,'2007-06-25 00:00:00','2007-07-23 00:00:00','2007-07-04 00:00:00',2,13.73,'Ship to 45-C','9012 Polk St. Suite 5','San Francisco','CA','10226','USA'),(10580,56,4,'2007-06-26 00:00:00','2007-07-24 00:00:00','2007-07-01 00:00:00',3,75.89,'Ship to 56-C','Mehrheimerstr. 2345','Köln',NULL,'10260','Germany'),(10581,21,3,'2007-06-26 00:00:00','2007-07-24 00:00:00','2007-07-02 00:00:00',1,3.01,'Destination SSYXZ','Rua Orós, 3456','Sao Paulo','SP','10161','Brazil'),(10582,6,3,'2007-06-27 00:00:00','2007-07-25 00:00:00','2007-07-14 00:00:00',2,27.71,'Ship to 6-A','Forsterstr. 2345','Mannheim',NULL,'10300','Germany'),(10583,87,2,'2007-06-30 00:00:00','2007-07-28 00:00:00','2007-07-04 00:00:00',2,7.28,'Ship to 87-C','Torikatu 3456','Oulu',NULL,'10352','Finland'),(10584,7,4,'2007-06-30 00:00:00','2007-07-28 00:00:00','2007-07-04 00:00:00',1,59.14,'Ship to 7-B','1234, place Kléber','Strasbourg',NULL,'10330','France'),(10585,88,7,'2007-07-01 00:00:00','2007-07-29 00:00:00','2007-07-10 00:00:00',1,13.41,'Ship to 88-A','Rua do Mercado, 4567','Resende','SP','10353','Brazil'),(10586,66,9,'2007-07-02 00:00:00','2007-07-30 00:00:00','2007-07-09 00:00:00',1,0.48,'Ship to 66-B','Strada Provinciale 1234','Reggio Emilia',NULL,'10289','Italy'),(10587,61,1,'2007-07-02 00:00:00','2007-07-30 00:00:00','2007-07-09 00:00:00',1,62.52,'Ship to 61-C','Rua da Panificadora, 7890','Rio de Janeiro','RJ','10275','Brazil'),(10588,63,2,'2007-07-03 00:00:00','2007-07-31 00:00:00','2007-07-10 00:00:00',3,194.67,'Ship to 63-A','Taucherstraße 1234','Cunewalde',NULL,'10279','Germany'),(10589,32,8,'2007-07-04 00:00:00','2007-08-01 00:00:00','2007-07-14 00:00:00',2,4.42,'Destination AVQUS','2345 Baker Blvd.','Eugene','OR','10190','USA'),(10590,51,4,'2007-07-07 00:00:00','2007-08-04 00:00:00','2007-07-14 00:00:00',3,44.77,'Ship to 51-B','7890 rue St. Laurent','Montréal','Québec','10245','Canada'),(10591,83,1,'2007-07-07 00:00:00','2007-07-21 00:00:00','2007-07-16 00:00:00',1,55.92,'Ship to 83-A','Smagsloget 0123','Århus',NULL,'10339','Denmark'),(10592,44,3,'2007-07-08 00:00:00','2007-08-05 00:00:00','2007-07-16 00:00:00',1,32.10,'Ship to 44-B','Magazinweg 5678','Frankfurt a.M.',NULL,'10223','Germany'),(10593,44,7,'2007-07-09 00:00:00','2007-08-06 00:00:00','2007-08-13 00:00:00',2,174.20,'Ship to 44-C','Magazinweg 6789','Frankfurt a.M.',NULL,'10224','Germany'),(10594,55,3,'2007-07-09 00:00:00','2007-08-06 00:00:00','2007-07-16 00:00:00',2,5.24,'Ship to 55-B','8901 Bering St.','Anchorage','AK','10256','USA'),(10595,20,2,'2007-07-10 00:00:00','2007-08-07 00:00:00','2007-07-14 00:00:00',1,96.78,'Destination CUVPF','Kirchgasse 1234','Graz',NULL,'10159','Austria'),(10596,89,8,'2007-07-11 00:00:00','2007-08-08 00:00:00','2007-08-12 00:00:00',1,16.34,'Ship to 89-C','9012 - 12th Ave. S.','Seattle','WA','10358','USA'),(10597,59,7,'2007-07-11 00:00:00','2007-08-08 00:00:00','2007-07-18 00:00:00',3,35.12,'Ship to 59-B','Geislweg 7890','Salzburg',NULL,'10265','Austria'),(10598,65,1,'2007-07-14 00:00:00','2007-08-11 00:00:00','2007-07-18 00:00:00',3,44.42,'Ship to 65-C','9012 Milton Dr.','Albuquerque','NM','10287','USA'),(10599,11,6,'2007-07-15 00:00:00','2007-08-26 00:00:00','2007-07-21 00:00:00',3,29.98,'Destination DLEUN','Fauntleroy Circus 4567','London',NULL,'10132','UK'),(10600,36,4,'2007-07-16 00:00:00','2007-08-13 00:00:00','2007-07-21 00:00:00',1,45.13,'Destination HOHCR','City Center Plaza 3456 Main St.','Elgin','OR','10201','USA'),(10601,35,7,'2007-07-16 00:00:00','2007-08-27 00:00:00','2007-07-22 00:00:00',1,58.30,'Destination UOUWK','Carrera 9012 con Ave. Carlos Soublette #8-35','San Cristóbal','Táchira','10197','Venezuela'),(10602,83,8,'2007-07-17 00:00:00','2007-08-14 00:00:00','2007-07-22 00:00:00',2,2.92,'Ship to 83-A','Smagsloget 0123','Århus',NULL,'10339','Denmark'),(10603,71,8,'2007-07-18 00:00:00','2007-08-15 00:00:00','2007-08-08 00:00:00',2,48.77,'Ship to 71-C','9012 Suffolk Ln.','Boise','Id','10307','USA'),(10604,28,1,'2007-07-18 00:00:00','2007-08-15 00:00:00','2007-07-29 00:00:00',1,7.46,'Destination CIRQO','Jardim das rosas n. 8901','Lisboa',NULL,'10176','Portugal'),(10605,51,1,'2007-07-21 00:00:00','2007-08-18 00:00:00','2007-07-29 00:00:00',2,379.13,'Ship to 51-B','7890 rue St. Laurent','Montréal','Québec','10245','Canada'),(10606,81,4,'2007-07-22 00:00:00','2007-08-19 00:00:00','2007-07-31 00:00:00',3,79.40,'Ship to 81-C','Av. Inês de Castro, 7890','Sao Paulo','SP','10336','Brazil'),(10607,71,5,'2007-07-22 00:00:00','2007-08-19 00:00:00','2007-07-25 00:00:00',1,200.24,'Ship to 71-C','9012 Suffolk Ln.','Boise','Id','10307','USA'),(10608,79,4,'2007-07-23 00:00:00','2007-08-20 00:00:00','2007-08-01 00:00:00',2,27.79,'Ship to 79-C','Luisenstr. 9012','Münster',NULL,'10328','Germany'),(10609,18,7,'2007-07-24 00:00:00','2007-08-21 00:00:00','2007-07-30 00:00:00',2,1.85,'Destination SNPXM','0123, rue des Cinquante Otages','Nantes',NULL,'10148','France'),(10610,41,8,'2007-07-25 00:00:00','2007-08-22 00:00:00','2007-08-06 00:00:00',1,26.78,'Ship to 41-C','0123 rue Alsace-Lorraine','Toulouse',NULL,'10218','France'),(10611,91,6,'2007-07-25 00:00:00','2007-08-22 00:00:00','2007-08-01 00:00:00',2,80.65,'Ship to 91-B','ul. Filtrowa 6789','Warszawa',NULL,'10365','Poland'),(10612,71,1,'2007-07-28 00:00:00','2007-08-25 00:00:00','2007-08-01 00:00:00',2,544.08,'Ship to 71-A','7890 Suffolk Ln.','Boise','Id','10305','USA'),(10613,35,4,'2007-07-29 00:00:00','2007-08-26 00:00:00','2007-08-01 00:00:00',2,8.11,'Destination JYDLM','Carrera1234 con Ave. Carlos Soublette #8-35','San Cristóbal','Táchira','10199','Venezuela'),(10614,6,8,'2007-07-29 00:00:00','2007-08-26 00:00:00','2007-08-01 00:00:00',3,1.93,'Ship to 6-A','Forsterstr. 2345','Mannheim',NULL,'10300','Germany'),(10615,90,2,'2007-07-30 00:00:00','2007-08-27 00:00:00','2007-08-06 00:00:00',3,0.75,'Ship to 90-B','Keskuskatu 3456','Helsinki',NULL,'10362','Finland'),(10616,32,1,'2007-07-31 00:00:00','2007-08-28 00:00:00','2007-08-05 00:00:00',2,116.53,'Destination LLUXZ','1234 Baker Blvd.','Eugene','OR','10189','USA'),(10617,32,4,'2007-07-31 00:00:00','2007-08-28 00:00:00','2007-08-04 00:00:00',2,18.53,'Destination AVQUS','2345 Baker Blvd.','Eugene','OR','10190','USA'),(10618,51,1,'2007-08-01 00:00:00','2007-09-12 00:00:00','2007-08-08 00:00:00',1,154.68,'Ship to 51-C','8901 rue St. Laurent','Montréal','Québec','10246','Canada'),(10619,51,3,'2007-08-04 00:00:00','2007-09-01 00:00:00','2007-08-07 00:00:00',3,91.05,'Ship to 51-B','7890 rue St. Laurent','Montréal','Québec','10245','Canada'),(10620,42,2,'2007-08-05 00:00:00','2007-09-02 00:00:00','2007-08-14 00:00:00',3,0.94,'Ship to 42-A','1234 Elm St.','Vancouver','BC','10219','Canada'),(10621,38,4,'2007-08-05 00:00:00','2007-09-02 00:00:00','2007-08-11 00:00:00',2,23.73,'Destination LMVGS','Garden House Crowther Way 8901','Cowes','Isle of Wight','10206','UK'),(10622,67,4,'2007-08-06 00:00:00','2007-09-03 00:00:00','2007-08-11 00:00:00',3,50.97,'Ship to 67-A','Av. Copacabana, 3456','Rio de Janeiro','RJ','10291','Brazil'),(10623,25,8,'2007-08-07 00:00:00','2007-09-04 00:00:00','2007-08-12 00:00:00',2,97.18,'Destination VAPXU','Berliner Platz 0123','München',NULL,'10168','Germany'),(10624,78,4,'2007-08-07 00:00:00','2007-09-04 00:00:00','2007-08-19 00:00:00',2,94.80,'Ship to 78-C','6789 Grizzly Peak Rd.','Butte','MT','10325','USA'),(10625,2,3,'2007-08-08 00:00:00','2007-09-05 00:00:00','2007-08-14 00:00:00',1,43.90,'Destination QOTQA','Avda. de la Constitución 3456','México D.F.',NULL,'10181','Mexico'),(10626,5,1,'2007-08-11 00:00:00','2007-09-08 00:00:00','2007-08-20 00:00:00',2,138.69,'Ship to 5-A','Berguvsvägen 9012','Luleå',NULL,'10267','Sweden'),(10627,71,8,'2007-08-11 00:00:00','2007-09-22 00:00:00','2007-08-21 00:00:00',3,107.46,'Ship to 71-B','8901 Suffolk Ln.','Boise','Id','10306','USA'),(10628,7,4,'2007-08-12 00:00:00','2007-09-09 00:00:00','2007-08-20 00:00:00',3,30.36,'Ship to 7-B','1234, place Kléber','Strasbourg',NULL,'10330','France'),(10629,30,4,'2007-08-12 00:00:00','2007-09-09 00:00:00','2007-08-20 00:00:00',3,85.46,'Destination IIYDD','C/ Romero, 5678','Sevilla',NULL,'10183','Spain'),(10630,39,1,'2007-08-13 00:00:00','2007-09-10 00:00:00','2007-08-19 00:00:00',2,32.35,'Destination RMBHM','Maubelstr. 1234','Brandenburg',NULL,'10209','Germany'),(10631,41,8,'2007-08-14 00:00:00','2007-09-11 00:00:00','2007-08-15 00:00:00',1,0.87,'Destination OLJND','8901 rue Alsace-Lorraine','Toulouse',NULL,'10216','France'),(10632,86,8,'2007-08-14 00:00:00','2007-09-11 00:00:00','2007-08-19 00:00:00',1,41.38,'Ship to 86-C','Adenauerallee 0123','Stuttgart',NULL,'10349','Germany'),(10633,20,7,'2007-08-15 00:00:00','2007-09-12 00:00:00','2007-08-18 00:00:00',3,477.90,'Destination FFXKT','Kirchgasse 0123','Graz',NULL,'10158','Austria'),(10634,23,4,'2007-08-15 00:00:00','2007-09-12 00:00:00','2007-08-21 00:00:00',3,487.38,'Destination AGPCO','6789, chaussée de Tournai','Lille',NULL,'10164','France'),(10635,49,8,'2007-08-18 00:00:00','2007-09-15 00:00:00','2007-08-21 00:00:00',3,47.46,'Ship to 49-A','Via Ludovico il Moro 8901','Bergamo',NULL,'10235','Italy'),(10636,87,4,'2007-08-19 00:00:00','2007-09-16 00:00:00','2007-08-26 00:00:00',1,1.15,'Ship to 87-A','Torikatu 1234','Oulu',NULL,'10350','Finland'),(10637,62,6,'2007-08-19 00:00:00','2007-09-16 00:00:00','2007-08-26 00:00:00',1,201.29,'Ship to 62-C','Alameda dos Canàrios, 0123','Sao Paulo','SP','10278','Brazil'),(10638,47,3,'2007-08-20 00:00:00','2007-09-17 00:00:00','2007-09-01 00:00:00',1,158.44,'Ship to 47-B','Ave. 5 de Mayo Porlamar 4567','I. de Margarita','Nueva Esparta','10231','Venezuela'),(10639,70,7,'2007-08-20 00:00:00','2007-09-17 00:00:00','2007-08-27 00:00:00',3,38.64,'Ship to 70-B','Erling Skakkes gate 5678','Stavern',NULL,'10303','Norway'),(10640,86,4,'2007-08-21 00:00:00','2007-09-18 00:00:00','2007-08-28 00:00:00',1,23.55,'Ship to 86-A','Adenauerallee 8901','Stuttgart',NULL,'10347','Germany'),(10641,35,4,'2007-08-22 00:00:00','2007-09-19 00:00:00','2007-08-26 00:00:00',2,179.61,'Destination JYDLM','Carrera1234 con Ave. Carlos Soublette #8-35','San Cristóbal','Táchira','10199','Venezuela'),(10642,73,7,'2007-08-22 00:00:00','2007-09-19 00:00:00','2007-09-05 00:00:00',3,41.89,'Ship to 73-C','Vinbæltet 2345','Kobenhavn',NULL,'10311','Denmark'),(10643,1,6,'2007-08-25 00:00:00','2007-09-22 00:00:00','2007-09-02 00:00:00',1,29.46,'Destination LOUIE','Obere Str. 6789','Berlin',NULL,'10154','Germany'),(10644,88,3,'2007-08-25 00:00:00','2007-09-22 00:00:00','2007-09-01 00:00:00',2,0.14,'Ship to 88-A','Rua do Mercado, 4567','Resende','SP','10353','Brazil'),(10645,34,4,'2007-08-26 00:00:00','2007-09-23 00:00:00','2007-09-02 00:00:00',1,12.41,'Destination DPCVR','Rua do Paço, 6789','Rio de Janeiro','RJ','10194','Brazil'),(10646,37,9,'2007-08-27 00:00:00','2007-10-08 00:00:00','2007-09-03 00:00:00',3,142.33,'Destination ATSOA','4567 Johnstown Road','Cork','Co. Cork','10202','Ireland'),(10647,61,4,'2007-08-27 00:00:00','2007-09-10 00:00:00','2007-09-03 00:00:00',2,45.54,'Ship to 61-B','Rua da Panificadora, 6789','Rio de Janeiro','RJ','10274','Brazil'),(10648,67,5,'2007-08-28 00:00:00','2007-10-09 00:00:00','2007-09-09 00:00:00',2,14.25,'Ship to 67-C','Av. Copacabana, 5678','Rio de Janeiro','RJ','10293','Brazil'),(10649,50,5,'2007-08-28 00:00:00','2007-09-25 00:00:00','2007-08-29 00:00:00',3,6.20,'Ship to 50-B','Rue Joseph-Bens 4567','Bruxelles',NULL,'10242','Belgium'),(10650,21,5,'2007-08-29 00:00:00','2007-09-26 00:00:00','2007-09-03 00:00:00',3,176.81,'Destination SSYXZ','Rua Orós, 3456','Sao Paulo','SP','10161','Brazil'),(10651,86,8,'2007-09-01 00:00:00','2007-09-29 00:00:00','2007-09-11 00:00:00',2,20.60,'Ship to 86-A','Adenauerallee 8901','Stuttgart',NULL,'10347','Germany'),(10652,31,4,'2007-09-01 00:00:00','2007-09-29 00:00:00','2007-09-08 00:00:00',2,7.14,'Destination VNIAG','Av. Brasil, 9012','Campinas','SP','10187','Brazil'),(10653,25,1,'2007-09-02 00:00:00','2007-09-30 00:00:00','2007-09-19 00:00:00',1,93.25,'Destination QOCBL','Berliner Platz 1234','München',NULL,'10169','Germany'),(10654,5,5,'2007-09-02 00:00:00','2007-09-30 00:00:00','2007-09-11 00:00:00',1,55.26,'Ship to 5-C','Berguvsvägen 1234','Luleå',NULL,'10269','Sweden'),(10655,66,1,'2007-09-03 00:00:00','2007-10-01 00:00:00','2007-09-11 00:00:00',2,4.41,'Ship to 66-B','Strada Provinciale 1234','Reggio Emilia',NULL,'10289','Italy'),(10656,32,6,'2007-09-04 00:00:00','2007-10-02 00:00:00','2007-09-10 00:00:00',1,57.15,'Destination AVQUS','2345 Baker Blvd.','Eugene','OR','10190','USA'),(10657,71,2,'2007-09-04 00:00:00','2007-10-02 00:00:00','2007-09-15 00:00:00',2,352.69,'Ship to 71-A','7890 Suffolk Ln.','Boise','Id','10305','USA'),(10658,63,4,'2007-09-05 00:00:00','2007-10-03 00:00:00','2007-09-08 00:00:00',1,364.15,'Ship to 63-C','Taucherstraße 3456','Cunewalde',NULL,'10281','Germany'),(10659,62,7,'2007-09-05 00:00:00','2007-10-03 00:00:00','2007-09-10 00:00:00',2,105.81,'Ship to 62-B','Alameda dos Canàrios, 9012','Sao Paulo','SP','10277','Brazil'),(10660,36,8,'2007-09-08 00:00:00','2007-10-06 00:00:00','2007-10-15 00:00:00',1,111.29,'Destination HOHCR','City Center Plaza 3456 Main St.','Elgin','OR','10201','USA'),(10661,37,7,'2007-09-09 00:00:00','2007-10-07 00:00:00','2007-09-15 00:00:00',3,17.55,'Destination ATSOA','4567 Johnstown Road','Cork','Co. Cork','10202','Ireland'),(10662,48,3,'2007-09-09 00:00:00','2007-10-07 00:00:00','2007-09-18 00:00:00',2,1.28,'Ship to 48-C','7890 Chiaroscuro Rd.','Portland','OR','10234','USA'),(10663,9,2,'2007-09-10 00:00:00','2007-09-24 00:00:00','2007-10-03 00:00:00',2,113.15,'Ship to 9-B','9012, rue des Bouchers','Marseille',NULL,'10368','France'),(10664,28,1,'2007-09-10 00:00:00','2007-10-08 00:00:00','2007-09-19 00:00:00',3,1.27,'Destination OTSWR','Jardim das rosas n. 9012','Lisboa',NULL,'10177','Portugal'),(10665,48,1,'2007-09-11 00:00:00','2007-10-09 00:00:00','2007-09-17 00:00:00',2,26.31,'Ship to 48-B','6789 Chiaroscuro Rd.','Portland','OR','10233','USA'),(10666,68,7,'2007-09-12 00:00:00','2007-10-10 00:00:00','2007-09-22 00:00:00',2,232.42,'Ship to 68-A','Starenweg 6789','Genève',NULL,'10294','Switzerland'),(10667,20,7,'2007-09-12 00:00:00','2007-10-10 00:00:00','2007-09-19 00:00:00',1,78.09,'Destination CUVPF','Kirchgasse 1234','Graz',NULL,'10159','Austria'),(10668,86,1,'2007-09-15 00:00:00','2007-10-13 00:00:00','2007-09-23 00:00:00',2,47.22,'Ship to 86-C','Adenauerallee 0123','Stuttgart',NULL,'10349','Germany'),(10669,73,2,'2007-09-15 00:00:00','2007-10-13 00:00:00','2007-09-22 00:00:00',1,24.39,'Ship to 73-A','Vinbæltet 1234','Kobenhavn',NULL,'10310','Denmark'),(10670,25,4,'2007-09-16 00:00:00','2007-10-14 00:00:00','2007-09-18 00:00:00',1,203.48,'Destination QOCBL','Berliner Platz 1234','München',NULL,'10169','Germany'),(10671,26,1,'2007-09-17 00:00:00','2007-10-15 00:00:00','2007-09-24 00:00:00',1,30.34,'Destination OPXJT','4567, rue Royale','Nantes',NULL,'10172','France'),(10672,5,9,'2007-09-17 00:00:00','2007-10-01 00:00:00','2007-09-26 00:00:00',2,95.75,'Ship to 5-C','Berguvsvägen 1234','Luleå',NULL,'10269','Sweden'),(10673,90,2,'2007-09-18 00:00:00','2007-10-16 00:00:00','2007-09-19 00:00:00',1,22.76,'Ship to 90-B','Keskuskatu 3456','Helsinki',NULL,'10362','Finland'),(10674,38,4,'2007-09-18 00:00:00','2007-10-16 00:00:00','2007-09-30 00:00:00',2,0.90,'Destination QVTLW','Garden House Crowther Way 7890','Cowes','Isle of Wight','10205','UK'),(10675,25,5,'2007-09-19 00:00:00','2007-10-17 00:00:00','2007-09-23 00:00:00',2,31.85,'Destination WEGWI','Berliner Platz 2345','München',NULL,'10170','Germany'),(10676,80,2,'2007-09-22 00:00:00','2007-10-20 00:00:00','2007-09-29 00:00:00',2,2.01,'Ship to 80-C','Avda. Azteca 5678','México D.F.',NULL,'10334','Mexico'),(10677,3,1,'2007-09-22 00:00:00','2007-10-20 00:00:00','2007-09-26 00:00:00',3,4.03,'Destination LANNN','Mataderos 4567','México D.F.',NULL,'10212','Mexico'),(10678,71,7,'2007-09-23 00:00:00','2007-10-21 00:00:00','2007-10-16 00:00:00',3,388.98,'Ship to 71-A','7890 Suffolk Ln.','Boise','Id','10305','USA'),(10679,7,8,'2007-09-23 00:00:00','2007-10-21 00:00:00','2007-09-30 00:00:00',3,27.94,'Ship to 7-A','0123, place Kléber','Strasbourg',NULL,'10329','France'),(10680,55,1,'2007-09-24 00:00:00','2007-10-22 00:00:00','2007-09-26 00:00:00',1,26.61,'Ship to 55-B','8901 Bering St.','Anchorage','AK','10256','USA'),(10681,32,3,'2007-09-25 00:00:00','2007-10-23 00:00:00','2007-09-30 00:00:00',3,76.13,'Destination AVQUS','2345 Baker Blvd.','Eugene','OR','10190','USA'),(10682,3,3,'2007-09-25 00:00:00','2007-10-23 00:00:00','2007-10-01 00:00:00',2,36.13,'Destination RTGIS','Mataderos 2345','México D.F.',NULL,'10210','Mexico'),(10683,18,2,'2007-09-26 00:00:00','2007-10-24 00:00:00','2007-10-01 00:00:00',1,4.40,'Destination FVRGC','2345, rue des Cinquante Otages','Nantes',NULL,'10150','France'),(10684,56,3,'2007-09-26 00:00:00','2007-10-24 00:00:00','2007-09-30 00:00:00',1,145.63,'Ship to 56-B','Mehrheimerstr. 1234','Köln',NULL,'10259','Germany'),(10685,31,4,'2007-09-29 00:00:00','2007-10-13 00:00:00','2007-10-03 00:00:00',2,33.75,'Destination VNIAG','Av. Brasil, 9012','Campinas','SP','10187','Brazil'),(10686,59,2,'2007-09-30 00:00:00','2007-10-28 00:00:00','2007-10-08 00:00:00',1,96.50,'Ship to 59-B','Geislweg 7890','Salzburg',NULL,'10265','Austria'),(10687,37,9,'2007-09-30 00:00:00','2007-10-28 00:00:00','2007-10-30 00:00:00',2,296.43,'Destination KPVYJ','5678 Johnstown Road','Cork','Co. Cork','10203','Ireland'),(10688,83,4,'2007-10-01 00:00:00','2007-10-15 00:00:00','2007-10-07 00:00:00',2,299.09,'Ship to 83-A','Smagsloget 0123','Århus',NULL,'10339','Denmark'),(10689,5,1,'2007-10-01 00:00:00','2007-10-29 00:00:00','2007-10-07 00:00:00',2,13.42,'Ship to 5-B','Berguvsvägen 0123','Luleå',NULL,'10268','Sweden'),(10690,34,1,'2007-10-02 00:00:00','2007-10-30 00:00:00','2007-10-03 00:00:00',1,15.80,'Destination JPAIY','Rua do Paço, 8901','Rio de Janeiro','RJ','10196','Brazil'),(10691,63,2,'2007-10-03 00:00:00','2007-11-14 00:00:00','2007-10-22 00:00:00',2,810.05,'Ship to 63-B','Taucherstraße 2345','Cunewalde',NULL,'10280','Germany'),(10692,1,4,'2007-10-03 00:00:00','2007-10-31 00:00:00','2007-10-13 00:00:00',2,61.02,'Destination RSVRP','Obere Str. 8901','Berlin',NULL,'10156','Germany'),(10693,89,3,'2007-10-06 00:00:00','2007-10-20 00:00:00','2007-10-10 00:00:00',3,139.34,'Ship to 89-C','9012 - 12th Ave. S.','Seattle','WA','10358','USA'),(10694,63,8,'2007-10-06 00:00:00','2007-11-03 00:00:00','2007-10-09 00:00:00',3,398.36,'Ship to 63-A','Taucherstraße 1234','Cunewalde',NULL,'10279','Germany'),(10695,90,7,'2007-10-07 00:00:00','2007-11-18 00:00:00','2007-10-14 00:00:00',1,16.72,'Ship to 90-C','Keskuskatu 4567','Helsinki',NULL,'10363','Finland'),(10696,89,8,'2007-10-08 00:00:00','2007-11-19 00:00:00','2007-10-14 00:00:00',3,102.55,'Ship to 89-A','7890 - 12th Ave. S.','Seattle','WA','10356','USA'),(10697,47,3,'2007-10-08 00:00:00','2007-11-05 00:00:00','2007-10-14 00:00:00',1,45.52,'Ship to 47-B','Ave. 5 de Mayo Porlamar 4567','I. de Margarita','Nueva Esparta','10231','Venezuela'),(10698,20,4,'2007-10-09 00:00:00','2007-11-06 00:00:00','2007-10-17 00:00:00',1,272.47,'Destination RVDMF','Kirchgasse 9012','Graz',NULL,'10157','Austria'),(10699,52,3,'2007-10-09 00:00:00','2007-11-06 00:00:00','2007-10-13 00:00:00',3,0.58,'Ship to 52-B','Heerstr. 0123','Leipzig',NULL,'10248','Germany'),(10700,71,3,'2007-10-10 00:00:00','2007-11-07 00:00:00','2007-10-16 00:00:00',1,65.10,'Ship to 71-C','9012 Suffolk Ln.','Boise','Id','10307','USA'),(10701,37,6,'2007-10-13 00:00:00','2007-10-27 00:00:00','2007-10-15 00:00:00',3,220.31,'Destination KPVYJ','5678 Johnstown Road','Cork','Co. Cork','10203','Ireland'),(10702,1,4,'2007-10-13 00:00:00','2007-11-24 00:00:00','2007-10-21 00:00:00',1,23.94,'Destination ZELZJ','Obere Str. 7890','Berlin',NULL,'10155','Germany'),(10703,24,6,'2007-10-14 00:00:00','2007-11-11 00:00:00','2007-10-20 00:00:00',2,152.30,'Destination KBSBN','Åkergatan 9012','Bräcke',NULL,'10167','Sweden'),(10704,62,6,'2007-10-14 00:00:00','2007-11-11 00:00:00','2007-11-07 00:00:00',1,4.78,'Ship to 62-C','Alameda dos Canàrios, 0123','Sao Paulo','SP','10278','Brazil'),(10705,35,9,'2007-10-15 00:00:00','2007-11-12 00:00:00','2007-11-18 00:00:00',2,3.52,'Destination JYDLM','Carrera1234 con Ave. Carlos Soublette #8-35','San Cristóbal','Táchira','10199','Venezuela'),(10706,55,8,'2007-10-16 00:00:00','2007-11-13 00:00:00','2007-10-21 00:00:00',3,135.63,'Ship to 55-C','9012 Bering St.','Anchorage','AK','10257','USA'),(10707,4,4,'2007-10-16 00:00:00','2007-10-30 00:00:00','2007-10-23 00:00:00',3,21.74,'Ship to 4-A','Brook Farm Stratford St. Mary 0123','Colchester','Essex','10238','UK'),(10708,77,6,'2007-10-17 00:00:00','2007-11-28 00:00:00','2007-11-05 00:00:00',2,2.96,'Ship to 77-C','3456 Jefferson Way Suite 2','Portland','OR','10322','USA'),(10709,31,1,'2007-10-17 00:00:00','2007-11-14 00:00:00','2007-11-20 00:00:00',3,210.80,'Destination GWPFK','Av. Brasil, 0123','Campinas','SP','10188','Brazil'),(10710,27,1,'2007-10-20 00:00:00','2007-11-17 00:00:00','2007-10-23 00:00:00',1,4.98,'Destination FFLQT','Via Monte Bianco 6789','Torino',NULL,'10174','Italy'),(10711,71,5,'2007-10-21 00:00:00','2007-12-02 00:00:00','2007-10-29 00:00:00',2,52.41,'Ship to 71-A','7890 Suffolk Ln.','Boise','Id','10305','USA'),(10712,37,3,'2007-10-21 00:00:00','2007-11-18 00:00:00','2007-10-31 00:00:00',1,89.93,'Destination KPVYJ','5678 Johnstown Road','Cork','Co. Cork','10203','Ireland'),(10713,71,1,'2007-10-22 00:00:00','2007-11-19 00:00:00','2007-10-24 00:00:00',1,167.05,'Ship to 71-C','9012 Suffolk Ln.','Boise','Id','10307','USA'),(10714,71,5,'2007-10-22 00:00:00','2007-11-19 00:00:00','2007-10-27 00:00:00',3,24.49,'Ship to 71-A','7890 Suffolk Ln.','Boise','Id','10305','USA'),(10715,9,3,'2007-10-23 00:00:00','2007-11-06 00:00:00','2007-10-29 00:00:00',1,63.20,'Ship to 9-B','9012, rue des Bouchers','Marseille',NULL,'10368','France'),(10716,64,4,'2007-10-24 00:00:00','2007-11-21 00:00:00','2007-10-27 00:00:00',2,22.57,'Ship to 64-B','Av. del Libertador 5678','Buenos Aires',NULL,'10283','Argentina'),(10717,25,1,'2007-10-24 00:00:00','2007-11-21 00:00:00','2007-10-29 00:00:00',2,59.25,'Destination QOCBL','Berliner Platz 1234','München',NULL,'10169','Germany'),(10718,39,1,'2007-10-27 00:00:00','2007-11-24 00:00:00','2007-10-29 00:00:00',3,170.88,'Destination DKMQA','Maubelstr. 0123','Brandenburg',NULL,'10208','Germany'),(10719,45,8,'2007-10-27 00:00:00','2007-11-24 00:00:00','2007-11-05 00:00:00',2,51.44,'Ship to 45-A','8901 Polk St. Suite 5','San Francisco','CA','10225','USA'),(10720,61,8,'2007-10-28 00:00:00','2007-11-11 00:00:00','2007-11-05 00:00:00',2,9.53,'Ship to 61-C','Rua da Panificadora, 7890','Rio de Janeiro','RJ','10275','Brazil'),(10721,63,5,'2007-10-29 00:00:00','2007-11-26 00:00:00','2007-10-31 00:00:00',3,48.92,'Ship to 63-A','Taucherstraße 1234','Cunewalde',NULL,'10279','Germany'),(10722,71,8,'2007-10-29 00:00:00','2007-12-10 00:00:00','2007-11-04 00:00:00',1,74.58,'Ship to 71-A','7890 Suffolk Ln.','Boise','Id','10305','USA'),(10723,89,3,'2007-10-30 00:00:00','2007-11-27 00:00:00','2007-11-25 00:00:00',1,21.72,'Ship to 89-C','9012 - 12th Ave. S.','Seattle','WA','10358','USA'),(10724,51,8,'2007-10-30 00:00:00','2007-12-11 00:00:00','2007-11-05 00:00:00',2,57.75,'Ship to 51-A','6789 rue St. Laurent','Montréal','Québec','10244','Canada'),(10725,21,4,'2007-10-31 00:00:00','2007-11-28 00:00:00','2007-11-05 00:00:00',3,10.83,'Destination KKELL','Rua Orós, 4567','Sao Paulo','SP','10162','Brazil'),(10726,19,4,'2007-11-03 00:00:00','2007-11-17 00:00:00','2007-12-05 00:00:00',1,16.56,'Destination FRCGJ','5678 King George','London',NULL,'10153','UK'),(10727,66,2,'2007-11-03 00:00:00','2007-12-01 00:00:00','2007-12-05 00:00:00',1,89.90,'Ship to 66-A','Strada Provinciale 0123','Reggio Emilia',NULL,'10288','Italy'),(10728,62,4,'2007-11-04 00:00:00','2007-12-02 00:00:00','2007-11-11 00:00:00',2,58.33,'Ship to 62-A','Alameda dos Canàrios, 8901','Sao Paulo','SP','10276','Brazil'),(10729,47,8,'2007-11-04 00:00:00','2007-12-16 00:00:00','2007-11-14 00:00:00',3,141.06,'Ship to 47-A','Ave. 5 de Mayo Porlamar 3456','I. de Margarita','Nueva Esparta','10230','Venezuela'),(10730,9,5,'2007-11-05 00:00:00','2007-12-03 00:00:00','2007-11-14 00:00:00',1,20.12,'Ship to 9-A','8901, rue des Bouchers','Marseille',NULL,'10367','France'),(10731,14,7,'2007-11-06 00:00:00','2007-12-04 00:00:00','2007-11-14 00:00:00',1,96.65,'Destination YUJRD','Hauptstr. 1234','Bern',NULL,'10139','Switzerland'),(10732,9,3,'2007-11-06 00:00:00','2007-12-04 00:00:00','2007-11-07 00:00:00',1,16.97,'Ship to 9-A','8901, rue des Bouchers','Marseille',NULL,'10367','France'),(10733,5,1,'2007-11-07 00:00:00','2007-12-05 00:00:00','2007-11-10 00:00:00',3,110.11,'Ship to 5-A','Berguvsvägen 9012','Luleå',NULL,'10267','Sweden'),(10734,31,2,'2007-11-07 00:00:00','2007-12-05 00:00:00','2007-11-12 00:00:00',3,1.63,'Destination VNIAG','Av. Brasil, 9012','Campinas','SP','10187','Brazil'),(10735,45,6,'2007-11-10 00:00:00','2007-12-08 00:00:00','2007-11-21 00:00:00',2,45.97,'Ship to 45-A','8901 Polk St. Suite 5','San Francisco','CA','10225','USA'),(10736,37,9,'2007-11-11 00:00:00','2007-12-09 00:00:00','2007-11-21 00:00:00',2,44.10,'Destination DGKOU','6789 Johnstown Road','Cork','Co. Cork','10204','Ireland'),(10737,85,2,'2007-11-11 00:00:00','2007-12-09 00:00:00','2007-11-18 00:00:00',2,7.79,'Ship to 85-C','7890 rue de l\'Abbaye','Reims',NULL,'10346','France'),(10738,74,2,'2007-11-12 00:00:00','2007-12-10 00:00:00','2007-11-18 00:00:00',1,2.91,'Ship to 74-A','3456, rue Lauriston','Paris',NULL,'10312','France'),(10739,85,3,'2007-11-12 00:00:00','2007-12-10 00:00:00','2007-11-17 00:00:00',3,11.08,'Ship to 85-C','7890 rue de l\'Abbaye','Reims',NULL,'10346','France'),(10740,89,4,'2007-11-13 00:00:00','2007-12-11 00:00:00','2007-11-25 00:00:00',2,81.88,'Ship to 89-B','8901 - 12th Ave. S.','Seattle','WA','10357','USA'),(10741,4,4,'2007-11-14 00:00:00','2007-11-28 00:00:00','2007-11-18 00:00:00',3,10.96,'Ship to 4-C','Brook Farm Stratford St. Mary 2345','Colchester','Essex','10240','UK'),(10742,10,3,'2007-11-14 00:00:00','2007-12-12 00:00:00','2007-11-18 00:00:00',3,243.73,'Destination LPHSI','3456 Tsawassen Blvd.','Tsawassen','BC','10131','Canada'),(10743,4,1,'2007-11-17 00:00:00','2007-12-15 00:00:00','2007-11-21 00:00:00',2,23.72,'Ship to 4-C','Brook Farm Stratford St. Mary 2345','Colchester','Essex','10240','UK'),(10744,83,6,'2007-11-17 00:00:00','2007-12-15 00:00:00','2007-11-24 00:00:00',1,69.19,'Ship to 83-A','Smagsloget 0123','Århus',NULL,'10339','Denmark'),(10745,63,9,'2007-11-18 00:00:00','2007-12-16 00:00:00','2007-11-27 00:00:00',1,3.52,'Ship to 63-C','Taucherstraße 3456','Cunewalde',NULL,'10281','Germany'),(10746,14,1,'2007-11-19 00:00:00','2007-12-17 00:00:00','2007-11-21 00:00:00',3,31.43,'Destination NRTZZ','Hauptstr. 0123','Bern',NULL,'10138','Switzerland'),(10747,59,6,'2007-11-19 00:00:00','2007-12-17 00:00:00','2007-11-26 00:00:00',1,117.33,'Ship to 59-B','Geislweg 7890','Salzburg',NULL,'10265','Austria'),(10748,71,3,'2007-11-20 00:00:00','2007-12-18 00:00:00','2007-11-28 00:00:00',1,232.55,'Ship to 71-B','8901 Suffolk Ln.','Boise','Id','10306','USA'),(10749,38,4,'2007-11-20 00:00:00','2007-12-18 00:00:00','2007-12-19 00:00:00',2,61.53,'Destination QVTLW','Garden House Crowther Way 7890','Cowes','Isle of Wight','10205','UK'),(10750,87,9,'2007-11-21 00:00:00','2007-12-19 00:00:00','2007-11-24 00:00:00',1,79.30,'Ship to 87-C','Torikatu 3456','Oulu',NULL,'10352','Finland'),(10751,68,3,'2007-11-24 00:00:00','2007-12-22 00:00:00','2007-12-03 00:00:00',3,130.79,'Ship to 68-A','Starenweg 6789','Genève',NULL,'10294','Switzerland'),(10752,53,2,'2007-11-24 00:00:00','2007-12-22 00:00:00','2007-11-28 00:00:00',3,1.39,'Ship to 53-C','South House 3456 Queensbridge','London',NULL,'10251','UK'),(10753,27,3,'2007-11-25 00:00:00','2007-12-23 00:00:00','2007-11-27 00:00:00',1,7.70,'Destination DICGM','Via Monte Bianco 7890','Torino',NULL,'10175','Italy'),(10754,49,6,'2007-11-25 00:00:00','2007-12-23 00:00:00','2007-11-27 00:00:00',3,2.38,'Ship to 49-B','Via Ludovico il Moro 9012','Bergamo',NULL,'10236','Italy'),(10755,9,4,'2007-11-26 00:00:00','2007-12-24 00:00:00','2007-11-28 00:00:00',2,16.71,'Ship to 9-C','0123, rue des Bouchers','Marseille',NULL,'10369','France'),(10756,75,8,'2007-11-27 00:00:00','2007-12-25 00:00:00','2007-12-02 00:00:00',2,73.21,'Ship to 75-C','P.O. Box 7890','Lander','WY','10316','USA'),(10757,71,6,'2007-11-27 00:00:00','2007-12-25 00:00:00','2007-12-15 00:00:00',1,8.19,'Ship to 71-B','8901 Suffolk Ln.','Boise','Id','10306','USA'),(10758,68,3,'2007-11-28 00:00:00','2007-12-26 00:00:00','2007-12-04 00:00:00',3,138.17,'Ship to 68-C','Starenweg 8901','Genève',NULL,'10296','Switzerland'),(10759,2,3,'2007-11-28 00:00:00','2007-12-26 00:00:00','2007-12-12 00:00:00',3,11.99,'Destination QOTQA','Avda. de la Constitución 3456','México D.F.',NULL,'10181','Mexico'),(10760,50,4,'2007-12-01 00:00:00','2007-12-29 00:00:00','2007-12-10 00:00:00',1,155.64,'Ship to 50-B','Rue Joseph-Bens 4567','Bruxelles',NULL,'10242','Belgium'),(10761,65,5,'2007-12-02 00:00:00','2007-12-30 00:00:00','2007-12-08 00:00:00',2,18.66,'Ship to 65-B','8901 Milton Dr.','Albuquerque','NM','10286','USA'),(10762,24,3,'2007-12-02 00:00:00','2007-12-30 00:00:00','2007-12-09 00:00:00',1,328.74,'Destination YCMPK','Åkergatan 8901','Bräcke',NULL,'10166','Sweden'),(10763,23,3,'2007-12-03 00:00:00','2007-12-31 00:00:00','2007-12-08 00:00:00',3,37.35,'Destination PXQRR','5678, chaussée de Tournai','Lille',NULL,'10163','France'),(10764,20,6,'2007-12-03 00:00:00','2007-12-31 00:00:00','2007-12-08 00:00:00',3,145.45,'Destination CUVPF','Kirchgasse 1234','Graz',NULL,'10159','Austria'),(10765,63,3,'2007-12-04 00:00:00','2008-01-01 00:00:00','2007-12-09 00:00:00',3,42.74,'Ship to 63-A','Taucherstraße 1234','Cunewalde',NULL,'10279','Germany'),(10766,56,4,'2007-12-05 00:00:00','2008-01-02 00:00:00','2007-12-09 00:00:00',1,157.55,'Ship to 56-C','Mehrheimerstr. 2345','Köln',NULL,'10260','Germany'),(10767,76,4,'2007-12-05 00:00:00','2008-01-02 00:00:00','2007-12-15 00:00:00',3,1.59,'Ship to 76-B','Boulevard Tirou, 9012','Charleroi',NULL,'10318','Belgium'),(10768,4,3,'2007-12-08 00:00:00','2008-01-05 00:00:00','2007-12-15 00:00:00',2,146.32,'Ship to 4-B','Brook Farm Stratford St. Mary 1234','Colchester','Essex','10239','UK'),(10769,83,3,'2007-12-08 00:00:00','2008-01-05 00:00:00','2007-12-12 00:00:00',1,65.06,'Ship to 83-C','Smagsloget 2345','Århus',NULL,'10341','Denmark'),(10770,34,8,'2007-12-09 00:00:00','2008-01-06 00:00:00','2007-12-17 00:00:00',3,5.32,'Destination JPAIY','Rua do Paço, 8901','Rio de Janeiro','RJ','10196','Brazil'),(10771,20,9,'2007-12-10 00:00:00','2008-01-07 00:00:00','2008-01-02 00:00:00',2,11.19,'Destination CUVPF','Kirchgasse 1234','Graz',NULL,'10159','Austria'),(10772,44,3,'2007-12-10 00:00:00','2008-01-07 00:00:00','2007-12-19 00:00:00',2,91.28,'Ship to 44-B','Magazinweg 5678','Frankfurt a.M.',NULL,'10223','Germany'),(10773,20,1,'2007-12-11 00:00:00','2008-01-08 00:00:00','2007-12-16 00:00:00',3,96.43,'Destination FFXKT','Kirchgasse 0123','Graz',NULL,'10158','Austria'),(10774,24,4,'2007-12-11 00:00:00','2007-12-25 00:00:00','2007-12-12 00:00:00',1,48.20,'Destination KBSBN','Åkergatan 9012','Bräcke',NULL,'10167','Sweden'),(10775,78,7,'2007-12-12 00:00:00','2008-01-09 00:00:00','2007-12-26 00:00:00',1,20.25,'Ship to 78-A','4567 Grizzly Peak Rd.','Butte','MT','10323','USA'),(10776,20,1,'2007-12-15 00:00:00','2008-01-12 00:00:00','2007-12-18 00:00:00',3,351.53,'Destination RVDMF','Kirchgasse 9012','Graz',NULL,'10157','Austria'),(10777,31,7,'2007-12-15 00:00:00','2007-12-29 00:00:00','2008-01-21 00:00:00',2,3.01,'Destination GWPFK','Av. Brasil, 0123','Campinas','SP','10188','Brazil'),(10778,5,3,'2007-12-16 00:00:00','2008-01-13 00:00:00','2007-12-24 00:00:00',1,6.79,'Ship to 5-A','Berguvsvägen 9012','Luleå',NULL,'10267','Sweden'),(10779,52,3,'2007-12-16 00:00:00','2008-01-13 00:00:00','2008-01-14 00:00:00',2,58.13,'Ship to 52-A','Heerstr. 9012','Leipzig',NULL,'10247','Germany'),(10780,46,2,'2007-12-16 00:00:00','2007-12-30 00:00:00','2007-12-25 00:00:00',1,42.13,'Ship to 46-C','Carrera 2345 con Ave. Bolívar #65-98 Llano Largo','Barquisimeto','Lara','10229','Venezuela'),(10781,87,2,'2007-12-17 00:00:00','2008-01-14 00:00:00','2007-12-19 00:00:00',3,73.16,'Ship to 87-A','Torikatu 1234','Oulu',NULL,'10350','Finland'),(10782,12,9,'2007-12-17 00:00:00','2008-01-14 00:00:00','2007-12-22 00:00:00',3,1.10,'Destination CJDJB','Cerrito 8901','Buenos Aires',NULL,'10136','Argentina'),(10783,34,4,'2007-12-18 00:00:00','2008-01-15 00:00:00','2007-12-19 00:00:00',2,124.98,'Destination DPCVR','Rua do Paço, 6789','Rio de Janeiro','RJ','10194','Brazil'),(10784,49,4,'2007-12-18 00:00:00','2008-01-15 00:00:00','2007-12-22 00:00:00',3,70.09,'Ship to 49-A','Via Ludovico il Moro 8901','Bergamo',NULL,'10235','Italy'),(10785,33,1,'2007-12-18 00:00:00','2008-01-15 00:00:00','2007-12-24 00:00:00',3,1.51,'Destination FQJFJ','5ª Ave. Los Palos Grandes 4567','Caracas','DF','10192','Venezuela'),(10786,62,8,'2007-12-19 00:00:00','2008-01-16 00:00:00','2007-12-23 00:00:00',1,110.87,'Ship to 62-B','Alameda dos Canàrios, 9012','Sao Paulo','SP','10277','Brazil'),(10787,41,2,'2007-12-19 00:00:00','2008-01-02 00:00:00','2007-12-26 00:00:00',1,249.93,'Destination DWJIO','9012 rue Alsace-Lorraine','Toulouse',NULL,'10217','France'),(10788,63,1,'2007-12-22 00:00:00','2008-01-19 00:00:00','2008-01-19 00:00:00',2,42.70,'Ship to 63-C','Taucherstraße 3456','Cunewalde',NULL,'10281','Germany'),(10789,23,1,'2007-12-22 00:00:00','2008-01-19 00:00:00','2007-12-31 00:00:00',2,100.60,'Destination PXQRR','5678, chaussée de Tournai','Lille',NULL,'10163','France'),(10790,31,6,'2007-12-22 00:00:00','2008-01-19 00:00:00','2007-12-26 00:00:00',1,28.23,'Destination XOIGC','Av. Brasil, 8901','Campinas','SP','10186','Brazil'),(10791,25,6,'2007-12-23 00:00:00','2008-01-20 00:00:00','2008-01-01 00:00:00',2,16.85,'Destination QOCBL','Berliner Platz 1234','München',NULL,'10169','Germany'),(10792,91,1,'2007-12-23 00:00:00','2008-01-20 00:00:00','2007-12-31 00:00:00',3,23.79,'Ship to 91-C','ul. Filtrowa 7890','Warszawa',NULL,'10366','Poland'),(10793,4,3,'2007-12-24 00:00:00','2008-01-21 00:00:00','2008-01-08 00:00:00',3,4.52,'Ship to 4-B','Brook Farm Stratford St. Mary 1234','Colchester','Essex','10239','UK'),(10794,61,6,'2007-12-24 00:00:00','2008-01-21 00:00:00','2008-01-02 00:00:00',1,21.49,'Ship to 61-C','Rua da Panificadora, 7890','Rio de Janeiro','RJ','10275','Brazil'),(10795,20,8,'2007-12-24 00:00:00','2008-01-21 00:00:00','2008-01-20 00:00:00',2,126.66,'Destination FFXKT','Kirchgasse 0123','Graz',NULL,'10158','Austria'),(10796,35,3,'2007-12-25 00:00:00','2008-01-22 00:00:00','2008-01-14 00:00:00',1,26.52,'Destination UOUWK','Carrera 9012 con Ave. Carlos Soublette #8-35','San Cristóbal','Táchira','10197','Venezuela'),(10797,17,7,'2007-12-25 00:00:00','2008-01-22 00:00:00','2008-01-05 00:00:00',2,33.35,'Destination AJTHX','Walserweg 9012','Aachen',NULL,'10147','Germany'),(10798,38,2,'2007-12-26 00:00:00','2008-01-23 00:00:00','2008-01-05 00:00:00',1,2.33,'Destination AXVHD','Garden House Crowther Way 9012','Cowes','Isle of Wight','10207','UK'),(10799,39,9,'2007-12-26 00:00:00','2008-02-06 00:00:00','2008-01-05 00:00:00',3,30.76,'Destination DKMQA','Maubelstr. 0123','Brandenburg',NULL,'10208','Germany'),(10800,72,1,'2007-12-26 00:00:00','2008-01-23 00:00:00','2008-01-05 00:00:00',3,137.44,'Ship to 72-C','1234 Wadhurst Rd.','London',NULL,'10309','UK'),(10801,8,4,'2007-12-29 00:00:00','2008-01-26 00:00:00','2007-12-31 00:00:00',2,97.09,'Ship to 8-C','C/ Araquil, 1234','Madrid',NULL,'10360','Spain'),(10802,73,4,'2007-12-29 00:00:00','2008-01-26 00:00:00','2008-01-02 00:00:00',2,257.26,'Ship to 73-A','Vinbæltet 1234','Kobenhavn',NULL,'10310','Denmark'),(10803,88,4,'2007-12-30 00:00:00','2008-01-27 00:00:00','2008-01-06 00:00:00',1,55.23,'Ship to 88-B','Rua do Mercado, 5678','Resende','SP','10354','Brazil'),(10804,72,6,'2007-12-30 00:00:00','2008-01-27 00:00:00','2008-01-07 00:00:00',2,27.33,'Ship to 72-C','1234 Wadhurst Rd.','London',NULL,'10309','UK'),(10805,77,2,'2007-12-30 00:00:00','2008-01-27 00:00:00','2008-01-09 00:00:00',3,237.34,'Ship to 77-A','1234 Jefferson Way Suite 2','Portland','OR','10320','USA'),(10806,84,3,'2007-12-31 00:00:00','2008-01-28 00:00:00','2008-01-05 00:00:00',2,22.11,'Ship to 84-C','5678, rue du Commerce','Lyon',NULL,'10344','France'),(10807,27,4,'2007-12-31 00:00:00','2008-01-28 00:00:00','2008-01-30 00:00:00',1,1.36,'Destination XNLFB','Via Monte Bianco 5678','Torino',NULL,'10173','Italy'),(10808,55,2,'2008-01-01 00:00:00','2008-01-29 00:00:00','2008-01-09 00:00:00',3,45.53,'Ship to 55-B','8901 Bering St.','Anchorage','AK','10256','USA'),(10809,88,7,'2008-01-01 00:00:00','2008-01-29 00:00:00','2008-01-07 00:00:00',1,4.87,'Ship to 88-C','Rua do Mercado, 6789','Resende','SP','10355','Brazil'),(10810,42,2,'2008-01-01 00:00:00','2008-01-29 00:00:00','2008-01-07 00:00:00',3,4.33,'Ship to 42-A','1234 Elm St.','Vancouver','BC','10219','Canada'),(10811,47,8,'2008-01-02 00:00:00','2008-01-30 00:00:00','2008-01-08 00:00:00',1,31.22,'Ship to 47-B','Ave. 5 de Mayo Porlamar 4567','I. de Margarita','Nueva Esparta','10231','Venezuela'),(10812,66,5,'2008-01-02 00:00:00','2008-01-30 00:00:00','2008-01-12 00:00:00',1,59.78,'Ship to 66-B','Strada Provinciale 1234','Reggio Emilia',NULL,'10289','Italy'),(10813,67,1,'2008-01-05 00:00:00','2008-02-02 00:00:00','2008-01-09 00:00:00',1,47.38,'Ship to 67-C','Av. Copacabana, 5678','Rio de Janeiro','RJ','10293','Brazil'),(10814,84,3,'2008-01-05 00:00:00','2008-02-02 00:00:00','2008-01-14 00:00:00',3,130.94,'Ship to 84-B','4567, rue du Commerce','Lyon',NULL,'10343','France'),(10815,71,2,'2008-01-05 00:00:00','2008-02-02 00:00:00','2008-01-14 00:00:00',3,14.62,'Ship to 71-A','7890 Suffolk Ln.','Boise','Id','10305','USA'),(10816,32,4,'2008-01-06 00:00:00','2008-02-03 00:00:00','2008-02-04 00:00:00',2,719.78,'Destination AVQUS','2345 Baker Blvd.','Eugene','OR','10190','USA'),(10817,39,3,'2008-01-06 00:00:00','2008-01-20 00:00:00','2008-01-13 00:00:00',2,306.07,'Destination RMBHM','Maubelstr. 1234','Brandenburg',NULL,'10209','Germany'),(10818,49,7,'2008-01-07 00:00:00','2008-02-04 00:00:00','2008-01-12 00:00:00',3,65.48,'Ship to 49-B','Via Ludovico il Moro 9012','Bergamo',NULL,'10236','Italy'),(10819,12,2,'2008-01-07 00:00:00','2008-02-04 00:00:00','2008-01-16 00:00:00',3,19.76,'Destination QTHBC','Cerrito 6789','Buenos Aires',NULL,'10134','Argentina'),(10820,65,3,'2008-01-07 00:00:00','2008-02-04 00:00:00','2008-01-13 00:00:00',2,37.52,'Ship to 65-B','8901 Milton Dr.','Albuquerque','NM','10286','USA'),(10821,75,1,'2008-01-08 00:00:00','2008-02-05 00:00:00','2008-01-15 00:00:00',1,36.68,'Ship to 75-A','P.O. Box 5678','Lander','WY','10314','USA'),(10822,82,6,'2008-01-08 00:00:00','2008-02-05 00:00:00','2008-01-16 00:00:00',3,7.00,'Ship to 82-B','9012 DaVinci Blvd.','Kirkland','WA','10338','USA'),(10823,46,5,'2008-01-09 00:00:00','2008-02-06 00:00:00','2008-01-13 00:00:00',2,163.97,'Ship to 46-A','Carrera 0123 con Ave. Bolívar #65-98 Llano Largo','Barquisimeto','Lara','10227','Venezuela'),(10824,24,8,'2008-01-09 00:00:00','2008-02-06 00:00:00','2008-01-30 00:00:00',1,1.23,'Destination NCKKO','Åkergatan 7890','Bräcke',NULL,'10165','Sweden'),(10825,17,1,'2008-01-09 00:00:00','2008-02-06 00:00:00','2008-01-14 00:00:00',1,79.25,'Destination BJCXA','Walserweg 7890','Aachen',NULL,'10145','Germany'),(10826,7,6,'2008-01-12 00:00:00','2008-02-09 00:00:00','2008-02-06 00:00:00',1,7.09,'Ship to 7-C','2345, place Kléber','Strasbourg',NULL,'10331','France'),(10827,9,1,'2008-01-12 00:00:00','2008-01-26 00:00:00','2008-02-06 00:00:00',2,63.54,'Ship to 9-B','9012, rue des Bouchers','Marseille',NULL,'10368','France'),(10828,64,9,'2008-01-13 00:00:00','2008-01-27 00:00:00','2008-02-04 00:00:00',1,90.85,'Ship to 64-B','Av. del Libertador 5678','Buenos Aires',NULL,'10283','Argentina'),(10829,38,9,'2008-01-13 00:00:00','2008-02-10 00:00:00','2008-01-23 00:00:00',1,154.72,'Destination QVTLW','Garden House Crowther Way 7890','Cowes','Isle of Wight','10205','UK'),(10830,81,4,'2008-01-13 00:00:00','2008-02-24 00:00:00','2008-01-21 00:00:00',2,81.83,'Ship to 81-C','Av. Inês de Castro, 7890','Sao Paulo','SP','10336','Brazil'),(10831,70,3,'2008-01-14 00:00:00','2008-02-11 00:00:00','2008-01-23 00:00:00',2,72.19,'Ship to 70-B','Erling Skakkes gate 5678','Stavern',NULL,'10303','Norway'),(10832,41,2,'2008-01-14 00:00:00','2008-02-11 00:00:00','2008-01-19 00:00:00',2,43.26,'Ship to 41-C','0123 rue Alsace-Lorraine','Toulouse',NULL,'10218','France'),(10833,56,6,'2008-01-15 00:00:00','2008-02-12 00:00:00','2008-01-23 00:00:00',2,71.49,'Ship to 56-B','Mehrheimerstr. 1234','Köln',NULL,'10259','Germany'),(10834,81,1,'2008-01-15 00:00:00','2008-02-12 00:00:00','2008-01-19 00:00:00',3,29.78,'Ship to 81-A','Av. Inês de Castro, 6789','Sao Paulo','SP','10335','Brazil'),(10835,1,1,'2008-01-15 00:00:00','2008-02-12 00:00:00','2008-01-21 00:00:00',3,69.53,'Destination LOUIE','Obere Str. 6789','Berlin',NULL,'10154','Germany'),(10836,20,7,'2008-01-16 00:00:00','2008-02-13 00:00:00','2008-01-21 00:00:00',1,411.88,'Destination CUVPF','Kirchgasse 1234','Graz',NULL,'10159','Austria'),(10837,5,9,'2008-01-16 00:00:00','2008-02-13 00:00:00','2008-01-23 00:00:00',3,13.32,'Ship to 5-A','Berguvsvägen 9012','Luleå',NULL,'10267','Sweden'),(10838,47,3,'2008-01-19 00:00:00','2008-02-16 00:00:00','2008-01-23 00:00:00',3,59.28,'Ship to 47-A','Ave. 5 de Mayo Porlamar 3456','I. de Margarita','Nueva Esparta','10230','Venezuela'),(10839,81,3,'2008-01-19 00:00:00','2008-02-16 00:00:00','2008-01-22 00:00:00',3,35.43,'Ship to 81-C','Av. Inês de Castro, 7890','Sao Paulo','SP','10336','Brazil'),(10840,47,4,'2008-01-19 00:00:00','2008-03-02 00:00:00','2008-02-16 00:00:00',2,2.71,'Ship to 47-A','Ave. 5 de Mayo Porlamar 3456','I. de Margarita','Nueva Esparta','10230','Venezuela'),(10841,76,5,'2008-01-20 00:00:00','2008-02-17 00:00:00','2008-01-29 00:00:00',2,424.30,'Ship to 76-B','Boulevard Tirou, 9012','Charleroi',NULL,'10318','Belgium'),(10842,80,1,'2008-01-20 00:00:00','2008-02-17 00:00:00','2008-01-29 00:00:00',3,54.42,'Ship to 80-A','Avda. Azteca 3456','México D.F.',NULL,'10332','Mexico'),(10843,84,4,'2008-01-21 00:00:00','2008-02-18 00:00:00','2008-01-26 00:00:00',2,9.26,'Ship to 84-C','5678, rue du Commerce','Lyon',NULL,'10344','France'),(10844,59,8,'2008-01-21 00:00:00','2008-02-18 00:00:00','2008-01-26 00:00:00',2,25.22,'Ship to 59-A','Geislweg 6789','Salzburg',NULL,'10264','Austria'),(10845,63,8,'2008-01-21 00:00:00','2008-02-04 00:00:00','2008-01-30 00:00:00',1,212.98,'Ship to 63-A','Taucherstraße 1234','Cunewalde',NULL,'10279','Germany'),(10846,76,2,'2008-01-22 00:00:00','2008-03-05 00:00:00','2008-01-23 00:00:00',3,56.46,'Ship to 76-C','Boulevard Tirou, 0123','Charleroi',NULL,'10319','Belgium'),(10847,71,4,'2008-01-22 00:00:00','2008-02-05 00:00:00','2008-02-10 00:00:00',3,487.57,'Ship to 71-A','7890 Suffolk Ln.','Boise','Id','10305','USA'),(10848,16,7,'2008-01-23 00:00:00','2008-02-20 00:00:00','2008-01-29 00:00:00',2,38.24,'Destination QKQNB','Berkeley Gardens 5678 Brewery','London',NULL,'10143','UK'),(10849,39,9,'2008-01-23 00:00:00','2008-02-20 00:00:00','2008-01-30 00:00:00',2,0.56,'Destination DKMQA','Maubelstr. 0123','Brandenburg',NULL,'10208','Germany'),(10850,84,1,'2008-01-23 00:00:00','2008-03-06 00:00:00','2008-01-30 00:00:00',1,49.19,'Ship to 84-C','5678, rue du Commerce','Lyon',NULL,'10344','France'),(10851,67,5,'2008-01-26 00:00:00','2008-02-23 00:00:00','2008-02-02 00:00:00',1,160.55,'Ship to 67-C','Av. Copacabana, 5678','Rio de Janeiro','RJ','10293','Brazil'),(10852,65,8,'2008-01-26 00:00:00','2008-02-09 00:00:00','2008-01-30 00:00:00',1,174.05,'Ship to 65-A','7890 Milton Dr.','Albuquerque','NM','10285','USA'),(10853,6,9,'2008-01-27 00:00:00','2008-02-24 00:00:00','2008-02-03 00:00:00',2,53.83,'Ship to 6-B','Forsterstr. 3456','Mannheim',NULL,'10301','Germany'),(10854,20,3,'2008-01-27 00:00:00','2008-02-24 00:00:00','2008-02-05 00:00:00',2,100.22,'Destination CUVPF','Kirchgasse 1234','Graz',NULL,'10159','Austria'),(10855,55,3,'2008-01-27 00:00:00','2008-02-24 00:00:00','2008-02-04 00:00:00',1,170.97,'Ship to 55-A','7890 Bering St.','Anchorage','AK','10255','USA'),(10856,3,3,'2008-01-28 00:00:00','2008-02-25 00:00:00','2008-02-10 00:00:00',2,58.43,'Destination FQFLS','Mataderos 3456','México D.F.',NULL,'10211','Mexico'),(10857,5,8,'2008-01-28 00:00:00','2008-02-25 00:00:00','2008-02-06 00:00:00',2,188.85,'Ship to 5-B','Berguvsvägen 0123','Luleå',NULL,'10268','Sweden'),(10858,40,2,'2008-01-29 00:00:00','2008-02-26 00:00:00','2008-02-03 00:00:00',1,52.51,'Destination POAEW','7890, avenue de l\'Europe','Versailles',NULL,'10215','France'),(10859,25,1,'2008-01-29 00:00:00','2008-02-26 00:00:00','2008-02-02 00:00:00',2,76.10,'Destination QOCBL','Berliner Platz 1234','München',NULL,'10169','Germany'),(10860,26,3,'2008-01-29 00:00:00','2008-02-26 00:00:00','2008-02-04 00:00:00',3,19.26,'Destination XBVKN','3456, rue Royale','Nantes',NULL,'10171','France'),(10861,89,4,'2008-01-30 00:00:00','2008-02-27 00:00:00','2008-02-17 00:00:00',2,14.93,'Ship to 89-C','9012 - 12th Ave. S.','Seattle','WA','10358','USA'),(10862,44,8,'2008-01-30 00:00:00','2008-03-13 00:00:00','2008-02-02 00:00:00',2,53.23,'Ship to 44-C','Magazinweg 6789','Frankfurt a.M.',NULL,'10224','Germany'),(10863,35,4,'2008-02-02 00:00:00','2008-03-02 00:00:00','2008-02-17 00:00:00',2,30.26,'Destination UOUWK','Carrera 9012 con Ave. Carlos Soublette #8-35','San Cristóbal','Táchira','10197','Venezuela'),(10864,4,4,'2008-02-02 00:00:00','2008-03-02 00:00:00','2008-02-09 00:00:00',2,3.04,'Ship to 4-C','Brook Farm Stratford St. Mary 2345','Colchester','Essex','10240','UK'),(10865,63,2,'2008-02-02 00:00:00','2008-02-16 00:00:00','2008-02-12 00:00:00',1,348.14,'Ship to 63-A','Taucherstraße 1234','Cunewalde',NULL,'10279','Germany'),(10866,5,5,'2008-02-03 00:00:00','2008-03-03 00:00:00','2008-02-12 00:00:00',1,109.11,'Ship to 5-B','Berguvsvägen 0123','Luleå',NULL,'10268','Sweden'),(10867,48,6,'2008-02-03 00:00:00','2008-03-17 00:00:00','2008-02-11 00:00:00',1,1.93,'Ship to 48-B','6789 Chiaroscuro Rd.','Portland','OR','10233','USA'),(10868,62,7,'2008-02-04 00:00:00','2008-03-04 00:00:00','2008-02-23 00:00:00',2,191.27,'Ship to 62-C','Alameda dos Canàrios, 0123','Sao Paulo','SP','10278','Brazil'),(10869,72,5,'2008-02-04 00:00:00','2008-03-04 00:00:00','2008-02-09 00:00:00',1,143.28,'Ship to 72-A','0123 Wadhurst Rd.','London',NULL,'10308','UK'),(10870,91,5,'2008-02-04 00:00:00','2008-03-04 00:00:00','2008-02-13 00:00:00',3,12.04,'Ship to 91-A','ul. Filtrowa 5678','Warszawa',NULL,'10364','Poland'),(10871,9,9,'2008-02-05 00:00:00','2008-03-05 00:00:00','2008-02-10 00:00:00',2,112.27,'Ship to 9-B','9012, rue des Bouchers','Marseille',NULL,'10368','France'),(10872,30,5,'2008-02-05 00:00:00','2008-03-05 00:00:00','2008-02-09 00:00:00',2,175.32,'Destination GGQIR','C/ Romero, 6789','Sevilla',NULL,'10184','Spain'),(10873,90,4,'2008-02-06 00:00:00','2008-03-06 00:00:00','2008-02-09 00:00:00',1,0.82,'Ship to 90-B','Keskuskatu 3456','Helsinki',NULL,'10362','Finland'),(10874,30,5,'2008-02-06 00:00:00','2008-03-06 00:00:00','2008-02-11 00:00:00',2,19.58,'Destination IIYDD','C/ Romero, 5678','Sevilla',NULL,'10183','Spain'),(10875,5,4,'2008-02-06 00:00:00','2008-03-06 00:00:00','2008-03-03 00:00:00',2,32.37,'Ship to 5-A','Berguvsvägen 9012','Luleå',NULL,'10267','Sweden'),(10876,9,7,'2008-02-09 00:00:00','2008-03-09 00:00:00','2008-02-12 00:00:00',3,60.42,'Ship to 9-A','8901, rue des Bouchers','Marseille',NULL,'10367','France'),(10877,67,1,'2008-02-09 00:00:00','2008-03-09 00:00:00','2008-02-19 00:00:00',1,38.06,'Ship to 67-B','Av. Copacabana, 4567','Rio de Janeiro','RJ','10292','Brazil'),(10878,63,4,'2008-02-10 00:00:00','2008-03-10 00:00:00','2008-02-12 00:00:00',1,46.69,'Ship to 63-B','Taucherstraße 2345','Cunewalde',NULL,'10280','Germany'),(10879,90,3,'2008-02-10 00:00:00','2008-03-10 00:00:00','2008-02-12 00:00:00',3,8.50,'Ship to 90-A','Keskuskatu 2345','Helsinki',NULL,'10361','Finland'),(10880,24,7,'2008-02-10 00:00:00','2008-03-24 00:00:00','2008-02-18 00:00:00',1,88.01,'Destination KBSBN','Åkergatan 9012','Bräcke',NULL,'10167','Sweden'),(10881,12,4,'2008-02-11 00:00:00','2008-03-11 00:00:00','2008-02-18 00:00:00',1,2.84,'Destination IGLOB','Cerrito 7890','Buenos Aires',NULL,'10135','Argentina'),(10882,71,4,'2008-02-11 00:00:00','2008-03-11 00:00:00','2008-02-20 00:00:00',3,23.10,'Ship to 71-B','8901 Suffolk Ln.','Boise','Id','10306','USA'),(10883,48,8,'2008-02-12 00:00:00','2008-03-12 00:00:00','2008-02-20 00:00:00',3,0.53,'Ship to 48-C','7890 Chiaroscuro Rd.','Portland','OR','10234','USA'),(10884,45,4,'2008-02-12 00:00:00','2008-03-12 00:00:00','2008-02-13 00:00:00',2,90.97,'Ship to 45-C','9012 Polk St. Suite 5','San Francisco','CA','10226','USA'),(10885,76,6,'2008-02-12 00:00:00','2008-03-12 00:00:00','2008-02-18 00:00:00',3,5.64,'Ship to 76-B','Boulevard Tirou, 9012','Charleroi',NULL,'10318','Belgium'),(10886,34,1,'2008-02-13 00:00:00','2008-03-13 00:00:00','2008-03-02 00:00:00',1,4.99,'Destination SCQXA','Rua do Paço, 7890','Rio de Janeiro','RJ','10195','Brazil'),(10887,29,8,'2008-02-13 00:00:00','2008-03-13 00:00:00','2008-02-16 00:00:00',3,1.25,'Destination VPNNG','Rambla de Cataluña, 0123','Barcelona',NULL,'10178','Spain'),(10888,30,1,'2008-02-16 00:00:00','2008-03-16 00:00:00','2008-02-23 00:00:00',2,51.87,'Destination IIYDD','C/ Romero, 5678','Sevilla',NULL,'10183','Spain'),(10889,65,9,'2008-02-16 00:00:00','2008-03-16 00:00:00','2008-02-23 00:00:00',3,280.61,'Ship to 65-C','9012 Milton Dr.','Albuquerque','NM','10287','USA'),(10890,18,7,'2008-02-16 00:00:00','2008-03-16 00:00:00','2008-02-18 00:00:00',1,32.76,'Destination JNSYI','1234, rue des Cinquante Otages','Nantes',NULL,'10149','France'),(10891,44,7,'2008-02-17 00:00:00','2008-03-17 00:00:00','2008-02-19 00:00:00',2,20.37,'Ship to 44-A','Magazinweg 4567','Frankfurt a.M.',NULL,'10222','Germany'),(10892,50,4,'2008-02-17 00:00:00','2008-03-17 00:00:00','2008-02-19 00:00:00',2,120.27,'Ship to 50-A','Rue Joseph-Bens 3456','Bruxelles',NULL,'10241','Belgium'),(10893,39,9,'2008-02-18 00:00:00','2008-03-18 00:00:00','2008-02-20 00:00:00',2,77.78,'Destination RMBHM','Maubelstr. 1234','Brandenburg',NULL,'10209','Germany'),(10894,71,1,'2008-02-18 00:00:00','2008-03-18 00:00:00','2008-02-20 00:00:00',1,116.13,'Ship to 71-A','7890 Suffolk Ln.','Boise','Id','10305','USA'),(10895,20,3,'2008-02-18 00:00:00','2008-03-18 00:00:00','2008-02-23 00:00:00',1,162.75,'Destination CUVPF','Kirchgasse 1234','Graz',NULL,'10159','Austria'),(10896,50,7,'2008-02-19 00:00:00','2008-03-19 00:00:00','2008-02-27 00:00:00',3,32.45,'Ship to 50-A','Rue Joseph-Bens 3456','Bruxelles',NULL,'10241','Belgium'),(10897,37,3,'2008-02-19 00:00:00','2008-03-19 00:00:00','2008-02-25 00:00:00',2,603.54,'Destination DGKOU','6789 Johnstown Road','Cork','Co. Cork','10204','Ireland'),(10898,54,4,'2008-02-20 00:00:00','2008-03-20 00:00:00','2008-03-06 00:00:00',2,1.27,'Ship to 54-B','Ing. Gustavo Moncada 5678 Piso 20-A','Buenos Aires',NULL,'10253','Argentina'),(10899,46,5,'2008-02-20 00:00:00','2008-03-20 00:00:00','2008-02-26 00:00:00',3,1.21,'Ship to 46-C','Carrera 2345 con Ave. Bolívar #65-98 Llano Largo','Barquisimeto','Lara','10229','Venezuela'),(10900,88,1,'2008-02-20 00:00:00','2008-03-20 00:00:00','2008-03-04 00:00:00',2,1.66,'Ship to 88-A','Rua do Mercado, 4567','Resende','SP','10353','Brazil'),(10901,35,4,'2008-02-23 00:00:00','2008-03-23 00:00:00','2008-02-26 00:00:00',1,62.09,'Destination UOUWK','Carrera 9012 con Ave. Carlos Soublette #8-35','San Cristóbal','Táchira','10197','Venezuela'),(10902,24,1,'2008-02-23 00:00:00','2008-03-23 00:00:00','2008-03-03 00:00:00',1,44.15,'Destination NCKKO','Åkergatan 7890','Bräcke',NULL,'10165','Sweden'),(10903,34,3,'2008-02-24 00:00:00','2008-03-24 00:00:00','2008-03-04 00:00:00',3,36.71,'Destination DPCVR','Rua do Paço, 6789','Rio de Janeiro','RJ','10194','Brazil'),(10904,89,3,'2008-02-24 00:00:00','2008-03-24 00:00:00','2008-02-27 00:00:00',3,162.95,'Ship to 89-A','7890 - 12th Ave. S.','Seattle','WA','10356','USA'),(10905,88,9,'2008-02-24 00:00:00','2008-03-24 00:00:00','2008-03-06 00:00:00',2,13.72,'Ship to 88-A','Rua do Mercado, 4567','Resende','SP','10353','Brazil'),(10906,91,4,'2008-02-25 00:00:00','2008-03-11 00:00:00','2008-03-03 00:00:00',3,26.29,'Ship to 91-B','ul. Filtrowa 6789','Warszawa',NULL,'10365','Poland'),(10907,74,6,'2008-02-25 00:00:00','2008-03-25 00:00:00','2008-02-27 00:00:00',3,9.19,'Ship to 74-B','4567, rue Lauriston','Paris',NULL,'10313','France'),(10908,66,4,'2008-02-26 00:00:00','2008-03-26 00:00:00','2008-03-06 00:00:00',2,32.96,'Ship to 66-B','Strada Provinciale 1234','Reggio Emilia',NULL,'10289','Italy'),(10909,70,1,'2008-02-26 00:00:00','2008-03-26 00:00:00','2008-03-10 00:00:00',2,53.05,'Ship to 70-C','Erling Skakkes gate 6789','Stavern',NULL,'10304','Norway'),(10910,90,1,'2008-02-26 00:00:00','2008-03-26 00:00:00','2008-03-04 00:00:00',3,38.11,'Ship to 90-A','Keskuskatu 2345','Helsinki',NULL,'10361','Finland'),(10911,30,3,'2008-02-26 00:00:00','2008-03-26 00:00:00','2008-03-05 00:00:00',1,38.19,'Destination IIYDD','C/ Romero, 5678','Sevilla',NULL,'10183','Spain'),(10912,37,2,'2008-02-26 00:00:00','2008-03-26 00:00:00','2008-03-18 00:00:00',2,580.91,'Destination DGKOU','6789 Johnstown Road','Cork','Co. Cork','10204','Ireland'),(10913,62,4,'2008-02-26 00:00:00','2008-03-26 00:00:00','2008-03-04 00:00:00',1,33.05,'Ship to 62-A','Alameda dos Canàrios, 8901','Sao Paulo','SP','10276','Brazil'),(10914,62,6,'2008-02-27 00:00:00','2008-03-27 00:00:00','2008-03-02 00:00:00',1,21.19,'Ship to 62-B','Alameda dos Canàrios, 9012','Sao Paulo','SP','10277','Brazil'),(10915,80,2,'2008-02-27 00:00:00','2008-03-27 00:00:00','2008-03-02 00:00:00',2,3.51,'Ship to 80-C','Avda. Azteca 5678','México D.F.',NULL,'10334','Mexico'),(10916,64,1,'2008-02-27 00:00:00','2008-03-27 00:00:00','2008-03-09 00:00:00',2,63.77,'Ship to 64-C','Av. del Libertador 6789','Buenos Aires',NULL,'10284','Argentina'),(10917,69,4,'2008-03-02 00:00:00','2008-03-30 00:00:00','2008-03-11 00:00:00',2,8.29,'Ship to 69-C','Gran Vía, 1234','Madrid',NULL,'10299','Spain'),(10918,10,3,'2008-03-02 00:00:00','2008-03-30 00:00:00','2008-03-11 00:00:00',3,48.83,'Destination OLSSJ','2345 Tsawassen Blvd.','Tsawassen','BC','10130','Canada'),(10919,47,2,'2008-03-02 00:00:00','2008-03-30 00:00:00','2008-03-04 00:00:00',2,19.80,'Ship to 47-B','Ave. 5 de Mayo Porlamar 4567','I. de Margarita','Nueva Esparta','10231','Venezuela'),(10920,4,4,'2008-03-03 00:00:00','2008-03-31 00:00:00','2008-03-09 00:00:00',2,29.61,'Ship to 4-A','Brook Farm Stratford St. Mary 0123','Colchester','Essex','10238','UK'),(10921,83,1,'2008-03-03 00:00:00','2008-04-14 00:00:00','2008-03-09 00:00:00',1,176.48,'Ship to 83-A','Smagsloget 0123','Århus',NULL,'10339','Denmark'),(10922,34,5,'2008-03-03 00:00:00','2008-03-31 00:00:00','2008-03-05 00:00:00',3,62.74,'Destination DPCVR','Rua do Paço, 6789','Rio de Janeiro','RJ','10194','Brazil'),(10923,41,7,'2008-03-03 00:00:00','2008-04-14 00:00:00','2008-03-13 00:00:00',3,68.26,'Destination OLJND','8901 rue Alsace-Lorraine','Toulouse',NULL,'10216','France'),(10924,5,3,'2008-03-04 00:00:00','2008-04-01 00:00:00','2008-04-08 00:00:00',2,151.52,'Ship to 5-A','Berguvsvägen 9012','Luleå',NULL,'10267','Sweden'),(10925,34,3,'2008-03-04 00:00:00','2008-04-01 00:00:00','2008-03-13 00:00:00',1,2.27,'Destination JPAIY','Rua do Paço, 8901','Rio de Janeiro','RJ','10196','Brazil'),(10926,2,4,'2008-03-04 00:00:00','2008-04-01 00:00:00','2008-03-11 00:00:00',3,39.92,'Destination RAIGI','Avda. de la Constitución 4567','México D.F.',NULL,'10182','Mexico'),(10927,40,4,'2008-03-05 00:00:00','2008-04-02 00:00:00','2008-04-08 00:00:00',1,19.79,'Destination WWJLO','6789, avenue de l\'Europe','Versailles',NULL,'10214','France'),(10928,29,1,'2008-03-05 00:00:00','2008-04-02 00:00:00','2008-03-18 00:00:00',1,1.36,'Destination WOFLH','Rambla de Cataluña, 1234','Barcelona',NULL,'10179','Spain'),(10929,25,6,'2008-03-05 00:00:00','2008-04-02 00:00:00','2008-03-12 00:00:00',1,33.93,'Destination QOCBL','Berliner Platz 1234','München',NULL,'10169','Germany'),(10930,76,4,'2008-03-06 00:00:00','2008-04-17 00:00:00','2008-03-18 00:00:00',3,15.55,'Ship to 76-A','Boulevard Tirou, 8901','Charleroi',NULL,'10317','Belgium'),(10931,68,4,'2008-03-06 00:00:00','2008-03-20 00:00:00','2008-03-19 00:00:00',2,13.60,'Ship to 68-B','Starenweg 7890','Genève',NULL,'10295','Switzerland'),(10932,9,8,'2008-03-06 00:00:00','2008-04-03 00:00:00','2008-03-24 00:00:00',1,134.64,'Ship to 9-B','9012, rue des Bouchers','Marseille',NULL,'10368','France'),(10933,38,6,'2008-03-06 00:00:00','2008-04-03 00:00:00','2008-03-16 00:00:00',3,54.15,'Destination QVTLW','Garden House Crowther Way 7890','Cowes','Isle of Wight','10205','UK'),(10934,44,3,'2008-03-09 00:00:00','2008-04-06 00:00:00','2008-03-12 00:00:00',3,32.01,'Ship to 44-C','Magazinweg 6789','Frankfurt a.M.',NULL,'10224','Germany'),(10935,88,4,'2008-03-09 00:00:00','2008-04-06 00:00:00','2008-03-18 00:00:00',3,47.59,'Ship to 88-A','Rua do Mercado, 4567','Resende','SP','10353','Brazil'),(10936,32,3,'2008-03-09 00:00:00','2008-04-06 00:00:00','2008-03-18 00:00:00',2,33.68,'Destination AVQUS','2345 Baker Blvd.','Eugene','OR','10190','USA'),(10937,12,7,'2008-03-10 00:00:00','2008-03-24 00:00:00','2008-03-13 00:00:00',3,31.51,'Destination QTHBC','Cerrito 6789','Buenos Aires',NULL,'10134','Argentina'),(10938,63,3,'2008-03-10 00:00:00','2008-04-07 00:00:00','2008-03-16 00:00:00',2,31.89,'Ship to 63-C','Taucherstraße 3456','Cunewalde',NULL,'10281','Germany'),(10939,49,2,'2008-03-10 00:00:00','2008-04-07 00:00:00','2008-03-13 00:00:00',2,76.33,'Ship to 49-A','Via Ludovico il Moro 8901','Bergamo',NULL,'10235','Italy'),(10940,9,8,'2008-03-11 00:00:00','2008-04-08 00:00:00','2008-03-23 00:00:00',3,19.77,'Ship to 9-C','0123, rue des Bouchers','Marseille',NULL,'10369','France'),(10941,71,7,'2008-03-11 00:00:00','2008-04-08 00:00:00','2008-03-20 00:00:00',2,400.81,'Ship to 71-A','7890 Suffolk Ln.','Boise','Id','10305','USA'),(10942,66,9,'2008-03-11 00:00:00','2008-04-08 00:00:00','2008-03-18 00:00:00',3,17.95,'Ship to 66-C','Strada Provinciale 2345','Reggio Emilia',NULL,'10290','Italy'),(10943,11,4,'2008-03-11 00:00:00','2008-04-08 00:00:00','2008-03-19 00:00:00',2,2.17,'Destination NZASL','Fauntleroy Circus 5678','London',NULL,'10133','UK'),(10944,10,6,'2008-03-12 00:00:00','2008-03-26 00:00:00','2008-03-13 00:00:00',3,52.92,'Destination XJIBQ','1234 Tsawassen Blvd.','Tsawassen','BC','10129','Canada'),(10945,52,4,'2008-03-12 00:00:00','2008-04-09 00:00:00','2008-03-18 00:00:00',1,10.22,'Ship to 52-B','Heerstr. 0123','Leipzig',NULL,'10248','Germany'),(10946,83,1,'2008-03-12 00:00:00','2008-04-09 00:00:00','2008-03-19 00:00:00',2,27.20,'Ship to 83-B','Smagsloget 1234','Århus',NULL,'10340','Denmark'),(10947,11,3,'2008-03-13 00:00:00','2008-04-10 00:00:00','2008-03-16 00:00:00',2,3.26,'Destination NZASL','Fauntleroy Circus 5678','London',NULL,'10133','UK'),(10948,30,3,'2008-03-13 00:00:00','2008-04-10 00:00:00','2008-03-19 00:00:00',3,23.39,'Destination GGQIR','C/ Romero, 6789','Sevilla',NULL,'10184','Spain'),(10949,10,2,'2008-03-13 00:00:00','2008-04-10 00:00:00','2008-03-17 00:00:00',3,74.44,'Destination OLSSJ','2345 Tsawassen Blvd.','Tsawassen','BC','10130','Canada'),(10950,49,1,'2008-03-16 00:00:00','2008-04-13 00:00:00','2008-03-23 00:00:00',2,2.50,'Ship to 49-B','Via Ludovico il Moro 9012','Bergamo',NULL,'10236','Italy'),(10951,68,9,'2008-03-16 00:00:00','2008-04-27 00:00:00','2008-04-07 00:00:00',2,30.85,'Ship to 68-A','Starenweg 6789','Genève',NULL,'10294','Switzerland'),(10952,1,1,'2008-03-16 00:00:00','2008-04-27 00:00:00','2008-03-24 00:00:00',1,40.42,'Destination LOUIE','Obere Str. 6789','Berlin',NULL,'10154','Germany'),(10953,4,9,'2008-03-16 00:00:00','2008-03-30 00:00:00','2008-03-25 00:00:00',2,23.72,'Ship to 4-B','Brook Farm Stratford St. Mary 1234','Colchester','Essex','10239','UK'),(10954,47,5,'2008-03-17 00:00:00','2008-04-28 00:00:00','2008-03-20 00:00:00',1,27.91,'Ship to 47-B','Ave. 5 de Mayo Porlamar 4567','I. de Margarita','Nueva Esparta','10231','Venezuela'),(10955,24,8,'2008-03-17 00:00:00','2008-04-14 00:00:00','2008-03-20 00:00:00',2,3.26,'Destination YCMPK','Åkergatan 8901','Bräcke',NULL,'10166','Sweden'),(10956,6,6,'2008-03-17 00:00:00','2008-04-28 00:00:00','2008-03-20 00:00:00',2,44.65,'Ship to 6-B','Forsterstr. 3456','Mannheim',NULL,'10301','Germany'),(10957,35,8,'2008-03-18 00:00:00','2008-04-15 00:00:00','2008-03-27 00:00:00',3,105.36,'Destination UOUWK','Carrera 9012 con Ave. Carlos Soublette #8-35','San Cristóbal','Táchira','10197','Venezuela'),(10958,54,7,'2008-03-18 00:00:00','2008-04-15 00:00:00','2008-03-27 00:00:00',2,49.56,'Ship to 54-C','Ing. Gustavo Moncada 6789 Piso 20-A','Buenos Aires',NULL,'10254','Argentina'),(10959,31,6,'2008-03-18 00:00:00','2008-04-29 00:00:00','2008-03-23 00:00:00',2,4.98,'Destination GWPFK','Av. Brasil, 0123','Campinas','SP','10188','Brazil'),(10960,35,3,'2008-03-19 00:00:00','2008-04-02 00:00:00','2008-04-08 00:00:00',1,2.08,'Destination SXYQX','Carrera 0123 con Ave. Carlos Soublette #8-35','San Cristóbal','Táchira','10198','Venezuela'),(10961,62,8,'2008-03-19 00:00:00','2008-04-16 00:00:00','2008-03-30 00:00:00',1,104.47,'Ship to 62-A','Alameda dos Canàrios, 8901','Sao Paulo','SP','10276','Brazil'),(10962,63,8,'2008-03-19 00:00:00','2008-04-16 00:00:00','2008-03-23 00:00:00',2,275.79,'Ship to 63-B','Taucherstraße 2345','Cunewalde',NULL,'10280','Germany'),(10963,28,9,'2008-03-19 00:00:00','2008-04-16 00:00:00','2008-03-26 00:00:00',3,2.70,'Destination CIRQO','Jardim das rosas n. 8901','Lisboa',NULL,'10176','Portugal'),(10964,74,3,'2008-03-20 00:00:00','2008-04-17 00:00:00','2008-03-24 00:00:00',2,87.38,'Ship to 74-B','4567, rue Lauriston','Paris',NULL,'10313','France'),(10965,55,6,'2008-03-20 00:00:00','2008-04-17 00:00:00','2008-03-30 00:00:00',3,144.38,'Ship to 55-B','8901 Bering St.','Anchorage','AK','10256','USA'),(10966,14,4,'2008-03-20 00:00:00','2008-04-17 00:00:00','2008-04-08 00:00:00',1,27.19,'Destination NRTZZ','Hauptstr. 0123','Bern',NULL,'10138','Switzerland'),(10967,79,2,'2008-03-23 00:00:00','2008-04-20 00:00:00','2008-04-02 00:00:00',2,62.22,'Ship to 79-B','Luisenstr. 8901','Münster',NULL,'10327','Germany'),(10968,20,1,'2008-03-23 00:00:00','2008-04-20 00:00:00','2008-04-01 00:00:00',3,74.60,'Destination CUVPF','Kirchgasse 1234','Graz',NULL,'10159','Austria'),(10969,15,1,'2008-03-23 00:00:00','2008-04-20 00:00:00','2008-03-30 00:00:00',2,0.21,'Destination EVHYA','Av. dos Lusíadas, 3456','Sao Paulo','SP','10141','Brazil'),(10970,8,9,'2008-03-24 00:00:00','2008-04-07 00:00:00','2008-04-24 00:00:00',1,16.16,'Ship to 8-C','C/ Araquil, 1234','Madrid',NULL,'10360','Spain'),(10971,26,2,'2008-03-24 00:00:00','2008-04-21 00:00:00','2008-04-02 00:00:00',2,121.82,'Destination XBVKN','3456, rue Royale','Nantes',NULL,'10171','France'),(10972,40,4,'2008-03-24 00:00:00','2008-04-21 00:00:00','2008-03-26 00:00:00',2,0.02,'Destination MVTWX','5678, avenue de l\'Europe','Versailles',NULL,'10213','France'),(10973,40,6,'2008-03-24 00:00:00','2008-04-21 00:00:00','2008-03-27 00:00:00',2,15.17,'Destination WWJLO','6789, avenue de l\'Europe','Versailles',NULL,'10214','France'),(10974,75,3,'2008-03-25 00:00:00','2008-04-08 00:00:00','2008-04-03 00:00:00',3,12.96,'Ship to 75-B','P.O. Box 6789','Lander','WY','10315','USA'),(10975,10,1,'2008-03-25 00:00:00','2008-04-22 00:00:00','2008-03-27 00:00:00',3,32.27,'Destination OLSSJ','2345 Tsawassen Blvd.','Tsawassen','BC','10130','Canada'),(10976,35,1,'2008-03-25 00:00:00','2008-05-06 00:00:00','2008-04-03 00:00:00',1,37.97,'Destination SXYQX','Carrera 0123 con Ave. Carlos Soublette #8-35','San Cristóbal','Táchira','10198','Venezuela'),(10977,24,8,'2008-03-26 00:00:00','2008-04-23 00:00:00','2008-04-10 00:00:00',3,208.50,'Destination NCKKO','Åkergatan 7890','Bräcke',NULL,'10165','Sweden'),(10978,50,9,'2008-03-26 00:00:00','2008-04-23 00:00:00','2008-04-23 00:00:00',2,32.82,'Ship to 50-A','Rue Joseph-Bens 3456','Bruxelles',NULL,'10241','Belgium'),(10979,20,8,'2008-03-26 00:00:00','2008-04-23 00:00:00','2008-03-31 00:00:00',2,353.07,'Destination CUVPF','Kirchgasse 1234','Graz',NULL,'10159','Austria'),(10980,24,4,'2008-03-27 00:00:00','2008-05-08 00:00:00','2008-04-17 00:00:00',1,1.26,'Destination YCMPK','Åkergatan 8901','Bräcke',NULL,'10166','Sweden'),(10981,34,1,'2008-03-27 00:00:00','2008-04-24 00:00:00','2008-04-02 00:00:00',2,193.37,'Destination JPAIY','Rua do Paço, 8901','Rio de Janeiro','RJ','10196','Brazil'),(10982,10,2,'2008-03-27 00:00:00','2008-04-24 00:00:00','2008-04-08 00:00:00',1,14.01,'Destination XJIBQ','1234 Tsawassen Blvd.','Tsawassen','BC','10129','Canada'),(10983,71,2,'2008-03-27 00:00:00','2008-04-24 00:00:00','2008-04-06 00:00:00',2,657.54,'Ship to 71-B','8901 Suffolk Ln.','Boise','Id','10306','USA'),(10984,71,1,'2008-03-30 00:00:00','2008-04-27 00:00:00','2008-04-03 00:00:00',3,211.22,'Ship to 71-B','8901 Suffolk Ln.','Boise','Id','10306','USA'),(10985,37,2,'2008-03-30 00:00:00','2008-04-27 00:00:00','2008-04-02 00:00:00',1,91.51,'Destination ATSOA','4567 Johnstown Road','Cork','Co. Cork','10202','Ireland'),(10986,54,8,'2008-03-30 00:00:00','2008-04-27 00:00:00','2008-04-21 00:00:00',2,217.86,'Ship to 54-A','Ing. Gustavo Moncada 4567 Piso 20-A','Buenos Aires',NULL,'10252','Argentina'),(10987,19,8,'2008-03-31 00:00:00','2008-04-28 00:00:00','2008-04-06 00:00:00',1,185.48,'Destination FRCGJ','5678 King George','London',NULL,'10153','UK'),(10988,65,3,'2008-03-31 00:00:00','2008-04-28 00:00:00','2008-04-10 00:00:00',2,61.14,'Ship to 65-A','7890 Milton Dr.','Albuquerque','NM','10285','USA'),(10989,61,2,'2008-03-31 00:00:00','2008-04-28 00:00:00','2008-04-02 00:00:00',1,34.76,'Ship to 61-A','Rua da Panificadora, 5678','Rio de Janeiro','RJ','10273','Brazil'),(10990,20,2,'2008-04-01 00:00:00','2008-05-13 00:00:00','2008-04-07 00:00:00',3,117.61,'Destination RVDMF','Kirchgasse 9012','Graz',NULL,'10157','Austria'),(10991,63,1,'2008-04-01 00:00:00','2008-04-29 00:00:00','2008-04-07 00:00:00',1,38.51,'Ship to 63-A','Taucherstraße 1234','Cunewalde',NULL,'10279','Germany'),(10992,77,1,'2008-04-01 00:00:00','2008-04-29 00:00:00','2008-04-03 00:00:00',3,4.27,'Ship to 77-C','3456 Jefferson Way Suite 2','Portland','OR','10322','USA'),(10993,24,7,'2008-04-01 00:00:00','2008-04-29 00:00:00','2008-04-10 00:00:00',3,8.81,'Destination NCKKO','Åkergatan 7890','Bräcke',NULL,'10165','Sweden'),(10994,83,2,'2008-04-02 00:00:00','2008-04-16 00:00:00','2008-04-09 00:00:00',3,65.53,'Ship to 83-C','Smagsloget 2345','Århus',NULL,'10341','Denmark'),(10995,58,1,'2008-04-02 00:00:00','2008-04-30 00:00:00','2008-04-06 00:00:00',3,46.00,'Ship to 58-B','Calle Dr. Jorge Cash 4567','México D.F.',NULL,'10262','Mexico'),(10996,63,4,'2008-04-02 00:00:00','2008-04-30 00:00:00','2008-04-10 00:00:00',2,1.12,'Ship to 63-C','Taucherstraße 3456','Cunewalde',NULL,'10281','Germany'),(10997,46,8,'2008-04-03 00:00:00','2008-05-15 00:00:00','2008-04-13 00:00:00',2,73.91,'Ship to 46-A','Carrera 0123 con Ave. Bolívar #65-98 Llano Largo','Barquisimeto','Lara','10227','Venezuela'),(10998,91,8,'2008-04-03 00:00:00','2008-04-17 00:00:00','2008-04-17 00:00:00',2,20.31,'Ship to 91-A','ul. Filtrowa 5678','Warszawa',NULL,'10364','Poland'),(10999,56,6,'2008-04-03 00:00:00','2008-05-01 00:00:00','2008-04-10 00:00:00',2,96.35,'Ship to 56-B','Mehrheimerstr. 1234','Köln',NULL,'10259','Germany'),(11000,65,2,'2008-04-06 00:00:00','2008-05-04 00:00:00','2008-04-14 00:00:00',3,55.12,'Ship to 65-A','7890 Milton Dr.','Albuquerque','NM','10285','USA'),(11001,24,2,'2008-04-06 00:00:00','2008-05-04 00:00:00','2008-04-14 00:00:00',2,197.30,'Destination YCMPK','Åkergatan 8901','Bräcke',NULL,'10166','Sweden'),(11002,71,4,'2008-04-06 00:00:00','2008-05-04 00:00:00','2008-04-16 00:00:00',1,141.16,'Ship to 71-A','7890 Suffolk Ln.','Boise','Id','10305','USA'),(11003,78,3,'2008-04-06 00:00:00','2008-05-04 00:00:00','2008-04-08 00:00:00',3,14.91,'Ship to 78-B','5678 Grizzly Peak Rd.','Butte','MT','10324','USA'),(11004,50,3,'2008-04-07 00:00:00','2008-05-05 00:00:00','2008-04-20 00:00:00',1,44.84,'Ship to 50-C','Rue Joseph-Bens 5678','Bruxelles',NULL,'10243','Belgium'),(11005,90,2,'2008-04-07 00:00:00','2008-05-05 00:00:00','2008-04-10 00:00:00',1,0.75,'Ship to 90-A','Keskuskatu 2345','Helsinki',NULL,'10361','Finland'),(11006,32,3,'2008-04-07 00:00:00','2008-05-05 00:00:00','2008-04-15 00:00:00',2,25.19,'Destination LLUXZ','1234 Baker Blvd.','Eugene','OR','10189','USA'),(11007,60,8,'2008-04-08 00:00:00','2008-05-06 00:00:00','2008-04-13 00:00:00',2,202.24,'Ship to 60-C','Estrada da saúde n. 4567','Lisboa',NULL,'10272','Portugal'),(11008,20,7,'2008-04-08 00:00:00','2008-05-06 00:00:00',NULL,3,79.46,'Destination CUVPF','Kirchgasse 1234','Graz',NULL,'10159','Austria'),(11009,30,2,'2008-04-08 00:00:00','2008-05-06 00:00:00','2008-04-10 00:00:00',1,59.11,'Destination WVLDH','C/ Romero, 7890','Sevilla',NULL,'10185','Spain'),(11010,66,2,'2008-04-09 00:00:00','2008-05-07 00:00:00','2008-04-21 00:00:00',2,28.71,'Ship to 66-A','Strada Provinciale 0123','Reggio Emilia',NULL,'10288','Italy'),(11011,1,3,'2008-04-09 00:00:00','2008-05-07 00:00:00','2008-04-13 00:00:00',1,1.21,'Destination LOUIE','Obere Str. 6789','Berlin',NULL,'10154','Germany'),(11012,25,1,'2008-04-09 00:00:00','2008-04-23 00:00:00','2008-04-17 00:00:00',3,242.95,'Destination WEGWI','Berliner Platz 2345','München',NULL,'10170','Germany'),(11013,69,2,'2008-04-09 00:00:00','2008-05-07 00:00:00','2008-04-10 00:00:00',1,32.99,'Ship to 69-A','Gran Vía, 9012','Madrid',NULL,'10297','Spain'),(11014,47,2,'2008-04-10 00:00:00','2008-05-08 00:00:00','2008-04-15 00:00:00',3,23.60,'Ship to 47-A','Ave. 5 de Mayo Porlamar 3456','I. de Margarita','Nueva Esparta','10230','Venezuela'),(11015,70,2,'2008-04-10 00:00:00','2008-04-24 00:00:00','2008-04-20 00:00:00',2,4.62,'Ship to 70-C','Erling Skakkes gate 6789','Stavern',NULL,'10304','Norway'),(11016,4,9,'2008-04-10 00:00:00','2008-05-08 00:00:00','2008-04-13 00:00:00',2,33.80,'Ship to 4-A','Brook Farm Stratford St. Mary 0123','Colchester','Essex','10238','UK'),(11017,20,9,'2008-04-13 00:00:00','2008-05-11 00:00:00','2008-04-20 00:00:00',2,754.26,'Destination CUVPF','Kirchgasse 1234','Graz',NULL,'10159','Austria'),(11018,48,4,'2008-04-13 00:00:00','2008-05-11 00:00:00','2008-04-16 00:00:00',2,11.65,'Ship to 48-B','6789 Chiaroscuro Rd.','Portland','OR','10233','USA'),(11019,64,6,'2008-04-13 00:00:00','2008-05-11 00:00:00',NULL,3,3.17,'Ship to 64-B','Av. del Libertador 5678','Buenos Aires',NULL,'10283','Argentina'),(11020,56,2,'2008-04-14 00:00:00','2008-05-12 00:00:00','2008-04-16 00:00:00',2,43.30,'Ship to 56-B','Mehrheimerstr. 1234','Köln',NULL,'10259','Germany'),(11021,63,3,'2008-04-14 00:00:00','2008-05-12 00:00:00','2008-04-21 00:00:00',1,297.18,'Ship to 63-B','Taucherstraße 2345','Cunewalde',NULL,'10280','Germany'),(11022,34,9,'2008-04-14 00:00:00','2008-05-12 00:00:00','2008-05-04 00:00:00',2,6.27,'Destination SCQXA','Rua do Paço, 7890','Rio de Janeiro','RJ','10195','Brazil'),(11023,11,1,'2008-04-14 00:00:00','2008-04-28 00:00:00','2008-04-24 00:00:00',2,123.83,'Destination NZASL','Fauntleroy Circus 5678','London',NULL,'10133','UK'),(11024,19,4,'2008-04-15 00:00:00','2008-05-13 00:00:00','2008-04-20 00:00:00',1,74.36,'Destination BBMRT','4567 King George','London',NULL,'10152','UK'),(11025,87,6,'2008-04-15 00:00:00','2008-05-13 00:00:00','2008-04-24 00:00:00',3,29.17,'Ship to 87-C','Torikatu 3456','Oulu',NULL,'10352','Finland'),(11026,27,4,'2008-04-15 00:00:00','2008-05-13 00:00:00','2008-04-28 00:00:00',1,47.09,'Destination DICGM','Via Monte Bianco 7890','Torino',NULL,'10175','Italy'),(11027,10,1,'2008-04-16 00:00:00','2008-05-14 00:00:00','2008-04-20 00:00:00',1,52.52,'Destination XJIBQ','1234 Tsawassen Blvd.','Tsawassen','BC','10129','Canada'),(11028,39,2,'2008-04-16 00:00:00','2008-05-14 00:00:00','2008-04-22 00:00:00',1,29.59,'Destination DKMQA','Maubelstr. 0123','Brandenburg',NULL,'10208','Germany'),(11029,14,4,'2008-04-16 00:00:00','2008-05-14 00:00:00','2008-04-27 00:00:00',1,47.84,'Destination YUJRD','Hauptstr. 1234','Bern',NULL,'10139','Switzerland'),(11030,71,7,'2008-04-17 00:00:00','2008-05-15 00:00:00','2008-04-27 00:00:00',2,830.75,'Ship to 71-C','9012 Suffolk Ln.','Boise','Id','10307','USA'),(11031,71,6,'2008-04-17 00:00:00','2008-05-15 00:00:00','2008-04-24 00:00:00',2,227.22,'Ship to 71-C','9012 Suffolk Ln.','Boise','Id','10307','USA'),(11032,89,2,'2008-04-17 00:00:00','2008-05-15 00:00:00','2008-04-23 00:00:00',3,606.19,'Ship to 89-B','8901 - 12th Ave. S.','Seattle','WA','10357','USA'),(11033,68,7,'2008-04-17 00:00:00','2008-05-15 00:00:00','2008-04-23 00:00:00',3,84.74,'Ship to 68-A','Starenweg 6789','Genève',NULL,'10294','Switzerland'),(11034,55,8,'2008-04-20 00:00:00','2008-06-01 00:00:00','2008-04-27 00:00:00',1,40.32,'Ship to 55-B','8901 Bering St.','Anchorage','AK','10256','USA'),(11035,76,2,'2008-04-20 00:00:00','2008-05-18 00:00:00','2008-04-24 00:00:00',2,0.17,'Ship to 76-B','Boulevard Tirou, 9012','Charleroi',NULL,'10318','Belgium'),(11036,17,8,'2008-04-20 00:00:00','2008-05-18 00:00:00','2008-04-22 00:00:00',3,149.47,'Destination YPUYI','Walserweg 8901','Aachen',NULL,'10146','Germany'),(11037,30,7,'2008-04-21 00:00:00','2008-05-19 00:00:00','2008-04-27 00:00:00',1,3.20,'Destination GGQIR','C/ Romero, 6789','Sevilla',NULL,'10184','Spain'),(11038,76,1,'2008-04-21 00:00:00','2008-05-19 00:00:00','2008-04-30 00:00:00',2,29.59,'Ship to 76-A','Boulevard Tirou, 8901','Charleroi',NULL,'10317','Belgium'),(11039,47,1,'2008-04-21 00:00:00','2008-05-19 00:00:00',NULL,2,65.00,'Ship to 47-C','Ave. 5 de Mayo Porlamar 5678','I. de Margarita','Nueva Esparta','10232','Venezuela'),(11040,32,4,'2008-04-22 00:00:00','2008-05-20 00:00:00',NULL,3,18.84,'Destination VYOBK','3456 Baker Blvd.','Eugene','OR','10191','USA'),(11041,14,3,'2008-04-22 00:00:00','2008-05-20 00:00:00','2008-04-28 00:00:00',2,48.22,'Destination YUJRD','Hauptstr. 1234','Bern',NULL,'10139','Switzerland'),(11042,15,2,'2008-04-22 00:00:00','2008-05-06 00:00:00','2008-05-01 00:00:00',1,29.99,'Destination EVHYA','Av. dos Lusíadas, 3456','Sao Paulo','SP','10141','Brazil'),(11043,74,5,'2008-04-22 00:00:00','2008-05-20 00:00:00','2008-04-29 00:00:00',2,8.80,'Ship to 74-B','4567, rue Lauriston','Paris',NULL,'10313','France'),(11044,91,4,'2008-04-23 00:00:00','2008-05-21 00:00:00','2008-05-01 00:00:00',1,8.72,'Ship to 91-B','ul. Filtrowa 6789','Warszawa',NULL,'10365','Poland'),(11045,10,6,'2008-04-23 00:00:00','2008-05-21 00:00:00',NULL,2,70.58,'Destination LPHSI','3456 Tsawassen Blvd.','Tsawassen','BC','10131','Canada'),(11046,86,8,'2008-04-23 00:00:00','2008-05-21 00:00:00','2008-04-24 00:00:00',2,71.64,'Ship to 86-C','Adenauerallee 0123','Stuttgart',NULL,'10349','Germany'),(11047,19,7,'2008-04-24 00:00:00','2008-05-22 00:00:00','2008-05-01 00:00:00',3,46.62,'Destination FRCGJ','5678 King George','London',NULL,'10153','UK'),(11048,10,7,'2008-04-24 00:00:00','2008-05-22 00:00:00','2008-04-30 00:00:00',3,24.12,'Destination XJIBQ','1234 Tsawassen Blvd.','Tsawassen','BC','10129','Canada'),(11049,31,3,'2008-04-24 00:00:00','2008-05-22 00:00:00','2008-05-04 00:00:00',1,8.34,'Destination XOIGC','Av. Brasil, 8901','Campinas','SP','10186','Brazil'),(11050,24,8,'2008-04-27 00:00:00','2008-05-25 00:00:00','2008-05-05 00:00:00',2,59.41,'Destination YCMPK','Åkergatan 8901','Bräcke',NULL,'10166','Sweden'),(11051,41,7,'2008-04-27 00:00:00','2008-05-25 00:00:00',NULL,3,2.79,'Destination OLJND','8901 rue Alsace-Lorraine','Toulouse',NULL,'10216','France'),(11052,34,3,'2008-04-27 00:00:00','2008-05-25 00:00:00','2008-05-01 00:00:00',1,67.26,'Destination DPCVR','Rua do Paço, 6789','Rio de Janeiro','RJ','10194','Brazil'),(11053,59,2,'2008-04-27 00:00:00','2008-05-25 00:00:00','2008-04-29 00:00:00',2,53.05,'Ship to 59-A','Geislweg 6789','Salzburg',NULL,'10264','Austria'),(11054,12,8,'2008-04-28 00:00:00','2008-05-26 00:00:00',NULL,1,0.33,'Destination QTHBC','Cerrito 6789','Buenos Aires',NULL,'10134','Argentina'),(11055,35,7,'2008-04-28 00:00:00','2008-05-26 00:00:00','2008-05-05 00:00:00',2,120.92,'Destination JYDLM','Carrera1234 con Ave. Carlos Soublette #8-35','San Cristóbal','Táchira','10199','Venezuela'),(11056,19,8,'2008-04-28 00:00:00','2008-05-12 00:00:00','2008-05-01 00:00:00',2,278.96,'Destination QTKCU','3456 King George','London',NULL,'10151','UK'),(11057,53,3,'2008-04-29 00:00:00','2008-05-27 00:00:00','2008-05-01 00:00:00',3,4.13,'Ship to 53-C','South House 3456 Queensbridge','London',NULL,'10251','UK'),(11058,6,9,'2008-04-29 00:00:00','2008-05-27 00:00:00',NULL,3,31.14,'Ship to 6-A','Forsterstr. 2345','Mannheim',NULL,'10300','Germany'),(11059,67,2,'2008-04-29 00:00:00','2008-06-10 00:00:00',NULL,2,85.80,'Ship to 67-A','Av. Copacabana, 3456','Rio de Janeiro','RJ','10291','Brazil'),(11060,27,2,'2008-04-30 00:00:00','2008-05-28 00:00:00','2008-05-04 00:00:00',2,10.98,'Destination DICGM','Via Monte Bianco 7890','Torino',NULL,'10175','Italy'),(11061,32,4,'2008-04-30 00:00:00','2008-06-11 00:00:00',NULL,3,14.01,'Destination VYOBK','3456 Baker Blvd.','Eugene','OR','10191','USA'),(11062,66,4,'2008-04-30 00:00:00','2008-05-28 00:00:00',NULL,2,29.93,'Ship to 66-B','Strada Provinciale 1234','Reggio Emilia',NULL,'10289','Italy'),(11063,37,3,'2008-04-30 00:00:00','2008-05-28 00:00:00','2008-05-06 00:00:00',2,81.73,'Destination KPVYJ','5678 Johnstown Road','Cork','Co. Cork','10203','Ireland'),(11064,71,1,'2008-05-01 00:00:00','2008-05-29 00:00:00','2008-05-04 00:00:00',1,30.09,'Ship to 71-C','9012 Suffolk Ln.','Boise','Id','10307','USA'),(11065,46,8,'2008-05-01 00:00:00','2008-05-29 00:00:00',NULL,1,12.91,'Ship to 46-C','Carrera 2345 con Ave. Bolívar #65-98 Llano Largo','Barquisimeto','Lara','10229','Venezuela'),(11066,89,7,'2008-05-01 00:00:00','2008-05-29 00:00:00','2008-05-04 00:00:00',2,44.72,'Ship to 89-A','7890 - 12th Ave. S.','Seattle','WA','10356','USA'),(11067,17,1,'2008-05-04 00:00:00','2008-05-18 00:00:00','2008-05-06 00:00:00',2,7.98,'Destination BJCXA','Walserweg 7890','Aachen',NULL,'10145','Germany'),(11068,62,8,'2008-05-04 00:00:00','2008-06-01 00:00:00',NULL,2,81.75,'Ship to 62-A','Alameda dos Canàrios, 8901','Sao Paulo','SP','10276','Brazil'),(11069,80,1,'2008-05-04 00:00:00','2008-06-01 00:00:00','2008-05-06 00:00:00',2,15.67,'Ship to 80-B','Avda. Azteca 4567','México D.F.',NULL,'10333','Mexico'),(11070,44,2,'2008-05-05 00:00:00','2008-06-02 00:00:00',NULL,1,136.00,'Ship to 44-A','Magazinweg 4567','Frankfurt a.M.',NULL,'10222','Germany'),(11071,46,1,'2008-05-05 00:00:00','2008-06-02 00:00:00',NULL,1,0.93,'Ship to 46-B','Carrera 1234 con Ave. Bolívar #65-98 Llano Largo','Barquisimeto','Lara','10228','Venezuela'),(11072,20,4,'2008-05-05 00:00:00','2008-06-02 00:00:00',NULL,2,258.64,'Destination RVDMF','Kirchgasse 9012','Graz',NULL,'10157','Austria'),(11073,58,2,'2008-05-05 00:00:00','2008-06-02 00:00:00',NULL,2,24.95,'Ship to 58-B','Calle Dr. Jorge Cash 4567','México D.F.',NULL,'10262','Mexico');
/*!40000 ALTER TABLE `salesorder` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `shipper`
--
DROP TABLE IF EXISTS `shipper`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `shipper` (
`shipperId` int NOT NULL AUTO_INCREMENT,
`companyName` varchar(40) COLLATE utf8_bin NOT NULL,
`phone` varchar(44) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`shipperId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `shipper`
--
LOCK TABLES `shipper` WRITE;
/*!40000 ALTER TABLE `shipper` DISABLE KEYS */;
INSERT INTO `shipper` VALUES (1,'Shipper GVSUA','(503) 555-0137'),(2,'Shipper ETYNR','(425) 555-0136'),(3,'Shipper ZHISN','(415) 555-0138');
/*!40000 ALTER TABLE `shipper` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `supplier`
--
DROP TABLE IF EXISTS `supplier`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `supplier` (
`supplierId` int NOT NULL AUTO_INCREMENT,
`companyName` varchar(40) COLLATE utf8_bin NOT NULL,
`contactName` varchar(30) COLLATE utf8_bin DEFAULT NULL,
`contactTitle` varchar(30) COLLATE utf8_bin DEFAULT NULL,
`address` varchar(60) COLLATE utf8_bin DEFAULT NULL,
`city` varchar(15) COLLATE utf8_bin DEFAULT NULL,
`region` varchar(15) COLLATE utf8_bin DEFAULT NULL,
`postalCode` varchar(10) COLLATE utf8_bin DEFAULT NULL,
`country` varchar(15) COLLATE utf8_bin DEFAULT NULL,
`phone` varchar(24) COLLATE utf8_bin DEFAULT NULL,
`email` varchar(225) COLLATE utf8_bin DEFAULT NULL,
`fax` varchar(24) COLLATE utf8_bin DEFAULT NULL,
`HomePage` text COLLATE utf8_bin,
PRIMARY KEY (`supplierId`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `supplier`
--
LOCK TABLES `supplier` WRITE;
/*!40000 ALTER TABLE `supplier` DISABLE KEYS */;
INSERT INTO `supplier` VALUES (1,'Supplier SWRXU','Adolphi, Stephan','Purchasing Manager','2345 Gilbert St.','London',NULL,'10023','UK','(171) 456-7890',NULL,NULL,NULL),(2,'Supplier VHQZD','Hance, Jim','Order Administrator','P.O. Box 5678','New Orleans','LA','10013','USA','(100) 555-0111',NULL,NULL,NULL),(3,'Supplier STUAZ','Parovszky, Alfons','Sales Representative','1234 Oxford Rd.','Ann Arbor','MI','10026','USA','(313) 555-0109',NULL,'(313) 555-0112',NULL),(4,'Supplier QOVFD','Balázs, Erzsébet','Marketing Manager','7890 Sekimai Musashino-shi','Tokyo',NULL,'10011','Japan','(03) 6789-0123',NULL,NULL,NULL),(5,'Supplier EQPNC','Holm, Michael','Export Administrator','Calle del Rosal 4567','Oviedo','Asturias','10029','Spain','(98) 123 45 67',NULL,NULL,NULL),(6,'Supplier QWUSF','Popkova, Darya','Marketing Representative','8901 Setsuko Chuo-ku','Osaka',NULL,'10028','Japan','(06) 789-0123',NULL,NULL,NULL),(7,'Supplier GQRCV','Ræbild, Jesper','Marketing Manager','5678 Rose St. Moonie Ponds','Melbourne','Victoria','10018','Australia','(03) 123-4567',NULL,'(03) 456-7890',NULL),(8,'Supplier BWGYE','Iallo, Lucio','Sales Representative','9012 King\'s Way','Manchester',NULL,'10021','UK','(161) 567-8901',NULL,NULL,NULL),(9,'Supplier QQYEU','Basalik, Evan','Sales Agent','Kaloadagatan 4567','Göteborg',NULL,'10022','Sweden','031-345 67 89',NULL,'031-678 90 12',NULL),(10,'Supplier UNAHG','Barnett, Dave','Marketing Manager','Av. das Americanas 2345','Sao Paulo',NULL,'10034','Brazil','(11) 345 6789',NULL,NULL,NULL),(11,'Supplier ZPYVS','Jain, Mukesh','Sales Manager','Tiergartenstraße 3456','Berlin',NULL,'10016','Germany','(010) 3456789',NULL,NULL,NULL),(12,'Supplier SVIYA','Regev, Barak','International Marketing Mgr.','Bogenallee 9012','Frankfurt',NULL,'10024','Germany','(069) 234567',NULL,NULL,NULL),(13,'Supplier TEGSC','Brehm, Peter','Coordinator Foreign Markets','Frahmredder 3456','Cuxhaven',NULL,'10019','Germany','(04721) 1234',NULL,'(04721) 2345',NULL),(14,'Supplier KEREV','Keil, Kendall','Sales Representative','Viale Dante, 6789','Ravenna',NULL,'10015','Italy','(0544) 56789',NULL,'(0544) 34567',NULL),(15,'Supplier NZLIF','Sałas-Szlejter, Karolina','Marketing Manager','Hatlevegen 1234','Sandvika',NULL,'10025','Norway','(0)9-012345',NULL,NULL,NULL),(16,'Supplier UHZRG','Scholl, Thorsten','Regional Account Rep.','8901 - 8th Avenue Suite 210','Bend','OR','10035','USA','(503) 555-0108',NULL,NULL,NULL),(17,'Supplier QZGUF','Kleinerman, Christian','Sales Representative','Brovallavägen 0123','Stockholm',NULL,'10033','Sweden','08-234 56 78',NULL,NULL,NULL),(18,'Supplier LVJUA','Canel, Fabrice','Sales Manager','3456, Rue des Francs-Bourgeois','Paris',NULL,'10031','France','(1) 90.12.34.56',NULL,'(1) 01.23.45.67',NULL),(19,'Supplier JDNUG','Chapman, Greg','Wholesale Account Agent','Order Processing Dept. 7890 Paul Revere Blvd.','Boston','MA','10027','USA','(617) 555-0110',NULL,'(617) 555-0113',NULL),(20,'Supplier CIYNM','Köszegi, Emília','Owner','6789 Serangoon Loop, Suite #402','Singapore',NULL,'10037','Singapore','012-3456',NULL,NULL,NULL),(21,'Supplier XOXZA','Shakespear, Paul','Sales Manager','Lyngbysild Fiskebakken 9012','Lyngby',NULL,'10012','Denmark','67890123',NULL,'78901234',NULL),(22,'Supplier FNUXM','Skelly, Bonnie L.','Accounting Manager','Verkoop Rijnweg 8901','Zaandam',NULL,'10014','Netherlands','(12345) 8901',NULL,'(12345) 5678',NULL),(23,'Supplier ELCRN','LaMee, Brian','Product Manager','Valtakatu 1234','Lappeenranta',NULL,'10032','Finland','(953) 78901',NULL,NULL,NULL),(24,'Supplier JNNES','Clark, Molly','Sales Representative','6789 Prince Edward Parade Hunter\'s Hill','Sydney','NSW','10030','Australia','(02) 234-5678',NULL,'(02) 567-8901',NULL),(25,'Supplier ERVYZ','Sprenger, Christof','Marketing Manager','7890 Rue St. Laurent','Montréal','Québec','10017','Canada','(514) 456-7890',NULL,NULL,NULL),(26,'Supplier ZWZDM','Cunha, Gonçalo','Order Administrator','Via dei Gelsomini, 5678','Salerno',NULL,'10020','Italy','(089) 4567890',NULL,'(089) 4567890',NULL),(27,'Supplier ZRYDZ','Leoni, Alessandro','Sales Manager','4567, rue H. Voiron','Montceau',NULL,'10036','France','89.01.23.45',NULL,NULL,NULL),(28,'Supplier OAVQT','Teper, Jeff','Sales Representative','Bat. B 2345, rue des Alpes','Annecy',NULL,'10010','France','01.23.45.67',NULL,'89.01.23.45',NULL),(29,'Supplier OGLRK','Walters, Rob','Accounting Manager','0123 rue Chasseur','Ste-Hyacinthe','Québec','10009','Canada','(514) 567-890',NULL,'(514) 678-9012',NULL);
/*!40000 ALTER TABLE `supplier` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `territory`
--
DROP TABLE IF EXISTS `territory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `territory` (
`territoryId` varchar(20) COLLATE utf8_bin NOT NULL,
`territorydescription` varchar(50) COLLATE utf8_bin NOT NULL,
`regionId` int NOT NULL,
PRIMARY KEY (`territoryId`),
KEY `regionId` (`regionId`),
CONSTRAINT `territory_ibfk_1` FOREIGN KEY (`regionId`) REFERENCES `region` (`regionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `territory`
--
LOCK TABLES `territory` WRITE;
/*!40000 ALTER TABLE `territory` DISABLE KEYS */;
INSERT INTO `territory` VALUES ('01581','Westboro',1),('01730','Bedford',1),('01833','Georgetow',1),('02116','Boston',1),('02139','Cambridge',1),('02184','Braintree',1),('02903','Providence',1),('03049','Hollis',3),('03801','Portsmouth',3),('06897','Wilton',1),('07960','Morristown',1),('08837','Edison',1),('10019','New York',1),('10038','New York',1),('11747','Mellvile',1),('14450','Fairport',1),('19428','Philadelphia',3),('19713','Neward',1),('20852','Rockville',1),('27403','Greensboro',1),('27511','Cary',1),('29202','Columbia',4),('30346','Atlanta',4),('31406','Savannah',4),('32859','Orlando',4),('33607','Tampa',4),('40222','Louisville',1),('44122','Beachwood',3),('45839','Findlay',3),('48075','Southfield',3),('48084','Troy',3),('48304','Bloomfield Hills',3),('53404','Racine',3),('55113','Roseville',3),('55439','Minneapolis',3),('60179','Hoffman Estates',2),('60601','Chicago',2),('72716','Bentonville',4),('75234','Dallas',4),('78759','Austin',4),('80202','Denver',2),('80909','Colorado Springs',2),('85014','Phoenix',2),('85251','Scottsdale',2),('90405','Santa Monica',2),('94025','Menlo Park',2),('94105','San Francisco',2),('95008','Campbell',2),('95054','Santa Clara',2),('95060','Santa Cruz',2),('98004','Bellevue',2),('98052','Redmond',2),('98104','Seattle',2);
/*!40000 ALTER TABLE `territory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping routines for database 'northwind'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2022-12-17 21:24:46