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

DROP TABLE IF EXISTS `fc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `fc` (
  `id` double NOT NULL AUTO_INCREMENT,
  `shortname` varchar(255) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `tipo` varchar(45) DEFAULT NULL,
  `wwa_charge_code` varchar(10) DEFAULT NULL,
  `clasificacion` varchar(255) DEFAULT NULL,
  `clasificacion_contable` varchar(255) DEFAULT NULL,
  `gravamen` int(2) DEFAULT NULL,
  `visible` int(1) DEFAULT '1',
  `clasificacion_costo_pl` varchar(255) DEFAULT NULL,
  `concepto_tarifario` text,
  `codigo_sat` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=480 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fc`
--

LOCK TABLES `fc` WRITE;
/*!40000 ALTER TABLE `fc` DISABLE KEYS */;
INSERT INTO `fc` VALUES (6,'BAF (BUNKER ADJUSTMENT FACTOR)','BAF','W/M LS MIN ','BAF','FLETE MARITIMO','FLETE MARITIMO',0,1,'INGRESO MARITIMO','BAF','80151600'),(13,'PICK UP','PICK UP','LS','OTH','FLETE TERRESTRE','FLETE TERRESTRE',16,1,'INGRESO TERRESTRE',NULL,'81141601'),(16,'DELIVERY PORT','DELIVERY AT PORT','LS','DLRF','FLETE TERRESTRE','FLETE TERRESTRE',16,1,'INGRESO TERRESTRE',NULL,'81141601'),(17,'CUSTOMS CLEARANCE','CUSTOMS CLEARANCE','LS ','CUSC','DESPACHO ADUANAL','DESPACHO ADUANAL',16,1,'INGRESO DESPACHO','','80151605'),(28,'BL FEE','BL FEE','Per BL ','B/L','OTROS INGRESOS MARITIMOS','FLETE MARITIMO',0,1,'INGRESO LOCALES','','80151600'),(30,'HANDLING','HANDLING','W/M LS MIN ','HNDF','OTROS INGRESOS MARITIMOS','FLETE MARITIMO',0,1,'INGRESO MARITIMO','','80151600'),(32,'AMS FEE','AMS FEE','Per BL ','AMS','OTROS INGRESOS MARITIMOS','OTROS INGRESOS GRAVAMEN CERO',0,1,'INGRESO LOCALES','','80151600'),(33,'FUMIGATION FEE','FUMIGATION FEE','LS ','FMG','OTROS INGRESOS MARITIMOS','FLETE MARITIMO',0,1,'INGRESO MARITIMO','','80151605'),(46,'GRI','GRI','W/M LS MIN ','GRI','FLETE MARITIMO','FLETE MARITIMO',0,1,'INGRESO MARITIMO','','80151600'),(112,'CONSOL FEE','CONSOL FEE','W/M MIN ','CONS','CONSOLIDACION','CONSOLIDACION',0,1,'INGRESO LOCALES','','80151600'),(146,'STORAGES (CFS)','STORAGES (CFS)','LS','STRG','OTROS INGRESOS DESPACHO','DESPACHO ADUANAL',16,1,'INGRESO DESPACHO',NULL,'78131601'),(147,'STORAGE INLAND','STORAGES (INLAND)','LS','STRG','OTROS INGRESOS TERRESTRES','FLETE TERRESTRE',16,1,'INGRESO TERRESTRE',NULL,'78131601'),(150,'CUSTOMS INSPECTION','CUSTOMS INSPECTION','LS ','SCHR','OTROS INGRESOS DESPACHO','DESPACHO ADUANAL',16,1,'INGRESO DESPACHO','','80151605'),(195,'CORRECTION BL','CORRECTION','LS ','OTH','OTROS INGRESOS MARITIMOS','OTROS INGRESOS GRAVADOS',0,1,'INGRESO MARITIMO','','81141601'),(202,'ADMINISTRATION FEE','ADMINISTRATION FEE','Per BL ','ADMF','INGRESOS LOCALES','OTROS INGRESOS GRAVADOS',16,1,'INGRESO LOCALES','ADMINISTRATION FEE','81141601'),(214,'DDU','DDU CHARGES','W/M LS MIN ','OTH','OTROS INGRESOS MARITIMOS','FLETE MARITIMO',0,1,'INGRESO MARITIMO','','80151600'),(220,'OVERLENGHT','OVERLENGHT','W/M LS MIN ','OVRS','OTROS INGRESOS MARITIMOS','FLETE MARITIMO',0,1,'INGRESO MARITIMO','','80151600'),(234,'OCEAN FREIGHT','OCEAN FREIGHT','W/M LS MIN ','OFR','FLETE MARITIMO','FLETE MARITIMO',0,1,'INGRESO MARITIMO','OCEAN FREIGHT','80151600'),(250,'DEST CHARGES','DESTINATION CHARGES','W/M LS MIN ','DDC','OTROS INGRESOS MARITIMOS','FLETE MARITIMO',0,1,'INGRESO MARITIMO','','80151600'),(251,'NON STACKABLE','NON STACKABLE CHARGE','W/M LS MIN ','OTH','OTROS INGRESOS MARITIMOS','FLETE MARITIMO',0,1,'INGRESO MARITIMO','','81141601'),(256,'DDP','DDP CHARGES','W/M LS MIN ','OTH','OTROS INGRESOS MARITIMOS','FLETE MARITIMO',0,1,'INGRESO MARITIMO','','80151600'),(257,'TRANSMISSION FEE','TRANSMISSION FEE','Per BL ','VALF','INGRESOS LOCALES','OTROS INGRESOS GRAVADOS',16,1,'INGRESO LOCALES','','80151600'),(258,'DEMURRAGES','DEMURRAGES','LS ','OTH','OTROS INGRESOS LOCALES','OTROS INGRESOS GRAVADOS',0,1,'INGRESO MARITIMO','','76122401'),(260,'ENS FEE','ENS FEE','Per BL ','ENS','FLETE MARITIMO','FLETE MARITIMO',0,1,'INGRESO MARITIMO','','80151600'),(276,'R1 RECTIFICATION','R1 (RECTIFICATION)','LS','OTH','OTROS INGRESOS DESPACHO','DESPACHO ADUANAL',16,1,'INGRESO DESPACHO',NULL,'80151605'),(277,'LABELING (T)','LABELING (ETIQUETADO)','LS ','OTH','OTROS INGRESOS TERRESTRES','FLETE TERRESTRE',16,1,'INGRESO DESPACHO','','81141601'),(278,'RED LIGHT','RED LIGHT','LS','OTH','OTROS INGRESOS DESPACHO','DESPACHO ADUANAL',16,1,'INGRESO DESPACHO',NULL,'80151605'),(289,'DAP CHARGES','DAP CHARGES','W/M LS MIN ','OTH','OTROS INGRESOS MARITIMOS','FLETE MARITIMO',0,1,'INGRESO MARITIMO','','80151600'),(291,'FLETE EN FALSO','FLETE EN FALSO','LS','OTH','OTROS INGRESOS TERRESTRES','FLETE TERRESTRE',16,1,'INGRESO TERRESTRE',NULL,'81141601'),(292,'LAYOVER FEE','LAYOVER FEE (ESTADIAS)','LS','OTH','OTROS INGRESOS TERRESTRES','FLETE TERRESTRE',16,1,'INGRESO TERRESTRE',NULL,'76122401'),(307,'ISPS','ISPS','LS ','ISPS','CONSOLIDACION','CONSOLIDACION',0,1,'INGRESO LOCALES','ISPS','80151600'),(321,'CARGO DE CITA','CARGO DE CITA','LS','OTH','OTROS INGRESOS TERRESTRES','FLETE TERRESTRE',16,1,'INGRESO TERRESTRE',NULL,'81141601'),(323,'OVERWEIGHT','OVERWEIGHT','W/M LS MIN ','OVRS','OTROS INGRESOS MARITIMOS','FLETE MARITIMO',0,1,'INGRESO MARITIMO','','80151600'),(324,'TRANSSHIPMENT','TRANSSHIPMENT','W/M LS MIN ','OTH','OTROS INGRESOS MARITIMOS','FLETE MARITIMO',0,1,'INGRESO MARITIMO','','80151600'),(327,'IMO TRANSSHIPMENT','IMO TRANSSHIPMENT','W/M,MIN,LS','IMC','OTROS INGRESOS MARITIMOS','FLETE MARITIMO',0,1,'INGRESO MARITIMO',NULL,'80151600'),(330,'TRANSH. NON STACK','TRANSSHIPMENT NON STACKABLE','W/M,LS','OTH','OTROS INGRESOS MARITIMOS','FLETE MARITIMO',0,1,'INGRESO MARITIMO',NULL,'81141601'),(333,'RETURN CHARGES','RETURN CHARGES','LS ','OTH','OTROS INGRESOS MARITIMOS','OTROS INGRESOS GRAVAMEN CERO',0,1,'INGRESO MARITIMO','','80151600'),(334,'LSS','LOW SULPHUR SURCHARGE','W/M MIN ','SCHR','FLETE MARITIMO','FLETE MARITIMO',0,1,'INGRESO MARITIMO','','80151600'),(337,'LATE ARRIVAL','LATE ARRIVAL','LS ','OTH','OTROS INGRESOS LOCALES','OTROS INGRESOS GRAVADOS',0,1,'INGRESO LOCALES','','81141601'),(338,'CHANGE OF EQUIPMENT','CAMBIO DE EQUIPO','LS ','CNTM','CONSOLIDACION','CONSOLIDACION',0,1,'INGRESO LOCALES','','80151600'),(339,'PTF','PTF','W/M LS MIN ',NULL,'CONSOLIDACION','CONSOLIDACION',0,1,'INGRESO LOCALES','','80151600'),(341,'EMPLAYE','EMPLAYE','LS',NULL,'OTROS INGRESOS MARITIMOS','FLETE MARITIMO',0,1,'INGRESO MARITIMO',NULL,'78121502'),(346,'STUFFING','STUFFING','W/M LS MIN ','CONS','CONSOLIDACION','CONSOLIDACION',0,1,'INGRESO LOCALES','','80151600'),(347,'STUFFING IMO','STUFFING IMO','W/M LS MIN ','CONS','CONSOLIDACION','CONSOLIDACION',0,1,'INGRESO LOCALES','','80151600'),(352,'TRANSSHIPMENT SURCHARGE','TRANSSHIPMENT SURCHARGE','W/M LS ','OTH','OTROS INGRESOS MARITIMOS','FLETE MARITIMO',0,1,'INGRESO MARITIMO','','80151600'),(353,'PALLETIZING','PALLETIZING','LS ','OTH','OTROS INGRESOS DESPACHO','DESPACHO ADUANAL',16,1,'INGRESO DESPACHO','','78121502'),(354,'VGM FEE','VGM FEE','Per BL ',NULL,'CONSOLIDACION','CONSOLIDACION',0,1,'INGRESO LOCALES','','80151600'),(355,'VGM T/S FEE','VGM T/S FEE','Per BL ',NULL,'OTROS INGRESOS MARITIMOS','FLETE MARITIMO',0,1,'INGRESO MARITIMO','','80151600'),(357,'BL & VGM FEE','BL & VGM FEE','Per BL ',NULL,'OTROS INGRESOS MARITIMOS','FLETE MARITIMO',0,1,'INGRESO LOCALES','','80151600'),(358,'ENS & AMS FEE','ENS & AMS FEE','Per BL ','AMS','FLETE MARITIMO','FLETE MARITIMO',0,1,'INGRESO MARITIMO','','80151600'),(359,'PICK UP & DELIVERY','PICK UP & DELIVERY','LS ',NULL,'FLETE TERRESTRE','FLETE TERRESTRE',16,1,'INGRESO TERRESTRE','','81141601'),(376,'EBS MIN','EBS','W/M MIN ',NULL,'OTROS INGRESOS MARITIMOS','FLETE MARITIMO',0,1,'INGRESO MARITIMO','EBS','80151600'),(379,'ESTADIAS T','ESTADIAS T','LS',NULL,'OTROS INGRESOS TERRESTRES','FLETE TERRESTRE',16,1,'INGRESO TERRESTRE',NULL,'76122401'),(380,'NO ESTIBABLE T','NO ESTIBABLE T','LS',NULL,'OTROS INGRESOS TERRESTRES','FLETE TERRESTRE',16,1,'INGRESO TERRESTRE',NULL,'81141601'),(381,'EMBALAJE T','EMBALAJE T','LS',NULL,'OTROS INGRESOS TERRESTRES','FLETE TERRESTRE',16,1,'INGRESO TERRESTRE',NULL,'78121502'),(382,'MANIOBRAS T','MANIOBRAS T','LS',NULL,'OTROS INGRESOS TERRESTRES','FLETE TERRESTRE',16,1,'INGRESO TERRESTRE',NULL,'81141601'),(384,'DDC','DDC','W/M LS MIN ','OTH','OTROS INGRESOS MARITIMOS','FLETE MARITIMO',0,1,'INGRESO MARITIMO','','80151600'),(385,'WRS','WAR RISK SURCHARGE','W/M,MIN','OTH','FLETE MARITIMO','FLETE MARITIMO',0,1,'INGRESO MARITIMO',NULL,'80151600'),(390,'PALLETIZING (INLAND)','PALLETIZING (INLAND)','LS','OTH','FLETE TERRESTRE','FLETE TERRESTRE',16,1,'INGRESO TERRESTRE',NULL,'78121502'),(400,'PSS','PEAK SEASON SURCHARGE','W/M MIN ',NULL,'FLETE MARITIMO','FLETE MARITIMO',0,1,'INGRESO MARITIMO','','80151600'),(402,'LABELING','LABELING (ETIQUETADO D)','LS','OTH','OTROS INGRESOS DESPACHO','DESPACHO ADUANAL',16,1,'INGRESO DESPACHO',NULL,'80151600'),(403,'DEDICATED SERVICE','DEDICATED SERVICE','LS','OTH','OTROS INGRESOS TERRESTRES','FLETE TERRESTRE',16,1,'INGRESO TERRESTRE',NULL,'81141601'),(404,'INSURANCE FEE','INSURANCE FEE','LS ','OTH','OTROS INGRESOS MARITIMOS','OTROS INGRESOS GRAVAMEN CERO',0,1,'INGRESO MARITIMO','','81141601'),(405,'RECEPTION FEE','RECEPTION FEE','W/M ',NULL,'OTROS INGRESOS DESPACHO','DESPACHO ADUANAL',16,1,'INGRESO DESPACHO','','80151605'),(407,'COURIER','COURIER','LS ',NULL,'OTROS INGRESOS LOCALES','OTROS INGRESOS GRAVADOS',0,1,'INGRESO LOCALES','','81141601'),(410,'TAXES','TAXES','LS ',NULL,'OTROS INGRESOS LOCALES','OTROS INGRESOS GRAVAMEN CERO',0,1,'INGRESO LOCALES','','80151600'),(411,'OTHERS ORIGIN CHARGES','OTHERS ORIGIN CHARGES','W/M LS MIN TON ',NULL,'OTROS INGRESOS MARITIMOS','OTROS INGRESOS GRAVAMEN CERO',0,1,'INGRESO MARITIMO','','81141601'),(415,'OTHERS DESTINATION CHARGES','OTHERS DESTINATION CHARGES','W/M LS MIN ',NULL,'OTROS INGRESOS MARITIMOS','OTROS INGRESOS GRAVAMEN CERO',0,1,'INGRESO MARITIMO','','81141601'),(417,'FUMIGATION FEE (T)','FUMIGATION FEE (T)','LS ',NULL,'OTROS INGRESOS TERRESTRES','FLETE TERRESTRE',16,1,'INGRESO TERRESTRE','','80151605'),(421,'INLD SERV COORD','INLAND SERVICE COORDINATION','W/M LS MIN ',NULL,'FLETE TERRESTRE','FLETE TERRESTRE',16,1,'INGRESO TERRESTRE','','81141601'),(446,'DGD FEE','DGD FEE','LS',NULL,'OTROS INGRESOS MARITIMOS','FLETE MARITIMO',0,1,'INGRESO MARITIMO',NULL,'81141601'),(448,'OVERWEIGHT CARGO T/S','OVERWEIGHT CARGO T/S','W/M LS MIN ',NULL,'OTROS INGRESOS MARITIMOS','FLETE MARITIMO',0,1,'INGRESO MARITIMO','','80151600'),(451,'OVERSIZE T/S','OVERSIZE T/S','W/M LS MIN ',NULL,'OTROS INGRESOS MARITIMOS','FLETE MARITIMO',0,1,'INGRESO MARITIMO','','80151600'),(453,'HAZARDOUS DOC FEE','HAZARDOUS DOC FEE','Per BL ',NULL,'OTROS INGRESOS MARITIMOS','OTROS INGRESOS GRAVAMEN CERO',0,1,'INGRESO MARITIMO','','80151600'),(454,'NO SHOW','NO SHOW','LS ',NULL,'OTROS INGRESOS MARITIMOS','OTROS INGRESOS GRAVAMEN CERO',0,1,'INGRESO MARITIMO','','81141601'),(455,'ROLL OVER','ROLL OVER','LS ',NULL,'OTROS INGRESOS MARITIMOS','OTROS INGRESOS GRAVAMEN CERO',0,1,'INGRESO DESPACHO','','81141601'),(456,'MEI LUMPSUM','MEI','LS',NULL,'OTROS INGRESOS DESPACHO','DESPACHO ADUANAL',16,1,'INGRESO DESPACHO',NULL,'81141601'),(457,'CANCELLATION FEE','CANCELLATION FEE','LS ',NULL,'OTROS INGRESOS MARITIMOS','FLETE MARITIMO',0,1,'INGRESO MARITIMO','','81141601'),(458,'OTHERS CUSTOMS CHARGES','OTHERS CUSTOMS CHARGES','LS ','OTH','OTROS INGRESOS DESPACHO','DESPACHO ADUANAL',16,1,'INGRESO DESPACHO','','81141601'),(462,'DOC FEE','DOC FEE','Per BL ',NULL,'CONSOLIDACION','CONSOLIDACION',0,1,'INGRESO LOCALES','','80151600'),(464,'LOCAL CH DESTIN','LOCAL CHARGES AT DESTINATION','W/M MIN Per BL TON ',NULL,'OTROS INGRESOS MARITIMOS','OTROS INGRESOS GRAVAMEN CERO',0,1,'OTROS INGRESOS MARITIMOS','','80151600'),(465,'HAZARDOUS CONSOL FEE','HAZARDOUS CONSOL FEE','W/M LS MIN ',NULL,'CONSOLIDACION','CONSOLIDACION',0,1,'INGRESO LOCALES','','80151600'),(468,'HAZARDOUS SURCHARGE','HAZARDOUS SURCHARGE','LS ',NULL,'FLETE MARITIMO','FLETE MARITIMO',0,1,'INGRESO MARITIMO','','80151600'),(469,'EU ETSS','EU ETSS','W/M MIN ',NULL,'OTROS INGRESOS MARITIMOS','OTROS INGRESOS GRAVAMEN CERO',0,1,'OTROS INGRESOS MARITIMOS','','80151600'),(471,'ESF MIN','ESF','W/M,MIN',NULL,'OTROS INGRESOS MARITIMOS','OTROS INGRESOS GRAVAMEN CERO',0,1,'OTROS INGRESOS MARITIMOS',NULL,'80151600'),(473,'PORT ENTRY FEE (LUMPSUM)','PORT ENTRY FEE','LS',NULL,'OTROS INGRESOS TERRESTRES','FLETE TERRESTRE',16,1,'INGRESO TERRESTRE',NULL,'81141601'),(475,'INLD SERV COORD (PRECARRIAGE)','INLAND SERVICE COORDINATION (PRECARRIAGE)','W/M MIN ',NULL,'OTROS INGRESOS TERRESTRES','FLETE TERRESTRE',16,1,'INGRESO TERRESTRE','','81141601'),(477,'OVERWEIGHT SURCHARGE','OVERWEIGHT SURCHARGE','W/M ',NULL,'OTROS INGRESOS MARITIMOS','FLETE MARITIMO',0,1,'INGRESO LOCALES','','80151600'),(478,'111','111','W/M ',NULL,'CONSOLIDACION','CONSOLIDACION',1,1,'INGRESO MARITIMO','',NULL),(479,'ICS2','ICS2','Per BL ',NULL,'FLETE MARITIMO','FLETE MARITIMO',0,1,'INGRESO MARITIMO','BLABLEBLI','80151600');
/*!40000 ALTER TABLE `fc` 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:38:29
