[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb:[2644] trunk/sql/coa
- Subject: SF.net SVN: ledger-smb:[2644] trunk/sql/coa
- From: ..hidden..
- Date: Fri, 12 Jun 2009 01:39:22 +0000
Revision: 2644
http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2644&view=rev
Author: einhverfr
Date: 2009-06-12 01:39:22 +0000 (Fri, 12 Jun 2009)
Log Message:
-----------
More chart conversions
Modified Paths:
--------------
trunk/sql/coa/ch/chart/German.sql
trunk/sql/coa/co/chart/PUC.sql
Modified: trunk/sql/coa/ch/chart/German.sql
===================================================================
--- trunk/sql/coa/ch/chart/German.sql 2009-06-12 01:38:06 UTC (rev 2643)
+++ trunk/sql/coa/ch/chart/German.sql 2009-06-12 01:39:22 UTC (rev 2644)
@@ -2,155 +2,155 @@
-- Swiss chart of accounts
-- adapted to numeric representation of chart no.
--
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('10000','AKTIVEN','H','1','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11000','UMLAUFSVERMÃGEN','H','10000','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11100','FlÃssige Mittel','H','11000','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11102','Bank CS Kt. 177929-11','A','11100','A','AR_paid:AP_paid');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11110','Forderungen','H','11000','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11120','VorrÃte und angefangene Arbeiten','H','11000','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11128','Angefangene Arbeiten','A','11120','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11130','Aktive Rechnungsabgrenzung','A','11000','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('14000','ANLAGEVERMÃGEN','H','10000','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('18000','AKTIVIERTER AUFWAND UND AKTIVE BERICHTIGUNGSPOSTEN','H','10000','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('18182','Entwicklungsaufwand','A','18000','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('20000','PASSIVEN','H','2','L','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21000','FREMDKAPITAL KURZFRISTIG','H','20000','L','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21200','Kurzfristige Verbindlichkeiten aus Lieferungen und Leistungen','H','21000','L','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21201','Lieferanten','A','21200','L','AP');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21202','Personalaufwand','A','21200','L','AP');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21203','Sozialversicherungen','A','21200','L','AP');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21205','Leasing','A','21200','L','AP');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21210','Kurzfristige Finanzverbindlichkeiten','H','21000','L','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21220','Andere kurzfristige Verbindlichkeiten','H','21000','L','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21222','MWST (3,6)','A','21220','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21229','GewinnausschÃttung','A','21220','L','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21230','Passive Rechnungsabgrenzung, kurzfristige RÃckstellungen','H','21000','L','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21235','RÃckstellungen','A','21230','L','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('24000','FREMDKAPITAL LANGFRISTIG','H','20000','L','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('24256','Gesellschafter','A','24000','L','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('28000','EIGENKAPITAL','H','20000','Q','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('28280','Stammkapital','A','28000','Q','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('28290','Reserven, Bilanzgewinn','H','28000','Q','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('28291','Reserven','A','28290','Q','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('28295','Gewinnvortrag','A','28290','Q','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('28296','Jahresgewinn','A','28290','Q','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('30000','BETRIEBSERTRAG AUS LIEFERUNGEN UND LEISTUNGEN','H','30000','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('31000','PRODUKTIONSERTRAG','H','30000','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('31001','Computer','A','31000','I','AR_amount:IC_sale');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('31005','Ãbrige Produkte','A','31000','I','AR_amount:IC_sale');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('32000','HANDELSERTRAG','H','30000','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('32001','Hardware','A','32000','I','AR_amount:IC_sale');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('32002','Software OSS','A','32000','I','AR_amount:IC_sale');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('32003','Software kommerz.','A','32000','I','AR_amount:IC_sale');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('32005','Ãbrige','A','32000','I','AR_amount:IC_sale');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('34000','DIENSTLEISTUNGSERTRAG','H','30000','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('34001','Beratung','A','34000','I','AR_amount:IC_income');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('34002','Installation','A','34000','I','AR_amount:IC_income');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('36000','ÃBRIGER ERTRAG','H','30000','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('37000','EIGENLEISTUNGEN UND EIGENVERBRAUCH','H','30000','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('37001','Eigenleistungen','A','37000','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('37002','Eigenverbrauch','A','37000','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('38000','BESTANDESÃNDERUNGEN ANGEFANGENE UND FERTIGGESTELLTE ARBEITUNG AUS PRODUKTION UND DIENSTLEISTUNG','H','30000','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('38001','BestandesÃnderungen','A','38000','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('39000','ERTRAGSMINDERUNGEN AUS PRODUKTIONS-, HANDELS- UND DIENSTLEISTUNGSERTRÃGEN','H','30000','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('40000','AUFWAND FÃR MATERIAL, WAREN UND DIENSTLEISTUNGEN','H','40000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('41000','MATERIALAUFWAND','H','40000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('41001','Computer','A','41000','E','AP_amount:IC_cogs');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('41005','Ãbrige Produkte','A','41000','E','AP_amount:IC_cogs');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('42000','HANDELSWARENAUFWAND','H','40000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('42001','Hardware','A','42000','E','AP_amount:IC_cogs');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('42002','Software OSS','A','32000','I','AP_amount:IC_cogs');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('42003','Software kommerz.','A','42000','I','AP_amount:IC_cogs');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('42005','Ãbrige','A','42000','E','AP_amount:IC_cogs');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('44000','AUFWAND FÃR DRITTLEISTUNGEN','H','40000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('46000','ÃBRIGER AUFWAND','H','40000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('47000','DIREKTE EINKAUFSSPESEN','H','40000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('47001','Einkaufsspesen','A','47000','E','AP_amount:IC_expense');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('48000','BESTANDESVERÃNDERUNGEN, MATERIAL- UND WARENVERLUSTE','H','40000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('48001','BestandesÃnderungen','A','48000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('49000','AUFWANDMINDERUNGEN','H','40000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('49005','Aufwandminderungen','A','49000','E','AP_amount:IC_expense');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('50000','PERSONALAUFWAND','H','50000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('57000','SOZIALVERSICHERUNGSAUFWAND','H','50000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('58000','ÃBRIGER PERSONALAUFWAND','H','58000','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('58005','Sonstiger Personalaufwand','A','58000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('59000','ARBEITSLEISTUNGEN DRITTER','H','50000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('60000','SONSTIGER BETRIEBSAUFWAND','H','60000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('61000','RAUMAUFWAND','H','60000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('61900','UNTERHALT, REPARATUREN, ERSATZ, LEASINGAUFWAND MOBILE SACHANLAGEN','H','60000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('61901','Unterhalt','A','61900','E','AP_amount');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('62000','FAHRZEUG- UND TRANSPORTAUFWAND','H','60000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('62002','Transportaufwand','A','62000','E','AP_amount');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('63000','SACHVERSICHERUNGEN, ABGABEN, GEBÃHREN, BEWILLIGUNGEN','H','60000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('65000','VERWALTUNGS- UND INFORMATIKAUFWAND','H','60000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('66000','WERBEAUFWAND','H','60000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('67000','ÃBRIGER BETRIEBSAUFWAND','H','60000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('67001','Ãbriger Betriebsaufwand','A','67000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('68000','FINANZERFOLG','H','60000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('68001','Finanzaufwand','A','68000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('68002','Bankspesen','A','68000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('68005','Finanzertrag','A','68000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('69000','ABSCHREIBUNGEN','H','60000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('69001','Abschreibungen','A','69000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('80000','AUSSERORDENTLICHER UND BETRIEBSFREMDER ERFOLG, STEUERN','H','80000','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('80001','Ausserordentlicher Ertrag','A','80000','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('80002','Ausserordentlicher Aufwand','A','80000','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('89000','STEUERAUFWAND','H','80000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('89001','Steuern','A','80000','E','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('90000','ABSCHLUSS','H','90000','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('91000','ERFOLGSRECHNUNG','H','91000','I','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('92000','BILANZ','H','92000','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('93000','GEWINNVERWENDUNG','H','93000','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('99000','SAMMEL- UND FEHLBUCHUNGEN','H','99000','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11121','WarenvorrÃte','A','11120','A','IC');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('44001','Aufwand fÃr Drittleistungen','A','44000','E','AP_amount:IC_expense');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('63001','Betriebsversicherungen','A','63000','E','AP_amount:IC_expense');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('57004','Unfallversicherung','A','57000','E','AP_amount:IC_expense');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('57005','Krankentaggeldversicherung','A','57000','E','AP_amount:IC_expense');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('57003','Berufliche Vorsorge','A','57000','E','AP_amount:IC_expense');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('57002','FAK','A','57000','E','AP_amount:IC_income:IC_expense');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('65009','Ãbriger Verwaltungsaufwand','A','65000','E','AP_amount:IC_expense');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('65003','Porti','A','65000','E','AP_amount:IC_expense');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('65002','Telekomm','A','65000','E','AP_amount:IC_expense');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('65001','BÃromaterial','A','65000','E','AP_amount:IC_expense');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('18181','GrÃndungsaufwand','A','18000','A','IC_expense');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('50001','LÃhne und GehÃlter','A','50000','E','IC_expense');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('50002','Erfolgsbeteiligungen','A','50000','E','IC_expense');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21216','Gesellschafter','A','21210','L','AP');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('62001','Fahrzeugaufwand','A','62000','E','AP_amount:IC_expense');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('58003','Spesen','A','58000','E','IC_expense');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('65004','Fachliteratur','A','65000','E','AP_amount:IC_expense');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('39001','Skonti','A','39000','I','IC_sale:IC_cogs:IC_income:IC_expense');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('39002','Rabatte, PreisnachlÃsse','A','39000','I','IC_sale:IC_cogs:IC_income:IC_expense');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('36005','Kursgewinn','A','39000','I','IC_sale:IC_cogs:IC_income');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('39006','Kursverlust','A','39000','E','IC_sale:IC_cogs:IC_expense');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('39005','Verluste aus Forderungen','A','39000','E','IC_sale:IC_cogs:IC_expense');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('14151','Mobiliar und Einrichtungen','A','14150','A','IC');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('14152','BÃromaschinen, EDV','A','14150','A','IC');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11119','Verrechnungssteuer','A','11110','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11118','MWST Vorsteuer auf Investitionen','A','11110','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('36004','Versand','A','36000','I','IC_income');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('36001','Reisezeit','A','36000','I','IC_income');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('36002','Reise (Fahrt)','A','36000','I','IC_income');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11117','MWST Vorsteuer auf Aufwand','A','11110','A','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21228','Geschuldete Steuern','A','21220','L','AP');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21223','MWST (7,6)','A','21220','L','AR_tax:AP_tax:IC_taxpart:IC_expense:IC_taxservice');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('57001','AHV, IV, EO, ALV','A','57000','E','AP_amount:IC_income:IC_expense');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21221','MWST (2,4)','A','21220','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21224','MWST (7.6) 1/2','A','21220','L','AR_tax:AP_tax:IC_taxpart:IC_expense:IC_taxservice');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('66001','Werbeaufwand','A','66000','E','AP_amount:IC_expense');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21217','Privat','A','21210','L','AP');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11101','Kasse','A','11100','A','AR_paid:AP_paid');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('50005','Leistungen von Sozialversicherung','A','50000','E','AP_amount:IC_income:IC_expense');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('65005','Informatikaufwand','A','65000','E','AP_amount:IC_expense');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('39004','Rundungsdifferenzen','A','39000','I','AR_paid:AP_paid');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11111','Debitoren','A','11110','A','AR');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('61001','Miete','A','61000','E','IC_expense');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('61002','Reinigung','A','61000','E','IC_expense');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('61005','Ãbriger Raumaufwand','A','61000','E','IC_expense');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('36003','Essen','A','36000','I','IC_income');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21231','Passive Rechnungsabgrenzung','A','21230','L','');
-INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('67002','Produkteentwicklung','A','67000','E','');
+SELECT account_heading_save(NULL, '10000', 'AKTIVEN', NULL);
+SELECT account_heading_save(NULL, '11000', 'UMLAUFSVERMÃGEN', NULL);
+SELECT account_heading_save(NULL, '11100', 'FlÃssige Mittel', NULL);
+SELECT account_save(NULL,'11102','Bank CS Kt. 177929-11','A','11100', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_heading_save(NULL, '11110', 'Forderungen', NULL);
+SELECT account_heading_save(NULL, '11120', 'VorrÃte und angefangene Arbeiten', NULL);
+SELECT account_save(NULL,'11128','Angefangene Arbeiten','A','11120', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'11130','Aktive Rechnungsabgrenzung','A','11000', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '14000', 'ANLAGEVERMÃGEN', NULL);
+SELECT account_heading_save(NULL, '18000', 'AKTIVIERTER AUFWAND UND AKTIVE BERICHTIGUNGSPOSTEN', NULL);
+SELECT account_save(NULL,'18182','Entwicklungsaufwand','A','18000', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '20000', 'PASSIVEN', NULL);
+SELECT account_heading_save(NULL, '21000', 'FREMDKAPITAL KURZFRISTIG', NULL);
+SELECT account_heading_save(NULL, '21200', 'Kurzfristige Verbindlichkeiten aus Lieferungen und Leistungen', NULL);
+SELECT account_save(NULL,'21201','Lieferanten','L','21200', NULL, false,string_to_array('AP', ':'));
+SELECT account_save(NULL,'21202','Personalaufwand','L','21200', NULL, false,string_to_array('AP', ':'));
+SELECT account_save(NULL,'21203','Sozialversicherungen','L','21200', NULL, false,string_to_array('AP', ':'));
+SELECT account_save(NULL,'21205','Leasing','L','21200', NULL, false,string_to_array('AP', ':'));
+SELECT account_heading_save(NULL, '21210', 'Kurzfristige Finanzverbindlichkeiten', NULL);
+SELECT account_heading_save(NULL, '21220', 'Andere kurzfristige Verbindlichkeiten', NULL);
+SELECT account_save(NULL,'21222','MWST (3,6)','L','21220', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'21229','GewinnausschÃttung','L','21220', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '21230', 'Passive Rechnungsabgrenzung, kurzfristige RÃckstellungen', NULL);
+SELECT account_save(NULL,'21235','RÃckstellungen','L','21230', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '24000', 'FREMDKAPITAL LANGFRISTIG', NULL);
+SELECT account_save(NULL,'24256','Gesellschafter','L','24000', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '28000', 'EIGENKAPITAL', NULL);
+SELECT account_save(NULL,'28280','Stammkapital','Q','28000', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '28290', 'Reserven, Bilanzgewinn', NULL);
+SELECT account_save(NULL,'28291','Reserven','Q','28290', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'28295','Gewinnvortrag','Q','28290', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'28296','Jahresgewinn','Q','28290', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '30000', 'BETRIEBSERTRAG AUS LIEFERUNGEN UND LEISTUNGEN', NULL);
+SELECT account_heading_save(NULL, '31000', 'PRODUKTIONSERTRAG', NULL);
+SELECT account_save(NULL,'31001','Computer','I','31000', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
+SELECT account_save(NULL,'31005','Ãbrige Produkte','I','31000', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
+SELECT account_heading_save(NULL, '32000', 'HANDELSERTRAG', NULL);
+SELECT account_save(NULL,'32001','Hardware','I','32000', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
+SELECT account_save(NULL,'32002','Software OSS','I','32000', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
+SELECT account_save(NULL,'32003','Software kommerz.','I','32000', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
+SELECT account_save(NULL,'32005','Ãbrige','I','32000', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
+SELECT account_heading_save(NULL, '34000', 'DIENSTLEISTUNGSERTRAG', NULL);
+SELECT account_save(NULL,'34001','Beratung','I','34000', NULL, false,string_to_array('AR_amount:IC_income', ':'));
+SELECT account_save(NULL,'34002','Installation','I','34000', NULL, false,string_to_array('AR_amount:IC_income', ':'));
+SELECT account_heading_save(NULL, '36000', 'ÃBRIGER ERTRAG', NULL);
+SELECT account_heading_save(NULL, '37000', 'EIGENLEISTUNGEN UND EIGENVERBRAUCH', NULL);
+SELECT account_save(NULL,'37001','Eigenleistungen','I','37000', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'37002','Eigenverbrauch','I','37000', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '38000', 'BESTANDESÃNDERUNGEN ANGEFANGENE UND FERTIGGESTELLTE ARBEITUNG AUS PRODUKTION UND DIENSTLEISTUNG', NULL);
+SELECT account_save(NULL,'38001','BestandesÃnderungen','I','38000', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '39000', 'ERTRAGSMINDERUNGEN AUS PRODUKTIONS-, HANDELS- UND DIENSTLEISTUNGSERTRÃGEN', NULL);
+SELECT account_heading_save(NULL, '40000', 'AUFWAND FÃR MATERIAL, WAREN UND DIENSTLEISTUNGEN', NULL);
+SELECT account_heading_save(NULL, '41000', 'MATERIALAUFWAND', NULL);
+SELECT account_save(NULL,'41001','Computer','E','41000', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
+SELECT account_save(NULL,'41005','Ãbrige Produkte','E','41000', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
+SELECT account_heading_save(NULL, '42000', 'HANDELSWARENAUFWAND', NULL);
+SELECT account_save(NULL,'42001','Hardware','E','42000', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
+SELECT account_save(NULL,'42002','Software OSS','I','32000', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
+SELECT account_save(NULL,'42003','Software kommerz.','I','42000', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
+SELECT account_save(NULL,'42005','Ãbrige','E','42000', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
+SELECT account_heading_save(NULL, '44000', 'AUFWAND FÃR DRITTLEISTUNGEN', NULL);
+SELECT account_heading_save(NULL, '46000', 'ÃBRIGER AUFWAND', NULL);
+SELECT account_heading_save(NULL, '47000', 'DIREKTE EINKAUFSSPESEN', NULL);
+SELECT account_save(NULL,'47001','Einkaufsspesen','E','47000', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_heading_save(NULL, '48000', 'BESTANDESVERÃNDERUNGEN, MATERIAL- UND WARENVERLUSTE', NULL);
+SELECT account_save(NULL,'48001','BestandesÃnderungen','E','48000', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '49000', 'AUFWANDMINDERUNGEN', NULL);
+SELECT account_save(NULL,'49005','Aufwandminderungen','E','49000', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_heading_save(NULL, '50000', 'PERSONALAUFWAND', NULL);
+SELECT account_heading_save(NULL, '57000', 'SOZIALVERSICHERUNGSAUFWAND', NULL);
+SELECT account_heading_save(NULL, '58000', 'ÃBRIGER PERSONALAUFWAND', NULL);
+SELECT account_save(NULL,'58005','Sonstiger Personalaufwand','E','58000', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '59000', 'ARBEITSLEISTUNGEN DRITTER', NULL);
+SELECT account_heading_save(NULL, '60000', 'SONSTIGER BETRIEBSAUFWAND', NULL);
+SELECT account_heading_save(NULL, '61000', 'RAUMAUFWAND', NULL);
+SELECT account_heading_save(NULL, '61900', 'UNTERHALT, REPARATUREN, ERSATZ, LEASINGAUFWAND MOBILE SACHANLAGEN', NULL);
+SELECT account_save(NULL,'61901','Unterhalt','E','61900', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_heading_save(NULL, '62000', 'FAHRZEUG- UND TRANSPORTAUFWAND', NULL);
+SELECT account_save(NULL,'62002','Transportaufwand','E','62000', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_heading_save(NULL, '63000', 'SACHVERSICHERUNGEN, ABGABEN, GEBÃHREN, BEWILLIGUNGEN', NULL);
+SELECT account_heading_save(NULL, '65000', 'VERWALTUNGS- UND INFORMATIKAUFWAND', NULL);
+SELECT account_heading_save(NULL, '66000', 'WERBEAUFWAND', NULL);
+SELECT account_heading_save(NULL, '67000', 'ÃBRIGER BETRIEBSAUFWAND', NULL);
+SELECT account_save(NULL,'67001','Ãbriger Betriebsaufwand','E','67000', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '68000', 'FINANZERFOLG', NULL);
+SELECT account_save(NULL,'68001','Finanzaufwand','E','68000', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'68002','Bankspesen','E','68000', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'68005','Finanzertrag','E','68000', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '69000', 'ABSCHREIBUNGEN', NULL);
+SELECT account_save(NULL,'69001','Abschreibungen','E','69000', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '80000', 'AUSSERORDENTLICHER UND BETRIEBSFREMDER ERFOLG, STEUERN', NULL);
+SELECT account_save(NULL,'80001','Ausserordentlicher Ertrag','I','80000', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'80002','Ausserordentlicher Aufwand','I','80000', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '89000', 'STEUERAUFWAND', NULL);
+SELECT account_save(NULL,'89001','Steuern','E','80000', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '90000', 'ABSCHLUSS', NULL);
+SELECT account_heading_save(NULL, '91000', 'ERFOLGSRECHNUNG', NULL);
+SELECT account_heading_save(NULL, '92000', 'BILANZ', NULL);
+SELECT account_heading_save(NULL, '93000', 'GEWINNVERWENDUNG', NULL);
+SELECT account_heading_save(NULL, '99000', 'SAMMEL- UND FEHLBUCHUNGEN', NULL);
+SELECT account_save(NULL,'11121','WarenvorrÃte','A','11120', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'44001','Aufwand fÃr Drittleistungen','E','44000', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'63001','Betriebsversicherungen','E','63000', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'57004','Unfallversicherung','E','57000', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'57005','Krankentaggeldversicherung','E','57000', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'57003','Berufliche Vorsorge','E','57000', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'57002','FAK','E','57000', NULL, false,string_to_array('AP_amount:IC_income:IC_expense', ':'));
+SELECT account_save(NULL,'65009','Ãbriger Verwaltungsaufwand','E','65000', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'65003','Porti','E','65000', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'65002','Telekomm','E','65000', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'65001','BÃromaterial','E','65000', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'18181','GrÃndungsaufwand','A','18000', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'50001','LÃhne und GehÃlter','E','50000', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'50002','Erfolgsbeteiligungen','E','50000', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'21216','Gesellschafter','L','21210', NULL, false,string_to_array('AP', ':'));
+SELECT account_save(NULL,'62001','Fahrzeugaufwand','E','62000', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'58003','Spesen','E','58000', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'65004','Fachliteratur','E','65000', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'39001','Skonti','I','39000', NULL, false,string_to_array('IC_sale:IC_cogs:IC_income:IC_expense', ':'));
+SELECT account_save(NULL,'39002','Rabatte, PreisnachlÃsse','I','39000', NULL, false,string_to_array('IC_sale:IC_cogs:IC_income:IC_expense', ':'));
+SELECT account_save(NULL,'36005','Kursgewinn','I','39000', NULL, false,string_to_array('IC_sale:IC_cogs:IC_income', ':'));
+SELECT account_save(NULL,'39006','Kursverlust','E','39000', NULL, false,string_to_array('IC_sale:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'39005','Verluste aus Forderungen','E','39000', NULL, false,string_to_array('IC_sale:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'14151','Mobiliar und Einrichtungen','A','14150', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'14152','BÃromaschinen, EDV','A','14150', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'11119','Verrechnungssteuer','A','11110', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'11118','MWST Vorsteuer auf Investitionen','A','11110', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'36004','Versand','I','36000', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'36001','Reisezeit','I','36000', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'36002','Reise (Fahrt)','I','36000', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'11117','MWST Vorsteuer auf Aufwand','A','11110', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'21228','Geschuldete Steuern','L','21220', NULL, false,string_to_array('AP', ':'));
+SELECT account_save(NULL,'21223','MWST (7,6)','L','21220', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_expense:IC_taxservice', ':'));
+SELECT account_save(NULL,'57001','AHV, IV, EO, ALV','E','57000', NULL, false,string_to_array('AP_amount:IC_income:IC_expense', ':'));
+SELECT account_save(NULL,'21221','MWST (2,4)','L','21220', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'21224','MWST (7.6) 1/2','L','21220', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_expense:IC_taxservice', ':'));
+SELECT account_save(NULL,'66001','Werbeaufwand','E','66000', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'21217','Privat','L','21210', NULL, false,string_to_array('AP', ':'));
+SELECT account_save(NULL,'11101','Kasse','A','11100', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'50005','Leistungen von Sozialversicherung','E','50000', NULL, false,string_to_array('AP_amount:IC_income:IC_expense', ':'));
+SELECT account_save(NULL,'65005','Informatikaufwand','E','65000', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'39004','Rundungsdifferenzen','I','39000', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'11111','Debitoren','A','11110', NULL, false,string_to_array('AR', ':'));
+SELECT account_save(NULL,'61001','Miete','E','61000', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'61002','Reinigung','E','61000', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'61005','Ãbriger Raumaufwand','E','61000', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'36003','Essen','I','36000', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'21231','Passive Rechnungsabgrenzung','L','21230', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'67002','Produkteentwicklung','E','67000', NULL, false,string_to_array('', ':'));
--
insert into tax (chart_id,rate) values ((select id from chart where accno = '21222'),0.036);
insert into tax (chart_id,rate) values ((select id from chart where accno = '21223'),0.076);
Modified: trunk/sql/coa/co/chart/PUC.sql
===================================================================
--- trunk/sql/coa/co/chart/PUC.sql 2009-06-12 01:38:06 UTC (rev 2643)
+++ trunk/sql/coa/co/chart/PUC.sql 2009-06-12 01:39:22 UTC (rev 2644)
@@ -6,738 +6,738 @@
-- Si quieres aportar: Contactenos www.caribenet.com - ..hidden..
--
-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');
@@ Diff output truncated at 100000 characters. @@
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.