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

DROP TABLE IF EXISTS `datosimpoint_ael_hbls`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `datosimpoint_ael_hbls` (
  `idhbl` double NOT NULL AUTO_INCREMENT,
  `iddatosimpoint` int(11) DEFAULT NULL,
  `referencia_cliente` varchar(255) DEFAULT NULL,
  `referencia_puerto` varchar(255) DEFAULT NULL,
  `bl_house` varchar(255) DEFAULT NULL,
  `consignatario` text,
  `transport_company` varchar(255) DEFAULT NULL,
  `transport_contact` varchar(255) DEFAULT NULL,
  `transport_telephone` varchar(255) DEFAULT NULL,
  `transport_email` varchar(255) DEFAULT NULL,
  `pickupdate` date DEFAULT NULL,
  `pickup_place` varchar(255) DEFAULT NULL,
  `pickup_address` varchar(255) DEFAULT NULL,
  `pickup_city` varchar(255) DEFAULT NULL,
  `pickup_state` varchar(255) DEFAULT NULL,
  `pickup_zip` varchar(255) DEFAULT NULL,
  `pickup_contact` varchar(255) DEFAULT NULL,
  `pickup_telephone` varchar(255) DEFAULT NULL,
  `pickup_instructions` text,
  `delivery_date` date DEFAULT NULL,
  `delivery_place` varchar(255) DEFAULT NULL,
  `delivery_address` varchar(255) DEFAULT NULL,
  `delivery_city` varchar(255) DEFAULT NULL,
  `delivery_state` varchar(255) DEFAULT NULL,
  `delivery_zip` varchar(255) DEFAULT NULL,
  `delivery_contact` varchar(255) DEFAULT NULL,
  `delivery_telephone` varchar(255) DEFAULT NULL,
  `delivery_instructions` text,
  `fecha_entrada_almacen` datetime DEFAULT NULL,
  PRIMARY KEY (`idhbl`)
) ENGINE=InnoDB AUTO_INCREMENT=356540 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `datosimpoint_ael_hbls`
--

LOCK TABLES `datosimpoint_ael_hbls` WRITE;
/*!40000 ALTER TABLE `datosimpoint_ael_hbls` DISABLE KEYS */;
INSERT INTO `datosimpoint_ael_hbls` VALUES (356525,356526,'BUEVERSSL 041.19','ALPM-0001.19','BUE42648','PANALPINA TRANSPORTES MUNDIALES SA DE CV',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','','0000-00-00','','','','','','',NULL,NULL,NULL),(356526,356526,'BUEVERSSL 041.19','ALPM-0001.19','BUE42638','DACOMSA SA DE CV','XCF','','','','2019-09-09','1','2','3','4','5','6','7','8','2019-09-16','9','10','11','12','13','14','15','16',NULL),(356528,356526,'BUEVERSSL 041.19','ALPM-0001.19','BUE42655','OBJECTIVE CARGO SA DE CV',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','','0000-00-00','','','','','','',NULL,NULL,NULL),(356529,356526,'BUEVERSSL 041.19','ALPM-0001.19','BUE42644','DACHSER DE MEXICO SA DE CV',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','','0000-00-00','','','','','','',NULL,NULL,NULL),(356530,356526,'BUEVERSSL 041.19','ALPM-0001.19','BUE42646','FAST FORWARD CONSOLIDATORS SA DE CV','LZ INC','','','','2019-09-02','A','B','D','D','E','F','G','H','2019-09-23','I','J','K','L','M','N','O','P',NULL),(356531,356526,'BUEVERSSL 041.19','ALPM-0001.19','BUE42662','DRAGON CARGO SA DE CV',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-09-10 10:06:28'),(356533,356527,'ABCROUTE','ALPM-0002.19','ABCHBL1','LORENA ZAPATA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-09-10 10:34:49'),(356534,356527,'ABCROUTE','ALPM-0002.19','ABCHBL2','XOCHITL ZAYAS','ABC TRANSPORTE','','','','2019-09-10','','','','','','','','','2019-09-17','','','','','','','','','2019-09-10 10:41:38'),(356535,356530,'BUEVERSSL 040.19','ALPM-0005.19','BUE42643','PANALPINA TRANSPORTES MUNDIALES S.A. DE C.V.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-09-17 13:33:54'),(356536,356530,'BUEVERSSL 040.19','ALPM-0005.19','BUE42627','DHL GLOBAL FORWARDING MEXICO S.A. DE C.V.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-09-17 13:33:54'),(356537,356530,'BUEVERSSL 040.19','ALPM-0005.19','BUE42601','PLUSCARGO TRANSPORTE MEXICANA S.A. DE C.V.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-09-17 13:33:54'),(356538,356530,'BUEVERSSL 040.19','ALPM-0005.19','BUE42574','FAST FORWARD CONSOLIDATORS S.A. DE C.V.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-09-17 13:33:54'),(356539,356529,'MAN15700078','ALPM-0004.19','HBL1','LORENA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-09-17 13:48:00');
/*!40000 ALTER TABLE `datosimpoint_ael_hbls` 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:40:27
