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

DROP TABLE IF EXISTS `freightcharges_clasificacion`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `freightcharges_clasificacion` (
  `id` double NOT NULL AUTO_INCREMENT,
  `shortname` varchar(255) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `validation` varchar(255) NOT NULL DEFAULT '',
  `order1` double NOT NULL DEFAULT '0',
  `nameforhbl` varchar(50) NOT NULL DEFAULT '',
  `wm` varchar(10) NOT NULL DEFAULT '',
  `wwa_charge_code` varchar(10) DEFAULT NULL,
  `clasificacion` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=356 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `freightcharges_clasificacion`
--

LOCK TABLES `freightcharges_clasificacion` WRITE;
/*!40000 ALTER TABLE `freightcharges_clasificacion` DISABLE KEYS */;
INSERT INTO `freightcharges_clasificacion` VALUES (6,'BAF W/M','BAF W/M','%',0,'BAF W/M','YES','BAF','FLETE MARITIMO'),(8,'BAF MIN','BAF MIN','%',0,'BAF MIN','NO','BAF','FLETE MARITIMO'),(13,'PICK UP L','PICK UP (LUMPSUM)','%',0,'PICK UP (LUMPSUM)','NO','OTH','FLETE TERRESTRE'),(14,'INLNDFREIGHT W','INLAND FREIGHT W/M','%',0,'INLAND FREIGHT W/M','YES','INL','FLETE TERRESTRE'),(15,'INLNDFREIGHT M','INLAND FREIGHT MIN','%',0,'INLAND FREIGHT MIN','NO','INL','FLETE TERRESTRE'),(16,'DELIVERY PORT','DELIVERY AT PORT','%',0,'DELIVERY AT PORT','NO','DLRF','FLETE TERRESTRE'),(17,'CUSTOMS CLEAR','CUSTOMS CLEARANCE','%',0,'CUSTOMS CLEARANCE','NO','CUSC','OTROS INGRESOS DESPACHO'),(28,'BL FEE','BL FEE','%',0,'BL FEE','NO','B/L','BL FEE'),(30,'HANDLING','HANDLING','%',0,'HANDLING','NO','HNDF','OTROS INGRESOS MARITIMOS'),(32,'AMS FEE','AMS FEE','%',0,'AMS FEE','NO','AMS','OTROS INGRESOS MARITIMOS'),(33,'FUMIGATION FEE','FUMIGATION FEE','%',0,'FUMIGATION FEE','NO','FMG','DESPACHO ADUANAL'),(36,'CONSOL FEE W/M','CONSOL FEE W/M','%',0,'CONSOL FEE W/M','YES','CONS','CONSOLIDACION'),(37,'CONSOL FEE M','CONSOL FEE MIN','%',0,'CONSOL FEE MIN','NO','CONS','CONSOLIDACION'),(46,'GRI W/M','GRI W/M','%',0,'GRI W/M','YES','GRI','FLETE MARITIMO'),(49,'INLAND FREIGHT','INLAND FREIGHT (LUMPSUM)','%',0,'INLAND FREIGHT (LUMPSUM)','NO','INL','FLETE TERRESTRE'),(59,'GRI MIN','GRI MIN','%',0,'GRI MIN','NO','GRI','FLETE MARITIMO'),(60,'GRI (LUMPSUM)','GRI (LUMPSUM)','%',0,'GRI (LUMPSUM)','NO','GRI','FLETE MARITIMO'),(71,'IMO SURCHARGE','IMO SURCHARGE','%',0,'IMO SURCHARGE','NO','IMC','OTROS INGRESOS MARITIMOS'),(112,'CONSOL FEE L','CONSOL FEE (LUMPSUM)','%',0,'CONSOL FEE (LUMPSUM)','NO','CONS','CONSOLIDACION'),(137,'OVRWEIGHT S L','OVERWEIGHT (LUMPSUM)','%',0,'OVERWEIGHT (LUMPSUM)','NO','OVRS','OTROS INGRESOS MARITIMOS'),(146,'STORAGES (CFS)','STORAGES (CFS)','%',0,'STORAGES (CFS)','NO','STRG','DESPACHO ADUANAL'),(147,'STORAGEINLAND','STORAGES (INLAND)','%',0,'STORAGES (INLAND)','NO','STRG','DESPACHO ADUANAL'),(150,'CUSTOMS INSPEC','CUSTOMS INSPECTION','%',0,'CUSTOMS INSPECTION','NO','SCHR','DESPACHO ADUANAL'),(179,'OVRLENGHT S W','OVERLENGHT W/M','%',0,'OVERLENGHT W/M','NO','OVRS','OTROS INGRESOS MARITIMOS'),(182,'VALIDATION FEE','VALIDATION FEE','%',0,'VALIDATION FEE','NO','VALF','VALIDATION & ADMON FEE'),(195,'CORRECTION','CORRECTION','%',0,'CORRECTION','NO','OTH','OTROS INGRESOS MARITIMOS'),(202,'ADMINISTRATION ','ADMINISTRATION FEE','%',0,'ADMINISTRATION FEE','NO','ADMF','VALIDATION & ADMON FEE'),(214,'DDU CHARGES','DDU CHARGES','%',0,'DDU CHARGES','NO','OTH','OTROS INGRESOS MARITIMOS'),(220,'OVRLNGHTS L','OVERLENGHT (LUMPSUM)','%',0,'OVERLENGHT (LUMPSUM)','NO','OVRS','OTROS INGRESOS MARITIMOS'),(234,'OCEAN FRGHT L','OCEAN FREIGHT (LUMPSUM)','%',0,'OCEAN FREIGHT (LUMPSUM)','NO','OFR','FLETE MARITIMO'),(236,'OCEAN FRGHT M','OCEAN FREIGHT (MIN)','%',0,'OCEAN FREIGHT (MIN)','NO','OFR','FLETE MARITIMO'),(237,'OCEAN FRGHT W','OCEANFREIGHT W/M','%',0,'OCEANFREIGHT W/M','YES','OFR','FLETE MARITIMO'),(241,'PICK & DELIVERY','PICK UP & DELIVERY','%',0,'PICK UP & DELIVERY','NO','OTH','FLETE TERRESTRE'),(248,'BAF (LUMPSUM)','BAF (LUMPSUM)','%',0,'BAF (LUMPSUM)','NO','BAF','FLETE MARITIMO'),(249,'IMO CONSOLFEE L','IMO CONSOL FEE (LUMPSUM)','%',0,'IMO CONSOL FEE (LUMPSUM)','NO','IMO','CONSOLIDACION'),(250,'DEST CHARGES','DESTINATION CHARGES','%',0,'DESTINATION CHARGES','NO','DDC','OTROS INGRESOS MARITIMOS'),(251,'NO STACKABLE W','NON STACKABLE CHARGE W/M','%',0,'NON STACKABLE CHARGE W/M','YES','OTH','OTROS INGRESOS MARITIMOS'),(252,'NO STACKABLE M','NON STACKABLE CHARGE MIN','%',0,'NON STACKABLE CHARGE MIN','NO','OTH','OTROS INGRESOS MARITIMOS'),(256,'DDP CHARGES','DDP CHARGES','%',0,'DDP CHARGES','NO','OTH','OTROS INGRESOS MARITIMOS'),(257,'VALID & ADMON','VALIDATION & ADMON. FEE','%',0,'VALIDATION & ADMON. FEE','NO','VALF','VALIDATION & ADMON FEE'),(258,'DEMURRAGES','DEMURRAGES','%',0,'DEMURRAGES','NO','OTH','OTROS INGRESOS MARITIMOS'),(260,'ENS FEE','ENS FEE','%',0,'ENS FEE','NO','ENS','ENS'),(276,'R1 RECTIFICATIO','R1 (RECTIFICATION)','%',0,'R1 (RECTIFICATION)','NO','OTH','DESPACHO ADUANAL'),(277,'LABELING','LABELING (ETIQUETADO)','%',0,'LABELING (ETIQUETADO)','NO','OTH','DESPACHO ADUANAL'),(278,'RED LIGHT','RED LIGHT','%',0,'RED LIGHT','NO','OTH','DESPACHO ADUANAL'),(289,'DAP CHARGES','DAP CHARGES','%',0,'DAP CHARGES','NO','OTH','OTROS INGRESOS MARITIMOS'),(291,'FLETE EN FALSO','FLETE EN FALSO','%',0,'FLETE EN FALSO','NO','OTH','OTROS INGRESOS TERRESTRES'),(292,'LAYOVER FEE','LAYOVER FEE (ESTADIAS)','%',0,'LAYOVER FEE (ESTADIAS)','NO','OTH','OTROS INGRESOS TERRESTRES'),(294,'IMO CONSOLFEE M','IMO CONSOL FEE MIN','%',0,'IMO CONSOL FEE MIN','NO','IMO','CONSOLIDACION'),(299,'IMO CONSOLFEE W','IMO CONSOL FEE W/M','%',0,'IMO CONSOL FEE W/M','YES','IMC','OTROS INGRESOS MARITIMOS'),(307,'ISPS','ISPS','%',0,'ISPS','NO','ISPS','CONSOLIDACION'),(321,'CARGO DE CITA','CARGO DE CITA','%',0,'CARGO DE CITA','NO','OTH','OTROS INGRESOS TERRESTRES'),(322,'NO STACKABLE L','NON STACKABLE (LUMPSUM)','%',0,'NON STACKABLE (LUMPSUM)','NO','OTH','OTROS INGRESOS MARITIMOS'),(323,'OVERWEIGHT S W','OVERWEIGHT SURCHARGE W/M','%',0,'OVERWEIGHT SURCHARGE W/M','NO','OVRS','OTROS INGRESOS MARITIMOS'),(324,'TRANSHIPMNT L','TRANSHIPMENT (LUMPSUM)','%',0,'TRANSHIPMENT (LUMPSUM)','NO','OTH','OTROS INGRESOS MARITIMOS'),(325,'TRANSHIPMNT M','TRANSHIPMENT MIN','%',0,'TRANSHIPMENT MIN','NO','OTH','OTROS INGRESOS MARITIMOS'),(326,'TRANSHIPMNT W','TRANSHIPMENT W/M','%',0,'TRANSHIPMENT W/M','YES','OTH','OTROS INGRESOS MARITIMOS'),(327,'IMO TRNSPM W','IMO TRANSSHIPMENT W/M','%',0,'IMO TRANSSHIPMENT W/M','YES','IMC','OTROS INGRESOS MARITIMOS'),(328,'IMO TRNSHPM M','IMO TRANSSHIPMENT MIN','%',0,'IMO TRANSSHIPMENT MIN','NO','IMC','OTROS INGRESOS MARITIMOS'),(329,'IMO TRNSHPM L','IMO TRANSSHIPMENT (LUMPSUM)','%',0,'IMO TRANSSHIPMENT (LUMPSUM)','NO','IMC','OTROS INGRESOS MARITIMOS'),(330,'TRNSHPMNT N L','TRANSSHIPMENT NON STACKABLE','%',0,'TRANSSHIPMENT NON STACKABLE','NO','OTH','OTROS INGRESOS MARITIMOS'),(331,'TRNSHPMNT N','TRANSSHIPMENT NON STACKABLE W/M','%',0,'TRANSSHIPMENT NON STACKABLE W/M','NO','OTH','OTROS INGRESOS MARITIMOS'),(332,'THC','THC','%',0,'THC','NO','THC','CONSOLIDACION'),(333,'RETURN CHARGES','RETURN CHARGES','%',0,'RETURN CHARGES','NO','OTH','OTROS INGRESOS MARITIMOS'),(334,'LSS','LOW SULPHUR SURCHARGE W/M ','%',0,'LOW SULPHUR SURCHARGE W/M ','YES','SCHR','LOW SULPHUR, SULPHUR'),(335,'LSS MIN','LOW SULPHUR SURCHARGE ','%',0,'LOW SULPHUR SURCHARGE ','NO','SCHR','LOW SULPHUR, SULPHUR'),(336,'HANDLING ','HANDLING W/M','%',0,'HANDLING W/M','NO','HNDF','OTROS INGRESOS MARITIMOS'),(337,'LATE ARRIVAL L','LATE ARRIVAL LUMPSUM','%',0,'LATE ARRIVAL LUMPSUM','NO','OTH','OTROS INGRESOS LOCALES'),(338,'CAMBIO CNTR','CAMBIO DE EQUIPO','%',0,'CAMBIO DE EQUIPO','NO','CNTM','CONSOLIDACION'),(339,'PTF W/M','PTF W/M','%',0,'PTF W/M','YES',NULL,'PTF'),(340,'PTF (LUMPSUM)','PTF (LUMPSUM)','%',0,'(LUMPSUM)','NO',NULL,'PTF'),(341,'EMPLAYE','EMPLAYE','%',0,'EMPLAYE','NO',NULL,'OTROS INGRESOS MARITIMOS'),(342,'COLLECT FEE','COLLECT FEE','%',0,'COLLECT FEE','NO',NULL,'OTROS INGRESOS MARITIMOS'),(343,'THC W/M','THC W/M','%',0,'THC W/M','YES','THC','OTROS INGRESOS LOCALES'),(344,'RAYOS X W/M','RAYOS X W/M','%',0,'RAYOS X W/M','YES',NULL,'CONSOLIDACION'),(346,'STUFFING','STUFFING','%',0,'STUFFING','NO','CONS','CONSOLIDACION'),(347,'STUFFING IMO MIN','STUFFING IMO MIN','%',0,'STUFFING IMO MIN','NO','CONS','CONSOLIDACION'),(348,'STUFFING IMO W/M','STUFFING IMO W/M','%',0,'STUFFING IMO W/M','NO','CONS','CONSOLIDACION'),(349,'STUFFING MIN','STUFFING MIN','%',0,'STUFFING MIN','NO','CONS','CONSOLIDACION'),(350,'STUFFING W/M','STUFFING W/M','%',0,'STUFFING W/M','NO','CONS','CONSOLIDACION'),(351,'OCEAN FRGHT WM','OCEAN FREIGHT W/M','%',0,'OCEAN FREIGHT W/M','NO','OFR','FLETE MARITIMO'),(352,'TRNSHPMNT SRC','TRANSSHIPMENT SURCHARGE','%',0,'TRANSSHIPMENT SURCHARGE','NO','OTH','OTROS INGRESOS MARITIMOS'),(353,'PALLETIZING','PALLETIZING','%',0,'PALLETIZING','NO','OTH','DESPACHO ADUANAL'),(354,'DDC MIN','DDC MIN','%',0,'DDC MIN','NO','OTH','FLETE MARITIMO'),(355,'DDC W/M','DDC W/M','%',0,'DDC W/M','YES','DDC','FLETE MARITIMO');
/*!40000 ALTER TABLE `freightcharges_clasificacion` 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:47:35
