-- 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 */;
INSERT INTO `cuentasban` (`cb_cuenta`, `cb_descri`, `cb_codigo`) VALUES ('1110050102','Cta Cte N 004-9 Energia','1110050102'),('1110050103','Cta Cte N 005-6 Aseo','1110050103'),('1110050104','Cta Cte N 007-2 Acueducto','1110050104'),('1110050105','Cta Cte N 045-2 Recicladores y Escobitas','1110050105'),('1110050106','Cta Cte N 048-6 fondo distribucion de i','1110050106'),('1110050209','SUBSIDIOS ACUEDUCTO','1110050209'),('1110050107','Uso Racional Convenio 24','1110050107'),('1110050210','SUBSIDIOS ALCANTARILLADO','1110050210'),('1110050211','SUBSIDIOS ASEO','1110050211'),('0','NO APLICA',''),('1110050101','Cta Cte N 002-3 Alcantarillado','1110050101'),('1110060106','CTA AHORRO 475143007187 CONVENIO 08 ALUMB NAVI','1110060106'),('1110060107','CTA AHORRO 475143007152CONVENIO 006 ALCANTARILLADO','1110060107'),('1110050201','Cta Cte N 313-6 Subsidios menores','1110050201'),('1110050202','Cta Cte N 386-2 Energia','1110050202'),('1110060202','P.A. COMERCIALIZADORES FIDEICOMITENTE 2','1110060202'),('1110060301','Fideicomiso fondo empresarial','1110060301');
/*!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','UNIDAD DE SERVICIOS PÚBLICOS','T','','','','','','','','','',''),('1','TOTAL PRESUPUESTO DE INGRESOS','T','','','','','','','','','',''),('101','ACUEDUCTO','T','','','','','','','','','',''),('10101','INGRESOS CORRIENTES','T','','','','','','','','','',''),('1010101','SERVICIO DE ACUEDUCTO','T','','','','','','','','','',''),('101010101','Consumo Acueducto','D','','','','','','','','','',''),('101010102','Recuperacion de Cartera','D','','','','','','','','','',''),('101010103','Derechos de Conexion','D','','','','','','','','','',''),('101010104','Venta de Micromedidores','D','','','','','','','','','',''),('101010105','Venta de Materiales','D','','','','','','','','','',''),('102','ALCANTARILLADO','T','','','','','','','','','',''),('10201','INGRESOS CORRIENTES','T','','','','','','','','','',''),('1020101','SERVICIO DE ALCANTARILLADO','T','','','','','','','','','',''),('102010101','Venta de Servicios Alcantarillado','D','','','','','','','','','',''),('102010102','Conexiones Alcantarillado','D','','','','','','','','','',''),('103','ASEO','T','','','','','','','','','',''),('10301','INGRESOS CORRIENTES','T','','','','','','','','','',''),('1030101','RECOLECCION TRASPORTE Y DISPOSICION FINAL','T','','','','','','','','','',''),('104','SISTEMA GENERAL DE PARTICIPACIONES','T','','','','','','','','','',''),('10401','SUBSIDIOS','T','','','','','','','','','',''),('1040101','SUBSIDIO ACUEDUCTO','D','','','','','','','','','',''),('1040102','SUBSIDIO ALCANTARILLADO','D','','','','','','','','','',''),('1040103','SUBSIDIO ASEO','D','','','','','','','','','',''),('105','INGRESOS CAPITAL','T','','','','','','','','','',''),('10501','INGRESOS CAPITAL','T','','','','','','','','','',''),('1050101','RENDIMIENTOS FINANCIEROS-RECURSOS PROPIOS','D','','','','','','','','','',''),('25','UNIDAD DE SERVICIOS P?BLICOS','T','','','','','','','','','',''),('251','FUNCIONAMIENTO','T','','','','','','','','','',''),('2510','NINGUNO','T','','','','','','','','','',''),('251001','GASTOS DE PERSONAL','T','','','','','','','','','',''),('25100112','UNIDAD DE SERVICIOS P?BLICOS','T','','','','','','','','','',''),('2510011201','SERVICIOS PERSONALES ASOCIADOS A LA N?MINA','T','','','','','','','','','',''),('25100112010153','Suedo Personal de N?mina','D','','','','','','','','','',''),('25100112010253','Vacaciones','D','','','','','','','','','',''),('25100112010353','Prima de Navidad','D','','','','','','','','','',''),('2510011202','SERVICIOS PERSONALES INDIRECTOS','T','','','','','','','','','',''),('25100112020153','Honorarios y Servicios Profesionales','D','','','','','','','','','',''),('25100112020253','Servicios T?cnicos','D','','','','','','','','','',''),('25100112020353','Servicios Caracterizaci?n Agua, Aire - Relleno Sanitario','D','','','','','','','','','',''),('25100112020453','Servicio Topograf?a Control Acentamiento Relleno Sanitario','D','','','','','','','','','',''),('25100112020553','Otros Servicios Personales Indirectos','D','','','','','','','','','',''),('2510011203','CONTRIBUCIONES INHERENTES A LA N?MINA','T','','','','','','','','','',''),('25100112030153','Aportes para Cesant?as','D','','','','','','','','','',''),('25100112030253','Aportes para Seguridad Social Pensi?n','D','','','','','','','','','',''),('25100112030353','Aportes para Seguridad Social Salud','D','','','','','','','','','',''),('25100112030453','Aportes para Riesgos Laborales','D','','','','','','','','','',''),('25100112030553','Caja de Compensaci?n Familiar de Amazonas','D','','','','','','','','','',''),('251002','GASTOS GENERALES','T','','','','','','','','','',''),('25100212','UNIDAD DE SERVICIOS P?BLICOS','T','','','','','','','','','',''),('2510021206','ADQUISICI?N DE BIENES','T','','','','','','','','','',''),('25100212060153','Materiales y Suministros','D','','','','','','','','','',''),('25100212060253','Compra de Equipos','D','','','','','','','','','',''),('25100212060353','Dotaci?n Personal','D','','','','','','','','','',''),('25100212060453','Enseres y Equipo de Oficina','D','','','','','','','','','',''),('25100212060553','Papeler?a y ?tiles de Oficina','D','','','','','','','','','',''),('25100212060653','Combustible, Lubricantes y Grasas','D','','','','','','','','','',''),('25100212060753','?tiles de Cafeter?a y Aseo','D','','','','','','','','','',''),('2510021207','ADQUISICI?N DE SERVICIOS','T','','','','','','','','','',''),('25100212070153','Vi?ticos y Gastos de Transporte y de Viaje','D','','','','','','','','','',''),('25100212070253','Comunicaci?n y Transporte','D','','','','','','','','','',''),('25100212070353','Servicios P?blicos - Energ','D','','','','','','','','','',''),('25100212070453','Publicidad','D','','','','','','','','','',''),('25100212070553','Impresos, Publicaciones, Suscripciones y Afiliaciones','D','','','','','','','','','',''),('25100212070653','Seguros','D','','','','','','','','','',''),('25100212070753','Mantenimiento y Reparaciones','D','','','','','','','','','',''),('25100212070827','Alquiler de Maquinaria','D','','','','','','','','','',''),('25100212070953','Alquiler de Maquinaria','D','','','','','','','','','',''),('25100212071053','Grav?men a Movimientos Financieros','D','','','','','','','','','',''),('25100212071153','Contribuciones CRA','D','','','','','','','','','',''),('25100212071253','Contribuciones a la Superintendencia','D','','','','','','','','','',''),('25100212071353','Industria y Comercio','D','','','','','','','','','',''),('25100212071453','Impuesto Alumbrado P?blico','D','','','','','','','','','',''),('25100212071553','Intereses','D','','','','','','','','','',''),('25100212071653','Multas','D','','','','','','','','','',''),('25100212071753','Sanciones','D','','','','','','','','','',''),('25100212071853','Otros Impuestos, Tasas y Contribuciones','D','','','','','','','','','',''),('25100212071953','Convenio ENAM','D','','','','','','','','','',''),('25100212072053','Prestamo FINDETER','D','','','','','','','','','',''),('251003','TRANSFERENCIAS CORRIENTES','T','','','','','','','','','',''),('25100312','UNIDAD DE SERVICIOS P?BLICOS','T','','','','','','','','','',''),('2510031210','OTRAS TRANSFERENCIAS CORRIENTES','T','','','','','','','','','',''),('25100312100153','Sentencias','D','','','','','','','','','',''),('251028','AGUA POTABLE Y SANEAMIENTO B?SICO','T','','','','','','','','','',''),('25102812','UNIDAD DE SERVICIOS P?BLICOS','T','','','','','','','','','',''),('2510281247','AGUA Y ENTORNOS SALUDABLES PENSANDO EN GRANDE','T','','','','','','','','','',''),('25102812470153','Micromedidores','D','','','','','','','','','',''),('25102812470253','V?lvulas y Accesorios','D','','','','','','','','','',''),('25102812470353','Tapas, Cajillas, Registros, Tuber?a de Presi?n','D','','','','','','','','','',''),('25102812470427','Insumos Qu?micos Acueducto','D','','','','','','','','','',''),('25102812470527','Insumos Relleno Sanitario','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 ('25100112020153','1','Honorarios ','24905401','51080201'),('25100112020253','1','Servicios tecnicos','24905501','75010205');
/*!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 */;
INSERT INTO `cuotasnom_liq` (`ct_periodo`, `ct_cedula`, `ct_codcon`, `ct_cobro`, `ct_totfin`, `ct_vlrtot`, `ct_vlrcuo`, `ct_cuotas`, `ct_pagada`, `ct_fecreg`, `ct_usuari`, `ct_estado`) VALUES (202101,15887827,113,0,2536464.00,2536464.00,211372.00,12,0,'2021-01-01','1121205881','A'),(202101,6565822,113,0,960696.00,960696.00,80058.00,12,0,'2021-01-01','1121205881','A');
/*!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 */;
INSERT INTO `cxp` (`cxp_numero`, `cxp_codcli`, `cxp_nropla`, `cxp_codres`, `cxp_fecreg`, `cxp_horreg`, `cxp_vlrtot`, `cxp_descli`, `cxp_vlriva`, `cxp_vlretencion`, `cxp_vlreteica`, `cxp_vlretebom`, `cxp_vlreteiva`, `cxp_apagar`, `cxp_estado`, `cxp_tippag`, `cxp_pagado`, `cxp_observ`, `cxp_fecven`, `cxp_usuari`) VALUES (210001,1121205881,'','1121205881','2021-01-04','02:54:33',2700321.00,0.00,0.00,0.00,0.00,0.00,0.00,2700321.00,'P','N',0.00,'','2021-01-04','1121205881'),(210002,1121207115,'','1121205881','2021-01-08','10:25:41',1729622.00,0.00,0.00,0.00,0.00,0.00,0.00,1729622.00,'P','N',0.00,'','2021-01-08','1121205881');
/*!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 */;
INSERT INTO `detavances` (`da_numero`, `da_codcon`, `da_nrofac`, `da_vlrtot`, `da_detalle`) VALUES (210001,201,0,50000.00,'AVANCE DE VIATICOS SEGUN RESOLUCION ADMON N 005 DE 2021'),(210002,201,0,50000.00,'AVANCE DE VIATICOS SEGUN RESOLUCION ADMON N 005 DE 2021'),(210003,201,0,50000.00,''),(210004,201,0,50000.00,''),(210005,201,0,310000.00,''),(210006,201,0,310000.00,'AVANCE DE VIATICOS SEGUN RESOLUCION ADMON N 009 DE 2021');
/*!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 */;
INSERT INTO `detdisponibilidad` (`ddis_numero`, `ddis_codcta`, `ddis_vlrtot`, `ddis_regist`, `ddis_girosp`, `ddis_reinte`, `ddis_saldod`, `ddis_vlrfut`, `ddis_ejefut`) VALUES (210002,'25100112020153',18894372.00,18894372.00,0.00,0.00,0.00,0.00,0.00),(210003,'25100112020253',11164848.00,11164848.00,0.00,0.00,0.00,0.00,0.00);
/*!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 */;
INSERT INTO `detliquinom_liq` (`dlq_periodo`, `dlq_cedula`, `dlq_codcon`, `dlq_apagar`) VALUES (202101,41061456,1,1081078.00),(202101,41061456,5,106454.00),(202101,41061456,14,43243.12),(202101,41061456,15,43243.12),(202101,41061456,16,91891.63),(202101,41061456,18,129729.36),(202101,41061456,21,43243.12),(202101,41061456,22,32432.34),(202101,41061456,23,21621.56),(202101,41061456,24,26335.06),(202101,41061456,25,94487.61),(202101,41061456,26,45048.52),(202101,41061456,27,94487.61),(202101,41061456,28,11343.05),(202101,41061456,40,128237.47),(202101,41061456,41,89653.80),(202101,41057122,1,936934.27),(202101,41057122,5,92260.13),(202101,41057122,14,37477.37),(202101,41057122,15,37477.37),(202101,41057122,16,79639.41),(202101,41057122,18,112432.11),(202101,41057122,21,37477.37),(202101,41057122,22,28108.03),(202101,41057122,23,18738.69),(202101,41057122,24,22823.72),(202101,41057122,25,85762.77),(202101,41057122,26,39042.05),(202101,41057122,27,85762.77),(202101,41057122,28,10291.94),(202101,41057122,40,111139.14),(202101,41057122,41,77699.96),(202101,40179489,1,1081078.00),(202101,40179489,5,106454.00),(202101,40179489,14,43243.12),(202101,40179489,15,43243.12),(202101,40179489,16,91891.63),(202101,40179489,18,129729.36),(202101,40179489,21,43243.12),(202101,40179489,22,32432.34),(202101,40179489,23,21621.56),(202101,40179489,24,26335.06),(202101,40179489,25,94487.61),(202101,40179489,26,45048.52),(202101,40179489,27,94487.61),(202101,40179489,28,11343.05),(202101,40179489,40,128237.47),(202101,40179489,41,89653.80),(202101,35522746,1,1081078.00),(202101,35522746,5,106454.00),(202101,35522746,14,43243.12),(202101,35522746,15,43243.12),(202101,35522746,16,91891.63),(202101,35522746,18,129729.36),(202101,35522746,21,43243.12),(202101,35522746,22,32432.34),(202101,35522746,23,21621.56),(202101,35522746,24,26335.06),(202101,35522746,25,94487.61),(202101,35522746,26,45048.52),(202101,35522746,27,94487.61),(202101,35522746,28,11343.05),(202101,35522746,40,128237.47),(202101,35522746,41,89653.80),(202101,26636785,1,1081078.00),(202101,26636785,5,106454.00),(202101,26636785,14,43243.12),(202101,26636785,15,43243.12),(202101,26636785,16,91891.63),(202101,26636785,18,129729.36),(202101,26636785,21,43243.12),(202101,26636785,22,32432.34),(202101,26636785,23,21621.56),(202101,26636785,24,26335.06),(202101,26636785,25,94487.61),(202101,26636785,26,45048.52),(202101,26636785,27,94487.61),(202101,26636785,28,11343.05),(202101,26636785,40,128237.47),(202101,26636785,41,89653.80),(202101,40179500,1,1081078.00),(202101,40179500,5,106454.00),(202101,40179500,14,43243.12),(202101,40179500,15,43243.12),(202101,40179500,16,91891.63),(202101,40179500,18,129729.36),(202101,40179500,21,43243.12),(202101,40179500,22,32432.34),(202101,40179500,23,21621.56),(202101,40179500,24,26335.06),(202101,40179500,25,94487.61),(202101,40179500,26,45048.52),(202101,40179500,27,94487.61),(202101,40179500,28,11343.05),(202101,40179500,40,128237.47),(202101,40179500,41,89653.80),(202101,15888856,1,1966387.00),(202101,15888856,14,78655.48),(202101,15888856,15,78655.48),(202101,15888856,16,167142.89),(202101,15888856,18,235966.44),(202101,15888856,21,78655.48),(202101,15888856,22,58991.61),(202101,15888856,23,39327.74),(202101,15888856,24,47901.19),(202101,15888856,25,163800.04),(202101,15888856,26,81939.35),(202101,15888856,27,163800.04),(202101,15888856,28,19663.87),(202101,15888856,40,233252.83),(202101,15888856,41,163072.47),(202101,6565822,1,1317216.00),(202101,6565822,5,106454.00),(202101,6565822,113,80058.00),(202101,6565822,14,52688.64),(202101,6565822,15,52688.64),(202101,6565822,16,111963.36),(202101,6565822,18,158065.92),(202101,6565822,21,52688.64),(202101,6565822,22,39516.48),(202101,6565822,23,26344.32),(202101,6565822,24,32087.38),(202101,6565822,25,114157.90),(202101,6565822,26,54888.39),(202101,6565822,27,114157.90),(202101,6565822,28,13704.43),(202101,6565822,40,156248.16),(202101,6565822,41,109236.72),(202101,15889146,1,1317216.00),(202101,15889146,5,106454.00),(202101,15889146,14,52688.64),(202101,15889146,15,52688.64),(202101,15889146,16,111963.36),(202101,15889146,18,158065.92),(202101,15889146,21,52688.64),(202101,15889146,22,39516.48),(202101,15889146,23,26344.32),(202101,15889146,24,32087.38),(202101,15889146,25,114157.90),(202101,15889146,26,54888.39),(202101,15889146,27,114157.90),(202101,15889146,28,13704.43),(202101,15889146,40,156248.16),(202101,15889146,41,109236.72),(202101,6567094,1,1317216.00),(202101,6567094,5,106454.00),(202101,6567094,14,52688.64),(202101,6567094,15,52688.64),(202101,6567094,16,111963.36),(202101,6567094,18,158065.92),(202101,6567094,21,52688.64),(202101,6567094,22,39516.48),(202101,6567094,23,26344.32),(202101,6567094,24,32087.38),(202101,6567094,25,114157.90),(202101,6567094,26,54888.39),(202101,6567094,27,114157.90),(202101,6567094,28,13704.43),(202101,6567094,40,156248.16),(202101,6567094,41,109236.72),(202101,6566915,1,1317216.00),(202101,6566915,5,106454.00),(202101,6566915,14,52688.64),(202101,6566915,15,52688.64),(202101,6566915,16,111963.36),(202101,6566915,18,158065.92),(202101,6566915,21,52688.64),(202101,6566915,22,39516.48),(202101,6566915,23,26344.32),(202101,6566915,24,32087.38),(202101,6566915,25,114157.90),(202101,6566915,26,54888.39),(202101,6566915,27,114157.90),(202101,6566915,28,13704.43),(202101,6566915,40,156248.16),(202101,6566915,41,109236.72),(202101,1122267585,1,1317216.00),(202101,1122267585,5,106454.00),(202101,1122267585,14,52688.64),(202101,1122267585,15,52688.64),(202101,1122267585,16,111963.36),(202101,1122267585,18,158065.92),(202101,1122267585,21,52688.64),(202101,1122267585,22,39516.48),(202101,1122267585,23,26344.32),(202101,1122267585,24,32087.38),(202101,1122267585,25,114157.90),(202101,1122267585,26,54888.39),(202101,1122267585,27,114157.90),(202101,1122267585,28,13704.43),(202101,1122267585,40,156248.16),(202101,1122267585,41,109236.72),(202101,6566670,1,1317216.00),(202101,6566670,5,106454.00),(202101,6566670,14,52688.64),(202101,6566670,15,52688.64),(202101,6566670,16,111963.36),(202101,6566670,18,158065.92),(202101,6566670,21,52688.64),(202101,6566670,22,39516.48),(202101,6566670,23,26344.32),(202101,6566670,24,32087.38),(202101,6566670,25,114157.90),(202101,6566670,26,54888.39),(202101,6566670,27,114157.90),(202101,6566670,28,13704.43),(202101,6566670,40,156248.16),(202101,6566670,41,109236.72),(202101,6566664,1,1545738.00),(202101,6566664,5,106454.00),(202101,6566664,14,61829.52),(202101,6566664,15,61829.52),(202101,6566664,16,131387.73),(202101,6566664,18,185488.56),(202101,6566664,21,61829.52),(202101,6566664,22,46372.14),(202101,6566664,23,30914.76),(202101,6566664,24,37654.18),(202101,6566664,25,133193.78),(202101,6566664,26,64410.90),(202101,6566664,27,133193.78),(202101,6566664,28,15989.65),(202101,6566664,40,183355.44),(202101,6566664,41,128188.05),(202101,12230636,1,1966387.00),(202101,12230636,14,78655.48),(202101,12230636,15,78655.48),(202101,12230636,16,167142.89),(202101,12230636,18,235966.44),(202101,12230636,21,78655.48),(202101,12230636,22,58991.61),(202101,12230636,23,39327.74),(202101,12230636,24,47901.19),(202101,12230636,25,163800.04),(202101,12230636,26,81939.35),(202101,12230636,27,163800.04),(202101,12230636,28,19663.87),(202101,12230636,40,233252.83),(202101,12230636,41,163072.47),(202101,15323907,1,2242482.00),(202101,15323907,14,89699.28),(202101,15323907,15,89699.28),(202101,15323907,16,190610.97),(202101,15323907,18,269097.84),(202101,15323907,21,89699.28),(202101,15323907,22,67274.46),(202101,15323907,23,44849.64),(202101,15323907,24,54626.86),(202101,15323907,25,186798.75),(202101,15323907,26,93444.22),(202101,15323907,27,186798.75),(202101,15323907,28,22424.82),(202101,15323907,40,266003.21),(202101,15323907,41,185969.03),(202101,1121202335,1,1317216.00),(202101,1121202335,5,106454.00),(202101,1121202335,14,52688.64),(202101,1121202335,15,52688.64),(202101,1121202335,16,111963.36),(202101,1121202335,18,158065.92),(202101,1121202335,21,52688.64),(202101,1121202335,22,39516.48),(202101,1121202335,23,26344.32),(202101,1121202335,24,32087.38),(202101,1121202335,25,114157.90),(202101,1121202335,26,54888.39),(202101,1121202335,27,114157.90),(202101,1121202335,28,13704.43),(202101,1121202335,40,156248.16),(202101,1121202335,41,109236.72),(202101,15879400,1,1317216.00),(202101,15879400,5,106454.00),(202101,15879400,14,52688.64),(202101,15879400,15,52688.64),(202101,15879400,16,111963.36),(202101,15879400,18,158065.92),(202101,15879400,21,52688.64),(202101,15879400,22,39516.48),(202101,15879400,23,26344.32),(202101,15879400,24,32087.38),(202101,15879400,25,114157.90),(202101,15879400,26,54888.39),(202101,15879400,27,114157.90),(202101,15879400,28,13704.43),(202101,15879400,40,156248.16),(202101,15879400,41,109236.72),(202101,15879542,1,1317216.00),(202101,15879542,5,106454.00),(202101,15879542,14,52688.64),(202101,15879542,15,52688.64),(202101,15879542,16,111963.36),(202101,15879542,18,158065.92),(202101,15879542,21,52688.64),(202101,15879542,22,39516.48),(202101,15879542,23,26344.32),(202101,15879542,24,32087.38),(202101,15879542,25,114157.90),(202101,15879542,26,54888.39),(202101,15879542,27,114157.90),(202101,15879542,28,13704.43),(202101,15879542,40,156248.16),(202101,15879542,41,109236.72),(202101,18070075,1,1317216.00),(202101,18070075,5,106454.00),(202101,18070075,14,52688.64),(202101,18070075,15,52688.64),(202101,18070075,16,111963.36),(202101,18070075,18,158065.92),(202101,18070075,21,52688.64),(202101,18070075,22,39516.48),(202101,18070075,23,26344.32),(202101,18070075,24,32087.38),(202101,18070075,25,114157.90),(202101,18070075,26,54888.39),(202101,18070075,27,114157.90),(202101,18070075,28,13704.43),(202101,18070075,40,156248.16),(202101,18070075,41,109236.72),(202101,15888658,1,1317216.00),(202101,15888658,5,106454.00),(202101,15888658,14,52688.64),(202101,15888658,15,52688.64),(202101,15888658,16,111963.36),(202101,15888658,18,158065.92),(202101,15888658,21,52688.64),(202101,15888658,22,39516.48),(202101,15888658,23,26344.32),(202101,15888658,24,32087.38),(202101,15888658,25,114157.90),(202101,15888658,26,54888.39),(202101,15888658,27,114157.90),(202101,15888658,28,13704.43),(202101,15888658,40,156248.16),(202101,15888658,41,109236.72),(202101,1121209707,1,1317216.00),(202101,1121209707,5,106454.00),(202101,1121209707,14,52688.64),(202101,1121209707,15,52688.64),(202101,1121209707,16,111963.36),(202101,1121209707,18,158065.92),(202101,1121209707,21,52688.64),(202101,1121209707,22,39516.48),(202101,1121209707,23,26344.32),(202101,1121209707,24,32087.38),(202101,1121209707,25,114157.90),(202101,1121209707,26,54888.39),(202101,1121209707,27,114157.90),(202101,1121209707,28,13704.43),(202101,1121209707,40,156248.16),(202101,1121209707,41,109236.72),(202101,1121200881,1,1317216.00),(202101,1121200881,5,106454.00),(202101,1121200881,14,52688.64),(202101,1121200881,15,52688.64),(202101,1121200881,16,111963.36),(202101,1121200881,18,158065.92),(202101,1121200881,21,52688.64),(202101,1121200881,22,39516.48),(202101,1121200881,23,26344.32),(202101,1121200881,24,32087.38),(202101,1121200881,25,114157.90),(202101,1121200881,26,54888.39),(202101,1121200881,27,114157.90),(202101,1121200881,28,13704.43),(202101,1121200881,40,156248.16),(202101,1121200881,41,109236.72),(202101,15887593,1,1317216.00),(202101,15887593,5,106454.00),(202101,15887593,14,52688.64),(202101,15887593,15,52688.64),(202101,15887593,16,111963.36),(202101,15887593,18,158065.92),(202101,15887593,21,52688.64),(202101,15887593,22,39516.48),(202101,15887593,23,26344.32),(202101,15887593,24,32087.38),(202101,15887593,25,114157.90),(202101,15887593,26,54888.39),(202101,15887593,27,114157.90),(202101,15887593,28,13704.43),(202101,15887593,40,156248.16),(202101,15887593,41,109236.72),(202101,15889012,1,1317216.00),(202101,15889012,5,106454.00),(202101,15889012,14,52688.64),(202101,15889012,15,52688.64),(202101,15889012,16,111963.36),(202101,15889012,18,158065.92),(202101,15889012,21,52688.64),(202101,15889012,22,39516.48),(202101,15889012,23,26344.32),(202101,15889012,24,32087.38),(202101,15889012,25,114157.90),(202101,15889012,26,54888.39),(202101,15889012,27,114157.90),(202101,15889012,28,13704.43),(202101,15889012,40,156248.16),(202101,15889012,41,109236.72),(202101,15889590,1,1317216.00),(202101,15889590,5,106454.00),(202101,15889590,14,52688.64),(202101,15889590,15,52688.64),(202101,15889590,16,111963.36),(202101,15889590,18,158065.92),(202101,15889590,21,52688.64),(202101,15889590,22,39516.48),(202101,15889590,23,26344.32),(202101,15889590,24,32087.38),(202101,15889590,25,114157.90),(202101,15889590,26,54888.39),(202101,15889590,27,114157.90),(202101,15889590,28,13704.43),(202101,15889590,40,156248.16),(202101,15889590,41,109236.72),(202101,15876459,1,1317216.00),(202101,15876459,5,106454.00),(202101,15876459,14,52688.64),(202101,15876459,15,52688.64),(202101,15876459,16,111963.36),(202101,15876459,18,158065.92),(202101,15876459,21,52688.64),(202101,15876459,22,39516.48),(202101,15876459,23,26344.32),(202101,15876459,24,32087.38),(202101,15876459,25,114157.90),(202101,15876459,26,54888.39),(202101,15876459,27,114157.90),(202101,15876459,28,13704.43),(202101,15876459,40,156248.16),(202101,15876459,41,109236.72),(202101,6566799,1,1317216.00),(202101,6566799,5,106454.00),(202101,6566799,14,52688.64),(202101,6566799,15,52688.64),(202101,6566799,16,111963.36),(202101,6566799,18,158065.92),(202101,6566799,21,52688.64),(202101,6566799,22,39516.48),(202101,6566799,23,26344.32),(202101,6566799,24,32087.38),(202101,6566799,25,114157.90),(202101,6566799,26,54888.39),(202101,6566799,27,114157.90),(202101,6566799,28,13704.43),(202101,6566799,40,156248.16),(202101,6566799,41,109236.72),(202101,15887089,1,1317216.00),(202101,15887089,5,106454.00),(202101,15887089,14,52688.64),(202101,15887089,15,52688.64),(202101,15887089,16,111963.36),(202101,15887089,18,158065.92),(202101,15887089,21,52688.64),(202101,15887089,22,39516.48),(202101,15887089,23,26344.32),(202101,15887089,24,32087.38),(202101,15887089,25,114157.90),(202101,15887089,26,54888.39),(202101,15887089,27,114157.90),(202101,15887089,28,13704.43),(202101,15887089,40,156248.16),(202101,15887089,41,109236.72),(202101,6565709,1,1317216.00),(202101,6565709,5,106454.00),(202101,6565709,14,52688.64),(202101,6565709,15,52688.64),(202101,6565709,16,111963.36),(202101,6565709,18,158065.92),(202101,6565709,21,52688.64),(202101,6565709,22,39516.48),(202101,6565709,23,26344.32),(202101,6565709,24,52688.64),(202101,6565709,25,114157.90),(202101,6565709,26,54888.39),(202101,6565709,27,114157.90),(202101,6565709,28,13704.43),(202101,6565709,40,156248.16),(202101,6565709,41,109236.72),(202101,15877394,1,1317216.00),(202101,15877394,5,106454.00),(202101,15877394,14,52688.64),(202101,15877394,15,52688.64),(202101,15877394,16,111963.36),(202101,15877394,18,158065.92),(202101,15877394,21,52688.64),(202101,15877394,22,39516.48),(202101,15877394,23,26344.32),(202101,15877394,24,32087.38),(202101,15877394,25,114157.90),(202101,15877394,26,54888.39),(202101,15877394,27,114157.90),(202101,15877394,28,13704.43),(202101,15877394,40,156248.16),(202101,15877394,41,109236.72),(202101,15876086,1,1317216.00),(202101,15876086,5,106454.00),(202101,15876086,14,52688.64),(202101,15876086,15,52688.64),(202101,15876086,16,111963.36),(202101,15876086,18,158065.92),(202101,15876086,21,52688.64),(202101,15876086,22,39516.48),(202101,15876086,23,26344.32),(202101,15876086,24,32087.38),(202101,15876086,25,114157.90),(202101,15876086,26,54888.39),(202101,15876086,27,114157.90),(202101,15876086,28,13704.43),(202101,15876086,40,156248.16),(202101,15876086,41,109236.72),(202101,15886945,1,1317216.00),(202101,15886945,5,106454.00),(202101,15886945,14,52688.64),(202101,15886945,15,52688.64),(202101,15886945,16,111963.36),(202101,15886945,18,158065.92),(202101,15886945,21,52688.64),(202101,15886945,22,39516.48),(202101,15886945,23,26344.32),(202101,15886945,24,32087.38),(202101,15886945,25,114157.90),(202101,15886945,26,54888.39),(202101,15886945,27,114157.90),(202101,15886945,28,13704.43),(202101,15886945,40,156248.16),(202101,15886945,41,109236.72),(202101,15876584,1,1966387.00),(202101,15876584,14,78655.48),(202101,15876584,15,78655.48),(202101,15876584,16,167142.89),(202101,15876584,18,235966.44),(202101,15876584,21,78655.48),(202101,15876584,22,58991.61),(202101,15876584,23,39327.74),(202101,15876584,24,47901.19),(202101,15876584,25,163800.04),(202101,15876584,26,81939.35),(202101,15876584,27,163800.04),(202101,15876584,28,19663.87),(202101,15876584,40,233252.83),(202101,15876584,41,163072.47),(202101,15887827,1,1966387.00),(202101,15887827,113,211372.00),(202101,15887827,14,78655.48),(202101,15887827,15,78655.48),(202101,15887827,16,167142.89),(202101,15887827,18,235966.44),(202101,15887827,21,78655.48),(202101,15887827,22,58991.61),(202101,15887827,23,39327.74),(202101,15887827,24,47901.19),(202101,15887827,25,163800.04),(202101,15887827,26,81939.35),(202101,15887827,27,163800.04),(202101,15887827,28,19663.87),(202101,15887827,40,233252.83),(202101,15887827,41,163072.47),(202101,41055613,1,1081078.00),(202101,41055613,5,106454.00),(202101,41055613,14,43243.12),(202101,41055613,15,43243.12),(202101,41055613,16,91891.63),(202101,41055613,18,129729.36),(202101,41055613,21,43243.12),(202101,41055613,22,32432.34),(202101,41055613,23,21621.56),(202101,41055613,24,26335.06),(202101,41055613,25,94487.61),(202101,41055613,26,45048.52),(202101,41055613,27,94487.61),(202101,41055613,28,11343.05),(202101,41055613,40,128237.47),(202101,41055613,41,89653.80),(202101,41057835,1,1081078.00),(202101,41057835,5,106454.00),(202101,41057835,14,43243.12),(202101,41057835,15,43243.12),(202101,41057835,16,91891.63),(202101,41057835,18,129729.36),(202101,41057835,21,43243.12),(202101,41057835,22,32432.34),(202101,41057835,23,21621.56),(202101,41057835,24,26335.06),(202101,41057835,25,94487.61),(202101,41057835,26,45048.52),(202101,41057835,27,94487.61),(202101,41057835,28,11343.05),(202101,41057835,40,128237.47),(202101,41057835,41,89653.80),(202101,1121200251,1,1081078.00),(202101,1121200251,5,106454.00),(202101,1121200251,14,43243.12),(202101,1121200251,15,43243.12),(202101,1121200251,16,91891.63),(202101,1121200251,18,129729.36),(202101,1121200251,21,43243.12),(202101,1121200251,22,32432.34),(202101,1121200251,23,21621.56),(202101,1121200251,24,26335.06),(202101,1121200251,25,94487.61),(202101,1121200251,26,45048.52),(202101,1121200251,27,94487.61),(202101,1121200251,28,11343.05),(202101,1121200251,40,128237.47),(202101,1121200251,41,89653.80),(202101,41056278,1,1081078.00),(202101,41056278,5,106454.00),(202101,41056278,14,43243.12),(202101,41056278,15,43243.12),(202101,41056278,16,91891.63),(202101,41056278,18,129729.36),(202101,41056278,21,43243.12),(202101,41056278,22,32432.34),(202101,41056278,23,21621.56),(202101,41056278,24,26335.06),(202101,41056278,25,94487.61),(202101,41056278,26,45048.52),(202101,41056278,27,94487.61),(202101,41056278,28,11343.05),(202101,41056278,40,128237.47),(202101,41056278,41,89653.80),(202101,1121197139,1,1317216.00),(202101,1121197139,5,106454.00),(202101,1121197139,14,52688.64),(202101,1121197139,15,52688.64),(202101,1121197139,16,111963.36),(202101,1121197139,18,158065.92),(202101,1121197139,21,52688.64),(202101,1121197139,22,39516.48),(202101,1121197139,23,26344.32),(202101,1121197139,24,32087.38),(202101,1121197139,25,114157.90),(202101,1121197139,26,54888.39),(202101,1121197139,27,114157.90),(202101,1121197139,28,13704.43),(202101,1121197139,40,156248.16),(202101,1121197139,41,109236.72);
/*!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 */;
INSERT INTO `detmovto` (`dmo_tipcom`, `dmo_numero`, `dmo_secuen`, `dmo_codcta`, `dmo_tercer`, `dmo_auxili`, `dmo_codtic`, `dmo_detall`, `dmo_cheque`, `dmo_codcen`, `dmo_tipmov`, `dmo_vlrmov`, `dmo_fecreg`, `dmo_codemp`) VALUES (111,210001,3,'24072213',1121205881,0,'FAC','Causacion: 210001','3149062.00',101011,2,7873.00,'2021-01-04','11212058'),(111,210001,2,'24905401',1121205881,0,'FAC','Causacion: 210001','3149062.00',101011,2,2700321.00,'2021-01-04','11212058'),(111,210001,1,'51080201',1121205881,0,'FAC','Causacion: 210001','',101011,1,3149062.00,'2021-01-04','11212058'),(111,210001,4,'24072202',1121205881,0,'FAC','Causacion: 210001','3149062.00',101011,2,125962.00,'2021-01-04','11212058'),(111,210001,5,'24072203',1121205881,0,'FAC','Causacion: 210001','3149062.00',101011,2,62981.00,'2021-01-04','11212058'),(111,210001,6,'24072212',1121205881,0,'FAC','Causacion: 210001','3149062.00',101011,2,251925.00,'2021-01-04','11212058'),(111,210002,1,'75010205',1121207115,0,'FAC','Causacion: 210002','',100000,1,1860808.00,'2021-01-08','11212058'),(111,210002,2,'24072212',1121207115,0,'FAC','Causacion: 210002','1860808.00',100000,2,14886.00,'2021-01-08','11212058'),(111,210002,3,'24905501',1121207115,0,'FAC','Causacion: 210002','1860808.00',100000,2,1729622.00,'2021-01-08','11212058'),(111,210002,4,'24072213',1121207115,0,'FAC','Causacion: 210002','1860808.00',100000,2,4652.00,'2021-01-08','11212058'),(111,210002,5,'24072202',1121207115,0,'FAC','Causacion: 210002','1860808.00',100000,2,74432.00,'2021-01-08','11212058'),(111,210002,6,'24072203',1121207115,0,'FAC','Causacion: 210002','1860808.00',100000,2,37216.00,'2021-01-08','11212058');
/*!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 */;
INSERT INTO `detpedcom` (`dpc_numero`, `dpc_codcon`, `dpc_cantid`, `dpc_vlruni`, `dpc_vlrtot`, `dpc_iva`, `observacion`) VALUES (210001,10168,2.00,10000.00,20000.00,0.00,'elementos de papeleria');
/*!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 */;
INSERT INTO `detregistro` (`dreg_numero`, `dreg_codcta`, `dreg_vlrtot`) VALUES (210001,'25100112020153',18894372.00),(210002,'25100112020253',11164848.00);
/*!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 */;
INSERT INTO `detregistroc` (`dreg_numero`, `dreg_codcta`, `dreg_codcen`, `dreg_vlrtot`) VALUES (210002,'25100112020253',100000,1860808.00),(210001,'25100112020153',101011,3149062.00);
/*!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 */;
INSERT INTO `detregistroct` (`dregt_numero`, `dregt_codcta`, `dregt_tipcta`) VALUES (210001,'25100112020153','1'),(210002,'25100112020253','1');
/*!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 */;
INSERT INTO `detregistrop` (`dregp_numero`, `dregp_codcta`, `dregp_vlrtot`, `dregp_pagado`) VALUES (210001,'25100112020153',3149062.00,0.00),(210002,'25100112020253',1860808.00,0.00);
/*!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 */;
INSERT INTO `dettraslado` (`dtra_numero`, `dtra_codcta`, `dtra_coddes`, `dtra_vlrtot`) VALUES (210001,'25100112020253','25100112020153',108000000.00),(210001,'25100112020453','25100112020153',21044000.00),(210001,'25100212070153','25100112020153',26998095.00);
/*!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 */;
INSERT INTO `disponibilidad` (`dis_numero`, `dis_codcli`, `dis_codres`, `dis_fecreg`, `dis_horreg`, `dis_estado`, `dis_tippag`, `dis_vlrtot`, `dis_regist`, `dis_girosp`, `dis_reinte`, `dis_saldod`, `dis_detalle`, `dis_feccre`, `dis_vlrfut`, `dis_ejefut`) VALUES (210001,0,'1121205881','2021-01-04','02:40:31','A','1',0.00,0.00,0.00,0.00,0.00,' ','2021-02-01',0.00,0.00),(210002,1121205881,'1121205881','2021-01-04','02:42:11','C','1',18894372.00,18894372.00,0.00,0.00,0.00,'  Prestación de servicios profesionales de contador publico para realizar la asesoría contable de la unidad de servicios públicos domiciliarios, según contrato de prestacion de servicios n° 020 del 2021','2021-02-01',0.00,0.00),(210003,1121207115,'1121205881','2021-01-04','09:53:22','C','1',11164848.00,11164848.00,0.00,0.00,0.00,' Prestación de servicios en técnico electromecánico para el mantenimiento y operación de las estaciones de bombeo de agua residuales de la USPDL','2021-02-02',0.00,0.00);
/*!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 */;
INSERT INTO `empleadonom` (`em_cedula`, `em_nombre`, `em_direcc`, `em_telefo`, `em_estciv`, `em_numhij`, `em_enteps`, `em_entarp`, `em_entpen`, `em_entcaj`, `em_ccosto`, `em_grupo`, `em_fecnac`, `em_fecing`, `em_salbas`, `em_estado`, `em_nivest`, `em_catlic`, `em_nrolic`, `em_tipcon`, `em_tipoem`, `em_riesgo`, `em_cargo`, `em_sexo`, `em_fecter`, `em_correo`, `em_nombres`, `em_apellidos`) VALUES (15887827,'FRANCISCO PERDOMO MORA','BARRIO SAN MIGUEL','311 4608051','U',0,800251440,860011153,900336004,800003122,0,201,'1962-01-21','2021-01-01',1966387.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(15876584,'MARTIN RODRIGUEZ BOLIVAR','Calle 14 No. 3A 43','320 3732138','U',0,837000084,860011153,800224808,800003122,0,201,'1978-11-30','2021-01-01',1966387.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(15886945,'JOSE CARMEN NOGUERA RODRIGUEZ','Calle 7 No. 5B','322 6093700','U',0,900156264,860011153,900336004,800003122,0,201,'1956-06-05','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(15876086,'MANUEL GONSALEZ RAMOS','Carrera 2 No. 2-01 Barrio Colombia','321 9185824','U',0,901037916,860011153,800224808,800003122,0,201,'1978-09-25','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(15877394,'COSMEN LIZ CARDOZO CATACHUNGA','Calle 6 No. 4-39 Barrio GaitAn','311 5127456','U',0,800251440,860011153,900336004,800003122,0,201,'1981-11-03','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(6565709,'JORGE ANTONIO MORALES CABRERA','Calle 12 No. 8-40','310 2104654','U',0,900156264,860011153,800224808,800003122,0,201,'1972-12-22','2021-01-01',1317216.00,'A','','','','F','1',4.35000,'20','M','0000-00-00','','',''),(15887089,'BENITO CAYETANO AHUE','KM 3 COMUNIDAD SAN SEBASTIAN','313 2820447','U',0,800251440,860011153,800224808,800003122,0,201,'1952-03-29','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(6566799,'LEODAN ESCOBERO PINTO','VIA LOS LAGOS','314 4126120','U',0,800251440,860011153,800224808,800003122,0,201,'1975-05-12','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(15876459,'CLAUDIO FELIPE FERNANDEZ','KM 3 COMUNIDAD SAN SEBASTIAN','312 4977325','U',0,800251440,860011153,800224808,800003122,0,201,'1978-10-15','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(15889590,'EMILIO CHU?A HUANIRI','URBANIZACION ?IA NEE MECHI','312 3424849','U',0,800251440,860011153,800224808,800003122,0,201,'1970-01-01','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(15889012,'ERLINTO IPUCHIMA AHUANARI','Calle 18 No. 7-05','311 8449019','U',0,900156264,860011153,800224808,800003122,0,202,'1968-06-23','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(15887593,'ERNESTO FLOREZ TORRES','Carrera 8 No. 5-55','314 2202144/','U',0,900156264,860011153,900336004,800003122,0,202,'1962-11-08','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(1121200881,'ALEJANDRO RODRIGUEZ TECHEIRA','Carrera 3 No. 1-36 Barrio Colombia','321 2550791/','U',0,800251440,860011153,900336004,800003122,0,202,'1988-06-10','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(1121209707,'JOSE LUIS CASTRO IPUCHIMA','Calle 6 No. 7A-46 Barrio Porvenir','314 2001173','U',0,800251440,860011153,900336004,800003122,0,202,'1993-04-20','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(15888658,'LUIS CASTRO MURRIETA','Calle 6 No. 7A-46 Barrio Porvenir','314 4418376','U',0,800251440,860011153,900336004,800003122,0,202,'1960-01-04','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(18070075,'ELOY FLOREZ VASQUEZ','VIa los lagos - San SebastiAn','322 9365870','U',0,800251440,860011153,900336004,800003122,0,202,'1967-08-26','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(15879542,'MARCO JACKSON PARENTE ROMAN','CASTA?AL LOS LAGOS','','U',0,900156264,860011153,900336004,800003122,0,202,'1985-02-15','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(15879400,'JOHN FREY PARRA GALDINO','Comunidad San JosE Km 6','321 2017953','U',0,900156264,860011153,800224808,800003122,0,202,'1984-07-18','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(1121202335,'JUAN ANTONIO SILVA LEON','Carrera 7 No. 11-25','320 8989268','U',0,900156264,860011153,900336004,800003122,0,202,'1988-12-20','2021-01-08',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(15323907,'FABIAN HUMBERTO MESA PINO','Carrera 6 No. 13-84 B. JosE MarIa HernAndez','311 2735046/','U',0,900156264,860011153,800224808,800003122,0,203,'1967-04-07','2021-01-01',2242482.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(12230636,'GERMAN MOLINA HERRERA','Carrera 8 No. 7 - 46','310 7787504','U',0,800251440,860011153,900336004,800003122,0,203,'1964-10-20','2021-01-01',1966387.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(6566664,'JUAN GABRIEL GARCIA DE SOUZA','Calle 6 No. 7-18 B. Porvenir','320 8783971','U',0,800251440,860011153,800224808,800003122,0,203,'1973-01-24','2021-01-01',1545738.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(6566670,'PABLO SANTOS PINTO','Comunidad San SebastiAn','322 7436189','U',0,900156264,860011153,800224808,800003122,0,203,'1971-12-05','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(1122267585,'JERSON PABLO CASTILLO MACEDO','Calle 2 No. 9 - 43 Barrio Casta?al Porvenir','311 2964320','U',0,900156264,860011153,800224808,800003122,0,203,'1987-12-22','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(6566915,'ALBERTO GREFA DIAZ','Calle 11 con Cra 11','311 8029109','U',0,900156264,860011153,800224808,800003122,0,203,'1974-05-30','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(6567094,'MIGUEL ANGEL SUAREZ CARBAHIO','Calle 4 No. 2-20','314 4824035','U',0,900156264,860011153,900336004,800003122,0,203,'1975-04-10','2021-01-07',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(15889146,'CAMILO FARES LOZADA SINARAGUA','Carrera 7 No. 8-31','','U',0,900156264,860011153,900336004,800003122,0,203,'1967-12-18','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(6565822,'RUITER SANGAMA RAMOS','Calle 10 No. 11-132 B. Victoria Regia','314 4049442','U',0,800251440,860011153,900336004,800003122,0,201,'1973-05-06','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(15888856,'LUIS EDUARDO RENDON CASTRO','San SebastiAn Los Lagos','321 4068278','U',0,837000084,860011153,900336004,800003122,0,203,'1963-12-25','2021-01-01',1966387.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(40179500,'YANETH FERNANDEZ SUAREZ','Calle 3 No. 9A - 05','314 4290020','U',0,837000084,860011153,800224808,800003122,0,203,'1970-12-21','2021-01-01',1081078.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(26636785,'ADOLFINA CANDRE GEIKONO','Carrera 3 No. 10-26 BARRIO TAUCHI - INEM','322 3829658','U',0,900156264,860011153,900336004,800003122,0,203,'1964-09-01','2021-01-01',1081078.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(35522746,'MIREYA PUA FERREIRA','Calle 5 No. 7A-56 Barrio Porvenir','312 3222947','U',0,800251440,860011153,800224808,800003122,0,203,'1968-09-22','2021-01-01',1081078.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(40179489,'LOURDES MERCEDES CAUPER BARDALES','Comunidad La Playa','321 9199472','U',0,837000084,860011153,800224808,800003122,0,203,'1970-08-24','2021-01-01',1081078.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(41057122,'MARIA PATRICIA GALINDO MANUYAMA','Cra 12 No. 10-40 Barrio Victoria Regia','320 4259476','U',0,900156264,860011153,800224808,800003122,0,203,'1976-01-12','2021-01-05',1081078.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(41061456,'ANA CRISTINA DIAZ PINTO','Los Lagos Casta?al 2','318 6116449','U',0,837000084,860011153,900336004,800003122,0,203,'1973-03-24','2021-01-01',1081078.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(41055613,'MARIA LUZ CABRERA RODRIGUEZ','Calle 13 No. 8-21 Barrio JosE MarIa HernAndez','317 8351620','U',0,837000084,860011153,800224808,800003122,0,203,'1974-07-01','2021-01-01',1081078.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(41057835,'MARIEN YAMILE RAMOS VIRTO','Cra 12 No. 4A-46 Barrio El Aguila','312 4458892','U',0,900156264,860011153,800224808,800003122,0,203,'1978-09-10','2021-01-05',1081078.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(1121200251,'LEIDY YOHANA RIASCOS DEVIA','Carrera 7 No. 5 - 45 B. El Porvenir','313 2960855','U',0,900156264,860011153,800224808,800003122,0,203,'1987-04-22','2021-01-08',1081078.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(41056278,'LUCILA LONDO?O ARIRAMA','Calle 11 No. 11-92 Barrio Victoria Regia','322 4066235','U',0,900156264,860011153,900336004,800003122,0,203,'1974-01-18','2021-01-12',1081078.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(1121197139,'NELSON ENRIQUE VARGAS PINTO','UrbanizaciOn ?ia Nee Mechi','322 2508700/','U',0,900156264,860011153,800224808,800003122,0,203,'1985-01-24','2021-01-05',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','','');
/*!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 */;
INSERT INTO `empleadonom_liq` (`em_periodo`, `em_cedula`, `em_nombre`, `em_direcc`, `em_telefo`, `em_estciv`, `em_numhij`, `em_enteps`, `em_entarp`, `em_entpen`, `em_entcaj`, `em_ccosto`, `em_grupo`, `em_fecnac`, `em_fecing`, `em_salbas`, `em_estado`, `em_nivest`, `em_catlic`, `em_nrolic`, `em_tipcon`, `em_tipoem`, `em_riesgo`, `em_cargo`, `em_sexo`, `em_fecter`, `em_correo`, `em_nombres`, `em_apellidos`) VALUES (202101,41061456,'ANA CRISTINA DIAZ PINTO','Los Lagos Casta?al 2','318 6116449','U',0,837000084,860011153,900336004,800003122,0,203,'1973-03-24','2021-01-01',1081078.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,41057122,'MARIA PATRICIA GALINDO MANUYAMA','Cra 12 No. 10-40 Barrio Victoria Regia','320 4259476','U',0,900156264,860011153,800224808,800003122,0,203,'1976-01-12','2021-01-05',1081078.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,40179489,'LOURDES MERCEDES CAUPER BARDALES','Comunidad La Playa','321 9199472','U',0,837000084,860011153,800224808,800003122,0,203,'1970-08-24','2021-01-01',1081078.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,35522746,'MIREYA PUA FERREIRA','Calle 5 No. 7A-56 Barrio Porvenir','312 3222947','U',0,800251440,860011153,800224808,800003122,0,203,'1968-09-22','2021-01-01',1081078.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,26636785,'ADOLFINA CANDRE GEIKONO','Carrera 3 No. 10-26 BARRIO TAUCHI - INEM','322 3829658','U',0,900156264,860011153,900336004,800003122,0,203,'1964-09-01','2021-01-01',1081078.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,40179500,'YANETH FERNANDEZ SUAREZ','Calle 3 No. 9A - 05','314 4290020','U',0,837000084,860011153,800224808,800003122,0,203,'1970-12-21','2021-01-01',1081078.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,15888856,'LUIS EDUARDO RENDON CASTRO','San SebastiAn Los Lagos','321 4068278','U',0,837000084,860011153,900336004,800003122,0,203,'1963-12-25','2021-01-01',1966387.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,6565822,'RUITER SANGAMA RAMOS','Calle 10 No. 11-132 B. Victoria Regia','314 4049442','U',0,800251440,860011153,900336004,800003122,0,201,'1973-05-06','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,15889146,'CAMILO FARES LOZADA SINARAGUA','Carrera 7 No. 8-31','','U',0,900156264,860011153,900336004,800003122,0,203,'1967-12-18','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,6567094,'MIGUEL ANGEL SUAREZ CARBAHIO','Calle 4 No. 2-20','314 4824035','U',0,900156264,860011153,900336004,800003122,0,203,'1975-04-10','2021-01-07',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,6566915,'ALBERTO GREFA DIAZ','Calle 11 con Cra 11','311 8029109','U',0,900156264,860011153,800224808,800003122,0,203,'1974-05-30','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,1122267585,'JERSON PABLO CASTILLO MACEDO','Calle 2 No. 9 - 43 Barrio Casta?al Porvenir','311 2964320','U',0,900156264,860011153,800224808,800003122,0,203,'1987-12-22','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,6566670,'PABLO SANTOS PINTO','Comunidad San SebastiAn','322 7436189','U',0,900156264,860011153,800224808,800003122,0,203,'1971-12-05','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,6566664,'JUAN GABRIEL GARCIA DE SOUZA','Calle 6 No. 7-18 B. Porvenir','320 8783971','U',0,800251440,860011153,800224808,800003122,0,203,'1973-01-24','2021-01-01',1545738.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,12230636,'GERMAN MOLINA HERRERA','Carrera 8 No. 7 - 46','310 7787504','U',0,800251440,860011153,900336004,800003122,0,203,'1964-10-20','2021-01-01',1966387.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,15323907,'FABIAN HUMBERTO MESA PINO','Carrera 6 No. 13-84 B. JosE MarIa HernAndez','311 2735046/','U',0,900156264,860011153,800224808,800003122,0,203,'1967-04-07','2021-01-01',2242482.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,1121202335,'JUAN ANTONIO SILVA LEON','Carrera 7 No. 11-25','320 8989268','U',0,900156264,860011153,900336004,800003122,0,202,'1988-12-20','2021-01-08',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,15879400,'JOHN FREY PARRA GALDINO','Comunidad San JosE Km 6','321 2017953','U',0,900156264,860011153,800224808,800003122,0,202,'1984-07-18','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,15879542,'MARCO JACKSON PARENTE ROMAN','CASTA?AL LOS LAGOS','','U',0,900156264,860011153,900336004,800003122,0,202,'1985-02-15','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,18070075,'ELOY FLOREZ VASQUEZ','VIa los lagos - San SebastiAn','322 9365870','U',0,800251440,860011153,900336004,800003122,0,202,'1967-08-26','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,15888658,'LUIS CASTRO MURRIETA','Calle 6 No. 7A-46 Barrio Porvenir','314 4418376','U',0,800251440,860011153,900336004,800003122,0,202,'1960-01-04','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,1121209707,'JOSE LUIS CASTRO IPUCHIMA','Calle 6 No. 7A-46 Barrio Porvenir','314 2001173','U',0,800251440,860011153,900336004,800003122,0,202,'1993-04-20','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,1121200881,'ALEJANDRO RODRIGUEZ TECHEIRA','Carrera 3 No. 1-36 Barrio Colombia','321 2550791/','U',0,800251440,860011153,900336004,800003122,0,202,'1988-06-10','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,15887593,'ERNESTO FLOREZ TORRES','Carrera 8 No. 5-55','314 2202144/','U',0,900156264,860011153,900336004,800003122,0,202,'1962-11-08','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,15889012,'ERLINTO IPUCHIMA AHUANARI','Calle 18 No. 7-05','311 8449019','U',0,900156264,860011153,800224808,800003122,0,202,'1968-06-23','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,15889590,'EMILIO CHU?A HUANIRI','URBANIZACION ?IA NEE MECHI','312 3424849','U',0,800251440,860011153,800224808,800003122,0,201,'1970-01-01','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,15876459,'CLAUDIO FELIPE FERNANDEZ','KM 3 COMUNIDAD SAN SEBASTIAN','312 4977325','U',0,800251440,860011153,800224808,800003122,0,201,'1978-10-15','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,6566799,'LEODAN ESCOBERO PINTO','VIA LOS LAGOS','314 4126120','U',0,800251440,860011153,800224808,800003122,0,201,'1975-05-12','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,15887089,'BENITO CAYETANO AHUE','KM 3 COMUNIDAD SAN SEBASTIAN','313 2820447','U',0,800251440,860011153,800224808,800003122,0,201,'1952-03-29','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,6565709,'JORGE ANTONIO MORALES CABRERA','Calle 12 No. 8-40','310 2104654','U',0,900156264,860011153,800224808,800003122,0,201,'1972-12-22','2021-01-01',1317216.00,'A','','','','F','1',4.00000,'20','F','0000-00-00','','',''),(202101,15877394,'COSMEN LIZ CARDOZO CATACHUNGA','Calle 6 No. 4-39 Barrio GaitAn','311 5127456','U',0,800251440,860011153,900336004,800003122,0,201,'1981-11-03','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,15876086,'MANUEL GONSALEZ RAMOS','Carrera 2 No. 2-01 Barrio Colombia','321 9185824','U',0,901037916,860011153,800224808,800003122,0,201,'1978-09-25','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,15886945,'JOSE CARMEN NOGUERA RODRIGUEZ','Calle 7 No. 5B','322 6093700','U',0,900156264,860011153,900336004,800003122,0,201,'1956-06-05','2021-01-01',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,15876584,'MARTIN RODRIGUEZ BOLIVAR','Calle 14 No. 3A 43','320 3732138','U',0,837000084,860011153,800224808,800003122,0,201,'1978-11-30','2021-01-01',1966387.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,15887827,'FRANCISCO PERDOMO MORA','BARRIO SAN MIGUEL','311 4608051','U',0,800251440,860011153,900336004,800003122,0,201,'1962-01-21','2021-01-01',1966387.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,41055613,'MARIA LUZ CABRERA RODRIGUEZ','Calle 13 No. 8-21 Barrio JosE MarIa HernAndez','317 8351620','U',0,837000084,860011153,800224808,800003122,0,203,'1974-07-01','2021-01-01',1081078.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,41057835,'MARIEN YAMILE RAMOS VIRTO','Cra 12 No. 4A-46 Barrio El Aguila','312 4458892','U',0,900156264,860011153,800224808,800003122,0,203,'1978-09-10','2021-01-05',1081078.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,1121200251,'LEIDY YOHANA RIASCOS DEVIA','Carrera 7 No. 5 - 45 B. El Porvenir','313 2960855','U',0,900156264,860011153,800224808,800003122,0,203,'1987-04-22','2021-01-08',1081078.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,41056278,'LUCILA LONDO?O ARIRAMA','Calle 11 No. 11-92 Barrio Victoria Regia','322 4066235','U',0,900156264,860011153,900336004,800003122,0,203,'1974-01-18','2021-01-12',1081078.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','',''),(202101,1121197139,'NELSON ENRIQUE VARGAS PINTO','UrbanizaciOn ?ia Nee Mechi','322 2508700/','U',0,900156264,860011153,800224808,800003122,0,203,'1985-01-24','2021-01-05',1317216.00,'A','','','','F','5',2.43600,'1','F','0000-00-00','','','');
/*!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 ('899999302-9','UNIDAD DE SERVICIOS PUBLICOS DE LETICIA','Cl. 10 ##10-47','5928064','','');
/*!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'),(837000084,'MALLAMAS','',''),(901037916,'ADRES','',''),(800003122,'CAFAMAZ','','');
/*!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 */;
INSERT INTO `horasnom_liq` (`ho_periodo`, `ho_cedula`, `ho_codcon`, `ho_cantidad`, `ho_fecreg`, `ho_usuari`, `ho_fecini`, `ho_fecfin`, `ho_observa`) VALUES (202101,41057122,1,26.00,'2021-02-18','1121205881','2021-01-05','2021-01-30','Ingreso'),(202101,41057122,14,26.00,'2021-02-18','1121205881','2021-01-05','2021-01-30','Ingreso');
/*!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 */;
INSERT INTO `liquinom_liq` (`lq_periodo`, `lq_cedula`, `lq_apagar`, `lq_deduci`, `lq_deveng`, `lq_numdia`, `lq_numsus`, `lq_fecini`, `lq_fecfin`, `lq_fecreg`, `lq_usuari`, `lq_horreg`) VALUES (202101,41061456,1101045.76,86486,1187532,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:45'),(202101,41057122,954239.66,74955,1029194,26,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:45'),(202101,40179489,1101045.76,86486,1187532,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:45'),(202101,35522746,1101045.76,86486,1187532,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:45'),(202101,26636785,1101045.76,86486,1187532,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:45'),(202101,40179500,1101045.76,86486,1187532,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:45'),(202101,15888856,1809076.04,157311,1966387,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:45'),(202101,6565822,1238234.72,185435,1423670,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:45'),(202101,15889146,1318292.72,105377,1423670,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:45'),(202101,6567094,1318292.72,105377,1423670,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:45'),(202101,6566915,1318292.72,105377,1423670,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:45'),(202101,1122267585,1318292.72,105377,1423670,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:46'),(202101,6566670,1318292.72,105377,1423670,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:46'),(202101,6566664,1528532.96,123659,1652192,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:46'),(202101,12230636,1809076.04,157311,1966387,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:46'),(202101,15323907,2063083.44,179399,2242482,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:46'),(202101,1121202335,1318292.72,105377,1423670,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:46'),(202101,15879400,1318292.72,105377,1423670,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:46'),(202101,15879542,1318292.72,105377,1423670,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:46'),(202101,18070075,1318292.72,105377,1423670,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:46'),(202101,15888658,1318292.72,105377,1423670,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:46'),(202101,1121209707,1318292.72,105377,1423670,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:46'),(202101,1121200881,1318292.72,105377,1423670,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:46'),(202101,15887593,1318292.72,105377,1423670,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:46'),(202101,15889012,1318292.72,105377,1423670,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:46'),(202101,15889590,1318292.72,105377,1423670,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:46'),(202101,15876459,1318292.72,105377,1423670,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:46'),(202101,6566799,1318292.72,105377,1423670,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:46'),(202101,15887089,1318292.72,105377,1423670,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:46'),(202101,6565709,1318292.72,105377,1423670,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:46'),(202101,15877394,1318292.72,105377,1423670,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:47'),(202101,15876086,1318292.72,105377,1423670,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:47'),(202101,15886945,1318292.72,105377,1423670,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:47'),(202101,15876584,1809076.04,157311,1966387,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:47'),(202101,15887827,1597704.04,368683,1966387,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:47'),(202101,41055613,1101045.76,86486,1187532,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:47'),(202101,41057835,1101045.76,86486,1187532,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:47'),(202101,1121200251,1101045.76,86486,1187532,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:47'),(202101,41056278,1101045.76,86486,1187532,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:47'),(202101,1121197139,1318292.72,105377,1423670,30,0,'2021-01-01','2021-01-30','2021-02-18','1121205881','10:12:47');
/*!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 */;
INSERT INTO `movto` (`mo_tipcom`, `mo_numero`, `mo_fecreg`, `mo_horreg`, `mo_codcli`, `mo_factur`, `mo_estado`, `mo_detalle`, `mo_fecing`, `mo_horing`, `mo_codemp`) VALUES (111,210001,'2021-01-04','02:54:33',1121205881,0,'C','Prestación de servicios profesionales de contador publico para realizar la asesoría contable de la unidad de servicios públicos domiciliarios, según contrato de prestacion de servicios n° 020 del 2021','2021-02-02','09:41:44','11212058'),(111,210002,'2021-01-08','10:25:41',1121207115,0,'C','  Prestación de servicios en técnico electromecánico para el mantenimiento y operación de las estaciones de bombeo de agua residuales de la USPDL','2021-02-02','10:34:02','11212058'),(118,210001,'2021-02-18','10:24:11',800082204,202101,'C','Contabilizacion Nomina del 202101','2021-02-18','10:24:11','asexis');
/*!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 */;
INSERT INTO `pedcom` (`pec_numero`, `pec_mesa`, `pec_observ`) VALUES (210001,1000,'1000');
/*!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 */;
INSERT INTO `pedidosal` (`pes_numero`, `pes_observ`, `pes_codcli`, `descripcion`, `pes_fecha`, `causado`, `anulado`, `observacion`) VALUES (210001,'1000','1000','','2021-05-06',0,0,''),(210002,'1000','1003','','2021-05-06',0,0,'');
/*!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 */;
/*!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 */;
INSERT INTO `registro` (`reg_numero`, `reg_codcli`, `reg_codres`, `reg_fecreg`, `reg_horreg`, `reg_estado`, `reg_tippag`, `reg_dispon`, `reg_vlrtot`, `reg_detalle`, `reg_feccre`, `reg_cretencion`, `reg_creteica`, `reg_retencion`, `reg_reteica`, `reg_vlrgir`, `reg_proyecto`, `reg_auxiliar`, `reg_codsec`, `reg_codare`, `reg_nrofac`) VALUES (210001,1121205881,'1121205881','2021-01-04','02:48:11','C','1',210002,18894372.00,' Prestación de servicios profesionales de contador publico para realizar la asesoría contable de la unidad de servicios públicos domiciliarios, según contrato de prestación de servicios N° 020 del 2021','2021-02-01','','',0.00,0.00,18894372.00,0,0,0,0,''),(210002,1121207115,'1121205881','2021-01-04','10:10:42','C','1',210003,11164848.00,' Prestación de servicios en técnico electromecánico para el mantenimiento y operación de las estaciones de bombeo de agua residuales de la USPDL','2021-02-02','NA','NA',0.00,0.00,11164848.00,0,0,16,1,'');
/*!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 */;
INSERT INTO `registrop` (`regp_numero`, `regp_codcli`, `regp_codres`, `regp_fecreg`, `regp_horreg`, `regp_estado`, `regp_tippag`, `regp_dispon`, `regp_vlrtot`, `regp_detalle`, `regp_feccre`, `regp_cretencion`, `regp_creteica`, `regp_retencion`, `regp_reteica`, `regp_vlriva`, `regp_vlrgir`, `regp_proyecto`, `regp_auxiliar`, `regp_codsec`, `regp_codare`, `regp_nrofac`, `regp_nroreg`, `regp_nroord`, `regp_soporte`, `regp_tipcon`, `regp_forpag`, `regp_creteiva`, `regp_cbomberil`, `regp_iva`, `regp_dias`, `regp_reteiva`, `regp_bomberil`, `regp_tipact`, `regp_contrato_vigencia`, `regp_contrato_numero`, `regp_origen`, `regp_guerra`, `regp_vguerra`, `regp_imp_cree`, `regp_vimp_cree`, `regp_ent_inv`, `regp_ent_inv_num`, `regp_base`, `regp_tipo_contrato`, `regp_otros1`, `regp_votros1`, `regp_otros2`, `regp_votros2`, `regp_otros3`, `regp_votros3`) VALUES (210001,1121205881,'1121205881','2021-01-04','02:54:33','C','1',210002,3149062.00,'Prestación de servicios profesionales de contador publico para realizar la asesoría contable de la unidad de servicios públicos domiciliarios, según contrato de prestacion de servicios n° 020 del 2021','2021-02-01','NA','',0.00,0.00,0.00,2700321.00,0,0,0,0,'',210001,0,0,'Servicios',0,'NA','NA',0.00,0,0.00,0.00,'0','2021','020','','CONTDEP',7873.00,'CONTEDAD',125962.00,0,'',3149062.00,0,'CONTCUL',62981.00,'RETEICA',251925.00,'',0.00),(210002,1121207115,'1121205881','2021-01-08','10:25:41','C','1',210003,1860808.00,'  Prestación de servicios en técnico electromecánico para el mantenimiento y operación de las estaciones de bombeo de agua residuales de la USPDL','2021-02-02','','RETEICA',0.00,14886.00,0.00,1729622.00,0,0,16,1,'',210002,0,0,'Servicios',0,'','',0.00,0,0.00,0.00,'','2021','024','','CONTDEP',4652.00,'CONTEDAD',74432.00,0,'',1860808.00,0,'CONTCUL',37216.00,'',0.00,'',0.00);
/*!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','UNIDAD DE SERVICIOS PUBLICOS DE LETICIA','GENERAL'),('1121205881','LIZETH CHRISTINA SILVA SALAZAR','CONTABLE');
/*!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 */;
/*!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 ('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)','24360502',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','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)','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','24360503',2.00,0.00,0.00),('CONTEDAD','Contribucion Tercera Edad','24072202',4.00,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),('CONTCUL','Contribucion Cultura','24072203',2.00,0.00,0.00),('RETEICA07','Reteica Cemento,Manofacturas, Aserradero y Metales','24370101',7.00,0.00,0.00),('RETEICA05','Reteica Compras en Gral','24362703',5.00,0.00,0.00),('RETEICA10','Reteica Cigarrillo, Combustible','24370101',10.00,0.00,0.00),('EPDEPARTA','Estampilla Pro desarrollo departamental','2905020101',2.00,0.00,0.00),('EPFRONT01','Pro fronterizo 0.5%','29050201',0.50,7377170.00,0.00),('EPFRONT02','Pro fronterizo 1%','29050201',1.00,73771700.00,0.00),('EPFRONT03','Pro fronterizo 1.5%','29050201',1.50,99999999.99,0.00),('CEOBRAS','Contribucion Especial Obras Publicas','2905020203',5.00,0.00,0.00),('RETE029','Industria y Comercio','24400401',0.80,0.00,0.00),('24408001','EP PRO UNIVERSIDAD DE LE GUAJIRA','24408001',2.00,0.00,0.00),('RETE026','Servicio de Licenciamineto o Uso de Software','24360305',3.50,0.00,0.00),('CONTDEP','Contribucion Deporte','24072213',2.50,0.00,0.00),('CONTSEGC','Contribucion Seguridad Ciudadana','24079001',5.00,0.00,0.00),('RETEICA06','Reteica x Servicios en Gral','24362701',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),('RETEICA','Reteica 8x1000','24072212',8.00,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'),(201,'DEPARTAMENTO OPERATIVO'),(202,'JEFE DE OPERARIOS'),(3333,'REDES DE DISTRIBUCION'),(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',210003),('G','Registros Presupuestales',210002),('GP','Giro Presupuestal',210000),('CS','Consignaciones',210000),('PE','Pedidos Entradas',210001),('OR','Ordenes de Compra',210000),('PS','Pedidos Salidas',210002),('A','Adiciones Presupuestales',210000),('DP','Disminucion Presupuestal',210000),('TP','Traslado Presupuestal',210001),('OP','Orden de pago',210002),('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 */;
INSERT INTO `terceros` (`te_codcli`, `te_nombre`, `te_direcc`, `te_telefo`, `te_porcen`, `te_nombr1`, `te_nombr2`, `te_apell1`, `te_apell2`, `te_codact`, `te_codciu`, `te_tipo`, `te_tipter`, `te_tipdoc`, `te_autore`, `te_gran`, `te_ent_publica`, `te_regimen`, `te_estado`, `te_correo`) VALUES (901359132,'CONSORCIO MONITOREO LETICIA 2020','','',0,'','','','',0,91001,'J','E','N','N','N','N','N','A',''),(900204777,'INVERSIONES DUCAR SAS','','',0,'','','','',0,91001,'J','E','N','N','N','N','N','A',''),(800252844,'CORPOAMAZONIA','','',0,'','','','',0,91001,'J','E','N','N','N','N','N','A',''),(900956057,'SOLUCIONES EN SERVICIOS PUBLICOS ESPECIALIZADOS','','',0,'','','','',0,91001,'J','E','N','N','N','N','N','A',''),(830018438,'GEOSIGMA LTDA','','',0,'','','','',0,91001,'J','E','N','N','N','N','N','A',''),(900073874,'COMPANIA AMAZONICA DE SERVICIOS CAS SAS','','',0,'','','','',0,91001,'J','E','N','N','N','N','N','A',''),(900692604,'AAA MAQUINARIAS Y MATERIALES SAS','','',0,'','','','',0,91001,'J','E','N','N','N','N','N','A',''),(901014148,'INVERSIONES JYV SAS','','',0,'','','','',0,91001,'J','E','N','N','N','N','N','A',''),(15877822,'SEGUNDO HIPOLITO ARCENTALES VARGAS','','',0,'','','','',0,91001,'J','E','N','N','N','N','N','A',''),(900615414,'TALLER DE VIDRIOS DEL AMAZONAS','','',0,'','','','',0,91001,'J','E','N','N','N','N','N','A',''),(900880860,'INVERSIONES JUNIN DEL AMAZONAS SAS','','',0,'','','','',0,91001,'J','E','N','N','N','N','N','A',''),(1018420094,'GERMAN ANDR?S / VEGA ROJAS','Calle 3 No. 9B Peatonal Piso 2 Barrio Porvenir','315 5776484',0,'','','','',0,91001,'J','E','N','N','N','N','N','A',''),(6566429,'JAIRO HERNANDO / ORDO?EZ YATES','Calle 1E No. 14A-36','322 8363777',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(1121218688,'ARMANDO JAVIER VENANCINO SANDI','','318 5776163',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(1121213973,'YAN MARCO BLANCO AYALA','Calle 14 No. 9-30 B. Jos? Mar?a Hern?ndez','310 8631908',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(1006733519,'JUAN PABLO CHAVEZ SANDOVAL','Carrera 3 este No. 14A 37 B. Humarizal','311 8505857',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(1121221395,'CAMILA ALEJANDRA PULIDO LONDO?O','Calle 3 No. 3-21 B. Porvenir','320 8675387',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(1116266313,'GINA LUCIA BLANDON OSORIO','Calle 11 8-60','317 3014923',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(1121205875,'JORGE FERNANDO MORENO BARBOSA','Calle 14 No. 8-42','317 3659275',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(98764566,'MANUEL ALBEIRO ZULUAGA GARC?A','Carrera 7 6 - 46 Punta Brava','318 8759019',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(15887597,'MIGUEL ANGEL/PINTO ESCOBEDO','KM 3.5 URBANIZACION ?IA NEE MECHI CASA 20 MZ C','320 9840282',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(15878714,'TULIO SANGAMA SALDA?A','SAN SEBASTIAN LOS LAGOS','315 6192757',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(1121221111,'BEYSON EDUAR ALEJANDRO ARIRAMA','KM 5 COMUNIDAD SAN JOS','320 3548491',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(1123690099,'CARLOS RICOPA COQUINCHE','KM 3 VIA SAN MIGUEL','310 8821953',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(4590973,'JOSE RAMON/AGUDELO AGUDELO','KM 18 VIA LETICIA - TARAPAC?','311 4988768',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(1121204062,'CARLOS/TANGARIFE GUAYAMBA','KM 18 VIA LETICIA - TARAPAC?','313 3651994',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(15875528,'ROBER/PACAYA TAPAYURI','KM 18 VIA LETICIA - TARAPAC?','',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(93373679,'LUIS ENRIQUE / RIVAS NI?O','CALLE 5 A 7-32 BARRIO PORVENIR','314 5255778',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(41057557,'PAULA ANDREA / VEGA FERREIRA','Carrera 3 3-05 B. Colombia','317 5014319',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(1121197955,'YENY LENY / VARGAS COSTA','Calle 4 No. 4A-05','320 3260616',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(1127793704,'ANDRES IGNACIO / ACOSTA URREGO','Carrera 9 No. 12-33','313 6784236',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(1121211623,'MYRIAN JULLIET PIMENTEL VALVERDE','Calle 9B No. 3A-07 B. Tauchi','320 4798628',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(1006784008,'CHARLY HANS QUEIJA PINTO','Calle 12 3A 48 B. San Mart',' 320 8865955',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(52787537,'ANGELA PATRICIA / CRUZ RODRIGUEZ','Transversal 16 No. 1 E 15 Barrio Costa Rica','320 4135053',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(41060619,'ERIKA VANESSA CHARPENTIER','Calle 7 No. 4 - 06 Barrio Once de Noviembre','311 5677898',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(1121197139,'NELSON ENRIQUE VARGAS PINTO','Urbanizaci?n ?ia Nee Mechi','322 2508700/',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(41056278,'LUCILA LONDO?O ARIRAMA','Calle 11 No. 11-92 Barrio Victoria Regia','322 4066235',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(1121200251,'LEIDY YOHANA RIASCOS DEVIA','Carrera 7 No. 5 - 45 B. El Porvenir','313 2960855',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(41057835,'MARIEN YAMILE RAMOS VIRTO','Cra 12 No. 4A-46 Barrio El Aguila','312 4458892',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(41055613,'MARIA LUZ CABRERA RODRIGUEZ','Calle 13 No. 8-21 Barrio Jos? Mar?a Hern?ndez','317 8351620',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(41061456,'ANA CRISTINA DIAZ PINTO','Los Lagos Casta?al 2','318 6116449',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(41057122,'MARIA PATRICIA GALINDO MANUYAMA','Cra 12 No. 10-40 Barrio Victoria Regia','320 4259476',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(40179489,'LOURDES MERCEDES CAUPER BARDALES','Comunidad La Playa','321 9199472',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(35522746,'MIREYA PUA FERREIRA','Calle 5 No. 7A-56 Barrio Porvenir','312 3222947',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(26636785,'ADOLFINA CANDRE GEIKONO','Carrera 3 No. 10-26 BARRIO TAUCHI - INEM','322 3829658',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(40179500,'YANETH FERNANDEZ SUAREZ','Calle 3 No. 9A - 05','314 4290020',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(15888856,'LUIS EDUARDO RENDON CASTRO','San Sebasti?n Los Lagos','321 4068278',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(6565822,'RUITER SANGAMA RAMOS','Calle 10 No. 11-132 B. Victoria Regia','314 4049442',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(15889146,'CAMILO FARES LOZADA SINARAGUA','Carrera 7 No. 8-31','',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(6567094,'MIGUEL ANGEL SUAREZ CARBAHIO','Calle 4 No. 2-20','314 4824035',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(6566915,'ALBERTO GREFA D?AZ','Calle 11 con Cra 11','311 8029109',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(1122267585,'JERSON PABLO CASTILLO MACEDO','Calle 2 No. 9 - 43 Barrio Casta?al Porvenir','311 2964320',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(6566670,'PABLO SANTOS PINTO','Comunidad San Sebasti','322 7436189',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(6566664,'JUAN GABRIEL GARCIA DE SOUZA','Calle 6 No. 7-18 B. Porvenir','320 8783971',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(12230636,'GERMAN MOLINA HERRERA','Carrera 8 No. 7 - 46','310 7787504',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(15323907,'FABIAN HUMBERTO MESA PINO','Carrera 6 No. 13-84 B. Jos? Mar?a Hern?ndez','311 2735046/',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(1121202335,'JUAN ANTONIO SILVA LE?N','Carrera 7 No. 11-25','320 8989268',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(15879400,'JOHN FREY PARRA GALDINO','Comunidad San Jos? Km 6','321 2017953',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(15879542,'MARCO JACKSON PARENTE ROMAN','CASTA?AL LOS LAGOS','',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(18070075,'ELOY FLOREZ VASQUEZ','V?a los lagos - San Sebasti','322 9365870',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(15888658,'LUIS CASTRO MURRIETA','Calle 6 No. 7A-46 Barrio Porvenir','314 4418376',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(1121209707,'JOSE LUIS CASTRO IPUCHIMA','Calle 6 No. 7A-46 Barrio Porvenir','314 2001173',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(1121200881,'ALEJANDRO RODRIGUEZ TECHEIRA','Carrera 3 No. 1-36 Barrio Colombia','321 2550791/',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(15887593,'ERNESTO FLOREZ TORRES','Carrera 8 No. 5-55','314 2202144/',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(15889012,'ERLINTO IPUCHIMA AHUANARI','Calle 18 No. 7-05','311 8449019',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(15889590,'EMILIO CHU?A HUANIRI','URBANIZACI?N ?IA NEE MECHI','312 3424849',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(15876459,'CLAUDIO FELIPE FERNANDEZ','KM 3 COMUNIDAD SAN SEBASTI?N','312 4977325',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(6566799,'LEODAN ESCOBERO PINTO','VIA LOS LAGOS','314 4126120',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(0,'No Aplica','','',0,'','','','',0,0,'','','','','','N','','',''),(15887089,'BENITO CAYETANO AHUE','KM 3 COMUNIDAD SAN SEBASTI?N','313 2820447',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(6565709,'JORGE ANTONIO MORALES CABRERA','Calle 12 No. 8-40','310 2104654',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(15877394,'COSMEN LIZ CARDOZO CATACHUNGA','Calle 6 No. 4-39 Barrio Gait','311 5127456',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(15876086,'MANUEL GONSALEZ RAMOS','Carrera 2 No. 2-01 Barrio Colombia','321 9185824',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(15876584,'MARTIN RODRIGUEZ BOL?VAR','Calle 14 No. 3A 43','320 3732138',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(15886945,'JOSE CARMEN NOGUERA RODRIGUEZ','Calle 7 No. 5B','322 6093700',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(15887827,'FRANCISCO PERDOMO MORA','BARRIO SAN MIGUEL','311 4608051',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A',''),(1121207115,'LUIS ENRIQUE RIVAS NIÑO','CLL 5A # 7-32 PORVENIR','317 3795053',0,'LUIS','ENRIQUE','RIVAS','NIÑO',3313,91001,'','E','CC','N','N','N','N','A',''),(1121205881,'LIZETH CHRISTINA SILVA SALAZAR','CRA 9 # 5-21 BARRIO PORVENIR','3143301525',0,'','','','',0,91001,'N','E','CC','N','N','N','N','A','');
/*!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',210001),(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);
/*!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 */;
INSERT INTO `traslado` (`tra_numero`, `tra_codres`, `tra_fecreg`, `tra_horreg`, `tra_estado`, `tra_tippag`, `tra_vlrtot`, `tra_detalle`, `tra_feccre`, `tra_anopre`) VALUES (210001,'1121205881','2021-01-04','08:37:34','P','1',156042095.00,' Ajustes presupuestales año 2021','2021-01-22',2021);
/*!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_leticia_contable2021'
--

--
-- Dumping routines for database 'antsoftw_leticia_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 2026-06-05  2:37:42
