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

DROP TABLE IF EXISTS `tarifasint_n`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tarifasint_n` (
  `idtarifasint` double NOT NULL AUTO_INCREMENT,
  `no_cliente` varchar(255) NOT NULL DEFAULT '',
  `cliente` varchar(255) NOT NULL DEFAULT '',
  `tipo_de_tarifa` varchar(255) NOT NULL DEFAULT '',
  `aplicacion_de_tarifa` varchar(255) NOT NULL DEFAULT '',
  `imp_procedente_de` varchar(255) NOT NULL DEFAULT '',
  `liberacion_en_puerto` varchar(255) NOT NULL DEFAULT '',
  `canje_de_documentos` varchar(255) NOT NULL DEFAULT '',
  `desconsolidacion` varchar(255) NOT NULL DEFAULT '',
  `cargo_minimo` varchar(255) NOT NULL DEFAULT '',
  `recargo_imco` varchar(255) NOT NULL DEFAULT '',
  `recargo_imco_minimo` varchar(255) NOT NULL DEFAULT '',
  `recargo_imco_minimo_mas_tonelada` varchar(255) NOT NULL DEFAULT '',
  `tarifa_vigente_al` varchar(255) NOT NULL DEFAULT '',
  `credito` varchar(255) NOT NULL DEFAULT '',
  `comentarios` varchar(255) NOT NULL DEFAULT '',
  `autorizo` varchar(255) NOT NULL DEFAULT '',
  `fecha_de_actualizacion` varchar(255) NOT NULL DEFAULT '',
  `mayor_que` varchar(255) NOT NULL DEFAULT '',
  `menor_que` varchar(255) NOT NULL DEFAULT '',
  `collect_fee` varchar(255) NOT NULL DEFAULT '',
  `collect_fee_minimo` varchar(255) NOT NULL DEFAULT '',
  `persona` varchar(255) NOT NULL DEFAULT '',
  `fax` varchar(255) NOT NULL DEFAULT '',
  `email` text NOT NULL,
  `contenedor` varchar(255) NOT NULL DEFAULT '',
  `nicknamet` varchar(150) NOT NULL DEFAULT '',
  `liberacion_en_puerto_usd` varchar(50) NOT NULL DEFAULT '',
  `canje_de_documentos_usd` varchar(50) NOT NULL DEFAULT '',
  `desconsolidacion_usd` varchar(50) NOT NULL DEFAULT '',
  `recargo_imco_minimo_usd` varchar(100) NOT NULL DEFAULT '',
  `recargo_imco_minimo_mas_tonelada_usd` varchar(100) NOT NULL DEFAULT '',
  `validacion_mn` varchar(50) NOT NULL DEFAULT '',
  `validacion_usd` varchar(50) NOT NULL DEFAULT '',
  `administration_fee_mn` varchar(50) NOT NULL DEFAULT '',
  `administration_fee_usd` varchar(50) NOT NULL DEFAULT '',
  `acuerdos_especiales` varchar(250) NOT NULL DEFAULT '',
  `cobro_en_pesos` varchar(250) NOT NULL DEFAULT '',
  `port_transfer_fee_tarifario` varchar(50) NOT NULL,
  `moneda_liberacion_en_puerto` varchar(3) DEFAULT NULL,
  `moneda_port_transfer_fee` varchar(3) DEFAULT NULL,
  `tipo_tarifa_standard` varchar(255) DEFAULT NULL,
  `historial` text,
  `vigencia` date DEFAULT NULL,
  PRIMARY KEY (`idtarifasint`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tarifasint_n`
--

