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

DROP TABLE IF EXISTS `tarifario_cotizaciones`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tarifario_cotizaciones` (
  `idcotizacion` int(11) NOT NULL AUTO_INCREMENT,
  `cotizacion_numero` int(11) DEFAULT NULL,
  `fecha_cotizacion` datetime DEFAULT NULL,
  `tipo_servicio` varchar(45) DEFAULT NULL,
  `closing_date` datetime DEFAULT NULL,
  `usuario_creo_cotizacion` varchar(30) DEFAULT NULL,
  `idtarifario` int(11) DEFAULT NULL,
  `customer` varchar(255) DEFAULT NULL,
  `razon_social` varchar(255) DEFAULT NULL,
  `origin_country` varchar(255) DEFAULT NULL,
  `origin_cfs` varchar(255) DEFAULT NULL,
  `destination_cfs` varchar(255) DEFAULT NULL,
  `destination_country` varchar(255) DEFAULT NULL,
  `frequency` varchar(50) DEFAULT NULL,
  `flete_terrestre` varchar(10) DEFAULT NULL,
  `lugar_recoleccion` varchar(45) DEFAULT NULL,
  `uncode_via` varchar(10) DEFAULT NULL,
  `tt` varchar(10) DEFAULT NULL,
  `comments` text,
  `incoterm` varchar(10) DEFAULT NULL,
  `producto` text,
  `valor_estimado_carga` varchar(20) DEFAULT NULL,
  `no_bultos_total` varchar(20) DEFAULT NULL,
  `peso_bruto_total` varchar(20) DEFAULT NULL,
  `volumen` varchar(20) DEFAULT NULL,
  `peligroso` varchar(20) DEFAULT NULL,
  `estibable` varchar(20) DEFAULT NULL,
  `volumen_cargable` varchar(20) DEFAULT NULL,
  `customer_type` varchar(45) DEFAULT NULL,
  `customer_service` varchar(45) DEFAULT NULL,
  `ejecutivo_de_ventas` varchar(45) DEFAULT NULL,
  `ejecutivo_pricing` varchar(45) DEFAULT NULL,
  `follow_up` varchar(45) DEFAULT NULL,
  `historial` text,
  `archivo_cotizacion` text,
  `usuario_imprimio_cotizacion` varchar(255) DEFAULT NULL,
  `fecha_impresion_cotizacion` datetime DEFAULT NULL,
  `archivo_enviado` text,
  `fecha_envio` datetime DEFAULT NULL,
  `usuario_envio_cotizacion` varchar(255) DEFAULT NULL,
  `contacto` varchar(255) DEFAULT NULL,
  `correo` varchar(255) DEFAULT NULL,
  `telefono` varchar(255) DEFAULT NULL,
  `tc` varchar(10) DEFAULT NULL,
  `vigencia` date DEFAULT NULL,
  `status` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`idcotizacion`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tarifario_cotizaciones`
--

