-- 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_resultado_inventarios` -- DROP TABLE IF EXISTS `r_resultado_inventarios`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `r_resultado_inventarios` ( `R_Resultado_InventariosID` varchar(50) NOT NULL DEFAULT '0', `R_Toma_InventariosID` varchar(50) DEFAULT NULL, `TiendasID` varchar(50) DEFAULT NULL, `Titulo` varchar(50) DEFAULT NULL, `Fecha` date DEFAULT NULL, `CorteInicial` varchar(50) DEFAULT NULL, `CorteFinal` varchar(50) DEFAULT NULL, `CorteEnlaceInicial` varchar(50) DEFAULT NULL, `CorteEnlaceFinal` varchar(50) DEFAULT NULL, `UtilidadBruta` decimal(24,6) DEFAULT '0.000000', `CostoVentas` decimal(24,6) DEFAULT '0.000000', `Ventas` decimal(24,6) DEFAULT '0.000000', `Porcentaje` decimal(24,6) DEFAULT '0.000000', `InventarioFisico` decimal(24,6) DEFAULT '0.000000', `InventarioFinal` decimal(24,6) DEFAULT '0.000000', `FechaInicial` date DEFAULT NULL, `FechaFinal` date DEFAULT NULL, `FechaInicialEnlace` date DEFAULT NULL, `FechaFinalEnlace` date DEFAULT NULL, `Sobrante` decimal(24,6) DEFAULT '0.000000', `CantidadArticulosSobrante` int(11) DEFAULT '0', `Faltante` decimal(24,6) DEFAULT '0.000000', `CantidadArticulosFaltante` int(11) DEFAULT '0', `Diferencia` decimal(24,6) DEFAULT '0.000000', `InventarioInicial` decimal(24,6) DEFAULT '0.000000', `ComprasInventario` decimal(24,6) DEFAULT '0.000000', `Traspasos` decimal(24,6) DEFAULT '0.000000', `CostosVentaEnlace` decimal(24,6) DEFAULT '0.000000', `TraspasosEnlace` decimal(24,6) DEFAULT '0.000000', `ComprasEnlace` decimal(24,6) DEFAULT '0.000000', `ArticulosContados` int(11) DEFAULT '0', `ArticulosConExistencia` int(11) DEFAULT '0', `Cobro` decimal(24,6) DEFAULT '0.000000', `CantidadArticulosCobro` int(11) DEFAULT '0', `VentasEnlace` decimal(24,6) DEFAULT '0.000000', `Memo1` varchar(50) DEFAULT NULL, `Memo2` varchar(50) DEFAULT NULL, `Memo3` varchar(50) DEFAULT NULL, `Memo4` int(11) DEFAULT '0', `Memo5` int(11) DEFAULT '0', `Memo6` int(11) DEFAULT '0', `InternalVersion` int(11) DEFAULT '0', PRIMARY KEY (`R_Resultado_InventariosID`), KEY `WDIDX_R_Resultado_Inventarios_R_Toma_InventariosID` (`R_Toma_InventariosID`), KEY `WDIDX_R_Resultado_Inventarios_TiendasID` (`TiendasID`), KEY `WDIDX_R_Resultado_Inventarios_Fecha` (`Fecha`), KEY `WDIDX_R_Resultado_Inventarios_CorteInicial` (`CorteInicial`), KEY `WDIDX_R_Resultado_Inventarios_CorteFinal` (`CorteFinal`), KEY `WDIDX_R_Resultado_Inventarios_CorteEnlaceInicial` (`CorteEnlaceInicial`), KEY `WDIDX_R_Resultado_Inventarios_CorteEnlaceFinal` (`CorteEnlaceFinal`), KEY `WDIDX_R_Resultado_Inventarios_FechaInicial` (`FechaInicial`), KEY `WDIDX_R_Resultado_Inventarios_FechaFinal` (`FechaFinal`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `r_resultado_inventarios` -- LOCK TABLES `r_resultado_inventarios` WRITE; /*!40000 ALTER TABLE `r_resultado_inventarios` DISABLE KEYS */; INSERT INTO `r_resultado_inventarios` VALUES ('850-1','850-1','192-402','','2023-04-10','','','','',0.000000,0.000000,0.000000,0.000000,242434.035200,0.000000,NULL,NULL,NULL,NULL,2181503.660000,410727,-2361733.100000,-5449570,-180229.440000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1685063,0,0.000000,0,0.000000,'0','','',0,0,0,151),('850-10','850-10','192-402','','2024-01-15','','','','',0.000000,0.000000,0.000000,0.000000,124822.055400,0.000000,NULL,NULL,NULL,NULL,63351.860000,150059,-93729.970000,-856860,-30378.110000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,938219,0,0.000000,0,0.000000,'0','','',0,0,0,82),('850-11','850-11','192-402','','2024-02-19','','','','',0.000000,0.000000,0.000000,0.000000,193214.823900,0.000000,NULL,NULL,NULL,NULL,72367.310000,103094,-101360.480000,-1010045,-28993.170000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1797835,0,0.000000,0,0.000000,'0','','',0,0,0,74),('850-12','850-12','192-402','','2024-03-25','','','','',0.000000,0.000000,0.000000,0.000000,205870.338100,0.000000,NULL,NULL,NULL,NULL,17954.710000,82700,-102217.540000,-1184687,-84262.830000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1797141,0,0.000000,0,0.000000,'0','','',0,0,0,139),('850-13','850-13','192-402','','2024-04-29','','','','',0.000000,0.000000,0.000000,0.000000,211968.200300,0.000000,NULL,NULL,NULL,NULL,23465.940000,17001,-83429.360000,-867649,-59963.420000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,2194206,0,0.000000,0,0.000000,'0','','',0,0,0,83),('850-14','850-14','192-402','','2024-06-06','','','','',0.000000,0.000000,0.000000,0.000000,146495.944600,0.000000,NULL,NULL,NULL,NULL,33962.040000,204745,-61702.220000,-735433,-27740.180000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1268301,0,0.000000,0,0.000000,'0','','',0,0,0,61),('850-15','850-15','192-402','','2024-07-09','','','','',0.000000,0.000000,0.000000,0.000000,207187.645500,0.000000,NULL,NULL,NULL,NULL,32647.040000,160557,-50562.850000,-590813,-17915.810000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,2090865,0,0.000000,0,0.000000,'0','','',0,0,0,64),('850-16','850-16','192-402','','2024-08-09','','','','',0.000000,0.000000,0.000000,0.000000,150835.723600,0.000000,NULL,NULL,NULL,NULL,37609.250000,223045,-30652.030000,-330195,6957.220000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1477205,0,0.000000,0,0.000000,'0','','',0,0,0,99),('850-17','850-17','192-402','','2024-09-24','','','','',0.000000,0.000000,0.000000,0.000000,205381.116400,0.000000,NULL,NULL,NULL,NULL,15465.340000,108342,-94208.150000,-921780,-78742.810000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,2005592,0,0.000000,0,0.000000,'0','','',0,0,0,76),('850-18','850-18','192-402','','2024-10-30','','','','',0.000000,0.000000,0.000000,0.000000,179948.219000,0.000000,NULL,NULL,NULL,NULL,13740.890000,64836,-80406.060000,-755265,-66665.170000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1776578,0,0.000000,0,0.000000,'0','','',0,0,0,73),('850-19','850-19','192-402','','2024-11-30','','','','',0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,NULL,NULL,NULL,NULL,6780.080000,9257,-74391.250000,-582857,-67611.170000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0,0,0.000000,0,0.000000,'','','',0,0,0,69),('850-2','850-2','192-402','','2023-05-08','','','','',0.000000,0.000000,0.000000,0.000000,311132.101300,0.000000,NULL,NULL,NULL,NULL,95953.240000,25969,-302339.370000,-2519229,-206386.130000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,2428882,0,0.000000,0,0.000000,'0','','',0,0,0,118),('850-3','850-3','192-402','','2023-06-08','','','','',0.000000,0.000000,0.000000,0.000000,373068.232900,0.000000,NULL,NULL,NULL,NULL,100984.230000,99109,-299873.970000,-2681130,-198889.740000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,2709564,0,0.000000,0,0.000000,'0','','',0,0,0,93),('850-5','850-5','192-402','','2023-08-10','','','','',0.000000,0.000000,0.000000,0.000000,163054.194600,0.000000,NULL,NULL,NULL,NULL,93172.440000,159253,-132248.590000,-1058736,-39076.150000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1075504,0,0.000000,0,0.000000,'0','','',0,0,0,142),('850-6','850-6','192-402','','2023-09-11','','','','',0.000000,0.000000,0.000000,0.000000,152404.509300,0.000000,NULL,NULL,NULL,NULL,53971.830000,517006,-119678.030000,-515336,-65706.200000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,810757,0,0.000000,0,0.000000,'0','','',0,0,0,106),('850-7','850-7','192-402','','2023-10-12','','','','',0.000000,0.000000,0.000000,0.000000,150932.750300,0.000000,NULL,NULL,NULL,NULL,47408.070000,46200,-112909.700000,-324931,-65501.630000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,945399,0,0.000000,0,0.000000,'0','','',0,0,0,126),('850-8','850-8','192-402','','2023-11-10','','','','',0.000000,0.000000,0.000000,0.000000,135815.102700,0.000000,NULL,NULL,NULL,NULL,73367.090000,83059,-81505.020000,-721009,-8137.930000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,797848,0,0.000000,0,0.000000,'0','','',0,0,0,107),('850-9','850-9','192-402','','2023-12-18','','','','',0.000000,0.000000,0.000000,0.000000,197290.449300,0.000000,NULL,NULL,NULL,NULL,93214.070000,105518,-106506.580000,-974148,-13292.510000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1632844,0,0.000000,0,0.000000,'0','','',0,0,0,83),('851-4','851-4','192-402','','2023-07-11','','','','',0.000000,0.000000,0.000000,0.000000,208499.064800,0.000000,NULL,NULL,NULL,NULL,93102.710000,21503,-287639.790000,-2634458,-194537.080000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,1285723,0,0.000000,0,0.000000,'0','','',0,0,0,63); /*!40000 ALTER TABLE `r_resultado_inventarios` 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:23:37