-- MySQL dump 10.13  Distrib 5.6.24, for Win64 (x86_64)
--
-- 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 `conceptosfacturas`
--

DROP TABLE IF EXISTS `conceptosfacturas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `conceptosfacturas` (
  `ConceptosFacturasID` varchar(50) NOT NULL,
  `InternalVersion` int(11) DEFAULT '0',
  `Descripcion` varchar(50) DEFAULT NULL,
  `DivisionesID` varchar(50) DEFAULT NULL,
  `Codigo` varchar(50) DEFAULT NULL,
  `Activo` tinyint(4) DEFAULT '0',
  `Consecutivo` bigint(20) DEFAULT '0',
  PRIMARY KEY (`ConceptosFacturasID`),
  KEY `WDIDX_ConceptosFacturas_DivisionesID` (`DivisionesID`),
  KEY `WDIDX_ConceptosFacturas_Codigo` (`Codigo`),
  KEY `WDIDX_ConceptosFacturas_Activo` (`Activo`),
  KEY `WDIDX_ConceptosFacturas_Consecutivo` (`Consecutivo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `conceptosfacturas`
--

LOCK TABLES `conceptosfacturas` WRITE;
/*!40000 ALTER TABLE `conceptosfacturas` DISABLE KEYS */;
INSERT INTO `conceptosfacturas` VALUES ('104-1',1,'CONSUMO GENERAL','CK','CG',1,0),('104-10',1,'CONCEPTOS','EA','C1',1,0),('104-11',1,'AGUA','EA','A1',1,0),('104-12',1,'GARRAFONES','EA','G1',1,0),('104-13',1,'HIELO','EA','H1',1,0),('104-14',1,'CONCEPTOS','SP','C1',1,0),('104-15',1,'VENTAS EXENTAS ','SP','VE',1,0),('104-16',1,'VENTAS GRAVADAS AL 0%','SP','VG1',1,0),('104-17',1,'VENTAS GRAVADAS AL 11%','SP','VG2',1,0),('104-18',2,'VENTAS EXENTAS','CK','KVE',1,0),('104-19',2,'VENTAS GRAVADAS AL 0%','CK','KV0',1,0),('104-2',1,'CONSUMO','CK','C01',1,0),('104-20',2,'VENTAS GRAVADAS AL 11%','CK','KV11',1,0),('104-21',1,'VENTAS EXCENTAS','SUB','SVE',1,0),('104-22',1,'VENTAS GRAVADAS AL 0%','SUB','SV0',1,0),('104-23',1,'VENTAS GRAVADAS AL 11%','SUB','SV11',1,0),('104-24',1,'FLETES','GAS','FL',1,0),('104-25',1,'OTRO','GAS','O1',1,0),('104-26',1,'COMISIONES','GAS','COM',1,0),('104-27',2,'VENTAS GRAVADAS AL 16%','SP','V16',1,0),('104-28',1,'VENTAS GRAVADAS AL 16%','SUB','SV16',1,0),('104-29',1,'VENTAS GRAVADAS AL 0%','TH','THV0',1,0),('104-3',1,'CONSUMO DE ALIMENTOS','CK','C02',1,0),('104-30',1,'VENTAS GRAVADAS AL 16%','TH','THV16',1,0),('104-31',1,'VENTAS EXCENTAS','TH','THVE',1,0),('104-32',1,'CONSUMO DE AGUA','GAS','CA',1,0),('104-33',3,'VENTAS EXENTAS','AE','KVE',1,0),('104-34',3,'VENTAS GRAVADAS AL 0%','AE','KV0',1,0),('104-35',2,'VENTAS AL 16%','EA','CV16',1,0),('104-36',3,'VENTAS 16%','AE','CV16',1,0),('104-4',1,'ACEITES Y LUBRICANTES','GAS','AL',1,0),('104-5',1,'BONOS DE GASOLINA','GAS','BG',1,0),('104-6',1,'CONSUMO','SUB','C01',1,0),('104-7',1,'CONSUMO ALIMENTO','SUB','C02',1,0),('104-8',1,'CONCEPTOS','OC','C1',1,0),('104-9',1,'VENTAS 11%','OC','V11',1,0),('141-1',1,'INDEMNIZACION','GAS','IN',1,0),('141-2',1,'TRANSMISION DE LA PROPIEDAD','GAS','TP',1,0),('999-1',1,'VENTAS AL 16%','OC','OV16',1,0),('999-2',1,'VENTAS AL 16%','CK','CV16',1,0),('999-3',1,'VENTAS AL 16%','GAS','GV16',1,0);
/*!40000 ALTER TABLE `conceptosfacturas` 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 2017-09-12  8:17:45
