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

DROP TABLE IF EXISTS `agentes_aduanales_puertos_razones_sociales`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `agentes_aduanales_puertos_razones_sociales` (
  `id` varchar(10) NOT NULL DEFAULT '',
  `idrazonsocial` int(11) NOT NULL AUTO_INCREMENT,
  `invoicename3` varchar(255) DEFAULT NULL,
  `invoicecity3` varchar(255) DEFAULT NULL,
  `calle_invoice3` varchar(255) DEFAULT NULL,
  `no_ext_invoice3` varchar(255) DEFAULT NULL,
  `no_int_invoice3` varchar(255) DEFAULT NULL,
  `colonia_invoice3` varchar(255) DEFAULT NULL,
  `estado_invoice3` varchar(255) DEFAULT NULL,
  `cp3` varchar(10) DEFAULT NULL,
  `pais_invoice3` varchar(255) DEFAULT NULL,
  `rfc3` varchar(20) DEFAULT NULL,
  `email_cobranza3` text,
  PRIMARY KEY (`idrazonsocial`)
) ENGINE=InnoDB AUTO_INCREMENT=11070 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `agentes_aduanales_puertos_razones_sociales`
--

LOCK TABLES `agentes_aduanales_puertos_razones_sociales` WRITE;
/*!40000 ALTER TABLE `agentes_aduanales_puertos_razones_sociales` DISABLE KEYS */;
INSERT INTO `agentes_aduanales_puertos_razones_sociales` VALUES ('62',10849,'COIMPORTEX SERVICIOS ADUANALES SC','GUSTAVO A MADERO','AV SAN JUAN DE ARAGON','551','','II SECCION SAN JUAN DE ARAGON','','07969','MEXICO','CSA090922PF2',''),('185',10868,'MEDINA FORWARDING MEXICO SC','VERACRUZ','AV IGNACIO ALLENDE','2156','','CENTRO','VERACRUZ','91700','MÉXICO','MFM051125M40',''),('185',10869,'SADIMEX SC','VERACRUZ','CJON SANTO DOMINGO','586','','LOS PINOS','VERACRUZ','91870','MÉXICO','SAD0907036U1',''),('590',10870,'DICEX SA DE CV','MONTERREY','BELISARIO DOMINGUEZ','2376','','OBISPADO','NUEVO LEON','64060','MEXICO','DIC881125G65',''),('179',10871,'LOGISTICA ADUANAL JH Y ASOCIADOS SC','TAMPICO','CUARTA AVENIDA','117','','LAGUNA DE LA PUERTA','TAMAULIPAS','89310','MEXICO','LAJ160818355',''),('591',10873,'VISA LOGISTICA ADUANERA SC','MANZANILLO','AV AUDIENCIA','48','58','PENINSULA DE SANTIAGO','COLIMA','28867','MEXICO','VLA090720GA9',''),('619',10892,'VALEO SISTEMAS ELECTRICOS SA DE CV','SAN LUIS POTOSI','CARRETERA MEXICO PIEDRAS NEGRAS KM 416','3900','','ZONA INDUSTRIAL','SAN LUIS POTOSI','78395','MEXICO','VSE941206BT0',''),('626',10893,'LESCHACO MEXICANA S.A. DE C.V.','MIGUEL HIDALGO','MANUEL AVILA CAMACHO','88','PISO 8','LOMAS DE CHAPULTEPEC','DISTRITO FEDERAL','','MEXICO','LME980116R15',''),('610',10903,'RADAR CUSTOMS & LOGISTICS SAPI DE CV','MIGUEL HIDALGO','BOSQUE DE DURAZNOS','55','PISO 3','BOSQUES DE LAS LOMAS','DISTRITO FEDERAL','11700','MEXICO','RCA1606221V5',''),('610',10904,'RADAR CUSTOMS & LOGISTICS SAPI DE CV','ALTAMIRA','AV. RIO TAMESÃ KM 0+700 TORRE MULTIMODAL','LOCAL N Y O- PB','','PUERTO INDUSTRIAL','TAMAULIPAS','89603','MEXICO','RCA1606221V5',''),('610',10905,'','','','','','','','','MEXICO','',''),('51',10909,'AGENCIA ADUANAL GUSTAVO AVILA SC','VENUSTIANO CARRANZA','MATAMOROS','86','','PEÑON DE LOS BAÑOS','CIUDAD DE MEXICO','15520','MEXICO','AAG061023LS9',''),('640',10913,'CONSORCIO INTERNACIONAL ADUANERO SC','VERACRUZ','MARIO MOLINA','465','','CENTRO','VERACRUZ','91700','MEXICO','CIA100601TQ6',''),('640',10914,'DAM-MEX SERVICIOS ADUANALES S.C','TAMPICO','EMILIO CARRANZA','517','106','CENTRO','TAMAULIPAS','89000','MEXICO','DGM040830DU3',''),('640',10915,'','','','','','','','','MEXICO','',''),('640',10916,'','','','','','','','','MEXICO','',''),('667',10922,'FERNANDEZ HINOJOSA Y CIA, S.C.','AZCAPOTZALCO','AVENIDA DE LOS ANGELES','303','12','SAN MARTIN XOCHINAHUAC','ESTADO DE MEXICO','02120','MEXICO','FHI8704277E9',''),('139',10923,'GESTORIA Y ASESORIA ADUANAL DE VERACRUZ SC','VERACRUZ','MIGUEL HIDALGO','321','','CENTRO','VERACRUZ','91700','MÉXICO','GAA100904855',''),('139',10924,'CONTROL ADUANAL Y TRAMITES SC','VERACRUZ','5 DE MAYO','842','','CENTRO','VERACRUZ','91700','MÉXICO','CAT100421791',''),('139',10925,'SOLUCIONES COMERCIALES DOFASA,SA DE CV','VERACRUZ','GENERAL PRIM','583','','CENTRO','VERACRUZ','91700','MEXICO','SCD150110CR0',''),('290',10939,'','','','','','','','','MEXICO','',''),('290',10940,'','','','','','','','','MEXICO','',''),('290',10941,'','','','','','','','','MEXICO','',''),('686',10942,'RADAR CUSTOM & LOGISTICS SAPI DE CV','LAZARO CARDENAS','AVENIDA MANUEL BUENDIA','120 B','','2 DO. SECTOR DE FIDELAC','MICHOACAN','60950','MEXICO','RCA1606221V5',''),('348',10943,'BARRENECHEA SUCESORES SC','MANZANILLO','CONSTITUCION','10','','MORELOS','COLIMA','28217','MEXICO','BSU050304I80',''),('684',10944,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('210',10947,'CORPORATIVO ADUANERO Y LOGISTICA INTERNACIONAL S DE RL DE C.V.','TAMPICO','PLAZUELA DE LOS CANTAROS','30 A','','PETROLERA','TAMAULIPAS','89110','MEXICO','CAA070712L11',''),('210',10948,'ASESORIA SERVICIOS ADUANALES Y MANIOBRAS PORTUARIOS DEL NORESTE N&N , S.A. DE C.V.','TAMPICO','BRILLANTE','216','','FRACCIONAMIENTO DIAMANTE','','89366','MEXICO','ASA1207303RA',''),('697',10949,'VILLANUEVA CERVANTES Y ASOCIADOS, SC','MANZANILLO','CARRETERA A MINATITLAN','KM 1  LOTE 16','MANZANA 2','TAPEIXTLES','COLIMA','28239','MEXICO','VCA0802255A5',''),('701',10953,'COIMPORTEX SERVICIOS ADUANALES SC','GUSTAVO A MADERO','AV SAN JUAN DE ARAGON','551','','II SECCION SAN JUAN DE ARAGON','','07969','MEXICO','CSA090922PF2',''),('701',10954,'','','','','','','','','MEXICO','',''),('115',10955,'HERNANDEZ BOLAÑOS Y ASOCIADOS SC','MEXICO','AVENIDA RIO CONSULADO','2662 A','PISO 1 Y 2','SAN JUAN DE ARAGON','ESTADO DE MEXICO','07920','MEXICO','HBA010125HV2',''),('634',10956,'RDZ AGENCIA ADUANAL S.A. DE C.V.','MEXICO','SINALOA','31','LOCAL 5-A','PEÑON DE LOS BAÑOS','ESTADO DE MEXICO','15520','MEXICO','RAA070213FT4',''),('20',10984,'CONSORCIO INTERNACIONAL ADUANERO SC','VERACRUZ','MARIO MOLINA','465','','CENTRO','VERACRUZ','91700','MEXICO','CIA100601TQ6',''),('20',10985,'SERVICIO ADUANAL E INTERNACIONAL BLAMARDI,S.C.','VERACRUZ','RIO DELICIAS','53','','LOMAS DE RIO MEDIO','VERACRUZ','','MEXICO','SAE0911197T1','Juan.alejandro@prodigy.net.mx'),('20',10986,'GRUPO ADUANAL LMS, S.C','VERACRUZ','MARIO MOLINA','465','','CENTRO','VERACRUZ','91700','MEXICO','GAL160502JT5',''),('20',10987,'REGMAR COMERCIO EXTERIOR SC','VERACRUZ','ESTEBAN MORALES','276','','FAROS','VERACRUZ','91709','MEXICO','RCE1310303E7',''),('20',10988,'','','','','','','','','MEXICO','',''),('20',10989,'','','','','','','','','MEXICO','',''),('369',10990,'ESTRATEGIA INTERNACIONAL GANE SC','MANZANILLO','AV. DIVISION DEL NORTE','34','A','EL PACIFICO','COLIMA','28219','MEXICO','EIG040505QPA',''),('369',10991,'GRUPO SAN INTELIGENCIA ADUANAL SC','MANZANILLO','AV. DIVISION DEL NORTE','34','','EL PACIFICO','COLIMA','28219','MEXICO','GSI090528KL1',''),('366',10992,'COMEXTAA  SC','VERACRUZ','AQUILES SERDAN','712','2 DO. PISO','CENTRO','VERACRUZ','91700','MEXICO','COM080925CN3',''),('584',10994,'ONE LOG SA DE CV','MANZANILLO','AV. LA AUDICIENCA','48','LOCAL B2','SALAGUA','COLIMA','28869','MEXICO','OLO130906193',''),('584',10995,'','','','','','','','','MEXICO','',''),('614',11030,'ABJ LOGISTICA ADUANAL DE VERACRUZ SA DE CV','MANZANILLO','AV. PAROTAS','L5','M5','VALLE DE LAS GARZAS','COLIMA','28219','MÉXICO','ALA110711JL1',''),('614',11031,'SADIMEX SC','VERACRUZ','CJON SANTO DOMINGO','586','','LOS PINOS','VERACRUZ','91870','MÉXICO','SAD0907036U1',''),('614',11032,'','','','','','','','','MEXICO','',''),('614',11033,'','','','','','','','','MEXICO','',''),('614',11034,'','','','','','','','','MEXICO','',''),('614',11035,'','','','','','','','','MEXICO','',''),('614',11036,'','','','','','','','','MEXICO','',''),('614',11037,'','','','','','','','','MEXICO','',''),('614',11038,'','','','','','','','','MEXICO','',''),('614',11039,'','','','','','','','','MEXICO','',''),('614',11040,'','','','','','','','','MEXICO','',''),('605',11041,'JORGE REYES HIDALGO SUCESORES SC','MANZANILLO','BLVD. MIGUEL DE LA MADRID','560','','VALLE DE LAS GARZAS','COLIMA','28876','MEXICO','JRH9210065M1',''),('320',11042,'ITRANS SERVICIOS ADUANALES','MEXICO','LA PAZ','116','','PEÑON DE LOS BAÑOS','ESTADO DE MEXICO','15520','MEXICO','ITS020918QK6',''),('615',11046,'TRUCA CARGO MX SA DE CV','GUSTAVO A. MADERO','AV. 535','86','','SAN JUAN DE ARAGON','MEXICO','07969','MEXICO','TCM110117AVA',''),('615',11047,'MOVERS SOLUCIONES INTEGRALES SC','NUEVO LAREDO','HEROE DE NACATAZ','3838','1B','NUEVO LAREDO CENTRO','TAMAULIPAS','88000','MEXICO','MSI171114CV9',''),('615',11048,'','','','','','','','','MEXICO','',''),('63',11049,'SOLUCIONES INTEGRALES COMEXAA SA DE CV','NOPALTEPEC','ZARAGOZA','SIN NUMERO','','MORELOS A','ESTADO DE MEXICO','55970','MEXICO','SIC171101UX7',''),('99',11050,'SADIMEX  SC','VERACRUZ','J.F. MOLINA','387','','LOS PINO','VERACRUZ','91870','MEXICO','SAD0907036U1',''),('731',11051,'ITRANS SERVICIOS ADUANALES','MEXICO','LA PAZ','116','','PEÑON DE LOS BAÑOS','ESTADO DE MEXICO','15520','MEXICO','ITS020918QK6',''),('731',11052,'','','','','','','','','MEXICO','',''),('243',11053,'AGENTES  ADUANALES AL SERVICIO DEL COMERCIO EXTERIOR SA DE CV','BENITO JUAREZ','AV INSURGENTES SUR','730','PISO 3','DEL VALLE','DISTRITO FEDERAL','03100','MEXICO','AAS060214UA4','carlos.galindo@expeditors.com'),('753',11057,'ONE LOG SA DE CV','MANZANILLO','AV. LA AUDICIENCA','48','LOCAL B2','SALAGUA','COLIMA','28869','MEXICO','OLO130906193',''),('753',11058,'ONE LOG S.A. DE C.V.','VERACRUZ','ZAMORA','462','301','CENTRO','VERACRUZ','91700','MEXICO','OLO130906193',''),('753',11059,'','','','','','','','','MEXICO','',''),('753',11060,'','','','','','','','','MEXICO','',''),('754',11063,'SOLUCIONES INTEGRALES COMEXAA SA DE CV','NOPALTEPEC','ZARAGOZA','SIN NUMERO','','MORELOS A','ESTADO DE MEXICO','55970','MEXICO','SIC171101UX7',''),('754',11064,'SOLUCIONES INTEGRALES COMEXXA SA DE CV','NOPALTEPEC','ZARAGOZA','S/N','','MORELOS','ESTADO DE MEXICO','55970','MEXICO','SIC171101UX7',''),('754',11065,'','','','','','','','','MEXICO','',''),('203',11066,'CONSADINT, S.C.','NUEVO LAREDO','HEROE DE NACATAZ','3602','','FERROCARRILERA 1','TAMAULIPAS','88040','MEXICO','CON071017IY3',''),('762',11068,'MOZ AGENCIAS ADUANALES DE LAZARO CARDENAS SC','LAZARO CARDENAS','CEREZOS','20 ALTOS','','COL. 2DO. SECTOR DE FIDELAC','MICHOACAN','60950','MEXICO','MAA041209FA4',''),('762',11069,'','','','','','','','','MEXICO','','');
/*!40000 ALTER TABLE `agentes_aduanales_puertos_razones_sociales` 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:46:44
