-- MySQL dump 10.13  Distrib 8.0.31, for Win64 (x86_64)
--
-- Host: 35.225.233.105    Database: 2018_2019
-- ------------------------------------------------------
-- 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`
--

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

--
-- Dumping data for table `referencias_impo_interteam`
--

LOCK TABLES `referencias_impo_interteam` WRITE;
/*!40000 ALTER TABLE `referencias_impo_interteam` DISABLE KEYS */;
INSERT INTO `referencias_impo_interteam` VALUES (3,'ANR-ATM-SSC','2006','1',NULL,NULL,NULL),(4,'ANR-VER-SSC','2006','1',NULL,NULL,NULL),(11,'HAM-VER-SSL','2006','1',NULL,NULL,NULL),(14,'HK-ZLLO-GLW','2006','1',NULL,NULL,NULL),(15,'HK-ZLLO-HT','2006','1',NULL,NULL,NULL),(18,'JNPT-VER-WSA','2007','1',NULL,NULL,NULL),(20,'KEE-ZLLO-AQL','2006','1',NULL,NULL,NULL),(21,'KEE-ZLLO-HT','2006','1',NULL,NULL,NULL),(22,'KEE-ZLLO-GLW','2006','1',NULL,NULL,NULL),(23,'KEE-ZLO-HT','2006','1',NULL,NULL,NULL),(24,'KEE-ZLLO-NPIL','2006','1',NULL,NULL,NULL),(25,'KEE-ZLLO-DPH','2006','1',NULL,NULL,NULL),(26,'KEE-ZLLO-SHIP','2006','1',NULL,NULL,NULL),(27,'PUS-ZLLO-GLW','2006','1',NULL,NULL,NULL),(28,'PUS-ZLLO-HT','2006','1',NULL,NULL,NULL),(30,'PUS-ZLLO-NPIL','2006','1',NULL,NULL,NULL),(31,'PUS-ZLLO-OWS','2006','1',NULL,NULL,NULL),(32,'RGR-VER-ALLINK','2006','1',NULL,NULL,NULL),(37,'SHA-ZLLO-CHT','2006','1',NULL,NULL,NULL),(38,'SHA-ZLLO-GLW','2006','1',NULL,NULL,NULL),(39,'SHA-ZLLO-HT','2006','1',NULL,NULL,NULL),(40,'SHA-ZLLO-NPIL','2006','1',NULL,NULL,NULL),(41,'SHA-ZLLO-OWS','2006','1',NULL,NULL,NULL),(42,'SSZ-ATM-ALLINK','2006','1',NULL,NULL,NULL),(43,'SSZ-VER-ALLINK','2006','1',NULL,NULL,NULL),(44,'TXG-ZLLO-AQL','2006','1',NULL,NULL,NULL),(45,'TXG-ZLLO-CHT','2006','1',NULL,NULL,NULL),(46,'TXG-ZLLO-GLW','2006','1',NULL,NULL,NULL),(47,'TXG-ZLLO-HT','2006','1',NULL,NULL,NULL),(48,'TXG-ZLLO-NPIL','2006','1',NULL,NULL,NULL),(49,'TXG-ZLLO-OWS','2006','1',NULL,NULL,NULL),(50,'TXG-ZLLO-SHP','2006','1',NULL,NULL,NULL),(51,'SHIPCO ATM','2006','1',NULL,NULL,NULL),(57,'RTM-VER-BOX','2006','1',NULL,NULL,NULL),(59,'BUE-ATM-SSL','2008','1',NULL,NULL,NULL),(60,'JNPT-VER-MIR','2006','1',NULL,NULL,NULL),(62,'PUS-ZLLO-WPC','2006','1',NULL,NULL,NULL),(64,'HK-ZLLO-AMF','2006','1',NULL,NULL,NULL),(65,'CTG-VER-MAHE','2006','1',NULL,NULL,NULL),(66,'CTG-ATM-MAHE','2006','1',NULL,NULL,NULL),(69,'BUE-VER-SSL','2008','1',NULL,NULL,NULL),(75,'PUS-ZLLO-WDA','2006','1',NULL,NULL,NULL),(76,'HK-ZLLO-SHIP','2006','1',NULL,NULL,NULL),(79,'JNPT-VER-NLS','2006','1',NULL,NULL,NULL),(81,'RTM-VER-SSC','2006','1',NULL,NULL,NULL),(83,'SHA-ZLLO-AMASS','2006','1',NULL,NULL,NULL),(84,'XIA-ZLLO-MAR','2006','1',NULL,NULL,NULL),(85,'LEH-VER-BOX','2006','1',NULL,NULL,NULL),(88,'TSN-ZLLO-TCL','2006','1',NULL,NULL,NULL),(89,'JNPT-MZO-WSA','2006','1',NULL,NULL,NULL),(90,'VAP-ZLLO-SSL','2009','1',NULL,NULL,NULL),(92,'RTM-VER-SACO','2006','1',NULL,NULL,NULL),(93,'VAP-ZLLO-S&F','2006','1',NULL,NULL,NULL),(96,'VZLA-VER-PAN','2006','1',NULL,NULL,NULL),(98,'PAN-VE-ZLLO','2006','1',NULL,NULL,NULL),(99,'VAP-VER-SHIPCO','2006','1',NULL,NULL,NULL),(100,'JNPT-ZLLO-MAG','2006','1',NULL,NULL,NULL),(101,'TAO-ZLLO-JAG','2006','1',NULL,NULL,NULL),(102,'MVD-VER-ABC','2006','1',NULL,NULL,NULL),(104,'JNPT-ZLLO-WSA','2007','1',NULL,NULL,NULL),(105,'THM-VER-UNS','2006','1',NULL,NULL,NULL),(106,'JNPT-ZLLO-MIR','2006','1',NULL,NULL,NULL),(108,'PUS-ZLLO-HUM','2006','1',NULL,NULL,NULL),(109,'SIN-ZLLO-EUR','2006','1',NULL,NULL,NULL),(112,'SEL-LAX-MEX-WOO','2006','1',NULL,NULL,NULL),(113,'GATE-FRA-MEX','2006','1',NULL,NULL,NULL),(115,'JNPT-ALT-WSA','2006','1',NULL,NULL,NULL),(117,'THA-ZLLO-CRY','2006','1',NULL,NULL,NULL),(118,'CHI-ZLLO-SHEN','2006','1',NULL,NULL,NULL),(119,'PUS-ZLLO-TRU','2006','-',NULL,NULL,NULL),(121,'NIN-ZLLO-BON','2006','1',NULL,NULL,NULL),(123,'SHE-ZLLO-HT','2007','1',NULL,NULL,NULL),(124,'SIN-ZLLO-CRY','2007','1',NULL,NULL,NULL),(125,'SIN-VER-CRY','2007','1',NULL,NULL,NULL),(126,'JNPT-LAC-WSA','2007','1',NULL,NULL,NULL),(127,'JOHN - FRA - MEX','2007','1',NULL,NULL,NULL),(128,'BKK-ZLO-AMF','2007','1',NULL,NULL,NULL),(129,'UK-VER-UNS','2007','*',NULL,NULL,NULL),(130,'UK-ATM-UNS','2007','*',NULL,NULL,NULL),(131,'MIL-MEX-CL','2006','1',NULL,NULL,NULL),(133,'ROS-MEX-OVS','2006','1',NULL,NULL,NULL),(136,'ANR-VER-SHIPCO','2007','1',NULL,NULL,NULL),(137,'SHA-ZLLO-HUM','2007','1',NULL,NULL,NULL),(138,'RTM-VER-PVY','2007','1',NULL,NULL,NULL),(139,'ANR-VER-PVY','2007','1',NULL,NULL,NULL),(141,'MUM-MEX-ZEU','2007','1',NULL,NULL,NULL),(145,'LEH-VER-MMCL','2007','1',NULL,NULL,NULL),(147,'CPH-VER-SHIPCO','2007','1',NULL,NULL,NULL),(152,'MAL-ZLLO-WSA','2007','1',NULL,NULL,NULL),(154,'USA-VER-SHI','2007','001',NULL,NULL,NULL),(155,'LAG-MEX-SHIP','2007','1',NULL,NULL,NULL),(156,'MIA-MEX-SHIP','2007','1',NULL,NULL,NULL),(157,'STL-MIA-MEX-SHIP','2007','1',NULL,NULL,NULL),(159,'PAN-VER-PCS','07','1',NULL,NULL,NULL),(160,'UK-VER-TGF','2007','001',NULL,NULL,NULL),(163,'NRT-MEX-AEREO-HT','2008','1',NULL,NULL,NULL),(164,'USA-MEX-SHI','2008','1',NULL,NULL,NULL),(167,'KAR-ZLLO-DYN','2008','1',NULL,NULL,NULL),(168,'USA-MOR-SHI','2008','1',NULL,NULL,NULL),(171,'VAP-ZLLO-MG','2008','1',NULL,NULL,NULL),(172,'USA-MZO-SHI','2008','001',NULL,NULL,NULL),(173,'UK-VER-SHI','2008','001',NULL,NULL,NULL),(175,'SHA-LC-HT','2008','1',NULL,NULL,NULL),(176,'YAN-ZLLO-HT','2008','1',NULL,NULL,NULL),(177,'VAP-ZLLO-SHI','2008','1',NULL,NULL,NULL),(178,'VAP-ZLLO-SHIPCO','2008','001',NULL,NULL,NULL),(179,'JNPT-ZLLO-TICC','2008','1',NULL,NULL,NULL),(180,'CHI-ZLLO-HT','2008','1',NULL,NULL,NULL),(181,'KOL-ZLLO-TTS','2008','1',NULL,NULL,NULL),(182,'JNPT-ZLLO-TTS','2008','1',NULL,NULL,NULL),(183,'KEE-LC-HT','2008','001',NULL,NULL,NULL),(185,'JNPT-VER-TTS','2008','1',NULL,NULL,NULL),(186,'BRV-ATM-SSL','2011','1',NULL,NULL,NULL),(187,'BKK-ZLO-SHIP','2008','1',NULL,NULL,NULL),(188,'KAR-LAC-DYN','2008','1',NULL,NULL,NULL),(189,'MUC-GDL-AEREO-SSL','2008','1',NULL,NULL,NULL),(191,'XIA-ZLLO-AMASS','2008','1',NULL,NULL,NULL),(192,'YOK-ZLLO-GTC','2008','1',NULL,NULL,NULL),(193,'CAL-ZLLO-SSL','08','1',NULL,NULL,NULL),(195,'VAP-VER-AEREO-MG','2008','1',NULL,NULL,NULL),(199,'SUR-LAX-MEX-AEREO-SHIP','2008','1',NULL,NULL,NULL),(201,'VAP-MEX-AEREO-NEW','2009','1',NULL,NULL,NULL),(202,'NIN-ZLLO-HT','2009','1',NULL,NULL,NULL),(203,'BCN-VER-TGY','2009','001',NULL,NULL,NULL),(204,'QIN-ZLLO-PAN','2011','1',NULL,NULL,NULL),(205,'GOA-ATM-CM','2009','1',NULL,NULL,NULL),(206,'GOA-VER-CM','09','1',NULL,NULL,NULL),(208,'SIN-ZLLO-SHIP','2009','1',NULL,NULL,NULL),(212,'ALL POL  MZLLO','2010','1',NULL,NULL,NULL),(213,'ALL POL VCZ','2009','1',NULL,NULL,NULL),(214,'ALL POL ATM','2009','1',NULL,NULL,NULL),(216,'SCL-MEX-AEREO-SHIP','2009','1',NULL,NULL,NULL),(217,'YAN-PRO-HT','2009','1',NULL,NULL,NULL),(219,'JNB-MEX-CFR','2009','001',NULL,NULL,NULL),(220,'NIN-ZLLO-PAN','2009','1',NULL,NULL,NULL),(221,'USA-ATM-SHI','2009','001',NULL,NULL,NULL),(222,'USA-PGO-SHI','2009','001',NULL,NULL,NULL),(223,'MIL-MEX-CM','2009','001',NULL,NULL,NULL),(224,'MIL-MEX-CFR','2009','1',NULL,NULL,NULL),(225,'USA-LZC-SHI','2009','001',NULL,NULL,NULL),(226,'SHA-ZLLO-TRA','2009','1',NULL,NULL,NULL),(227,'MYC-MEX-AIR-SSL','2009','1',NULL,NULL,NULL),(228,'MUC-MEX-AIR-SSL','2009','1',NULL,NULL,NULL),(229,'SJCR-MEX-AIR-NAZEL','09','1',NULL,NULL,NULL),(230,'SAN-MEX-AIR-SHIP','2010','1',NULL,NULL,NULL),(231,'USA-TAM-SHI','2009','001',NULL,NULL,NULL),(232,'HK-ZLLO-WIN','2009','1',NULL,NULL,NULL),(233,'CHI-ZLLO-WIN','2009','1',NULL,NULL,NULL),(236,'SHA-MEX-AIR-HT','09','1',NULL,NULL,NULL),(237,'PAN-MEX-AIR-SSL','2009','01',NULL,NULL,NULL),(238,'SHE-ZLLO-SHIP','2012','1',NULL,NULL,NULL),(239,'BRV-VER-SSL','2009','1',NULL,NULL,NULL),(240,'VIET-ZLLO-EVE','2010','01',NULL,NULL,NULL),(242,'SHA-ZLLO-SHIP','10','001',NULL,NULL,NULL),(243,'YOK-ZLLO-SHIP','2010','1',NULL,NULL,NULL),(245,'PUS-MEX-AIR-GLW','2010','1',NULL,NULL,NULL),(246,'VLC-VER-TGY','2010','1',NULL,NULL,NULL),(247,'BCN-ATM-TGY','2011','001',NULL,NULL,NULL),(248,'JNPT-VER-CPW','2010','001',NULL,NULL,NULL),(249,'JNPT-ZLLO-CPW','2010','2010',NULL,NULL,NULL),(250,'NASH-VER-CPW ','2010','1',NULL,NULL,NULL),(251,'CHI-ZLLO-SHIP','2010','1',NULL,NULL,NULL),(252,'VLC-ATM-TGY ','2010','1',NULL,NULL,NULL),(255,'NASH-ZLLO-CPW','2010','1',NULL,NULL,NULL),(257,'SHA-PRO-HT','2010','1',NULL,NULL,NULL),(259,'NASH-ZLLO-TGL','2010','1',NULL,NULL,NULL),(260,'SEK-ZLLO-HT','2010','1',NULL,NULL,NULL),(261,'ALL POL A-V RO','2010','01',NULL,NULL,NULL),(262,'ALL POL ZLO RO','2010','01',NULL,NULL,NULL),(263,'ALL POL A-V','2010','01',NULL,NULL,NULL),(264,'ALL POL ZLO','2010','01',NULL,NULL,NULL),(265,'ALL POL','2010','01',NULL,NULL,NULL),(266,'USA-MEX-AEREO-SHIP','2010','001',NULL,NULL,NULL),(267,'CTG-VER MAHE RO','2010','1',NULL,NULL,NULL),(268,'CAL-ZLO-SSL RO','2010','0',NULL,NULL,NULL),(269,'ALL POL RO','2010','1',NULL,NULL,NULL),(270,'KEE-ZLO-HT RO','2010','1',NULL,NULL,NULL),(271,'HAM A-V','2010','1',NULL,NULL,NULL),(272,'SSZ A-V','2010','1',NULL,NULL,NULL),(273,'VAP-MEX-AEREO-SHIP','2010','01',NULL,NULL,NULL),(274,'BUE-VER-SSL RO','2010','1',NULL,NULL,NULL),(275,'GOA A-V','2010','1',NULL,NULL,NULL),(276,'GOA A-V RO','2010','1',NULL,NULL,NULL),(277,'BCN-VER','2010','1',NULL,NULL,NULL),(278,'BCN-VER RO','2010','1',NULL,NULL,NULL),(279,'NO VALIDO PARA TODOS','2010','01',NULL,NULL,NULL),(280,'NASH-ATM-CPW','2010','1',NULL,NULL,NULL),(281,'NIN-MEX-AEREO-HT','2010','01',NULL,NULL,NULL),(282,'KAR-ZLLO-GM','2010','01',NULL,NULL,NULL),(283,'UK-ATM-SHI','2010','001',NULL,NULL,NULL),(284,'PC-VER-PTV','2010','001',NULL,NULL,NULL),(285,'BUE- A-V SSL','2011','01',NULL,NULL,NULL),(286,'RTM A-V','2011','1',NULL,NULL,NULL),(287,'BRV-A-V-SSL','2011','1',NULL,NULL,NULL),(288,'NASH-LC-CPW','2011','001',NULL,NULL,NULL),(289,'ALL-VER-UPS','2011','01',NULL,NULL,NULL),(290,'KEE-MEX-AEREO-HT','2011','1',NULL,NULL,NULL),(291,'XIA-MEX-AIR-HT','2011','01',NULL,NULL,NULL),(292,'NASH-VER-TGL','2011','01',NULL,NULL,NULL),(293,'LPV_OTROS','2011','1',NULL,NULL,NULL),(294,'BRE Y BRV- ALT Y VER','2011','01',NULL,NULL,NULL),(295,'QIN-MEX-AIR-PAN','2011','01',NULL,NULL,NULL),(297,'NIN-MEX-AEREO-PAN','2011','1',NULL,NULL,NULL),(298,'SHA-ZLLO-PAN','2011','1',NULL,NULL,NULL),(299,'SYD-MEX-AIR-AGS','2011','01',NULL,NULL,NULL),(300,'NIN-ZLLO-SHIP','2011','01',NULL,NULL,NULL),(301,'PIR-VER-ARI','2011','01',NULL,NULL,NULL),(302,'SHA-ENS-HT','2011','01',NULL,NULL,NULL),(303,'BUD-MEX-AIR-SSL','2011','01',NULL,NULL,NULL),(304,'LIM-MEX-AIR-UNX','2011','01',NULL,NULL,NULL),(305,'BCN A-V TGY','2011','1',NULL,NULL,NULL),(308,'BRE & HAM - ALT & VER','2011','1',NULL,NULL,NULL),(309,'MIL A-V CB','1','1',NULL,NULL,NULL),(310,'ALL INDIA- VER& ZLO TEAMGLOBAL','2011','01',NULL,NULL,NULL),(311,'PAN-MEX-AIR-PCS','11','001',NULL,NULL,NULL),(312,'THA-ZLLO-SHIP','2012','01',NULL,NULL,NULL),(313,'BCN&VAL-VER TGY','2012','1',NULL,NULL,NULL),(314,'PUS-ZLLO-MTM','2012','01',NULL,NULL,NULL),(315,'HAM/ BRE-A-V','2012','01',NULL,NULL,NULL),(316,'ANR-A-V','2012','01',NULL,NULL,NULL),(317,'GYE-ZLLO-SSL','2012','01',NULL,NULL,NULL),(318,'MEL-ZLLO-AGS','2012','01',NULL,NULL,NULL),(319,'AEREO MEL-MEX-AGS','2012','01',NULL,NULL,NULL),(320,'JKT-ZLLO-IDD','2012','01',NULL,NULL,NULL),(321,'SHA-VER-HT','2012','01',NULL,NULL,NULL),(322,'ASIA-ZLLO-STAR','2012','01',NULL,NULL,NULL),(323,'SHA-ZLLO-SINO','2012','01',NULL,NULL,NULL),(325,'MAD-MEX-TGY','2012','001',NULL,NULL,NULL),(327,'SSZ-VER-ATM-ALLINK','2012','01',NULL,NULL,NULL),(328,'NIN-ZLLO-GCI','2013','01',NULL,NULL,NULL),(329,'MIL-CUN-CM','2012','001',NULL,NULL,NULL),(330,'MIL-CUN-CAD','2012','001',NULL,NULL,NULL),(332,'TERR-IMP-IND','2012','01',NULL,NULL,NULL),(334,'HAM ZLO','2012','1',NULL,NULL,NULL),(335,'HAM ALL POL','2012','01',NULL,NULL,NULL),(337,'PK-VER-DYN','2012','01',NULL,NULL,NULL),(338,'KAR-VER-DYN','2012','01',NULL,NULL,NULL),(339,'KEE-ENS-HT','2012','001',NULL,NULL,NULL),(340,'ZUR-MEX-SSC ','2012','01',NULL,NULL,NULL),(342,'SHA-MEX-AIR-SHIP','2012','1',NULL,NULL,NULL),(343,'AIR PVG-LAX-MEX','2013','001',NULL,NULL,NULL),(344,'SEA - AIR CARGO','13','001',NULL,NULL,NULL),(345,'THAZLO-FCL-SHI','2013','01',NULL,NULL,NULL),(346,'THAZLO-FCL-AMF','2013','01',NULL,NULL,NULL),(347,'SHAZLO-FCL-SINO','2013','01',NULL,NULL,NULL),(348,'NASHZLO-FCL-CPW','2013','01',NULL,NULL,NULL),(349,'NASHVER-FCL-CPW','2013','01',NULL,NULL,NULL),(350,'ASIAZLO-FCL-STAR','2013','01',NULL,NULL,NULL),(351,'JKTZLO-FCL-IDD','2013','01',NULL,NULL,NULL),(352,'IZMZLO-FCL-STG','2013','01',NULL,NULL,NULL),(353,'PENZLO-FCL-CPW','2013','01',NULL,NULL,NULL),(354,'USAVER-FCL-SHI','2013','01',NULL,NULL,NULL),(355,'USAZLO-FCL-SHI','2013','01',NULL,NULL,NULL),(356,'USAATM-FCL-SHI','2013','01',NULL,NULL,NULL),(357,'KEEZLO-FCL-HT','2013','01',NULL,NULL,NULL),(358,'LIOVER-FCL-NAZEL','2013','01',NULL,NULL,NULL),(359,'AIR MEX','2013','0001',NULL,NULL,NULL),(360,'AIR SFO-MEX','2013','001',NULL,NULL,NULL),(361,'SHAZLO-FCL-SHI','2013','001',NULL,NULL,NULL),(362,'SIN-ZLO-GLINK','2013','01',NULL,NULL,NULL),(363,'CHITT-ZLO-KASE','2013','01',NULL,NULL,NULL),(364,'SHAZLO-FCL-HT','2013','001',NULL,NULL,NULL),(365,'ASIAVER-FCL-STAR','2013','001',NULL,NULL,NULL),(366,'ANRATM-FCL-SSL','2013','001',NULL,NULL,NULL),(367,'QIN-ZLLO-SHIP','2013','001',NULL,NULL,NULL),(368,'PUSZLO-FCL-KOR','2013','001',NULL,NULL,NULL),(369,'HAM & UK- VER & ALT','2013','1',NULL,NULL,NULL),(370,'HK-ZLLO-SHI','2013','001',NULL,NULL,NULL),(371,'ANRVER-FCL-SSL','2013','001',NULL,NULL,NULL),(372,'PKG-ZLO-HT','2013','001',NULL,NULL,NULL),(373,'NASHZLO-FCL-TGL','2013','001',NULL,NULL,NULL),(374,'XIN-ZLLO-TCI','2013','01',NULL,NULL,NULL),(375,'NINZLO-FCL-HT','2013','001',NULL,NULL,NULL),(376,'SJUVER-FCL-DFF','13','01',NULL,NULL,NULL),(377,'BRVATM-FCL-SSL','2013','001',NULL,NULL,NULL),(378,'FRE-BUS-ZLO','2013','01',NULL,NULL,NULL),(379,'SHAENS-FCL-HT','2013','001',NULL,NULL,NULL),(380,'SHAZLO-FCL-SHIP','2013','001',NULL,NULL,NULL),(381,'VLCATM-FCL-TGY','2013','001',NULL,NULL,NULL),(382,'ANRVER-FCL-SSC','2013','001',NULL,NULL,NULL),(383,'BCNVER-FCL-TGY','2013','001',NULL,NULL,NULL),(384,'PUSZLO-FCL-GLW','2013','001',NULL,NULL,NULL),(385,'CTGATM-FCL-MAHE','2013','01',NULL,NULL,NULL),(386,'SPEFCL-VER-CM','2013','01',NULL,NULL,NULL),(387,'ASIAZLO-FCL-HT','2013','001',NULL,NULL,NULL),(388,'SHEFCL-ZLO-SHIP','2013','001',NULL,NULL,NULL),(390,'GOAVER-FCL-CM','2013','001',NULL,NULL,NULL),(391,'PKG-ZLO-WLS','2013','01',NULL,NULL,NULL),(392,'SSZVER-FCL-ALLINK','2013','001',NULL,NULL,NULL),(393,'SHAZLO-FCL-MAR','2013','001',NULL,NULL,NULL),(394,'CTGVER-FCL-MAHE','2013','001',NULL,NULL,NULL),(395,'BRVER-FCL-SSL','2013','001',NULL,NULL,NULL),(396,'USAPRG-FCL-SHIP','2013','001',NULL,NULL,NULL),(397,'PKGZLO-FCL-MAHE','2014','01',NULL,NULL,NULL),(398,'ANRATM-FCL-SSC','2014','01',NULL,NULL,NULL),(399,'KARZLO-FCL-RIA','2014','01',NULL,NULL,NULL),(400,'NINZLO-FCL-GLOW','2014','01',NULL,NULL,NULL),(401,'ALL POL LOGITECH','2014','01',NULL,NULL,NULL),(402,'AMIKOO-TERR','2014','01',NULL,NULL,NULL),(403,'SAT-ZLO-SHIP','2014','01',NULL,NULL,NULL),(404,'ANRVER-FCL-SHIP','2014','01',NULL,NULL,NULL),(405,'BKKZLO-FCL-AMF','2014','001',NULL,NULL,NULL),(406,'NASHVER-FCL-TGL','-','-',NULL,NULL,NULL),(407,'VIET-ZLLO-SHIP','-','-',NULL,NULL,NULL),(408,'BRVPJC-FCL-RON','2014','001',NULL,NULL,NULL),(411,'THA-ATM-SHIP','2014','-',NULL,NULL,NULL),(412,'THAATM-FCL-SHIP','2014','-',NULL,NULL,NULL),(413,'LCBZLO-FCL-GIL','2014','001',NULL,NULL,NULL),(414,'YOK-ENS-SHIP','2014','001',NULL,NULL,NULL),(415,'IST-VER SHIPCO-SACO','2014','01',NULL,NULL,NULL),(416,'HAM-BRE VER & ALT RO','2014','01',NULL,NULL,NULL),(417,'ANT VER & ALT RO','2014','01',NULL,NULL,NULL),(418,'PJC-FCL-ITT','2014','01',NULL,NULL,NULL),(419,'SGNZLO-FCL-TSA','2014','01',NULL,NULL,NULL),(420,'GFSFCL','','001',NULL,NULL,NULL),(421,'NASHATM-FCL-TGL','2014','01',NULL,NULL,NULL),(422,'ANRATMSSC','2014','01',NULL,NULL,NULL),(423,'ANRVERSSC','2014','01',NULL,NULL,NULL),(424,'BCNATMTGY','2014','01',NULL,NULL,NULL),(425,'BCNVERTGY','2014','01',NULL,NULL,NULL),(428,'BUEVERSSL','2014','01',NULL,NULL,NULL),(429,'CLLZLOSSL','2014','01',NULL,NULL,NULL),(430,'CTGVERMAH','2014','01',NULL,NULL,NULL),(431,'GBATMSTI','2014','01',NULL,NULL,NULL),(432,'GBVERSTI','2014','01',NULL,NULL,NULL),(433,'HKGZLOHTS','2014','01',NULL,NULL,NULL),(434,'HKGZLOSTI','2014','01',NULL,NULL,NULL),(435,'HKGZLOWIN','2014','01',NULL,NULL,NULL),(436,'KELZLOHTS','2014','01',NULL,NULL,NULL),(437,'KELZLOSTI','2014','01',NULL,NULL,NULL),(438,'ITATMCOM','2014','01',NULL,NULL,NULL),(439,'ITVERCOM','2014','01',NULL,NULL,NULL),(440,'NGBZLOGCI','2014','01',NULL,NULL,NULL),(441,'NGBZLOSTI','2014','01',NULL,NULL,NULL),(442,'NSAVERTGL','2014','01',NULL,NULL,NULL),(443,'NSAZLOTGL','2014','01',NULL,NULL,NULL),(444,'PUSZLOGLW','2014','01',NULL,NULL,NULL),(445,'SHAZLOHTS','2014','01',NULL,NULL,NULL),(446,'SHAZLOSTI','2014','01',NULL,NULL,NULL),(447,'SSZATMATI','2014','01',NULL,NULL,NULL),(448,'SSZVERATI','2014','01',NULL,NULL,NULL),(449,'SZXZLOHTS','2014','01',NULL,NULL,NULL),(450,'SZXZLOSTI','2014','01',NULL,NULL,NULL),(451,'TAOZLOPAN','2014','01',NULL,NULL,NULL),(452,'USAATMSTI','2014','01',NULL,NULL,NULL),(453,'USAVERSTI','2014','01',NULL,NULL,NULL),(454,'USAZLOSTI','2014','01',NULL,NULL,NULL),(455,'VAPZLOSTI','2014','01',NULL,NULL,NULL),(456,'XGGZLOTCI','2014','01',NULL,NULL,NULL),(457,'YOKZLOSTI','2014','01',NULL,NULL,NULL),(458,'BRVVERSSL','2015','001',NULL,NULL,NULL),(459,'BRVATMSSL','2014','01',NULL,NULL,NULL),(460,'FCL','2015','001',NULL,NULL,NULL),(461,'NGBZLOHTI','2015','01',NULL,NULL,NULL),(462,'SCHLPV','2015','01',NULL,NULL,NULL),(463,'OTROS','2015','01',NULL,NULL,NULL),(464,'BUNZLOMAH','2015','01',NULL,NULL,NULL),(465,'NGBZLOWIN','2015','01',NULL,NULL,NULL),(470,'INTLPA','','','PIA','INT','LPA'),(471,'AUMXAWT','2015','01',NULL,NULL,NULL),(472,'TEST-PUERTOS','','','I',NULL,NULL),(474,'TEST-PUERTOS','','','',NULL,NULL),(477,'TEST-VER-IMPO-PUERTOS','','','',NULL,NULL),(479,'TEST-A-VER-IMPO-PUERTOS','','','',NULL,NULL),(480,'FACTWWA MAR-AE','2015','001',NULL,NULL,NULL),(481,'KUELPM','','','PIM','KUE','LPM'),(482,'INTLPV','','','PIV','INT','LPV'),(483,'PANLPV','','','PIV','PAN','LPV'),(484,'KUELPV','','','PIV','KUE','LPV'),(485,'SCHLPV','','','PIV','SCH','LPV'),(486,'DACLPV','','','PIV','DAC','LPV'),(487,'JASLPV','','','PIV','JAS','LPV'),(488,'SCYLPV','','','PIV','SCY','LPV'),(489,'GEOLPV','','','PIV','GEO','LPV'),(490,'LPV-GASTOS','','','PIV','','LPV-GASTOS'),(491,'PANLPA','','','PIA','PAN','LPA'),(492,'KUELPA','','','PIA','KUE','LPA'),(493,'SCHLPA','','','PIA','SCH','LPA'),(494,'JASLPA','','','PIA','JAS','LPA'),(495,'SCHLPM','','','PIM','SCH','LPM'),(496,'JASLPM','','','PIM','JAS','LPM'),(497,'PANLPM','','','PIM','PAN','LPM'),(499,'GEOLPM','','','PIM','GEO','LPM'),(501,'SCHSCHLPM','','','','SCH','SCHLPM'),(502,'INTLPM','','','PIM','INT','LPM'),(506,'BKKZLOSTI','2015','01',NULL,NULL,NULL),(507,'','15','',NULL,NULL,NULL),(508,'DACLPM','','','PIM','DAC','LPM'),(509,'TRLLPM','','','PIM','TRL','LPM'),(510,'SGNZLOSTI','2015','001',NULL,NULL,NULL),(511,'GOAATMCOM','2016','001',NULL,NULL,NULL),(512,'GOAVERCOM','2016','001',NULL,NULL,NULL),(513,'LONATMSTI','2016','001',NULL,NULL,NULL),(514,'LONVERSTI','2016','001',NULL,NULL,NULL),(515,'MIAVERSTI','2016','001',NULL,NULL,NULL),(516,'HAMATMSSL','2016','001',NULL,NULL,NULL),(517,'HAMVERSSL','2016','001',NULL,NULL,NULL),(518,'BREVERSSL','2016','001',NULL,NULL,NULL),(519,'BREATMSSL','2016','001',NULL,NULL,NULL),(520,'VGILPV','','','PIV','VGI','LPV'),(521,'VGILPA','','','PIA','VGI','LPA'),(522,'FCLRON','2016','001',NULL,NULL,NULL),(523,'FCLDEL','2016','001',NULL,NULL,NULL),(524,'FCLVAL','2016','001',NULL,NULL,NULL),(526,'NEWLPV','','','PIV','NEW','LPV'),(527,'NEWLPA','','','PIA','NEW','LPA'),(529,'NEWLPM','','','PIM','NEW','LPM'),(533,'VLCVERTGY','2016','001',NULL,NULL,NULL),(534,'VLCATMTGY','2016','001',NULL,NULL,NULL),(535,'NGBZLOHTS','2016','001',NULL,NULL,NULL),(536,'ROLGW','2016','001',NULL,NULL,NULL),(537,'EXTINT','2016','001',NULL,NULL,NULL),(539,'UPSLPA','','','PIA','UPS','LPA'),(540,'UPSLPV','','','PIV','UPS','LPV'),(541,'UPSLPM','','','PIM','UPS','LPM'),(542,'VSELPV','','','PIV','VSE','LPV'),(543,'VSELPM','','','PIM','VSE','LPM'),(544,'VSELPA','','','PIA','VSE','LPA'),(545,'BOLLPA','','','PIA','BOL','LPA'),(546,'INTLPV','','','FCLPV','INT','LPV'),(547,'PANLPV','','','FCLPV','PAN','LPV'),(548,'KUELPV','','','FCLPV','KUE','LPV'),(549,'SCHLPV','','','FCLPV','SCH','LPV'),(550,'DACLPV','','','FCLPV','DAC','LPV'),(551,'JASLPV','','','FCLPV','JAS','LPV'),(552,'SCYLPV','','','FCLPV','SCY','LPV'),(553,'GEOLPV','','','FCLPV','GEO','LPV'),(554,'VGILPV','','','FCLPV','VGI','LPV'),(555,'NEWLPV','','','FCLPV','NEW','LPV'),(556,'UPSLPV','','','FCLPV','UPS','LPV'),(557,'VSELPV','','','FCLPV','VSE','LPV'),(558,'VSELPM','','','FCLPM','VSE','LPM'),(559,'UPSLPM','','','FCLPM','UPS','LPM'),(560,'NEWLPM','','','FCLPM','NEW','LPM'),(561,'TRLLPM','','','FCLPM','TRL','LPM'),(562,'INTLPM','','','FCLPM','INT','LPM'),(563,'GEOLPM','','','FCLPM','GEO','LPM'),(564,'PANLPM','','','FCLPM','PAN','LPM'),(565,'JASLPM','','','FCLPM','JAS','LPM'),(566,'SCHLPM','','','FCLPM','SCH','LPM'),(567,'KUELPM','','','FCLPM','KUE','LPM'),(568,'DACLPM','','','FCLPM','DAC','LPM'),(569,'VSELPA','','','FCLPA','VSE','LPA'),(570,'BOLLPA','','','FCLPA','BOL','LPA'),(571,'UPSLPA','','','FCLPA','UPS','LPA'),(572,'NEWLPA','','','FCLPA','NEW','LPA'),(573,'VGILPA','','','FCLPA','VGI','LPA'),(574,'JASLPA','','','FCLPA','JAS','LPA'),(575,'SCHLPA','','','FCLPA','SCH','LPA'),(576,'KUELPA','','','FCLPA','KUE','LPA'),(577,'PANLPA','','','FCLPA','PAN','LPA'),(578,'INTLPA','','','FCLPA','INT','LPA'),(579,'INTLPL','','','PIL','INT','LPL'),(580,'PANLPL','','','PIL','PAN','LPL'),(582,'SCHLPL','','','PIL','SCH','LPL'),(587,'LPL-GASTOS','','','PIL','','LPL-GASTOS'),(592,'AGLLPV','','','FCLPV','AGL','LPV'),(593,'AGLLPM','','','FCLPM','AGL','LPM'),(594,'AGLLPA','','','FCLPA','AGL','LPA'),(595,'PUSLZCGLW','2017','001',NULL,NULL,NULL),(596,'TINTVERMEX','2017','001',NULL,NULL,NULL),(597,'TINTZLONLN','2017','001',NULL,NULL,NULL),(598,'TINTZLOEDO','2017','001',NULL,NULL,NULL),(599,'TINTZLOSON','2017','001',NULL,NULL,NULL),(600,'TINTZLOGTO','2017','001',NULL,NULL,NULL),(601,'TINTVEREDO','2017','001',NULL,NULL,NULL),(602,'VGILPM','','','PIM','VGI','LPM'),(603,'ECSLPM','','','PIM','ECS','LPM'),(604,'BOLLPM','','','FCLPM','BOL','LPM'),(605,'BOLLPM','','','PIM','BOL','LPM'),(606,'HKGLZCSTI','2017','001',NULL,NULL,NULL),(607,'EXTLPV','','','PIV','EXT','LPV'),(608,'PRTLPV','','','PIV','PRT','LPV'),(609,'SCHLPL','','','FCLPL','SCH','LPL'),(610,'UPSLPL','','','FCLPL','UPS','LPL'),(611,'AGLLPL','','','FCLPL','AGL','LPL'),(612,'BOLLPL','','','FCLPL','BOL','LPL'),(613,'DACLPL','','','FCLPL','DAC','LPL'),(614,'GEOLPL','','','FCLPL','GEO','LPL'),(615,'INTLPL','','','FCLPL','INT','LPL'),(616,'JASLPL','','','FCLPL','JAS','LPL'),(617,'KUELPL','','','FCLPL','KUE','LPL'),(618,'NEWLPL','','','FCLPL','NEW','LPL'),(619,'PANLPL','','','FCLPL','PAN','LPL'),(620,'TRLLPL','','','FCLPL','TRL','LPL'),(621,'TRLLPL','','','FCLPL','TRL','LPL'),(622,'SHAZLOWJL','2018','001',NULL,NULL,NULL),(623,'SENLPM','','','PIM','SEN','LPM'),(624,'SENLPV','','','PIV','SEN','LPV'),(625,'SHALZCSTI','2018','001',NULL,NULL,NULL),(626,'XMNZLOAFT','2018','001',NULL,NULL,NULL),(627,'OLMLPA','','','FCLPA','OLM','LPA'),(628,'POLPODPRU','2018','001',NULL,NULL,NULL),(629,'SHAZLOJDN','2018','001',NULL,NULL,NULL),(630,'MACLPM','','','PIM','MAC','LPM'),(631,'SZXLZCHTS','2018','01',NULL,NULL,NULL),(632,'PACLPA','','','FCLPA','PAC','LPA'),(634,'NYCATMSTI','2018','001',NULL,NULL,NULL),(635,'UFSLPV','','','PIV','UFS','LPV'),(636,'BOLLPV','','','FCLPV','BOL','LPV'),(637,'XMNZLOSTI','2019','001',NULL,NULL,NULL),(638,'RHSLPV','','','PIV','RHS','LPV'),(639,'RHSLPA','','','PIA','RHS','LPA'),(640,'SZXLZCSTI','2019','001',NULL,NULL,NULL),(641,'HARLPA','','','FCLPA','HAR','LPA'),(642,'BOLLPV','','','PIV','BOL','LPV'),(643,'CHRLPV','','','PIV','CHR','LPV'),(644,'RTMVERSSC','2019','001',NULL,NULL,NULL),(645,'SZXZLOFCI','2019','001',NULL,NULL,NULL),(646,'RTMATMSSC','2019','001',NULL,NULL,NULL),(647,'GFHLPM','','','PIM','GFH','LPM'),(648,'CHRLPA','','','PIA','CHR','LPA'),(650,'BCNVERWPL','2019','001',NULL,NULL,NULL),(651,'CTLLPM','','','PIM','CTL','LPM'),(652,'DACLPA','','','PIA','DAC','LPA'),(653,'CTLLPL','','','PIL','CTL','PIL'),(654,'MOLLPA','','','PIA','MOL','LPA'),(656,'SENLPM','','','FCLPM','SEN','LPM'),(657,'SENLPV','','','FCLPV','SEN','LPV'),(658,'BILLPV','','','PIV','BIL','LPV'),(659,'DSVLPV','','','PIV','DSV','LPV'),(660,'DSVLPM','','','PIM','DSV','LPM'),(661,'DSVLPA','','','PIA','DSV','LPA'),(662,'DSVLPL','','','PIL','DSV','LPL'),(663,'DSVLPA','','','FCLPA','DSV','LPA'),(664,'DSVLPM','','','FCLPM','DSV','LPM'),(665,'DSVLPV','','','FCLPV','DSV','LPV'),(666,'DSVLPL','','','FCLPL','DSV','LPL'),(667,'BLLLPV','','','PIV','BLL','LPV'),(668,'SENLPA','','','PIA','SEN','LPA'),(669,'YOKZLOGLW','2020','01',NULL,NULL,NULL);
/*!40000 ALTER TABLE `referencias_impo_interteam` 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:14:12
