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