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

DROP TABLE IF EXISTS `cargasimpointtmp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cargasimpointtmp` (
  `idcargasimpoint` double NOT NULL AUTO_INCREMENT,
  `referencia_cargas` varchar(255) DEFAULT NULL,
  `blmaster_cargas` varchar(255) DEFAULT NULL,
  `hbl_cargas` varchar(255) DEFAULT NULL,
  `mercancia_cargas` varchar(255) DEFAULT NULL,
  `no_de_paquetes_cargas` varchar(255) DEFAULT NULL,
  `tipo_de_paquete_cargas` varchar(255) DEFAULT NULL,
  `marcas_cargas` text,
  `imo_cargas` varchar(255) DEFAULT NULL,
  `peso_cargas` varchar(255) DEFAULT NULL,
  `volumen_cargas` varchar(255) DEFAULT NULL,
  `no_de_paquetes_cargas_puerto` varchar(50) DEFAULT NULL,
  `tipo_de_paquete_cargas_puerto` varchar(250) DEFAULT NULL,
  `marcas_cargas_puerto` text,
  `imo_cargas_puerto` varchar(50) DEFAULT NULL,
  `peso_cargas_puerto` varchar(50) DEFAULT NULL,
  `volumen_cargas_puerto` varchar(50) DEFAULT NULL,
  `averia` text,
  `peso_cargable` varchar(200) DEFAULT NULL,
  `tipodedano3` varchar(200) DEFAULT NULL,
  `tarjasdeaveria` text,
  `fotosaveria` varchar(250) DEFAULT NULL,
  `tarjas_de_desconsolidacion_m` varchar(200) DEFAULT NULL,
  `fecha_de_revalidacion_puerto_m` varchar(200) DEFAULT NULL,
  `importador_de_la_mercancia_m` varchar(200) DEFAULT NULL,
  `agente_aduanal_que_libera_puerto_m` varchar(250) DEFAULT NULL,
  `quien_firmo_recibido_puerto_m` varchar(250) DEFAULT NULL,
  `hora_de_revalidacion_puerto_m` varchar(250) DEFAULT NULL,
  `observaciones_puerto_m` text,
  `bultosaveria` varchar(200) DEFAULT NULL,
  `tarjas_de_desconsolidacion_cargas` varchar(250) DEFAULT NULL,
  `fecha_de_revalidacion_cargas` varchar(250) DEFAULT NULL,
  `importador_de_la_mercancia_cargas` varchar(250) DEFAULT NULL,
  `agente_aduanal_que_libera_cargas` varchar(250) DEFAULT NULL,
  `quien_firmo_de_recibido_cargas` varchar(250) DEFAULT NULL,
  `hora_de_revalidacion_cargas` varchar(250) DEFAULT NULL,
  `observaciones_cargas` text,
  `posicion_almacen` text,
  `comentarios_de_empaque` varchar(200) DEFAULT NULL,
  `usuario_revalido` varchar(150) DEFAULT NULL,
  `cntr` varchar(200) DEFAULT NULL,
  `contenido` varchar(250) DEFAULT NULL,
  `bultos_danados_2` varchar(15) DEFAULT NULL,
  `bultos_danados_3` varchar(15) DEFAULT NULL,
  `jaulas` varchar(250) DEFAULT NULL,
  `liberar` tinyint(4) DEFAULT NULL,
  `agente_aduanal_cargas` varchar(255) DEFAULT NULL,
  `patente_aduanal_cargas` varchar(10) DEFAULT NULL,
  `bultos_averiados_puerto` varchar(10) DEFAULT NULL,
  `tipo_de_averia_puerto` text,
  `fotos_averia_puerto` text,
  `idrevalidacioncarga` int(11) DEFAULT '0',
  `updated_on` varchar(100) DEFAULT NULL,
  `consecutivo_golmex` varchar(100) DEFAULT NULL,
  `status_golmex` varchar(255) DEFAULT NULL,
  `actualizacion_remota` tinyint(1) DEFAULT NULL,
  `idagente_aduanal` int(11) DEFAULT NULL,
  `status_golmex_hbl` varchar(25) DEFAULT NULL,
  `usuario_autorizo` varchar(255) DEFAULT NULL,
  `fecha_autorizacion` datetime DEFAULT NULL,
  `autorizacion` int(1) DEFAULT NULL,
  `un_cargas` varchar(25) DEFAULT NULL,
  `url_tarja_individual` text,
  `url_tarja_averia` text,
  `actualizacion_en_tiempo_real_golmex` varchar(1) DEFAULT NULL,
  `FechaEntradaCfs` varchar(100) DEFAULT NULL,
  `HoraEntradaCfs` varchar(100) DEFAULT NULL,
  `facilidad_administrativa` varchar(2) DEFAULT NULL,
  `url_revalidacion` text,
  `fecha_asignacion_agente_aduanal` datetime DEFAULT NULL,
  `existencia` varchar(100) DEFAULT NULL,
  `notificacion_carga_en_almacen` varchar(10) DEFAULT NULL,
  `notificacion_abandono_tacito` varchar(10) DEFAULT NULL,
  `recepcion_oficio_abandono` varchar(10) DEFAULT NULL,
  `envio_notificacion_abandono` varchar(10) DEFAULT NULL,
  `respuesta_ws_golmex` varchar(300) DEFAULT NULL,
  PRIMARY KEY (`idcargasimpoint`),
  KEY `idxcargasimpoint` (`idcargasimpoint`),
  KEY `idxreferencia_cargas` (`referencia_cargas`),
  KEY `referencia_cargas` (`referencia_cargas`),
  KEY `hbl_cargas` (`hbl_cargas`),
  KEY `updated_on` (`updated_on`),
  KEY `idcargasimpoint` (`idcargasimpoint`),
  KEY `hbl_cargas_2` (`hbl_cargas`),
  KEY `agente_aduanal_cargas` (`agente_aduanal_cargas`),
  KEY `patente_aduanal_cargas` (`patente_aduanal_cargas`),
  KEY `idrevalidacioncarga` (`idrevalidacioncarga`),
  KEY `referencia_cargas_2` (`referencia_cargas`,`hbl_cargas`),
  KEY `updated_on_2` (`updated_on`),
  KEY `updated_on_3` (`updated_on`,`status_golmex`),
  KEY `idcargasimpoint_2` (`idcargasimpoint`,`referencia_cargas`,`hbl_cargas`),
  KEY `i_ref_hbl_cargas` (`referencia_cargas`,`hbl_cargas`),
  KEY `i_id_ref_hbl_cargasimpoint` (`idcargasimpoint`,`referencia_cargas`,`hbl_cargas`),
  KEY `i_id_ref_hbl_cargas` (`idcargasimpoint`,`referencia_cargas`,`hbl_cargas`),
  KEY `i_ref_hbl_cargas1` (`referencia_cargas`,`hbl_cargas`),
  KEY `i_ref_hbl_cargas2` (`referencia_cargas`,`hbl_cargas`)
) ENGINE=InnoDB AUTO_INCREMENT=610620 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cargasimpointtmp`
--

LOCK TABLES `cargasimpointtmp` WRITE;
/*!40000 ALTER TABLE `cargasimpointtmp` DISABLE KEYS */;
INSERT INTO `cargasimpointtmp` VALUES (373610,'HAMVERSSL 216.19','ONEYHAMV99457600','VER248428','TWO LIFTVANS WITH OLD AND USED HOUSEHOLD GOODS AND PERSONAL EFFECTS','2','PACKAGE','IRNICH','0','1000.000','10.006','2','PALLETS','CHRISTOPH IRNICH','','1000.00','','','','','','','','','','','','','','','','','','','','','',',0,0;','','','','','','','',0,'ENRIQUE IGNACIO REYES SUAREZ','1740','2','BR,CR,BR,','',182843,'2019-10-14 16:23:38','5','**out**',1,368,'','ARODRIGUEZ','2019-10-07 09:53:04',1,'','http://200.77.121.74:1087/MVC/Digitales/VerTarja?Parametro=0LaPw3AspufvuTQJG3FcQw%3d%3d','http://200.77.121.74:1087/MVC/Digitales/VerAveria?Parametro=0LaPw3AspufvuTQJG3FcQw%3d%3d','1','2019-10-05','16:30','NO','','0000-00-00 00:00:00','','','','','',''),(578510,'GOAVERCOM 126.23','HLCUGOA231063354','01/23/151260/A','CYLINDERS','1','ALL KIND OF BOXES','TUBOS DE ACERO DE MEXICO','0','2420.000','2.370','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'JESUS ENRIQUE GOMEZ REYES','3945','','','',0,'2023-11-17 15:17:58','','',1,19,'','VMONTIEL','2023-12-06 12:20:58',0,'','','','','2023-12-05','','','','2023-11-17 15:17:59','','','','','',''),(583123,'HAMVERSSL 413.23','','VER270665','VER270665','6','PALLETS','ZWISSTEX MEXICO','0','2330.00','7.817','6','PALLETS','ZWISSTEX MEXICO','','2330.00','','','','','','','','','','','','','','','','','','','','','',',0,0;','','','','','','','',0,'CARLOS ALBERTO RAMIREZ GONZALEZ','3452','6','CR,BP,','',0,'2024-01-05 12:44:14','17','**in CFS**',1,420,'','DMARTINEZ','2024-01-05 12:54:11',1,'','https://servicios.golmex.mx/MVC/Digitales/VerTarja?Parametro=A3YHlqWnCV3QhyfxmIvOtw%3d%3d','https://servicios.golmex.mx/MVC/Digitales/VerAveria?Parametro=A3YHlqWnCV3QhyfxmIvOtw%3d%3d','','2024-01-05','00:01','','','2023-12-28 13:39:51','','','','','',''),(584806,'SEALPM 0003.24','','OLC23120032MZL','AIR COOLED INDUSTRIAL','3','CAJA MADERA','ANGES ','0','786.00','4.386','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','',0,'','','',0,0,'','','0000-00-00 00:00:00',0,'0','','','','','','','','0000-00-00 00:00:00','','','','','',''),(585006,'LIFLPM 0002.24','','HHSE3114798','CHAIN MODULAR BELT PAD SPROCKET','3','OTROS','MODULEBELT','0','470.00','2.050','3','OTROS','MODULEBELT','','470','','','','','','','','','','','','','','','','','','','','','','A9-9','4','','','','','','',0,'MAURICIO FERNANDEZ DE ALBA Y LOPEZ','1774','1','DT','',429766,'2024-01-04 07:54:54','4','**in CFS**',0,855,'','JQUINONES','2024-01-05 09:03:54',1,'0','','','','2024-01-03','22:31','','','2024-01-04 10:28:55','','','','','',''),(585084,'PANLPV 0574.19','','ZQ23120048','VALVE','13','PAQUETES','VALVE WLBL 344 2023','0','13550.00','15.929','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','',0,'','','',0,0,'','','0000-00-00 00:00:00',0,'','','','','','','','','0000-00-00 00:00:00','','','','','',''),(585090,'NEWLPM 0006.24','','ZQ23120048','VALVE','13','PAQUETES','VALVE WLBL 344 2023','0','13550.00','15.929','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','',0,'','','',0,0,'','','0000-00-00 00:00:00',0,'','','','','','','','','0000-00-00 00:00:00','','','','','',''),(585596,'JASLPM 0004.24','','SZX37066010','57 101241 01 SPRT FRAME ASSY FOR JED ','3','TARIMAS','USI  IN DIA  PO 2000134169  INVOICE NO 231123 01 HS CODE 8473290000','0','1160.00','5.727','','','','','','','','','','','','','','','','','','','','','','','','','','','','2','','','','','','',0,'ROSALINDA CARVAJAL UDAVE','3953','','','',0,'','2','',0,1160,'','JWIPES','2024-01-05 11:03:21',1,'0','','','','','','','','2024-01-03 19:21:36','','','','','',''),(585635,'GOAVERCOM 003.24','HLCUGOA231161083','01/23/151260/A','CYLINDERS','1','CAJAS TODO TIPO','TUBOS DE ACERO MEXICO','0','2420.000','2.370','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'JESUS ENRIQUE GOMEZ REYES','3945','','','',0,'2024-01-05 12:08:35','','',1,19,'','','0000-00-00 00:00:00',0,'','','','','','','','','2024-01-05 12:08:36','','','','','',''),(585654,'NEWLPM 0022.24','','LLLMZL23B24618MZL','BIODEGRADABLE BAGS','15','CAJAS','KABIAX SA DE CV','0','139.00','0.389','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','',0,'','','',0,0,'','','0000-00-00 00:00:00',0,'0','','','','','','','','0000-00-00 00:00:00','','','','','',''),(585831,'SCHLPM 0007.24','','CNSZX0000516835','PLASTIC PLATING PART','3','PALLETS','PROJECT NO.P7-2 / PROJECT NO.CD6','0','457.00','5.540','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','',0,'','','',0,0,'','','0000-00-00 00:00:00',0,'0','','','','','','','','0000-00-00 00:00:00','','','','','',''),(585844,'SCHLPM 0008.24','','CNSZX0000516835','PLASTIC PLATING PART','4','ATADOS','PROJECT NO.P7-2 / PROJECT NO.CD6','0','457.00','5.540','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','',0,'','','',0,0,'','','0000-00-00 00:00:00',0,'0','','','','','','','','0000-00-00 00:00:00','','','','','',''),(585869,'HELLPM 0001.24','','SZXZLON09378','PRINTED CIRCUIT BOARD','9','TARIMAS','3675030 P040328825 3675029 P040328832  HS NO 85340090','0','3905.20','8.640','','','','','','','','','','','','','','','','','','','','','','','','','','','','3','','','','','','',0,'ANDRES ENRIQUE PALAZUELOS PEREZ ORONOZ','3098','','','',0,'','3','',0,567,'','','0000-00-00 00:00:00',0,'0','','','','','','','','2024-01-04 11:41:23','','','','','',''),(585872,'HELLPM 0001.24','','CANZLON05519','THERMOSTAT','8','TARIMAS','WHIRLPOOL SUPSA  0022000046 00080  0022000046 00090','0','2414.00','14.710','','','','','','','','','','','','','','','','','','','','','','','','','','','','1','','','','','','',0,'GABRIELA ALICIA SALAS CASIAN','1690','','','',0,'','1','',0,1197,'','','0000-00-00 00:00:00',0,'0','','','','','','','','2024-01-04 11:44:45','','','','','',''),(586143,'JASLPM 0011.24','','SHA37142483','POINTER/CHEVRON BASE/WINDOW TRIM/RO','5','PALLETS','MARELLI TOLUCA MEXICO','0','607.45','7.360','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','',0,'','','',0,0,'','','0000-00-00 00:00:00',0,'0','','','','','','','','2024-01-05 15:51:26','','','','','',''),(586167,'JASLPM 0012.24','','SHA37139327','LATCH ASSY 40 SUB','8','PALLETS','AVANZAR INTERIOR TECHNOLOGIES','0','1920.00','5.070','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','',0,'','','',0,0,'','','0000-00-00 00:00:00',0,'0','','','','','','','','2024-01-05 15:55:53','','','','','',''),(586232,'JASLPA 0002.24','','MIL37112627','TEMPORIZADORA','1','PALLET','VALVULAS URREA','0','181.00','1.008','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','',0,'','','',0,0,'','','0000-00-00 00:00:00',0,'','','','','','','','','0000-00-00 00:00:00','','','','','',''),(586430,'HELLPV 0002.24','','DUSVERN06813','AUTOMOTIVE PARTS','12','PAQUETES','MELECS ELECTRONICS QUERETARO S.A. DE C.V.','0','1053.00','10.013','12','PALLET','MELECS ELECTRONICS DUSVERN06813','0','1053','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'RAMON GOMEZ BARQUIN','3622','3','DT,CR,TR,BR,DY,','',431223,'2024-01-10 12:15:16','4','',1,50,'','VPAREDES','2024-01-11 11:34:53',1,'','','','','2024-01-10','11:40','','','2024-01-08 16:24:40','','','','','',''),(587081,'SEALPM 0011.24','','OLC23120289MZL','AIR-COOLED INDUSTRIAL CHILLER','1','CAJA MADERA','ANGES','0','799.50','5.354','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','',0,'','','',0,0,'','','0000-00-00 00:00:00',0,'0','','','','','','','','0000-00-00 00:00:00','','','','','',''),(587341,'LIFLPM 0012.24','','PSLNBOMAN02727B','VALVULA BOLA M PALANCA','2','TARIMA','COMERCIALIZADORA METROGAS SA DE CV','0','846.70','1.415','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','',0,'','','',0,0,'','','0000-00-00 00:00:00',0,'0','','','','','','','','0000-00-00 00:00:00','','','','','',''),(587762,'JASLPM 0024.24','','SHA37179378','FORD MACH E PRIMARY OPTIC','1','TARIMAS','HELLA AUTOMOTIVE MEXICO SA DE CV','0','84.00','1.200','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'VICENTE RIVERA RAMOS','1628','','','',0,'','','',0,111,'','','0000-00-00 00:00:00',0,'0','','','','','','','','2024-01-19 15:48:24','','','','','',''),(587879,'JASLPM 0023.24','','SHA37166864','BALL STUD','10','PALLETS','PART NO./QTY GJ-M-2371','0','8460.00','7.900','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'ALEJANDRO GONZALEZ GARZA','1634','','','',0,'','','',0,204,'','','0000-00-00 00:00:00',0,'0','','','','','','','','2024-01-19 21:26:14','','','','','',''),(588467,'CHRLPV 0005.24','','456102744DEL','PARTS & ACCESSORIES OF MOTOR VEHICLE','11','PAQUETES','METALSA S.A.P.I DE CV','0','6535.93','1.000','11','PALLETS','METALSA','','6535.93','','','','','','','','','','','','','','','','','','','','','',',0,0;','','','','','','','',0,'ALEJANDRO GONZALEZ GARZA','1634','4','CR,DY,','',433320,'2024-01-24 09:39:29','4','**in CFS**',0,184,'','VPAREDES','2024-01-24 12:40:10',1,'','https://servicios.golmex.mx/MVC/Digitales/VerTarja?Parametro=NJyB1GS3nNAfciw18KOp6Q%3d%3d','https://servicios.golmex.mx/MVC/Digitales/VerAveria?Parametro=NJyB1GS3nNAfciw18KOp6Q%3d%3d','','2024-01-24','06:30','','https://intralogs.com.mx/INT/importaciones/prin/formatoderevalidacionint.php?x=qqGmpZqk&y=qZ6oo5ej','2024-01-23 13:28:10','','','','','',' OK|3289bb4a04ea457fae52ca46dc5e6af4'),(589024,'SCHLPL 0004.24','','HKHKG0000506941','TRANSFORMER','2','PAQUETES','E.G.O.','0','404.00','1.330','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'MARIO HERBE VENEGAS CUBERO','3772','','','',0,'','','',0,831,'','','0000-00-00 00:00:00',0,'','','','','','','','','2024-01-26 10:01:10','','','','','',''),(590110,'CHRLPA 0008.24','','459085508VIE','SPECIAL MINICLAMP','1','CARTON','CHG MERIDIA MéXIC EDGARDO PEDROZA','0','880.00','0.875','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'GERARDO GOMEZ BARQUIN','1710','','','',0,'','','',0,630,'','','0000-00-00 00:00:00',0,'','','','','','','','','2024-02-09 11:37:47','','','','','',''),(590128,'CHRLPV 0007.24','','459085866WAW','SEAT CAR PARTS','8','PACKAGES','ADIENT MEXICO AUTOMOTRIZ S DE RL DE CV','9','1200.00','5.837','8','PALLETS','ADIENT MEXICO','','1200.00','','','','','','','','','','','','','','','','','','','','','','RD,35,4;','','','','','','','',0,'GONZALO ADOLFO SALAS CASIAN','3699','8','CR,PKD,BP,DY,BR,','',436003,'2024-02-09 09:29:25','7','**in CFS**',0,557,'','DMARTINEZ','2024-02-09 09:48:27',1,'3268','https://servicios.golmex.mx/MVC/Digitales/VerTarja?Parametro=8QpHOh0DysgNsMefwONNNA%3d%3d','https://servicios.golmex.mx/MVC/Digitales/VerAveria?Parametro=8QpHOh0DysgNsMefwONNNA%3d%3d','','2024-02-08','11:23','','https://intralogs.com.mx/INT/importaciones/prin/formatoderevalidacionint.php?x=qqGooZik&y=qZ6roJWm','2024-02-06 09:36:47','','','','','',' OK|0c27e3a944394479bd82dc30fb2783e3'),(590145,'NEWLPL 0006.24','','NTLZ0222N','UNICOAT-GCF-2003','11','PALLET','UNICOAT-GCF-2003','0','8617.00','15.150','11','PALLET','UNICOAT-GCF-2003','','8617.00','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'ANA LYSETTE ARREDONDO FLORES','3974','','','',436115,'2024-02-09 16:33:40','11','',0,1247,'','VMENDOZA','2024-02-09 16:27:45',1,'','','','','2024-02-09','13:25','','','2024-02-08 08:59:33','','','','','',''),(590153,'JASLPM 0042.24','','CAN37221341','APEX TOOL GROUP','3','PAQUETES','APEX TOOL GROUP MANUFACTURING MEXICO','0','1755.50','3.771','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'JOSE LUIS SALDANA CAMACHO','1614','','','',0,'','','',0,942,'','','0000-00-00 00:00:00',0,'0','','','','','','','','2024-02-09 12:48:47','','','','','',''),(590161,'JASLPM 0043.24','','NGB47238364','RUBBER MOUNT','1','PALLET','ZF SERVICES','0','280.00','1.000','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','',0,'','','',0,0,'','','0000-00-00 00:00:00',0,'0','','','','','','','','2024-02-08 17:25:47','','','','','',''),(590691,'HELLPA 0001.24','','DUSATMO00084','AUTOMOTIVE PARTS','20','PACKAGES','CONTITECH FLUID MEXICANA','0','2419.70','13.094','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'RICARDO BENJAMIN MATEOS MAULEON','1662','','','',0,'','','',0,254,'','','0000-00-00 00:00:00',0,'','','','','','','','','2024-02-08 12:22:04','','','','','',''),(590692,'HELLPA 0001.24','','DUSATMN07044','AUTOMOTIVE PARTS','1','PACKAGE','TRISTONE FLOWTECH MEXICO','0','108.16','1.056','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'RICARDO GUTIERREZ MARGALEFF','3846','','','',0,'','','',0,123,'','','0000-00-00 00:00:00',0,'','','','','','','','','2024-02-08 12:24:04','','','','','',''),(590703,'HELLPA 0001.24','','DUSATMN07086','AUTOMOTIVE PARTS','2','PACKAGES','VALEO SISTEMAS ELECTRICOS','0','436.22','2.170','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','',0,'','','',0,0,'','','0000-00-00 00:00:00',0,'','','','','','','','','0000-00-00 00:00:00','','','','','',''),(590994,'JASLPA 0008.24','','MIL47267806','HOUSING FOR THE MANUFACTURE OF SEMICONDUCTOR DEVICES','4','CASES','UNIVERSAL SCIENTIFIC INDUSTRIAL DE MEXICO','0','1856.00','3.840','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','',0,'','','',0,0,'','','0000-00-00 00:00:00',0,'','','','','','','','','0000-00-00 00:00:00','','','','','',''),(591340,'JASLPM 0059.24','','SEL47261514','FITTING','5','PAQUETES','PH DE MEXICO SA DE CV PO 31698083C 3121JC INVOICE NO  17755617','0','2640.00','5.606','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','',0,'','','',0,0,'','','0000-00-00 00:00:00',0,'0','','','','','','','','2024-02-14 17:13:42','','','','','',''),(591352,'JASLPM 0061.24','','SZX47249683','CONNECTORS','1','PAQUETES','CI231212 45 PO  2000170616 PO 2000164747 PO 2000165762 MADE IN CHINA HS CODE 8536909000','0','286.00','0.720','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'ROSALINDA CARVAJAL UDAVE','3953','','','',0,'','','',0,1160,'','','0000-00-00 00:00:00',0,'0','','','','','','','','2024-02-16 12:08:42','','','','','',''),(591407,'JASLPM 0064.24','','NGB47274908','CONTACTOR','9','TARIMAS','CONTACTOR PO NO 4500470123 NAME NO 0102   400 MADE IN CHINA','0','6300.00','10.000','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','',0,'','','',0,0,'','','0000-00-00 00:00:00',0,'0','','','','','','','','0000-00-00 00:00:00','','','','','',''),(591412,'JASLPM 0065.24','','NGB47287940','PIEZO IGNITOR','3','TARIMAS','008 HV GENERATOR  PO','0','1235.00','2.500','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'PEDRO RAMON PURON ACEVEDO','3752','','','',0,'','','',0,493,'','','0000-00-00 00:00:00',0,'0','','','','','','','','2024-02-16 16:50:08','','','','','',''),(591606,'LIFLPM 0021.24','','EURFLD2410101ZLO','ENGINE LIFTERS ROCKER ARMS SHAFTS','16','OTROS','DACOMSA SA DE CV','0','9372.00','13.639','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','',0,'2024-02-14 10:42:57','','',0,0,'','','0000-00-00 00:00:00',0,'0','','','','','','','','0000-00-00 00:00:00','','','','','',''),(591912,'HELLPM 0004.24','','TAOZLOO00195','CLIP FOR EW8 SENSOR ASSY FR','12','TARIMAS','INVOICE NO 8950165054 8950165055','0','1405.00','10.844','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'SERGIO ALVAREZ RAMIREZ','3931','','','',0,'','','',0,484,'','','0000-00-00 00:00:00',0,'0','','','','','','','','2024-02-15 11:15:36','','','','','',''),(591916,'HELLPM 0004.24','','TAOZLOO00079','59001196632 SWINGVALVE ASSY 59001192664 WASTEGATE VALVE 59001192624 WASTEGATE VALVE','5','CAJAS','NAC BORGWARNER','0','2766.00','4.520','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'EDGAR ORFELIO MARTINEZ QUINTANILLA','1660','','','',0,'','','',0,1158,'','','0000-00-00 00:00:00',0,'0','','','','','','','','2024-02-15 11:16:58','','','','','',''),(591921,'JASLPM 0066.24','','SZX47246513','MOTORS','6','PAQUETES','FAURECIA SAN LUIS POTOSI MADE IN CHINA 5800149742 2756452X-03','0','2465.00','6.459','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','',0,'','','',0,0,'','','0000-00-00 00:00:00',0,'0','','','','','','','','2024-02-16 12:07:19','','','','','',''),(592540,'DACLPV 0012.24','','10230092306','CHEMICALS','14','PALLETS','AIRBUS HELICOPTERS MEXICO QUERETARO SA DE CV','9','6249.75','11.981','14','PALLETS','AIRBUS HELICOPTERS MEXICO QUERETARO','9','6249.75','','','','','','','','','','','','','','','','','','','','','','AP,3,1;','','','','','','','',0,'JOHN MICHAEL WILLY KOLTER','3903','8','CR,DY,WET,PKD,','',439741,'2024-03-05 20:38:24','6','**out**',1,113,'','DMARTINEZ','2024-02-29 17:00:45',1,'3082','https://servicios.golmex.mx/MVC/Digitales/VerTarja?Parametro=aeiEeVxAxra9izoQgKpNkg%3d%3d','https://servicios.golmex.mx/MVC/Digitales/VerAveria?Parametro=aeiEeVxAxra9izoQgKpNkg%3d%3d','1','2024-02-26','17:07','','https://intralogs.com.mx/INT/importaciones/prin/formatoderevalidacionint.php?x=qqGqpJim&y=qZ6up5mk','2024-02-28 12:59:19','','','','','',' OK|f46027c9ce854b20ae0fcb17d3decbc8'),(592837,'SEALPM 0038.24','','QDUC24011286','ALUMINUM ANODE','2','TARIMAS','INDUSTRIAS UNIDAS SA DE CV QDUC24011286','0','1120.00','1.240','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','',0,'','','',0,0,'','','0000-00-00 00:00:00',0,'0','','','','','','','','0000-00-00 00:00:00','','','','','',''),(592846,'SEALPM 0038.24','','QDUC24011422','ALCK6130 CNC LATHE MACHINE','1','PAQUETES','TRADEPARTNER TPIES IMPORT  EXPORT SOLUTIONS S DE RL DE CV  QDUC24011422','0','950.00','5.900','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','',0,'','','',0,0,'','','0000-00-00 00:00:00',0,'0','','','','','','','','0000-00-00 00:00:00','','','','','',''),(593082,'JASLPV 0015.24','','STR47321714','ELEVEN PACKAGES STUFFED ELECTRICAL CABLE, ACCESORIES AND PROMOTIONALS','11','BULTOS','HELUKABEL MEXICO S DE RL DE CV','0','3754.00','9.499','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','',0,'','','',0,0,'','','0000-00-00 00:00:00',0,'','','','','','','','','0000-00-00 00:00:00','','','','','',''),(593320,'SCHLPV 0020.24','','ATVIE0000020470','ELECTRONIC GOODS','1','PALLET','MELECS ELECTRONICS QUERETARO S.A. DE C.V.','0','80.00','0.413','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','',0,'','','',0,0,'','','0000-00-00 00:00:00',0,'','','','','','','','','0000-00-00 00:00:00','','','','','',''),(593345,'LIFLPM 0040.24','','HHSE4016293YA','TEXTILE PIECE GOODS','28','OTROS','COMERCIALIZADORA LA MARINA SA DE CV','0','1058.00','4.500','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','',0,'','','',0,0,'','','0000-00-00 00:00:00',0,'0','','','','','','','','0000-00-00 00:00:00','','','','','',''),(593412,'SCHLPM 0035.24','','HKHKG0000509501','BARE PRINTED CIRCUIT BOARD','7','TARIMAS','PN 196 320 10 AB 196 321 09 REV AA 232 183 01 REV AB 232 183 02 REV AB DN 0075497454 0085565533 0085565534','0','3110.00','6.940','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'VICENTE RIVERA RAMOS','1628','','','',0,'','','',0,111,'','','0000-00-00 00:00:00',0,'0','','','','','','','','2024-02-23 16:15:02','','','','','',''),(593794,'HELLPA 0002.24','','DUSATMO00278','NO ESTIBABLE AUTOMOTIVE PARTS','2','PACKAGES','TRISTONE FLOWTECH MEXICO','0','276.90','2.613','','','','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'RICARDO GUTIERREZ MARGALEFF','3846','','','',0,'','','',1,123,'','','0000-00-00 00:00:00',0,'','','','','','','','','2024-02-26 14:44:23','','','','','',''),(605162,'BCNVERTGY 047.24','HLCUBC1240446854','022024033149-A','CLOSURE BUFFER TUBE BOMBARDIER FIBER SPLICE PROTECTORS','0','PACKAGE','ALSTOM FERROVIARI DE MEXICO','0','0','0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','',0,'2024-06-27 16:16:52','7','',1,23,'','','0000-00-00 00:00:00',0,'','','','','','','','https://intralogs.com.mx/INT/importaciones/prin/formatoderevalidacionint.php?x=qqKspJWr&y=qaGlpZuk','2024-06-27 16:16:53','','','','','',' El consecutivo 8 de la tarja ya se encuentra revalidado. Agente Actual 382 SONIA ERIKA CERDA DE LA TORRE'),(610619,'VLCVERTGY 019.24','HLCUBC1240566391','022024033149-A','CLOSURE BUFFER TUBE BOMBARDIER  FIBER SPLICE PROTECTORS','5','PACKAGE','ALSTOM FERROVIARIA MEXICO','0','525.000','5.780','5','BULTOS','ALSTOM FERROVIARIA MEXICO','','525.00','','','','','','','','','','','','','','','','','','','','','',',0,0;','','','','','','','',0,'FERNANDO DEL VALLE BETANZO','1609','3','BR,CR,DY,BP,','',460561,'2024-07-12 12:42:47','8','**out**',1,23,'','VMONTIEL','2024-06-26 09:49:45',1,'','https://servicios.golmex.mx/MVC/Digitales/VerTarja?Parametro=a0%2be5IVPG1FcD5H66S5YCg%3d%3d','https://servicios.golmex.mx/MVC/Digitales/VerAveria?Parametro=a0%2be5IVPG1FcD5H66S5YCg%3d%3d','1','2024-06-20','12:18','','https://intralogs.com.mx/INT/importaciones/prin/formatoderevalidacionint.php?x=qqKspJWr&y=qaGlpZuk','2024-06-24 12:44:29','','','','','',' El consecutivo 8 de la tarja ya se encuentra revalidado. Agente Actual 382 SONIA ERIKA CERDA DE LA TORRE');
/*!40000 ALTER TABLE `cargasimpointtmp` 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:28:10
