[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb: [851] trunk/sql

Subject: SF.net SVN: ledger-smb: [851] trunk/sql
From: ..hidden..
Date: Mon, 05 Mar 2007 19:32:21 -0800
Revision: 851
          http://svn.sourceforge.net/ledger-smb/?rev=851&view=rev
Author:   einhverfr
Date:     2007-03-05 19:32:20 -0800 (Mon, 05 Mar 2007)

Log Message:
-----------
Second installment of re-organized coa files

Added Paths:
-----------
    trunk/sql/coa/Sample-chart.sql
    trunk/sql/coa/at/
    trunk/sql/coa/at/chart/
    trunk/sql/coa/at/chart/General.sql
    trunk/sql/coa/at/gifi/
    trunk/sql/coa/at/gifi/General.sql
    trunk/sql/coa/be/
    trunk/sql/coa/be/chart/
    trunk/sql/coa/be/chart/General.sql
    trunk/sql/coa/be/gifi/
    trunk/sql/coa/be/gifi/General.sql
    trunk/sql/coa/br/
    trunk/sql/coa/br/chart/
    trunk/sql/coa/br/chart/General.sql
    trunk/sql/coa/cz/
    trunk/sql/coa/cz/chart/
    trunk/sql/coa/cz/chart/General.sql
    trunk/sql/coa/dk/
    trunk/sql/coa/dk/General.sql
    trunk/sql/coa/dk/chart/
    trunk/sql/coa/eg/
    trunk/sql/coa/eg/chart/
    trunk/sql/coa/eg/chart/General.sql
    trunk/sql/coa/fr/
    trunk/sql/coa/fr/chart/
    trunk/sql/coa/fr/chart/General.sql
    trunk/sql/coa/hu/
    trunk/sql/coa/hu/chart/
    trunk/sql/coa/hu/chart/General.sql
    trunk/sql/coa/hu/gifi/
    trunk/sql/coa/hu/gifi/General.sql
    trunk/sql/coa/id/
    trunk/sql/coa/id/chart/
    trunk/sql/coa/id/chart/General.sql
    trunk/sql/coa/nl/
    trunk/sql/coa/nl/chart/
    trunk/sql/coa/nl/chart/General.sql
    trunk/sql/coa/nl/chart/Simple.sql
    trunk/sql/coa/us/chart/UCOA-Form990.sql
    trunk/sql/coa/us/chart/UCOA-Form990EZ.sql
    trunk/sql/coa/us/gifi/UCOA-Form990.sql
    trunk/sql/coa/us/gifi/UCOA-Form990EZ.sql
    trunk/sql/legacy/NAICS-1997.sql

Removed Paths:
-------------
    trunk/sql/Austria-chart.sql
    trunk/sql/Austria-gifi.sql
    trunk/sql/Bahasa-Indonesia_Default-chart.sql
    trunk/sql/Belgium-chart.sql
    trunk/sql/Belgium-gifi.sql
    trunk/sql/Brazil_General-chart.sql
    trunk/sql/Czech-Republic-chart.sql
    trunk/sql/Danish_Default-chart.sql
    trunk/sql/Default-chart.sql
    trunk/sql/Dutch_Default-chart.sql
    trunk/sql/Dutch_Standard-chart.sql
    trunk/sql/Egypt-chart.sql
    trunk/sql/France-chart.sql
    trunk/sql/Hungary-chart.sql
    trunk/sql/Hungary-gifi.sql
    trunk/sql/NAICS.sql
    trunk/sql/UCOA-Form990-gifi.sql
    trunk/sql/UCOA-Form990EZ-chart.sql
    trunk/sql/UCOA-Form990EZ-gifi.sql
    trunk/sql/coa/us/UCOA-Form990.sql

Deleted: trunk/sql/Austria-chart.sql
===================================================================
--- trunk/sql/Austria-chart.sql	2007-03-06 02:48:38 UTC (rev 850)
+++ trunk/sql/Austria-chart.sql	2007-03-06 03:32:20 UTC (rev 851)
@@ -1,156 +0,0 @@
-begin;
--- Kontoplan fÃr Ãsterreich
--- Ferdinand Gassauer, Tue, 5 Feb 2002
--- checked and completed, Thu, 7 Feb 2002, Dieter Simader
---
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0000','AUFWENDUNGEN FÃR INGANGSETZEN UND ERWEITERN DES BETRIEBES','H','00','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0010','Firmenwert','A','015','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0100','IMMATERIELLE VERMÃGENSGEGENSTÃNDE','H','01','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0110','Rechte','A','011','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0200','GRUNDSTÃCKE','H','02-03','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0210','unbebaute GrundstÃcke','A','020','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0220','bebaute GrundstÃcke','A','021','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('0229','kum. Abschreibung bebaute GrundstÃcke','A','039','A','','1');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0400','MASCHINEN','H','04-05','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0410','Maschinen','A','041','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('0419','kum. Abschreibung Maschinen','A','069','A','','1');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0500','FAHRZEUGE','H','06','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0510','Fahrzeuge','A','063','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('0519','kum. Abschreibung Fahrzeuge','A','069','A','','1');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0600','BETRIEBS- UND GESCHÃFTSAUSSTATTUNG','H','06','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0620','BÃroeinrichtungen','A','066','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('0625','kum. Abschreibung Betriebs- und GeschÃftsausstattung','A','069','A','','1');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0700','GELEISTETE ANZAHLUNGEN','H','07','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0800','FINANZANLAGEN','H','08-09','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0810','Beteiligungen','A','081','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0820','Wertpapiere','A','080','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1100','ROHSTOFFE','H','1','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1120','VorrÃte - Rohstoffe','A','110-119','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1200','BEZOGENE TEILE','H','1','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1220','VorrÃte - bezogene Teile','A','120-129','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1300','HILFS- UND BETRIEBSSTOFFE','H','1','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1320','Hilfsstoffe','A','130-134','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1350','Betriebssstoffe','A','135-139','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1400','UNFERTIGE ERZEUGNISSE','H','1','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1420','VorrÃte - unfertige Erzeugnisse','A','140-149','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1500','FERTIGE ERZEUGNISSE','H','1','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1520','VorrÃte - Hardware','A','150-159','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1530','VorrÃte - Software','A','150-159','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1540','VorrÃte - Ersatzteile','A','150-159','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1600','WAREN','H','1','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1700','NOCH NICHT ABGERECHNETE LEISTUNGEN','H','1','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1800','GELEISTETE ANZAHLUNGEN','H','1','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1900','WERTBERICHTIGUNGEN','H','1','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2000','FORDEUNGEN AUS LIEFERUNGEN UND LEISTUNGEN','H','2','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2010','Forderungen Lieferung & Leistung','A','200-207','A','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2019','Wertberichtigung uneinbringliche Forderungen','A','20-21','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2300','SONSTIGE FORDERUNGEN','H','2','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2320','sonstige Forderungen','A','23-24','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2500','FORDERUNGEN AUS ABGABENVERRECHNUNG','H','2','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2520','sonstige Forderungen aus Abgebenverrechnung','A','25','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2600','WERTPAPIERE UND ANTEILE','H','2','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2620','Wertpapiere UmlaufvermÃgen','A','26','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2700','KASSABESTAND','H','2','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2701','Kassa','A','27-28','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2800','SCHECKS, GUTHABEN BEI KREDITINSTITUTEN','H','2','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2810','Schecks','A','27-28','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2820','Bankguthaben','A','280-288','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3100','LANGFRISTIGE VERBINDLICHKEITEN','H','3','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3110','Bank Verbindlichkeiten','A','31','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3120','Kredite von EigentÃmern','A','310','L','AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3300','VERBINDLICHKEITEN AUS LIEFERUNGEN UND LEISTUNGEN','H','33','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3310','Verbindlichkeiten aus Lieferungen und Leistungen','A','330-335','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3500','VERBINDLICHKEITEN FINANZAMT','H','35','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3510','Finanzamt Verrechnung KÃrperschaftssteuer','A','350-359','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3520','Finanzamt Verrechnung Umsatzsteuer','A','350-359','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3530','Mehrwertsteuer 0%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3531','Mehrwertsteuer 10%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3532','Mehrwertsteuer 20%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3540','Vorsteuer 0%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3541','Vorsteuer 10%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3542','Vorsteuer 20%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4000','UMSATZ','H','4','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4020','Verkauf - Hardware','A','40-44','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4030','Verkauf - Software ','A','40-44','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4040','Verkauf - Ersatzteile','A','40-44','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4300','UMSATZ BERATUNG','H','4','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4320','ErlÃse Beratung','A','40-44','I','AR_amount:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4330','ErlÃse Programmierung','A','40-44','I','AR_amount:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4600','SONSTIGE ERLÃSE','H','4','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4630','FrachterlÃse','A','46-49','I','IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5000','WARENEINSATZ','H','5','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5020','Wareneinsatz / Hardware','A','500-509','E','AP_amount:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5030','Wareneinsatz / Software','A','500-509','E','AP_amount:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5040','Wareneinsatz / Ersatzteile','A','520-529','E','AP_amount:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5600','VERBRAUCH BRENN- UND TREIBSTOFFEN, ENERGIE UND WASSER','H','5','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5610','Energie, Wasser','A','560-569','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6000','LOHNAUFWAND','H','6','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6010','Lohn ','A','600-619','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6200','GEAHLTSAUFWAND','H','6','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6210','Gehalt ','A','620-639','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6500','GESETZLICHER SOZIALAUFWAND','H','6','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6510','Dienstgeberanteile','A','645-649','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6700','FREIWILLIGER SOZIALAUFWAND','H','6','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6710','freiwilliger Sozialaufwand','A','660-665','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7000','ABSCHREIBUNGEN','H','7','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7010','Abschreibungen','A','700','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7020','geringwertige WirtschaftsgÃter','A','701-708','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7100','SONSTIGE STEUERN','H','71','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7110','Ertragssteuern','A','710-719','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7120','Grundsteuern','A','710-719','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7200','INSTANDHALTUNGSAUFWAND','H','7','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7210','Reparatur und Instandhaltung','A','720-729','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7300','TRANSPORTKOSTEN','H','73','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7310','Frachtaufwand','A','730-731','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7400','MIET-,PACHT-,LEASING-, LIZENZAUFWAND','H','74','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7410','Miete','A','740-743','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7411','Lizenzen','A','748-749','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7600','VERWALTUNGSKOSTEN','H','76','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7610','Beratungsaufwand','A','775-776','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7611','BÃromaterialien','A','760','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7615','Werbung und Marketing','A','765-768','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7620','uneinbringliche Forderungen','A','799','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7630','Telephonkosten','A','738-739','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7631','Internetkosten','A','738-739','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7632','Reise- und ReprÃsentationsaufwand','A','734-735','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7634','RegistrierungsgebÃhren','A','748-749','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7700','VERSICHERUNGEN','H','77-78','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7710','Versicherung','A','770-774','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8000','FINANZERTRÃGE UND FINANZAUFWENDUNGEN','H','8','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8020','Bankzinsen und GebÃhren','A','80-83','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8100','BETEILIGUNGSERTRÃGE','H','8','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8110','ErtrÃge aus Beteiligungen','A','800-804','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9000','KAPITAL','H','9','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9010','Aktien, GeschÃftsanteile','A','900-918','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9020','nicht einbezahltes Kapital','A','919','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9200','KAPITALRÃCKLAGEN','H','9','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9210','freie RÃcklage','A','920-929','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9300','GEWINN','H','939','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9310','Gewinnvortrag Vorjahr','A','980','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9320','Jahresgewinn','A','985','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9400','RÃCKSTELLUNGEN','H','3','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9420','AbfertigungsrÃckstellung','A','300','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9430','UrlaubsrÃckstellung','A','304-309','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9700','EINLAGEN STILLER GESELLSCHAFTER','H','9','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9800','EB,SB,G+V KONTEN','H','9','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4640','Devisengewinne','A','80-83','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8050','Devisenverluste','A','80-83','E','');
---
-insert into tax (chart_id,rate) values ((select id from chart where accno = '3530'),0.00);
-insert into tax (chart_id,rate) values ((select id from chart where accno = '3531'),0.10);
-insert into tax (chart_id,rate) values ((select id from chart where accno = '3532'),0.20);
---
-INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520')); 
-INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4020'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '7610'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '4640'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '8050'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('curr', 'EUR:USD');
-
- INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
---
-commit;

Deleted: trunk/sql/Austria-gifi.sql
===================================================================
--- trunk/sql/Austria-gifi.sql	2007-03-06 02:48:38 UTC (rev 850)
+++ trunk/sql/Austria-gifi.sql	2007-03-06 03:32:20 UTC (rev 851)
@@ -1,336 +0,0 @@
-begin;
--- Ãsterreichischer Einheitskontenrahmen / Kontenplan (ÃSV Ãsterreichischer Steuerverein)
---
-INSERT INTO gifi (accno, description) VALUES ('0', 'AnlagevermÃgen und Aufwendungen fÃr das Ingangsetzen und Erweitern eines Betriebes');
---
-INSERT INTO gifi (accno, description) VALUES ('00', 'Aufwendungen fÃr das Ingangsetzen und Erweitern eines Betriebes');
-INSERT INTO gifi (accno, description) VALUES ('001', 'Aufwendungen fÃr das Ingangsetzen und Erweitern eines Betriebes');
-INSERT INTO gifi (accno, description) VALUES ('009', 'Kumulierte Abschreibungen');
---
-INSERT INTO gifi (accno, description) VALUES ('01', 'Immaterielle VermÃgensgegenstÃnde');
-INSERT INTO gifi (accno, description) VALUES ('010', 'Konzessionen');
-INSERT INTO gifi (accno, description) VALUES ('011', 'Patentrechte und Lizenzen');
-INSERT INTO gifi (accno, description) VALUES ('012', 'Datenverarbeitungsprogramme');
-INSERT INTO gifi (accno, description) VALUES ('013', 'Marken, Warenzeichen und Musterschutzrechte, sonstige Urheberrechte');
-INSERT INTO gifi (accno, description) VALUES ('014', 'Pacht- und Mietrechte');
-INSERT INTO gifi (accno, description) VALUES ('015', 'GeschÃfts(Firmen)wert');
-INSERT INTO gifi (accno, description) VALUES ('018', 'Geleistete Anzahlungen');
-INSERT INTO gifi (accno, description) VALUES ('019', 'Kumulierte Abschreibungen');
---
-INSERT INTO gifi (accno, description) VALUES ('02-03', 'GrundstÃcke, grundstÃcksgleiche Rechte und Bauten, einschlieÃlich der Bauten auf fremden Grund');
-INSERT INTO gifi (accno, description) VALUES ('020', 'Unbebaute GrundstÃcke');
-INSERT INTO gifi (accno, description) VALUES ('021', 'Bebaute GrundstÃcke (Grundwert)');
-INSERT INTO gifi (accno, description) VALUES ('022', 'GrundstÃcksgleiche Rechte');
-INSERT INTO gifi (accno, description) VALUES ('030', 'Betriebs- und GeschÃftsgebÃude auf eigenem Grund');
-INSERT INTO gifi (accno, description) VALUES ('031', 'Wohn- und SozialgebÃude auf eigenem Grund');
-INSERT INTO gifi (accno, description) VALUES ('032', 'Betriebs- und GeschÃftsgebÃude auf fremdem Grund');
-INSERT INTO gifi (accno, description) VALUES ('033', 'Wohn- und SozialgebÃude auf fremdem Grund');
-INSERT INTO gifi (accno, description) VALUES ('034', 'GrundstÃckseinrichtungen auf eigenem Grund');
-INSERT INTO gifi (accno, description) VALUES ('035', 'GrundstÃckseinrichtungen auf fremdem Grund');
-INSERT INTO gifi (accno, description) VALUES ('036', 'Bauliche Investitionen in fremden (gepachteten) Betriebs- und GeschÃftsgebÃuden');
-INSERT INTO gifi (accno, description) VALUES ('037', 'Bauliche Investitionen in fremden (gepachteten) Wohn- und SozialgebÃuden');
-INSERT INTO gifi (accno, description) VALUES ('039', 'Kumulierte Abschreibungen');
---
-INSERT INTO gifi (accno, description) VALUES ('04-05', 'Technische Anlagen und Maschinen');
-INSERT INTO gifi (accno, description) VALUES ('040', 'Fertigungsmaschinen');
-INSERT INTO gifi (accno, description) VALUES ('041', 'Antriebsmaschinen');
-INSERT INTO gifi (accno, description) VALUES ('042', 'Energieversorgungsanlagen');
-INSERT INTO gifi (accno, description) VALUES ('043', 'Transportanlagen');
-INSERT INTO gifi (accno, description) VALUES ('044-049', 'Sonstige Maschinen und maschinelle Anlagen');
-INSERT INTO gifi (accno, description) VALUES ('050', 'Maschinenwerkzeuge');
-INSERT INTO gifi (accno, description) VALUES ('051', 'Allgemeine Werkzeuge und Handwerkzeuge');
-INSERT INTO gifi (accno, description) VALUES ('052', 'Vorrichtungen, Formen und Modelle');
-INSERT INTO gifi (accno, description) VALUES ('053', 'Andere Erzeugungshilfsmittel');
-INSERT INTO gifi (accno, description) VALUES ('054', 'Hebezeuge und Montageanlagen');
-INSERT INTO gifi (accno, description) VALUES ('055', 'Geringwertige VermÃgensgegenstÃnde, soweit im ErzeugungsprozeÃ verwendet');
---
-INSERT INTO gifi (accno, description) VALUES ('06', 'Andere Anlagen, Betriebs- und GeschÃftsausstattung');
-INSERT INTO gifi (accno, description) VALUES ('060', 'Beheizungs- und Beleuchtungsanlagen');
-INSERT INTO gifi (accno, description) VALUES ('061', 'Nachrichten- und Kontrollanlagen');
-INSERT INTO gifi (accno, description) VALUES ('062', 'BÃromaschinen, EDV-Anlagen');
-INSERT INTO gifi (accno, description) VALUES ('063', 'PKW');
-INSERT INTO gifi (accno, description) VALUES ('064', 'LKW');
-INSERT INTO gifi (accno, description) VALUES ('065', 'Andere BefÃrderungsmittel');
-INSERT INTO gifi (accno, description) VALUES ('066', 'Andere Betriebs- und GeschÃftsausstattung');
-INSERT INTO gifi (accno, description) VALUES ('067', 'Gebinde');
-INSERT INTO gifi (accno, description) VALUES ('068', 'Geringwertige VermÃgensgegenstÃnde, soweit nicht im ErzeugungsprozeÃ verwendet');
-INSERT INTO gifi (accno, description) VALUES ('069', 'Kumulierte Abschreibungen');
---
-INSERT INTO gifi (accno, description) VALUES ('07', 'Geleistete Anzahlungen und Anlagen in Bau');
-INSERT INTO gifi (accno, description) VALUES ('070', 'Geleistete Anzahlungen');
-INSERT INTO gifi (accno, description) VALUES ('071', 'Anlagen in Bau');
-INSERT INTO gifi (accno, description) VALUES ('079', 'Kumulierte Abschreibungen');
---
-INSERT INTO gifi (accno, description) VALUES ('08-09', 'Finanzanlagen');
-INSERT INTO gifi (accno, description) VALUES ('080', 'Anteile an verbundenen Unternehmen');
-INSERT INTO gifi (accno, description) VALUES ('081', 'Beteiligungen an Gemeinschaftsunternehmen');
-INSERT INTO gifi (accno, description) VALUES ('082', 'Beteiligungen an angeschlossenen (assoziierten) Unternehmen');
-INSERT INTO gifi (accno, description) VALUES ('083', 'Sonstige Beteiligungen');
-INSERT INTO gifi (accno, description) VALUES ('084', 'Ausleihungen an verbundene Unternehmen');
-INSERT INTO gifi (accno, description) VALUES ('085', 'Ausleihungen an Unternehmen, mit denen ein BeteiligungsverhÃltnis besteht');
-INSERT INTO gifi (accno, description) VALUES ('086', 'Sonstige Ausleihungen');
-INSERT INTO gifi (accno, description) VALUES ('087', 'Anteile an Kapitalgesellschaften ohne Beteiligungscharakter');
-INSERT INTO gifi (accno, description) VALUES ('088', 'Anteile an Personengesellschaften ohne Beteiligungscharakter');
-INSERT INTO gifi (accno, description) VALUES ('090', 'Genossenschaftsanteile ohne Beteiligungscharakter');
-INSERT INTO gifi (accno, description) VALUES ('091', 'Anteile an Investmentfonds');
-INSERT INTO gifi (accno, description) VALUES ('092-093', 'Festverzinsliche Wertpapiere des AnlagevermÃgens');
-INSERT INTO gifi (accno, description) VALUES ('094-097', 'Sonstige Finanzanlagen, Wertrechte');
-INSERT INTO gifi (accno, description) VALUES ('098', 'Geleistete Anzahlungen');
-INSERT INTO gifi (accno, description) VALUES ('099', 'Kumulierte Abschreibungen');
---
-INSERT INTO gifi (accno, description) VALUES ('1', 'VorrÃte');
-INSERT INTO gifi (accno, description) VALUES ('100-109', 'Bezugsverrechnung');
-INSERT INTO gifi (accno, description) VALUES ('110-119', 'Rohstoffe');
-INSERT INTO gifi (accno, description) VALUES ('120-129', 'Bezogene Teile');
-INSERT INTO gifi (accno, description) VALUES ('130-134', 'Hilfsstoffe');
-INSERT INTO gifi (accno, description) VALUES ('135-139', 'Betriebsstoffe');
-INSERT INTO gifi (accno, description) VALUES ('140-149', 'Unfertige Erzeugnisse');
-INSERT INTO gifi (accno, description) VALUES ('150-159', 'Fertige Erzeugnisse');
-INSERT INTO gifi (accno, description) VALUES ('160-169', 'Waren');
-INSERT INTO gifi (accno, description) VALUES ('170-179', 'Noch nicht abrechenbare Leistungen');
-INSERT INTO gifi (accno, description) VALUES ('180', 'Geleistete Anzahlungen');
-INSERT INTO gifi (accno, description) VALUES ('190-199', 'Wertberichtigungen');
---
-INSERT INTO gifi (accno, description) VALUES ('2', 'Sonstiges UmlaufvermÃgen, Rechnungsabgrenzungsposten');
-INSERT INTO gifi (accno, description) VALUES ('20-21', 'Forderungen aus Lieferungen und Leistungen');
-INSERT INTO gifi (accno, description) VALUES ('200-207', 'Forderungen aus Lieferungen und Leistungen Inland');
-INSERT INTO gifi (accno, description) VALUES ('208', 'Einzelwertberichtigungen zu Forderungen aus Lieferungen und Leistungen Inland');
-INSERT INTO gifi (accno, description) VALUES ('209', 'Pauschalwertberichtigungen zu Forderungen aus Lieferungen und Leistungen Inland');
-INSERT INTO gifi (accno, description) VALUES ('210-212', 'Forderungen aus Lieferungen und Leistungen WÃhrungsunion');
-INSERT INTO gifi (accno, description) VALUES ('213', 'Einzelwertberichtigungen zu Forderungen aus Lieferungen und Leistungen WÃhrungsunion');
-INSERT INTO gifi (accno, description) VALUES ('214', 'Pauschalwertberichtigungen zu Forderungen aus Lieferungen und Leistungen WÃhrungsunion');
-INSERT INTO gifi (accno, description) VALUES ('215-217', 'Forderungen aus Lieferungen und Leistungen sonstiges Ausland');
-INSERT INTO gifi (accno, description) VALUES ('218', 'Einzelwertberichtigungen zu Forderungen aus Lieferungen und Leistungen sonstiges Ausland');
-INSERT INTO gifi (accno, description) VALUES ('219', 'Pauschalwertberichtigungen zu Forderungen aus Lieferungen und Leistungen sonstiges Ausland');
---
-INSERT INTO gifi (accno, description) VALUES ('22', 'Forderungen gegenÃber verbundenen Unternehmen und Unternehmen, mit denen ein BeteiligungsverhÃltnis besteht');
-INSERT INTO gifi (accno, description) VALUES ('220-222', 'Forderungen gegenÃber verbundenen Unternehmen');
-INSERT INTO gifi (accno, description) VALUES ('223', 'Einzelwertberichtigungen zu Forderungen gegenÃber verbundenen Unternehmen');
-INSERT INTO gifi (accno, description) VALUES ('224', 'Pauschalwertberichtigungen zu Forderungen gegenÃber verbundenen Unternehmen');
-INSERT INTO gifi (accno, description) VALUES ('225-227', 'Forderungen gegenÃber Unternehmen, mit denen ein BeteiligungsverhÃltnis besteht');
-INSERT INTO gifi (accno, description) VALUES ('228', 'Einzelwertberichtigungen zu Forderungen gegenÃber Unternehmen, mit denen ein BeteiligungsverhÃltnis besteht');
-INSERT INTO gifi (accno, description) VALUES ('229', 'Pauschalwertberichtigungen zu Forderungen gegenÃber Unternehmen, mit denen ein BeteiligungsverhÃltnis besteht');
---
-INSERT INTO gifi (accno, description) VALUES ('23-24', 'Sonstige Forderungen und VermÃgensgegenstÃnde');
-INSERT INTO gifi (accno, description) VALUES ('230-246', 'Sonstige Forderungen und VermÃgensgegenstÃnde');
-INSERT INTO gifi (accno, description) VALUES ('247', 'Eingeforderte, aber noch nicht eingezahlte Einlagen');
-INSERT INTO gifi (accno, description) VALUES ('248', 'Einzelwertberichtigungen zu sonstigen Forderungen und VermÃgensgegenstÃnden');
-INSERT INTO gifi (accno, description) VALUES ('249', 'Pauschalwertberichtigungen zu sonstigen Forderungen und VermÃgensgegenstÃnden');
---
-INSERT INTO gifi (accno, description) VALUES ('25', 'Forderungen aus der Abgabenverrechnung');
-INSERT INTO gifi (accno, description) VALUES ('250-259', 'Forderungen aus der Abgabenverrechnung');
---
-INSERT INTO gifi (accno, description) VALUES ('26', 'Wertpapiere und Anteile');
-INSERT INTO gifi (accno, description) VALUES ('260', 'Eigene Anteile');
-INSERT INTO gifi (accno, description) VALUES ('261', 'Anteile an verbundenen Unternehmen');
-INSERT INTO gifi (accno, description) VALUES ('262', 'Sonstige Anteile');
-INSERT INTO gifi (accno, description) VALUES ('263-267', 'Sonstige Wertpapiere');
-INSERT INTO gifi (accno, description) VALUES ('268', 'Besitzwechsel, soweit dem Unternehmen nicht die der Ausstellung zugrundeliegenden Forderungen zustehen');
-INSERT INTO gifi (accno, description) VALUES ('269', 'Wertberichtigungen');
---
-INSERT INTO gifi (accno, description) VALUES ('27-28', 'Kassenbestand, Schecks, Guthaben bei Kreditinstituten');
-INSERT INTO gifi (accno, description) VALUES ('270-272', 'KassenbestÃnde in InlandswÃhrung');
-INSERT INTO gifi (accno, description) VALUES ('273', 'Postwertzeichen');
-INSERT INTO gifi (accno, description) VALUES ('274', 'Stempelmarken');
-INSERT INTO gifi (accno, description) VALUES ('275-277', 'KassenbestÃnde in FremdwÃhrung');
-INSERT INTO gifi (accno, description) VALUES ('278', 'Schecks in InlandswÃhrung');
-INSERT INTO gifi (accno, description) VALUES ('280-288', 'Guthaben bei Kreditinstituten');
-INSERT INTO gifi (accno, description) VALUES ('289', 'Wertberichtigungen');
---
-INSERT INTO gifi (accno, description) VALUES ('29', 'Rechnungsabgrenzungsposten');
-INSERT INTO gifi (accno, description) VALUES ('290', 'Aktive Rechnungsabgrenzungsposten');
-INSERT INTO gifi (accno, description) VALUES ('295', 'Disagio');
-INSERT INTO gifi (accno, description) VALUES ('296', 'Unterschiedsbetrag zur gebotenen PensionsrÃckstellung');
-INSERT INTO gifi (accno, description) VALUES ('297', 'Unterschiedsbetrag gem. Abschnitt XII Pensionskassengesetz');
-INSERT INTO gifi (accno, description) VALUES ('298', 'Steuerabgrenzung');
---
-INSERT INTO gifi (accno, description) VALUES ('3', 'RÃckstellungen, Verbindlichkeiten und Rechnungsabgrenzungsposten');
---
-INSERT INTO gifi (accno, description) VALUES ('30', 'RÃckstellungen');
-INSERT INTO gifi (accno, description) VALUES ('300', 'RÃckstellungen fÃr Abfertigungen');
-INSERT INTO gifi (accno, description) VALUES ('301', 'RÃckstellungen fÃr Pensionen');
-INSERT INTO gifi (accno, description) VALUES ('302-303', 'SteuerrÃckstellungen');
-INSERT INTO gifi (accno, description) VALUES ('304-309', 'Sonstige RÃckstellungen');
---
-INSERT INTO gifi (accno, description) VALUES ('31', 'Anleihen, Verbindlichkeiten gegenÃber Kreditinstituten und Finanzinstituten');
-INSERT INTO gifi (accno, description) VALUES ('310', 'Anleihen (einschlieÃlich konvertibler)');
-INSERT INTO gifi (accno, description) VALUES ('311-317', 'Verbindlichkeiten gegenÃber Kreditinstituten');
-INSERT INTO gifi (accno, description) VALUES ('318-319', 'Verbindlichkeiten gegenÃber Finanzinstituten');
---
-INSERT INTO gifi (accno, description) VALUES ('32', 'Erhaltene Anzahlungen auf Bestellungen');
-INSERT INTO gifi (accno, description) VALUES ('320', 'Erhaltene Anzahlungen auf Bestellungen');
-INSERT INTO gifi (accno, description) VALUES ('321', 'Umsatzsteuer-Evidenzkonto fÃr erhaltene Anzahlungen auf Bestellungen');
---
-INSERT INTO gifi (accno, description) VALUES ('33', 'Verbindlichkeiten aus Lieferungen und Leistungen, Verbindlichkeiten aus der Annahme gezogener und der Ausstellung eigener Wechsel');
-INSERT INTO gifi (accno, description) VALUES ('330-335', 'Verbindlichkeiten aus Lieferungen und Leistungen Inland');
-INSERT INTO gifi (accno, description) VALUES ('336', 'Verbindlichkeiten aus Lieferungen und Leistungen WÃhrungsunion');
-INSERT INTO gifi (accno, description) VALUES ('337', 'Verbindlichkeiten aus Lieferungen und Leistungen sonstiges Ausland');
-INSERT INTO gifi (accno, description) VALUES ('338-339', 'Verbindlichkeiten aus der Annahme gezogener Wechsel und der Ausstellung eigener Wechsel');
---
-INSERT INTO gifi (accno, description) VALUES ('34', 'Verbindlichkeiten gegenÃber verbundenen Unternehmen, gegenÃber Unternehmen, mit denen ein BeteiligungsverhÃltnis besteht und gegenÃber Gesellschaftern');
-INSERT INTO gifi (accno, description) VALUES ('340-347', 'Verbindlichkeiten gegenÃber verbundenen Unternehmen, Verbindlichkeiten gegenÃber Unternehmen, mit denen ein BeteiligungsverhÃltnis besteht');
-INSERT INTO gifi (accno, description) VALUES ('348', 'Verbindlichkeiten gegenÃber Gesellschaftern');
---
-INSERT INTO gifi (accno, description) VALUES ('35', 'Verbindlichkeiten aus Steuern');
-INSERT INTO gifi (accno, description) VALUES ('350-359', 'Verbindlichkeiten aus Steuern');
---
-INSERT INTO gifi (accno, description) VALUES ('36', 'Verbindlichkeiten im Rahmen der sozialen Sicherheit');
-INSERT INTO gifi (accno, description) VALUES ('360-369', 'Verbindlichkeiten im Rahmen der sozialen Sicherheit');
---
-INSERT INTO gifi (accno, description) VALUES ('37-38', 'Ãbrige sonstige Verbindlichkeiten');
-INSERT INTO gifi (accno, description) VALUES ('370-389', 'Ãbrige sonstige Verbindlichkeiten');
---
-INSERT INTO gifi (accno, description) VALUES ('39', 'Rechnungsabgrenzungsposten');
-INSERT INTO gifi (accno, description) VALUES ('390-399', 'Passive Rechnungsabgrenzungsposten');
---
-INSERT INTO gifi (accno, description) VALUES ('4', 'Betriebliche ErtrÃge');
---
-INSERT INTO gifi (accno, description) VALUES ('40-44', 'Brutto-UmsatzerlÃse und ErlÃsschmÃlerungen');
-INSERT INTO gifi (accno, description) VALUES ('400-439', 'Brutto-UmsatzerlÃse');
-INSERT INTO gifi (accno, description) VALUES ('440-449', 'ErlÃsschmÃlerungen');
---
-INSERT INTO gifi (accno, description) VALUES ('45', 'BestandsverÃnderungen und aktivierte Eigenleistungen');
-INSERT INTO gifi (accno, description) VALUES ('450-457', 'VerÃnderungen des Bestandes an fertigen und unfertigen Erzeugnissen sowie an noch nicht abrechenbaren Leistungen');
-INSERT INTO gifi (accno, description) VALUES ('458-459', 'andere aktivierte Eigenleistungen');
---
-INSERT INTO gifi (accno, description) VALUES ('46-49', 'Sonstige betriebliche ErtrÃge');
-INSERT INTO gifi (accno, description) VALUES ('460-462', 'ErlÃse aus dem Abgang vom AnlagevermÃgen, ausgenommen Finanzanlagen');
-INSERT INTO gifi (accno, description) VALUES ('463-465', 'ErtrÃge aus dem Abgang vom AnlagevermÃgen, ausgenommen Finanzanlagen');
-INSERT INTO gifi (accno, description) VALUES ('466-467', 'ErtrÃge aus der Zuschreibung zum AnlagevermÃgen, ausgenommen Finanzanlagen');
-INSERT INTO gifi (accno, description) VALUES ('470-479', 'ErtrÃge aus der AuflÃsung von RÃckstellungen');
-INSERT INTO gifi (accno, description) VALUES ('480-499', 'Ãbrige betriebliche ErtrÃge');
---
-INSERT INTO gifi (accno, description) VALUES ('5', 'Materialaufwand und sonstige bezogene Herstellungsleistungen');
-INSERT INTO gifi (accno, description) VALUES ('500-509', 'Wareneinsatz');
-INSERT INTO gifi (accno, description) VALUES ('510-519', 'Verbrauch von Rohstoffen');
-INSERT INTO gifi (accno, description) VALUES ('520-529', 'Verbrauch von bezogenen Fertig- und Einzelteilen');
-INSERT INTO gifi (accno, description) VALUES ('530-539', 'Verbrauch von Hilfsstoffen');
-INSERT INTO gifi (accno, description) VALUES ('540-549', 'Verbrauch von Betriebsstoffen');
-INSERT INTO gifi (accno, description) VALUES ('550-559', 'Verbrauch von Werkzeugen und anderen Erzeugungshilfsmitteln');
-INSERT INTO gifi (accno, description) VALUES ('560-569', 'Verbrauch von Brenn- und Treibstoffen, Energie und Wasser');
-INSERT INTO gifi (accno, description) VALUES ('570-579', 'Sonstige bezogene Herstellungsleistungen');
-INSERT INTO gifi (accno, description) VALUES ('580', 'SkontoertrÃge auf Materialaufwand');
-INSERT INTO gifi (accno, description) VALUES ('581', 'SkontoertrÃge auf sonstige bezogene Herstellungsleistungen');
-INSERT INTO gifi (accno, description) VALUES ('590', 'Aufwandsstellenrechnung');
---
-INSERT INTO gifi (accno, description) VALUES ('6', 'Personalaufwand');
-INSERT INTO gifi (accno, description) VALUES ('600-619', 'LÃhne');
-INSERT INTO gifi (accno, description) VALUES ('620-639', 'GehÃlter');
-INSERT INTO gifi (accno, description) VALUES ('640-644', 'Aufwendungen fÃr Abfertigungen');
-INSERT INTO gifi (accno, description) VALUES ('645-649', 'Aufwendungen fÃr Altersversorgung');
-INSERT INTO gifi (accno, description) VALUES ('650-655', 'Gesetzlicher Sozialaufwand Arbeiter');
-INSERT INTO gifi (accno, description) VALUES ('656-659', 'Gesetzlicher Sozialaufwand Angestellte');
-INSERT INTO gifi (accno, description) VALUES ('660-665', 'LohnabhÃngige Abgaben und PflichtbeitrÃge');
-INSERT INTO gifi (accno, description) VALUES ('666-669', 'GehaltsabhÃngige Abgaben und PflichtbeitrÃge');
-INSERT INTO gifi (accno, description) VALUES ('670-689', 'Sonstige Sozialaufwendungen');
-INSERT INTO gifi (accno, description) VALUES ('690', 'Aufwandsstellenrechnung');
---
-INSERT INTO gifi (accno, description) VALUES ('7', 'Abschreibungen und sonstige betriebliche Aufwendunge');
---
-INSERT INTO gifi (accno, description) VALUES ('70', 'Abschreibungen');
-INSERT INTO gifi (accno, description) VALUES ('700', 'Abschreibungen auf aktivierte Aufwendungen fÃr das Ingangsetzen und Erweitern eines Betriebes');
-INSERT INTO gifi (accno, description) VALUES ('701-708', 'Abschreibungen auf das AnlagevermÃgen (ausgenommen Finanzanlagen)');
-INSERT INTO gifi (accno, description) VALUES ('709', 'Abschreibungen vom UmlaufvermÃgen, soweit diese die im Unternehmen Ãblichen Abschreibungen Ãbersteigen');
---
-INSERT INTO gifi (accno, description) VALUES ('71', 'Sonstige Steuern');
-INSERT INTO gifi (accno, description) VALUES ('710-719', 'Sonstige Steuern');
---
-INSERT INTO gifi (accno, description) VALUES ('72-78', 'Ãbrige betriebliche Aufwendungen');
---
-INSERT INTO gifi (accno, description) VALUES ('72', 'Instandhaltung und Reinigung durch Dritte, Entsorgung, Beleuchtung');
-INSERT INTO gifi (accno, description) VALUES ('720-729', 'Instandhaltung und Reinigung durch Dritte, Entsorgung, Beleuchtung');
---
-INSERT INTO gifi (accno, description) VALUES ('73', 'Transport-, Reise- und Fahrtaufwand, Nachrichtenaufwand');
-INSERT INTO gifi (accno, description) VALUES ('730-731', 'Transporte durch Dritte');
-INSERT INTO gifi (accno, description) VALUES ('732-733', 'Kfz-Aufwand');
-INSERT INTO gifi (accno, description) VALUES ('734-735', 'Reise- und Fahrtaufwand');
-INSERT INTO gifi (accno, description) VALUES ('736-737', 'Tag- und NÃchtigungsgelder');
-INSERT INTO gifi (accno, description) VALUES ('738-739', 'Nachrichtenaufwand');
---
-INSERT INTO gifi (accno, description) VALUES ('74', 'Miet-, Pacht-, Leasing- und Lizenzaufwand');
-INSERT INTO gifi (accno, description) VALUES ('740-743', 'Miet- und Pachtaufwand');
-INSERT INTO gifi (accno, description) VALUES ('744-747', 'Leasingaufwand');
-INSERT INTO gifi (accno, description) VALUES ('748-749', 'Lizenzaufwand');
---
-INSERT INTO gifi (accno, description) VALUES ('75', 'Aufwand fÃr beigestelltes Personal, Provisionen an Dritte, AufsichtsratsvergÃtungen');
-INSERT INTO gifi (accno, description) VALUES ('750-753', 'Aufwand fÃr beigestelltes Personal');
-INSERT INTO gifi (accno, description) VALUES ('754-757', 'Provisionen an Dritte');
-INSERT INTO gifi (accno, description) VALUES ('758-759', 'AufsichtsratsvergÃtungen');
---
-INSERT INTO gifi (accno, description) VALUES ('76', 'BÃro-, Werbe- und ReprÃsentationsaufwand');
-INSERT INTO gifi (accno, description) VALUES ('760', 'BÃromaterial und Drucksorten');
-INSERT INTO gifi (accno, description) VALUES ('761-762', 'Druckerzeugnisse und VervielfÃltigungen');
-INSERT INTO gifi (accno, description) VALUES ('763', 'Fachliteratur und Zeitungen');
-INSERT INTO gifi (accno, description) VALUES ('765-768', 'Werbung und ReprÃsentation');
-INSERT INTO gifi (accno, description) VALUES ('769', 'Spenden und Trinkgelder');
---
-INSERT INTO gifi (accno, description) VALUES ('77-78', 'Versicherungen, Ãbrige Aufwendungen');
-INSERT INTO gifi (accno, description) VALUES ('770-774', 'Versicherungen');
-INSERT INTO gifi (accno, description) VALUES ('775-776', 'Beratungs- und PrÃfungsaufwand');
-INSERT INTO gifi (accno, description) VALUES ('777', 'Aus- und Fortbildung');
-INSERT INTO gifi (accno, description) VALUES ('778', 'MitgliedsbeitrÃge');
-INSERT INTO gifi (accno, description) VALUES ('779', 'Spesen des Geldverkehrs');
-INSERT INTO gifi (accno, description) VALUES ('780-781', 'SchadensfÃlle');
-INSERT INTO gifi (accno, description) VALUES ('782', 'Buchwert abgegangener Anlagen, ausgenommen Finanzanlagen');
-INSERT INTO gifi (accno, description) VALUES ('783', 'Verluste aus dem Abgang vom AnlagevermÃgen, ausgenommen Finanzanlagen');
-INSERT INTO gifi (accno, description) VALUES ('784-788', 'Verschiedene betriebliche Aufwendungen');
-INSERT INTO gifi (accno, description) VALUES ('789', 'SkontoertrÃge auf sonstige betriebliche Aufwendungen');
---
-INSERT INTO gifi (accno, description) VALUES ('79', 'Konten fÃr das Umsatzkostenverfahren');
-INSERT INTO gifi (accno, description) VALUES ('790', 'Aufwandsstellenrechnung');
-INSERT INTO gifi (accno, description) VALUES ('791-799', 'Aufwandsstellen im Rahmen des Umsatzkostenverfahrens');
-INSERT INTO gifi (accno, description) VALUES ('791-795', 'Aufwandsstellen der Herstellung');
-INSERT INTO gifi (accno, description) VALUES ('796', 'Herstellungskosten der zur Erzielung der UmsatzerlÃse erbrachten Leistungen');
-INSERT INTO gifi (accno, description) VALUES ('797', 'Vertriebskosten');
-INSERT INTO gifi (accno, description) VALUES ('798', 'Verwaltungskosten');
-INSERT INTO gifi (accno, description) VALUES ('799', 'Sonstige betriebliche Aufwendungen');
---
-INSERT INTO gifi (accno, description) VALUES ('8', 'FinanzertrÃge und Finanzaufwendungen, a.o. ErtrÃge und a.o. Aufwendungen, Steuern vom Einkommen und vom Ertrag, RÃcklagenbewegung');
---
-INSERT INTO gifi (accno, description) VALUES ('80-83', 'FinanzertrÃge und Finanzaufwendungen');
-INSERT INTO gifi (accno, description) VALUES ('800-804', 'ErtrÃge aus Beteiligungen');
-INSERT INTO gifi (accno, description) VALUES ('805-809', 'ErtrÃge aus anderen Wertpapieren und Ausleihungen des FinanzanlagevermÃgens');
-INSERT INTO gifi (accno, description) VALUES ('810-813', 'Sonstige Zinsen und Ãhnliche ErtrÃge');
-INSERT INTO gifi (accno, description) VALUES ('814', 'ErlÃse aus dem Abgang von Beteiligungen');
-INSERT INTO gifi (accno, description) VALUES ('815', 'ErlÃse aus dem Abgang von sonstigen Finanzanlagen');
-INSERT INTO gifi (accno, description) VALUES ('816', 'ErlÃse aus dem Abgang von Wertpapieren des UmlaufvermÃgens');
-INSERT INTO gifi (accno, description) VALUES ('817', 'Buchwert abgegangener Beteiligungen');
-INSERT INTO gifi (accno, description) VALUES ('818', 'Buchwert abgegangener sonstiger Finanzanlagen');
-INSERT INTO gifi (accno, description) VALUES ('819', 'Buchwert abgegangener Wertpapiere des UmlaufvermÃgens');
-INSERT INTO gifi (accno, description) VALUES ('820', 'ErtrÃge aus dem Abgang von und der Zuschreibung zu Finanzanlagen');
-INSERT INTO gifi (accno, description) VALUES ('821', 'ErtrÃge aus dem Abgang von und der Zuschreibung zu Wertpapieren des UmlaufvermÃgens');
-INSERT INTO gifi (accno, description) VALUES ('822-825', 'Aufwendungen aus Beteiligungen');
-INSERT INTO gifi (accno, description) VALUES ('826-827', 'Aufwendungen aus sonstigen Finanzanlagen und aus Wertpapieren des UmlaufvermÃgens');
-INSERT INTO gifi (accno, description) VALUES ('828-834', 'Zinsen und Ãhnliche Aufwendungen');
-INSERT INTO gifi (accno, description) VALUES ('835', 'Nicht ausgenÃtzte Lieferantenskonti');
---
-INSERT INTO gifi (accno, description) VALUES ('84', 'AuÃerordentliche ErtrÃge und auÃerordentliche Aufwendungen');
-INSERT INTO gifi (accno, description) VALUES ('840-844', 'AuÃerordentliche ErtrÃge');
-INSERT INTO gifi (accno, description) VALUES ('845-849', 'AuÃerordentliche Aufwendungen');
---
-INSERT INTO gifi (accno, description) VALUES ('85', 'Steuern vom Einkommen und vom Ertrag');
-INSERT INTO gifi (accno, description) VALUES ('850-859', 'Steuern vom Einkommen und vom Ertrag');
---
-INSERT INTO gifi (accno, description) VALUES ('86-89', 'RÃcklagenbewegung, ErgebnisÃberrechnung');
-INSERT INTO gifi (accno, description) VALUES ('860-869', 'AuflÃsung unversteuerter RÃcklagen');
-INSERT INTO gifi (accno, description) VALUES ('870-874', 'AuflÃsung von KapitalrÃcklagen');
-INSERT INTO gifi (accno, description) VALUES ('875-879', 'AuflÃsung von GewinnrÃcklagen');
-INSERT INTO gifi (accno, description) VALUES ('880-889', 'Zuweisung zu unversteuerten RÃcklagen');
-INSERT INTO gifi (accno, description) VALUES ('890-895', 'Zuweisung zu GewinnrÃcklagen');
-INSERT INTO gifi (accno, description) VALUES ('899', 'Gewinnabfuhr bzw. VerlustÃberrechnung aus ErgebnisabfÃhrungsvertrÃgen');
---
-INSERT INTO gifi (accno, description) VALUES ('9', 'Eigenkapital, unversteuerte RÃcklagen, Einlagen Stiller Gesellschafter, AbschluÃ- und Evidenzkonten');
---
-INSERT INTO gifi (accno, description) VALUES ('900-918', 'Gezeichnetes bzw. gewidmetes Kapital');
-INSERT INTO gifi (accno, description) VALUES ('919', 'Nicht eingeforderte ausstehende Einlagen');
-INSERT INTO gifi (accno, description) VALUES ('920-929', 'KapitalrÃcklagen');
-INSERT INTO gifi (accno, description) VALUES ('930-938', 'GewinnrÃcklagen');
-INSERT INTO gifi (accno, description) VALUES ('939', 'Bilanzgewinn (-verlust)');
-INSERT INTO gifi (accno, description) VALUES ('940-959', 'Bewertungsreserven und sonstige unversteuerte RÃcklagen');
-INSERT INTO gifi (accno, description) VALUES ('960-969', 'Privat- und Verrechnungskonten bei Einzelunternehmen und Personengesellschaften');
-INSERT INTO gifi (accno, description) VALUES ('970-979', 'Einlagen Stiller Gesellschafter');
-INSERT INTO gifi (accno, description) VALUES ('980', 'ErÃffnungsbilanz');
-INSERT INTO gifi (accno, description) VALUES ('985', 'SchluÃbilanz');
-INSERT INTO gifi (accno, description) VALUES ('989', 'Gewinn- und Verlustrechnung');
-INSERT INTO gifi (accno, description) VALUES ('990-999', 'Evidenzkonten');
-commit;

Deleted: trunk/sql/Bahasa-Indonesia_Default-chart.sql
===================================================================
--- trunk/sql/Bahasa-Indonesia_Default-chart.sql	2007-03-06 02:48:38 UTC (rev 850)
+++ trunk/sql/Bahasa-Indonesia_Default-chart.sql	2007-03-06 03:32:20 UTC (rev 851)
@@ -1,87 +0,0 @@
-begin;
--- Default chart of accounts
--- sample only
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1000','AKTIVA LANCAR','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1060','Bank','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1065','Kas Kecil','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1200','Piutang','A','','A','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1500','INVENTORY','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1520','Inventory / Umum','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1530','Inventory / Aftermarket Parts','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1800','AKTIVA TETAP','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1820','Perabot Kantor & Peralatan','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('1825','Akumulasi Amort. Perabot & Peralatan','A','','A','','1');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1840','Kendaraan','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('1845','Akumulasi Amort. Kendaraan','A','','A','','1');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2000','HUTANG LANCAR','H','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2100','Hutang Dagang','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2160','Hutang Pajak','A','','L','');
---insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2190','Federal Income Tax Payable','A','','L','');
---insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2210','Workers Comp Payable','A','','L','');
---insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2220','Vacation Pay Payable','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2250','Hutang Rencana Pensiun','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2260','Hutang Asuransi Karyawan','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2280','Hutang Pajak Gaji','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2310','PPn (10%)','A','','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
---insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2320','VAT (14%)','A','','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
---insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2330','VAT (30%)','A','','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2600','HUTANG JANGKA PANJANG','H','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2620','Hutang Bank','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2680','Hutang ke Pemegang Saham','A','','L','AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3300','MODAL','H','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3350','Modal Umum','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4000','PENDAPATAN PENJUALAN','H','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4020','Penjualan / General','A','','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4030','Penjualan / Aftermarket Parts','A','','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4300','PENDAPATAN KONSULTASI','H','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4320','Jasa Konsultasi','A','','I','AR_amount:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4400','PENDAPATAN LAIN','H','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4430','Jasa Pengiriman dan Pengepakan','A','','I','IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4440','Bunga','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4450','Keuntungan Selisih Kurs','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5000','BIAYA PENJUALAN','H','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5010','Pembelian','A','','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5020','COGS / General','A','','E','AP_amount:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5030','COGS / Aftermarket Parts','A','','E','AP_amount:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5100','Ongkos Kirim','A','','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5400','BIAYA GAJI','H','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5410','Biaya Gaji','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5420','Biaya Asuransi Karyawan','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5430','Biaya Rencana Pensiun','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5600','BIAYA UMUM DAN ADMINISTRASI','H','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5610','Akunting dan Legalitas','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5615','Iklan dan Promosi','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5650','Capital Cost Allowance Expense','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5660','Biaya Amortisasi','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5680','Biaya Pajak Pendapatan','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5685','Asuransi','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5690','Biaya Bank dan Bunga','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5700','Biaya Keperluan Kantor','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5760','Biaya Sewa','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5765','Reparasi & Maintenance','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5780','Telephone','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5785','Perjalanan dan Entertainment','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5790','Utilitas','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5795','Registrasi','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5800','Licensi','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5810','Rugi Selisih Kurs','A','','E','');
---
-insert into tax (chart_id,rate) values ((select id from chart where accno = '2310'),0.1);
---insert into tax (chart_id,rate) values ((select id from chart where accno = '2320'),0.14);
---insert into tax (chart_id,rate) values ((select id from chart where accno = '2330'),0.3);
---
-INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4020'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5010'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '4450'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '5810'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('curr', 'IDR:USD:CAD:EUR');
-
- INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
---
-commit;

Deleted: trunk/sql/Belgium-chart.sql
===================================================================
--- trunk/sql/Belgium-chart.sql	2007-03-06 02:48:38 UTC (rev 850)
+++ trunk/sql/Belgium-chart.sql	2007-03-06 03:32:20 UTC (rev 851)
@@ -1,448 +0,0 @@
-begin;
--- selon PLAN COMPTABLE MINIMUM NORMALISE BELGE
--- contribu. par Jens-Ingo Brodesser, ..hidden..
--- verified May 19, 2006
---
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('756000', 'Produits financiers divers', 'A', 'I', 'AR_paid:AP_paid', '75', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('555000', 'DEX02', 'A', 'A', 'AR_paid:AP_paid', '55', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('499200', 'Compte de repartition NDC - Verdelingsrekening CN', 'A', 'L', 'AR_paid:AP_paid', '', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('460', 'Acomptes reÃus sur commandes', 'A', 'L', 'AR_paid', '46', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('4168', 'Rabais, ristournes, remises Ã obtenir et autres avoirs non encore reÃus', 'A', 'A', 'AP_paid', '416', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('43', 'Dettes financiÃres - FinanciÃle schulden', 'H', 'L', '', '43', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('2400', 'Mobilier - Meubilair', 'A', 'A', '', '24', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('240190', 'MatÃriel bureau amort. anterieurs - Afschr. op bureaumaterieel vorig boekj.', 'A', 'A', '', '24', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('221900', 'Constructions amort. anterieurs - Afschr. op gebouwen vorig boekj.', 'A', 'A', '', '22', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('221910', 'Constructions amort. de l''exercice - Afschr. op gebouwen dit boekj.', 'A', 'A', '', '22', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('75', 'Produits financiers - FinanciÃle opbrengsten', 'H', 'I', '', '75', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('230900', 'Inst. techniques amort. anterieurs - Afschr. op installaties vorig boekj.', 'A', 'A', '', '23', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('240090', 'Mobilier amort. anter. - Afschr. op meubilair vorig boekj.', 'A', 'A', '', '24', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('240091', 'Mobilier amort. exercice - Afschr. op meubilair dit boekj.', 'A', 'A', '', '24', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('240191', 'MatÃriel bureau amort. exercice - Afschr. op bureaumaterieel dit boekj.', 'A', 'A', '', '24', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('240290', 'Materiel Informatique amort. anter. - Afschr. op hardware vorig boekj.', 'A', 'A', '', '24', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('240291', 'Mat. informat. amort. exercice - Afschr. op hardware dit boekj.', 'A', 'A', '', '24', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('241900', 'Voiture amort. anter. - Afschr. op wagen vorig boekj.', 'A', 'A', '', '24', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('241910', 'Voiture amort. exercice - Afschr. op wagen dit boekj. ', 'A', 'A', '', '24', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('260900', 'Amen. loc. louÃs amort. anter. - Inrichtingskost. vorig boekj.', 'A', 'A', '', '26', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('230910', 'Inst. techniques amort. exercice - Afschr. op installaties dit boekj.', 'A', 'A', '', '23', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('231900', 'Mach. et gros mat. amort. anterieurs - Afschr. op machines vorig boekj.', 'A', 'A', '', '23', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('231910', 'Mach. et gros mat. amort. exercice - Afschr. op machines dit boekj.', 'A', 'A', '', '23', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('237900', 'Outillage amort. anterieurs - Afschr. op uitrusting vorig boekj.', 'A', 'A', '', '23', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('237910', 'Outillage amort. exercice - Afschr. op uitrusting dit boekj.', 'A', 'A', '', '23', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('260910', 'Amen. loc. louÃs amort. exercice - Inrichtingskost. dit boekj.', 'A', 'A', '', '26', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('451541', 'TVA DUE VENTES 21%', 'A', 'L', 'AR_tax:IC_taxpart:IC_taxservice', '451', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('612200', 'Carburants voitures', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('630', 'Dotations amort., rÃduction valeur s/immo. - Afschr., waardeverm. op v. a., toevoeging', 'A', 'E', '', '63', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('613210', 'Honoraires avocats', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('712', 'Des encours de fabrication - In de vooraad goederen in bewerking', 'A', 'I', 'IC_sale', '71', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('600', 'Achats matiÃres premiÃres - Aankopen van grondstoffen', 'A', 'E', 'IC_cogs', '60', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('614400', 'EntrÃe aux foires', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('742', 'Plus-values crÃances com. - Meerwaarden realis. handelsvorderingen', 'A', 'I', '', '74', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('613304', 'Traiteurs-rÃception clientÃle', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('64', 'Autres charges exploitation - Andere bedrijfskosten', 'H', 'E', '', '64', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('76', 'Produits exceptionnels - Uitzonderlijke opbrengsten', 'H', 'I', '', '76', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('743000', 'Ventes diverses - Diverse bedrijfsopbrengsten', 'A', 'I', '', '74', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('760100', 'sur immobilisations corp. - op materiÃle vaste activa', 'A', 'I', '', '760', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('611150', 'Charges locatives voitures', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('771200', 'Reprises de provisions fiscales - Terugn. fiscale voorz.', 'A', 'I', '', '771', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('794', 'Intervention associÃ perte - Tussenkomst vennoten verlies', 'A', 'I', '', '79', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('404', 'Produits Ã recevoir - Te innen opbrengsten', 'A', 'A', '', '40', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('500', 'Action propres - Eigen aandelen', 'A', 'A', '', '50', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('41', 'Autres crÃances - Overige vorderingen', 'H', 'A', '', '41', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('407', 'CrÃances douteuses - Dubieuze debiteuren', 'A', 'A', 'AR_paid', '40', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('442001', 'Fournisseurs essence', 'A', 'L', 'AP', '44', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('608', 'Remises ristournes rabais obtenus - Ontvangen kortingen ristorno''s en rabatten (-)', 'A', 'E', 'IC_cogs', '60', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('612140', 'Internet', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('50', 'Actions propres - Eigen aandelen', 'H', 'A', '', '50', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('6', 'CLASSE 6 -- CHARGES - KOSTEN', 'H', 'E', '', '', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('611350', 'Entr. & Repar. Voitures & Veh. Mixtes', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('655000', 'Ecarts de conversion de devises', 'A', 'E', 'AR_paid:IC_sale:IC_expense', '65', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('451560', 'TVA DUE CO-CONTRACTANT', 'A', 'L', '', '451', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('609000', 'de matiÃres premiÃres - van grondstofen', 'A', 'E', '', '60', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('411590', 'TVA ACHATS 6%', 'A', 'A', 'AP_tax:IC_taxpart:IC_taxservice', '411', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('411591', 'TVA ACHATS 21%', 'A', 'A', 'AP_tax:IC_taxpart:IC_taxservice', '411', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('411620', 'TVA Ã rÃgulariser (case 62)', 'A', 'A', '', '411', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('411', 'TVA A RECUPERER - TERUG TE VORDEREN BTW', 'H', 'A', '', '', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('44', 'Dettes commerciales - Handelsschulden', 'H', 'L', '', '44', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('409', 'RÃductions de valeur actÃes (-) - Geboekte waardevermindering', 'A', 'A', '', '40', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('451540', 'TVA DUE VENTES 6%', 'A', 'L', 'AR_tax:IC_taxpart:IC_taxservice', '451', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('640', 'Charges fiscales de l''exploitation - Bedrijfsbelastingen', 'A', 'E', '', '64', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('713', 'Des Produits finis - In de voorraad gereed product', 'A', 'I', 'IC_sale', '71', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('750', 'Produits immo. financiÃres - Opbrengsten financiÃle vaste activa', 'A', 'I', '', '75', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('656500', 'IntÃrÃts retards sociaux - Sociale achterst. interest', 'A', 'E', 'AP_amount:IC_expense', '65', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('755000', 'Ecarts de convers. devises - Resultats omrekening vreemde valuta', 'A', 'I', 'IC_sale:IC_income', '75', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('754000', 'DiffÃrence de change - Wisselresultaten', 'A', 'I', 'AR_amount:IC_income', '75', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('761', 'Reprises rÃduct. valeur immo. fin. - Terugneming waardeverm. fin. v. a.', 'A', 'I', '', '76', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('773', 'ImpÃts Ãtrangers s/rÃsultat - Buitenl. belasting op resultaat', 'A', 'I', '', '77', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('77', 'RÃgularisation d''impÃts, reprises provisions fiscales - Regul. belastingen en terugneming fiscale voorz.', 'H', 'I', '', '77', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('7', 'CLASSE 7 -- PRODUITS - OPBRENGSTEN', 'H', 'I', '', '', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('411640', 'TVA Ã recupÃrer s/NDC Ãmises (case 64)', 'A', 'A', '', '411', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('612300', 'Abonnements & Documentations', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('410', 'Capital appelÃ, non versÃ - Opgevraagd, niet-gestort kapitaal', 'A', 'A', '', '41', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('417', 'CrÃances douteuses - Dubieuze debiteuren', 'A', 'A', '', '416', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('451', 'TVA A PAYER - TE BETALEN BTW', 'H', 'L', '', '', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('499000', 'Compte d''attente - Wachtrekening', 'A', 'L', '', '', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('455', 'RÃmunerations - Bezoldigingen', 'A', 'L', '', '45', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('601', 'Achat des fournitures - Aankoop van hulpstoffen', 'A', 'E', 'IC_cogs', '60', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('49', 'Comptes de rÃgularisation - Overlopende- en wachtrekeningen', 'H', 'L', '', '', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('613220', 'Honoraires notaires', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('414100', 'IndeminitÃs s/sinistres Ã recevoir - Te ontvang. schadevergoed.', 'A', 'A', '', '41', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('42', 'Dettes Ã plus d''un an Ãcheant dans l''annÃe - Schulden op meer dan ÃÃn jaar die binnen het jaar verfallen', 'H', 'L', '', '42', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('613311', 'Deplacements Ãtranger train, taxi, etc', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('611151', 'Charges locatives camions/camionnettes', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('432', 'Etabli. crÃdit, crÃdits d''acceptation - Acceptkrediten', 'A', 'L', '', '43', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('433', 'Etabl. crÃdit, dettes cpt. courant - Schulden rekening courant', 'A', 'L', '', '43', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('705100', 'DNS REGISTRY', 'A', 'I', 'AR_amount:IC_income', '70', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('609100', 'de fourniture - van hulpstoffen', 'A', 'E', '', '60', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('656100', 'Frais de banque', 'A', 'E', 'AP_amount:IC_expense', '65', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('620000', 'Administrateurs ou gÃrants - Bestuurders of zaakvoerders', 'A', 'E', '', '62', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('618', 'Divers', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('65', 'Charges financiÃres', 'H', 'E', '', '65', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('442004', 'VISA - dÃcompte mensuel', 'A', 'L', 'AP_paid', '44', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('620100', 'Personnel de direction - Directiepersoneel', 'A', 'E', '', '62', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('617', 'Personnel intÃrimaire - Uitzendkrachten', 'A', 'E', '', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('440', 'Fournisseurs - Leveranciers', 'A', 'L', 'AP', '44', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('52', 'Titres Ã revenu fixe - Vastrentende Effecten', 'H', 'A', '', '52', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('4529', '453 - 459 Dettes salariales et sociales - Bezoldigingen en sociale schulden', 'H', 'L', '', '', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('620', 'RÃmunerations et avant. sociaux directs - Bezolgingen en rechts. sociale voordelen', 'A', 'E', '', '62', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('602', 'Achats services, travaux, Ãtudes - Aankopen diensten, werk, studies', 'A', 'E', 'IC_cogs', '60', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('612000', 'Eau', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('611351', 'Pneus Voitures & Vehic. Mixtes', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('641', 'Moins-values s/rÃalis. cour. d''immo. corp. - Minderwa. courante realis. vaste activa', 'A', 'E', '', '64', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('715', 'Des immeubles constr. dest. Ã la vente - In de voorr. onroe. goederen best. v. verkoop', 'A', 'I', 'IC_sale', '71', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('612400', 'ImprimÃs & fournitures de bureau', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('414200', 'Subsides en capital Ã recevoir - Te ontv. kapitaalsubsidies', 'A', 'A', '', '41', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('66', 'Charges exceptionnelles', 'H', 'E', '', '66', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('613230', 'Honoraires huissiers de justice', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('613313', 'Restaurants Ãtranger', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('74', 'Autres produits exploitation - Andere bedrijfsopbrengsten', 'H', 'I', '', '74', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('610', 'Loyers et charges locatives', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('70', 'Chiffre d''affaires - Omzet', 'H', 'I', '', '', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('751', 'Produits actifs circulants - Opbrengsten uit vlottende activa', 'A', 'I', '', '75', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('705200', 'WEB HOSTING', 'A', 'I', 'AR_amount:IC_income', '70', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('442005', 'AMERICAN EXPRESS - dÃcompte mensuel', 'A', 'L', 'AP_paid', '44', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('762', 'Reprises provisions risq. charg. except. - Terugn. voorz. uitz. risico en kosten', 'A', 'I', '', '76', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('780', 'PrÃlÃvements s/impÃts diffÃrÃs - Onttrekking a. uitgesteld. belast.', 'A', 'I', '', '78', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('78', 'PrÃlÃvements rÃserves immunisÃes et impÃts diffÃrÃs - Onttrek. belast.vrije reserves en de uitgestelde belastingen', 'H', 'I', '', '78', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('53', 'DÃpÃts Ã terme - Termijndeposito''s', 'H', 'A', '', '53', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('614100', 'Catalogues et imprimÃes', 'A', 'I', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('451500', 'TVA DUE ACHATS INCO', 'A', 'L', '', '451', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('613110', 'Assurance vol', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('451543', 'TVA due 2e trimestre', 'A', 'L', '', '451', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('609400', 'de marchandises - van handelsgoederen', 'A', 'E', 'AP_amount:IC_sale', '60', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('613305', 'Collations', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('612010', 'Chauffage', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('612410', 'Fournitures informatiques', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('613250', 'Honoraires sÃcretariat social', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('611362', 'Control technique voitures', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('482200', 'ASSOCIES - MEMBRES', 'A', 'L', '', '48', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('612530', 'Petit outillage & petit matÃriel', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('613400', 'Seminaires & Recyclages', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('612540', 'Petit matÃriel informatique', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('603', 'Sous-traitances gÃnÃrales - Algemene onderaanemingen', 'A', 'E', 'IC_cogs', '60', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('743200', 'COTISATION DE MEMBRE', 'A', 'I', 'AR_amount:IC_income', '74', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('601000', 'Emballages perdus', 'A', 'E', 'IC_cogs', '60', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('230010', 'Inst. techniques acquis. exercice - Installaties m.b.t. dit boekj.', 'A', 'A', 'AP_amount:IC_expense', '23', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('570000', 'CAISSE ESPECES - CONTANTEN', 'A', 'A', 'AR_paid:AP_paid', '57', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('451544', 'TVA due 3e trimestre', 'A', 'L', '', '451', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('411000', 'Cpt. curr. TVA Ã rÃcuperer - Terug te vord. BTW: saldo BTW r/c', 'A', 'A', '', '411', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('611152', 'Locations machines et outils', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('56', 'Office des chÃques postaux - PostchÃque en girodienst', 'H', 'A', '', '56', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('411593', 'TVA RECUP. 1ER TRIMESTRE TOTAL (case 59)', 'A', 'A', '', '411', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('51', 'Actions et parts - Aandelen', 'H', 'A', '', '51', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('510010', 'Montants non-appelÃs (-) - Niet opgevraagde bedragen aan. (-)', 'A', 'A', '', '51', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('609500', 'd''immeubles achÃtÃs destinÃs Ã vente - van gek. onroer. goederen best. v. verkoop', 'A', 'E', '', '60', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('58', 'Virements interns - Interne overboekingen', 'H', 'A', '', '58', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('416', 'CrÃances diverses - Diverse vorderingen ', 'H', 'A', '', '416', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('416200', 'Cpt. courant associÃs - Rekening-courant vennoten', 'A', 'A', '', '416', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('418', 'Cautionnements versÃs en numÃraire - Borgtochten betaald in contanten', 'A', 'A', '', '416', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('67', 'ImpÃt sur le rÃsultat', 'H', 'E', '', '67', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('654', 'DiffÃrence de change', 'A', 'E', 'AP_amount', '65', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('642', 'Moins-values s/rÃalis. crÃances com. - Minderwa. realis. handelsvorderingen', 'A', 'E', '', '64', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('717', 'Des commandes en cours exÃcution - In de bestelling in uitvoering', 'A', 'I', 'IC_sale', '71', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('752', 'Plus-values rÃalis. d''actifs circulants - Meerwaar. realis. v. vlottende activa', 'A', 'I', '', '75', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('763', 'Plus-values s/rÃalis. actifs immo. - Meerwaar. realis. vaste a.', 'A', 'I', '', '76', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('789', 'PrÃlÃvements s/rÃserves immunisÃes - Onttrekking a. belast.vrije reserves', 'A', 'I', '', '78', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('79', 'Affectations et prÃlÃvements - Resultaatverwerking', 'H', 'I', '', '79', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('412', 'ImpÃts, prÃcomptes Ã rÃcupÃrer - Terug te vorderen belast. en voorheffingen', 'A', 'A', '', '41', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('120', 'Plus-values de rÃÃvaluation sur immo. incorp. - Herwaarderingsmeerwaarde', 'A', 'L', '', '12', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('121', 'Plus-values de rÃÃvaluation sur immo. corp. - Herwaarderingsmeerwaarde', 'A', 'L', '', '12', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('122', 'Plus-values de rÃÃvaluation sur immo. financiers - Herwaarderingsmeerwaarde', 'A', 'L', '', '12', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('123', 'Plus-values de rÃÃvaluation sur stocks - Herwaarderingsmeerwaarde', 'A', 'L', '', '12', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('124', 'Reprises de rÃduction de valeur sur placements trÃsorerie - Herwaarderingsmeerwaarde', 'A', 'L', '', '12', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('12', 'Plus-values de rÃÃvaluation - Herwaarderingsmeerwaarde', 'H', 'L', '', '12', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('110', 'Primes d''Ãmission - Uitgiftepremies', 'A', 'L', '', '11', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('11', 'Primes d''Ãmission - Uitgiftepremies', 'H', 'L', '', '11', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('643', '643-648 Charges d''exploitation diverses - Diverse berijfskosten', 'H', 'E', '', '', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('612100', 'Telephone', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('10', 'Capital - Kapitaal', 'H', 'L', '', '10', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('1', 'CLASSE 1 -- CAPITAL PROPRE, ... - EIGEN VERMOGEN, ...', 'H', 'L', '', '', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('60', 'Approv. et marchandises', 'H', 'E', '', '60', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('717000', 'Valeur d''acquisition - Aanschaffingswaarde', 'A', 'I', '', '717', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('68', 'Transferts comptes immunisÃes et impÃts diffÃrÃs', 'H', 'E', '', '68', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('130', 'RÃserve lÃgale - Wettelijke reserve', 'A', 'L', '', '13', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('131100', 'Autres rÃserves indisponibles - Andere onbeschikbare reserves', 'A', 'L', '', '13', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('132', 'RÃserves immunisÃes - Belastingvrije reserves', 'A', 'L', '', '13', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('131000', 'RÃserves pour actions propres - Reserve voor eigen aandelen', 'A', 'L', '', '13', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('133', 'RÃserves disponibles - Beschikbare reserves', 'A', 'L', '', '13', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('101', 'Capital non appelÃ (-) - Niet opgevraagd kapitaal (-)', 'A', 'L', '', '10', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('14', 'BÃnÃfice/perte reportÃ(e) - Overgedragen winst/verlies', 'H', 'L', '', '14', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('100', 'Capital souscrit - Geplaatst kapitaal', 'A', 'L', '', '10', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('601010', 'Emballages recuperables', 'A', 'E', 'IC_cogs', '60', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('140', 'BÃnÃfice/perte reportÃ(e) - Overgedragen winst/verlies', 'A', 'Q', '', '14', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('15', 'Subsides en capital - Kapitaalsubsidies', 'H', 'L', '', '15', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('419', 'RÃductions de valeur actÃes (-) - Geboekte waardevermindering (-)', 'A', 'A', '', '416', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('612450', 'Photocopies-Photographies', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('131', 'RÃserves indisponibles - Onbeschikbare reserves', 'A', 'L', '', '13', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('16', 'Provisions et impÃts diffÃrÃs - Voorz. en uitgestelde belastingen', 'H', 'L', '', '16', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('160', 'Provisions pensions et obligations - Voorz. pensioenen en soortg. verplichtingen', 'A', 'L', '', '16', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('161', 'Provisions charges fiscales - Voorz. belastingen', 'A', 'L', '', '16', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('162', 'Provisions gros entretiens et rÃparations - Voorz. grote herstel/onderh.', 'A', 'L', '', '16', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('163', 'Provisions autres risques-charges - Voorzieningen voor Lijfrente', 'A', 'L', '', '16', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('753', 'Subsides en capital et intÃrÃts - Kapitaal- en interestsubsidies', 'A', 'I', '', '75', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('705000', 'Prestations de services - Verkopen en dienstprestaties', 'A', 'I', '', '70', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('764', '764-769 Autres produits execptionnels - Andere uitz. opbrengsten', 'H', 'I', '', '', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('790', 'BÃnÃfice reportÃ exercice prÃcÃd. - Overgedragen winst vorige boekj.', 'A', 'I', '', '79', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('168200', 'ImpÃts diff. s/+value immo. corp. - Uitg. belast./meerwa./mat. v.a.', 'A', 'L', '', '16', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('604', 'Achats marchandises - Aankopen van handelsgoederen', 'A', 'E', 'IC_cogs', '60', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('168000', 'ImpÃts diff. s/subsides en capital - Uitgest. belast./Kapitaalsubsidie', 'A', 'L', '', '16', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('613265', 'Honoraires d''autres', 'A', 'E', 'AP_amount:IC_expense', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('620800', 'Assurance revenus garantis', 'A', 'E', 'AP_amount:IC_expense', '62', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('168800', 'ImpÃts diffÃrÃs Ãtrangers - Uitg. belast. buitenland', 'A', 'L', '', '16', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('17', 'Dettes Ã plus d''un an - Schulden op meer dan een jaar', 'H', 'L', '', '17', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('150', 'Montants obtenus - Kapitaalsubsidies', 'A', 'L', '', '15', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('172000', 'Dettes location fin. et assimilÃes - Leasingschuld. van vaste activa', 'A', 'L', '', '17', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('231010', 'Mach. et gros mat. acquis. exercice - Machines m.b.t. dit boekj.', 'A', 'A', 'AP_amount:IC_expense', '23', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('451610', 'TVA Ã rÃgulariser (case 61)', 'A', 'L', '', '45', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('456', 'PÃcules de vacances - Vakantiegeld', 'A', 'L', '', '45', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('176', 'Acomptes reÃus sur commandes', 'A', 'L', '', '17', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('47', 'Dettes affectation rÃsultat - Schulden besteming resultaat', 'H', 'L', '', '47', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('620200', 'EmployÃs - Bedienden', 'A', 'E', '', '62', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('178', 'Cautionnements reÃu en numÃraire - Borgtocht. ontvang. in contanten', 'A', 'L', '', '17', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('179', 'Dettes diverses - Overige schulden', 'A', 'L', '', '17', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('174', 'Autres emprunts - Overige schulden', 'A', 'L', '', '17', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('2', 'CLASSE 2 -- FRAIS D''ETABLISSEMENT, ACTIFS IMMOBILISES, ... - OPRICHTINGSKOSTEN, VASTE ACTIVA, ...', 'H', 'A', '', '', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('20', 'Frais d''Ãtablissement - Oprichtingskosten', 'H', 'A', '', '20', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('200', 'Frais de constitution - Kosten van oprichting', 'A', 'A', '', '20', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('200000', 'Fr. const. acquis. anterieurs - Kost. opricht./kapitaalverhoging', 'A', 'A', '', '20', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('605', 'Achats d''immeubles destinÃs vente - Aankopen onroer. goederen bestemd v. verkoop', 'A', 'E', 'IC_cogs', '60', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('61', 'Services et biens divers', 'H', 'E', '', '61', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('69', 'Affectations et prÃlÃvements', 'H', 'E', '', '69', '0');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('200900', 'Fr. const. amort. anterieur - Afschr. kost. opricht./kap.verh. vorig', 'A', 'A', '', '20', '0');

@@ Diff output truncated at 100000 characters. @@

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
Prev by Date: SF.net SVN: ledger-smb: [850] trunk/sql
Next by Date: SF.net SVN: ledger-smb: [852] trunk/sql
Previous by thread: SF.net SVN: ledger-smb: [850] trunk/sql
Next by thread: SF.net SVN: ledger-smb: [852] trunk/sql
Index(es):
- Date
- Thread