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

DROP TABLE IF EXISTS `bookingexpint_onhold`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `bookingexpint_onhold` (
  `files` varchar(255) NOT NULL DEFAULT '',
  `booking` varchar(255) NOT NULL DEFAULT '',
  `hbl` varchar(255) NOT NULL DEFAULT '',
  `customer` varchar(255) NOT NULL DEFAULT '',
  `idcustomer` varchar(255) NOT NULL DEFAULT '',
  `customertel` varchar(255) NOT NULL DEFAULT '',
  `customerfax` varchar(255) NOT NULL DEFAULT '',
  `customeremail` varchar(255) NOT NULL DEFAULT '',
  `customercontact` varchar(255) NOT NULL DEFAULT '',
  `placeofdelivery` varchar(255) NOT NULL DEFAULT '',
  `podbooking` varchar(255) NOT NULL DEFAULT '',
  `podiatabooking` varchar(255) NOT NULL DEFAULT '',
  `finaldestination` varchar(255) NOT NULL DEFAULT '',
  `transbordo` varchar(255) DEFAULT NULL,
  `transport` varchar(255) NOT NULL DEFAULT '',
  `transportcve` varchar(255) NOT NULL DEFAULT '',
  `transporttel` varchar(255) NOT NULL DEFAULT '',
  `transportcontact` varchar(255) NOT NULL DEFAULT '',
  `commentbooking` varchar(255) NOT NULL DEFAULT '',
  `blindcommentbooking` varchar(255) NOT NULL DEFAULT '',
  `etafinaldest` varchar(255) NOT NULL DEFAULT '',
  `pickupdate` varchar(255) NOT NULL DEFAULT '',
  `customsagent` varchar(255) NOT NULL DEFAULT '',
  `customstel` varchar(255) NOT NULL DEFAULT '',
  `customscontact` varchar(255) NOT NULL DEFAULT '',
  `container` varchar(255) NOT NULL DEFAULT '',
  `impresionconfirmacionbooking` varchar(255) NOT NULL DEFAULT '',
  `customsfax` varchar(255) NOT NULL DEFAULT '',
  `ofwm` varchar(255) NOT NULL DEFAULT '',
  `ofmin` varchar(255) NOT NULL DEFAULT '',
  `precarr` varchar(255) NOT NULL DEFAULT '',
  `other1` varchar(255) NOT NULL DEFAULT '',
  `imco` varchar(255) NOT NULL DEFAULT '',
  `custcl` varchar(255) NOT NULL DEFAULT '',
  `other2` varchar(255) NOT NULL DEFAULT '',
  `bllp` varchar(255) NOT NULL DEFAULT '',
  `exporter` varchar(255) NOT NULL DEFAULT '',
  `importer` varchar(255) NOT NULL DEFAULT '',
  `customstariffcode` varchar(255) NOT NULL DEFAULT '',
  `puckupyes` varchar(255) NOT NULL DEFAULT '',
  `ofwmc` varchar(255) NOT NULL DEFAULT '',
  `ofminc` varchar(255) NOT NULL DEFAULT '',
  `bllpc` varchar(255) NOT NULL DEFAULT '',
  `precarrc` varchar(255) NOT NULL DEFAULT '',
  `other1c` varchar(255) NOT NULL DEFAULT '',
  `imcoc` varchar(255) NOT NULL DEFAULT '',
  `custclc` varchar(255) NOT NULL DEFAULT '',
  `other2c` varchar(255) NOT NULL DEFAULT '',
  `id` varchar(250) NOT NULL DEFAULT '',
  `incoterms` varchar(250) NOT NULL DEFAULT '',
  `transportcompany` varchar(250) NOT NULL DEFAULT '',
  `ofwmop` varchar(10) NOT NULL DEFAULT '',
  `ofminop` varchar(10) NOT NULL DEFAULT '',
  `bllpop` varchar(10) NOT NULL DEFAULT '',
  `imcoop` varchar(10) NOT NULL DEFAULT '',
  `precarrop` varchar(10) NOT NULL DEFAULT '',
  `custclop` varchar(10) NOT NULL DEFAULT '',
  `other1op` varchar(10) NOT NULL DEFAULT '',
  `other2op` varchar(10) NOT NULL DEFAULT '',
  `cfs` varchar(50) NOT NULL DEFAULT '',
  `fum` varchar(50) NOT NULL DEFAULT '',
  `cfsc` varchar(50) NOT NULL DEFAULT '',
  `fumc` varchar(50) NOT NULL DEFAULT '',
  `cfsop` varchar(50) NOT NULL DEFAULT '',
  `fumop` varchar(50) NOT NULL DEFAULT '',
  `ofwmpp` varchar(50) NOT NULL DEFAULT '',
  `ofminpp` varchar(50) NOT NULL DEFAULT '',
  `bllppp` varchar(50) NOT NULL DEFAULT '',
  `imcopp` varchar(50) NOT NULL DEFAULT '',
  `precarrpp` varchar(50) NOT NULL DEFAULT '',
  `custclpp` varchar(50) NOT NULL DEFAULT '',
  `other1pp` varchar(50) NOT NULL DEFAULT '',
  `other2pp` varchar(50) NOT NULL DEFAULT '',
  `fumpp` varchar(50) NOT NULL DEFAULT '',
  `cfspp` varchar(50) NOT NULL DEFAULT '',
  `pickupaddress` varchar(250) NOT NULL DEFAULT '',
  `pickuptime` varchar(100) NOT NULL DEFAULT '',
  `transportfax` varchar(50) NOT NULL DEFAULT '',
  `transportemail` varchar(200) NOT NULL DEFAULT '',
  `customsemail` varchar(200) NOT NULL DEFAULT '',
  `idbooking` double NOT NULL AUTO_INCREMENT,
  `charge1` varchar(80) NOT NULL DEFAULT '',
  `charge2` varchar(80) NOT NULL DEFAULT '',
  `charge3` varchar(80) NOT NULL DEFAULT '',
  `charge4` varchar(80) NOT NULL DEFAULT '',
  `charge5` varchar(80) NOT NULL DEFAULT '',
  `charge6` varchar(80) NOT NULL DEFAULT '',
  `charge7` varchar(80) NOT NULL DEFAULT '',
  `charge8` varchar(80) NOT NULL DEFAULT '',
  `charge9` varchar(80) NOT NULL DEFAULT '',
  `charge10` varchar(80) NOT NULL DEFAULT '',
  `cwm1` tinyint(4) NOT NULL DEFAULT '0',
  `cwm2` tinyint(4) NOT NULL DEFAULT '0',
  `cwm3` tinyint(4) NOT NULL DEFAULT '0',
  `cwm4` tinyint(4) NOT NULL DEFAULT '0',
  `cwm5` tinyint(4) NOT NULL DEFAULT '0',
  `cwm6` tinyint(4) NOT NULL DEFAULT '0',
  `cwm7` tinyint(4) NOT NULL DEFAULT '0',
  `cwm8` tinyint(4) NOT NULL DEFAULT '0',
  `cwm9` tinyint(4) NOT NULL DEFAULT '0',
  `cwm10` tinyint(4) NOT NULL DEFAULT '0',
  `issue_hbl_booking` varchar(100) NOT NULL DEFAULT '',
  `inlandfreightterms` varchar(250) NOT NULL DEFAULT '',
  `oceanfreightterms` varchar(250) NOT NULL DEFAULT '',
  `scac_code` varchar(250) NOT NULL DEFAULT '',
  `referencia_interteam` varchar(150) NOT NULL DEFAULT '',
  `booking_interteam` varchar(150) NOT NULL DEFAULT '',
  `hbl_interteam` varchar(150) NOT NULL DEFAULT '',
  `pick_up_contact` varchar(250) NOT NULL DEFAULT '',
  `pick_up_telephone` varchar(250) NOT NULL DEFAULT '',
  `port_cto` varchar(250) NOT NULL DEFAULT '',
  `pick_up_comments` text NOT NULL,
  `tariff_pick_up` text NOT NULL,
  `transport_comments` text NOT NULL,
  `exportador_rfc` varchar(200) NOT NULL DEFAULT '',
  `exportador_telefono` varchar(250) NOT NULL DEFAULT '',
  `exportador_fax` varchar(250) NOT NULL DEFAULT '',
  `exportador_contacto` varchar(250) NOT NULL DEFAULT '',
  `consignee_tax_id` varchar(200) NOT NULL DEFAULT '',
  `consignee_telefono` varchar(250) NOT NULL DEFAULT '',
  `consignee_fax` varchar(250) NOT NULL DEFAULT '',
  `consignee_contacto` varchar(250) NOT NULL DEFAULT '',
  `fraccion` varchar(250) NOT NULL DEFAULT '',
  `regimen` varchar(250) NOT NULL DEFAULT '',
  `factura_comercial` varchar(250) NOT NULL DEFAULT '',
  `fecha_factura_comercial` varchar(50) NOT NULL DEFAULT '',
  `valor_comercial` varchar(200) NOT NULL DEFAULT '',
  `valor_agregado` varchar(200) NOT NULL DEFAULT '',
  `instrucciones_especiales_despacho` text NOT NULL,
  `notas_especiales_despacho` text NOT NULL,
  `exportador_direccion` text NOT NULL,
  `consignee_direccion` text NOT NULL,
  `regimen_de_exportacion` varchar(150) NOT NULL DEFAULT '',
  `factura_comercial_da` text NOT NULL,
  `fecha_factura_da` varchar(200) NOT NULL DEFAULT '',
  `valor_comercial_da` varchar(200) NOT NULL DEFAULT '',
  `valor_agregado_da` varchar(200) NOT NULL DEFAULT '',
  `as_agreed` varchar(50) NOT NULL DEFAULT '',
  `departure_date_cfs` varchar(20) NOT NULL DEFAULT '',
  `eta_port` varchar(20) NOT NULL DEFAULT '',
  `customer_nick_name` varchar(200) NOT NULL DEFAULT '',
  `agent_ref_numbers_1` varchar(200) NOT NULL DEFAULT '',
  `agent_ref_numbers_2` varchar(200) NOT NULL DEFAULT '',
  `pod_arrival_date` varchar(200) NOT NULL DEFAULT '',
  `ths_motor_vessel` varchar(200) NOT NULL DEFAULT '',
  `ets_tracking` varchar(200) NOT NULL DEFAULT '',
  `pod_tracking` varchar(200) NOT NULL DEFAULT '',
  `eta_tracking` varchar(200) NOT NULL DEFAULT '',
  `delivery_date_tracking` varchar(200) NOT NULL DEFAULT '',
  `notes_tracking` varchar(200) NOT NULL DEFAULT '',
  `no_cntr_2` varchar(200) NOT NULL DEFAULT '',
  `devaning_date` varchar(50) NOT NULL DEFAULT '',
  `pick_up_fee2` varchar(250) NOT NULL,
  `pick_up_fee3` varchar(250) NOT NULL,
  `comprador` varchar(250) NOT NULL,
  `comprador_direccion` varchar(250) NOT NULL,
  `comprador_contacto` varchar(250) NOT NULL,
  `comprador_telefono` varchar(250) NOT NULL,
  `comprador_fax` varchar(250) NOT NULL,
  `comprador_tax_id` varchar(250) NOT NULL,
  `communication_reference` text,
  `WWAShipmentReference` varchar(200) DEFAULT NULL,
  `forwarder_reference` varchar(250) DEFAULT NULL,
  `fechaRegistro` date DEFAULT NULL,
  `invoice_amount` varchar(11) DEFAULT NULL,
  `customercity` varchar(256) DEFAULT NULL,
  `pickuptime_from` varchar(100) DEFAULT NULL,
  `pickuptime_till` varchar(100) DEFAULT NULL,
  `pickupplace` varchar(100) DEFAULT NULL,
  `pickupcity` varchar(100) DEFAULT NULL,
  `pickupstate` varchar(100) DEFAULT NULL,
  `pickupzip` varchar(100) DEFAULT NULL,
  `pickupemail` varchar(100) DEFAULT NULL,
  `transportreference` varchar(100) DEFAULT NULL,
  `status20` int(11) DEFAULT '0',
  `status20_fecha_envio` datetime DEFAULT NULL,
  `status30` int(11) DEFAULT '0',
  `status30_fecha_envio` datetime DEFAULT NULL,
  `status40` int(11) DEFAULT '0',
  `status40_fecha_envio` datetime DEFAULT NULL,
  `idaa` int(11) DEFAULT NULL,
  `inlandfreightComments` text,
  `incoterm_ams` varchar(255) DEFAULT NULL,
  `status10` int(11) DEFAULT '0',
  `status10_fecha_envio` datetime DEFAULT NULL,
  `payment_date` date DEFAULT NULL,
  `status50` int(11) DEFAULT '0',
  `status50_fecha_envio` datetime DEFAULT NULL,
  `scac` varchar(100) DEFAULT NULL,
  `releasex` varchar(25) DEFAULT NULL,
  `ejecutivo_de_ventas` varchar(255) DEFAULT NULL,
  `routing_order` tinyint(1) DEFAULT '0',
  `sucursal` varchar(255) DEFAULT NULL,
  `confirmado` tinyint(1) DEFAULT NULL,
  `ejecutivo_anterior` varchar(255) DEFAULT NULL,
  `cambiado_por` varchar(255) DEFAULT NULL,
  `fecha_confirmacion` datetime DEFAULT NULL,
  `last_update` timestamp NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `customs_quotation` varchar(100) DEFAULT NULL,
  `customs_invoice_amount` varchar(100) DEFAULT NULL,
  `booking_interteam_nuevo` varchar(100) DEFAULT NULL,
  `guardo_usuario` varchar(100) DEFAULT NULL,
  `modifico_usuario` varchar(100) DEFAULT NULL,
  `horaRegistro` varchar(11) DEFAULT NULL,
  `horaModificacion` varchar(11) DEFAULT NULL,
  `archivo_status10` text,
  `archivo_status20` text,
  `archivo_status30` text,
  `archivo_status40` text,
  `archivo_status50` text,
  `archivo_nofee` tinyint(1) DEFAULT '0',
  `service_terrestre` varchar(10) DEFAULT NULL,
  `datos_de_recoleccion` varchar(25) DEFAULT NULL,
  `operador_terrestre` varchar(255) DEFAULT NULL,
  `placas` varchar(100) DEFAULT NULL,
  `tipo_de_unidad` varchar(100) DEFAULT NULL,
  `recoleccion_efectiva` varchar(25) DEFAULT NULL,
  `fecha_estimada_llegada_a_puerto` date DEFAULT NULL,
  `tt_a_puerto` varchar(10) DEFAULT NULL,
  `llegada_a_puerto` varchar(25) DEFAULT NULL,
  `fecha_confirmada_arribo_a_puerto` date DEFAULT NULL,
  `tt_real_a_puerto` varchar(10) DEFAULT NULL,
  `reporte_de_embarque_aa` varchar(255) DEFAULT NULL,
  `ingreso_a_recinto_portuario` varchar(25) DEFAULT NULL,
  `fecha_ingreso_a_recinto` date DEFAULT NULL,
  `observaciones_recoleccion` text,
  `numero_de_servicio_terrestre` varchar(100) DEFAULT NULL,
  `ronline_barco` varchar(100) DEFAULT NULL,
  `ronline_from` varchar(255) DEFAULT NULL,
  `ronline_via` varchar(255) DEFAULT NULL,
  `ronline_viaje` varchar(10) DEFAULT NULL,
  `ronline_zarpe` varchar(10) DEFAULT NULL,
  `ronline_cierreimo` varchar(10) DEFAULT NULL,
  `ronline_cierredoctos` varchar(10) DEFAULT NULL,
  `ronline_ets` varchar(10) DEFAULT NULL,
  `ronline_flete_maritimo` varchar(25) DEFAULT NULL,
  `ronline_completado` tinyint(1) DEFAULT '0',
  `idagente_aduanal` int(11) DEFAULT NULL,
  `atd` date DEFAULT NULL,
  `ets` date DEFAULT NULL,
  `facturado` int(1) DEFAULT '0',
  `fecha_factura` datetime DEFAULT NULL,
  `facturo_factura` varchar(100) DEFAULT NULL,
  `referencia_int` varchar(100) DEFAULT NULL,
  `folio_facturas` varchar(10) DEFAULT NULL,
  `archivo_xml` text,
  `archivo_pdf` text,
  `creo_atd` varchar(100) DEFAULT NULL,
  `idticket` int(11) DEFAULT NULL,
  `no_aplica_confirmacion_pago` text,
  `status12` int(11) DEFAULT '0',
  `status12_fecha_envio` datetime DEFAULT NULL,
  `archivo_status12` text,
  `liberado` date DEFAULT NULL,
  `routing_reference` varchar(255) DEFAULT NULL,
  `harmonized_code` text,
  `usuario_guardo_no_aplica` text,
  `actualizacion_remota` int(11) DEFAULT '0',
  `fecha_estimada_programacion` date DEFAULT NULL,
  `fecha_estimada_confirmacion` date DEFAULT NULL,
  `fecha_datos_recoleccion` date DEFAULT NULL,
  `fecha_arribo_planta` date DEFAULT NULL,
  `fecha_recoleccion_efectiva` date DEFAULT NULL,
  `fecha_reporte_aa` date DEFAULT NULL,
  `fecha_ingreso_efectiva` date DEFAULT NULL,
  `fecha_real_programacion` date DEFAULT NULL,
  `fecha_real_confirmacion_servicio` date DEFAULT NULL,
  `hora_estimada_programacion` varchar(11) DEFAULT NULL,
  `hora_estimada_confirmacion` varchar(11) DEFAULT NULL,
  `hora_real_datos_recoleccion` varchar(11) DEFAULT NULL,
  `hora_planeada_arribo` varchar(11) DEFAULT NULL,
  `hora_real_recoleccion` varchar(11) DEFAULT NULL,
  `hora_estimada_arribo_puerto` varchar(11) DEFAULT NULL,
  `hora_estimada` varchar(11) DEFAULT NULL,
  `hora_real_reporte` varchar(11) DEFAULT NULL,
  `hora_confirmada_arribo` varchar(11) DEFAULT NULL,
  `hora_real_ingreso` varchar(11) DEFAULT NULL,
  `hora_real_programacion` varchar(11) DEFAULT NULL,
  `hora_real_confirmacion` varchar(11) DEFAULT NULL,
  `hora_real_llegada_puerto` varchar(11) DEFAULT NULL,
  `hora_real_llegada` varchar(11) DEFAULT NULL,
  `recoleccion_puerta` date DEFAULT NULL,
  `fecha_salida_almacen` date DEFAULT NULL,
  `fecha_ingreso_almacen_cross_dock_pod` date DEFAULT NULL,
  `fecha_salida_almacen_cross_dock_pod` date DEFAULT NULL,
  `fecha_ingreso_almacen_cross_dock_destino` date DEFAULT NULL,
  `fecha_salida_almacen_cross_dock_destino` date DEFAULT NULL,
  `hora_planeada_recoleccion` varchar(11) DEFAULT NULL,
  `hora_confirmada_salida` varchar(11) DEFAULT NULL,
  `hora_planeada_cross_dock_pod` varchar(11) DEFAULT NULL,
  `hora_confirmada_cross_dock_pod` varchar(11) DEFAULT NULL,
  `hora_planeada_cross_dock_destino` varchar(11) DEFAULT NULL,
  `hora_confirmada_cross_dock_destino` varchar(11) DEFAULT NULL,
  `fecha_creo_atd` varchar(19) DEFAULT NULL,
  `fecha_modifico_atd` varchar(19) DEFAULT NULL,
  `modifico_atd` varchar(100) DEFAULT NULL,
  `numero_guia` varchar(255) DEFAULT NULL,
  `pickupplace2` varchar(255) DEFAULT NULL,
  `via` text,
  `cotizacion_numero` varchar(10) DEFAULT NULL,
  `patente` varchar(25) DEFAULT NULL,
  `status_booking_mensaje` text,
  `status_booking` varchar(45) DEFAULT NULL,
  `fecha_updated_ronline` varchar(45) DEFAULT NULL,
  `referencia_credito` text,
  `reviso_pago_no_aplica` varchar(45) DEFAULT NULL,
  `fecha_reviso_pago_no_aplica` varchar(45) DEFAULT NULL,
  `coordinacion_cs` varchar(45) DEFAULT NULL,
  `incoterm_booking` varchar(45) DEFAULT NULL,
  `ets_booking` varchar(45) DEFAULT NULL,
  `tipo_de_cierre_mex` varchar(45) DEFAULT NULL,
  `nac` text,
  `fecha_recepcion_ro` varchar(45) DEFAULT NULL,
  `hora_recepcion_ro` varchar(45) DEFAULT NULL,
  `fecha_solicitud_booking_manual` varchar(45) DEFAULT NULL,
  `hora_solicitud_booking_manual` varchar(45) DEFAULT NULL,
  `fecha_contacto_cliente` varchar(45) DEFAULT NULL,
  `hora_contacto_cliente` varchar(45) DEFAULT NULL,
  `comentarios_status_contacto_shipper` text,
  `fecha_confirmacion_reservacion` varchar(45) DEFAULT NULL,
  `finaldestination_uncode` varchar(45) DEFAULT NULL,
  `transporte_responsable_recoleccion_fuera_de_tiempo` varchar(1) DEFAULT NULL,
  `podria_tener_servicio_terrestre` varchar(2) DEFAULT NULL,
  `legs` varchar(25) DEFAULT NULL,
  `ejecutivo_ro` varchar(50) DEFAULT NULL,
  `historial_cambios` text,
  `condiciones_de_credito` varchar(45) DEFAULT NULL,
  `fecha_primer_roll` varchar(45) DEFAULT NULL,
  `customer_service` varchar(100) DEFAULT NULL,
  `delivery_street` text,
  `delivery_location` text,
  `delivery_city` text,
  `delivery_state` text,
  `delivery_country` text,
  `delivery_zip` text,
  `delivery_name_contact` text,
  `delivery_telephone` text,
  `delivery_email` text,
  `validity_until` varchar(25) DEFAULT NULL,
  `actualizacion_tarifas` int(11) DEFAULT NULL,
  `update_billing` int(1) DEFAULT NULL,
  `update_billing_fecha` varchar(45) DEFAULT NULL,
  `update_billing_hora` varchar(45) DEFAULT NULL,
  `update_billing_usuario` varchar(45) DEFAULT NULL,
  `fecha_hora_reservacion` text,
  `customer_services_interteam_segun_lane` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`idbooking`),
  KEY `i_files_b` (`files`),
  KEY `i_files__booking_b` (`files`,`booking`),
  KEY `i_booking_b` (`booking`),
  KEY `i_fechaReg_b` (`fechaRegistro`),
  KEY `i_rr_b` (`booking_interteam`,`routing_reference`),
  KEY `i_crr_b` (`booking_interteam`,`communication_reference`(255)),
  KEY `i_frr_b` (`booking_interteam`,`forwarder_reference`),
  KEY `i_B_BEXPINT` (`booking_interteam`),
  KEY `i_fr` (`forwarder_reference`),
  KEY `i_rr` (`routing_reference`),
  KEY `i_files` (`files`),
  KEY `i_customer` (`customer`),
  KEY `i_atd` (`atd`),
  KEY `i_booking_interteam` (`booking_interteam`),
  KEY `i_etafinaldest` (`etafinaldest`),
  KEY `i_fecha_primer_roll` (`fecha_primer_roll`),
  KEY `i_ets` (`ets`)
) ENGINE=InnoDB AUTO_INCREMENT=856463 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bookingexpint_onhold`
--

LOCK TABLES `bookingexpint_onhold` WRITE;
/*!40000 ALTER TABLE `bookingexpint_onhold` DISABLE KEYS */;
INSERT INTO `bookingexpint_onhold` VALUES ('ZLOSHG14207M24','BKG853061','','HALDEX PRODUCTS DE MEXICO S.A. DE C.V.','','81 81569500','','RAUL.GARCIA@HALDEX.COM','RAUL GARCIA','MEXICO CITY, MEXICO','','','SHANGHAI Pt, CHINA',NULL,'','','','','','','2024/03/02','2023-09-13','CARLOS MIGUEL REYES DIAZ						','','IRIS PADRON','','','','20','15','20','','13','154','','20','','','','','','','','','','','','','','','TRANS NEYNO, S.A. DE C.V.','USD','USD','USD','USD','USD','USD','','','215','20','','','USD','USD','CC','CC','CC','CC','CC','CC','','','CC','CC','CARR MIGUEL ALEMAN KM 20.5, PARQUE PROLOGIS INT 2','','','','IPADRON.MTY@GRUPOEI.COM.MX',853061,'CONSOL FEE W/M','BL FEE','VGM FEE','PTF W/M','VALIDATION & ADMON. FEE','INLAND SERVICE COORDINATION LUMPSUM','CUSTOMS CLEARANCE','OCEAN FREIGHT W/M','','',1,0,0,1,0,0,0,1,0,0,'','2720.16','','','','EXITZLOSHA853061','','RAUL GARCIA','81.81.56.95.28','','MTY2271','','SIN EXTENSION DE HORARIO','','','','','','','','','','','','','','','','','','','','','','','','','','2023-09-21','','','','','','','','','','','','','','','','','','','','','','EXITZLOSHA853061MXMEX01','NOT PROVIDED','2023-09-12','3046.58',NULL,'07:00 AM','04:00 PM','HALDEX PRODUCTS DE MEXICO S.A. DE C.V.','APODACA','NUEVO LEON','66627','.','TAE',1,'2023-10-03 13:51:30',1,'2023-10-09 05:25:32',1,'2023-10-27 06:46:01',0,'0.00 USD',NULL,1,'2023-09-12 13:34:09','2023-10-06',1,'2023-10-27 06:47:24','NO APLICA','YES','   NO ASIGNADO',1,'NUEVO LEON',NULL,NULL,NULL,NULL,'2024-02-20 17:12:06',NULL,NULL,'EXITZLOSHA853061','MOHERNANDEZ',NULL,'13:34:08',NULL,'../MILESTONES/SHIPMENT_STATUS.INTERTEAM.20230912.013408.00.xml','','../MILESTONES/SHIPMENT_STATUS.INTERTEAM30.20231009.052532.00.xml','../MILESTONES/SHIPMENT_STATUS.INTERTEAM40.20231027.064600.00.xml','../MILESTONES/SHIPMENT_STATUS.INTERTEAM50.20231027.064723.00.xml',1,'LTL','EN TIEMPO','ALFONSO QUIÑONEZ','DS-23-E','CAMIONETA 1 ½','EN TIEMPO','2023-09-17','3','EN TIEMPO','2023-09-17','3','EN TIEMPO','EN TIEMPO','2023-09-17','','TINTZLOSHA4570.23',NULL,NULL,'HKHKG',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'0000-00-00','2023-09-27',1,'2024-01-17 10:54:08','MBECERRA','ZLO4523-SHA','447326','sm/F202401/F_INTERTEAM_DF__447326_2024-01-1710.54.05.xml','sm/PDF202401/F_INTERTEAM_DF__447326_2024-01-1710.54.08.pdf',NULL,NULL,'',1,'2024-02-19 04:07:31','../MILESTONES/SHIPMENT_STATUS.INTERTEAM12.20240219.040730.00.xml','0000-00-00','.','8708309903, 8481809900','JPUGA-exporta 2023-10-26',0,'2023-09-13','2023-09-13','2023-09-13','2023-09-13','2023-09-13','2023-09-17','2023-09-17','2023-09-13','2023-09-13','11:00 pm','11:00 pm','11:00 pm','11:00 pm','11:00 pm','11:00 pm','11:00 pm','11:00 pm','11:00 pm','11:00 pm','01:00 am','01:00 am','01:00 am','01:00 am','2023-09-14','2023-09-12','2023-09-06','2023-09-04','2023-09-21','2023-09-13','11:00 pm','03:00 am','11:00 pm','03:00 am','11:00 pm','03:00 am',NULL,'2024-02-19 17:07:51','FMENDOZA-exporta',NULL,NULL,'HONG KONG','EXPO-47978',NULL,NULL,NULL,NULL,'',NULL,NULL,'','DAP','2024/03/02','','','2023-09-12','13:35','2023-09-06','17:51:44','','','','2023-09-12 13:34:08','CNSHG','0',NULL,'DIRECT','MOHERNANDEZ','<p>2023-09-12 14:34:32 MOHERNANDEZ Nuevo concepto </p><p>2023-09-12 14:34:32 MOHERNANDEZ Nuevo concepto </p><p>2023-09-12 14:34:32 MOHERNANDEZ Nuevo concepto </p><p>2023-09-12 14:34:32 MOHERNANDEZ Nuevo concepto </p><p>2023-09-12 14:34:32 MOHERNANDEZ Nuevo concepto </p><p>2023-09-12 14:34:32 MOHERNANDEZ Nuevo concepto </p><p>2023-09-12 14:34:32 MOHERNANDEZ Nuevo concepto </p><p>2023-09-12 14:34:32 MOHERNANDEZ Nuevo concepto </p><p>2023-09-12 14:34:32 MOHERNANDEZ Nuevo concepto </p><p>2023-09-12 14:34:32 MOHERNANDEZ Nuevo concepto </p><p>2023-09-12 14:34:32 MOHERNANDEZ Nuevo concepto </p><p>2023-09-19 13:59:50 FMENDOZA Nuevo concepto R</p><p>2023-09-19 13:59:50 FMENDOZA Borro concepto R</p><p>2023-09-19 13:59:50 FMENDOZA Nuevo concepto ROLL OVER LUMPSUM</p><p>2023-10-10 12:43:42 CBRENIZ Nuevo concepto R</p><p>2023-10-10 12:43:42 CBRENIZ Borro concepto R</p><p>2023-12-04 16:28:52 FMENDOZA Nuevo concepto R</p><p>2023-12-04 16:28:52 FMENDOZA Borro concepto R</p><p>2024-02-16 16:45:41 IVMARTINEZ Nuevo concepto R</p><p>2024-02-16 16:45:41 IVMARTINEZ Borro concepto R</p><p>2024-02-20 09:02:15 TSANCHEZ Nuevo concepto R</p><p>2024-02-20 09:02:15 TSANCHEZ Borro concepto R</p><p>2024-02-20 09:02:15 TSANCHEZ Borro concepto CONSOL FEE W/M</p><p>2024-02-20 09:02:15 TSANCHEZ Nuevo concepto BL FEE</p><p>2024-02-20 09:02:15 TSANCHEZ Nuevo concepto VGM FEE</p><p>2024-02-20 09:02:15 TSANCHEZ Nuevo concepto PTF W/M</p><p>2024-02-20 09:02:15 TSANCHEZ Nuevo concepto VALIDATION & ADMON. FEE</p><p>2024-02-20 09:02:15 TSANCHEZ Nuevo concepto PICK UP & DELIVERY</p><p>2024-02-20 09:02:15 TSANCHEZ Nuevo concepto CUSTOMS CLEARANCE</p><p>2024-02-20 09:02:15 TSANCHEZ Nuevo concepto OCEAN FREIGHT W/M</p><p>2024-02-20 09:02:15 TSANCHEZ Nuevo concepto ROLL OVER LUMPSUM</p><p>2024-02-20 09:02:15 TSANCHEZ Cambio concepto de CONSOL FEE W/M a </p><p>2024-02-20 09:02:15 TSANCHEZ Cambio concepto de BL FEE a </p><p>2024-02-20 09:02:15 TSANCHEZ Cambio concepto de VGM FEE a </p><p>2024-02-20 09:02:15 TSANCHEZ Cambio concepto de PTF W/M a </p><p>2024-02-20 09:02:15 TSANCHEZ Cambio concepto de VALIDATION & ADMON. FEE a </p><p>2024-02-20 09:02:15 TSANCHEZ Cambio concepto de PICK UP & DELIVERY a </p><p>2024-02-20 09:02:15 TSANCHEZ Cambio concepto de CUSTOMS CLEARANCE a </p><p>2024-02-20 09:02:15 TSANCHEZ Cambio concepto de OCEAN FREIGHT W/M a </p><p>2024-02-20 09:02:15 TSANCHEZ Cambio concepto de ROLL OVER LUMPSUM a </p><p>2024-02-20 09:02:15 TSANCHEZ Cambio importe de  de 20 a </p><p>2024-02-20 09:02:15 TSANCHEZ Cambio importe de  de 15 a </p><p>2024-02-20 09:02:15 TSANCHEZ Cambio importe de  de 20 a </p><p>2024-02-20 09:02:15 TSANCHEZ Cambio importe de  de 13 a </p><p>2024-02-20 09:02:15 TSANCHEZ Cambio importe de  de 20 a </p><p>2024-02-20 09:02:15 TSANCHEZ Cambio importe de  de 154 a </p><p>2024-02-20 09:02:15 TSANCHEZ Cambio importe de de 116 a </p><p>2024-02-20 09:02:15 TSANCHEZ Cambio importe de  de 215 a </p><p>2024-02-20 09:02:15 TSANCHEZ Cambio importe de  de 20 a </p><p>2024-02-20 11:12:06 TSANCHEZ Nuevo concepto R</p><p>2024-02-20 11:12:06 TSANCHEZ Borro concepto R</p><p>2024-02-20 11:12:06 TSANCHEZ Nuevo concepto CONSOL FEE W/M</p><p>2024-02-20 11:12:06 TSANCHEZ Nuevo concepto BL FEE</p><p>2024-02-20 11:12:06 TSANCHEZ Nuevo concepto VGM FEE</p><p>2024-02-20 11:12:06 TSANCHEZ Nuevo concepto PTF W/M</p><p>2024-02-20 11:12:06 TSANCHEZ Nuevo concepto VALIDATION & ADMON. FEE</p><p>2024-02-20 11:12:06 TSANCHEZ Nuevo concepto INLAND SERVICE COORDINATION LUMPSUM</p><p>2024-02-20 11:12:06 TSANCHEZ Nuevo concepto CUSTOMS CLEARANCE</p><p>2024-02-20 11:12:06 TSANCHEZ Nuevo concepto OCEAN FREIGHT W/M</p>','DE CONTADO','2024-02-01 21:57:14','','','','','','','','','','','2023-09-30',NULL,NULL,NULL,NULL,NULL,'2023-09-12 13:39:40',NULL),('VERCFZ14316M24','BKG856461','','REDUCTORES DE MEXICO S.A.','','00-0000-0000','','ELIZAMATA@REMEX-AMARILLO.COM','ELIZABETH MATA','NUEVO LEON, MEXICO','','','COLON, PANAMA',NULL,'','','','','OMISION DE PAGO MEI','','2024/03/16','2024-02-12','INTERTEAM // AA DAG','','','','','','15','20','240','60','20','309','','13','REDUCTORES DE MEXICO','AZULES DEL CAMPO S.A.','','','','','','','','','','','','','TRANS NEYNO, S.A. DE C.V.','USD','USD','USD','USD','USD','USD','USD','','20','20','','','USD','USD','CC','CC','CC','CC','CC','CC','CC','','CC','CC','CALLEJON LOS ARREDONDO NO. 183 COL. EX HACIENDA DE ARREDONDOS','','','','',856461,'BL FEE','VGM FEE','PTF (LUMPSUM)','VALIDATION & ADMON. FEE','INLAND SERVICE COORDINATION LUMPSUM','CUSTOMS CLEARANCE','NON STACKABLE CHARGE MIN','CONSOL FEE MIN','OCEAN FREIGHT (MIN)','',0,0,0,0,0,0,0,0,0,0,'','4161.83','','','','EXITVERONX856461','','ELIZABETH MATA CORTES','(81)15222780 -  82 -  83','','MTY3341','','NO ESTIBABLE','RME770714I22','','','','','','','','','','','','','','','','CALLEJON LOS ARREDONDO 183 BOSQUES DEL PONIENTE SANTA CATARINA NUEVO LEóN MéXICO 66362','PARQUE LEFEVRE, BOULEVARD ROBERTO MOTTA ED. CAP. PLAZA PISO 19 OF 19A PANAMA PANAMA PANAMá 0801','A1','332','2024-01-23','14,900.00 USD ','14,900.00','','','','','','','','','','','','','','','','','','AZULES DEL CAMPO S.A.','PARQUE LEFEVRE, BOULEVARD ROBERTO MOTTA ED. CAP. PLAZA PISO 19 OF 19A PANAMA PANAMA PANAMá 0801','','','','','','EXITVERONX856461MXMEX01','NOT PROVIDED','2024-02-08','4661.29',NULL,'09:00 AM','04:00 PM','REDUCTORES DE MEXICO S.A.','SANTA CATARINA','NUEVO LEON','66362','.','TAE',0,NULL,0,NULL,0,NULL,0,'0.00 USD','EXW ',1,'2024-02-08 11:13:09','2024-03-01',0,NULL,'NO APLICA','YES','   NO ASIGNADO',1,'MONTERREY',NULL,NULL,NULL,NULL,'2024-02-26 23:15:56','','','EXITVERONX856461','ESANTOS',NULL,'12:13:07',NULL,'../MILESTONES/SHIPMENT_STATUS.INTERTEAM.20240208.111308.00.xml',NULL,NULL,NULL,NULL,0,'LTL','EN TIEMPO','ALFONSO QUIÑONEZ','PO-M98-1','CAMIONETA 3 ½','EN TIEMPO','2024-02-18','3','FUERA DE TIEMPO','2024-02-18','3','EN TIEMPO','EN TIEMPO','2024-02-18','','TINTVERONX0529.24',NULL,NULL,'DIRECT',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'2023-08-20','2023-08-20',0,NULL,NULL,'VER3023-ONX',NULL,NULL,NULL,NULL,NULL,NULL,1,'2024-02-15 11:50:38','../MILESTONES/SHIPMENT_STATUS.INTERTEAM12.20240215.115037.00.xml','0000-00-00','','8483400999',NULL,0,'2024-02-13','2024-02-13','2024-02-13','2024-02-13','2024-02-13','2024-02-18','2024-02-18','2024-02-13','2024-02-13','11:00 pm','11:00 pm','11:00 pm','11:00 pm','11:00 pm','11:00 pm','11:00 pm','11:00 pm','10:00 pm','11:00 pm','02:00 am','02:00 am','02:00 am','03:00 am','2024-02-08','2024-02-22','2024-02-07','2024-02-08','2024-02-21','2024-02-15','11:00 pm','02:00 am','11:00 pm','02:00 am','11:00 pm','02:00 am',NULL,NULL,NULL,NULL,NULL,'','EXPO-55380',NULL,NULL,NULL,NULL,'',NULL,NULL,'','EXW',NULL,'','','2024-02-08','12:12','2024-02-07','12:44:53','','','','2024-02-08 12:13:08','PAONX','0',NULL,'DIRECT','ESANTOS','<p>2024-02-08 12:14:30 ESANTOS Nuevo concepto </p><p>2024-02-08 12:14:30 ESANTOS Nuevo concepto </p><p>2024-02-08 12:14:30 ESANTOS Nuevo concepto </p><p>2024-02-08 12:14:30 ESANTOS Nuevo concepto </p><p>2024-02-08 12:14:30 ESANTOS Nuevo concepto </p><p>2024-02-08 12:14:30 ESANTOS Nuevo concepto </p><p>2024-02-08 12:14:30 ESANTOS Nuevo concepto </p><p>2024-02-08 12:14:30 ESANTOS Nuevo concepto </p><p>2024-02-08 12:14:30 ESANTOS Nuevo concepto </p><p>2024-02-08 12:14:30 ESANTOS Nuevo concepto </p><p>2024-02-08 12:14:30 ESANTOS Nuevo concepto </p><p>2024-02-08 12:15:48 ESANTOS Nuevo concepto R</p><p>2024-02-08 12:15:48 ESANTOS Borro concepto R</p><p>2024-02-08 12:15:48 ESANTOS Nuevo concepto PTF (LUMPSUM)</p><p>2024-02-08 12:15:48 ESANTOS Nuevo concepto NON STACKABLE CHARGE MIN</p><p>2024-02-08 12:15:48 ESANTOS Nuevo concepto CONSOL FEE MIN</p><p>2024-02-08 12:15:48 ESANTOS Nuevo concepto OCEAN FREIGHT (MIN)</p><p>2024-02-08 12:15:48 ESANTOS Cambio concepto de PTF W/M a PTF (LUMPSUM)</p><p>2024-02-08 12:15:48 ESANTOS Cambio concepto de NON STACKABLE CHARGE W/M a NON STACKABLE CHARGE MIN</p><p>2024-02-08 12:15:48 ESANTOS Cambio concepto de CONSOL FEE W/M a CONSOL FEE MIN</p><p>2024-02-08 12:15:48 ESANTOS Cambio concepto de OCEAN FREIGHT W/M a OCEAN FREIGHT (MIN)</p><p>2024-02-13 10:27:37 ESANTOS Nuevo concepto R</p><p>2024-02-13 10:27:37 ESANTOS Cambio concepto de R a LABELING (ETIQUETADO)</p><p>2024-02-19 14:15:17 ESANTOS Nuevo concepto R</p><p>2024-02-19 14:15:17 ESANTOS Cambio concepto de R a LABELING (ETIQUETADO)</p><p>2024-02-26 17:15:56 ESANTOS Nuevo concepto R</p><p>2024-02-26 17:15:56 ESANTOS Cambio concepto de R a LABELING (ETIQUETADO)</p>','DE CONTADO','2024-02-22 21:35:26','','','','','','','','','','','2024-03-31',NULL,NULL,NULL,NULL,NULL,'2024-02-08 12:25:38',NULL),('VERCFZ14316M24','BKG856462','','REDUCTORES DE MEXICO S.A.','','00-0000-0000','','ELIZAMATA@REMEX-AMARILLO.COM','ELIZABETH MATA','NUEVO LEON, MEXICO','','','COLON, PANAMA',NULL,'','','81 8386-3521','MAYRA BALDERAS','','','2024/03/16','2024-02-09','INTERTEAM // AA DAG','','','','','','15','20','414.90','60','20','309','','13','REDUCTORES DE MEXICO, S.A.				','AGUADULCE SEAFOOD VIA S.A.','','','','','','','','','','','','','TRANS NEYNO, S.A. DE C.V.','USD','USD','USD','USD','USD','USD','USD','','20','20','','','USD','USD','CC','CC','CC','CC','CC','CC','CC','','CC','CC','CALLEJON LOS ARREDONDO NO. 183 COL. EX HACIENDA DE ARREDONDOS','','','LOGISTICAALT@TRANSNEYNO.COM.MX','',856462,'BL FEE','VGM FEE','PTF W/M','VALIDATION & ADMON. FEE','INLAND SERVICE COORDINATION LUMPSUM','CUSTOMS CLEARANCE','NON STACKABLE CHARGE W/M','CONSOL FEE W/M','OCEAN FREIGHT W/M','',0,0,1,0,0,0,1,1,1,0,'','5398.86','','','','EXITVERONX856462','','ELIZABETH MATA CORTES','(81)15222780 -  82 -  83','','MTY3340','','NO ESTIBABLE','RME770714I22','','','','XEXX010101000','','','','','','','','','','','','CALLEJON LOS ARREDONDO 183 BOSQUES DEL PONIENTE SANTA CATARINA NUEVO LEóN MéXICO 66362','AGUADULCE VIA EL PUERTO PANAMA PANAMA PANAMA 0801','A1','334','2024-01-23','29,800.00 USD ','','','','','','','','','','','','','','','','','','','AGUADULCE SEAFOOD VIA S.A.','AGUADULCE VIA EL PUERTO PANAMA PANAMA PANAMA 0801','','','','XEXX010101000','','EXITVERONX856462MXMEX01','NOT PROVIDED','2024-02-08','6046.73',NULL,'09:00 AM','04:00 PM','REDUCTORES DE MEXICO S.A.','SANTA CATARINA','NUEVO LEON','66362','.','TAE',0,NULL,0,NULL,0,NULL,0,'0.00 USD','EXW',1,'2024-02-08 11:18:41','2024-03-01',0,NULL,'NO APLICA','YES','   NO ASIGNADO',1,'MONTERREY',NULL,NULL,NULL,NULL,'2024-02-28 16:41:21','','0.00','EXITVERONX856462','ESANTOS',NULL,'12:18:40',NULL,'../MILESTONES/SHIPMENT_STATUS.INTERTEAM.20240208.111840.00.xml',NULL,NULL,NULL,NULL,0,'LTL','EN TIEMPO','ALFONSO QUIÑONEZ','PO-M98-1','CAMIONETA 3 ½','EN TIEMPO','2024-02-18','3','EN TIEMPO','2024-02-18','3','FUERA DE TIEMPO','EN TIEMPO','2024-02-18','','TINTVERONX0528.24',NULL,NULL,'DIRECT',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'2023-08-20','2023-08-20',0,NULL,NULL,'VER3023-ONX',NULL,NULL,NULL,NULL,NULL,NULL,1,'2024-02-19 02:52:13','../MILESTONES/SHIPMENT_STATUS.INTERTEAM12.20240219.025212.00.xml','0000-00-00','.','8483400999',NULL,0,'2024-02-13','2024-02-13','2024-02-13','2024-02-13','2024-02-13','2024-02-18','2024-02-18','2024-02-13','2024-02-13','11:00 pm','11:00 pm','11:00 pm','11:00 pm','11:00 pm','11:00 pm','11:00 pm','11:00 pm','10:00 pm','11:00 pm','02:00 am','02:00 am','02:00 am','03:00 am','2024-02-08','2024-02-14','2024-02-21','2024-02-14','2024-02-21','2024-02-08','11:00 pm','02:00 am','11:00 pm','02:00 am','11:00 pm','02:00 am',NULL,NULL,NULL,NULL,NULL,'','EXPO-55417',NULL,NULL,NULL,NULL,'',NULL,NULL,'','EXW',NULL,'','','2024-02-08','12:18','2024-02-07','16:24:12','','','','2024-02-08 12:18:40','PAONX','0',NULL,'DIRECT','ESANTOS','<p>2024-02-08 12:20:39 ESANTOS Nuevo concepto </p><p>2024-02-08 12:20:39 ESANTOS Nuevo concepto </p><p>2024-02-08 12:20:39 ESANTOS Nuevo concepto </p><p>2024-02-08 12:20:39 ESANTOS Nuevo concepto </p><p>2024-02-08 12:20:39 ESANTOS Nuevo concepto </p><p>2024-02-08 12:20:39 ESANTOS Nuevo concepto </p><p>2024-02-08 12:20:39 ESANTOS Nuevo concepto </p><p>2024-02-08 12:20:39 ESANTOS Nuevo concepto </p><p>2024-02-08 12:20:39 ESANTOS Nuevo concepto </p><p>2024-02-08 12:20:39 ESANTOS Nuevo concepto </p><p>2024-02-08 12:20:39 ESANTOS Nuevo concepto </p><p>2024-02-08 12:20:39 ESANTOS Nuevo concepto PTF (LUMPSUM)</p><p>2024-02-08 12:20:39 ESANTOS Nuevo concepto NON STACKABLE CHARGE MIN</p><p>2024-02-08 12:20:39 ESANTOS Nuevo concepto CONSOL FEE MIN</p><p>2024-02-08 12:20:39 ESANTOS Nuevo concepto OCEAN FREIGHT (MIN)</p><p>2024-02-08 12:20:39 ESANTOS Cambio concepto de PTF W/M a PTF (LUMPSUM)</p><p>2024-02-08 12:20:39 ESANTOS Cambio concepto de NON STACKABLE CHARGE W/M a NON STACKABLE CHARGE MIN</p><p>2024-02-08 12:20:39 ESANTOS Cambio concepto de CONSOL FEE W/M a CONSOL FEE MIN</p><p>2024-02-08 12:20:39 ESANTOS Cambio concepto de OCEAN FREIGHT W/M a OCEAN FREIGHT (MIN)</p><p>2024-02-13 10:07:11 ESANTOS Nuevo concepto R</p><p>2024-02-13 10:07:11 ESANTOS Cambio concepto de R a LABELING (ETIQUETADO)</p><p>2024-02-15 13:32:04 ESANTOS Nuevo concepto R</p><p>2024-02-15 13:32:04 ESANTOS Cambio concepto de R a LABELING (ETIQUETADO)</p><p>2024-02-15 15:20:18 ESANTOS Nuevo concepto R</p><p>2024-02-15 15:20:18 ESANTOS Cambio concepto de R a LABELING (ETIQUETADO)</p><p>2024-02-15 15:20:28 ESANTOS Nuevo concepto R</p><p>2024-02-15 15:20:28 ESANTOS Cambio concepto de R a LABELING (ETIQUETADO)</p><p>2024-02-19 15:52:31 ESANTOS Nuevo concepto R</p><p>2024-02-19 15:52:31 ESANTOS Cambio concepto de R a LABELING (ETIQUETADO)</p><p>2024-02-23 18:19:34 ESANTOS Nuevo concepto R</p><p>2024-02-23 18:19:34 ESANTOS Cambio concepto de R a LABELING (ETIQUETADO)</p><p>2024-02-23 18:19:34 ESANTOS Nuevo concepto PTF W/M</p><p>2024-02-23 18:19:34 ESANTOS Nuevo concepto NON STACKABLE CHARGE W/M</p><p>2024-02-23 18:19:34 ESANTOS Nuevo concepto CONSOL FEE W/M</p><p>2024-02-23 18:19:34 ESANTOS Nuevo concepto OCEAN FREIGHT W/M</p><p>2024-02-23 18:19:34 ESANTOS Cambio concepto de PTF (LUMPSUM) a PTF W/M</p><p>2024-02-23 18:19:34 ESANTOS Cambio concepto de NON STACKABLE CHARGE MIN a NON STACKABLE CHARGE W/M</p><p>2024-02-23 18:19:34 ESANTOS Cambio concepto de CONSOL FEE MIN a CONSOL FEE W/M</p><p>2024-02-23 18:19:34 ESANTOS Cambio concepto de OCEAN FREIGHT (MIN) a OCEAN FREIGHT W/M</p><p>2024-02-23 18:23:46 ESANTOS Nuevo concepto R</p><p>2024-02-23 18:23:46 ESANTOS Cambio concepto de R a LABELING (ETIQUETADO)</p><p>2024-02-28 10:41:21 TSANCHEZ Nuevo concepto R</p><p>2024-02-28 10:41:21 TSANCHEZ Cambio concepto de R a LABELING (ETIQUETADO)</p><p>2024-02-28 10:41:21 TSANCHEZ Cambio importe de INLAND SERVICE COORDINATION LUMPSUM de 240 a 414.90</p>','DE CONTADO','2024-02-22 21:35:02','','','','','','','','','','','2024-03-31',NULL,NULL,NULL,NULL,NULL,'2024-02-08 12:28:00',NULL);
/*!40000 ALTER TABLE `bookingexpint_onhold` 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:26
