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

DROP TABLE IF EXISTS `tarifario_conceptos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tarifario_conceptos` (
  `id_concepto` int(11) NOT NULL AUTO_INCREMENT,
  `concepto` varchar(100) DEFAULT NULL,
  `unidad` varchar(255) DEFAULT NULL,
  `monedas` varchar(255) DEFAULT NULL,
  `calculo` varchar(255) DEFAULT NULL,
  `impuesto` int(11) DEFAULT NULL,
  `categoria` varchar(100) DEFAULT NULL,
  `servicio` varchar(50) DEFAULT NULL,
  `activo` tinyint(4) DEFAULT '1',
  PRIMARY KEY (`id_concepto`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tarifario_conceptos`
--

LOCK TABLES `tarifario_conceptos` WRITE;
/*!40000 ALTER TABLE `tarifario_conceptos` DISABLE KEYS */;
INSERT INTO `tarifario_conceptos` VALUES (1,'Pick-up Charges','LS','USD,MXN',NULL,16,'DOMESTIC INLAND SERVICE','CROSS BORDER',1),(2,'Inland Service Coordination (Dedicated Service)','LS','USD,MXN',NULL,16,'DOMESTIC INLAND SERVICE','CROSS BORDER',1),(3,'Non-Stackable Surcharge','LS,MIN,W/M','USD,MXN','35 % Valor total del flete',16,'DOMESTIC INLAND SERVICE','CROSS BORDER',1),(4,'DOC FEE','LS','USD,MXN',NULL,16,'DOMESTIC INLAND SERVICE','CROSS BORDER',1),(5,'Customs Inspection','LS','USD,MXN',NULL,16,'DOMESTIC INLAND SERVICE','CROSS BORDER',1),(6,'Export Customs Clearance','LS','USD,MXN',NULL,16,'DOMESTIC INLAND SERVICE','CROSS BORDER',1),(7,'Inland Service Coordination','LS,MIN,W/M,TON','USD,MXN','PER KGS,W/M,LS',16,'DOMESTIC INLAND SERVICE','CROSS BORDER',1),(8,'Import Customs Clearance','LS','USD',NULL,16,'DOMESTIC INLAND SERVICE','CROSS BORDER',1),(9,'Delivery Charges','LS','USD',NULL,16,'DOMESTIC INLAND SERVICE','CROSS BORDER',1),(10,'Pick-up Charges','LS','USD,MXN',NULL,16,'INTERNATIONAL INLAND FREIGHT','CROSS BORDER',1),(11,'Inland Service Coordination (Dedicated Service)','LS','USD,MXN',NULL,16,'INTERNATIONAL INLAND FREIGHT','CROSS BORDER',1),(12,'Non-Stackable Surcharge','LS,MIN,W/M','USD,MXN','35% Valor total del flete',16,'INTERNATIONAL INLAND FREIGHT','CROSS BORDER',1),(13,'DOC FEE','LS','USD,MXN',NULL,16,'INTERNATIONAL INLAND FREIGHT','CROSS BORDER',1),(14,'Customs Inspection','LS','USD,MXN',NULL,16,'INTERNATIONAL INLAND FREIGHT','CROSS BORDER',1),(15,'Export Customs Clearance','LS','USD,MXN',NULL,16,'INTERNATIONAL INLAND FREIGHT','CROSS BORDER',1),(16,'Import Customs Clearance','LS','USD',NULL,16,'INTERNATIONAL INLAND FREIGHT','CROSS BORDER',1),(17,'Delivery Charges','LS','USD',NULL,16,'INTERNATIONAL INLAND FREIGHT','CROSS BORDER',1),(18,'International Inland Service Coordination','LS,MIN,W/M','USD','PER KGS + W/M',NULL,'INTERNATIONAL INLAND FREIGHT','CROSS BORDER',1),(19,'MAGA Inspection','TON','USD','',NULL,'INTERNATIONAL INLAND FREIGHT','CROSS BORDER',1),(20,'Manuevers','MIN,W/M','USD,MXN',NULL,16,'ADDITIONAL CHARGES','CROSS BORDER',1),(21,'Storage Charges','W/M','USD,MXN','PER DAY',16,'ADDITIONAL CHARGES','CROSS BORDER',1),(22,'DGD FEE','LS','USD,MXN','45% Valor total del flete',16,'ADDITIONAL CHARGES','CROSS BORDER',1),(23,'Re-packing services (Labelling, Palletizing)','LS','USD,MXN','PER PALLET',16,'ADDITIONAL CHARGES','CROSS BORDER',1),(24,'Custody Fee','TON','USD','PER KGS',16,'ADDITIONAL CHARGES','CROSS BORDER',1),(25,'Storage Charges at destination','W/M','USD','PER DAY',16,'ADDITIONAL CHARGES','CROSS BORDER',1),(26,'MEI','LS','USD',NULL,16,'ADDITIONAL CHARGES','CROSS BORDER',1),(27,'Other Customs Charges','LS','USD',NULL,16,'ADDITIONAL CHARGES','CROSS BORDER',1),(28,'Insurance Fee','LS','USD',NULL,16,'ADDITIONAL CHARGES','CROSS BORDER',1),(29,'Handling Fee','LS','USD',NULL,16,'ADDITIONAL CHARGES','CROSS BORDER',1);
/*!40000 ALTER TABLE `tarifario_conceptos` 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 20:35:44
