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

DROP TABLE IF EXISTS `bookingexpint_egresos_por_hbl`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `bookingexpint_egresos_por_hbl` (
  `idegresos_por_hbl` int(11) NOT NULL AUTO_INCREMENT,
  `files_expo_egreso` varchar(255) DEFAULT NULL,
  `referencia_interteam_expo_egreso` varchar(100) DEFAULT NULL,
  `idbooking_expo_egreso` varchar(45) DEFAULT NULL,
  `hbl_interteam_expo_egreso` varchar(255) DEFAULT NULL,
  `booking_interteam_expo_egreso` varchar(45) DEFAULT NULL,
  `concepto_expo_egreso` varchar(255) DEFAULT NULL,
  `importe_expo_egreso` varchar(255) DEFAULT NULL,
  `moneda_expo_egreso` varchar(255) DEFAULT NULL,
  `tipo_de_cambio_expo_egreso` varchar(255) DEFAULT NULL,
  `observaciones_expo_egreso` varchar(20) DEFAULT NULL,
  UNIQUE KEY `idegresos_por_hbl_UNIQUE` (`idegresos_por_hbl`),
  KEY `referencia_egreso` (`files_expo_egreso`),
  KEY `referencia_egreso_2` (`files_expo_egreso`),
  KEY `hbl_egreso` (`hbl_interteam_expo_egreso`),
  KEY `concepto_egreso` (`concepto_expo_egreso`),
  KEY `moneda_egreso` (`moneda_expo_egreso`),
  KEY `referencia_egreso_3` (`files_expo_egreso`,`concepto_expo_egreso`),
  KEY `i_ref_con_egresos` (`files_expo_egreso`,`concepto_expo_egreso`),
  KEY `idegresos_interteam_2` (`files_expo_egreso`)
) ENGINE=InnoDB AUTO_INCREMENT=141 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bookingexpint_egresos_por_hbl`
--

LOCK TABLES `bookingexpint_egresos_por_hbl` WRITE;
/*!40000 ALTER TABLE `bookingexpint_egresos_por_hbl` DISABLE KEYS */;
INSERT INTO `bookingexpint_egresos_por_hbl` VALUES (10,'ATMSSZ09988B22','ALT03522-SSZBC','117657','INTERATMSSZ117657','EXITATMSSZ117657','CORRECCION EXTEMPORANEA','5281','USD','',''),(11,'ATMSSZ09988B22','ALT03522-SSZBC','117657','INTERATMSSZ117657','EXITATMSSZ117657','CORRECCION EXTEMPORANEA','77.73','USD','',''),(12,'ATMSSZ09988B22','ALT03522-SSZBC','117657','INTERATMSSZ117657','EXITATMSSZ117657','CORRECCION EXTEMPORANEA','150','USD','',''),(13,'ZLOGYE9838M22','ZLO1622-GYE','117109','INTERZLOGYE117109','EXITZLOGYE117109','DEMORAS','1220','USD','',''),(14,'ZLOGYE9838M22','ZLO1622-GYE','117109','INTERZLOGYE117109','EXITZLOGYE117109','ROLL OVER','8210.28','MXP','',''),(19,'VERANR10137M22','VER2022-ANR','118769','INTERVERANR118769','EXITVERANR118769','CORRECCION EXTEMPORANEA','150','USD','',''),(20,'ZLOPUS10280M22','FCLE22065','119117','INTERZLONSA119117','EXITZLONSA119117','ALMACENAJES','59080','MXP','',''),(23,'ZLOPUS10338M22','ZLO5522-PUS','119273','INTERZLOMAA119273','EXITZLOMAA119273','DEMORAS','2380.98','MXP','',''),(24,'ATMANR10269M22','ATM2822-ANR','118522','INTERATMDUR118522','EXITATMDUR118522','DEMORAS','175.00','USD','',''),(25,'ZLOBUN10374M22','ZLO2722-BUN','119492','INTERZLOBUN119492','EXITZLOBUN119492','CORRECCION EXTEMPORANEA','300','USD','',''),(26,'VERSSZ10420B22','VER06822-SSZBC','119665','INTERVERSSZ119665','EXITVERSSZ119665','CORRECCION EXTEMPORANEA','150','USD','',''),(27,'ZLOSAI10279M22','ZLO2222-SAI','118996','INTERZLOVAP118996','EXITZLOVAP118996','CORRECCION EXTEMPORANEA','100','USD','',''),(28,'ATMPNG10237M22','ATM0922-PNG','118318','INTERATMPNG118318','EXITATMPNG118318','CORRECCION EXTEMPORANEA','145.00','USD','',''),(29,'VERPNG10403M22','VER1322-PNG','119841','INTERVERPNG119841','EXITVERPNG119841','CORRECCION EXTEMPORANEA','145.00','USD','',''),(30,'VERSSZ10467M22','VER2522-SSZ','120014','INTERVERSSZ120014','EXITVERSSZ120014','ROLL OVER','40','USD','',''),(31,'VERSSZ10467M22','VER2522-SSZ','','INTERVERSSZ120014','EXITVERSSZ120014','ROLL OVER','40','USD','',''),(32,'VERBCN10412M22','VER2822-BCN','119682','INTERVERDUR119682','EXITVERDUR119682','CORRECCION EXTEMPORANEA','100','USD','',''),(33,'ATMANR10099M22','ATM2222-ANR','118577','INTERATMDUR118577','EXITATMDUR118577','CORRECCION EXTEMPORANEA','80','USD','',''),(34,'ZLOCLL10623M22','ZLO2822-CLL','119753','INTERZLOCLL119753','EXITZLOCLL119753','CORRECCION EXTEMPORANEA','1430','MXP','',''),(35,'ATMPNG10237M22','ATM0922-PNG','118917','INTERATMPNG118917','EXITATMPNG118917','CORRECCION EXTEMPORANEA','783','USD','',''),(36,'ZLOSAI10279M22','ZLO2222-SAI','119202','INTERZLOSAI119202','EXITZLOSAI119202','DEMORAS','138.89','USD','',''),(37,'ATMANR10667M22','ATM4022-ANR','119612','INTERATMRTM119612','EXITATMRTM119612','CORRECCION EXTEMPORANEA','160.83','USD','',''),(38,'VERPNG10532B22','VER02522-PNGBC','120645','INTERVERPNG120645','EXITVERPNG120645','CORRECCION EXTEMPORANEA','150','USD','',''),(39,'VERCTG10712M22','VER3322-CTG','119810','INTERVERCTG119810','EXITVERCTG119810','ALMACENAJES','27702','MXP','',''),(40,'VERHAI10648M22','VER5922-HAI','120615','INTERVERHAI120615','EXITVERHAI120615','CORRECCION EXTEMPORANEA','100','USD','',''),(41,'ATMHAM10710M22','ATM6722-HAM','121190','INTERATMBUD121190','EXITATMBUD121190','ALMACENAJES','2320','MXP','',''),(42,'ATMANR10585M22','ATM3722-ANR','120021','INTERATMBUE120021','EXITATMBUE120021','CORRECCION EXTEMPORANEA','162','USD','',''),(43,'VERMIL10715M22','VER2622-MIL','121076','INTERVERLIN121076','EXITVERLIN121076','CORRECCION EXTEMPORANEA','150','USD','',''),(44,'VERCTG10712M22','VER3322-CTG','121274','INTERVERCTG121274','EXITVERCTG121274','ALMACENAJES','907.2','MXP','',''),(46,'ATMSSZ10482B22','ALT07422-SSZBC','121336','INTERATMSSZ121336','EXITATMSSZ121336','CORRECCION EXTEMPORANEA','150','USD','',''),(48,'ATMHAM10745M22','ATM7322-HAM','120954','INTERATMHAM120954','EXITATMHAM120954','ALMACENAJES','10129.12','MXP','',''),(49,'VERSSZ10943B22','VER012922-SSZBC','121993','INTERVERSSZ121993','EXITVERSSZ121993','CORRECCION EXTEMPORANEA','150','USD','',''),(50,'VERSSZ10728B22','VER09822-SSZBC','121498','INTERVERSSZ121498','EXITVERSSZ121498','CORRECCION EXTEMPORANEA','150','USD','',''),(51,'VERHAM10888M22','VER6322-HAM','121632','INTERVERHAM121632','EXITVERHAM121632','ALMACENAJES','18252.6','MXP','',''),(52,'ATMSSZ11023M22','ATM3422-SSZ','122011','INTERATMITJ122011','EXITATMITJ122011','ALMACENAJES','1260','MXP','',''),(53,'VERONX11037M22','VER3322-ONX','122427','INTERVERPTY122427','EXITVERPTY122427','CORRECCION EXTEMPORANEA','100','USD','',''),(54,'ZLOCLL10895M22','ZLO3322-CLL','120356','INTERZLOCLL120356','EXITZLOCLL120356','ALMACENAJES','32258.25','MXP','',''),(55,'VERHAI11275M22','VER8422-HAI','123360','INTERVERHAI123360','EXITVERHAI123360','DGD FEE','1430','MXP','',''),(60,'ZLOBUN11213M22','ZLO4222-BUN','123061','INTERZLOBUN123061','EXITZLOBUN123061','CORRECCION EXTEMPORANEA','150','USD','',''),(61,'ZLOGYE11156M22','ZLO5822-GYE','123004','INTERZLOGYE123004','EXITZLOGYE123004','CORRECCION EXTEMPORANEA','116','USD','',''),(62,'ZLOBUN11213M22','ZLO4222-BUN','122739','INTERZLOBUN122739','EXITZLOBUN122739','CORRECCION EXTEMPORANEA','150','USD','',''),(63,'ZLOSHA11254M22','ZLO8422-SHA','123187','INTERZLOSHA123187','EXITZLOSHA123187','ALMACENAJES','3968.00','MXP','',''),(64,'ZLOPUS11340M22','ZLO9322-PUS','123177','INTERZLONGB123177','EXITZLONGB123177','ALMACENAJES','4960.00','MXP','',''),(65,'VERSSZ11361B22','VER017622-SSZBC','123628','INTERVERSSZ123628','EXITVERSSZ123628','CORRECCION EXTEMPORANEA','150','USD','',''),(66,'VERSJO11591M22','VER0123-SJO','124243','INTERVERSJO124243','EXITVERSJO124243','DGD FEE','1430','MXP','',''),(67,'ZLOCLL11034M22','ZLO3722-CLL','122632','INTERZLOCLL122632','EXITZLOCLL122632','SOBREFLETE','150.88','USD','',''),(68,'ZLOBUN10986M22','ZLO3622-BUN','121914','INTERZLOBUN121914','EXITZLOBUN121914','ALMACENAJES','1160.32','USD','',''),(69,'VERCTG11019M22','VER4122-CTG','122222','INTERVERCTG122222','EXITVERCTG122222','ALMACENAJES','425.96','USD','',''),(72,'ZLOSAI11346M22','ZLO4522-SAI','123683','INTERZLOSVE123683','EXITZLOSVE123683','TRANSHIPMENT','400','USD','',''),(75,'VERHAM11278M22','VER8222-HAM','123241','INTERVERHAM123241','EXITVERHAM123241','SOBREFLETE','100.00','USD','',''),(76,'VERHAM11278M22','VER8222-HAM','123241','INTERVERHAM123241','EXITVERHAM123241','TRANSHIPMENT','100.00','USD','',''),(77,'ZLOSHA11254M22','ZLO8422-SHA','123187','INTERZLOSHA123187','EXITZLOSHA123187','ALMACENAJES','3968.00','MXP','',''),(79,'VERBUE10857M22','VER2822-BUE','121867','INTERVERBUE121867','EXITVERBUE121867','CORRECCION EXTEMPORANEA','550','USD','',''),(80,'ZLOPUS11163M22','ZLO8822-PUS','122543','INTERZLONGB122543','EXITZLONGB122543','ALMACENAJES','7936.00','MXP','',''),(81,'ZLOSHA11254M22','ZLO8422-SHA','123154','INTERZLOSHA123154','EXITZLOSHA123154','ALMACENAJES','6944.00','MXP','',''),(82,'ZLOSHA11403M22','ZLO8722-SHA','123587','INTERZLOSHA123587','EXITZLOSHA123587','ALMACENAJES','6944.00','MXP','',''),(84,'ZLOSHA11462M22','ZLO8922-SHA','123979','INTERZLOSHA123979','EXITZLOSHA123979','ALMACENAJES','17325','MXP','',''),(85,'VERONX10603M22','VER2622-ONX','120552','INTERVERBGI120552','EXITVERBGI120552','SOBREFLETE','200','USD','',''),(86,'VERONX10603M22','VER2622-ONX','120552','INTERVERBGI120552','EXITVERBGI120552','TRANSHIPMENT','1170.38','USD','',''),(87,'ZLOSHA11403M22','ZLO8722-SHA','123894','INTERZLOSHA123894','EXITZLOSHA123894','ALMACENAJES','992.00','MXP','',''),(88,'ZLOPUS11382M22','ZLO9522-PUS','124187','INTERZLODLC124187','EXITZLODLC124187','TRANSHIPMENT','31.28','USD','',''),(89,'ZLOPUS11382M22','ZLO9522-PUS','124153','INTERZLOKHI124153','EXITZLOKHI124153','TRANSHIPMENT','110.57','USD','',''),(90,'ZLOPUS11382M22','ZLO9522-PUS','123784','INTERZLOLCH123784','EXITZLOLCH123784','TRANSHIPMENT','84.55','USD','',''),(91,'ZLOPUS11382M22','ZLO9522-PUS','123994','INTERZLOLCH123994','EXITZLOLCH123994','TRANSHIPMENT','85.17','USD','',''),(92,'ZLOPUS11382M22','ZLO9522-PUS','124109','INTERZLOLCH124109','EXITZLOLCH124109','TRANSHIPMENT','178.93','USD','',''),(93,'ZLOPUS11382M22','ZLO9522-PUS','123944','INTERZLONGO123944','EXITZLONGO123944','TRANSHIPMENT','48.91','USD','',''),(94,'ZLOPUS11382M22','ZLO9522-PUS','124099','INTERZLONGO124099','EXITZLONGO124099','TRANSHIPMENT','48.62','USD','',''),(95,'ZLOPUS11382M22','ZLO9522-PUS','124212','INTERZLONGO124212','EXITZLONGO124212','TRANSHIPMENT','48.12','USD','',''),(96,'ZLOPUS11382M22','ZLO9522-PUS','123049','INTERZLONSA123049','EXITZLONSA123049','TRANSHIPMENT','487.49','USD','',''),(97,'ZLOPUS11382M22','ZLO9522-PUS','123517','INTERZLONSA123517','EXITZLONSA123517','TRANSHIPMENT','115','USD','',''),(98,'ZLOPUS11382M22','ZLO9522-PUS','123518','INTERZLONSA123518','EXITZLONSA123518','TRANSHIPMENT','115','USD','',''),(99,'ZLOPUS11382M22','ZLO9522-PUS','123709','INTERZLONSA123709','EXITZLONSA123709','TRANSHIPMENT','115','USD','',''),(100,'ZLOPUS11382M22','ZLO9522-PUS','123722','INTERZLONSA123722','EXITZLONSA123722','TRANSHIPMENT','115','USD','',''),(101,'ZLOPUS11382M22','ZLO9522-PUS','123833','INTERZLONSA123833','EXITZLONSA123833','TRANSHIPMENT','116.38','USD','',''),(102,'ZLOPUS11382M22','ZLO9522-PUS','123875','INTERZLONSA123875','EXITZLONSA123875','TRANSHIPMENT','221.03','USD','',''),(103,'ZLOPUS11382M22','ZLO9522-PUS','124037','INTERZLONSA124037','EXITZLONSA124037','TRANSHIPMENT','488.18','USD','',''),(104,'ZLOPUS11382M22','ZLO9522-PUS','124146','INTERZLOSZX124146','EXITZLOSZX124146','TRANSHIPMENT','377.06','USD','',''),(105,'ZLOPUS11382M22','ZLO9522-PUS','123940','INTERZLOTSN123940','EXITZLOTSN123940','TRANSHIPMENT','61.7','USD','',''),(106,'ZLOPUS11382M22','ZLO9522-PUS','123989','INTERZLOTSN123989','EXITZLOTSN123989','TRANSHIPMENT','89.33','USD','',''),(107,'ZLOPUS11382M22','ZLO9522-PUS','124063','INTERZLOTSN124063','EXITZLOTSN124063','TRANSHIPMENT','43.95','USD','',''),(108,'VERPNG11594M22','VER0223-PNG','123704','INTERVERPNG123704','EXITVERPNG123704','ALMACENAJES','1270.76','MXP','',''),(109,'VERBCN11537M22','VER0123-BCN','124461','INTERVERBCN124461','EXITVERBCN124461','ALMACENAJES','755.28','MXP','',''),(110,'VERBCN11211M22','VER4622-BCN','123052','INTERVERIST123052','EXITVERIST123052','TRANSHIPMENT','152.83','USD','',''),(111,'VERANR11570M22','VER0223-ANR','124426','INTERVERDUB124426','EXITVERDUB124426','ALMACENAJES','251.76','MXP','',''),(112,'ZLOBUN11688M23','ZLO0323-BUN','124796','INTERZLOBUN124796','EXITZLOBUN124796','CORRECCION EXTEMPORANEA','116','USD','',''),(113,'ZLOGYE11719M23','ZLO0823-GYE','124904','INTERZLOGYE124904','EXITZLOGYE124904','ALMACENAJES','440.8','MXP','',''),(114,'ZLOMIT11179M22','FCLE22114','122915','INTERZLOROD122915','EXITZLOROD122915','ALMACENAJES','210947.20','MXP','',''),(115,'ZLOSAI11582M22','ZLO0123-SAI','123749','INTERZLOSAI123749','EXITZLOSAI123749','ALMACENAJES','35046','MXP','',''),(116,'ZLOSHA11905M23','ZLO1123-SHA','125708','INTERZLOSHA125708','EXITZLOSHA125708','ROLL OVER','393','MXP','',''),(117,'ZLOSHA11905M23','ZLO1123-SHA','125386','INTERZLOSHA125386','EXITZLOSHA125386','ROLL OVER','393','MXP','',''),(118,'ZLOCLL11960M23','ZLO1023-CLL','125675','INTERZLOCLL125675','EXITZLOCLL125675','ALMACENAJES','2970','MXP','',''),(119,'VERANR11107M22','VER4322-ANR','123013','INTERVERLEH123013','EXITVERLEH123013','ALMACENAJES','3867.53','USD','',''),(120,'ATMANR11845M23','ATM0923-ANR','124404','INTERATMBCN124404','EXITATMBCN124404','DEMORAS','548.68','USD','',''),(121,'VERBCN11317M22','VER4922-BCN','123592','INTERVERBCN123592','EXITVERBCN123592','CORRECCION EXTEMPORANEA','145','USD','',''),(122,'ZLOGYE12454M23','ZLO2523-GYE','127748','INTERZLOGYE127748','EXITZLOGYE127748','CORRECCION EXTEMPORANEA','2105.40','MXP','',''),(123,'VERONX12377M23','VER1723-ONX','126978','INTERVERONX126978','EXITVERONX126978','ALMACENAJES','2838.10','MXP','',''),(124,'ZLOCLL12586M23','ZLO2423-CLL','127847','INTERZLOCLL127847','EXITZLOCLL127847','ALMACENAJES','13884.75','MXP','',''),(125,'VERSJO12550M23','VER2423-SJO','128212','INTERVERSJO128212','EXITVERSJO128212','CORRECCION EXTEMPORANEA','364','MXP','',''),(126,'ZLOSIN12776M23','ZLO2923-SIN','128959','INTERZLOAKL128959','EXITZLOAKL128959','CORRECCION EXTEMPORANEA','1674.25','MXP','',''),(127,'VERBCN12948M23','VER3023-BCN','129324','INTERVERBCN129324','EXITVERBCN129324','DGD FEE','1573.00','MXP','',''),(128,'VERANR13472M23','VER4323-ANR','854042','INTERVERDUB854042','EXITVERDUB854042','TRANSHIPMENT','2095.82','USD','',''),(129,'ZLOSIN13619M23','ZLO4923-SIN','854383','INTERZLOPKG854383','EXITZLOPKG854383','CORRECCION EXTEMPORANEA','341','USD','',''),(130,'ZLOCLL13279M23','ZLO4023-CLL','853266','INTERZLOCLL853266','EXITZLOCLL853266','DEMORAS','375','USD','',''),(131,'ZLOHKG13880M23','ZLO0124-HKG','854985','INTERZLOHKG854985','EXITZLOHKG854985','ALMACENAJES','7504','MXP','',''),(132,'VERHAM14013M24','VER0524-HAM','855446','INTERVERHAM855446','EXITVERHAM855446','CORRECCION EXTEMPORANEA','1575.67','USD','',''),(133,'ATMBUE14873M24','FCLE24043','858572','INTERATMBUE858572','EXITATMBUE858572','DGD FEE','3217.25','MXP','',''),(134,'VERHAI14474M24','VER1424-HAI','857365','INTERVERHAI857365','EXITVERHAI857365','ALMACENAJES','3118.80','MXP','',''),(135,'VERBCN14250M24','VER0824-BCN','856656','INTERVERBCN856656','EXITVERBCN856656','ALMACENAJES','42625.20','MXP','',''),(136,'VERBCN14250M24','VER0824-BCN','856656','INTERVERBCN856656','EXITVERBCN856656','ALMACENAJES','3165','USD','',''),(137,'ZLOSHG14529M24','ZLO1824-SHG','857394','INTERZLOSHG857394','EXITZLOSHG857394','ALMACENAJES','2250','MXP','',''),(138,'ZLOGYE15080M24','ZLO2824-GYE','859371','INTERZLOGYE859371','EXITZLOGYE859371','SOBREFLETE','6714.81','MXP','',''),(139,'ONHOLD','ONHOLD','860049','INTERZLOSIN860049','EXITZLOSIN860049','DEMORAS','1035','USD','',''),(140,'VERCFZ16613M24','VER0325-CFZ','864148','INTERVERPTY864148','EXITVERPTY864148','ALMACENAJES','1061.61','MXP','','');
/*!40000 ALTER TABLE `bookingexpint_egresos_por_hbl` 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:48
