-- MySQL dump 10.13 Distrib 5.7.12, for Win32 (AMD64) -- -- Host: localhost Database: circle_k -- ------------------------------------------------------ -- Server version 5.7.10-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 */; /*!40101 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 `r_traspasos` -- DROP TABLE IF EXISTS `r_traspasos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `r_traspasos` ( `R_TraspasosID` varchar(50) NOT NULL, `TiendasID` varchar(50) DEFAULT NULL, `NoTraspasoID` varchar(50) DEFAULT NULL, `TiendaDestinoID` varchar(50) DEFAULT NULL, `SalidasEstatusID` varchar(50) DEFAULT NULL, `Fecha` datetime DEFAULT NULL, `Total` decimal(24,6) DEFAULT '0.000000', `MotivoCancelacion` varchar(50) DEFAULT NULL, `FechaEntrega` date DEFAULT NULL, `EsInsumo` tinyint(4) DEFAULT '0', `Verificado` tinyint(4) DEFAULT '0', `UsuarioRealizo` varchar(50) DEFAULT NULL, `UsuarioAcepto` varchar(50) DEFAULT NULL, `ClaveConfirmacion` varchar(50) DEFAULT NULL, `PorVerificarOrigen` tinyint(4) DEFAULT '0', `PorVerificarDestino` tinyint(4) DEFAULT '0', `Memo1` varchar(50) DEFAULT NULL, `Memo2` varchar(50) DEFAULT NULL, `Memo3` varchar(50) DEFAULT NULL, `Memo4` varchar(50) DEFAULT NULL, `Memo5` varchar(50) DEFAULT NULL, `Memo6` varchar(50) DEFAULT NULL, `InternalVersion` int(11) DEFAULT '0', PRIMARY KEY (`R_TraspasosID`), UNIQUE KEY `NoTraspasoID` (`NoTraspasoID`), KEY `WDIDX_R_Traspasos_TiendasID` (`TiendasID`), KEY `WDIDX_R_Traspasos_TiendaDestinoID` (`TiendaDestinoID`), KEY `WDIDX_R_Traspasos_SalidasEstatusID` (`SalidasEstatusID`), KEY `WDIDX_R_Traspasos_Fecha` (`Fecha`), KEY `WDIDX_R_Traspasos_EsInsumo` (`EsInsumo`), KEY `WDIDX_R_Traspasos_Verificado` (`Verificado`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `r_traspasos` -- LOCK TABLES `r_traspasos` WRITE; /*!40000 ALTER TABLE `r_traspasos` DISABLE KEYS */; INSERT INTO `r_traspasos` VALUES ('409-1','192-147','FY1','192-402','PENDIENTE','2023-06-05 18:15:41',3456.000000,'',NULL,0,0,'294-1025','','38235474',0,0,'','','','','','',1),('438-2','192-158','GL2','192-402','PENDIENTE','2023-06-08 11:24:45',1728.000000,'',NULL,0,0,'491-327','','36239624',0,0,'','','','','','',1),('438-4','192-158','GL4','192-402','PENDIENTE','2023-06-13 18:03:52',864.000000,'',NULL,0,0,'491-327','','28390503',0,0,'','','','','','',1),('6-10','192-375','RGS10','192-402','PENDIENTE','2023-05-16 09:06:59',518.400000,'',NULL,0,0,'324-248','','89199829',0,0,'','','','','','',1),('6-13','192-375','RGS13','192-402','PENDIENTE','2023-12-15 09:03:58',499.400000,'',NULL,0,0,'324-248','','91448974',0,0,'','','','','','',1),('851-1','192-402','AEA1','192-375','ACEPTADA','2023-07-18 13:05:17',4896.000000,'','2023-07-19',0,0,'192-5435','324-248','71780395',0,0,'','','07:42:28','','','',2),('851-10','192-402','AEA10','192-14','ACEPTADA','2024-11-27 16:47:12',85.448400,'',NULL,0,0,'192-1033','192-1033','29415894',0,0,'','','','','','',3),('851-11','192-402','AEA11','192-375','ACEPTADA','2024-11-28 13:07:33',1692.000000,'','2024-11-30',0,0,'192-1033','324-248','23477173',0,0,'','','09:10:49','','','',2),('851-12','192-402','AEA12','192-375','ACEPTADA','2024-11-28 13:14:38',1668.000000,'','2024-11-30',1,0,'192-1033','324-248','03643799',0,0,'','','09:11:21','','','',2),('851-13','192-402','AEA13','192-375','ACEPTADA','2024-11-28 14:54:03',9911.920000,'','2024-11-30',0,0,'192-1033','324-248','09335328',0,0,'','','09:14:38','','','',2),('851-14','192-402','AEA14','192-375','ACEPTADA','2024-11-28 16:56:38',44868.783800,'','2024-11-30',1,0,'192-1033','324-248','35034180',0,0,'','','09:15:10','','','',2),('851-15','192-402','AEA15','192-375','ACEPTADA','2024-11-28 17:00:37',21121.474900,'','2024-11-30',0,0,'192-1033','324-248','22326660',0,0,'','','09:15:58','','','',2),('851-16','192-402','AEA16','192-14','ACEPTADA','2024-11-28 17:47:01',12647.920000,'',NULL,0,0,'192-1033','192-1033','47866821',0,0,'','','','','','',3),('851-17','192-402','AEA17','192-14','ACEPTADA','2024-11-29 08:19:21',28323.901600,'',NULL,1,0,'192-1033','192-1033','74981689',0,0,'','','','','','',4),('851-18','192-402','AEA18','192-14','ACEPTADA','2024-11-29 08:20:26',2017.040000,'',NULL,0,0,'192-1033','192-1033','88958740',0,0,'','','','','','',3),('851-19','192-402','AEA19','192-14','ACEPTADA','2024-11-29 09:51:03',112.500000,'',NULL,1,0,'192-1033','192-1033','63513183',0,0,'','','','','','',3),('851-2','192-402','AEA2','192-420','ACEPTADA','2024-01-10 08:44:49',1881.000000,'','2024-01-10',0,0,'0-299','192-1033','85327148',0,0,'','','21:17:26','','','',2),('851-20','192-402','AEA20','81-1','ACEPTADA','2024-11-29 17:34:44',1603.600000,'',NULL,0,0,'192-1033','192-1033','74261474',0,0,'','','','','','',3),('851-21','192-402','AEA21','81-1','ACEPTADA','2024-11-29 17:37:12',2590.150000,'',NULL,1,0,'192-1033','192-1033','03637696',0,0,'','','','','','',3),('851-22','192-402','AEA22','192-14','ACEPTADA','2024-11-29 17:52:35',1931.491600,'',NULL,1,0,'192-1033','192-1033','98333740',0,0,'','','','','','',3),('851-23','192-402','AEA23','192-14','ACEPTADA','2024-11-29 17:54:21',882.252000,'',NULL,0,0,'192-1033','192-1033','31079102',0,0,'','','','','','',3),('851-24','192-402','AEA24','192-14','ACEPTADA','2024-11-29 18:00:04',1632.640000,'',NULL,1,0,'192-1033','192-1033','28762818',0,0,'','','','','','',3),('851-25','192-402','AEA25','192-14','ACEPTADA','2024-11-30 10:26:21',2823.261000,'',NULL,1,0,'192-1033','192-1033','90490722',0,0,'','','','','','',3),('851-26','192-402','AEA26','192-14','ACEPTADA','2024-11-30 10:28:49',740.240000,'',NULL,0,0,'192-1033','192-1033','87158203',0,0,'','','','','','',3),('851-27','192-402','AEA27','192-14','ACEPTADA','2024-11-30 13:45:46',15855.542800,'',NULL,1,0,'192-1033','192-1033','62716675',0,0,'','','','','','',3),('851-28','192-402','AEA28','81-1','ACEPTADA','2024-11-30 13:47:13',1331.650000,'',NULL,1,0,'192-1033','192-1033','45697022',0,0,'','','','','','',3),('851-29','192-402','AEA29','192-14','ACEPTADA','2024-11-30 14:01:22',2941.769600,'',NULL,0,0,'192-1033','192-1033','06103516',0,0,'','','','','','',3),('851-3','192-402','AEA3','192-14','ACEPTADA','2024-01-16 11:26:43',3014.488000,'',NULL,0,0,'0-299','0-299','64468384',0,0,'','','','','','',3),('851-30','192-402','AEA30','192-14','ACEPTADA','2024-11-30 14:02:27',88.000000,'',NULL,1,0,'192-1033','192-1033','20632935',0,0,'','','','','','',3),('851-31','192-402','AEA31','192-375','ACEPTADA','2024-11-30 14:28:58',2259.190000,'','2024-11-30',1,0,'192-1033','324-248','01959229',0,0,'','','16:11:12','','','',2),('851-32','192-402','AEA32','192-375','ACEPTADA','2024-11-30 14:30:45',2383.888000,'','2024-11-30',0,0,'192-1033','324-248','38946533',0,0,'','','16:11:42','','','',2),('851-33','192-402','AEA33','192-420','PENDIENTE','2024-11-30 14:33:21',822.326400,'',NULL,1,0,'192-1033','','22290039',0,0,'','','','','','',1),('851-34','192-402','AEA34','192-14','ACEPTADA','2024-11-30 14:36:17',180.000000,'',NULL,1,0,'192-1033','192-1033','05404664',0,0,'','','','','','',3),('851-35','192-402','AEA35','192-375','ACEPTADA','2024-11-30 15:39:01',10427.686800,'','2024-11-30',1,0,'192-1033','324-248','15872193',0,0,'','','16:12:10','','','',2),('851-36','192-402','AEA36','192-375','ACEPTADA','2024-11-30 15:40:07',1632.680000,'','2024-11-30',0,0,'192-1033','324-248','05120850',0,0,'','','16:12:37','','','',2),('851-37','192-402','AEA37','192-375','ACEPTADA','2024-11-30 15:49:20',1375.498800,'','2024-11-30',1,0,'192-1033','324-248','14776612',0,0,'','','16:13:00','','','',2),('851-38','192-402','AEA38','192-14','ACEPTADA','2024-11-30 15:53:48',550.000000,'',NULL,1,0,'192-1033','192-1033','65032959',0,0,'','','','','','',3),('851-39','192-402','AEA39','192-14','ACEPTADA','2024-11-30 16:05:36',2433.040000,'',NULL,0,0,'192-1033','192-1033','38369751',0,0,'','','','','','',3),('851-4','192-402','AEA4','192-420','ACEPTADA','2024-02-02 12:41:41',199.900000,'','2024-02-09',0,0,'324-315','473-3388','41281128',0,0,'','','11:19:52','','','',2),('851-5','192-402','AEA5','192-420','ACEPTADA','2024-06-29 16:56:05',508.240000,'','2024-07-01',1,0,'324-315','473-3442','14175415',0,0,'','','20:11:17','','','',2),('851-6','192-402','AEA6','192-420','ACEPTADA','2024-06-30 18:54:57',1203.600000,'','2024-07-01',1,0,'324-315','473-3442','89883422',0,0,'','','20:06:03','','','',2),('851-7','192-402','AEA7','192-419','ACEPTADA','2024-10-09 17:06:50',2022.435000,'','2024-10-21',0,0,'324-315','473-3423','93914794',0,0,'','','13:15:42','','','',2),('851-8','192-402','AEA8','192-14','ACEPTADA','2024-11-27 13:05:42',89850.692000,'',NULL,0,0,'192-1033','192-1033','39724732',0,0,'','','','','','',3),('851-9','192-402','AEA9','192-14','ACEPTADA','2024-11-27 16:40:13',5481.308800,'',NULL,0,0,'192-1033','192-1033','33065796',0,0,'','','','','','',3),('903-1','178-47','LJ1','192-402','PENDIENTE','2023-06-01 12:31:20',518.400000,'',NULL,0,0,'192-5059','','13604737',0,0,'','','','','','',1); /*!40000 ALTER TABLE `r_traspasos` 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 2026-05-30 9:25:18