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

DROP TABLE IF EXISTS `montos_especiales`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `montos_especiales` (
  `id_monto` int(11) NOT NULL AUTO_INCREMENT,
  `id_cliente_tarifario` int(11) NOT NULL,
  `codigo_tarifario` varchar(45) DEFAULT NULL,
  `concepto` varchar(45) DEFAULT NULL,
  `minimo_porcentual` int(11) DEFAULT NULL,
  `maximo_porcentual` int(11) DEFAULT NULL,
  `minimo_valor` int(11) DEFAULT NULL,
  `maximo_valor` int(11) DEFAULT NULL,
  PRIMARY KEY (`id_monto`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `montos_especiales`
--

LOCK TABLES `montos_especiales` WRITE;
/*!40000 ALTER TABLE `montos_especiales` DISABLE KEYS */;
INSERT INTO `montos_especiales` VALUES (1,3,NULL,'of_wm',10,9,NULL,NULL),(2,3,NULL,'of_min',10,9,NULL,NULL),(3,3,NULL,'pss',10,9,NULL,NULL),(4,3,NULL,'sec_fee',10,9,NULL,NULL),(5,3,NULL,'baf_wm',10,9,NULL,NULL),(6,3,NULL,'doc_fee',10,9,NULL,NULL),(7,3,NULL,'efaf_wm',10,9,NULL,NULL),(8,3,NULL,'handling',10,9,NULL,NULL),(9,3,NULL,'transmision_ams_fee',10,9,NULL,NULL),(10,3,NULL,'low_sulphure_surcharge_wm',10,9,NULL,NULL),(11,3,NULL,'ts_doc_fee_per_bl',10,9,NULL,NULL),(12,3,NULL,'ams_fee_per_bl',10,9,NULL,NULL),(13,3,NULL,'ddc_wm',10,9,NULL,NULL),(14,3,NULL,'ens_fee_per_bl',10,9,NULL,NULL),(15,3,NULL,'wrs_wm',10,9,NULL,NULL),(16,3,NULL,'bmsb_surchargue_wm_usd',10,9,NULL,NULL),(17,3,NULL,'bmsb_surchargue_minimum_usd',10,9,NULL,NULL),(18,3,NULL,'ts_vgm_fee_per_bl',10,9,NULL,NULL),(19,3,NULL,'ts_charges_ls',10,9,NULL,NULL),(20,3,NULL,'ts_charges_ls1',10,9,NULL,NULL),(21,3,NULL,'consol_fee_wm',10,9,NULL,NULL),(22,3,NULL,'doc_fee_per_bl',10,9,NULL,NULL),(23,3,NULL,'vgm_fee_per_bl',10,9,NULL,NULL),(24,3,NULL,'port_transfer_fee_wm',10,9,NULL,NULL),(25,3,NULL,'transmission_fee_per_bl',10,9,NULL,NULL),(26,3,NULL,'admon_fee_per_bl',10,9,NULL,NULL),(27,3,NULL,'custom_clearence',10,9,NULL,NULL),(28,3,NULL,'insurance_per_shipment',10,9,NULL,NULL),(29,3,NULL,'iva',10,9,NULL,NULL),(30,3,NULL,'ts_frequency',10,9,NULL,NULL),(31,3,NULL,'oncarriage_minimum_charge_usd',10,9,NULL,NULL),(32,3,NULL,'oncarriage_wm_charge_usd',10,9,NULL,NULL),(33,3,NULL,'precarriage_minimum_charge_usd',10,9,NULL,NULL),(34,3,NULL,'precarriage_wm_charge_usd',10,9,NULL,NULL),(35,4,NULL,'of_wm',20,5,NULL,NULL),(36,4,NULL,'low_sulphure_surcharge_wm',20,5,NULL,NULL),(37,2,NULL,'of_wm',4,10,NULL,NULL),(38,2,NULL,'of_min',4,10,NULL,NULL);
/*!40000 ALTER TABLE `montos_especiales` 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:02:02
