-- Table structure for table `cuentas_niif`
--

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;

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


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

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;

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


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

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;

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


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

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,
  `cupd_cpc` varchar(20) NOT NULL,
  PRIMARY KEY (`cupd_codcta`,`cupd_tipcta`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


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

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;

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

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 (202208,39574392,149,0,10000000.00,10000000.00,2000000.00,5,0,'2022-08-30','39574392','A'),(202210,1069174879,29,0,960000.00,960000.00,320000.00,3,0,'2022-10-01','39574392','A'),(202210,11224412,149,0,9522555.00,9522555.00,272073.00,35,0,'2022-10-01','39574392','A'),(202210,11224412,150,0,11495120.00,11495120.00,328432.00,35,0,'2022-10-01','39574392','A'),(202210,1069179327,149,0,31392956.00,31392956.00,532084.00,59,0,'2022-10-01','39574392','A'),(202210,1069177652,149,0,17956796.00,17956796.00,408109.00,44,0,'2022-10-01','39574392','A'),(202210,11299784,149,0,10661175.00,10661175.00,426447.00,25,0,'2022-10-01','39574392','A'),(202210,11299784,150,0,3012373.00,3012373.00,231721.00,13,0,'2022-10-01','39574392','A'),(202210,1069175583,150,0,4866267.00,4866267.00,231727.00,21,0,'2022-10-01','39574392','A'),(202210,80493007,150,0,1807360.00,1807360.00,225920.00,8,0,'2022-10-01','39574392','A'),(202210,80493007,149,0,16650828.00,16650828.00,462523.00,36,0,'2022-10-01','39574392','A'),(202210,11312820,150,0,10838256.00,10838256.00,328432.00,33,0,'2022-10-01','39574392','A'),(202210,3150971,31,0,869388.00,869388.00,72449.00,12,0,'2022-10-01','39574392','A'),(202210,1069177652,31,0,869388.00,869388.00,72449.00,12,0,'2022-10-01','39574392','A'),(202210,39581254,31,0,869388.00,869388.00,67619.00,12,0,'2022-10-01','39574392','A'),(202210,11312820,31,0,869388.00,869388.00,72449.00,12,0,'2022-10-01','39574392','A'),(202210,80493007,31,0,869388.00,869388.00,72449.00,12,0,'2022-10-01','39574392','A'),(202210,11299784,30,0,869388.00,869388.00,72449.00,12,0,'2022-10-01','39574392','A'),(202210,1069176415,31,0,869388.00,869388.00,31525.00,12,0,'2022-10-01','39574392','A'),(202210,1069179245,31,0,869388.00,869388.00,72449.00,12,0,'2022-10-01','39574392','A'),(202210,1069174984,31,0,869388.00,869388.00,72449.00,12,0,'2022-10-01','39574392','A'),(202210,1069177243,31,0,869388.00,869388.00,72449.00,12,0,'2022-10-01','39574392','A'),(202210,1069175583,31,0,869388.00,869388.00,72449.00,12,0,'2022-10-01','39574392','A'),(202210,1069175333,31,0,869388.00,869388.00,72449.00,12,0,'2022-10-01','39574392','A');

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

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;

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


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

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;

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


--
-- Table structure for table `cxpm`
--

CREATE TABLE `cxpm` (
  `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;

--
-- Dumping data for table `cxpm`
--


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


--
-- Table structure for table `detcamregistrop`
--

CREATE TABLE `detcamregistrop` (
  `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;

--
-- Dumping data for table `detcamregistrop`
--


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

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;

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


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

CREATE TABLE `detcxp` (
  `dcxp_numero` int(9) NOT NULL,
  `dcxp_codcon` varchar(30) NOT NULL,
  `dcxp_conse` int(9) 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`,`dcxp_conse`),
  KEY `dcxp_numero` (`dcxp_numero`),
  KEY `dcxp_codcon` (`dcxp_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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

INSERT INTO `detliquinom_liq` (`dlq_periodo`, `dlq_cedula`, `dlq_codcon`, `dlq_apagar`) VALUES (202208,1069179327,24,15200.00),(202208,1069179327,21,116700.00),(202208,1069179327,18,350000.00),(202208,1069179327,15,116700.00),(202208,1069179327,14,116700.00),(202208,1069179327,1,2916855.00),(202208,1069179245,24,35300.00),(202208,1069179245,21,58000.00),(202208,1069179245,18,174100.00),(202208,1069179245,15,58000.00),(202208,1069179245,14,58000.00),(202208,1069179245,5,117172.00),(202208,1069179245,1,1450443.00),(202208,1069177652,24,35300.00),(202208,1069177652,21,58000.00),(202208,1069177652,18,174100.00),(202208,1069177652,15,58000.00),(202208,1069177652,14,58000.00),(202208,1069177652,5,117172.00),(202208,1069177652,1,1450443.00),(202208,1069177243,24,71800.00),(202208,1069177243,21,66000.00),(202208,1069177243,18,198100.00),(202208,1069177243,15,66000.00),(202208,1069177243,14,66000.00),(202208,1069177243,5,117172.00),(202208,1069177243,1,1651050.00),(202208,1069176415,24,35300.00),(202208,1069176415,21,58000.00),(202208,1069176415,18,174100.00),(202208,1069176415,15,58000.00),(202208,1069176415,14,58000.00),(202208,1069176415,5,117172.00),(202208,1069176415,1,1450443.00),(202208,1069176320,24,53000.00),(202208,1069176320,21,87000.00),(202208,1069176320,18,261100.00),(202208,1069176320,15,87000.00),(202208,1069176320,14,87000.00),(202208,1069176320,1,2175666.00),(202208,1069175583,24,35300.00),(202208,1069175583,21,58000.00),(202208,1069175583,18,174100.00),(202208,1069175583,15,58000.00),(202208,1069175583,14,58000.00),(202208,1069175583,5,117172.00),(202208,1069175583,1,1450443.00),(202208,1069175333,24,8700.00),(202208,1069175333,21,67000.00),(202208,1069175333,18,201000.00),(202208,1069175333,15,67000.00),(202208,1069175333,14,67000.00),(202208,1069175333,5,117172.00),(202208,1069175333,1,1675255.00),(202208,1069174984,24,35300.00),(202208,1069174984,21,58000.00),(202208,1069174984,18,174100.00),(202208,1069174984,15,58000.00),(202208,1069174984,14,58000.00),(202208,1069174984,5,117172.00),(202208,1069174984,1,1450443.00),(202208,1069174879,24,258000.00),(202208,1069174879,21,237300.00),(202208,1069174879,19,59317.00),(202208,1069174879,18,711800.00),(202208,1069174879,15,237300.00),(202208,1069174879,14,237300.00),(202208,1069174879,1,5931671.00),(202208,1069174702,24,203000.00),(202208,1069174702,21,116700.00),(202208,1069174702,18,350000.00),(202208,1069174702,15,116700.00),(202208,1069174702,14,116700.00),(202208,1069174702,1,2916855.00),(202208,80493007,24,35300.00),(202208,80493007,21,58000.00),(202208,80493007,18,174100.00),(202208,80493007,15,58000.00),(202208,80493007,14,58000.00),(202208,80493007,5,117172.00),(202208,80493007,1,1450443.00),(202208,39581254,24,4400.00),(202208,39581254,21,34000.00),(202208,39581254,18,204000.00),(202208,39581254,15,68000.00),(202208,39581254,14,68000.00),(202208,39581254,219,850000.00),(202208,39581254,5,58586.00),(202208,39581254,1,850000.00),(202208,39574392,24,15200.00),(202208,39574392,21,116700.00),(202208,39574392,18,350000.00),(202208,39574392,15,116700.00),(202208,39574392,14,116700.00),(202208,39574392,149,2000000.00),(202208,39574392,1,2916855.00),(202208,11312820,24,35300.00),(202208,11312820,21,62000.00),(202208,11312820,18,186100.00),(202208,11312820,15,62000.00),(202208,11312820,14,62000.00),(202208,11312820,36,100000.00),(202208,11312820,5,117172.00),(202208,11312820,1,1450443.00),(202208,11304572,24,66500.00),(202208,11304572,21,109100.00),(202208,11304572,18,327400.00),(202208,11304572,15,109100.00),(202208,11304572,14,109100.00),(202208,11304572,1,2728570.00),(202208,11299784,24,11500.00),(202208,11299784,21,88100.00),(202208,11299784,18,264200.00),(202208,11299784,15,88100.00),(202208,11299784,14,88100.00),(202208,11299784,1,2201400.00),(202208,11224412,24,17400.00),(202208,11224412,21,133400.00),(202208,11224412,18,400300.00),(202208,11224412,15,133400.00),(202208,11224412,14,133400.00),(202208,11224412,1,3336019.00),(202208,3150971,24,8100.00),(202208,3150971,21,13300.00),(202208,3150971,18,40000.00),(202208,3150971,15,13300.00),(202208,3150971,14,13300.00),(202208,3150971,5,39057.33),(202208,3150971,1,333338.33),(202210,1069179327,24,15200.00),(202210,1069179327,21,116700.00),(202210,1069179327,18,350000.00),(202210,1069179327,15,116700.00),(202210,1069179327,14,116700.00),(202210,1069179327,149,532084.00),(202210,1069179327,1,2916855.00),(202210,1069179245,24,35300.00),(202210,1069179245,21,138600.00),(202210,1069179245,18,401800.00),(202210,1069179245,15,133900.00),(202210,1069179245,14,133900.00),(202210,1069179245,36,1898261.00),(202210,1069179245,31,72449.00),(202210,1069179245,5,117172.00),(202210,1069179245,1,1450443.00),(202210,1069177652,24,35300.00),(202210,1069177652,21,62700.00),(202210,1069177652,149,408109.00),(202210,1069177652,31,72449.00),(202210,1069177652,5,117172.00),(202210,1069177652,1,1450443.00),(202210,1069177243,24,71800.00),(202210,1069177243,21,70700.00),(202210,1069177243,18,198100.00),(202210,1069177243,15,66000.00),(202210,1069177243,14,66000.00),(202210,1069177243,31,72449.00),(202210,1069177243,5,117172.00),(202210,1069177243,1,1651050.00),(202210,1069176415,24,15300.00),(202210,1069176415,21,27200.00),(202210,1069176415,18,87000.00),(202210,1069176415,15,29000.00),(202210,1069176415,14,29000.00),(202210,1069176415,213,96696.20),(202210,1069176415,31,31525.00),(202210,1069176415,5,50774.53),(202210,1069176415,1,628525.30),(202210,1069176320,24,53000.00),(202210,1069176320,21,87000.00),(202210,1069176320,18,261100.00),(202210,1069176320,15,87000.00),(202210,1069176320,14,87000.00),(202210,1069176320,1,2175666.00),(202210,1069175583,24,35300.00),(202210,1069175583,21,62700.00),(202210,1069175583,18,174100.00),(202210,1069175583,15,58000.00),(202210,1069175583,14,58000.00),(202210,1069175583,150,231727.00),(202210,1069175583,31,72449.00),(202210,1069175583,5,117172.00),(202210,1069175583,1,1450443.00),(202210,1069175333,24,8700.00),(202210,1069175333,21,71700.00),(202210,1069175333,18,201000.00),(202210,1069175333,15,67000.00),(202210,1069175333,14,67000.00),(202210,1069175333,31,72449.00),(202210,1069175333,5,117172.00),(202210,1069175333,1,1675255.00),(202210,1069174984,24,28300.00),(202210,1069174984,21,50200.00),(202210,1069174984,18,166300.00),(202210,1069174984,15,55400.00),(202210,1069174984,14,55400.00),(202210,1069174984,214,128934.71),(202210,1069174984,213,96696.20),(202210,1069174984,31,72449.00),(202210,1069174984,5,93737.60),(202210,1069174984,1,1160354.40),(202210,1069174879,24,32600.00),(202210,1069174879,21,250100.00),(202210,1069174879,19,62517.00),(202210,1069174879,18,750200.00),(202210,1069174879,15,250100.00),(202210,1069174879,14,250100.00),(202210,1069174879,29,320000.00),(202210,1069174879,1,5931671.00),(202210,1069174702,24,203000.00),(202210,1069174702,21,116700.00),(202210,1069174702,18,350000.00),(202210,1069174702,15,116700.00),(202210,1069174702,14,116700.00),(202210,1069174702,1,2916855.00),(202210,80493007,24,35300.00),(202210,80493007,21,62700.00),(202210,80493007,14,58000.00),(202210,80493007,150,225920.00),(202210,80493007,149,462523.00),(202210,80493007,31,72449.00),(202210,80493007,5,117172.00),(202210,80493007,1,1450443.00),(202210,39581254,24,8200.00),(202210,39581254,21,66900.00),(202210,39581254,18,187600.00),(202210,39581254,15,62500.00),(202210,39581254,14,62500.00),(202210,39581254,31,67619.00),(202210,39581254,5,109360.53),(202210,39581254,1,1563571.33),(202210,39574392,24,15200.00),(202210,39574392,21,116700.00),(202210,39574392,18,350000.00),(202210,39574392,15,116700.00),(202210,39574392,14,116700.00),(202210,39574392,1,2916855.00),(202210,11312820,24,35300.00),(202210,11312820,21,62700.00),(202210,11312820,18,174100.00),(202210,11312820,15,58000.00),(202210,11312820,14,58000.00),(202210,11312820,150,328432.00),(202210,11312820,31,72449.00),(202210,11312820,5,117172.00),(202210,11312820,1,1450443.00),(202210,11299784,24,11500.00),(202210,11299784,21,88100.00),(202210,11299784,18,264200.00),(202210,11299784,15,88100.00),(202210,11299784,14,88100.00),(202210,11299784,150,231721.00),(202210,11299784,149,426447.00),(202210,11299784,30,72449.00),(202210,11299784,1,2201400.00),(202210,11224412,24,17400.00),(202210,11224412,21,133400.00),(202210,11224412,18,400300.00),(202210,11224412,15,133400.00),(202210,11224412,14,133400.00),(202210,11224412,150,328432.00),(202210,11224412,149,272073.00),(202210,11224412,1,3336019.00),(202210,3150971,24,24400.00),(202210,3150971,21,44700.00),(202210,3150971,18,120000.00),(202210,3150971,15,40000.00),(202210,3150971,14,40000.00),(202210,3150971,31,72449.00),(202210,3150971,5,117172.00),(202210,3150971,1,1000015.00);

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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

CREATE TABLE `detped_cxp` (
  `dp_numero` int(9) NOT NULL,
  `dp_codcon` int(4) NOT NULL,
  `dp_conse` int(9) 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`,`dp_conse`),
  KEY `dp_codcon` (`dp_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


--
-- Table structure for table `detpedsaldev`
--

CREATE TABLE `detpedsaldev` (
  `dps_numero` int(9) NOT NULL,
  `dps_codcon` int(4) NOT NULL,
  `dps_codigo` int(9) 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`,`dps_codigo`),
  KEY `dps_codcon` (`dps_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `detpedsaldev`
--


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

CREATE TABLE `detsalidasdev` (
  `ds_tipo_sa` int(1) NOT NULL,
  `ds_numero` int(9) NOT NULL,
  `ds_codcon` int(4) NOT NULL,
  `ds_codigo` int(11) 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`,`ds_codigo`),
  KEY `ds_codcon` (`ds_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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

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 (1,0,'asexis','2023-10-18','05:40:27','P','1',0.00,0.00,0.00,0.00,0.00,' compra de elementos','2023-10-18',0.00,0.00);

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

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;

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


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

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,
  `em_banco` 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;

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

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`, `em_banco`) VALUES (39581254,'ANYELA TATINA ORTIZ SERNA','VEREDA MANUEL SUR','3042916484','U',1,800251440,890903790,800224808,8001485142,200000,101,'1982-07-23','2022-10-03',1675255.00,'A','','0','24095127264','I','5',0.52200,'6','F','0000-00-00','','ANYELA TATINA','ORTIZ SERNA','CAJA SOCIAL'),(11304572,'GERMAN JOHAN HERRAN MARTINEZ','CRA 8 No. 44?a-20 Barrio Portachuelo','3204496122','U',1,800130907,890903790,900336004,860007336,200000,101,'1959-12-08','2014-01-02',2728570.00,'I','P','','356200002166','F','1',2.43600,'xx','M','0000-00-00','','GERMAN JOHAN HERRAN MARTINEZ','','DAVIVIENDA'),(11224412,'RODRIGO ALEXANDER JARAMILLO RODRIGUEZ','MZA E1 CASA 6 URBANIZACION SENDEROS DE LAS ACACIAS','3143249961','U',1,8300035647,890903790,800224808,860007336,200000,101,'1980-03-08','2015-05-02',3336019.00,'A','P','0','356070200437','I','1',0.52200,'xx','M','0000-00-00','','RODRIGO ALEXANDER ','JARAMILLO RODRIGUEZ','DAVIVIENDA'),(1069174879,'YEIMI PAULINA MENDOZA PERDOMO','MZA F2 CASA 10 URBANIZACION SENDEROS DE LAS ACACIA','3007481753','S',1,8300035647,890903790,800224808,860007336,200000,202,'1988-08-08','2019-04-01',5931671.00,'A','U','0','24047898682','I','1',0.52200,'1','F','0000-00-00','yeimipau@gmail.com','YEIMI PAULINA ','MENDOZA PERDOMO','CAJA SOCIAL'),(39574392,'MARTHA ISABEL CESPEDES CALDERON','CLLE 47-B No. 4-20 MZA B CASA 28 BARRIO PORTACHUEO','3016092784','C',2,800251440,890903790,900336004,860007336,200000,101,'1978-01-05','2021-01-14',2916855.00,'A','U','0','24063545012','I','1',0.52200,'5','F','0000-00-00','marthaisaces78@hotmail.com','MARTHA ISABEL ','CESPEDES CALDERON','CAJA SOCIAL'),(1069179327,'DIEGO ANDRES AVILA PERDOMO','VEREDA LAS VARAS MUNICIPO DE RICAURTE CUNDINAMARCA','3232235673','S',0,8300035647,890903790,800224808,860007336,200000,202,'1999-06-13','2022-07-05',2916855.00,'A','U','0','24099292780','I','2',0.52200,'23','M','0000-00-00','','DIEGO ANDRES ','AVILA PERDOMO','CAJA SOCIAL'),(11299784,'CIRO MURILLO GUZMAN','  CONJUNTO RESIDENCIAL JOSE MARIA CORDOBA MZA 5 CA','3124899500','U',2,8300035647,890903790,900336004,860007336,200000,202,'1955-12-09','2019-06-26',2201400.00,'A','','0','24066164241','I','2',0.52200,'xx','M','0000-00-00','','CIRO ','MURILLO GUZMAN','CAJA SOCIAL'),(1069175333,'XIMENA HERNANDEX CUELLAR','DIAGONAL 1 No.17-51 CONJUNTO BRISAS DE ABRIL TORRE','3208695244','U',1,800251440,890903790,800224808,860007336,200000,202,'1988-05-24','2015-01-02',1675255.00,'A','','','24050618457','I','2',0.52200,'xx','F','0000-00-00','','XIMENA','HERNADEZ CUELLAR','CAJA SOCIAL'),(1069177243,'JAIME ANDRES SANCHEZ RAMIREZ','MZ E CASA 36 VILLA DIANA CAROLINA','3229474836','U',1,800130907,890903790,800224808,860007336,200000,202,'1994-02-12','2014-08-08',1651050.00,'A','P','0','570359670018118','I','2',4.35000,'25','M','0000-00-00','','JAIME ANDRES ','SANCHEZ RAMIREZ','DAVIVIENDA'),(1069174702,'STEPHANNI CAROLINA OLAYA JIMENEZ','DIAGONAL 1 No.17-51 CONJUNTO BRISAS DE ABRILTORRE','3046553252','S',0,8300035647,890903790,800224808,860007336,200000,202,'1988-01-26','2022-08-09',2916855.00,'A','U','0','65906762000','I','1',6.96000,'27','F','0000-00-00','','STEPHANNI CAROLINA ','OLAYA JIMENEZ','BANCOLOMBIA'),(1069176320,'LUIS CARLOS AVILA ESTRELLA','CONJUNTO RESIDENCIAL JOSE MARIA CORDOBA MZA 8 CASA','3219273504','S',0,800130907,890903790,800224808,860007336,200000,202,'1991-10-11','2016-03-01',2175666.00,'I','','','838198943','I','1',2.43600,'xx','M','0000-00-00','','LUIS CARLOS AVILA ESTRELLA',' AVILA ESTRELLA','BANCO DE BOGOTA'),(11312820,'BENJAMIN ROJAS ESTRELLA','VEREDA LLANO DEL POZO RICAURTE CUNDINAMARCA','3213516059','U',2,8300035647,890903790,900336004,860007336,200000,202,'1964-11-08','2014-08-01',1450443.00,'A','P','0','570359670018100','I','1',2.43600,'xx','M','0000-00-00','','BENJAMIN ','ROJAS ESTRELLA','DAVIVIENDA'),(1069176415,'CRISTIAN FABIAN MEDINA DONCEL','VEREDA BERLIN AGUA DE DIOS CUNDINAMARCA','3213395972','U',1,8300035647,890903790,800224808,860007336,200000,202,'1991-12-28','2015-06-23',1450443.00,'A','P','0','24090624544','I','1',2.43600,'26','M','0000-00-00','','CRISTIAN FABIAN ','MEDINA DONCEL','BANCO CAJA SOCIAL'),(80493007,'CARLOS ARTURO MORENO VERA','CALLE 10 8-68 BARRIO ISLA DEL SOL PARTE ALTA RICAU','3126855178','U',3,800251440,890903790,0,860007336,200000,202,'1973-04-27','2017-11-01',1450443.00,'A','P','','359600003735','I','1',2.43600,'26','M','0000-00-00','','CARLOS ARTURO ','MORENO VERA','DAVIVIENDA'),(1069175583,'WILSON VILLAREAL MARTINEZ','URBANIZACION VILLA DIANA CAROLINA MANZ C CASA 26','3052246595','S',1,800130907,890903790,800224808,860007336,200000,202,'1990-01-15','2021-02-15',1450443.00,'A','P','0','24087603705','I','2',2.43600,'26','M','0000-00-00','','WILSON ','VILLAREAL MARTINEZ','BANCO CAJA SOCIAL'),(1069177652,'ANDRES FELIPE NU?EZ SANCHEZ','VEREDA LAS VARAS MUNICIPO DE RICAURTE CUNDINAMARCA','3227499634','U',0,8300035647,890903790,800224808,860007336,200000,202,'1995-02-23','2019-06-26',1450443.00,'A','B','0','24071600794','I','2',2.43600,'26','M','0000-00-00','','ANDRES FELIPE ','NUÑEZ SANCHEZ','BANCO CAJA SOCIAL'),(3150971,'ALEJADRO RICO MEDINA','VEREDA LIMONCITOS MUNICIPIO DE RICAURTE CUNDINAMAR','3046571923','U',0,8300035647,890903790,800224808,860007336,200000,202,'1974-07-17','2021-02-01',1000015.00,'A','P','','24071283531','I','1',2.43600,'xx','M','0000-00-00','','ALEJADRO RICO MEDINA ','','BANCO CAJA SOCIAL'),(1069174984,'ERIK MAURICIO VARGAS ROMERO','VEREDA EL PORTAL MUNNICIPIO DE RICAURTE CUNDINAMAR','3184943921','U',2,800130907,890903790,800224808,860007336,200000,202,'1998-09-01','2021-05-05',1450443.00,'A','B','0','356070274408','I','2',2.43600,'26','M','0000-00-00','','ERIK MAURICIO ','VARGAS ROMERO','DAVIVIENDA'),(1069179245,'DANIEL ALFONSO GALINDO CASTILLO','VEREDA CASA BLANCA MUNICIPIO DE RICAURTE CUNDINAMR','3162865041','S',0,800130907,890903790,800224808,860007336,200000,202,'1999-03-02','2021-10-15',1450443.00,'A','B','0','24109048316','I','2',2.43600,'26','M','0000-00-00','','DANIEL ALFONSO','GALINDO CASTILLO','BANCO CAJA SOCIAL'),(1069179050,'CINDY MARCELA SALGUERO DONCEL','VEREDA LA TETILLA RICAURTE CUNDINAMARCA','3145871466','S',0,800130907,890903790,800224808,860007336,200000,202,'1998-09-12','2022-11-08',2000000.00,'A','T','0','65906809316','I','2',0.52200,'7','F','0000-00-00','marcela.salguero892@gamil.com','CINDY MARCELA ','SALGUERO DONCEL','BANCOLOMBIA'),(11205476,'CLEIBRE RODRIGO GARCIA ORTIZ','CONJUNTO RESIDENCIA BRISAS DE ABRIL T 6 APT  201','3206118190','U',1,800130907,890903790,800224808,860007336,200000,202,'1984-05-27','2022-11-08',3018945.00,'A','U','0','65906762107','I','xx',0.52200,'8','M','0000-00-00','cleiberodrigo28@hotmail.com','CLEIBER RODRIGO ','GARCIA ORTIZ','BANCOLOMBIA');

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

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;

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


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

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,
  `em_banco` 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;

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

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`, `em_banco`) VALUES (202208,1069179245,'DANIEL ALFONSO GALINDO CASTILLO','VEREDA CASA BLANCA MUNICIPIO DE RICAURTE CUNDINAMR','3162865041','S',0,800130907,890903790,800144331,860007336,200000,202,'1999-03-02','2021-10-15',1450443.00,'A','B','','24109048316','I','1',2.43600,'0','M','0000-00-00','','DANIEL ALFONSO GALINDO CASTILLO','','BANCO CAJA SOCIAL'),(202208,1069174984,'ERIK MAURICIO VARGAS ROMERO','VEREDA EL PORTAL MUNNICIPIO DE RICAURTE CUNDINAMAR','3184943921','U',2,800130907,890903790,800144331,860007336,200000,202,'1998-09-01','2021-05-05',1450443.00,'A','B','','356070274408','I','1',2.43600,'0','M','0000-00-00','','ERIK MAURICIO VARGAS ROMERO','','DAVIVIENDA'),(202208,3150971,'ALEJADRO RICO MEDINA','VEREDA LIMONCITOS MUNICIPIO DE RICAURTE CUNDINAMAR','3046571923','U',0,830003564,890903790,800149496,860007336,200000,202,'1974-07-17','2021-02-01',1000015.00,'A','P','','24071283531','I','1',2.43600,'0','M','0000-00-00','','ALEJADRO RICO MEDINA ','','BANCO CAJA SOCIAL'),(202208,1069177652,'ANDRES FELIPE NU?EZ SANCHEZ','VEREDA LAS VARAS MUNICIPO DE RICAURTE CUNDINAMARCA','3227499634','U',0,830003564,890903790,800144331,860007336,200000,202,'1995-02-23','2019-06-26',1450443.00,'A','B','','24071600794','I','1',2.43600,'0','M','0000-00-00','','ANDRES FELIPE NU?EZ SANCHEZ','','BANCO CAJA SOCIAL'),(202208,1069176415,'CRISTIAN FABIAN MEDINA DONCEL','VEREDA BERLIN AGUA DE DIOS CUNDINAMARCA','3213395972','U',1,830003564,890903790,800144331,860007336,200000,202,'1991-12-28','2015-06-23',1450443.00,'A','P','','24090624544','I','1',2.43600,'0','M','0000-00-00','','CRISTIAN FABIAN MEDINA DONCEL','','BANCO CAJA SOCIAL'),(202208,80493007,'CARLOS ARTURO MORENO VERA','CALLE 10 8-68 BARRIO ISLA DEL SOL PARTE ALTA RICAU','3126855178','U',3,800251440,890903790,800144331,860007336,200000,202,'1973-04-27','2017-11-01',1450443.00,'A','P','','359600003735','I','1',2.43600,'0','M','0000-00-00','','CARLOS ARTURO MORENO VERA','','DAVIVIENDA'),(202208,1069175583,'WILSON VILLAREAL MARTINEZ','URBANIZACION VILLA DIANA CAROLINA MANZ C CASA 26','3052246595','S',1,800130907,890903790,800144331,860007336,200000,202,'1990-01-15','2021-02-15',1450443.00,'A','P','','24087603705','I','1',2.43600,'0','M','0000-00-00','','WILSON VILLAREAL MARTINEZ','','BANCO CAJA SOCIAL'),(202208,11312820,'BENJAMIN ROJAS ESTRELLA','VEREDA LLANO DEL POZO RICAURTE CUNDINAMARCA','3213516059','U',2,830003564,890903790,900336004,860007336,200000,202,'1964-11-08','2014-08-01',1450443.00,'A','P','','570359670018100','I','1',2.43600,'0','M','0000-00-00','','BENJAMIN ROJAS ESTRELLA','','DAVIVIENDA'),(202208,1069176320,'LUIS CARLOS AVILA ESTRELLA','CONJUNTO RESIDENCIAL JOSE MARIA CORDOBA MZA 8 CASA','3219273504','S',0,800130907,890903790,800144331,860007336,200000,202,'1991-10-11','2016-03-01',2175666.00,'A','T','','838198943','I','1',2.43600,'0','M','0000-00-00','','LUIS CARLOS AVILA ESTRELLA','','BANCO DE BOGOTA'),(202208,1069174702,'STEPHANNI CAROLINA OLAYA JIMENEZ','DIAGONAL 1 No.17-51 CONJUNTO BRISAS DE ABRILTORRE','3046553252','S',0,830003564,890903790,800144331,860007336,200000,202,'1988-01-26','2022-08-09',2916855.00,'A','P','','65906762000','I','1',6.96000,'0','F','0000-00-00','','STEPHANNI CAROLINA OLAYA JIMENEZ','','BANCOLOMBIA'),(202208,1069177243,'JAIME ANDRES SANCHEZ RAMIREZ','MZ E CASA 36 VILLA DIANA CAROLINA','3229474836','U',1,800130907,890903790,800144331,860007336,200000,101,'1994-02-12','2014-08-08',1651050.00,'A','P','','570359670018118','I','1',4.35000,'0','M','0000-00-00','','JAIME ANDRES SANCHEZ RAMIREZ','','DAVIVIENDA'),(202208,1069175333,'XIMENA HERNANDEX CUELLAR','DIAGONAL 1 No.17-51 CONJUNTO BRISAS DE ABRIL TORRE','3208695244','U',1,800251440,890903790,800144331,860007336,200000,101,'1988-05-24','2015-01-02',1675255.00,'A','T','','24050618457','I','1',0.52200,'0','F','0000-00-00','','XIMENA HERNANDEX CUELLAR','','CAJA SOCIAL'),(202208,11299784,'CIRO MURILLO GUZMAN','  CONJUNTO RESIDENCIAL JOSE MARIA CORDOBA MZA 5 CA','3124899500','U',2,830003564,890903790,900336004,860007336,200000,101,'1955-12-09','2019-06-26',2201400.00,'A','T','','24066164241','I','1',0.52200,'0','M','0000-00-00','','CIRO MURILLO GUZMAN','','CAJA SOCIAL'),(202208,39574392,'MARTHA ISABEL CESPEDES CALDERON','CLLE 47-B No. 4-20 MZA B CASA 28 BARRIO PORTACHUEO','3016092784','C',2,800251440,890903790,900336004,860007336,200000,101,'1978-01-05','2021-01-14',2916855.00,'A','P','','24063545012','I','1',0.52200,'0','F','0000-00-00','','MARTHA ISABEL CESPEDES CALDERON','','CAJA SOCIAL'),(202208,1069179327,'DIEGO ANDRES AVILA PERDOMO','VEREDA LAS VARAS MUNICIPO DE RICAURTE CUNDINAMARCA','3232235673','S',0,830003564,890903790,800144331,860007336,200000,101,'1999-06-13','2022-07-05',2916855.00,'A','P','','24099292780','I','1',0.52200,'0','M','0000-00-00','','DIEGO ANDRES AVILA PERDOMO','','CAJA SOCIAL'),(202208,39581254,'ANYELA TATINA ORTIZ SERNA','VEREDA MANUEL SUR','3042916484','U',1,800251440,890903790,800224808,8001485142,200000,101,'1982-07-23','2022-10-03',1700000.00,'A','T','0','24095127264','I','5',0.52200,'6','F','0000-00-00','','','','CAJA SOCIAL'),(202208,11304572,'GERMAN JOHAN HERRAN MARTINEZ','CRA 8 No. 44?a-20 Barrio Portachuelo','3204496122','U',1,800130907,890903790,900336004,860007336,200000,101,'1959-12-08','2014-01-02',2728570.00,'A','P','','356200002166','F','1',2.43600,'0','M','0000-00-00','','GERMAN JOHAN HERRAN MARTINEZ','','DAVIVIENDA'),(202208,11224412,'RODRIGO ALEXANDER JARAMILLO RODRIGUEZ','MZA E1 CASA 6 URBANIZACION SENDEROS DE LAS ACACIAS','3143249961','U',1,830003564,890903790,800149496,860007336,200000,101,'1980-03-08','2015-05-02',3336019.00,'A','P','','356070200437','I','1',0.52200,'0','M','0000-00-00','','RODRIGO ALEXANDER JARAMILLO RODRIGUEZ ','','DAVIVIENDA'),(202208,1069174879,'YEIMI PAULINA MENDOZA PERDOMO','MZA F2 CASA 10 URBANIZACION SENDEROS DE LAS ACACIA','3007481753','S',1,830003564,890903790,800144331,860007336,200000,101,'1988-08-08','2019-04-01',5931671.00,'A','P','','24047898682','I','1',4.35000,'0','F','0000-00-00','','YEIMI PAULINA MENDOZA PERDOMO','','CAJA SOCIAL'),(202210,1069174984,'ERIK MAURICIO VARGAS ROMERO','VEREDA EL PORTAL MUNNICIPIO DE RICAURTE CUNDINAMAR','3184943921','U',2,800130907,890903790,800224808,860007336,200000,202,'1998-09-01','2021-05-05',1450443.00,'A','B','','356070274408','I','1',2.43600,'26','M','0000-00-00','','ERIK MAURICIO VARGAS ROMERO','VARGAS ROMERO','DAVIVIENDA'),(202210,3150971,'ALEJADRO RICO MEDINA','VEREDA LIMONCITOS MUNICIPIO DE RICAURTE CUNDINAMAR','3046571923','U',0,8300035647,890903790,800227940,860007336,200000,202,'1974-07-17','2021-02-01',1000015.00,'A','P','0','24071283531','I','2',2.43600,'26','M','0000-00-00','','ALEJADRO ','RICO MEDINA','BANCO CAJA SOCIAL'),(202210,1069177652,'ANDRES FELIPE NU?EZ SANCHEZ','VEREDA LAS VARAS MUNICIPO DE RICAURTE CUNDINAMARCA','3227499634','U',0,0,890903790,0,860007336,200000,202,'1995-02-23','2019-06-26',1450443.00,'A','B','','24071600794','I','1',2.43600,'26','M','0000-00-00','','ANDRES FELIPE ','NUNEZ SANCHEZ','BANCO CAJA SOCIAL'),(202210,1069175583,'WILSON VILLAREAL MARTINEZ','URBANIZACION VILLA DIANA CAROLINA MANZ C CASA 26','3052246595','S',1,800130907,890903790,800224808,860007336,200000,202,'1990-01-15','2021-02-15',1450443.00,'A','P','','24087603705','I','1',2.43600,'26','M','0000-00-00','','WILSON ','VILLAREAL MARTINEZ','BANCO CAJA SOCIAL'),(202210,80493007,'CARLOS ARTURO MORENO VERA','CALLE 10 8-68 BARRIO ISLA DEL SOL PARTE ALTA RICAU','3126855178','U',3,800251440,890903790,0,860007336,200000,202,'1973-04-27','2017-11-01',1450443.00,'A','P','','359600003735','I','1',2.43600,'26','M','0000-00-00','','CARLOS ARTURO ','MORENO VERA','DAVIVIENDA'),(202210,1069176415,'CRISTIAN FABIAN MEDINA DONCEL','VEREDA BERLIN AGUA DE DIOS CUNDINAMARCA','3213395972','U',1,8300035647,890903790,800224808,860007336,200000,202,'1991-12-28','2015-06-23',1450443.00,'A','P','','24090624544','I','1',2.43600,'26','M','0000-00-00','','CRISTIAN FABIAN MEDINA DONCEL','MEDINA DONCEL','BANCO CAJA SOCIAL'),(202210,11312820,'BENJAMIN ROJAS ESTRELLA','VEREDA LLANO DEL POZO RICAURTE CUNDINAMARCA','3213516059','U',2,8300035647,890903790,900336004,860007336,200000,202,'1964-11-08','2014-08-01',1450443.00,'A','P','','570359670018100','I','1',2.43600,'xx','M','0000-00-00','','BENJAMIN ROJAS ESTRELLA','','DAVIVIENDA'),(202210,1069176320,'LUIS CARLOS AVILA ESTRELLA','CONJUNTO RESIDENCIAL JOSE MARIA CORDOBA MZA 8 CASA','3219273504','S',0,800130907,890903790,800224808,860007336,200000,202,'1991-10-11','2016-03-01',2175666.00,'A','','','838198943','I','1',2.43600,'xx','M','0000-00-00','','LUIS CARLOS ','AVILA ESTRELLA','BANCO DE BOGOTA'),(202210,1069174702,'STEPHANNI CAROLINA OLAYA JIMENEZ','DIAGONAL 1 No.17-51 CONJUNTO BRISAS DE ABRILTORRE','3046553252','S',0,8300035647,890903790,800224808,860007336,200000,202,'1988-01-26','2022-08-09',2916855.00,'A','P','','65906762000','I','1',6.96000,'27','F','0000-00-00','','STEPHANNI CAROLINA ','OLAYA JIMENEZ','BANCOLOMBIA'),(202210,1069177243,'JAIME ANDRES SANCHEZ RAMIREZ','MZ E CASA 36 VILLA DIANA CAROLINA','3229474836','U',1,800130907,890903790,800224808,860007336,200000,101,'1994-02-12','2014-08-08',1651050.00,'A','P','','570359670018118','I','1',4.35000,'25','M','0000-00-00','','JAIME ANDRES SANCHEZ RAMIREZ','SANCHEZ RAMIREZ','DAVIVIENDA'),(202210,1069175333,'XIMENA HERNANDEX CUELLAR','DIAGONAL 1 No.17-51 CONJUNTO BRISAS DE ABRIL TORRE','3208695244','U',1,800251440,890903790,800144331,860007336,200000,101,'1988-05-24','2015-01-02',1675255.00,'A','T','','24050618457','I','1',0.52200,'0','F','0000-00-00','','XIMENA HERNANDEX CUELLAR','','CAJA SOCIAL'),(202210,11299784,'CIRO MURILLO GUZMAN','  CONJUNTO RESIDENCIAL JOSE MARIA CORDOBA MZA 5 CA','3124899500','U',2,830003564,890903790,900336004,860007336,200000,101,'1955-12-09','2019-06-26',2201400.00,'A','T','','24066164241','I','1',0.52200,'0','M','0000-00-00','','CIRO MURILLO GUZMAN','','CAJA SOCIAL'),(202210,1069179327,'DIEGO ANDRES AVILA PERDOMO','VEREDA LAS VARAS MUNICIPO DE RICAURTE CUNDINAMARCA','3232235673','S',0,8300035647,890903790,800224808,860007336,200000,101,'1999-06-13','2022-07-05',2916855.00,'A','P','','24099292780','I','1',0.52200,'23','M','0000-00-00','','DIEGO ANDRES ','AVILA PERDOMO','CAJA SOCIAL'),(202210,39574392,'MARTHA ISABEL CESPEDES CALDERON','CLLE 47-B No. 4-20 MZA B CASA 28 BARRIO PORTACHUEO','3016092784','C',2,800251440,890903790,900336004,860007336,200000,101,'1978-01-05','2021-01-14',2916855.00,'A','P','','24063545012','I','1',0.52200,'5','F','0000-00-00','','MARTHA ISABEL ','CESPEDES CALDERON','CAJA SOCIAL'),(202210,1069174879,'YEIMI PAULINA MENDOZA PERDOMO','MZA F2 CASA 10 URBANIZACION SENDEROS DE LAS ACACIA','3007481753','S',1,8300035647,890903790,800224808,860007336,200000,101,'1988-08-08','2019-04-01',5931671.00,'A','P','','24047898682','I','1',0.52200,'1','F','0000-00-00','yeimipau@gmail.com','YEIMI PAULINA MENDOZA PERDOMO','MENDOZA PERDOMO','CAJA SOCIAL'),(202210,11224412,'RODRIGO ALEXANDER JARAMILLO RODRIGUEZ','MZA E1 CASA 6 URBANIZACION SENDEROS DE LAS ACACIAS','3143249961','U',1,8300035647,890903790,800224808,860007336,200000,101,'1980-03-08','2015-05-02',3336019.00,'A','U','0','356070200437','I','2',0.52200,'2','M','0000-00-00','','RODRIGO ALEXANDER ','JARAMILLO RODRIGUEZ','DAVIVIENDA'),(202210,39581254,'ANYELA TATINA ORTIZ SERNA','VEREDA MANUEL SUR','3042916484','U',1,800251440,890903790,800224808,8001485142,200000,101,'1982-07-23','2022-10-03',1675255.00,'A','','0','24095127264','I','5',0.52200,'6','F','0000-00-00','','ANYELA TATINA','ORTIZ SERNA','CAJA SOCIAL'),(202210,1069179245,'DANIEL ALFONSO GALINDO CASTILLO','VEREDA CASA BLANCA MUNICIPIO DE RICAURTE CUNDINAMR','3162865041','S',0,800130907,890903790,800224808,860007336,200000,202,'1999-03-02','2021-10-15',1450443.00,'A','B','','24109048316','I','1',2.43600,'26','M','0000-00-00','','DANIEL ALFONSO GALINDO CASTILLO','GALINDO CASTILLO','BANCO CAJA SOCIAL');

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

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;

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

INSERT INTO `empresa` (`ep_codemp`, `ep_nombre`, `ep_direcc`, `ep_telefo`, `ep_dpto`, `ep_mcpio`) VALUES ('900639486-4','ALCARI S.A.S. E.S.P.','CL 9 16 84','8366621','','');

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

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;

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

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'),(890310455,'FUNERALES LOS OLIVOS','','1'),(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'),(901097473,'MEDIMAS','MEDIMAS','EPS044'),(890903790,'SURA','',''),(860007336,'COLSUBSIDIO','COLSUBSIDIO','CCF02');

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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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

INSERT INTO `falta` (`fal_codigo`, `fal_descri`, `fal_dias`) VALUES ('1','Inasistencia',3),('2','VACACIONES',1);

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

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;

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


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

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;

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


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

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;

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


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

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;

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

INSERT INTO `grupo` (`gr_codgru`, `gr_descri`, `entradas_deb`, `entradas_cre`, `salidas_deb`, `salidas_cre`) VALUES (1,'INGRESOS','','','',''),(2,'GASTOS','','','',''),(219,'Redes de Distribucion','','','',''),(215,'Equipos y maquinas de oficina','','','',''),(222,'Redes, lineas y cables','','','',''),(230,'Edificios y Construcciones',' ',' ',' ',' '),(221,'Plantas, Ductos y tuneles',' ',' ',' ',' '),(218,'Equipos Enseres y Maquinas para Oficina',' ',' ',' ',' '),(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 para la estacion de bombeo',' ',' ',' ',' '),(208,'Equipos y Maquinas de Construccion',' ',' ',' ',' '),(206,'Equipos y Maquinas Industrial',' ',' ',' ',' '),(207,'Equipos y Maquinas de Comunicaciones Transformadores',' ',' ',' ',' '),(203,'Otros Muebles, Enseres y Equipo de Oficina',' ',' ',' ',' '),(120,'Otros',' ',' ',' ',' '),(202,'Elementos Intangibles Software',' ',' ',' ',' '),(117,'Otros Elementos de energia ',' ',' ',' ',' '),(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 Energia',' ',' ',' ',' '),(109,'Accesorios para computador',' ',' ',' ',' '),(108,'Materiales y Herramientas Acueducto',' ',' ',' ',' '),(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 Acueducto',' ',' ',' ',' '),(102,'Aceites y Lubricantes Aseo',' ',' ',' ',' '),(101,'Elementos y Materiales de Energia',' ',' ',' ',' '),(122,'Aceites y Lubricantes Energia','','','',''),(123,'Materiales y Herramientas Alcantarillado','','','',''),(124,'Materiales y Herramientas Aseo','','','',''),(125,'Materiales y Herramientas Energia','','','',''),(126,'Elementos de Aseo Energia','','','',''),(118,'Elementos de proteccion y dotacion Acueducto','','','',''),(119,'Elementos de proteccion y dotacion Aseo','','','',''),(127,'Elementos de proteccion y dotacion Energia','','','',''),(128,'Otros Elementos Alcantarillado','','','',''),(129,'Otros Elementos Aseo','','','',''),(130,'Otros Elementos Energia','','','',''),(131,'Dotacion Aseo','','','',''),(132,'Suministro y Mantenimiento de Energia','','','',''),(135,'Utiles de Escritorio, Dibujo y papeleria Acueducto','','','',''),(136,'materiales para distribucion de energia ','','','',''),(137,'Elementos de aseo Administrativo','','','',''),(138,'Otros elementos de Energia ','','','',''),(139,'Materiales para distribucion energia ','','','',''),(140,'Activos fijos de consumo energia','','','',''),(141,'Activos Fijos de Consumo Alcantarillado','','','',''),(142,'Activos fijos de consumo acueducto','','','',''),(143,'Activo fijo de Consumo Aseo','','','',''),(144,'Materiales Transitorios Varios','','','',''),(145,'Herramientas activos','','','',''),(146,'Otros energia','','','',''),(147,'Muebles y enseres acueducto','','','',''),(148,'blanco','','','',''),(201,'Elementos Intangibles Licencia','','','',''),(121,'Elementos Dotacion','','','',''),(149,'Activos menor cuantía energía','','','',''),(231,'Redes de Distribución Acueducto ','','','',''),(232,'Casetas y Campamentos','','','',''),(233,'Parquederos','','','',''),(234,'Tanques de Almacenamientos','','','',''),(235,'Equipos de Comunicación  Varios','','','',''),(236,'Edificios y Casas','','','',''),(237,'Plantas de tratamiento','','','','');

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

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;

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

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');

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

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;

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

INSERT INTO `horasnom_liq` (`ho_periodo`, `ho_cedula`, `ho_codcon`, `ho_cantidad`, `ho_fecreg`, `ho_usuari`, `ho_fecini`, `ho_fecfin`, `ho_observa`) VALUES (202208,3150971,213,2.00,'2022-09-29','39574392','2022-08-01','2022-08-02','incapacidad'),(202208,3150971,214,18.00,'2022-09-29','39574392','2022-08-03','2022-08-17','incapacidad'),(202208,39581254,219,15.00,'2022-09-29','39574392','2022-08-01','2022-08-15','LICENCIA'),(202210,1069176415,213,2.00,'2022-11-16','39574392','2022-10-26','2022-10-27','incapacidad'),(202210,1069174984,214,4.00,'2022-11-04','39574392','2022-10-04','2022-10-07','incapacidad '),(202210,1069174984,213,2.00,'2022-11-04','39574392','2022-10-01','2022-10-02','incapacidad'),(202210,1069176415,1,15.00,'2022-11-16','39574392','2022-10-03','2022-10-30','asignacion '),(202210,39581254,1,28.00,'2022-11-16','asexis','2022-10-03','2022-10-30','asignacion');

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

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;

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


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

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;

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


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

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;

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

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 (202208,1069179327,2683455.00,233400,2916855,30,0,'2021-08-01','2021-08-30','2022-09-29','39574392','14:45:56'),(202208,1069179245,1451615.00,116000,1567615,30,0,'2021-08-01','2021-08-30','2022-09-29','39574392','14:45:56'),(202208,1069177652,1451615.00,116000,1567615,30,0,'2021-08-01','2021-08-30','2022-09-29','39574392','14:45:56'),(202208,1069177243,1636222.00,132000,1768222,30,0,'2021-08-01','2021-08-30','2022-09-29','39574392','14:45:56'),(202208,1069176415,1451615.00,116000,1567615,30,0,'2021-08-01','2021-08-30','2022-09-29','39574392','14:45:56'),(202208,1069176320,2001666.00,174000,2175666,30,0,'2021-08-01','2021-08-30','2022-09-29','39574392','14:45:56'),(202208,1069175583,1451615.00,116000,1567615,30,0,'2021-08-01','2021-08-30','2022-09-29','39574392','14:45:56'),(202208,1069175333,1658427.00,134000,1792427,30,0,'2021-08-01','2021-08-30','2022-09-29','39574392','14:45:56'),(202208,1069174984,1451615.00,116000,1567615,30,0,'2021-08-01','2021-08-30','2022-09-29','39574392','14:45:56'),(202208,1069174879,5397754.00,533917,5931671,30,0,'2021-08-01','2021-08-30','2022-09-29','39574392','14:45:56'),(202208,1069174702,2683455.00,233400,2916855,30,0,'2021-08-01','2021-08-30','2022-09-29','39574392','14:45:56'),(202208,80493007,1451615.00,116000,1567615,30,0,'2021-08-01','2021-08-30','2022-09-29','39574392','14:45:56'),(202208,39581254,1622586.00,136000,1758586,15,0,'2021-08-01','2021-08-30','2022-09-29','39574392','14:45:56'),(202208,39574392,683455.00,2233400,2916855,30,0,'2021-08-01','2021-08-30','2022-09-29','39574392','14:45:56'),(202208,11312820,1543615.00,124000,1667615,30,0,'2021-08-01','2021-08-30','2022-09-29','39574392','14:45:56'),(202208,11304572,2510370.00,218200,2728570,30,0,'2021-08-01','2021-08-30','2022-09-29','39574392','14:45:56'),(202208,11299784,2025200.00,176200,2201400,30,0,'2021-08-01','2021-08-30','2022-09-29','39574392','14:45:56'),(202208,11224412,3069219.00,266800,3336019,30,0,'2021-08-01','2021-08-30','2022-09-29','39574392','14:45:56'),(202208,3150971,345795.66,26600,372396,10,0,'2021-08-01','2021-08-30','2022-09-29','39574392','14:45:56'),(202210,1069179327,2151371.00,765484,2916855,30,0,'2022-10-01','2022-10-31','2022-11-18','jmorales','17:51:37'),(202210,1069179245,3270525.00,267800,3538325,30,0,'2022-10-01','2022-10-31','2022-11-18','jmorales','17:51:37'),(202210,1069177652,1231955.00,408109,1640064,30,0,'2022-10-01','2022-10-31','2022-11-18','jmorales','17:51:37'),(202210,1069177243,1708671.00,132000,1840671,30,0,'2022-10-01','2022-10-31','2022-11-18','jmorales','17:51:37'),(202210,1069176415,749521.03,58000,807521,13,0,'2022-10-01','2022-10-31','2022-11-18','jmorales','17:51:37'),(202210,1069176320,2001666.00,174000,2175666,30,0,'2022-10-01','2022-10-31','2022-11-18','jmorales','17:51:37'),(202210,1069175583,1292337.00,347727,1640064,30,0,'2022-10-01','2022-10-31','2022-11-18','jmorales','17:51:37'),(202210,1069175333,1730876.00,134000,1864876,30,0,'2022-10-01','2022-10-31','2022-11-18','jmorales','17:51:37'),(202210,1069174984,1441371.91,110800,1552172,24,0,'2022-10-01','2022-10-31','2022-11-18','jmorales','17:51:37'),(202210,1069174879,5688954.00,562717,6251671,30,0,'2022-10-01','2022-10-31','2022-11-18','jmorales','17:51:37'),(202210,1069174702,2683455.00,233400,2916855,30,0,'2022-10-01','2022-10-31','2022-11-18','jmorales','17:51:37'),(202210,80493007,893621.00,746443,1640064,30,0,'2022-10-01','2022-10-31','2022-11-18','jmorales','17:51:37'),(202210,39581254,1615550.86,125000,1740551,28,0,'2022-10-01','2022-10-31','2022-11-18','jmorales','17:51:37'),(202210,39574392,2683455.00,233400,2916855,30,0,'2022-10-01','2022-10-31','2022-11-18','jmorales','17:51:37'),(202210,11312820,1195632.00,444432,1640064,30,0,'2022-10-01','2022-10-31','2022-11-18','jmorales','17:51:36'),(202210,11299784,1294583.00,906817,2201400,30,0,'2022-10-01','2022-10-31','2022-11-18','jmorales','17:51:36'),(202210,11224412,2468714.00,867305,3336019,30,0,'2022-10-01','2022-10-31','2022-11-18','jmorales','17:51:36'),(202210,3150971,1109636.00,80000,1189636,30,0,'2022-10-01','2022-10-31','2022-11-18','jmorales','17:51:36');

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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


--
-- Table structure for table `nominadian`
--

CREATE TABLE `nominadian` (
  `nd_numero` int(9) NOT NULL,
  `nd_tercero` bigint(12) NOT NULL DEFAULT '0',
  `nd_periodo` char(6) DEFAULT NULL,
  `nd_codres` char(12) NOT NULL,
  `nd_fecreg` date DEFAULT NULL,
  `nd_horreg` time NOT NULL DEFAULT '00:00:00',
  `nd_vlrtot` double(15,2) DEFAULT NULL,
  `nd_devenga` double(15,2) DEFAULT NULL,
  `nd_deduce` double(15,2) DEFAULT NULL,
  `nd_estado` char(1) NOT NULL,
  `nd_cune` text NOT NULL,
  `nd_id` varchar(50) NOT NULL,
  `nd_url_representacion_grafica` text NOT NULL,
  PRIMARY KEY (`nd_numero`),
  KEY `nd_tercero` (`nd_tercero`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `nominadian`
--


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

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;

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


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

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;

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


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

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;

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

INSERT INTO `novlrnom_liq` (`nv_periodo`, `nv_cedula`, `nv_codcon`, `nv_cobro`, `nv_valor`, `nv_fecreg`, `nv_usuari`) VALUES (202208,11312820,36,0,100000.00,'2022-09-29','39574392'),(202210,1069179245,36,0,1898261.00,'2022-11-17','asexis');

--
-- Table structure for table `novlrnomaju_liq`
--

CREATE TABLE `novlrnomaju_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;

--
-- Dumping data for table `novlrnomaju_liq`
--


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

CREATE TABLE `observaciones` (
  `ob_numero` int(9) NOT NULL,
  `ob_detalle` text,
  PRIMARY KEY (`ob_numero`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


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

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;

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


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

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;

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


--
-- Table structure for table `parametros`
--

CREATE TABLE `parametros` (
  `pa_codigo` varchar(10) NOT NULL,
  `pa_descri` varchar(100) NOT NULL,
  `pa_valor` text NOT NULL,
  `pa_modulo` varchar(3) DEFAULT NULL,
  `pa_estado` varchar(1) NOT NULL,
  PRIMARY KEY (`pa_codigo`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `parametros`
--

INSERT INTO `parametros` (`pa_codigo`, `pa_descri`, `pa_valor`, `pa_modulo`, `pa_estado`) VALUES ('BANNER','BANNER','','FAC','A'),('CIUDADEMP','NOMBRE CIUDAD DE ORIGEN EMPRESA','CARTAGENA DEL CHAIRA','GEN','A'),('DIRECCION','DIRECCION','CL 4 5 32 BRR EL CENTRO','FAC','A'),('EMPRESA','NOMBRE EMPRESA','EMPRESA MUNICIPAL DE SERVICIOS PUBLICOS DE CARTAGENA DEL CHAIRA','GEN','A'),('IMAGENC','IMAGEN ENCABEZADO','iVBORw0KGgoAAAANSUhEUgAABskAAAN5CAYAAABKUdWuAAAAIGNIUk0AAHomAACAhAAA','FAC','A'),('LOGO','LOGO','[encoded data, 17940 characters]','FAC','A'),('MODO','MODO DE OPERACION','2','FAC','A'),('NIT','NIT EMPRESA','828000191','GEN','A'),('NUMRESFAE','NUMERO DE RESOLUCION FACTURACION ELECTRONICA','18760000001','FAE','A'),('PAGUEAQUI','REFERENCIA DE PAGO','','FAC','A'),('PREFIJOFE','PREFIJO FACTURACIÓN ELECTRÓNICA','SETP','FAE','A'),('TELEFONO','TELEFONO','3108715677','FAC','A'),('TESTSETID','TESTSETID','97683971-1b46-47b6-b472-e7195e808d4a','FAC','A'),('TOKEN','TOKEN','7ccdf9e2ed97b4d27cdff3707ee8c7f1426641864468baaae0c783d0bef0cf33','FAC','A'),('URL_HABILI','URL_HABILITACION','https://servicios.afacturar.com/api/vp/','FAC','A'),('URL_PRODUC','URL PRODUCCION','https://servicios.afacturar.com/api/vp/','FAC','A'),('URL_PRUEBA','URL_PRUEBAS','https://servicios-pruebas.afacturar.com/api/vp/','FAC','A');

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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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

INSERT INTO `retencion` (`rte_cuenta`, `rte_descri`, `rte_codigo`, `rte_porcen`, `rte_base`, `rte_baseuvt`) VALUES ('ESTUNACION','Estampilla universidad Nacionales','24072204',0.50,0.00,0.00),('RETE001','Compras generales (declarantes)','24360802',2.50,742000.00,27.00),('RETE002','Compras generales (no declarantes)','24360801',3.50,742000.00,27.00),('RETE003','Compras con tarjeta debito o credito','',1.50,0.00,0.00),('RETE004','Compras de combustibles derivados del petroleo','24360803',0.10,0.00,0.00),('RETE005','Servicios generales (declarantes)','24360505',4.00,110000.00,4.00),('RETE006','Servicios generales (no declarantes)','24360501',6.00,110000.00,4.00),('RETE007','Servicios de transporte de carga','24360505',1.00,0.00,4.00),('RETE008','Servicios de transporte nacional de pasajeros por via terrestre (declarantes)','24360504',2.50,742000.00,27.00),('RETE009','Servicios de licenciamiento de Software 3.5%','24360503',3.50,0.00,0.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','24360513',2.00,144000.00,4.00),('RETE014','Servicios de hoteles y restaurantes (declarantes)','24360504',3.50,119000.00,4.00),('RETE015','Servicios de hoteles y restaurantes (no declarantes)','24360504',3.50,119000.00,4.00),('RETE016','Arrendamiento de bienes muebles','24360602',4.00,0.00,0.00),('RETE017','Arrendamiento de bienes inmuebles (declarantes)','24360602',2.50,742000.00,27.00),('RETE018','Arrendamiento de bienes inmuebles (no declarantes)','24360603',3.50,742000.00,27.00),('RETE019','Otros ingresos tributarios (declarantes)','',2.50,742000.00,27.00),('RETE020','Otros ingresos tributarios (no declarantes)','',3.50,742000.00,27.00),('RETE021','Pagos o abonos en cuenta gravables realizados a personas naturales trib.empleado','24369001',95.00,0.00,0.00),('RETE022','Pagos o abonos en cuenta gravables realizados a personas naturales Tarifa Minima','24369001',128.96,0.00,0.00),('RETE023','Honorarios y comisiones (personas juridicas)','24360302',11.00,0.00,0.00),('RETE024','Honorarios y comisiones personas naturales contrato o sumatoria > 3300 uvt','24360303',10.00,0.00,0.00),('RETE025','Honorarios y comisiones (no declarantes)','24360301',10.00,0.00,0.00),('RETE027','Intereses o rendimientos financieros','24360701',7.00,0.00,0.00),('RETE028','Contratos de obra','243626',2.00,0.00,0.00),('ESTDEP','ESTAMPILLA FORMENTO AL DEPORTE 1.5%','24072213',15.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),('IMC001','Impuesto al Consumo','',8.00,0.00,0.00),('RETEICA07','Reteica Cemento,Manofacturas, Aserradero y Metales','24362703',7.00,0.00,0.00),('RETEICA05','Reteica Compras en Gral','24362701',5.00,0.00,0.00),('RETEICA10','Reteica Cigarrillo, Combustible','24362705',10.00,0.00,0.00),('ADULTOMAYOR','ESTAMPILLA DEL ADULTO MAYOR 4%','24072202',4.00,0.00,0.00),('RETEICA03','Rete ICA 0.3%','24362706',3.00,0.00,0.00),('uniamazonia','ESTAMPILLA UNIAMAZONIA .5','24072201',0.50,0.00,0.00),('ESTELECT','ESTAMPILLA DE ELECTRIFICACION RURAL 1%','24072210',1.00,0.00,0.00),('RETE029','Industria y Comercio 0.8%','24362704',8.00,0.00,0.00),('0','No aplica','',0.00,0.00,0.00),('RETE026','Servicio de Licenciamineto o Uso de Software','24360305',3.50,0.00,0.00),('procultura','ESTAMPILLA PROCULTURA 1.5','24072203',1.50,0.00,0.00),('RETEICA06','Reteica x Servicios en Gral','24362702',6.00,0.00,0.00);

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

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;

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

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

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

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;

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

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),(2022,1000000,117172);

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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


--
-- Table structure for table `saldosinventariogen`
--

CREATE TABLE `saldosinventariogen` (
  `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;

--
-- Dumping data for table `saldosinventariogen`
--


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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

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

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

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;

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

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

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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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

INSERT INTO `tico` (`ti_codtip`, `ti_descri`, `ti_numero`) VALUES (100,'Saldo Inicial',0),(101,'Facturas Servicios Publicos',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,'Compras y Ctas x Pagar',0),(112,'Comprobante de Egreso Adicional',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),(117,'Comprobante de Ingreso',0),(120,'Entrada Medidores OC',0),(121,'Entrada Devolutivos OC',0),(131,'Facturas de Portafolio',0),(132,'Recibos de Pago',0),(122,'Traslados Bancarios',0),(133,'Notas Credito Facturacion Saldo A favor',0),(140,'Pago Directos por cuenta',0),(129,'Avances',0),(170,'Depreciacion',0),(171,'Bajas de Inventario',0),(134,'Ajustes de Nomina',0);

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

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;

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

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',2),(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);

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

CREATE TABLE `tidocu` (
  `td_tidocu` char(2) NOT NULL,
  `td_descri` char(40) DEFAULT NULL,
  PRIMARY KEY (`td_tidocu`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `tidocu` (`td_tidocu`, `td_descri`) VALUES ('CC','Cedula de Ciudadania'),('CE','Cedula de Extranjeria'),('NI','NIT');

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

CREATE TABLE `timovto` (
  `tm_timovto` int(2) NOT NULL,
  `tm_descri` char(40) DEFAULT NULL,
  PRIMARY KEY (`tm_timovto`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

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'),(170,'Depreciacion'),(171,'Bajas de Inventario');

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

CREATE TABLE `tipcon` (
  `tc_codtic` char(3) NOT NULL,
  `tc_descri` char(40) DEFAULT NULL,
  PRIMARY KEY (`tc_codtic`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

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');

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

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;

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

INSERT INTO `tipveh` (`tv_tipveh`, `tv_descri`) VALUES (0,'No Aplica');

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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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

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'),('3001',0,0,'CAJA MENOR - GESTION ADMINISTRATIVA',0,NULL,NULL,NULL,NULL,'0','',NULL,NULL,0,0,NULL,NULL,NULL,NULL,'','',''),('3002',0,0,'CAJA MENOR - TECNICA',0,NULL,NULL,NULL,NULL,'0','',NULL,NULL,0,0,NULL,NULL,NULL,NULL,'','','');

--
-- Dumping events for database 'antsoftw_ricaurte_contable'
--

--
-- Dumping routines for database 'antsoftw_ricaurte_contable'
--


