-- 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 `referencias_impo_interteam_n`
--

DROP TABLE IF EXISTS `referencias_impo_interteam_n`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `referencias_impo_interteam_n` (
  `idreferencias_impo_interteam` double NOT NULL AUTO_INCREMENT,
  `referencia` varchar(255) NOT NULL DEFAULT '',
  `año` varchar(255) NOT NULL DEFAULT '',
  `contador` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`idreferencias_impo_interteam`)
) ENGINE=InnoDB AUTO_INCREMENT=414 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `referencias_impo_interteam_n`
--

LOCK TABLES `referencias_impo_interteam_n` WRITE;
/*!40000 ALTER TABLE `referencias_impo_interteam_n` DISABLE KEYS */;
INSERT INTO `referencias_impo_interteam_n` VALUES (3,'ANR-ATM-SSC','2006','1'),(4,'ANR-VER-SSC','2006','1'),(11,'HAM-VER-SSL','2006','1'),(12,'HK-ZLLO-AQL','2006','1'),(13,'HK-ZLLO-CHT','2006','1'),(14,'HK-ZLLO-GLW','2006','1'),(15,'HK-ZLLO-HT','2006','1'),(16,'HK-ZLLO-NPIL','2006','1'),(17,'HK-ZLLO-OWS','2006','1'),(18,'JNPT-VER-WSA','2007','1'),(20,'KEE-ZLLO-AQL','2006','1'),(21,'KEE-ZLLO-HT','2006','1'),(22,'KEE-ZLLO-GLW','2006','1'),(23,'KEE-ZLO-HT','2006','1'),(24,'KEE-ZLLO-NPIL','2006','1'),(25,'KEE-ZLLO-DPH','2006','1'),(26,'KEE-ZLLO-SHP','2006','1'),(27,'PUS-ZLLO-GLW','2006','1'),(28,'PUS-ZLLO-HT','2006','1'),(30,'PUS-ZLLO-NPIL','2006','1'),(31,'PUS-ZLLO-OWS','2006','1'),(32,'RGR-VER-ALLINK','2006','1'),(37,'SHA-ZLLO-CHT','2006','1'),(38,'SHA-ZLLO-GLW','2006','1'),(39,'SHA-ZLLO-HT','2006','1'),(40,'SHA-ZLLO-NPIL','2006','1'),(41,'SHA-ZLLO-OWS','2006','1'),(42,'SSZ-ATM-ALLINK','2006','1'),(43,'SSZ-VER-ALLINK','2006','1'),(44,'TXG-ZLLO-AQL','2006','1'),(45,'TXG-ZLLO-CHT','2006','1'),(46,'TXG-ZLLO-GLW','2006','1'),(47,'TXG-ZLLO-HT','2006','1'),(48,'TXG-ZLLO-NPIL','2006','1'),(49,'TXG-ZLLO-OWS','2006','1'),(50,'TXG-ZLLO-SHP','2006','1'),(51,'SHIPCO ATM','2006','1'),(55,'BRE - VER - SSL','2006','1'),(56,'BRE - ATM - SSL','2006','1'),(57,'RTM-VER-BOX','2006','1'),(59,'BUE-ATM-SSL','2008','1'),(60,'JNPT-VER-MIR','2006','1'),(62,'PUS-ZLLO-WPC','2006','1'),(64,'HK-ZLLO-AMF','2006','1'),(65,'CTG-VER-MAHE','2006','1'),(66,'CTG-ATM-MAHE','2006','1'),(67,'CTG-ZLLO-MAHE','2006','1'),(69,'BUE-VER-SSL','2008','1'),(71,'ANR-VER-BOX','2006','1'),(74,'IST-VER-UNI','2006','1'),(75,'PUS-ZLLO-WDA','2006','1'),(76,'HK-ZLLO-SHIP','2006','1'),(78,'BRE-VER-FRANS','2006','1'),(79,'JNPT-VER-NLS','2006','1'),(81,'RTM-VER-SSC','2006','1'),(83,'SHA-ZLLO-AMASS','2006','1'),(84,'XIA-ZLLO-MAR','2006','1'),(85,'LEH-VER-BOX','2006','1'),(87,'BRV-VER-GATE','2006','1'),(88,'TSN-ZLLO-TCL','2006','1'),(89,'JNPT-MZO-WSA','2006','1'),(90,'VAP-ZLLO-SSL','2009','1'),(92,'RTM-VER-SACO','2006','1'),(93,'VAP-ZLLO-S&F','2006','1'),(94,'HAM-ATM-GATE','2006','1'),(96,'VZLA-VER-PAN','2006','1'),(97,'JAPON-ZLLO-OCL','2006','1'),(98,'PAN-VE-ZLLO','2006','1'),(99,'VAP-VER-SHIPCO','2006','1'),(100,'JNPT-ZLLO-MAG','2006','1'),(101,'TAO-ZLLO-JAG','2006','1'),(102,'MVD-VER-ABC','2006','1'),(104,'JNPT-ZLLO-WSA','2007','1'),(105,'THM-VER-UNS','2006','1'),(106,'JNPT-ZLLO-MIR','2006','1'),(108,'PUS-ZLLO-HUM','2006','1'),(109,'SIN-ZLLO-EUR','2006','1'),(110,'FRA-MEX-AEREO-SSL','2011','1'),(111,'BRE-ATM-GATE','2006','1'),(112,'SEL-LAX-MEX-WOO','2006','1'),(113,'GATE-FRA-MEX','2006','1'),(114,'HK-ZLLO-MAR','2006','1'),(115,'JNPT-ALT-WSA','2006','1'),(116,'FUZ-ZLLO-HON','2006','1'),(117,'THA-ZLLO-CRY','2006','1'),(118,'CHI-ZLLO-SHEN','2006','1'),(119,'PUS-ZLLO-TRU','2006','-'),(120,'GOT-MEX-AEREO','2006','1'),(121,'NIN-ZLLO-BON','2006','1'),(122,'HK-ZLLO-VAN','2007','1'),(123,'SHE-ZLLO-HT','2007','1'),(124,'SIN-ZLLO-CRY','2007','1'),(125,'SIN-VER-CRY','2007','1'),(126,'JNPT-LAC-WSA','2007','1'),(127,'JOHN - FRA - MEX','2007','1'),(128,'THA-ZLLO-AMF','2007','1'),(129,'UK-VER-UNS','2007','*'),(130,'UK-ATM-UNS','2007','*'),(131,'MIL-MEX-CL','2006','1'),(132,'BUE-MEX-CFS','2006','1'),(133,'ROS-MEX-OVS','2006','1'),(134,'HK-MEX-HT','2007','1'),(135,'BOM-MEX-AEREO-WSA','2007','1'),(136,'ANR-VER-SHIPCO','2007','1'),(137,'SHA-ZLLO-HUM','2007','1'),(138,'RTM-VER-PVY','2007','1'),(139,'ANR-VER-PVY','2007','1'),(140,'FIN-MEX-AEREO-SSL','2007','1'),(141,'MUM-MEX-ZEU','2007','1'),(143,'HGH-MEX-AEREO-GLW','2007','1'),(144,'CMB-MEX-AEREO-MIR','2007','1'),(145,'LEH-VER-MMCL','2007','1'),(146,'CHEN-ZLLO-UNI','2007','1'),(147,'CPH-VER-SHIPCO','2007','1'),(148,'FIN-VER-SHIPCO','2007','1'),(149,'HK-ZLLO-SHEN','2007','1'),(151,'HOCH-ZLLO-VIN','2007','1'),(152,'MAL-ZLLO-WSA','2007','1'),(153,'IST-VER-JMS','2007','001'),(154,'USA-VER-SHI','2007','001'),(155,'LAG-MEX-SHIP','2007','1'),(156,'MIA-MEX-SHIP','2007','1'),(157,'STL-MIA-MEX-SHIP','2007','1'),(159,'PAN-VER-PCS','07','1'),(160,'UK-VER-TGF','2007','001'),(162,'HK-ZLLO-AE','2007','1'),(163,'NRT-MEX-AEREO-HT','2008','1'),(164,'USA-MEX-SHI','2008','1'),(165,'CPH-MEX-AEREO-SSL','2008','1'),(166,'CHEN-VER-UNI','2008','1'),(167,'KAR-ZLLO-DYN','2008','1'),(168,'USA-MOR-SHI','2008','1'),(171,'VAP-ZLLO-MG','2008','1'),(172,'USA-MZO-SHI','2008','001'),(173,'UK-VER-SHI','2008','001'),(175,'SHA-LC-HT','2008','1'),(176,'YAN-ZLLO-HT','2008','1'),(177,'VAP-ZLLO-SHI','2008','1'),(178,'VAP-ZLLO-SHIPCO','2008','001'),(179,'JNPT-ZLLO-TICC','2008','1'),(180,'CHI-ZLLO-HT','2008','1'),(181,'KOL-ZLLO-TTS','2008','1'),(182,'JNPT-ZLLO-TTS','2008','1'),(183,'KEE-LC-HT','2008','001'),(184,'DUR-ZLLO-CFR','2008','1'),(185,'JNPT-VER-TTS','2008','1'),(186,'BRV-ATM-SSL','2011','1'),(187,'BKK-ZLLO-SHIP','2008','1'),(188,'KAR-LAC-DYN','2008','1'),(189,'MUC-GDL-AEREO-SSL','2008','1'),(191,'XIA-ZLLO-AMASS','2008','1'),(192,'YOK-ZLLO-GTC','2008','1'),(193,'CAL-ZLLO-SSL','08','1'),(194,'ALY-VER-MESCO','2008','01'),(195,'VAP-VER-AEREO-MG','2008','1'),(197,'CHEN-ZLLO-SUR','2008','1'),(198,'CHEN-ALT-MIR','2008','1'),(199,'SUR-LAX-MEX-AEREO-SHIP','2008','1'),(200,'IZM-VER-UNI','2008','001'),(201,'VAP-MEX-AEREO-NEW','2009','1'),(202,'NIN-ZLLO-HT','2009','1'),(203,'BCN-VER-TGY','2009','001'),(204,'QIN-ZLLO-PAN','2011','1'),(205,'GOA-ATM-CM','2009','1'),(206,'GOA-VER-CM','09','1'),(207,'INC-LAX-MEX-AEREO-SHIP','2009','1'),(208,'SIN-ZLLO-SHIP','2009','1'),(209,'COC-ZLLO-TTS','2009','1'),(210,'BRV-ZLLO-SSL','2011','1'),(211,'CHI-LAC-HT','2009','1'),(212,'ALL POL  MZLLO','2010','1'),(213,'ALL POL VCZ','2009','1'),(214,'ALL POL ATM','2009','1'),(215,'BUE-MEX-AEREO-MAHE','2009','1'),(216,'SCL-MEX-AEREO-SHIP','2009','1'),(217,'YAN-PRO-HT','2009','1'),(218,'BIL-VER-TGY','2009','001'),(219,'JNB-MEX-CFR','2009','001'),(220,'NIN-ZLLO-PAN','2009','1'),(221,'USA-ATM-SHI','2009','001'),(222,'USA-PGO-SHI','2009','001'),(223,'MIL-MEX-CM','2009','001'),(224,'MIL-MEX-CFR','2009','1'),(225,'USA-LZC-SHI','2009','001'),(226,'SHA-ZLLO-TRA','2009','1'),(227,'MYC-MEX-AIR-SSL','2009','1'),(228,'MUC-MEX-AIR-SSL','2009','1'),(229,'SJCR-MEX-AIR-NAZEL','09','1'),(230,'SAN-MEX-AIR-SHIP','2010','1'),(231,'USA-TAM-SHI','2009','001'),(232,'HK-ZLLO-WIN','2009','1'),(233,'CHI-ZLLO-WIN','2009','1'),(234,'CHEN-ZLLO-TTS','2009','1'),(235,'HK-MEX-AIR-SHIP','2009','1'),(236,'SHA-MEX-AIR-HT','09','1'),(237,'PAN-MEX-AIR-SSL','2009','01'),(238,'SHE-ZLLO-SHIP','2012','1'),(239,'BRV-VER-SSL','2009','1'),(240,'VIET-ZLLO-EVE','2010','01'),(241,'BIL-PGO-TGY ','2010','001'),(242,'SHA-ZLLO-SHIP','10','001'),(243,'YOK-ZLLO-SHIP','2010','1'),(244,'DAL-ZLLO-PAN','2010','1'),(245,'PUS-MEX-AIR-GLW','2010','1'),(246,'VLC-VER-TGY','2010','1'),(247,'BCN-ATM-TGY ','2011','001'),(248,'JNPT-VER-CPW','2010','001'),(249,'JNPT-ZLLO-CPW','2010','2010'),(250,'NASH-VER-CPW ','2010','1'),(251,'CHI-ZLLO-SHIP','2010','1'),(252,'VLC-ATM-TGY ','2010','1'),(253,'CHEN-VER-CPW','2010','1'),(255,'NASH-ZLLO-CPW','2010','1'),(256,'IST-ATM-MGS','2010','1'),(257,'SHA-PRO-HT','2010','1'),(258,'HPG-ZLLO-ICL','2010','001'),(259,'NASH-ZLLO-TGL','2010','1'),(260,'SEK-ZLLO-HT','2010','1'),(261,'ALL POL A-V RO','2010','01'),(262,'ALL POL ZLO RO','2010','01'),(263,'ALL POL A-V','2010','01'),(264,'ALL POL ZLO','2010','01'),(265,'ALL POL','2010','01'),(266,'USA-MEX-AEREO-SHIP','2010','001'),(267,'CTG-VER MAHE RO','2010','1'),(268,'CAL-ZLO-SSL RO','2010','0'),(269,'ALL POL RO','2010','1'),(270,'KEE-ZLO-HT RO','2010','1'),(271,'HAM A-V','2010','1'),(272,'SSZ A-V','2010','1'),(273,'VAP-MEX-AEREO-SHIP','2010','01'),(274,'BUE-VER-SSL RO','2010','1'),(275,'GOA A-V','2010','1'),(276,'GOA A-V RO','2010','1'),(277,'BCN-VER','2010','1'),(278,'BCN-VER RO','2010','1'),(279,'NO VALIDO PARA TODOS','2010','01'),(280,'NASH-ATM-CPW','2010','1'),(281,'NIN-MEX-AEREO-HT','2010','01'),(282,'KAR-ZLLO-GM','2010','01'),(283,'UK-ATM-SHI','2010','001'),(284,'PC-VER-PTV','2010','001'),(285,'BUE- A-V SSL','2011','01'),(286,'RTM A-V','2011','1'),(287,'BRV-A-V-SSL','2011','1'),(288,'NASH-LC-CPW','2011','001'),(289,'ALL-VER-UPS','2011','01'),(290,'KEE-MEX-AEREO-HT','2011','1'),(291,'XIA-MEX-AIR-HT','2011','01'),(292,'NASH-VER-TGL','2011','01'),(293,'LPV_OTROS','2011','1'),(294,'BRE Y BRV- ALT Y VER','2011','01'),(295,'QIN-MEX-AIR-PAN','2011','01'),(296,'GRE-VER-ARI','2011','001'),(297,'NIN-MEX-AEREO-PAN','2011','1'),(298,'SHA-ZLLO-PAN','2011','1'),(299,'SYD-MEX-AIR-AGS','2011','01'),(300,'NIN-ZLLO-SHIP','2011','01'),(301,'PIR-VER-ARI','2011','01'),(302,'SHA-ENS-HT','2011','01'),(303,'BUD-MEX-AIR-SSL','2011','01'),(304,'LIM-MEX-AIR-UNX','2011','01'),(305,'BCN A-V TGY','2011','1'),(306,'HK-ZLLO-ICL','2011','01'),(307,'BUE-MEX-AIR-SSL','2011','01'),(308,'BRE & HAM - ALT & VER','2011','1'),(309,'MIL A-V CB','1','1'),(310,'ALL INDIA- VER& ZLO TEAMGLOBAL','2011','01'),(311,'PAN-MEX-AIR-PCS','11','001'),(312,'THA-ZLLO-SHIP','2012','01'),(313,'BCN&VAL-VER TGY','2012','1'),(314,'PUS-ZLLO-MTM','2012','01'),(315,'HAM/ BRE-A-V','2012','01'),(316,'ANR-A-V','2012','01'),(317,'GYE-ZLLO-SSL','2012','01'),(318,'MEL-ZLLO-AGS','2012','01'),(319,'AEREO MEL-MEX-AGS','2012','01'),(320,'JKT-ZLLO-IDD','2012','01'),(321,'SHA-VER-HT','2012','01'),(322,'ASIA-ZLLO-STAR','2012','01'),(323,'SHA-ZLLO-SINO','2012','01'),(324,'BCN-MEX-TGY ','2012','001'),(325,'MAD-MEX-TGY','2012','001'),(326,'HK-MEX-AIR-HT','2012','1'),(327,'SSZ-VER-ATM-ALLINK','2012','01'),(328,'NIN-ZLLO-GCI','2013','01'),(329,'MIL-CUN-CM','2012','001'),(330,'MIL-CUN-CAD','2012','001'),(331,'BAH-MEX-AIR-SSL','2012','01'),(332,'TERR-IMP-IND','2012','01'),(333,'IZM-ALT-STG','2012','01'),(334,'HAM ZLO','2012','1'),(335,'HAM ALL POL','2012','01'),(336,'IZM-ZLLO-STG','2012','001'),(337,'PK-VER-DYN','2012','01'),(338,'KAR-VER-DYN','2012','01'),(339,'KEE-ENS-HT','2012','001'),(340,'ZUR-MEX-SSC ','2012','01'),(341,'BOG-MEX-MAHE','2012','01'),(342,'SHA-MEX-AIR-SHIP','2012','1'),(343,'AIR PVG-LAX-MEX','2013','001'),(344,'SEA - AIR CARGO','13','001'),(345,'THAZLO-FCL-SHI','2013','01'),(346,'THAZLO-FCL-AMF','2013','01'),(347,'SHAZLO-FCL-SINO','2013','01'),(348,'NASHZLO-FCL-CPW','2013','01'),(349,'NASHVER-FCL-CPW','2013','01'),(350,'ASIAZLO-FCL-STAR','2013','01'),(351,'JKTZLO-FCL-IDD','2013','01'),(352,'IZMZLO-FCL-STG','2013','01'),(353,'PENZLO-FCL-CPW','2013','01'),(354,'USAVER-FCL-SHI','2013','01'),(355,'USAZLO-FCL-SHI','2013','01'),(356,'USAATM-FCL-SHI','2013','01'),(357,'KEEZLO-FCL-HT','2013','01'),(358,'LIOVER-FCL-NAZEL','2013','01'),(359,'AIR MEX ','2013','0001'),(360,'AIR SFO-MEX','2013','001'),(361,'SHAZLO-FCL-SHI','2013','001'),(362,'SIN-ZLO-GLINK','2013','01'),(363,'CHITT-ZLO-KASE','2013','01'),(364,'SHAZLO-FCL-HT','2013','001'),(365,'ASIAVER-FCL-STAR','2013','001'),(366,'ANRATM-FCL-SSL','2013','001'),(367,'QIN-ZLLO-SHIP','2013','001'),(368,'PUSZLO-FCL-KOR','2013','001'),(369,'HAM & UK- VER & ALT','2013','1'),(370,'HK-ZLLO-SHI','2013','001'),(371,'ANRVER-FCL-SSL','2013','001'),(372,'PKG-ZLO-HT','2013','001'),(373,'NASHZLO-FCL-TGL','2013','001'),(374,'XIN-ZLO-TCI','2013','01'),(375,'NINZLO-FCL-HT','2013','001'),(376,'SJUVER-FCL-DFF','13','01'),(377,'BRVATM-FCL-SSL','2013','001'),(378,'FRE-BUS-ZLO','2013','01'),(379,'SHAENS-FCL-HT','2013','001'),(380,'SHAZLO-FCL-SHIP','2013','001'),(381,'VLCATM-FCL-TGY','2013','001'),(382,'ANRVER-FCL-SSC','2013','001'),(383,'BCNVER-FCL-TGY','2013','001'),(384,'PUSZLO-FCL-GLW','2013','001'),(385,'CTGATM-FCL-MAHE','2013','01'),(386,'SPEFCL-VER-CM','2013','01'),(387,'ASIAZLO-FCL-HT','2013','001'),(388,'SHEFCL-ZLO-SHIP','2013','001'),(389,'GOAVCR-FCL-CM','2013','001'),(390,'GOAVER-FCL-CM','2013','001'),(391,'PKG-ZLO-WLS','2013','01'),(392,'SSZVER-FCL-ALLINK','2013','001'),(401,'ESPECIAL ESCALONADA','2015','1'),(402,'MIL- VER RO','2015','1'),(403,'VLC- VER RO','2015','1'),(404,'SS0215SP01680','2015','1'),(405,'ALL POL ASIA','2015','1'),(406,'BANGALORE-VER TEAMGLOBAL','2016','1'),(407,'BANGALORE-ZLO TEAMGLOBAL-GOLDWAY','2016','1'),(408,'ALL POL LZC','2017','1'),(409,'ALL POL LZC RO','2017','1'),(410,'ALL POL A-V-M RO','2017','1'),(411,'MIL- ESP- HAM- BRE   ALT/VER','2017','1'),(412,'ESPECIAL STISHA FF USD ZLO CIF','2018','1'),(413,'SHA-ZLLO-JAG','2018','1');
/*!40000 ALTER TABLE `referencias_impo_interteam_n` 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:49:19