LOCK TABLES `tarifasint_n` WRITE;
/*!40000 ALTER TABLE `tarifasint_n` DISABLE KEYS */;
INSERT INTO `tarifasint_n` VALUES (37,'','','LCL/LCL','','','147','0','0','02','0','','','','','TARIFA NO TRANSFERIBLE','','2018-03-06','00','55','03','','','','NO APLICA','','','','12','60','350','','0','15','0','15','UNICAMENTE PARA USO DE EDUARDO CASTRO','','10','USD','USD','ESPECIAL PANDA CD USD ZLO CIF','2016-11-17 05:51:15 REGISTRO NUEVA TARIFA NORMA CAMARA<br>2018-03-06 09:33:52 EDITO NORMA CAMARA','2017-02-28'),(46,'','','AEREO/AIR','','','60','0','0','00','0','','','','','TARIFA NO TRANSFERIBLE','','2019-03-25','01','01','00','','','','','','','','0','0','0','','0','10','0','10','UNICAMENTE PARA USO DE AEREOS','','00','USD','USD','AIR MEX','2019-03-21 02:49:00 REGISTRO NUEVA TARIFA NORMA CAMARA<br>2019-03-25 11:45:11 EDITO NORMA CAMARA<br>2019-03-25 11:45:19 EDITO NORMA CAMARA<br>2019-03-25 11:45:32 EDITO NORMA CAMARA<br>2019-03-25 11:45:39 EDITO NORMA CAMARA','2019-06-30'),(48,'','','LCL/LCL','','','100','0','0','02','0','','250','','','TARIFA NO TRANSFERIBLE','','2020-01-09','00','55','04','','','','','','','','12','55','250','','0','10','0','10','','','10','USD','USD','SPLC CD USD','2020-01-07 12:53:38 REGISTRO NUEVA TARIFA NORMA CAMARA<br>2020-01-07 12:56:15 EDITO NORMA CAMARA<br>2020-01-09 05:26:47 EDITO ELIZABETH BEDOLLA','2020-06-30'),(49,'','','LCL/LCL','','','1722','0','770','02','4052','','4052','','','TARIFA NO TRANSFERIBLE','','2020-01-09','00','55','04','','','','','','','','0','0','0','','200','0','200','0','','','205','MXP','MXP','SPLC FF MXP','2020-01-09 05:37:19 REGISTRO NUEVA TARIFA ELIZABETH BEDOLLA<br>2020-01-09 05:43:11 EDITO ELIZABETH BEDOLLA','2020-06-30'),(50,'','','LCL/LCL','','','85','0','0','02','0','','200','','','TARIFA NO TRANSFERIBLE','','2020-01-09','00','55','04','','','','','','','','0','38','200','','0','10','0','10','','','10','USD','USD','SPLC FF USD','2020-01-09 05:41:38 REGISTRO NUEVA TARIFA ELIZABETH BEDOLLA<br>2020-01-09 05:45:04 EDITO ELIZABETH BEDOLLA','2020-06-30'),(51,'','','LCL/LCL','','','77','0','0','02','0','','200','','','TARIFA NO TRANSFERIBLE','','2020-01-09','00','55','00','','','','','','','','0','34','200','','0','10','0','10','','','10','USD','USD','EPLC FOB F','2020-01-09 06:05:51 REGISTRO NUEVA TARIFA ELIZABETH BEDOLLA<br>2020-01-09 06:06:16 EDITO ELIZABETH BEDOLLA','2020-06-30'),(52,'','','LCL/LCL','','','68','0','0','02','0','','200','','','TARIFA NO TRANSFERIBLE','','2020-01-13','00','55','00','','','','','','','','0','30','200','','0','10','0','10','','','10','USD','USD','EPLC FOB E','2020-01-13 10:12:08 REGISTRO NUEVA TARIFA ELIZABETH BEDOLLA<br>2020-01-13 10:12:38 EDITO ELIZABETH BEDOLLA','2020-06-30'),(53,'','','LCL/LCL','','','64','0','0','02','0','','200','','','TARIFA NO TRANSFERIBLE','','2020-01-13','00','55','00','','','','','','','','0','29','200','','0','10','0','10','','','10','USD','USD','EPLC FOB D','2020-01-13 10:13:56 REGISTRO NUEVA TARIFA ELIZABETH BEDOLLA<br>2020-01-13 10:14:13 EDITO ELIZABETH BEDOLLA','2020-06-30'),(54,'','','LCL/LCL','','','55','0','0','02','0','','200','','','TARIFA NO TRANSFERIBLE','','2020-01-13','00','55','00','','','','','','','','0','25','200','','0','10','0','10','','','10','USD','USD','EPLC FOB C','2020-01-13 10:28:10 REGISTRO NUEVA TARIFA ELIZABETH BEDOLLA<br>2020-01-13 10:28:25 EDITO ELIZABETH BEDOLLA','2020-06-30'),(55,'','','LCL/LCL','','','51','0','0','02','0','','200','','','TARIFA NO TRANSFERIBLE','','2020-01-13','00','55','00','','','','','','','','0','23','200','','0','10','0','10','','','10','USD','USD','EPLC FOB B','2020-01-13 10:29:01 REGISTRO NUEVA TARIFA ELIZABETH BEDOLLA<br>2020-01-13 10:29:17 EDITO ELIZABETH BEDOLLA','2020-06-30'),(56,'','','LCL/LCL','','','43','0','0','02','0','','200','','','TARIFA NO TRANSFERIBLE','','2020-01-13','00','55','00','','','','','','','','0','19','200','','0','10','0','10','','','10','USD','USD','EPLC FOB A','2020-01-13 10:29:43 REGISTRO NUEVA TARIFA ELIZABETH BEDOLLA<br>2020-01-13 10:29:53 EDITO ELIZABETH BEDOLLA','2020-06-30'),(57,'','','LCL/LCL','','','77','0','0','02','0','','200','','','TARIFA NO TRANSFERIBLE','','2020-01-13','00','55','04','','','','','','','','0','34','200','','0','10','0','10','','','10','USD','USD','EPLC CIF F','2020-01-13 12:10:38 REGISTRO NUEVA TARIFA ELIZABETH BEDOLLA<br>2020-01-13 12:13:32 EDITO ELIZABETH BEDOLLA','2020-06-30'),(58,'','','LCL/LCL','','','68','0','0','02','0','','200','','','TARIFA NO TRANSFERIBLE','','2020-01-13','00','55','04','','','','','','','','0','30','200','','0','10','0','10','','','10','USD','USD','EPLC CIF E','2020-01-13 12:13:08 REGISTRO NUEVA TARIFA ELIZABETH BEDOLLA<br>2020-01-13 12:13:48 EDITO ELIZABETH BEDOLLA','2020-06-30'),(59,'','','LCL/LCL','','','64','0','0','02','0','','200','','','TARIFA NO TRANSFERIBLE','','2020-01-13','00','55','04','','','','','','','','0','29','200','','0','10','0','10','','','10','USD','USD','EPLC CIF D','2020-01-13 12:14:22 REGISTRO NUEVA TARIFA ELIZABETH BEDOLLA<br>2020-01-13 12:14:35 EDITO ELIZABETH BEDOLLA','2020-06-30'),(60,'','','LCL/LCL','','','55','0','0','02','0','','200','','','TARIFA NO TRANSFERIBLE','','2020-01-13','00','55','04','','','','','','','','0','25','200','','0','10','0','10','','','10','USD','USD','EPLC CIF C','2020-01-13 12:15:09 REGISTRO NUEVA TARIFA ELIZABETH BEDOLLA<br>2020-01-13 12:15:19 EDITO ELIZABETH BEDOLLA','2020-06-30'),(61,'','','LCL/LCL','','','51','0','0','02','0','','200','','','TARIFA NO TRANSFERIBLE','','2020-01-13','00','55','04','','','','','','','','0','23','200','','0','10','0','10','','','10','USD','USD','EPLC CIF B','2020-01-13 12:15:53 REGISTRO NUEVA TARIFA ELIZABETH BEDOLLA<br>2020-01-13 12:16:13 EDITO ELIZABETH BEDOLLA','2020-06-30'),(62,'','','LCL/LCL','','','43','0','0','02','0','','200','','','TARIFA NO TRANSFERIBLE','','2020-01-13','00','55','04','','','','','','','','0','19','200','','0','10','0','10','','','10','USD','USD','EPLC CIF A','2020-01-13 12:16:39 REGISTRO NUEVA TARIFA ELIZABETH BEDOLLA<br>2020-01-13 12:16:55 EDITO ELIZABETH BEDOLLA','2020-06-30'),(63,'','','LCL/LCL','','','77','0','0','02','0','','200','','','TARIFA NO TRANSFERIBLE','','2020-01-13','00','55','00','','','','','','','','0','34','200','','0','10','0','10','','','10','USD','USD','EPLC ALL F','2020-01-13 12:17:50 REGISTRO NUEVA TARIFA ELIZABETH BEDOLLA<br>2020-01-13 12:18:09 EDITO ELIZABETH BEDOLLA','2020-06-30'),(64,'','','LCL/LCL','','','68','0','0','02','0','','200','','','TARIFA NO TRANSFERIBLE','','2020-01-13','00','55','00','','','','','','','','0','30','200','','0','10','0','10','','','10','USD','USD','EPLC ALL E','2020-01-13 12:18:33 REGISTRO NUEVA TARIFA ELIZABETH BEDOLLA<br>2020-01-13 12:18:46 EDITO ELIZABETH BEDOLLA','2020-06-30'),(65,'','','LCL/LCL','','','64','0','0','02','0','','200','','','TARIFA NO TRANSFERIBLE','','2020-01-13','00','55','00','','','','','','','','0','29','200','','0','10','0','10','','','10','USD','USD','EPLC ALL D','2020-01-13 12:19:09 REGISTRO NUEVA TARIFA ELIZABETH BEDOLLA<br>2020-01-13 12:19:21 EDITO ELIZABETH BEDOLLA','2020-06-30'),(66,'','','LCL/LCL','','','55','0','0','02','0','','200','','','TARIFA NO TRANSFERIBLE','','2020-01-13','00','55','00','','','','','','','','0','25','200','','0','10','0','10','','','10','USD','USD','EPLC ALL C','2020-01-13 12:19:53 REGISTRO NUEVA TARIFA ELIZABETH BEDOLLA<br>2020-01-13 12:20:18 EDITO ELIZABETH BEDOLLA','2020-06-30'),(67,'','','LCL/LCL','','','51','0','0','02','0','','200','','','TARIFA NO TRANSFERIBLE','','2020-01-13','00','55','00','','','','','','','','0','23','200','','0','10','0','10','','','10','USD','USD','EPLC ALL B','2020-01-13 12:20:39 REGISTRO NUEVA TARIFA ELIZABETH BEDOLLA<br>2020-01-13 12:20:50 EDITO ELIZABETH BEDOLLA','2020-06-30'),(68,'','','LCL/LCL','','','43','0','0','02','0','','200','','','TARIFA NO TRANSFERIBLE','','2020-01-13','00','55','00','','','','','','','','0','19','200','','0','10','0','10','','','10','USD','USD','EPLC ALL A','2020-01-13 12:21:20 REGISTRO NUEVA TARIFA ELIZABETH BEDOLLA<br>2020-01-13 12:21:32 EDITO ELIZABETH BEDOLLA','2020-06-30'),(69,'','','LCL/LCL','','','1291.50','0','577.50','02','4052','','4052 ','','','TARIFA NO TRANSFERIBLE','','2020-01-17','00','55','00','','','','','','','','0','0','0','','200','0','200','0','','','205','MXP','MXP','EPLC FOB D MXP','2020-01-17 12:31:11 REGISTRO NUEVA TARIFA ELIZABETH BEDOLLA<br>2020-01-17 12:31:41 EDITO ELIZABETH BEDOLLA','2020-06-30'),(70,'','','LCL/LCL','','','85','0','0','02','0','','200','','','TARIFA NO TRANSFERIBLE','','2020-02-13','00','55','04','','','','','','','','0','38','200','','0','10','0','10','','','10','USD','USD','SPLC FF USD CIF','2020-01-29 12:26:33 REGISTRO NUEVA TARIFA ELIZABETH BEDOLLA<br>2020-01-29 12:26:54 EDITO ELIZABETH BEDOLLA<br>2020-02-13 03:35:51 EDITO ELIZABETH BEDOLLA','2020-06-30'),(71,'','','FCL/FCL','','','130','0','0','01','0','','0','','','TARIFA NO TRANSFERIBLE','','2020-02-13','1','1','00','','','','','','','','0','0','','','0','10','0','10','','','0','USD','USD','FCL FOB','2020-02-13 03:39:39 REGISTRO NUEVA TARIFA ELIZABETH BEDOLLA','2020-06-30'),(72,'','','FCL/FCL','','','150','0','0','01','0','','0','','','TARIFA NO TRANSFERIBLE','','2020-06-09','1','1','00','','','','','','','','0','0','','','0','10','0','20','EXCLUSIVA OPERACIONES IMPORTACION ***SOLICITUD AYEPEZ***','','0','USD','USD','FCL CIF','2020-06-09 09:06:58 REGISTRO NUEVA TARIFA NORMA CAMARA','2020-12-31');
/*!40000 ALTER TABLE `tarifasint_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:21:13
