-- MySQL dump 10.13  Distrib 8.0.31, for Win64 (x86_64)
--
-- Host: 35.225.233.105    Database: 2018_2019
-- ------------------------------------------------------
-- 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,
  `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=18 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','','','MXP','4','0000-00-00','','2018-06-20 16:13:26','SISTEMAS','',NULL,NULL,NULL),(2,'IMPORTACION','1','2','','','','0000-00-00','','','MXP','3','0000-00-00','','2018-06-20 16:14:35','SISTEMAS','',NULL,NULL,NULL),(3,'IMPORTACION','5','5','','','','0000-00-00','','','MXP','5','0000-00-00','','2018-06-20 16:31:54','SISTEMAS','',NULL,NULL,NULL),(4,'EXPORTACION','2','2','','','','0000-00-00','','','MXP','2','0000-00-00','','2018-06-20 16:36:55','SISTEMAS','',NULL,NULL,NULL),(5,'IMPORTACION','4','4','','','','0000-00-00','','','MXP','4','0000-00-00','','2018-06-20 16:43:52','SISTEMAS','',NULL,NULL,NULL),(6,'AEREO','3','3','3','','','0000-00-00','','','MXP','3','0000-00-00','','2018-06-20 16:44:04','SISTEMAS','',NULL,NULL,NULL),(7,'AEREO','10','10','','','','0000-00-00','','','USD','10','0000-00-00','','2018-06-20 17:31:55','SISTEMAS','',NULL,NULL,NULL),(8,'TERRESTRE','55','55','','','','0000-00-00','','','USD','55','0000-00-00','','2018-06-20 17:33:11','SISTEMAS','',NULL,NULL,NULL),(9,'EXPORTACION','88','88','','','','0000-00-00','','','MXP','88','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','MXP','5478','2018-06-22','','2018-06-20 17:35:04','SISTEMAS','MXP',NULL,NULL,NULL),(11,'IMPORTACION','99','99','1','CHEQUE','1','2018-06-20','1','1','MXP','99','2018-06-22','','2018-06-20 17:39:58','SISTEMAS','MXP',NULL,NULL,NULL),(12,'IMPORTACION','AGUNSA','ALMACENAJES','','','','0000-00-00','','','MXN','10','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','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','2020-04-17','SI','2020-04-17 12:05:44','CSAMAYOA','MXP','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','2020-04-23','SI','2020-04-20 11:34:56','CSAMAYOA','MXP','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','2020-05-20','','2020-05-15 13:17:41','JLARIOS','MXP','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','2020-06-23','','2020-06-19 12:37:00','CSAMAYOA','MXP','0000-00-00','','0000-00-00');
/*!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 21:11:53