LOCK TABLES `tarifario_cotizaciones` WRITE;
/*!40000 ALTER TABLE `tarifario_cotizaciones` DISABLE KEYS */;
INSERT INTO `tarifario_cotizaciones` VALUES (1,1,'2020-07-07 21:22:26','EXPORT','2020-07-21 00:00:00','EGUARNEROS',43,'STANDARD','CAPITAL LOGISTICS S.A. DE C.V. CIUDAD DE MEXICO','MEXICO','VERACRUZ','ANTWERP','BELGIUM','WEEKLY','Si','AZCAPOTZALCO','DIRECT','28',NULL,'EXW','NO ESTIBABLE','600','2','1000','3.36','NO','NO','3.36','CLIENTE ACTIVO','CROMERO','GFUENTES','HGUILLEN',NULL,NULL,'cotizacion_1_2020.07.07_21.29.26.pdf',NULL,'2020-07-07 21:29:26',NULL,NULL,NULL,'JUAN LUIS MARTINEZ','JLMARTINEZ@CAPITAL-LOG.MX','5545896236','22.4147','2020-07-31',NULL),(2,2,'2020-07-07 21:22:40','EXPORT','2020-07-21 16:24:41','AMORALES',70,'STANDARD','AGILITY LOGISTICS S.A. DE C.V. GUADALAJARA','MEXICO','VERACRUZ','SANTOS','BRAZIL','WEEKLY','Si','LERMA, TOLUCA','DIRECT','22',NULL,'EXW','PINTURA','750','2 PALLETS','500','4.00','SI','SI','4.00','CLIENTE ACTIVO','JARMENTA','NBARRERA','AMORALES',NULL,NULL,'cotizacion_2_2020.07.08_12.42.55.pdf',NULL,'2020-07-08 12:42:55',NULL,NULL,NULL,'RODRIGO RAZO','X','1234567890','22.4147','2020-07-31',NULL),(3,3,'2020-07-07 21:26:10','EXPORT',NULL,'AMORALES',70,'STANDARD','AGILITY LOGISTICS S.A. DE C.V. GUADALAJARA','MEXICO','VERACRUZ','SANTOS','BRAZIL','WEEKLY','','','DIRECT','22',NULL,'FOB','PINTURA','700','1','500','1','SI','SI','1','CLIENTE ACTIVO','JARMENTA','NBARRERA','AMORALES',NULL,NULL,'cotizacion_3_2020.07.07_21.26.51.pdf',NULL,'2020-07-07 21:26:51',NULL,NULL,NULL,'RODRIGO RAZO','X','123456789','22.4147','2020-07-31',NULL),(4,4,'2020-07-08 09:48:36','EXPORT',NULL,'RRAZO',216,'STANDARD','ICL AND NAVIOMEX S.A. DE C.V. ESTADO DE MEXICO','MEXICO','MANZANILLO','BUENAVENTURA','COLOMBIA','WEEKLY','Si','CELAYA, GTO','DIRECT','6',NULL,'CFR','CANASTAS','14000','10','5000','15','','NO','15','CLIENTE ACTIVO','JARMENTA','GRAMIREZ','RRAZO',NULL,NULL,'cotizacion_4_2020.07.08_09.52.18.pdf',NULL,'2020-07-08 09:52:18',NULL,NULL,NULL,'ERIK LOPEZ','RODRIGO.RAZO@INTERTEAM.COM.MX','5578363535','22.2808','2020-07-31',NULL),(5,5,'2020-07-08 09:56:05','EXPORT',NULL,'RRAZO',216,'STANDARD','RH SHIPPING AND CHARTERING S. DE R.L. DE C.V. CIUDAD DE MEXICO','MEXICO','MANZANILLO','BUENAVENTURA','COLOMBIA','WEEKLY','','CELAYA, GTO','DIRECT','6',NULL,'CFR','MEZCLA DE SUSTANCIAS ODORIFERAS','25000','5','5000','7','SI','NO','7','CLIENTE ACTIVO','JLPRIETO','GRAMIREZ','RRAZO',NULL,NULL,'cotizacion_5_2020.07.08_10.02.23.pdf',NULL,'2020-07-08 10:02:23',NULL,NULL,NULL,'OMAR HERNANDEZ','OMAR.HDZ@RH.COM','5674 7377','22.2808','2020-07-31',NULL),(6,6,'2020-07-08 10:05:48','EXPORT',NULL,'RRAZO',306,'STANDARD','LESCHACO MEXICANA S.A. DE C.V. CIUDAD DE MEXICO','MEXICO','VERACRUZ','HAMBURG','GERMANY','WEEKLY','Si','RECOLECCION EN CIUDAD DE MEXIC, VALLEJO INDUS','DIRECT','30',NULL,'DAP','PANTALONES DE ALGODON','50000','20','12500','25','NO','SI','25','CLIENTE ACTIVO','MBRAVO','GRAMIREZ','RRAZO',NULL,NULL,'cotizacion_6_2020.07.08_10.26.41.pdf',NULL,'2020-07-08 10:26:41',NULL,NULL,NULL,'ANGELICA PEREZ','ANGELICA.PEREZ@LESCHACO.COM','55 67 68 56 56','22.2808','2020-07-31',NULL),(7,7,'2020-07-08 10:15:42','EXPORT',NULL,'GDURAN',38,'STANDARD','SKYNET CARGO S.A.P.I. DE C.V. CIUDAD DE MEXICO','MEXICO','MANZANILLO','CHATTOGRAM (CHITTAGONG) ','BANGLADESH','WEEKLY','Si','JIUTEPEC, MORELOS','SGSIN','45',NULL,'EXW','METFORMINA','5000','25','1500','3','SI','NO','3','CLIENTE ACTIVO','JRAMOS','GRAMIREZ','GDURAN',NULL,NULL,'cotizacion_7_2020.07.08_10.27.14.pdf',NULL,'2020-07-08 10:27:14',NULL,NULL,NULL,'VANNESA LOPEZ','VANNESA.LO@SKYNET.COM','5536985741','22.2808','2020-07-31',NULL),(8,8,'2020-07-08 10:25:55','EXPORT',NULL,'RRAZO',306,'STANDARD','DHL GLOBAL FORWARDING MEXICO S.A. DE C.V. CIUDAD DE MEXICO','MEXICO','VERACRUZ','HAMBURG','GERMANY','WEEKLY','','RECOLECCION EN CIUDAD DE MEXIC, VALLEJO INDUS','DIRECT','30',NULL,'CIF','ZAPATOS','14000','8','4670','10','NO','SI','10','','MBRAVO','GFUENTES','RRAZO',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CINTIA REYES','CINTIA.REYES','54 56 46 47','22.2808','2020-07-31',NULL),(9,9,'2020-07-08 10:32:59','EXPORT',NULL,'RRAZO',400,'STANDARD','SCHENKER INTERNATIONAL S.A. DE C.V. CIUDAD DE MEXICO','MEXICO','MANZANILLO','CHENNAI (MADRAS)','INDIA','WEEKLY','Si','RECOLECCION EN TORREON COAHUILA','SGSIN','43',NULL,'DAP','PARTES AUTOMOTRICES','100000','45','6759','12','NO','NO','12','CLIENTE ACTIVO','MBRAVO','WLUCERO','RRAZO',NULL,NULL,'cotizacion_9_2020.07.08_10.35.03.pdf',NULL,'2020-07-08 10:35:03',NULL,NULL,NULL,'FABINA DELGADO','FABINA.DELGADO@SCHENKER.COM','55 46 47 464','22.2808','2020-07-31',NULL),(10,10,'2020-07-08 10:37:03','EXPORT',NULL,'AMORALES',247,'STANDARD','BYTA CARGO LOGISTICS S.A.P.I. DE C.V. CIUDAD DE MEXICO','MEXICO','ALTAMIRA','LE HAVRE','FRANCE','WEEKLY','Si','GARZA GARCIA, NUEVO LEON','BEANR','36',NULL,'EXW','FRASCOS DE VIDRIO VACIOS NUEVOS','269','3','1300','3.6','NO','NO','3.6','CLIENTE ACTIVO','MCRUZ','IBARRAGAN','AMORALES',NULL,NULL,'cotizacion_10_2020.07.08_10.37.12.pdf',NULL,'2020-07-08 10:37:12',NULL,NULL,NULL,'OMAR NUÑEZ','ONUNEZ@XXX.COM','987654321','22.2808','2020-07-31',NULL),(11,11,'2020-07-08 10:38:09','EXPORT',NULL,'GDURAN',812,'STANDARD','GRECARGO S.C. CIUDAD DE MEXICO','MEXICO','VERACRUZ','LONDON','UNITED KINGDOM','WEEKLY','Si','EL MARQUES, QRO.','BEANR','35',NULL,'EXW','PUERTAS DE VIDRIO','8000','2','800','6.60','NO','NO','6.60','CLIENTE ACTIVO','MBRAVO','GRAMIREZ','GDURAN',NULL,NULL,'cotizacion_11_2020.07.08_10.38.19.pdf',NULL,'2020-07-08 10:38:19',NULL,NULL,NULL,'DIANA MENDEZ','DIANA@GRECARGO.COM','5524489665','22.2808','2020-07-31',NULL),(12,12,'2020-07-08 10:45:38','EXPORT',NULL,'RRAZO',418,'STANDARD','DHL GLOBAL FORWARDING MEXICO S.A. DE C.V. CIUDAD DE MEXICO','MEXICO','VERACRUZ','DUBLIN','IRELAND','WEEKLY','Si','RECOLECCION EN AGRICOLA ORIENTAL ROJO GOMEZ C','BEANR','34',NULL,'DAP','MONOFILAMENTOS','35000','25','10000','27','NO','NO','27','CLIENTE ACTIVO','MBRAVO','GFUENTES','RRAZO',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ALEX JUAREZ','ALEX.JUAREZ@DHL.COM.MX','55 67686869','22.2808','2020-07-31',NULL),(13,13,'2020-07-08 10:46:06','EXPORT',NULL,'GDURAN',15,'STANDARD','SEA BRIDGE MEXICO S.A. DE C.V. CIUDAD DE MEXICO','MEXICO','MANZANILLO','BRISBANE','AUSTRALIA','WEEKLY','','','SGSIN','47',NULL,'FOB','QUIMICOS','9000','2','1200','4.80','SI','NO','4.80','CLIENTE ACTIVO','NCAMARA','ARASCON','GDURAN',NULL,NULL,'cotizacion_13_2020.07.08_10.49.58.pdf',NULL,'2020-07-08 10:49:58',NULL,NULL,NULL,'HUMBERTO ORDOñEZ','HUMBERTO@SEA.COM','5587142359','22.2808','2020-07-31',NULL),(14,14,'2020-07-08 10:58:19','EXPORT',NULL,'AMORALES',781,'STANDARD','WELLDEX INTERNACIONAL S.C. VERACRUZ','MEXICO','MANZANILLO','LAEM CHABANG','THAILAND','WEEKLY','Si','ORIZABA, VERACRUZ','KRPUS','33',NULL,'EXW','PLACAS DE ACERO','1258','2','5500','3.025','NO','NO','5.50','CLIENTE ACTIVO','RURIBE','WLUCERO','AMORALES',NULL,NULL,'cotizacion_14_2020.07.08_10.59.02.pdf',NULL,'2020-07-08 10:59:02',NULL,NULL,NULL,'NOHEMA SOSA','NSOSA@XXXX.COM','9638527410','22.2808','2020-07-22',NULL),(15,15,'2020-07-08 11:05:08','EXPORT',NULL,'GDURAN',230,'STANDARD','CAPITAL LOGISTICS S.A. DE C.V. GUADALAJARA','MEXICO','VERACRUZ','AARHUS','DENMARK','WEEKLY','','','DEHAM','44',NULL,'DAT','CASCOS','2000','1','800','1.94','NO','SI','1.94','CLIENTE ACTIVO','AELIZALDE','EBARRERA','GDURAN',NULL,NULL,'cotizacion_15_2020.07.08_11.05.21.pdf',NULL,'2020-07-08 11:05:21',NULL,NULL,NULL,'JUAN PEREZ','JUAM@CAPITAL.COM','5544992136','22.2808','2020-07-31',NULL),(16,16,'2020-07-08 11:07:16','EXPORT',NULL,'EGUARNEROS',375,'STANDARD','CARGO Y SERVICIOS INTERNACIONALES S.A. DE C.V. CIUDAD DE MEXICO','MEXICO','MANZANILLO','HONG KONG','HONG KONG','WEEKLY','Si','SAN JUAN DEL RIO, QUERETARO','DIRECT','24',NULL,'DAP','GENERAL','','3 PALLETS','1500','5.37','NO','NO','5.37','CLIENTE ACTIVO','AELIZALDE','GFUENTES','EGUARNEROS',NULL,NULL,'cotizacion_16_2020.07.08_11.33.25.pdf',NULL,'2020-07-08 11:33:25',NULL,NULL,NULL,'ESTEFANI GUARNEROS LUNA','ESTEFANI. INTERTEAM','554789612','22.2808','2020-07-31',NULL),(17,17,'2020-07-08 11:10:23','EXPORT',NULL,'GDURAN',218,'STANDARD','RH SHIPPING AND CHARTERING S. DE R.L. DE C.V. CIUDAD DE MEXICO','MEXICO','VERACRUZ','SAN JOSE','COSTA RICA','WEEKLY','','','DIRECT','10',NULL,'DDP','ROPA','5000','2','2000','2','NO','SI','2.00','CLIENTE ACTIVO','JLPRIETO','GRAMIREZ','GDURAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CARLOS SANCHEZ','CARLOS@RH.COM','5522884514','22.2808','2020-07-31',NULL),(18,18,'2020-07-08 11:59:18','EXPORT',NULL,'EGUARNEROS',656,'STANDARD','AB LOGISTICS DE MEXICO S.A. DE C.V. CIUDAD DE MEXICO','MEXICO','VERACRUZ','COLON','PANAMA','WEEKLY','Si','PUEBLA','DIRECT','12',NULL,'DAP','GENERAL','600','2','500','2.20','SI','SI','2.20','CLIENTE ACTIVO','JRAMOS','GFUENTES','EGUARNEROS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'GABY','GABY. INTERTEAM','45896321','22.2808','2020-07-31',NULL),(19,19,'2020-07-08 12:12:35','EXPORT',NULL,'EGUARNEROS',656,'STANDARD','AB LOGISTICS DE MEXICO S.A. DE C.V. CIUDAD DE MEXICO','MEXICO','VERACRUZ','COLON','PANAMA','WEEKLY','Si','PUEBLA','DIRECT','12',NULL,'DAP','GENERAL','600','2','250','2.20','NO','NO','2.20','CLIENTE ACTIVO','JRAMOS','GFUENTES','EGUARNEROS',NULL,NULL,'cotizacion_19_2020.07.08_12.12.43.pdf',NULL,'2020-07-08 12:12:43',NULL,NULL,NULL,'GABY','JDBCJD','7866','22.2808','2020-07-31',NULL),(20,20,'2020-07-09 17:15:40','EXPORT',NULL,'RRAZO',306,'STANDARD','DHL GLOBAL FORWARDING MEXICO S.A. DE C.V. CIUDAD DE MEXICO','MEXICO','VERACRUZ','HAMBURG','GERMANY','WEEKLY','','','DIRECT','30',NULL,'CIF','CANASTAS','14000','5','12500','15','NO','SI','15','CLIENTE ACTIVO','CRENTERIA','SHURTADO','RRAZO',NULL,NULL,'cotizacion_20_2020.07.09_17.16.07.pdf',NULL,'2020-07-09 17:16:07',NULL,NULL,NULL,'CRVRR','RODRIGO.RAZO@INTERTEAM.COM.MX','4754','22.6213','2020-07-31',NULL),(21,21,'2020-07-14 18:23:56','EXPORT',NULL,'CSAMAYOA',70,'STANDARD','JAS FORWARDING DE MEXICO S.A. DE C.V. GUADALAJARA','MEXICO','VERACRUZ','SANTOS','BRAZIL','WEEKLY','','','DIRECT','22',NULL,'FOB','A','1000','10','200','9','NO','NO','9','CLIENTE ACTIVO','CRENTERIA','ERUIZ','HGUILLEN',NULL,NULL,'cotizacion_21_2020.07.14_18.24.03.pdf',NULL,'2020-07-14 18:24:03',NULL,NULL,NULL,'ASDF','HUGO.GUILLEN@INTERTEAM.COM.MX','5551333602','22.5342','2020-07-25',NULL),(22,22,'2020-07-16 02:05:54','EXPORT',NULL,'HGUILLEN',3,'STANDARD','CAPITAL LOGISTICS S.A. DE C.V. GUADALAJARA','MEXICO','VERACRUZ','ALGER (ALGIERS)','ALGERIA','WEEKLY','','','ESBCN','37',NULL,'','','','','','','','','','CLIENTE ACTIVO','AELIZALDE','ARASCON','HGUILLEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','','22.6173','2020-07-31',NULL),(23,23,'2020-07-09 17:15:40','EXPORT','2020-07-21 16:11:58',NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'cotizacion_23_2020.07.30_17.04.24.pdf',NULL,'2020-07-30 17:04:24',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-07-31',NULL),(24,24,'2020-07-16 02:11:44','EXPORT','0000-00-00 00:00:00','HGUILLEN',2,'STANDARD','CAPITAL LOGISTICS S.A. DE C.V. GUADALAJARA','MEXICO','ALTAMIRA','ALGER (ALGIERS)','ALGERIA','WEEKLY','','','DEHAM','60',NULL,'','','','','','','','','','CLIENTE ACTIVO','AELIZALDE','BDELRIO','HGUILLEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','','22.6173','2020-07-31',NULL),(25,25,'2020-07-16 02:14:46','EXPORT','0000-00-00 00:00:00','HGUILLEN',2,'STANDARD','CAPITAL LOGISTICS S.A. DE C.V. GUADALAJARA','MEXICO','ALTAMIRA','ALGER (ALGIERS)','ALGERIA','WEEKLY','','','DEHAM','60',NULL,'DDP','ZAPATOS','1000','10','10000','9','NO','NO','10.00','CLIENTE ACTIVO','AELIZALDE','ARASCON','AMORALES',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ASDF','ASDFA','5551333602','22.6173','2020-07-31',NULL),(26,26,'2020-07-16 03:13:50','EXPORT','2020-07-31 00:21:49','HGUILLEN',2,'STANDARD','CAPITAL LOGISTICS S.A. DE C.V. GUADALAJARA','MEXICO','ALTAMIRA','ALGER (ALGIERS)','ALGERIA','WEEKLY','','','DEHAM','60',NULL,'FCA','ZAPATOS','','','','','NO','SI','','CLIENTE ACTIVO','AELIZALDE','EBARRERA','HGUILLEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','','22.6173','2020-07-25',NULL),(27,27,'2020-07-16 03:17:34','EXPORT',NULL,'HGUILLEN',2,'STANDARD','CAPITAL LOGISTICS S.A. DE C.V. GUADALAJARA','MEXICO','ALTAMIRA','ALGER (ALGIERS)','ALGERIA','WEEKLY','','','DEHAM','60',NULL,'FOB','ZAPATOS','','','','','NO','SI','','CLIENTE ACTIVO','AELIZALDE','EBARRERA','HGUILLEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','','22.6173','2020-08-01',NULL),(28,28,'2020-07-16 03:43:14','EXPORT',NULL,'HGUILLEN',2,'STANDARD','CAPITAL LOGISTICS S.A. DE C.V. GUADALAJARA','MEXICO','ALTAMIRA','ALGER (ALGIERS)','ALGERIA','WEEKLY','','','DEHAM','60',NULL,'','','','','','','','','','CLIENTE ACTIVO','AELIZALDE','EBARRERA','HGUILLEN',NULL,NULL,'cotizacion_28_2020.07.21_17.49.14.pdf',NULL,'2020-07-21 17:49:14',NULL,NULL,NULL,'','','','22.6173','2020-07-31',NULL),(29,29,'2020-07-16 04:04:37','EXPORT',NULL,'HGUILLEN',2,'STANDARD','CAPITAL LOGISTICS S.A. DE C.V. LEON','MEXICO','ALTAMIRA','ALGER (ALGIERS)','ALGERIA','WEEKLY','','','DEHAM','60',NULL,'','','','','','','','','','CLIENTE ACTIVO','AELIZALDE','EBARRERA','HGUILLEN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','','22.6173','2020-09-05','FUP'),(30,30,'2020-07-29 10:20:22',NULL,NULL,'AMORALES',70,'STANDARD','PANALPINA TRANSPORTES MUNDIALES S.A. DE C.V. MONTERREY','MEXICO','VERACRUZ','SANTOS','BRAZIL','WEEKLY','','','DIRECT','22',NULL,'DAT','RELOJES','1000','10','10000','9','NO','NO','10.00','CLIENTE ACTIVO','CRENTERIA','SHURTADO','AMORALES',NULL,NULL,'cotizacion_30_2020.07.29_10.23.46.pdf',NULL,'2020-07-29 10:23:46',NULL,NULL,NULL,'HUGO GUILLEN','HUGO.GUILLEN@INTERTEAM.COM.MX','5551333602','22.0275','2020-07-31',NULL),(31,31,'2020-07-29 11:06:41',NULL,NULL,'CSAMAYOA',70,'STANDARD','PANALPINA TRANSPORTES MUNDIALES S.A. DE C.V. MONTERREY','MEXICO','VERACRUZ','SANTOS','BRAZIL','WEEKLY','Si','09750 VIADUCTO 146','DIRECT','22',NULL,'FAS','RELOJES','1000','10','10000','9','NO','SI','10.00','CLIENTE ACTIVO','CRENTERIA','SHURTADO','CSAMAYOA',NULL,NULL,'cotizacion_31_2020.07.29_11.08.06.pdf',NULL,'2020-07-29 11:08:06',NULL,NULL,NULL,'ASDF','HUGO.GUILLEN@INTERTEAM.COM.MX','5551333602','22.0275','2020-07-31',NULL);
/*!40000 ALTER TABLE `tarifario_cotizaciones` 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:16:11
