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