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

INSERT INTO `cuentasban` (`cb_cuenta`, `cb_descri`, `cb_codigo`) VALUES ('-','NO APLICA',''),('1','PAGO POR CAJA','11050101'),('11100501	','BANCOLOMBIA CUENTA CORRIENTE No 71800000898','11100501	');

--
-- 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(15) 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,
  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`
--


--
-- 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,
  `cxp_soporte` varchar(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`
--

INSERT INTO `cxp` (`cxp_numero`, `cxp_codcli`, `cxp_nropla`, `cxp_codres`, `cxp_fecreg`, `cxp_horreg`, `cxp_vlrtot`, `cxp_descli`, `cxp_vlriva`, `cxp_vlretencion`, `cxp_vlreteica`, `cxp_vlretebom`, `cxp_vlreteiva`, `cxp_apagar`, `cxp_estado`, `cxp_tippag`, `cxp_pagado`, `cxp_observ`, `cxp_fecven`, `cxp_usuari`, `cxp_soporte`) VALUES (1,890700622,'1','1234644889','2021-01-04','03:15:38',3807200.00,0.00,0.00,0.00,0.00,0.00,0.00,3807200.00,'F','E',3807200.00,'GASTOS DE CONSTITUCIÓN','2021-01-04','1234644889','0'),(2,901372611,'1','1234644889','2021-01-15','03:23:51',5900.00,0.00,0.00,0.00,0.00,0.00,0.00,5900.00,'F','E',180000.00,'CERTIFICADO CONSTITUCION','2021-01-15','1234644889','018'),(3,901372611,'1','1234644889','2021-05-21','05:07:38',180000.00,0.00,0.00,0.00,0.00,0.00,0.00,180000.00,'F','T',180000.00,'ALQUILER SALA DE JUNTAS','2021-05-21','1234644889','0'),(4,93395024,'1','1234644889','2021-05-24','09:07:34',4514121.00,0.00,0.00,270847.00,0.00,0.00,0.00,4243274.00,'F','T',4243274.00,'REMODELACIÓN LOCAL','2021-05-24','1234644889','0'),(5,900277379,'1','1234644889','2021-01-18','10:00:03',157950.00,0.00,30010.50,0.00,0.00,0.00,0.00,187960.50,'F','T',157969.00,'COMPRA LAMPARAS','2021-01-18','1234644889','935');

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

