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

DROP TABLE IF EXISTS `servicios_terrestres_importes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `servicios_terrestres_importes` (
  `idimporte` int(11) NOT NULL AUTO_INCREMENT,
  `numero_de_guia_terrestre` varchar(100) DEFAULT NULL,
  `concepto` varchar(255) DEFAULT NULL,
  `importe` varchar(255) DEFAULT NULL,
  `moneda` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`idimporte`)
) ENGINE=InnoDB AUTO_INCREMENT=304 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `servicios_terrestres_importes`
--

LOCK TABLES `servicios_terrestres_importes` WRITE;
/*!40000 ALTER TABLE `servicios_terrestres_importes` DISABLE KEYS */;
INSERT INTO `servicios_terrestres_importes` VALUES (14,'TINTCLYLZC0004.16','ALMACENAJES','1','USD'),(15,'TINTCLYLZC0004.16','ENTREGA EN PUERTO','2','USD'),(16,'TINTCLYLZC0004.16','LAYOVER FEE (ESTADIAS)','5','USD'),(18,'TINTNDJVER0021.17','PICK UP (LUMPSUM)','450','USD'),(23,'TINTLERAPZ0190.17','INLAND FREIGHT (LUMPSUM)','3900','MXP'),(24,'TINTNDJAPZ0224.17','FLETE W/M','32','USD'),(25,'TINTNDJAPZ0224.17','RECOLECCION Y ENTREGA EN PUERTO','89','USD'),(27,'TINTZLOAPD0226.17','INLAND FREIGHT (LUMPSUM)','1000','MXP'),(28,'TINTMEXNJD0236.17','FLETE LUPSUM','250','USD'),(32,'TINTMAMVER0238.17','FLETE EN FALSO','1500','USD'),(33,'TINTMAMVER0238.17','INLAND FREIGHT W/M','100','MXP'),(34,'TINTMAMVER0238.17','RECOLECCION Y ENTREGA','50','MXP'),(35,'TINTAZCCHT0240.17','PICK UP & DELIVERY','14','MXP'),(37,'TINTMXVERNDJ0249.17','FLETE LUPSUM','490','USD'),(38,'TINTATMGDL0250.17','FLETE LUPSUM','560','USD'),(40,'TINTZLOQRO0133.18','RECOLECCION Y ENTREGA','230','USD'),(41,'TINTZLOTLC0150.18','CARGO DE CITA','1','MXP'),(44,'TINTIRPMEX2750.18','INLAND FREIGHT (LUMPSUM)','207.20','USD'),(45,'TINTAGUATM2738.18','FLETE LUMPSUM','330.40','USD'),(46,'TINTVERVER2778.18','PICK UP (LUMPSUM)','127.68','MXP'),(51,'TINTRMAMEX2734.18','FLETE LUMPSUM','257.60','MXP'),(52,'TINTRMAMEX2734.18','ALMACENAJES','194.88','MXP'),(53,'TINTAPDESC2893.18','FLETE LUMPSUM','95.20','MXP'),(58,'TINTMTYMTY3245.18','FLETE W/M','242.31','USD'),(59,'TINTMTYMTY3245.18','PICK UP & DELIVERY','94.08','USD'),(60,'TINTMTYMTY3245.18','FLETE LUMPSUM','436.80','USD'),(61,'TINTQROVER3267.18','INLAND FREIGHT (LUMPSUM)','672.00','MXP'),(64,'TINTQROQRO3341.18','FLETE LUMPSUM','166.00','USD'),(65,'TINTQROQRO3341.18','FLETE LUMPSUM','120.00','USD'),(66,'TINTQROQRO3341.18','ALMACENAJES','1116.00','USD'),(67,'TINTQROQRO3342.18','FLETE LUMPSUM','166.00','USD'),(68,'TINTQROQRO3342.18','FLETE LUMPSUM','120.00','USD'),(69,'TINTQROQRO3342.18','ALMACENAJES','372.00','USD'),(70,'TINTTLCMEX3492.18','FLETE LUMPSUM','437.69','USD'),(71,'TINTTLCMEX3492.18','DEMORAS','87.00','USD'),(72,'TINTTLCMEX3492.18','FLETE LUMPSUM','218.85','USD'),(78,'TINTGLPZLO3726.18','INLAND FREIGHT MIN','147.84','USD'),(79,'TINTGLPZLO3726.18','PICK UP (LUMPSUM)','94.08','USD'),(80,'TINTSTCNDJ3281.18','INLAND FREIGHT (LUMPSUM)','6282.51','MXP'),(81,'TINTGLPZLO3907.18','INLAND FREIGHT (LUMPSUM)','147.84','USD'),(82,'TINTGLPZLO3907.18','PICK UP & DELIVERY','94.08','USD'),(83,'TINTSTCZLO3525.18','FLETE LUMPSUM','8843.24','MXP'),(84,'TINTMEXMGA3833.18','INLAND FREIGHT (LUMPSUM)','1232.15','MXP'),(85,'TINTNDJZLO4238.18','PICK UP (LUMPSUM)','6282.51','MXP'),(86,'TINTIXPVER4281.18','INLAND FREIGHT (LUMPSUM)','884.80','USD'),(97,'TINTTEQVER4365.18','INLAND FREIGHT (LUMPSUM)','392.00','USD'),(98,'TINTVERTEQ4318.18','INLAND FREIGHT (LUMPSUM)','548.80','USD'),(102,'TINTSTCSTC4414.18','FLETE LUMPSUM','190.40','USD'),(103,'TINTNDJNDJ4453.18','FLETE EN FALSO','139.20','USD'),(106,'TINTVERSLP4332.18','RECOLECCION Y ENTREGA','4787.72','USD'),(107,'TINTVERMEX4438.18','RECOLECCION Y ENTREGA','5847.52','MXP'),(108,'TINTZLOSLP4455.18','RECOLECCION Y ENTREGA','17167.92','MXP'),(110,'TINTAPDAPD4545.18','INLAND FREIGHT (LUMPSUM)','380.80','MXP'),(111,'TINTCHLZLO4590.18','FLETE LUMPSUM','840.00','USD'),(116,'TINTVERNDJ4652.18','RECOLECCION Y ENTREGA','302.48','USD'),(117,'TINTZLOSLP4646.18','RECOLECCION Y ENTREGA','6262.50','MXP'),(121,'TINTRMAZLO4657.18','FLETE LUMPSUM','627.20','USD'),(123,'TINTRMAZLO4736.18','PICK UP (LUMPSUM)','638.40','USD'),(124,'TINTNDJVER4870.18','FLETE LUMPSUM','6372.80','MXP'),(126,'TINTZLOSLP4493.18','RECOLECCION Y ENTREGA','14516.87','MXP'),(128,'TINTZLOQRO4844.18','RECOLECCION Y ENTREGA','6074.69','MXP'),(131,'TINTZLOSLP4871.18','RECOLECCION Y ENTREGA','10132.89','MXP'),(132,'TINTNDJZLO4912.18','INLAND FREIGHT (LUMPSUM)','3770','MXP'),(134,'TINTZLOSLP4821.18','RECOLECCION Y ENTREGA','8341.66','MXP'),(135,'TINTZLOSLP4872.18','RECOLECCION Y ENTREGA','8341.66','MXP'),(136,'TINTZLOQRO4873.18','RECOLECCION Y ENTREGA','260','USD'),(137,'TINTVERAPZ4874.18','RECOLECCION Y ENTREGA','345','USD'),(138,'TINTOAXZLO4983.18','PICK UP (LUMPSUM)','1220.80','USD'),(140,'TINTNDJZLO4761.18','FLETE LUMPSUM','6282.51','MXP'),(142,'TINTSTCZLO4762.18','FLETE LUMPSUM','5550.71','MXP'),(143,'TINTRMAZLO5036.18','INLAND FREIGHT (LUMPSUM)','621.90','USD'),(150,'TINTVERNDJ5072.18','RECOLECCION Y ENTREGA','4339.56','MXP'),(151,'TINTVERCUT5085.18','RECOLECCION Y ENTREGA','3527.50','MXP'),(152,'TINTVERMTY5124.18','RECOLECCION Y ENTREGA','5102.61','MXP'),(154,'TINTRMAZLO4880.18','RECOLECCION Y ENTREGA','9866.70',''),(155,'TINTNDJZLO4905.18','RECOLECCION Y ENTREGA','3454.39','MXP'),(156,'TINTNDJZLO4908.18','RECOLECCION Y ENTREGA','4312','MXP'),(157,'TINTVERZLO5025.18','INLAND FREIGHT (LUMPSUM)','10876.1','MXP'),(158,'TINTZLOSLP5101.18','RECOLECCION Y ENTREGA','4446.82','MXP'),(160,'TINTVERNDJ0177.19','FLETE LUMPSUM','340','USD'),(161,'TINTVERMEX0182.19','PICK UP (LUMPSUM)','240.59','USD'),(162,'TINTNDJZLO0084.19','INLAND FREIGHT (LUMPSUM)','3850','MXP'),(163,'TINTVERCUT0196.19','FLETE LUMPSUM','280','USD'),(164,'TINTVERNDJ0243.19','INLAND FREIGHT (LUMPSUM)','331.6','USD'),(165,'TINTVERCUT0007.19','FLETE LUMPSUM','218.96','USD'),(168,'TINTVERCUT0252.19','INLAND FREIGHT (LUMPSUM)','194','USD'),(171,'TINTZLOQUE0343.19','INLAND FREIGHT (LUMPSUM)','27000','MXP'),(189,'TINTCLYZLO0443.19','INLAND FREIGHT MIN','103.04','USD'),(190,'TINTCLYZLO0443.19','PICK UP (LUMPSUM)','94.08','USD'),(195,'TINTZLOSLP0380.19','FLETE LUMPSUM','4508.03','MXP'),(198,'TINTRMAZLO5146.18','INLAND FREIGHT (LUMPSUM)','627.20','USD'),(199,'TINTRMAZLO5146.18','STORAGES (INLAND)','14.73','USD'),(202,'TINTNDJZLO0476.19','INLAND FREIGHT (LUMPSUM)','3830.40','MXP'),(204,'TINTNDJVER0521.19','FLETE LUMPSUM','4078.50','USD'),(208,'TINTNDJZLO0358.19','INLAND FREIGHT (LUMPSUM)','7712.54','MXP'),(209,'TINTVERCUT0490.19','INLAND FREIGHT (LUMPSUM)','270','USD'),(210,'TINTNDJZLO0542.19','PICK UP (LUMPSUM)','2,904.65 ','MXP'),(211,'TINTVERNDJ0498.19','INLAND FREIGHT W/M','32','USD'),(212,'TINTVERNDJ0498.19','PICK UP & DELIVERY','130','USD'),(213,'TINTZLOMEX0475.19','PICK UP (LUMPSUM)','233','USD'),(214,'TINTVERCUT0595.19','INLAND FREIGHT (LUMPSUM)','360','USD'),(215,'TINTRMAZLO0658.19','FLETE LUMPSUM','800','USD'),(216,'TINTVERNDJ0613.19','INLAND FREIGHT (LUMPSUM)','360.08','USD'),(218,'TINTVERTLP0653.19','INLAND FREIGHT (LUMPSUM)','575','USD'),(219,'TINTOAXZLO0713.19','INLAND FREIGHT (LUMPSUM)','680','USD'),(220,'TINTVERQRO5173.18','FLETE LUMPSUM',' 9960 ','MXP'),(221,'TINTZLOAPD0811.19','INLAND FREIGHT (LUMPSUM)','574.84','USD'),(222,'TINTVERNDJ0621.19','INLAND FREIGHT (LUMPSUM)','382.8','USD'),(223,'TINTTLAZLO0816.19','INLAND FREIGHT MIN','76.16','USD'),(224,'TINTTLAZLO0816.19','PICK UP & DELIVERY','94.08','USD'),(227,'TINTVERCUT0846.19','INLAND FREIGHT (LUMPSUM)','194','USD'),(230,'TINTVERNDJ0856.19','INLAND FREIGHT (LUMPSUM)','317.84','USD'),(231,'TINTRMAVER4282.18','INLAND FREIGHT MIN','183.68','USD'),(232,'TINTRMAVER4282.18','PICK UP & DELIVERY','94.08','USD'),(233,'TINTRMAVER4282.18','DEMORAS','17.40','USD'),(237,'TINTGUAMEX0825.19','INLAND FREIGHT (LUMPSUM)','296.80','USD'),(238,'TINTGUAMEX0825.19','ALMACENAJES','255.20','USD'),(241,'TINTZLOMEX1022.19','PICK UP (LUMPSUM)','350','USD'),(242,'TINTVERQRO1043.19','INLAND FREIGHT W/M','61','USD'),(243,'TINTVERQRO1043.19','PICK UP & DELIVERY','130','USD'),(244,'TINTVERNDJ0998.19','INLAND FREIGHT W/M','32','USD'),(245,'TINTVERNDJ0998.19','PICK UP & DELIVERY','130','USD'),(246,'TINTVERCUT1099.19','INLAND FREIGHT W/M','32','USD'),(247,'TINTVERCUT1099.19','PICK UP & DELIVERY','130','USD'),(248,'TINTZLOTTN1100.19','INLAND FREIGHT W/M','34','USD'),(249,'TINTZLOTTN1100.19','PICK UP & DELIVERY','130','USD'),(252,'TINTZLOSLP1168.19','INLAND FREIGHT W/M','50','USD'),(253,'TINTZLOSLP1168.19','RECOLECCION Y ENTREGA','130','USD'),(254,'TINTNDJZLO1095.19','FLETE LUMPSUM','6027.00','MXP'),(256,'TINTVERNDJ0876.19','RECOLECCION Y ENTREGA','3094.95','MXP'),(257,'TINTATMZLO1196.19','INLAND FREIGHT (LUMPSUM)','220','USD'),(258,'TINTVERSTC1143.19','INLAND FREIGHT (LUMPSUM)','740','USD'),(259,'TINTZLOTLQ1194.19','INLAND FREIGHT W/M','33','USD'),(260,'TINTZLOTLQ1194.19','RECOLECCION Y ENTREGA','130','USD'),(261,'TINTVERNDJ1224.19','PICK UP (LUMPSUM)','395','USD'),(262,'TINTMTYZLO1337.19','INLAND FREIGHT (LUMPSUM)','8200','MXP'),(264,'TINTNDJZLO0544.19','INLAND FREIGHT (LUMPSUM)','3120.87','MXP'),(265,'TINTGDLZLO1339.19','INLAND FREIGHT (LUMPSUM)','5897','MXP'),(266,'TINTMTYZLO1340.19','INLAND FREIGHT (LUMPSUM)','6525','MXP'),(267,'TINTNDJZLO1343.19','INLAND FREIGHT (LUMPSUM)','4660','MXP'),(269,'TINTZLOGDL1409.19','INLAND FREIGHT (LUMPSUM)','350','USD'),(274,'TINTZLOTPR1379.19','INLAND FREIGHT (LUMPSUM)','690','USD'),(282,'TINTMTYZLO1508.19','INLAND FREIGHT (LUMPSUM)','9994','MXP'),(283,'TINTNDJZLO1386.19','INLAND FREIGHT (LUMPSUM)','5390','MXP'),(284,'TINTNDJZLO1385.19','INLAND FREIGHT (LUMPSUM)','5276','MXP'),(286,'TINTATMSLP1492.19','INLAND FREIGHT (LUMPSUM)','910','USD'),(289,'TINTRMAZLO1516.19','INLAND FREIGHT (LUMPSUM)','672.00','USD'),(291,'TINTZLOCHL1515.19','RECOLECCION Y ENTREGA','210','USD'),(292,'TINTZLOCHL1515.19','LAYOVER FEE (ESTADIAS)','480','MXP'),(293,'TINTNDJZLO1395.19','INLAND FREIGHT (LUMPSUM)','8399','MXP'),(296,'TINTVERCUT1550.19','INLAND FREIGHT W/M','32','USD'),(297,'TINTVERCUT1550.19','RECOLECCION Y ENTREGA','130','USD'),(298,'TINTNDJZLO1620.19','INLAND FREIGHT (LUMPSUM)','2440','MXP'),(301,'TINTLZCMEX1643.19','INLAND FREIGHT W/M','37','USD'),(302,'TINTLZCMEX1643.19','RECOLECCION Y ENTREGA','130','USD'),(303,'TINTNDJZLO1766.19','INLAND FREIGHT (LUMPSUM)','3260','MXP');
/*!40000 ALTER TABLE `servicios_terrestres_importes` 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:50:35
