-- Table structure for table `cuentas_niif`
--

DROP TABLE IF EXISTS `cuentas_niif`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cuentas_niif` (
  `cu_codcta` char(12) NOT NULL,
  `cu_nombre` char(50) NOT NULL DEFAULT '',
  `cu_tipcta` char(1) NOT NULL DEFAULT '',
  `cu_natura` char(1) NOT NULL DEFAULT '',
  `cu_tercer` char(1) NOT NULL DEFAULT '',
  `cu_tipter` char(1) NOT NULL DEFAULT '',
  `cu_segaux` char(1) NOT NULL DEFAULT '',
  `cu_tipseg` char(1) NOT NULL DEFAULT '',
  `cu_cencos` char(1) NOT NULL DEFAULT '',
  `cu_balanc` char(1) NOT NULL DEFAULT '',
  `cu_basere` char(1) NOT NULL DEFAULT '',
  `cu_porcen` decimal(2,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`cu_codcta`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cuentas_niif`
--

LOCK TABLES `cuentas_niif` WRITE;
/*!40000 ALTER TABLE `cuentas_niif` DISABLE KEYS */;
/*!40000 ALTER TABLE `cuentas_niif` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cuentasban`
--

DROP TABLE IF EXISTS `cuentasban`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cuentasban` (
  `cb_cuenta` char(12) NOT NULL,
  `cb_descri` char(50) DEFAULT NULL,
  `cb_codigo` char(12) DEFAULT NULL,
  PRIMARY KEY (`cb_cuenta`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cuentasban`
--

LOCK TABLES `cuentasban` WRITE;
/*!40000 ALTER TABLE `cuentasban` DISABLE KEYS */;
/*!40000 ALTER TABLE `cuentasban` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cuentaspre`
--

DROP TABLE IF EXISTS `cuentaspre`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cuentaspre` (
  `cup_codcta` varchar(25) NOT NULL,
  `cup_nombre` varchar(100) NOT NULL,
  `cup_tipcta` char(1) NOT NULL DEFAULT '',
  `cup_cxp` varchar(12) NOT NULL,
  `cup_gasto` varchar(12) NOT NULL,
  `cup_pcgp` varchar(30) NOT NULL,
  `cup_recursos` varchar(20) NOT NULL,
  `cup_oei` varchar(20) NOT NULL,
  `cup_destinacion` varchar(20) NOT NULL,
  `cup_tercero` varchar(20) NOT NULL,
  `cup_finalidad` varchar(20) NOT NULL,
  `cup_situacion` varchar(1) NOT NULL,
  `cup_chip` varchar(30) NOT NULL,
  PRIMARY KEY (`cup_codcta`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cuentaspre`
--

LOCK TABLES `cuentaspre` WRITE;
/*!40000 ALTER TABLE `cuentaspre` DISABLE KEYS */;
INSERT INTO `cuentaspre` (`cup_codcta`, `cup_nombre`, `cup_tipcta`, `cup_cxp`, `cup_gasto`, `cup_pcgp`, `cup_recursos`, `cup_oei`, `cup_destinacion`, `cup_tercero`, `cup_finalidad`, `cup_situacion`, `cup_chip`) VALUES ('2','GASTOS NEGOCIO DE ENERGIA','T','','','','','','','','','',''),('21','FUNCIONAMIENTO','T','','','','','','','','','',''),('211','GASTOS DE PERSONAL','T','','','','','','','','','',''),('21101','PLANTA DE PERSONAL PERMANENTE','T','','','','','','','','','',''),('2110101','FACTORES CONSTITUTIVOS DE SALARIO','T','','','','','','','','','',''),('2110101001','FACTORES SALARIALES COMUNES','T','','','','','','','','','',''),('211010100101','Sueldo b?sico','T','','','','','','','','','',''),('21101010010101','Sueldo b?sico administrativo','D','','','','','','','','','',''),('21101010010102','Sueldo b?sico operativo','D','','','','','','','','','',''),('211010100102','Horas extras, dominicales, festivos y recargos','T','','','','','','','','','',''),('21101010010201','Horas extras, dominicales, festivos y recargos operativos','D','','','','','','','','','',''),('211010100105','Auxilio de transporte','T','','','','','','','','','',''),('21101010010501','Auxilio de transporte administrativo','D','','','','','','','','','',''),('21101010010502','Auxilio de transporte operativo','D','','','','','','','','','',''),('211010100106','Prima de servicios','T','','','','','','','','','',''),('21101010010601','Prima de servicios administrativo','D','','','','','','','','','',''),('21101010010602','Prima de servicios operativo','D','','','','','','','','','',''),('211010100107','Bonificaci?n por servicios prestados','T','','','','','','','','','',''),('21101010010701','Bonificaci?n por servicios prestados administrativo','D','','','','','','','','','',''),('21101010010702','Bonificaci?n por servicios prestados operativo','D','','','','','','','','','',''),('211010100108','Prestaciones sociales','T','','','','','','','','','',''),('21101010010801','Prima de Navidad administrativo','D','','','','','','','','','',''),('21101010010802','Prima de vacaciones administratrivo','D','','','','','','','','','',''),('21101010010803','Prima de navidad operativo','D','','','','','','','','','',''),('21101010010804','Prima de vacaciones operativo','D','','','','','','','','','',''),('211010100110','Vi?ticos de los funcionarios en comisi?n','T','','','','','','','','','',''),('21101010011001','Vi?ticos de los funcionarios en comisi?n administrativo','D','','','','','','','','','',''),('21101010011002','Vi?ticos de los funcionarios en comisi?n operativo','D','','','','','','','','','',''),('2110102','CONTRIBUCIONES INHERENTES A LA N?MINA\n\n','T','','','','','','','','','',''),('211010201','Aportes a la seguridad social en pensiones ','T','','','','','','','','','',''),('21101020101','Aporte a la seguridad social en pensiones Administrativa','D','','','','','','','','','',''),('21101020102','Aporte a la seguridad social en pensiones Operativa','D','','','','','','','','','',''),('211010202','Aportes a la seguridad social en salud','T','','','','','','','','','',''),('21101020201','Aporte a la seguridad social en salud Administrativa','D','','','','','','','','','',''),('21101020202','Aporte a la seguridad social en salud Operativa','D','','','','','','','','','',''),('21101020203','Aportes de cesant?as ','T','','','','','','','','','',''),('2110102020301','Aportes de cesantias Administracion ','D','','','','','','','','','',''),('2110102020302','Aportes de cesantias Operativo','D','','','','','','','','','',''),('21101020204','Intereses de Cesantias','T','','','','','','','','','',''),('2110102020401','Intereses de Cesantias Administracion','D','','','','','','','','','',''),('2110102020402','Intereses de Cesantias Operativo','D','','','','','','','','','',''),('21101020205','Aportes a cajas de compensaci?n familiar','T','','','','','','','','','',''),('2110102020501','Aporte a cajas de compesacion familiar Administrativa','D','','','','','','','','','',''),('2110102020502','Aporte a cajas de compesacion familiar Operativa','D','','','','','','','','','',''),('21101020206','Aportes generales al sistema de riesgos laborales','T','','','','','','','','','',''),('2110102020601','Aporte a riesgo laborales Administrativo','D','','','','','','','','','',''),('2110102020602','Aporte a riesgo laborales Operativo','D','','','','','','','','','',''),('21102','REMUNERACIONES NO CONSTITUTIVAS DE FACTOR SALARIAL','T','','','','','','','','','',''),('2110201','Honorarios ','T','','','','','','','','','',''),('211020101','Honorarios Juridico','D','','','','','','','','','',''),('211020102','Horario salud ocupacional','D','','','','','','','','','',''),('211020103','Honorarios profesional proyecto energia ','D','','','','','','','','','',''),('211020104','Honorarios profesional  modernizacion subestacion energia','D','','','','','','','','','',''),('2110202','Otros Servicios indirectos','T','','','','','','','','','',''),('211020201','Otros Servicios indirectos Administrativo','D','','','','','','','','','',''),('211020202','Otros Servicios indirectos Operativo','D','','','','','','','','','',''),('2110203','Apoyo de sostenimiento aprendices Sena Adm','D','','','','','','','','','',''),('2110204','Apoyo de sostenimiento  Pasantias profesionales ','T','','','','','','','','','',''),('211020401','Apoyo de sostenimiento  Pasantias profesionales  Adm','D','','','','','','','','','',''),('211020402','Apoyo de sostenimiento  Pasantias profesionales  operativ','D','','','','','','','','','',''),('2110205','Auxilio rodamiento Operativo','D','','','','','','','','','',''),('2110206','Bienestar Social','T','','','','','','','','','',''),('211020601','Bienestar Social Adminis','D','','','','','','','','','',''),('211020602','Bienestar Social Operativo','D','','','','','','','','','',''),('2110207','Capacitacion','T','','','','','','','','','',''),('211020701','Capacitacion Adm','D','','','','','','','','','',''),('211020702','Capacitacion Operativo','D','','','','','','','','','',''),('2110208','Examenes medicolaborales ','T','','','','','','','','','',''),('211020801','Examenes medicolaborales Adm','D','','','','','','','','','',''),('211020802','Examenes medicolaborales Operativo','D','','','','','','','','','',''),('2110209','Certificacion de alturas operativo','D','','','','','','','','','',''),('2110210','Bonificacion por recreacion ','T','','','','','','','','','',''),('211021001','Bonificacion por recreacion  Adm','D','','','','','','','','','',''),('211021002','Bonificacion por recreacion  Operativo','D','','','','','','','','','',''),('2110211','Vacaciones','T','','','','','','','','','',''),('211021101','Vacaciones Adm','D','','','','','','','','','',''),('211021102','Vacaciones Operativo','D','','','','','','','','','',''),('212','ADQUISICIONES DE BIENES Y SERVICIOS','T','','','','','','','','','',''),('21201','MATERIALES Y SUMINISTROS','T','','','','','','','','','',''),('2120101','Dotacion','D','','','','','','','','','',''),('2120102','Papeleria','D','','','','','','','','','',''),('2120103','productos de cafeteria y limpieza','D','','','','','','','','','',''),('21202','EQUIPOS  DE OFICINA, CONTABILIDAD E INFORM?TICA','T','','','','','','','','','',''),('2120201','Equipos  de inform?tica y sus partes, piezas y accesorios','D','','','','','','','','','',''),('21203','ADQUISICI?N DE SERVICIOS','T','','','','','','','','','',''),('2120301','Servicios de mantenimientos de redes y circuitos ','D','','','','','','','','','',''),('2120302','Servicios de seguros ','D','','','','','','','','','',''),('2120303','Servicios publicos','D','','','','','','','','','',''),('2120304','Comisiones e intereses y demas gastos bancarios fiduciaria','D','','','','','','','','','',''),('2120305','Otras adquisiciones de servicios','D','','','','','','','','','',''),('21204','IMPUESTOS','T','','','','','','','','','',''),('2120401','impuestos predial','D','','','','','','','','','',''),('2120402','Impuesto sobre la renta y complementarios','D','','','','','','','','','',''),('2120403','impuesto del ICA','D','','','','','','','','','',''),('2120404','Impuesto de industria y comercio','D','','','','','','','','','',''),('2120405','Impuesto vehicular','D','','','','','','','','','',''),('21205','CONTRIBUCIONES','T','','','','','','','','','',''),('2120501','Cuota de auditaje','D','','','','','','','','','',''),('2120502','Contribucion superservicios','D','','','','','','','','','',''),('2120503','Contribucion CREG','D','','','','','','','','','',''),('215','COMERCIALIZACION Y / O PRODUCCION','T','','','','','','','','','',''),('2151','MATERIALES Y SUMINISTROS','T','','','','','','','','','',''),('215101','Materiales electricos','D','','','','','','','','','',''),('215102','herramientas electricas','D','','','','','','','','','',''),('215103','Dotacion','D','','','','','','','','','',''),('215104','seguridad Industrial','D','','','','','','','','','',''),('215105','combusttibles aceites y lubricantes','D','','','','','','','','','',''),('215106','Facturas preimpresas y talonarios de lecturas','D','','','','','','','','','',''),('2152','MAQUINARIA Y EQUIPO','T','','','','','','','','','',''),('215201','Trasformadores','D','','','','','','','','','',''),('215202','Equipo de comunicaci?n','D','','','','','','','','','',''),('2153','ADQUISICION DE SERVICIOS','T','','','','','','','','','',''),('215301','Reparacion de transformadores','D','','','','','','','','','',''),('215302','Mantenimiento de motos','D','','','','','','','','','',''),('215303','Arrendamiento de vehiculo automotor Camioneta','D','','','','','','','','','',''),('215304','arrendamiento de vehiculo automotor volqueta','D','','','','','','','','','',''),('215305','Otras adquisiciones de servicios','D','','','','','','','','','',''),('2154','GENERACION TRANSMISION Y DISTRIBUCION ','T','','','','','','','','','',''),('215401','Transacciones internacionles de energia TIE','D','','','','','','','','','',''),('215402','Transaccionesde energia en bolsa','D','','','','','','','','','',''),('215403','Sistema de transmision nacional STN','D','','','','','','','','','',''),('215404','Ajustes','D','','','','','','','','','',''),('215405','Sistema de transmision regional STR','D','','','','','','','','','',''),('215406','Area de distribucion norte y sur','D','','','','','','','','','',''),('215407','Transacciones de energia por generador','D','','','','','','','','','',''),('23','INVERSION','T','','','','','','','','','',''),('232','ADQUISICION DE BIENES Y SERVICIOS','T','','','','','','','','','',''),('23201','MEJORAS','T','','','','','','','','','',''),('2230101','Mejoramiento infraestuctura administrativa','D','','','','','','','','','',''),('2230102','Expansion y remodelacion de redes','D','','','','','','','','','',''),('22302','PROGRAMA DE INFORMATICA Y BASES DE DATOS','T','','','','','','','','','',''),('2230201','Paquete de software financiero y comercial','D','','','','','','','','','',''),('22','SERVICIO DE LA DEUDA','T','','','','','','','','','',''),('2201','DEUDA INTERNA','T','','','','','','','','','',''),('220101','SECTOR PUBLICO','T','','','','','','','','','',''),('22010101','Credito Superservicios SSPD','D','','','','','','','','','',''),('22010102','intereses  Superservicios SSPD','D','','','','','','','','','',''),('3','GASTOS  ACUEDUCTO','T','','','','','','','','','',''),('31','FUNCIONAMIENTO','T','','','','','','','','','',''),('311','GASTOS DE PERSONAL ADMINISTRATIVO','T','','','','','','','','','',''),('31101','FACTORES CONSTITUTIVOS DE SALARIO','T','','','','','','','','','',''),('3110101','FACTORES SALARIALES COMUNES','T','','','','','','','','','',''),('311010100101','Sueldo','T','','','','','','','','','',''),('31101010010101','Sueldo b?sico administrativo','D','','','','','','','','','',''),('31101010010102','Sueldo b?sico operativo','D','','','','','','','','','',''),('311010100102','Horas extras, dominicales, festivos y recargos','T','','','','','','','','','',''),('31101010010201','Horas extras, dominicales, festivos y recargos operativos','D','','','','','','','','','',''),('311010100105','Auxilio de Transporte','T','','','','','','','','','',''),('31101010010501','Auxilio de transporte administrativo','D','','','','','','','','','',''),('31101010010502','Auxilio de transporte operativo','D','','','','','','','','','',''),('311010100106','Prima de servicios','T','','','','','','','','','',''),('31101010010601','Prima de servicios administrativo','D','','','','','','','','','',''),('31101010010602','Prima de servicios operativo','D','','','','','','','','','',''),('311010100107','Bonificacion por servicios prestados ','T','','','','','','','','','',''),('31101010010701','Bonificaci?n por servicios prestados administrativo','D','','','','','','','','','',''),('31101010010702','Bonificaci?n por servicios prestados operativo','D','','','','','','','','','',''),('311010100108','Prestaciones sociales','T','','','','','','','','','',''),('31101010010801','Prima de Navidad administrativo','D','','','','','','','','','',''),('31101010010802','Prima de vacaciones administratrivo','D','','','','','','','','','',''),('31101010010803','Prima de navidad operativo','D','','','','','','','','','',''),('31101010010804','Prima de vacaciones operativo','D','','','','','','','','','',''),('311010100110','Viaticos de los Funcionarios en comision','T','','','','','','','','','',''),('31101010011001','Vi?ticos de los funcionarios en comisi?n administrativo','D','','','','','','','','','',''),('31101010011002','Vi?ticos de los funcionarios en comisi?n operativo','D','','','','','','','','','',''),('3110102','CONTRIBUCIONES INHERENTES A LA NOMINA','T','','','','','','','','','',''),('311010201','Aportes a la seguridad social en pensiones ','T','','','','','','','','','',''),('31101020101','Aporte a la seguridad social en pensiones Administrativa','D','','','','','','','','','',''),('31101020102','Aporte a la seguridad social en pensiones Operativa','D','','','','','','','','','',''),('311010202','Aporte a la seguridad social en salud','T','','','','','','','','','',''),('31101020201','Aporte a la seguridad social en salud Administrativa','D','','','','','','','','','',''),('31101020202','Aporte a la seguridad social en salud Operativa','D','','','','','','','','','',''),('311010203','Aporte de cesantias','T','','','','','','','','','',''),('31101020301','Aportes de cesantias Administracion ','D','','','','','','','','','',''),('31101020302','Aportes de cesantias Operativo','D','','','','','','','','','',''),('311010204','Intereses de Cesantias','T','','','','','','','','','',''),('31101020401','Intereses de Cesantias Administracion','D','','','','','','','','','',''),('31101020402','Intereses de Cesantias Operativo','D','','','','','','','','','',''),('311010205','Aporte a cajas de compensacion familiar','T','','','','','','','','','',''),('31101020501','Aporte a cajas de compesacion familiar Administrativa','D','','','','','','','','','',''),('31101020502','Aporte a cajas de compesacion familiar Operativa','D','','','','','','','','','',''),('311010206','Aporte a riesgo laborales','T','','','','','','','','','',''),('31101020601','Aporte a riesgo laborales Administrativo','D','','','','','','','','','',''),('31101020602','Aporte a riesgo laborales Operativo','D','','','','','','','','','',''),('31102','REMUNERACIONES NO CONSTITUTIVAS DE FACTOR SALARIAL','T','','','','','','','','','',''),('3110201','Honorarios','T','','','','','','','','','',''),('311020101','Honorarios Juridico','D','','','','','','','','','',''),('311020102','Horario salud ocupacional','D','','','','','','','','','',''),('311020103','Honorarios profesional ingeneria Quimica','D','','','','','','','','','',''),('3110202','Otros Servicios indirectos','T','','','','','','','','','',''),('311020201','Otros Servicios indirectos Administrativo','D','','','','','','','','','',''),('3110203','Apoyo de sostenimiento aprendices Sena Adm','D','','','','','','','','','',''),('3110204','Apoyo de sostenimiento  Pasantias profesionales ','T','','','','','','','','','',''),('311020401','Apoyo de sostenimiento  Pasantias profesionales  Adm','D','','','','','','','','','',''),('3110205','Auxilio rodamiento Operativo','D','','','','','','','','','',''),('3110206','Bienestar Social','T','','','','','','','','','',''),('311020601','Bienestar Social Adminis','D','','','','','','','','','',''),('311020602','Bienestar Social Operativo','D','','','','','','','','','',''),('3110207','Capacitacion','T','','','','','','','','','',''),('311020701','Capacitacion Adm','D','','','','','','','','','',''),('311020702','Capacitacion Operativo','D','','','','','','','','','',''),('3110208','Examenes medicos','T','','','','','','','','','',''),('311020801','Examenes medicolaborales Adm','D','','','','','','','','','',''),('311020802','Examenes medicolaborales Operativo','D','','','','','','','','','',''),('3110209','Certificacion de alturas operativo','D','','','','','','','','','',''),('3110210','Bonificacion por recreacion ','T','','','','','','','','','',''),('311021001','Bonificacion por recreacion  Adm','D','','','','','','','','','',''),('311021002','Bonificacion por recreacion  Operativo','D','','','','','','','','','',''),('3110211','Vacaciones','T','','','','','','','','','',''),('311021101','Vacaciones Adm','D','','','','','','','','','',''),('311021102','Vacaciones Operativo','D','','','','','','','','','',''),('3110212','certificacion de espacios confinados','D','','','','','','','','','',''),('312','ADQUISICIONES DE BIENES Y SERVICIOS','T','','','','','','','','','',''),('31201','MATERIALES Y SUMINISTROS','T','','','','','','','','','',''),('3120101','Dotacion','D','','','','','','','','','',''),('3120102','Papeleria','D','','','','','','','','','',''),('3120103','productos de cafeteria y limpieza','D','','','','','','','','','',''),('31202','EQUIPOS  DE OFICINA, CONTABILIDAD E INFORM?TICA','T','','','','','','','','','',''),('3120201','Equipos  de inform?tica y sus partes, piezas y accesorios','D','','','','','','','','','',''),('31203','ADQUISICI?N DE SERVICIOS','T','','','','','','','','','',''),('3120301','Servicios de mantenimientos de redes y circuitos ','D','','','','','','','','','',''),('3120302','Servicios de seguros ','D','','','','','','','','','',''),('3120303','Servicios publicos','D','','','','','','','','','',''),('3120304','Comisiones e intereses y demas gastos bancarios fiduciaria','D','','','','','','','','','',''),('31204','IMPUESTOS','T','','','','','','','','','',''),('3120401','impuestos predial','D','','','','','','','','','',''),('3120402','Impuesto sobre la renta y complementarios','D','','','','','','','','','',''),('3120403','impuesto del ICA','D','','','','','','','','','',''),('3120404','Impuesto de industria y comercio','D','','','','','','','','','',''),('3120405','Impuesto vehicular','D','','','','','','','','','',''),('31205','CONTRIBUCIONES','T','','','','','','','','','',''),('3120501','Cuota de auditaje','D','','','','','','','','','',''),('3120502','Contribucion superservicios','D','','','','','','','','','',''),('3120503','Contribucion CRA','D','','','','','','','','','',''),('31206','SANCIONES','T','','','','','','','','','',''),('3120601','Sancion Superservicios IRCA','D','','','','','','','','','',''),('315','COMERCIALIZACION Y / O PRODUCCION','T','','','','','','','','','',''),('31501','MATERIALES Y SUMINISTROS','T','','','','','','','','','',''),('3150101','tuberias y accesorios de redes y conexiones','D','','','','','','','','','',''),('3150102','herramientas ','D','','','','','','','','','',''),('3150103','Dotacion','D','','','','','','','','','',''),('3150104','seguridad Industrial','D','','','','','','','','','',''),('3150105','combusttibles aceites y lubricantes','D','','','','','','','','','',''),('3150106','Quimicos y reactivos','D','','','','','','','','','',''),('3150107','Facturas preimpresas y talonarios de lecturas','D','','','','','','','','','',''),('31502','MAQUINARIA Y EQUIPO','T','','','','','','','','','',''),('3150201','Carcazas electrobombas','D','','','','','','','','','',''),('3150202','Sello mec?nico ','D','','','','','','','','','',''),('3150203','Tablero para electrobomba ','D','','','','','','','','','',''),('3150204','Electrobombas ','D','','','','','','','','','',''),('3150205','Cheque horizontal ','D','','','','','','','','','',''),('3150206','Flanches ','D','','','','','','','','','',''),('3150207','Valvulas ','D','','','','','','','','','',''),('3150208','Miples ','D','','','','','','','','','',''),('3150209','Tapa v?lvula ','D','','','','','','','','','',''),('3150210','Sistema De Respirador De Aire Potencia ','D','','','','','','','','','',''),('3150211','Acople','D','','','','','','','','','',''),('3150212','Tubos de 4\" galvanizados','D','','','','','','','','','',''),('3150213','Valineras ','D','','','','','','','','','',''),('31503','ADQUISICION DE SERVICIOS','T','','','','','','','','','',''),('3150301','Mantenimiento  de electrobomba','D','','','','','','','','','',''),('3150302','Mantenimiento de motos','D','','','','','','','','','',''),('3150303','Analisis de agua','D','','','','','','','','','',''),('3150304','Plan de reforestacion y educacion ambiental','D','','','','','','','','','',''),('3150305','Servicios publicos','D','','','','','','','','','',''),('31504','PERMISOS SEGUIMIENTOS Y CONCESIONES','T','','','','','','','','','',''),('3150401','Visitas de seguimientos','D','','','','','','','','','',''),('3150402','Concesion de aguas','D','','','','','','','','','',''),('33','INVERSION','T','','','','','','','','','',''),('332','ADQUISICION DE BIENES Y SERVICIOS','T','','','','','','','','','',''),('33201','MATERIALES Y SUMINISTROS','T','','','','','','','','','',''),('3320101','Mejoramiento infraestuctura administrativa','D','','','','','','','','','',''),('3320102','Reposici?n Tuber?a de flujo libre o presi?n','D','','','','','','','','','',''),('3320103','Reposici?n de los flucuradores de las plantas etapa 2 ','D','','','','','','','','','',''),('3320104','Reposicion de red de distribucion mediante la  Reposicion de 1 km anuales de tuber','D','','','','','','','','','',''),('3320105','Instalacion de  50 Macromedidores  en la red de distribucion','D','','','','','','','','','',''),('3320106','monitoreo y control y calidad del agua','D','','','','','','','','','',''),('33202','PROGRAMA DE INFORMATICA Y BASES DE DATOS','T','','','','','','','','','',''),('3320201','Paquete de software financiero y comercial','D','','','','','','','','','',''),('33203','EQUIPOS','T','','','','','','','','','',''),('3320301','Adquisici?n de Equipos de laboratorio ','D','','','','','','','','','',''),('4','GASTO NEGOCIO  ALCANTARILLADO','T','','','','','','','','','',''),('41','FUNCIONAMIENTO','T','','','','','','','','','',''),('411','GASTOS DE PERSONAL ADMINISTRATIVO','T','','','','','','','','','',''),('41101','FACTORES CONSTITUTIVOS DE SALARIO','T','','','','','','','','','',''),('4110101','FACTORES SALARIALES COMUNES','T','','','','','','','','','',''),('411010100101','Sueldo','T','','','','','','','','','',''),('41101010010101','Sueldo b?sico administrativo','D','','','','','','','','','',''),('41101010010102','Sueldo b?sico operativo','D','','','','','','','','','',''),('411010100102','Horas extras, dominicales, festivos y recargos','T','','','','','','','','','',''),('41101010010201','Horas extras, dominicales, festivos y recargos operativos','D','','','','','','','','','',''),('411010100105','Auxilio de Transporte','D','','','','','','','','','',''),('41101010010501','Auxilio de transporte administrativo','D','','','','','','','','','',''),('41101010010502','Auxilio de transporte operativo','D','','','','','','','','','',''),('411010100106','Prima de servicios','T','','','','','','','','','',''),('41101010010601','Prima de servicios administrativo','D','','','','','','','','','',''),('41101010010602','Prima de servicios operativo','D','','','','','','','','','',''),('411010100107','Bonificacion por servicios prestados ','T','','','','','','','','','',''),('41101010010701','Bonificaci?n por servicios prestados administrativo','D','','','','','','','','','',''),('41101010010702','Bonificaci?n por servicios prestados operativo','D','','','','','','','','','',''),('411010100108','Prestaciones sociales','T','','','','','','','','','',''),('41101010010801','Prima de Navidad administrativo','D','','','','','','','','','',''),('41101010010802','Prima de vacaciones administratrivo','D','','','','','','','','','',''),('41101010010803','Prima de navidad operativo','D','','','','','','','','','',''),('41101010010804','Prima de vacaciones operativo','D','','','','','','','','','',''),('411010100110','Viaticos de los Funcionarios en comision','T','','','','','','','','','',''),('41101010011001','Vi?ticos de los funcionarios en comisi?n administrativo','D','','','','','','','','','',''),('41101010011002','Vi?ticos de los funcionarios en comisi?n operativo','D','','','','','','','','','',''),('4110102','CONTRIBUCIONES INHERENTES A LA NOMINA','T','','','','','','','','','',''),('411010201','Aportes a la seguridad social en pensiones ','T','','','','','','','','','',''),('41101020101','Aporte a la seguridad social en pensiones Administrativa','D','','','','','','','','','',''),('41101020102','Aporte a la seguridad social en pernsiones Operativa','D','','','','','','','','','',''),('411010202','Aporte a la seguridad social en salud','T','','','','','','','','','',''),('41101020201','Aporte a la seguridad social en salud Administrativa','D','','','','','','','','','',''),('41101020202','Aporte a la seguridad social en salud Operativa','D','','','','','','','','','',''),('411010203','Aporte de cesantias','T','','','','','','','','','',''),('41101020301','Aportes de cesantias Administracion ','D','','','','','','','','','',''),('41101020302','Aportes de cesantias Operativo','D','','','','','','','','','',''),('411010204','Intereses de Cesantias','T','','','','','','','','','',''),('41101020401','Intereses de Cesantias Administracion','D','','','','','','','','','',''),('41101020402','Intereses de Cesantias Operativo','D','','','','','','','','','',''),('411010205','Aporte a caja de compensacion familiar','T','','','','','','','','','',''),('41101020501','Aporte a cajas de compesacion familiar Administrativa','D','','','','','','','','','',''),('41101020502','Aporte a cajas de compesacion familiar Operativa','D','','','','','','','','','',''),('411010206','Aporte a riesgo laborales','T','','','','','','','','','',''),('41101020601','Aporte a riesgo laborales Administrativo','D','','','','','','','','','',''),('41101020602','Aporte a riesgo laborales Operativo','D','','','','','','','','','',''),('41102','REMUNERACIONES NO CONSTITUTIVAS DE FACTOR SALARIAL','T','','','','','','','','','',''),('4110201','Honorarios','T','','','','','','','','','',''),('411020101','Honorarios juridico','D','','','','','','','','','',''),('411020102','Horario salud ocupacional','D','','','','','','','','','',''),('4110202','Otros Servicios indirectos Administrativo','D','','','','','','','','','',''),('4110203','Apoyo de sostenimiento aprendices Sena Adm','D','','','','','','','','','',''),('4110204','Apoyo de sostenimiento  Pasantias profesionales  Adm','D','','','','','','','','','',''),('4110205','Bienestar Social','T','','','','','','','','','',''),('411020501','Bienestar Social Adminis','D','','','','','','','','','',''),('411020502','Bienestar Social Operativo','D','','','','','','','','','',''),('4110206','Capacitacion','T','','','','','','','','','',''),('411020601','Capacitacion Adm','D','','','','','','','','','',''),('411020602','Capacitacion Operativo','D','','','','','','','','','',''),('4110207','Examenes medicolaborales','T','','','','','','','','','',''),('411020701','Examenes medicolaborales Adm','D','','','','','','','','','',''),('411020702','Examenes medicolaborales Operativo','D','','','','','','','','','',''),('4110208','certificacion de espacios confinados','D','','','','','','','','','',''),('4110209','Bonificacion por recreacion ','T','','','','','','','','','',''),('411020901','Bonificacion por recreacion  Adm','D','','','','','','','','','',''),('411020902','Bonificacion por recreacion  Operativo','D','','','','','','','','','',''),('4110210','Vacaciones','T','','','','','','','','','',''),('411021001','Vacaciones Adm','D','','','','','','','','','',''),('411021002','Vacaciones Operativo','D','','','','','','','','','',''),('412','ADQUISICIONES DE BIENES Y SERVICIOS','T','','','','','','','','','',''),('41201','MATERIALES Y SUMINISTROS','T','','','','','','','','','',''),('4120101','Dotacion','D','','','','','','','','','',''),('4120102','Papeleria','D','','','','','','','','','',''),('4120103','productos de cafeteria y limpieza','D','','','','','','','','','',''),('41202','EQUIPOS DE OFICINA, CONTABILIDAD E INFORMATICA','T','','','','','','','','','',''),('4120201','Equipo de informatica y sus partes piezas y accesorios','D','','','','','','','','','',''),('41203','ADQUISICION DE SERVICIOS','T','','','','','','','','','',''),('4120301','Servicios de seguros ','D','','','','','','','','','',''),('4120302','Servicios publicos','D','','','','','','','','','',''),('4120303','Comisiones e intereses y demas gastos bancarios fiduciaria','D','','','','','','','','','',''),('4120304','Servicios de mantenimientos de redes y circuitos ','D','','','','','','','','','',''),('41204','IMPUESTOS','T','','','','','','','','','',''),('4120401','impuestos predial','D','','','','','','','','','',''),('4120402','Impuestos sobre la renta y complementarios','D','','','','','','','','','',''),('4120403','Impuestos de ICA','D','','','','','','','','','',''),('4120404','Impuestos de industria y comercio','D','','','','','','','','','',''),('41205','CONTRIBUCIONES','T','','','','','','','','','',''),('4120501','Cuota de auditaje','D','','','','','','','','','',''),('4120502','Contribucion superservicios','D','','','','','','','','','',''),('415','COMERCIALIZACION Y / O PRODUCCION','T','','','','','','','','','',''),('41501','MATERIALES Y SUMINISTROS','T','','','','','','','','','',''),('4150101','Accesorios de redes y conexiones','D','','','','','','','','','',''),('4150102','Herramientas','D','','','','','','','','','',''),('4150103','Dotacion','D','','','','','','','','','',''),('4150104','seguridad Industrial','D','','','','','','','','','',''),('4150105','Facturas preimpresas y talonarios de lecturas','D','','','','','','','','','',''),('41502','MAQUINARIA Y EQUIPO','T','','','','','','','','','',''),('4150201','Apisador','D','','','','','','','','','',''),('4150202','Cortador de Asfalto','D','','','','','','','','','',''),('4150203','Carretilla','D','','','','','','','','','',''),('41503','ADQUISICION DE SERVICIOS','T','','','','','','','','','',''),('4150301','Analisis de agua','D','','','','','','','','','',''),('41504','PERMISOS SEGUIMIENTOS Y CONCESIONES','T','','','','','','','','','',''),('4150401','Tasa Retributiva','D','','','','','','','','','',''),('43','INVERSION','T','','','','','','','','','',''),('432','ADQUISICIONES DE BIENES Y SERVICIOS','T','','','','','','','','','',''),('43201','MEJORAMIENTOS','T','','','','','','','','','',''),('4320101','Mejoramiento infraestuctura administrativa','D','','','','','','','','','',''),('4320102','Cofinaiciacion Cobertura de 2000 metros redes de alcantarillado','D','','','','','','','','','',''),('4320103','Reposicion de 2000 metros redes de alcantarillado','D','','','','','','','','','',''),('4320104','Reposicion de 400 metros domiciliarias','D','','','','','','','','','',''),('4320105','Arreglo de 80 pozos colectores por calles','D','','','','','','','','','',''),('43202','PROGRAMA DE INFORMATICA Y BASES DE DATOS','T','','','','','','','','','',''),('4320201','Paquete de software financiero y comercial','D','','','','','','','','','',''),('5','NEGOCIO DE ASEO','T','','','','','','','','','',''),('51','FUNCIONAMIENTO','T','','','','','','','','','',''),('511','GASTOS DE PERSONAL ','T','','','','','','','','','',''),('5110101','FACTORES CONSTITUTIVOS DE SALARIO','T','','','','','','','','','',''),('5110101001','FACTORES SALARIALES COMUNES','T','','','','','','','','','',''),('511010100101','Sueldo','T','','','','','','','','','',''),('51101010010101','Sueldo b?sico administrativo','D','','','','','','','','','',''),('51101010010102','Sueldo b?sico operativo','D','','','','','','','','','',''),('511010100102','Horas extras, dominicales, festivos y recargos','T','','','','','','','','','',''),('51101010010201','Horas extras, dominicales, festivos y recargos operativos','D','','','','','','','','','',''),('511010100105','Auxilio de Transporte','T','','','','','','','','','',''),('51101010010501','Auxilio de transporte administrativo','D','','','','','','','','','',''),('51101010010502','Auxilio de transporte operativo','D','','','','','','','','','',''),('511010100106','Prima de servicios','T','','','','','','','','','',''),('51101010010601','Prima de servicios administrativo','D','','','','','','','','','',''),('51101010010602','Prima de servicios operativo','D','','','','','','','','','',''),('511010100107','Bonificacion por servicios prestados ','T','','','','','','','','','',''),('51101010010701','Bonificaci?n por servicios prestados administrativo','D','','','','','','','','','',''),('51101010010702','Bonificaci?n por servicios prestados operativo','D','','','','','','','','','',''),('511010100108','Prestaciones sociales','T','','','','','','','','','',''),('51101010010801','Prima de Navidad administrativo','D','','','','','','','','','',''),('51101010010802','Prima de vacaciones administratrivo','D','','','','','','','','','',''),('51101010010803','Prima de navidad operativo','D','','','','','','','','','',''),('51101010010804','Prima de vacaciones operativo','D','','','','','','','','','',''),('511010100110','Viaticos de los Funcionarios en comision','T','','','','','','','','','',''),('51101010011001','Vi?ticos de los funcionarios en comisi?n administrativo','D','','','','','','','','','',''),('51101010011002','Vi?ticos de los funcionarios en comisi?n operativo','D','','','','','','','','','',''),('5110102','CONTRIBUCIONES INHERENTES A LA NOMINA','T','','','','','','','','','',''),('511010201','Aportes a la seguridad social en pensiones ','T','','','','','','','','','',''),('51101020101','Aporte a la seguridad social en pensiones Administrativa','D','','','','','','','','','',''),('51101020102','Aporte a la seguridad social en pensiones Operativa','D','','','','','','','','','',''),('511010202','Aporte a la seguridad social en salud','T','','','','','','','','','',''),('51101020201','Aporte a la seguridad social en salud Administrativa','D','','','','','','','','','',''),('51101020202','Aporte a la seguridad social en salud Operativa','D','','','','','','','','','',''),('511010203','Aporte de cesantias','T','','','','','','','','','',''),('51101020301','Aportes de cesantias Administracion ','D','','','','','','','','','',''),('51101020302','Aportes de cesantias Operativo','D','','','','','','','','','',''),('511010204','Intereses de Cesantias','T','','','','','','','','','',''),('51101020401','Intereses de Cesantias Administracion','D','','','','','','','','','',''),('51101020402','Intereses de Cesantias Operativo','D','','','','','','','','','',''),('511010205','Aporte a cajas de compensacion familiar','T','','','','','','','','','',''),('51101020501','Aporte a cajas de compesacion familiar Administrativa','D','','','','','','','','','',''),('51101020502','Aporte a cajas de compesacion familiar Operativa','D','','','','','','','','','',''),('511010206','Aporte a riesgo laborales','T','','','','','','','','','',''),('51101020601','Aporte a riesgo laborales Administrativo','D','','','','','','','','','',''),('51101020602','Aporte a riesgo laborales Operativo','D','','','','','','','','','',''),('51102','REMUNERACIONES NO CONSTITUTIVAS DE FACTOR SALARIAL','T','','','','','','','','','',''),('5110201','Honorarios','T','','','','','','','','','',''),('511020101','Honorarios Juridico','D','','','','','','','','','',''),('511020102','Horario salud ocupacional','D','','','','','','','','','',''),('5110202','Otros Servicios indirectos','T','','','','','','','','','',''),('511020201','Otros Servicios indirectos Administrativo','D','','','','','','','','','',''),('5110203','Apoyo de sostenimiento aprendices Sena Adm','D','','','','','','','','','',''),('5110204','Apoyo de sostenimiento  Pasantias profesionales ','T','','','','','','','','','',''),('511020401','Apoyo de sostenimiento  Pasantias profesionales  Adm','D','','','','','','','','','',''),('5110206','Bienestar Social','T','','','','','','','','','',''),('511020601','Bienestar Social Adminis','D','','','','','','','','','',''),('511020602','Bienestar Social Operativo','D','','','','','','','','','',''),('5110207','Capacitacion','T','','','','','','','','','',''),('511020701','Capacitacion Adm','D','','','','','','','','','',''),('511020702','Capacitacion Operativo','D','','','','','','','','','',''),('5110208','Examenes medicos','T','','','','','','','','','',''),('511020801','Examenes medicolaborales Adm','D','','','','','','','','','',''),('511020802','Examenes medicolaborales Operativo','D','','','','','','','','','',''),('5110210','Bonificacion por recreacion ','T','','','','','','','','','',''),('511021001','Bonificacion por recreacion  Adm','D','','','','','','','','','',''),('511021002','Bonificacion por recreacion  Operativo','D','','','','','','','','','',''),('5110211','Vacaciones','T','','','','','','','','','',''),('511021101','Vacaciones Adm','D','','','','','','','','','',''),('511021102','Vacaciones Operativo','D','','','','','','','','','',''),('5110212','certificacion de espacios confinados','D','','','','','','','','','',''),('512','ADQUISICIONES DE BIENES Y SERVICIOS','T','','','','','','','','','',''),('51201','MATERIALES Y SUMINISTROS','T','','','','','','','','','',''),('5120101','Dotacion','D','','','','','','','','','',''),('5120102','Papeleria','D','','','','','','','','','',''),('5120103','productos de cafeteria y limpieza','D','','','','','','','','','',''),('51202','EQUIPOS DE OFICINA, CONTABILIDAD E INFORMATICA','T','','','','','','','','','',''),('5120201','Equipos de informatica y sus partes , piezas y accesorios','D','','','','','','','','','',''),('51203','ADQUISICION DE SERVICIOS','T','','','','','','','','','',''),('5120301','Servicios de mantenimientos de redes y circuitos ','D','','','','','','','','','',''),('5120302','Servicios de seguros ','D','','','','','','','','','',''),('5120303','Servicios publicos','D','','','','','','','','','',''),('5120304','Comisiones e intereses y demas gastos bancarios fiduciaria','D','','','','','','','','','',''),('51204','IMPUESTOS ','T','','','','','','','','','',''),('5120401','impuestos predial','D','','','','','','','','','',''),('5120402','Impuestos sobre la renta y complementarios','D','','','','','','','','','',''),('5120403','impuesto del ICA','D','','','','','','','','','',''),('5120404','Impuestos de industria y comercio','D','','','','','','','','','',''),('5120405','Impuesto vehicular','D','','','','','','','','','',''),('51205','CONTRIBUCIONES','T','','','','','','','','','',''),('5120501','Cuota de auditaje','D','','','','','','','','','',''),('5120502','Contribucion superservicios','D','','','','','','','','','',''),('515','COMERCIALIZACION Y / O PRODUCCION','T','','','','','','','','','',''),('51501','MATERIALES Y SUMINISTROS','T','','','','','','','','','',''),('5150101','elementos para recoleccion','D','','','','','','','','','',''),('5150102','Adquisicion de llantas','D','','','','','','','','','',''),('5150103','Dotacion','D','','','','','','','','','',''),('5150104','seguridad Industrial','D','','','','','','','','','',''),('5150105','combusttibles aceites y lubricantes','D','','','','','','','','','',''),('5150106','Facturas preimpresas y talonarios de lecturas','D','','','','','','','','','',''),('51502','ADQUISICION DE SERVICIOS','T','','','','','','','','','',''),('5150201','Mantenimiento correctivo carro compactador','D','','','','','','','','','',''),('5150202','Mantenimiento preventivo carro compactador','D','','','','','','','','','',''),('5150203','Arriendo de maquinaria amarilla','D','','','','','','','','','',''),('5150204','Plan de reforestacion y educacion ambiental','D','','','','','','','','','',''),('51503','PERMISOS SEGUIMIENTOS Y CONCESIONES','T','','','','','','','','','',''),('5150301','Visitas de seguimientos','D','','','','','','','','','',''),('53','INVERSION','T','','','','','','','','','',''),('532','ADQUISICION DE BIENES Y SERVICIOS','T','','','','','','','','','',''),('53201','MATERIALES Y SUMINISTROS','T','','','','','','','','','',''),('5320101','Mejoramiento infraestuctura administrativa','D','','','','','','','','','',''),('5320102','Cofinaiciacion para construccion de celda de disposicion final','D','','','','','','','','','',''),('5320103','Control de plagas y desinfeccion de areas de operaci?n del relleno sanitario La pradera','D','','','','','','','','','',''),('5320104','Actividades de posclausura','D','','','','','','','','','',''),('5320105','monitoreo a piezametros y fuentes adyacentes','D','','','','','','','','','',''),('53202','PROGRAMA DE INFORMATICA Y BASES DE DATOS','T','','','','','','','','','',''),('5320201','Paquete de software financiero y comercial','D','','','','','','','','','',''),('53203','PROGRAMA DE BARRIDO Y LIMPIEZA','T','','','','','','','','','',''),('5320301','Personal para labores de limpieza y corte cesped en las vias y areas publicas del municipio','D','','','','','','','','','',''),('5320302','Personal para labores de barrido y limpieza en las principales calles del municipio','D','','','','','','','','','',''),('5320303','Lanzamiento y fortalecimiento de campa?as de sensibilizacion sobre la separacion en la fuente de EMS','D','','','','','','','','','',''),('5320304','Compraventa de guada?adora y elementos de proteccion personl para el desempe?o de las actividades de','D','','','','','','','','','',''),('53204','PROGRAMA DE APROVECHAMIENTO','T','','','','','','','','','',''),('5320401','Bolsas biodegradable con medias de 70 cm de lagro 60 cm de achos y calibre 1 para la recoleccion de ','D','','','','','','','','','',''),('5320402','contendores para recuperacion de envases de PET , soplado y vidrios','D','','','','','','','','','',''),('21298','Vigencias Anteriores','D','24010101','24010101','','','','','','','',''),('31298','Vigencias Anteriores','D','24010101','24010101','','','','','','','',''),('41298','Vigencias Anteriores','D','24010101','24010101','','','','','','','',''),('51298','Vigencias Anteriores','D','24010101','24010101','','','','','','','',''),('11','INGRESOS ENERGIA','T','','','','','','','','','',''),('1110','DISPONIBILIDAD INICIAL','T','','','','','','','','','',''),('111001','Caja','D','','','','','','','','','',''),('111002','Bancos','D','','','','','','','','','',''),('1111','INGRESOS CORRIENTES','T','','','','','','','','','',''),('111102','INGRESOS NO TRIBUTARIOS','T','','','','','','','','','',''),('11110205','VENTA DE BIENES Y SERVICIOS','T','','','','','','','','','',''),('11110205001','Ventas de establecimientos de mercado','T','','','','','','','','','',''),('1111020500101','Minerales; electricidad, gas y agua','T','','','','','','','','','',''),('111102050010101','Servicio de Energia','T','','','','','','','','','',''),('11110205001010101','Consumo de energia','D','','','','','','','','','',''),('11110205001010102','Derecho de matricula','D','','','','','','','','','',''),('11110205001010103','Revision inicial y sellado de conexion','D','','','','','','','','','',''),('11110205001010105','Reconexion del Servicio','D','','','','','','','','','',''),('11110205001010106','Inspeccion tecnica de instalaciones','D','','','','','','','','','',''),('11110205001010107','Instalacion de transformadores monofisico','D','','','','','','','','','',''),('11110205001010108','Instalacion de transformadores bifisico','D','','','','','','','','','',''),('11110205001010109','Arriendo de Infraestructura','D','','','','','','','','','',''),('11110205001010110','Copia de factura','D','','','','','','','','','',''),('11110205001010111','Intereses','D','','','','','','','','','',''),('11110205001010112','Cartera','D','','','','','','','','','',''),('11110205001010113','Contribuciones','D','','','','','','','','','',''),('11110205001010114','Incapacidades','D','','','','','','','','','',''),('11110205001010115','Rendimientos Financiero','D','','','','','','','','','',''),('11110205001010116','Subsidios sector Residencial','D','','','','','','','','','',''),('12','INGRESOS ACUEDUCTO','T','','','','','','','','','',''),('1210','DISPONIBILIDAD INICIAL','T','','','','','','','','','',''),('121001','Caja','D','','','','','','','','','',''),('121002','Bancos','D','','','','','','','','','',''),('1211','INGRESOS CORRIENTES','T','','','','','','','','','',''),('121102','INGRESOS NO TRIBUTARIOS','T','','','','','','','','','',''),('12110205','VENTA DE BIENES Y SERVICIOS','T','','','','','','','','','',''),('12110205001','Ventas de establecimientos de mercado','T','','','','','','','','','',''),('1211020500106','Servicios de alojamiento; servicios de suministro de comidas y bebidas','T','','','','','','','','','',''),('121102050010602','Servicio de acueducto','T','','','','','','','','','',''),('12110205001060201','Servicio de acueducto Consumo (CMA)','D','','','','','','','','','',''),('12110205001060202','Servicio de acueducto consumo (CMO)','D','','','','','','','','','',''),('12110205001060203','Servicio de acueducto consumo (CMI)','D','','','','','','','','','',''),('12110205001060204','Servicio de acueducto consumo (CMT)','D','','','','','','','','','',''),('12110205001060205','Derecho de matricula','D','','','','','','','','','',''),('12110205001060206','Revision inicial y sellado','D','','','','','','','','','',''),('12110205001060207','Sellos de seguridad','D','','','','','','','','','',''),('12110205001060208','Reconexion','D','','','','','','','','','',''),('12110205001060209','Reinstalacion','D','','','','','','','','','',''),('12110205001060210','Inspecciones tecnicas de las instalaciones','D','','','','','','','','','',''),('12110205001060211','Copias facturas','D','','','','','','','','','',''),('12110205001060212','Intereses','D','','','','','','','','','',''),('12110205001060213','Cartera','D','','','','','','','','','',''),('12110205001060214','Contribuciones','D','','','','','','','','','',''),('12110205001060215','Incapacidades','D','','','','','','','','','',''),('12110205001060216','Rendimientos Financieros','D','','','','','','','','','',''),('12110205001060217','Subsidios sector Residencial','D','','','','','','','','','',''),('13','INGRESOS ALCANTARILLADO','T','','','','','','','','','',''),('1310','DISPONIBILIDAD INICIAL','T','','','','','','','','','',''),('131001','Caja','D','','','','','','','','','',''),('131002','Bancos','D','','','','','','','','','',''),('1311','INGRESOS CORRIENTES','T','','','','','','','','','',''),('131102','INGRESOS NO TRIBUTARIOS','T','','','','','','','','','',''),('13110205','VENTA DE BIENES Y SERVICIOS','T','','','','','','','','','',''),('13110205001','Ventas de establecimientos de mercado','T','','','','','','','','','',''),('1311020500109','Servicios para la comunidad, sociales y personales','T','','','','','','','','','',''),('131102050010901','Servicio de alcantarillado','T','','','','','','','','','',''),('13110205001090101','Servicio de alcantarillado Consumo (CMA)','D','','','','','','','','','',''),('13110205001090102','Servicio de alcantarillado (CMO)','D','','','','','','','','','',''),('13110205001090103','Servicio de alcantarillado consumo (CMI)','D','','','','','','','','','',''),('13110205001090104','Servicio de alcantarillado consumo (CMT)','D','','','','','','','','','',''),('13110205001090105','Derecho matricula','D','','','','','','','','','',''),('13110205001090106','Destaponamiento Domiciliario 1 mt de intervencion','D','','','','','','','','','',''),('13110205001090107','Intereses','D','','','','','','','','','',''),('13110205001090108','Cartera','D','','','','','','','','','',''),('13110205001090109','Contribuciones','D','','','','','','','','','',''),('13110205001090110','Incapacidades','D','','','','','','','','','',''),('13110205001090111','Rendimientos Financieros','D','','','','','','','','','',''),('13110205001090113','Subsidios sector Residencial','D','','','','','','','','','',''),('14','INGRESOS ASEO','T','','','','','','','','','',''),('1410','DISPONIBILIDAD INICIAL','T','','','','','','','','','',''),('141001','Caja','D','','','','','','','','','',''),('141002','Bancos','D','','','','','','','','','',''),('1411','INGRESOS CORRIENTES','T','','','','','','','','','',''),('141102','INGRESOS NO TRIBUTARIOS','T','','','','','','','','','',''),('14110205','VENTA DE BIENES Y SERVICIOS','T','','','','','','','','','',''),('14110205001','Ventas de establecimientos de mercado','T','','','','','','','','','',''),('1411020500109','Servicios para la comunidad, sociales y personales','T','','','','','','','','','',''),('141102050010901','Servicios de Aseo','T','','','','','','','','','',''),('14110205001090101','Comercialización','D','','','','','','','','','',''),('14110205001090102','Limpieza y barrido','D','','','','','','','','','',''),('14110205001090103','Recoleccion y transporte','D','','','','','','','','','',''),('14110205001090104','Disposicion Final','D','','','','','','','','','',''),('14110205001090106','Recoleccion de animales muertos hasta 50kg','D','','','','','','','','','',''),('14110205001090107','Recoleccion de inservibles y verdes metro cubico zona urbana','D','','','','','','','','','',''),('14110205001090108','Barrido por km ?reas privadas incluye recoleccion','D','','','','','','','','','',''),('14110205001090109','Despapale de postes y paredes por dias','D','','','','','','','','','',''),('14110205001090110','Lavado de zonas por 5 m2','D','','','','','','','','','',''),('14110205001090111','Limpieza de eventos masivos hasta de 4 horas','D','','','','','','','','','',''),('14110205001090112','Podas de zonas verdes a partir de 500m2','D','','','','','','','','','',''),('14110205001090113','Intereses','D','','','','','','','','','',''),('14110205001090114','Cartera','D','','','','','','','','','',''),('14110205001090115','Contribuciones','D','','','','','','','','','',''),('14110205001090116','Incapacidades','D','','','','','','','','','',''),('14110205001090117','Rendimientos Financiero','D','','','','','','','','','',''),('14110205001090119','Subsidios sector Residencial','D','','','','','','','','','',''),('1','TOTAL PRESUPUESTO DE INGRESOS','T','','','','','','','','','',''),('11110205001010104','Sello de seguridad','D','','','','','','','','','','');
/*!40000 ALTER TABLE `cuentaspre` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cuentaspred`
--

DROP TABLE IF EXISTS `cuentaspred`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cuentaspred` (
  `cupd_codcta` varchar(25) NOT NULL,
  `cupd_tipcta` varchar(5) NOT NULL DEFAULT '',
  `cupd_nombre` varchar(100) NOT NULL,
  `cupd_cxp` varchar(12) NOT NULL,
  `cupd_gasto` varchar(12) NOT NULL,
  PRIMARY KEY (`cupd_codcta`,`cupd_tipcta`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cuentaspred`
--

LOCK TABLES `cuentaspred` WRITE;
/*!40000 ALTER TABLE `cuentaspred` DISABLE KEYS */;
INSERT INTO `cuentaspred` (`cupd_codcta`, `cupd_tipcta`, `cupd_nombre`, `cupd_cxp`, `cupd_gasto`) VALUES ('21101010010101','1','Contabilizacion','251101','510101'),('21101010010102','1','Contabilizacion','251101','75010301'),('21101010010201','1','Contabilizacion','251101','75010304'),('21101010010501','1','Contabilizacion','251101','510123'),('21101010010502','1','Contabilizacion','251101','75010306'),('21101010010601','1','Contabilizacion','251106','510706'),('21101010010602','1','Contabilizacion','251106','75010903'),('21101010010701','1','Contabilizacion','25110901','51079502'),('21101010010702','1','Contabilizacion','25110901','75010907'),('21101010010801','1','Contabilizacion','251107','510705'),('21101010010802','1','Contabilizacion','251105','510704'),('21101010010803','1','Contabilizacion','251107','75010904'),('21101010010804','1','Contabilizacion','251105','75010906'),('21101010011001','1','Contabilizacion','249027','510810'),('21101010011002','1','Contabilizacion','249027','75010211'),('21101020101','1','Contabilizacion','25112201','51030701'),('21101020102','1','Contabilizacion','25112201','75010506'),('21101020201','1','Contabilizacion','25112301','51030301'),('21101020202','1','Contabilizacion','25112301','75010503'),('2110102020301','1','Contabilizacion','25110201','510702'),('2110102020302','1','Contabilizacion','25110201','75010901'),('2110102020401','1','Contabilizacion','25110301','510703'),('2110102020402','1','Contabilizacion','25110301','7501902'),('2110102020501','1','Contabilizacion','25112401','510302'),('2110102020502','1','Contabilizacion','25112401','75010502'),('2110102020601','1','Contabilizacion','25111101','51030501'),('2110102020602','1','Contabilizacion','25111101','75010505'),('211020101','1','Contabilizacion','249054','510802'),('211020102','1','Contabilizacion','249054','510802'),('211020103','1','Contabilizacion','249054','75010204'),('211020104','1','Contabilizacion','249054','75010204'),('211020201','1','Contabilizacion','249055','511111'),('211020202','1','Contabilizacion','249055','75010205'),('2110203','1','Contabilizacion','249055','511163'),('211020401','1','Contabilizacion','249055','511163'),('211020402','1','Contabilizacion','249055','75010214'),('2110205','1','Contabilizacion','249055','75010216'),('211020601','1','Contabilizacion','251115','510803'),('211020602','1','Contabilizacion','251115','75010307'),('211020701','1','Contabilizacion','251115','510803'),('211020702','1','Contabilizacion','251115','75010307'),('211020801','1','Contabilizacion','24010101','511133'),('211020802','1','Contabilizacion','24010101','75010215'),('2110209','1','Contabilizacion','24010101','75010215'),('211021001','1','Contabilizacion','25110902','51079501'),('211021002','1','Contabilizacion','25110902','75010908'),('211021101','1','Contabilizacion','251104','510701'),('211021102','1','Contabilizacion','251104','75010905'),('2120101','1','Contabilizacion','24010102','15142101'),('2120102','1','Contabilizacion','24010102','15149001'),('2120103','1','Contabilizacion','24010102','15149002'),('2120201','1','Contabilizacion','24010102','15149004'),('2120301','1','Contabilizacion','51115001','24010101'),('2120302','1','Contabilizacion','24010101','511125'),('2120303','1','Contabilizacion','249051','51111701'),('2120304','1','Contabilizacion','244020','512024'),('2120305','1','Contabilizacion','24010101','511190'),('2120401','1','Contabilizacion','244003','512001'),('2120402','1','Contabilizacion','244001','582101'),('2120403','1','Contabilizacion','244004','512009'),('2120404','1','Contabilizacion','244004','512009'),('2120405','1','Contabilizacion','244016','512011'),('2120501','1','Contabilizacion','244014','512002'),('2120502','1','Contabilizacion','24402301','512004'),('2120503','1','Contabilizacion','24402301','512005'),('215101','1','Contabilizacion','24010102','15141001'),('215102','1','Contabilizacion','24010102','15141003'),('215103','1','Contabilizacion','24010102','15142101'),('215104','1','Contabilizacion','24010102','15149002'),('215105','1','Contabilizacion','24010102','15142301'),('215106','1','Contabilizacion','24010102','15149001'),('215201','1','Contabilizacion','24010102','15141002'),('215202','1','Contabilizacion','24010102','15149004'),('215301','1','Contabilizacion','24010101','75010201'),('215302','1','Contabilizacion','24010101','75010201'),('215303','1','Contabilizacion','24010101','75010207'),('215304','1','Contabilizacion','24010101','75010207'),('215305','1','Contabilizacion','24010101','75010201'),('215401','1','Contabilizacion','24010101','7501010602'),('215402','1','Contabilizacion','24010101','7501010603'),('215403','1','Contabilizacion','24010101','7501010604'),('215404','1','Contabilizacion','24010101','7501010605'),('215405','1','Contabilizacion','24010101','7501010606'),('215406','1','Contabilizacion','24010101','7501010607'),('215407','1','Contabilizacion','24010101','7501010608'),('2230101','1','Contabilizacion','164001','24010102'),('2230102','1','Contabilizacion','165002','24010102'),('2230201','1','Contabilizacion','24010101','75010217'),('22010101','1','Contabilizacion','24010101','23160401'),('22010102','1','Contabilizacion','24010101','581032'),('31101010010101','1','Contabilizacion','251101','510101'),('31101010010102','1','Contabilizacion','251101','75020301'),('31101010010201','1','Contabilizacion','251101','75020303'),('31101010010501','1','Contabilizacion','251101','510123'),('31101010010502','1','Contabilizacion','251101','75020323'),('31101010010601','1','Contabilizacion','251106','510706'),('31101010010602','1','Contabilizacion','251106','510705'),('31101010010701','1','Contabilizacion','25110901','51079502'),('31101010010702','1','Contabilizacion','25110901','75020907'),('31101010010801','1','Contabilizacion','251107','510705'),('31101010010802','1','Contabilizacion','251105','510704'),('31101010010803','1','Contabilizacion','251107','75020904'),('31101010010804','1','Contabilizacion','251105','75020906'),('31101010011001','1','Contabilizacion','249027','510810'),('31101010011002','1','Contabilizacion','249027','75020203'),('31101020101','1','Contabilizacion','25112201','51030701'),('31101020102','1','Contabilizacion','25112201','75020506'),('31101020201','1','Contabilizacion','25112301','51030301'),('31101020202','1','Contabilizacion','25112301','75020301'),('31101020301','1','Contabilizacion','25110201','510702'),('31101020302','1','Contabilizacion','25110201','75020901'),('31101020401','1','Contabilizacion','25110301','510703'),('31101020402','1','Contabilizacion','25110301','75020902'),('31101020501','1','Contabilizacion','25112401','510302'),('31101020502','1','Contabilizacion','25112401','75020502'),('31101020601','1','Contabilizacion','25111101','51030501'),('31101020602','1','Contabilizacion','25111101','75020505'),('311020101','1','Contabilizacion','249054','510802'),('311020102','1','Contabilizacion','249054','75020209'),('311020103','1','Contabilizacion','249054','75020209'),('311020201','1','Contabilizacion','249055','511111'),('3110203','1','Contabilizacion','249055','511163'),('311020401','1','Contabilizacion','249055','511163'),('3110205','1','Contabilizacion','249055','75010216'),('311020601','1','Contabilizacion','251115','510803'),('311020602','1','Contabilizacion','251115','75020207'),('311020701','1','Contabilizacion','251115','510803'),('311020702','1','Contabilizacion','251115','75020208'),('311020801','1','Contabilizacion','24010101','511133'),('311020802','1','Contabilizacion','24010101','75020263'),('3110209','1','Contabilizacion','24010101','75020263'),('311021001','1','Contabilizacion','25110902','51079501'),('311021002','1','Contabilizacion','25110902','75020908'),('311021101','1','Contabilizacion','251104','510701'),('311021102','1','Contabilizacion','251104','75020905'),('3110212','1','Contabilizacion','24010101','75020263'),('3120101','1','Contabilizacion','24010102','15142101'),('3120102','1','Contabilizacion','24010102','15149001'),('3120103','1','Contabilizacion','24010102','15149002'),('3120201','1','Contabilizacion','24010102','15149004'),('3120301','1','Contabilizacion','24010101','511150'),('3120302','1','Contabilizacion','24010101','511125'),('3120303','1','Contabilizacion','249051','75020202'),('3120304','1','Contabilizacion','244020','580536'),('3120401','1','Contabilizacion','244003','512001'),('3120402','1','Contabilizacion','244001','582101'),('3120403','1','Contabilizacion','244004','512009'),('3120404','1','Contabilizacion','244004','512009'),('3120405','1','Contabilizacion','244016','512011'),('3120501','1','Contabilizacion','244014','512002'),('3120502','1','Contabilizacion','24402301','512004'),('3120503','1','Contabilizacion','24402301','512005'),('3120601','1','Contabilizacion','24402301','512008'),('3150101','1','Contabilizacion','24010102','15141301'),('3150102','1','Contabilizacion','24010102','15141003'),('3150103','1','Contabilizacion','24010102','15142101'),('3150104','1','Contabilizacion','24010102','15141301'),('3150105','1','Contabilizacion','24010102','15141301'),('3150106','1','Contabilizacion','24010102','15141301'),('3150107','1','Contabilizacion','24010102','15141301'),('3150201','1','Contabilizacion','24010102','15141301'),('3150202','1','Contabilizacion','24010102','15141301'),('3150203','1','Contabilizacion','24010102','15141301'),('3150204','1','Contabilizacion','24010102','15141301'),('3150205','1','Contabilizacion','24010102','15141301'),('3150206','1','Contabilizacion','24010102','15141301'),('3150207','1','Contabilizacion','24010102','15141301'),('3150208','1','Contabilizacion','24010102','15141301'),('3150209','1','Contabilizacion','24010102','15141301'),('3150210','1','Contabilizacion','24010102','15141301'),('3150211','1','Contabilizacion','24010102','15141301'),('3150212','1','Contabilizacion','24010102','15141301'),('3150213','1','Contabilizacion','24010102','15141301'),('3150301','1','Contabilizacion','24010101','75020201'),('3150302','1','Contabilizacion','24010101','75020201'),('3150303','1','Contabilizacion','24010101','75020245'),('3150304','1','Contabilizacion','24010101','75020279'),('3150305','1','Contabilizacion','249051','75020202'),('3150401','1','Contabilizacion','24010101','75020245'),('3150402','1','Contabilizacion','24010101','75020245'),('3320101','1','Contabilizacion','24010101','511115'),('3320102','1','Contabilizacion','24010101','75020101'),('3320103','1','Contabilizacion','24010101','75020101'),('3320104','1','Contabilizacion','24010101','75020101'),('3320105','1','Contabilizacion','24010101','15141301'),('3320106','1','Contabilizacion','24010101','75020245'),('3320201','1','Contabilizacion','24010101','511150'),('3320301','1','Contabilizacion','24010102','15141301'),('41101010010101','1','Contabilizacion','251101','510101'),('41101010010102','1','Contabilizacion','251101','75030301'),('41101010010201','1','Contabilizacion','251101','75030304'),('411010100105','1','Contabilizacion','251101','75030306'),('41101010010501','1','Contabilizacion','251101','510123'),('41101010010502','1','Contabilizacion','251101','75030306'),('41101010010601','1','Contabilizacion','251106','510706'),('41101010010602','1','Contabilizacion','251106','7503903'),('41101010010701','1','Contabilizacion','25110901','51079502'),('41101010010702','1','Contabilizacion','25110901','75030909'),('41101010010801','1','Contabilizacion','251107','510705'),('41101010010802','1','Contabilizacion','251105','510704'),('41101010010803','1','Contabilizacion','251107','75030904'),('41101010010804','1','Contabilizacion','251105','75030906'),('41101010011001','1','Contabilizacion','249027','510810'),('41101010011002','1','Contabilizacion','249027','75030201'),('41101020101','1','Contabilizacion','25112201','51030701'),('41101020102','1','Contabilizacion','25112201','75030506'),('41101020201','1','Contabilizacion','25112301','51030301'),('41101020202','1','Contabilizacion','25112301','7503050301'),('41101020301','1','Contabilizacion','25110201','510702'),('41101020302','1','Contabilizacion','25110201','75030901'),('41101020401','1','Contabilizacion','25110301','510703'),('41101020402','1','Contabilizacion','25110301','75030902'),('41101020501','1','Contabilizacion','25112401','510302'),('41101020502','1','Contabilizacion','25112401','75030502'),('41101020601','1','Contabilizacion','25111101','51030501'),('41101020602','1','Contabilizacion','25111101','75030505'),('411020101','1','Contabilizacion','249054','510802'),('411020102','1','Contabilizacion','249054','510802'),('4110202','1','Contabilizacion','249055','511111'),('4110203','1','Contabilizacion','249055','511163'),('4110204','1','Contabilizacion','249055','511163'),('411020501','1','Contabilizacion','251115','510803'),('411020502','1','Contabilizacion','251115','75030290'),('411020601','1','Contabilizacion','251115','510803'),('411020602','1','Contabilizacion','251115','75030223'),('411020701','1','Contabilizacion','24010101','511133'),('411020702','1','Contabilizacion','24010101','75030206'),('4110208','1','Contabilizacion','24010101','75030206'),('411020901','1','Contabilizacion','25110902','51079501'),('411020902','1','Contabilizacion','25110902','75030910'),('411021001','1','Contabilizacion','251104','510701'),('411021002','1','Contabilizacion','251104','75030905'),('4120101','1','Contabilizacion','24010102','15142101'),('4120102','1','Contabilizacion','24010102','15149001'),('4120103','1','Contabilizacion','24010102','15149002'),('4120201','1','Contabilizacion','24010102','75030214'),('4120301','1','Contabilizacion','24010101','511125'),('4120302','1','Contabilizacion','249051','75030212'),('4120303','1','Contabilizacion','244020','580536'),('4120304','1','Contabilizacion','24010102','75030214'),('4120401','1','Contabilizacion','244003','512001'),('4120402','1','Contabilizacion','244001','582101'),('4120403','1','Contabilizacion','244004','512009'),('4120404','1','Contabilizacion','244004','512009'),('4120501','1','Contabilizacion','244014','512002'),('4120502','1','Contabilizacion','24402301','512004'),('4150101','1','Contabilizacion','24010102','15141401'),('4150102','1','Contabilizacion','24010102','15141003'),('4150103','1','Contabilizacion','24010102','15142101'),('4150104','1','Contabilizacion','24010102','15149004'),('4150105','1','Contabilizacion','24010102','15149001'),('4150201','1','Contabilizacion','24010102','15141401'),('4150202','1','Contabilizacion','24010102','15141401'),('4150203','1','Contabilizacion','24010102','15141401'),('4150301','1','Contabilizacion','24010101','75030220'),('4150401','1','Contabilizacion','24010101','75030208'),('4320101','1','Contabilizacion','24010101','511115'),('4320102','1','Contabilizacion','24010101','75030214'),('4320103','1','Contabilizacion','24010101','75030214'),('4320104','1','Contabilizacion','24010101','75030214'),('4320105','1','Contabilizacion','24010101','75030214'),('4320201','1','Contabilizacion','24010101','511150'),('51101010010101','1','Contabilizacion','251101','510101'),('51101010010102','1','Contabilizacion','251101','75040301'),('51101010010201','1','Contabilizacion','251101','75040303'),('51101010010501','1','Contabilizacion','251101','510123'),('51101010010502','1','Contabilizacion','251101','75040305'),('51101010010601','1','Contabilizacion','251106','510706'),('51101010010602','1','Contabilizacion','251106','7504903'),('51101010010701','1','Contabilizacion','25110901','51079502'),('51101010010702','1','Contabilizacion','25110901','75040909'),('51101010010801','1','Contabilizacion','251107','510705'),('51101010010802','1','Contabilizacion','251105','510704'),('51101010010803','1','Contabilizacion','251107','75040904'),('51101010010804','1','Contabilizacion','251105','75040906'),('51101010011001','1','Contabilizacion','249027','510810'),('51101010011002','1','Contabilizacion','249027','75040217'),('51101020101','1','Contabilizacion','25112201','51030701'),('51101020102','1','Contabilizacion','25112201','75040506'),('51101020201','1','Contabilizacion','25112301','51030301'),('51101020202','1','Contabilizacion','25112301','75040503'),('51101020301','1','Contabilizacion','25110201','510702'),('51101020302','1','Contabilizacion','25110201','75040901'),('51101020401','1','Contabilizacion','25110301','510703'),('51101020402','1','Contabilizacion','25110301','75040901'),('51101020501','1','Contabilizacion','25112401','510302'),('51101020502','1','Contabilizacion','25112401','75040502'),('51101020601','1','Contabilizacion','25111101','51030501'),('51101020602','1','Contabilizacion','25111101','75040505'),('511020101','1','Contabilizacion','249054','510802'),('511020102','1','Contabilizacion','249054','510802'),('511020201','1','Contabilizacion','249055','511111'),('5110203','1','Contabilizacion','249055','511163'),('511020401','1','Contabilizacion','249055','511163'),('511020601','1','Contabilizacion','251115','510803'),('511020602','1','Contabilizacion','251115','75040211'),('511020701','1','Contabilizacion','251115','510803'),('511020702','1','Contabilizacion','251115','75040223'),('511020801','1','Contabilizacion','24010101','511133'),('511020802','1','Contabilizacion','24010101','75040218'),('511021001','1','Contabilizacion','25110902','51079501'),('511021002','1','Contabilizacion','25110902','75040910'),('511021101','1','Contabilizacion','251104','510701'),('511021102','1','Contabilizacion','251104','75040905'),('5110212','1','Contabilizacion','24010101','75040218'),('5120101','1','Contabilizacion','24010102','15142101'),('5120102','1','Contabilizacion','24010102','15149001'),('5120103','1','Contabilizacion','24010102','15149002'),('5120201','1','Contabilizacion','24010102','15149004'),('5120302','1','Contabilizacion','24010101','511125'),('5120303','1','Contabilizacion','249051','75040202'),('5120304','1','Contabilizacion','244020','580536'),('5120401','1','Contabilizacion','244003','512001'),('5120402','1','Contabilizacion','244001','582101'),('5120403','1','Contabilizacion','244004','512009'),('5120404','1','Contabilizacion','244004','512009'),('5120405','1','Contabilizacion','244016','512011'),('5120501','1','Contabilizacion','244014','512002'),('5120502','1','Contabilizacion','24402301','512004'),('5150101','1','Contabilizacion','24010102','15141701'),('5150102','1','Contabilizacion','24010102','15141701'),('5150103','1','Contabilizacion','24010102','15142101'),('5150104','1','Contabilizacion','24010102','15149004'),('5150105','1','Contabilizacion','24010102','15142301'),('5150106','1','Contabilizacion','24010102','15149001'),('5150201','1','Contabilizacion','24010101','75040201'),('5150202','1','Contabilizacion','24010101','75040201'),('5150203','1','Contabilizacion','24010101','75040221'),('5150204','1','Contabilizacion','24010101','75040213'),('5150301','1','Contabilizacion','24010101','75040222'),('5320101','1','Contabilizacion','24010101','511115'),('5320102','1','Contabilizacion','24010101','75040220'),('5320103','1','Contabilizacion','24010101','75040203'),('5320104','1','Contabilizacion','24010101','75040223'),('5320105','1','Contabilizacion','24010101','75040216'),('5320201','1','Contabilizacion','24010101','511150'),('5320301','1','Contabilizacion','24010101','75040224'),('5320302','1','Contabilizacion','24010101','75040224'),('5320303','1','Contabilizacion','24010101','75040213'),('5320304','1','Contabilizacion','24010102','15141701'),('5320401','1','Contabilizacion','24010102','15141701'),('5320402','1','Contabilizacion','24010102','15141701'),('21298','1','Contabilizacion','24010101','24010101'),('31298','1','Contabilizacion','24010101','24010101'),('41298','1','Contabilizacion','24010101','24010101'),('51298','1','Contabilizacion','24010101','24010101');
/*!40000 ALTER TABLE `cuentaspred` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cuotasnom_liq`
--

DROP TABLE IF EXISTS `cuotasnom_liq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cuotasnom_liq` (
  `ct_periodo` int(7) NOT NULL DEFAULT '0',
  `ct_cedula` bigint(12) NOT NULL DEFAULT '0',
  `ct_codcon` int(4) NOT NULL,
  `ct_cobro` int(4) NOT NULL,
  `ct_totfin` double(15,2) DEFAULT NULL,
  `ct_vlrtot` double(15,2) DEFAULT NULL,
  `ct_vlrcuo` double(15,2) DEFAULT NULL,
  `ct_cuotas` int(9) DEFAULT NULL,
  `ct_pagada` int(9) DEFAULT NULL,
  `ct_fecreg` date DEFAULT NULL,
  `ct_usuari` char(12) NOT NULL,
  `ct_estado` char(1) NOT NULL DEFAULT 'A',
  PRIMARY KEY (`ct_periodo`,`ct_cedula`,`ct_codcon`,`ct_cobro`),
  KEY `ct_cedula` (`ct_cedula`),
  KEY `ct_codcon` (`ct_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cuotasnom_liq`
--

LOCK TABLES `cuotasnom_liq` WRITE;
/*!40000 ALTER TABLE `cuotasnom_liq` DISABLE KEYS */;
/*!40000 ALTER TABLE `cuotasnom_liq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cxp`
--

DROP TABLE IF EXISTS `cxp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cxp` (
  `cxp_numero` int(9) NOT NULL,
  `cxp_codcli` bigint(12) NOT NULL DEFAULT '0',
  `cxp_nropla` char(6) DEFAULT NULL,
  `cxp_codres` char(12) NOT NULL,
  `cxp_fecreg` date DEFAULT NULL,
  `cxp_horreg` time NOT NULL DEFAULT '00:00:00',
  `cxp_vlrtot` double(15,2) DEFAULT NULL,
  `cxp_descli` double(15,2) DEFAULT NULL,
  `cxp_vlriva` double(15,2) DEFAULT NULL,
  `cxp_vlretencion` double(15,2) NOT NULL,
  `cxp_vlreteica` double(15,2) NOT NULL,
  `cxp_vlretebom` double(15,2) NOT NULL,
  `cxp_vlreteiva` double(15,2) NOT NULL,
  `cxp_apagar` double(15,2) DEFAULT NULL,
  `cxp_estado` char(1) NOT NULL,
  `cxp_tippag` char(1) NOT NULL,
  `cxp_pagado` double(15,2) DEFAULT NULL,
  `cxp_observ` varchar(70) NOT NULL,
  `cxp_fecven` date DEFAULT NULL,
  `cxp_usuari` char(12) NOT NULL,
  PRIMARY KEY (`cxp_numero`),
  KEY `cxp_codcli` (`cxp_codcli`),
  KEY `cxp_nropla` (`cxp_nropla`),
  KEY `cxp_codres` (`cxp_codres`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cxp`
--

LOCK TABLES `cxp` WRITE;
/*!40000 ALTER TABLE `cxp` DISABLE KEYS */;
/*!40000 ALTER TABLE `cxp` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cxp_bas`
--

DROP TABLE IF EXISTS `cxp_bas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cxp_bas` (
  `cxp_numero` int(9) NOT NULL,
  `cxp_codcli` bigint(12) NOT NULL DEFAULT '0',
  `cxp_fecreg` date DEFAULT NULL,
  `cxp_horreg` time NOT NULL DEFAULT '00:00:00',
  `cxp_vlrtot` double(15,2) DEFAULT NULL,
  `cxp_estado` char(1) NOT NULL,
  `cxp_tippag` char(2) NOT NULL,
  `cxp_pagado` double(15,2) DEFAULT NULL,
  `cxp_observa` text NOT NULL,
  `cxp_fecven` date DEFAULT NULL,
  `cxp_usuari` char(12) NOT NULL,
  `cxp_tipcom` int(3) NOT NULL,
  `cxp_numcom` int(9) NOT NULL,
  `cxp_ordenp` int(9) NOT NULL,
  PRIMARY KEY (`cxp_numero`,`cxp_tippag`),
  KEY `cxp_codcli` (`cxp_codcli`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cxp_bas`
--

LOCK TABLES `cxp_bas` WRITE;
/*!40000 ALTER TABLE `cxp_bas` DISABLE KEYS */;
/*!40000 ALTER TABLE `cxp_bas` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `depreciacion`
--

DROP TABLE IF EXISTS `depreciacion`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `depreciacion` (
  `de_codcon` int(9) NOT NULL,
  `de_codigo` int(6) NOT NULL,
  `de_estado` char(1) NOT NULL,
  `de_vidautil` int(9) DEFAULT NULL,
  `de_serial` varchar(30) NOT NULL,
  `de_placa` text NOT NULL,
  `de_fecent` date NOT NULL,
  `de_valor` double(15,2) DEFAULT NULL,
  `de_ajuste` double(15,2) DEFAULT NULL,
  `de_depacu` double(15,2) DEFAULT NULL,
  `de_vlrper` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`de_codcon`,`de_codigo`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `depreciacion`
--

LOCK TABLES `depreciacion` WRITE;
/*!40000 ALTER TABLE `depreciacion` DISABLE KEYS */;
/*!40000 ALTER TABLE `depreciacion` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `descuentos`
--

DROP TABLE IF EXISTS `descuentos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `descuentos` (
  `de_numero` int(9) NOT NULL,
  `de_codcli` bigint(12) DEFAULT NULL,
  `de_nropla` char(6) DEFAULT NULL,
  `de_codres` char(12) NOT NULL,
  `de_fecreg` date DEFAULT NULL,
  `de_horreg` time NOT NULL DEFAULT '00:00:00',
  `de_vlrtot` double(15,2) DEFAULT NULL,
  `de_estado` char(1) NOT NULL,
  `de_tippag` char(1) NOT NULL,
  `de_pagado` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`de_numero`),
  KEY `de_codcli` (`de_codcli`),
  KEY `de_nropla` (`de_nropla`),
  KEY `de_codres` (`de_codres`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `descuentos`
--

LOCK TABLES `descuentos` WRITE;
/*!40000 ALTER TABLE `descuentos` DISABLE KEYS */;
/*!40000 ALTER TABLE `descuentos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detaumento`
--

DROP TABLE IF EXISTS `detaumento`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detaumento` (
  `daum_numero` int(9) NOT NULL,
  `daum_codcta` varchar(25) NOT NULL,
  `daum_vlrtot` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`daum_numero`,`daum_codcta`),
  KEY `daum_numero` (`daum_numero`),
  KEY `daum_codcta` (`daum_codcta`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detaumento`
--

LOCK TABLES `detaumento` WRITE;
/*!40000 ALTER TABLE `detaumento` DISABLE KEYS */;
/*!40000 ALTER TABLE `detaumento` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detavances`
--

DROP TABLE IF EXISTS `detavances`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detavances` (
  `da_numero` int(9) NOT NULL,
  `da_codcon` int(4) NOT NULL,
  `da_nrofac` int(9) NOT NULL,
  `da_vlrtot` double(15,2) DEFAULT NULL,
  `da_detalle` varchar(100) NOT NULL,
  PRIMARY KEY (`da_numero`,`da_codcon`,`da_nrofac`),
  KEY `da_numero` (`da_numero`),
  KEY `da_codcon` (`da_codcon`),
  KEY `da_nrofac` (`da_nrofac`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detavances`
--

LOCK TABLES `detavances` WRITE;
/*!40000 ALTER TABLE `detavances` DISABLE KEYS */;
/*!40000 ALTER TABLE `detavances` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detcamdispo`
--

DROP TABLE IF EXISTS `detcamdispo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detcamdispo` (
  `dcdis_numero` int(9) NOT NULL,
  `dcdis_codcta` varchar(25) NOT NULL,
  `dcdis_vlrtot` double(15,2) DEFAULT NULL,
  `dcdis_tipcam` varchar(1) NOT NULL,
  PRIMARY KEY (`dcdis_numero`,`dcdis_codcta`),
  KEY `dcdis_numero` (`dcdis_numero`),
  KEY `dcdis_codcta` (`dcdis_codcta`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detcamdispo`
--

LOCK TABLES `detcamdispo` WRITE;
/*!40000 ALTER TABLE `detcamdispo` DISABLE KEYS */;
/*!40000 ALTER TABLE `detcamdispo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detcamregistro`
--

DROP TABLE IF EXISTS `detcamregistro`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detcamregistro` (
  `dcreg_numero` int(9) NOT NULL,
  `dcreg_codcta` varchar(25) NOT NULL,
  `dcreg_vlrtot` double(15,2) DEFAULT NULL,
  `dcreg_tipcam` varchar(1) NOT NULL,
  PRIMARY KEY (`dcreg_numero`,`dcreg_codcta`),
  KEY `dcreg_numero` (`dcreg_numero`),
  KEY `dcreg_codcta` (`dcreg_codcta`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detcamregistro`
--

LOCK TABLES `detcamregistro` WRITE;
/*!40000 ALTER TABLE `detcamregistro` DISABLE KEYS */;
/*!40000 ALTER TABLE `detcamregistro` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detcom`
--

DROP TABLE IF EXISTS `detcom`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detcom` (
  `dc_numero` int(9) NOT NULL,
  `dc_codcon` int(9) NOT NULL,
  `dc_codigo` int(6) NOT NULL,
  `dc_cantid` double(15,2) DEFAULT NULL,
  `dc_vlruni` double(15,2) DEFAULT NULL,
  `dc_vlriva` double(15,2) DEFAULT NULL,
  `dc_vlrtot` double(15,2) DEFAULT NULL,
  `observacion` text,
  PRIMARY KEY (`dc_numero`,`dc_codcon`,`dc_codigo`),
  KEY `dc_numero` (`dc_numero`),
  KEY `dc_codcon` (`dc_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detcom`
--

LOCK TABLES `detcom` WRITE;
/*!40000 ALTER TABLE `detcom` DISABLE KEYS */;
/*!40000 ALTER TABLE `detcom` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detcxp`
--

DROP TABLE IF EXISTS `detcxp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detcxp` (
  `dcxp_numero` int(9) NOT NULL,
  `dcxp_codcon` int(4) NOT NULL,
  `dcxp_cantid` double(15,2) DEFAULT NULL,
  `dcxp_vlruni` double(15,2) DEFAULT NULL,
  `dcxp_vlrtot` double(15,2) DEFAULT NULL,
  `dcxp_pagos` double(15,2) DEFAULT NULL,
  `dcxp_detalle` varchar(40) NOT NULL,
  `dcxp_iva` char(12) NOT NULL,
  `dcxp_retencion` char(12) NOT NULL,
  `dcxp_reteica` char(12) NOT NULL,
  `dcxp_retebom` char(12) NOT NULL,
  `dcxp_reteiva` char(12) NOT NULL,
  `dcxp_vlriva` double(15,2) NOT NULL,
  `dcxp_vlretencion` double(15,2) NOT NULL,
  `dcxp_vlreteica` double(15,2) NOT NULL,
  `dcxp_vlretebom` double(15,2) NOT NULL,
  `dcxp_vlreteiva` double(15,2) NOT NULL,
  `dcxp_vlrcxp` double(15,2) NOT NULL,
  PRIMARY KEY (`dcxp_numero`,`dcxp_codcon`),
  KEY `dcxp_numero` (`dcxp_numero`),
  KEY `dcxp_codcon` (`dcxp_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detcxp`
--

LOCK TABLES `detcxp` WRITE;
/*!40000 ALTER TABLE `detcxp` DISABLE KEYS */;
/*!40000 ALTER TABLE `detcxp` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detdepreciacion`
--

DROP TABLE IF EXISTS `detdepreciacion`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detdepreciacion` (
  `dde_codcon` int(9) NOT NULL,
  `dde_codigo` int(6) NOT NULL,
  `dde_tipo_comp` varchar(7) NOT NULL DEFAULT 'SIIF',
  `dde_compro` varchar(10) NOT NULL,
  `dde_ccosto` int(6) NOT NULL,
  `dde_fecha` date NOT NULL,
  `dde_valor` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`dde_codcon`,`dde_codigo`,`dde_tipo_comp`,`dde_compro`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detdepreciacion`
--

LOCK TABLES `detdepreciacion` WRITE;
/*!40000 ALTER TABLE `detdepreciacion` DISABLE KEYS */;
/*!40000 ALTER TABLE `detdepreciacion` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detdescuentos`
--

DROP TABLE IF EXISTS `detdescuentos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detdescuentos` (
  `dd_numero` int(9) NOT NULL,
  `dd_codcon` int(4) NOT NULL,
  `dd_nrofac` int(9) NOT NULL,
  `dd_vlrtot` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`dd_numero`,`dd_codcon`,`dd_nrofac`),
  KEY `dd_numero` (`dd_numero`),
  KEY `dd_codcon` (`dd_codcon`),
  KEY `dd_nrofac` (`dd_nrofac`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detdescuentos`
--

LOCK TABLES `detdescuentos` WRITE;
/*!40000 ALTER TABLE `detdescuentos` DISABLE KEYS */;
/*!40000 ALTER TABLE `detdescuentos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detdisminucion`
--

DROP TABLE IF EXISTS `detdisminucion`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detdisminucion` (
  `ddim_numero` int(9) NOT NULL,
  `ddim_codcta` varchar(25) NOT NULL,
  `ddim_vlrtot` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`ddim_numero`,`ddim_codcta`),
  KEY `ddim_numero` (`ddim_numero`),
  KEY `ddim_codcta` (`ddim_codcta`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detdisminucion`
--

LOCK TABLES `detdisminucion` WRITE;
/*!40000 ALTER TABLE `detdisminucion` DISABLE KEYS */;
/*!40000 ALTER TABLE `detdisminucion` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detdisponibilidad`
--

DROP TABLE IF EXISTS `detdisponibilidad`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detdisponibilidad` (
  `ddis_numero` int(9) NOT NULL,
  `ddis_codcta` varchar(25) NOT NULL,
  `ddis_vlrtot` double(15,2) DEFAULT NULL,
  `ddis_regist` double(15,2) DEFAULT NULL,
  `ddis_girosp` double(15,2) DEFAULT NULL,
  `ddis_reinte` double(15,2) NOT NULL,
  `ddis_saldod` double(15,2) DEFAULT NULL,
  `ddis_vlrfut` double(15,2) NOT NULL,
  `ddis_ejefut` double(15,2) NOT NULL,
  PRIMARY KEY (`ddis_numero`,`ddis_codcta`),
  KEY `ddis_numero` (`ddis_numero`),
  KEY `ddis_codcta` (`ddis_codcta`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detdisponibilidad`
--

LOCK TABLES `detdisponibilidad` WRITE;
/*!40000 ALTER TABLE `detdisponibilidad` DISABLE KEYS */;
/*!40000 ALTER TABLE `detdisponibilidad` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detfac`
--

DROP TABLE IF EXISTS `detfac`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detfac` (
  `df_numero` int(9) NOT NULL,
  `df_codcon` int(4) NOT NULL,
  `df_cantid` double(15,2) DEFAULT NULL,
  `df_vlruni` double(15,2) DEFAULT NULL,
  `df_vlriva` double(15,2) DEFAULT NULL,
  `df_vlrtot` double(15,2) DEFAULT NULL,
  `df_pagos` double(15,2) DEFAULT NULL,
  `df_detalle` varchar(40) NOT NULL,
  PRIMARY KEY (`df_numero`,`df_codcon`),
  KEY `df_numero` (`df_numero`),
  KEY `df_codcon` (`df_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detfac`
--

LOCK TABLES `detfac` WRITE;
/*!40000 ALTER TABLE `detfac` DISABLE KEYS */;
/*!40000 ALTER TABLE `detfac` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detfe`
--

DROP TABLE IF EXISTS `detfe`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detfe` (
  `dfe_numero` int(9) NOT NULL,
  `dfe_codcon` int(4) NOT NULL,
  `dfe_cantid` double(15,2) DEFAULT NULL,
  `dfe_vlruni` double(15,2) DEFAULT NULL,
  `dfe_vlrtot` double(15,2) DEFAULT NULL,
  `dfe_pagos` double(15,2) DEFAULT NULL,
  `dfe_detalle` varchar(40) NOT NULL,
  `dfe_iva` char(12) NOT NULL,
  `dfe_vlriva` double(15,2) NOT NULL,
  `dfe_vlrfe` double(15,2) NOT NULL,
  PRIMARY KEY (`dfe_numero`,`dfe_codcon`),
  KEY `dfe_numero` (`dfe_numero`),
  KEY `dfe_codcon` (`dfe_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detfe`
--

LOCK TABLES `detfe` WRITE;
/*!40000 ALTER TABLE `detfe` DISABLE KEYS */;
/*!40000 ALTER TABLE `detfe` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detgiro`
--

DROP TABLE IF EXISTS `detgiro`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detgiro` (
  `dgir_numero` int(9) NOT NULL,
  `dgir_codcta` varchar(25) NOT NULL,
  `dgir_vlrtot` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`dgir_numero`,`dgir_codcta`),
  KEY `dgir_numero` (`dgir_numero`),
  KEY `dgir_codcta` (`dgir_codcta`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detgiro`
--

LOCK TABLES `detgiro` WRITE;
/*!40000 ALTER TABLE `detgiro` DISABLE KEYS */;
/*!40000 ALTER TABLE `detgiro` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detgiro_ret`
--

DROP TABLE IF EXISTS `detgiro_ret`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detgiro_ret` (
  `dgir_numero` int(9) NOT NULL,
  `dgir_codcta` varchar(25) NOT NULL,
  `dgir_dispon` int(9) NOT NULL,
  `dgir_vlrtot` double(15,2) DEFAULT NULL,
  `dgir_fecreg` date NOT NULL,
  PRIMARY KEY (`dgir_numero`,`dgir_codcta`),
  KEY `dgir_numero` (`dgir_numero`),
  KEY `dgir_codcta` (`dgir_codcta`),
  KEY `dgir_dispon` (`dgir_dispon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detgiro_ret`
--

LOCK TABLES `detgiro_ret` WRITE;
/*!40000 ALTER TABLE `detgiro_ret` DISABLE KEYS */;
/*!40000 ALTER TABLE `detgiro_ret` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detgiroct`
--

DROP TABLE IF EXISTS `detgiroct`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detgiroct` (
  `dgirt_numero` int(9) NOT NULL,
  `dgirt_codcta` varchar(25) NOT NULL,
  `dgirt_tipcta` varchar(5) NOT NULL DEFAULT '',
  PRIMARY KEY (`dgirt_numero`,`dgirt_codcta`,`dgirt_tipcta`),
  KEY `dgirt_numero` (`dgirt_numero`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detgiroct`
--

LOCK TABLES `detgiroct` WRITE;
/*!40000 ALTER TABLE `detgiroct` DISABLE KEYS */;
/*!40000 ALTER TABLE `detgiroct` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detliquinom_liq`
--

DROP TABLE IF EXISTS `detliquinom_liq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detliquinom_liq` (
  `dlq_periodo` int(7) NOT NULL DEFAULT '0',
  `dlq_cedula` bigint(12) NOT NULL DEFAULT '0',
  `dlq_codcon` int(4) NOT NULL,
  `dlq_apagar` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`dlq_periodo`,`dlq_cedula`,`dlq_codcon`),
  KEY `dlq_cedula` (`dlq_cedula`),
  KEY `dlq_codcon` (`dlq_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detliquinom_liq`
--

LOCK TABLES `detliquinom_liq` WRITE;
/*!40000 ALTER TABLE `detliquinom_liq` DISABLE KEYS */;
/*!40000 ALTER TABLE `detliquinom_liq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detliquiter_liq`
--

DROP TABLE IF EXISTS `detliquiter_liq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detliquiter_liq` (
  `dlq_numero` int(7) NOT NULL DEFAULT '0',
  `dlq_cedula` bigint(12) NOT NULL DEFAULT '0',
  `dlq_codcon` int(4) NOT NULL,
  `dlq_unidad` double(15,2) DEFAULT NULL,
  `dlq_apagar` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`dlq_numero`,`dlq_cedula`,`dlq_codcon`),
  KEY `dlq_cedula` (`dlq_cedula`),
  KEY `dlq_codcon` (`dlq_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detliquiter_liq`
--

LOCK TABLES `detliquiter_liq` WRITE;
/*!40000 ALTER TABLE `detliquiter_liq` DISABLE KEYS */;
/*!40000 ALTER TABLE `detliquiter_liq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detmovto`
--

DROP TABLE IF EXISTS `detmovto`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detmovto` (
  `dmo_tipcom` int(3) NOT NULL,
  `dmo_numero` int(9) NOT NULL,
  `dmo_secuen` int(5) NOT NULL,
  `dmo_codcta` char(12) NOT NULL,
  `dmo_tercer` bigint(12) DEFAULT NULL,
  `dmo_auxili` int(9) DEFAULT NULL,
  `dmo_codtic` char(3) NOT NULL,
  `dmo_detall` char(50) DEFAULT NULL,
  `dmo_cheque` char(12) DEFAULT NULL,
  `dmo_codcen` int(6) DEFAULT NULL,
  `dmo_tipmov` int(1) DEFAULT NULL,
  `dmo_vlrmov` double(15,2) DEFAULT NULL,
  `dmo_fecreg` date DEFAULT NULL,
  `dmo_codemp` char(8) DEFAULT NULL,
  PRIMARY KEY (`dmo_tipcom`,`dmo_numero`,`dmo_secuen`),
  KEY `dmo_tipcom` (`dmo_tipcom`,`dmo_numero`),
  KEY `dmo_codcta` (`dmo_codcta`),
  KEY `dmo_codcen` (`dmo_codcen`),
  KEY `dmo_codtic` (`dmo_codtic`),
  KEY `dmo_tipcom_2` (`dmo_tipcom`),
  KEY `dmo_tercer` (`dmo_tercer`),
  KEY `dmo_auxili` (`dmo_auxili`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detmovto`
--

LOCK TABLES `detmovto` WRITE;
/*!40000 ALTER TABLE `detmovto` DISABLE KEYS */;
/*!40000 ALTER TABLE `detmovto` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detmovto_niif`
--

DROP TABLE IF EXISTS `detmovto_niif`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detmovto_niif` (
  `dmo_tipcom` int(3) NOT NULL,
  `dmo_numero` int(9) NOT NULL,
  `dmo_secuen` int(5) NOT NULL,
  `dmo_codcta` char(12) NOT NULL,
  `dmo_tercer` bigint(12) DEFAULT NULL,
  `dmo_auxili` int(9) DEFAULT NULL,
  `dmo_codtic` char(3) NOT NULL,
  `dmo_detall` char(50) DEFAULT NULL,
  `dmo_cheque` char(12) DEFAULT NULL,
  `dmo_codcen` int(6) DEFAULT NULL,
  `dmo_tipmov` int(1) DEFAULT NULL,
  `dmo_vlrmov` double(15,2) DEFAULT NULL,
  `dmo_fecreg` date DEFAULT NULL,
  `dmo_codemp` char(8) DEFAULT NULL,
  `dmo_revela` text,
  PRIMARY KEY (`dmo_tipcom`,`dmo_numero`,`dmo_secuen`),
  KEY `dmo_tipcom` (`dmo_tipcom`,`dmo_numero`),
  KEY `dmo_codcta` (`dmo_codcta`),
  KEY `dmo_codcen` (`dmo_codcen`),
  KEY `dmo_codtic` (`dmo_codtic`),
  KEY `dmo_tipcom_2` (`dmo_tipcom`),
  KEY `dmo_tercer` (`dmo_tercer`),
  KEY `dmo_auxili` (`dmo_auxili`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detmovto_niif`
--

LOCK TABLES `detmovto_niif` WRITE;
/*!40000 ALTER TABLE `detmovto_niif` DISABLE KEYS */;
/*!40000 ALTER TABLE `detmovto_niif` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detnotas`
--

DROP TABLE IF EXISTS `detnotas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detnotas` (
  `dn_numero` int(9) NOT NULL,
  `dn_codcon` int(4) NOT NULL,
  `dn_nrofac` int(9) NOT NULL,
  `dn_vlrtot` double(15,2) DEFAULT NULL,
  `dn_detalle` varchar(100) NOT NULL,
  PRIMARY KEY (`dn_numero`,`dn_codcon`,`dn_nrofac`),
  KEY `dn_numero` (`dn_numero`),
  KEY `dn_codcon` (`dn_codcon`),
  KEY `dn_nrofac` (`dn_nrofac`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detnotas`
--

LOCK TABLES `detnotas` WRITE;
/*!40000 ALTER TABLE `detnotas` DISABLE KEYS */;
/*!40000 ALTER TABLE `detnotas` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detordenes`
--

DROP TABLE IF EXISTS `detordenes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detordenes` (
  `dor_numero` int(9) NOT NULL,
  `dor_codcon` int(9) NOT NULL,
  `dor_bodega` varchar(6) NOT NULL,
  `dor_cantid` double(15,2) DEFAULT NULL,
  `dor_vlruni` double(15,2) DEFAULT NULL,
  `dor_vlriva` double(15,2) DEFAULT NULL,
  `dor_vlrtot` double(15,2) DEFAULT NULL,
  `dor_entrega` double(15,2) NOT NULL,
  PRIMARY KEY (`dor_numero`,`dor_codcon`,`dor_bodega`),
  KEY `dor_numero` (`dor_numero`),
  KEY `dor_codcon` (`dor_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detordenes`
--

LOCK TABLES `detordenes` WRITE;
/*!40000 ALTER TABLE `detordenes` DISABLE KEYS */;
/*!40000 ALTER TABLE `detordenes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detped`
--

DROP TABLE IF EXISTS `detped`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detped` (
  `dp_numero` int(9) NOT NULL,
  `dp_codcon` int(4) NOT NULL,
  `dp_cantid` double(15,2) DEFAULT NULL,
  `dp_vlruni` double(15,2) DEFAULT NULL,
  `dp_vlrtot` double(15,2) DEFAULT NULL,
  `dp_detalle` varchar(40) NOT NULL,
  PRIMARY KEY (`dp_numero`,`dp_codcon`),
  KEY `dp_codcon` (`dp_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detped`
--

LOCK TABLES `detped` WRITE;
/*!40000 ALTER TABLE `detped` DISABLE KEYS */;
/*!40000 ALTER TABLE `detped` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detped_cxp`
--

DROP TABLE IF EXISTS `detped_cxp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detped_cxp` (
  `dp_numero` int(9) NOT NULL,
  `dp_codcon` int(4) NOT NULL,
  `dp_cantid` double(15,2) DEFAULT NULL,
  `dp_vlruni` double(15,2) DEFAULT NULL,
  `dp_vlrtot` double(15,2) DEFAULT NULL,
  `dp_detalle` varchar(40) NOT NULL,
  `dp_iva` char(12) NOT NULL,
  `dp_retencion` char(12) NOT NULL,
  `dp_reteica` char(12) NOT NULL,
  `dp_retebom` char(12) NOT NULL,
  `dp_reteiva` char(12) NOT NULL,
  `dp_vlriva` double(15,2) NOT NULL,
  `dp_vlretencion` double(15,2) NOT NULL,
  `dp_vlreteica` double(15,2) NOT NULL,
  `dp_vlretebom` double(15,2) NOT NULL,
  `dp_vlreteiva` double(15,2) NOT NULL,
  `dp_vlrcxp` double(15,2) NOT NULL,
  PRIMARY KEY (`dp_numero`,`dp_codcon`),
  KEY `dp_codcon` (`dp_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detped_cxp`
--

LOCK TABLES `detped_cxp` WRITE;
/*!40000 ALTER TABLE `detped_cxp` DISABLE KEYS */;
/*!40000 ALTER TABLE `detped_cxp` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detped_fe`
--

DROP TABLE IF EXISTS `detped_fe`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detped_fe` (
  `dp_numero` int(9) NOT NULL,
  `dp_codcon` int(4) NOT NULL,
  `dp_cantid` double(15,2) DEFAULT NULL,
  `dp_vlruni` double(15,2) DEFAULT NULL,
  `dp_vlrtot` double(15,2) DEFAULT NULL,
  `dp_detalle` varchar(80) NOT NULL,
  `dp_iva` char(12) NOT NULL,
  `dp_vlriva` double(15,2) NOT NULL,
  `dp_vlrfe` double(15,2) NOT NULL,
  PRIMARY KEY (`dp_numero`,`dp_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detped_fe`
--

LOCK TABLES `detped_fe` WRITE;
/*!40000 ALTER TABLE `detped_fe` DISABLE KEYS */;
/*!40000 ALTER TABLE `detped_fe` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detpedcom`
--

DROP TABLE IF EXISTS `detpedcom`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detpedcom` (
  `dpc_numero` int(9) NOT NULL,
  `dpc_codcon` int(9) NOT NULL,
  `dpc_cantid` double(15,2) DEFAULT NULL,
  `dpc_vlruni` double(15,2) DEFAULT NULL,
  `dpc_vlrtot` double(15,2) DEFAULT NULL,
  `dpc_iva` double(6,2) NOT NULL,
  `observacion` text,
  PRIMARY KEY (`dpc_numero`,`dpc_codcon`),
  KEY `dpc_codcon` (`dpc_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detpedcom`
--

LOCK TABLES `detpedcom` WRITE;
/*!40000 ALTER TABLE `detpedcom` DISABLE KEYS */;
/*!40000 ALTER TABLE `detpedcom` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detpedes`
--

DROP TABLE IF EXISTS `detpedes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detpedes` (
  `dpd_numero` int(9) NOT NULL,
  `dpd_codcon` int(4) NOT NULL,
  `dpd_nrofac` int(9) NOT NULL DEFAULT '0',
  `dpd_vlrtot` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`dpd_numero`,`dpd_codcon`,`dpd_nrofac`),
  KEY `dpd_codcon` (`dpd_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detpedes`
--

LOCK TABLES `detpedes` WRITE;
/*!40000 ALTER TABLE `detpedes` DISABLE KEYS */;
/*!40000 ALTER TABLE `detpedes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detpedno`
--

DROP TABLE IF EXISTS `detpedno`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detpedno` (
  `dpn_numero` int(9) NOT NULL,
  `dpn_codcon` int(9) NOT NULL,
  `dpn_nrofac` int(9) NOT NULL DEFAULT '0',
  `dpn_vlrtot` double(15,2) DEFAULT NULL,
  `dpn_detalle` varchar(100) NOT NULL,
  PRIMARY KEY (`dpn_numero`,`dpn_codcon`,`dpn_nrofac`),
  KEY `dpn_codcon` (`dpn_codcon`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detpedno`
--

LOCK TABLES `detpedno` WRITE;
/*!40000 ALTER TABLE `detpedno` DISABLE KEYS */;
/*!40000 ALTER TABLE `detpedno` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detpedped`
--

DROP TABLE IF EXISTS `detpedped`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detpedped` (
  `dpp_numero` int(9) NOT NULL,
  `dpp_codcon` int(9) NOT NULL,
  `dpp_cantid` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`dpp_numero`,`dpp_codcon`),
  KEY `dpp_codcon` (`dpp_codcon`),
  KEY `dpp_numero` (`dpp_numero`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detpedped`
--

LOCK TABLES `detpedped` WRITE;
/*!40000 ALTER TABLE `detpedped` DISABLE KEYS */;
/*!40000 ALTER TABLE `detpedped` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detpedre`
--

DROP TABLE IF EXISTS `detpedre`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detpedre` (
  `dpr_numero` int(9) NOT NULL,
  `dpr_codcon` int(4) NOT NULL,
  `dpr_nrofac` int(9) NOT NULL DEFAULT '0',
  `dpr_vlrtot` double(15,2) DEFAULT NULL,
  `dpr_detalle` varchar(100) NOT NULL,
  PRIMARY KEY (`dpr_numero`,`dpr_codcon`,`dpr_nrofac`),
  KEY `dpr_codcon` (`dpr_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detpedre`
--

LOCK TABLES `detpedre` WRITE;
/*!40000 ALTER TABLE `detpedre` DISABLE KEYS */;
/*!40000 ALTER TABLE `detpedre` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detpedre_nom`
--

DROP TABLE IF EXISTS `detpedre_nom`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detpedre_nom` (
  `dpr_numero` int(9) NOT NULL,
  `dpr_cuenta` char(12) NOT NULL,
  `dpr_ccosto` int(6) NOT NULL DEFAULT '0',
  `dpr_vlrtot` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`dpr_numero`,`dpr_cuenta`,`dpr_ccosto`),
  KEY `dpr_cuenta` (`dpr_cuenta`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detpedre_nom`
--

LOCK TABLES `detpedre_nom` WRITE;
/*!40000 ALTER TABLE `detpedre_nom` DISABLE KEYS */;
/*!40000 ALTER TABLE `detpedre_nom` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detpedrec`
--

DROP TABLE IF EXISTS `detpedrec`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detpedrec` (
  `dpr_numero` int(9) NOT NULL,
  `dpr_codcon` int(4) NOT NULL,
  `dpr_nrofac` int(9) NOT NULL DEFAULT '0',
  `dpr_vlrtot` double(15,2) DEFAULT NULL,
  `dpr_detalle` char(60) NOT NULL,
  PRIMARY KEY (`dpr_numero`,`dpr_codcon`,`dpr_nrofac`),
  KEY `dpr_codcon` (`dpr_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detpedrec`
--

LOCK TABLES `detpedrec` WRITE;
/*!40000 ALTER TABLE `detpedrec` DISABLE KEYS */;
/*!40000 ALTER TABLE `detpedrec` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detpedrec2`
--

DROP TABLE IF EXISTS `detpedrec2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detpedrec2` (
  `dpr_numero` int(9) NOT NULL,
  `dpr_codcon` varchar(20) NOT NULL,
  `dpr_tercer` varchar(15) NOT NULL DEFAULT '0',
  `dpr_vlrtot` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`dpr_numero`,`dpr_codcon`,`dpr_tercer`),
  KEY `dpr_codcon` (`dpr_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detpedrec2`
--

LOCK TABLES `detpedrec2` WRITE;
/*!40000 ALTER TABLE `detpedrec2` DISABLE KEYS */;
/*!40000 ALTER TABLE `detpedrec2` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detpedsal`
--

DROP TABLE IF EXISTS `detpedsal`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detpedsal` (
  `dps_numero` int(9) NOT NULL,
  `dps_codcon` int(4) NOT NULL,
  `dps_cantid` double(15,2) DEFAULT NULL,
  `dps_vlruni` double(15,2) NOT NULL,
  `dps_vlrtot` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`dps_numero`,`dps_codcon`),
  KEY `dps_codcon` (`dps_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detpedsal`
--

LOCK TABLES `detpedsal` WRITE;
/*!40000 ALTER TABLE `detpedsal` DISABLE KEYS */;
/*!40000 ALTER TABLE `detpedsal` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detrecaudo`
--

DROP TABLE IF EXISTS `detrecaudo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detrecaudo` (
  `drec_numero` int(9) NOT NULL,
  `drec_codcta` varchar(25) NOT NULL,
  `drec_vlrtot` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`drec_numero`,`drec_codcta`),
  KEY `drec_numero` (`drec_numero`),
  KEY `drec_codcta` (`drec_codcta`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detrecaudo`
--

LOCK TABLES `detrecaudo` WRITE;
/*!40000 ALTER TABLE `detrecaudo` DISABLE KEYS */;
/*!40000 ALTER TABLE `detrecaudo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detrecaudo_aju`
--

DROP TABLE IF EXISTS `detrecaudo_aju`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detrecaudo_aju` (
  `dreca_numero` int(9) NOT NULL,
  `dreca_ccosto` int(6) NOT NULL,
  `dreca_codcta` varchar(25) NOT NULL,
  `dreca_vlrtot` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`dreca_numero`,`dreca_ccosto`,`dreca_codcta`),
  KEY `dreca_numero` (`dreca_numero`),
  KEY `dreca_codcta` (`dreca_codcta`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detrecaudo_aju`
--

LOCK TABLES `detrecaudo_aju` WRITE;
/*!40000 ALTER TABLE `detrecaudo_aju` DISABLE KEYS */;
/*!40000 ALTER TABLE `detrecaudo_aju` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detrecibos`
--

DROP TABLE IF EXISTS `detrecibos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detrecibos` (
  `dr_numero` int(9) NOT NULL,
  `dr_codcon` int(4) NOT NULL,
  `dr_nrofac` int(9) NOT NULL,
  `dr_vlrtot` double(15,2) DEFAULT NULL,
  `dr_detalle` varchar(100) NOT NULL,
  PRIMARY KEY (`dr_numero`,`dr_codcon`,`dr_nrofac`),
  KEY `dr_numero` (`dr_numero`),
  KEY `dr_codcon` (`dr_codcon`),
  KEY `dr_nrofac` (`dr_nrofac`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detrecibos`
--

LOCK TABLES `detrecibos` WRITE;
/*!40000 ALTER TABLE `detrecibos` DISABLE KEYS */;
/*!40000 ALTER TABLE `detrecibos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detrecibosp`
--

DROP TABLE IF EXISTS `detrecibosp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detrecibosp` (
  `dr_numero` int(9) NOT NULL,
  `dr_codcon` int(4) NOT NULL,
  `dr_nrofac` int(9) NOT NULL,
  `dr_vlrtot` float(15,2) DEFAULT NULL,
  `dr_detalle` char(60) NOT NULL,
  PRIMARY KEY (`dr_numero`,`dr_codcon`,`dr_nrofac`),
  KEY `dr_numero` (`dr_numero`),
  KEY `dr_codcon` (`dr_codcon`),
  KEY `dr_nrofac` (`dr_nrofac`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detrecibosp`
--

LOCK TABLES `detrecibosp` WRITE;
/*!40000 ALTER TABLE `detrecibosp` DISABLE KEYS */;
/*!40000 ALTER TABLE `detrecibosp` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detrecibosp2`
--

DROP TABLE IF EXISTS `detrecibosp2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detrecibosp2` (
  `dr_numero` int(9) NOT NULL,
  `dr_codcon` varchar(15) NOT NULL,
  `dr_tercer` varchar(15) NOT NULL,
  `dr_vlrtot` float(15,2) DEFAULT NULL,
  PRIMARY KEY (`dr_numero`,`dr_codcon`,`dr_tercer`),
  KEY `dr_numero` (`dr_numero`),
  KEY `dr_codcon` (`dr_codcon`),
  KEY `dr_nrofac` (`dr_tercer`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detrecibosp2`
--

LOCK TABLES `detrecibosp2` WRITE;
/*!40000 ALTER TABLE `detrecibosp2` DISABLE KEYS */;
/*!40000 ALTER TABLE `detrecibosp2` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detrecibosp_nom`
--

DROP TABLE IF EXISTS `detrecibosp_nom`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detrecibosp_nom` (
  `dr_numero` int(9) NOT NULL,
  `dr_cuenta` char(12) NOT NULL,
  `dr_ccosto` int(6) NOT NULL,
  `dr_vlrtot` double(15,2) DEFAULT NULL,
  `dr_detalle` char(60) NOT NULL,
  PRIMARY KEY (`dr_numero`,`dr_cuenta`,`dr_ccosto`),
  KEY `dr_numero` (`dr_numero`),
  KEY `dr_codcon` (`dr_cuenta`),
  KEY `dr_nrofac` (`dr_ccosto`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detrecibosp_nom`
--

LOCK TABLES `detrecibosp_nom` WRITE;
/*!40000 ALTER TABLE `detrecibosp_nom` DISABLE KEYS */;
/*!40000 ALTER TABLE `detrecibosp_nom` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detregistro`
--

DROP TABLE IF EXISTS `detregistro`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detregistro` (
  `dreg_numero` int(9) NOT NULL,
  `dreg_codcta` varchar(25) NOT NULL,
  `dreg_vlrtot` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`dreg_numero`,`dreg_codcta`),
  KEY `dreg_numero` (`dreg_numero`),
  KEY `dreg_codcta` (`dreg_codcta`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detregistro`
--

LOCK TABLES `detregistro` WRITE;
/*!40000 ALTER TABLE `detregistro` DISABLE KEYS */;
/*!40000 ALTER TABLE `detregistro` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detregistroc`
--

DROP TABLE IF EXISTS `detregistroc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detregistroc` (
  `dreg_numero` int(9) NOT NULL,
  `dreg_codcta` varchar(25) NOT NULL,
  `dreg_codcen` int(6) NOT NULL,
  `dreg_vlrtot` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`dreg_numero`,`dreg_codcta`,`dreg_codcen`),
  KEY `dreg_numero` (`dreg_numero`),
  KEY `dreg_codcen` (`dreg_codcen`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detregistroc`
--

LOCK TABLES `detregistroc` WRITE;
/*!40000 ALTER TABLE `detregistroc` DISABLE KEYS */;
/*!40000 ALTER TABLE `detregistroc` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detregistroct`
--

DROP TABLE IF EXISTS `detregistroct`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detregistroct` (
  `dregt_numero` int(9) NOT NULL,
  `dregt_codcta` varchar(25) NOT NULL,
  `dregt_tipcta` varchar(5) NOT NULL DEFAULT '',
  PRIMARY KEY (`dregt_numero`,`dregt_codcta`,`dregt_tipcta`),
  KEY `dregt_numero` (`dregt_numero`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detregistroct`
--

LOCK TABLES `detregistroct` WRITE;
/*!40000 ALTER TABLE `detregistroct` DISABLE KEYS */;
/*!40000 ALTER TABLE `detregistroct` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detregistrop`
--

DROP TABLE IF EXISTS `detregistrop`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detregistrop` (
  `dregp_numero` int(9) NOT NULL,
  `dregp_codcta` varchar(25) NOT NULL,
  `dregp_vlrtot` double(15,2) DEFAULT NULL,
  `dregp_pagado` double(15,2) NOT NULL,
  PRIMARY KEY (`dregp_numero`,`dregp_codcta`),
  KEY `dregp_numero` (`dregp_numero`),
  KEY `dregp_codcta` (`dregp_codcta`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detregistrop`
--

LOCK TABLES `detregistrop` WRITE;
/*!40000 ALTER TABLE `detregistrop` DISABLE KEYS */;
/*!40000 ALTER TABLE `detregistrop` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detreintegro`
--

DROP TABLE IF EXISTS `detreintegro`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detreintegro` (
  `drei_numero` int(9) NOT NULL,
  `drei_codcta` varchar(25) NOT NULL,
  `drei_vlrtot` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`drei_numero`,`drei_codcta`),
  KEY `drei_numero` (`drei_numero`),
  KEY `drei_codcta` (`drei_codcta`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detreintegro`
--

LOCK TABLES `detreintegro` WRITE;
/*!40000 ALTER TABLE `detreintegro` DISABLE KEYS */;
/*!40000 ALTER TABLE `detreintegro` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detsalidas`
--

DROP TABLE IF EXISTS `detsalidas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detsalidas` (
  `ds_tipo_sa` int(1) NOT NULL,
  `ds_numero` int(9) NOT NULL,
  `ds_codcon` int(4) NOT NULL,
  `ds_cantid` double(15,2) DEFAULT NULL,
  `ds_vlruni` double(15,2) DEFAULT NULL,
  `ds_vlriva` double(15,2) DEFAULT NULL,
  `ds_vlrtot` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`ds_tipo_sa`,`ds_numero`,`ds_codcon`),
  KEY `ds_codcon` (`ds_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detsalidas`
--

LOCK TABLES `detsalidas` WRITE;
/*!40000 ALTER TABLE `detsalidas` DISABLE KEYS */;
/*!40000 ALTER TABLE `detsalidas` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detsalidasdev`
--

DROP TABLE IF EXISTS `detsalidasdev`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detsalidasdev` (
  `ds_tipo_sa` int(1) NOT NULL,
  `ds_numero` int(9) NOT NULL,
  `ds_codcon` int(4) NOT NULL,
  `ds_cantid` float(9,2) DEFAULT NULL,
  `ds_vlruni` int(9) DEFAULT NULL,
  `ds_vlriva` int(9) DEFAULT NULL,
  `ds_vlrtot` int(9) DEFAULT NULL,
  PRIMARY KEY (`ds_tipo_sa`,`ds_numero`,`ds_codcon`),
  KEY `ds_codcon` (`ds_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detsalidasdev`
--

LOCK TABLES `detsalidasdev` WRITE;
/*!40000 ALTER TABLE `detsalidasdev` DISABLE KEYS */;
/*!40000 ALTER TABLE `detsalidasdev` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detsolicitud`
--

DROP TABLE IF EXISTS `detsolicitud`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detsolicitud` (
  `ddis_numero` int(9) NOT NULL,
  `ddis_codcta` varchar(25) NOT NULL,
  `ddis_vlrtot` double(15,2) DEFAULT NULL,
  `ddis_regist` double(15,2) DEFAULT NULL,
  `ddis_girosp` double(15,2) DEFAULT NULL,
  `ddis_reinte` double(15,2) NOT NULL,
  `ddis_saldod` double(15,2) DEFAULT NULL,
  `ddis_vlrfut` double(15,2) NOT NULL,
  `ddis_ejefut` double(15,2) NOT NULL,
  PRIMARY KEY (`ddis_numero`,`ddis_codcta`),
  KEY `ddis_numero` (`ddis_numero`),
  KEY `ddis_codcta` (`ddis_codcta`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detsolicitud`
--

LOCK TABLES `detsolicitud` WRITE;
/*!40000 ALTER TABLE `detsolicitud` DISABLE KEYS */;
/*!40000 ALTER TABLE `detsolicitud` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dettraslado`
--

DROP TABLE IF EXISTS `dettraslado`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dettraslado` (
  `dtra_numero` int(9) NOT NULL,
  `dtra_codcta` varchar(25) NOT NULL,
  `dtra_coddes` varchar(25) NOT NULL,
  `dtra_vlrtot` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`dtra_numero`,`dtra_codcta`,`dtra_coddes`),
  KEY `dtra_numero` (`dtra_numero`),
  KEY `dtra_codcta` (`dtra_codcta`),
  KEY `dtra_coddes` (`dtra_codcta`),
  KEY `dettraslado_ibfk_3` (`dtra_coddes`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dettraslado`
--

LOCK TABLES `dettraslado` WRITE;
/*!40000 ALTER TABLE `dettraslado` DISABLE KEYS */;
/*!40000 ALTER TABLE `dettraslado` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `diariocol`
--

DROP TABLE IF EXISTS `diariocol`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `diariocol` (
  `dco_tipcom` int(3) NOT NULL,
  `dco_codcta` char(4) NOT NULL DEFAULT '',
  `dco_nombre` char(50) DEFAULT NULL,
  `dco_descri` char(30) NOT NULL,
  `dco_debmes` float(10,2) DEFAULT NULL,
  `dco_cremes` float(10,2) DEFAULT NULL,
  PRIMARY KEY (`dco_tipcom`,`dco_codcta`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `diariocol`
--

LOCK TABLES `diariocol` WRITE;
/*!40000 ALTER TABLE `diariocol` DISABLE KEYS */;
/*!40000 ALTER TABLE `diariocol` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `diasvaca_liq`
--

DROP TABLE IF EXISTS `diasvaca_liq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `diasvaca_liq` (
  `dv_periodo` int(7) NOT NULL DEFAULT '0',
  `dv_cedula` bigint(12) NOT NULL DEFAULT '0',
  `dv_pendientes` double(15,3) DEFAULT NULL,
  `dv_disfrutados` double(15,3) DEFAULT NULL,
  `dv_generados` double(15,3) NOT NULL,
  `dv_nuevos` double(15,3) NOT NULL,
  PRIMARY KEY (`dv_periodo`,`dv_cedula`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `diasvaca_liq`
--

LOCK TABLES `diasvaca_liq` WRITE;
/*!40000 ALTER TABLE `diasvaca_liq` DISABLE KEYS */;
/*!40000 ALTER TABLE `diasvaca_liq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `disminucion`
--

DROP TABLE IF EXISTS `disminucion`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `disminucion` (
  `dim_numero` int(9) NOT NULL,
  `dim_codres` char(12) NOT NULL,
  `dim_fecreg` date DEFAULT NULL,
  `dim_horreg` time NOT NULL DEFAULT '00:00:00',
  `dim_estado` char(1) NOT NULL,
  `dim_tippag` char(1) NOT NULL,
  `dim_vlrtot` double(15,2) DEFAULT NULL,
  `dim_detalle` text NOT NULL,
  `dim_feccre` date NOT NULL,
  `dim_anopre` int(4) NOT NULL,
  PRIMARY KEY (`dim_numero`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `disminucion`
--

LOCK TABLES `disminucion` WRITE;
/*!40000 ALTER TABLE `disminucion` DISABLE KEYS */;
/*!40000 ALTER TABLE `disminucion` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `disponibilidad`
--

DROP TABLE IF EXISTS `disponibilidad`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `disponibilidad` (
  `dis_numero` int(9) NOT NULL,
  `dis_codcli` bigint(12) DEFAULT NULL,
  `dis_codres` char(12) NOT NULL,
  `dis_fecreg` date DEFAULT NULL,
  `dis_horreg` time NOT NULL DEFAULT '00:00:00',
  `dis_estado` char(1) NOT NULL,
  `dis_tippag` char(1) NOT NULL,
  `dis_vlrtot` double(15,2) DEFAULT NULL,
  `dis_regist` double(15,2) DEFAULT NULL,
  `dis_girosp` double(15,2) DEFAULT NULL,
  `dis_reinte` double(15,2) NOT NULL,
  `dis_saldod` double(15,2) DEFAULT NULL,
  `dis_detalle` text NOT NULL,
  `dis_feccre` date NOT NULL,
  `dis_vlrfut` double(15,2) NOT NULL,
  `dis_ejefut` double(15,2) NOT NULL,
  PRIMARY KEY (`dis_numero`),
  KEY `dis_codcli` (`dis_codcli`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `disponibilidad`
--

LOCK TABLES `disponibilidad` WRITE;
/*!40000 ALTER TABLE `disponibilidad` DISABLE KEYS */;
/*!40000 ALTER TABLE `disponibilidad` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `empleado_fir`
--

DROP TABLE IF EXISTS `empleado_fir`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `empleado_fir` (
  `em_codemp` char(12) NOT NULL DEFAULT '',
  `em_nombre` char(60) NOT NULL DEFAULT '',
  `em_direcc` char(60) NOT NULL DEFAULT '',
  `em_telefo` char(10) NOT NULL DEFAULT '',
  `em_profes` char(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`em_codemp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `empleado_fir`
--

LOCK TABLES `empleado_fir` WRITE;
/*!40000 ALTER TABLE `empleado_fir` DISABLE KEYS */;
/*!40000 ALTER TABLE `empleado_fir` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `empleadonom`
--

DROP TABLE IF EXISTS `empleadonom`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `empleadonom` (
  `em_cedula` bigint(12) NOT NULL DEFAULT '0',
  `em_nombre` char(50) NOT NULL DEFAULT '',
  `em_direcc` char(50) NOT NULL DEFAULT '',
  `em_telefo` char(12) NOT NULL DEFAULT '',
  `em_estciv` char(1) NOT NULL,
  `em_numhij` int(3) DEFAULT NULL,
  `em_enteps` bigint(12) NOT NULL DEFAULT '0',
  `em_entarp` bigint(12) NOT NULL DEFAULT '0',
  `em_entpen` bigint(12) NOT NULL DEFAULT '0',
  `em_entcaj` bigint(12) NOT NULL DEFAULT '0',
  `em_ccosto` int(6) NOT NULL DEFAULT '0',
  `em_grupo` int(4) NOT NULL DEFAULT '0',
  `em_fecnac` date DEFAULT NULL,
  `em_fecing` date DEFAULT NULL,
  `em_salbas` double(9,2) DEFAULT NULL,
  `em_estado` char(2) NOT NULL,
  `em_nivest` char(1) DEFAULT NULL,
  `em_catlic` char(1) NOT NULL,
  `em_nrolic` char(25) NOT NULL,
  `em_tipcon` char(1) DEFAULT NULL,
  `em_tipoem` char(4) DEFAULT NULL,
  `em_riesgo` double(9,5) DEFAULT NULL,
  `em_cargo` char(4) NOT NULL DEFAULT '0',
  `em_sexo` char(1) DEFAULT NULL,
  `em_fecter` date DEFAULT NULL,
  `em_correo` varchar(70) NOT NULL,
  `em_nombres` varchar(60) NOT NULL,
  `em_apellidos` varchar(60) NOT NULL,
  PRIMARY KEY (`em_cedula`),
  KEY `em_enteps` (`em_enteps`),
  KEY `em_entarp` (`em_entarp`),
  KEY `em_entpen` (`em_entpen`),
  KEY `em_ccosto` (`em_ccosto`),
  KEY `em_grupo` (`em_grupo`),
  KEY `em_entcaj` (`em_entcaj`),
  KEY `em_cargo` (`em_cargo`),
  KEY `em_tipoem` (`em_tipoem`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `empleadonom`
--

LOCK TABLES `empleadonom` WRITE;
/*!40000 ALTER TABLE `empleadonom` DISABLE KEYS */;
/*!40000 ALTER TABLE `empleadonom` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `empleadonom_dis`
--

DROP TABLE IF EXISTS `empleadonom_dis`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `empleadonom_dis` (
  `emd_cedula` bigint(12) NOT NULL DEFAULT '0',
  `emd_mcpio` int(9) NOT NULL DEFAULT '0',
  `emd_porce` double(15,3) DEFAULT NULL,
  PRIMARY KEY (`emd_cedula`,`emd_mcpio`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `empleadonom_dis`
--

LOCK TABLES `empleadonom_dis` WRITE;
/*!40000 ALTER TABLE `empleadonom_dis` DISABLE KEYS */;
/*!40000 ALTER TABLE `empleadonom_dis` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `empleadonom_liq`
--

DROP TABLE IF EXISTS `empleadonom_liq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `empleadonom_liq` (
  `em_periodo` int(7) NOT NULL DEFAULT '0',
  `em_cedula` bigint(12) NOT NULL DEFAULT '0',
  `em_nombre` char(50) NOT NULL DEFAULT '',
  `em_direcc` char(50) NOT NULL DEFAULT '',
  `em_telefo` char(12) NOT NULL DEFAULT '',
  `em_estciv` char(1) NOT NULL,
  `em_numhij` int(3) DEFAULT NULL,
  `em_enteps` bigint(12) NOT NULL DEFAULT '0',
  `em_entarp` bigint(12) NOT NULL DEFAULT '0',
  `em_entpen` bigint(12) NOT NULL DEFAULT '0',
  `em_entcaj` bigint(12) NOT NULL DEFAULT '0',
  `em_ccosto` int(6) NOT NULL DEFAULT '0',
  `em_grupo` int(4) NOT NULL DEFAULT '0',
  `em_fecnac` date DEFAULT NULL,
  `em_fecing` date DEFAULT NULL,
  `em_salbas` double(9,2) DEFAULT NULL,
  `em_estado` char(2) NOT NULL,
  `em_nivest` char(1) DEFAULT NULL,
  `em_catlic` char(1) NOT NULL,
  `em_nrolic` char(15) NOT NULL,
  `em_tipcon` char(1) DEFAULT NULL,
  `em_tipoem` char(4) DEFAULT NULL,
  `em_riesgo` double(9,5) DEFAULT NULL,
  `em_cargo` char(4) NOT NULL DEFAULT '0',
  `em_sexo` char(1) DEFAULT NULL,
  `em_fecter` date DEFAULT NULL,
  `em_correo` varchar(70) NOT NULL,
  `em_nombres` varchar(60) NOT NULL,
  `em_apellidos` varchar(60) NOT NULL,
  PRIMARY KEY (`em_periodo`,`em_cedula`),
  KEY `em_enteps` (`em_enteps`),
  KEY `em_entarp` (`em_entarp`),
  KEY `em_entpen` (`em_entpen`),
  KEY `em_ccosto` (`em_ccosto`),
  KEY `em_grupo` (`em_grupo`),
  KEY `em_entcaj` (`em_entcaj`),
  KEY `em_cargo` (`em_cargo`),
  KEY `em_tipoem` (`em_tipoem`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `empleadonom_liq`
--

LOCK TABLES `empleadonom_liq` WRITE;
/*!40000 ALTER TABLE `empleadonom_liq` DISABLE KEYS */;
/*!40000 ALTER TABLE `empleadonom_liq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `empresa`
--

DROP TABLE IF EXISTS `empresa`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `empresa` (
  `ep_codemp` char(12) NOT NULL DEFAULT '',
  `ep_nombre` char(70) NOT NULL DEFAULT '',
  `ep_direcc` char(40) NOT NULL DEFAULT '',
  `ep_telefo` char(10) NOT NULL DEFAULT '',
  `ep_dpto` varchar(3) NOT NULL,
  `ep_mcpio` varchar(3) NOT NULL,
  PRIMARY KEY (`ep_codemp`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `empresa`
--

LOCK TABLES `empresa` WRITE;
/*!40000 ALTER TABLE `empresa` DISABLE KEYS */;
INSERT INTO `empresa` (`ep_codemp`, `ep_nombre`, `ep_direcc`, `ep_telefo`, `ep_dpto`, `ep_mcpio`) VALUES ('828000191-2','EMPRESA MUNICIPAL DE SERVICIOS PUBLICOS DE CARTAGENA DEL CHAIRA','CL 4 5 32 BRR EL CENTRO','3108715677','','');
/*!40000 ALTER TABLE `empresa` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `entidad`
--

DROP TABLE IF EXISTS `entidad`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `entidad` (
  `en_codigo` bigint(12) NOT NULL DEFAULT '0',
  `en_nombre` char(50) NOT NULL DEFAULT '',
  `en_respon` char(50) NOT NULL DEFAULT '',
  `en_telefo` char(12) NOT NULL DEFAULT '',
  PRIMARY KEY (`en_codigo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `entidad`
--

LOCK TABLES `entidad` WRITE;
/*!40000 ALTER TABLE `entidad` DISABLE KEYS */;
INSERT INTO `entidad` (`en_codigo`, `en_nombre`, `en_respon`, `en_telefo`) VALUES (0,'NO APLICA','NO APLICA','0'),(890924205,'FONDO NACIONAL DEL AHORRO','FONDO NACIONAL DEL AHORRO','270000'),(800130907,'SALUD TOTAL','SALUD TOTAL','EPS002'),(800140949,'CAFESALUD','CAFESALUD','EPS003'),(891800213,'COMFABOY','COMFABOY','CCF10'),(800224808,'PORVENIR','PORVENIR','230301'),(800226175,'COLMENA','COLMENA','14-25'),(800227940,'COLFONDOS','COLFONDOS','231001'),(800229739,'PROTECCION','PROTECCION','230201'),(800231967,'HORIZONTE','HORIZONTE','230501'),(800250119,'SALUDCOOP','SALUDCOOP','EPS013'),(800251440,'SANITAS','SANITAS','EPS005'),(804002273,'SOLSALUD','SOLSALUD','EPS026'),(805000427,'COOMEVA','COOMEVA','EPS016'),(805001157,'S.O.S. SERVICIO OCCIDENTAL DE SALUD S.A.','S.O.S. SERVICIO OCCIDENTAL DE SALUD S.A.','EPS018'),(830006404,'HUMANA VIVIR','HUMANA VIVIR','EPS014'),(830074184,'SALUDVIDA','SALUDVIDA','EPS033'),(860002503,'SEGUROS BOLIVAR','SEGUROS BOLIVAR','ARP14-7'),(890700148,'COMFENALCO TOLIMA','COMFENALCO TOLIMA','CCF50'),(899999034,'SENA','SENA','PASENA'),(899999239,'INSTITUTO COLOMBIANO DE BIENESTAR FAMILIAR','INSTITUTO COLOMBIANO DE BIENESTAR FAMILIAR','PAICBF'),(900074992,'GOLDEN CROSS S.A.','GOLDEN CROSS S.A.','EPS039'),(900156264,'NUEVA EPS','NUEVA EPS','EPS037'),(900336004,'COLPENSIONES','COLPENSIONES','25-14'),(830054904,'MAPFRE','','14-30'),(892200015,'COMFASUCRE','COMFASUCRE','CCF41'),(806008394,'MUTUAL SER','MUTUAL SER','ESS207'),(860011153,'POSITIVA ARL','','14-23'),(8300035647,'FAMISANAR','FAMISANAR','EPS017'),(892115006,'COMFAGUAJIRA','LUIS EDUARDO MEDINA ROMERO','CCFC23'),(8001485142,'OLDMUTUAL','OLDMUTUAL','230901'),(9010974735,'MEDIMAS','MEDIMAS','EPS044'),(8902015787,'COMFENALCO SANTANDER','COMFENALCO SANTANDER','CCF40'),(8002561619,'SEGUROS DE RIESGOS LABORALES SURAMERICANA','SEGUROS DE RIESGOS LABORALES SURAMERINACA','14-28'),(8040021050,'COMPARTA','COMPARTA','ESSC33'),(891190047,'COMFACA CAJA','COMFACA CAJA','CCF13'),(900935126,'ASMET SALUD EPS','ASMET SALUD EPS','EPS54');
/*!40000 ALTER TABLE `entidad` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `estudios`
--

DROP TABLE IF EXISTS `estudios`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `estudios` (
  `est_codcli` bigint(12) NOT NULL DEFAULT '0',
  `est_registro` int(11) NOT NULL,
  `est_titulo` char(40) NOT NULL DEFAULT '',
  `est_institucion` char(40) NOT NULL DEFAULT '',
  `est_ciudad` char(20) NOT NULL DEFAULT '',
  `est_anos` int(2) DEFAULT NULL,
  `est_fecter` date DEFAULT NULL,
  PRIMARY KEY (`est_codcli`,`est_registro`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `estudios`
--

LOCK TABLES `estudios` WRITE;
/*!40000 ALTER TABLE `estudios` DISABLE KEYS */;
/*!40000 ALTER TABLE `estudios` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `exogena`
--

DROP TABLE IF EXISTS `exogena`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `exogena` (
  `exo_vigencia` int(4) NOT NULL,
  `exo_formato` char(12) NOT NULL,
  `exo_concepto` char(12) NOT NULL,
  `exo_nit` bigint(12) NOT NULL,
  `exo_col1` double(15,2) NOT NULL,
  `exo_col2` double(15,2) NOT NULL,
  `exo_col3` double(15,2) NOT NULL,
  `exo_col4` double(15,2) NOT NULL,
  `exo_col5` double(15,2) NOT NULL,
  `exo_col6` double(15,2) NOT NULL,
  `exo_col7` double(15,2) NOT NULL,
  `exo_col8` double(15,2) NOT NULL,
  `exo_col9` double(15,2) NOT NULL,
  PRIMARY KEY (`exo_vigencia`,`exo_formato`,`exo_concepto`,`exo_nit`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `exogena`
--

LOCK TABLES `exogena` WRITE;
/*!40000 ALTER TABLE `exogena` DISABLE KEYS */;
/*!40000 ALTER TABLE `exogena` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `experiencia`
--

DROP TABLE IF EXISTS `experiencia`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `experiencia` (
  `exp_codcli` bigint(12) NOT NULL DEFAULT '0',
  `exp_registro` int(11) NOT NULL,
  `exp_empresa` char(40) NOT NULL DEFAULT '',
  `exp_direccion` char(40) NOT NULL DEFAULT '',
  `exp_cargo` char(20) NOT NULL DEFAULT '',
  `exp_jefe` char(40) NOT NULL DEFAULT '',
  `exp_telefo` char(20) NOT NULL DEFAULT '',
  `exp_fecing` date DEFAULT NULL,
  `exp_fecret` date DEFAULT NULL,
  `exp_motivo` char(15) NOT NULL DEFAULT '',
  `exp_placa` char(10) NOT NULL DEFAULT '',
  PRIMARY KEY (`exp_codcli`,`exp_registro`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `experiencia`
--

LOCK TABLES `experiencia` WRITE;
/*!40000 ALTER TABLE `experiencia` DISABLE KEYS */;
/*!40000 ALTER TABLE `experiencia` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `facturas`
--

DROP TABLE IF EXISTS `facturas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `facturas` (
  `fa_numero` int(9) NOT NULL,
  `fa_codcli` bigint(12) NOT NULL DEFAULT '0',
  `fa_nropla` char(6) DEFAULT NULL,
  `fa_codres` char(12) NOT NULL,
  `fa_fecreg` date DEFAULT NULL,
  `fa_horreg` time NOT NULL DEFAULT '00:00:00',
  `fa_vlrtot` double(15,2) DEFAULT NULL,
  `fa_descli` double(15,2) DEFAULT NULL,
  `fa_vlriva` double(15,2) DEFAULT NULL,
  `fa_apagar` double(15,2) DEFAULT NULL,
  `fa_estado` char(1) NOT NULL,
  `fa_tippag` char(1) NOT NULL,
  `fa_pagado` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`fa_numero`),
  KEY `fa_codcli` (`fa_codcli`),
  KEY `fa_nropla` (`fa_nropla`),
  KEY `fa_codres` (`fa_codres`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `facturas`
--

LOCK TABLES `facturas` WRITE;
/*!40000 ALTER TABLE `facturas` DISABLE KEYS */;
/*!40000 ALTER TABLE `facturas` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `falta`
--

DROP TABLE IF EXISTS `falta`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `falta` (
  `fal_codigo` char(2) NOT NULL,
  `fal_descri` char(50) DEFAULT NULL,
  `fal_dias` int(11) DEFAULT NULL,
  PRIMARY KEY (`fal_codigo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `falta`
--

LOCK TABLES `falta` WRITE;
/*!40000 ALTER TABLE `falta` DISABLE KEYS */;
INSERT INTO `falta` (`fal_codigo`, `fal_descri`, `fal_dias`) VALUES ('1','Inasistencia',3),('2','VACACIONES',1);
/*!40000 ALTER TABLE `falta` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `familia`
--

DROP TABLE IF EXISTS `familia`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `familia` (
  `fam_codcli` bigint(12) NOT NULL DEFAULT '0',
  `fam_registro` int(11) NOT NULL,
  `fam_nombre` char(40) NOT NULL DEFAULT '',
  `fam_direccion` char(40) NOT NULL DEFAULT '',
  `fam_parentesco` char(20) NOT NULL DEFAULT '',
  `fam_anos` date DEFAULT NULL,
  PRIMARY KEY (`fam_codcli`,`fam_registro`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `familia`
--

LOCK TABLES `familia` WRITE;
/*!40000 ALTER TABLE `familia` DISABLE KEYS */;
/*!40000 ALTER TABLE `familia` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `fe`
--

DROP TABLE IF EXISTS `fe`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fe` (
  `fe_numero` int(9) NOT NULL,
  `fe_codcli` bigint(12) NOT NULL DEFAULT '0',
  `fe_codpro` bigint(12) NOT NULL DEFAULT '0',
  `fe_nropla` char(6) DEFAULT NULL,
  `fe_codres` char(12) NOT NULL,
  `fe_fecreg` date DEFAULT NULL,
  `fe_horreg` time NOT NULL DEFAULT '00:00:00',
  `fe_vlrtot` double(15,2) DEFAULT NULL,
  `fe_descli` double(15,2) DEFAULT NULL,
  `fe_vlriva` double(15,2) DEFAULT NULL,
  `fe_apagar` double(15,2) DEFAULT NULL,
  `fe_estado` char(1) NOT NULL,
  `fe_tippag` char(1) NOT NULL,
  `fe_pagado` double(15,2) DEFAULT NULL,
  `fe_observ` varchar(70) NOT NULL,
  `fe_fecven` date DEFAULT NULL,
  `fe_usuari` char(12) NOT NULL,
  PRIMARY KEY (`fe_numero`),
  KEY `fe_codcli` (`fe_codcli`),
  KEY `fe_codpro` (`fe_codpro`),
  KEY `fe_nropla` (`fe_nropla`),
  KEY `fe_codres` (`fe_codres`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fe`
--

LOCK TABLES `fe` WRITE;
/*!40000 ALTER TABLE `fe` DISABLE KEYS */;
/*!40000 ALTER TABLE `fe` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `giro`
--

DROP TABLE IF EXISTS `giro`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `giro` (
  `gir_numero` int(9) NOT NULL,
  `gir_codcli` bigint(12) DEFAULT NULL,
  `gir_codres` char(12) NOT NULL,
  `gir_fecreg` date DEFAULT NULL,
  `gir_horreg` time NOT NULL DEFAULT '00:00:00',
  `gir_estado` char(1) NOT NULL,
  `gir_tippag` char(1) NOT NULL,
  `gir_dispon` int(9) NOT NULL,
  `gir_vlrtot` double(15,2) DEFAULT NULL,
  `gir_detalle` text NOT NULL,
  `gir_feccre` date NOT NULL,
  `gir_cuenta` char(12) NOT NULL,
  `gir_cretencion` varchar(12) NOT NULL,
  `gir_creteica` varchar(12) NOT NULL,
  `gir_retencion` double(15,2) NOT NULL,
  `gir_reteica` double(15,2) NOT NULL,
  `gir_ccosto` int(6) NOT NULL,
  `gir_vlrgir` double(15,2) NOT NULL,
  `gir_cheque` varchar(12) NOT NULL,
  `gir_codaux` int(9) NOT NULL,
  `gir_egreso` int(9) NOT NULL,
  `gir_origen` varchar(20) NOT NULL,
  PRIMARY KEY (`gir_numero`),
  KEY `gir_codcli` (`gir_codcli`),
  KEY `gir_dispon` (`gir_dispon`),
  KEY `gir_cuenta` (`gir_cuenta`),
  KEY `gir_codaux` (`gir_codaux`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `giro`
--

LOCK TABLES `giro` WRITE;
/*!40000 ALTER TABLE `giro` DISABLE KEYS */;
/*!40000 ALTER TABLE `giro` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `grupo`
--

DROP TABLE IF EXISTS `grupo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `grupo` (
  `gr_codgru` int(3) NOT NULL DEFAULT '0',
  `gr_descri` varchar(80) NOT NULL,
  `entradas_deb` varchar(15) NOT NULL,
  `entradas_cre` varchar(15) NOT NULL,
  `salidas_deb` varchar(15) NOT NULL,
  `salidas_cre` varchar(15) NOT NULL,
  PRIMARY KEY (`gr_codgru`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `grupo`
--

LOCK TABLES `grupo` WRITE;
/*!40000 ALTER TABLE `grupo` DISABLE KEYS */;
INSERT INTO `grupo` (`gr_codgru`, `gr_descri`, `entradas_deb`, `entradas_cre`, `salidas_deb`, `salidas_cre`) VALUES (1,'INGRESOS','','','',''),(2,'GASTOS','','','',''),(219,'Otros','','','',''),(215,'Equipos de comedor, cocina y hoteleria','','','',''),(222,'Redes, lineas y cables','','','',''),(230,'Edificios y Construcciones',' ',' ',' ',' '),(221,'Plantas, Ductos y tuneles',' ',' ',' ',' '),(218,'Mobiliario y Enseres',' ',' ',' ',' '),(220,'Vestuario, Ropa y Equipo',' ',' ',' ',' '),(217,'Llantas y Neumaticos',' ',' ',' ',' '),(216,'Elementos Electromecanicos',' ',' ',' ',' '),(214,'Herramientas y Accesorios',' ',' ',' ',' '),(213,'Equipos y Maquinas para Transporte',' ',' ',' ',' '),(212,'Equipos y Maquinas para Oficina',' ',' ',' ',' '),(211,'Equipos y Maquinas para Laboratorio',' ',' ',' ',' '),(209,'Equipos y Maquinas para Deporte',' ',' ',' ',' '),(208,'Equipos y Maquinas de Construccion',' ',' ',' ',' '),(206,'Equipos y Maquinas Industrial',' ',' ',' ',' '),(207,'Equipos y Maquinas de Comunicaciones',' ',' ',' ',' '),(203,'Elementos de Culto',' ',' ',' ',' '),(120,'Otros',' ',' ',' ',' '),(202,'Elementos Intangibles',' ',' ',' ',' '),(117,'Materiales Electromecanicos ',' ',' ',' ',' '),(116,'Elementos y Equipos de Proteccion',' ',' ',' ',' '),(114,'Medidores de Agua',' ',' ',' ',' '),(115,'Otros Elementos de Consumo',' ',' ',' ',' '),(113,'Elementos de Aseo',' ',' ',' ',' '),(112,'Mantenimiento Vehiculos',' ',' ',' ',' '),(111,'Viveres, Rancho y Licores',' ',' ',' ',' '),(110,'Utiles de Escritorio, Dibujo y papeleria',' ',' ',' ',' '),(109,'Accesorios para computador',' ',' ',' ',' '),(108,'Materiales Eletricos y Herramientas',' ',' ',' ',' '),(107,'Materiales para laboratorio',' ',' ',' ',' '),(106,'Elementos para Construccion e Instalacion Aseo',' ',' ',' ',' '),(105,'Elementos para Construccion e Instalacion Alcantarillado',' ',' ',' ',' '),(104,'Elementos para Construccion e Instalacion Acueducto',' ',' ',' ',' '),(103,'Insumos Quimicos ',' ',' ',' ',' '),(102,'Aceites y Lubricantes ',' ',' ',' ',' '),(101,'Ferreteria y Construccion',' ',' ',' ',' ');
/*!40000 ALTER TABLE `grupo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `grupo_nom`
--

DROP TABLE IF EXISTS `grupo_nom`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `grupo_nom` (
  `gr_codgru` int(3) NOT NULL DEFAULT '0',
  `gr_descri` varchar(80) NOT NULL,
  PRIMARY KEY (`gr_codgru`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `grupo_nom`
--

LOCK TABLES `grupo_nom` WRITE;
/*!40000 ALTER TABLE `grupo_nom` DISABLE KEYS */;
INSERT INTO `grupo_nom` (`gr_codgru`, `gr_descri`) VALUES (101,'Administracion y financiera'),(102,'Comercial'),(204,'Energia'),(201,'Acueducto'),(202,'Alcantarillado'),(203,'Aseo'),(52,'Pensionados');
/*!40000 ALTER TABLE `grupo_nom` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `horasnom_liq`
--

DROP TABLE IF EXISTS `horasnom_liq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `horasnom_liq` (
  `ho_periodo` int(7) NOT NULL DEFAULT '0',
  `ho_cedula` bigint(12) NOT NULL DEFAULT '0',
  `ho_codcon` int(4) NOT NULL,
  `ho_cantidad` double(15,2) DEFAULT NULL,
  `ho_fecreg` date DEFAULT NULL,
  `ho_usuari` char(12) NOT NULL,
  `ho_fecini` date NOT NULL,
  `ho_fecfin` date NOT NULL,
  `ho_observa` varchar(70) NOT NULL,
  PRIMARY KEY (`ho_periodo`,`ho_cedula`,`ho_codcon`),
  KEY `ho_cedula` (`ho_cedula`),
  KEY `ho_codcon` (`ho_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `horasnom_liq`
--

LOCK TABLES `horasnom_liq` WRITE;
/*!40000 ALTER TABLE `horasnom_liq` DISABLE KEYS */;
/*!40000 ALTER TABLE `horasnom_liq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kardex`
--

DROP TABLE IF EXISTS `kardex`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kardex` (
  `kd_numero` int(9) NOT NULL,
  `kd_codigo` int(6) NOT NULL,
  `kd_tipo` int(1) NOT NULL,
  `kd_fecreg` date DEFAULT NULL,
  `kd_cantid` double(15,2) DEFAULT NULL,
  `kd_vlrtot` double(15,2) DEFAULT NULL,
  `centro_costo` varchar(10) NOT NULL,
  PRIMARY KEY (`kd_numero`,`kd_codigo`,`kd_tipo`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kardex`
--

LOCK TABLES `kardex` WRITE;
/*!40000 ALTER TABLE `kardex` DISABLE KEYS */;
/*!40000 ALTER TABLE `kardex` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kardexbod`
--

DROP TABLE IF EXISTS `kardexbod`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kardexbod` (
  `kd_numero` int(9) NOT NULL,
  `kd_codigo` int(6) NOT NULL,
  `kd_tipo` int(1) NOT NULL,
  `kd_bodega` varchar(6) NOT NULL,
  `kd_fecreg` date DEFAULT NULL,
  `kd_cantid` float(9,2) DEFAULT NULL,
  `kd_vlrtot` int(9) DEFAULT NULL,
  PRIMARY KEY (`kd_numero`,`kd_codigo`,`kd_tipo`,`kd_bodega`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kardexbod`
--

LOCK TABLES `kardexbod` WRITE;
/*!40000 ALTER TABLE `kardexbod` DISABLE KEYS */;
/*!40000 ALTER TABLE `kardexbod` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `liquinom_liq`
--

DROP TABLE IF EXISTS `liquinom_liq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `liquinom_liq` (
  `lq_periodo` int(7) NOT NULL DEFAULT '0',
  `lq_cedula` bigint(12) NOT NULL DEFAULT '0',
  `lq_apagar` double(15,2) DEFAULT NULL,
  `lq_deduci` int(9) DEFAULT NULL,
  `lq_deveng` int(9) DEFAULT NULL,
  `lq_numdia` int(9) DEFAULT NULL,
  `lq_numsus` int(9) DEFAULT NULL,
  `lq_fecini` date DEFAULT NULL,
  `lq_fecfin` date DEFAULT NULL,
  `lq_fecreg` date DEFAULT NULL,
  `lq_usuari` char(12) NOT NULL,
  `lq_horreg` time NOT NULL DEFAULT '00:00:00',
  PRIMARY KEY (`lq_periodo`,`lq_cedula`),
  KEY `lq_cedula` (`lq_cedula`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `liquinom_liq`
--

LOCK TABLES `liquinom_liq` WRITE;
/*!40000 ALTER TABLE `liquinom_liq` DISABLE KEYS */;
/*!40000 ALTER TABLE `liquinom_liq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `liquiter_liq`
--

DROP TABLE IF EXISTS `liquiter_liq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `liquiter_liq` (
  `lq_numero` int(7) NOT NULL DEFAULT '0',
  `lq_cedula` bigint(12) NOT NULL DEFAULT '0',
  `lq_apagar` double(15,2) DEFAULT NULL,
  `lq_deduci` int(9) DEFAULT NULL,
  `lq_deveng` int(9) DEFAULT NULL,
  `lq_numdia` int(9) DEFAULT NULL,
  `lq_numsus` int(9) DEFAULT NULL,
  `lq_fecini` date DEFAULT NULL,
  `lq_fecfin` date DEFAULT NULL,
  `lq_fecreg` date DEFAULT NULL,
  `lq_usuari` char(12) NOT NULL,
  `lq_horreg` time NOT NULL DEFAULT '00:00:00',
  `lq_numcon` int(11) NOT NULL,
  `lq_estado` char(1) NOT NULL,
  `lq_tipcon` text NOT NULL,
  `lq_fecres` date NOT NULL,
  `lq_fecpos` date NOT NULL,
  PRIMARY KEY (`lq_numero`,`lq_cedula`),
  KEY `lq_cedula` (`lq_cedula`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `liquiter_liq`
--

LOCK TABLES `liquiter_liq` WRITE;
/*!40000 ALTER TABLE `liquiter_liq` DISABLE KEYS */;
/*!40000 ALTER TABLE `liquiter_liq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `marca`
--

DROP TABLE IF EXISTS `marca`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `marca` (
  `mr_codmar` int(3) NOT NULL DEFAULT '0',
  `mr_descri` char(40) NOT NULL DEFAULT '',
  `mr_nrolla` int(2) NOT NULL DEFAULT '0',
  `mr_nfilac` int(2) NOT NULL DEFAULT '0',
  `mr_nfilco` int(2) NOT NULL DEFAULT '0',
  `mr_nfilai` int(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`mr_codmar`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `marca`
--

LOCK TABLES `marca` WRITE;
/*!40000 ALTER TABLE `marca` DISABLE KEYS */;
INSERT INTO `marca` (`mr_codmar`, `mr_descri`, `mr_nrolla`, `mr_nfilac`, `mr_nfilco`, `mr_nfilai`) VALUES (1,'GENERAL',0,0,0,0);
/*!40000 ALTER TABLE `marca` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `minr`
--

DROP TABLE IF EXISTS `minr`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `minr` (
  `mr_codcon` int(9) NOT NULL,
  `mr_codigo` int(6) NOT NULL,
  `mr_ccosto` varchar(6) NOT NULL,
  `mr_codcli` varchar(12) NOT NULL DEFAULT '0',
  `mr_descri` varchar(200) NOT NULL,
  `mr_estado` char(1) NOT NULL,
  `mr_existen` double(15,2) DEFAULT NULL,
  `mr_valor` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`mr_codcon`,`mr_codigo`,`mr_ccosto`,`mr_codcli`),
  KEY `mr_codcon` (`mr_codcon`),
  KEY `mr_ccosto` (`mr_ccosto`),
  KEY `mr_codcli` (`mr_codcli`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `minr`
--

LOCK TABLES `minr` WRITE;
/*!40000 ALTER TABLE `minr` DISABLE KEYS */;
/*!40000 ALTER TABLE `minr` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `minr_tmp`
--

DROP TABLE IF EXISTS `minr_tmp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `minr_tmp` (
  `mrt_numero` int(9) NOT NULL,
  `mrt_codcon` int(9) NOT NULL,
  `mrt_codigo` int(6) NOT NULL,
  `mrt_descri` varchar(200) NOT NULL,
  `mrt_estado` char(1) NOT NULL,
  `mrt_existen` double(15,2) DEFAULT NULL,
  `mrt_valor` double(15,2) DEFAULT NULL,
  `mrt_iva` double(6,2) NOT NULL,
  PRIMARY KEY (`mrt_numero`,`mrt_codcon`,`mrt_codigo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `minr_tmp`
--

LOCK TABLES `minr_tmp` WRITE;
/*!40000 ALTER TABLE `minr_tmp` DISABLE KEYS */;
/*!40000 ALTER TABLE `minr_tmp` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `movto`
--

DROP TABLE IF EXISTS `movto`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `movto` (
  `mo_tipcom` int(3) NOT NULL,
  `mo_numero` int(9) NOT NULL,
  `mo_fecreg` date DEFAULT NULL,
  `mo_horreg` time NOT NULL DEFAULT '00:00:00',
  `mo_codcli` bigint(12) DEFAULT NULL,
  `mo_factur` int(9) NOT NULL,
  `mo_estado` char(1) NOT NULL,
  `mo_detalle` text,
  `mo_fecing` date DEFAULT NULL,
  `mo_horing` time NOT NULL DEFAULT '00:00:00',
  `mo_codemp` char(8) DEFAULT NULL,
  PRIMARY KEY (`mo_tipcom`,`mo_numero`),
  KEY `mo_tipcom` (`mo_tipcom`),
  KEY `mo_codcli` (`mo_codcli`),
  KEY `mo_fecreg` (`mo_fecreg`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `movto`
--

LOCK TABLES `movto` WRITE;
/*!40000 ALTER TABLE `movto` DISABLE KEYS */;
/*!40000 ALTER TABLE `movto` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `movto_niif`
--

DROP TABLE IF EXISTS `movto_niif`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `movto_niif` (
  `mo_tipcom` int(3) NOT NULL,
  `mo_numero` int(9) NOT NULL,
  `mo_fecreg` date DEFAULT NULL,
  `mo_horreg` time NOT NULL DEFAULT '00:00:00',
  `mo_codcli` bigint(12) DEFAULT NULL,
  `mo_factur` int(9) NOT NULL,
  `mo_estado` char(1) NOT NULL,
  `mo_detalle` text,
  `mo_fecing` date DEFAULT NULL,
  `mo_horing` time NOT NULL DEFAULT '00:00:00',
  `mo_codemp` char(8) DEFAULT NULL,
  `mo_tipcom_ref` int(3) NOT NULL,
  `mo_numero_ref` int(9) NOT NULL,
  PRIMARY KEY (`mo_tipcom`,`mo_numero`),
  KEY `mo_tipcom` (`mo_tipcom`),
  KEY `mo_codcli` (`mo_codcli`),
  KEY `mo_fecreg` (`mo_fecreg`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `movto_niif`
--

LOCK TABLES `movto_niif` WRITE;
/*!40000 ALTER TABLE `movto_niif` DISABLE KEYS */;
/*!40000 ALTER TABLE `movto_niif` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `notas`
--

DROP TABLE IF EXISTS `notas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `notas` (
  `no_numero` int(9) NOT NULL,
  `no_cuenta` char(12) DEFAULT NULL,
  `no_nropla` char(6) DEFAULT NULL,
  `no_codres` char(12) NOT NULL,
  `no_fecreg` date DEFAULT NULL,
  `no_horreg` time NOT NULL DEFAULT '00:00:00',
  `no_vlrtot` double(15,2) DEFAULT NULL,
  `no_estado` char(1) NOT NULL,
  `no_tippag` char(1) NOT NULL,
  `no_pagado` double(15,2) DEFAULT NULL,
  `no_ccosto` int(6) NOT NULL,
  `no_banco` int(6) NOT NULL,
  `no_cheque` varchar(20) NOT NULL,
  `no_codcli` bigint(12) NOT NULL DEFAULT '0',
  PRIMARY KEY (`no_numero`),
  KEY `no_cuenta` (`no_cuenta`),
  KEY `no_codcli` (`no_codcli`),
  KEY `no_codres` (`no_codres`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `notas`
--

LOCK TABLES `notas` WRITE;
/*!40000 ALTER TABLE `notas` DISABLE KEYS */;
/*!40000 ALTER TABLE `notas` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `novedadnom_liq`
--

DROP TABLE IF EXISTS `novedadnom_liq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `novedadnom_liq` (
  `no_periodo` int(7) NOT NULL DEFAULT '0',
  `no_cedula` bigint(12) NOT NULL DEFAULT '0',
  `no_01` char(1) NOT NULL,
  `no_02` char(1) NOT NULL,
  `no_03` char(1) NOT NULL,
  `no_04` char(1) NOT NULL,
  `no_05` char(1) NOT NULL,
  `no_06` char(1) NOT NULL,
  `no_07` char(1) NOT NULL,
  `no_08` char(1) NOT NULL,
  `no_09` char(1) NOT NULL,
  `no_10` char(1) NOT NULL,
  `no_11` char(1) NOT NULL,
  `no_12` char(1) NOT NULL,
  `no_13` char(1) NOT NULL,
  `no_14` char(1) NOT NULL,
  `no_15` char(1) NOT NULL,
  `no_fecreg` date DEFAULT NULL,
  `no_usuari` char(12) NOT NULL,
  `no_observa` varchar(70) NOT NULL,
  PRIMARY KEY (`no_periodo`,`no_cedula`),
  KEY `no_cedula` (`no_cedula`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `novedadnom_liq`
--

LOCK TABLES `novedadnom_liq` WRITE;
/*!40000 ALTER TABLE `novedadnom_liq` DISABLE KEYS */;
/*!40000 ALTER TABLE `novedadnom_liq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `novlrnom_liq`
--

DROP TABLE IF EXISTS `novlrnom_liq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `novlrnom_liq` (
  `nv_periodo` int(7) NOT NULL DEFAULT '0',
  `nv_cedula` bigint(12) NOT NULL DEFAULT '0',
  `nv_codcon` int(4) NOT NULL,
  `nv_cobro` int(4) NOT NULL,
  `nv_valor` double(15,2) DEFAULT NULL,
  `nv_fecreg` date DEFAULT NULL,
  `nv_usuari` char(12) NOT NULL,
  PRIMARY KEY (`nv_periodo`,`nv_cedula`,`nv_codcon`,`nv_cobro`),
  KEY `nv_cedula` (`nv_cedula`),
  KEY `nv_codcon` (`nv_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `novlrnom_liq`
--

LOCK TABLES `novlrnom_liq` WRITE;
/*!40000 ALTER TABLE `novlrnom_liq` DISABLE KEYS */;
/*!40000 ALTER TABLE `novlrnom_liq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `observaciones`
--

DROP TABLE IF EXISTS `observaciones`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `observaciones` (
  `ob_numero` int(9) NOT NULL,
  `ob_detalle` text,
  PRIMARY KEY (`ob_numero`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `observaciones`
--

LOCK TABLES `observaciones` WRITE;
/*!40000 ALTER TABLE `observaciones` DISABLE KEYS */;
/*!40000 ALTER TABLE `observaciones` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ordenes`
--

DROP TABLE IF EXISTS `ordenes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ordenes` (
  `or_numero` int(9) NOT NULL,
  `or_codcli` varchar(12) NOT NULL DEFAULT '0',
  `or_pedido` int(9) NOT NULL,
  `or_observa` text,
  `or_codres` char(12) NOT NULL,
  `or_fecreg` date DEFAULT NULL,
  `or_horreg` time NOT NULL DEFAULT '00:00:00',
  `or_vlrtot` int(9) DEFAULT NULL,
  `or_descli` int(9) DEFAULT NULL,
  `or_vlriva` int(9) DEFAULT NULL,
  `or_apagar` int(9) DEFAULT NULL,
  `or_estado` char(1) NOT NULL,
  `or_tippag` char(1) NOT NULL,
  `or_contrato` varchar(10) NOT NULL,
  `or_vigencia` int(6) NOT NULL,
  PRIMARY KEY (`or_numero`),
  KEY `or_codcli` (`or_codcli`),
  KEY `or_pedido` (`or_pedido`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ordenes`
--

LOCK TABLES `ordenes` WRITE;
/*!40000 ALTER TABLE `ordenes` DISABLE KEYS */;
/*!40000 ALTER TABLE `ordenes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `paraexogena`
--

DROP TABLE IF EXISTS `paraexogena`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `paraexogena` (
  `formato` char(12) NOT NULL,
  `concepto` char(12) NOT NULL,
  `ctainicial` char(12) NOT NULL,
  `ctafinal` char(12) NOT NULL,
  `columna` int(6) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `paraexogena`
--

LOCK TABLES `paraexogena` WRITE;
/*!40000 ALTER TABLE `paraexogena` DISABLE KEYS */;
/*!40000 ALTER TABLE `paraexogena` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pedcom`
--

DROP TABLE IF EXISTS `pedcom`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pedcom` (
  `pec_numero` int(9) NOT NULL,
  `pec_mesa` int(4) NOT NULL,
  `pec_observ` char(40) DEFAULT NULL,
  PRIMARY KEY (`pec_numero`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pedcom`
--

LOCK TABLES `pedcom` WRITE;
/*!40000 ALTER TABLE `pedcom` DISABLE KEYS */;
/*!40000 ALTER TABLE `pedcom` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pedcomp`
--

DROP TABLE IF EXISTS `pedcomp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pedcomp` (
  `pec_numero` int(9) NOT NULL,
  `pec_fecha` date NOT NULL,
  `pec_observ` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`pec_numero`,`pec_fecha`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pedcomp`
--

LOCK TABLES `pedcomp` WRITE;
/*!40000 ALTER TABLE `pedcomp` DISABLE KEYS */;
/*!40000 ALTER TABLE `pedcomp` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pedidos`
--

DROP TABLE IF EXISTS `pedidos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pedidos` (
  `pe_numero` int(9) NOT NULL,
  `pe_mesa` bigint(12) NOT NULL,
  `pe_observ` char(40) DEFAULT NULL,
  PRIMARY KEY (`pe_numero`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pedidos`
--

LOCK TABLES `pedidos` WRITE;
/*!40000 ALTER TABLE `pedidos` DISABLE KEYS */;
/*!40000 ALTER TABLE `pedidos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pedidos_cxp`
--

DROP TABLE IF EXISTS `pedidos_cxp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pedidos_cxp` (
  `pe_numero` int(9) NOT NULL,
  `pe_mesa` bigint(12) NOT NULL,
  `pe_observ` char(40) DEFAULT NULL,
  PRIMARY KEY (`pe_numero`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pedidos_cxp`
--

LOCK TABLES `pedidos_cxp` WRITE;
/*!40000 ALTER TABLE `pedidos_cxp` DISABLE KEYS */;
/*!40000 ALTER TABLE `pedidos_cxp` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pedidos_fe`
--

DROP TABLE IF EXISTS `pedidos_fe`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pedidos_fe` (
  `pe_numero` int(9) NOT NULL,
  `pe_mesa` bigint(12) NOT NULL,
  `pe_observ` char(40) DEFAULT NULL,
  PRIMARY KEY (`pe_numero`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pedidos_fe`
--

LOCK TABLES `pedidos_fe` WRITE;
/*!40000 ALTER TABLE `pedidos_fe` DISABLE KEYS */;
/*!40000 ALTER TABLE `pedidos_fe` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pedidosal`
--

DROP TABLE IF EXISTS `pedidosal`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pedidosal` (
  `pes_numero` int(9) NOT NULL,
  `pes_observ` char(40) DEFAULT NULL,
  `pes_codcli` varchar(12) DEFAULT NULL,
  `descripcion` text NOT NULL,
  `pes_fecha` date DEFAULT '0000-00-00' COMMENT 'Fecha de Creacion del Pedido',
  `causado` int(1) DEFAULT '0' COMMENT 'Indica si el Documento esta Causado',
  `anulado` int(1) DEFAULT '0' COMMENT 'Indica si el Documento esta Anulado',
  `observacion` text COMMENT 'Observaciones del Pedido',
  PRIMARY KEY (`pes_numero`),
  KEY `pes_codcli` (`pes_codcli`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pedidosal`
--

LOCK TABLES `pedidosal` WRITE;
/*!40000 ALTER TABLE `pedidosal` DISABLE KEYS */;
/*!40000 ALTER TABLE `pedidosal` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pedidosdes`
--

DROP TABLE IF EXISTS `pedidosdes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pedidosdes` (
  `ped_numero` int(9) NOT NULL,
  `ped_observ` char(40) DEFAULT NULL,
  `ped_codcli` bigint(12) DEFAULT NULL,
  PRIMARY KEY (`ped_numero`),
  KEY `ped_codcli` (`ped_codcli`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pedidosdes`
--

LOCK TABLES `pedidosdes` WRITE;
/*!40000 ALTER TABLE `pedidosdes` DISABLE KEYS */;
/*!40000 ALTER TABLE `pedidosdes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pedidosno`
--

DROP TABLE IF EXISTS `pedidosno`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pedidosno` (
  `pen_numero` int(9) NOT NULL,
  `pen_observ` char(40) DEFAULT NULL,
  `pen_cuenta` char(12) DEFAULT NULL,
  PRIMARY KEY (`pen_numero`),
  KEY `pen_cuenta` (`pen_cuenta`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pedidosno`
--

LOCK TABLES `pedidosno` WRITE;
/*!40000 ALTER TABLE `pedidosno` DISABLE KEYS */;
/*!40000 ALTER TABLE `pedidosno` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pedidosre`
--

DROP TABLE IF EXISTS `pedidosre`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pedidosre` (
  `per_numero` int(9) NOT NULL,
  `per_observ` char(40) DEFAULT NULL,
  `per_codcli` bigint(12) DEFAULT NULL,
  PRIMARY KEY (`per_numero`),
  KEY `per_codcli` (`per_codcli`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pedidosre`
--

LOCK TABLES `pedidosre` WRITE;
/*!40000 ALTER TABLE `pedidosre` DISABLE KEYS */;
INSERT INTO `pedidosre` (`per_numero`, `per_observ`, `per_codcli`) VALUES (1,'ALPUBLICIO',800095754);
/*!40000 ALTER TABLE `pedidosre` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pedidosre_nom`
--

DROP TABLE IF EXISTS `pedidosre_nom`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pedidosre_nom` (
  `per_numero` int(9) NOT NULL,
  `per_observ` char(40) DEFAULT NULL,
  `per_codcli` bigint(12) DEFAULT NULL,
  PRIMARY KEY (`per_numero`),
  KEY `per_codcli` (`per_codcli`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pedidosre_nom`
--

LOCK TABLES `pedidosre_nom` WRITE;
/*!40000 ALTER TABLE `pedidosre_nom` DISABLE KEYS */;
/*!40000 ALTER TABLE `pedidosre_nom` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pedidosrec`
--

DROP TABLE IF EXISTS `pedidosrec`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pedidosrec` (
  `per_numero` int(9) NOT NULL,
  `per_observ` char(40) DEFAULT NULL,
  `per_codcli` bigint(12) DEFAULT NULL,
  PRIMARY KEY (`per_numero`),
  KEY `per_codcli` (`per_codcli`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pedidosrec`
--

LOCK TABLES `pedidosrec` WRITE;
/*!40000 ALTER TABLE `pedidosrec` DISABLE KEYS */;
/*!40000 ALTER TABLE `pedidosrec` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pedidosrecc`
--

DROP TABLE IF EXISTS `pedidosrecc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pedidosrecc` (
  `per_numero` int(9) NOT NULL,
  `per_observ` char(40) DEFAULT NULL,
  `per_codcli` bigint(12) DEFAULT NULL,
  `per_fecini` date NOT NULL,
  `per_fecfin` date NOT NULL,
  PRIMARY KEY (`per_numero`),
  KEY `per_codcli` (`per_codcli`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pedidosrecc`
--

LOCK TABLES `pedidosrecc` WRITE;
/*!40000 ALTER TABLE `pedidosrecc` DISABLE KEYS */;
/*!40000 ALTER TABLE `pedidosrecc` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pedped`
--

DROP TABLE IF EXISTS `pedped`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pedped` (
  `pep_numero` int(9) NOT NULL,
  `pep_observa` text,
  `pep_codusu` char(12) NOT NULL,
  `pep_fecreg` date DEFAULT NULL,
  `pep_horreg` time NOT NULL DEFAULT '00:00:00',
  `pep_codare` int(4) NOT NULL,
  `pep_estado` char(1) NOT NULL,
  PRIMARY KEY (`pep_numero`),
  KEY `pep_codare` (`pep_codare`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pedped`
--

LOCK TABLES `pedped` WRITE;
/*!40000 ALTER TABLE `pedped` DISABLE KEYS */;
/*!40000 ALTER TABLE `pedped` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `permisos`
--

DROP TABLE IF EXISTS `permisos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `permisos` (
  `pe_codpro` int(11) NOT NULL DEFAULT '0',
  `pe_codemp` char(8) NOT NULL DEFAULT '',
  PRIMARY KEY (`pe_codpro`,`pe_codemp`),
  KEY `pe_codpro` (`pe_codpro`),
  KEY `pe_codemp` (`pe_codemp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `permisos`
--

LOCK TABLES `permisos` WRITE;
/*!40000 ALTER TABLE `permisos` DISABLE KEYS */;
/*!40000 ALTER TABLE `permisos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `recaudo`
--

DROP TABLE IF EXISTS `recaudo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `recaudo` (
  `rec_numero` int(9) NOT NULL,
  `rec_codcli` bigint(12) DEFAULT NULL,
  `rec_codres` char(12) NOT NULL,
  `rec_fecreg` date DEFAULT NULL,
  `rec_horreg` time NOT NULL DEFAULT '00:00:00',
  `rec_estado` char(1) NOT NULL,
  `rec_tippag` char(1) NOT NULL,
  `rec_refere` int(9) NOT NULL,
  `rec_vlrtot` double(15,2) DEFAULT NULL,
  `rec_detalle` text NOT NULL,
  `rec_feccre` date NOT NULL,
  PRIMARY KEY (`rec_numero`),
  KEY `rec_codcli` (`rec_codcli`),
  KEY `rec_refere` (`rec_refere`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `recaudo`
--

LOCK TABLES `recaudo` WRITE;
/*!40000 ALTER TABLE `recaudo` DISABLE KEYS */;
/*!40000 ALTER TABLE `recaudo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `recaudo_aju`
--

DROP TABLE IF EXISTS `recaudo_aju`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `recaudo_aju` (
  `reca_numero` int(9) NOT NULL,
  `reca_codcli` bigint(12) DEFAULT NULL,
  `reca_codres` char(12) NOT NULL,
  `reca_fecreg` date DEFAULT NULL,
  `reca_horreg` time NOT NULL DEFAULT '00:00:00',
  `reca_estado` char(1) NOT NULL,
  `reca_tippag` char(1) NOT NULL,
  `reca_refere` int(9) NOT NULL,
  `reca_vlrtot` double(15,2) DEFAULT NULL,
  `reca_detalle` text NOT NULL,
  `reca_feccre` date NOT NULL,
  PRIMARY KEY (`reca_numero`),
  KEY `reca_codcli` (`reca_codcli`),
  KEY `reca_refere` (`reca_refere`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `recaudo_aju`
--

LOCK TABLES `recaudo_aju` WRITE;
/*!40000 ALTER TABLE `recaudo_aju` DISABLE KEYS */;
/*!40000 ALTER TABLE `recaudo_aju` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `reccxp`
--

DROP TABLE IF EXISTS `reccxp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reccxp` (
  `rcxp_numero` int(9) NOT NULL,
  `rcxp_codcli` bigint(12) NOT NULL DEFAULT '0',
  `rcxp_fecreg` date DEFAULT NULL,
  `rcxp_horreg` time NOT NULL DEFAULT '00:00:00',
  `rcxp_vlrtot` double(15,2) DEFAULT NULL,
  `rcxp_estado` char(1) NOT NULL,
  `rcxp_tippag` char(2) NOT NULL,
  `rcxp_observa` text NOT NULL,
  `rcxp_usuari` char(12) NOT NULL,
  `rcxp_numcom` int(9) NOT NULL,
  `rcxp_tipcom` char(2) NOT NULL,
  `rcxp_cuenta` char(12) NOT NULL,
  `rcxp_cheque` char(12) NOT NULL,
  `rcxp_tercero` bigint(12) NOT NULL,
  `rcxp_nomtercero` varchar(60) NOT NULL,
  `rcxp_tipcont` int(4) NOT NULL,
  `rcxp_numcont` int(9) NOT NULL,
  `rcxp_giro` int(9) NOT NULL,
  PRIMARY KEY (`rcxp_numero`),
  KEY `rcxp_numcom` (`rcxp_numcom`),
  KEY `rcxp_codcli` (`rcxp_codcli`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `reccxp`
--

LOCK TABLES `reccxp` WRITE;
/*!40000 ALTER TABLE `reccxp` DISABLE KEYS */;
/*!40000 ALTER TABLE `reccxp` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `reccxp_detalle`
--

DROP TABLE IF EXISTS `reccxp_detalle`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reccxp_detalle` (
  `rcxpd_numero` int(9) NOT NULL,
  `rcxpd_codcta` char(12) NOT NULL,
  `rcxpd_regist` int(9) NOT NULL,
  `rcxpd_nroord` int(9) NOT NULL,
  `rcxpd_tipo` char(2) NOT NULL,
  `rcxpd_vlrtot` double(15,2) DEFAULT NULL,
  `rcxpd_detalle` varchar(100) NOT NULL,
  PRIMARY KEY (`rcxpd_numero`,`rcxpd_codcta`,`rcxpd_regist`,`rcxpd_nroord`,`rcxpd_tipo`),
  KEY `rcxpd_numero` (`rcxpd_numero`),
  KEY `rcxpd_codcta` (`rcxpd_codcta`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `reccxp_detalle`
--

LOCK TABLES `reccxp_detalle` WRITE;
/*!40000 ALTER TABLE `reccxp_detalle` DISABLE KEYS */;
/*!40000 ALTER TABLE `reccxp_detalle` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `recibos`
--

DROP TABLE IF EXISTS `recibos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `recibos` (
  `re_numero` int(9) NOT NULL,
  `re_codcli` bigint(12) DEFAULT NULL,
  `re_nropla` char(6) DEFAULT NULL,
  `re_codres` char(12) NOT NULL,
  `re_fecreg` date DEFAULT NULL,
  `re_horreg` time NOT NULL DEFAULT '00:00:00',
  `re_vlrtot` double(15,2) DEFAULT NULL,
  `re_estado` char(1) NOT NULL,
  `re_tippag` char(1) NOT NULL,
  `re_pagado` double(15,2) DEFAULT NULL,
  `re_ccosto` int(6) NOT NULL,
  `re_banco` int(6) NOT NULL,
  `re_cheque` varchar(20) NOT NULL,
  PRIMARY KEY (`re_numero`),
  KEY `re_codcli` (`re_codcli`),
  KEY `re_nropla` (`re_nropla`),
  KEY `re_codres` (`re_codres`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `recibos`
--

LOCK TABLES `recibos` WRITE;
/*!40000 ALTER TABLE `recibos` DISABLE KEYS */;
/*!40000 ALTER TABLE `recibos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `recibosp`
--

DROP TABLE IF EXISTS `recibosp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `recibosp` (
  `re_numero` int(9) NOT NULL,
  `re_codcli` bigint(12) DEFAULT NULL,
  `re_nropla` char(6) DEFAULT NULL,
  `re_codres` char(12) NOT NULL,
  `re_fecreg` date DEFAULT NULL,
  `re_horreg` time NOT NULL DEFAULT '00:00:00',
  `re_vlrtot` double(15,2) DEFAULT NULL,
  `re_estado` char(1) NOT NULL,
  `re_tippag` char(1) NOT NULL,
  `re_pagado` double(15,2) DEFAULT NULL,
  `re_ctapago` char(12) NOT NULL,
  `re_usuario` char(12) NOT NULL,
  `re_detalle` text NOT NULL,
  `re_soporte` char(15) NOT NULL,
  PRIMARY KEY (`re_numero`),
  KEY `re_codcli` (`re_codcli`),
  KEY `re_nropla` (`re_nropla`),
  KEY `re_codres` (`re_codres`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `recibosp`
--

LOCK TABLES `recibosp` WRITE;
/*!40000 ALTER TABLE `recibosp` DISABLE KEYS */;
/*!40000 ALTER TABLE `recibosp` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `recibosp2`
--

DROP TABLE IF EXISTS `recibosp2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `recibosp2` (
  `re_numero` int(9) NOT NULL,
  `re_codcli` bigint(12) DEFAULT NULL,
  `re_nropla` char(6) DEFAULT NULL,
  `re_codres` char(12) NOT NULL,
  `re_fecreg` date DEFAULT NULL,
  `re_horreg` time NOT NULL DEFAULT '00:00:00',
  `re_vlrtot` double(15,2) DEFAULT NULL,
  `re_estado` char(1) NOT NULL,
  `re_tippag` char(1) NOT NULL,
  `re_pagado` double(15,2) DEFAULT NULL,
  `re_ctapago` char(12) NOT NULL,
  `re_usuario` char(12) NOT NULL,
  `re_detalle` text NOT NULL,
  `re_soporte` char(15) NOT NULL,
  PRIMARY KEY (`re_numero`),
  KEY `re_codcli` (`re_codcli`),
  KEY `re_nropla` (`re_nropla`),
  KEY `re_codres` (`re_codres`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `recibosp2`
--

LOCK TABLES `recibosp2` WRITE;
/*!40000 ALTER TABLE `recibosp2` DISABLE KEYS */;
/*!40000 ALTER TABLE `recibosp2` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `recibosp_nom`
--

DROP TABLE IF EXISTS `recibosp_nom`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `recibosp_nom` (
  `re_numero` int(9) NOT NULL,
  `re_codcli` bigint(12) DEFAULT NULL,
  `re_nropla` char(6) DEFAULT NULL,
  `re_codres` char(12) NOT NULL,
  `re_fecreg` date DEFAULT NULL,
  `re_horreg` time NOT NULL DEFAULT '00:00:00',
  `re_vlrtot` double(15,2) DEFAULT NULL,
  `re_estado` char(1) NOT NULL,
  `re_tippag` char(1) NOT NULL,
  `re_pagado` double(15,2) DEFAULT NULL,
  `re_ctapago` char(12) NOT NULL,
  `re_usuario` char(12) NOT NULL,
  `re_detalle` text NOT NULL,
  `re_soporte` char(15) NOT NULL,
  PRIMARY KEY (`re_numero`),
  KEY `re_codcli` (`re_codcli`),
  KEY `re_nropla` (`re_nropla`),
  KEY `re_codres` (`re_codres`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `recibosp_nom`
--

LOCK TABLES `recibosp_nom` WRITE;
/*!40000 ALTER TABLE `recibosp_nom` DISABLE KEYS */;
/*!40000 ALTER TABLE `recibosp_nom` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `registro`
--

DROP TABLE IF EXISTS `registro`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `registro` (
  `reg_numero` int(9) NOT NULL,
  `reg_codcli` bigint(12) DEFAULT NULL,
  `reg_codres` char(12) NOT NULL,
  `reg_fecreg` date DEFAULT NULL,
  `reg_horreg` time NOT NULL DEFAULT '00:00:00',
  `reg_estado` char(1) NOT NULL,
  `reg_tippag` char(1) NOT NULL,
  `reg_dispon` int(9) NOT NULL,
  `reg_vlrtot` double(15,2) DEFAULT NULL,
  `reg_detalle` text NOT NULL,
  `reg_feccre` date NOT NULL,
  `reg_cretencion` varchar(12) NOT NULL,
  `reg_creteica` varchar(12) NOT NULL,
  `reg_retencion` double(15,2) NOT NULL,
  `reg_reteica` double(15,2) NOT NULL,
  `reg_vlrgir` double(15,2) NOT NULL,
  `reg_proyecto` int(9) NOT NULL,
  `reg_auxiliar` int(9) NOT NULL,
  `reg_codsec` int(4) NOT NULL,
  `reg_codare` int(4) NOT NULL,
  `reg_nrofac` char(12) NOT NULL,
  PRIMARY KEY (`reg_numero`),
  KEY `reg_codcli` (`reg_codcli`),
  KEY `reg_dispon` (`reg_dispon`),
  KEY `reg_proyecto` (`reg_proyecto`),
  KEY `reg_auxiliar` (`reg_auxiliar`),
  KEY `reg_codsec` (`reg_codsec`),
  KEY `reg_codare` (`reg_codare`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `registro`
--

LOCK TABLES `registro` WRITE;
/*!40000 ALTER TABLE `registro` DISABLE KEYS */;
/*!40000 ALTER TABLE `registro` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `registrop`
--

DROP TABLE IF EXISTS `registrop`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `registrop` (
  `regp_numero` int(9) NOT NULL,
  `regp_codcli` bigint(12) DEFAULT NULL,
  `regp_codres` char(12) NOT NULL,
  `regp_fecreg` date DEFAULT NULL,
  `regp_horreg` time NOT NULL DEFAULT '00:00:00',
  `regp_estado` char(1) NOT NULL,
  `regp_tippag` char(1) NOT NULL,
  `regp_dispon` int(9) NOT NULL,
  `regp_vlrtot` double(15,2) DEFAULT NULL,
  `regp_detalle` text NOT NULL,
  `regp_feccre` date NOT NULL,
  `regp_cretencion` varchar(12) NOT NULL,
  `regp_creteica` varchar(12) NOT NULL,
  `regp_retencion` double(15,2) NOT NULL,
  `regp_reteica` double(15,2) NOT NULL,
  `regp_vlriva` double(15,2) NOT NULL,
  `regp_vlrgir` double(15,2) NOT NULL,
  `regp_proyecto` int(9) NOT NULL,
  `regp_auxiliar` int(9) NOT NULL,
  `regp_codsec` int(4) NOT NULL,
  `regp_codare` int(4) NOT NULL,
  `regp_nrofac` char(12) NOT NULL,
  `regp_nroreg` int(9) NOT NULL,
  `regp_nroord` int(9) NOT NULL,
  `regp_soporte` int(9) NOT NULL,
  `regp_tipcon` varchar(12) NOT NULL,
  `regp_forpag` int(11) NOT NULL,
  `regp_creteiva` char(12) NOT NULL,
  `regp_cbomberil` char(12) NOT NULL,
  `regp_iva` double(6,2) NOT NULL,
  `regp_dias` int(11) NOT NULL,
  `regp_reteiva` double(15,2) NOT NULL,
  `regp_bomberil` double(15,2) NOT NULL,
  `regp_tipact` varchar(12) NOT NULL,
  `regp_contrato_vigencia` varchar(4) NOT NULL,
  `regp_contrato_numero` varchar(12) NOT NULL,
  `regp_origen` varchar(10) NOT NULL,
  `regp_guerra` varchar(12) NOT NULL,
  `regp_vguerra` double(15,2) NOT NULL,
  `regp_imp_cree` varchar(12) NOT NULL,
  `regp_vimp_cree` double(15,2) NOT NULL,
  `regp_ent_inv` int(1) NOT NULL DEFAULT '0' COMMENT '1- Si, 0 - No',
  `regp_ent_inv_num` varchar(30) NOT NULL DEFAULT '0',
  `regp_base` double(15,2) NOT NULL,
  `regp_tipo_contrato` int(11) NOT NULL COMMENT '2. contrato, 7. conv institu, 8, conv. admin',
  `regp_otros1` varchar(12) NOT NULL,
  `regp_votros1` double(15,2) NOT NULL,
  `regp_otros2` varchar(12) NOT NULL,
  `regp_votros2` double(15,2) NOT NULL,
  `regp_otros3` varchar(12) NOT NULL,
  `regp_votros3` double(15,2) NOT NULL,
  PRIMARY KEY (`regp_numero`),
  KEY `regp_codcli` (`regp_codcli`),
  KEY `regp_dispon` (`regp_dispon`),
  KEY `regp_nroreg` (`regp_nroreg`),
  KEY `regp_nroord` (`regp_nroord`),
  KEY `regp_proyecto` (`regp_proyecto`),
  KEY `regp_auxiliar` (`regp_auxiliar`),
  KEY `regp_codsec` (`regp_codsec`),
  KEY `regp_codare` (`regp_codare`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `registrop`
--

LOCK TABLES `registrop` WRITE;
/*!40000 ALTER TABLE `registrop` DISABLE KEYS */;
/*!40000 ALTER TABLE `registrop` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `reintegro`
--

DROP TABLE IF EXISTS `reintegro`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reintegro` (
  `rei_numero` int(9) NOT NULL,
  `rei_codcli` bigint(12) DEFAULT NULL,
  `rei_codres` char(12) NOT NULL,
  `rei_fecreg` date DEFAULT NULL,
  `rei_horreg` time NOT NULL DEFAULT '00:00:00',
  `rei_estado` char(1) NOT NULL,
  `rei_tippag` char(1) NOT NULL,
  `rei_dispon` int(9) NOT NULL,
  `rei_vlrtot` double(15,2) DEFAULT NULL,
  `rei_detalle` text NOT NULL,
  `rei_feccre` date NOT NULL,
  PRIMARY KEY (`rei_numero`),
  KEY `rei_codcli` (`rei_codcli`),
  KEY `rei_dispon` (`rei_dispon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `reintegro`
--

LOCK TABLES `reintegro` WRITE;
/*!40000 ALTER TABLE `reintegro` DISABLE KEYS */;
/*!40000 ALTER TABLE `reintegro` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `responsable`
--

DROP TABLE IF EXISTS `responsable`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `responsable` (
  `re_codres` char(12) NOT NULL,
  `re_nombre` char(40) DEFAULT NULL,
  `re_cargo` char(40) DEFAULT NULL,
  PRIMARY KEY (`re_codres`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `responsable`
--

LOCK TABLES `responsable` WRITE;
/*!40000 ALTER TABLE `responsable` DISABLE KEYS */;
INSERT INTO `responsable` (`re_codres`, `re_nombre`, `re_cargo`) VALUES ('1','EMPRESAS PUBLICAS MUNICIPALES ESP','GENERAL');
/*!40000 ALTER TABLE `responsable` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `responsablei`
--

DROP TABLE IF EXISTS `responsablei`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `responsablei` (
  `re_codres` char(12) NOT NULL,
  `re_nombre` char(40) DEFAULT NULL,
  `re_cargo` char(40) DEFAULT NULL,
  PRIMARY KEY (`re_codres`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `responsablei`
--

LOCK TABLES `responsablei` WRITE;
/*!40000 ALTER TABLE `responsablei` DISABLE KEYS */;
INSERT INTO `responsablei` (`re_codres`, `re_nombre`, `re_cargo`) VALUES ('1117508778','GENNY KATHERINE POLANCO CEDIEL','ALMACENISTA'),('17710656','JHONNIER GARCIA','TÉCNICO ELECTRICISTA'),('1676391','LUIS HUMBERTO FLOREZ CABRERA','AUX OPERATIVO'),('11379809','BENIGNO GAMEZ ROZO','CONDUCTOR'),('12108861','HUMBERTO CUENCA GUTIERREZ','AUX ADM DE MENSAJERIA'),('16186270','JUAN CARLOS SANTAMARIA OSPINA','AUX ADM DE RECAUDOS'),('16187894','JAMES DIAZ VALENCIA','AUX OPERATIVO'),('16227436	','WILMAR TORRES PALACIO','FONTANERO'),('16227436','FRANCISCO JAVIER ENCIZO CARDONA','OPERADOR DE MAQUINA'),('17652212','NELSON AUGUSTO ROMERO','AUX OPERATIVO'),('17688349','ANDERSON CHARRY CABRERA','COORDINADOR DE ENERGIA'),('17709143','ESAUC JARA ROBAYO','LABORATORISTA'),('17709400','NELSON DE JESUS MUNOZ CEBALLOS','LABORATORISTA'),('17709602','JORGE HUMBERTO  MUNOZ GALEANO','AUX OPERATIVO'),('17710062','JOHN JAIRO ORTIZ SANCHEZ','FONTANERO'),('17710093','CARLOS ALBERTO TOVAR BERGANO','TECNICO ELECTRICISTA'),('18467702','EDUIN ALEGRIA ROSERO','TECNICO ELECTRICISTA'),('40625532','MARIA CONSUELO NINCO VARGAS','AUX ADM DE PQR'),('40626007','YOLANDA FAJARDO','JEFE DE RECURSO HUMANO'),('40626164','ORFILIA BARRERO','AUX SERV GENERALES'),('40626885','MARGOTH MARTINEZ','AUX ADM DE FACTURACION'),('41250731','DEGNIS YILENA PEREZ JIMENEZ','GERENTE'),('66873421','ADRIANA MAYORGA BETANCOURTH','COORDINADORA AMBIENTAR'),('79201571','RAFAEL CAMPOS CRUZ','SUBGERENTE TECNICO OPERATIVO'),('96332313','ARTURO ORDONEZ ROJAS','COORDIANDOR DE AAA'),('96333592','EFREN OSORIO GAONA','FONTANERO'),('1067524170','LUIS JONATHAN RAMOS VARGAS','TECNICO ELECTRICISTA'),('1075226711','MARCELO YANGUAS CHACON','ADMINISTRATIVO'),('1109492696','DEICY JAZMIN CASTANEDA IQUINA','ADMINISTRATIVO'),('1115950121','RAUL ESNEIDER PENAGOS GAITA','AUX OPERATIVO'),('1116205528','IDELFONSO LEAL GASCA','ADMINISTRATIVO'),('1117497550','JOSE MANUEL ZABALA DIAZ','TECNICO ELECTRICISTA'),('1117535344','MAYERLY RAMIREZ  GALEANO','SECRETARIA GENERAL'),('1117543211','PEDRO MARIN MARIN','CONTADOR'),('1117964100','MARTHA ADRIANA GASCA CORRE','TESORERA');
/*!40000 ALTER TABLE `responsablei` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `retencion`
--

DROP TABLE IF EXISTS `retencion`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retencion` (
  `rte_cuenta` char(12) NOT NULL,
  `rte_descri` char(80) DEFAULT NULL,
  `rte_codigo` char(12) DEFAULT NULL,
  `rte_porcen` double(15,2) DEFAULT NULL,
  `rte_base` double(10,2) NOT NULL,
  `rte_baseuvt` double(10,2) NOT NULL,
  PRIMARY KEY (`rte_cuenta`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `retencion`
--

LOCK TABLES `retencion` WRITE;
/*!40000 ALTER TABLE `retencion` DISABLE KEYS */;
INSERT INTO `retencion` (`rte_cuenta`, `rte_descri`, `rte_codigo`, `rte_porcen`, `rte_base`, `rte_baseuvt`) VALUES ('EST.U NACION','Estampilla universidad Nacionales','24072204',0.50,0.00,0.00),('RETE001','Compras generales (declarantes)','24360801',2.50,742000.00,27.00),('RETE002','Compras generales (no declarantes)','24360802',3.50,742000.00,27.00),('RETE003','Compras con tarjeta debito o credito','',1.50,0.00,0.00),('RETE004','Compras de combustibles derivados del petroleo','24360803',0.10,0.00,0.00),('RETE005','Servicios generales (declarantes)','24360505',4.00,110000.00,4.00),('RETE006','Servicios generales (no declarantes)','24360501',6.00,110000.00,4.00),('RETE007','Servicios de transporte de carga','24360505',1.00,0.00,4.00),('RETE008','Servicios de transporte nacional de pasajeros por via terrestre (declarantes)','24360504',2.50,742000.00,27.00),('RETE009','Servicios de transporte nacional de pasajeros por via terrestre (no declarantes)','24360505',3.50,742000.00,27.00),('RETE010','Servicios de transporte nacional de pasajeros por via aerea o maritima','',1.00,110000.00,4.00),('RETE011','Servicios prestados por empresas de servicios temporales (sobre AIU)','24360501',1.00,119000.00,4.00),('RETE012','Servicios prestados por empresas de vigilancia y aseo (sobre AIU)','24360502',2.00,110000.00,4.00),('RETE013','Servicios integrales de salud prestados por IPS','',2.00,110000.00,4.00),('RETE014','Servicios de hoteles y restaurantes (declarantes)','24360504',3.50,119000.00,4.00),('RETE015','Servicios de hoteles y restaurantes (no declarantes)','24360504',3.50,119000.00,4.00),('RETE016','Arrendamiento de bienes muebles','24360602',4.00,0.00,0.00),('RETE017','Arrendamiento de bienes inmuebles (declarantes)','24360602',2.50,742000.00,27.00),('RETE018','Arrendamiento de bienes inmuebles (no declarantes)','24360603',3.50,742000.00,27.00),('RETE019','Otros ingresos tributarios (declarantes)','',2.50,742000.00,27.00),('RETE020','Otros ingresos tributarios (no declarantes)','',3.50,742000.00,27.00),('RETE021','Pagos o abonos en cuenta gravables realizados a personas naturales trib.empleado','24369001',95.00,0.00,0.00),('RETE022','Pagos o abonos en cuenta gravables realizados a personas naturales Tarifa Minima','24369001',128.96,0.00,0.00),('RETE023','Honorarios y comisiones (personas juridicas)','24360302',11.00,0.00,0.00),('RETE024','Honorarios y comisiones personas naturales contrato o sumatoria > 3300 uvt','24360303',10.00,0.00,0.00),('RETE025','Honorarios y comisiones (no declarantes)','24360301',10.00,0.00,0.00),('RETE027','Intereses o rendimientos financieros','24360701',7.00,0.00,0.00),('RETE028','Contratos de obra','243626',2.00,0.00,0.00),('EST FDEP','ESTAMPILLA DE FOMENTO DE DEPORTE','24072213',1.50,0.00,0.00),('RETIVA','Rete Regimen Comun 15%','24362501',15.00,0.00,0.00),('RETEICA08','Reteica Compras  Ferreteria, Equipos y otros','24362702',4.50,0.00,0.00),('RETEICA07','Reteica Cemento,Manofacturas, Aserradero y Metales','24370103',7.00,0.00,0.00),('RETEICA05','Reteica Compras en Gral','24362701',5.00,0.00,0.00),('RETEICA10','Reteica Cigarrillo, Combustible','24370105',10.00,0.00,0.00),('ADULTO MAYOR','ESTAMPILLA DEL ADULTO MAYOR','24072202',4.00,0.00,0.00),('uniamazonia','ESTAMPILLA UNIAMAZONIA .5','24072201',0.50,0.00,0.00),('EST ELECT','ESTAMPILLA DE ELECTRIFICACION RURAL','24072210',1.00,0.00,0.00),('RETE029','Industria y Comercio','24400401',0.80,0.00,0.00),('RETE026','Servicio de Licenciamineto o Uso de Software','24360305',3.50,0.00,0.00),('procultura','Estampilla procultura 1.5','24072203',1.50,0.00,0.00),('RETEICA06','Reteica x Servicios en Gral','24362702',6.00,0.00,0.00),('1392','Confecciones de artículos con materiales textiles excepto prendas de vestir','1392',0.40,0.00,0.00);
/*!40000 ALTER TABLE `retencion` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `retencion_niif`
--

DROP TABLE IF EXISTS `retencion_niif`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retencion_niif` (
  `rte_cuenta` char(12) NOT NULL,
  `rte_descri` char(80) DEFAULT NULL,
  `rte_codigo` char(12) DEFAULT NULL,
  `rte_porcen` double(15,2) DEFAULT NULL,
  `rte_base` double(10,2) NOT NULL,
  `rte_baseuvt` double(10,2) NOT NULL,
  PRIMARY KEY (`rte_cuenta`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `retencion_niif`
--

LOCK TABLES `retencion_niif` WRITE;
/*!40000 ALTER TABLE `retencion_niif` DISABLE KEYS */;
INSERT INTO `retencion_niif` (`rte_cuenta`, `rte_descri`, `rte_codigo`, `rte_porcen`, `rte_base`, `rte_baseuvt`) VALUES ('NA','NO APLICA','',0.00,0.00,0.00),('RETE001','Compras generales (declarantes)','24360801',2.50,742000.00,27.00),('RETE002','Compras generales (no declarantes)','24360802',3.50,742000.00,27.00),('RETE003','Compras con tarjeta debito o credito','',1.50,0.00,0.00),('RETE004','Compras de combustibles derivados del petroleo','24360803',0.10,0.00,0.00),('RETE005','Servicios generales (declarantes)','24360501',4.00,110000.00,4.00),('RETE006','Servicios generales (no declarantes)','24360502',6.00,110000.00,4.00),('RETE007','Servicios de transporte de carga','24360503',1.00,110000.00,4.00),('RETE008','Servicios de transporte nacional de pasajeros por via terrestre (declarantes)','24360504',2.50,742000.00,27.00),('RETE009','Servicios de transporte nacional de pasajeros por via terrestre (no declarantes)','24360505',3.50,742000.00,27.00),('RETE010','Servicios de transporte nacional de pasajeros por via aerea o maritima','',1.00,110000.00,4.00),('RETE011','Servicios prestados por empresas de servicios temporales (sobre AIU)','',1.00,110000.00,4.00),('RETE012','Servicios prestados por empresas de vigilancia y aseo (sobre AIU)','',2.00,110000.00,4.00),('RETE013','Servicios integrales de salud prestados por IPS','',2.00,110000.00,4.00),('RETE014','Servicios de hoteles y restaurantes (declarantes)','',2.50,110000.00,4.00),('RETE015','Servicios de hoteles y restaurantes (no declarantes)','',3.50,110000.00,4.00),('RETE016','Arrendamiento de bienes muebles','24360601',4.00,0.00,0.00),('RETE017','Arrendamiento de bienes inmuebles (declarantes)','24360602',2.50,742000.00,27.00),('RETE018','Arrendamiento de bienes inmuebles (no declarantes)','24360603',3.50,742000.00,27.00),('RETE019','Otros ingresos tributarios (declarantes)','',2.50,742000.00,27.00),('RETE020','Otros ingresos tributarios (no declarantes)','',3.50,742000.00,27.00),('RETE021','Pagos o abonos en cuenta gravables realizados a personas naturales trib.empleado','24369001',95.00,0.00,0.00),('RETE022','Pagos o abonos en cuenta gravables realizados a personas naturales Tarifa Minima','24369001',128.96,0.00,0.00),('RETE023','Honorarios y comisiones (personas juridicas)','24360301',11.00,0.00,0.00),('RETE024','Honorarios y comisiones personas naturales contrato o sumatoria > 3300 uvt','24360302',0.00,0.00,0.00),('RETE025','Honorarios y comisiones (no declarantes)','24360303',10.00,0.00,0.00),('RETE026','Servicios de licenciamiento o derecho de uso de software','',3.50,0.00,0.00),('RETE027','Intereses o rendimientos financieros','24360701',7.00,0.00,0.00),('RETE028','Contratos de construccion y urbanizacion','24362601',2.00,0.00,0.00);
/*!40000 ALTER TABLE `retencion_niif` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `salario`
--

DROP TABLE IF EXISTS `salario`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `salario` (
  `sa_ano` int(4) NOT NULL DEFAULT '0',
  `sa_valor` int(9) NOT NULL DEFAULT '0',
  `sa_subsi` int(9) NOT NULL DEFAULT '0',
  PRIMARY KEY (`sa_ano`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `salario`
--

LOCK TABLES `salario` WRITE;
/*!40000 ALTER TABLE `salario` DISABLE KEYS */;
INSERT INTO `salario` (`sa_ano`, `sa_valor`, `sa_subsi`) VALUES (2015,644350,74000),(2016,689455,77700),(2017,737717,83140),(2018,781242,88211),(2019,828116,97032),(2020,877803,102854),(2021,908526,106454);
/*!40000 ALTER TABLE `salario` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `saldos`
--

DROP TABLE IF EXISTS `saldos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `saldos` (
  `sal_ano` int(4) NOT NULL DEFAULT '0',
  `sal_mes` int(2) NOT NULL DEFAULT '0',
  `sal_codcta` char(12) NOT NULL,
  `sal_tercer` bigint(12) NOT NULL DEFAULT '0',
  `sal_auxili` int(9) NOT NULL DEFAULT '0',
  `sal_codcen` int(6) NOT NULL DEFAULT '0',
  `sal_salant` double(15,2) DEFAULT NULL,
  `sal_debmes` double(15,2) DEFAULT NULL,
  `sal_cremes` double(15,2) DEFAULT NULL,
  `sal_debacu` double(15,2) DEFAULT NULL,
  `sal_creacu` double(15,2) DEFAULT NULL,
  `sal_nuesal` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`sal_ano`,`sal_mes`,`sal_codcta`,`sal_tercer`,`sal_auxili`,`sal_codcen`),
  KEY `sal_codcta` (`sal_codcta`),
  KEY `sal_codcen` (`sal_codcen`),
  KEY `sal_tercer` (`sal_tercer`),
  KEY `sal_auxili` (`sal_auxili`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `saldos`
--

LOCK TABLES `saldos` WRITE;
/*!40000 ALTER TABLE `saldos` DISABLE KEYS */;
/*!40000 ALTER TABLE `saldos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `saldos_niif`
--

DROP TABLE IF EXISTS `saldos_niif`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `saldos_niif` (
  `sal_ano` int(4) NOT NULL DEFAULT '0',
  `sal_mes` int(2) NOT NULL DEFAULT '0',
  `sal_codcta` char(12) NOT NULL,
  `sal_tercer` bigint(12) NOT NULL DEFAULT '0',
  `sal_auxili` int(9) NOT NULL DEFAULT '0',
  `sal_codcen` int(6) NOT NULL DEFAULT '0',
  `sal_salant` double(15,2) DEFAULT NULL,
  `sal_debmes` double(15,2) DEFAULT NULL,
  `sal_cremes` double(15,2) DEFAULT NULL,
  `sal_debacu` double(15,2) DEFAULT NULL,
  `sal_creacu` double(15,2) DEFAULT NULL,
  `sal_nuesal` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`sal_ano`,`sal_mes`,`sal_codcta`,`sal_tercer`,`sal_auxili`,`sal_codcen`),
  KEY `sal_codcta` (`sal_codcta`),
  KEY `sal_codcen` (`sal_codcen`),
  KEY `sal_tercer` (`sal_tercer`),
  KEY `sal_auxili` (`sal_auxili`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `saldos_niif`
--

LOCK TABLES `saldos_niif` WRITE;
/*!40000 ALTER TABLE `saldos_niif` DISABLE KEYS */;
/*!40000 ALTER TABLE `saldos_niif` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `saldos_niifa`
--

DROP TABLE IF EXISTS `saldos_niifa`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `saldos_niifa` (
  `sala_ano` int(4) NOT NULL DEFAULT '0',
  `sala_mes` int(2) NOT NULL DEFAULT '0',
  `sala_codcta` char(12) NOT NULL DEFAULT '',
  `sala_tercer` bigint(12) NOT NULL DEFAULT '0',
  `sala_auxili` int(9) NOT NULL DEFAULT '0',
  `sala_salant` double(15,2) DEFAULT NULL,
  `sala_debmes` double(15,2) DEFAULT NULL,
  `sala_cremes` double(15,2) DEFAULT NULL,
  `sala_debacu` double(15,2) DEFAULT NULL,
  `sala_creacu` double(15,2) DEFAULT NULL,
  `sala_nuesal` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`sala_ano`,`sala_mes`,`sala_codcta`,`sala_tercer`,`sala_auxili`),
  KEY `sala_codcta` (`sala_codcta`),
  KEY `sala_tercer` (`sala_tercer`),
  KEY `sala_auxili` (`sala_auxili`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `saldos_niifa`
--

LOCK TABLES `saldos_niifa` WRITE;
/*!40000 ALTER TABLE `saldos_niifa` DISABLE KEYS */;
/*!40000 ALTER TABLE `saldos_niifa` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `saldos_niifx`
--

DROP TABLE IF EXISTS `saldos_niifx`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `saldos_niifx` (
  `salx_ano` int(4) NOT NULL DEFAULT '0',
  `salx_mes` int(2) NOT NULL DEFAULT '0',
  `salx_codcta` char(12) NOT NULL DEFAULT '',
  `salx_salant` double(15,2) DEFAULT NULL,
  `salx_debmes` double(15,2) DEFAULT NULL,
  `salx_cremes` double(15,2) DEFAULT NULL,
  `salx_debacu` double(15,2) DEFAULT NULL,
  `salx_creacu` double(15,2) DEFAULT NULL,
  `salx_nuesal` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`salx_ano`,`salx_mes`,`salx_codcta`),
  KEY `salx_codcta` (`salx_codcta`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `saldos_niifx`
--

LOCK TABLES `saldos_niifx` WRITE;
/*!40000 ALTER TABLE `saldos_niifx` DISABLE KEYS */;
/*!40000 ALTER TABLE `saldos_niifx` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `saldosa`
--

DROP TABLE IF EXISTS `saldosa`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `saldosa` (
  `sala_ano` int(4) NOT NULL DEFAULT '0',
  `sala_mes` int(2) NOT NULL DEFAULT '0',
  `sala_codcta` char(12) NOT NULL DEFAULT '',
  `sala_tercer` bigint(12) NOT NULL DEFAULT '0',
  `sala_auxili` int(9) NOT NULL DEFAULT '0',
  `sala_salant` double(15,2) DEFAULT NULL,
  `sala_debmes` double(15,2) DEFAULT NULL,
  `sala_cremes` double(15,2) DEFAULT NULL,
  `sala_debacu` double(15,2) DEFAULT NULL,
  `sala_creacu` double(15,2) DEFAULT NULL,
  `sala_nuesal` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`sala_ano`,`sala_mes`,`sala_codcta`,`sala_tercer`,`sala_auxili`),
  KEY `sala_codcta` (`sala_codcta`),
  KEY `sala_tercer` (`sala_tercer`),
  KEY `sala_auxili` (`sala_auxili`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `saldosa`
--

LOCK TABLES `saldosa` WRITE;
/*!40000 ALTER TABLE `saldosa` DISABLE KEYS */;
/*!40000 ALTER TABLE `saldosa` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `saldosc`
--

DROP TABLE IF EXISTS `saldosc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `saldosc` (
  `salc_ano` int(4) NOT NULL DEFAULT '0',
  `salc_mes` int(2) NOT NULL DEFAULT '0',
  `salc_codcta` char(25) NOT NULL,
  `salc_tercer` bigint(12) NOT NULL DEFAULT '0',
  `salc_auxili` int(9) NOT NULL DEFAULT '0',
  `salc_codcen` int(6) NOT NULL DEFAULT '0',
  `salc_salant` double(15,2) DEFAULT NULL,
  `salc_debmes` double(15,2) DEFAULT NULL,
  `salc_cremes` double(15,2) DEFAULT NULL,
  `salc_debacu` double(15,2) DEFAULT NULL,
  `salc_creacu` double(15,2) DEFAULT NULL,
  `salc_nuesal` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`salc_ano`,`salc_mes`,`salc_codcta`,`salc_tercer`,`salc_auxili`,`salc_codcen`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `saldosc`
--

LOCK TABLES `saldosc` WRITE;
/*!40000 ALTER TABLE `saldosc` DISABLE KEYS */;
/*!40000 ALTER TABLE `saldosc` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `saldosinventario`
--

DROP TABLE IF EXISTS `saldosinventario`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `saldosinventario` (
  `sal_fecha` date NOT NULL,
  `sal_codcon` int(10) NOT NULL,
  `sal_bodega` varchar(6) NOT NULL,
  `sal_canant` double(15,2) DEFAULT NULL,
  `sal_salant` double(15,2) DEFAULT NULL,
  `sal_caning` double(15,2) DEFAULT NULL,
  `sal_ingres` double(15,2) DEFAULT NULL,
  `sal_canegr` double(15,2) DEFAULT NULL,
  `sal_egreso` double(15,2) DEFAULT NULL,
  `sal_cannue` double(15,2) DEFAULT NULL,
  `sal_nuesal` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`sal_fecha`,`sal_codcon`,`sal_bodega`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `saldosinventario`
--

LOCK TABLES `saldosinventario` WRITE;
/*!40000 ALTER TABLE `saldosinventario` DISABLE KEYS */;
/*!40000 ALTER TABLE `saldosinventario` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `saldospre`
--

DROP TABLE IF EXISTS `saldospre`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `saldospre` (
  `sal_ano` int(4) NOT NULL DEFAULT '0',
  `sal_mes` int(2) NOT NULL DEFAULT '0',
  `sal_codcta` varchar(25) NOT NULL,
  `sal_salant` double(15,2) DEFAULT NULL,
  `sal_debmes` double(15,2) DEFAULT NULL,
  `sal_cremes` double(15,2) DEFAULT NULL,
  `sal_debacu` double(15,2) DEFAULT NULL,
  `sal_creacu` double(15,2) DEFAULT NULL,
  `sal_nuesal` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`sal_ano`,`sal_mes`,`sal_codcta`),
  KEY `sal_codcta` (`sal_codcta`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `saldospre`
--

LOCK TABLES `saldospre` WRITE;
/*!40000 ALTER TABLE `saldospre` DISABLE KEYS */;
/*!40000 ALTER TABLE `saldospre` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `saldosprej`
--

DROP TABLE IF EXISTS `saldosprej`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `saldosprej` (
  `sal_eje_ano` int(4) NOT NULL DEFAULT '0',
  `sal_eje_mes` int(2) NOT NULL DEFAULT '0',
  `sal_eje_codcta` varchar(25) NOT NULL,
  `sal_eje_salant` double(15,2) DEFAULT NULL,
  `sal_eje_credit` double(15,2) DEFAULT NULL,
  `sal_eje_concre` double(15,2) DEFAULT NULL,
  `sal_eje_adicio` double(15,2) DEFAULT NULL,
  `sal_eje_reducc` double(15,2) DEFAULT NULL,
  `sal_eje_defini` double(15,2) DEFAULT NULL,
  `sal_eje_dispon` double(15,2) DEFAULT NULL,
  `sal_eje_regist` double(15,2) DEFAULT NULL,
  `sal_eje_girosp` double(15,2) DEFAULT NULL,
  `sal_eje_nuesal` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`sal_eje_ano`,`sal_eje_mes`,`sal_eje_codcta`),
  KEY `sal_codcta` (`sal_eje_codcta`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `saldosprej`
--

LOCK TABLES `saldosprej` WRITE;
/*!40000 ALTER TABLE `saldosprej` DISABLE KEYS */;
/*!40000 ALTER TABLE `saldosprej` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `saldostes`
--

DROP TABLE IF EXISTS `saldostes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `saldostes` (
  `salt_fecha` date NOT NULL,
  `salt_codcta` char(12) NOT NULL,
  `salt_salant` double(15,2) DEFAULT NULL,
  `salt_ingresos` double(15,2) DEFAULT NULL,
  `salt_egresos` double(15,2) DEFAULT NULL,
  `salt_nuesal` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`salt_fecha`,`salt_codcta`),
  KEY `salt_codcta` (`salt_codcta`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `saldostes`
--

LOCK TABLES `saldostes` WRITE;
/*!40000 ALTER TABLE `saldostes` DISABLE KEYS */;
/*!40000 ALTER TABLE `saldostes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `saldosx`
--

DROP TABLE IF EXISTS `saldosx`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `saldosx` (
  `salx_ano` int(4) NOT NULL DEFAULT '0',
  `salx_mes` int(2) NOT NULL DEFAULT '0',
  `salx_codcta` char(12) NOT NULL DEFAULT '',
  `salx_salant` double(15,2) DEFAULT NULL,
  `salx_debmes` double(15,2) DEFAULT NULL,
  `salx_cremes` double(15,2) DEFAULT NULL,
  `salx_debacu` double(15,2) DEFAULT NULL,
  `salx_creacu` double(15,2) DEFAULT NULL,
  `salx_nuesal` double(15,2) DEFAULT NULL,
  PRIMARY KEY (`salx_ano`,`salx_mes`,`salx_codcta`),
  KEY `salx_codcta` (`salx_codcta`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `saldosx`
--

LOCK TABLES `saldosx` WRITE;
/*!40000 ALTER TABLE `saldosx` DISABLE KEYS */;
/*!40000 ALTER TABLE `saldosx` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `saldosxt`
--

DROP TABLE IF EXISTS `saldosxt`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `saldosxt` (
  `salx_ano` int(4) NOT NULL DEFAULT '0',
  `salx_mes` int(2) NOT NULL DEFAULT '0',
  `salx_codcta` char(12) NOT NULL DEFAULT '',
  `salx_salant` double(15,2) DEFAULT NULL,
  `salx_debmes` double(15,2) DEFAULT NULL,
  `salx_cremes` double(15,2) DEFAULT NULL,
  `salx_debacu` double(15,2) DEFAULT NULL,
  `salx_creacu` double(15,2) DEFAULT NULL,
  `salx_nuesal` double(15,2) DEFAULT NULL,
  `salx_cor` double(15,2) NOT NULL,
  `salx_ncor` double(15,2) NOT NULL,
  PRIMARY KEY (`salx_ano`,`salx_mes`,`salx_codcta`),
  KEY `salx_codcta` (`salx_codcta`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `saldosxt`
--

LOCK TABLES `saldosxt` WRITE;
/*!40000 ALTER TABLE `saldosxt` DISABLE KEYS */;
/*!40000 ALTER TABLE `saldosxt` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `salidas`
--

DROP TABLE IF EXISTS `salidas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `salidas` (
  `sa_tipo_sa` int(1) NOT NULL DEFAULT '1' COMMENT '1.Normal, 2. Almacen',
  `sa_numero` int(9) NOT NULL,
  `sa_codcli` varchar(12) NOT NULL,
  `sa_fecreg` date DEFAULT NULL,
  `sa_horreg` time NOT NULL DEFAULT '00:00:00',
  `sa_vlrtot` double(15,2) DEFAULT NULL,
  `sa_vlriva` double(15,2) DEFAULT NULL,
  `sa_apagar` double(15,2) DEFAULT NULL,
  `sa_estado` char(1) NOT NULL,
  `sa_codcen` varchar(6) NOT NULL,
  `sa_codaux` varchar(70) NOT NULL,
  `sa_usuario` varchar(15) NOT NULL,
  `sa_tipo` varchar(1) NOT NULL,
  `sa_ccosto` varchar(6) NOT NULL,
  `descripcion` text NOT NULL,
  `sa_clase` varchar(1) NOT NULL DEFAULT 'B' COMMENT 'Salidas Buenas o Malas',
  `sa_solicitud` int(11) NOT NULL,
  PRIMARY KEY (`sa_numero`,`sa_tipo_sa`),
  KEY `sa_codcli` (`sa_codcli`),
  KEY `sa_codcen` (`sa_codcen`),
  KEY `sa_codaux` (`sa_codaux`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `salidas`
--

LOCK TABLES `salidas` WRITE;
/*!40000 ALTER TABLE `salidas` DISABLE KEYS */;
/*!40000 ALTER TABLE `salidas` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `salidasdev`
--

DROP TABLE IF EXISTS `salidasdev`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `salidasdev` (
  `sa_tipo_sa` int(1) NOT NULL DEFAULT '1' COMMENT '1.Normal, 2. Almacen',
  `sa_numero` int(9) NOT NULL,
  `sa_codcli` varchar(12) NOT NULL,
  `sa_fecreg` date DEFAULT NULL,
  `sa_horreg` time NOT NULL DEFAULT '00:00:00',
  `sa_vlrtot` double(15,2) DEFAULT NULL,
  `sa_vlriva` double(15,2) DEFAULT NULL,
  `sa_apagar` double(15,2) DEFAULT NULL,
  `sa_estado` char(1) NOT NULL,
  `sa_codcen` varchar(6) NOT NULL,
  `sa_codaux` varchar(70) NOT NULL,
  `sa_usuario` varchar(15) NOT NULL,
  `sa_tipo` varchar(1) NOT NULL,
  `sa_ccosto` varchar(6) NOT NULL,
  `descripcion` text NOT NULL,
  `sa_clase` varchar(1) NOT NULL DEFAULT 'B' COMMENT 'Salidas Buenas o Malas',
  `sa_solicitud` int(11) NOT NULL,
  `sa_resori` varchar(12) NOT NULL,
  `sa_resdes` varchar(12) NOT NULL,
  PRIMARY KEY (`sa_numero`,`sa_tipo_sa`),
  KEY `sa_codcli` (`sa_codcli`),
  KEY `sa_codcen` (`sa_codcen`),
  KEY `sa_codaux` (`sa_codaux`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `salidasdev`
--

LOCK TABLES `salidasdev` WRITE;
/*!40000 ALTER TABLE `salidasdev` DISABLE KEYS */;
/*!40000 ALTER TABLE `salidasdev` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `secciones`
--

DROP TABLE IF EXISTS `secciones`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `secciones` (
  `se_codsec` int(4) NOT NULL DEFAULT '0',
  `se_descri` char(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`se_codsec`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `secciones`
--

LOCK TABLES `secciones` WRITE;
/*!40000 ALTER TABLE `secciones` DISABLE KEYS */;
INSERT INTO `secciones` (`se_codsec`, `se_descri`) VALUES (0,'NO APLICA'),(1001,'BODEGA ACUEDUCTO'),(1002,'BODEGA ALCANTARILLADO'),(1000,'BODEGA PRINCIPAL'),(1,'REDES'),(2,'DEPARTAMENTO OPERATIVO'),(3,'DEPARTAMENTO ADMINISTRATIVA'),(4,'GERENCIA'),(5,'QUEJAS Y RECLAMOS'),(6,'OFICINA CONTROL INTERNO'),(7,'DEPENDENCIA DE SISTEMAS'),(8,'DIVISION FINANCIERA'),(9,'OFICINA ALMACEN'),(10,'SERVICIOS GENERALES'),(14,'FACTURACION'),(15,'SECRETARIA GENERAL'),(16,'PLANTA BOMBEO'),(17,'PLANTA TRATAMIENTO'),(18,'PLANTA SUR'),(19,'JEFE RELLENO SANITARIO'),(20,'CELADURIA'),(21,'OPERARIO'),(22,'JEFATURA COMERCIAL'),(24,'ARCHIVO GENERAL'),(25,'FUNCIONARIA ADMINISTRATIVA'),(27,'LABORATORIO'),(28,'ASESOR JURIDICO'),(1004,'BODEGA ENERGIA'),(9902,'BODEGA DE RESPONSABILIDADES FISCALES'),(9999,'BODEGA DE INSERVIBLES'),(1003,'BODEGA ASEO');
/*!40000 ALTER TABLE `secciones` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `secuencia`
--

DROP TABLE IF EXISTS `secuencia`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `secuencia` (
  `se_tipsec` char(3) NOT NULL,
  `se_descri` char(40) DEFAULT NULL,
  `se_numero` int(9) DEFAULT NULL,
  PRIMARY KEY (`se_tipsec`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `secuencia`
--

LOCK TABLES `secuencia` WRITE;
/*!40000 ALTER TABLE `secuencia` DISABLE KEYS */;
INSERT INTO `secuencia` (`se_tipsec`, `se_descri`, `se_numero`) VALUES ('C','Compras',210000),('D','Descuentos',210000),('E','Factura Equivalente',210000),('F','Facturas',210000),('N','Recibos de pago Nomina',210000),('P','Recibos de Pago',210000),('R','Recibos de Caja',210000),('S','Salidas de Inventario',210000),('X','Cuentas Por Pagar',210000),('I','Disponibilidades',210000),('G','Registros Presupuestales',210000),('GP','Giro Presupuestal',210000),('CS','Consignaciones',210000),('PE','Pedidos Entradas',210000),('OR','Ordenes de Compra',210000),('PS','Pedidos Salidas',210000),('A','Adiciones Presupuestales',210000),('DP','Disminucion Presupuestal',210000),('TP','Traslado Presupuestal',210000),('OP','Orden de pago',210000),('EP','Egresos ordenes de pago',210000),('NB','Notas bancarias',210000),('CD','Cambios Disponibilidad',210000),('CR','Cambios Registros',210000),('RC','Recaudos Presupuestales',210000),('LC','Liquidacion Contrato',210000),('CN','Liquidacion Contrato',210000),('PC','Pagos directo por cuenta',210000),('SD','Solicitud de Disponibilidad',210000),('LA','Avances',210000),('TB','Traslados Bancarios',210000);
/*!40000 ALTER TABLE `secuencia` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `solicitud`
--

DROP TABLE IF EXISTS `solicitud`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `solicitud` (
  `sol_numero` int(9) NOT NULL,
  `sol_codcli` bigint(12) DEFAULT NULL,
  `sol_codres` char(12) NOT NULL,
  `sol_fecreg` date DEFAULT NULL,
  `sol_horreg` time NOT NULL DEFAULT '00:00:00',
  `sol_estado` char(1) NOT NULL,
  `sol_vigencia` int(9) NOT NULL,
  `sol_vlrtot` double(15,2) DEFAULT NULL,
  `sol_detalle` text NOT NULL,
  `sol_codsec` int(9) NOT NULL,
  `sol_codare` int(9) NOT NULL,
  PRIMARY KEY (`sol_numero`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `solicitud`
--

LOCK TABLES `solicitud` WRITE;
/*!40000 ALTER TABLE `solicitud` DISABLE KEYS */;
/*!40000 ALTER TABLE `solicitud` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `suspennom_liq`
--

DROP TABLE IF EXISTS `suspennom_liq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `suspennom_liq` (
  `sp_periodo` int(7) NOT NULL DEFAULT '0',
  `sp_cedula` bigint(12) NOT NULL DEFAULT '0',
  `sp_falta` char(2) NOT NULL,
  `sp_fecini` date DEFAULT NULL,
  `sp_valor` int(9) DEFAULT NULL,
  `sp_fecreg` date DEFAULT NULL,
  `sp_usuari` char(12) NOT NULL,
  `sp_detalle` text,
  PRIMARY KEY (`sp_periodo`,`sp_cedula`,`sp_falta`),
  KEY `sp_cedula` (`sp_cedula`),
  KEY `sp_falta` (`sp_falta`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `suspennom_liq`
--

LOCK TABLES `suspennom_liq` WRITE;
/*!40000 ALTER TABLE `suspennom_liq` DISABLE KEYS */;
/*!40000 ALTER TABLE `suspennom_liq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tarifas`
--

DROP TABLE IF EXISTS `tarifas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tarifas` (
  `tar_codigo` int(11) NOT NULL DEFAULT '0',
  `tar_minima` int(11) NOT NULL,
  `tar_banderazo` int(11) NOT NULL,
  `tar_caidamts` int(11) NOT NULL,
  `tar_caidaseg` int(11) NOT NULL,
  `tar_recargo` int(11) NOT NULL,
  `tar_radio` int(11) NOT NULL,
  `tar_aeropuerto` int(11) NOT NULL,
  `tar_porhoras` int(11) NOT NULL,
  PRIMARY KEY (`tar_codigo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tarifas`
--

LOCK TABLES `tarifas` WRITE;
/*!40000 ALTER TABLE `tarifas` DISABLE KEYS */;
/*!40000 ALTER TABLE `tarifas` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `temmovto`
--

DROP TABLE IF EXISTS `temmovto`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `temmovto` (
  `tem_tipcom` int(3) NOT NULL,
  `tem_numero` int(9) NOT NULL,
  `tem_codcta` char(12) NOT NULL,
  `tem_tercer` bigint(12) NOT NULL DEFAULT '0',
  `tem_tipmov` int(1) NOT NULL DEFAULT '0',
  `tem_auxili` int(9) DEFAULT NULL,
  `tem_codtic` char(3) NOT NULL,
  `tem_detall` char(50) DEFAULT NULL,
  `tem_cheque` char(12) DEFAULT NULL,
  `tem_codcen` int(6) NOT NULL DEFAULT '0',
  `tem_vlrmov` double(15,2) DEFAULT NULL,
  `tem_fecreg` date DEFAULT NULL,
  `tem_codemp` char(8) DEFAULT NULL,
  PRIMARY KEY (`tem_tipcom`,`tem_numero`,`tem_codcta`,`tem_tercer`,`tem_tipmov`,`tem_codcen`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `temmovto`
--

LOCK TABLES `temmovto` WRITE;
/*!40000 ALTER TABLE `temmovto` DISABLE KEYS */;
/*!40000 ALTER TABLE `temmovto` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `terceros`
--

DROP TABLE IF EXISTS `terceros`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `terceros` (
  `te_codcli` bigint(12) NOT NULL DEFAULT '0',
  `te_nombre` char(200) NOT NULL,
  `te_direcc` char(50) NOT NULL DEFAULT '',
  `te_telefo` char(12) NOT NULL DEFAULT '',
  `te_porcen` int(2) DEFAULT NULL,
  `te_nombr1` char(10) DEFAULT NULL,
  `te_nombr2` char(10) DEFAULT NULL,
  `te_apell1` char(20) DEFAULT NULL,
  `te_apell2` char(10) DEFAULT NULL,
  `te_codact` int(6) DEFAULT NULL,
  `te_codciu` int(3) DEFAULT NULL,
  `te_tipo` char(1) NOT NULL,
  `te_tipter` char(1) NOT NULL,
  `te_tipdoc` char(2) NOT NULL,
  `te_autore` char(1) NOT NULL,
  `te_gran` char(1) NOT NULL,
  `te_ent_publica` enum('S','N') NOT NULL,
  `te_regimen` varchar(1) NOT NULL,
  `te_estado` varchar(1) NOT NULL,
  `te_correo` varchar(70) NOT NULL,
  PRIMARY KEY (`te_codcli`),
  KEY `te_codact` (`te_codact`),
  KEY `te_codciu` (`te_codciu`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `terceros`
--

LOCK TABLES `terceros` WRITE;
/*!40000 ALTER TABLE `terceros` DISABLE KEYS */;
/*!40000 ALTER TABLE `terceros` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tico`
--

DROP TABLE IF EXISTS `tico`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tico` (
  `ti_codtip` int(3) NOT NULL,
  `ti_descri` char(40) DEFAULT NULL,
  `ti_numero` int(9) DEFAULT NULL,
  PRIMARY KEY (`ti_codtip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tico`
--

LOCK TABLES `tico` WRITE;
/*!40000 ALTER TABLE `tico` DISABLE KEYS */;
INSERT INTO `tico` (`ti_codtip`, `ti_descri`, `ti_numero`) VALUES (100,'Saldo Inicial',210000),(101,'Facturas Servicios Publicos',210000),(102,'Recibos de Recaudo',210000),(103,'Entradas',210000),(104,'Salidas de Inventario',210000),(105,'Notas Bancarias',210000),(106,'Consignaciones',210000),(107,'Notas Contables',210000),(108,'Descuentos de Facturas',210000),(109,'Cuentas Por pagar',210000),(110,'Recibos de Pago',210000),(111,'Compras y Ctas x Pagar',210000),(112,'Comprobante de Egreso Adicional',210000),(113,'Comprobante de Egreso',210000),(116,'Comprobante de Depreciacion',210000),(118,'Nomina',210000),(119,'Pago de Nomina',210000),(200,'Cierre de Año',210000),(115,'Notas Debito Facturacion',210000),(114,'Notas Credito Facturacion',210000),(117,'Comprobante de Ingreso',210000),(120,'Entrada Medidores OC',210000),(121,'Entrada Devolutivos OC',210000),(131,'Facturas de Portafolio',210000),(132,'Recibos de Pago',210000),(122,'Traslados Bancarios',210000),(133,'Notas Credito Facturacion Saldo A favor',210000),(140,'Pago Directos por cuenta',210000),(129,'Avances',210000),(170,'Depreciacion',210000);
/*!40000 ALTER TABLE `tico` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tico_niif`
--

DROP TABLE IF EXISTS `tico_niif`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tico_niif` (
  `ti_codtip` int(3) NOT NULL,
  `ti_descri` char(40) DEFAULT NULL,
  `ti_numero` int(9) DEFAULT NULL,
  PRIMARY KEY (`ti_codtip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tico_niif`
--

LOCK TABLES `tico_niif` WRITE;
/*!40000 ALTER TABLE `tico_niif` DISABLE KEYS */;
INSERT INTO `tico_niif` (`ti_codtip`, `ti_descri`, `ti_numero`) VALUES (100,'Saldo Inicial',0),(101,'Facturas',0),(102,'Recibos de Recaudo',0),(103,'Entradas',0),(104,'Salidas de Inventario',0),(105,'Notas Bancarias',0),(106,'Consignaciones',0),(107,'Notas Contables',0),(108,'Descuentos de Facturas',0),(109,'Cuentas Por pagar',0),(110,'Recibos de Pago',0),(111,'Comprobante de Causacion',0),(112,'Comprobante de Ingreso',0),(113,'Comprobante de Egreso',0),(116,'Comprobante de Depreciacion',0),(118,'Nomina',0),(119,'Pago de Nomina',0),(200,'Cierre de Año',0),(115,'Notas Debito Facturacion',0),(114,'Notas Credito Facturacion',0);
/*!40000 ALTER TABLE `tico_niif` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tidocu`
--

DROP TABLE IF EXISTS `tidocu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tidocu` (
  `td_tidocu` char(2) NOT NULL,
  `td_descri` char(40) DEFAULT NULL,
  PRIMARY KEY (`td_tidocu`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tidocu`
--

LOCK TABLES `tidocu` WRITE;
/*!40000 ALTER TABLE `tidocu` DISABLE KEYS */;
INSERT INTO `tidocu` (`td_tidocu`, `td_descri`) VALUES ('CC','Cedula de Ciudadania'),('CE','Cedula de Extranjeria'),('NI','NIT');
/*!40000 ALTER TABLE `tidocu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `timovto`
--

DROP TABLE IF EXISTS `timovto`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `timovto` (
  `tm_timovto` int(2) NOT NULL,
  `tm_descri` char(40) DEFAULT NULL,
  PRIMARY KEY (`tm_timovto`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `timovto`
--

LOCK TABLES `timovto` WRITE;
/*!40000 ALTER TABLE `timovto` DISABLE KEYS */;
INSERT INTO `timovto` (`tm_timovto`, `tm_descri`) VALUES (131,'Facturas Servicios Especiales'),(132,'Recibos de Caja Servicios especiales'),(103,'Entradas de Inventario'),(104,'Salidas de Inventario'),(108,'Descuentos de Facturas'),(109,'Cuentas Por Pagar'),(110,'Recibos de Pago'),(105,'Notas Bancarias'),(0,'Sin Definir'),(129,'Avances y Anticipos');
/*!40000 ALTER TABLE `timovto` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tipcon`
--

DROP TABLE IF EXISTS `tipcon`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tipcon` (
  `tc_codtic` char(3) NOT NULL,
  `tc_descri` char(40) DEFAULT NULL,
  PRIMARY KEY (`tc_codtic`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tipcon`
--

LOCK TABLES `tipcon` WRITE;
/*!40000 ALTER TABLE `tipcon` DISABLE KEYS */;
INSERT INTO `tipcon` (`tc_codtic`, `tc_descri`) VALUES ('CAU','Causacion'),('CIE','Cierre-Año'),('CON','Consignaciones'),('CXP','Cuenta Por Pagar'),('EIN','Entradas de Inventario'),('FAC','Segun Factura'),('NOB','Nota Bancaria'),('NOC','Nota Contable'),('NOF','Nota Facturacion'),('PT','Pago a Terceros'),('RC','Recibo de Caja No.'),('REC','Recaudos'),('REI','Segun Reintegro No.'),('SI','Saldo Inicial'),('SIN','Salida de Inventario');
/*!40000 ALTER TABLE `tipcon` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tipveh`
--

DROP TABLE IF EXISTS `tipveh`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tipveh` (
  `tv_tipveh` int(3) NOT NULL DEFAULT '0',
  `tv_descri` char(40) NOT NULL DEFAULT '',
  PRIMARY KEY (`tv_tipveh`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tipveh`
--

LOCK TABLES `tipveh` WRITE;
/*!40000 ALTER TABLE `tipveh` DISABLE KEYS */;
INSERT INTO `tipveh` (`tv_tipveh`, `tv_descri`) VALUES (0,'No Aplica');
/*!40000 ALTER TABLE `tipveh` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tmprevmovto_niif`
--

DROP TABLE IF EXISTS `tmprevmovto_niif`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tmprevmovto_niif` (
  `tmo_tipcom` int(3) NOT NULL,
  `tmo_numero` int(9) NOT NULL,
  `tmo_secuen` int(5) NOT NULL,
  `tmo_revela` text,
  PRIMARY KEY (`tmo_tipcom`,`tmo_numero`,`tmo_secuen`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tmprevmovto_niif`
--

LOCK TABLES `tmprevmovto_niif` WRITE;
/*!40000 ALTER TABLE `tmprevmovto_niif` DISABLE KEYS */;
/*!40000 ALTER TABLE `tmprevmovto_niif` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tramites`
--

DROP TABLE IF EXISTS `tramites`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tramites` (
  `tm_numero` int(9) NOT NULL,
  `tm_codare` int(3) NOT NULL,
  `tm_tidano` int(3) NOT NULL,
  `tm_fecreg` date DEFAULT NULL,
  `tm_horreg` time NOT NULL DEFAULT '00:00:00',
  `tm_codcli` bigint(12) NOT NULL,
  `tm_estado` char(1) NOT NULL,
  `tm_califi` char(1) DEFAULT NULL,
  `tm_feccon` date DEFAULT NULL,
  `tm_horcon` time NOT NULL DEFAULT '00:00:00',
  `tm_origen` char(1) NOT NULL,
  `tm_codres` char(12) NOT NULL,
  `tm_admin` double(12,2) NOT NULL,
  `tm_impre` double(12,2) NOT NULL,
  `tm_utilid` double(12,2) NOT NULL,
  `tm_ivauti` double(12,2) NOT NULL,
  PRIMARY KEY (`tm_numero`),
  KEY `tm_tidano` (`tm_tidano`),
  KEY `tm_codcli` (`tm_codcli`),
  KEY `tm_codare` (`tm_codare`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tramites`
--

LOCK TABLES `tramites` WRITE;
/*!40000 ALTER TABLE `tramites` DISABLE KEYS */;
INSERT INTO `tramites` (`tm_numero`, `tm_codare`, `tm_tidano`, `tm_fecreg`, `tm_horreg`, `tm_codcli`, `tm_estado`, `tm_califi`, `tm_feccon`, `tm_horcon`, `tm_origen`, `tm_codres`, `tm_admin`, `tm_impre`, `tm_utilid`, `tm_ivauti`) VALUES (1,0,0,'2013-03-01','10:46:16',0,'P','','0000-00-00','00:00:00','1','0',0.00,0.00,0.00,0.00);
/*!40000 ALTER TABLE `tramites` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `traslado`
--

DROP TABLE IF EXISTS `traslado`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `traslado` (
  `tra_numero` int(9) NOT NULL,
  `tra_codres` char(12) NOT NULL,
  `tra_fecreg` date DEFAULT NULL,
  `tra_horreg` time NOT NULL DEFAULT '00:00:00',
  `tra_estado` char(1) NOT NULL,
  `tra_tippag` char(1) NOT NULL,
  `tra_vlrtot` double(15,2) DEFAULT NULL,
  `tra_detalle` text NOT NULL,
  `tra_feccre` date NOT NULL,
  `tra_anopre` int(4) NOT NULL,
  PRIMARY KEY (`tra_numero`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `traslado`
--

LOCK TABLES `traslado` WRITE;
/*!40000 ALTER TABLE `traslado` DISABLE KEYS */;
/*!40000 ALTER TABLE `traslado` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `traslados`
--

DROP TABLE IF EXISTS `traslados`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `traslados` (
  `tr_numero` int(9) NOT NULL,
  `tr_cuenta_ori` char(12) DEFAULT NULL,
  `tr_cuenta_des` char(12) DEFAULT NULL,
  `tr_codres` char(12) NOT NULL,
  `tr_fecreg` date DEFAULT NULL,
  `tr_horreg` time NOT NULL DEFAULT '00:00:00',
  `tr_vlrtot` double(15,2) DEFAULT NULL,
  `tr_estado` char(1) NOT NULL,
  `tr_observa` text NOT NULL,
  `tr_codcli` bigint(12) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tr_numero`),
  KEY `tr_cuenta_ori` (`tr_cuenta_ori`),
  KEY `tr_cuenta_des` (`tr_cuenta_des`),
  KEY `tr_codcli` (`tr_codcli`),
  KEY `tr_codres` (`tr_codres`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `traslados`
--

LOCK TABLES `traslados` WRITE;
/*!40000 ALTER TABLE `traslados` DISABLE KEYS */;
/*!40000 ALTER TABLE `traslados` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `usuario`
--

DROP TABLE IF EXISTS `usuario`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `usuario` (
  `us_codemp` char(8) NOT NULL DEFAULT '',
  `us_nombre` char(40) NOT NULL DEFAULT '',
  `us_direcc` char(40) NOT NULL DEFAULT '',
  `us_telefo` char(10) NOT NULL DEFAULT '',
  `us_passwd` char(8) NOT NULL DEFAULT '',
  `us_nivelu` char(1) NOT NULL DEFAULT '',
  PRIMARY KEY (`us_codemp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `usuario`
--

LOCK TABLES `usuario` WRITE;
/*!40000 ALTER TABLE `usuario` DISABLE KEYS */;
/*!40000 ALTER TABLE `usuario` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vehiculo`
--

DROP TABLE IF EXISTS `vehiculo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vehiculo` (
  `vh_nropla` char(6) NOT NULL DEFAULT '',
  `vh_codmar` int(3) NOT NULL DEFAULT '0',
  `vh_tipveh` int(3) NOT NULL DEFAULT '0',
  `vh_descri` char(40) NOT NULL DEFAULT '',
  `vh_modelo` int(4) NOT NULL DEFAULT '0',
  `vh_nromot` char(20) DEFAULT NULL,
  `vh_nrocha` char(20) DEFAULT NULL,
  `vh_nrotra` char(20) DEFAULT NULL,
  `vh_nrocol` char(20) DEFAULT NULL,
  `vh_nroint` char(6) NOT NULL DEFAULT '0',
  `vh_combus` char(1) NOT NULL DEFAULT '',
  `vh_kmact` decimal(8,2) DEFAULT NULL,
  `vh_hmact` decimal(8,2) DEFAULT NULL,
  `vh_codcli` bigint(12) NOT NULL DEFAULT '0',
  `vh_pasaje` int(3) NOT NULL,
  `vh_cermov` int(10) DEFAULT NULL,
  `vh_feccer` date DEFAULT NULL,
  `vh_segobl` char(10) DEFAULT NULL,
  `vh_fecseg` date DEFAULT NULL,
  `vh_estado` char(1) NOT NULL DEFAULT '',
  `vh_afilia` char(1) NOT NULL,
  `vh_base` char(1) NOT NULL,
  PRIMARY KEY (`vh_nropla`),
  KEY `vh_tipveh` (`vh_tipveh`),
  KEY `vh_codcli` (`vh_codcli`),
  KEY `vh_codmar` (`vh_codmar`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vehiculo`
--

LOCK TABLES `vehiculo` WRITE;
/*!40000 ALTER TABLE `vehiculo` DISABLE KEYS */;
INSERT INTO `vehiculo` (`vh_nropla`, `vh_codmar`, `vh_tipveh`, `vh_descri`, `vh_modelo`, `vh_nromot`, `vh_nrocha`, `vh_nrotra`, `vh_nrocol`, `vh_nroint`, `vh_combus`, `vh_kmact`, `vh_hmact`, `vh_codcli`, `vh_pasaje`, `vh_cermov`, `vh_feccer`, `vh_segobl`, `vh_fecseg`, `vh_estado`, `vh_afilia`, `vh_base`) VALUES ('-',1,0,'No Aplica',0,'1','1','1','1','0','',1.00,1.00,0,0,1,'2011-11-01','1','2011-11-01','I','I','I');
/*!40000 ALTER TABLE `vehiculo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'antsoftw_sanangel_contable2021'
--

--
-- Dumping routines for database 'antsoftw_sanangel_contable2021'
--
/*!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 2024-03-13  3:58:59
