(6404,'OUT-LND-06404','2025-05-09 16:51:11','0000-00-00 00:00:00','PRE-CARRIAGE','PRE-CARRIAGE','2025-05-23 11:46:05','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','2',3225.6,'MXN',3908.04,3369,0,1,630,1.332,'NO','SI','1.332','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',19.56,'2025-05-31 00:00:00','WR','2025-05-23 00:00:00',NULL,NULL,25,0),(6405,'IN-LND-06405','2025-05-09 17:52:42','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE','2025-05-12 12:09:12','IMARIN','GENERAL',NULL,'IRE LOGISTICS S.A. DE C.V.','CIUDAD DE MEXICO','','3',3233.44,'MXN',3916.16,3376,0,1,300,0.346,'NO','SI','0.346','CLIENTE ACTIVO','NO ASIGNADO','SGRACIDA','IMARIN',NULL,'KARLA PINEDA','','',19.56,'0000-00-00 00:00:00','YES',NULL,NULL,NULL,25,0),(6406,'OUT-LND-06406','2025-05-11 23:48:16','2025-05-11 23:48:35','PRE-CARRIAGE','PRE-CARRIAGE','2025-05-23 11:46:04','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','5',0,'MXN',17801.952,15346.51,0,10,550,2.55,'NO','NO','2.550','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',19.56,'2025-05-31 00:00:00','WR','2025-05-23 00:00:00',NULL,NULL,100,0),(6407,'IN-LND-06407','2025-05-12 09:24:59','2025-05-12 09:28:36','ON-CARRIAGE','ON-CARRIAGE','2025-05-23 11:43:10','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','2',9318.4,'MXN',11346.83,9781.75,0,12,222,1.288,'SI','SI','1.288','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',19.49,'2025-05-31 00:00:00','NO','2025-05-23 00:00:00',NULL,NULL,75,0),(6408,'OUT-LND-06408','2025-05-12 10:30:16','0000-00-00 00:00:00','PRE-CARRIAGE','PRE-CARRIAGE','2025-05-14 11:40:45','RDOMINGUEZ','GENERAL',NULL,'TRAFIMAR RELOCATION SERVICES S.A. DE C.V.','ESTADO DE MEXICO','','',0,'MXN',16169.472,13939.2,0,3,1596,13.491,'NO','SI','13.491','CLIENTE ACTIVO','EBERNABE','PGIESS','RDOMINGUEZ',NULL,'','','',19.49,'0000-00-00 00:00:00','YES',NULL,'TINTNDJZLO2600.25',NULL,80,0),(6409,'IN-LND-06409','2025-05-12 10:34:51','2025-05-12 10:38:43','ON-CARRIAGE','ON-CARRIAGE','2025-05-23 11:43:36','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','2',11516.008,'MXN',13509.882,11646.45,0,30,1075,2.795,'SI','SI','2.795','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',19.49,'2025-05-31 00:00:00','NO','2025-05-23 00:00:00',NULL,NULL,70,0),(6410,'IN-LND-06410','2025-05-12 11:39:28','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE','2025-05-12 13:08:53','ALOPEZ','GENERAL',NULL,'TARIFA CLIENTE DIRECTO','CIUDAD DE MEXICO','','3',4560.64,'MXN',5401.772,4656.7,0,1,280,2.431,'NO','SI','2.431','CLIENTE ACTIVO','NO ASIGNADO','NO ASIGNADO','ALOPEZ',NULL,'','','',19.49,'2025-05-31 00:00:00','YES',NULL,'TINTZLOZAP2575.25',NULL,30,0),(6411,'IN-LND-06411','2025-05-12 12:54:12','2025-05-12 12:54:14','ON-CARRIAGE','ON-CARRIAGE','2025-05-23 11:46:02','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','2',0,'MXN',7446.852,6419.7,0,1,800,2.066,'NO','NO','2.066','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',19.49,'2025-05-31 00:00:00','WR','2025-05-23 00:00:00',NULL,NULL,30,0),(6412,'IN-LND-06412','2025-05-12 13:17:56','2025-05-12 13:18:07','ON-CARRIAGE','ON-CARRIAGE','2025-05-12 13:38:02','IMARTINEZ','GENERAL',NULL,'KCC MEXICO TRANSPORT SYSTEM S.A. DE C.V.','CIUDAD DE MEXICO','','3',7655.2,'MXN',9285.104,8004.4,0,4,2895,3.229,'NO','NO','3.229','CLIENTE ACTIVO','DALEON','MAGONZALEZ','IMARTINEZ',NULL,'','','',19.49,'2025-05-31 00:00:00','YES',NULL,'TINTZLOPQA2545.25',NULL,60,0),(6413,'IN-LND-06413','2025-05-13 09:39:50','2025-05-13 09:40:19','ON-CARRIAGE','ON-CARRIAGE','2025-06-23 16:45:55','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','4',9887.64,'MXN',10923.546,9416.85,0,1,176,0.778,'NO','NO','0.778','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',19.62,'2025-05-31 00:00:00','YES','2025-05-23 00:00:00',NULL,NULL,30,0),(6414,'IN-LND-06414','2025-05-13 09:49:54','2025-07-22 16:24:15','ON-CARRIAGE','ON-CARRIAGE','2025-05-13 09:56:41','EGUARNEROS','GENERAL',NULL,'CWL MEXICO S. DE R.L. DE C.V.','CIUDAD DE MEXICO','','6',0,'MXN',58860.009,50741.387,0,1,263.088,1.548,'NO','SI','1.548','CLIENTE ACTIVO','DALEON','DARROYO','EGUARNEROS',NULL,'Hector Duenas','Hector.Duenas@craneww.com','',19.62,'2025-05-18 00:00:00','YES','2025-05-13 00:00:00','TINTVERCUN3789.25',NULL,200.0809,0),(6415,'IN-LND-06415','2025-05-13 16:47:41','2025-05-14 14:43:49','ON-CARRIAGE','ON-CARRIAGE','2025-05-13 16:50:03','EGUARNEROS','GENERAL',NULL,'UPS SCS MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','2',8118.88,'MXN',9536.36,8221,0,1,426,0.74,'SI','NO','0.740','CLIENTE ACTIVO','EREYNA','ABALDERAS','EGUARNEROS',NULL,'Ruben Hernandez','rubenhernandez@ups.com','',19.44,'2025-06-10 00:00:00','YES',NULL,NULL,NULL,50,0),(6416,'IN-LND-06416','2025-05-13 17:35:34','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE','2025-05-13 17:37:50','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','2',4082.758,'MXN',4779.434,4120.202,0,1,100,1.536,'NO','NO','1.536','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Daniela Guevara','','',19.62,'2025-05-31 00:00:00','YES',NULL,'TINTATMMTY2597.25',NULL,24.204,0),(6417,'IN-LND-06417','2025-05-13 17:47:00','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE','2025-05-13 17:50:11','RDOMINGUEZ','GENERAL',NULL,'DAMON GLOBAL S.A. DE C.V.','QUERETARO','','',0,'MXN',27581.552,23777.2,0,11,10182.37,21,'NO','SI','21.000','CLIENTE ACTIVO','EBERNABE','DILOPEZ','RDOMINGUEZ',NULL,'','','',19.62,'0000-00-00 00:00:00','YES',NULL,NULL,NULL,60,0),(6418,'IN-LND-06418','2025-05-14 13:07:06','2025-05-15 11:49:40','ON-CARRIAGE','ON-CARRIAGE','2025-05-15 02:39:43','EGUARNEROS','GENERAL',NULL,'UPS SCS MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','2',0,'MXN',7547.331,6506.32,0,2,551,1.52,'NO','SI','1.520','CLIENTE ACTIVO','EREYNA','ABALDERAS','EGUARNEROS',NULL,'Doris Rivera','drivera4@ups.com','',19.44,'2025-05-31 00:00:00','NO',NULL,NULL,NULL,75,0),(6419,'IN-LND-06419','2025-05-15 09:38:06','2025-05-15 11:02:38','ON-CARRIAGE','ON-CARRIAGE','2025-05-28 10:52:32','IMARIN','GENERAL',NULL,'IRE LOGISTICS S.A. DE C.V.','CIUDAD DE MEXICO','','3',14511.84,'MXN',16265.288,14021.8,0,6,3198,7.986,'NO','NO','7.986','CLIENTE ACTIVO','NO ASIGNADO','SGRACIDA','IMARIN',NULL,'STELLA WANG','','',19.36,'0000-00-00 00:00:00','WR','2025-05-21 00:00:00',NULL,NULL,55,0),(6420,'OUT-LND-06420','2025-05-15 11:04:28','0000-00-00 00:00:00','PRE-CARRIAGE','PRE-CARRIAGE','2025-05-15 04:58:13','PRYDBERG','GENERAL',NULL,'ICL AND NAVIOMEX S.A. DE C.V.','ESTADO DE MEXICO','','1',7026.029,'MXN',7950.686,6854.04,0,3,3870.99,3.604,'NO','SI','3.87099','CLIENTE ACTIVO','MCRUZ','PRYDBERG','PRYDBERG',NULL,'Angeles Carmona','logistica1@grupoicl.com','9988933471',19.36,'2025-06-15 00:00:00','NO',NULL,NULL,NULL,30,0),(6421,'IN-LND-06421','2025-05-15 13:12:13','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE','2025-05-16 10:19:12','PRYDBERG','GENERAL',NULL,'CONTINENTAL LINK PANAMERICANA S.A. DE C.V.','CIUDAD DE MEXICO','','3',6537.608,'MXN',7444.822,6417.95,0,3,1752,4.73,'NO','SI','4.730','CLIENTE ACTIVO','DALEON','PRYDBERG','PRYDBERG',NULL,'Jazmin Romero','jromero@contilink.mx','',19.36,'2025-06-15 00:00:00','YES',NULL,NULL,NULL,30,0),(6422,'IN-LND-06422','2025-05-15 14:09:51','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE','2025-05-15 14:11:12','EGUARNEROS','GENERAL',NULL,'EXPEDITORS INTERNATIONAL DE MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','4',0,'MXN',22794.474,19650.409,0,1,2000,6.344,'NO','NO','6.344','CLIENTE ACTIVO','EBERNABE','DARROYO','EGUARNEROS',NULL,'Daniel Nunez','Daniel.Nunez@expeditors.com','',19.36,'2025-05-31 00:00:00','YES',NULL,NULL,NULL,118.001,0),(6423,'IN-LND-06423','2025-05-15 14:17:40','2025-07-01 15:00:20','ON-CARRIAGE','ON-CARRIAGE','2025-05-15 14:18:46','RDOMINGUEZ','GENERAL',NULL,'MEXICO AIR CARGO SYSTEMS S.A. DE C.V.','CIUDAD DE MEXICO','','',23980.208,'MXN',26498.506,22843.54,0,22,3210.02,8.789,'SI','SI','8.789','CLIENTE ACTIVO','MCRUZ','PGIESS','RDOMINGUEZ',NULL,'','','',19.36,'0000-00-00 00:00:00','YES',NULL,'TINTZLOELS3593.25',NULL,74,0),(6424,'OUT-LND-06424','2025-05-15 17:07:56','2025-05-16 10:33:19','PRE-CARRIAGE','PRE-CARRIAGE','2025-05-15 17:10:26','EGUARNEROS','GENERAL',NULL,'HELLMANN WORLDWIDE LOGISTICS S.A. DE C.V.','CIUDAD DE MEXICO','','2',0,'MXN',14647.494,12627.15,0,28,9520,10.376,'NO','SI','10.376','CLIENTE ACTIVO','EREYNA','DARROYO','EGUARNEROS',NULL,'Juan Manuel López','JoseManuel.Lopez@hellmann.com','',19.36,'2025-05-31 00:00:00','YES',NULL,'EXITVERLEH867755',NULL,110,0),(6425,'OUT-LND-06425','2025-05-15 20:57:05','2025-05-16 01:24:59','PRE-CARRIAGE','PRE-CARRIAGE','2025-05-16 10:42:21','EGUARNEROS','GENERAL',NULL,'GEODIS MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','2',0,'MXN',26785.862,23091.26,0,17,12631,9.198,'NO','SI','12.631','CLIENTE ACTIVO','EBERNABE','ABALDERAS','EGUARNEROS',NULL,'','','',19.36,'2025-05-31 00:00:00','YES','2025-05-16 00:00:00','EXITVERMRS867541',NULL,120,0),(6426,'IN-LND-06426','2025-05-16 13:29:49','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE','2025-05-16 13:34:21','IMARTINEZ','GENERAL',NULL,'AFIECSA LOGISTICS','S.A. DE C.V.','','3',3163.552,'USD',3276.536,2824.6,0,6,95,0.75,'NO','SI','0.750','CLIENTE ACTIVO','NO ASIGNADO','JANGELES','IMARTINEZ',NULL,'','','',19.48,'2025-05-31 00:00:00','YES',NULL,'TINTZLOLCO2789.25',NULL,0,0),(6427,'IN-LND-06427','2025-05-16 16:36:18','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE',NULL,'ALOPEZ','GENERAL',NULL,'INTERTRADE CARGO S.A. DE C.V.','CIUDAD DE MEXICO','','4',17830.4,'MXN',18919.136,16309.6,0,425,2422.5,14.062,'NO','SI','14.062','CLIENTE ACTIVO','NO ASIGNADO','MAGONZALEZ','ALOPEZ',NULL,'','','',19.48,'2025-05-31 00:00:00','NEW',NULL,NULL,NULL,20,0),(6428,'IN-LND-06428','2025-05-19 10:44:45','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE','2025-05-19 10:45:29','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','1',50960,'MXN',63368.488,54628.007,0,3,898,1.786,'NO','SI','1.786','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',19.51,'2025-05-31 00:00:00','YES',NULL,NULL,NULL,467.863,0),(6429,'IN-LND-06429','2025-05-19 13:30:48','2025-05-19 13:31:20','ON-CARRIAGE','ON-CARRIAGE','2025-05-23 11:45:59','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','3',17009.485,'MXN',19314.336,16650.29,0,9,1107,13.143,'NO','SI','13.143','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',19.51,'2025-05-31 00:00:00','WR','2025-05-19 00:00:00',NULL,NULL,75,0),(6430,'IN-LND-06430','2025-05-20 09:42:25','2025-05-20 10:56:44','ON-CARRIAGE','ON-CARRIAGE','2025-05-21 16:35:37','ALOPEZ','GENERAL',NULL,'NEWMAN INTERNATIONAL S.A. DE C.V.','MONTERREY','','3',4365.76,'MXN',5195.756,4479.1,0,2,9.7,0.021,'NO','SI','0.021','CLIENTE ACTIVO','EREYNA','SHURTADO','ALOPEZ',NULL,'','','',19.37,'2025-05-31 00:00:00','YES',NULL,'TINTZLORMA2708.25',NULL,30,0),(6431,'IN-LND-06431','2025-05-20 12:31:36','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE',NULL,'PRYDBERG','GENERAL',NULL,'ORANGE BOX LOGISTICS S.A. DE C.V.','CIUDAD DE MEXICO','','2',6901.339,'MXN',7709.546,6646.16,0,4,1412,5.973,'NO','SI','5.973','CLIENTE ACTIVO','LRUBIO','PRYDBERG','PRYDBERG',NULL,'Marco Vivanco','opsintl01@otob.mx','',19.37,'2025-06-15 00:00:00','NEW',NULL,NULL,NULL,25,0),(6432,'IN-LND-06432','2025-05-20 16:00:07','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE','2025-05-28 10:52:34','IMARIN','GENERAL',NULL,'KCC MEXICO TRANSPORT SYSTEM S.A. DE C.V.','CIUDAD DE MEXICO','','3',0,'MXN',9932.152,8562.2,0,6,4341.96,4.095,'NO','SI','4.34196','CLIENTE ACTIVO','DALEON','MAGONZALEZ','IMARIN',NULL,'','','',19.37,'0000-00-00 00:00:00','WR','2025-05-21 00:00:00',NULL,NULL,60,0),(6433,'OUT-LND-06433','2025-05-20 16:40:36','2025-05-20 16:44:16','PRE-CARRIAGE','PRE-CARRIAGE','2025-05-20 16:45:17','EGUARNEROS','GENERAL',NULL,'SCHENKER INTERNATIONAL S.A. DE C.V.','CIUDAD DE MEXICO','','4',0,'MXN',14167.01,12212.94,0,1,161,4.822,'NO','SI','4.822','CLIENTE ACTIVO','DALEON','ABALDERAS','EGUARNEROS',NULL,'','','',19.37,'2025-05-31 00:00:00','YES',NULL,NULL,NULL,45,0),(6434,'IN-LND-06434','2025-05-20 16:51:26','2025-05-22 12:12:37','ON-CARRIAGE','ON-CARRIAGE','2025-05-20 16:54:05','IMARTINEZ','GENERAL',NULL,'AFIECSA LOGISTICS','S.A. DE C.V.','','3',9899.68,'MXN',10923.488,9416.8,0,50,810,6.28,'NO','SI','6.280','CLIENTE ACTIVO','NO ASIGNADO','JANGELES','IMARTINEZ',NULL,'','','',19.26,'2025-05-31 00:00:00','YES',NULL,'TINTZLOLCO2705.25',NULL,30,0),(6435,'IN-LND-06435','2025-05-20 18:10:38','2025-05-21 11:15:17','ON-CARRIAGE','ON-CARRIAGE','2025-05-20 18:30:59','IMARTINEZ','GENERAL',NULL,'TERMINAL LOGISTICS DISTRIBUCION S.A. DE C.V.','CIUDAD DE MEXICO','','3',12155.36,'MXN',13371.436,11527.1,0,4,4231,8.21,'NO','NO','8.210','CLIENTE ACTIVO','EREYNA','JANGELES','IMARTINEZ',NULL,'','','',19.26,'2025-05-31 00:00:00','YES',NULL,'TINTZLOMTY2698.25',NULL,35,0),(6436,'IN-LND-06436','2025-05-21 15:44:49','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE','2025-05-21 15:47:57','IMARTINEZ','GENERAL',NULL,'AFIECSA LOGISTICS','S.A. DE C.V.','','3',14537.6,'MXN',16085.944,13867.193,0,372,4552,13,'NO','SI','13.000','CLIENTE ACTIVO','NO ASIGNADO','JANGELES','IMARTINEZ',NULL,'','','',19.26,'2025-05-31 00:00:00','YES',NULL,'TINTZLOQRO3106.25',NULL,46.064,0),(6437,'IN-LND-06437','2025-05-21 16:41:37','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE','2025-05-21 16:44:42','ALOPEZ','GENERAL',NULL,'CQL MEXICO S.A. DE C.V.','MONTERREY','','4',9707.04,'USD',10053.72,8667,0,2,605,5.226,'NO','SI','5.226','CLIENTE ACTIVO','EBERNABE','SHURTADO','ALOPEZ',NULL,'','','',19.26,'2025-05-31 00:00:00','YES',NULL,'TINTZLOAPD2713.25',NULL,0,0),(6438,'OUT-LND-06438','2025-05-22 11:09:09','2025-05-22 11:09:11','PRE-CARRIAGE','PRE-CARRIAGE','2025-05-23 11:45:58','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','5',5147.89,'MXN',6228.191,5369.13,0,6,100,1.104,'NO','NO','1.104','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',19.32,'2025-05-31 00:00:00','WR','2025-05-23 00:00:00',NULL,NULL,40,0),(6439,'OUT-LND-06439','2025-05-22 13:30:16','0000-00-00 00:00:00','PRE-CARRIAGE','PRE-CARRIAGE','2025-06-09 10:23:00','PRYDBERG','GENERAL',NULL,'ACCESS GLOBAL FORWARDING S.A. DE C.V.','CIUDAD DE MEXICO','','3',4687.693,'MXN',5482.624,4726.4,0,3,850,3.456,'NO','SI','3.456','CLIENTE ACTIVO','NO ASIGNADO','PRYDBERG','PRYDBERG',NULL,'Priscilla Rivero','pricing2@agf.com.mx','5557851048',19.32,'2025-06-30 00:00:00','WR',NULL,NULL,NULL,28,0),(6440,'OUT-LND-06440','2025-05-22 14:08:59','0000-00-00 00:00:00','PRE-CARRIAGE','PRE-CARRIAGE','2025-05-27 17:36:47','RDOMINGUEZ','GENERAL',NULL,'MEXICO AIR CARGO SYSTEMS S.A. DE C.V.','CIUDAD DE MEXICO','','',13112.848,'MXN',14029.388,12094.3,0,2,680.5,3.842,'NO','SI','3.842','CLIENTE ACTIVO','MCRUZ','PGIESS','RDOMINGUEZ',NULL,'','','',19.32,'0000-00-00 00:00:00','WR',NULL,NULL,NULL,20,0),(6441,'IN-LND-06441','2025-05-22 15:51:58','2025-05-22 17:16:20','ON-CARRIAGE','ON-CARRIAGE','2025-05-30 01:29:47','DDOMINGUEZ','GENERAL',NULL,'SISTEMAS DE FLETES INTERNACIONALES S.A. DE C.V.','VERACRUZ','','4',31507.773,'MXN',33753.61,29097.94,0,13,8696,16.003,'NO','SI','16.003','CLIENTE ACTIVO','NO ASIGNADO','JLPRIETO','DDOMINGUEZ',NULL,'Isabel Vázquez','isabel.vazquez@vitransgroup.com','',19.32,'2025-05-31 00:00:00','NO','2025-05-27 00:00:00',NULL,NULL,50,0),(6442,'OUT-LND-06442','2025-05-23 11:59:32','2025-05-23 11:59:39','PRE-CARRIAGE','PRE-CARRIAGE',NULL,'ALOPEZ','GENERAL',NULL,'INTERTEAM S.A. DE C.V.','CIUDAD DE MEXICO','','4',31136,'MXN',33368.56,28766,0,1,500,1,'NO','SI','1.000','CLIENTE ACTIVO','NO ASIGNADO','NO ASIGNADO','ALOPEZ',NULL,'','','',19.32,'2025-05-31 00:00:00','NEW',NULL,NULL,NULL,50,0),(6443,'OUT-LND-06443','2025-05-23 12:05:21','0000-00-00 00:00:00','PRE-CARRIAGE','PRE-CARRIAGE',NULL,'ALOPEZ','GENERAL',NULL,'INTERTEAM S.A. DE C.V.','CIUDAD DE MEXICO','','3',14930.496,'USD',15463.728,13330.8,0,1,500,1,'NO','SI','1.000','CLIENTE ACTIVO','NO ASIGNADO','NO ASIGNADO','ALOPEZ',NULL,'','','',19.32,'2025-05-31 00:00:00','NEW',NULL,NULL,NULL,0,0),(6444,'OUT-LND-06444','2025-05-23 12:09:09','2025-05-23 12:10:59','PRE-CARRIAGE','PRE-CARRIAGE','2025-05-23 12:12:30','EGUARNEROS','GENERAL',NULL,'CH ROBINSON GLOBAL FORWARDING MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','3',8742.272,'MXN',9726.832,8385.2,0,12,3377,6.84,'NO','SI','6.840','CLIENTE ACTIVO','LRUBIO','ABALDERAS','EGUARNEROS',NULL,'Yazmin Torres','Yazmin.Torres@chrobinson.com','',19.32,'2025-05-31 00:00:00','YES',NULL,'EXITVERPNG867815',NULL,30,0),(6445,'IN-LND-06445','2025-05-26 11:56:54','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE',NULL,'ALOPEZ','GENERAL',NULL,'NEWMAN INTERNATIONAL S.A. DE C.V.','MONTERREY','','6',59109.12,'MXN',61890.756,53354.1,0,5,3400,31.79,'NO','SI','31.790','CLIENTE ACTIVO','NO ASIGNADO','SHURTADO','ALOPEZ',NULL,'','','',19.27,'2025-05-31 00:00:00','NEW',NULL,NULL,NULL,30,0),(6446,'IN-LND-06446','2025-05-26 12:08:20','2025-05-26 12:08:26','ON-CARRIAGE','ON-CARRIAGE','2025-05-29 23:13:29','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','3',8574.026,'MXN',9550.837,8233.48,0,5,1830,6.145,'NO','SI','6.145','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',19.27,'2025-05-31 00:00:00','WR','2025-05-27 00:00:00',NULL,NULL,30,0),(6447,'IN-LND-06447','2025-05-26 12:18:45','2025-06-09 10:46:20','ON-CARRIAGE','ON-CARRIAGE','2025-05-26 13:33:41','EGUARNEROS','GENERAL',NULL,'SGL TRANSGROUP DE MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','2',4689.216,'MXN',5639.05,4861.25,0,1,1077.1,1.085,'NO','NO','1.085','CLIENTE ACTIVO','LRUBIO','ABALDERAS','EGUARNEROS',NULL,'Lizette Martinez','LizeM@scangl.com','',19.27,'2025-05-31 00:00:00','YES',NULL,'TINTZLOELS3050.25',NULL,35,0),(6448,'IN-LND-06448','2025-05-26 12:24:54','2025-05-26 15:52:49','ON-CARRIAGE','ON-CARRIAGE','2025-05-28 17:11:59','ALOPEZ','GENERAL',NULL,'NEWMAN INTERNATIONAL S.A. DE C.V.','MONTERREY','','4',5894.56,'MXN',6552.144,5648.4,0,1,18,0.55,'NO','NO','0.550','CLIENTE ACTIVO','NO ASIGNADO','SHURTADO','ALOPEZ',NULL,'','','',19.27,'2025-05-31 00:00:00','YES',NULL,'TINTZLORMA2869.25',NULL,20,0),(6449,'IN-LND-06449','2025-05-26 12:25:11','2025-06-06 11:57:37','ON-CARRIAGE','ON-CARRIAGE','2025-05-26 12:33:20','EGUARNEROS','GENERAL',NULL,'SGL TRANSGROUP DE MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','2',5540.864,'MXN',6409.348,5525.3,0,2,706.92,2.112,'NO','NO','2.112','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',19.27,'2025-06-15 00:00:00','YES',NULL,'TINTZLOELS2889.25',NULL,30,0),(6450,'LOC-LND-06450','2025-05-26 15:54:51','2025-05-28 12:56:31','SERVICIO LOCAL','SERVICIO LOCAL','2025-05-26 17:59:33','RDOMINGUEZ','GENERAL',NULL,'ROMEU MEXICO S.A. DE C.V.','CIUDAD DE MEXICO POLANCO','','',12700.968,'MXN',15121.656,13035.91,0,2,1000,6.209,'NO','SI','6.209','CLIENTE ACTIVO','DALEON','PGIESS','RDOMINGUEZ',NULL,'','','',19.27,'0000-00-00 00:00:00','YES',NULL,'TINTMEXGDL2845.25',NULL,88,0),(6451,'OUT-LND-06451','2025-05-27 09:37:08','2025-05-29 14:06:05','PRE-CARRIAGE','PRE-CARRIAGE','2025-05-27 09:42:56','EGUARNEROS','GENERAL',NULL,'UPS SCS MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','2',7811.059,'MXN',8841.195,7621.72,0,4,1074,8.214,'NO','SI','8.214','CLIENTE ACTIVO','NO ASIGNADO','ABALDERAS','EGUARNEROS',NULL,'','','',19.22,'2025-06-15 00:00:00','YES',NULL,'EXITATMMIL868017',NULL,33.692,0),(6452,'IN-LND-06452','2025-05-27 10:28:36','2025-05-27 10:29:53','ON-CARRIAGE','ON-CARRIAGE','2025-05-29 23:13:26','EGUARNEROS','GENERAL',NULL,'HELLMANN WORLDWIDE LOGISTICS S.A. DE C.V.','CIUDAD DE MEXICO','','1',28560,'MXN',33258.708,28671.3,0,6,2240,2.16,'NO','SI','2.24','CLIENTE ACTIVO','EREYNA','DARROYO','EGUARNEROS',NULL,'Elizabeth Chavez','Elizabeth.Chavez@hellmann.com','',19.22,'2025-06-15 00:00:00','WR','2025-05-27 00:00:00',NULL,NULL,165,0),(6453,'IN-LND-06453','2025-05-27 12:14:24','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE','2025-05-27 17:32:18','PRYDBERG','GENERAL',NULL,'SAMSUNG SDS MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','4',15987.608,'MXN',17115.974,14755.15,0,4,1500,12.43,'NO','SI','12.430','CLIENTE ACTIVO','NO ASIGNADO','PRYDBERG','PRYDBERG',NULL,'Abimael Garcia','abimael.ga@samsung.com','',19.22,'2025-06-30 00:00:00','YES',NULL,'TINTZLOJIU2853.25',NULL,25,0),(6454,'IN-LND-06454','2025-05-27 12:52:46','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE',NULL,'ALOPEZ','GENERAL',NULL,'NEWMAN INTERNATIONAL S.A. DE C.V.','MONTERREY','','4',0,'MXN',33726.536,29074.6,0,9,3825,22.869,'NO','NO','22.869','CLIENTE ACTIVO','NO ASIGNADO','SHURTADO','ALOPEZ',NULL,'','','',19.22,'2025-06-10 00:00:00','NEW',NULL,NULL,NULL,30,0),(6455,'IN-LND-06455','2025-05-27 16:41:55','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE',NULL,'IMARIN','GENERAL',NULL,'IRE LOGISTICS S.A. DE C.V.','CIUDAD DE MEXICO','','2',12303.2,'MXN',12742.6,10985,0,4,1856,8.343,'NO','NO','8.343','CLIENTE ACTIVO','NO ASIGNADO','SGRACIDA','IMARIN',NULL,'JOSUE LEE','','',19.22,'2025-06-30 00:00:00','FUP','2025-05-28 00:00:00',NULL,NULL,0,0),(6456,'OUT-LND-06456','2025-05-28 10:00:22','2025-06-02 09:46:12','PRE-CARRIAGE','PRE-CARRIAGE','2025-05-28 10:52:26','IMARIN','GENERAL',NULL,'INTERGLOBO MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','',3423.84,'MXN',3992.256,3441.6,0,24,408,1.316,'NO','SI','1.316','CLIENTE ACTIVO','NO ASIGNADO','SGRACIDA','IMARIN',NULL,'FEDERICA PULIGA','','',19.23,'0000-00-00 00:00:00','YES',NULL,'EXITZLOGYE868082',NULL,20,0),(6457,'IN-LND-06457','2025-05-29 10:43:27','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE',NULL,'IMARIN','GENERAL',NULL,'CLESE INTERNACIONAL Y ASOCIADOS S.C.','CIUDAD DE MEXICO','','',6512.8,'MXN',7420.52,6397,0,2,3106,3.173,'NO','SI','3.173','CLIENTE ACTIVO','EREYNA','RSANDOVAL','IMARIN',NULL,'GABRIELA SAYAGO','','',19.4,'0000-00-00 00:00:00','NEW',NULL,NULL,NULL,30,0),(6458,'OUT-LND-06458','2025-05-29 12:02:06','2025-05-29 12:21:29','PRE-CARRIAGE','PRE-CARRIAGE','2025-06-23 12:39:22','PRYDBERG','GENERAL',NULL,'SEGROVE INTERNACIONAL S.A. DE C.V.','CIUDAD DE MEXICO','','1',13809.376,'MXN',14865.168,12814.8,0,6,2808,3.471,'NO','SI','3.471','CLIENTE ACTIVO','EREYNA','PRYDBERG','PRYDBERG',NULL,'Antonio Hernandez','antonio.hernandez@segrove.com','',19.4,'2025-06-30 00:00:00','WR',NULL,NULL,NULL,25,0),(6459,'IN-LND-06459','2025-05-29 12:31:50','2025-05-30 11:56:33','ON-CARRIAGE','ON-CARRIAGE','2025-05-29 14:02:35','PRYDBERG','GENERAL',NULL,'SAMSUNG SDS MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','2',7840,'MXN',8570.08,7388,0,1,309.5,3.437,'NO','SI','3.437','CLIENTE ACTIVO','NO ASIGNADO','PRYDBERG','PRYDBERG',NULL,'Javier Cardenas','javier.cm@Samsung.com','',19.4,'0000-00-00 00:00:00','YES',NULL,'TINTZLOJIU2908.25',NULL,20,0),(6460,'OUT-LND-06460','2025-05-29 14:55:39','2025-05-29 14:55:43','PRE-CARRIAGE','PRE-CARRIAGE','2025-05-29 14:57:04','EGUARNEROS','GENERAL',NULL,'SCHENKER INTERNATIONAL S.A. DE C.V.','CIUDAD DE MEXICO','','2',0,'MXN',42874.171,36960.492,0,18,5198.92,27.968,'NO','NO','27.968','CLIENTE ACTIVO','DALEON','ABALDERAS','EGUARNEROS',NULL,'','','',19.4,'2025-06-10 00:00:00','YES',NULL,NULL,NULL,120.28,0),(6461,'OUT-LND-06461','2025-05-29 16:54:40','2025-05-29 16:59:01','PRE-CARRIAGE','PRE-CARRIAGE','2025-05-29 17:01:48','EGUARNEROS','GENERAL',NULL,'UPS SCS MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','2',16328.57,'MXN',20287.333,17489.08,0,7,616,5.171,'NO','NO','5.171','CLIENTE ACTIVO','NO ASIGNADO','ABALDERAS','EGUARNEROS',NULL,'','','',19.4,'2025-06-10 00:00:00','YES',NULL,'EXITATMANR868095',NULL,150,0),(6462,'IN-LND-06462','2025-05-30 11:13:24','2025-06-12 13:29:56','ON-CARRIAGE','ON-CARRIAGE',NULL,'IMARIN','GENERAL',NULL,'IRE LOGISTICS S.A. DE C.V.','CIUDAD DE MEXICO','','',4704,'MXN',5656.798,4876.55,0,2,970,0.279,'NO','SI','0.97','CLIENTE ACTIVO','NO ASIGNADO','SGRACIDA','IMARIN',NULL,'JOSUE LEE','','',19.33,'0000-00-00 00:00:00','FUP','2025-06-12 00:00:00',NULL,NULL,35,0),(6463,'OUT-LND-06463','2025-05-30 11:35:32','2025-05-30 11:40:39','PRE-CARRIAGE','PRE-CARRIAGE','2025-06-12 02:36:50','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','4',7139.418,'MXN',8291.309,7147.68,0,3,1029,1.447,'NO','SI','1.447','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',19.33,'2025-06-15 00:00:00','WR','2025-06-12 00:00:00',NULL,NULL,40,0),(6464,'IN-LND-06464','2025-05-30 11:50:07','2025-07-07 16:18:43','ON-CARRIAGE','ON-CARRIAGE','2025-06-04 15:32:54','DDOMINGUEZ','GENERAL',NULL,'ANKER LOGISTICA MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','3',9425.416,'MXN',10434.722,8995.45,0,1,826,0.99,'NO','SI','0.990','CLIENTE ACTIVO','MCRUZ','JLPRIETO','DDOMINGUEZ',NULL,'Eric Ranzahuer','pricing.mx@ankerlogistica.com','',19.33,'0000-00-00 00:00:00','YES','2025-06-04 00:00:00','TINTZLOCOL3552.25',NULL,30,0),(6465,'OUT-LND-06465','2025-05-30 15:46:40','0000-00-00 00:00:00','PRE-CARRIAGE','PRE-CARRIAGE',NULL,'ALOPEZ','GENERAL',NULL,'TARIFA CLIENTE DIRECTO','CIUDAD DE MEXICO','','4',14011.771,'MXN',15184.876,13090.41,0,5,4258.7,8.376,'NO','SI','8.376','CLIENTE ACTIVO','NO ASIGNADO','NO ASIGNADO','ALOPEZ',NULL,'','','',19.33,'2025-06-14 00:00:00','NEW',NULL,NULL,NULL,30,0),(6466,'OUT-LND-06466','2025-05-30 17:49:14','2025-06-02 10:57:15','PRE-CARRIAGE','PRE-CARRIAGE','2025-06-02 15:03:10','ALOPEZ','GENERAL',NULL,'TARIFA CLIENTE DIRECTO','CIUDAD DE MEXICO','','3',5398.4,'MXN',6712.34,5786.5,0,1,655,1.21,'NO','NO','1.210','CLIENTE ACTIVO','NO ASIGNADO','NO ASIGNADO','ALOPEZ',NULL,'','','',19.33,'2025-06-12 00:00:00','YES',NULL,'EXITZLOGYE868287',NULL,50,0),(6467,'OUT-LND-06467','2025-06-02 09:47:05','2025-06-02 09:48:22','PRE-CARRIAGE','PRE-CARRIAGE','2025-07-02 01:25:31','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','3',10416.986,'MXN',12026.103,10367.33,0,4,1152,6.912,'NO','SI','6.912','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',19.39,'2025-06-15 00:00:00','WR','2025-06-13 00:00:00',NULL,NULL,55,0),(6468,'IN-LND-06468','2025-06-02 12:20:16','2025-06-06 10:15:51','ON-CARRIAGE','ON-CARRIAGE','2025-06-05 17:17:43','EGUARNEROS','GENERAL',NULL,'SGL TRANSGROUP DE MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','3',5550.25,'MXN',6592.613,5683.287,0,1,120,0.432,'NO','NO','0.432','CLIENTE ACTIVO','LRUBIO','ABALDERAS','EGUARNEROS',NULL,'Lizette Martinez','LizeM@scangl.com','',19.39,'2025-06-15 00:00:00','YES',NULL,'TINTZLOTTL3018.25',NULL,37.53,0),(6469,'IN-LND-06469','2025-06-02 12:30:46','2025-06-11 14:00:43','ON-CARRIAGE','ON-CARRIAGE','2025-06-05 17:23:48','EGUARNEROS','GENERAL',NULL,'SGL TRANSGROUP DE MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','3',7540.915,'MXN',8597.468,7411.61,0,3,490,2.7,'NO','NO','2.700','CLIENTE ACTIVO','LRUBIO','ABALDERAS','EGUARNEROS',NULL,'Lizette Martinez','LizeM@scangl.com','',19.39,'2025-06-15 00:00:00','YES',NULL,'TINTZLOTTL3024.25',NULL,35,0),(6470,'OUT-LND-06470','2025-06-02 13:00:01','0000-00-00 00:00:00','PRE-CARRIAGE','PRE-CARRIAGE','2025-06-02 13:01:53','EGUARNEROS','GENERAL',NULL,'SCHENKER INTERNATIONAL S.A. DE C.V.','CIUDAD DE MEXICO','','2',11654.541,'MXN',13766.904,11868.021,0,5,476.4,13.63,'NO','SI','13.630','CLIENTE ACTIVO','DALEON','ABALDERAS','EGUARNEROS',NULL,'','','',19.39,'2025-06-15 00:00:00','YES',NULL,NULL,NULL,75.409,0),(6471,'IN-LND-06471','2025-06-02 13:48:06','2025-06-05 16:53:41','ON-CARRIAGE','ON-CARRIAGE','2025-07-07 16:03:19','HMAYEN','GENERAL',NULL,'','','SHIPCO TRANSPORT INC, SAN JUAN','3',7280,'MXN',8773.254,7563.15,0,2,1161.18,3.253,'NO','SI','3.253','CLIENTE AGENTE','HMAYEN','HMAYEN','HMAYEN',NULL,'BARBARA L ALSINA','balsina@shipco.com','',19.33,'0000-00-00 00:00:00','WR','2025-07-07 00:00:00',NULL,NULL,55,0),(6472,'IN-LND-06472','2025-06-02 15:35:44','2025-06-02 15:36:07','ON-CARRIAGE','ON-CARRIAGE','2025-06-02 15:37:57','EGUARNEROS','GENERAL',NULL,'UPS SCS MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','',8572.48,'MXN',9665.874,8332.65,0,4,1772,7.2,'NO','SI','7.200','CLIENTE ACTIVO','NO ASIGNADO','ABALDERAS','EGUARNEROS',NULL,'Ruben Hernandez','rubenhernandez@ups.com','',19.39,'2025-06-15 00:00:00','YES',NULL,NULL,NULL,35,0),(6473,'OUT-LND-06473','2025-06-02 15:37:22','2025-06-02 18:12:00','PRE-CARRIAGE','PRE-CARRIAGE','2025-06-09 12:15:43','PRYDBERG','GENERAL',NULL,'SERCOGUAMEX S.A. DE C.V.','CIUDAD DE MEXICO','','2',4115.854,'MXN',4937.621,4256.57,0,2,450,1.288,'NO','SI','1.288','CLIENTE ACTIVO','NO ASIGNADO','PRYDBERG','PRYDBERG',NULL,'Nancy Gascon','pricingmx@sercogua.com','',19.39,'0000-00-00 00:00:00','NO',NULL,NULL,NULL,30,0),(6474,'IN-LND-06474','2025-06-02 16:34:24','2025-06-02 16:36:20','ON-CARRIAGE','ON-CARRIAGE','2025-06-02 16:37:12','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','3',13903.288,'MXN',15749.378,13577.05,0,10,3660,12.289,'NO','SI','12.289','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',19.39,'2025-06-15 00:00:00','YES',NULL,NULL,NULL,60,0),(6475,'IN-LND-06475','2025-06-02 16:45:34','2025-06-02 17:27:59','ON-CARRIAGE','ON-CARRIAGE','2025-07-02 01:25:29','EGUARNEROS','GENERAL',NULL,'UPS SCS MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','3',48681.898,'MXN',51577.411,44463.285,0,3,1398,2.868,'NO','SI','2.868','CLIENTE ACTIVO','NO ASIGNADO','ABALDERAS','EGUARNEROS',NULL,'Pilar Nava','pnava@ups.com','',19.39,'2025-06-15 00:00:00','WR','2025-06-02 00:00:00',NULL,NULL,51.434,0),(6477,'OUT-LND-06477','2025-06-02 21:13:18','2025-06-02 21:15:29','PRE-CARRIAGE','PRE-CARRIAGE','2025-06-02 21:19:17','EGUARNEROS','GENERAL',NULL,'CEVA FREIGHT MANAGEMENT MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','4',5445.53,'MXN',6314.785,5443.78,0,1,41,0.72,'NO','NO','0.720','CLIENTE ACTIVO','MCRUZ','DARROYO','EGUARNEROS',NULL,'Daniela Alvarez','Daniela.alvarez1@cevalogistics.com','',19.39,'2025-06-15 00:00:00','YES',NULL,'EXITATMDUB868187',NULL,30,0),(6478,'IN-LND-06478','2025-06-02 21:30:24','2025-06-02 21:32:27','ON-CARRIAGE','ON-CARRIAGE','2025-06-02 21:33:09','EGUARNEROS','GENERAL',NULL,'UPS SCS MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','2',4290.944,'MXN',5231.426,4509.85,0,3,1288,2.88,'NO','SI','2.880','CLIENTE ACTIVO','NO ASIGNADO','ABALDERAS','EGUARNEROS',NULL,'Pilar Nava','pnava@ups.com','',19.39,'2025-06-15 00:00:00','YES',NULL,NULL,NULL,35,0),(6479,'IN-LND-06479','2025-06-03 12:17:42','2025-06-04 12:41:51','ON-CARRIAGE','ON-CARRIAGE','2025-06-05 10:30:26','EGUARNEROS','GENERAL',NULL,'UPS SCS MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','2',2975.93,'MXN',3416.815,2945.53,0,1,116,0.195,'NO','SI','0.195','CLIENTE ACTIVO','NO ASIGNADO','ABALDERAS','EGUARNEROS',NULL,'Doris Rivera','drivera4@ups.com','',19.23,'2025-06-15 00:00:00','YES','2025-06-03 00:00:00',NULL,NULL,15,0),(6480,'OUT-LND-06480','2025-06-03 16:53:11','0000-00-00 00:00:00','PRE-CARRIAGE','PRE-CARRIAGE',NULL,'ALOPEZ','GENERAL',NULL,'TARIFA CLIENTE DIRECTO','CIUDAD DE MEXICO','','3',5555.2,'MXN',6623.565,5709.97,0,1,255,0.878,'NO','NO','0.878','CLIENTE ACTIVO','NO ASIGNADO','NO ASIGNADO','ALOPEZ',NULL,'','','',19.23,'2025-06-30 00:00:00','NEW',NULL,NULL,NULL,39,0),(6481,'OUT-LND-06481','2025-06-04 00:57:55','2025-06-04 00:58:04','PRE-CARRIAGE','PRE-CARRIAGE','2025-06-04 13:59:14','EGUARNEROS','GENERAL',NULL,'HELLMANN WORLDWIDE LOGISTICS S.A. DE C.V.','CIUDAD DE MEXICO','','4',6284.858,'MXN',7178.521,6188.38,0,5,3150,3.544,'NO','SI','3.544','CLIENTE ACTIVO','EREYNA','DARROYO','EGUARNEROS',NULL,'Elizabeth Chavez','Elizabeth.Chavez@hellmann.com','',19.23,'2025-06-30 00:00:00','YES',NULL,'EXITZLOSHG868181',NULL,30,0),(6482,'IN-LND-06482','2025-06-04 10:32:48','2025-06-04 11:52:01','ON-CARRIAGE','ON-CARRIAGE','2025-06-04 12:32:47','IMARIN','GENERAL',NULL,'IRE LOGISTICS S.A. DE C.V.','CIUDAD DE MEXICO','','3',4384.8,'MXN',5569.114,4800.96,0,4,1484,0.827,'NO','NO','1.484','CLIENTE ACTIVO','NO ASIGNADO','SGRACIDA','IMARIN',NULL,'MARLENE CABRERA','','',19.26,'0000-00-00 00:00:00','YES',NULL,NULL,NULL,46,0),(6483,'IN-LND-06483','2025-06-04 12:19:27','2025-07-07 20:07:39','ON-CARRIAGE','ON-CARRIAGE','2025-07-07 08:06:13','EGUARNEROS','GENERAL',NULL,'KINTETSU WORLD EXPRESS MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','3',0,'MXN',41938.408,36153.8,0,3,3000,27.153,'NO','NO','27.153','CLIENTE ACTIVO','NO ASIGNADO','DARROYO','EGUARNEROS',NULL,'Ivan Garcia','Ivana.Garcia@am.kwe.com','',19.23,'2025-06-15 00:00:00','NO','2025-06-13 00:00:00',NULL,NULL,60,0),(6484,'OUT-LND-06484','2025-06-04 12:35:07','2025-06-04 12:35:09','PRE-CARRIAGE','PRE-CARRIAGE','2025-06-04 12:37:57','EGUARNEROS','GENERAL',NULL,'GEODIS MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','2',0,'MXN',28995.94,24996.5,0,20,14860,12.76,'NO','SI','14.86','CLIENTE ACTIVO','EBERNABE','ABALDERAS','EGUARNEROS',NULL,'','','',19.23,'2025-06-30 00:00:00','YES',NULL,NULL,NULL,120,0),(6485,'OUT-LND-06485','2025-06-04 15:17:19','2025-06-04 15:17:21','PRE-CARRIAGE','PRE-CARRIAGE','2025-06-05 16:32:55','ALOPEZ','GENERAL',NULL,'TARIFA CLIENTE DIRECTO','CIUDAD DE MEXICO','','5',13504.96,'MXN',14880.944,12828.4,0,1,2600,1.56,'NO','SI','2.6','CLIENTE ACTIVO','NO ASIGNADO','NO ASIGNADO','ALOPEZ',NULL,'','','',19.26,'2025-06-14 00:00:00','YES',NULL,'EXITVERSJO868293',NULL,40,0),(6486,'IN-LND-06486','2025-06-04 15:23:57','2025-06-05 10:25:25','ON-CARRIAGE','ON-CARRIAGE','2025-06-05 11:08:32','EGUARNEROS','GENERAL',NULL,'UPS SCS MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','4',8713.23,'MXN',9582.087,8260.42,0,5,1422,3.909,'NO','SI','3.909','CLIENTE ACTIVO','NO ASIGNADO','ABALDERAS','EGUARNEROS',NULL,'Doris Rivera','drivera4@ups.com','',19.23,'2025-06-30 00:00:00','YES','2025-06-05 00:00:00',NULL,NULL,25,0),(6488,'IN-LND-06488','2025-06-04 16:26:27','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE','2025-06-04 16:29:35','IMARTINEZ','GENERAL',NULL,'LATIN AMERICA MERCKDO S.A. DE C.V.','CIUDAD DE MEXICO','','2',3988.32,'MXN',5361.983,4622.399,0,2,1039.2,2.88,'NO','SI','2.880','CLIENTE ACTIVO','EBERNABE','MAGONZALEZ','IMARTINEZ',NULL,'','','',19.26,'0000-00-00 00:00:00','YES',NULL,'TINTATMMTY2997.25',NULL,55.109,0),(6489,'OUT-LND-06489','2025-06-04 16:27:31','2025-06-04 16:29:35','PRE-CARRIAGE','PRE-CARRIAGE','2025-06-05 04:37:35','EGUARNEROS','GENERAL',NULL,'CH ROBINSON GLOBAL FORWARDING MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','3',0,'MXN',11260.7,9707.5,0,9,8370,7.344,'NO','SI','8.37','CLIENTE ACTIVO','LRUBIO','ABALDERAS','EGUARNEROS',NULL,'Jatziry Uribe','Jatziry.Uribe@chrobinson.com','',19.23,'2025-06-30 00:00:00','NO','2025-06-05 00:00:00',NULL,NULL,65,0),(6490,'IN-LND-06490','2025-06-05 13:14:00','2025-06-05 13:14:44','ON-CARRIAGE','ON-CARRIAGE','2025-07-02 01:25:26','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','4',0,'MXN',8769.252,7559.7,0,2,186,0.598,'NO','NO','0.598','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',19.19,'2025-06-30 00:00:00','WR','2025-06-13 00:00:00',NULL,NULL,30,0),(6491,'IN-LND-06491','2025-06-05 13:23:37','2025-06-05 13:24:13','ON-CARRIAGE','ON-CARRIAGE','2025-07-02 01:25:24','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','5',11230.688,'MXN',12744.804,10986.9,0,1,160,0.9,'NO','SI','0.900','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',19.19,'2025-06-30 00:00:00','WR','2025-06-13 00:00:00',NULL,NULL,50,0),(6492,'IN-LND-06492','2025-06-05 13:46:02','2025-06-05 15:30:06','ON-CARRIAGE','ON-CARRIAGE','2025-06-05 05:37:32','EGUARNEROS','GENERAL',NULL,'UPS SCS MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','2',2990.4,'MXN',3542.408,3053.8,0,1,134,0.364,'NO','SI','0.364','CLIENTE ACTIVO','NO ASIGNADO','ABALDERAS','EGUARNEROS',NULL,'Doris Rivera','drivera4@ups.com','',19.19,'2025-06-30 00:00:00','NO','2025-06-05 00:00:00',NULL,NULL,20,0),(6493,'OUT-LND-06493','2025-06-05 18:23:52','2025-06-05 18:25:38','PRE-CARRIAGE','PRE-CARRIAGE','2025-06-09 13:55:26','EGUARNEROS','GENERAL',NULL,'HELLMANN WORLDWIDE LOGISTICS S.A. DE C.V.','CIUDAD DE MEXICO','','4',9270.654,'MXN',10362.609,8933.284,0,1,181,1.196,'NO','NO','1.196','CLIENTE ACTIVO','EREYNA','DARROYO','EGUARNEROS',NULL,'Elizabeth Chavez','Elizabeth.Chavez@hellmann.com','',19.19,'2025-06-30 00:00:00','YES',NULL,'EXITATMHAM868386',NULL,34.18,0),(6494,'IN-LND-06494','2025-06-06 10:23:25','2025-06-06 10:24:09','ON-CARRIAGE','ON-CARRIAGE',NULL,'IMARIN','GENERAL',NULL,'ENDEMICA MEDICINA ESTETICA Y SPA S. DE R.L. DE C.V.','ESTADO DE MEXICO','','',8253.28,'MXN',9393.054,8097.46,0,3,889,6.067,'NO','SI','6.067','CLIENTE ACTIVO','NO ASIGNADO','NO ASIGNADO','IMARIN',NULL,'','','',19.17,'2025-06-30 00:00:00','FUP','2025-06-12 00:00:00',NULL,NULL,38,0),(6495,'OUT-LND-06495','2025-06-06 12:30:05','2025-06-06 12:31:25','PRE-CARRIAGE','PRE-CARRIAGE','2025-07-02 01:25:22','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','3',4938.002,'MXN',5559.103,4792.33,0,3,1350,3.01,'NO','SI','3.010','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',19.17,'2025-06-30 00:00:00','WR','2025-06-13 00:00:00',NULL,NULL,20,0),(6496,'IN-LND-06496','2025-06-06 12:48:03','2025-06-06 12:52:58','ON-CARRIAGE','ON-CARRIAGE','2025-07-02 01:25:21','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','2',4823.549,'MXN',5440.562,4690.14,0,1,80,0.48,'NO','SI','0.480','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',19.17,'2025-06-30 00:00:00','WR','2025-06-06 00:00:00',NULL,NULL,20,0),(6497,'IN-LND-06497','2025-06-06 16:07:59','2025-06-06 16:09:32','ON-CARRIAGE','ON-CARRIAGE','2025-07-02 01:25:19','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','3',6441.982,'MXN',7339.169,6326.87,0,3,1056,3.687,'NO','SI','3.687','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',19.17,'2025-06-30 00:00:00','WR','2025-06-13 00:00:00',NULL,NULL,30,0),(6498,'OUT-LND-06498','2025-06-09 12:05:47','0000-00-00 00:00:00','PRE-CARRIAGE','PRE-CARRIAGE','2025-06-16 10:54:38','ALOPEZ','GENERAL',NULL,'TARIFA CLIENTE DIRECTO','CIUDAD DE MEXICO','','5',22487.36,'MXN',23956.204,20651.9,0,2,2500,2.22,'NO','SI','2.5','CLIENTE ACTIVO','NO ASIGNADO','NO ASIGNADO','ALOPEZ',NULL,'','','',19.13,'2025-06-21 00:00:00','YES',NULL,'EXITVERHAI868417',NULL,30,0),(6499,'IN-LND-06499','2025-06-09 13:26:13','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE','2025-06-09 13:27:32','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','2',9764.586,'MXN',11317.305,9756.297,0,10,2033,12.082,'NO','SI','12.082','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',19.13,'2025-06-30 00:00:00','YES',NULL,NULL,NULL,54.256,0),(6500,'IN-LND-06500','2025-06-10 15:37:05','2025-06-10 15:37:35','ON-CARRIAGE','ON-CARRIAGE','2025-07-02 01:25:18','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','3',0,'MXN',19857.53,17118.56,0,1,1950,14.129,'NO','NO','14.129','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',19.06,'2025-06-30 00:00:00','WR','2025-06-13 00:00:00',NULL,NULL,150,0),(6501,'IN-LND-06501','2025-06-10 17:15:04','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE',NULL,'ALOPEZ','GENERAL',NULL,'TARIFA CLIENTE DIRECTO','CIUDAD DE MEXICO','','3',11205.6,'MXN',12711.28,10958,0,5,2800,11.151,'NO','SI','11.151','CLIENTE ACTIVO','NO ASIGNADO','NO ASIGNADO','ALOPEZ',NULL,'','','',19.06,'2025-06-30 00:00:00','NEW',NULL,NULL,NULL,50,0),(6502,'OUT-LND-06502','2025-06-10 17:20:29','2025-06-10 17:20:47','PRE-CARRIAGE','PRE-CARRIAGE','2025-06-10 17:22:22','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','3',6678.918,'MXN',7580.739,6535.12,0,3,1029,1.413,'NO','SI','1.413','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',19.06,'2025-06-30 00:00:00','YES',NULL,'EXITVERANR868456',NULL,30,0),(6503,'OUT-LND-06503','2025-06-10 22:40:22','2025-06-10 22:41:33','PRE-CARRIAGE','PRE-CARRIAGE','2025-07-02 01:25:16','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','4',6618.293,'MXN',7186.304,6195.09,0,1,84.5,0.569,'NO','SI','0.569','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',19.06,'2025-06-30 00:00:00','WR','2025-06-10 00:00:00',NULL,NULL,15,0),(6504,'OUT-LND-06504','2025-06-11 15:25:28','0000-00-00 00:00:00','PRE-CARRIAGE','PRE-CARRIAGE','2025-06-12 02:01:07','EGUARNEROS','GENERAL',NULL,'KERRY LOGISTICS MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','4',11148.032,'MXN',12001.505,10346.125,0,5,2388.6,5.4,'NO','NO','5.400','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Jaqueline Vazquez','Jacqueline.Vazquez@kln.com','',19.05,'2025-06-30 00:00:00','NO',NULL,NULL,NULL,20.605,0),(6505,'LOC-LND-06505','2025-06-12 10:28:18','2025-06-12 10:28:56','SERVICIO LOCAL','SERVICIO LOCAL','2025-06-13 01:41:01','EGUARNEROS','GENERAL',NULL,'NIPPON EXPRESS DE MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','5',8518.574,'MXN',9628.803,8300.692,0,1,70,0.726,'NO','SI','0.726','CLIENTE ACTIVO','LRUBIO','ABALDERAS','EGUARNEROS',NULL,'Catalina Guajardo','Catalina.Guajardo@nipponexpress.com','',18.88,'2025-06-30 00:00:00','NO',NULL,NULL,NULL,36.802,0),(6506,'IN-LND-06506','2025-06-12 10:38:01','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE','2025-07-02 01:25:12','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','3',4111.296,'MXN',4915.152,4237.2,0,1,103,0.209,'NO','SI','0.209','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',18.88,'2025-06-30 00:00:00','WR','2025-06-13 00:00:00',NULL,NULL,30,0),(6507,'IN-LND-06507','2025-06-12 11:58:47','2025-06-12 11:59:30','ON-CARRIAGE','ON-CARRIAGE','2025-07-02 01:25:10','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','5',6176.722,'MXN',7163.847,6175.73,0,1,700,1.454,'NO','SI','1.454','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',18.88,'2025-06-30 00:00:00','WR','2025-06-13 00:00:00',NULL,NULL,35,0),(6508,'IN-LND-06508','2025-06-12 15:11:18','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE','2025-06-13 10:26:54','IMARIN','GENERAL',NULL,'CLESE INTERNACIONAL Y ASOCIADOS S.C.','CIUDAD DE MEXICO','','3',4256,'MXN',4846.016,4177.6,0,1,450,1,'NO','NO','1.000','CLIENTE ACTIVO','EREYNA','RSANDOVAL','IMARIN',NULL,'GABRIELA SAYAGO','','',18.88,'2025-06-30 00:00:00','YES','2025-06-12 00:00:00','TINTZLOMEX3151.25',NULL,20,0),(6509,'IN-LND-06509','2025-06-12 16:59:19','2025-06-12 16:59:19','ON-CARRIAGE','ON-CARRIAGE','2025-07-02 01:25:09','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','3',0,'MXN',25289.392,21801.2,0,8,3358,18.48,'NO','SI','18.480','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',18.88,'2025-06-30 00:00:00','WR','2025-06-13 00:00:00',NULL,NULL,90,0),(6510,'IN-LND-06510','2025-06-13 10:42:05','2025-06-13 10:43:22','ON-CARRIAGE','ON-CARRIAGE','2025-07-02 01:25:07','EGUARNEROS','GENERAL',NULL,'CWL MEXICO S. DE R.L. DE C.V.','CIUDAD DE MEXICO','','3',14191.016,'MXN',15695.294,13530.426,0,1,635,0.829,'SI','NO','0.829','CLIENTE ACTIVO','DALEON','DARROYO','EGUARNEROS',NULL,'Zulema Romero','zulema.romero@craneww.com','',18.91,'2025-06-30 00:00:00','WR','2025-06-13 00:00:00',NULL,NULL,45.472,0),(6511,'IN-LND-06511','2025-06-13 11:12:59','2025-06-13 11:13:03','ON-CARRIAGE','ON-CARRIAGE','2025-06-13 11:16:15','EGUARNEROS','GENERAL',NULL,'UPS SCS MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','2',2990.4,'MXN',3489.847,3008.489,0,1,134,0.364,'NO','SI','0.364','CLIENTE ACTIVO','NO ASIGNADO','ABALDERAS','EGUARNEROS',NULL,'Doris Rivera','drivera4@ups.com','',18.91,'2025-06-30 00:00:00','YES',NULL,NULL,NULL,17.9,0),(6512,'OUT-LND-06512','2025-06-13 13:13:20','2025-06-13 13:14:58','PRE-CARRIAGE','PRE-CARRIAGE','2025-06-17 16:49:57','EGUARNEROS','GENERAL',NULL,'CP TRANSPORTS SPEDITIONS S. DE R.L. DE C.V.','PUEBLA','','4',5826.341,'MXN',6363.458,5485.74,0,1,69.095,0.394,'NO','NO','0.394','CLIENTE ACTIVO','NO ASIGNADO','DARROYO','EGUARNEROS',NULL,'Adriana Miranda','Adriana.Miranda@cargo-partner.com','',18.91,'2025-06-30 00:00:00','YES',NULL,'EXITATMHAM868600',NULL,15,0),(6513,'IN-LND-06513','2025-06-13 15:26:53','2025-06-13 15:38:31','ON-CARRIAGE','ON-CARRIAGE','2025-06-13 15:39:04','DDOMINGUEZ','GENERAL',NULL,'KCC MEXICO TRANSPORT SYSTEM S.A. DE C.V.','CIUDAD DE MEXICO','','',4369.68,'MXN',5374.231,4632.958,0,1,819,1.152,'NO','NO','1.152','CLIENTE ACTIVO','DALEON','MAGONZALEZ','DDOMINGUEZ',NULL,'Jesús Zaragoza','kccmex@kccusa.com','',18.91,'0000-00-00 00:00:00','YES','2025-06-13 00:00:00',NULL,NULL,38.681,0),(6514,'OUT-LND-06514','2025-06-13 15:39:40','2025-06-13 15:40:03','PRE-CARRIAGE','PRE-CARRIAGE','2025-06-15 23:31:29','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','3',6702.192,'MXN',7818.98,6740.5,0,1,500,0.719,'NO','NO','0.719','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',18.91,'2025-06-30 00:00:00','YES',NULL,'EXITVERCTG868519',NULL,40,0),(6515,'IN-LND-06515','2025-06-13 16:40:34','2025-06-13 16:40:43','ON-CARRIAGE','ON-CARRIAGE','2025-07-01 18:53:21','IMARIN','GENERAL',NULL,'ROYAL CARGO 5GP S.A. DE C.V.','GUADALAJARA','','3',4389.28,'MXN',4984.752,4297.2,0,1,584,0.403,'NO','NO','0.584','CLIENTE ACTIVO','EBERNABE','NBARRERA','IMARIN',NULL,'NICKY CALZADA','','',18.91,'0000-00-00 00:00:00','WR',NULL,NULL,NULL,20,0),(6516,'IN-LND-06516','2025-06-13 16:58:33','2025-06-17 17:04:17','ON-CARRIAGE','ON-CARRIAGE','2025-06-17 17:00:21','IMARIN','GENERAL',NULL,'ALPI LTA MEXICO S.A. DE C.V.','GUANAJUATO','','4',10640,'MXN',11063.871,9537.82,0,125,1375,3.684,'NO','SI','3.684','CLIENTE ACTIVO','LRUBIO','DILOPEZ','IMARIN',NULL,'ABDIEL AGUILAR','','',18.91,'0000-00-00 00:00:00','YES',NULL,NULL,NULL,0,0),(6517,'IN-LND-06517','2025-06-16 12:29:19','2025-06-16 12:29:43','ON-CARRIAGE','ON-CARRIAGE','2025-07-02 01:25:06','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','3',4294.315,'MXN',5326.036,4591.41,0,30,210,1.211,'NO','SI','1.211','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',18.93,'2025-06-30 00:00:00','WR','2025-07-02 00:00:00',NULL,NULL,40,0),(6518,'IN-LND-06518','2025-06-16 15:10:49','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE','2025-07-02 01:25:04','EGUARNEROS','GENERAL',NULL,'GEODIS MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','5',8994.138,'MXN',10222.211,8812.251,0,4,474,2.136,'NO','SI','2.136','CLIENTE ACTIVO','EBERNABE','ABALDERAS','EGUARNEROS',NULL,'Rodrigo Arevalo','rodrigo.arevalo@geodis.com','',18.93,'2025-06-30 00:00:00','WR','2025-06-16 00:00:00',NULL,NULL,41.298,0),(6519,'IN-LND-06519','2025-06-16 18:12:11','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE','2025-06-17 11:37:40','IMARTINEZ','GENERAL',NULL,'SIMPLY ORANGE S.A. DE C.V.','QUERETARO','','',0,'MXN',0,0,0,1,225,1.92,'NO','SI','1.920','CLIENTE ACTIVO','LRUBIO','DILOPEZ','IMARTINEZ',NULL,'','','',18.93,'0000-00-00 00:00:00','YES',NULL,'TINTVERAPZ3209.25',NULL,0,0),(6520,'OUT-LND-06520','2025-06-17 11:41:14','2025-06-17 11:43:05','PRE-CARRIAGE','PRE-CARRIAGE','2025-06-17 11:45:12','EGUARNEROS','GENERAL',NULL,'UPS SCS MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','2',9327.752,'MXN',10757.666,9273.85,0,5,1500,9.377,'NO','SI','9.377','CLIENTE ACTIVO','NO ASIGNADO','ABALDERAS','EGUARNEROS',NULL,'','','',18.91,'2025-06-30 00:00:00','YES',NULL,'EXITATMMIL868623',NULL,50,0),(6521,'OUT-LND-06521','2025-06-17 15:44:06','2025-06-17 16:54:14','PRE-CARRIAGE','PRE-CARRIAGE','2025-06-18 19:42:33','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','3',7006.955,'MXN',7942.208,6846.731,0,1,342,1.252,'NO','NO','1.252','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',18.91,'2025-06-30 00:00:00','YES','2025-06-17 00:00:00','EXITZLOLCH868706',NULL,31.228,0),(6522,'IN-LND-06522','2025-06-18 10:06:33','2025-06-20 19:57:14','ON-CARRIAGE','ON-CARRIAGE','2025-07-01 06:36:27','DDOMINGUEZ','GENERAL',NULL,'EXPLORER CARGO S.A. DE C.V.','CIUDAD DE MEXICO','','2',3564.064,'MXN',3911.636,3372.1,0,1,100,1.101,'NO','NO','1.101','CLIENTE ACTIVO','LRUBIO','NO ASIGNADO','DDOMINGUEZ',NULL,'Naomi Silva','trafico2@explorercargo.com','',18.99,'2025-06-30 00:00:00','NO','2025-06-23 00:00:00',NULL,NULL,10,0),(6523,'IN-LND-06523','2025-06-18 13:50:31','2025-06-18 14:31:47','ON-CARRIAGE','ON-CARRIAGE',NULL,'IMARIN','GENERAL',NULL,'IRE LOGISTICS S.A. DE C.V.','CIUDAD DE MEXICO','','3',9873.92,'MXN',10887.412,9385.7,0,3,1599,3.993,'NO','NO','3.993','CLIENTE ACTIVO','NO ASIGNADO','SGRACIDA','IMARIN',NULL,'STELLA WANG','','',18.99,'0000-00-00 00:00:00','FUP','2025-07-01 00:00:00',NULL,NULL,30,0),(6524,'OUT-LND-06524','2025-06-18 19:27:43','0000-00-00 00:00:00','PRE-CARRIAGE','PRE-CARRIAGE','2025-06-18 19:30:47','EGUARNEROS','GENERAL',NULL,'SGL TRANSGROUP DE MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','4',12146.893,'MXN',13682.13,11794.94,0,10,2594,7.565,'NO','SI','7.565','CLIENTE ACTIVO','LRUBIO','ABALDERAS','EGUARNEROS',NULL,'Lizette Martinez','LizeM@scangl.com','',18.99,'2025-06-30 00:00:00','YES',NULL,'EXITATMGOT868607',NULL,50,0),(6525,'OUT-LND-06525','2025-06-20 15:52:26','2025-06-20 15:52:36','PRE-CARRIAGE','PRE-CARRIAGE','2025-07-02 01:25:03','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','2',0,'MXN',30736.218,26496.74,0,7,829,20.859,'NO','SI','20.859','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',19.09,'2025-06-30 00:00:00','WR','2025-07-02 00:00:00',NULL,NULL,250,0),(6526,'IN-LND-06526','2025-06-23 12:48:46','2025-06-23 12:53:32','ON-CARRIAGE','ON-CARRIAGE','2025-06-23 12:53:42','DDOMINGUEZ','GENERAL',NULL,'SISTEMAS DE FLETES INTERNACIONALES S.A. DE C.V.','VERACRUZ','','2',2996,'MXN',3769.42,3249.5,0,4,103,0.48,'NO','SI','0.480','CLIENTE ACTIVO','NO ASIGNADO','JLPRIETO','DDOMINGUEZ',NULL,'Isabel Vázquez','isabel.vazquez@vitransgroup.com','',19.15,'2025-06-30 00:00:00','YES','2025-06-23 00:00:00',NULL,NULL,30,0),(6527,'OUT-LND-06527','2025-06-23 13:27:20','2025-06-23 13:32:48','PRE-CARRIAGE','PRE-CARRIAGE','2025-07-02 01:25:01','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','3',0,'MXN',14695.831,12668.82,0,7,7000,10.164,'NO','NO','10.164','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',19.15,'2025-06-30 00:00:00','WR','2025-07-02 00:00:00',NULL,NULL,100,0),(6528,'IN-LND-06528','2025-06-23 16:28:30','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE','2025-06-23 16:31:14','RDOMINGUEZ','GENERAL',NULL,'MEXICO AIR CARGO SYSTEMS S.A. DE C.V.','CIUDAD DE MEXICO','','',0,'MXN',14895.908,12841.3,0,7,1068.004,12.407,'NO','SI','12.407','CLIENTE ACTIVO','MCRUZ','PGIESS','RDOMINGUEZ',NULL,'','','',19.15,'0000-00-00 00:00:00','YES',NULL,NULL,NULL,45,0),(6529,'OUT-LND-06529','2025-06-23 17:13:34','2025-06-23 17:14:43','PRE-CARRIAGE','PRE-CARRIAGE','2025-06-23 17:21:07','EGUARNEROS','GENERAL',NULL,'SGL TRANSGROUP DE MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','4',0,'MXN',15703.004,13537.072,0,1,320,1.059,'NO','SI','1.059','CLIENTE ACTIVO','LRUBIO','ABALDERAS','EGUARNEROS',NULL,'Lizette Martinez','LizeM@scangl.com','',19.15,'2025-06-30 00:00:00','YES',NULL,'EXITVERGOT868665',NULL,62.515,0),(6530,'IN-LND-06530','2025-06-24 01:42:44','2025-06-25 01:20:10','ON-CARRIAGE','ON-CARRIAGE','2025-07-02 01:24:59','EGUARNEROS','GENERAL',NULL,'LOGWIN AIR OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','1',0,'MXN',45768.509,39455.611,0,2,3548,1.435,'NO','NO','3.548','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Ximena Rodriguez','Ximena.Rodriguez@logwin-logistics.com','',19.15,'2025-06-30 00:00:00','WR','2025-06-25 00:00:00',NULL,NULL,154.34,0),(6531,'OUT-LND-06531','2025-06-24 11:26:46','0000-00-00 00:00:00','PRE-CARRIAGE','PRE-CARRIAGE','2025-07-07 17:13:36','PRYDBERG','GENERAL',NULL,'ZACH LOGISTICS S.A. DE C.V.','CIUDAD DE MEXICO','','4',0,'MXN',28754.718,24788.55,0,9,7200,16.918,'NO','SI','16.918','CLIENTE ACTIVO','MCRUZ','PRYDBERG','PRYDBERG',NULL,'Sergio Chavero','schavero@zach.mx','',19.15,'2025-07-31 00:00:00','WR',NULL,NULL,NULL,25,0),(6532,'IN-LND-06532','2025-06-24 13:03:36','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE','2025-06-24 13:20:35','IMARTINEZ','GENERAL',NULL,'AFIECSA LOGISTICS','S.A. DE C.V.','','3',4915.68,'MXN',6201.94,5346.5,0,52,895.5,1.76,'NO','SI','1.760','CLIENTE ACTIVO','NO ASIGNADO','JANGELES','IMARTINEZ',NULL,'','','',19.15,'0000-00-00 00:00:00','YES',NULL,'TINTZLOAPZ3332.25',NULL,50,0),(6533,'IN-LND-06533','2025-06-24 15:13:25','2025-06-24 15:17:42','ON-CARRIAGE','ON-CARRIAGE','2025-07-02 01:24:58','EGUARNEROS','GENERAL',NULL,'HILLEBRAND GORI MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','2',6524.078,'MXN',7277,6273.276,0,1,1000,1.728,'NO','NO','1.728','CLIENTE ACTIVO','NO ASIGNADO','DARROYO','EGUARNEROS',NULL,'Ivan Treviño','ivan.trevino@hillebrandgori.com','',19.15,'2025-07-15 00:00:00','WR','2025-06-24 00:00:00',NULL,NULL,23.405,0),(6534,'IN-LND-06534','2025-06-24 15:38:57','2025-06-24 16:20:55','ON-CARRIAGE','ON-CARRIAGE','2025-06-25 09:33:11','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','3',0,'MXN',25469.503,21956.468,0,9,2259,21.74,'NO','SI','21.740','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',19.15,'2025-07-15 00:00:00','NO','2025-06-24 00:00:00',NULL,NULL,158.849,0),(6535,'OUT-LND-06535','2025-06-25 00:00:37','2025-06-25 00:00:49','PRE-CARRIAGE','PRE-CARRIAGE','2025-06-25 00:05:12','EGUARNEROS','GENERAL',NULL,'SCHENKER INTERNATIONAL S.A. DE C.V.','CIUDAD DE MEXICO','','5',55440,'MXN',60322.503,52002.158,0,12,3570,22.865,'NO','NO','22.865','CLIENTE ACTIVO','DALEON','ABALDERAS','EGUARNEROS',NULL,'','','',19.15,'2025-06-30 00:00:00','YES',NULL,NULL,NULL,130.661,0),(6536,'IN-LND-06536','2025-06-25 12:36:15','2025-07-15 11:09:02','ON-CARRIAGE','ON-CARRIAGE','2025-06-26 11:07:25','DDOMINGUEZ','GENERAL',NULL,'DESCOMAR S.A. DE C.V.','CIUDAD DE MEXICO','','',3460.8,'MXN',4136.27,3565.75,0,1,236,0.169,'NO','SI','0.236','CLIENTE ACTIVO','DALEON','JLPRIETO','DDOMINGUEZ',NULL,'Leonel Medina','pricing1@descomar.com.mx','',19.03,'2025-07-31 00:00:00','YES','2025-06-26 00:00:00',NULL,NULL,25,0),(6537,'IN-LND-06537','2025-06-25 15:56:54','2025-06-25 16:34:14','ON-CARRIAGE','ON-CARRIAGE','2025-07-03 20:08:06','DDOMINGUEZ','GENERAL',NULL,'KCC MEXICO TRANSPORT SYSTEM S.A. DE C.V.','CIUDAD DE MEXICO','','1',42560,'MXN',45183.74,38951.5,0,3,59,0.18,'NO','SI','0.180','CLIENTE ACTIVO','DALEON','MAGONZALEZ','DDOMINGUEZ',NULL,'Heejin Jang','kccmex@kccusa.com','',19.03,'2025-06-30 00:00:00','WR','2025-07-01 00:00:00',NULL,NULL,50,0),(6538,'OUT-LND-06538','2025-06-26 14:01:05','2025-06-26 14:01:21','PRE-CARRIAGE','PRE-CARRIAGE','2025-06-30 12:14:53','EGUARNEROS','GENERAL',NULL,'CP TRANSPORTS SPEDITIONS S. DE R.L. DE C.V.','PUEBLA','','4',5826.341,'MXN',6621.995,5708.616,0,1,122.2,0.547,'NO','NO','0.547','CLIENTE ACTIVO','NO ASIGNADO','DARROYO','EGUARNEROS',NULL,'Adriana Miranda','Adriana.Miranda@cargo-partner.com','',18.92,'2025-07-15 00:00:00','YES',NULL,'EXITATMHAM868903',NULL,26.772,0),(6539,'OUT-LND-06539','2025-06-26 15:36:35','2025-06-26 15:36:40','PRE-CARRIAGE','PRE-CARRIAGE','2025-07-02 21:52:32','IMARTINEZ','GENERAL',NULL,'Gruas Industriales CMOR','','','3',3152.8,'MXN',4801.704,4139.4,0,1,300,0.7,'NO','SI','0.700','CLIENTE PROSPECTO','NO ASIGNADO','NO ASIGNADO','IMARTINEZ',NULL,'','','',18.92,'0000-00-00 00:00:00','YES',NULL,NULL,NULL,70,0),(6540,'IN-LND-06540','2025-06-27 17:45:46','2025-06-30 09:55:00','ON-CARRIAGE','ON-CARRIAGE','2025-06-30 10:00:25','EGUARNEROS','GENERAL',NULL,'NEWMAN INTERNATIONAL S.A. DE C.V.','MONTERREY','','3',8922.29,'MXN',9350.549,8060.818,0,2,235,4.477,'NO','NO','4.477','CLIENTE ACTIVO','NO ASIGNADO','SHURTADO','EGUARNEROS',NULL,'Jorge de Angel Puga','jorgepuga@newman.mx','',18.89,'2025-07-14 00:00:00','YES',NULL,'TINTZLOAPD3399.25',NULL,5.002,0),(6541,'IN-LND-06541','2025-06-30 12:20:00','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE','2025-06-30 12:23:18','RDOMINGUEZ','GENERAL',NULL,'MEXICO AIR CARGO SYSTEMS S.A. DE C.V.','CIUDAD DE MEXICO','','',0,'MXN',30619.186,26395.85,0,11,1768.8,27.192,'NO','SI','27.192','CLIENTE ACTIVO','MCRUZ','PGIESS','RDOMINGUEZ',NULL,'','','',18.85,'0000-00-00 00:00:00','YES',NULL,'TINTZLOMTY3406.25',NULL,21,0),(6542,'OUT-LND-06542','2025-06-30 18:05:27','2025-07-01 13:16:47','PRE-CARRIAGE','PRE-CARRIAGE','2025-06-30 18:07:05','EGUARNEROS','GENERAL',NULL,'HELLMANN WORLDWIDE LOGISTICS S.A. DE C.V.','CIUDAD DE MEXICO','','2',6661.099,'MXN',7351.493,6337.494,0,2,455.2,2.987,'NO','NO','2.987','CLIENTE ACTIVO','EREYNA','DARROYO','EGUARNEROS',NULL,'','','',18.85,'2025-07-15 00:00:00','YES',NULL,'EXITZLOSAI868916',NULL,20.6941,0),(6543,'OUT-LND-06543','2025-07-01 16:36:01','2025-07-01 16:36:03','PRE-CARRIAGE','PRE-CARRIAGE','2025-07-01 16:37:22','EGUARNEROS','GENERAL',NULL,'HELLMANN WORLDWIDE LOGISTICS S.A. DE C.V.','CIUDAD DE MEXICO','','2',4808.44,'MXN',5635.454,4858.15,0,1,500,1.2,'NO','NO','1.200','CLIENTE ACTIVO','EREYNA','DARROYO','EGUARNEROS',NULL,'','','',18.83,'2025-07-14 00:00:00','YES',NULL,'EXITZLOSAI868931',NULL,30,0),(6544,'IN-LND-06544','2025-07-01 18:47:06','2025-07-02 23:16:53','ON-CARRIAGE','ON-CARRIAGE','2025-07-02 12:04:29','IMARIN','GENERAL',NULL,'CLESE INTERNACIONAL Y ASOCIADOS S.C.','CIUDAD DE MEXICO','','3',8137.92,'MXN',9302.272,8019.2,0,2,540,5.151,'NO','NO','5.151','CLIENTE ACTIVO','EREYNA','RSANDOVAL','IMARIN',NULL,'GABRIELA SAYAGO','','',18.83,'2025-07-31 00:00:00','YES',NULL,NULL,NULL,40,0),(6545,'IN-LND-06545','2025-07-02 09:26:38','2025-07-02 09:26:44','ON-CARRIAGE','ON-CARRIAGE','2025-07-02 09:45:44','IMARIN','GENERAL',NULL,'IRE LOGISTICS S.A. DE C.V.','CIUDAD DE MEXICO','','1',47040,'MXN',49808.66,42938.5,0,1,2500,13.225,'NO','SI','13.225','CLIENTE ACTIVO','NO ASIGNADO','SGRACIDA','IMARIN',NULL,'JOUSE LEE','','',18.77,'2025-07-31 00:00:00','YES',NULL,'TINTZLOGLP3653.25',NULL,50,0),(6546,'IN-LND-06546','2025-07-02 12:24:14','2025-07-02 15:51:34','ON-CARRIAGE','ON-CARRIAGE','2025-07-21 10:19:34','PRYDBERG','GENERAL',NULL,'SEGROVE INTERNACIONAL S.A. DE C.V.','CIUDAD DE MEXICO','','2',3237.08,'MXN',3897.02,3359.5,0,1,73,0.48,'NO','NO','0.480','CLIENTE ACTIVO','EREYNA','PRYDBERG','PRYDBERG',NULL,'Antonio Hernandez','antonio.hernandez@segrove.com','',18.77,'2025-07-31 00:00:00','WR',NULL,NULL,NULL,25,0),(6547,'IN-LND-06547','2025-07-02 12:36:42','2025-07-02 12:45:01','ON-CARRIAGE','ON-CARRIAGE','2025-07-02 12:49:33','IMARIN','GENERAL',NULL,'CLESE INTERNACIONAL Y ASOCIADOS S.C.','CIUDAD DE MEXICO','','3',10843.84,'MXN',11731.904,10113.71,0,4,2524,6.776,'NO','NO','6.776','CLIENTE ACTIVO','EREYNA','JLPRIETO','IMARIN',NULL,'GABRIELA SAYAGO','','',18.77,'2025-07-31 00:00:00','YES',NULL,'TINTZLOIXP3457.25',NULL,23,0),(6548,'OUT-LND-06548','2025-07-02 19:35:52','2025-07-03 11:34:19','PRE-CARRIAGE','PRE-CARRIAGE','2025-07-03 11:35:16','DDOMINGUEZ','GENERAL',NULL,'RISH S.A. DE C.V.','ESTADO DE MEXICO','','4',10273.939,'MXN',12382.722,10674.76,0,3,1368.8,4.32,'NO','NO','4.320','CLIENTE ACTIVO','NO ASIGNADO','NO ASIGNADO','DDOMINGUEZ',NULL,'Jennifer Dolores Resillas Lievanos','jenifferr@rish.com.mx','',18.77,'2025-07-31 00:00:00','YES','2025-07-03 00:00:00','EXITZLOGYE868972',NULL,80,0),(6549,'OUT-LND-06549','2025-07-03 12:05:13','0000-00-00 00:00:00','PRE-CARRIAGE','PRE-CARRIAGE','2025-07-03 13:42:03','HMAYEN','GENERAL',NULL,'','','ALLINK TRANSPORTES INTERNACIONAIS, SANTOS','3',4654.72,'MXN',6234.71,5374.75,0,1,3.78,0.042,'NO','SI','0.042','CLIENTE AGENTE','HMAYEN','HMAYEN','HMAYEN',NULL,'MARZIO','MARZIO.GARCIA@INTERTEAM.COM.MX','',18.75,'0000-00-00 00:00:00','YES',NULL,'EXITVERSSZ869068',NULL,65,0),(6550,'IN-LND-06550','2025-07-03 15:36:30','2025-07-03 15:37:54','ON-CARRIAGE','ON-CARRIAGE',NULL,'EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','3',0,'MXN',12851.176,11078.6,0,6,8223,5.95,'NO','SI','8.223','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',18.75,'2025-07-31 00:00:00','FUP','2025-07-04 00:00:00',NULL,NULL,70,0),(6551,'IN-LND-06551','2025-07-04 11:44:17','2025-07-04 11:44:50','ON-CARRIAGE','ON-CARRIAGE',NULL,'EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','3',7508.01,'MXN',8209.297,7076.98,0,4,1443,4.916,'NO','SI','4.916','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',18.67,'2025-07-31 00:00:00','FUP','2025-07-06 00:00:00',NULL,NULL,20,0),(6552,'IN-LND-06552','2025-07-04 16:39:19','2025-07-07 12:20:18','ON-CARRIAGE','ON-CARRIAGE','2025-07-15 13:53:41','EGUARNEROS','GENERAL',NULL,'UPS SCS MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','2',9523.069,'MXN',10729.466,9249.54,0,20,2180,10.476,'NO','SI','10.476','CLIENTE ACTIVO','NO ASIGNADO','ABALDERAS','EGUARNEROS',NULL,'Doris','','',18.67,'2025-07-31 00:00:00','WR','2025-07-04 00:00:00',NULL,NULL,40,0),(6553,'LOC-LND-06553','2025-07-04 16:54:20','0000-00-00 00:00:00','SERVICIO LOCAL','SERVICIO LOCAL',NULL,'CMANZANO','GENERAL',NULL,'GLOBSTEP','','','5',26007.296,'MXN',28018.988,24154.3,0,2,1840,2.16,'NO','SI','2.160','CLIENTE PROSPECTO','NO ASIGNADO','NO ASIGNADO','CMANZANO',NULL,'','','',18.67,'0000-00-00 00:00:00','NEW',NULL,NULL,NULL,50,0),(6554,'LOC-LND-06554','2025-07-04 17:38:01','0000-00-00 00:00:00','SERVICIO LOCAL','SERVICIO LOCAL',NULL,'CMANZANO','GENERAL',NULL,'GLOBALSTEP','','','2',14767.76,'MXN',16378.04,14119,0,10,2741.24,14.903,'NO','SI','14.903','CLIENTE PROSPECTO','NO ASIGNADO','NO ASIGNADO','CMANZANO',NULL,'','','',18.67,'0000-00-00 00:00:00','NEW',NULL,NULL,NULL,50,0),(6555,'IN-LND-06555','2025-07-07 11:56:09','2025-07-07 11:56:43','ON-CARRIAGE','ON-CARRIAGE','2025-07-18 12:11:06','DDOMINGUEZ','GENERAL',NULL,'GENESEAS LOGISTICS S. DE R.L. DE C.V.','CIUDAD DE MEXICO','','3',3728.234,'MXN',4401.655,3794.53,0,3,556,1.547,'NO','SI','1.547','CLIENTE ACTIVO','DALEON','JLPRIETO','DDOMINGUEZ',NULL,'Andrea Vallejo','andrea.vallejo@gnseas.com','',18.63,'2025-07-31 00:00:00','WR','2025-07-11 00:00:00',NULL,NULL,25,0),(6556,'IN-LND-06556','2025-07-08 09:57:08','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE',NULL,'PRYDBERG','GENERAL',NULL,'EXPRESS FORWARDING COMPANY S.A. DE C.V.','CIUDAD DE MEXICO','','',3423.392,'MXN',4087.086,3523.35,0,1,427,1.32,'NO','SI','1.320','CLIENTE ACTIVO','DALEON','PRYDBERG','PRYDBERG',NULL,'Silvia Mondragon','silvia.mondragon@expresslinecorp.com','',18.67,'2025-07-31 00:00:00','NEW',NULL,NULL,NULL,25,0),(6557,'IN-LND-06557','2025-07-08 11:01:36','2025-07-08 13:17:11','ON-CARRIAGE','ON-CARRIAGE','2025-07-23 12:03:08','IMARTINEZ','GENERAL',NULL,'CLESE INTERNACIONAL Y ASOCIADOS S.C.','CIUDAD DE MEXICO','','3',20569.92,'MXN',22603.992,19486.2,0,11,64141,11.616,'NO','SI','64.141','CLIENTE ACTIVO','EREYNA','JLPRIETO','IMARTINEZ',NULL,'','','',18.67,'0000-00-00 00:00:00','YES','2025-07-18 00:00:00',NULL,NULL,60,0),(6558,'IN-LND-06558','2025-07-08 12:28:58','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE','2025-07-08 12:33:10','RDOMINGUEZ','GENERAL',NULL,'TRANSPORTACION Y COMERCIALIZADORA MEXICANA S.A. DE C.V.','MONTERREY','','',10638.6,'MXN',11884.838,10245.55,0,4,1351.4,6.686,'NO','SI','6.686','CLIENTE ACTIVO','DALEON','SHURTADO','RDOMINGUEZ',NULL,'','','',18.67,'0000-00-00 00:00:00','YES',NULL,NULL,NULL,40,0),(6559,'IN-LND-06559','2025-07-08 13:29:29','2025-07-11 11:16:43','ON-CARRIAGE','ON-CARRIAGE','2025-07-11 11:17:03','DDOMINGUEZ','GENERAL',NULL,'KCC MEXICO TRANSPORT SYSTEM S.A. DE C.V.','CIUDAD DE MEXICO','','3',4326.235,'MXN',5238.746,4516.16,0,1,500,1.573,'NO','SI','1.573','CLIENTE ACTIVO','DALEON','JANGELES','DDOMINGUEZ',NULL,'Sinwon Jang','kccmex@kccusa.com','',18.67,'0000-00-00 00:00:00','WR','2025-07-11 00:00:00',NULL,NULL,35,0),(6560,'OUT-LND-06560','2025-07-08 18:14:27','2025-07-08 18:14:37','PRE-CARRIAGE','PRE-CARRIAGE','2025-07-08 18:16:26','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','3',5190.338,'MXN',6388.874,5507.65,0,1,342,1.252,'NO','SI','1.252','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',18.67,'2025-07-31 00:00:00','YES',NULL,'EXITZLOLCH869162',NULL,46.782,0),(6561,'IN-LND-06561','2025-07-09 13:44:10','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE','2025-07-21 12:40:04','DDOMINGUEZ','GENERAL',NULL,'DESCOMAR S.A. DE C.V.','CIUDAD DE MEXICO','','0',0,'MXN',0,0,0,2,2785,4.003,'NO','SI','4.003','CLIENTE ACTIVO','DALEON','JLPRIETO','DDOMINGUEZ',NULL,'Valentina Olivares','sales1@descomar.com.mx','',18.71,'0000-00-00 00:00:00','WR','2025-07-18 00:00:00',NULL,NULL,0,0),(6562,'IN-LND-06562','2025-07-09 14:04:56','2025-07-09 16:07:45','ON-CARRIAGE','ON-CARRIAGE','2025-07-18 16:38:57','DDOMINGUEZ','GENERAL',NULL,'KCC MEXICO TRANSPORT SYSTEM S.A. DE C.V.','CIUDAD DE MEXICO','','3',21983.382,'MXN',23745.165,20469.97,0,6,6111,8.892,'NO','NO','8.892','CLIENTE ACTIVO','DALEON','JANGELES','DDOMINGUEZ',NULL,'Min Kwon','kccmex@kccusa.com','',18.71,'0000-00-00 00:00:00','YES','2025-07-15 00:00:00',NULL,NULL,45,0),(6563,'OUT-LND-06563','2025-07-09 17:07:43','2025-07-09 17:07:45','PRE-CARRIAGE','PRE-CARRIAGE','2025-07-09 17:09:54','EGUARNEROS','GENERAL',NULL,'SCHENKER INTERNATIONAL S.A. DE C.V.','CIUDAD DE MEXICO','','3',0,'MXN',69597.552,59997.89,0,12,3571,22.865,'NO','NO','22.865','CLIENTE ACTIVO','DALEON','ABALDERAS','EGUARNEROS',NULL,'','','',18.71,'2025-07-20 00:00:00','YES',NULL,'EXITZLOPUS869163',NULL,70,0),(6564,'IN-LND-06564','2025-07-09 17:35:06','2025-07-09 17:35:08','ON-CARRIAGE','ON-CARRIAGE','2025-07-23 11:59:52','EGUARNEROS','GENERAL',NULL,'CWL MEXICO S. DE R.L. DE C.V.','CIUDAD DE MEXICO','','3',5021.005,'MXN',5525.88,4763.69,0,1,207,0.8,'NO','SI','0.800','CLIENTE ACTIVO','DALEON','DARROYO','EGUARNEROS',NULL,'Daniela Sierra','Daniela.SierraVelez@craneww.com','',18.71,'2025-07-31 00:00:00','WR','2025-07-18 00:00:00',NULL,NULL,15,0),(6565,'OUT-LND-06565','2025-07-09 21:13:10','2025-07-14 11:49:24','PRE-CARRIAGE','PRE-CARRIAGE','2025-07-10 10:25:16','EGUARNEROS','GENERAL',NULL,'UPS SCS MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','2',14313.634,'MXN',15487.796,13351.548,0,6,2154,11.051,'NO','NO','11.051','CLIENTE ACTIVO','NO ASIGNADO','ABALDERAS','EGUARNEROS',NULL,'Pilar Nava','pnava@ups.com','',18.66,'2025-07-31 00:00:00','YES',NULL,'EXITATMMIL869190',NULL,30.628,0),(6566,'IN-LND-06566','2025-07-10 13:06:47','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE','2025-07-10 13:11:28','RDOMINGUEZ','GENERAL',NULL,'MEXICO AIR CARGO SYSTEMS S.A. DE C.V.','CIUDAD DE MEXICO','','',0,'MXN',16142.2,13915.69,0,18,2065.86,17.28,'NO','SI','17.280','CLIENTE ACTIVO','MCRUZ','PGIESS','RDOMINGUEZ',NULL,'','','',18.57,'0000-00-00 00:00:00','YES',NULL,'TINTZLOTMO3607.25',NULL,17,0),(6567,'OUT-LND-06567','2025-07-10 13:58:49','2025-07-10 14:03:33','PRE-CARRIAGE','PRE-CARRIAGE','2025-07-14 10:44:26','EGUARNEROS','GENERAL',NULL,'SCHENKER INTERNATIONAL S.A. DE C.V.','CIUDAD DE MEXICO','','1',38584,'MXN',42116.12,36307,0,7,6.3,0.093,'SI','NO','0.093','CLIENTE ACTIVO','DALEON','ABALDERAS','EGUARNEROS',NULL,'','','',18.57,'2025-07-31 00:00:00','WR','2025-07-10 00:00:00',NULL,NULL,100,0),(6568,'OUT-LND-06568','2025-07-10 18:04:51','2025-07-10 18:04:59','PRE-CARRIAGE','PRE-CARRIAGE','2025-07-14 15:51:30','EGUARNEROS','GENERAL',NULL,'UPS SCS MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','3',8294.082,'MXN',9099.296,7844.221,0,2,249,4.232,'NO','SI','4.232','CLIENTE ACTIVO','NO ASIGNADO','ABALDERAS','EGUARNEROS',NULL,'Nahum Ruiz','ruiz.nahum@ups.com','',18.57,'2025-07-31 00:00:00','WR',NULL,NULL,NULL,23.629,0),(6569,'IN-LND-06569','2025-07-10 18:14:19','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE','2025-07-14 15:51:33','BFLORES','GENERAL',NULL,'IRE LOGISTICS S.A. DE C.V.','CIUDAD DE MEXICO','','5',14392,'MXN',15552.236,13407.1,0,1,220,1.328,'NO','SI','1.328','CLIENTE ACTIVO','NO ASIGNADO','SGRACIDA','BFLORES',NULL,'JOSUE LEE','','',18.57,'2025-07-31 00:00:00','WR',NULL,NULL,NULL,30,0),(6570,'OUT-LND-06570','2025-07-10 18:17:53','2025-07-10 18:17:53','PRE-CARRIAGE','PRE-CARRIAGE','2025-07-14 11:06:00','EGUARNEROS','GENERAL',NULL,'CP TRANSPORTS SPEDITIONS S. DE R.L. DE C.V.','PUEBLA','','4',5826.341,'MXN',6680.66,5759.19,0,1,122.54,0.547,'NO','NO','0.547','CLIENTE ACTIVO','NO ASIGNADO','DARROYO','EGUARNEROS',NULL,'Adriana Miranda','Adriana.Miranda@cargo-partner.com','',18.57,'2025-07-31 00:00:00','YES',NULL,'EXITATMHAM869262',NULL,30,0),(6571,'IN-LND-06571','2025-07-11 09:23:32','2025-07-11 09:23:42','ON-CARRIAGE','ON-CARRIAGE','2025-07-14 15:51:35','HMAYEN','GENERAL',NULL,'','','ALLINK TRANSPORTES INTERNACIONAIS, ITAJAI','3',11469.92,'MXN',13284.262,11451.95,0,16,3583.52,8.448,'NO','SI','8.448','CLIENTE AGENTE','HMAYEN','HMAYEN','HMAYEN',NULL,'ANA ALVES','ana.alves@allink.com.br','',18.63,'0000-00-00 00:00:00','WR',NULL,NULL,NULL,65,0),(6572,'OUT-LND-06572','2025-07-11 11:48:19','2025-07-11 11:48:21','PRE-CARRIAGE','PRE-CARRIAGE','2025-07-14 15:51:37','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','4',10359.395,'MXN',11377.698,9808.36,0,4,656,4.454,'NO','SI','4.454','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',18.63,'2025-07-31 00:00:00','WR',NULL,NULL,NULL,30,0),(6573,'IN-LND-06573','2025-07-11 17:19:49','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE','2025-07-14 15:51:39','PRYDBERG','GENERAL',NULL,'EXPRESS FORWARDING COMPANY S.A. DE C.V.','CIUDAD DE MEXICO','','4',0,'MXN',11344.974,9780.15,0,3,757,25.056,'NO','SI','25.056','CLIENTE ACTIVO','DALEON','PRYDBERG','PRYDBERG',NULL,'Silvia Mondragon','silvia.mondragon@expresslinecorp.com','',18.63,'2025-07-31 00:00:00','WR',NULL,NULL,NULL,25,0),(6574,'OUT-LND-06574','2025-07-14 10:30:07','2025-07-16 14:40:13','PRE-CARRIAGE','PRE-CARRIAGE','2025-07-14 10:33:49','EGUARNEROS','GENERAL',NULL,'GEODIS MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','4',7283.718,'MXN',8397.008,7238.8,0,2,263.5,3.912,'NO','SI','3.912','CLIENTE ACTIVO','EBERNABE','ABALDERAS','EGUARNEROS',NULL,'','','',18.66,'2025-07-31 00:00:00','YES',NULL,'EXITATMSSZ869357',NULL,39.4148,0),(6575,'IN-LND-06575','2025-07-14 12:05:40','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE','2025-07-14 15:51:41','PRYDBERG','GENERAL',NULL,'NGL NAVIGATOR GLOBAL LOGISTICS S. DE R.L. DE C.V.','PUEBLA','','5',8995.437,'MXN',9857.842,8498.14,0,1,78,0.24,'NO','SI','0.240','CLIENTE ACTIVO','LRUBIO','PRYDBERG','PRYDBERG',NULL,'Luis Perez','luis.perez@ngl-mexico.com','',18.66,'0000-00-00 00:00:00','WR',NULL,NULL,NULL,25,0),(6576,'IN-LND-06576','2025-07-14 13:28:04','2025-07-14 14:04:12','ON-CARRIAGE','ON-CARRIAGE','2025-07-14 14:06:39','RDOMINGUEZ','GENERAL',NULL,'MEXICO AIR CARGO SYSTEMS S.A. DE C.V.','CIUDAD DE MEXICO','','',0,'MXN',16666.23,14367.44,0,9,5469.95,6.551,'NO','NO','6.551','CLIENTE ACTIVO','MCRUZ','PGIESS','RDOMINGUEZ',NULL,'','','',18.66,'0000-00-00 00:00:00','YES',NULL,NULL,NULL,4,0),(6577,'IN-LND-06577','2025-07-14 16:04:04','2025-07-14 16:50:20','ON-CARRIAGE','ON-CARRIAGE',NULL,'PRYDBERG','GENERAL',NULL,'ORANGE BOX LOGISTICS S.A. DE C.V.','CIUDAD DE MEXICO','','2',24416,'MXN',26045.596,22453.1,0,3,732,4.687,'NO','SI','4.687','CLIENTE ACTIVO','LRUBIO','PRYDBERG','PRYDBERG',NULL,'Marco Vivanco','opsintl01@otob.mx','',18.66,'0000-00-00 00:00:00','NEW',NULL,NULL,NULL,35,0),(6578,'OUT-LND-06578','2025-07-14 17:28:33','0000-00-00 00:00:00','PRE-CARRIAGE','PRE-CARRIAGE',NULL,'PRYDBERG','GENERAL',NULL,'TRAFILOG S.A. DE C.V.','CIUDAD DE MEXICO','','2',3202.64,'MXN',3858.16,3326,0,1,100,1,'NO','SI','1.000','CLIENTE ACTIVO','EBERNABE','PRYDBERG','PRYDBERG',NULL,'Norma Pineda','n.pineda@trafi-log.com.mx','',18.66,'0000-00-00 00:00:00','NEW',NULL,NULL,NULL,25,0),(6579,'OUT-LND-06579','2025-07-15 12:06:53','0000-00-00 00:00:00','PRE-CARRIAGE','PRE-CARRIAGE','2025-07-15 12:10:55','EGUARNEROS','GENERAL',NULL,'HELLMANN WORLDWIDE LOGISTICS S.A. DE C.V.','CIUDAD DE MEXICO','','4',12541.021,'MXN',13750.164,11853.59,0,3,360,3.456,'NO','NO','3.456','CLIENTE ACTIVO','EREYNA','DARROYO','EGUARNEROS',NULL,'','','',18.75,'2025-07-31 00:00:00','YES',NULL,'EXITATMVIE869304',NULL,35,0),(6580,'IN-LND-06580','2025-07-15 16:00:09','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE',NULL,'PRYDBERG','GENERAL',NULL,'EXPRESS FORWARDING COMPANY S.A. DE C.V.','CIUDAD DE MEXICO','','2',42224,'MXN',44710.75,38543.75,0,3,757,5.904,'NO','SI','5.904','CLIENTE ACTIVO','DALEON','PRYDBERG','PRYDBERG',NULL,'Silvia Mondragon','','',18.75,'2025-07-31 00:00:00','NEW',NULL,NULL,NULL,45,0),(6581,'IN-LND-06581','2025-07-15 16:40:41','2025-07-15 17:07:50','ON-CARRIAGE','ON-CARRIAGE','2025-07-15 16:43:26','RDOMINGUEZ','GENERAL',NULL,'SPARX INTERNATIONAL FREIGHT S.A. DE C.V.','CIUDAD DE MEXICO','','',0,'MXN',9791.56,8441,0,1,120,0.51,'NO','NO','0.510','CLIENTE ACTIVO','LRUBIO','PGIESS','RDOMINGUEZ',NULL,'','','',18.75,'0000-00-00 00:00:00','YES',NULL,NULL,NULL,90,0),(6582,'IN-LND-06582','2025-07-15 17:11:14','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE','2025-07-15 17:13:08','RDOMINGUEZ','GENERAL',NULL,'OVERSEAS FORWARDING S.A. DE C.V.','CIUDAD DE MEXICO','','',5248.376,'MXN',6414.568,5529.8,0,3,1500,4.27,'NO','SI','4.270','CLIENTE ACTIVO','NO ASIGNADO','PGIESS','RDOMINGUEZ',NULL,'','','',18.75,'0000-00-00 00:00:00','YES',NULL,NULL,NULL,45,0),(6583,'IN-LND-06583','2025-07-17 10:08:50','2025-07-17 16:13:53','ON-CARRIAGE','ON-CARRIAGE',NULL,'PRYDBERG','GENERAL',NULL,'SAMSUNG SDS MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','',29008,'MXN',30804.032,26555.2,0,7,2254,14.112,'NO','SI','14.112','CLIENTE ACTIVO','LRUBIO','PRYDBERG','PRYDBERG',NULL,'Delia Alvarez','delia.az@samsung.com','',18.72,'2025-08-15 00:00:00','NEW',NULL,NULL,NULL,35,0),(6584,'IN-LND-06584','2025-07-17 12:30:51','0000-00-00 00:00:00','ON-CARRIAGE','ON-CARRIAGE','2025-07-17 12:32:21','RDOMINGUEZ','GENERAL',NULL,'MEXPACK INTERNATIONAL S.A. DE C.V.','CIUDAD DE MEXICO','','',3998.4,'MXN',5422.397,4674.48,0,1,200,1.944,'NO','SI','1.944','CLIENTE ACTIVO','NO ASIGNADO','PGIESS','RDOMINGUEZ',NULL,'','','',18.72,'0000-00-00 00:00:00','YES',NULL,NULL,NULL,59,0),(6585,'IN-LND-06585','2025-07-17 14:50:41','2025-07-21 12:51:50','ON-CARRIAGE','ON-CARRIAGE','2025-07-17 14:52:25','EGUARNEROS','GENERAL',NULL,'SCHENKER INTERNATIONAL S.A. DE C.V.','CIUDAD DE MEXICO','','1',74480,'MXN',79747.194,68747.581,0,334,618.6,7.89,'SI','NO','7.890','CLIENTE ACTIVO','DALEON','ABALDERAS','EGUARNEROS',NULL,'','','',18.72,'2025-07-31 00:00:00','YES',NULL,'TINTZLOMXZLO3722.25',NULL,120.0631,0),(6586,'IN-LND-06586','2025-07-17 16:57:02','2025-07-17 16:57:03','ON-CARRIAGE','ON-CARRIAGE','2025-07-17 16:59:55','EGUARNEROS','GENERAL',NULL,'SHIPZO TX','TEXAS','','3',4712.557,'MXN',5640.894,4862.84,0,1,301,0.71,'NO','SI','0.710','CLIENTE ACTIVO','UGARCIA','SHURTADO','EGUARNEROS',NULL,'','','',18.72,'2025-07-31 00:00:00','YES',NULL,NULL,NULL,35,0),(6587,'OUT-LND-06587','2025-07-18 11:40:22','2025-07-18 11:43:24','PRE-CARRIAGE','PRE-CARRIAGE','2025-07-18 11:46:21','EGUARNEROS','GENERAL',NULL,'SCHENKER INTERNATIONAL S.A. DE C.V.','CIUDAD DE MEXICO','','3',0,'MXN',70249.82,60560.19,0,12,3410,22.865,'NO','NO','22.865','CLIENTE ACTIVO','DALEON','ABALDERAS','EGUARNEROS',NULL,'','','',18.72,'2025-07-31 00:00:00','YES',NULL,'TINTCUUZLO3721.25',NULL,100,0),(6588,'IN-LND-06588','2025-07-18 13:13:25','2025-07-18 13:15:21','ON-CARRIAGE','ON-CARRIAGE','2025-07-18 15:23:03','EGUARNEROS','GENERAL',NULL,'VGL LOGISTICA Y SOLUCIONES INTEGRALES S.A. DE C.V.','MONTERREY','','2',11951.251,'MXN',13898.146,11981.16,0,7,1000,9.891,'NO','SI','9.891','CLIENTE ACTIVO','EBERNABE','SHURTADO','EGUARNEROS',NULL,'','','',18.72,'2025-07-31 00:00:00','YES','2025-07-18 00:00:00',NULL,NULL,70,0),(6589,'OUT-LND-06589','2025-07-19 15:32:17','2025-07-21 13:22:04','PRE-CARRIAGE','PRE-CARRIAGE','2025-07-19 15:33:35','EGUARNEROS','GENERAL',NULL,'JAS FORWARDING DE MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','3',6561.414,'MXN',7488.009,6455.18,0,7,3794,5.031,'NO','SI','5.031','CLIENTE ACTIVO','LRUBIO','ABALDERAS','EGUARNEROS',NULL,'','','',18.72,'2025-07-31 00:00:00','YES',NULL,'EXITVERHAM869240',NULL,31.879,0),(6590,'OUT-LND-06590','2025-07-21 15:35:14','2025-07-21 15:35:23','PRE-CARRIAGE','PRE-CARRIAGE','2025-07-21 16:03:17','EGUARNEROS','GENERAL',NULL,'RHENUS AIR AND OCEAN MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','3',15126.194,'MXN',17080.695,14724.737,0,7,1699,10.626,'NO','NO','10.626','CLIENTE ACTIVO','LRUBIO','DARROYO','EGUARNEROS',NULL,'Gladys Rosas','Gladys.Rosas@rhenus.com','',18.77,'2025-07-31 00:00:00','YES',NULL,'EXITVERBCN869472',NULL,64.9551,0),(6591,'IN-LND-06591','2025-07-21 16:42:33','2025-07-21 17:32:14','ON-CARRIAGE','ON-CARRIAGE','2025-07-21 17:23:52','EGUARNEROS','GENERAL',NULL,'SGL TRANSGROUP DE MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','3',12601.893,'MXN',14140.62,12190.19,0,8,780,7.022,'NO','NO','7.022','CLIENTE ACTIVO','LRUBIO','ABALDERAS','EGUARNEROS',NULL,'Lizette Martinez','LizeM@scangl.com','',18.77,'2025-07-31 00:00:00','YES',NULL,'TINTZLOTTL3767.25',NULL,50,0),(6592,'OUT-LND-06592','2025-07-22 12:15:38','2025-07-22 12:16:27','PRE-CARRIAGE','PRE-CARRIAGE','2025-07-22 12:17:01','EGUARNEROS','GENERAL',NULL,'SCHENKER INTERNATIONAL S.A. DE C.V.','CIUDAD DE MEXICO','','6',21142.262,'MXN',23462.506,20226.298,0,3,160.56,5.135,'NO','SI','5.135','CLIENTE ACTIVO','DALEON','ABALDERAS','EGUARNEROS',NULL,'Nayelli Mendoza','nayelli.mendozalopez@dbschenker.com','',18.77,'2025-07-31 00:00:00','YES',NULL,'TINTVERZLO3769.25',NULL,71.8848,0),(6593,'OUT-LND-06593','2025-07-22 13:44:13','2025-07-22 13:44:24','PRE-CARRIAGE','PRE-CARRIAGE','2025-07-22 13:48:18','EGUARNEROS','GENERAL',NULL,'SCHENKER INTERNATIONAL S.A. DE C.V.','CIUDAD DE MEXICO','','3',0,'MXN',11209.08,9663,0,1,161,4.822,'NO','NO','4.822','CLIENTE ACTIVO','DALEON','ABALDERAS','EGUARNEROS',NULL,'Nayelli Mendoza','nayelli.mendozalopez@dbschenker.com','',18.77,'2025-07-31 00:00:00','YES',NULL,'TINTSILATM3779.25',NULL,70,0),(6594,'IN-LND-06594','2025-07-23 15:46:36','2025-07-23 15:46:42','ON-CARRIAGE','ON-CARRIAGE',NULL,'EGUARNEROS','GENERAL',NULL,'GEODIS MEXICO S.A. DE C.V.','CIUDAD DE MEXICO','','2',14365.68,'MXN',15960.44,13759,0,2,1446.5,2.52,'NO','SI','2.520','CLIENTE ACTIVO','EBERNABE','ABALDERAS','EGUARNEROS',NULL,'','','',18.65,'2025-07-31 00:00:00','FUP','2025-07-23 00:00:00',NULL,NULL,50,0);
/*!40000 ALTER TABLE `rs_pricing_inland` 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:00:43
