summaryrefslogtreecommitdiff
path: root/sql/Colombia-PUC-chart.sql
blob: 271de33600134ac81a8d55f28ceab4cda198937a (plain)
  1. --
  2. -- Plan único de Cuentas de Colombia, elaborado por Rene Real Hernandez (SDI S.A.), Francico Padilla (SDI S.A.),
  3. -- Silfredo Godoy Chavez (CaribeNet S.A.),
  4. -- Lourdes Mejía Martinez (CaribeNet S.A.) y Dirk Enrique Seiffert (CaribeNet S.A.)
  5. -- Si quieres aportar: Contactenos www.caribenet.com - info@caribenet.com
  6. --
  7. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1', 'ACTIVO', 'H', 'A', '', '1');
  8. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('11', 'ACTIVO DISPONIBLE', 'H', 'A', '', '11');
  9. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1105', 'CAJA', 'H', 'A', '', '1105');
  10. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('110505', 'CAJA GENERAL', 'H', 'A', '', '110505');
  11. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('110510', 'CAJAS MENORES', 'H', 'A', '', '110510');
  12. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1110', 'BANCOS', 'H', 'A', '', '1110');
  13. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('111005', 'BANCOS MONEDA NACIONAL', 'H', 'A', '', '111005');
  14. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1120', 'CUENTAS DE AHORRO', 'H', 'A', '', '1120');
  15. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('112005', 'CUENTAS DE AHORRO EN BANCOS', 'H', 'A', '', '112005');
  16. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('12', 'INVERSIONES', 'H', 'A', '', '12');
  17. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1205', 'ACCIONES', 'H', 'A', '', '1205');
  18. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1210', 'CUOTAS PARTES DE INTERES SOCIAL', 'H', 'A', '', '1210');
  19. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1215', 'BONOS', 'H', 'A', '', '1215');
  20. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1220', 'CEDULAS', 'H', 'A', '', '1220');
  21. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1225', 'CERTIFICADOS', 'H', 'A', '', '1225');
  22. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1230', 'PAPELES COMERCIALES', 'H', 'A', '', '1230');
  23. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1235', 'TITULOS', 'H', 'A', '', '1235');
  24. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1240', 'ACEPTACIONES BANCARIAS O FINANCI', 'H', 'A', '', '1240');
  25. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1245', 'DERECHOS FIDUCIARIOS', 'H', 'A', '', '1245');
  26. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('13', 'CUENTAS POR COBRAR', 'H', 'A', '', '13');
  27. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1305', 'CUENTAS POR COBRAR CLIENTES', 'H', 'A', '', '1305');
  28. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('130505', 'CLIENTES NACIONALES', 'H', 'A', '', '130505');
  29. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('130510', 'CLIENTES DEL EXTERIOR', 'H', 'A', '', '130510');
  30. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1310', 'CUENTAS CORRIENTES COMERCIALES', 'H', 'A', '', '1310');
  31. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1330', 'ANTICIPO Y AVANCES', 'H', 'A', '', '1330');
  32. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('133005', 'ANTICIPO A PROVEEDORES', 'H', 'A', '', '133005');
  33. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('133010', 'ANTICIPO A CONTRATISTAS', 'H', 'A', '', '133010');
  34. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('133015', 'ANTICIPO A TRABAJADORES', 'H', 'A', '', '133015');
  35. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1340', 'PROMESAS DE COMPRAVENTA', 'H', 'A', '', '1340');
  36. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('134005', 'DE BIENES RAICES', 'H', 'A', '', '134005');
  37. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1340050001', 'Promesas Compra Venta Bienes Rai', 'A', 'A', '', '1340050001');
  38. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1345', 'INGRESOS POR COBRAR', 'H', 'A', '', '1345');
  39. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1350', 'RETENCIONES SOBRE CONTRATOS', 'H', 'A', '', '1350');
  40. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('135005', 'DE CONTRATOS DE CONSTRUCCION', 'H', 'A', '', '135005');
  41. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('135010', 'DE PRESTACION DE SERVICIOS', 'H', 'A', '', '135010');
  42. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('135095', 'RETENCION SOBRE OTROS CONTRATOS', 'H', 'A', '', '135095');
  43. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1355', 'ANTICIPO DE IMPUESTOS', 'H', 'A', '', '1355');
  44. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('135505', 'ANTICIPO DE IMPUESTO DE RENTA', 'H', 'A', '', '135505');
  45. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1355050001', 'Anticipo de Impuesto de Renta', 'A', 'A', '', '1355050001');
  46. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('135510', 'ANTICIPO DE IMPTO DE IND. Y CCIO', 'H', 'A', '', '135510');
  47. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1355100001', 'Anticipo de Industria y Comercio', 'A', 'A', '', '1355100001');
  48. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('135515', 'RETENCION EN LA FUENTE', 'H', 'A', '', '135515');
  49. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1355150002', 'Retefuente 10% Honorarios', 'A', 'A', '', '1355150002');
  50. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1355150004', 'Retefuente Alquiler Bienes R. 4%', 'A', 'A', '', '1355150004');
  51. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1355150005', 'Retefuente Obras Civiles 1%', 'A', 'A', '', '1355150005');
  52. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1355150006', 'Retefuente 6% servicios', 'A', 'A', '', '1355150006');
  53. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1355150007', 'Retencion en la fuente 3.5%', 'A', 'A', '', '1355150007');
  54. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('135517', 'IMPUESTO A LAS VENTAS RETENIDO', 'H', 'A', '', '135517');
  55. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('135518', 'IMPUESTO DE IND. Y CCIO RETENIDO', 'H', 'A', '', '135518');
  56. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1355180001', 'Ica Retenido', 'A', 'A', '', '1355180001');
  57. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('135520', 'SOBRANTE EN LIQUIDACION PRIVADA', 'H', 'A', '', '135520');
  58. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1355200001', 'Saldo a Favor en Renta', 'A', 'A', '', '1355200001');
  59. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1355200002', 'Sobrante en Declaracion de IVA', 'A', 'A', '', '1355200002');
  60. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1380', 'DEUDORES VARIOS', 'H', 'A', '', '1380');
  61. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('138020', 'CUENTAS POR COBRAR A TERCEROS', 'H', 'A', '', '138020');
  62. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1380200001', 'Cuentas por Cobrar a Terceros', 'A', 'A', '', '1380200001');
  63. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('138095', 'OTROS DEUDORES VARIOS', 'H', 'A', '', '138095');
  64. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1380950001', 'Deudores Varios Otros', 'A', 'A', '', '1380950001');
  65. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1390', 'DEUDAS DE DIFICIL COBRO', 'H', 'A', '', '1390');
  66. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1399', 'PROVISIONES', 'H', 'A', '', '1399');
  67. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('139905', 'PROVISION CLIENTES', 'H', 'A', '', '139905');
  68. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1399050001', 'Provision cartera Dificil Cobro', 'A', 'A', '', '1399050001');
  69. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('14', 'INVENTARIOS', 'H', 'A', '', '14');
  70. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1410', 'PRODUCTOS EN PROCESO', 'H', 'A', '', '1410');
  71. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('141005', 'PRODUCTOS EN PROCESO', 'H', 'A', '', '141005');
  72. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('141099', 'AJ. POR INFLACION INV. EN PROCES', 'H', 'A', '', '141099');
  73. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1415', 'OBRAS DE CONSTRUCCION EN CURSO', 'H', 'A', '', '1415');
  74. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1420', 'CONTRATOS EN EJECUCION', 'H', 'A', '', '1420');
  75. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('142099', 'AJ.POR INFLACION CTOS EN EJECUCI', 'H', 'A', '', '142099');
  76. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1430', 'PRODUCTOS TERMINADOS', 'H', 'A', '', '1430');
  77. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('143005', 'PRODUCTOS MANUFACTURADOS', 'H', 'A', '', '143005');
  78. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('143099', 'AJ.POR INFLACION INV.PROD.TERMIN', 'H', 'A', '', '143099');
  79. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1435', 'MERCANCIAS NO FABRICADAS', 'H', 'A', '', '1435');
  80. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('143505', 'MCIA NO FABRICADA POR LA EMPRESA', 'H', 'A', '', '143505');
  81. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('143599', 'AJ.POR INFL.MCIA NO FAB.EMPRESA', 'H', 'A', '', '143599');
  82. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1465', 'INVENTARIOS EN TRANSITO', 'H', 'A', '', '1465');
  83. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('146505', 'INVENTARIOS EN TRANSITO', 'H', 'A', '', '146505');
  84. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('146599', 'AJ.POR INFLACION INV.EN TRANSITO', 'H', 'A', '', '146599');
  85. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('15', 'PROPIEDAD PLANTA Y EQUIPO', 'H', 'A', '', '15');
  86. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1504', 'TERRENOS', 'H', 'A', '', '1504');
  87. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1508', 'CONSTRUCCIONES EN CURSO', 'H', 'A', '', '1508');
  88. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1512', 'MAQUINARIA Y EQUIPO EN MONTAJE', 'H', 'A', '', '1512');
  89. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1516', 'CONSTRUCCIONES Y EDIFICACIONES', 'H', 'A', '', '1516');
  90. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('151610', 'OFICINAS', 'H', 'A', '', '151610');
  91. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('151699', 'AJUSTES POR INFLACION CONSTRUCCI', 'H', 'A', '', '151699');
  92. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('15169910', 'AJ. INFL. OFICINAS - LOCALES', 'H', 'A', '', '15169910');
  93. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1520', 'MAQUINARIA Y EQUIPO', 'H', 'A', '', '1520');
  94. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('152001', 'CONTRATOS YOPAL', 'H', 'A', '', '152001');
  95. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('152002', 'BODEGA', 'H', 'A', '', '152002');
  96. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('152099', 'AJUSTES POR INFLACION', 'H', 'A', '', '152099');
  97. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('15209902', 'AJUSTES POR INFLACION EQ.BODEGA', 'H', 'A', '', '15209902');
  98. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1524', 'EQUIPOS DE OFICINA', 'H', 'A', '', '1524');
  99. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('152405', 'MUEBLES Y ENSERES', 'H', 'A', '', '152405');
  100. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('152410', 'EQUIPOS', 'H', 'A', '', '152410');
  101. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('152499', 'AJUSTES POR INFLACION', 'H', 'A', '', '152499');
  102. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('15249910', 'AJUSTES POR INFLACION', 'H', 'A', '', '15249910');
  103. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1528', 'EQUIPOS DE COMPUTACION Y COMUNIC', 'H', 'A', '', '1528');
  104. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('152805', 'EQUIPOS DE PROCESAMIENTO DE DATO', 'H', 'A', '', '152805');
  105. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1528050001', 'Cinco Computadores', 'A', 'A', '', '1528050001');
  106. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('152899', 'AJUSTES POR INFLACION', 'H', 'A', '', '152899');
  107. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('15289905', 'AJ. INFL. EQ. PROCESAMIENTO DATO', 'H', 'A', '', '15289905');
  108. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1528990501', 'Aj. por Inflac. Cinco Computador', 'A', 'A', '', '1528990501');
  109. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1540', 'FLOTA Y EQUIPO DE TRANSPORTE', 'H', 'A', '', '1540');
  110. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('154005', 'AUTOS, CAMIONETAS Y CAMPEROS', 'H', 'A', '', '154005');
  111. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('154099', 'AJUSTES POR INFLACION', 'H', 'A', '', '154099');
  112. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('15409905', 'AJ. INFL. AUTOS CAMPEROS CMIONET', 'H', 'A', '', '15409905');
  113. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1540990501', 'Aj. Infl. Autos y Camperos', 'A', 'A', '', '1540990501');
  114. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1592', 'DEPRECIACION ACUMULADA', 'H', 'A', '', '1592');
  115. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('159205', 'DEPREC.DE CONSTRUCCIONES Y EDIFI', 'H', 'A', '', '159205');
  116. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('159210', 'DEPREC. MAQUINARIA Y EQUIPO', 'H', 'A', '', '159210');
  117. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('159215', 'DEPRECIACION EQUIPO DE OFICINA', 'H', 'A', '', '159215');
  118. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('159220', 'DEPRECIACION EQ. COMPUTACION Y C', 'H', 'A', '', '159220');
  119. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1592200001', 'Depreciacion Cinco Computadores', 'A', 'A', '', '1592200001');
  120. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('159235', 'DEPRECIACION FLOTA DE TRANSPORTE', 'H', 'A', '', '159235');
  121. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('159299', 'AJUSTES POR INFLACION', 'H', 'A', '', '159299');
  122. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1592990005', 'Aj.Infl. Construc. y Edificacion', 'A', 'A', '', '1592990005');
  123. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1592990010', 'Aj.Infl. Maquinaria y Equipo', 'A', 'A', '', '1592990010');
  124. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1592990015', 'Aj. Infl. Equipos de Oficina', 'A', 'A', '', '1592990015');
  125. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1592990020', 'Aj. Infl. Eq. Computac. y Comuni', 'A', 'A', '', '1592990020');
  126. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1592990035', 'Aj. Infl. Flota y Eq. de transpo', 'A', 'A', '', '1592990035');
  127. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('19', 'VALORIZACIONES', 'H', 'A', '', '19');
  128. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1905', 'VALORIZACIONES DE INVERSIONES', 'H', 'A', '', '1905');
  129. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1910', 'DE PROPIEDAD PLANTA Y EQUIPOS', 'H', 'A', '', '1910');
  130. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('191008', 'DE CONSTRUCCIONES Y EDIFICACIONE', 'H', 'A', '', '191008');
  131. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1995', 'VALORIZACION DE OTROS ACTIVOS', 'H', 'A', '', '1995');
  132. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2', 'PASIVOS', 'H', 'L', '', '2');
  133. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('21', 'OBLIGACIONES FINANCIERAS', 'H', 'L', '', '21');
  134. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2105', 'BANCOS NACIONALES', 'H', 'L', '', '2105');
  135. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('210505', 'SOBREGIROS', 'H', 'L', '', '210505');
  136. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2105050001', 'Sobregiros Bancarios', 'A', 'L', '', '2105050001');
  137. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('210510', 'PAGARES', 'H', 'L', '', '210510');
  138. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2105100001', 'Pagares', 'A', 'L', '', '2105100001');
  139. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2130', 'ENTIDADES FINANCIERAS DEL EXTERI', 'H', 'L', '', '2130');
  140. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2145', 'OBLIGACIONES GUBERNAMENTALES', 'H', 'L', '', '2145');
  141. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2195', 'OTRAS OBLIGACIONES', 'H', 'L', '', '2195');
  142. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('219505', 'OBLIGACIONES CON PARTICULARES', 'H', 'L', '', '219505');
  143. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2195050001', 'Otras obligaciones con Particula', 'A', 'L', '', '2195050001');
  144. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('219510', 'OBLIGACIONES COMPA?IAS VINCULADA', 'H', 'L', '', '219510');
  145. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('22', 'PROVEEDORES', 'H', 'L', '', '22');
  146. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2205', 'PROVEEDORES NACIONALES', 'H', 'L', '', '2205');
  147. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('220505', 'PROVEEDORES NACIONALES', 'H', 'L', '', '220505');
  148. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('23', 'CUENTAS POR PAGAR', 'H', 'L', '', '23');
  149. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2320', 'CUENTAS POR PAGAR A CONTRATISTAS', 'H', 'L', '', '2320');
  150. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('232005', 'CUENTAS POR PAGAR A CONTRATISTAS', 'H', 'L', '', '232005');
  151. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2335', 'COSTOS Y GASTOS POR PAGAR', 'H', 'L', '', '2335');
  152. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('233505', 'GASTOS FINANCIEROS', 'H', 'L', '', '233505');
  153. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('233510', 'GASTOS LEGALES', 'H', 'L', '', '233510');
  154. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('233515', 'LIBROS SUSCRIPCIONES PERIODICOS', 'H', 'L', '', '233515');
  155. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('233520', 'COMISIONES', 'H', 'L', '', '233520');
  156. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('233525', 'HONORARIOS', 'H', 'L', '', '233525');
  157. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('233530', 'SERVICIOS TECNICOS', 'H', 'L', '', '233530');
  158. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('233535', 'SERVICIOS DE MANTENIMIENTO', 'H', 'L', '', '233535');
  159. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('233540', 'ARRENDAMIENTOS', 'H', 'L', '', '233540');
  160. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('233545', 'TRANSPORTES FLETES Y ACARREOS', 'H', 'L', '', '233545');
  161. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('233550', 'SERVICIOS PUBLICOS', 'H', 'L', '', '233550');
  162. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('233555', 'SEGUROS', 'H', 'L', '', '233555');
  163. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('233560', 'GASTOS DE VIAJE', 'H', 'L', '', '233560');
  164. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('233565', 'GASTOS DE REPRESENTACION Y RELAC', 'H', 'L', '', '233565');
  165. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('233570', 'SERVICIOS ADUANEROS', 'H', 'L', '', '233570');
  166. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('233595', 'OTROS COSTOS Y GASTOS POR PAGAR', 'H', 'L', '', '233595');
  167. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2355', 'DEUDAS CON SOCIOS Y ACCIONISTAS', 'H', 'L', '', '2355');
  168. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('235505', 'ACCIONISTAS', 'H', 'L', '', '235505');
  169. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('235510', 'SOCIOS', 'H', 'L', '', '235510');
  170. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2360', 'DIVIDENDOS O PARTICIPACION POR P', 'H', 'L', '', '2360');
  171. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('236005', 'DIVIDENDOS POR PAGAR', 'H', 'L', '', '236005');
  172. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('236010', 'PARTICIPACIONES POR PAGAR', 'H', 'L', '', '236010');
  173. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365', 'RETENCION EN LA FUENTE', 'H', 'L', '', '2365');
  174. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('236505', 'SALARIOS Y PAGOS LABORALES', 'H', 'L', '', '236505');
  175. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('236510', 'DIVIDENDO Y/O PARTICIPACIONES', 'H', 'L', '', '236510');
  176. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('236515', 'HONORARIOS', 'H', 'L', '', '236515');
  177. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('236520', 'COMISIONES', 'H', 'L', '', '236520');
  178. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('236525', 'SERVICIOS', 'H', 'L', '', '236525');
  179. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365250002', 'Servicios Hoteleros 3.5%', 'A', 'L', '', '2365250002');
  180. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('236530', 'ARRENDAMIENTOS', 'H', 'L', '', '236530');
  181. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365300002', 'Arriendo Inmuebles 4%', 'A', 'L', '', '2365300002');
  182. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('236535', 'RENDIMIENTOS FINANCIERSO', 'H', 'L', '', '236535');
  183. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('236540', 'RETENCION POR COMPRAS', 'H', 'L', '', '236540');
  184. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2368', 'IMPTO DE IND. Y CCIO RETENIDO', 'H', 'L', '', '2368');
  185. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('236801', 'SECTOR INDUSTRIAL', 'H', 'L', '', '236801');
  186. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2368010003', 'Demas Activ. Industriales 7xmil', 'A', 'L', '', '2368010003');
  187. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('236802', 'SECTOR COMERCIAL', 'H', 'L', '', '236802');
  188. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2368020004', 'Demas Activ. Comerciales 7xmil', 'A', 'L', '', '2368020004');
  189. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('236803', 'SECTOR SERVICIOS', 'H', 'L', '', '236803');
  190. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2368030001', 'Retencin ICA 6xMil', 'A', 'L', '', '2368030001');
  191. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2368030009', 'Demas Activ. Servicios 8xmil', 'A', 'L', '', '2368030009');
  192. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2370', 'RETENCIONES Y APORTES DE NOMINA', 'H', 'L', '', '2370');
  193. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('237005', 'APORTES A EPS', 'H', 'L', '', '237005');
  194. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2370050001', 'Aportes a EPS', 'A', 'L', '', '2370050001');
  195. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('237006', 'APORTES A ARP', 'H', 'L', '', '237006');
  196. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('237010', 'APORTES A IDBF, SENA Y CAJAS COM', 'H', 'L', '', '237010');
  197. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2380', 'ACREEDORES VARIOS', 'H', 'L', '', '2380');
  198. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('238030', 'FONDOS DE CESANTIAS Y/O PENSION', 'H', 'L', '', '238030');
  199. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('238095', 'VARIOS', 'H', 'L', '', '238095');
  200. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('24', 'IMPUESTOS GRAVAMENES Y TASAS', 'H', 'L', '', '24');
  201. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2404', 'IMPUESTO DE RENTA', 'H', 'L', '', '2404');
  202. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('240405', 'VIGENCIA FISCAL CORRIENTE', 'H', 'L', '', '240405');
  203. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2404050001', 'IMPORENTA VIGENCIA ACTUAL', 'A', 'L', '', '2404050001');
  204. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('240410', 'VIGENCIAS FISCALES ANTERIORES', 'H', 'L', '', '240410');
  205. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2404100001', 'IMPORENTA VIGENCIA ANTERIORES', 'A', 'L', '', '2404100001');
  206. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2408', 'IMPUESTO A LAS VENTAS POR PAGAR', 'H', 'L', '', '2408');
  207. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('240805', 'IVA DESCONTABLE', 'H', 'L', '', '240805');
  208. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('240810', 'IVA GENERADO EN VENTAS', 'H', 'L', '', '240810');
  209. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('240815', 'IMPUESTOS POR PAGAR ANTERIORES', 'H', 'L', '', '240815');
  210. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2408150001', 'ViGencia Fiscal Anterior', 'A', 'L', '', '2408150001');
  211. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2412', 'IMPUESTO DE IND. Y COMERCIO', 'H', 'L', '', '2412');
  212. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('241205', 'VIGENCIA FISCAL CORRIENTE', 'H', 'L', '', '241205');
  213. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2412050001', 'ICA POR PAGAR', 'A', 'L', '', '2412050001');
  214. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('241210', 'VIGENCIAS FISCALES ANTERIORES', 'H', 'L', '', '241210');
  215. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('25', 'OBLIGACIONES LABORALES', 'H', 'L', '', '25');
  216. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2505', 'SALARIOS POR PAGAR', 'H', 'L', '', '2505');
  217. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('250505', 'NOMINA POR PAGAR', 'H', 'L', '', '250505');
  218. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2510', 'CESANTIAS CONSOLIDADAS', 'H', 'L', '', '2510');
  219. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2515', 'INTERESES SOBRE CESANTIAS', 'H', 'L', '', '2515');
  220. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2520', 'PRIMA DE SERVICIOS', 'H', 'L', '', '2520');
  221. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2525', 'VACACIONES CONSOLIDADAS', 'H', 'L', '', '2525');
  222. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2530', 'PRESTACIONES EXTRALEGALES', 'H', 'L', '', '2530');
  223. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('26', 'PASIVOS ESTIMADOS Y PROVISIONES', 'H', 'L', '', '26');
  224. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2605', 'PARA COSTOS Y GASTOS', 'H', 'L', '', '2605');
  225. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('260515', 'HONORARIOS', 'H', 'L', '', '260515');
  226. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('260525', 'TRANSPORTES FLETES Y ACARREOS', 'H', 'L', '', '260525');
  227. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('260530', 'GASTOS DE VIAJE', 'H', 'L', '', '260530');
  228. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2610', 'PARA OBLIGACIONES LABORALES', 'H', 'L', '', '2610');
  229. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('261005', 'CESANTIAS', 'H', 'L', '', '261005');
  230. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('261010', 'INTERESES SOBRE CESANTIAS', 'H', 'L', '', '261010');
  231. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('261015', 'VACACIONES', 'H', 'L', '', '261015');
  232. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('261020', 'PRIMA DE SERVICIOS', 'H', 'L', '', '261020');
  233. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2615', 'PARA OBLIGACIONES FISCALES', 'H', 'L', '', '2615');
  234. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('261505', 'DE RENTA Y COMPLEMENTARIOS', 'H', 'L', '', '261505');
  235. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2615050001', 'Impuesto de Renta y Complementar', 'A', 'L', '', '2615050001');
  236. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('261510', 'DE INDUSTRIA Y COMERCIO', 'H', 'L', '', '261510');
  237. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('261595', 'OTROS', 'H', 'L', '', '261595');
  238. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2630', 'PARA MANTENIMIENTO Y REPARACION', 'H', 'L', '', '2630');
  239. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2635', 'PARA CONTINGENCIAS', 'H', 'L', '', '2635');
  240. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('263505', 'MULTAS SANCIONES Y LITIGIOS', 'H', 'L', '', '263505');
  241. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('263510', 'INTERESES POR MULTAS Y SANCIONES', 'H', 'L', '', '263510');
  242. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('28', 'OTROS PASIVOS', 'H', 'L', '', '28');
  243. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2805', 'ANTICIPOS Y AVANCES RECIBIDOS', 'H', 'L', '', '2805');
  244. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('280505', 'DE CLIENTES', 'H', 'L', '', '280505');
  245. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('280510', 'SOBRE CONTRATOS', 'H', 'L', '', '280510');
  246. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2805100001', 'Anticipo Recibido Sobre Contrato', 'A', 'L', '', '2805100001');
  247. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('280515', 'PARA OBRAS EN PROCESO', 'H', 'L', '', '280515');
  248. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2815', 'INGRESOS RECIBIDOS PARA TERCEROS', 'H', 'L', '', '2815');
  249. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('281505', 'VALORES RECIBIDOS PARA TERCEROS', 'H', 'L', '', '281505');
  250. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('281510', 'VENTA POR CUENTA DE TERCEROS', 'H', 'L', '', '281510');
  251. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2825', 'RETENCION A TERCEROS SOBRE CONTR', 'H', 'L', '', '2825');
  252. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('282505', 'CUMPLIMIENTO OBLIGACIONES LABORA', 'H', 'L', '', '282505');
  253. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3', 'PATRIMONIO', 'H', 'Q', '', '3');
  254. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('31', 'CAPITAL SOCIAL', 'H', 'Q', '', '31');
  255. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3105', 'CAPITAL SUSCRITO Y PAGADO', 'H', 'Q', '', '3105');
  256. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('310505', 'CAPITAL AUTORIZADO', 'H', 'Q', '', '310505');
  257. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3105050001', 'Capital Suscrito y Pagado', 'A', 'Q', '', '3105050001');
  258. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('310510', 'CAPITAL POR SUSCRIBIR (DB)', 'H', 'Q', '', '310510');
  259. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('310515', 'CAPITAL SUSCRITO POR COBRAR (DB)', 'H', 'Q', '', '310515');
  260. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3115', 'APORTES SOCIALES', 'H', 'Q', '', '3115');
  261. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('33', 'RESERVAS', 'H', 'Q', '', '33');
  262. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3305', 'RESERVAS OBLIGATORIAS', 'H', 'Q', '', '3305');
  263. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('330505', 'RESERVA LEGAL', 'H', 'Q', '', '330505');
  264. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3305050001', 'Reserva Legal', 'A', 'Q', '', '3305050001');
  265. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3310', 'RESERVAS ESTATUTARIAS', 'H', 'Q', '', '3310');
  266. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3315', 'RESERVAS OCASIONALES', 'H', 'Q', '', '3315');
  267. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('34', 'REVALORIZACION DEL PATRIMONIO', 'H', 'Q', '', '34');
  268. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3405', 'AJUSTES POR INFLACION', 'H', 'Q', '', '3405');
  269. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('340505', 'DE CAPITAL SOCIAL', 'H', 'Q', '', '340505');
  270. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3405050001', 'AxI CAPITAL', 'A', 'Q', '', '3405050001');
  271. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('340510', 'DE SUPERAVIT DE CAPITAL', 'H', 'Q', '', '340510');
  272. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('340515', 'DE RESERVAS', 'H', 'Q', '', '340515');
  273. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3405150001', 'AxI RESERVA LEGAL', 'A', 'Q', '', '3405150001');
  274. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('340520', 'DE RESULTADO DE EJERC. ANTERIORE', 'H', 'Q', '', '340520');
  275. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3405200001', 'AxI RESULTADOS ANTERIORES', 'A', 'Q', '', '3405200001');
  276. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('340525', 'DE ACTIVOS DE PERIODO IMPRODUCTI', 'H', 'Q', '', '340525');
  277. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('340530', 'DE SANEAMIENTO FISCAL', 'H', 'Q', '', '340530');
  278. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('340535', 'DE AJUSTES DECRETO 3019 DE 1989', 'H', 'Q', '', '340535');
  279. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('340540', 'DE DIVIDENDOS Y PARTICIPACIONES', 'H', 'Q', '', '340540');
  280. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('340545', 'SUPERAVIT METODO DE PARTICIPACIO', 'H', 'Q', '', '340545');
  281. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('36', 'RESULTADOS DE EJERCICIO', 'H', 'Q', '', '36');
  282. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3605', 'UTILIDAD DEL EJERCICIO', 'H', 'Q', '', '3605');
  283. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('360505', 'UTILIDAD DEL EJERCICIO', 'H', 'Q', '', '360505');
  284. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3605050001', 'Utilidad del Ejercicio', 'A', 'Q', '', '3605050001');
  285. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3605050002', 'Utilidad de Ajustes por Inflacio', 'A', 'Q', '', '3605050002');
  286. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3610', 'PERDIDAS DEL EJERCICIO', 'H', 'Q', '', '3610');
  287. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('361005', 'PERDIDA DEL EJERCICIO', 'H', 'Q', '', '361005');
  288. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3610050001', 'Perdida del Ejercicio', 'A', 'Q', '', '3610050001');
  289. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('37', 'RESULTADOS EJERCICIOS ANRERIORES', 'H', 'Q', '', '37');
  290. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3705', 'UTILIDADES ACUMULADAS', 'H', 'Q', '', '3705');
  291. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('370510', 'UTILIDADES ACUMULADAS', 'H', 'Q', '', '370510');
  292. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3705100001', 'Utilidades Acumuladas', 'A', 'Q', '', '3705100001');
  293. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3710', 'PERDIDAS ACUMULADAS', 'H', 'Q', '', '3710');
  294. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('371010', 'PERDIDAS ACUMULADAS', 'H', 'Q', '', '371010');
  295. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3710100001', 'Perdidas Acumuladas', 'A', 'Q', '', '3710100001');
  296. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('38', 'SUPERAVIT POR VALORIZACIONES', 'H', 'Q', '', '38');
  297. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3805', 'DE INVERSIONES', 'H', 'Q', '', '3805');
  298. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('380505', 'DE ACCIONES', 'H', 'Q', '', '380505');
  299. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('380510', 'CUOTAS O PARTES DE INTERES SOCIA', 'H', 'Q', '', '380510');
  300. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3810', 'DE PROPIEDAD PLANTA Y EQUIPO', 'H', 'Q', '', '3810');
  301. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('381008', 'CONSTRUCCIONES Y EDIFICACIONES', 'H', 'Q', '', '381008');
  302. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3810080001', 'Superavit por Valorizacion C y E', 'A', 'Q', '', '3810080001');
  303. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3895', 'DE OTROS ACTIVOS', 'H', 'Q', '', '3895');
  304. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4', 'INGRESOS', 'H', 'I', '', '4');
  305. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('41', 'INGRESOS OPERACIONALES', 'H', 'I', '', '41');
  306. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4120', 'INDUSTRIA MANUFACTURERA', 'H', 'I', '', '4120');
  307. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4130', 'CONSTRUCCION', 'H', 'I', '', '4130');
  308. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('413005', 'PREPARACION DE TERRENOS', 'H', 'I', '', '413005');
  309. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('413010', 'CONSTRUCCION Y OBRAS CIVILES', 'H', 'I', '', '413010');
  310. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('413025', 'ALQUILER DE EQUIPOS CON OPERARIO', 'H', 'I', '', '413025');
  311. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('413095', 'ACTIVIDADES CONEXAS', 'H', 'I', '', '413095');
  312. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4135', 'COMERCIO AL POR MAYOR', 'H', 'I', '', '4135');
  313. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('413595', 'ACTIVIDADES CONEXAS', 'H', 'I', '', '413595');
  314. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4150', 'ACTIVIDAD FINANCIERA', 'H', 'I', '', '4150');
  315. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('415030', 'COMISIONES', 'H', 'I', '', '415030');
  316. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4175', 'DEVOLUCIONES EN VENTAS', 'H', 'I', '', '4175');
  317. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('417505', 'DEVOLUCIONES EN VENTAS', 'H', 'I', '', '417505');
  318. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4175050001', 'Devoluciones en Ventas', 'A', 'I', '', '4175050001');
  319. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4175050002', 'Descuento en Ventas', 'A', 'I', '', '4175050002');
  320. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('42', 'INGRESOS NO OPERACIONALES', 'H', 'I', '', '42');
  321. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4205', 'OTRAS VENTAS', 'H', 'I', '', '4205');
  322. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('420505', 'MATERIA PRIMA', 'H', 'I', '', '420505');
  323. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('420510', 'MATERIAL DE DESECHO', 'H', 'I', '', '420510');
  324. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4210', 'INGRESOS FINANCIEROS', 'H', 'I', '', '4210');
  325. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('421005', 'INTERESES', 'H', 'I', '', '421005');
  326. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('421040', 'DESCUENTOS COMERCIALES CONDICION', 'H', 'I', '', '421040');
  327. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4210400001', 'Descuentos Financieros', 'A', 'I', '', '4210400001');
  328. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4215', 'DIVIDENDOS Y PARTICIPACIONES', 'H', 'I', '', '4215');
  329. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4220', 'ARRENDAMIENTOS', 'H', 'I', '', '4220');
  330. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('422010', 'CONSTRUCCIONES Y EDIFICACIONES', 'H', 'I', '', '422010');
  331. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('422015', 'MAQUINARIA Y EQUIPOS', 'H', 'I', '', '422015');
  332. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4225', 'COMISIONES', 'H', 'I', '', '4225');
  333. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4230', 'HONORARIOS', 'H', 'I', '', '4230');
  334. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4235', 'SERVICIOS', 'H', 'I', '', '4235');
  335. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('423595', 'OTROS SERVICIOS', 'H', 'I', '', '423595');
  336. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4240', 'UTILIDAD EN VENTA DE INVERSIONES', 'H', 'I', '', '4240');
  337. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4245', 'UTIL.EN VENTA PROP.PLANTA Y EQUI', 'H', 'I', '', '4245');
  338. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4250', 'RECUPERACIONES', 'H', 'I', '', '4250');
  339. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('425005', 'DEUDAS MALAS', 'H', 'I', '', '425005');
  340. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('425015', 'RECLAMOS', 'H', 'I', '', '425015');
  341. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4255', 'INDEMNIZACIONES', 'H', 'I', '', '4255');
  342. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4260', 'PARTICIPACION EN CONCESIONES', 'H', 'I', '', '4260');
  343. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4265', 'INGRESOS DE EJERCICIOS ANTERIORE', 'H', 'I', '', '4265');
  344. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4275', 'DEVOLUCIONES EN OTRAS VENTAS', 'H', 'I', '', '4275');
  345. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4295', 'DIVERSOS', 'H', 'I', '', '4295');
  346. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('429503', 'CERT', 'H', 'I', '', '429503');
  347. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('429505', 'APROVECHAMIENTOS', 'H', 'I', '', '429505');
  348. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('429507', 'AUXILIOS', 'H', 'I', '', '429507');
  349. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('429533', 'MULTAS Y RECARGOS', 'H', 'I', '', '429533');
  350. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('429535', 'PREAVISOS DESCONTADOS', 'H', 'I', '', '429535');
  351. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('429537', 'RECLAMOS', 'H', 'I', '', '429537');
  352. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('429553', 'SOBRANTES DE CAJA', 'H', 'I', '', '429553');
  353. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('429581', 'AJUSTE AL PESO', 'H', 'I', '', '429581');
  354. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('429583', 'LLAMADAS TELEFONICAS', 'H', 'I', '', '429583');
  355. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('47', 'AJUSTES POR INFLACION', 'H', 'I', '', '47');
  356. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705', 'CORRECCION MONETARIA', 'H', 'I', '', '4705');
  357. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('470505', 'INVERSIONES (CR)', 'H', 'I', '', '470505');
  358. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('470510', 'INVENTARIOS (CR)', 'H', 'I', '', '470510');
  359. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705100005', 'Inventario Materia Prima', 'A', 'I', '', '4705100005');
  360. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705100010', 'Inventario Productos en Proceso', 'A', 'I', '', '4705100010');
  361. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705100015', 'Obras de construccion en curso', 'A', 'I', '', '4705100015');
  362. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705100020', 'Inventario contratos en ejecucio', 'A', 'I', '', '4705100020');
  363. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705100030', 'Inventario Producto terminado', 'A', 'I', '', '4705100030');
  364. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705100035', 'Inv. Mercancia no Fabricada', 'A', 'I', '', '4705100035');
  365. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705100065', 'Inventarios en transito', 'A', 'I', '', '4705100065');
  366. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('470515', 'PROPIEDAD PLANTA Y EQUIPO (CR)', 'H', 'I', '', '470515');
  367. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705150001', 'Terrenos', 'A', 'I', '', '4705150001');
  368. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705150003', 'Construcciones en Curso', 'A', 'I', '', '4705150003');
  369. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705150004', 'Maquinaria y Equipo en Montaje', 'A', 'I', '', '4705150004');
  370. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705150005', 'Construcciones y Edificaciones', 'A', 'I', '', '4705150005');
  371. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705150006', 'Maquinaria y Equipos', 'A', 'I', '', '4705150006');
  372. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705150007', 'Equipos de Oficina', 'A', 'I', '', '4705150007');
  373. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705150008', 'Equipos de Computacion y comunic', 'A', 'I', '', '4705150008');
  374. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705150011', 'Flota y Equipo de transporte', 'A', 'I', '', '4705150011');
  375. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('470540', 'PATRIMONIO', 'H', 'I', '', '470540');
  376. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705400001', 'Aj. por Infl. Patrimonio', 'A', 'I', '', '4705400001');
  377. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('470545', 'DEPRECIACION ACUMULADA (DB)', 'H', 'I', '', '470545');
  378. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4705450001', 'Depreciacion Acumulada (DB)', 'A', 'I', '', '4705450001');
  379. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('470550', 'DEPRECIACION DIFERIDA (CR)', 'H', 'I', '', '470550');
  380. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('470560', 'AMORTIZACION ACUMULADA (DB)', 'H', 'I', '', '470560');
  381. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5', 'GASTOS', 'H', 'E', '', '5');
  382. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('51', 'GASTOS OPERACIONALES DE ADMON.', 'H', 'E', '', '51');
  383. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5105', 'GASTOS DE PERSONAL', 'H', 'E', '', '5105');
  384. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('510548', 'BONIFICACION', 'H', 'E', '', '510548');
  385. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('52', 'GASTOS OPERACIONALES DE VENTAS', 'H', 'E', '', '52');
  386. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205', 'GASTOS DE PERSONAL', 'H', 'E', '', '5205');
  387. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('520506', 'SUELDOS', 'H', 'E', '', '520506');
  388. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('520527', 'AUXILIO DE TRANSPORTE', 'H', 'E', '', '520527');
  389. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('520530', 'CESANTIAS', 'H', 'E', '', '520530');
  390. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('520533', 'INTERESES SOBRE CESANTIAS', 'H', 'E', '', '520533');
  391. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205330001', 'Intereses Sobre Cesantias', 'A', 'E', '', '5205330001');
  392. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('520536', 'PRIMAS DE SERVICIOS', 'H', 'E', '', '520536');
  393. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('520539', 'VACACIONES', 'H', 'E', '', '520539');
  394. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('520548', 'BONIFICACIONES', 'H', 'E', '', '520548');
  395. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205480001', 'Bonificaciones a Empleados', 'A', 'E', '', '5205480001');
  396. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('520563', 'CAPACITACION AL PERSONAL', 'H', 'E', '', '520563');
  397. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205630001', 'Capacitacion al Personal', 'A', 'E', '', '5205630001');
  398. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('520568', 'APORTES ARP', 'H', 'E', '', '520568');
  399. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('520569', 'APORTES EPS', 'H', 'E', '', '520569');
  400. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('520570', 'APORTES A FONDO DE PENSIONES/CES', 'H', 'E', '', '520570');
  401. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('520572', 'APORTES CAJAS DE COMPENSACION', 'H', 'E', '', '520572');
  402. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('520575', 'APORTES ICBF', 'H', 'E', '', '520575');
  403. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('520578', 'APORTES SENA', 'H', 'E', '', '520578');
  404. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('520595', 'OTROS GASTOS DE PERSONAL', 'H', 'E', '', '520595');
  405. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205950001', 'Otros Gastos de personal', 'A', 'E', '', '5205950001');
  406. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5210', 'HONORARIOS', 'H', 'E', '', '5210');
  407. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('521005', 'JUNTA DIRECTIVA', 'H', 'E', '', '521005');
  408. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('521010', 'REVISORIA FISCAL', 'H', 'E', '', '521010');
  409. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('521015', 'AUDITORIA EXTERNA', 'H', 'E', '', '521015');
  410. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('521025', 'ASESORIA JURIDICA', 'H', 'E', '', '521025');
  411. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('521030', 'ASESORIA FINANCIERA', 'H', 'E', '', '521030');
  412. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('521035', 'ASESORIA TECNICA', 'H', 'E', '', '521035');
  413. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('521095', 'OTROS HONORARIOS', 'H', 'E', '', '521095');
  414. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5210950001', 'Estudio y Dise¤o de Planos', 'A', 'E', '', '5210950001');
  415. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5215', 'IMPUESTOS', 'H', 'E', '', '5215');
  416. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('521505', 'INDUSTRIA Y COMERCIO', 'H', 'E', '', '521505');
  417. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5215050001', 'Impuesto de Industria y Comercio', 'A', 'E', '', '5215050001');
  418. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('521510', 'DE TIMBRES', 'H', 'E', '', '521510');
  419. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5215100001', 'Impuesto de Timbre', 'A', 'E', '', '5215100001');
  420. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('521515', 'IMPUESTOS A LA PROPIEDAD RAIZ', 'H', 'E', '', '521515');
  421. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5215200001', 'DERECHOS SOBRE INSTRUMENTOS PUBL', 'A', 'E', '', '5215200001');
  422. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('521540', 'IMPUESTOS SOBRE VEHICULOS', 'H', 'E', '', '521540');
  423. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5215400001', 'Impuestos Sobre Vehiculos', 'A', 'E', '', '5215400001');
  424. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('521595', 'OTROS IMPUESTOS', 'H', 'E', '', '521595');
  425. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5220', 'ARRENDAMIENTOS', 'H', 'E', '', '5220');
  426. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('522010', 'CONSTRUCCIONES U EDIFICACIONES', 'H', 'E', '', '522010');
  427. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('522015', 'MAQUINARIA Y EQUIPO', 'H', 'E', '', '522015');
  428. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5220150001', 'Arriendo Maquinaria y Equipo', 'A', 'E', '', '5220150001');
  429. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('522025', 'EQUIPOS DE COMPUTACION Y COMUNIC', 'H', 'E', '', '522025');
  430. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5220250001', 'Alquiler Eq. Computacion y Comun', 'A', 'E', '', '5220250001');
  431. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('522040', 'FLOTA Y EQUIPO DE TRANSPORTE', 'H', 'E', '', '522040');
  432. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5220400001', 'Alquiler de Vehiculos y Camiones', 'A', 'E', '', '5220400001');
  433. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5230', 'SEGUROS', 'H', 'E', '', '5230');
  434. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523005', 'MANEJO', 'H', 'E', '', '523005');
  435. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523010', 'CUMPLIMIENTO', 'H', 'E', '', '523010');
  436. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5230100001', 'Polizas de Cumplimiento', 'A', 'E', '', '5230100001');
  437. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523040', 'FLOTA Y EQUIPO DE TRANSPORTE', 'H', 'E', '', '523040');
  438. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523075', 'OBLIGATORIO ACCIDENTES DE TRANSI', 'H', 'E', '', '523075');
  439. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235', 'SERVICIOS', 'H', 'E', '', '5235');
  440. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523505', 'ASEO Y VIGILANCIA', 'H', 'E', '', '523505');
  441. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523515', 'ASSITENCIA TECNICA', 'H', 'E', '', '523515');
  442. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523520', 'PROCESAMIENTO ELECTRONICO DE DAT', 'H', 'E', '', '523520');
  443. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235200001', 'Procesamiento electronico de Dat', 'A', 'E', '', '5235200001');
  444. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523525', 'ACUEDUCTO Y ALCANTARILLADO', 'H', 'E', '', '523525');
  445. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523530', 'ENERGIA ELECTRICA', 'H', 'E', '', '523530');
  446. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523535', 'TELEFONO', 'H', 'E', '', '523535');
  447. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523540', 'CORREO PORTES Y TELEGRAMAS', 'H', 'E', '', '523540');
  448. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523545', 'FAX Y TELEX', 'H', 'E', '', '523545');
  449. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235450001', 'fax y Telex', 'A', 'E', '', '5235450001');
  450. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523550', 'TRANSPORTES FLETES Y ACARREOS', 'H', 'E', '', '523550');
  451. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523555', 'GAS', 'H', 'E', '', '523555');
  452. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523560', 'PUBLICIDAD PROPAGANDA Y PROMOCIO', 'H', 'E', '', '523560');
  453. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235600001', 'Publicidad Propaganda y Promocio', 'A', 'E', '', '5235600001');
  454. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('523595', 'OTROS SERVICIOS', 'H', 'E', '', '523595');
  455. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235950002', 'Fabricacion y Elaboracion', 'A', 'E', '', '5235950002');
  456. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235950004', 'Capacitacion a Contratistas', 'A', 'E', '', '5235950004');
  457. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235950007', 'Digitación y archivo documentos', 'A', 'E', '', '5235950007');
  458. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5240', 'GASTOS LEGALES', 'H', 'E', '', '5240');
  459. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('524005', 'NOTARIALES', 'H', 'E', '', '524005');
  460. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('524010', 'REGISTRO MERCANTIL', 'H', 'E', '', '524010');
  461. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5240100001', 'Registro Mercantil', 'A', 'E', '', '5240100001');
  462. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('524015', 'TRAMITES Y LICENCIAS', 'H', 'E', '', '524015');
  463. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('524095', 'OTROS GASTOS LEGALES', 'H', 'E', '', '524095');
  464. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5240950001', 'Tramite de Vehiculos', 'A', 'E', '', '5240950001');
  465. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5240950003', 'Sobretasa', 'A', 'E', '', '5240950003');
  466. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5240950004', 'Dcmtos Varios en Camara Comercio', 'A', 'E', '', '5240950004');
  467. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5240950005', 'Floio para Libros Legales', 'A', 'E', '', '5240950005');
  468. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5240950006', 'Impuesto para preservar la Segur', 'A', 'E', '', '5240950006');
  469. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5245', 'MANTENIMIENTO Y REPARACIONES', 'H', 'E', '', '5245');
  470. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('524510', 'CONSTRUCCIONES Y EDIFICACIONES', 'H', 'E', '', '524510');
  471. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5245100001', 'Construcciones y Edificaciones', 'A', 'E', '', '5245100001');
  472. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('524515', 'MAQUINARIA Y EQUIPOS', 'H', 'E', '', '524515');
  473. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5245150001', 'Equipo de Refrigeracion', 'A', 'E', '', '5245150001');
  474. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5245150002', 'Equipos de Ingenieria Civil', 'A', 'E', '', '5245150002');
  475. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5245150003', 'Repuestos y Herramientas', 'A', 'E', '', '5245150003');
  476. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('524520', 'EQUIPO DE OFICINA', 'H', 'E', '', '524520');
  477. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5245200001', 'Equipo de Oficina', 'A', 'E', '', '5245200001');
  478. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('524525', 'EQUIPO DE COMPUTACION Y COMUNICA', 'H', 'E', '', '524525');
  479. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5245250001', 'Mtto y Rep. Eq. Computacion y Co', 'A', 'E', '', '5245250001');
  480. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('524540', 'FLOTA Y EQUIPO DE TRANSPORTE', 'H', 'E', '', '524540');
  481. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5245400001', 'Mantenimiento de Vehiculos', 'A', 'E', '', '5245400001');
  482. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5250', 'ADECUACION E INSTALACION', 'H', 'E', '', '5250');
  483. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('525005', 'INSTALACIONES ELECTRICAS', 'H', 'E', '', '525005');
  484. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5250050001', 'Instalaciones Electricas', 'A', 'E', '', '5250050001');
  485. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('525010', 'ARREGLOS ORNAMENTALES', 'H', 'E', '', '525010');
  486. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('525015', 'REPARACIONES LOCATIVAS', 'H', 'E', '', '525015');
  487. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('525095', 'OTROS ADECUACIONES E INSTALACION', 'H', 'E', '', '525095');
  488. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5255', 'GASTOS DE VIAJE', 'H', 'E', '', '5255');
  489. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('525505', 'ALOJAMIENTO Y MANUTENCION', 'H', 'E', '', '525505');
  490. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('525515', 'PASAJES AEREOS', 'H', 'E', '', '525515');
  491. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('525520', 'PASAJES TERRESTRES', 'H', 'E', '', '525520');
  492. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5255200001', 'Pasajes Terrestres', 'A', 'E', '', '5255200001');
  493. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('525595', 'OTROS GASTOS DE VIAJE', 'H', 'E', '', '525595');
  494. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5255950002', 'Llamadas Telefonicas en Viajes', 'A', 'E', '', '5255950002');
  495. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5260', 'DEPRECIACIONES', 'H', 'E', '', '5260');
  496. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('526005', 'CONSTRUCCIONES Y EDIFICACIONES', 'H', 'E', '', '526005');
  497. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5260050001', 'Depreciacion Locales Tequendama', 'A', 'E', '', '5260050001');
  498. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('526010', 'MAQUINARIA Y EQUIPO', 'H', 'E', '', '526010');
  499. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5260100001', 'Depreciacion de maq. y Equipos', 'A', 'E', '', '5260100001');
  500. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('526015', 'EQUIPOS DE OFICINA', 'H', 'E', '', '526015');
  501. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5260150001', 'Depreciacion Equipos de Oficina', 'A', 'E', '', '5260150001');
  502. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('526020', 'EQUIPOS DE COMPUTACION Y COMUNIC', 'H', 'E', '', '526020');
  503. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5260200001', 'Depreciacion Eq. de Computacion', 'A', 'E', '', '5260200001');
  504. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('526035', 'FLOTA Y EQUIPO DE TRANSPORTE', 'H', 'E', '', '526035');
  505. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5260350001', 'Depreciacion de Vehiculos', 'A', 'E', '', '5260350001');
  506. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('526099', 'AJUSTES POR INLFACION', 'H', 'E', '', '526099');
  507. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5260990005', 'Aj. Infl. Construcciones y Edif.', 'A', 'E', '', '5260990005');
  508. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5260990010', 'Aj. Infl. Maquinaria y Equipo', 'A', 'E', '', '5260990010');
  509. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5260990015', 'Aj. Infl. Equipos de Oficina', 'A', 'E', '', '5260990015');
  510. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5260990020', 'Aj. Infl. Eq. Computacion y Com.', 'A', 'E', '', '5260990020');
  511. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5260990035', 'Aj. Infl. Vehiculos', 'A', 'E', '', '5260990035');
  512. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5295', 'GASTOS DIVERSOS', 'H', 'E', '', '5295');
  513. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('529505', 'COMISIONES', 'H', 'E', '', '529505');
  514. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('529510', 'LIBROS SUSCRIPCIONES PERIODICOS', 'H', 'E', '', '529510');
  515. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5295100001', 'Libros Suscripciones periodicos', 'A', 'E', '', '5295100001');
  516. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('529520', 'GASTOS DE REPRESENTACION Y REL.P', 'H', 'E', '', '529520');
  517. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5295200001', 'Gastos de Representacion y Rel.P', 'A', 'E', '', '5295200001');
  518. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('529525', 'ELEMENTOS DE ASEO Y CAFETERIA', 'H', 'E', '', '529525');
  519. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('529530', 'UTILES PAPELERIA Y FOTOCOPIAS', 'H', 'E', '', '529530');
  520. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('529535', 'COMBUSTIBLES Y LUBRICANTES', 'H', 'E', '', '529535');
  521. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('529545', 'TAXIS Y BUSES', 'H', 'E', '', '529545');
  522. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('529550', 'ESTAMPILLAS', 'H', 'E', '', '529550');
  523. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5295500001', 'Estampillas', 'A', 'E', '', '5295500001');
  524. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('529560', 'CASINO Y RESTAURANTE', 'H', 'E', '', '529560');
  525. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('529565', 'PARQUEADEROS', 'H', 'E', '', '529565');
  526. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5295650001', 'Parqueaderos', 'A', 'E', '', '5295650001');
  527. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('529595', 'OTROS GASTOS DIVERSOS', 'H', 'E', '', '529595');
  528. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5295950001', 'Cargue y Decargue de Materiales', 'A', 'E', '', '5295950001');
  529. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5295950002', 'Autenticaciones', 'A', 'E', '', '5295950002');
  530. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5295950004', 'Ajuste al Peso', 'A', 'E', '', '5295950004');
  531. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5299', 'PROVISIONES', 'H', 'E', '', '5299');
  532. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('529910', 'DEUDORES', 'H', 'E', '', '529910');
  533. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5299100001', 'Provision Deudas Dificil Recaudo', 'A', 'E', '', '5299100001');
  534. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('53', 'GASTOS NO OPERACIONALES', 'H', 'E', '', '53');
  535. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5305', 'GASTOS FINANCIEROS', 'H', 'E', '', '5305');
  536. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('530505', 'GASTOS BANCARIOS', 'H', 'E', '', '530505');
  537. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5305050001', 'Gastos Bancarios', 'A', 'E', '', '5305050001');
  538. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('530515', 'COMISIONES', 'H', 'E', '', '530515');
  539. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5305150001', 'Comisiones Bancarias', 'A', 'E', '', '5305150001');
  540. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('530520', 'INTERESES', 'H', 'E', '', '530520');
  541. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5305200001', 'Intereses Corriente Ptmos Bancar', 'A', 'E', '', '5305200001');
  542. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5305200002', 'Intereses por Sobregiro Bancario', 'A', 'E', '', '5305200002');
  543. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5305200003', 'Intereses de Mora', 'A', 'E', '', '5305200003');
  544. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5315', 'GASTOS EXTRAORDINARIOS', 'H', 'E', '', '5315');
  545. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('531520', 'IMPUESTOS ASUMIDOS', 'H', 'E', '', '531520');
  546. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5315200001', 'Impuestos Asumidos', 'A', 'E', '', '5315200001');
  547. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('531595', 'OTROS GASTOS EXTRAORDINARIOS', 'H', 'E', '', '531595');
  548. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5395', 'GASTOS DIVERSOS', 'H', 'E', '', '5395');
  549. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('539520', 'MULTAS SANCIONES Y LITIGIOS', 'H', 'E', '', '539520');
  550. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5395200001', 'Multas Sanciones y Litigios', 'A', 'E', '', '5395200001');
  551. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('54', 'IMPUESTO DE RENTA Y COMPLEMENTAR', 'H', 'E', '', '54');
  552. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5405', 'IMPUESTO DE RENTA Y COMPLEMENTAR', 'H', 'E', '', '5405');
  553. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('540505', 'IMPUESTO DE RENTA Y COMPLEMENTAR', 'H', 'E', '', '540505');
  554. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5405050001', 'Impuesto de Renta y Complementar', 'A', 'E', '', '5405050001');
  555. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('6', 'COSTO DE VENTA', 'H', 'E', '', '6');
  556. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('61', 'COSTO DE VENTAS Y PREST. SERVICI', 'H', 'E', '', '61');
  557. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('6135', 'COMERCIO AL POR MAYOR Y MENOR', 'H', 'E', '', '6135');
  558. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('613554', 'VTA MAQ. EQ. OFIC. Y SOFTWARE', 'H', 'E', '', '613554');
  559. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('6135540001', 'Costo de Ventas', 'A', 'E', '', '6135540001');
  560. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('62', 'COMPRAS', 'H', 'E', '', '62');
  561. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('6205', 'COMPRA DE MERCANCIA', 'H', 'E', '', '6205');
  562. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('6210', 'COMPRA DE MATERIA PRIMA', 'H', 'E', '', '6210');
  563. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('621001', 'COMPRA DE MATERIA PRIMA', 'H', 'E', '', '621001');
  564. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1305050002', 'Clientes Nacionales', 'A', 'A', 'AR', '1305050002');
  565. 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', '2408050001');
  566. 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', '2408050002');
  567. 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', '2408050003');
  568. 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', '2408050004');
  569. 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', '2408050005');
  570. 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', '2408050010');
  571. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1305050001', 'Clientes Nacionales', 'A', 'A', 'AR', '1305050001');
  572. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1330050001', 'Anticipo a Proveedores', 'A', 'A', '', '1330050001');
  573. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1350950001', 'Contratos de Consultoria', 'A', 'A', '', '1350950001');
  574. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1465050001', 'Inventarios en Transito', 'A', 'A', 'IC', '1465050001');
  575. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2205050002', 'Proveedores Nacionales', 'A', 'L', 'AP', '2205050002');
  576. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2320050001', 'Cuentas por pagar a Contratistas', 'A', 'L', 'AP', '2320050001');
  577. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2315', 'A COMPA??AS VINCULADAS', 'H', 'L', '', '2315');
  578. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2335950001', 'Gastos Causados por Pagar', 'A', 'L', 'AP', '2335950001');
  579. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2205050001', 'Proveedores Nacionales', 'A', 'L', 'AP', '2205050001');
  580. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365150002', 'Honorarios Persona Natural 11%', 'A', 'L', 'AP_tax:IC_taxservice', '2365150002');
  581. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365150003', 'Honorarios Persona Juridica 10%', 'A', 'L', 'AP_tax:IC_taxservice', '2365150003');
  582. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5105480001', 'Bonificaciones a Empleados', 'A', 'E', '', '5105480001');
  583. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('142005', 'CONTRATOS EN EJECUCION', 'H', 'A', '', '142005');
  584. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5220100001', 'Arriendo Casa', 'A', 'E', 'IC_expense', '5220100001');
  585. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5255950001', 'Taxis y Buses', 'A', 'E', 'IC_expense', '5255950001');
  586. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235550001', 'Gas', 'A', 'E', 'IC_expense', '5235550001');
  587. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5255150001', 'Pasajes Aereos', 'A', 'E', 'IC_expense', '5255150001');
  588. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235250001', 'Acueducto y Alcantarilldo', 'A', 'E', 'IC_expense', '5235250001');
  589. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2368030002', 'Retencion ICA 8xMil', 'A', 'L', 'AP_tax:IC_taxservice', '2368030002');
  590. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2380950001', 'Cuentas por pagar', 'A', 'L', 'AP', '2380950001');
  591. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1330100001', 'Anticipo a Contratistas', 'A', 'A', 'AR', '1330100001');
  592. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2408050006', 'IVA Descontable en compras 20% ', 'A', 'L', 'IC_taxservice', '2408050006');
  593. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5295950003', 'Compra de Medicina Contratistas', 'A', 'E', 'IC_expense', '5295950003');
  594. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5295600001', 'Casino y Restaurante', 'A', 'E', 'IC_expense', '5295600001');
  595. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5295450001', 'Taxis y Buses Urbanos', 'A', 'E', 'IC_expense', '5295450001');
  596. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5295350001', 'Combustibles y lubricantes', 'A', 'E', 'IC_expense', '5295350001');
  597. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5295050001', 'Comisiones', 'A', 'E', 'IC_expense', '5295050001');
  598. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5255950003', 'Tasa Aeroportuaria', 'A', 'E', 'IC_expense', '5255950003');
  599. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5255050001', 'Alojamiento y Manutencion', 'A', 'E', 'IC_expense', '5255050001');
  600. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5250150001', 'Reparaciones Locativas', 'A', 'E', 'IC_expense', '5250150001');
  601. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5240950002', 'Exp. Certif. Libertad y tradicio', 'A', 'E', 'IC_expense', '5240950002');
  602. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5240150001', 'Tramites y Licencias', 'A', 'E', 'IC_expense', '5240150001');
  603. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235950006', 'Mano de Obra OBRAS CIVILES', 'A', 'E', 'IC_expense', '5235950006');
  604. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235950005', 'Jardineria', 'A', 'E', 'IC_expense', '5235950005');
  605. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235950003', 'Digitacion de Planos', 'A', 'E', 'IC_expense', '5235950003');
  606. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235950001', 'Pintura', 'A', 'E', 'IC_expense', '5235950001');
  607. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235500001', 'Transportes Fletes y Acarreos', 'A', 'E', 'IC_expense', '5235500001');
  608. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235400001', 'Correo Portes y Telegramas', 'A', 'E', 'IC_expense', '5235400001');
  609. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235150001', 'Asistencia tecnica', 'A', 'E', 'IC_expense', '5235150001');
  610. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235050001', 'Aseo y Vigilancia', 'A', 'E', 'IC_expense', '5235050001');
  611. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5215950001', 'Impuesto de 3 por Mil', 'A', 'E', 'IC_expense', '5215950001');
  612. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5215150001', 'Impuestos a la Propiedad raiz', 'A', 'E', 'IC_expense', '5215150001');
  613. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5210950003', 'Asesoria Administrativa y de Mer', 'A', 'E', 'IC_expense', '5210950003');
  614. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5210950002', 'Asesoria Contable', 'A', 'E', 'IC_expense', '5210950002');
  615. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5210250001', 'Asesorias Juridicas', 'A', 'E', 'IC_expense', '5210250001');
  616. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205780001', 'Aportes SENA', 'A', 'E', 'IC_expense', '5205780001');
  617. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205750001', 'Aportes ICBF', 'A', 'E', 'IC_expense', '5205750001');
  618. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205720001', 'Aportes cajas de Compensacion', 'A', 'E', 'IC_expense', '5205720001');
  619. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205700001', 'Aportes fondo de Pensiones y Ces', 'A', 'E', 'IC_expense', '5205700001');
  620. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205690001', 'Aportes EPS', 'A', 'E', 'IC_expense', '5205690001');
  621. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205680001', 'Aportes ARP', 'A', 'E', 'IC_expense', '5205680001');
  622. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205390001', 'Vacaciones', 'A', 'E', 'IC_expense', '5205390001');
  623. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205360001', 'Primas de Servicios', 'A', 'E', 'IC_expense', '5205360001');
  624. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205300001', 'Cesantias', 'A', 'E', 'IC_expense', '5205300001');
  625. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205270001', 'Auxilio de transporte', 'A', 'E', 'IC_expense', '5205270001');
  626. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4295050001', 'Aprovechamiento Material Sobrant', 'A', 'I', 'IC_sale:IC_income', '4295050001');
  627. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4210050001', 'Intereses por Rendimientos Finan', 'A', 'I', 'IC_income', '4210050001');
  628. 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', '2408100001');
  629. 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', '2408100002');
  630. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('6210010001', 'Compra de Materia Prima', 'A', 'E', 'IC_cogs', '6210010001');
  631. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365400002', 'Compra Combustibles y Lub. 0.1%', 'A', 'L', 'IC_taxservice', '2365400002');
  632. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365400001', 'Compras en General 3.5%', 'A', 'L', 'IC_taxpart:IC_taxservice', '2365400001');
  633. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365300004', 'Arriendo Maq. Obra Civil 2%', 'A', 'L', 'IC_taxservice', '2365300004');
  634. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365300003', 'Arriendo Bienes Muebles 4%', 'A', 'L', 'IC_taxservice', '2365300003');
  635. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365300001', 'Arriendo Inmuebles 3.5%', 'A', 'L', 'IC_taxservice', '2365300001');
  636. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365250004', 'Construccion Obra Civil 1%', 'A', 'L', 'IC_taxservice', '2365250004');
  637. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365250003', 'Transporte de Carga 1%', 'A', 'L', 'IC_taxservice', '2365250003');
  638. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365250001', 'Servicios en General 6%', 'A', 'L', 'IC_taxservice', '2365250001');
  639. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365200001', 'Retencion Comision del 11%', 'A', 'L', 'IC_taxpart:IC_taxservice', '2365200001');
  640. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365150001', 'Honorarios Persona Natural 10%', 'A', 'L', 'AP_tax:IC_taxservice', '2365150001');
  641. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5295300001', 'Utiles Papeleria y Fotocopias', 'A', 'E', 'AP_amount:IC_expense', '5295300001');
  642. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5295250001', 'Elementos de Aseo y Cafeteria', 'A', 'E', 'AP_amount:IC_expense', '5295250001');
  643. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235300001', 'Energia Electrica', 'A', 'E', 'AP_amount:IC_expense', '5235300001');
  644. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5235350001', 'Telefono', 'A', 'E', 'AP_amount:IC_expense', '5235350001');
  645. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1355150003', 'Retefuente 7% Rendimientos Finan', 'A', 'A', 'IC_taxpart:IC_taxservice', '1355150003');
  646. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1355150001', 'Retefuente 2% Factor multiplicad', 'A', 'A', '', '1355150001');
  647. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1355170001', 'Iva Retenido 75% de 16%', 'A', 'A', 'IC_taxpart:IC_taxservice', '1355170001');
  648. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2365150004', 'Honorarios Persona Juridica 11%', 'A', 'L', 'CT_tax', '2365150004');
  649. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2367050001', 'Iva retenido reg simplif 12% ', 'A', 'L', 'AP_tax', '236705');
  650. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('236710', 'IVA RETENIDO AL REGIMEN COMUN ', 'H', 'L', '', '2367');
  651. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('236705', 'IVA RETENIDO AL REGIMEN SIMPLIF. ', 'H', 'L', '', '2367');
  652. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2367', 'IMPUESTO A LAS VENTAS RETENIDO', 'H', 'L', '', '23');
  653. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4295810001', 'Ajuste al Peso', 'A', 'I', '', '4295810001');
  654. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5240050001', 'Gastos Notariales', 'A', 'E', 'IC_expense', '5240050001');
  655. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('429581001', 'Ajuste', 'A', 'I', '', '429581001');
  656. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4130950001', 'Consultorias', 'A', 'I', 'AR_amount:IC_income', '4130950001');
  657. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4130100001', 'Ingresos por Obras Civiles', 'A', 'I', 'AR_amount:IC_income', '4130100001');
  658. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4130950002', 'Interventorias', 'A', 'I', 'AR_amount:IC_income', '4130950002');
  659. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4220100001', 'Arriendo de locales y oficinas', 'A', 'I', 'AR_amount:IC_income', '4220100001');
  660. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4220150001', 'Arriendo de Maquinaria y Equipos', 'A', 'I', 'AR_amount:IC_income', '4220150001');
  661. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4235950001', 'Algo',
  662. 'A', 'I', 'AR_amount:IC_income', '4235950001');
  663. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5205060001', 'Sueldos de Personal', 'A', 'E', 'AP_amount:IC_expense', '5205060001');
  664. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2370060001', 'Aportes a ARP', 'A', 'L', '', '2370060001');
  665. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2380950002', 'Otros Acreedores Varios', 'A', 'L', 'AP', '2380950001');
  666. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2335300001', 'Servicios Tecnicos', 'A', 'L', 'AP', '2335300001');
  667. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2370100001', 'Aportes a Sena, icbf y Cajas com', 'A', 'L', '', '2370100001');
  668. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2380300001', 'Fondos de Cesantias y/o Pension', 'A', 'L', '', '2380300001');
  669. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2505050001', 'Salarios por Pagar', 'A', 'L', '', '2505050001');
  670. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2610050001', 'Cesantias', 'A', 'L', '', '2610050001');
  671. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2610100001', 'Intereses Sobre Cesantias', 'A', 'L', '', '2610100001');
  672. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2610150001', 'Vacaciones', 'A', 'L', '', '2610150001');
  673. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2610200001', 'Prima de Servicios', 'A', 'L', '', '2610200001');
  674. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2367100001', 'Iva retenido al reg comun 16% ', 'A', 'L', 'CT_tax', '236710');
  675. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2367050002', 'Iva retenido Reg Simp.del 7% ', 'A', 'L', 'IC_taxservice', '236705');
  676. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2367100002', 'Iva retenido al reg comun 20% ', 'A', 'L', 'IC_taxpart:IC_taxservice', '236710');
  677. 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', '236710');
  678. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1410990001', 'Aj. por Inflacion Inv. en Proces', 'A', 'A', '', '1410990001');
  679. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1465990001', 'Aj.por Infl. Inv. en Transito', 'A', 'A', '', '1465990001');
  680. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1330150001', 'Anticipo a Trabajadores', 'A', 'A', 'AR', '1330150001');
  681. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1420990001', 'Aj.por Inflacion Ctos en Ejecuci', 'A', 'A', '', '1420990001');
  682. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1430990001', 'Aj.por Inflacion Inv.Prod.Termin', 'A', 'A', '', '1430990001');
  683. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1435990001', 'Aj.por Infl.Mcia No Fab.Empresa', 'A', 'A', '', '1435990001');
  684. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1105050001', 'Caja Mayor', 'A', 'A', 'AR_paid:AP_paid', '1105050001');
  685. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1105100001', 'Caja Menor 1', 'A', 'A', 'AR_paid:AP_paid', '1105100001');
  686. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1105100002', 'Caja Menor 2', 'A', 'A', 'AR_paid:AP_paid', '1105100002');
  687. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1105100003', 'Caja Menor 3', 'A', 'A', 'AR_paid:AP_paid', '1105100003');
  688. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1105100004', 'Caja menor 4', 'A', 'A', 'AR_paid:AP_paid', '1105100004');
  689. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1105100005', 'Caja menor 5', 'A', 'A', 'AR_paid:AP_paid', '1105100005');
  690. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1110050013', 'Banco Ganadero Cta.Cte.xxxxxxxx', 'A', 'A', 'AR_paid:AP_paid', '1110050013');
  691. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1110050029', 'Tequendama Cte. #xxxxxxxx', 'A', 'A', 'AR_paid:AP_paid', '1110050029');
  692. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1120050013', 'Banco Ganadero Ahorro xxxxxxxx', 'A', 'A', 'AR_paid:AP_paid', '1120050013');
  693. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1120050019', 'Banco Colpatria Ahor. xxxxxxxxx', 'A', 'A', 'AR_paid:AP_paid', '1120050019');
  694. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1120051302', 'Bco Ganadero Ahorro xxxxxxxxxx', 'A', 'A', 'AR_paid:AP_paid', '1120051302');
  695. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1355150020', 'Retencion en la Fuente Año Anter', 'A', 'A', '', '1355150020');
  696. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1410050001', 'Muebles', 'A', 'A', 'IC', '1410050001');
  697. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1410050002', 'Inventario 1', 'A', 'A', 'IC', '1410050002');
  698. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1410050003', 'Inventario 2', 'A', 'A', 'IC', '1410050003');
  699. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1410050004', 'Inventario 3', 'A', 'A', 'IC', '1410050004');
  700. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1410050005', 'Inventario 4', 'A', 'A', 'IC', '1410050005');
  701. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1410050010', 'Inventario 5', 'A', 'A', 'IC', '1410050010');
  702. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1420050001', 'Lokesea', 'A', 'A', 'IC', '1420050001');
  703. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1430050001', 'Lokesea', 'A', 'A', 'IC', '1430050001');
  704. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1435050001', 'Lokesea', 'A', 'A', 'IC', '1435050001');
  705. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1420050002', 'Lokesea', 'A', 'A', 'IC', '1420050002');
  706. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1516100001', 'Local #1', 'A', 'A', '', '1516100001');
  707. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1516100002', 'Local #2', 'A', 'A', '', '1516100002');
  708. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1516100003', 'Local #3', 'A', 'A', '', '1516100003');
  709. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1516990001', 'Aj. Infl. Local #1', 'A', 'A', '', '1516990001');
  710. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1435050099', 'Cuenta Inventario para Lokesea', 'A', 'A', 'IC', '1435050099');
  711. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1516991001', 'Aj. Infl. Local #1', 'A', 'A', '', '1516991001');
  712. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1516991002', 'Aj. Infl. Local #2', 'A', 'A', '', '1516991002');
  713. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1516991003', 'Aj. Infl. Local #3', 'A', 'A', '', '1516991003');
  714. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1520020001', 'Lokesea del Inventario', 'A', 'A', '', '1520020001');
  715. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1520020002', 'Equipo de Lokeasea', 'A', 'A', '', '1520020002');
  716. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1520990201', 'Aj. por Inflacion Lokesea', 'A', 'A', '', '1520990201');
  717. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1520990202', 'Aj.x Infl. Otro Lokesea', 'A', 'A', '', '1520990202');
  718. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1524100001', 'Aire Acondicionado LG', 'A', 'A', '', '1524100001');
  719. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1524991001', 'Aj. por Inflac. Aire Acond. LG', 'A', 'A', '', '1524991001');
  720. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1592100001', 'Depreciacion Lokesea', 'A', 'A', '', '1592100001');
  721. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1540050001', 'Mazda Blanco Placa ALGO0815', 'A', 'A', '', '1540050001');
  722. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1592050001', 'Local #1', 'A', 'A', '', '1592050001');
  723. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1592050002', 'Local #2', 'A', 'A', '', '1592050002');
  724. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1592050003', 'Local #3', 'A', 'A', '', '1592050003');
  725. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1592100002', 'Deprec. Otro Lokesea', 'A', 'A', '', '1592100002');
  726. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1592150001', 'Depreciacion Aire LG', 'A', 'A', '', '1592150001');
  727. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1592350001', 'Mazda Balnco Placa ALGO0815', 'A', 'A', '', '1592350001');
  728. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1910080001', 'Local #1', 'A', 'A', '', '1910080001');
  729. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1910080002', 'Local #2', 'A', 'A', '', '1910080002');
  730. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1910080003', 'Local #3', 'A', 'A', '', '1910080003');
  731. 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');
  732. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3115050001', 'Yo', 'A', 'Q', '', '3115050001');
  733. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3115050002', 'Tu', 'A', 'Q', '', '3115050002');
  734. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4120270001', 'Lokeproducimos', 'A', 'I', 'AR_amount:IC_income', '4120270001');
  735. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4130950003', 'En que ganamos?', 'A', 'I', 'AR_amount:IC_income', '4130950003');
  736. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4135950001', 'Loquevendomos', 'A', 'I', '', '4135950001');
  737. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4150300001', 'Vendo hasta mi mama!', 'A', 'I', '', '4150300001');
  738. INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5230750001', 'Soat - Seguro Obligatorio Vehiculos', 'A', 'E', '', '5230750001');
  739. --
  740. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '1355150003'), -0.07);
  741. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '1355170001'), -0.12);
  742. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2365150001'), -0.1);
  743. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2365150002'), -0.11);
  744. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2365150003'), -0.1);
  745. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2365150004'), -0.11);
  746. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2365200001'), -0.11);
  747. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2365250001'), -0.06);
  748. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2365250003'), -0.01);
  749. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2365250004'), -0.01);
  750. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2365300001'), -0.035);
  751. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2365300003'), -0.04);
  752. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2365300004'), -0.02);
  753. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2365400001'), -0.035);
  754. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2365400002'), -0.001);
  755. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2367050001'), -0.12);
  756. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2367050002'), -0.0525);
  757. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2367100001'), -0.12);
  758. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2367100002'), -0.15);
  759. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2367100003'), -0.0525);
  760. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2368030002'), -0.008);
  761. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2408050001'), 0.16);
  762. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2408050002'), 0.16);
  763. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2408050003'), 0.07);
  764. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2408050004'), 0.08);
  765. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2408050005'), 0.2);
  766. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2408050006'), 0.2);
  767. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2408050010'), 0.12);
  768. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2408100001'), 0.16);
  769. INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '2408100002'), 0.07);
  770. INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id',
  771. SELECT id FROM chart WHERE accno = '141005001'));
  772. INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (SELECT id FROM chart WHERE accno = '412027001'));
  773. INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE accno = '5250150001'));
  774. INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE accno = '4705400001'));
  775. INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE accno = '530520001'));
  776. INSERT INTO defaults (setting_key, value) VALUES ('curr', 'COP');
  777. INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');