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

DROP TABLE IF EXISTS `aereos_conceptos_facturacion`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `aereos_conceptos_facturacion` (
  `idconcepto_aereo` int(11) NOT NULL AUTO_INCREMENT,
  `nombre_concepto_aereo` varchar(255) DEFAULT NULL,
  `tasa_iva_concepto_aereo` varchar(2) DEFAULT NULL,
  `clave_sat` varchar(8) DEFAULT NULL,
  `agrupar_en` varchar(80) DEFAULT NULL,
  `categoria` varchar(100) DEFAULT NULL,
  `tipo` varchar(45) DEFAULT NULL,
  UNIQUE KEY `idconcepto_aereo_UNIQUE` (`idconcepto_aereo`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `aereos_conceptos_facturacion`
--

LOCK TABLES `aereos_conceptos_facturacion` WRITE;
/*!40000 ALTER TABLE `aereos_conceptos_facturacion` DISABLE KEYS */;
INSERT INTO `aereos_conceptos_facturacion` VALUES (1,'ORIGIN PICK UP','0','81141601','','Recoleccion','impo'),(2,'FCA CHARGES','0','80151600',NULL,'Gastos en origen','impo'),(3,'PALLET CONDITIONING','0','80151600',NULL,'Acondicionamiento','impo'),(4,'AIR FREIGHT C/W','0','80151600','Air Freight C/W','Flete aereo','impo'),(5,'AIR FREIGHT SURCHARGE C/W','0','80151600','Air Freight C/W','Flete aereo','impo'),(6,'AIR FREIGHT','0','80151600','Air Freight','Flete aereo','impo'),(7,'AIR FREIGHT SURCHARGE','0','80151600','Air Freight','Flete aereo','impo'),(8,'AWB FEE','0','80151600',NULL,'Corte de guia','impo'),(9,'IMPORT CUSTOMS CLEARANCE','0','80151600','Import Customs Clearance','Despacho aduanal','impo'),(10,'IMPORT DUTIES & TAXES','0','80151600','Import Customs Clearance','Despacho aduanal','impo'),(11,'INSURANCE','0','80151600',NULL,'Seguro','impo'),(12,'PROFIT SHARE (P/S)','0','80151600',NULL,'Profit Share','impo'),(13,'STORAGE CHARGES','16','78131601',NULL,'Almacenajes','impo'),(14,'RELEASE FEE','16','80151600',NULL,'Revalidacion','impo'),(15,'ADMON FEE','16','81141601',NULL,'Admon Fee','impo'),(16,'TRANSMISSION','16','80151600',NULL,'Transmision','impo'),(17,'TERMINAL HANDLING','16','80151600',NULL,'Maniobras','impo'),(18,'DELIVERY','16','81141601',NULL,'Flete terrestre','impo'),(19,'DEAD FREIGHT','16','80151600',NULL,'Flete terrestre','impo'),(20,'DEMURRAGES','16','76122401',NULL,'Flete terrestre','impo'),(21,'TRADING COMPANY','16','80151600',NULL,'Comercializadora','impo'),(22,'EXTRA TIME','16','80151600',NULL,'Servicio extraordinario','impo'),(23,'PICK UP COORDINATION','16','81141601',NULL,'Flete terrestre','expo'),(24,'TRANSFER TO CUSTOMS','16','80151600',NULL,'Flete terrestre','expo'),(25,'EXPORT CUSTOMS CLEARANCE','16','80151600',NULL,'Despacho aduanal','expo'),(26,'PALLET CONDITIONING','16','80151600',NULL,'Acondicionamiento','expo'),(27,'AIR FREIGHT C/W','0','80151600',NULL,'Flete aereo','expo'),(28,'AIR FREIGHT SURCHARGE C/W','0','80151600',NULL,'Flete aereo','expo'),(29,'AIR FREIGHT','0','80151600',NULL,'Flete aereo','expo'),(30,'AIR FREIGHT SURCHARGE','0','80151600',NULL,'Flete aereo','expo'),(31,'AWB FEE','16','80151600',NULL,'Corte de guia','expo'),(32,'DESTINATION CHARGES','0','80151600',NULL,'Gastos en destino','expo'),(33,'DESTINATION DELIVERY','0','80151600',NULL,'Gastos en destino','expo'),(34,'PROFIT SHARE','16','80151600',NULL,'Profit Share','expo'),(35,'TERMINAL HANDLING','16','80151600',NULL,'Maniobras de exportacion','expo'),(36,'INSURANCE','0','81141601',NULL,'Seguro','expo'),(37,'IMPORT DUTIES & TAXES','0','80151600',NULL,'Gastos en destino','expo'),(38,'STORAGE CHARGES','16','78131601',NULL,'Almacenajes','expo'),(39,'AWB CORRECTION','16','81141601',NULL,'Corte de guia','expo'),(40,'TRADING COMPANY','16','80151600',NULL,'Comercializadora','expo'),(41,'EXTRA TIME','16','80151600',NULL,'Servicio extraordinario','expo'),(42,'DEAD FREIGHT','16','80151600',NULL,'Flete terrestre','expo'),(43,'DEMURRAGES','16','76122401',NULL,'Flete terrestre','expo'),(44,'OTROS IVA 16%','16','81141601',NULL,'Impo nota de credito','impo_nota_de_credito'),(45,'OTROS IVA 0%','0','81141601',NULL,'Impo nota de credito','impo_nota_de_credito');
/*!40000 ALTER TABLE `aereos_conceptos_facturacion` 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:21:43