CREATE TABLE `det_general` (
  `gen_id` int(11) NOT NULL,
  `det_cod` varchar(60) NOT NULL,
  `det_descripcion` varchar(200) NOT NULL,
  `det_aux` varchar(60) DEFAULT NULL,
  `det_estado` char(1) NOT NULL,
  PRIMARY KEY (`gen_id`,`det_cod`),
  KEY `IDX_GENID_DETCOL` (`gen_id`,`det_cod`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `det_general`
--

INSERT INTO `det_general` (`gen_id`, `det_cod`, `det_descripcion`, `det_aux`, `det_estado`) VALUES (1,'1','COMBUSTIBLES',NULL,'A'),(1,'10','ESTANDAR',NULL,'A'),(1,'2','EMISOR ES AUTORETENEDOR',NULL,'A'),(1,'3','EXCLUIDOS Y EXCENTOS',NULL,'A'),(1,'5','GENERICA',NULL,'A'),(1,'6','GENERICA CON PAGO ANTICIPADOS',NULL,'A'),(1,'7','GENERICA CON PERIODO DE FACTURACION',NULL,'A'),(1,'8','CONSORCIO',NULL,'A'),(1,'9','SERVICIOS AIU',NULL,'A'),(2,'1','CONTADO',NULL,'A'),(2,'2','CREDITO',NULL,'A'),(3,'1','INSTRUMENTO NO DEFINIDO',NULL,'A'),(3,'10','EFECTIVO',NULL,'A'),(3,'11','REVERSION CREDITO AHORRO',NULL,'A'),(3,'12','REVERSION DEBITO AHORRO',NULL,'A'),(3,'13','CREDITO AHORRO',NULL,'A'),(3,'14','DEBITO AHORRO',NULL,'A'),(3,'15','BOOKENTRY CREDITO',NULL,'A'),(3,'16','BOOKENTRY DEBITO',NULL,'A'),(3,'17','CONCENTRACION DE LA DEMANDA EN EFECTIVO DESEMBOLSO CREDITO CCD',NULL,'A'),(3,'18','CONCENTRACION DE LA DEMANDA EN EFECTIVO DESEMBOLSO CCD DEBITO',NULL,'A'),(3,'19','CREDITO PAGO NEGOCIO CORPORATIVO CTP',NULL,'A'),(3,'2','CREDITO ACH',NULL,'A'),(3,'20','CHEQUE',NULL,'A'),(3,'21','POYECTO BANCARIO',NULL,'A'),(3,'22','PROYECTO BANCARIO CERTIFICADO',NULL,'A'),(3,'23','CHEQUE BANCARIO',NULL,'A'),(3,'24','NOTA CAMBIARIA ESPERANDO ACEPTACION',NULL,'A'),(3,'25','CHEQUE CERTIFICADO',NULL,'A'),(3,'26','CHEQUE LOCAL',NULL,'A'),(3,'27','DEBITO PAGO NEOGCIO CORPORATIVO CTP',NULL,'A'),(3,'28','CREDITO NEGOCIO INTERCAMBIO CORPORATIVO CTX',NULL,'A'),(3,'29','DEBITO NEGOCIO INTERCAMBIO CORPORATIVO CTX',NULL,'A'),(3,'3','DEBITO ACH',NULL,'A'),(3,'30','TRANSFERECIA CREDITO',NULL,'A'),(3,'31','TRANSFERENCIA DEBITO',NULL,'A'),(3,'32','CONCENTRACION EFECTIVO DESEMBOLSO CREDITO PLUS CCD',NULL,'A'),(3,'33','CONCENTRACION EFECTIVO DESEMBOLSO DEBITO PLUS CCD',NULL,'A'),(3,'34','PAGO Y DEPOSITO PRE ACORDADO PPD',NULL,'A'),(3,'35','CONCENTRACION EFECTIVO AHORROS DESEMBOLSO CREDITO CCD',NULL,'A'),(3,'36','CONCENTRACION EFECTIVO AHORROS DESEMBOLSO DREDITO CCD',NULL,'A'),(3,'37','PAGO NEGOCIO CORPORATIVO AHORROS CREDITO CTP',NULL,'A'),(3,'38','PAGO NEOGCIO CORPORATIVO AHORROS DEBITO CTP',NULL,'A'),(3,'4','REVERSION DEBITO DEMANDA ACH',NULL,'A'),(3,'41','CONCENTRACION EFECTIVO DESEMBOLSO CREDITO PLUS CCD',NULL,'A'),(3,'42','CONSIGANCION BANCARIA',NULL,'A'),(3,'43','CONCENTRACION EFECTIVO DESEMBOLSO DEBITO PLUS CCD',NULL,'A'),(3,'44','NOTA CAMBIARIA',NULL,'A'),(3,'45','TRANSFERENCIA CREDITO BANCARIO',NULL,'A'),(3,'46','TRANSFERENCIA DEBITO INTERBANCARIO',NULL,'A'),(3,'47','TRANSFERENCIA DEBITO BANCARIA',NULL,'A'),(3,'48','TARJETA CREDITO',NULL,'A'),(3,'49','DEBITO',NULL,'A'),(3,'5','REVERSION CREDITO DEMANDA ACH',NULL,'A'),(3,'50','POSTGIRO',NULL,'A'),(3,'51','TELEX ESTANDAR BANCARIO FRANCES',NULL,'A'),(3,'52','PAGO COMERCIAL URGENTE',NULL,'A'),(3,'53','PAGO TESORERIA URGENTE',NULL,'A'),(3,'6','CRÉDITO DE DEMANDA ACH',NULL,'A'),(3,'60','PROMISORIA',NULL,'A'),(3,'61','NOTA PROMISORIA FIRMADA POR EL ACREEDOR',NULL,'A'),(3,'62','NOTA PROMISORIA FIRMADA POR EL ACREEDOR AVALADA POR EL BANCO',NULL,'A'),(3,'63','NOTA PROMISORIA FIRMADA POR EL ACREEDOR AVALADA POR UN TERCERO',NULL,'A'),(3,'64','NOTA PROMISORIA FIRMADA PRO EL BANCO',NULL,'A'),(3,'65','NOTA PROMISORIA FIRMADA POR UN BANCO AVALADA POR OTRO BANCO',NULL,'A'),(3,'66','NOTA PROMISORIA FIRMADA',NULL,'A'),(3,'67','NOTA PROMISORIA FIRMADA POR UN TERCERO AVALADA POR UN BANCO',NULL,'A'),(3,'7','DEBITO DE DEMANDA ACH',NULL,'A'),(3,'70','RETIRO DE NOTA POR EL POR EL ACREEDOR',NULL,'A'),(3,'74','RETIRO DE NOTA POR EL POR EL ACREEDOR SOBRE UN BANCO',NULL,'A'),(3,'75','PAGO RETIRO DE NOTA POR EL ACREEDOR AVALADA POR OTRO BANCO',NULL,'A'),(3,'76','RETIRO DE NOTA POR EL ACREEDOR SOBRE UN BANCO AVALADA POR UN TERCERO',NULL,'A'),(3,'77','RETIRO DE UNA NOTA POR EL ACREEDOR SOBRE UN TERCERO',NULL,'A'),(3,'78','RETIRO DE UNA NOTA POR EL ACREEDOR SOBRE UN AVALADA POR UN BANCO',NULL,'A'),(3,'8','MANTENER',NULL,'A'),(3,'9','CLEARING NACIONAL O REGIONAL',NULL,'A'),(3,'91','NOTA BANCARIA TRANFERIBLE',NULL,'A'),(3,'92','CHEQUE LOCAL TRAFERIBLE',NULL,'A'),(3,'93','GIRO REFERENCIADO',NULL,'A'),(3,'94','GIRO URGENTE',NULL,'A'),(3,'95','GIRO FORMATO ABIERTO',NULL,'A'),(3,'96','METODO DE PAGO SOLICITADO NO USUADO',NULL,'A'),(3,'97','CLEARING ENTRE PARTNERS',NULL,'A'),(4,'0','NO TIENE RETENCIONES',NULL,'A'),(4,'5','RETEIVA',NULL,'A'),(4,'6','RETEFUENTE',NULL,'A'),(4,'7','RETEICA',NULL,'A'),(5,'1','PERSONA JURIDICA',NULL,'A'),(5,'2','PERSONA NATURAL',NULL,'A'),(6,'0','SIMPLIFICADO',NULL,'A'),(6,'2','COMUN',NULL,'A'),(7,'11','REGISTRO_CIVIL',NULL,'A'),(7,'12','TARJETA DE IDENTIDAD',NULL,'A'),(7,'13','CEDULA CIUDADANIA',NULL,'A'),(7,'21','TARJETA DE EXTRANJERIA',NULL,'A'),(7,'22','CEDULA DE EXTRANJERIA',NULL,'A'),(7,'31','NIT',NULL,'A'),(7,'41','PASAPORTE',NULL,'A'),(7,'42','DOCUMENTO DE IDENTIFICACION EXTRANJERO',NULL,'A'),(8,'0','NO_ES_REGALO',NULL,'A'),(8,'1','REFERENCIA VALOR COMERCIAL',NULL,'A'),(8,'2','VALOR EN INVENTARIOS',NULL,'A'),(8,'3','OTRO VALOR',NULL,'A'),(9,'01','IVA',NULL,'A'),(9,'02','IMPUESTO AL CONSUMO',NULL,'A'),(9,'03','ICA',NULL,'A'),(9,'04','IMPUESTO NACIONAL AL CONSUMO',NULL,'A'),(10,'00','DESCUENTO POR IMPUESTO ASUMIDO',NULL,'A'),(10,'01','PAGUE UNO LLEVE OTRO',NULL,'A'),(10,'02','DESCUENTOS CONTRACTUALES',NULL,'A'),(10,'03','DESCUENTO POR PRONTO PAGO',NULL,'A'),(10,'04','ENVÍO GRATIS',NULL,'A'),(10,'05','DESCUENTOS ESPECÍFICOS POR INVENTARIOS',NULL,'A'),(10,'06','DESCUENTO POR MONTO DE COMPRAS',NULL,'A'),(10,'07','DESCUENTO DE TEMPORADA',NULL,'A'),(10,'08','DESCUENTO POR ACTUALIZACIÓN DE PRODUCTOS SERVICIOS',NULL,'A'),(10,'09','DESCUENTO GENERAL',NULL,'A'),(10,'10','DESCUENTO POR VOLUMEN',NULL,'A'),(10,'11','OTRO DESCUENTO',NULL,'A'),(10,'99','DESCUENTO NO APLICA',NULL,'A'),(11,'1','IVA',NULL,'A'),(11,'2','IMPUESTO AL CONSUMO',NULL,'A'),(11,'3','ICA',NULL,'A'),(11,'4','IMPUESTO NACIONAL AL CONSUMO',NULL,'A'),(12,'1','GASTOS X SALARIO','51050605-51054205','A'),(12,'10','CESANTIAS E INTERESES','25101005-25150505','A'),(12,'11','PENSIONES DE JUBILACION','0','A'),(12,'12','APORTES OBLIG X SALUD','23700505','A'),(12,'13','APORTES OBLIG X PENSION','23803005','A'),(12,'14','APORTES VOLUNT A PENSION','0','A'),(12,'15','APORTES AFC','0','A'),(12,'16','ING ARRENDAMIENTOS','51201005-51204005','A'),(12,'17','ING HONORARIOS','51109501-51109504','A'),(12,'18','ING INTERESES','53052005','A'),(12,'19','ING ENAJENACION','0','A'),(12,'2','GASTOS X HONORARIOS','51109501-51109503','A'),(12,'20','ING LOTERIAS','0','A'),(12,'21','ING OTROS','0','A'),(12,'22','EGRE ARRENDAMIENTOS','23653005-23653010','A'),(12,'23','EGRE HONORARIOS','23651505-23651510','A'),(12,'24','EGRE INTERESES','23653505','A'),(12,'25','EGRE ENAJENACION','0','A'),(12,'26','EGRE LOTERIAS','0','A'),(12,'27','EGRE OTROS','0','A'),(12,'3','GASTOS X SERVICIO','51451505-51501501','A'),(12,'4','GASTOS X COMISIONES','51109504','A'),(12,'5','GASTOS X PREST. SOCIALES','23700505','A'),(12,'6','GASTOS X VIATICOS','51550501-51559505','A'),(12,'7','GASTOS DE REPRESENTACION','0','A'),(12,'8','GASTOS X TRABAJO COOPERATIVO','0','A'),(12,'9','OTROS PAGOS','51054505','A');

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

INSERT INTO `detcom` (`dc_numero`, `dc_codcon`, `dc_codigo`, `dc_cantid`, `dc_vlruni`, `dc_vlriva`, `dc_vlrtot`, `observacion`) VALUES (1,100111,0,50.00,79000.00,750500.00,3950000.00,'');

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

CREATE TABLE `detcxp` (
  `dcxp_numero` int(9) NOT NULL,
  `dcxp_codcon` int(4) NOT NULL,
  `dcxp_conse` int(11) 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,
  `dcxp_base` 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`
--

INSERT INTO `detcxp` (`dcxp_numero`, `dcxp_codcon`, `dcxp_conse`, `dcxp_cantid`, `dcxp_vlruni`, `dcxp_vlrtot`, `dcxp_pagos`, `dcxp_detalle`, `dcxp_iva`, `dcxp_retencion`, `dcxp_reteica`, `dcxp_retebom`, `dcxp_reteiva`, `dcxp_vlriva`, `dcxp_vlretencion`, `dcxp_vlreteica`, `dcxp_vlretebom`, `dcxp_vlreteiva`, `dcxp_vlrcxp`, `dcxp_base`) VALUES (1,111,1,1.00,3807200.00,3807200.00,3807200.00,'GASTOS DE CONSTITUCIÓN','0','','','','',0.00,0.00,0.00,0.00,0.00,3807200.00,0.00),(2,111,1,1.00,5900.00,5900.00,0.00,'CERTIFICADO CONSTITUCION','0','','','','',0.00,0.00,0.00,0.00,0.00,5900.00,0.00),(3,201,1,4.00,45000.00,180000.00,0.00,'ALQUILER SALA DE JUNTAS','','','','','',0.00,0.00,0.00,0.00,0.00,180000.00,180000.00),(4,202,1,1.00,4514121.00,4514121.00,4243274.00,'REMODELACIÓN LOCAL MILLENIUM ','','14','','','',0.00,270847.00,0.00,0.00,0.00,4243274.00,4514121.00),(5,99999999,1,5.00,31590.00,157950.00,157969.00,'COMPRA LAMPARAS','19','','','','',30010.50,0.00,0.00,0.00,0.00,187960.50,157950.00);

--
-- 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=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `detfac` (`df_numero`, `df_codcon`, `df_cantid`, `df_vlruni`, `df_vlriva`, `df_vlrtot`, `df_pagos`, `df_detalle`) VALUES (990000001,26,1.00,100000.00,0.00,100000.00,0.00,'PRUEBA');

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

INSERT INTO `detfe` (`dfe_numero`, `dfe_codcon`, `dfe_cantid`, `dfe_vlruni`, `dfe_vlrtot`, `dfe_pagos`, `dfe_detalle`, `dfe_iva`, `dfe_vlriva`, `dfe_vlrfe`) VALUES (1,101,1.00,120000.00,120000.00,0.00,'SERV DE TELEFONIA CELULAR ','0',0.00,120000.00),(2,101,4.00,45000.00,180000.00,0.00,'ALQUILER SALA DE JUNTAS','',0.00,180000.00),(3,201,4.00,45000.00,180000.00,0.00,'ALQUILER SALA DE JUNTAS','',0.00,180000.00),(4,202,1.00,4514121.00,4514121.00,0.00,'REMODELACIÓN LOCAL','',14.00,4514121.00);

--
-- 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 `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 (2021021,1234644889,28,2566.67),(2021021,1234644889,27,21388.03),(2021021,1234644889,26,10695.30),(2021021,1234644889,25,21388.03),(2021021,1234644889,24,1339.80),(2021021,1234644889,21,10266.67),(2021021,1234644889,18,30800.00),(2021021,1234644889,15,10266.67),(2021021,1234644889,14,10266.67),(2021021,1234644889,5,24839.27),(2021021,1234644889,1,256666.67),(2021021,1110529679,28,2166.67),(2021021,1110529679,27,18054.83),(2021021,1110529679,26,9028.50),(2021021,1110529679,25,18054.83),(2021021,1110529679,24,15080.00),(2021021,1110529679,21,8666.67),(2021021,1110529679,18,26000.00),(2021021,1110529679,15,8666.67),(2021021,1110529679,14,8666.67),(2021021,1110529679,5,17742.33),(2021021,1110529679,1,216666.67),(2021022,1234644889,28,5500.00),(2021022,1234644889,27,45815.00),(2021022,1234644889,26,22918.50),(2021022,1234644889,25,45815.00),(2021022,1234644889,24,2871.00),(2021022,1234644889,21,22000.00),(2021022,1234644889,18,66000.00),(2021022,1234644889,15,22000.00),(2021022,1234644889,14,22000.00),(2021022,1234644889,5,53227.00),(2021022,1234644889,1,550000.00),(2021022,1110529679,27,54145.00),(2021022,1110529679,26,27085.50),(2021022,1110529679,25,54145.00),(2021022,1110529679,24,45240.00),(2021022,1110529679,21,26000.00),(2021022,1110529679,18,78000.00),(2021022,1110529679,15,26000.00),(2021022,1110529679,14,26000.00),(2021022,1110529679,105,180000.00),(2021022,1110529679,5,53227.00),(2021022,1110529679,1,650000.00),(2021022,1110529679,28,6500.00),(2021031,1110529679,1,650000.00),(2021031,1110529679,5,53227.00),(2021031,1110529679,14,26000.00),(2021031,1110529679,15,26000.00),(2021031,1110529679,18,78000.00),(2021031,1110529679,21,26000.00),(2021031,1110529679,24,45240.00),(2021031,1110529679,25,54145.00),(2021031,1110529679,26,27085.50),(2021031,1110529679,27,54145.00),(2021031,1110529679,28,6500.00),(2021031,1234644889,1,550000.00),(2021031,1234644889,5,53227.00),(2021031,1234644889,14,22000.00),(2021031,1234644889,15,22000.00),(2021031,1234644889,18,66000.00),(2021031,1234644889,21,22000.00),(2021031,1234644889,24,2871.00),(2021031,1234644889,25,45815.00),(2021031,1234644889,26,22918.50),(2021031,1234644889,27,45815.00),(2021031,1234644889,28,5500.00),(2021032,1110529679,1,650000.00),(2021032,1110529679,5,53227.00),(2021032,1110529679,105,200000.00),(2021032,1110529679,14,26000.00),(2021032,1110529679,15,26000.00),(2021032,1110529679,18,78000.00),(2021032,1110529679,21,26000.00),(2021032,1110529679,24,45240.00),(2021032,1110529679,25,54145.00),(2021032,1110529679,26,27085.50),(2021032,1110529679,27,54145.00),(2021032,1110529679,28,6500.00),(2021032,1234644889,1,550000.00),(2021032,1234644889,5,53227.00),(2021032,1234644889,14,22000.00),(2021032,1234644889,15,22000.00),(2021032,1234644889,18,66000.00),(2021032,1234644889,21,22000.00),(2021032,1234644889,24,2871.00),(2021032,1234644889,25,45815.00),(2021032,1234644889,26,22918.50),(2021032,1234644889,27,45815.00),(2021032,1234644889,28,5500.00),(2021041,1234644889,25,45815.00),(2021041,1234644889,24,2871.00),(2021041,1234644889,21,22000.00),(2021041,1234644889,18,66000.00),(2021041,1234644889,15,22000.00),(2021041,1234644889,14,22000.00),(2021041,1234644889,5,53227.00),(2021041,1234644889,1,550000.00),(2021041,1110473481,28,4333.33),(2021041,1110473481,27,36109.67),(2021041,1110473481,26,18057.00),(2021041,1110473481,25,36109.67),(2021041,1110473481,24,30160.00),(2021041,1110473481,21,17333.33),(2021041,1110473481,18,52000.00),(2021041,1110473481,15,17333.33),(2021041,1110473481,14,17333.33),(2021041,1110473481,105,200000.00),(2021041,1110473481,5,35484.67),(2021041,1110473481,1,433333.33),(2021041,1234644889,26,22918.50),(2021041,1234644889,27,45815.00),(2021041,1234644889,28,5500.00),(2021042,1110473481,5,53227.00),(2021042,1110473481,105,166666.00),(2021042,1110473481,28,6500.00),(2021042,1110473481,14,26000.00),(2021042,1110473481,15,26000.00),(2021042,1110473481,18,78000.00),(2021042,1110473481,21,26000.00),(2021042,1110473481,24,45240.00),(2021042,1110473481,25,54145.00),(2021042,1110473481,26,27085.50),(2021042,1110473481,1,650000.00),(2021042,1110473481,27,54145.00),(2021042,1234644889,1,550000.00),(2021042,1234644889,5,53227.00),(2021042,1234644889,201,64167.00),(2021042,1234644889,14,22000.00),(2021042,1234644889,15,22000.00),(2021042,1234644889,18,66000.00),(2021042,1234644889,21,22000.00),(2021042,1234644889,24,2871.00),(2021042,1234644889,25,45815.00),(2021042,1234644889,26,22918.50),(2021042,1234644889,27,45815.00),(2021042,1234644889,28,5500.00),(2021051,1110473481,1,650000.00),(2021051,1110473481,5,53227.00),(2021051,1110473481,14,26000.00),(2021051,1110473481,15,26000.00),(2021051,1110473481,18,78000.00),(2021051,1110473481,21,26000.00),(2021051,1110473481,24,45240.00),(2021051,1110473481,25,54145.00),(2021051,1110473481,26,27085.50),(2021051,1110473481,27,54145.00),(2021051,1110473481,28,6500.00),(2021051,1234644889,1,550000.00),(2021051,1234644889,5,53227.00),(2021051,1234644889,14,22000.00),(2021051,1234644889,15,22000.00),(2021051,1234644889,18,66000.00),(2021051,1234644889,21,22000.00),(2021051,1234644889,24,2871.00),(2021051,1234644889,25,45815.00),(2021051,1234644889,26,22918.50),(2021051,1234644889,27,45815.00),(2021051,1234644889,28,5500.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(12) 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`
--

INSERT INTO `detmovto` (`dmo_tipcom`, `dmo_numero`, `dmo_secuen`, `dmo_codcta`, `dmo_tercer`, `dmo_auxili`, `dmo_codtic`, `dmo_detall`, `dmo_cheque`, `dmo_codcen`, `dmo_tipmov`, `dmo_vlrmov`, `dmo_fecreg`, `dmo_codemp`) VALUES (100,2,1,'320403',14239866,0,'SI','SALDOS INCICIALES APORTE SOCIO','',0,2,15000000.00,'2021-01-15','1234644889'),(100,2,10,'320403',901390708,0,'SI','SALDOS INCICIALES APORTE SOCIO','',0,2,15000000.00,'2021-01-15','1234644889'),(100,2,2,'320403',93400620,0,'SI','SALDOS INCICIALES APORTE SOCIO','',0,2,15000000.00,'2021-01-15','1234644889'),(100,2,11,'320403',17314286,0,'SI','SALDOS INCICIALES APORTE SOCIO','',0,2,15000000.00,'2021-01-15','1234644889'),(100,2,8,'110501',0,0,'SI','SALDOS INCICIALES APORTE SOCIO','',0,1,16000000.00,'2021-01-15','1234644889'),(100,2,9,'11100501',0,0,'SI','SALDOS INCICIALES APORTE SOCIO','',0,1,44000000.00,'2021-01-15','1234644889'),(109,1,1,'24903101',890700622,1,'CXP','GASTOS DE CONSTITUCIÓN','0',0,2,3807200.00,'2021-01-04','12346448'),(109,1,2,'51116401',890700622,1,'CXP','GASTOS DE CONSTITUCIÓN','0',0,1,3807200.00,'2021-01-04','12346448'),(109,2,2,'51116401',901372611,1,'CXP','CERTIFICADO CONSTITUCION','0',0,1,5900.00,'2021-01-15','asexis'),(109,2,1,'24903101',901372611,1,'CXP','CERTIFICADO CONSTITUCION','0',0,2,5900.00,'2021-01-15','asexis'),(109,3,1,'19059002',901372611,1,'CXP','ALQUILER SALA DE JUNTAS','',0,1,180000.00,'2021-05-21','12346448'),(109,3,2,'24906301',901372611,1,'CXP','ALQUILER SALA DE JUNTAS','',0,2,180000.00,'2021-05-21','12346448'),(109,4,1,'19059002',93395024,1,'CXP','REMODELACIÓN LOCAL','',0,1,4514121.00,'2021-05-24','12346448'),(109,4,2,'24360501',93395024,1,'CXP','REMODELACIÓN LOCAL','',0,2,270847.00,'2021-05-24','12346448'),(109,4,3,'24905501',93395024,1,'CXP','REMODELACIÓN LOCAL','',0,2,4243274.00,'2021-05-24','12346448'),(110,5,1,'24010101',900277379,1,'RC','Cancelacion COMPRA LAMPARAS','5 - 0',0,1,0.00,'2021-01-18','12346448'),(109,5,1,'24010101',900277379,1,'CXP','COMPRA LAMPARAS','',0,2,30010.50,'2021-01-18','12346448'),(118,1,1,'510124',0,1,'CAU','Nomina del 2021041','',0,1,106000.00,'2021-05-26','1234644889'),(118,1,2,'251114',1110473481,1,'CAU','Nomina del 2021041','',0,2,106000.00,'2021-05-26','1234644889');

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

INSERT INTO `detmovto_niif` (`dmo_tipcom`, `dmo_numero`, `dmo_secuen`, `dmo_codcta`, `dmo_tercer`, `dmo_auxili`, `dmo_codtic`, `dmo_detall`, `dmo_cheque`, `dmo_codcen`, `dmo_tipmov`, `dmo_vlrmov`, `dmo_fecreg`, `dmo_codemp`, `dmo_revela`) VALUES (100,1,1,'320403',0,0,'SI','SALDOS INCICIALES APORTE SOCIO','',0,1,15000000.00,'2021-05-07','12346448',' ');

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

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


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

INSERT INTO `detped` (`dp_numero`, `dp_codcon`, `dp_cantid`, `dp_vlruni`, `dp_vlrtot`, `dp_detalle`) VALUES (1,26,1.00,100000.00,100000.00,'PRUEBA');

--
-- 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(11) 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,
  `dp_base` 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`
--

INSERT INTO `detpedcom` (`dpc_numero`, `dpc_codcon`, `dpc_cantid`, `dpc_vlruni`, `dpc_vlrtot`, `dpc_iva`, `observacion`) VALUES (1,100110,50.00,1452.00,72600.00,0.00,''),(2,100111,50.00,79000.00,3950000.00,19.00,'ELEMENTOS DE MEDICIÓN'),(3,100111,50.00,79000.00,3950000.00,19.00,'ELEMENTOS DE MEDICIÓN');

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

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


--
-- 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_conse` int(11) 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_conse`,`dpr_nrofac`),
  KEY `dpr_codcon` (`dpr_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `detpedrec` (`dpr_numero`, `dpr_codcon`, `dpr_conse`, `dpr_nrofac`, `dpr_vlrtot`, `dpr_detalle`) VALUES (3,201,1,3,180000.00,'ALQUILER SALA DE JUNTAS'),(4,202,1,4,4243274.00,'REMODELACIÓN LOCAL'),(3,111,1,3,5900.00,'ALQUILER SALA DE JUNTAS'),(2,111,1,2,5900.00,'ALQUILER SALA DE JUNTAS'),(5,99999999,1,5,157950.00,'COMPRA LAMPARAS');

--
-- 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` float(9,2) DEFAULT NULL,
  `dps_vlruni` float(9,2) NOT NULL,
  `dps_vlrtot` float(9,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 `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_conse` int(11) 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_conse`,`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`
--

INSERT INTO `detrecibosp` (`dr_numero`, `dr_codcon`, `dr_conse`, `dr_nrofac`, `dr_vlrtot`, `dr_detalle`) VALUES (1,111,1,1,3807200.00,'GASTOS DE CONSTITUCIÓN'),(2,101,1,2,180000.00,'ALQUILER SALA DE JUNTAS'),(3,201,1,3,180000.00,'ALQUILER SALA DE JUNTAS'),(4,202,1,4,4243274.00,'REMODELACIÓN LOCAL'),(5,99999999,1,5,157969.00,'COMPRA LAMPARAS');

--
-- 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` float(9,2) DEFAULT NULL,
  `ds_vlruni` int(9) DEFAULT NULL,
  `ds_vlriva` int(9) DEFAULT NULL,
  `ds_vlrtot` int(9) DEFAULT NULL,
  PRIMARY KEY (`ds_tipo_sa`,`ds_numero`,`ds_codcon`),
  KEY `ds_codcon` (`ds_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


--
-- 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`),
  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 `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`
--


--
-- 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(15,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,
  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`) VALUES (1234644889,'KEVIN STEWE GARCIA LOZADA','CALLE 64 N0 20-89','3207872406','S',0,800251440,800130907,800224808,890700148,0,1,'1999-07-11','2021-02-09',1100000.00,'A','','','91218576325','F','1',0.52200,'1','F','0000-00-00'),(1110529679,'CESAR AUGUSTO RINCON OCAMPO','','3208190541','S',0,900156264,800088702,800224808,890700148,101,2,'0000-00-00','2021-02-11',1300000.00,'I','B','','597-032906-25','','1',6.96000,'61','F','0000-00-00'),(1110473481,'JORGE WILSON ALZATE FERIA','','3132683994','',0,900156264,800088702,800224808,890700148,101,2,'2021-06-28','2021-04-05',1300000.00,'A','','','','I','1',6.96000,'61','F','0000-00-00');

--
-- 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(15,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,
  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`) VALUES (2021021,1234644889,'KEVIN STEWE GARCIA LOZADA','CALLE 64 N0 20-89','3207872406','S',0,800251440,800130907,800224808,890700148,0,1,'1999-07-11','2021-02-09',1100000.00,'A','','','91218576325','F','1',0.52200,'1','F','0000-00-00'),(2021021,1110529679,'CESAR AUGUSTO RINCON OCAMPO','','3208190541','S',0,900156264,800088702,800224808,890700148,101,2,'0000-00-00','2021-02-11',1300000.00,'A','B','','597-032906-25','','1',6.96000,'61','F','0000-00-00'),(2021022,1234644889,'KEVIN STEWE GARCIA LOZADA','CALLE 64 N0 20-89','3207872406','S',0,800251440,800130907,800224808,890700148,0,1,'1999-07-11','2021-02-09',1100000.00,'A','','','91218576325','F','1',0.52200,'1','F','0000-00-00'),(2021022,1110529679,'CESAR AUGUSTO RINCON OCAMPO','','3208190541','S',0,900156264,800088702,800224808,890700148,101,2,'0000-00-00','2021-02-11',1300000.00,'A','B','','597-032906-25','','1',6.96000,'61','M','0000-00-00'),(2021031,1234644889,'KEVIN STEWE GARCIA LOZADA','CALLE 64 N0 20-89','3207872406','S',0,800251440,800130907,800224808,890700148,0,1,'1999-07-11','2021-02-09',1100000.00,'A','','','91218576325','F','1',0.52200,'1','F','0000-00-00'),(2021031,1110529679,'CESAR AUGUSTO RINCON OCAMPO','','3208190541','S',0,900156264,800088702,800224808,890700148,101,2,'0000-00-00','2021-02-11',1300000.00,'A','B','','597-032906-25','','1',6.96000,'61','M','0000-00-00'),(2021032,1234644889,'KEVIN STEWE GARCIA LOZADA','CALLE 64 N0 20-89','3207872406','S',0,800251440,800130907,800224808,890700148,0,1,'1999-07-11','2021-02-09',1100000.00,'A','','','91218576325','F','1',0.52200,'1','F','0000-00-00'),(2021032,1110529679,'CESAR AUGUSTO RINCON OCAMPO','','3208190541','S',0,900156264,800088702,800224808,890700148,101,2,'0000-00-00','2021-02-11',1300000.00,'A','B','','597-032906-25','','1',6.96000,'61','M','0000-00-00'),(2021041,1234644889,'KEVIN STEWE GARCIA LOZADA','CALLE 64 N0 20-89','3207872406','S',0,800251440,800130907,800224808,890700148,0,1,'1999-07-11','2021-02-09',1100000.00,'A','','','91218576325','F','1',0.52200,'1','F','0000-00-00'),(2021041,1110473481,'JORGE WILSON ALZATE FERIA','','3132683994','',0,900156264,800088702,800224808,890700148,101,2,'2021-06-28','2021-04-05',1300000.00,'A','','','','I','1',6.96000,'61','F','0000-00-00'),(2021042,1234644889,'KEVIN STEWE GARCIA LOZADA','CALLE 64 N0 20-89','3207872406','S',0,800251440,800130907,800224808,890700148,0,1,'1999-07-11','2021-02-09',1100000.00,'A','','','91218576325','F','1',0.52200,'1','F','0000-00-00'),(2021042,1110473481,'JORGE WILSON ALZATE FERIA','','3132683994','',0,900156264,800088702,800224808,890700148,101,2,'2021-06-28','2021-04-05',1300000.00,'A','','','','I','1',6.96000,'61','F','0000-00-00'),(2021051,1234644889,'KEVIN STEWE GARCIA LOZADA','CALLE 64 N0 20-89','3207872406','S',0,800251440,800130907,800224808,890700148,0,1,'1999-07-11','2021-02-09',1100000.00,'A','','','91218576325','F','1',0.52200,'1','F','0000-00-00'),(2021051,1110473481,'JORGE WILSON ALZATE FERIA','','3132683994','',0,900156264,800088702,800224808,890700148,101,2,'2021-06-28','2021-04-05',1300000.00,'A','','','','I','1',6.96000,'61','F','0000-00-00');

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

CREATE TABLE `empresa` (
  `ep_codemp` char(12) NOT NULL DEFAULT '',
  `ep_nombre` char(70) NOT NULL,
  `ep_direcc` char(70) NOT NULL,
  `ep_telefo` char(25) NOT NULL DEFAULT '',
  PRIMARY KEY (`ep_codemp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `empresa` (`ep_codemp`, `ep_nombre`, `ep_direcc`, `ep_telefo`) VALUES ('901445146-5','GASO COLOMBIA S.A.S. E.S.P.','CR 7 CL 65 B CONJ. MILENIUM LC -1','3235726291');

--
-- 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',''),(800130907,'SALUD TOTAL','SALUD TOTAL','EPS002'),(800140949,'CAFESALUD','CAFESALUD','EPS003'),(890480023,'COMFENALCO','',''),(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','',''),(892200015,'COMFASUCRE','COMFASUCRE',''),(806008394,'MUTUAL SER','MUTUAL SER',''),(860002183,'COLPATRIA','COLPATRIA','14-4'),(890300279,'BANCO DE OCCIDENTE','BANCO DE OCCIDENTE',''),(800088702,'EPS SURA','EPS SURA',''),(890101994,'COMFAMILIAR DEL ATLANTICO','','9'),(860011153,'POSITIVA COMPAÑIA DE SEGUROS','',''),(804002105,'COMPARTA E.P.S.','',''),(901097473,'MEDIMAS','',''),(800249241,'COOPSALUD E.S.S CARTAGENA','COOPSALUD E.S.S CARTAGENA',''),(818000140,'AMBUQ ESS','AMBUQ ESS','ESSC76');

--
-- 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,
  `exo_col10` double(15,2) NOT NULL,
  `exo_col11` double(15,2) NOT NULL,
  `exo_col12` double(15,2) NOT NULL,
  `exo_col13` 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,
  `fa_cufe` text NOT NULL,
  `fa_id` varchar(50) NOT NULL,
  `fa_url_representacion_grafica` text NOT NULL,
  `fa_pagueaqui` text NOT NULL,
  `fa_descuento` double(15,2) NOT NULL,
  `fa_total` double(15,2) NOT NULL,
  PRIMARY KEY (`fa_numero`),
  KEY `fa_codcli` (`fa_codcli`),
  KEY `fa_nropla` (`fa_nropla`),
  KEY `fa_codres` (`fa_codres`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `facturas` (`fa_numero`, `fa_codcli`, `fa_nropla`, `fa_codres`, `fa_fecreg`, `fa_horreg`, `fa_vlrtot`, `fa_descli`, `fa_vlriva`, `fa_apagar`, `fa_estado`, `fa_tippag`, `fa_pagado`, `fa_cufe`, `fa_id`, `fa_url_representacion_grafica`, `fa_pagueaqui`, `fa_descuento`, `fa_total`) VALUES (990000001,800053720,'-','jmorales','2021-05-18','04:25:49',100000.00,0.00,0.00,100000.00,'F','C',0.00,'','','','PRUEBA',0.00,100000.00);

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


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

INSERT INTO `fe` (`fe_numero`, `fe_codcli`, `fe_codpro`, `fe_nropla`, `fe_codres`, `fe_fecreg`, `fe_horreg`, `fe_vlrtot`, `fe_descli`, `fe_vlriva`, `fe_apagar`, `fe_estado`, `fe_tippag`, `fe_pagado`, `fe_observ`, `fe_fecven`, `fe_usuari`) VALUES (1,14236203,0,'1','asexis','2021-05-06','10:31:40',120000.00,0.00,0.00,120000.00,'F','E',0.00,'ERV DE TELEFONIA CELULAR','2021-05-06','asexis'),(2,901372611,900586384,'1','1234644889','2021-01-15','03:23:51',180000.00,0.00,0.00,180000.00,'F','E',0.00,'ALQUILER SALA DE JUNTAS','2021-01-15','1234644889'),(3,901372611,900586384,'1','1234644889','2021-05-21','05:07:39',180000.00,0.00,0.00,180000.00,'F','T',0.00,'ALQUILER SALA DE JUNTAS','2021-05-21','1234644889'),(4,93395024,900586384,'1','1234644889','2021-05-24','09:07:34',4514121.00,0.00,0.00,4243274.00,'F','T',0.00,'REMODELACIÓN LOCAL','2021-05-24','1234644889');

--
-- Table structure for table `general`
--

CREATE TABLE `general` (
  `coid` int(11) NOT NULL,
  `conombre` varchar(200) NOT NULL,
  `comodulo` varchar(4) NOT NULL,
  `coestado` char(1) NOT NULL,
  PRIMARY KEY (`coid`),
  UNIQUE KEY `IDX_U_GENERAL` (`conombre`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `general`
--

INSERT INTO `general` (`coid`, `conombre`, `comodulo`, `coestado`) VALUES (1,'TIPOS DE FACTURA','FACE','A'),(2,'MÉTODOS DE PAGO','FACE','A'),(3,'MEDIOS DE PAGO','FACE','A'),(4,'RETENCIONES','FACE','A'),(5,'TIPO DE CONTRIBUYENTE','FACE','A'),(6,'TIPO DE RÉGIMEN','FACE','A'),(7,'TIPO DE IDENTIFICACIÓN','FACE','A'),(8,'REGALO','FACE','A'),(9,'IMPUESTO','FACE','A'),(10,'DESCUENTOS','FACE','A'),(11,'IMPUESTO DETALLE','FACE','A'),(12,'FORM INGRESOS Y RETENCIONES','CONT','A');

--
-- 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,
  PRIMARY KEY (`gr_codgru`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `grupo` (`gr_codgru`, `gr_descri`) VALUES (11,'INGRESOS'),(12,'GASTOS'),(51,'Regulador pilotado '),(3,'TANQUES'),(4,'MEDIDORES DE GAS'),(5,'REGULADORES'),(6,'MATERIALES Y ACCESORIOS'),(7,'HERRAMIENTAS'),(8,'ELEMENTOS DE CONSUMO'),(31,'Tanques nuevos'),(32,'Tanques usados'),(311,'Tanques nuevos de 500 galones'),(312,'Tanques nuevos de 1000 galones'),(321,'Tanques usados de 500 galones'),(322,'Tanques usados de 1000 galones'),(2,'GLP'),(41,'Medidores G 1.6'),(61,'Codos'),(62,'Elevadores'),(63,'Universales'),(64,'Niples'),(65,'Valvulas'),(66,'Reducciones'),(67,'Manometros'),(68,'Fistos'),(69,'Trenzas'),(52,'Regulador de unica etapa'),(53,'Regulador de primera etapa'),(54,'Regulador de segunda etapa'),(71,'Machete'),(81,'Pinturas '),(82,'Cintas'),(83,'Lija '),(84,'Glicerina');

--
-- 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 (1,'ADMINISTRATIVOS '),(2,'OPERATIVOS Y TECNICOS'),(5,'COMERCIAL'),(8,'APRENDICES SENA'),(4,'GESTION  CORPORATIVA'),(6,'GESTION CORPORATIVA TM');

--
-- 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,
  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`) VALUES (2021021,1110529679,14,5.00,'2021-05-20','1234644889'),(2021021,1234644889,14,7.00,'2021-05-20','1234644889'),(2021021,1110529679,1,5.00,'2021-05-20','1234644889'),(2021021,1234644889,1,7.00,'2021-05-20','1234644889'),(2021022,1234644889,105,15.00,'2021-05-20','1234644889'),(2021041,1110473481,14,10.00,'2021-05-22','1234644889'),(2021041,1110473481,1,10.00,'2021-05-22','1234644889');

--
-- 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` float(9,2) DEFAULT NULL,
  `kd_vlrtot` int(9) 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`
--

INSERT INTO `kardex` (`kd_numero`, `kd_codigo`, `kd_tipo`, `kd_fecreg`, `kd_cantid`, `kd_vlrtot`, `centro_costo`) VALUES (1,100111,1,'2021-05-14',50.00,3950000,'1000');

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

INSERT INTO `kardexbod` (`kd_numero`, `kd_codigo`, `kd_tipo`, `kd_bodega`, `kd_fecreg`, `kd_cantid`, `kd_vlrtot`) VALUES (1,100111,1,'1000','2021-05-14',50.00,3950000);

--
-- 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` double(15,2) DEFAULT NULL,
  `lq_deveng` double(15,2) 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 (2021021,1234644889,260972.60,20533.34,281505.94,7,0,'2021-02-01','2021-02-15','2021-05-20','1234644889','15:06:26'),(2021021,1110529679,217075.66,17333.34,234409.00,5,0,'2021-02-01','2021-02-15','2021-05-20','1234644889','15:06:26'),(2021022,1234644889,559227.00,44000.00,603227.00,15,0,'2021-02-16','2021-02-28','2021-05-20','1234644889','16:04:02'),(2021022,1110529679,831227.00,52000.00,883227.00,15,0,'2021-02-16','2021-02-28','2021-05-20','1234644889','16:04:02'),(2021031,1110529679,651227.00,52000.00,703227.00,15,0,'2021-03-01','2021-03-15','2021-05-21','1234644889','16:41:59'),(2021031,1234644889,559227.00,44000.00,603227.00,15,0,'2021-03-01','2021-03-15','2021-05-21','1234644889','16:41:59'),(2021032,1110529679,851227.00,52000.00,903227.00,15,0,'2021-03-16','2021-03-31','2021-05-21','1234644889','16:56:16'),(2021032,1234644889,559227.00,44000.00,603227.00,15,0,'2021-03-16','2021-03-31','2021-05-21','1234644889','16:56:16'),(2021041,1110473481,634151.34,34666.66,668818.00,10,0,'2021-04-01','2021-04-15','2021-05-22','1234644889','09:07:33'),(2021041,1234644889,559227.00,44000.00,603227.00,15,0,'2021-04-01','2021-04-15','2021-05-22','1234644889','09:07:33'),(2021042,1110473481,817893.00,52000.00,869893.00,15,0,'2021-04-16','2021-04-30','2021-05-22','1234644889','10:40:35'),(2021042,1234644889,623394.00,44000.00,667394.00,15,0,'2021-04-16','2021-04-30','2021-05-22','1234644889','10:40:35'),(2021051,1110473481,651227.00,52000.00,703227.00,15,0,'2021-05-01','2021-05-15','2021-05-22','1234644889','10:45:10'),(2021051,1234644889,559227.00,44000.00,603227.00,15,0,'2021-05-01','2021-05-15','2021-05-22','1234644889','10:45:10');

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

INSERT INTO `marca` (`mr_codmar`, `mr_descri`, `mr_nrolla`, `mr_nfilac`, `mr_nfilco`, `mr_nfilai`) VALUES (1,'GENERAL',0,0,0,0);

--
-- 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(12) 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`
--

INSERT INTO `movto` (`mo_tipcom`, `mo_numero`, `mo_fecreg`, `mo_horreg`, `mo_codcli`, `mo_factur`, `mo_estado`, `mo_detalle`, `mo_fecing`, `mo_horing`, `mo_codemp`) VALUES (111,2,'2021-05-06','10:44:32',0,0,'C',' 111111','2021-05-06','10:44:41','asexis'),(109,1,'2021-01-04','10:11:14',0,0,'C','GASTOS DE CONSTITUCIÓN','2021-05-21','02:53:07','1234644889'),(100,2,'2021-01-15','08:48:04',901445146,0,'C',' SALDOS INICIALES','2021-05-07','08:48:33','1234644889'),(100,3,'2021-01-15','08:56:59',901445146,0,'C',' SALDOS INICIALES','2021-05-07','08:57:52','1234644889'),(105,1,'2021-01-30','10:10:06',890903938,0,'C',' NOTA DE BANCO MES DE ENERO DEL 2021','2021-05-07','10:18:16','1234644889'),(109,2,'2021-01-15','03:23:51',901372611,0,'C','CERTIFICADO CONSTITUCION','2021-05-24','10:12:13','asexis'),(109,4,'2021-05-24','09:07:34',93395024,0,'C','REMODELACIÓN LOCAL','2021-05-24','09:46:36','1234644889'),(118,1,'2021-05-26','05:32:46',900586384,2021041,'C','Contabilizacion Nomina del 2021041 ','2021-05-26','05:32:46','1234644889'),(110,1,'2021-01-04','03:15:38',890700622,0,'C','Cancelacion GASTOS DE CONSTITUCIÓN','2021-05-14','03:15:38','1234644889'),(110,2,'2021-01-15','03:23:51',901372611,0,'C','Cancelacion ALQUILER SALA DE JUNTAS','2021-05-14','03:23:51','1234644889'),(103,1,'2021-05-14','03:51:44',890206908,1,'C','Registro Contable Entrada No. 1','2021-05-14','03:51:44','1234644889'),(110,3,'2021-05-21','05:07:38',901372611,0,'C','Cancelacion ALQUILER SALA DE JUNTAS','2021-05-21','05:07:39','1234644889'),(110,4,'2021-05-24','09:07:34',93395024,0,'C','Cancelacion REMODELACIÓN LOCAL','2021-05-24','09:07:34','1234644889'),(109,3,'2021-05-21','05:07:38',901372611,0,'C','ALQUILER SALA DE JUNTAS','2021-05-24','09:55:08','1234644889'),(109,5,'2021-01-18','10:00:03',900277379,0,'C','COMPRA LAMPARAS','2021-05-24','10:02:00','1234644889'),(110,5,'2021-01-18','10:00:03',900277379,0,'C','Cancelacion COMPRA LAMPARAS','2021-05-24','10:00:03','1234644889');

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

INSERT INTO `movto_niif` (`mo_tipcom`, `mo_numero`, `mo_fecreg`, `mo_horreg`, `mo_codcli`, `mo_factur`, `mo_estado`, `mo_detalle`, `mo_fecing`, `mo_horing`, `mo_codemp`, `mo_tipcom_ref`, `mo_numero_ref`) VALUES (100,1,'2021-05-07','08:56:16',901445146,0,'C',' SALDOS INICIALES','2021-01-15','08:56:16','12346448',100,2),(109,1,'2021-05-07','10:24:33',900277379,0,'C','LAMPARA REGLETA LED ','2021-05-07','10:24:33','12346448',109,1);

--
-- Table structure for table `municipio`
--

CREATE TABLE `municipio` (
  `municipio` int(2) NOT NULL,
  `dane` varchar(15) NOT NULL,
  `detalle` text NOT NULL,
  PRIMARY KEY (`municipio`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `municipio`
--

INSERT INTO `municipio` (`municipio`, `dane`, `detalle`) VALUES (1,'73001','IBAGUE');

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

CREATE TABLE `notasfacturas` (
  `co_numero` int(9) NOT NULL,
  `co_codcli` varchar(12) DEFAULT NULL,
  `co_fecreg` date DEFAULT NULL,
  `co_horreg` time NOT NULL DEFAULT '00:00:00',
  `co_vlrtot` double(15,2) DEFAULT NULL,
  `co_vlriva` double(15,2) DEFAULT NULL,
  `co_apagar` double(15,2) DEFAULT NULL,
  `co_estado` char(1) NOT NULL,
  `co_codcen` varchar(6) NOT NULL,
  `co_codaux` int(9) NOT NULL,
  `co_usuario` char(15) NOT NULL,
  `co_tipo` char(1) NOT NULL,
  `co_ccosto` varchar(6) NOT NULL,
  `co_contrato` int(11) NOT NULL DEFAULT '0',
  `co_tipcon` int(11) NOT NULL DEFAULT '0',
  `co_anocon` int(4) NOT NULL DEFAULT '0',
  `co_nrofac` varchar(20) NOT NULL,
  `co_fecfac` date NOT NULL,
  `co_cufe` text NOT NULL,
  `co_id` varchar(50) NOT NULL,
  `co_url_representacion_grafica` text NOT NULL,
  PRIMARY KEY (`co_numero`),
  KEY `co_codcli` (`co_codcli`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `notasfacturas`
--


--
-- 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 (2021022,1110529679,105,0,180000.00,'2021-05-20','1234644889'),(2021032,1110529679,105,0,200000.00,'2021-05-21','1234644889'),(2021041,1110473481,105,0,200000.00,'2021-05-22','1234644889'),(2021042,1110473481,105,0,166666.00,'2021-05-22','1234644889'),(2021042,1234644889,201,0,64167.00,'2021-05-22','1234644889');

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

INSERT INTO `observaciones` (`ob_numero`, `ob_detalle`) VALUES (0,'NO APLICA PROYECTO');

--
-- 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,
  `or_seccion` varchar(12) NOT NULL,
  `or_fecpag` date NOT NULL,
  `or_forpag` varchar(30) NOT NULL,
  `or_poliza` varchar(30) NOT NULL,
  `or_autoriza` varchar(30) 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,
  `columna` int(6) NOT NULL,
  PRIMARY KEY (`formato`,`concepto`,`ctainicial`)
) 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','[encoded data, 12016 characters]','FAC','A'),('CIUDADEMP','NOMBRE CIUDAD DE ORIGEN EMPRESA','IBAGUE','GEN','A'),('DIRECCION','DIRECCION','CR 7 CL 65 B CONJ MILLENIUM LC 1','FAC','A'),('EMPRESA','NOMBRE EMPRESA','GASO COLOMBIA SAS E.S.P','GEN','A'),('IMAGENC','IMAGEN ENCABEZADO','iVBORw0KGgoAAAANSUhEUgAABskAAAN5CAYAAABKUdWuAAAAIGNIUk0AAHomAACAhAAA','FAC','A'),('LOGO','LOGO','[encoded data, 17940 characters]','FAC','A'),('MODO','MODO DE OPERACION','1','FAC','A'),('NIT','NIT EMPRESA','901445146','GEN','A'),('NUMRESFAE','NUMERO DE RESOLUCION FACTURACION ELECTRONICA','18760000001','FAC','A'),('PAGUEAQUI','REFERENCIA DE PAGO','','FAC','A'),('PREFIJOFE','PREFIJO FACTURACIÓN ELECTRÓNICA','SETP','FAE','A'),('TELEFONO','TELEFONO','4567890','FAC','A'),('TESTSETID','TESTSETID','7b04962b-4111-4b76-a1ea-28b08838d1e4','FAC','A'),('TOKEN','TOKEN','08de582f5e38fc5e7b2b6e7b17ba6fdda95d5d2c7da52d107a28be6d585ecb65','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`
--

INSERT INTO `pedcom` (`pec_numero`, `pec_mesa`, `pec_observ`) VALUES (1,1000,'1000'),(2,1000,'1000'),(3,1000,'1000');

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

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


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

INSERT INTO `pedidos` (`pe_numero`, `pe_mesa`, `pe_observ`) VALUES (1,800053720,'-');

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

INSERT INTO `pedidos_cxp` (`pe_numero`, `pe_mesa`, `pe_observ`) VALUES (1,17314286,'-');

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

INSERT INTO `pedidosre` (`per_numero`, `per_observ`, `per_codcli`) VALUES (1,'-',890480041);

--
-- 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,
  `pep_fecsol` date NOT NULL,
  `pep_fecnec` date NOT NULL,
  PRIMARY KEY (`pep_numero`)
) 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` varchar(20) 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`
--

INSERT INTO `recibosp` (`re_numero`, `re_codcli`, `re_nropla`, `re_codres`, `re_fecreg`, `re_horreg`, `re_vlrtot`, `re_estado`, `re_tippag`, `re_pagado`, `re_ctapago`, `re_usuario`, `re_detalle`, `re_soporte`) VALUES (1,890700622,'1','1234644889','2021-01-04','03:15:38',3807200.00,'F','E',3807200.00,'11100501','1234644889','Cancelacion GASTOS DE CONSTITUCIÓN','0'),(2,901372611,'1','1234644889','2021-01-15','03:23:51',180000.00,'F','E',180000.00,'1','1234644889','Cancelacion ALQUILER SALA DE JUNTAS','0'),(3,901372611,'1','1234644889','2021-05-21','05:07:38',180000.00,'F','T',180000.00,'11100501','1234644889','Cancelacion ALQUILER SALA DE JUNTAS','0'),(4,93395024,'1','1234644889','2021-05-24','09:07:34',4243274.00,'F','T',4243274.00,'11100501','1234644889','Cancelacion REMODELACIÓN LOCAL','0'),(5,900277379,'1','1234644889','2021-01-18','10:00:03',157969.00,'F','T',157969.00,'11100501','1234644889','Cancelacion COMPRA LAMPARAS','0');

--
-- 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` int(11) 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` int(11) NOT NULL,
  `regp_contrato_vigencia` int(4) NOT NULL,
  `regp_contrato_numero` int(11) NOT NULL,
  `regp_origen` varchar(10) NOT NULL,
  `regp_guerra` char(1) NOT NULL,
  `regp_vguerra` double(15,2) NOT NULL,
  `regp_imp_cree` varchar(12) NOT NULL DEFAULT 'NA',
  `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',
  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`
--

INSERT INTO `responsable` (`re_codres`, `re_nombre`, `re_cargo`) VALUES ('jmorales','JOHN JAIRO MORALES','Administrador del sistema'),('asexis','Asexis Soporte','Asexis'),('1234644889','KEVIN GARCIA','CONTADOR');

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

INSERT INTO `responsablei` (`re_codres`, `re_nombre`, `re_cargo`) VALUES ('1','GASOCOL COLOMBIA','GENERAL');

--
-- 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 ('55','ICA COMBUSTIBLE - PLATO','24370101',4.00,0.00,0.00),('2','Iva Compras Equipos de Computo y Telecomunicaciones 20%','',20.00,0.00,0.00),('3','Venta de Bienes','',16.00,0.00,0.00),('4','Venta de Servicios','',16.00,0.00,0.00),('5','Retencion de Ica Turbaco por compras 7/1000','24370101',6.00,0.00,0.00),('6','Retencion de Ica Arjona por servicios 8/1000','24370202',8.00,0.00,0.00),('7','Retencion de Ica Cartagena por compras 7/1000','',0.70,0.00,0.00),('8','Retencion de Ica por Servicios Turbaco 7/1000','24370201',7.00,0.00,0.00),('9','Retencion de Ica por Servicios Arjona 10/1000','24370203',10.00,0.00,0.00),('10','IVA descontable','51201802',19.00,1.00,0.00),('11','Retencion de Ica Servicios Cartagena 8/1000','',0.80,0.00,0.00),('12','Retencion en la Fuente Honorarios Personas Juridicas 11%','24360302',11.00,0.00,0.00),('13','Retencion en la Fuente  Honorarios Personas Naturales 10%','24360301',10.00,0.00,0.00),('14','Retencion en la Fuente Servicios Generales 6% No declarantes','24360501',6.00,127000.00,4.00),('15','Retencion en la Fuente Servicios Aseo 2%','24360502',2.00,0.00,0.00),('16','Retencion en la Fuente Servicios de Vigilancia 2%','24360503',2.00,0.00,0.00),('17','Retencion en la Fuente Servicios Temporales 1%','24360504',1.00,127000.00,4.00),('18','Retencion en la Fuente Transporte de Carga 1%','24360503',1.00,0.00,0.00),('19','Retencion en la Fuente Transporte de pasajeros 3.5%','24360506',3.50,0.00,0.00),('20','Retencion en la Fuente Contratos de Construccion 2%','24369001',2.00,0.00,0.00),('21','Retencion en la Fuente Arrendamiento Bienes Muebles 4%','24360602',4.00,0.00,0.00),('22','Retención en la Fuente Arrendamientos Bienes Inmuebles 3.5%','24360601',3.50,860000.00,27.00),('23','Retencion en la Fuente Compras Generales 3.5% No declarantes','24360803',3.50,860000.00,27.00),('24','Retencion en la Fuente Compra Combustible 0.1%','24360802',0.10,0.00,0.00),('25','Retencion de Impuesto de Timbre 1.5%','244008',1.50,0.00,0.00),('26','Retencion de IVA por Compras  mayores a ($566.000) 50%','',50.00,0.00,0.00),('27','Retencion de IVA por Compras  Servicios mayores a ($84.000) 50%','',50.00,0.00,0.00),('28','Retencion de IVA Regimen Simplificado 50%','',50.00,0.00,0.00),('29','Retencion en la Fuente Servicios Generales 4% Declarantes','24360502',4.00,127000.00,4.00),('30','Descuento comercial 5% por compras','',5.00,0.00,0.00),('31','Retencion por servicios integrales de salud','24360510',2.00,0.00,0.00),('32','Descuento comercial 10% por compras','',10.00,0.00,0.00),('33','Retencion de Ica Arjona por compras 8/1000','24370102',8.00,0.00,0.00),('34','Retencion en la Fuente Compras Generales 2.5% Declarantes','24360801',2.50,860000.00,27.00),('35','Retencion en la Fuente Bienes Muebles 3.5%','24360601',3.50,0.00,0.00),('36','DESCUENTO COMERCIAL 3%','',3.00,0.00,0.00),('37','Comercial e Industrial 0.3%','',0.30,0.00,0.00),('38','Servicios. Construcción 0.06','',0.60,0.00,0.00),('39','Mineria e Hidrocarburos 1.5%','',1.50,0.00,0.00),('40','Retencion en la Fuente Compras Generales 1.5%','',1.50,0.00,0.00),('41','RETENCION CONTRATO DE OBRAS 2%','24369001',2.00,0.00,0.00),('42','Iva Compra 5%','',5.00,0.00,0.00),('43','Servicios de Licenciamiento o Derecho de uso de Software		','24360511',3.50,0.00,0.00),('44','Retencion por salarios y pagos laboraes','24360101',5.64,0.00,0.00),('46','RETEICA COMPRA COMBUSTIBLE','24370101',9.00,0.00,0.00),('47','RETEICA DEMÁS COMPRAS','24370102',10.00,0.00,0.00),('48','RETEICA COMPRA MATERIALES - PAPELERIA - IMPRESOS','24370103',9.00,0.00,0.00),('49','RETEICA ARRIENDO','24370301',7.00,0.00,0.00),('50','RETEICA SERV TRANSP','24370302',7.00,0.00,0.00),('51','RETEICA PUBLICIDAD','24370303',7.00,0.00,0.00),('52','RETEICA CONSULTORIA','24370304',6.00,0.00,0.00),('53','RETEICA DEMAS SERVICIOS','24370305',10.00,0.00,0.00),('54','AUTORRETENCIONES ICA','24370401',0.00,0.00,0.00),('56','RT ICA MATERIALES - PAPELERIA -IMPRESOS PLATO','24370103',8.00,0.00,0.00),('57','RT ICA TRANSPORTE PLATO','24370302',5.00,0.00,0.00),('58','RT ICA PUBLICIDAD PLATO','24370303',6.00,0.00,0.00),('59','RT ICA CONSULTORIA PROFESIONAL PLATO','24370304',6.00,0.00,0.00),('60','RT ICA DEMAS SERVICIOS PLATO','24370305',10.00,0.00,0.00),('61','RT ICA DEMAS COMPRAS PLATO','24370102',10.00,0.00,0.00),('62','RT ICA ARRIENDO PLATO','24370301',10.00,0.00,0.00),('63','RETEICA COMBUSTIBLE ZB','24370101',9.00,0.00,0.00),('64','RETEICA DEMAS COMPRAS ZB','24370102',10.00,0.00,0.00),('65','RETEICA COMPRA MATERIALES, PAPELERIA, IMPRESOS ZB','24370103',9.00,0.00,0.00),('66','RETEICA ARRIENDO ZB','24370301',10.00,0.00,0.00),('67','RETEICA SERV TRANSP ZB','24370302',7.00,0.00,0.00),('68','RETEICA PUBLICIDAD ZB','24370303',10.00,0.00,0.00),('69','RETEICA CONSULTORIA ZB','24370304',9.00,0.00,0.00),('70','RETEICA DEMAS SERVICIOS ZB','24370305',10.00,0.00,0.00),('71','RETEICA COMBUSTIBLE TM','24370101',7.00,0.00,0.00),('72','RETEICA DEMAS COMPRAS TM','24370102',5.00,0.00,0.00),('73','RETEICA COMPRA MATERIALES TM','24370103',7.00,0.00,0.00),('74','RETEICA COMPRA PAPELERIA, IMPRESOS TM','24370103',5.00,0.00,0.00),('75','RETEICA ARRIENDO TM','24370301',10.00,0.00,0.00),('76','RETEICA SERV TRANSP TM','24370302',6.00,0.00,0.00),('77','RETEICA PUBLICIDAD TM','24370303',10.00,0.00,0.00),('78','RETEICA CONSULTORIA TM','24370304',10.00,0.00,0.00),('79','RETEICA DEMAS SERVICIOS TM','24370305',10.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 (2021,908526,106454),(2020,877803,102854),(2018,781242,88211),(2019,828116,97032);

--
-- 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 `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,
  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 `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'),(1000,'BODEGA PRINCIPAL');

--
-- 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',1),('D','Descuentos',0),('E','Factura Equivalente',4),('F','Facturas',990000001),('N','Recibos de pago Nomina',0),('P','Recibos de Pago',5),('R','Recibos de Caja',0),('S','Salidas de Inventario',0),('X','Cuentas Por Pagar',5),('I','Disponibilidades',0),('G','Registros Presupuestales',0),('GP','Giro Presupuestal',0),('CS','Consignaciones',0),('PE','Pedidos Entradas',3),('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),('Y','Documentos',0),('PI','Pedidos Internos',0),('PC','Pagos por Cuenta',0),('LA','Avances y Anticipos',0),('LC','Liquidacion Contrato',0),('NF','Notas Facturas',0),('PF','Pedidos facturas',0);

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

INSERT INTO `terceros` (`te_codcli`, `te_nombre`, `te_direcc`, `te_telefo`, `te_porcen`, `te_nombr1`, `te_nombr2`, `te_apell1`, `te_apell2`, `te_codact`, `te_codciu`, `te_tipo`, `te_tipter`, `te_tipdoc`, `te_autore`, `te_gran`, `te_ent_publica`, `te_regimen`, `te_estado`, `te_correo`) VALUES (800130907,'SALUD TOTAL','SALUD TOTAL','',0,'','','','',0,70001,'J','E','N','N','N','N','','',''),(800140949,'CAFESALUD','CAFESALUD','',0,'','','','',0,70001,'J','E','N','N','N','N','','',''),(800224808,'PORVENIR','PORVENIR','',0,'','','','',0,70001,'J','E','N','N','N','N','','',''),(800226175,'COLMENA','COLMENA','',0,'','','','',0,70001,'J','E','N','N','N','N','','',''),(800227940,'COLFONDOS','COLFONDOS','',0,'','','','',0,70001,'J','E','N','N','N','N','','',''),(800229739,'PROTECCION','PROTECCION','',0,'','','','',0,70001,'J','E','N','N','N','N','','',''),(800231967,'HORIZONTE','HORIZONTE','',0,'','','','',0,70001,'J','E','N','N','N','N','','',''),(800250119,'SALUDCOOP','SALUDCOOP','',0,'','','','',0,70001,'J','E','N','N','N','N','','',''),(800251440,'SANITAS','SANITAS','',0,'','','','',0,70001,'J','E','N','N','N','N','','',''),(804002273,'SOLSALUD','SOLSALUD','',0,'','','','',0,70001,'J','E','N','N','N','N','','',''),(805000427,'COOMEVA','COOMEVA','',0,'','','','',0,70001,'J','E','N','N','N','N','','',''),(805001157,'S.O.S. SERVICIO OCCIDENTAL DE SALUD S.A.','S.O.S. SERVICIO OCCIDENTAL DE SALUD S.A.','',0,'','','','',0,70001,'J','E','N','N','N','N','','',''),(830006404,'HUMANA VIVIR','HUMANA VIVIR','',0,'','','','',0,70001,'J','E','N','N','N','N','','',''),(830074184,'SALUDVIDA','SALUDVIDA','',0,'','','','',0,70001,'J','E','N','N','N','N','','',''),(860002503,'SEGUROS BOLIVAR','SEGUROS BOLIVAR','',0,'','','','',0,70001,'J','E','N','N','N','N','','',''),(890700148,'COMFENALCO TOLIMA','COMFENALCO TOLIMA','',0,'','','','',0,70001,'J','E','N','N','N','N','','',''),(900074992,'GOLDEN CROSS S.A.','GOLDEN CROSS S.A.','',0,'','','','',0,70001,'J','E','N','N','N','N','','',''),(900156264,'NUEVA EPS','NUEVA EPS','',0,'','','','',0,70001,'J','E','N','N','N','N','','',''),(900336004,'COLPENSIONES','COLPENSIONES','',0,'','','','',0,70001,'J','E','N','N','N','N','','',''),(830054904,'MAPFRE','MAPFRE','',0,'','','','',0,70001,'J','E','N','N','N','N','','',''),(38361775,'SANDRA MONICA HERNANDEZ ORTIZ','CONJ RESIDENCIAL OKAPI T.1 APTO 403','3106493223',0,'SANDRA','MONICA','HERNANDEZ','ORTIZ',0,73001,'N','','CC','N','N','N','','','monihernandez768@gmail.com'),(800197268,'DIRECCION DE IMPUESTOS Y ADUANAS NACIONALES - DIAN','','',0,'','','','',0,70001,'J','N','NI','N','N','N','','',''),(860009578,'SEGUROS DEL ESTADO','','',0,'','','','',0,70001,'J','N','NI','N','N','N','','',''),(860011153,'POSITIVA COMPA?IA DE  SEGUROS S.A','','',0,'','','','',0,70001,'J','N','NI','N','N','N','','',''),(800242106,'ALMACENES HOMECENTER','','',0,'','','','',0,70001,'J','N','NI','N','N','N','','',''),(830122566,'COLOMBIA TELECOMUNICACIONES S.A ESP','AV SUBA # 114 A 55','70050000',1,'','','','',0,11001,'J','C','NI','N','S','N','','',''),(890100577,'AVIANCA S.A','AVENIDA CALLE 26 59-15','',0,'','','','',0,11001,'N','N','N','N','N','N','','',''),(28554917,'MONICA  RUBIO ROJAS','CL 78B #5-29 B. GERMAN HUERTAS','3148943185',0,'MONICA','','RUBIO','ROJAS',0,73001,'N','','CC','N','N','N','','','monikrubio22@hotmail.com'),(1110583311,'YURI ALEXANDRA JIMENEZ RONDON','CL 69 #28-47 B. LOS CIRUELOS','3138482996',0,'YURI','ALEXANDRA','JIMENEZ','RONDON',0,73001,'N','','CC','N','N','N','','','yajimenez591@hotmail.com'),(860032115,'CENTRO AUTOMOTOR DIESEL S.A CENTRODIESEL','CLL 13 68 B 11','4136797',6,'','','','',0,11001,'J','C','NI','S','S','N','','',''),(890480041,'CAMARA DE COMERCIO DE CARTAGENA','CENTRO CL SANTA TERESA 3241','(5)6501110',1,'','','','',0,13001,'J','C','NI','N','N','N','','',''),(28687160,'SANDRA LILIANA PATARROYO CAMACHO','MZ 48 C 11 JORDAN 2? ETAPA','3177365994',0,'SANDRA','LILIANA','PATARROYO','CAMACHO',0,73001,'N','','CC','N','N','N','','','slipatarroyo@hotmail.com'),(8336587,'CARLOS HUMBERTO RUDA MORALES','CR 12 SUR #97-61 OKAPI','3213031761',0,'CARLOS','HUMBERTO','RUDA','MORALES',0,73001,'N','','CC','N','N','N','','','rudamoralesc@gmail.com'),(1110520250,'CATALINA  ECHEVERRY RUDA','CONJ RESIDENCIAL OKAPI T.1 APTO 503','3114820351',0,'CATALINA','','ECHEVERRY','RUDA',0,73001,'N','','CC','N','N','N','','','kta9202@gmail.com'),(38258033,'AYDE  YATE LUGO','CONJ RESIDENCIAL OKAPI T.2 APTO 101','3152528992',0,'AYDE','','YATE','LUGO',0,73001,'N','','CC','N','N','N','','','aydeyatelugo@gmail.com'),(804002105,'COMPARTA EPS','Cra 19A #13a-109','0',0,'','','','',0,70001,'J','N','NI','','','N','','',''),(806008394,'MUTUAL SER EPS','# a 16a-144,, Cra. 17 #162','',7,'','','','',0,70001,'J','N','NI','','','N','','',''),(901097473,'MEDIMAS EPS','Cra. 25 #20a-18','',5,'','','','',0,70001,'J','N','','','','N','','',''),(5819064,'GUILLERMO ANTONIO HERRAN SABOGAL','CR 5 SUR #23A 71 B. LIBERTANO','3209514695',0,'GUILLERMO','ANTONIO','HERRAN','SABOGAL',0,73001,'N','','CC','N','N','N','','','chic_ur@hotmail.com'),(4439007,'CARLOS ALBERTO LAGUNA CORTES','MZ 7 CASA 16 ETAPA 3 VILLA CAF','3216488760',0,'CARLOS','ALBERTO','LAGUNA','CORTES',0,73001,'N','','CC','N','N','N','','','carlos.albelaguna@gmail.com'),(1110498431,'JAIRO ALBERTO GOMEZ PEREZ','CONJ RESIDENCIAL OKAPI T.1 APTO 103','3204213465',0,'JAIRO','ALBERTO','GOMEZ','PEREZ',0,73001,'N','','CC','N','N','N','','','jairito54321@hotmail.com'),(860519235,'TALLERES AUTORIZADOS S.A','CL75 N 5-105','',0,'','','','',0,23001,'J','N','NI','N','N','N','','',''),(1110499542,'MORA MUNERA DAVID LEONARDO','CRA 6   39 35','3058903496',0,'DAVID','LEONARDO','MORA','MUNERA',0,73001,'','','','','','N','','A',''),(1005714622,'MUÑOZ DARWIN ALEXANDER','MZ 9  C 1B','3143233583',0,'DARWIN','ALEXANDER','MUÑOZ','',0,0,'','','','','','N','','',''),(900097602,'OBRAS Y DISEÑOS ELECTRICOS J.R LTDA','CR 5 86 83 LAS MARGARITAS LC 7 URB LAS MARGARITAS','2683462',5,'','','','',4752,73001,'J','P','NI','N','N','N','S','A',''),(65782673,'ORTIZ OYOLA NURY MILENA','CALLE 11 NO. 4-24 OFICINA 201','3102703540',0,'NURY','MILENA','ORTIZ','OYOLA',0,0,'','','','','','N','','','angelito0911@gmail.com                            '),(830037946,'PANAMERICANA LIBRERIA Y PAPELERIA SA','CR 5  60 73','2665155',3,'','','','',4761,11001,'J','P','NI','S','S','N','S','A',''),(1006119979,'MC DOTACIONES','CL 51  4B 52','3127806064',0,'MARIA','CAMILA','PARRA','CASTELLANO',0,0,'','','','','','N','','',''),(79391966,'FERRETERIA GEGAS','CR 32  10 04 SUR LC 108','3158988388',3,'GIOVANNI','EMILIO','PEDRAZA','CASTELLANO',4752,11001,'N','P','CC','N','N','N','S','A',''),(1110444497,' DIANA CAROLINA POVEDA MAHECHA','CARRERA 8 SUR #45-132 SOLARIUM APTO 1904','3235726291',0,'DIANA','CAROLINA','POVEDA','MAHECHA',0,0,'','C','','','','N','','',''),(1110529679,'RINCON OCAMPO CESAR','','',0,'CESAR','','RINCON','OCAMPO',0,73001,'N','E','CC','N','N','N','N','A',''),(899999034,'SENA','','',0,'','','','',0,0,'','N','','','','S','','',''),(7556168,'CONSTRU FER DEL TOLIMA','CRA 5  75 76 LC 2','2684659',0,'ROBERTO','ORLANDO','SERRANO','PEREZ',0,73001,'','','','','','N','S','',''),(899999239,'ICBF','','',0,'','','','',0,0,'','C','','','','S','','',''),(800089809,'IBAL SA ESP','CRA 5  41 20 LC 201','2756000',6,'','','','',0,73001,'J','P','','S','S','N','S','A',''),(832004104,'MAXICASSA SAS','CARRERA 7 CALLE 65 B LOCAL 1','3235726291',4,'','','','',0,0,'','','','','','N','','',''),(860512330,'SERVIENTREGA S.A','AV CALLE 6  34 A  11','2765954',3,'','','','',0,11001,'','','','','','N','','',''),(900184558,'SERVIR INGENIEROS E.U','CALLE 37 #4F-67','2700683',1,'','','','',4322,73001,'J','P','NI','N','N','N','S','A',''),(800144331,'SOCIEDAD ADMINISTRADORA DE FONDOS DE PENSIONES Y CESANTIAS PORVENIR S.A.','CRA. 13   53 45','3393000',3,'','','','',0,11001,'','','','','','N','','',''),(900083058,'SYSCAFE S.A.S.','CR 3 N 38A-18 B/LA CASTELLANA','2739888',7,'','','','',0,73001,'','','','','','N','','','info@syscafe.com.co                               '),(55151131,'TODO REPUESTOS DEL TOLIMA','CL 17  3 58','3183541794',4,'TERESA','','TOVAR','RAMIREZ',4754,73001,'N','P','CC','N','N','N','S','A',''),(900204302,'VALVUNIPLES Y ACCESORIOS LIMITADA','CR 28   11 65  OF 310','3106290164',0,'','','','',4663,11001,'J','P','NI','N','N','N','S','A','valvuniples@gmail.com                             '),(1110524984,'VILLALBA VARGAS LUISA FERNANDA','CL 51 7B  28 ED  JOMAR AP 501','3202334235',1,'LUISA','FERNANDA','VILLALBA','VARGAS',8299,73001,'N','P','CC','N','N','N','N','A','luisavillalba920720@gmail.com                     '),(93357050,'ALEXANDER  TORO HERRERA','CL 160 #21 SUR 70 T.17 APTO 301','3186184573',0,'ALEXANDER','','TORO','HERRERA',0,73001,'N','','CC','N','N','N','','','mirianhdz812@hotmail.com'),(1110535316,'JHONATAN ISRAEL ALVAREZ ROJAS','CONJ RESIDENCIAL OKAPI T.3 APTO 301','3107976480',0,'JHONATAN','ISRAEL','ALVAREZ','ROJAS',0,73001,'N','','CC','N','N','N','','','jhonatanalr@gmail.com'),(14324200,'CARLOS ALBERTO LEAL BASTO','MZ B CASA 45 URB LA ESPERANZA','3127043042',0,'CARLOS','ALBERTO','LEAL','BASTO',0,73001,'N','','CC','N','N','N','','',''),(1104700513,'LUZ MARYURI ROBAYO VELASQUEZ','CONJ RESIDENCIAL OKAPI T.3 APTO 304','3224290689',0,'LUZ','MARYURI','ROBAYO','VELASQUEZ',0,73001,'N','','CC','N','N','N','','','maryuryrobayo.25@gmail.com'),(65701953,'MIRTA  MOLINA SANCHEZ','CASA 66 #20-10 B. AMBALA','3168653670',0,'MIRTA','','MOLINA','SANCHEZ',0,73001,'N','','CC','N','N','N','','','mirtamolina93@hotmail.com'),(1110469095,'YEIMY VIVIANA CORTES SALAZAR','CONJ RESIDENCIAL OKAPI T.3 APTO 402','3102944860',0,'YEIMY','VIVIANA','CORTES','SALAZAR',0,73001,'N','','CC','N','N','N','','','jeimivivianacortes@hotmail.com'),(1005771356,'VALENTINA  GUZMAN CADENA','MZ 65 CASA 2 JORDAN 8? ETAPA','3175951937',0,'VALENTINA','','GUZMAN','CADENA',0,73001,'N','','CC','N','N','N','','','valentina.cadena99@gmail.com'),(1110487184,'LINDA KATHERINE RIPE TORRES','MZ E CASA 16 B. NUEVO COMBEIMA','3155766235',0,'LINDA','KATHERINE','RIPE','TORRES',0,73001,'N','','CC','N','N','N','','','lindarippe87@gmail.com'),(1234641138,'PAULA ANDREA OROZCO TORRES','MZ B CASA 9 B. TULIO VARON','3197377663',0,'PAULA','ANDREA','OROZCO','TORRES',0,73001,'N','','CC','N','N','N','','','paulaorozco318@hotmail.com'),(1071840280,'SERGIO ELIAS HERRERA HERRERA','CR 1 #18-62 FUSAGASUGA','3232922321',0,'SERGIO','ELIAS','HERRERA','HERRERA',0,73001,'N','','CC','N','N','N','','','sergioeliasherrera2@gmail.com'),(1110589549,'CRISTIAN RICARDO BENAVIDES RODRIGUEZ','MZ F CASA 26 BRISAS DEL PEDREGAL','3007609508',0,'CRISTIAN','RICARDO','BENAVIDES','RODRIGUEZ',0,73001,'N','','CC','N','N','N','','','benavudes0403@gmail.com'),(51956605,'BEATRIZ  SALGADO TORRES','CONJ RESIDENCIAL OJAPI T.4 APTO 304','3203995238',0,'BEATRIZ','','SALGADO','TORRES',0,73001,'N','','CC','N','N','N','','','albarogomez08@hotmail.com'),(1110492624,'ANDERSON JAVIER VARON ALVIS','CR 12 SUR #97-61 T.4 APTO 403','3152881675',0,'ANDERSON','JAVIER','VARON','ALVIS',0,73001,'N','','CC','N','N','N','','','anderson.2810@hotmail.com'),(38212825,'NATALY  GUAYARA','CL 65 #20A 28 APTO 206','3164148349',0,'NATALY','','GUAYARA','',0,73001,'N','','CC','N','N','N','','','natalygu@gmail.com'),(1110557972,'CRISTHIAN FELIPE DIAZ ORTIZ','CL 57 #7B 35 RINCON DE PIEDRA PINTADA','3208574755',0,'CRISTHIAN','FELIPE','DIAZ','ORTIZ',0,73001,'N','','CC','N','N','N','','','crisfedior@hotmail.es'),(71260846,'WILLIAN ALEJANDRO LAGUNA CABEZAS','CL 80 #8-20 CONDOMINIO LA CAROLINA CASA 8','3153770727',0,'WILLIAN','ALEJANDRO','LAGUNA','CABEZAS',0,73001,'N','','CC','N','N','N','','','walcel7@gmail.com'),(14136692,'DAVID ANDRES BERRIO DUQUE','MZ 5 CASA 15 URB. ONZAGA','3168078710',0,'DAVID','ANDRES','BERRIO','DUQUE',0,73001,'N','','CC','N','N','N','','','davidu1.db@gmail.com'),(0,'NO APLICA','','',0,'','','','',0,73001,'J','','','','','N','','I',''),(901445146,'GASO COLOMBIA S.A.S. E.S.P.','CR 7 CL 65 B CONJ. MILENIUM LC -1','3235726291',0,'','','','',0,73001,'','','','N','N','N','S','A',''),(901390708,'DX CAPITALES SAS','CRA 8 SUR NO 40-132 SOLARIUM 1904','3235726291',6,'','','','',0,73001,'J','C','NI','N','N','N','S','A','dxcapitalesgmail.com'),(93400620,'JHON FERNANDO AVILA MELO','CL 53 6-13 TORRE 2 APT 201 TORREON SANTAMONICA','3174016220',0,'JHON','FERNANDO','AVILA','MELO',0,73001,'N','C','CC','N','N','N','N','A',''),(17314286,'ALBERTO MARIN TRUJILLO','MANZANA D CASA 8 BOSQUES DE VARSOVIA','3125876108',0,'ALBERTO','','MARIN','TRUJILLO',0,73001,'N','C','CC','N','N','N','N','A',''),(14239866,'FREDY POVEDA RONDÓN','CALLE 60 #7A-13 LOCAL 1 SAN JERONIMO','2668630',0,'FREDY','','POVEDA','RONDÓN',0,73001,'N','C','CC','N','N','N','N','A',''),(900277379,'PROVEEDORA DE ILUMINACIÓN LTDA PROILUM','CRA 4 18 51 BRR CENTRO','2612351',1,'','','','',4752,73001,'J','P','NI','N','N','N','S','A',''),(890903938,'BANCOLOMBIA S.A','CARRERA 48 26 85 AVENIDA INDUSTRIALES','4040000',8,'','','','',0,0,'J','P','NI','S','S','N','N','A',''),(890903790,'SEGUROS DE VIDA SURAMERICANA S.A','CR 63   49 A 31 P 1 ED CAMACOL','2602100',5,'','','','',0,5001,'J','C','NI','N','N','N','S','A',''),(890700622,'CAMARA DE COMERCIO DE IBAGUÉ','Cra 8 #60-55','2772000',4,'','','','',0,73001,'J','C','NI','N','N','N','S','A','ccardozo@ccibague.org'),(901372611,'BURO 17 CO WORK SAS','CL 39 B 4 B7 B/LA MACARENA PARTE ALTA','3134661949',4,'','','','',6810,73001,'J','P','NI','N','N','N','S','A','buro17cowork.com'),(890206908,'TECNOLOGIAS UNIDAS SAS','CR 31 35 12 OF 704','634341',7,'','','','',4610,68001,'J','P','NI','N','N','N','S','A','contabilidad@tecun.com'),(800053720,'PROYECTAMOS Y EDIFICAMOS SAS','CRA 16 No.93A 36 OF 202','7462088',4,'','JOHN JAIRO','VELASCO','',9609,73001,'J','C','NI','N','N','N','S','A','jmorales@asexis.com'),(860002964,'BANCO DE BOGOTA','CLL 23 A #19-50 CENTRO','2822095',4,'','','','',0,70001,'J','N','NI','N','N','N','','',''),(800088702,'SURAMERICANA EPS','BARRANQUILLA ATLANTICO','2602100',2,'','','','',0,8001,'J','N','CC','N','N','N','','',''),(800113672,'GOBERNACIÓN DEL TOLIMA','CRA 3 ENTRE CALL 10 Y 11','2611111',7,'','','','',0,73001,'','N','','','','S','','',''),(65729466,'MULTIALUMINIOS','CR 6 21 02 ESQ BRR EL CARMEN','3103296513',5,'MARIA','ENERIET','GONZALES','TORRES',4663,73001,'N','P','CC','N','N','N','S','A','multialuminios@yahoo.es                           '),(901363514,'HE MATERIALES S.A.S','CR 14  147  11 BRR EL SALADO','3103236278',1,'','','','',4752,73001,'J','P','NI','N','N','N','S','A','hemateriales1@gmail.com                           '),(28526867,'HERNANDEZ DE NARANJO MARIA NELLY','MANZANA C CASA #178','3212609575',0,'MARIA','NELLY','HERNANDEZ','DE NARANJO',0,73001,'N','','CC','','','N','','A','arbelaezladino@yahoo.com                          '),(10251147,'HERNANDEZ HERNAN','CALLE 19 # 13 195  CONJ FENIX CASA 31','3212306638',0,'HERNAN','','HERNANDEZ','',0,73001,'N','','CC','','','N','','',''),(14236398,'MAXI DOTACIONES','CRA 6 #27-56','3166946598',0,'GUSTAVO','','HERRERA','GARCIA',0,73001,'','P','','N','N','N','N','A',''),(900972316,'INTERGAS DEL TOLIMA SAS','MZ 3 CA 4 BRR JORDAN ET 4','3165464381',7,'','','','',4329,73001,'J','P','NI','N','N','N','S','A','intergasdeltolima@hotmail.com                     '),(93406941,'PREFABRICADOS DE CEMENTO OPTIMO','CR 16 SUR  67A 15','3112187023',8,'JHON','JAIRO','IZQUIERDO','',2395,73001,'N','P','NI','N','N','N','N','A',''),(900276962,'KOBA COLOMBIA SAS','CARRERA 7 155 C 30 ED NORTH POINT TORRE E PISO 37','2541050',1,'','','','',0,11001,'','','','','','N','','',''),(1110465269,'LOPEZ BEDOYA LUIS FERNANDO','MZ 5 CA 2 ET 8 BRR JORDAN','3219211411',1,'LUIS','FERNANDO','LOPEZ','BEDOYA',7010,73001,'N','P','NI','N','N','N','N','A','luilopez13.ii@gmail.com                           '),(1110596500,'MAHECHA CASALLAS GABRIELA','','',0,'','','','',0,0,'','','','','','N','','',''),(800081030,'MAYUN S.A.S','CL 33 41 66 BG 111','3218523723',1,'','','','',4663,5360,'J','P','NI','S','S','N','S','A','contaduria@mayun.com.co                           '),(1110504608,'GUILLERMO  CASALLAS RAMIREZ','CONJ RESIDENCIAL OKAPI T.2 APTO 402','3185320988',0,'GUILLERMO','','CASALLAS','RAMIREZ',0,73001,'N','','CC','N','N','N','','','gcasallasra1990@hotmail.com'),(14236203,'OSCAR AUGUSTO RODRIGUEZ PI?EROS','MZ 1 CASA 12 JORDAN 1? ETAPA','3178107892',0,'OSCAR','AUGUSTO','RODRIGUEZ','PI?EROS',0,73001,'N','','CC','N','N','N','','','alexar355@gmail.com'),(1069754208,'ANGELA MARCELA SUAREZ ROMERO','CONJ RESIDENCIAL OKAPI T.2 APTO 504','3177083455',0,'ANGELA','MARCELA','SUAREZ','ROMERO',0,73001,'N','','CC','N','N','N','','','angelysua80@gmail.com'),(1110486224,'JARELY  GARCIA GARCIA','MZ K CASA 6 B. TULIO VARON','3138407904',0,'JARELY','','GARCIA','GARCIA',0,73001,'N','','CC','N','N','N','','','jare19892009@hotmail.com'),(1109069812,'JHONNATAN ARLEY LEYTON TOVAR','CONJ RESINDECIAL OKAPI T.3 APTO 103','3142059693',0,'JHONNATAN','ARLEY','LEYTON','TOVAR',0,73001,'N','','CC','N','N','N','','','j_arleytont92@hotmail.com'),(1110177213,'MARIA ALEJANDRA BERMUDEZ RODRIGUEZ','CONJ RESIDENCIAL OKAPI T.1 APTO 303','3015369984',0,'MARIA','ALEJANDRA','BERMUDEZ','RODRIGUEZ',0,73001,'N','','CC','N','N','N','','','aledgarin1405@hotmail.com'),(819000939,'INTERASEO S.A.S E.S.P','KM 2 VIA GAIRA SEC ZONA FRANCA TECHIN','3183730513',1,'','','','',0,47001,'J','N','NI','N','N','N','','',''),(800250984,'SUPER INTENDENCIA DE SERVICIOS PUBLICO DOMICILIARIOS','KR 18 # 84 -35','6913006',6,'','','','',0,11001,'J','N','NI','N','N','N','','',''),(802023228,'EMPRESA COLOMBIANA DE SERVICIOS','CL 92 11-51 BOGOTA','-',0,'','','','',0,11001,'J','N','NI','N','N','N','','',''),(830070527,'REDEBAN MULTICOLOR S.A','KR 20 # 33-15 BOGOTA COLOMBIA','30771 EXT 12',1,'','','','',0,11001,'J','N','NI','S','S','N','S','A','aarojas@rbm.com.co'),(860002400,'LA PREVISORA S.A.COMPAÑIA DE SEGUROS','CLL 57 #9-07 BOGOTA','',2,'','','','',0,11001,'J','N','NI','N','N','N','N','A',''),(901060979,'AUDISERVICIOS SAS','CR 5  59 10','2789571',1,'','','','',7112,73001,'J','P','NI','N','N','N','S','A',''),(65778487,'BERNAL LOPEZ ANA BRIGITTE','CL 83   2A SUR 35 CONJ VIVIENZA CASA 9','3186195590',0,'ANA','BRIGITTE','BERNAL','LOPEZ',0,73001,'N','E','CC','N','N','N','N','A',''),(65752837,'BOHORQUEZ CASTELLANOS ANA ISABEL','','',0,'ANA','ISABEL','BOHORQUEZ','CASTELLANO',0,73001,'N','P','CC','N','N','N','N','A',''),(860030640,'C I INDUSTRIAS HUMCAR S.A.S','AV AMERICAS   64 33','7562300',2,'','','','',0,11001,'J','P','NI','S','S','N','S','A',''),(38226268,'CAFE BARZAL','CL 60  7A 13 LC 2 SAN JERONIMO','3112082124',6,'','','','',0,73001,'N','P','CC','N','N','N','N','A',''),(93357126,'IBASEO FABRICACION DE ELEMENTOS DE ASEO','CR 2 A  16 58 LC','3158410987',0,'JAMES','CASTAÑEDA','CASTEÑEDA','FIERRO',4759,73001,'N','P','CC','N','N','N','S','A','james_casta_ibaseo@hotmail.com                    '),(800249860,'CELSIA COLOMBIA SA ESP','CL 15  29B 30','3210000',1,'','','','',3511,76892,'J','N','NI','S','S','S','S','A',''),(901009782,'CENKAP COLOMBIA SAS','CR 12   13 20','3164674463',0,'','','','',7020,25269,'J','P','NI','N','N','N','S','A','cenkapsas@gmail.com                               '),(800153993,'COMCEL SA','CR 68A  24B 10','7429797',7,'','','','',4690,11001,'J','N','','S','S','N','S','A',''),(900716800,'COMERCIALIZADORA CENTRO ORIENTE SA ESP','CR 16 A  80 36','3128318104',4,'COMECO','','','',4661,11001,'J','P','NI','N','N','N','N','A','comcentrooriente@gmail.com                        '),(830130648,'COMPAÑIA DE SERVICIOS PUBLICOS SA ESP','KM 1 PUNTO 8 VIA MADRID PUENTE PIEDRA','3138719875',0,'CODEGAS SA','','','',4661,25430,'J','P','NI','N','N','N','S','A','administracion@codegascolombia.com                '),(809010682,'CONJUNTO RESIDENCIAL MILLENIUM PRIMERA ETAPA','CRA 5 ENTRE CL 62  64 SEC ARKACENTRO','3124623361',0,'','','','',9499,73001,'J','P','NI','N','N','N','N','A','dianaromerobravo@hotmail.com                      '),(900720128,'CYMA INGENIERIAS SAS','CR 8   126  377','3186937654',8,'','','','',7730,73001,'J','P','NI','N','N','N','S','A','info@cymasas.com                                  '),(901003739,'D & N INTERNACIONAL S.A.S','CR 3 15  41 LC 11 CC LOS PANCHES','3184778569',6,'','','','',4741,73001,'J','P','NI','N','N','N','S','A','jhodorado@yahoo.com                               '),(900387788,'EMUNA MEDICAL CENTER IPS SAS','CR 8  60A  54 URB PRADOS DEL NORTE ET 2','3174274934',0,'','','','',8621,73001,'J','P','NI','N','N','N','S','A','emunasas@gmail.com                                '),(800185306,'ENVIA COLVANES SAS','CR 88   17B 10','4954711',4,'','','','',4923,11001,'J','P','NI','S','S','N','S','A',''),(93395024,'ESPINOSA ELVER','CR12  35 43','3208965746',1,'ELVER','','ESPINOSA','',4111,0,'N','P','CC','N','N','N','N','A',''),(93383600,'MADEIROS MADERA Y MOLDURA','CR 3  20 75','3157434172',0,'HERNANDO','','ESPITIA','',0,73001,'N','','CC','N','N','N','N','',''),(900017447,'FALABELLA DE COLOMBIA SA','CL 99 11 A   32 P 2','7420404',8,'','','','',4719,11001,'J','P','NI','S','S','N','S','A','impuestosfalabella@falabella.com.co               '),(80538404,'FERNANDEZ YERSON MAURICIO','CL 151 F  133 38 AP 202 BRR COMPARTIR SUBA','3202262701',3,'YERSON','MAURICIO','FERNANDEZ','',4923,11001,'N','P','CC','N','N','N','N','A','mauricio_fernandez04@hotmail.com                  '),(800196698,'FERRETERIA TUBERIAS Y HERRAMIENTAS DEL TOLIMA LTDA','AV FERROCARRIL #28-11 BRR HIPODROMO','(092) 652001',3,'','','','',4752,73001,'J','P','NI','N','N','N','S','A','ferretubertol@hotmail.com                         '),(901289365,'FORTIALAMBRE SAS','CL 16  2 91  97','3202734101',2,'','','','',3110,73001,'J','P','NI','N','N','N','S','','daniel.ramos@fortialambre.com                     '),(1110462010,'NEO DESING','CR 6  16 28','3164105903',6,'SERGIO','','GALINDO','ROZO',4761,73001,'N','P','CC','N','N','N','N','A','sergiogali@hotmail.com                            '),(1234644889,'GARCIA LOZADA KEVIN STEVE','CL 64  20 89','3207872406',0,'KEVIN','STEVE','GARCIA','LOZADA',0,73001,'N','E','CC','N','N','N','N','A',''),(1110476382,'POLARIX CAR SOUND','AV AMBALA 33  67','3125701176',1,'SERGIO','ALEJANDRO','AGUIRRE','ZUÑIGA',4530,73001,'N','P','CC','N','N','N','N','A',''),(1110473481,'ALZATE FERIA JORGE WILSON','','3132683994',0,'JORGE','WILSON','ALZATE','FERIA',0,73001,'N','E','CC','N','N','N','N','A',''),(800119432,'ANTORCHA INGENIERIA CIA LTDA','CR 1 A 11 130 OF 123','3163050091',3,'','','','',4774,25175,'J','P','NI','N','N','N','S','A','antorcha.ing@gmail.com                            '),(900147238,'APORTES EN LINEA S.A','CRA 13 # 26 A-47 PISO 12','7560606',2,'','','','',0,11001,'','','NI','','','N','','',''),(93359902,'ARISTIZABAL JOSE EVARISTO','CALLE 17 N 3-111','2623483',0,'JOSE','EVARISTO','ARISTIZABAL','',0,73001,'N','P','CC','','','N','','','bodegala17@hotmail.com                            ');

--
-- 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',3),(101,'Facturas',0),(102,'Recibos de Recaudo',0),(103,'Entradas',0),(104,'Salidas de Inventario',0),(105,'Notas Bancarias',1),(106,'Consignaciones',0),(107,'Notas Contables',0),(108,'Descuentos de Facturas',0),(109,'Cuentas Por pagar',4),(110,'Recibos de Pago',0),(111,'Comprobante de Causacion',2),(112,'Comprobante de Egreso Directo',0),(113,'Comprobante de Egreso',0),(116,'Comprobante de Depreciacion',0),(118,'Nomina',1),(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),(121,'Amortizacion Diferidos',0),(122,'Aportes parafiscales',0),(123,'Notas Debito/Credito Proveedores',0),(124,'Operacion con personas Naturales',0),(125,'Anulaciones',0),(126,'Prestaciones Sociales',0),(127,'Vacaciones',0),(120,'Traslados Bancarios',0),(128,'Retencion en la fuente',0),(129,'Avances y Anticipos',0),(130,'Transferencias',0),(131,'Provision Cartera',0),(132,'Provision Impuestos',0),(133,'Cruce de Cuentas',0),(134,'Cuentas de orden',0),(135,'Ajustes Por Inflacion',0),(136,'Intereses Cesantias',0),(137,'Aportes Seguridad Social',0),(138,'Aportes Riesgo Profesionales',0),(139,'Provision Prestaciones Sociales',0),(140,'Pagos por Cuenta',0),(141,'REEMBOLSO DE CAJA MENOR',0),(142,'Legalizaciones',0),(143,'Traslados Banco Bogotá',0),(144,'Recibos de Ingresos',0),(151,'Facturacion Electronica',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',1),(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',1),(110,'Recibos de Pago',0),(111,'Comprobante de Causacion',0),(112,'Comprobante de Ingreso',1),(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 (101,'Facturas'),(102,'Recibos de Caja'),(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'),(144,'Recibos de Ingreso');

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

INSERT INTO `tmprevmovto_niif` (`tmo_tipcom`, `tmo_numero`, `tmo_secuen`, `tmo_revela`) VALUES (111,1,1,' '),(111,1,2,' '),(100,2,10,' '),(100,2,1,' '),(100,2,8,' '),(100,2,9,' '),(100,2,2,' '),(100,2,11,' '),(109,2,1,' '),(109,2,2,' ');

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

INSERT INTO `tramites` (`tm_numero`, `tm_codare`, `tm_tidano`, `tm_fecreg`, `tm_horreg`, `tm_codcli`, `tm_estado`, `tm_califi`, `tm_feccon`, `tm_horcon`, `tm_origen`, `tm_codres`, `tm_admin`, `tm_impre`, `tm_utilid`, `tm_ivauti`) VALUES (1,0,0,'2013-03-01','10:46:16',0,'P','','0000-00-00','00:00:00','1','0',0.00,0.00,0.00,0.00);

--
-- 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 `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` varchar(20) 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,0,'GASOCOL',0,NULL,NULL,NULL,NULL,'GASOCOL','',NULL,NULL,0,0,NULL,NULL,NULL,NULL,'','','');

--
-- Dumping events for database 'antsoftw_leticia_contable'
--

--
-- Dumping routines for database 'antsoftw_leticia_contable'
--


