-- MySQL dump 10.13  Distrib 8.0.31, for Win64 (x86_64)
--
-- Host: 35.225.233.105    Database: 2017_2018
-- ------------------------------------------------------
-- Server version	5.7.44-google-log

/*!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 `wwa_offices_ultimate`
--

DROP TABLE IF EXISTS `wwa_offices_ultimate`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `wwa_offices_ultimate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pais_verdadero` varchar(100) DEFAULT NULL,
  `SenderID` varchar(30) DEFAULT NULL,
  `ReceiverID` varchar(10) DEFAULT NULL,
  `Office` varchar(255) DEFAULT NULL,
  `Country` varchar(255) DEFAULT NULL,
  `Type_of_Office` varchar(255) DEFAULT NULL,
  `Observaciones` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=758 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wwa_offices_ultimate`
--

LOCK TABLES `wwa_offices_ultimate` WRITE;
/*!40000 ALTER TABLE `wwa_offices_ultimate` DISABLE KEYS */;
INSERT INTO `wwa_offices_ultimate` VALUES (1,'ALGERIA','edi_transglory_prod','DZALG01','ALGIERS','ALGERIA','Ocean',NULL),(2,'ARGENTINA','edi_sslconsolidation_prod','ARBUE01','BUENOS AIRES','ARGENTINA','Ocean',NULL),(3,'AUSTRALIA','edi_ags_prod','AUSYD01','SYDNEY','AUSTRALIA','Ocean',NULL),(4,'AUSTRALIA','edi_ags_prod','AUMEL01','MELBOURNE','AUSTRALIA','Ocean',NULL),(5,'AUSTRALIA','edi_ags_prod','AUBNE01','BRISBANE','AUSTRALIA','Ocean',NULL),(6,'AUSTRALIA','edi_ags_prod','AUADL01','ADELAIDE','AUSTRALIA','Ocean',NULL),(7,'AUSTRALIA','edi_ags_prod','AUFRE01','FREEMANTLE','AUSTRALIA','Ocean',NULL),(8,'AUSTRIA','edi_sslaustria_prod','ATVIE01','WIEN','AUSTRIA','Ocean',NULL),(9,'BELGIUM','edi_shipco_prod','BEANR01','ANTWERP','BELGIUM','Ocean and Air',NULL),(10,'BRAZIL','edi_allink_prod','BRCWB01','CURITIBA','BRAZIL','Ocean',NULL),(11,'BRAZIL','edi_allink_prod','BRITJ01','ITAJAI','BRAZIL','Ocean',NULL),(12,'BRAZIL','edi_allink_prod','BRPNG01','PARANAGUA','BRAZIL','Ocean',NULL),(13,'BRAZIL','edi_allink_prod','BRPOA01','PORTO ALEGRE','BRAZIL','Ocean',NULL),(14,'BRAZIL','edi_allink_prod','BRRIG01','RIO GRANDE','BRAZIL','Ocean',NULL),(15,'BRAZIL','edi_allink_prod','BRRIO01','RIO DE JANEIRO','BRAZIL','Ocean',NULL),(16,'BRAZIL','edi_allink_prod','BRSAO01','SAO PAULO','BRAZIL','Ocean',NULL),(17,'BRAZIL','edi_allink_prod','BRSSZ01','SANTOS','BRAZIL','Ocean',NULL),(18,'BRAZIL','edi_allink_prod','BRVIX01','VITORIA','BRAZIL','Ocean',NULL),(19,'CANADA','edi_shipco_prod','CATOR01','TORONTO','CANADA','Ocean and Air',NULL),(20,'CANADA','edi_shipco_prod','CAMTR01','MONTREAL','CANADA','Ocean and Air',NULL),(21,'CHILE','edi_shipco_prod','CLSCL01','SANTIAGO','CHILE','Ocean and Air',NULL),(22,'CHILE','edi_sslchile_prod','CLSCL02','SANTIAGO','CHILE','Ocean',NULL),(23,'CHINA','edi_shipco_prod','CNDLC01','DALIAN','CHINA','Ocean and Air',NULL),(24,'CHINA','edi_shipco_prod','CNGZP01','GUANGZHOU PT','CHINA','Ocean',NULL),(25,'CHINA','edi_shipco_prod','HKHKG01','HONG KONG','CHINA','Ocean and Air',NULL),(26,'CHINA','edi_shipco_prod','CNNGB01','NINGBO','CHINA','Ocean',NULL),(27,'CHINA','edi_shipco_prod','CNTAO01','QINGDAO','CHINA','Ocean',NULL),(28,'CHINA','edi_shipco_prod','CNSHA01','SHANGHAI','CHINA','Ocean and Air',NULL),(29,'CHINA','edi_shipco_prod','CNSZX01','SHENZHEN','CHINA','Ocean and Air',NULL),(30,'CHINA','edi_shipco_prod','CNCKG01','CHONGQING','CHINA','Ocean',NULL),(31,'CHINA','edi_shipco_prod','CNXMN01','XIAMEN','CHINA','Ocean',NULL),(32,'CHINA','edi_tianjin_prod','CNTSN01','TIANJIN','CHINA','Ocean and Air',NULL),(33,'COLUMBIA','edi_mahe_prod','COBOG01','BOGOTA','COLUMBIA','Ocean',NULL),(34,'COLUMBIA','edi_mahe_prod','COMDE01','MEDELLIN','COLUMBIA','Ocean',NULL),(35,'COLUMBIA','edi_mahe_prod','COCLO01','CALI','COLUMBIA','Ocean',NULL),(36,'COLUMBIA','edi_mahe_prod','COCTG01','CARTAGENA','COLUMBIA','Ocean',NULL),(37,'COLUMBIA','edi_mahe_prod','COBUN01','BUENAVENTURA','COLUMBIA','Ocean',NULL),(38,'COLUMBIA','edi_mahe_prod','COBAQ01','BARRANQUILLA','COLUMBIA','Ocean',NULL),(39,'CYPRUS','edi_sslcyprus_prod','CYLMS01','LIMASSOL','CYPRUS','Ocean',NULL),(40,'CYPRUS','edi_sslcyprus_prod','CYLCA01','LARNACA','CYPRUS','Ocean',NULL),(41,'CZECH REPUBLIC','edi_sslconsolidation_prod','CZPRG01','PRAGUE','CZECH REPUBLIC','Ocean','Czech Republic: Currently is being handled by edi_saco_prod (DEHAM01)'),(42,'DENMARK','edi_shipco_prod','DKCPH01','COPENHAGEN','DENMARK','Ocean and Air',NULL),(43,'DOMINICAN REPUBLIC','edi_neutral_prod','DOSDQ01','SANTO DOMINGO','DOMINICAN REPUBLIC','Ocean',NULL),(44,'DOMINICAN REPUBLIC','edi_neutral_prod','DOSTI01','SANTIAGO','DOMINICAN REPUBLIC','Ocean',NULL),(45,'ECUADOR','edi_sslecuador_prod','ECGYE01','GUAYAQUIL','ECUADOR','Ocean',NULL),(46,'EGYPT','edi_mesco_prod','EGALY01','ALEXANDRIA','EGYPT','Ocean',NULL),(47,'EGYPT','edi_mesco_prod','EGCAI01','CAIRO','EGYPT','Ocean',NULL),(48,'ESTONIA','edi_shipco_prod','EETLL01','TALLINN','ESTONIA','Ocean and Air',NULL),(49,'FINLAND','edi_shipco_prod','FIHEL01','HELSINKI','FINLAND','Ocean and Air',NULL),(50,'FRANCE','edi_multimodal_prod','FRPAR01','PARIS','FRANCE','Ocean',NULL),(51,'FRANCE','edi_multimodal_prod','FRLEH01','LE HAVRE','FRANCE','Ocean',NULL),(52,'FRANCE','edi_multimodal_prod','FRLIO01','LYON','FRANCE','Ocean',NULL),(53,'FRANCE','edi_multimodal_prod','FRMRS01','MARSEILLE','FRANCE','Ocean',NULL),(54,'FRANCE','edi_multimodal_prod','FRFOS01','FOS','FRANCE','Ocean',NULL),(55,'GERMANY','edi_saco_prod','DEBRE01','BREMEN','GERMANY','Ocean',NULL),(56,'GERMANY','edi_saco_prod','DEHAM01','HAMBURG','GERMANY','Ocean',NULL),(57,'HUNGARY','edi_sslhungary_prod','HUBUD01','BUDAPEST','HUNGARY','Ocean',NULL),(58,'INDIA','edi_teamglobal_prod','INBOM01','MUMBAI','INDIA','Ocean',NULL),(59,'INDIA','edi_teamglobal_prod','INAMD01','AHMEDABAD','INDIA','Ocean',NULL),(60,'INDIA','edi_teamglobal_prod','INBLR01','BANGALORE','INDIA','Ocean',NULL),(61,'INDIA','edi_teamglobal_prod','INBRC01','BARODA','INDIA','Ocean',NULL),(62,'INDIA','edi_teamglobal_prod','INMAA01','CHENNAI','INDIA','Ocean',NULL),(63,'INDIA','edi_teamglobal_prod','INCOK01','COCHIN','INDIA','Ocean',NULL),(64,'INDIA','edi_teamglobal_prod','INCJB01','COIMBATORE','INDIA','Ocean',NULL),(65,'INDIA','edi_teamglobal_prod','INDEL01','DELHI','INDIA','Ocean',NULL),(66,'INDIA','edi_teamglobal_prod','INHYD01','HYDERABAD','INDIA','Ocean',NULL),(67,'INDIA','edi_teamglobal_prod','INJAI01','JAIPUR','INDIA','Ocean',NULL),(68,'INDIA','edi_teamglobal_prod','INJDH01','JODHPUR','INDIA','Ocean',NULL),(69,'INDIA','edi_teamglobal_prod','INKUR01','KARUR','INDIA','Ocean',NULL),(70,'INDIA','edi_teamglobal_prod','INKOC01','KOCHI','INDIA','Ocean',NULL),(71,'INDIA','edi_teamglobal_prod','INCCU01','KOLKATA','INDIA','Ocean',NULL),(72,'INDIA','edi_teamglobal_prod','INLUH01','LUDHIANA','INDIA','Ocean',NULL),(73,'INDIA','edi_teamglobal_prod','INICD01','NEW DELHI','INDIA','Ocean',NULL),(74,'INDIA','edi_teamglobal_prod','INPNQ01','PUNE','INDIA','Ocean',NULL),(75,'INDIA','edi_teamglobal_prod','INTUP01','TIRUPUR','INDIA','Ocean',NULL),(76,'INDIA','edi_teamglobal_prod','INTUT01','TUTICORIN','INDIA','Ocean',NULL),(77,'INDONESIA','edi_shipco_prod','IDJKT01','JAKARTA','INDONESIA','Ocean and Air',NULL),(78,'INDONESIA','edi_shipco_prod','IDSUB01','SURABAYA','INDONESIA','Ocean and Air',NULL),(79,'IRELAND','edi_shipco_prod','IEDUB01','DUBLIN','IRELAND','Ocean',NULL),(80,'ISRAEL','edi_eldancargo_prod','ILHFA01','HAIFA','ISRAEL','Ocean',NULL),(81,'ISRAEL','edi_eldancargo_prod','ILASH01','ASHDOD','ISRAEL','Ocean',NULL),(82,'ISRAEL','edi_eldancargo_prod','ILTLV01','AZUR','ISRAEL','Ocean',NULL),(83,'ITALY','edi_combimar_prod','ITFLR01','FIRENZE','ITALY','Ocean',NULL),(84,'ITALY','edi_combimar_prod','ITGOA01','GENOA','ITALY','Ocean',NULL),(85,'ITALY','edi_combimar_prod','ITLIV01','LIVORNO','ITALY','Ocean',NULL),(86,'ITALY','edi_combimar_prod','ITMIL01','MILAN','ITALY','Ocean',NULL),(87,'JAPAN','edi_shipco_prod','JPTYO01','TOKYO','JAPAN','Ocean and Air',NULL),(88,'KOREA','edi_goldway_prod','KRPUS02','BUSAN','KOREA','Ocean',NULL),(89,'KOREA','edi_goldway_prod','KRSEL03','SEOUL','KOREA','Ocean',NULL),(90,'KOREA','edi_shipco_prod','KRSEL01','SEOUL','KOREA','Ocean',NULL),(91,'LATVIA','edi_shipco_prod','LVRIX01','RIGA','LATVIA','Ocean and Air',NULL),(92,'LEBANON','edi_oceanairconsolidators_prod','LBBEY01','BEIRUT','LEBANON','Ocean',NULL),(93,'LITHUANIA','edi_shipco_prod','LTVNO01','VILNUIS','LITHUANIA','Ocean and Air',NULL),(94,'MALAYSIA','edi_shipco_prod','MYPEN01','PENANG','MALAYSIA','Ocean and Air',NULL),(95,'MALAYSIA','edi_shipco_prod','MYPKG01','PORT KELANG','MALAYSIA','Ocean and Air',NULL),(96,'MEXICO','edi_interteam_prod','MXMEX01','MEXICO CITY','MEXICO','Ocean',NULL),(97,'MEXICO','edi_interteam_prod','MXVER01','VERACRUZ','MEXICO','Ocean',NULL),(98,'MEXICO','edi_interteam_prod','MXZLO01','MANZANILLO','MEXICO','Ocean',NULL),(99,'MEXICO','edi_interteam_prod','MXGDL01','GUADALAJARA','MEXICO','Ocean',NULL),(100,'MEXICO','edi_interteam_prod','MXATM01','ALTAMIRA','MEXICO','Ocean',NULL),(101,'MOROCCO','edi_transglory_prod','MACAS01','CASABLANCA','MOROCCO','Ocean',NULL),(102,'NEW ZEALAND','edi_shipco_prod','NZAKL01','AUCKLAND','NEW ZEALAND','Ocean and Air',NULL),(103,'NETHERLANDS','edi_shipco_prod','NLRTM01','ROTTERDAM','NETHERLANDS','Ocean and Air',NULL),(104,'NORWAY','edi_shipco_prod','NOOSL01','OSLO','NORWAY','Ocean and Air',NULL),(105,'PAKISTAN','edi_shipco_prod','PKKHI01','KARACHI','PAKISTAN','Ocean',NULL),(106,'PANAMA','edi_pcspanama_prod','PAPTY01','PANAMA CITY','PANAMA','Ocean',NULL),(107,'PARAGUAY','edi_sslparaguay_prod','PYASU01','ASUNCION','PARAGUAY','Ocean',NULL),(108,'ROMANIA','edi_shipco_prod','ROBUH01','BUCHAREST','ROMANIA','Ocean',NULL),(109,'PERU','edi_sslperu_prod','PELIM01','LIMA','PERU','Ocean',NULL),(110,'PHILIPPINES','edi_shipco_prod','PHMNL01','MANILA','PHILIPPINES','Ocean and Air',NULL),(111,'POLAND','edi_shipco_prod','PLGDY01','GDYNIA','POLAND','Ocean and Air',NULL),(112,'PORTUGAL','edi_transglory_prod','PTLIS01','LISBON','PORTUGAL','Ocean',NULL),(113,'PORTUGAL','edi_transglory_prod','PTLEI01','LEIXOES','PORTUGAL','Ocean',NULL),(114,'PORTUGAL','edi_transglory_prod','PTOPO01','OPORTO CITY','PORTUGAL','Ocean',NULL),(115,'PUERTO RICO','edi_shipco_prod','PRSJU01','SAN JUAN','PUERTO RICO','Ocean',NULL),(116,'ROMANIA','edi_shipco_prod','ROBUH01','BUCHAREST','ROMANIA','Ocean and Air',NULL),(117,'RUSSIA','edi_scanway_prod','RUSTP01','ST. PETERSBURG','RUSSIA','Ocean',NULL),(118,'RUSSIA','edi_scanway_prod','RUMOW01','MOSCOW','RUSSIA','Ocean',NULL),(119,'SINGAPORE','edi_shipco_prod','SGSIN01','SINGAPORE','SINGAPORE','Ocean and Air',NULL),(120,'SLOVAKIA','edi_saco_prod','DEHAM01','SLOVAKIA','SLOVAKIA','Ocean','Slovakia: Currently is being handled by edi_saco_prod (DEHAM01)'),(121,'SLOVENIA','edi_shipco_prod','SIKOP01','KOPER','SLOVENIA','Ocean',NULL),(122,'SOUTH AFRICA','edi_cfrfreight_prod','ZACPT01','CAPE TOWN','SOUTH AFRICA','Ocean and Air',NULL),(123,'SOUTH AFRICA','edi_cfrfreight_prod','ZADUR01','DURBAN','SOUTH AFRICA','Ocean and Air',NULL),(124,'SOUTH AFRICA','edi_cfrfreight_prod','ZAJNB01','JOHANNESBURG','SOUTH AFRICA','Ocean and Air',NULL),(125,'SOUTH AFRICA','edi_cfrfreight_prod','ZAPLZ01','PORT ELIZABETH','SOUTH AFRICA','Ocean and Air',NULL),(126,'SPAIN','edi_transglory_prod','ESBCN01','BARCELONA','SPAIN','Ocean',NULL),(127,'SPAIN','edi_transglory_prod','ESBIO01','BILBAO','SPAIN','Ocean',NULL),(128,'SPAIN','edi_transglory_prod','ESMAD01','MADRID','SPAIN','Ocean',NULL),(129,'SPAIN','edi_transglory_prod','ESVLC01','VALENCIA','SPAIN','Ocean',NULL),(130,'SPAIN','edi_transglory_prod','ESZAZ01','ZARAGOZA','SPAIN','Ocean',NULL),(131,'SRI LANKA','edi_shipco_prod','LKCMB01','COLOMBO','SRI LANKA','Ocean and Air',NULL),(132,'SWEDEN','edi_shipco_prod','SEGOT01','GOTHENBURG','SWEDEN','Ocean and Air',NULL),(133,'SWITZERLAND','edi_sslswitzerland_prod','CHBSL01','BASEL','SWITZERLAND','Ocean',NULL),(134,'TAIWAN','edi_shipco_prod','TWTPE01','TAIPEI CITY','TAIWAN','Ocean',NULL),(135,'THAILAND','edi_shipco_prod','THBKK01','BANGKOK','THAILAND','Ocean',NULL),(136,'THAILAND','edi_shipco_prod','THBKK02','BANGKOK','THAILAND','Air',NULL),(137,'TUNISIA','edi_transglory_prod','TNRDS01','RADES-TUNIS','TUNISIA','Ocean',NULL),(138,'TUNISIA','edi_transglory_prod','TNSFA01','SFAX','TUNISIA','Ocean',NULL),(139,'TUNISIA','edi_transglory_prod','TNSUS01','SOUSSE','TUNISIA','Ocean',NULL),(140,'TURKEY','edi_shipco_prod','TRIST01','ISTANBUL','TURKEY','Ocean',NULL),(141,'UKRAINE','edi_shipco_prod','UAODS01','ODESSA','UKRAINE','Ocean',NULL),(142,'UNITED ARAB EMIRATES','edi_shipco_prod','AEDXB01','DUBAI','UNITED ARAB EMIRATES','Ocean and Air',NULL),(143,'UNITED ARAB EMIRATES','edi_shipco_prod','AEAUH01','ABU DHABI','UNITED ARAB EMIRATES','Ocean and Air',NULL),(144,'UNITED KINGDOM','edi_shipco_prod','GBLON01','LONDON','UNITED KINGDOM','Ocean and Air',NULL),(145,'USA','edi_shipco_prod','USATL01','ATLANTA','USA','Ocean and Air',NULL),(146,'USA','edi_shipco_prod','USAUS01','AUSTIN','USA','Ocean',NULL),(147,'USA','edi_shipco_prod','USBWI01','BALTIMORE','USA','Ocean and Air',NULL),(148,'USA','edi_shipco_prod','USBOS01','BOSTON','USA','Ocean',NULL),(149,'USA','edi_shipco_prod','USCHS01','CHARLESTON','USA','Ocean and Air',NULL),(150,'USA','edi_shipco_prod','USCLT01','CHARLOTTE','USA','Ocean',NULL),(151,'USA','edi_shipco_prod','USCVG01','CINCINNATI','USA','Ocean',NULL),(152,'USA','edi_shipco_prod','USCLE01','CLEVELAND','USA','Ocean',NULL),(153,'USA','edi_shipco_prod','USCHI01','CHICAGO','USA','Ocean and Air',NULL),(154,'USA','edi_shipco_prod','USDAL01','DALLAS','USA','Ocean',NULL),(155,'USA','edi_shipco_prod','USDEN01','DENVER','USA','Ocean',NULL),(156,'USA','edi_shipco_prod','USDTT01','DETROIT, IL','USA','Ocean',NULL),(157,'USA','edi_shipco_prod','USIAD01','DULLES INT APT/WASHINGTON','USA','Ocean and Air',NULL),(158,'USA','edi_shipco_prod','USELP01','EL PASO','USA','Ocean',NULL),(159,'USA','edi_shipco_prod','USGSP01','GREENVILLE-GREER APT','USA','Ocean and Air',NULL),(160,'USA','edi_shipco_prod','USHOU01','HOUSTON','USA','Ocean and Air',NULL),(161,'USA','edi_shipco_prod','USHSV01','HUNTSVILLE, AL','USA','Ocean',NULL),(162,'USA','edi_shipco_prod','USIND01','INDIANAPOLIS, AL','USA','Ocean',NULL),(163,'USA','edi_shipco_prod','USMKC01','KANSAS CITY, MO','USA','Ocean',NULL),(164,'USA','edi_shipco_prod','USLRD01','LAREDO','USA','Ocean',NULL),(165,'USA','edi_shipco_prod','USLAX01','LOS ANGELES','USA','Ocean',NULL),(166,'USA','edi_shipco_prod','USLAX02','LOS ANGELES','USA','Air',NULL),(167,'USA','edi_shipco_prod','USTXC01','MCALLEN','USA','Ocean',NULL),(168,'USA','edi_shipco_prod','USMEM01','MEMPHIS','USA','Ocean',NULL),(169,'USA','edi_shipco_prod','USMIA01','MIAMI','USA','Ocean and Air',NULL),(170,'USA','edi_shipco_prod','USMSP01','MINNEAPOLIS/ST PAUL APT','USA','Ocean',NULL),(171,'USA','edi_shipco_prod','USBNA01','NASHVILLE','USA','Ocean',NULL),(172,'USA','edi_shipco_prod','USMSY01','NEW ORLEANS','USA','Ocean',NULL),(173,'USA','edi_shipco_prod','USNYC01','NEW YORK','USA','Ocean',NULL),(174,'USA','edi_shipco_prod','USNYC02','NEW YORK','USA','Air',NULL),(175,'USA','edi_shipco_prod','USNYC03','NEW YORK','USA','Corporate',NULL),(176,'USA','edi_shipco_prod','USORF01','NORFOLK','USA','Ocean',NULL),(177,'USA','edi_shipco_prod','USORL01','ORLANDO','USA','Ocean',NULL),(178,'USA','edi_shipco_prod','USPHL01','PHILADELPHIA','USA','Ocean',NULL),(179,'USA','edi_shipco_prod','USPHX01','PHOENIX','USA','Ocean',NULL),(180,'USA','edi_shipco_prod','USPIT01','PITTSBURGH','USA','Ocean',NULL),(181,'USA','edi_shipco_prod','USPDX01','PORTLAND','USA','Ocean',NULL),(182,'USA','edi_shipco_prod','USRDU01','RALEIGH-DURHAM APT','USA','Ocean and Air',NULL),(183,'USA','edi_shipco_prod','USSLC01','SALT LAKE CITY','USA','Ocean',NULL),(184,'USA','edi_shipco_prod','USSAN01','SAN DIEGO','USA','Ocean',NULL),(185,'USA','edi_shipco_prod','USSFO01','SAN FRANCISCO','USA','Ocean and Air',NULL),(186,'USA','edi_shipco_prod','USSCU01','SCITUATE','USA','Ocean',NULL),(187,'USA','edi_shipco_prod','USSEA01','SEATTLE','USA','Ocean and Air',NULL),(188,'USA','edi_shipco_prod','USTUL01','TULSA','USA','Ocean',NULL),(189,'USA','edi_shipco_prod','USBDL01','WINDSOR LOCKS-HARTFORD APT','USA','Ocean',NULL),(190,'URUGUAY','edi_sslconsolidation_prod','UYMVD01','MONTEVIDEO','URUGUAY','Ocean',NULL),(191,'VIETNAM','edi_shipco_prod','VNHAN01','HANOI','VIETNAM','Ocean',NULL),(192,'VIETNAM','edi_shipco_prod','VNSGN01','HO CHI MINH CITY','VIETNAM','Ocean and Air',NULL),(193,'VIETNAM','edi_shipco_prod','VNDAD01','DANANG','VIETNAM','Ocean and Air',NULL),(194,'VIETNAM','edi_shipco_prod','VNHPH01','HAIPHONG','VIETNAM','Ocean and Air',NULL),(198,'ANDORRA',NULL,NULL,NULL,'ANDORRA',NULL,NULL),(199,'AFGHANISTAN',NULL,NULL,'OFICINA A','AFGHANISTAN',NULL,NULL),(200,'ANTIGUA AND BARBUDA',NULL,NULL,NULL,'ANTIGUA AND BARBUDA',NULL,NULL),(201,'ANGUILLA',NULL,NULL,NULL,'ANGUILLA',NULL,NULL),(202,'ALBANIA',NULL,NULL,NULL,'ALBANIA',NULL,NULL),(203,'ARMENIA',NULL,NULL,NULL,'ARMENIA',NULL,NULL),(204,'ANGOLA',NULL,NULL,NULL,'ANGOLA',NULL,NULL),(205,'ANTARCTICA',NULL,NULL,NULL,'ANTARCTICA',NULL,NULL),(206,'AMERICAN SAMOA',NULL,NULL,NULL,'AMERICAN SAMOA',NULL,NULL),(207,'ARUBA',NULL,NULL,NULL,'ARUBA',NULL,NULL),(208,'ALAND',NULL,NULL,'ALAND 1','ALAND',NULL,NULL),(209,'AZERBAIJAN',NULL,NULL,NULL,'AZERBAIJAN',NULL,NULL),(213,'BURKINA FASO',NULL,NULL,NULL,'BURKINA FASO',NULL,NULL),(214,'BULGARIA',NULL,NULL,'SOFIA','BULGARIA',NULL,NULL),(216,'BURUNDI',NULL,NULL,NULL,'BURUNDI',NULL,NULL),(217,'BENIN',NULL,NULL,NULL,'BENIN',NULL,NULL),(218,'SAINT BARTHELEMY',NULL,NULL,NULL,'SAINT BARTHELEMY',NULL,NULL),(219,'BERMUDA',NULL,NULL,NULL,'BERMUDA',NULL,NULL),(220,'BRUNEI',NULL,NULL,NULL,'BRUNEI',NULL,NULL),(221,'BOLIVIA',NULL,'BOSRZ01',NULL,'BOLIVIA',NULL,NULL),(222,'BONAIRE',NULL,NULL,NULL,'BONAIRE',NULL,NULL),(224,'BHUTAN',NULL,NULL,NULL,'BHUTAN',NULL,NULL),(227,'BELARUS',NULL,NULL,NULL,'BELARUS',NULL,NULL),(228,'BELIZE',NULL,NULL,NULL,'BELIZE',NULL,NULL),(229,'COCOS [KEELING] ISLANDS',NULL,NULL,NULL,'COCOS [KEELING] ISLANDS',NULL,NULL),(230,'DEMOCRATIC REPUBLIC OF THE CONGO',NULL,NULL,NULL,'DEMOCRATIC REPUBLIC OF THE CONGO',NULL,NULL),(231,'CENTRAL AFRICAN REPUBLIC',NULL,NULL,NULL,'CENTRAL AFRICAN REPUBLIC',NULL,NULL),(232,'REPUBLIC OF THE CONGO',NULL,NULL,NULL,'REPUBLIC OF THE CONGO',NULL,NULL),(233,'IVORY COAST',NULL,NULL,NULL,'IVORY COAST',NULL,NULL),(234,'COOK ISLANDS',NULL,NULL,NULL,'COOK ISLANDS',NULL,NULL),(235,'CAMEROON',NULL,NULL,NULL,'CAMEROON',NULL,NULL),(236,'COSTA RICA',NULL,NULL,NULL,'COSTA RICA',NULL,NULL),(237,'CUBA',NULL,NULL,'OFICINA LA HABANA','CUBA',NULL,NULL),(238,'CAPE VERDE',NULL,NULL,NULL,'CAPE VERDE',NULL,NULL),(239,'CURACAO',NULL,NULL,NULL,'CURACAO',NULL,NULL),(240,'CHRISTMAS ISLAND',NULL,NULL,NULL,'CHRISTMAS ISLAND',NULL,NULL),(241,'DJIBOUTI',NULL,NULL,NULL,'DJIBOUTI',NULL,NULL),(242,'DOMINICA',NULL,NULL,NULL,'DOMINICA',NULL,NULL),(244,'ERITREA',NULL,NULL,NULL,'ERITREA',NULL,NULL),(245,'ETHIOPIA',NULL,NULL,NULL,'ETHIOPIA',NULL,NULL),(246,'FIDJI',NULL,NULL,NULL,'FIDJI',NULL,NULL),(247,'FALKLAND ISLANDS',NULL,NULL,NULL,'FALKLAND ISLANDS',NULL,NULL),(249,'FAROE ISLANDS',NULL,NULL,NULL,'FAROE ISLANDS',NULL,NULL),(250,'GABON',NULL,NULL,NULL,'GABON',NULL,NULL),(251,'GRENADA',NULL,NULL,NULL,'GRENADA',NULL,NULL),(252,'GEORGIA',NULL,NULL,NULL,'GEORGIA',NULL,NULL),(253,'FRENCH GUIANA',NULL,NULL,NULL,'FRENCH GUIANA',NULL,NULL),(254,'GUERNSEY',NULL,NULL,NULL,'GUERNSEY',NULL,NULL),(255,'GHANA',NULL,NULL,NULL,'GHANA',NULL,NULL),(256,'GIBRALTAR',NULL,NULL,NULL,'GIBRALTAR',NULL,NULL),(257,'GREENLAND',NULL,NULL,NULL,'GREENLAND',NULL,NULL),(258,'GAMBIA',NULL,NULL,NULL,'GAMBIA',NULL,NULL),(259,'GUINEA',NULL,NULL,NULL,'GUINEA',NULL,NULL),(260,'GUADELOUPE',NULL,NULL,NULL,'GUADELOUPE',NULL,NULL),(261,'EQUATORIAL GUINEA',NULL,NULL,NULL,'EQUATORIAL GUINEA',NULL,NULL),(262,'GREECE',NULL,NULL,NULL,'GREECE',NULL,NULL),(264,'GUATEMALA',NULL,NULL,NULL,'GUATEMALA',NULL,NULL),(265,'GUAM',NULL,NULL,NULL,'GUAM',NULL,NULL),(266,'GUINEA-BISSAU',NULL,NULL,NULL,'GUINEA-BISSAU',NULL,NULL),(267,'GUYANA',NULL,NULL,NULL,'GUYANA',NULL,NULL),(268,'HONG KONG',NULL,NULL,NULL,'HONG KONG',NULL,NULL),(269,'HEARD ISLAND AND MCDONALD ISLANDS',NULL,NULL,NULL,'HEARD ISLAND AND MCDONALD ISLANDS',NULL,NULL),(270,'HONDURAS',NULL,NULL,NULL,'HONDURAS',NULL,NULL),(271,'CROATIA',NULL,NULL,NULL,'CROATIA',NULL,NULL),(272,'HAITI',NULL,NULL,NULL,'HAITI',NULL,NULL),(273,'ISLE OF MAN',NULL,NULL,NULL,'ISLE OF MAN',NULL,NULL),(274,'BRITISH INDIAN OCEAN TERRITORY',NULL,NULL,NULL,'BRITISH INDIAN OCEAN TERRITORY',NULL,NULL),(275,'IRAQ',NULL,NULL,NULL,'IRAQ',NULL,NULL),(276,'IRAN',NULL,NULL,NULL,'IRAN',NULL,NULL),(277,'ICELAND',NULL,NULL,NULL,'ICELAND',NULL,NULL),(278,'JERSEY',NULL,NULL,NULL,'JERSEY',NULL,NULL),(279,'JAMAICA',NULL,NULL,NULL,'JAMAICA',NULL,NULL),(280,'JORDAN',NULL,NULL,NULL,'JORDAN',NULL,NULL),(281,'KENYA',NULL,NULL,'MOMBASA','KENYA',NULL,NULL),(282,'KYRGYZSTAN',NULL,NULL,NULL,'KYRGYZSTAN',NULL,NULL),(283,'CAMBODIA',NULL,NULL,NULL,'CAMBODIA',NULL,NULL),(284,'KIRIBATI',NULL,NULL,NULL,'KIRIBATI',NULL,NULL),(285,'COMOROS',NULL,NULL,NULL,'COMOROS',NULL,NULL),(287,'KUWAIT',NULL,NULL,NULL,'KUWAIT',NULL,NULL),(288,'CAYMAN ISLANDS',NULL,NULL,NULL,'CAYMAN ISLANDS',NULL,NULL),(289,'KAZAKHSTAN',NULL,NULL,NULL,'KAZAKHSTAN',NULL,NULL),(290,'LAOS',NULL,NULL,NULL,'LAOS',NULL,NULL),(292,'LIECHTENSTEIN',NULL,NULL,NULL,'LIECHTENSTEIN',NULL,NULL),(293,'LIBERIA',NULL,NULL,NULL,'LIBERIA',NULL,NULL),(294,'LESOTHO',NULL,NULL,NULL,'LESOTHO',NULL,NULL),(295,'LUXEMBOURG',NULL,NULL,NULL,'LUXEMBOURG',NULL,NULL),(296,'LIBYA',NULL,NULL,NULL,'LIBYA',NULL,NULL),(301,'MADAGASCAR',NULL,NULL,NULL,'MADAGASCAR',NULL,NULL),(303,'MACEDONIA',NULL,NULL,NULL,'MACEDONIA',NULL,NULL),(304,'MALI',NULL,NULL,NULL,'MALI',NULL,NULL),(307,'MACAO',NULL,NULL,NULL,'MACAO',NULL,NULL),(312,'MALTA',NULL,NULL,NULL,'MALTA',NULL,NULL),(313,'MAURITIUS',NULL,NULL,NULL,'MAURITIUS',NULL,NULL),(314,'MALDIVES',NULL,NULL,NULL,'MALDIVES',NULL,NULL),(315,'MALAWI',NULL,NULL,NULL,'MALAWI',NULL,NULL),(327,'FRENCH POLYNESIA',NULL,NULL,NULL,'FRENCH POLYNESIA',NULL,NULL),(328,'PAPUA NEW GUINEA',NULL,NULL,NULL,'PAPUA NEW GUINEA',NULL,NULL),(330,'PITCAIRN ISLANDS',NULL,NULL,NULL,'PITCAIRN ISLANDS',NULL,NULL),(331,'PALESTINE',NULL,NULL,NULL,'PALESTINE',NULL,NULL),(332,'PALAU',NULL,NULL,NULL,'PALAU',NULL,NULL),(333,'QATAR',NULL,NULL,NULL,'QATAR',NULL,NULL),(334,'REUNION',NULL,NULL,NULL,'REUNION',NULL,NULL),(336,'RWANDA',NULL,NULL,NULL,'RWANDA',NULL,NULL),(349,'SAO TOME AND PRI­NCIPE',NULL,NULL,NULL,'SAO TOME AND PRI­NCIPE',NULL,NULL),(350,'EL SALVADOR',NULL,NULL,NULL,'EL SALVADOR',NULL,NULL),(355,'CHAD',NULL,NULL,NULL,'CHAD',NULL,NULL),(356,'FRENCH SOUTHERN TERRITORIES',NULL,NULL,NULL,'FRENCH SOUTHERN TERRITORIES',NULL,NULL),(357,'TOGO',NULL,NULL,NULL,'TOGO',NULL,NULL),(359,'TOKELAU',NULL,NULL,NULL,'TOKELAU',NULL,NULL),(360,'EAST TIMOR',NULL,NULL,NULL,'EAST TIMOR',NULL,NULL),(362,'TONGA',NULL,NULL,NULL,'TONGA',NULL,NULL),(365,'TANZANIA',NULL,NULL,'DAR ES SALAAM','TANZANIA',NULL,NULL),(372,'BRITISH VIRGIN ISLANDS',NULL,NULL,NULL,'BRITISH VIRGIN ISLANDS',NULL,NULL),(377,'KOSOVO',NULL,NULL,NULL,'KOSOVO',NULL,NULL),(395,'BARBADOS',NULL,NULL,NULL,'BARBADOS',NULL,NULL),(510,'OMAN',NULL,NULL,NULL,'OMAN',NULL,NULL),(578,'BOSNIA AND HERZEGOVINA',NULL,NULL,NULL,'BOSNIA AND HERZEGOVINA',NULL,NULL),(580,'BANGLADESH',NULL,NULL,NULL,'BANGLADESH',NULL,NULL),(583,'BAHRAIN',NULL,NULL,NULL,'BAHRAIN',NULL,NULL),(591,'BAHAMAS',NULL,NULL,NULL,'BAHAMAS',NULL,NULL),(593,'BOUVET ISLAND',NULL,NULL,NULL,'BOUVET ISLAND',NULL,NULL),(594,'BOTSWANA',NULL,NULL,NULL,'BOTSWANA',NULL,NULL),(611,'WESTERN SAHARA',NULL,NULL,NULL,'WESTERN SAHARA',NULL,NULL),(616,'MICRONESIA',NULL,NULL,NULL,'MICRONESIA',NULL,NULL),(631,'SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS',NULL,NULL,NULL,'SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS',NULL,NULL),(654,'SAINT KITTS AND NEVIS',NULL,NULL,NULL,'SAINT KITTS AND NEVIS',NULL,NULL),(659,'SAINT LUCIA',NULL,NULL,NULL,'SAINT LUCIA',NULL,NULL),(665,'MONACO',NULL,NULL,NULL,'MONACO',NULL,NULL),(666,'MOLDOVA',NULL,NULL,NULL,'MOLDOVA',NULL,NULL),(667,'MONTENEGRO',NULL,NULL,NULL,'MONTENEGRO',NULL,NULL),(668,'SAINT MARTIN',NULL,NULL,NULL,'SAINT MARTIN',NULL,NULL),(670,'MARSHALL ISLANDS',NULL,NULL,NULL,'MARSHALL ISLANDS',NULL,NULL),(673,'MYANMAR [BURMA]',NULL,NULL,NULL,'MYANMAR [BURMA]',NULL,NULL),(674,'MONGOLIA',NULL,NULL,NULL,'MONGOLIA',NULL,NULL),(676,'NORTHERN MARIANA ISLANDS',NULL,NULL,NULL,'NORTHERN MARIANA ISLANDS',NULL,NULL),(677,'MARTINIQUE',NULL,NULL,NULL,'MARTINIQUE',NULL,NULL),(678,'MAURITANIA',NULL,NULL,NULL,'MAURITANIA',NULL,NULL),(679,'MONTSERRAT',NULL,NULL,NULL,'MONTSERRAT',NULL,NULL),(684,'MOZAMBIQUE',NULL,NULL,NULL,'MOZAMBIQUE',NULL,NULL),(685,'NAMIBIA',NULL,NULL,NULL,'NAMIBIA',NULL,NULL),(686,'NEW CALEDONIA',NULL,NULL,NULL,'NEW CALEDONIA',NULL,NULL),(687,'NIGER',NULL,NULL,NULL,'NIGER',NULL,NULL),(688,'NORFOLK ISLAND',NULL,NULL,NULL,'NORFOLK ISLAND',NULL,NULL),(689,'NIGERIA',NULL,NULL,NULL,'NIGERIA',NULL,NULL),(690,'NICARAGUA',NULL,NULL,NULL,'NICARAGUA',NULL,NULL),(691,'NEPAL',NULL,NULL,NULL,'NEPAL',NULL,NULL),(692,'NAURU',NULL,NULL,NULL,'NAURU',NULL,NULL),(693,'NIUE',NULL,NULL,NULL,'NIUE',NULL,NULL),(694,'OMAN',NULL,NULL,NULL,'OMAN',NULL,NULL),(697,'SAINT PIERRE AND MIQUELON',NULL,NULL,NULL,'SAINT PIERRE AND MIQUELON',NULL,NULL),(703,'SERBIA',NULL,NULL,NULL,'SERBIA',NULL,NULL),(705,'SAUDI ARABIA',NULL,NULL,NULL,'SAUDI ARABIA',NULL,NULL),(706,'SOLOMON ISLANDS',NULL,NULL,NULL,'SOLOMON ISLANDS',NULL,NULL),(707,'SEYCHELLES',NULL,NULL,NULL,'SEYCHELLES',NULL,NULL),(708,'SUDAN',NULL,NULL,NULL,'SUDAN',NULL,NULL),(709,'SAINT HELENA',NULL,NULL,NULL,'SAINT HELENA',NULL,NULL),(710,'SVALBARD AND JAN MAYEN',NULL,NULL,NULL,'SVALBARD AND JAN MAYEN',NULL,NULL),(711,'SIERRA LEONE',NULL,NULL,NULL,'SIERRA LEONE',NULL,NULL),(712,'SAN MARINO',NULL,NULL,NULL,'SAN MARINO',NULL,NULL),(713,'SENEGAL',NULL,NULL,NULL,'SENEGAL',NULL,NULL),(714,'SOMALIA',NULL,NULL,NULL,'SOMALIA',NULL,NULL),(715,'SURINAME',NULL,NULL,NULL,'SURINAME',NULL,NULL),(716,'SOUTH SUDAN',NULL,NULL,NULL,'SOUTH SUDAN',NULL,NULL),(719,'SINT MAARTEN',NULL,NULL,NULL,'SINT MAARTEN',NULL,NULL),(720,'SYRIA',NULL,NULL,NULL,'SYRIA',NULL,NULL),(721,'SWAZILAND',NULL,NULL,NULL,'SWAZILAND',NULL,NULL),(722,'TURKS AND CAICOS ISLANDS',NULL,NULL,NULL,'TURKS AND CAICOS ISLANDS',NULL,NULL),(726,'TAJIKISTAN',NULL,NULL,NULL,'TAJIKISTAN',NULL,NULL),(729,'TURKMENISTAN',NULL,NULL,NULL,'TURKMENISTAN',NULL,NULL),(731,'TRINIDAD AND TOBAGO',NULL,NULL,NULL,'TRINIDAD AND TOBAGO',NULL,NULL),(732,'TUVALU',NULL,NULL,NULL,'TUVALU',NULL,NULL),(734,'UGANDA',NULL,NULL,NULL,'UGANDA',NULL,NULL),(735,'U.S. MINOR OUTLYING ISLANDS',NULL,NULL,NULL,'U.S. MINOR OUTLYING ISLANDS',NULL,NULL),(736,'UZBEKISTAN',NULL,NULL,NULL,'UZBEKISTAN',NULL,NULL),(737,'VATICAN CITY',NULL,NULL,NULL,'VATICAN CITY',NULL,NULL),(738,'SAINT VINCENT AND THE GRENADINES',NULL,NULL,NULL,'SAINT VINCENT AND THE GRENADINES',NULL,NULL),(739,'VENEZUELA',NULL,NULL,NULL,'VENEZUELA',NULL,NULL),(741,'U.S. VIRGIN ISLANDS',NULL,NULL,NULL,'U.S. VIRGIN ISLANDS',NULL,NULL),(742,'VANUATU',NULL,NULL,NULL,'VANUATU',NULL,NULL),(743,'WALLIS AND FUTUNA',NULL,NULL,NULL,'WALLIS AND FUTUNA',NULL,NULL),(744,'SAMOA',NULL,NULL,NULL,'SAMOA',NULL,NULL),(746,'YEMEN',NULL,NULL,NULL,'YEMEN',NULL,NULL),(747,'MAYOTTE',NULL,NULL,NULL,'MAYOTTE',NULL,NULL),(748,'ZAMBIA',NULL,NULL,NULL,'ZAMBIA',NULL,NULL),(749,'ZIMBABWE',NULL,NULL,NULL,'ZIMBABWE',NULL,NULL),(750,NULL,NULL,NULL,'OFICINA B','AFGHANISTAN',NULL,NULL),(751,NULL,NULL,NULL,'ALAND 2','ALAND',NULL,NULL),(752,NULL,NULL,NULL,'ALAND 3','ALAND',NULL,NULL),(753,'ALAND',NULL,NULL,'A 4','ALAND',NULL,NULL),(754,'TAIWAN',NULL,NULL,'KEELUNG','TAIWAN',NULL,NULL),(755,'TURKEY',NULL,NULL,'IZMIR','TURKEY',NULL,NULL),(756,'PHILIPPINES',NULL,NULL,'CEBU','PHILIPPINES',NULL,NULL),(757,'ARGENTINA',NULL,NULL,'CONCORDIA','ARGENTINA',NULL,NULL);
/*!40000 ALTER TABLE `wwa_offices_ultimate` ENABLE KEYS */;
UNLOCK TABLES;
/*!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 2025-07-25 21:44:54
