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

DROP TABLE IF EXISTS `ventas_prin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ventas_prin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `booking` varchar(255) DEFAULT NULL,
  `referencia_puerto` varchar(255) DEFAULT NULL,
  `fecha_servicio` date DEFAULT NULL,
  `hora_servicio` varchar(45) DEFAULT NULL,
  `transpInternac` varchar(100) DEFAULT NULL,
  `tipodeservicio` varchar(100) DEFAULT NULL,
  `totalDistRec` varchar(100) DEFAULT NULL,
  `razsoce` varchar(255) DEFAULT NULL,
  `crfce` varchar(55) DEFAULT NULL,
  `ccpe` varchar(25) DEFAULT NULL,
  `ccallee` varchar(255) DEFAULT NULL,
  `cnoexte` varchar(55) DEFAULT NULL,
  `cnointe` varchar(55) DEFAULT NULL,
  `ccoloniae` varchar(255) DEFAULT NULL,
  `clocalidade` varchar(150) DEFAULT NULL,
  `cmunicipioe` varchar(150) DEFAULT NULL,
  `cestadoe` varchar(150) DEFAULT NULL,
  `cpaise` varchar(150) DEFAULT NULL,
  `ccontactoe` varchar(255) DEFAULT NULL,
  `ctelefonoe` varchar(150) DEFAULT NULL,
  `creferenciae` varchar(255) DEFAULT NULL,
  `razsocr` varchar(255) DEFAULT NULL,
  `crfcr` varchar(55) DEFAULT NULL,
  `ccpr` varchar(25) DEFAULT NULL,
  `ccaller` varchar(255) DEFAULT NULL,
  `cnoextr` varchar(55) DEFAULT NULL,
  `cnointr` varchar(55) DEFAULT NULL,
  `ccoloniar` varchar(255) DEFAULT NULL,
  `clocalidadr` varchar(150) DEFAULT NULL,
  `cmunicipior` varchar(150) DEFAULT NULL,
  `cestador` varchar(150) DEFAULT NULL,
  `cpaisr` varchar(150) DEFAULT NULL,
  `ccontactor` varchar(255) DEFAULT NULL,
  `ctelefonor` varchar(150) DEFAULT NULL,
  `creferenciar` varchar(255) DEFAULT NULL,
  `crazsocsregcap` varchar(500) DEFAULT NULL,
  `regfiscliente` varchar(500) DEFAULT NULL,
  `forma_de_pago` varchar(150) DEFAULT NULL,
  `condiciones_de_pago` varchar(150) DEFAULT NULL,
  `metodo_de_pago` varchar(150) DEFAULT NULL,
  `usocfdi` varchar(150) DEFAULT NULL,
  `moneda_cfdi` varchar(100) DEFAULT NULL,
  `fecha_hora_facturas` datetime DEFAULT NULL,
  `liga_pdf` varchar(255) DEFAULT NULL,
  `no_solicitud` varchar(150) DEFAULT NULL,
  `status` varchar(100) NOT NULL,
  `usuario` varchar(50) DEFAULT NULL,
  `folio_facturas` varchar(45) DEFAULT NULL,
  `serie_facturas` varchar(45) DEFAULT NULL,
  `impresa_facturas` varchar(45) DEFAULT NULL,
  `cancelada_facturas` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`,`status`),
  KEY `i_booking` (`booking`)
) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ventas_prin`
--

LOCK TABLES `ventas_prin` WRITE;
/*!40000 ALTER TABLE `ventas_prin` DISABLE KEYS */;
INSERT INTO `ventas_prin` VALUES (137,'','','2024-05-12','5:45 AM','','','','','','','','','','','','','','','','','','L.C. MULTIPURPOSE TERMINAL S.A. DE C.V.','LMT121123LC8','60950','BOULEVARD DE LAS ISLAS','1','MODULO 14',' ISLA DEL CAYACAL','','','MICHOACAN','MEXICO','','','','L.C. MULTIPURPOSE TERMINAL','601 - GENERAL DE LEY PERSONAS MORALES','','','','','','2024-05-12 11:41:10','','CP-2405-00002','Solicitado','',NULL,NULL,NULL,NULL),(138,'','','2024-05-13','9:30 AM','','','','','','','','','','','','','','','','','','L APERO WINE S.A. DE C.V.','LAW170125282','72830','PASEO BUGAMBILIAS','70','','LOMAS DE ANGELOPOLIS CLOSSTER 222','','','PUEBLA','MEXICO','','','','L APERO WINE','601 - GENERAL DE LEY PERSONAS MORALES','','','','','','2024-05-13 15:22:17','','CP-2405-00003','Solicitado','',NULL,NULL,NULL,NULL),(139,'','','2024-05-13','9:30 AM','','','','','','','','','','','','','','','','','','LORPEN MEXICO S. DE R.L. DE C.V.','LME060517SK0','72050','25 NORTE','3642','','LAS CUARTILLAS','','','PUEBLA','MEXICO','','','','LORPEN MEXICO','601 - GENERAL DE LEY PERSONAS MORALES','','','','','','2024-05-13 15:23:29','','CP-2405-00004','Solicitado','',NULL,NULL,NULL,NULL),(140,'','','2024-05-13','9:30 AM','','','','','','','','','','','','','','','','','','LORPEN MEXICO S. DE R.L. DE C.V.','LME060517SK0','72050','25 NORTE','3642','','LAS CUARTILLAS','','','PUEBLA','MEXICO','','','','LORPEN MEXICO','601 - GENERAL DE LEY PERSONAS MORALES','','','','','','2024-05-13 15:23:30','','CP-2405-00005','Solicitado','',NULL,NULL,NULL,NULL),(141,'','','2024-05-13','9:30 AM','','','','','','','','','','','','','','','','','','LORPEN MEXICO S. DE R.L. DE C.V.','LME060517SK0','72050','25 NORTE','3642','','LAS CUARTILLAS','','','PUEBLA','MEXICO','','','','LORPEN MEXICO','601 - GENERAL DE LEY PERSONAS MORALES','','','','','','2024-05-13 15:28:14','','CP-2405-00006','Solicitado','',NULL,NULL,NULL,NULL),(142,'','','2024-05-13','9:30 AM','','','','','','','','','','','','','','','','','','LORPEN MEXICO S. DE R.L. DE C.V.','LME060517SK0','72050','25 NORTE','3642','','LAS CUARTILLAS','','','PUEBLA','MEXICO','','','','LORPEN MEXICO','601 - GENERAL DE LEY PERSONAS MORALES','','','','','','2024-05-13 15:29:10','','CP-2405-00007','Solicitado','',NULL,NULL,NULL,NULL),(143,'','','2024-05-13','10:30 AM','','','','','','','','','','','','','','','','','','MORIGSA CONSTRUCCIONES','MCO170707E13','86220','KM 5.5','5.5','','NACAXUXUCA 2A SECC','','NACAJUCA','TABASCO','MEX','','','','MORIGSA CONSTRUCCIONES','601 - GENERAL DE LEY PERSONAS MORALES','','','','','','2024-05-13 16:22:43','','CP-2405-00008','Solicitado','',NULL,NULL,NULL,NULL),(144,'','','2024-05-14','2:30 PM','','','','','','','','','','','','','','','','','','ZAFIRO VAZQUEZ LOPEZ','VALZ781001SK5','28869','PUERTA DEL SOL','13','','NO ESPECIFICADA','','','COLIMA','MEXICO','','','','ZAFIRO VAZQUEZ LOPEZ','612 - PERSONAS FíSICAS CON ACTIVIDADES EMPRESARIALES Y PROFESIONALES','','','','','','2024-05-14 20:23:59','','CP-2405-00009','Solicitado','',NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `ventas_prin` 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:29:06
