diff options
Diffstat (limited to 'sql-ledger/sql/Colombia-PUC-chart.sql')
| -rw-r--r-- | sql-ledger/sql/Colombia-PUC-chart.sql | 771 |
1 files changed, 0 insertions, 771 deletions
diff --git a/sql-ledger/sql/Colombia-PUC-chart.sql b/sql-ledger/sql/Colombia-PUC-chart.sql deleted file mode 100644 index 9291e3194..000000000 --- a/sql-ledger/sql/Colombia-PUC-chart.sql +++ /dev/null @@ -1,771 +0,0 @@ --- --- Plan único de Cuentas de Colombia, elaborado por Rene Real Hernandez (SDI S.A.), Francico Padilla (SDI S.A.), --- Silfredo Godoy Chavez (CaribeNet S.A.), --- Lourdes Mejía Martinez (CaribeNet S.A.) y Dirk Enrique Seiffert (CaribeNet S.A.) --- Si quieres aportar: Contactenos www.caribenet.com - info@caribenet.com --- - -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1', 'ACTIVO', 'H', 'A', '', '1'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('11', 'ACTIVO DISPONIBLE', 'H', 'A', '', '11'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1105', 'CAJA', 'H', 'A', '', '1105'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('110505', 'CAJA GENERAL', 'H', 'A', '', '110505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('110510', 'CAJAS MENORES', 'H', 'A', '', '110510'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1110', 'BANCOS', 'H', 'A', '', '1110'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('111005', 'BANCOS MONEDA NACIONAL', 'H', 'A', '', '111005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1120', 'CUENTAS DE AHORRO', 'H', 'A', '', '1120'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('112005', 'CUENTAS DE AHORRO EN BANCOS', 'H', 'A', '', '112005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('12', 'INVERSIONES', 'H', 'A', '', '12'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1205', 'ACCIONES', 'H', 'A', '', '1205'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1210', 'CUOTAS PARTES DE INTERES SOCIAL', 'H', 'A', '', '1210'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1215', 'BONOS', 'H', 'A', '', '1215'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1220', 'CEDULAS', 'H', 'A', '', '1220'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1225', 'CERTIFICADOS', 'H', 'A', '', '1225'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1230', 'PAPELES COMERCIALES', 'H', 'A', '', '1230'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1235', 'TITULOS', 'H', 'A', '', '1235'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1240', 'ACEPTACIONES BANCARIAS O FINANCI', 'H', 'A', '', '1240'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1245', 'DERECHOS FIDUCIARIOS', 'H', 'A', '', '1245'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('13', 'CUENTAS POR COBRAR', 'H', 'A', '', '13'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1305', 'CUENTAS POR COBRAR CLIENTES', 'H', 'A', '', '1305'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('130505', 'CLIENTES NACIONALES', 'H', 'A', '', '130505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('130510', 'CLIENTES DEL EXTERIOR', 'H', 'A', '', '130510'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1310', 'CUENTAS CORRIENTES COMERCIALES', 'H', 'A', '', '1310'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1330', 'ANTICIPO Y AVANCES', 'H', 'A', '', '1330'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('133005', 'ANTICIPO A PROVEEDORES', 'H', 'A', '', '133005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('133010', 'ANTICIPO A CONTRATISTAS', 'H', 'A', '', '133010'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('133015', 'ANTICIPO A TRABAJADORES', 'H', 'A', '', '133015'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1340', 'PROMESAS DE COMPRAVENTA', 'H', 'A', '', '1340'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('134005', 'DE BIENES RAICES', 'H', 'A', '', '134005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1340050001', 'Promesas Compra Venta Bienes Rai', 'A', 'A', '', '1340050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1345', 'INGRESOS POR COBRAR', 'H', 'A', '', '1345'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1350', 'RETENCIONES SOBRE CONTRATOS', 'H', 'A', '', '1350'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('135005', 'DE CONTRATOS DE CONSTRUCCION', 'H', 'A', '', '135005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('135010', 'DE PRESTACION DE SERVICIOS', 'H', 'A', '', '135010'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('135095', 'RETENCION SOBRE OTROS CONTRATOS', 'H', 'A', '', '135095'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1355', 'ANTICIPO DE IMPUESTOS', 'H', 'A', '', '1355'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('135505', 'ANTICIPO DE IMPUESTO DE RENTA', 'H', 'A', '', '135505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1355050001', 'Anticipo de Impuesto de Renta', 'A', 'A', '', '1355050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('135510', 'ANTICIPO DE IMPTO DE IND. Y CCIO', 'H', 'A', '', '135510'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1355100001', 'Anticipo de Industria y Comercio', 'A', 'A', '', '1355100001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('135515', 'RETENCION EN LA FUENTE', 'H', 'A', '', '135515'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1355150002', 'Retefuente 10% Honorarios', 'A', 'A', '', '1355150002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1355150004', 'Retefuente Alquiler Bienes R. 4%', 'A', 'A', '', '1355150004'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1355150005', 'Retefuente Obras Civiles 1%', 'A', 'A', '', '1355150005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1355150006', 'Retefuente 6% servicios', 'A', 'A', '', '1355150006'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1355150007', 'Retencion en la fuente 3.5%', 'A', 'A', '', '1355150007'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('135517', 'IMPUESTO A LAS VENTAS RETENIDO', 'H', 'A', '', '135517'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('135518', 'IMPUESTO DE IND. Y CCIO RETENIDO', 'H', 'A', '', '135518'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1355180001', 'Ica Retenido', 'A', 'A', '', '1355180001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('135520', 'SOBRANTE EN LIQUIDACION PRIVADA', 'H', 'A', '', '135520'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1355200001', 'Saldo a Favor en Renta', 'A', 'A', '', '1355200001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1355200002', 'Sobrante en Declaracion de IVA', 'A', 'A', '', '1355200002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1380', 'DEUDORES VARIOS', 'H', 'A', '', '1380'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('138020', 'CUENTAS POR COBRAR A TERCEROS', 'H', 'A', '', '138020'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1380200001', 'Cuentas por Cobrar a Terceros', 'A', 'A', '', '1380200001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('138095', 'OTROS DEUDORES VARIOS', 'H', 'A', '', '138095'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1380950001', 'Deudores Varios Otros', 'A', 'A', '', '1380950001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1390', 'DEUDAS DE DIFICIL COBRO', 'H', 'A', '', '1390'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1399', 'PROVISIONES', 'H', 'A', '', '1399'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('139905', 'PROVISION CLIENTES', 'H', 'A', '', '139905'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1399050001', 'Provision cartera Dificil Cobro', 'A', 'A', '', '1399050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('14', 'INVENTARIOS', 'H', 'A', '', '14'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1410', 'PRODUCTOS EN PROCESO', 'H', 'A', '', '1410'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('141005', 'PRODUCTOS EN PROCESO', 'H', 'A', '', '141005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('141099', 'AJ. POR INFLACION INV. EN PROCES', 'H', 'A', '', '141099'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1415', 'OBRAS DE CONSTRUCCION EN CURSO', 'H', 'A', '', '1415'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1420', 'CONTRATOS EN EJECUCION', 'H', 'A', '', '1420'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('142099', 'AJ.POR INFLACION CTOS EN EJECUCI', 'H', 'A', '', '142099'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1430', 'PRODUCTOS TERMINADOS', 'H', 'A', '', '1430'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('143005', 'PRODUCTOS MANUFACTURADOS', 'H', 'A', '', '143005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('143099', 'AJ.POR INFLACION INV.PROD.TERMIN', 'H', 'A', '', '143099'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1435', 'MERCANCIAS NO FABRICADAS', 'H', 'A', '', '1435'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('143505', 'MCIA NO FABRICADA POR LA EMPRESA', 'H', 'A', '', '143505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('143599', 'AJ.POR INFL.MCIA NO FAB.EMPRESA', 'H', 'A', '', '143599'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1465', 'INVENTARIOS EN TRANSITO', 'H', 'A', '', '1465'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('146505', 'INVENTARIOS EN TRANSITO', 'H', 'A', '', '146505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('146599', 'AJ.POR INFLACION INV.EN TRANSITO', 'H', 'A', '', '146599'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('15', 'PROPIEDAD PLANTA Y EQUIPO', 'H', 'A', '', '15'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1504', 'TERRENOS', 'H', 'A', '', '1504'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1508', 'CONSTRUCCIONES EN CURSO', 'H', 'A', '', '1508'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1512', 'MAQUINARIA Y EQUIPO EN MONTAJE', 'H', 'A', '', '1512'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1516', 'CONSTRUCCIONES Y EDIFICACIONES', 'H', 'A', '', '1516'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('151610', 'OFICINAS', 'H', 'A', '', '151610'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('151699', 'AJUSTES POR INFLACION CONSTRUCCI', 'H', 'A', '', '151699'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('15169910', 'AJ. INFL. OFICINAS - LOCALES', 'H', 'A', '', '15169910'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1520', 'MAQUINARIA Y EQUIPO', 'H', 'A', '', '1520'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('152001', 'CONTRATOS YOPAL', 'H', 'A', '', '152001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('152002', 'BODEGA', 'H', 'A', '', '152002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('152099', 'AJUSTES POR INFLACION', 'H', 'A', '', '152099'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('15209902', 'AJUSTES POR INFLACION EQ.BODEGA', 'H', 'A', '', '15209902'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1524', 'EQUIPOS DE OFICINA', 'H', 'A', '', '1524'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('152405', 'MUEBLES Y ENSERES', 'H', 'A', '', '152405'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('152410', 'EQUIPOS', 'H', 'A', '', '152410'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('152499', 'AJUSTES POR INFLACION', 'H', 'A', '', '152499'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('15249910', 'AJUSTES POR INFLACION', 'H', 'A', '', '15249910'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1528', 'EQUIPOS DE COMPUTACION Y COMUNIC', 'H', 'A', '', '1528'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('152805', 'EQUIPOS DE PROCESAMIENTO DE DATO', 'H', 'A', '', '152805'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1528050001', 'Cinco Computadores', 'A', 'A', '', '1528050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('152899', 'AJUSTES POR INFLACION', 'H', 'A', '', '152899'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('15289905', 'AJ. INFL. EQ. PROCESAMIENTO DATO', 'H', 'A', '', '15289905'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1528990501', 'Aj. por Inflac. Cinco Computador', 'A', 'A', '', '1528990501'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1540', 'FLOTA Y EQUIPO DE TRANSPORTE', 'H', 'A', '', '1540'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('154005', 'AUTOS, CAMIONETAS Y CAMPEROS', 'H', 'A', '', '154005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('154099', 'AJUSTES POR INFLACION', 'H', 'A', '', '154099'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('15409905', 'AJ. INFL. AUTOS CAMPEROS CMIONET', 'H', 'A', '', '15409905'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1540990501', 'Aj. Infl. Autos y Camperos', 'A', 'A', '', '1540990501'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1592', 'DEPRECIACION ACUMULADA', 'H', 'A', '', '1592'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('159205', 'DEPREC.DE CONSTRUCCIONES Y EDIFI', 'H', 'A', '', '159205'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('159210', 'DEPREC. MAQUINARIA Y EQUIPO', 'H', 'A', '', '159210'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('159215', 'DEPRECIACION EQUIPO DE OFICINA', 'H', 'A', '', '159215'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('159220', 'DEPRECIACION EQ. COMPUTACION Y C', 'H', 'A', '', '159220'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1592200001', 'Depreciacion Cinco Computadores', 'A', 'A', '', '1592200001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('159235', 'DEPRECIACION FLOTA DE TRANSPORTE', 'H', 'A', '', '159235'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('159299', 'AJUSTES POR INFLACION', 'H', 'A', '', '159299'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1592990005', 'Aj.Infl. Construc. y Edificacion', 'A', 'A', '', '1592990005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1592990010', 'Aj.Infl. Maquinaria y Equipo', 'A', 'A', '', '1592990010'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1592990015', 'Aj. Infl. Equipos de Oficina', 'A', 'A', '', '1592990015'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1592990020', 'Aj. Infl. Eq. Computac. y Comuni', 'A', 'A', '', '1592990020'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1592990035', 'Aj. Infl. Flota y Eq. de transpo', 'A', 'A', '', '1592990035'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('19', 'VALORIZACIONES', 'H', 'A', '', '19'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1905', 'VALORIZACIONES DE INVERSIONES', 'H', 'A', '', '1905'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1910', 'DE PROPIEDAD PLANTA Y EQUIPOS', 'H', 'A', '', '1910'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('191008', 'DE CONSTRUCCIONES Y EDIFICACIONE', 'H', 'A', '', '191008'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1995', 'VALORIZACION DE OTROS ACTIVOS', 'H', 'A', '', '1995'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2', 'PASIVOS', 'H', 'L', '', '2'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('21', 'OBLIGACIONES FINANCIERAS', 'H', 'L', '', '21'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2105', 'BANCOS NACIONALES', 'H', 'L', '', '2105'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('210505', 'SOBREGIROS', 'H', 'L', '', '210505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2105050001', 'Sobregiros Bancarios', 'A', 'L', '', '2105050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('210510', 'PAGARES', 'H', 'L', '', '210510'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2105100001', 'Pagares', 'A', 'L', '', '2105100001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2130', 'ENTIDADES FINANCIERAS DEL EXTERI', 'H', 'L', '', '2130'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2145', 'OBLIGACIONES GUBERNAMENTALES', 'H', 'L', '', '2145'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2195', 'OTRAS OBLIGACIONES', 'H', 'L', '', '2195'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('219505', 'OBLIGACIONES CON PARTICULARES', 'H', 'L', '', '219505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2195050001', 'Otras obligaciones con Particula', 'A', 'L', '', '2195050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('219510', 'OBLIGACIONES COMPA?IAS VINCULADA', 'H', 'L', '', '219510'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('22', 'PROVEEDORES', 'H', 'L', '', '22'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2205', 'PROVEEDORES NACIONALES', 'H', 'L', '', '2205'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('220505', 'PROVEEDORES NACIONALES', 'H', 'L', '', '220505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('23', 'CUENTAS POR PAGAR', 'H', 'L', '', '23'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2320', 'CUENTAS POR PAGAR A CONTRATISTAS', 'H', 'L', '', '2320'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('232005', 'CUENTAS POR PAGAR A CONTRATISTAS', 'H', 'L', '', '232005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2335', 'COSTOS Y GASTOS POR PAGAR', 'H', 'L', '', '2335'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('233505', 'GASTOS FINANCIEROS', 'H', 'L', '', '233505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('233510', 'GASTOS LEGALES', 'H', 'L', '', '233510'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('233515', 'LIBROS SUSCRIPCIONES PERIODICOS', 'H', 'L', '', '233515'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('233520', 'COMISIONES', 'H', 'L', '', '233520'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('233525', 'HONORARIOS', 'H', 'L', '', '233525'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('233530', 'SERVICIOS TECNICOS', 'H', 'L', '', '233530'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('233535', 'SERVICIOS DE MANTENIMIENTO', 'H', 'L', '', '233535'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('233540', 'ARRENDAMIENTOS', 'H', 'L', '', '233540'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('233545', 'TRANSPORTES FLETES Y ACARREOS', 'H', 'L', '', '233545'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('233550', 'SERVICIOS PUBLICOS', 'H', 'L', '', '233550'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('233555', 'SEGUROS', 'H', 'L', '', '233555'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('233560', 'GASTOS DE VIAJE', 'H', 'L', '', '233560'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('233565', 'GASTOS DE REPRESENTACION Y RELAC', 'H', 'L', '', '233565'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('233570', 'SERVICIOS ADUANEROS', 'H', 'L', '', '233570'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('233595', 'OTROS COSTOS Y GASTOS POR PAGAR', 'H', 'L', '', '233595'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2355', 'DEUDAS CON SOCIOS Y ACCIONISTAS', 'H', 'L', '', '2355'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('235505', 'ACCIONISTAS', 'H', 'L', '', '235505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('235510', 'SOCIOS', 'H', 'L', '', '235510'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2360', 'DIVIDENDOS O PARTICIPACION POR P', 'H', 'L', '', '2360'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('236005', 'DIVIDENDOS POR PAGAR', 'H', 'L', '', '236005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('236010', 'PARTICIPACIONES POR PAGAR', 'H', 'L', '', '236010'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365', 'RETENCION EN LA FUENTE', 'H', 'L', '', '2365'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('236505', 'SALARIOS Y PAGOS LABORALES', 'H', 'L', '', '236505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('236510', 'DIVIDENDO Y/O PARTICIPACIONES', 'H', 'L', '', '236510'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('236515', 'HONORARIOS', 'H', 'L', '', '236515'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('236520', 'COMISIONES', 'H', 'L', '', '236520'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('236525', 'SERVICIOS', 'H', 'L', '', '236525'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365250002', 'Servicios Hoteleros 3.5%', 'A', 'L', '', '2365250002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('236530', 'ARRENDAMIENTOS', 'H', 'L', '', '236530'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365300002', 'Arriendo Inmuebles 4%', 'A', 'L', '', '2365300002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('236535', 'RENDIMIENTOS FINANCIERSO', 'H', 'L', '', '236535'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('236540', 'RETENCION POR COMPRAS', 'H', 'L', '', '236540'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2368', 'IMPTO DE IND. Y CCIO RETENIDO', 'H', 'L', '', '2368'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('236801', 'SECTOR INDUSTRIAL', 'H', 'L', '', '236801'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2368010003', 'Demas Activ. Industriales 7xmil', 'A', 'L', '', '2368010003'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('236802', 'SECTOR COMERCIAL', 'H', 'L', '', '236802'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2368020004', 'Demas Activ. Comerciales 7xmil', 'A', 'L', '', '2368020004'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('236803', 'SECTOR SERVICIOS', 'H', 'L', '', '236803'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2368030001', 'Retencin ICA 6xMil', 'A', 'L', '', '2368030001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2368030009', 'Demas Activ. Servicios 8xmil', 'A', 'L', '', '2368030009'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2370', 'RETENCIONES Y APORTES DE NOMINA', 'H', 'L', '', '2370'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('237005', 'APORTES A EPS', 'H', 'L', '', '237005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2370050001', 'Aportes a EPS', 'A', 'L', '', '2370050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('237006', 'APORTES A ARP', 'H', 'L', '', '237006'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('237010', 'APORTES A IDBF, SENA Y CAJAS COM', 'H', 'L', '', '237010'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2380', 'ACREEDORES VARIOS', 'H', 'L', '', '2380'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('238030', 'FONDOS DE CESANTIAS Y/O PENSION', 'H', 'L', '', '238030'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('238095', 'VARIOS', 'H', 'L', '', '238095'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('24', 'IMPUESTOS GRAVAMENES Y TASAS', 'H', 'L', '', '24'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2404', 'IMPUESTO DE RENTA', 'H', 'L', '', '2404'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('240405', 'VIGENCIA FISCAL CORRIENTE', 'H', 'L', '', '240405'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2404050001', 'IMPORENTA VIGENCIA ACTUAL', 'A', 'L', '', '2404050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('240410', 'VIGENCIAS FISCALES ANTERIORES', 'H', 'L', '', '240410'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2404100001', 'IMPORENTA VIGENCIA ANTERIORES', 'A', 'L', '', '2404100001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2408', 'IMPUESTO A LAS VENTAS POR PAGAR', 'H', 'L', '', '2408'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('240805', 'IVA DESCONTABLE', 'H', 'L', '', '240805'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('240810', 'IVA GENERADO EN VENTAS', 'H', 'L', '', '240810'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('240815', 'IMPUESTOS POR PAGAR ANTERIORES', 'H', 'L', '', '240815'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2408150001', 'ViGencia Fiscal Anterior', 'A', 'L', '', '2408150001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2412', 'IMPUESTO DE IND. Y COMERCIO', 'H', 'L', '', '2412'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('241205', 'VIGENCIA FISCAL CORRIENTE', 'H', 'L', '', '241205'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2412050001', 'ICA POR PAGAR', 'A', 'L', '', '2412050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('241210', 'VIGENCIAS FISCALES ANTERIORES', 'H', 'L', '', '241210'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('25', 'OBLIGACIONES LABORALES', 'H', 'L', '', '25'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2505', 'SALARIOS POR PAGAR', 'H', 'L', '', '2505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('250505', 'NOMINA POR PAGAR', 'H', 'L', '', '250505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2510', 'CESANTIAS CONSOLIDADAS', 'H', 'L', '', '2510'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2515', 'INTERESES SOBRE CESANTIAS', 'H', 'L', '', '2515'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2520', 'PRIMA DE SERVICIOS', 'H', 'L', '', '2520'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2525', 'VACACIONES CONSOLIDADAS', 'H', 'L', '', '2525'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2530', 'PRESTACIONES EXTRALEGALES', 'H', 'L', '', '2530'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('26', 'PASIVOS ESTIMADOS Y PROVISIONES', 'H', 'L', '', '26'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2605', 'PARA COSTOS Y GASTOS', 'H', 'L', '', '2605'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('260515', 'HONORARIOS', 'H', 'L', '', '260515'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('260525', 'TRANSPORTES FLETES Y ACARREOS', 'H', 'L', '', '260525'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('260530', 'GASTOS DE VIAJE', 'H', 'L', '', '260530'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2610', 'PARA OBLIGACIONES LABORALES', 'H', 'L', '', '2610'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('261005', 'CESANTIAS', 'H', 'L', '', '261005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('261010', 'INTERESES SOBRE CESANTIAS', 'H', 'L', '', '261010'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('261015', 'VACACIONES', 'H', 'L', '', '261015'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('261020', 'PRIMA DE SERVICIOS', 'H', 'L', '', '261020'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2615', 'PARA OBLIGACIONES FISCALES', 'H', 'L', '', '2615'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('261505', 'DE RENTA Y COMPLEMENTARIOS', 'H', 'L', '', '261505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2615050001', 'Impuesto de Renta y Complementar', 'A', 'L', '', '2615050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('261510', 'DE INDUSTRIA Y COMERCIO', 'H', 'L', '', '261510'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('261595', 'OTROS', 'H', 'L', '', '261595'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2630', 'PARA MANTENIMIENTO Y REPARACION', 'H', 'L', '', '2630'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2635', 'PARA CONTINGENCIAS', 'H', 'L', '', '2635'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('263505', 'MULTAS SANCIONES Y LITIGIOS', 'H', 'L', '', '263505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('263510', 'INTERESES POR MULTAS Y SANCIONES', 'H', 'L', '', '263510'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('28', 'OTROS PASIVOS', 'H', 'L', '', '28'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2805', 'ANTICIPOS Y AVANCES RECIBIDOS', 'H', 'L', '', '2805'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('280505', 'DE CLIENTES', 'H', 'L', '', '280505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('280510', 'SOBRE CONTRATOS', 'H', 'L', '', '280510'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2805100001', 'Anticipo Recibido Sobre Contrato', 'A', 'L', '', '2805100001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('280515', 'PARA OBRAS EN PROCESO', 'H', 'L', '', '280515'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2815', 'INGRESOS RECIBIDOS PARA TERCEROS', 'H', 'L', '', '2815'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('281505', 'VALORES RECIBIDOS PARA TERCEROS', 'H', 'L', '', '281505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('281510', 'VENTA POR CUENTA DE TERCEROS', 'H', 'L', '', '281510'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2825', 'RETENCION A TERCEROS SOBRE CONTR', 'H', 'L', '', '2825'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('282505', 'CUMPLIMIENTO OBLIGACIONES LABORA', 'H', 'L', '', '282505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3', 'PATRIMONIO', 'H', 'Q', '', '3'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('31', 'CAPITAL SOCIAL', 'H', 'Q', '', '31'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3105', 'CAPITAL SUSCRITO Y PAGADO', 'H', 'Q', '', '3105'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('310505', 'CAPITAL AUTORIZADO', 'H', 'Q', '', '310505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3105050001', 'Capital Suscrito y Pagado', 'A', 'Q', '', '3105050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('310510', 'CAPITAL POR SUSCRIBIR (DB)', 'H', 'Q', '', '310510'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('310515', 'CAPITAL SUSCRITO POR COBRAR (DB)', 'H', 'Q', '', '310515'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3115', 'APORTES SOCIALES', 'H', 'Q', '', '3115'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('33', 'RESERVAS', 'H', 'Q', '', '33'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3305', 'RESERVAS OBLIGATORIAS', 'H', 'Q', '', '3305'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('330505', 'RESERVA LEGAL', 'H', 'Q', '', '330505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3305050001', 'Reserva Legal', 'A', 'Q', '', '3305050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3310', 'RESERVAS ESTATUTARIAS', 'H', 'Q', '', '3310'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3315', 'RESERVAS OCASIONALES', 'H', 'Q', '', '3315'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('34', 'REVALORIZACION DEL PATRIMONIO', 'H', 'Q', '', '34'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3405', 'AJUSTES POR INFLACION', 'H', 'Q', '', '3405'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('340505', 'DE CAPITAL SOCIAL', 'H', 'Q', '', '340505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3405050001', 'AxI CAPITAL', 'A', 'Q', '', '3405050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('340510', 'DE SUPERAVIT DE CAPITAL', 'H', 'Q', '', '340510'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('340515', 'DE RESERVAS', 'H', 'Q', '', '340515'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3405150001', 'AxI RESERVA LEGAL', 'A', 'Q', '', '3405150001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('340520', 'DE RESULTADO DE EJERC. ANTERIORE', 'H', 'Q', '', '340520'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3405200001', 'AxI RESULTADOS ANTERIORES', 'A', 'Q', '', '3405200001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('340525', 'DE ACTIVOS DE PERIODO IMPRODUCTI', 'H', 'Q', '', '340525'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('340530', 'DE SANEAMIENTO FISCAL', 'H', 'Q', '', '340530'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('340535', 'DE AJUSTES DECRETO 3019 DE 1989', 'H', 'Q', '', '340535'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('340540', 'DE DIVIDENDOS Y PARTICIPACIONES', 'H', 'Q', '', '340540'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('340545', 'SUPERAVIT METODO DE PARTICIPACIO', 'H', 'Q', '', '340545'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('36', 'RESULTADOS DE EJERCICIO', 'H', 'Q', '', '36'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3605', 'UTILIDAD DEL EJERCICIO', 'H', 'Q', '', '3605'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('360505', 'UTILIDAD DEL EJERCICIO', 'H', 'Q', '', '360505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3605050001', 'Utilidad del Ejercicio', 'A', 'Q', '', '3605050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3605050002', 'Utilidad de Ajustes por Inflacio', 'A', 'Q', '', '3605050002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3610', 'PERDIDAS DEL EJERCICIO', 'H', 'Q', '', '3610'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('361005', 'PERDIDA DEL EJERCICIO', 'H', 'Q', '', '361005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3610050001', 'Perdida del Ejercicio', 'A', 'Q', '', '3610050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('37', 'RESULTADOS EJERCICIOS ANRERIORES', 'H', 'Q', '', '37'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3705', 'UTILIDADES ACUMULADAS', 'H', 'Q', '', '3705'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('370510', 'UTILIDADES ACUMULADAS', 'H', 'Q', '', '370510'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3705100001', 'Utilidades Acumuladas', 'A', 'Q', '', '3705100001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3710', 'PERDIDAS ACUMULADAS', 'H', 'Q', '', '3710'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('371010', 'PERDIDAS ACUMULADAS', 'H', 'Q', '', '371010'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3710100001', 'Perdidas Acumuladas', 'A', 'Q', '', '3710100001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('38', 'SUPERAVIT POR VALORIZACIONES', 'H', 'Q', '', '38'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3805', 'DE INVERSIONES', 'H', 'Q', '', '3805'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('380505', 'DE ACCIONES', 'H', 'Q', '', '380505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('380510', 'CUOTAS O PARTES DE INTERES SOCIA', 'H', 'Q', '', '380510'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3810', 'DE PROPIEDAD PLANTA Y EQUIPO', 'H', 'Q', '', '3810'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('381008', 'CONSTRUCCIONES Y EDIFICACIONES', 'H', 'Q', '', '381008'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3810080001', 'Superavit por Valorizacion C y E', 'A', 'Q', '', '3810080001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3895', 'DE OTROS ACTIVOS', 'H', 'Q', '', '3895'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4', 'INGRESOS', 'H', 'I', '', '4'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('41', 'INGRESOS OPERACIONALES', 'H', 'I', '', '41'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4120', 'INDUSTRIA MANUFACTURERA', 'H', 'I', '', '4120'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4130', 'CONSTRUCCION', 'H', 'I', '', '4130'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('413005', 'PREPARACION DE TERRENOS', 'H', 'I', '', '413005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('413010', 'CONSTRUCCION Y OBRAS CIVILES', 'H', 'I', '', '413010'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('413025', 'ALQUILER DE EQUIPOS CON OPERARIO', 'H', 'I', '', '413025'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('413095', 'ACTIVIDADES CONEXAS', 'H', 'I', '', '413095'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4135', 'COMERCIO AL POR MAYOR', 'H', 'I', '', '4135'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('413595', 'ACTIVIDADES CONEXAS', 'H', 'I', '', '413595'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4150', 'ACTIVIDAD FINANCIERA', 'H', 'I', '', '4150'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('415030', 'COMISIONES', 'H', 'I', '', '415030'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4175', 'DEVOLUCIONES EN VENTAS', 'H', 'I', '', '4175'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('417505', 'DEVOLUCIONES EN VENTAS', 'H', 'I', '', '417505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4175050001', 'Devoluciones en Ventas', 'A', 'I', '', '4175050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4175050002', 'Descuento en Ventas', 'A', 'I', '', '4175050002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('42', 'INGRESOS NO OPERACIONALES', 'H', 'I', '', '42'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4205', 'OTRAS VENTAS', 'H', 'I', '', '4205'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('420505', 'MATERIA PRIMA', 'H', 'I', '', '420505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('420510', 'MATERIAL DE DESECHO', 'H', 'I', '', '420510'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4210', 'INGRESOS FINANCIEROS', 'H', 'I', '', '4210'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('421005', 'INTERESES', 'H', 'I', '', '421005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('421040', 'DESCUENTOS COMERCIALES CONDICION', 'H', 'I', '', '421040'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4210400001', 'Descuentos Financieros', 'A', 'I', '', '4210400001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4215', 'DIVIDENDOS Y PARTICIPACIONES', 'H', 'I', '', '4215'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4220', 'ARRENDAMIENTOS', 'H', 'I', '', '4220'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('422010', 'CONSTRUCCIONES Y EDIFICACIONES', 'H', 'I', '', '422010'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('422015', 'MAQUINARIA Y EQUIPOS', 'H', 'I', '', '422015'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4225', 'COMISIONES', 'H', 'I', '', '4225'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4230', 'HONORARIOS', 'H', 'I', '', '4230'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4235', 'SERVICIOS', 'H', 'I', '', '4235'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('423595', 'OTROS SERVICIOS', 'H', 'I', '', '423595'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4240', 'UTILIDAD EN VENTA DE INVERSIONES', 'H', 'I', '', '4240'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4245', 'UTIL.EN VENTA PROP.PLANTA Y EQUI', 'H', 'I', '', '4245'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4250', 'RECUPERACIONES', 'H', 'I', '', '4250'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('425005', 'DEUDAS MALAS', 'H', 'I', '', '425005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('425015', 'RECLAMOS', 'H', 'I', '', '425015'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4255', 'INDEMNIZACIONES', 'H', 'I', '', '4255'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4260', 'PARTICIPACION EN CONCESIONES', 'H', 'I', '', '4260'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4265', 'INGRESOS DE EJERCICIOS ANTERIORE', 'H', 'I', '', '4265'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4275', 'DEVOLUCIONES EN OTRAS VENTAS', 'H', 'I', '', '4275'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4295', 'DIVERSOS', 'H', 'I', '', '4295'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('429503', 'CERT', 'H', 'I', '', '429503'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('429505', 'APROVECHAMIENTOS', 'H', 'I', '', '429505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('429507', 'AUXILIOS', 'H', 'I', '', '429507'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('429533', 'MULTAS Y RECARGOS', 'H', 'I', '', '429533'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('429535', 'PREAVISOS DESCONTADOS', 'H', 'I', '', '429535'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('429537', 'RECLAMOS', 'H', 'I', '', '429537'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('429553', 'SOBRANTES DE CAJA', 'H', 'I', '', '429553'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('429581', 'AJUSTE AL PESO', 'H', 'I', '', '429581'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('429583', 'LLAMADAS TELEFONICAS', 'H', 'I', '', '429583'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('47', 'AJUSTES POR INFLACION', 'H', 'I', '', '47'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705', 'CORRECCION MONETARIA', 'H', 'I', '', '4705'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('470505', 'INVERSIONES (CR)', 'H', 'I', '', '470505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('470510', 'INVENTARIOS (CR)', 'H', 'I', '', '470510'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705100005', 'Inventario Materia Prima', 'A', 'I', '', '4705100005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705100010', 'Inventario Productos en Proceso', 'A', 'I', '', '4705100010'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705100015', 'Obras de construccion en curso', 'A', 'I', '', '4705100015'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705100020', 'Inventario contratos en ejecucio', 'A', 'I', '', '4705100020'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705100030', 'Inventario Producto terminado', 'A', 'I', '', '4705100030'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705100035', 'Inv. Mercancia no Fabricada', 'A', 'I', '', '4705100035'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705100065', 'Inventarios en transito', 'A', 'I', '', '4705100065'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('470515', 'PROPIEDAD PLANTA Y EQUIPO (CR)', 'H', 'I', '', '470515'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705150001', 'Terrenos', 'A', 'I', '', '4705150001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705150003', 'Construcciones en Curso', 'A', 'I', '', '4705150003'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705150004', 'Maquinaria y Equipo en Montaje', 'A', 'I', '', '4705150004'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705150005', 'Construcciones y Edificaciones', 'A', 'I', '', '4705150005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705150006', 'Maquinaria y Equipos', 'A', 'I', '', '4705150006'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705150007', 'Equipos de Oficina', 'A', 'I', '', '4705150007'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705150008', 'Equipos de Computacion y comunic', 'A', 'I', '', '4705150008'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705150011', 'Flota y Equipo de transporte', 'A', 'I', '', '4705150011'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('470540', 'PATRIMONIO', 'H', 'I', '', '470540'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705400001', 'Aj. por Infl. Patrimonio', 'A', 'I', '', '4705400001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('470545', 'DEPRECIACION ACUMULADA (DB)', 'H', 'I', '', '470545'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705450001', 'Depreciacion Acumulada (DB)', 'A', 'I', '', '4705450001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('470550', 'DEPRECIACION DIFERIDA (CR)', 'H', 'I', '', '470550'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('470560', 'AMORTIZACION ACUMULADA (DB)', 'H', 'I', '', '470560'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5', 'GASTOS', 'H', 'E', '', '5'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('51', 'GASTOS OPERACIONALES DE ADMON.', 'H', 'E', '', '51'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5105', 'GASTOS DE PERSONAL', 'H', 'E', '', '5105'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('510548', 'BONIFICACION', 'H', 'E', '', '510548'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('52', 'GASTOS OPERACIONALES DE VENTAS', 'H', 'E', '', '52'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205', 'GASTOS DE PERSONAL', 'H', 'E', '', '5205'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('520506', 'SUELDOS', 'H', 'E', '', '520506'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('520527', 'AUXILIO DE TRANSPORTE', 'H', 'E', '', '520527'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('520530', 'CESANTIAS', 'H', 'E', '', '520530'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('520533', 'INTERESES SOBRE CESANTIAS', 'H', 'E', '', '520533'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205330001', 'Intereses Sobre Cesantias', 'A', 'E', '', '5205330001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('520536', 'PRIMAS DE SERVICIOS', 'H', 'E', '', '520536'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('520539', 'VACACIONES', 'H', 'E', '', '520539'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('520548', 'BONIFICACIONES', 'H', 'E', '', '520548'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205480001', 'Bonificaciones a Empleados', 'A', 'E', '', '5205480001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('520563', 'CAPACITACION AL PERSONAL', 'H', 'E', '', '520563'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205630001', 'Capacitacion al Personal', 'A', 'E', '', '5205630001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('520568', 'APORTES ARP', 'H', 'E', '', '520568'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('520569', 'APORTES EPS', 'H', 'E', '', '520569'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('520570', 'APORTES A FONDO DE PENSIONES/CES', 'H', 'E', '', '520570'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('520572', 'APORTES CAJAS DE COMPENSACION', 'H', 'E', '', '520572'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('520575', 'APORTES ICBF', 'H', 'E', '', '520575'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('520578', 'APORTES SENA', 'H', 'E', '', '520578'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('520595', 'OTROS GASTOS DE PERSONAL', 'H', 'E', '', '520595'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205950001', 'Otros Gastos de personal', 'A', 'E', '', '5205950001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5210', 'HONORARIOS', 'H', 'E', '', '5210'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('521005', 'JUNTA DIRECTIVA', 'H', 'E', '', '521005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('521010', 'REVISORIA FISCAL', 'H', 'E', '', '521010'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('521015', 'AUDITORIA EXTERNA', 'H', 'E', '', '521015'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('521025', 'ASESORIA JURIDICA', 'H', 'E', '', '521025'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('521030', 'ASESORIA FINANCIERA', 'H', 'E', '', '521030'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('521035', 'ASESORIA TECNICA', 'H', 'E', '', '521035'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('521095', 'OTROS HONORARIOS', 'H', 'E', '', '521095'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5210950001', 'Estudio y Dise¤o de Planos', 'A', 'E', '', '5210950001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5215', 'IMPUESTOS', 'H', 'E', '', '5215'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('521505', 'INDUSTRIA Y COMERCIO', 'H', 'E', '', '521505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5215050001', 'Impuesto de Industria y Comercio', 'A', 'E', '', '5215050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('521510', 'DE TIMBRES', 'H', 'E', '', '521510'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5215100001', 'Impuesto de Timbre', 'A', 'E', '', '5215100001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('521515', 'IMPUESTOS A LA PROPIEDAD RAIZ', 'H', 'E', '', '521515'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5215200001', 'DERECHOS SOBRE INSTRUMENTOS PUBL', 'A', 'E', '', '5215200001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('521540', 'IMPUESTOS SOBRE VEHICULOS', 'H', 'E', '', '521540'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5215400001', 'Impuestos Sobre Vehiculos', 'A', 'E', '', '5215400001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('521595', 'OTROS IMPUESTOS', 'H', 'E', '', '521595'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5220', 'ARRENDAMIENTOS', 'H', 'E', '', '5220'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('522010', 'CONSTRUCCIONES U EDIFICACIONES', 'H', 'E', '', '522010'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('522015', 'MAQUINARIA Y EQUIPO', 'H', 'E', '', '522015'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5220150001', 'Arriendo Maquinaria y Equipo', 'A', 'E', '', '5220150001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('522025', 'EQUIPOS DE COMPUTACION Y COMUNIC', 'H', 'E', '', '522025'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5220250001', 'Alquiler Eq. Computacion y Comun', 'A', 'E', '', '5220250001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('522040', 'FLOTA Y EQUIPO DE TRANSPORTE', 'H', 'E', '', '522040'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5220400001', 'Alquiler de Vehiculos y Camiones', 'A', 'E', '', '5220400001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5230', 'SEGUROS', 'H', 'E', '', '5230'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523005', 'MANEJO', 'H', 'E', '', '523005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523010', 'CUMPLIMIENTO', 'H', 'E', '', '523010'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5230100001', 'Polizas de Cumplimiento', 'A', 'E', '', '5230100001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523040', 'FLOTA Y EQUIPO DE TRANSPORTE', 'H', 'E', '', '523040'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523075', 'OBLIGATORIO ACCIDENTES DE TRANSI', 'H', 'E', '', '523075'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235', 'SERVICIOS', 'H', 'E', '', '5235'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523505', 'ASEO Y VIGILANCIA', 'H', 'E', '', '523505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523515', 'ASSITENCIA TECNICA', 'H', 'E', '', '523515'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523520', 'PROCESAMIENTO ELECTRONICO DE DAT', 'H', 'E', '', '523520'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235200001', 'Procesamiento electronico de Dat', 'A', 'E', '', '5235200001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523525', 'ACUEDUCTO Y ALCANTARILLADO', 'H', 'E', '', '523525'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523530', 'ENERGIA ELECTRICA', 'H', 'E', '', '523530'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523535', 'TELEFONO', 'H', 'E', '', '523535'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523540', 'CORREO PORTES Y TELEGRAMAS', 'H', 'E', '', '523540'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523545', 'FAX Y TELEX', 'H', 'E', '', '523545'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235450001', 'fax y Telex', 'A', 'E', '', '5235450001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523550', 'TRANSPORTES FLETES Y ACARREOS', 'H', 'E', '', '523550'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523555', 'GAS', 'H', 'E', '', '523555'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523560', 'PUBLICIDAD PROPAGANDA Y PROMOCIO', 'H', 'E', '', '523560'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235600001', 'Publicidad Propaganda y Promocio', 'A', 'E', '', '5235600001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523595', 'OTROS SERVICIOS', 'H', 'E', '', '523595'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235950002', 'Fabricacion y Elaboracion', 'A', 'E', '', '5235950002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235950004', 'Capacitacion a Contratistas', 'A', 'E', '', '5235950004'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235950007', 'Digitación y archivo documentos', 'A', 'E', '', '5235950007'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5240', 'GASTOS LEGALES', 'H', 'E', '', '5240'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('524005', 'NOTARIALES', 'H', 'E', '', '524005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('524010', 'REGISTRO MERCANTIL', 'H', 'E', '', '524010'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5240100001', 'Registro Mercantil', 'A', 'E', '', '5240100001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('524015', 'TRAMITES Y LICENCIAS', 'H', 'E', '', '524015'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('524095', 'OTROS GASTOS LEGALES', 'H', 'E', '', '524095'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5240950001', 'Tramite de Vehiculos', 'A', 'E', '', '5240950001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5240950003', 'Sobretasa', 'A', 'E', '', '5240950003'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5240950004', 'Dcmtos Varios en Camara Comercio', 'A', 'E', '', '5240950004'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5240950005', 'Floio para Libros Legales', 'A', 'E', '', '5240950005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5240950006', 'Impuesto para preservar la Segur', 'A', 'E', '', '5240950006'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5245', 'MANTENIMIENTO Y REPARACIONES', 'H', 'E', '', '5245'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('524510', 'CONSTRUCCIONES Y EDIFICACIONES', 'H', 'E', '', '524510'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5245100001', 'Construcciones y Edificaciones', 'A', 'E', '', '5245100001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('524515', 'MAQUINARIA Y EQUIPOS', 'H', 'E', '', '524515'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5245150001', 'Equipo de Refrigeracion', 'A', 'E', '', '5245150001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5245150002', 'Equipos de Ingenieria Civil', 'A', 'E', '', '5245150002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5245150003', 'Repuestos y Herramientas', 'A', 'E', '', '5245150003'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('524520', 'EQUIPO DE OFICINA', 'H', 'E', '', '524520'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5245200001', 'Equipo de Oficina', 'A', 'E', '', '5245200001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('524525', 'EQUIPO DE COMPUTACION Y COMUNICA', 'H', 'E', '', '524525'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5245250001', 'Mtto y Rep. Eq. Computacion y Co', 'A', 'E', '', '5245250001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('524540', 'FLOTA Y EQUIPO DE TRANSPORTE', 'H', 'E', '', '524540'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5245400001', 'Mantenimiento de Vehiculos', 'A', 'E', '', '5245400001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5250', 'ADECUACION E INSTALACION', 'H', 'E', '', '5250'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('525005', 'INSTALACIONES ELECTRICAS', 'H', 'E', '', '525005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5250050001', 'Instalaciones Electricas', 'A', 'E', '', '5250050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('525010', 'ARREGLOS ORNAMENTALES', 'H', 'E', '', '525010'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('525015', 'REPARACIONES LOCATIVAS', 'H', 'E', '', '525015'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('525095', 'OTROS ADECUACIONES E INSTALACION', 'H', 'E', '', '525095'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5255', 'GASTOS DE VIAJE', 'H', 'E', '', '5255'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('525505', 'ALOJAMIENTO Y MANUTENCION', 'H', 'E', '', '525505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('525515', 'PASAJES AEREOS', 'H', 'E', '', '525515'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('525520', 'PASAJES TERRESTRES', 'H', 'E', '', '525520'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5255200001', 'Pasajes Terrestres', 'A', 'E', '', '5255200001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('525595', 'OTROS GASTOS DE VIAJE', 'H', 'E', '', '525595'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5255950002', 'Llamadas Telefonicas en Viajes', 'A', 'E', '', '5255950002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5260', 'DEPRECIACIONES', 'H', 'E', '', '5260'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('526005', 'CONSTRUCCIONES Y EDIFICACIONES', 'H', 'E', '', '526005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5260050001', 'Depreciacion Locales Tequendama', 'A', 'E', '', '5260050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('526010', 'MAQUINARIA Y EQUIPO', 'H', 'E', '', '526010'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5260100001', 'Depreciacion de maq. y Equipos', 'A', 'E', '', '5260100001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('526015', 'EQUIPOS DE OFICINA', 'H', 'E', '', '526015'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5260150001', 'Depreciacion Equipos de Oficina', 'A', 'E', '', '5260150001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('526020', 'EQUIPOS DE COMPUTACION Y COMUNIC', 'H', 'E', '', '526020'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5260200001', 'Depreciacion Eq. de Computacion', 'A', 'E', '', '5260200001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('526035', 'FLOTA Y EQUIPO DE TRANSPORTE', 'H', 'E', '', '526035'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5260350001', 'Depreciacion de Vehiculos', 'A', 'E', '', '5260350001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('526099', 'AJUSTES POR INLFACION', 'H', 'E', '', '526099'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5260990005', 'Aj. Infl. Construcciones y Edif.', 'A', 'E', '', '5260990005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5260990010', 'Aj. Infl. Maquinaria y Equipo', 'A', 'E', '', '5260990010'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5260990015', 'Aj. Infl. Equipos de Oficina', 'A', 'E', '', '5260990015'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5260990020', 'Aj. Infl. Eq. Computacion y Com.', 'A', 'E', '', '5260990020'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5260990035', 'Aj. Infl. Vehiculos', 'A', 'E', '', '5260990035'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5295', 'GASTOS DIVERSOS', 'H', 'E', '', '5295'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('529505', 'COMISIONES', 'H', 'E', '', '529505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('529510', 'LIBROS SUSCRIPCIONES PERIODICOS', 'H', 'E', '', '529510'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5295100001', 'Libros Suscripciones periodicos', 'A', 'E', '', '5295100001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('529520', 'GASTOS DE REPRESENTACION Y REL.P', 'H', 'E', '', '529520'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5295200001', 'Gastos de Representacion y Rel.P', 'A', 'E', '', '5295200001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('529525', 'ELEMENTOS DE ASEO Y CAFETERIA', 'H', 'E', '', '529525'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('529530', 'UTILES PAPELERIA Y FOTOCOPIAS', 'H', 'E', '', '529530'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('529535', 'COMBUSTIBLES Y LUBRICANTES', 'H', 'E', '', '529535'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('529545', 'TAXIS Y BUSES', 'H', 'E', '', '529545'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('529550', 'ESTAMPILLAS', 'H', 'E', '', '529550'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5295500001', 'Estampillas', 'A', 'E', '', '5295500001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('529560', 'CASINO Y RESTAURANTE', 'H', 'E', '', '529560'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('529565', 'PARQUEADEROS', 'H', 'E', '', '529565'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5295650001', 'Parqueaderos', 'A', 'E', '', '5295650001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('529595', 'OTROS GASTOS DIVERSOS', 'H', 'E', '', '529595'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5295950001', 'Cargue y Decargue de Materiales', 'A', 'E', '', '5295950001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5295950002', 'Autenticaciones', 'A', 'E', '', '5295950002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5295950004', 'Ajuste al Peso', 'A', 'E', '', '5295950004'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5299', 'PROVISIONES', 'H', 'E', '', '5299'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('529910', 'DEUDORES', 'H', 'E', '', '529910'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5299100001', 'Provision Deudas Dificil Recaudo', 'A', 'E', '', '5299100001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('53', 'GASTOS NO OPERACIONALES', 'H', 'E', '', '53'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5305', 'GASTOS FINANCIEROS', 'H', 'E', '', '5305'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('530505', 'GASTOS BANCARIOS', 'H', 'E', '', '530505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5305050001', 'Gastos Bancarios', 'A', 'E', '', '5305050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('530515', 'COMISIONES', 'H', 'E', '', '530515'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5305150001', 'Comisiones Bancarias', 'A', 'E', '', '5305150001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('530520', 'INTERESES', 'H', 'E', '', '530520'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5305200001', 'Intereses Corriente Ptmos Bancar', 'A', 'E', '', '5305200001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5305200002', 'Intereses por Sobregiro Bancario', 'A', 'E', '', '5305200002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5305200003', 'Intereses de Mora', 'A', 'E', '', '5305200003'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5315', 'GASTOS EXTRAORDINARIOS', 'H', 'E', '', '5315'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('531520', 'IMPUESTOS ASUMIDOS', 'H', 'E', '', '531520'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5315200001', 'Impuestos Asumidos', 'A', 'E', '', '5315200001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('531595', 'OTROS GASTOS EXTRAORDINARIOS', 'H', 'E', '', '531595'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5395', 'GASTOS DIVERSOS', 'H', 'E', '', '5395'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('539520', 'MULTAS SANCIONES Y LITIGIOS', 'H', 'E', '', '539520'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5395200001', 'Multas Sanciones y Litigios', 'A', 'E', '', '5395200001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('54', 'IMPUESTO DE RENTA Y COMPLEMENTAR', 'H', 'E', '', '54'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5405', 'IMPUESTO DE RENTA Y COMPLEMENTAR', 'H', 'E', '', '5405'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('540505', 'IMPUESTO DE RENTA Y COMPLEMENTAR', 'H', 'E', '', '540505'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5405050001', 'Impuesto de Renta y Complementar', 'A', 'E', '', '5405050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('6', 'COSTO DE VENTA', 'H', 'E', '', '6'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('61', 'COSTO DE VENTAS Y PREST. SERVICI', 'H', 'E', '', '61'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('6135', 'COMERCIO AL POR MAYOR Y MENOR', 'H', 'E', '', '6135'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('613554', 'VTA MAQ. EQ. OFIC. Y SOFTWARE', 'H', 'E', '', '613554'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('6135540001', 'Costo de Ventas', 'A', 'E', '', '6135540001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('62', 'COMPRAS', 'H', 'E', '', '62'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('6205', 'COMPRA DE MERCANCIA', 'H', 'E', '', '6205'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('6210', 'COMPRA DE MATERIA PRIMA', 'H', 'E', '', '6210'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('621001', 'COMPRA DE MATERIA PRIMA', 'H', 'E', '', '621001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1305050002', 'Clientes Nacionales', 'A', 'A', 'AR', '1305050002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2408050001', 'Iva Descontable en compras 16%', 'A', 'L', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax', '2408050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2408050002', 'Iva Descontable en servicios 16%', 'A', 'L', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax', '2408050002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2408050003', 'Iva Descontable Arri. y Hotel 7%', 'A', 'L', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax', '2408050003'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2408050004', 'Iva Descontable en Tiquetes 8%', 'A', 'L', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax', '2408050004'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2408050005', 'Iva Descontable en Servicios 20%', 'A', 'L', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax', '2408050005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2408050010', 'Iva Descon. Reg. Simplif. 12%', 'A', 'L', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax', '2408050010'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1305050001', 'Clientes Nacionales', 'A', 'A', 'AR', '1305050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1330050001', 'Anticipo a Proveedores', 'A', 'A', '', '1330050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1350950001', 'Contratos de Consultoria', 'A', 'A', '', '1350950001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1465050001', 'Inventarios en Transito', 'A', 'A', 'IC', '1465050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2205050002', 'Proveedores Nacionales', 'A', 'L', 'AP', '2205050002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2320050001', 'Cuentas por pagar a Contratistas', 'A', 'L', 'AP', '2320050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2315', 'A COMPA??AS VINCULADAS', 'H', 'L', '', '2315'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2335950001', 'Gastos Causados por Pagar', 'A', 'L', 'AP', '2335950001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2205050001', 'Proveedores Nacionales', 'A', 'L', 'AP', '2205050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365150002', 'Honorarios Persona Natural 11%', 'A', 'L', 'AP_tax:IC_taxservice', '2365150002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365150003', 'Honorarios Persona Juridica 10%', 'A', 'L', 'AP_tax:IC_taxservice', '2365150003'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5105480001', 'Bonificaciones a Empleados', 'A', 'E', '', '5105480001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('142005', 'CONTRATOS EN EJECUCION', 'H', 'A', '', '142005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5220100001', 'Arriendo Casa', 'A', 'E', 'IC_expense', '5220100001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5255950001', 'Taxis y Buses', 'A', 'E', 'IC_expense', '5255950001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235550001', 'Gas', 'A', 'E', 'IC_expense', '5235550001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5255150001', 'Pasajes Aereos', 'A', 'E', 'IC_expense', '5255150001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235250001', 'Acueducto y Alcantarilldo', 'A', 'E', 'IC_expense', '5235250001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2368030002', 'Retencion ICA 8xMil', 'A', 'L', 'AP_tax:IC_taxservice:CT_tax', '2368030002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2380950001', 'Cuentas por pagar', 'A', 'L', 'AP', '2380950001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1330100001', 'Anticipo a Contratistas', 'A', 'A', 'AR', '1330100001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2408050006', 'IVA Descontable en compras 20% ', 'A', 'L', 'IC_taxservice:CT_tax', '2408050006'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5295950003', 'Compra de Medicina Contratistas', 'A', 'E', 'IC_expense', '5295950003'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5295600001', 'Casino y Restaurante', 'A', 'E', 'IC_expense', '5295600001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5295450001', 'Taxis y Buses Urbanos', 'A', 'E', 'IC_expense', '5295450001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5295350001', 'Combustibles y lubricantes', 'A', 'E', 'IC_expense', '5295350001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5295050001', 'Comisiones', 'A', 'E', 'IC_expense', '5295050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5255950003', 'Tasa Aeroportuaria', 'A', 'E', 'IC_expense', '5255950003'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5255050001', 'Alojamiento y Manutencion', 'A', 'E', 'IC_expense', '5255050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5250150001', 'Reparaciones Locativas', 'A', 'E', 'IC_expense', '5250150001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5240950002', 'Exp. Certif. Libertad y tradicio', 'A', 'E', 'IC_expense', '5240950002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5240150001', 'Tramites y Licencias', 'A', 'E', 'IC_expense', '5240150001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235950006', 'Mano de Obra OBRAS CIVILES', 'A', 'E', 'IC_expense', '5235950006'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235950005', 'Jardineria', 'A', 'E', 'IC_expense', '5235950005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235950003', 'Digitacion de Planos', 'A', 'E', 'IC_expense', '5235950003'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235950001', 'Pintura', 'A', 'E', 'IC_expense', '5235950001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235500001', 'Transportes Fletes y Acarreos', 'A', 'E', 'IC_expense', '5235500001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235400001', 'Correo Portes y Telegramas', 'A', 'E', 'IC_expense', '5235400001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235150001', 'Asistencia tecnica', 'A', 'E', 'IC_expense', '5235150001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235050001', 'Aseo y Vigilancia', 'A', 'E', 'IC_expense', '5235050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5215950001', 'Impuesto de 3 por Mil', 'A', 'E', 'IC_expense', '5215950001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5215150001', 'Impuestos a la Propiedad raiz', 'A', 'E', 'IC_expense', '5215150001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5210950003', 'Asesoria Administrativa y de Mer', 'A', 'E', 'IC_expense', '5210950003'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5210950002', 'Asesoria Contable', 'A', 'E', 'IC_expense', '5210950002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5210250001', 'Asesorias Juridicas', 'A', 'E', 'IC_expense', '5210250001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205780001', 'Aportes SENA', 'A', 'E', 'IC_expense', '5205780001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205750001', 'Aportes ICBF', 'A', 'E', 'IC_expense', '5205750001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205720001', 'Aportes cajas de Compensacion', 'A', 'E', 'IC_expense', '5205720001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205700001', 'Aportes fondo de Pensiones y Ces', 'A', 'E', 'IC_expense', '5205700001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205690001', 'Aportes EPS', 'A', 'E', 'IC_expense', '5205690001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205680001', 'Aportes ARP', 'A', 'E', 'IC_expense', '5205680001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205390001', 'Vacaciones', 'A', 'E', 'IC_expense', '5205390001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205360001', 'Primas de Servicios', 'A', 'E', 'IC_expense', '5205360001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205300001', 'Cesantias', 'A', 'E', 'IC_expense', '5205300001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205270001', 'Auxilio de transporte', 'A', 'E', 'IC_expense', '5205270001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4295050001', 'Aprovechamiento Material Sobrant', 'A', 'I', 'IC_sale:IC_income', '4295050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4210050001', 'Intereses por Rendimientos Finan', 'A', 'I', 'IC_income', '4210050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2408100001', 'Iva Generado por Ingresos 16%', 'A', 'L', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax', '2408100001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2408100002', 'Iva Generado por Ingresos 7%', 'A', 'L', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax', '2408100002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('6210010001', 'Compra de Materia Prima', 'A', 'E', 'IC_cogs', '6210010001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365400002', 'Compra Combustibles y Lub. 0.1%', 'A', 'L', 'IC_taxservice', '2365400002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365400001', 'Compras en General 3.5%', 'A', 'L', 'IC_taxpart:IC_taxservice:CT_tax', '2365400001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365300004', 'Arriendo Maq. Obra Civil 2%', 'A', 'L', 'IC_taxservice', '2365300004'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365300003', 'Arriendo Bienes Muebles 4%', 'A', 'L', 'IC_taxservice:CT_tax', '2365300003'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365300001', 'Arriendo Inmuebles 3.5%', 'A', 'L', 'IC_taxservice:CT_tax', '2365300001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365250004', 'Construccion Obra Civil 1%', 'A', 'L', 'IC_taxservice:CT_tax', '2365250004'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365250003', 'Transporte de Carga 1%', 'A', 'L', 'IC_taxservice:CT_tax', '2365250003'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365250001', 'Servicios en General 6%', 'A', 'L', 'IC_taxservice:CT_tax', '2365250001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365200001', 'Retencion Comision del 11%', 'A', 'L', 'IC_taxpart:IC_taxservice:CT_tax', '2365200001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365150001', 'Honorarios Persona Natural 10%', 'A', 'L', 'AP_tax:IC_taxservice:CT_tax', '2365150001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5295300001', 'Utiles Papeleria y Fotocopias', 'A', 'E', 'AP_amount:IC_expense', '5295300001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5295250001', 'Elementos de Aseo y Cafeteria', 'A', 'E', 'AP_amount:IC_expense', '5295250001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235300001', 'Energia Electrica', 'A', 'E', 'AP_amount:IC_expense', '5235300001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235350001', 'Telefono', 'A', 'E', 'AP_amount:IC_expense', '5235350001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1355150003', 'Retefuente 7% Rendimientos Finan', 'A', 'A', 'IC_taxpart:IC_taxservice', '1355150003'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1355150001', 'Retefuente 2% Factor multiplicad', 'A', 'A', '', '1355150001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1355170001', 'Iva Retenido 75% de 16%', 'A', 'A', 'IC_taxpart:IC_taxservice', '1355170001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365150004', 'Honorarios Persona Juridica 11%', 'A', 'L', 'CT_tax', '2365150004'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2367050001', 'Iva retenido reg simplif 12% ', 'A', 'L', 'AP_tax:CT_tax', '236705'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('236710', 'IVA RETENIDO AL REGIMEN COMUN ', 'H', 'L', '', '2367'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('236705', 'IVA RETENIDO AL REGIMEN SIMPLIF. ', 'H', 'L', '', '2367'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2367', 'IMPUESTO A LAS VENTAS RETENIDO', 'H', 'L', '', '23'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4295810001', 'Ajuste al Peso', 'A', 'I', '', '4295810001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5240050001', 'Gastos Notariales', 'A', 'E', 'IC_expense', '5240050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('429581001', 'Ajuste', 'A', 'I', '', '429581001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4130950001', 'Consultorias', 'A', 'I', 'AR_amount:IC_income', '4130950001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4130100001', 'Ingresos por Obras Civiles', 'A', 'I', 'AR_amount:IC_income', '4130100001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4130950002', 'Interventorias', 'A', 'I', 'AR_amount:IC_income', '4130950002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4220100001', 'Arriendo de locales y oficinas', 'A', 'I', 'AR_amount:IC_income', '4220100001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4220150001', 'Arriendo de Maquinaria y Equipos', 'A', 'I', 'AR_amount:IC_income', '4220150001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4235950001', 'Algo', -'A', 'I', 'AR_amount:IC_income', '4235950001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205060001', 'Sueldos de Personal', 'A', 'E', 'AP_amount:IC_expense', '5205060001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2370060001', 'Aportes a ARP', 'A', 'L', '', '2370060001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2380950002', 'Otros Acreedores Varios', 'A', 'L', 'AP', '2380950001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2335300001', 'Servicios Tecnicos', 'A', 'L', 'AP', '2335300001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2370100001', 'Aportes a Sena, icbf y Cajas com', 'A', 'L', '', '2370100001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2380300001', 'Fondos de Cesantias y/o Pension', 'A', 'L', '', '2380300001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2505050001', 'Salarios por Pagar', 'A', 'L', '', '2505050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2610050001', 'Cesantias', 'A', 'L', '', '2610050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2610100001', 'Intereses Sobre Cesantias', 'A', 'L', '', '2610100001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2610150001', 'Vacaciones', 'A', 'L', '', '2610150001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2610200001', 'Prima de Servicios', 'A', 'L', '', '2610200001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2367100001', 'Iva retenido al reg comun 16% ', 'A', 'L', 'CT_tax', '236710'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2367050002', 'Iva retenido Reg Simp.del 7% ', 'A', 'L', 'IC_taxservice:CT_tax', '236705'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2367100002', 'Iva retenido al reg comun 20% ', 'A', 'L', 'IC_taxpart:IC_taxservice:CT_tax', '236710'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2367100003', 'Iva retenido al reg comun del 7% ', 'A', 'L', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax', '236710'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1410990001', 'Aj. por Inflacion Inv. en Proces', 'A', 'A', '', '1410990001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1465990001', 'Aj.por Infl. Inv. en Transito', 'A', 'A', '', '1465990001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1330150001', 'Anticipo a Trabajadores', 'A', 'A', 'AR', '1330150001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1420990001', 'Aj.por Inflacion Ctos en Ejecuci', 'A', 'A', '', '1420990001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1430990001', 'Aj.por Inflacion Inv.Prod.Termin', 'A', 'A', '', '1430990001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1435990001', 'Aj.por Infl.Mcia No Fab.Empresa', 'A', 'A', '', '1435990001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1105050001', 'Caja Mayor', 'A', 'A', 'AR_paid:AP_paid', '1105050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1105100001', 'Caja Menor 1', 'A', 'A', 'AR_paid:AP_paid', '1105100001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1105100002', 'Caja Menor 2', 'A', 'A', 'AR_paid:AP_paid', '1105100002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1105100003', 'Caja Menor 3', 'A', 'A', 'AR_paid:AP_paid', '1105100003'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1105100004', 'Caja menor 4', 'A', 'A', 'AR_paid:AP_paid', '1105100004'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1105100005', 'Caja menor 5', 'A', 'A', 'AR_paid:AP_paid', '1105100005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1110050013', 'Banco Ganadero Cta.Cte.xxxxxxxx', 'A', 'A', 'AR_paid:AP_paid', '1110050013'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1110050029', 'Tequendama Cte. #xxxxxxxx', 'A', 'A', 'AR_paid:AP_paid', '1110050029'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1120050013', 'Banco Ganadero Ahorro xxxxxxxx', 'A', 'A', 'AR_paid:AP_paid', '1120050013'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1120050019', 'Banco Colpatria Ahor. xxxxxxxxx', 'A', 'A', 'AR_paid:AP_paid', '1120050019'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1120051302', 'Bco Ganadero Ahorro xxxxxxxxxx', 'A', 'A', 'AR_paid:AP_paid', '1120051302'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1355150020', 'Retencion en la Fuente Año Anter', 'A', 'A', '', '1355150020'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1410050001', 'Muebles', 'A', 'A', 'IC', '1410050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1410050002', 'Inventario 1', 'A', 'A', 'IC', '1410050002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1410050003', 'Inventario 2', 'A', 'A', 'IC', '1410050003'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1410050004', 'Inventario 3', 'A', 'A', 'IC', '1410050004'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1410050005', 'Inventario 4', 'A', 'A', 'IC', '1410050005'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1410050010', 'Inventario 5', 'A', 'A', 'IC', '1410050010'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1420050001', 'Lokesea', 'A', 'A', 'IC', '1420050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1430050001', 'Lokesea', 'A', 'A', 'IC', '1430050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1435050001', 'Lokesea', 'A', 'A', 'IC', '1435050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1420050002', 'Lokesea', 'A', 'A', 'IC', '1420050002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1516100001', 'Local #1', 'A', 'A', '', '1516100001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1516100002', 'Local #2', 'A', 'A', '', '1516100002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1516100003', 'Local #3', 'A', 'A', '', '1516100003'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1516990001', 'Aj. Infl. Local #1', 'A', 'A', '', '1516990001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1435050099', 'Cuenta Inventario para Lokesea', 'A', 'A', 'IC', '1435050099'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1516991001', 'Aj. Infl. Local #1', 'A', 'A', '', '1516991001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1516991002', 'Aj. Infl. Local #2', 'A', 'A', '', '1516991002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1516991003', 'Aj. Infl. Local #3', 'A', 'A', '', '1516991003'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1520020001', 'Lokesea del Inventario', 'A', 'A', '', '1520020001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1520020002', 'Equipo de Lokeasea', 'A', 'A', '', '1520020002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1520990201', 'Aj. por Inflacion Lokesea', 'A', 'A', '', '1520990201'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1520990202', 'Aj.x Infl. Otro Lokesea', 'A', 'A', '', '1520990202'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1524100001', 'Aire Acondicionado LG', 'A', 'A', '', '1524100001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1524991001', 'Aj. por Inflac. Aire Acond. LG', 'A', 'A', '', '1524991001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1592100001', 'Depreciacion Lokesea', 'A', 'A', '', '1592100001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1540050001', 'Mazda Blanco Placa ALGO0815', 'A', 'A', '', '1540050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1592050001', 'Local #1', 'A', 'A', '', '1592050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1592050002', 'Local #2', 'A', 'A', '', '1592050002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1592050003', 'Local #3', 'A', 'A', '', '1592050003'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1592100002', 'Deprec. Otro Lokesea', 'A', 'A', '', '1592100002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1592150001', 'Depreciacion Aire LG', 'A', 'A', '', '1592150001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1592350001', 'Mazda Balnco Placa ALGO0815', 'A', 'A', '', '1592350001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1910080001', 'Local #1', 'A', 'A', '', '1910080001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1910080002', 'Local #2', 'A', 'A', '', '1910080002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1910080003', 'Local #3', 'A', 'A', '', '1910080003'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2335950002', 'Cuentas por pagar CaribeNet S.A. (www.caribenet.com)', 'A', 'L', 'AP', '2335950002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3115050001', 'Yo', 'A', 'Q', '', '3115050001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3115050002', 'Tu', 'A', 'Q', '', '3115050002'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4120270001', 'Lokeproducimos', 'A', 'I', 'AR_amount:IC_income', '4120270001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4130950003', 'En que ganamos?', 'A', 'I', 'AR_amount:IC_income', '4130950003'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4135950001', 'Loquevendomos', 'A', 'I', '', '4135950001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4150300001', 'Vendo hasta mi mama!', 'A', 'I', '', '4150300001'); -INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5230750001', 'Soat - Seguro Obligatorio Vehiculos', 'A', 'E', '', '5230750001'); --- -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '1355150003'), -0.07); -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '1355170001'), -0.12); -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2365150001'), -0.1); -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2365150002'), -0.11); -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2365150003'), -0.1); -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2365150004'), -0.11); -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2365200001'), -0.11); -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2365250001'), -0.06); -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2365250003'), -0.01); -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2365250004'), -0.01); -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2365300001'), -0.035); -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2365300003'), -0.04); -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2365300004'), -0.02); -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2365400001'), -0.035); -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2365400002'), -0.001); -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2367050001'), -0.12); -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2367050002'), -0.0525); -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2367100001'), -0.12); -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2367100002'), -0.15); -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2367100003'), -0.0525); -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2368030002'), -0.008); -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2408050001'), 0.16); -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2408050002'), 0.16); -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2408050003'), 0.07); -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2408050004'), 0.08); -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2408050005'), 0.2); -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2408050006'), 0.2); -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2408050010'), 0.12); -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2408100001'), 0.16); -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2408100002'), 0.07); - |