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

DROP TABLE IF EXISTS `solicitudes_de_pago`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `solicitudes_de_pago` (
  `idsolicitud` double NOT NULL AUTO_INCREMENT,
  `tipo_solicitud` varchar(255) NOT NULL DEFAULT '',
  `proveedor` varchar(255) DEFAULT NULL,
  `concepto` varchar(255) DEFAULT NULL,
  `cuenta_bancaria` varchar(255) NOT NULL DEFAULT '',
  `metodo_de_pago` varchar(255) NOT NULL,
  `saldo_a_favor` varchar(255) NOT NULL,
  `fecha_saldo_a_favor` date NOT NULL,
  `referencia_interna` varchar(255) NOT NULL,
  `referencia_cliente` varchar(255) DEFAULT NULL,
  `moneda` varchar(3) NOT NULL,
  `monto` varchar(255) NOT NULL,
  `urgente` varchar(3) DEFAULT 'No',
  `fecha_limite_de_pago` date NOT NULL,
  `cancelada` varchar(2) NOT NULL,
  `fecha_solicitud` datetime NOT NULL,
  `usuario_solicitud` varchar(255) NOT NULL,
  `moneda_saldo_a_favor` varchar(3) DEFAULT NULL,
  `fecha_aplicacion_pago` date DEFAULT NULL,
  `comprobante` varchar(2) DEFAULT NULL,
  `fecha_entrega_comprobante` date DEFAULT NULL,
  PRIMARY KEY (`idsolicitud`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `solicitudes_de_pago`
--

LOCK TABLES `solicitudes_de_pago` WRITE;
/*!40000 ALTER TABLE `solicitudes_de_pago` DISABLE KEYS */;
INSERT INTO `solicitudes_de_pago` VALUES (1,'IMPORTACION','1','2','3','','','0000-00-00','','','MXN','4','No','0000-00-00','','2018-06-20 16:13:26','SISTEMAS','',NULL,NULL,NULL),(2,'IMPORTACION','1','2','','','','0000-00-00','','','MXN','3','No','0000-00-00','','2018-06-20 16:14:35','SISTEMAS','',NULL,NULL,NULL),(3,'IMPORTACION','5','5','','','','0000-00-00','','','MXN','5','No','0000-00-00','','2018-06-20 16:31:54','SISTEMAS','',NULL,NULL,NULL),(4,'EXPORTACION','2','2','','','','0000-00-00','','','MXN','2','No','0000-00-00','','2018-06-20 16:36:55','SISTEMAS','',NULL,NULL,NULL),(5,'IMPORTACION','4','4','','','','0000-00-00','','','MXN','4','No','0000-00-00','','2018-06-20 16:43:52','SISTEMAS','',NULL,NULL,NULL),(6,'AEREO','3','3','3','','','0000-00-00','','','MXN','3','No','0000-00-00','','2018-06-20 16:44:04','SISTEMAS','',NULL,NULL,NULL),(7,'AEREO','10','10','','','','0000-00-00','','','USD','10','No','0000-00-00','','2018-06-20 17:31:55','SISTEMAS','',NULL,NULL,NULL),(8,'TERRESTRE','55','55','','','','0000-00-00','','','USD','55','No','0000-00-00','','2018-06-20 17:33:11','SISTEMAS','',NULL,NULL,NULL),(9,'EXPORTACION','88','88','','','','0000-00-00','','','MXN','88','No','0000-00-00','','2018-06-20 17:34:18','SISTEMAS','',NULL,NULL,NULL),(10,'TERRESTRE','LORENA ZAPATA','PAGO DE FACTURA N° 100','1245785858','CHEQUE','125.65','2018-06-20','TINTVEREDO 100.18','PHPINC','MXN','5478','No','2018-06-22','','2018-06-20 17:35:04','SISTEMAS','MXN',NULL,NULL,NULL),(11,'IMPORTACION','99','99','1','CHEQUE','1','2018-06-20','1','1','MXN','99','No','2018-06-22','','2018-06-20 17:39:58','SISTEMAS','MXN',NULL,NULL,NULL),(12,'IMPORTACION','AGUNSA','ALMACENAJES','','','','0000-00-00','','','MXN','10','No','0000-00-00','','2018-07-03 06:11:41','SISTEMAS','',NULL,NULL,NULL),(13,'IMPORTACION','COSCO SHIPPING LINES MEXICO S DE RL DE CV','ALMACENAJES','JP MORGAN CHASE BANK SA CUENTA: 880285643','TRANSFERENCIA ELECTRONICA DE FONDOS','','0000-00-00','','','MXN','10','No','0000-00-00','','2018-12-26 15:45:29','SISTEMAS','','0000-00-00','','0000-00-00'),(14,'IMPORTACION','AUTOTRANSPORTES DE CARGA TRES GUERRAS SA DE CV','ANTICIPO','CLABE: 002090700309443113','CHEQUE','2000','2020-04-14','VER263546','VER0819-HAM','MXN','5000','No','2020-04-17','SI','2020-04-17 12:05:44','CSAMAYOA','MXN','2020-04-20','SI','2020-04-13'),(15,'IMPORTACION','TERMINAL INTERNACIONAL DE MANZANILLO  SA DE CV','CARGO DE CITA','BBVA BANCOMER CUENTA: 0450693537','TRANSFERENCIA ELECTRONICA DE FONDOS','200','2020-03-17','VER263546','PAN21547','MXN','2000','No','2020-04-23','SI','2020-04-20 11:34:56','CSAMAYOA','MXN','2020-04-24','NO','0000-00-00'),(16,'IMPORTACION','AGUNSA L & D SA DE CV','CLEANING FEE','BANAMEX CUENTA: 1985018','CHEQUE CERTIFICADO','3000','2020-05-19','VER263546','PAN21547','MXN','5000','No','2020-05-20','','2020-05-15 13:17:41','JLARIOS','MXN','0000-00-00','','0000-00-00'),(17,'IMPORTACION','CMA CGM SECURITIES B.V.','CONTAINER PREMIUM','BBVA BANCOMER CUENTA: 0450693537','CHEQUE','2000','2020-05-05','VER263546','PAN21547','USD','5000','No','2020-06-23','','2020-06-19 12:37:00','CSAMAYOA','MXN','0000-00-00','','0000-00-00'),(18,'IMPORTACION','AGENCIA MARITIMA DE NAVEGACION DEL PACIFICO SA DE CV','MANIOBRAS','HSBC CLABE: 021180040536341011','','','0000-00-00','','','MXN','1000','No','0000-00-00','','2022-08-15 17:58:54','SISTEMAS','','0000-00-00','','0000-00-00'),(19,'IMPORTACION','AGENCIA MARITIMA DE NAVEGACION DEL PACIFICO SA DE CV','REVALIDACION','HSBC CLABE: 021180040536341011','','','0000-00-00','','','MXN','2200','No','0000-00-00','','2022-08-15 17:59:41','SISTEMAS','','0000-00-00','','0000-00-00'),(20,'IMPORTACION','AGENCIA MARITIMA DE NAVEGACION DEL PACIFICO SA DE CV','MANIOBRAS','HSBC CLABE: 021180040536341011','CHEQUE','100','2022-08-01','VER234234','ABCKD / OPOOIER','MXN','1000','No','2022-08-18','','2022-08-15 18:06:47','CSAMAYOA','MXN','2022-08-18','SI','0000-08-15'),(21,'IMPORTACION','ESTAFETA MEXICANA  SA DE CV','MODULACION DIRECTA','BBVA BANCOMER CLABE: 012180004434325139','CHEQUE','1000','2022-08-15','VER12341234','VER4921-ANR','MXN','1000','No','2022-08-18','','2022-08-17 13:21:47','CSAMAYOA','MXN','2022-08-15','SI','0000-00-00'),(22,'IMPORTACION','AUTOTRANSPORTES DE CARGA TRES GUERRAS SA DE CV','CONTAINER INSPECTION FEES','CLABE: 002090700309443113','CHEQUE','','0000-00-00','VER2342342','1234ABCD','USD','1000','No','2022-08-26','','2022-08-23 13:52:35','CSAMAYOA','','0000-00-00','','0000-00-00'),(23,'IMPORTACION','HAMBURG SUD MEXICO  SA DE CV','FLETE MARITIMO MBL','HSBC CLABE: 021180550300058839','CHEQUE','100','2022-08-01','VER234234','1234ABCD','USD','1000','No','2022-08-31','','2022-08-30 18:34:32','CSAMAYOA','USD','0000-00-00','NO','0000-00-00'),(24,'IMPORTACION','AMERICAN PRESIDENT LINES  LTD','CLEANING FEE','CITIBANK N.A. AMERICAN PRESIDENT LINES, LTD CUENTA: 4075-9943','CHEQUE','100','2023-07-18','ASDF','ASDF','MXN','1000','No','2023-07-20','','2023-07-18 13:18:28','CSAMAYOA','MXN','0000-00-00','','0000-00-00'),(25,'EXPORTACION','TRANS NEYNO SA DE CV','CONTAINER INSPECTION FEES','HSBC CUENTA: 4002605848','CHEQUE CERTIFICADO','','0000-00-00','VER234234','ATM2923-HAM','USD','1000','No','2024-08-15','','2024-08-08 19:29:10','CSAMAYOA','','0000-00-00','','0000-00-00'),(26,'IMPORTACION','SEA BRIDGE MEXICO  SA DE CV','DEMORAS','BBVA BANCOMER CUENTA: 110405620','TRANSFERENCIA ELECTRONICA DE FONDOS','100','2024-07-16','VER23234','ATM7423-HAM','USD','1000','No','2024-08-16','','2024-08-13 18:01:30','CSAMAYOA','USD','0000-00-00','','0000-00-00'),(27,'EXPORTACION','AGENCIA MARITIMA DE NAVEGACION DEL PACIFICO SA DE CV','REVALIDACION','HSBC CLABE: 021180040536341011','CHEQUE','100','2024-08-05','VER','ATM7423-HAM','MXN','1000','No','2024-08-22','SI','2024-08-15 11:30:23','CSAMAYOA','USD','0000-00-00','','0000-00-00'),(28,'IMPORTACION','COSCO SHIPPING LINES MEXICO S DE RL DE CV','FLETE MARITIMO MBL','JP MORGAN CHASE BANK SA CUENTA: 880285643','TRANSFERENCIA ELECTRONICA DE FONDOS','500','2024-08-13','VER24','VER4921-ANR','USD','10000','No','2024-08-30','SI','2024-08-22 17:44:21','CSAMAYOA','USD','0000-00-00','SI','0000-00-00'),(29,'IMPORTACION','AGUNSA L & D SA DE CV','CARGO POR IMO','CITIBANK NA CUENTA: 36286952','CHEQUE CERTIFICADO','100','2024-09-19','VER234567','VER6023-HAM','MXN','1000','No','2024-09-06','','2024-09-02 11:36:48','CSAMAYOA','MXN','0000-00-00','','0000-00-00'),(30,'IMPORTACION','AMERICAN PRESIDENT LINES  LTD','CLEANING FEE','CITIBANK N.A. AMERICAN PRESIDENT LINES, LTD CUENTA: 4075-9943','TRANSFERENCIA ELECTRONICA DE FONDOS','100','2024-08-07','VER242584','ATM7423-HAM','USD','1000','No','2024-09-06','SI','2024-09-03 13:18:34','CSAMAYOA','USD','0000-00-00','SI','0000-00-00'),(31,'AEREO','ORIENT OVERSEAS CONTAINER LINE','CARGO POR IMO','HSBC BANK USA CUENTA: 000127205','TRANSFERENCIA ELECTRONICA DE FONDOS','100','2024-08-05','CUSU12341234','VER6023-HAM','MXN','1000','No','2024-09-12','','2024-09-03 13:40:57','CSAMAYOA','USD','0000-00-00','','0000-00-00'),(32,'EXPORTACION','HAPAG-LLOYD MEXICO SA DE CV','MODULACION DIRECTA','CITIBANK, N.A. CUENTA: 30830603','TRANSFERENCIA ELECTRONICA DE FONDOS','500','2024-09-10','VER2432342','1234','MXN','4000','No','2024-10-04','','2024-10-02 13:00:19','CSAMAYOA','USD','0000-00-00','','0000-00-00'),(33,'IMPORTACION','COSCO SHIPPING LINES MEXICO S DE RL DE CV','CONTAINER PREMIUM','JP MORGAN CHASE BANK SA CUENTA: 880285643','TRANSFERENCIA ELECTRONICA DE FONDOS','100','2024-09-03','HAMVERSSL 045.24','VER4921-ANR','USD','1000','No','2024-10-04','','2024-10-09 17:56:44','CSAMAYOA','USD','0000-00-00','','0000-00-00'),(34,'IMPORTACION','HAPAG-LLOYD MEXICO SA DE CV','CARGO DE CITA','MONEX CLABE: 112180000017657348','TRANSFERENCIA ELECTRONICA DE FONDOS','1000','2024-10-14','OPIUYTR567890','CVBNM3456789LFGHJ','MXN','10000','No','2024-10-31','','2024-10-16 00:00:00','HGUILLEN','MXN',NULL,NULL,NULL),(35,'TERRESTRE','TRANSPORTES ALEMAN ESTRELLA SA DE CV','CARGO DE CITA','BANAMEX CUENTA: 4774778','CHEQUE CERTIFICADO','1800','2024-10-15','IUWERRTYU98765','MNBFVD567645','MXN','20000','No','2024-10-31','','2024-10-16 00:00:00','HGUILLEN','MXN',NULL,NULL,NULL),(36,'EXPORTACION','ZIM AMERICAN INTEGRATED SHIPPING SERVICES ACQUISITION COMPANY','CARGO NO ESTIBABLE','WELLS FARGO BANK N.A. ','CHEQUE CERTIFICADO','234','2024-10-16','JGJHGJHGJHGH766','JHJHGJHGJHG76675','USD','1222','No','2024-11-08','','2024-10-16 00:00:00','HGUILLEN','USD',NULL,NULL,NULL),(37,'IMPORTACION','AMERICAN PRESIDENT LINES  LTD','CARGO DE CITA','CITIBANK N.A. AMERICAN PRESIDENT LINES, LTD CUENTA: 4075-9943','CHEQUE','','0000-00-00','12342134','ASDFASDF','MXN','10000','No','2024-10-24','','2024-10-22 14:44:56','CSAMAYOA','','0000-00-00','','0000-00-00'),(38,'IMPORTACION','INLAND FREIGHT SERVICE SADE CV','ANTICIPO','HSBC CUENTA: 0210883556','CHEQUE CERTIFICADO','','0000-00-00','123412341234','asdfasdf','MXN','12341234','No','2024-10-25','','0000-00-00 00:00:00','CSAMAYOA',NULL,NULL,NULL,NULL),(39,'EXPORTACION','TRANSPORTES ALEMAN ESTRELLA SA DE CV','ESTADIAS','BANAMEX CUENTA: 4774778','TRANSFERENCIA ELECTRONICA DE FONDOS','5000','2024-10-24','UYGHLKNKJH7567G',NULL,'MXN','20000','No','2024-10-31','','2024-10-24 05:22:16','HGUILLEN','MXN',NULL,NULL,NULL),(40,'IMPORTACION','CMA CGM SECURITIES B.V.','DEMORAS','BNP PARIBAS  CUENTA: 0020062494100148 ','TRANSFERENCIA ELECTRONICA DE FONDOS','100','2024-10-01','verasdfasdf','VER4921-ANR','USD','10000','No','2024-11-15','','2024-10-30 09:42:46','CSAMAYOA','USD',NULL,NULL,NULL);
/*!40000 ALTER TABLE `solicitudes_de_pago` 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:30:35
