[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb: [852] trunk/sql
- Subject: SF.net SVN: ledger-smb: [852] trunk/sql
- From: ..hidden..
- Date: Mon, 05 Mar 2007 20:16:33 -0800
Revision: 852
http://svn.sourceforge.net/ledger-smb/?rev=852&view=rev
Author: einhverfr
Date: 2007-03-05 20:16:33 -0800 (Mon, 05 Mar 2007)
Log Message:
-----------
Third installment of refactoring of coa files
Added Paths:
-----------
trunk/sql/coa/de/
trunk/sql/coa/de/chart/
trunk/sql/coa/de/chart/DATEV-SKR03.sql
trunk/sql/coa/de/chart/General.sql
trunk/sql/coa/de/chart/SKR03.sql
trunk/sql/coa/de/gifi/
trunk/sql/coa/de/gifi/DATEV-SKR03.sql
trunk/sql/coa/de/gifi/General.sql
trunk/sql/coa/de/gifi/SKR03.sql
trunk/sql/coa/it/
trunk/sql/coa/it/chart/
trunk/sql/coa/it/chart/General.sql
trunk/sql/coa/it/chart/cc2424.sql
trunk/sql/coa/it/gifi/
trunk/sql/coa/it/gifi/General.sql
trunk/sql/coa/it/gifi/cc2424.sql
trunk/sql/coa/lv/
trunk/sql/coa/lv/chart/
trunk/sql/coa/lv/chart/General.sql
trunk/sql/coa/no/
trunk/sql/coa/no/chart/
trunk/sql/coa/no/chart/General.sql
trunk/sql/coa/py/
trunk/sql/coa/py/chart/
trunk/sql/coa/py/chart/General.sql
trunk/sql/coa/py/gifi/
trunk/sql/coa/py/gifi/General.sql
Removed Paths:
-------------
trunk/sql/German-Sample-chart.sql
trunk/sql/German-Sample-gifi.sql
trunk/sql/Germany-DATEV-SKR03-chart.sql
trunk/sql/Germany-DATEV-SKR03-gifi.sql
trunk/sql/Germany-SKR03-chart.sql
trunk/sql/Germany-SKR03-gifi.sql
trunk/sql/Italy-gifi.sql
trunk/sql/Italy_General-chart.sql
trunk/sql/Italy_cc2424-chart.sql
trunk/sql/Latvia-chart.sql
trunk/sql/Norwegian_Default-chart.sql
trunk/sql/Paraguay-chart.sql
trunk/sql/Paraguay-gifi.sql
Deleted: trunk/sql/German-Sample-chart.sql
===================================================================
--- trunk/sql/German-Sample-chart.sql 2007-03-06 03:32:20 UTC (rev 851)
+++ trunk/sql/German-Sample-chart.sql 2007-03-06 04:16:33 UTC (rev 852)
@@ -1,230 +0,0 @@
-begin;
--- Einfacher Deutscher Kontenrahmen => Very Easy German Default Chart
--- Vorbereitet von / Prepared by Paul Tammes May 9th, 2002. Kommentar / Comments : ..hidden..
--- Englische Texte fÃr eigene Zwecke und um Refernz in LedgerSMB Dokumentation zu erleichtern.
--- English terms used mostly for my own reference and to make lookup in LedgerSMB documentation easier.
--- GIFI-codes werden benutzt/misbraucht um die art der Rechnung zu deuten, Fehler nicht ausgeschlossen denn
--- Ich bin kein Deutscher Steuerberater ;-(
--- GIFI field codes re-used for following specs:
--- Link: Achtung, sehr wenig benutzt da mir die Kentnisse zum Deutschen System fehlen. Sehr gut aufpassen und wenn
--- Ihr Fehler oder Praktische TIPS hat: gerne!
--- Link: used to a minimum, update and customization may well be needed!
--- A0 = AnlagevermÃgen / Fixed Assets
--- A1-1 = Warenbestand / Inventory
--- A1-2 = Forderungen / Liabilities
--- A1-3 = Liquide Mittel / Assets
--- A1-4 = Aktive Rechnungsabgrenzung / Closing Account results
--- E = ErtrÃge / Income
--- K0 = Wareneinsatz / COGS
--- K1 = Personalkosten / Salaries etc
--- K2 = Raumkosten / Rental etc
--- K3 = Sonstige Kosten / Various costs
--- NA = Neutrale Aufwendungen / Neutral Costs
--- NE - Neutrale ErlÃse / Neutral Income
--- P0 = Eigenkapital / Equity
--- P1 = RÃckstellungen / Reserves
--- P2 = Fremdkapital Langfristig / Liabilities Long Term
--- P3 = Fremdkapital Kurzfristig / Liabilities Short Term
--- P4 = Passive Rechnungsabgrenzung / Closing Account results
---
--- A0
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0000','ANLAGEVERMÃGEN','H','A0','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0100','Konzessionen & Lizenzen','A','A0','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0135','EDV-Programme','A','A0','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0440','Maschinen','A','A0','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0500','Betriebsausstattung','A','A0','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0520','PKW','A','A0','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0650','BÃroeinrichtung','A','A0','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0670','GWG','A','A0','A','');
--- A1-1
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1100','WARENBESTAND','H','A1-1','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1140','Warenbestand','A','A1-1','A','IC');
--- A1-2
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1200','FORDERUNGEN','H','A1-2','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1201','Geleistete Anzahlungen','A','A1-2','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1210','Forderungen ohne Kontokorrent','A','A1-2','A','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1300','Sonstige Forderungen','A','A1-2','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1400','Anrechenbare Vorsteuer','A','A1-2','A','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1401','Anrechenbare Vorsteuer 7%','A','A1-2','A','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1402','Vorsteuer ig Erwerb','A','A1-2','A','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1403','Vorsteuer ig Erwerb 16%','A','A1-2','A','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1405','Anrechenbare Vorsteuer 16%','A','A1-2','A','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1406','Anrechenbare Vorsteuer 15%','A','A1-2','A','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1433','bezahlte Einfuhrumsatzsteuer','A','A1-2','A','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1370','UngeklÃrte Posten','A','A1-2','A','');
--- A1-3
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1600','LIQUIDE MITTEL','H','A1-3','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1601','Kasse','A','A1-3','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1700','Postgiro','A','A1-3','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1800','Bank','A','A1-3','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1810','Bank USD','A','A1-3','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1820','Kreditkarten','A','A1-3','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1890','Geldtransit','A','A1-3','A','');
--- A1-4
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1900','Aktive Rechnungsabgrenzung','A','A1-4','A','');
--- P0
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2000','EIGENKAPITAL','H','P0','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2001','Eigenkapital','A','P0','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2100','Privatentnahmen','A','P0','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2150','Privatsteuern','A','P0','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2180','Privateinlagen','A','P0','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2200','Sonderausgaben beschr.abzugsf.','A','P0','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2900','Gezeichnetes Kapital','A','P0','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2910','Ausstehende Einlagen','A','P0','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2970','Gewinnvortrag vor Verwendung','A','P0','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2978','Verlustvortrag vor Verwendung','A','P0','Q','');
--- P1
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3000','RÃCKSTELLUNGEN','H','P1','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3030','GewerbesteuerrÃckstellung','A','P1','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3070','Sonstige RÃckstellungen','A','P1','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3095','RÃckstellung fÃr Abschlusskosten','A','P1','L','');
--- P2
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3100','FREMDKAPITAL LANGFRISTIG','H','P2','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3160','Bankdarlehen','A','P2','L','');
--- P3
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3200','FREMDKAPITAL KURZFRISTIG','H','P3','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3280','Erhaltene Anzahlungen','A','P3','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3310','Kreditoren ohne Kontokorrent','A','P3','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3500','Sonstige Verbindlichkeiten','A','P3','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3560','Darlehen','A','P3','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3700','Verbindl. Betr.steuern u.Abgaben','A','P3','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3720','Verbindlichkeiten LÃhne und GehÃlter','A','P3','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3730','Verbindlichkeiten Lohnsteuer','A','P3','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3740','Verbindlichkeiten Sozialversicherung','A','P3','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3800','Umsatzsteuer','A','P3','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3801','Umsatzsteuer 7%','A','P3','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3802','Umsatzsteuer ig. Erwerb','A','P3','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3803','Umsatzsteuer ig. Erwerb 16%','A','P3','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3805','Umsatzsteuer 16%','A','P3','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3806','Umsatzsteuer 15%','A','P3','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3815','Umsatzsteuer nicht fÃllig 16%','A','P3','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3816','Umsatzsteuer nicht fÃllig 15%','A','P3','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3820','Umsatzsteuer-Vorauszahlungen','A','P3','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3841','Umsatzsteuer Vorjahr','A','P3','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
--- P4
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3900','Aktive Rechnungsabgrenzung','A','P4','L','');
--- K0
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5100','WARENEINGANG','H','K0','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5200','Wareneingang ohne Vorsteuer','A','K0','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5300','Wareneingang 7%','A','K0','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5400','Wareneingang 15%','A','K0','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5420','ig.Erwerb 7% VoSt. und 7% USt.','A','K0','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5425','ig.Erwerb 15% VoSt. und 15% USt.','A','K0','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5731','Erhaltene Skonti 7% Vorsteuer','A','K0','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5736','Erhaltene Skonti 15% Vorsteuer','A','K0','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5800','Anschaffungsnebenkosten','A','K0','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5900','Fremdarbeiten','A','K0','E','AP_amount:IC_cogs:IC_expense');
--- K1
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6000','PERSONALKOSTEN','H','K1','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6001','Personalkosten','H','K1','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6010','LÃhne','A','K1','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6020','GehÃlter','A','K1','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6030','AushilfslÃhne','A','K1','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6040','Lohnsteuer Aushilfen','A','K1','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6080','VermÃgenswirksame Leistungen','A','K1','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6090','Fahrtkostenerst.Whg./ArbeitsstÃtte','A','K1','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6110','Sozialversicherung','A','K1','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6120','Berufsgenossenschaft','A','K1','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6130','Freiw. Soz. Aufw. LSt- u. Soz.Vers.frei','A','K1','E','');
--- K2
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6300','RAUMKOSTEN','H','K2','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6310','Miete','A','K2','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6315','Pacht','A','K2','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6320','Heizung','A','K2','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6325','Gas Strom Wasser','A','K2','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6330','Reinigung','A','K2','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6335','Instandhaltung betriebliche RÃume','A','K2','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6345','Sonstige Raumkosten','A','K2','E','AP_amount:IC_expense');
--- K3
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6400','SONSTIGE KOSTEN','H','K3','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6402','Abschreibungen','A','K3','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6403','Kaufleasing','A','K3','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6404','Sofortabschreibung GWG','A','K3','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6405','Sonstige Kosten','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6410','Versicherung','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6420','BeitrÃge und GebÃhren','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6430','Sonstige Abgaben','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6470','Rep. und Instandhaltung BGA','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6520','Kfz-Versicherung','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6530','Lfd. Kfz-Kosten','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6540','Kfz-Reparaturen','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6560','Fremdfahrzeuge','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6570','Sonstige Kfz-Kosten','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6600','Werbung','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6610','Kundengeschenke bis DM 75.','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6620','Kundengeschenke Ãber DM 75.-','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6630','ReprÃsentationkosten','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6640','Bewirtungskosten','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6644','Nicht abzugsf.Bewirtungskosten','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6650','Reisekosten Arbeitnehmer','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6660','Reisekosten Arbeitnehmer 12.3%','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6665','Reisekosten Arbeitnehmer 9.8%','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6670','Reisekosten Unternehmer','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6680','Reisekosten Unternehmer 12.3%','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6685','Reisekosten Unternehmer 9.8%','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6688','Reisekosten Unternehmer 5.7%','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6690','Km-Geld-Erstattung 8.2%','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6710','Verpackungsmaterial','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6740','Ausgangsfrachten','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6780','Fremdarbeiten','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6800','Porto','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6805','Telefon','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6815','BÃrobedarf','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6820','Zeitschriften & BÃcher','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6825','Rechts- und Beratungskosten','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6835','Mieten fÃr Einrichtungen','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6840','Mietleasing','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6845','Werkzeuge und KleingerÃte','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6850','Betriebsbedarf','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6852','GastÃttenbedarf','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6855','Nebenkosten des Geldverkehrs','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6880','Aufwendungen aus Kursdifferenzen','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6885','ErlÃse aus Anlageverk.(Buchverlust)','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7610','Gewerbesteuer','A','K3','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7685','Kfz-Steuer','A','K3','E','AP_amount:IC_cogs:IC_expense');
--- E
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8100','ERTRÃGE','H','E','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8120','Steuerfreie UmsÃtze 4 Nr. 1a UStG.','A','E','I','AR_amount:IC_sale:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8125','Steuerfreie ig. Lieferungen 1b UStG.','A','E','I','AR_amount:IC_sale:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8200','ErlÃse ohne Umsatzsteuer','A','E','I','AR_amount:IC_sale:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8300','ErlÃse 7% Umsatzsteuer','A','E','I','AR_amount:IC_sale:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8400','ErlÃse 15% Umsatzsteuer','A','E','I','AR_amount:IC_sale:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8500','ProvisionserlÃse','A','E','I','AR_amount:IC_sale:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8630','Entnahme sonstg. Leistungen 7% USt.','A','E','I','AR_amount:IC_sale:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8640','Entnahme sonstg. Leistungen 15% USt.','A','E','I','AR_amount:IC_sale:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8731','Gew. Skonti 7% USt.','A','E','I','AR_amount:IC_sale:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8736','Gew. Skonti 15% USt.','A','E','I','AR_amount:IC_sale:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8840','ErtrÃge aus Kursdifferenzen','A','E','I','AR_amount:IC_sale:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8845','ErlÃse aus Anlageverk. (Buchgewinn)','A','E','I','AR_amount:IC_sale:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8900','ErtrÃge aus Abgang von Anlageverm.','A','E','I','AR_amount:IC_sale:IC_income');
--- NA
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9300','NEUTRALE AUFWENDUNGEN','H','NA','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9310','Zinsen kurzfr. Verbindlichkeiten','A','NA','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9320','Zinsen langfr. Verbindlichkeiten','A','NA','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9500','Ausserordentl.Aufwendungen','A','NA','E','');
--- NE
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9600','NEUTRALE ERTRÃGE','H','NE','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9610','Guthabenzinsen','H','NE','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9700','Ausserordentl.ErtrÃge','H','NE','I','');
---
--- Default settings
---
-insert into tax (chart_id,rate) values ((select id from chart where accno = '3801'),0.07);
-insert into tax (chart_id,rate) values ((select id from chart where accno = '3805'),0.16);
-insert into tax (chart_id,rate) values ((select id from chart where accno = '3806'),0.15);
---
-INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1140'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '8120'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5800'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '8840'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '6880'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('curr', 'EUR');
-
- INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
---
-commit;
Deleted: trunk/sql/German-Sample-gifi.sql
===================================================================
--- trunk/sql/German-Sample-gifi.sql 2007-03-06 03:32:20 UTC (rev 851)
+++ trunk/sql/German-Sample-gifi.sql 2007-03-06 04:16:33 UTC (rev 852)
@@ -1,21 +0,0 @@
-begin;
--- Einfacher Kontoplan fÃr Deutschland
---
-INSERT INTO gifi (accno,description) VALUES ('A0', 'AnlagevermÃgen');
-INSERT INTO gifi (accno,description) VALUES ('A1-1', 'Warenbestand');
-INSERT INTO gifi (accno,description) VALUES ('A1-2', 'Forderungen');
-INSERT INTO gifi (accno,description) VALUES ('A1-3', 'Liquide Mittel');
-INSERT INTO gifi (accno,description) VALUES ('A1-4', 'Aktive Rechnungsabgrenzung');
-INSERT INTO gifi (accno,description) VALUES ('E', 'ErtrÃge');
-INSERT INTO gifi (accno,description) VALUES ('K0', 'Wareneinsatz');
-INSERT INTO gifi (accno,description) VALUES ('K1', 'Personalkosten');
-INSERT INTO gifi (accno,description) VALUES ('K2', 'Raumkosten');
-INSERT INTO gifi (accno,description) VALUES ('K3', 'Sonstige Kosten');
-INSERT INTO gifi (accno,description) VALUES ('NA', 'Neutrale Aufwendungen');
-INSERT INTO gifi (accno,description) VALUES ('NE', 'Neutrale ErlÃse');
-INSERT INTO gifi (accno,description) VALUES ('P0', 'Eigenkapital');
-INSERT INTO gifi (accno,description) VALUES ('P1', 'RÃckstellungen');
-INSERT INTO gifi (accno,description) VALUES ('P2', 'Fremdkapital Langfristig');
-INSERT INTO gifi (accno,description) VALUES ('P3', 'Fremdkapital Kurzfristig');
-INSERT INTO gifi (accno,description) VALUES ('P4', 'Passive Rechnungsabgrenzung');
-commit;
Deleted: trunk/sql/Germany-DATEV-SKR03-chart.sql
===================================================================
--- trunk/sql/Germany-DATEV-SKR03-chart.sql 2007-03-06 03:32:20 UTC (rev 851)
+++ trunk/sql/Germany-DATEV-SKR03-chart.sql 2007-03-06 04:16:33 UTC (rev 852)
@@ -1,241 +0,0 @@
-begin;
--- DATEV SKR03
---
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0002700','EDV-Software','A','A','','0002700');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0010000','Fabrikbauten','A','A','','0010000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0011000','Garagen','A','A','','0011000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0011100','AuÃenanlagen','A','A','','0011100');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0011200','Hof-und Wegebefestigung','A','A','','0011200');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0011500','Andere Bauten','A','A','','0011500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0016500','GeschÃftsbauten','A','A','','0016500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0008500','GrundstÃckswert eige.bebau.Grundst.','A','A','','0008500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0009000','GeschÃftsbauten','A','A','','0009000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0016000','Bauten auf fremden GrundstÃcken','H','A','','0016000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0017000','Fabrikbauten','A','A','','0017000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0017500','Garagen','A','A','','0017500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0017600','AuÃenanlage','A','A','','0017600');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0020000','Techn.Anlagen und Maschinen','H','A','','0020000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0021000','Maschinen','A','A','','0021000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0022000','Maschinengebundene Werkzeuge','A','A','','0022000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0024000','Maschinelle Anlagen','A','A','','0024000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0028000','Betriebsvorrichtung','A','A','','0028000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0030000','Andere Anlagen,Betrieb-und GeschÃftsaus','H','A','','0030000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0031000','Andere Anlagen','A','A','','0031000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0032000','PKW','A','A','','0032000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0035000','LKW','A','A','','0035000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0040000','Betriebsausstattung','A','A','','0040000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0041000','GeschÃftsausstattung','A','A','','0041000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0042000','BÃroeinrichtung','A','A','','0042000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0043000','Ladeneinrichtung','A','A','','0043000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0048000','Geringwertige Wirtschaftsg.b.410EUR','A','A','','0048000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0049000','Sons.Betriebs- GeschÃftsausstattung','A','A','','0049000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0050400','Ant.a.herr.o.m.Mehrh.bet.Ges.schaft','A','A','','0050400');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0051300','Typisch stille Beteiligungen','A','A','','0051300');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0063100','- Restlaufzeit bis 1 Jahr','A','L','','0063100');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0051600','Atypische stille Beteiligungen','A','A','','0051600');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0064000','- Restlaufzeit 1 bis 5 Jahre','A','L','','0064000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0065000','- Restlaufzeit grÃÃer als 5 Jahre','A','L','','0065000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0099600','Pauschalwertb.m.Restlaufzeit v. 1J.','A','A','','0099600');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0140000','Ford. a.Lieferungen und Leistungen','A','A','AR','0140000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0080000','Gezeichnetes Kapital','A','Q','','0080000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0150000','Sonstige VermÃgensgegenstÃnde','A','A','','0150000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0153000','Forderungen gegen Personal','A','A','','0153000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0154500','Umsatzsteuerforderungen','A','A','','0154500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0100000','Kasse','A','A','AR_paid:AP_paid','0100000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0120000','Bank','A','A','AR_paid:AP_paid','0120000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0096300','KÃrperschaftssteuerrÃckstellung','A','Q','','0096300');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0095500','SteuerrÃckstellung','A','Q','','0095500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0095700','GewerbesteuerrÃckstellung','A','Q','','0095700');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0080100','Ausst.Einl.a.d.gezeichnete Kapital','A','Q','','0080100');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0084000','KapitalrÃcklage','A','Q','','0084000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0086000','Gewinnvortrag vor Verwendung','A','Q','','0086000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0086900','Vortrag auf neue Rechnungen','A','Q','','0086900');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0000500','Sachanlagen','H','A','','0000500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0050000','Finanzanlagen','H','A','','0050000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0051000','Beteiligungen','A','A','','0051000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0063000','Verbindl.gegenÃber Kreditinstituten','A','L','','0063000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0060000','Verbindlichkeiten','H','L','','0060000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0086800','Verlustvortrag vor Verwendung','A','L','','0086800');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0097000','Sonstige RÃckstellungen','A','L','','0097000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0097400','RÃckstellungen fÃr GewÃhrleistungen','A','L','','0097400');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0097700','RÃcks.f.AbschluÃ-u.PrÃfungskosten','A','L','','0097700');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0097800','AufwandsrÃckstellungen','A','L','','0097800');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0098000','Aktive Rechnungsabgrenzung','A','A','','0098000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0099000','Passive Rechnungsabgrenzung','A','L','','0099000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0099200','Wertberichtigungen','A','A','','0099200');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0099800','Einzelwertber.m.Restlaufzeit v.1 J.','A','A','','0099800');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0146000','Zweifelhafte Forderungen','A','A','','0146000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0151000','Geleistete Anzahlung auf VorrÃte','A','A','','0151000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0151100','Geleistete Anzahlungen 7%','A','A','','0151100');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0151700','Geleistete Anzahlung 16%','A','A','','0151700');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0152500','Kautionen','A','A','','0152500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0154000','SteuerÃberzahlungen','A','A','','0154000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0157000','Abziehbare Vorsteuer','A','A','AR_tax:AP_tax','0157000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0160000','Verbindlichkeiten aus Lief.u.Leist.','A','L','AP','0160000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0174100','Verbindl.a.Lohn-und Kirchensteuer','A','L','','0174100');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0178000','Umsatzsteuer-Vorauszahlungen','A','L','','0178000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0178100','Umsatzsteuer-Vorauszahlung 1/11','A','L','','0178100');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0178900','Umsatzsteuer laufendes Jahr','A','L','','0178900');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0179000','Umsatzsteuer Vorjahr','A','L','','0179000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0179100','Umsatzsteuer frÃhere Jahre','A','L','','0179100');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0180000','Privatentnahme allgemein','A','Q','','0180000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0189000','Privateinlagen','A','Q','','0189000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0210000','Zinsen und Ãhnl.Aufwendungen','A','E','','0210000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0211000','Zinsaufwendung f.kurzf.Verbindlichk','A','E','','0211000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0212000','Zinsaufwendung f.langf.Verbindlichk','A','E','','0212000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0221000','Kapitalertragssteuer','A','E','','0221000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0231000','AnlagenabgÃnge - bei Buchverlust','A','E','','0231000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0231500','AnlagenabgÃnge-Buchgewinn','A','I','','0231500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0237500','Grundsteuer','A','E','','0237500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0245000','Einstell.i.d.Pauschalwertbe.z.Forde','A','E','','0245000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0245100','Einstell.i.d.Einzelwertb.z.Forderun','A','E','','0245100');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0250000','AuÃerordentliche ErtrÃge','A','I','','0250000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0251000','Betriebsfremde ErtrÃge n.auÃerorden','A','I','','0251000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0252000','Periodenfremde ErtrÃge nicht auÃero','A','I','','0252000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0270000','Sonstige ErtrÃge','A','I','','0270000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0272000','Ertr.a.d.Abgang v.Gegens.d.Anlageve','A','I','','0272000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0272500','Ertr.a.d.Abg.v.Gegenst.d.Umlaufverm','A','I','','0272500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0273000','Ertr.a.Herab.d.Pauschal.z.Forderung','A','I','','0273000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0273100','Ertr.a.Herab.d.Einzelw.z.Forderunge','A','I','','0273100');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0273200','Ertr. aus abgeschriebenen Forderung','A','I','','0273200');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0274200','VersicherungsentschÃdigungen','A','I','','0274200');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0286000','Gewinnvortrag nach Verwendung','A','L','','0286000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0286800','Verlustvortrag nach Verwendung','A','L','','0286800');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0286900','Vortrag auf neue Rechnungen','A','L','','0286900');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0375000','Erhaltene Boni 7% Vorsteuer','A','I','','0375000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0376000','Erhaltene Boni 16% Vorsteuer','A','I','','0376000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0380000','Anschaffungsnebenkosten','A','E','IC_cogs:IC_expense','0380000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0383000','Leergut','A','E','IC_cogs:IC_expense','0383000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0385000','ZÃlle und Einfuhrabgaben','A','E','IC_cogs:IC_expense','0385000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0396000','Bestandsver.Roh-,Hilfs-.Betriebs.','A','E','','0396000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0397000','Bestand Roh-,Hilfs-,u.Betriebsstoff','A','A','IC','0397000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0398000','Bestand Waren','A','E','IC','0398000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0399000','Verrechnete Stoffkosten','A','E','IC_cogs:IC_expense','0399000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0400000','Material-und Stoffverbrauch','A','E','IC_cogs:IC_expense','0400000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0410000','LÃhne und GehÃlter','A','E','AP_amount','0410000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0412500','Ehegattengehalt','A','E','AP_amount','0412500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0340000','Wareneingang 16% Vorsteuer','A','E','AP_amount','0340000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0342000','Innergemein.Erwerb 7% VorSt u. Ust','A','E','AP_amount','0342000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0342500','Innergem.Erwerb 16% VorSt u. Ust','A','E','AP_amount','0342500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0373100','Erhaltene Skonti 7% Vorsteuer','A','I','AP_paid','0373100');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0373500','Erhaltene Skonti 16% Vorsteuer','A','I','AP_paid','0373500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0330000','Wareneingang 7% Vorsteuer','A','E','AP_amount','0330000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0413000','Gesetzlich soziale Aufwendungen','A','E','AP_amount','0413000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0413800','BeitrÃge zur Berufsgenossenschaftr','A','E','AP_amount','0413800');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0414500','Freiwillige sozi.Aufw.lohnsteuerfr.','A','E','AP_amount','0414500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0414900','Pauschale Lohnsteuera.sons.BezÃge','A','E','AP_amount','0414900');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0416500','Aufwendung f.Altersversorgung','A','E','AP_amount','0416500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0417000','VermÃgenswirksame Leistungen','A','E','AP_amount','0417000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0420000','Raumkosten','A','E','AP_amount:AP_tax','0420000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0417500','Fahrtkostenerst.Wohnung/ArbeitsstÃt','A','E','AP_amount','0417500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0419000','AushilfslÃhne','A','E','AP_amount','0419000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0419900','Lohnsteuer fÃr Aushilfe','A','E','AP_amount','0419900');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0159000','Durchlaufende Posten','A','A','','0159000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0422000','Pacht','A','E','AP_amount','0422000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0423000','Heizung','A','E','AP_amount','0423000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0424000','Gas,Strom, Wasser','A','E','AP_amount','0424000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0425000','Reinigung','A','E','AP_amount','0425000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0426000','Instandhaltung betrieb.RÃume','A','E','AP_amount','0426000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0428000','Sonstige Raumkosten','A','E','AP_amount','0428000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0432000','Gewerbesteuer','A','E','AP_amount','0432000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0434000','Sonstige Betriebssteuern','A','E','','0434000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0436000','Versicherungen','A','E','','0436000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0438000','BeitrÃge','A','E','','0438000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0439000','Sonstige Abgaben','A','E','AP_amount','0439000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0450000','Fahrzugkosten','A','E','','0450000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0451000','Kfz-Steuer','A','E','','0451000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0452000','Kfz-Versicherungen','A','E','','0452000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0453000','Laufende Kfz-Betriebskosten','A','E','AP_amount','0453000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0454000','Kfz-Reparaturen','A','E','AP_amount','0454000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0455000','Garagenmiete','A','E','AP_amount','0455000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0457000','Fremdfahrzeuge','A','E','AP_amount','0457000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0458000','Sonstige Kfz-Kosten','A','E','AP_amount','0458000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0461000','Werbekosten','A','E','AP_amount','0461000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0463000','Geschenke bis 40 EUR','A','E','AP_amount','0463000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0463500','Geschenke Ãber 40 EUR','A','E','AP_amount','0463500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0464000','ReprÃsentationskosten','A','E','AP_amount','0464000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0465000','Bewirtungskosten','A','E','AP_amount','0465000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0465400','Nicht abzugsfÃhige Bewirtungskosten','A','E','AP_amount','0465400');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0465500','Nicht abzugsfÃhige Betriebsausgaben','A','E','','0465500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0466300','Reisekosten Arbeitn.m.Vorsteuerabzu','A','E','AP_amount','0466300');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0466600','Reisekosten Arbeitn.Ãbernachtungsau','A','E','','0466600');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0466800','Kilometerentgelderstattung Arbeitne','A','E','','0466800');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0467400','Reisekosten Untern.Verpflegungsmehr','A','E','','0467400');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0467600','Reisekosten Untern.Ãbernachtungsauf','A','E','','0467600');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0467800','Kilometererstattungsgeld Unternehme','A','E','','0467800');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0470000','Kosten der Warenabgabe','A','E','IC_cogs','0470000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0471000','Verpackungsmaterial','A','E','IC_cogs','0471000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0473000','Ausgangsfracht','A','E','IC_cogs','0473000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0475000','Transportversicherung','A','E','IC_cogs','0475000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0476000','Verkaufsprovision','A','E','IC_cogs','0476000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0478000','Fremdarbeiten','A','E','IC_cogs','0478000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0479000','Aufwand fÃr GewÃhrleistungen','A','E','','0479000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0480900','Sonstige Reparaturen u.Instandhalt.','A','E','AP_amount','0480900');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0481000','Mietleasing','A','E','AP_amount','0481000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0481500','Kaufleasing','A','E','AP_amount','0481500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0482000','AfA a.Aufw.f.d.Inga.u.Erw.GeschÃfts','A','E','AP_amount','0482000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0482100','AfA a.Aufw.f.d.WÃhrungsumst.a.Euro','A','E','AP_amount','0482100');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0483000','Abschreibungen auf Sachanlagen','A','E','AP_amount','0483000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0485500','Sofortabschreibung GWG','A','E','AP_amount','0485500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0491000','Porto','A','E','AP_amount','0491000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0492000','Telefon','A','E','AP_amount','0492000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0492500','Telefax','A','E','AP_amount','0492500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0493000','BÃrobedarf','A','E','AP_amount','0493000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0494000','Zeitschriften, BÃcher','A','E','AP_amount','0494000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0494500','Fortbildungskosten','A','E','AP_amount','0494500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0494600','Freiwillige Sozialleistungen','A','E','','0494600');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0495000','Rechts- und Beratungskosten','A','E','AP_amount','0495000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0495500','BuchfÃhrungskosten','A','E','AP_amount','0495500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0495700','AbschluÃ- und PrÃfungskosten','A','E','AP_amount','0495700');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0496000','Mieten fÃr Einrichtungen','A','E','AP_amount','0496000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0497000','Nebenkosten des Geldverkehrs','A','E','','0497000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0498000','Betriebsbedarf','A','E','AP_amount','0498000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0498500','Werkzeuge und KleingerÃte','A','E','AP_amount','0498500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0498600','Sonstige Aufwendungen (Ausbuchung)','A','E','AP_amount','0498600');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0700000','Unfertige Erzeu.unfert.Leistungen','A','A','','0700000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0136000','Geldtransit','A','A','','0136000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0705000','Unfertige Erzeugnisse','A','A','IC','0705000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0708000','Unfertige Leistungen','A','A','IC','0708000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0711000','Fertige Erzeugnisse (Bestand)','A','A','IC','0711000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0714000','Waren (Bestand)','A','A','IC','0714000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0873100','GewÃhrte Skonti 7% USt','A','I','AP_paid','0873100');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0873500','GewÃhrte Skonti 16% USt.','A','I','AP_paid','0873500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0875000','GewÃhrte Boni 7% USt.','A','I','','0875000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0876000','GewÃhrte Boni 16% USt.','A','I','','0876000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0882000','ErlÃse aus AnlageverkÃufen 16%Ust','A','I','IC_sale','0882000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0895500','UmsatzsteuervergÃtungen','A','I','','0895500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0890500','Entnahme v. Gegenst.o.USt.','A','I','','0890500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0900000','SaldenvertrÃge,Sachkonten','A','A','','0900000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0900800','SaldenvertrÃge,Debitoren','A','A','','0900800');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0900900','SaldenvertrÃge,Kreditoren','A','L','','0900900');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0266000','ErtrÃge aus Kursdifferenzen','A','I','','0266000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0215000','Aufwendungen aus Kursdifferenzen','A','E','','0215000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0850000','ProvisionserlÃse','A','I','AR_amount:IC_income','0850000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0157100','Abziebare Vorsteuer 7%','A','A','AP_tax','0157100');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0157500','Abziehbare Vorsteuer 16%','A','A','AP_tax:AP_paid','0157500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0177100','Umsatzsteuer 7%','A','L','AR_tax:IC_taxpart:IC_taxservice','0177100');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0177500','Umsatzsteuer 16%','A','L','AR_tax:IC_taxpart:IC_taxservice','0177500');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0830000','ErlÃse 7%USt','A','I','AR_amount:IC_sale:IC_income','0830000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('0840000','ErlÃse 16% USt.','A','I','AR_amount:IC_sale:IC_income','0840000');
-INSERT INTO chart (accno,description,charttype,category,link,gifi_accno) VALUES ('950','RÃckstellungen','H','L','','');
---
-INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '0398000'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '0840000'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '0399000'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '0266000'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '0215000'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('curr', 'EUR:USD');
-
- INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
---
-INSERT INTO tax (chart_id,rate) VALUES ((SELECT id FROM chart WHERE accno = '0157100'),0.07);
-INSERT INTO tax (chart_id,rate) VALUES ((SELECT id FROM chart WHERE accno = '0157500'),0.16);
-INSERT INTO tax (chart_id,rate) VALUES ((SELECT id FROM chart WHERE accno = '0177100'),0.07);
-INSERT INTO tax (chart_id,rate) VALUES ((SELECT id FROM chart WHERE accno = '0177500'),0.16);
-
-commit;
Deleted: trunk/sql/Germany-DATEV-SKR03-gifi.sql
===================================================================
--- trunk/sql/Germany-DATEV-SKR03-gifi.sql 2007-03-06 03:32:20 UTC (rev 851)
+++ trunk/sql/Germany-DATEV-SKR03-gifi.sql 2007-03-06 04:16:33 UTC (rev 852)
@@ -1,552 +0,0 @@
-begin;
--- DATEV SKR03
---
-INSERT INTO gifi (accno,description) VALUES ('0000100', 'Aufwand GeschÃftsbetrieb');
-INSERT INTO gifi (accno,description) VALUES ('0000200', 'Aufwendungen Umstellung a.d.Euro');
-INSERT INTO gifi (accno,description) VALUES ('0001000', 'Konzession,gewerb.Schutzre.u.Werten');
-INSERT INTO gifi (accno,description) VALUES ('0001500', 'Konzessionen');
-INSERT INTO gifi (accno,description) VALUES ('0002700', 'EDV-Software');
-INSERT INTO gifi (accno,description) VALUES ('0003500', 'GeschÃfts-oder Firmenwert');
-INSERT INTO gifi (accno,description) VALUES ('0003800', 'Anzahlungen a.GeschÃft-o.Firmenwert');
-INSERT INTO gifi (accno,description) VALUES ('0003900', 'Anz.a.immaterielle VermÃgsgegenstÃn');
-INSERT INTO gifi (accno,description) VALUES ('0004000', 'Verschmelzungsmehrwert');
-INSERT INTO gifi (accno,description) VALUES ('0005000', 'GrundstÃcke,grundstÃcksgl.Rechte..');
-INSERT INTO gifi (accno,description) VALUES ('0006000', 'GrundstÃcke u.grundstgl.Rech.o.Baut');
-INSERT INTO gifi (accno,description) VALUES ('0008000', 'Bauten a.eig. GrundstÃcken,Grgl.Rec');
-INSERT INTO gifi (accno,description) VALUES ('0008500', 'GrundstÃckswert eige.bebau.Grundst.');
-INSERT INTO gifi (accno,description) VALUES ('0009000', 'GeschÃftsbauten');
-INSERT INTO gifi (accno,description) VALUES ('0010000', 'Fabrikbauten');
-INSERT INTO gifi (accno,description) VALUES ('0011000', 'Garagen');
-INSERT INTO gifi (accno,description) VALUES ('0011100', 'AuÃenanlagen');
-INSERT INTO gifi (accno,description) VALUES ('0011200', 'Hof-und Wegebefestigung');
-INSERT INTO gifi (accno,description) VALUES ('0011500', 'Andere Bauten');
-INSERT INTO gifi (accno,description) VALUES ('0012000', 'GeschÃfts-,Fabrik-,andere Bau.imBau');
-INSERT INTO gifi (accno,description) VALUES ('0012900', 'Anz.GeschÃfts-,Fabrik u. and.Bauten');
-INSERT INTO gifi (accno,description) VALUES ('0015000', 'Wohnbauten im Bau');
-INSERT INTO gifi (accno,description) VALUES ('0016000', 'Bauten auf fremden GrundstÃcken');
-INSERT INTO gifi (accno,description) VALUES ('0016500', 'GeschÃftsbauten');
-INSERT INTO gifi (accno,description) VALUES ('0017000', 'Fabrikbauten');
-INSERT INTO gifi (accno,description) VALUES ('0017500', 'Garagen');
-INSERT INTO gifi (accno,description) VALUES ('0017600', 'AuÃenanlage');
-INSERT INTO gifi (accno,description) VALUES ('0020000', 'Techn.Anlagen und Maschinen');
-INSERT INTO gifi (accno,description) VALUES ('0021000', 'Maschinen');
-INSERT INTO gifi (accno,description) VALUES ('0022000', 'Maschinengebundene Werkzeuge');
-INSERT INTO gifi (accno,description) VALUES ('0024000', 'Maschinelle Anlagen');
-INSERT INTO gifi (accno,description) VALUES ('0028000', 'Betriebsvorrichtung');
-INSERT INTO gifi (accno,description) VALUES ('0029000', 'Techn.Anlagen u.Maschinen im Bau');
-INSERT INTO gifi (accno,description) VALUES ('0029900', 'Anz.a.techn.Anlagen und Maschinen');
-INSERT INTO gifi (accno,description) VALUES ('0030000', 'Andere Anlagen,Betrieb-GeschÃftsaus');
-INSERT INTO gifi (accno,description) VALUES ('0031000', 'Andere Anlagen');
-INSERT INTO gifi (accno,description) VALUES ('0032000', 'PKW');
-INSERT INTO gifi (accno,description) VALUES ('0035000', 'LKW');
-INSERT INTO gifi (accno,description) VALUES ('0040000', 'Betriebsausstattung');
-INSERT INTO gifi (accno,description) VALUES ('0041000', 'GeschÃftsausstattung');
-INSERT INTO gifi (accno,description) VALUES ('0042000', 'BÃroeinrichtung');
-INSERT INTO gifi (accno,description) VALUES ('0043000', 'Ladeneinrichtung');
-INSERT INTO gifi (accno,description) VALUES ('0048000', 'Geringwertige Wirtschaftsg.b.800DM');
-INSERT INTO gifi (accno,description) VALUES ('0049000', 'Sons.Betriebs- GeschÃftsausstattung');
-INSERT INTO gifi (accno,description) VALUES ('0049800', 'And. Anlagen,Betrieb/GeschÃf.im Bau');
-INSERT INTO gifi (accno,description) VALUES ('0049900', 'Anz.and.Anlagen,Betrieb.GeschÃftsau');
-INSERT INTO gifi (accno,description) VALUES ('0050000', 'Anteile a.verb.Unternehmen');
-INSERT INTO gifi (accno,description) VALUES ('0050400', 'Ant.a.herr.o.m.Mehrh.bet.Ges.schaft');
-INSERT INTO gifi (accno,description) VALUES ('0050500', 'Ausleihung an verb.Unternehmen');
-INSERT INTO gifi (accno,description) VALUES ('0051000', 'Beteiligungen');
-INSERT INTO gifi (accno,description) VALUES ('0051300', 'Typisch stille Beteiligungen');
-INSERT INTO gifi (accno,description) VALUES ('0051600', 'Atypische stille Beteiligungen');
-INSERT INTO gifi (accno,description) VALUES ('0052000', 'Ausl.a.Untern.m.BeteiligungsverhÃlt');
-INSERT INTO gifi (accno,description) VALUES ('0052500', 'Wertpapiere des AnlagevermÃgens');
-INSERT INTO gifi (accno,description) VALUES ('0054000', 'Sonstige Ausleihungen');
-INSERT INTO gifi (accno,description) VALUES ('0057000', 'Genossenschaftsan.z.langf.Verbleib');
-INSERT INTO gifi (accno,description) VALUES ('0059500', 'RÃckdeckansp.Lebensvers.langf.Verbl');
-INSERT INTO gifi (accno,description) VALUES ('0060000', 'Anleihen-nicht konvertibel');
-INSERT INTO gifi (accno,description) VALUES ('0063000', 'Verbindl.gegenÃber Kreditinstituten');
-INSERT INTO gifi (accno,description) VALUES ('0070000', 'Verbind.gegenÃber verb.Unternehmern');
-INSERT INTO gifi (accno,description) VALUES ('0071500', 'Verbind.gegen.Untern.m.Beteili.Verh');
-INSERT INTO gifi (accno,description) VALUES ('0073000', 'Verbindlichkeiten gegen. Gesellscha');
-INSERT INTO gifi (accno,description) VALUES ('0076000', 'Darl.typ.stiller Gesellschafter');
-INSERT INTO gifi (accno,description) VALUES ('0078000', 'Partiarische Darlehen');
-INSERT INTO gifi (accno,description) VALUES ('0080000', 'Gezeichnetes Kapital');
-INSERT INTO gifi (accno,description) VALUES ('0080100', 'Ausst.Einl.a.d.gezeichnete Kapital');
-INSERT INTO gifi (accno,description) VALUES ('0084000', 'KapitalrÃcklage');
-INSERT INTO gifi (accno,description) VALUES ('0084600', 'Gesetzliche RÃcklage');
-INSERT INTO gifi (accno,description) VALUES ('0085000', 'RÃcklage fÃr eigene Anteile');
-INSERT INTO gifi (accno,description) VALUES ('0085100', 'SatzungsmÃÃige RÃcklagen');
-INSERT INTO gifi (accno,description) VALUES ('0086000', 'Gewinnvortrag vor Verwendung');
-INSERT INTO gifi (accno,description) VALUES ('0086800', 'Verlustvortrag vor Verwendung');
-INSERT INTO gifi (accno,description) VALUES ('0086900', 'Vortrag auf neue Rechnungen');
-INSERT INTO gifi (accno,description) VALUES ('0087000', 'Festkapital');
-INSERT INTO gifi (accno,description) VALUES ('0088000', 'Variables Kapital');
-INSERT INTO gifi (accno,description) VALUES ('0089000', 'Gesellschafter-Darlehen');
-INSERT INTO gifi (accno,description) VALUES ('0090000', 'Kommandit-Kapital');
-INSERT INTO gifi (accno,description) VALUES ('0091000', 'Verlustausgleichskonto');
-INSERT INTO gifi (accno,description) VALUES ('0092000', 'Gesellschafter-Darlehen');
-INSERT INTO gifi (accno,description) VALUES ('0093000', 'Sonderposten mit RÃcklagenanteil');
-INSERT INTO gifi (accno,description) VALUES ('0093100', 'Sopo m.RÃckl.ant.nach Â6b EstG');
-INSERT INTO gifi (accno,description) VALUES ('0093200', 'Sopo m.RÃckl.ant.Abschn.35 EstR');
-INSERT INTO gifi (accno,description) VALUES ('0093500', 'Sopo aus WÃhrungsumstellung Euro');
-INSERT INTO gifi (accno,description) VALUES ('0094700', 'Sopo m.RÃckl.ant. Â7g Abs.1 EstG');
-INSERT INTO gifi (accno,description) VALUES ('0094800', 'Sopo m.RÃckl.ant. Â7g Abs.3,7 EstG');
-INSERT INTO gifi (accno,description) VALUES ('0095500', 'SteuerrÃckstellung');
-INSERT INTO gifi (accno,description) VALUES ('0095700', 'GewerbesteuerrÃckstellung');
-INSERT INTO gifi (accno,description) VALUES ('0096300', 'KÃrperschaftssteuerrÃckstellung');
-INSERT INTO gifi (accno,description) VALUES ('0096900', 'RÃckstellung fÃr latente Steuern');
-INSERT INTO gifi (accno,description) VALUES ('0097000', 'Sonstige RÃckstellungen');
-INSERT INTO gifi (accno,description) VALUES ('0097400', 'RÃckstellungen fÃr GewÃhrleistungen');
-INSERT INTO gifi (accno,description) VALUES ('0097600', 'RÃcks.f.drohe.Verl.schweb.GeschÃft');
-INSERT INTO gifi (accno,description) VALUES ('0097700', 'RÃcks.f.AbschluÃ-u.PrÃfungskosten');
-INSERT INTO gifi (accno,description) VALUES ('0097800', 'AufwandsrÃckstellungen');
-INSERT INTO gifi (accno,description) VALUES ('0098000', 'Aktive Rechnungsabgrenzung');
-INSERT INTO gifi (accno,description) VALUES ('0098300', 'Abgrenzung aktive latente Steuern');
-INSERT INTO gifi (accno,description) VALUES ('0098600', 'Damnum/Disagio');
-INSERT INTO gifi (accno,description) VALUES ('0099000', 'Passive Rechnungsabgrenzung');
-INSERT INTO gifi (accno,description) VALUES ('0099200', 'Wertberichtigungen');
-INSERT INTO gifi (accno,description) VALUES ('0099600', 'Pauschalwertb.m.Restlaufzeit v. 1J.');
-INSERT INTO gifi (accno,description) VALUES ('0099800', 'Einzelwertber.m.Restlaufzeit v.1 J.');
-INSERT INTO gifi (accno,description) VALUES ('0100000', 'Kasse');
-INSERT INTO gifi (accno,description) VALUES ('0110000', 'Postbank');
-INSERT INTO gifi (accno,description) VALUES ('0120000', 'Bank');
-INSERT INTO gifi (accno,description) VALUES ('0121000', 'Dresdner Bank AG');
-INSERT INTO gifi (accno,description) VALUES ('0121009', 'Verrechnungskonto Dresdner Bank AG');
-INSERT INTO gifi (accno,description) VALUES ('0122000', 'Deutsche Bank AG');
-INSERT INTO gifi (accno,description) VALUES ('0130000', 'Wechsel a. Lieferungen u.Leistungen');
-INSERT INTO gifi (accno,description) VALUES ('0131000', 'Besitzwechsel geg.verb.Unternehmen');
-INSERT INTO gifi (accno,description) VALUES ('0132000', 'Besitzw.geg.Untern.m.Beteiligungsve');
-INSERT INTO gifi (accno,description) VALUES ('0132700', 'Finanzwechsel');
-INSERT INTO gifi (accno,description) VALUES ('0133000', 'Schecks (Eingang)');
-INSERT INTO gifi (accno,description) VALUES ('0133300', 'Schecks (Ausgang)');
-INSERT INTO gifi (accno,description) VALUES ('0133500', 'Ãberweisungen (unterwegs)');
-INSERT INTO gifi (accno,description) VALUES ('0134000', 'Anteile verb.Untern.-UmlaufvermÃgen');
-INSERT INTO gifi (accno,description) VALUES ('0134400', 'Anteil an herr.m.betei.Gesellschaft');
-INSERT INTO gifi (accno,description) VALUES ('0134500', 'Eigene Anteile');
-INSERT INTO gifi (accno,description) VALUES ('0134800', 'Sonstige Wertpapiere');
-INSERT INTO gifi (accno,description) VALUES ('0136000', 'Geldtransit');
-INSERT INTO gifi (accno,description) VALUES ('0136100', 'Geldtransit (Ãberweisungen)');
-INSERT INTO gifi (accno,description) VALUES ('0136200', 'Geldtransit,Bankeinzug/Lastschrift');
-INSERT INTO gifi (accno,description) VALUES ('0136300', 'Scheck / Wechsel');
-INSERT INTO gifi (accno,description) VALUES ('0140000', 'Ford. a.Lieferungen und Leistungen');
-INSERT INTO gifi (accno,description) VALUES ('0141100', 'Forderungssammelkonto Vorausre.');
-INSERT INTO gifi (accno,description) VALUES ('0141200', 'Forderungssammelkonto Anzahlungen');
-INSERT INTO gifi (accno,description) VALUES ('0146000', 'Zweifelhafte Forderungen');
-INSERT INTO gifi (accno,description) VALUES ('0147000', 'Forder.a.Liefe.u.Leis.geg.verb.Unte');
-INSERT INTO gifi (accno,description) VALUES ('0147800', 'Wertb.a.Ford.m.Rest.1j.geg.verb.Unt');
-INSERT INTO gifi (accno,description) VALUES ('0148000', 'Lief.u.Leis.geg.Untern.m.Beteiligve');
-INSERT INTO gifi (accno,description) VALUES ('0148800', 'Wertb.a.Ford.m.Rest.1j.Beteiligungs');
-INSERT INTO gifi (accno,description) VALUES ('0149000', 'Forderung a.Leis.u.Lief.geg.Gesells');
-INSERT INTO gifi (accno,description) VALUES ('0150000', 'Sonstige VermÃgensgegenstÃnde');
-INSERT INTO gifi (accno,description) VALUES ('0150300', 'Forde.geg.Vorstandsm.u.GeschÃftsfÃh');
-INSERT INTO gifi (accno,description) VALUES ('0150800', 'Forderungen gegen Gesellschafter');
-INSERT INTO gifi (accno,description) VALUES ('0151000', 'Geleistete Anzahlung auf VorrÃte');
-INSERT INTO gifi (accno,description) VALUES ('0151100', 'Geleistete Anzahlungen 7%');
-INSERT INTO gifi (accno,description) VALUES ('0151700', 'Geleistete Anzahlung 16%');
-INSERT INTO gifi (accno,description) VALUES ('0152500', 'Kautionen');
-INSERT INTO gifi (accno,description) VALUES ('0153000', 'Forderungen gegen Personal');
-INSERT INTO gifi (accno,description) VALUES ('0154000', 'SteuerÃberzahlungen');
-INSERT INTO gifi (accno,description) VALUES ('0154500', 'Umsatzsteuerforderungen');
-INSERT INTO gifi (accno,description) VALUES ('0154800', 'Vorsteuer im Folgejahr abziehbar');
-INSERT INTO gifi (accno,description) VALUES ('0154900', 'KÃrperschaftsteuerrÃckforderung');
-INSERT INTO gifi (accno,description) VALUES ('0155000', 'Darlehen');
-INSERT INTO gifi (accno,description) VALUES ('0156000', 'Aufzuteilende Vorsteuer');
-INSERT INTO gifi (accno,description) VALUES ('0156500', 'Aufzuteilende Vorsteuer 16%');
-INSERT INTO gifi (accno,description) VALUES ('0157000', 'Abziehbare Vorsteuer');
-INSERT INTO gifi (accno,description) VALUES ('0157100', 'Abziebare Vorsteuer 7%');
-INSERT INTO gifi (accno,description) VALUES ('0157200', 'Abziehb. VorSt innergemein. Erwerb');
-INSERT INTO gifi (accno,description) VALUES ('0157300', 'Abziehb.VorSt. innergem.Erwerb 16%');
-INSERT INTO gifi (accno,description) VALUES ('0157500', 'Abziehbare Vorsteuer 16%');
-INSERT INTO gifi (accno,description) VALUES ('0157800', 'Berichtigung d.Vorstabzugs frÃh.J.');
-INSERT INTO gifi (accno,description) VALUES ('0157900', 'Vorsteuer 0%');
-INSERT INTO gifi (accno,description) VALUES ('0158400', 'abziehb.VorSt IG Erwerb Neufahrzeug');
-INSERT INTO gifi (accno,description) VALUES ('0158800', 'Bezahlte Einfuhrumsatzsteuer');
-INSERT INTO gifi (accno,description) VALUES ('0159000', 'Durchlaufende Posten');
-INSERT INTO gifi (accno,description) VALUES ('0159400', 'Forderungen geg. verb. Unternehmen');
-INSERT INTO gifi (accno,description) VALUES ('0159700', 'Ford.geg.Untern.m.Beteiligungsverh.');
-INSERT INTO gifi (accno,description) VALUES ('0160000', 'Verbindlichkeiten aus Lief.u.Leist.');
-INSERT INTO gifi (accno,description) VALUES ('0160100', 'Verbindlichkeiten a.Lief.und Leist.');
-INSERT INTO gifi (accno,description) VALUES ('0163000', 'Verbindl.Lief.u.Leist.gegÃ.verb.Unt');
-INSERT INTO gifi (accno,description) VALUES ('0164000', 'Verb.L.u.L gegÃ.Unter.Beteiligungsv');
-INSERT INTO gifi (accno,description) VALUES ('0165000', 'Verb.L.u.L gegÃ.Gesellschaftern');
-INSERT INTO gifi (accno,description) VALUES ('0166000', 'Schuldwechsel');
-INSERT INTO gifi (accno,description) VALUES ('0170000', 'Sonstige Verbindlichkeiten');
-INSERT INTO gifi (accno,description) VALUES ('0170500', 'Darlehen');
-INSERT INTO gifi (accno,description) VALUES ('0170900', 'GewinnverfÃgungskonto stiller Ges.');
-INSERT INTO gifi (accno,description) VALUES ('0171000', 'Erhaltene Anzahlungen-Verbindlichke');
-INSERT INTO gifi (accno,description) VALUES ('0171100', 'Erhaltene,versteuert Anzahlungen 7%');
-INSERT INTO gifi (accno,description) VALUES ('0171700', 'Erhaltene,versteuerte Anzahl. 16%');
-INSERT INTO gifi (accno,description) VALUES ('0171900', 'Erhaltene Anzahlungen bis 1j.');
-INSERT INTO gifi (accno,description) VALUES ('0172200', 'Erhaltene Anzahlung');
-INSERT INTO gifi (accno,description) VALUES ('0172300', 'Verbindlichkeiten S-konto Vorausre.');
-INSERT INTO gifi (accno,description) VALUES ('0173200', 'Erhaltene Kautionen');
-INSERT INTO gifi (accno,description) VALUES ('0174100', 'Verbindl.a.Lohn-und Kirchensteuer');
-INSERT INTO gifi (accno,description) VALUES ('0175500', 'Lohn-und Gehaltsverrechnung');
-INSERT INTO gifi (accno,description) VALUES ('0175800', 'USt-Abzugsverfahren 16%');
-INSERT INTO gifi (accno,description) VALUES ('0175900', 'Ust 0%');
-INSERT INTO gifi (accno,description) VALUES ('0176000', 'Umsatzsteuer nicht fÃllig');
-INSERT INTO gifi (accno,description) VALUES ('0176100', 'Umsatzsteuer nicht fÃllig 7%');
-INSERT INTO gifi (accno,description) VALUES ('0176200', 'Umsatzsteuer nicht fÃllig EG Lief.');
-INSERT INTO gifi (accno,description) VALUES ('0177000', 'Umsatzsteuer');
-INSERT INTO gifi (accno,description) VALUES ('0177100', 'Umsatzsteuer 7%');
-INSERT INTO gifi (accno,description) VALUES ('0177200', 'Umsatzsteuer aus innergem. Erwerb');
-INSERT INTO gifi (accno,description) VALUES ('0177300', 'Umsatzsteuer innergem.Erwerb 16%');
-INSERT INTO gifi (accno,description) VALUES ('0177500', 'Umsatzsteuer 16%');
-INSERT INTO gifi (accno,description) VALUES ('0177700', 'Ust aus im Inland stpfl. EG-Lief16%');
-INSERT INTO gifi (accno,description) VALUES ('0178000', 'Umsatzsteuer-Vorauszahlungen');
-INSERT INTO gifi (accno,description) VALUES ('0178100', 'Umsatzsteuer-Vorauszahlung 1/11');
-INSERT INTO gifi (accno,description) VALUES ('0178300', 'In Rechn unberecht.ausgew.gesch Ust');
-INSERT INTO gifi (accno,description) VALUES ('0178400', 'Ust IG Erwerb Neufahrzeug o.Ust ID');
-INSERT INTO gifi (accno,description) VALUES ('0178800', 'Einfuhrumsatzsteuer augeschoben bis');
-INSERT INTO gifi (accno,description) VALUES ('0178900', 'Umsatzsteuer laufendes Jahr');
-INSERT INTO gifi (accno,description) VALUES ('0179000', 'Umsatzsteuer Vorjahr');
-INSERT INTO gifi (accno,description) VALUES ('0179100', 'Umsatzsteuer frÃhere Jahre');
-INSERT INTO gifi (accno,description) VALUES ('0179200', 'Sonstige Verrechnungskonten');
-INSERT INTO gifi (accno,description) VALUES ('0180000', 'Privatentnahme allgemein');
-INSERT INTO gifi (accno,description) VALUES ('0181000', 'Privatsteuern');
-INSERT INTO gifi (accno,description) VALUES ('0189000', 'Privateinlagen');
-INSERT INTO gifi (accno,description) VALUES ('0200000', 'AuÃerordentliche Aufwendung');
-INSERT INTO gifi (accno,description) VALUES ('0201000', 'Betriebsfremde Aufwendungen');
-INSERT INTO gifi (accno,description) VALUES ('0202000', 'Periodenfremde Aufwendungen');
-INSERT INTO gifi (accno,description) VALUES ('0210000', 'Zinsen und Ãhnl.Aufwendungen');
-INSERT INTO gifi (accno,description) VALUES ('0210300', 'Steuerl.abzugsfÃhig,and.Nebenl.Steu');
-INSERT INTO gifi (accno,description) VALUES ('0210400', 'Steuerl.nicht.abzugsf.ande.Nl.z.Ste');
-INSERT INTO gifi (accno,description) VALUES ('0210700', 'Zinsaufwendung-betriebliche Steuern');
-INSERT INTO gifi (accno,description) VALUES ('0210800', 'Zinsaufwendung-Personsteuer');
-INSERT INTO gifi (accno,description) VALUES ('0210900', 'Zinsaufwendungen an verb.Unternehm.');
-INSERT INTO gifi (accno,description) VALUES ('0211000', 'Zinsaufwendung f.kurzf.Verbindlichk');
-INSERT INTO gifi (accno,description) VALUES ('0212000', 'Zinsaufwendung f.langf.Verbindlichk');
-INSERT INTO gifi (accno,description) VALUES ('0213000', 'Diskontaufwendung');
-INSERT INTO gifi (accno,description) VALUES ('0215000', 'Aufwendungen aus Kursdifferenzen');
-INSERT INTO gifi (accno,description) VALUES ('0216500', 'Aufw.a.d.WÃhrungsumstell.a.d.Euro');
-INSERT INTO gifi (accno,description) VALUES ('0217000', 'Nicht abziehbare Vorsteuer');
-INSERT INTO gifi (accno,description) VALUES ('0217100', 'Nicht abziehbare Vorsteuer 7%');
-INSERT INTO gifi (accno,description) VALUES ('0217500', 'Nicht abziehbare Vorsteuer 16%');
-INSERT INTO gifi (accno,description) VALUES ('0220000', 'KÃrperschaftssteuer');
-INSERT INTO gifi (accno,description) VALUES ('0220300', 'KÃrperschaftssteuer fÃr Vorjahr');
-INSERT INTO gifi (accno,description) VALUES ('0220500', 'Anrechb.KÃrperschaftsst.vereinn.Kap');
-INSERT INTO gifi (accno,description) VALUES ('0220800', 'SolidaritÃtszuschlag');
-INSERT INTO gifi (accno,description) VALUES ('0220900', 'SolidaritÃtszuschlag fÃr Vorjahr');
-INSERT INTO gifi (accno,description) VALUES ('0221000', 'Kapitalertragssteuer');
-INSERT INTO gifi (accno,description) VALUES ('0221300', 'Anrechb.SolidaritÃtszusch.a.Zinsabs');
-INSERT INTO gifi (accno,description) VALUES ('0221500', 'Zinsabschlagsteuer');
-INSERT INTO gifi (accno,description) VALUES ('0221800', 'Anrechb.Solidari.zuschlag a.Zinsabs');
-INSERT INTO gifi (accno,description) VALUES ('0228000', 'Stnachzahl.Vorj.v.Einkomm u.Ertrag');
-INSERT INTO gifi (accno,description) VALUES ('0228200', 'Sterstat.Vorj.Steuer v.Eink.u.Ertrag');
-INSERT INTO gifi (accno,description) VALUES ('0228400', 'Ertr.a.d.Aufl.v.RÃcks.f.St.v.Ein.Er');
-INSERT INTO gifi (accno,description) VALUES ('0228500', 'Steuernachzahlung Vorj.f.sons.Steue');
-INSERT INTO gifi (accno,description) VALUES ('0228700', 'Steuererstattung Vorj.f.sons.Steuer');
-INSERT INTO gifi (accno,description) VALUES ('0228900', 'ErtrÃge a.d.Aufl.v. RÃck.f.sons.Ste');
-INSERT INTO gifi (accno,description) VALUES ('0230000', 'Sonstige Aufwendungen');
-INSERT INTO gifi (accno,description) VALUES ('0231000', 'AnlagenabgÃnge - bei Buchverlust');
-INSERT INTO gifi (accno,description) VALUES ('0231500', 'AnlagenabgÃnge-Buchgewinn');
-INSERT INTO gifi (accno,description) VALUES ('0232000', 'Verluste Abgang Gegenst.d.Anlagever');
-INSERT INTO gifi (accno,description) VALUES ('0232500', 'Verlust a.d.Abg.v.Gegens.d.Umlaufve');
-INSERT INTO gifi (accno,description) VALUES ('0234000', 'Einstellungen Sopo m.RÃckanlageant.');
-INSERT INTO gifi (accno,description) VALUES ('0234500', 'Einstellungen Sopo m.R.(Sonderafa)');
-INSERT INTO gifi (accno,description) VALUES ('0237500', 'Grundsteuer');
-INSERT INTO gifi (accno,description) VALUES ('0240000', 'Forderungsverlust-Ãbliche HÃhe');
-INSERT INTO gifi (accno,description) VALUES ('0241000', 'Einstellungen Sopo m.RÃckl.(Â7g )');
-INSERT INTO gifi (accno,description) VALUES ('0243000', 'Forderungsverluste-unÃblich hoch');
-INSERT INTO gifi (accno,description) VALUES ('0245000', 'Einstell.i.d.Pauschalwertbe.z.Forde');
-INSERT INTO gifi (accno,description) VALUES ('0245100', 'Einstell.i.d.Einzelwertb.z.Forderun');
-INSERT INTO gifi (accno,description) VALUES ('0249000', 'Aufwendung aus VerlustÃbernahme');
-INSERT INTO gifi (accno,description) VALUES ('0249200', 'Abgef.Gewinn aufgr.e.Gewinngemeinsc');
-INSERT INTO gifi (accno,description) VALUES ('0249300', 'Abgef.Gewinnant.an stille Gesellsch');
-INSERT INTO gifi (accno,description) VALUES ('0249500', 'Einst.KapitalrÃckl.n.Vorschr.vere.K');
-INSERT INTO gifi (accno,description) VALUES ('0249600', 'Einstellungen in die gesetzl.RÃckla');
-INSERT INTO gifi (accno,description) VALUES ('0250000', 'AuÃerordentliche ErtrÃge');
-INSERT INTO gifi (accno,description) VALUES ('0251000', 'Betriebsfremde ErtrÃge n.auÃerorden');
-INSERT INTO gifi (accno,description) VALUES ('0252000', 'Periodenfremde ErtrÃge nicht auÃero');
-INSERT INTO gifi (accno,description) VALUES ('0260000', 'ErtrÃge aus Beteiligten');
-INSERT INTO gifi (accno,description) VALUES ('0261700', 'Gewinn a.Anteila.nicht stbef.Kapita');
-INSERT INTO gifi (accno,description) VALUES ('0261900', 'ErtrÃge a.Beteil.a.verb.UntÃrnehmer');
-INSERT INTO gifi (accno,description) VALUES ('0262000', 'ErtrÃge a.anderen Wertp u.Ausl.Fina');
-INSERT INTO gifi (accno,description) VALUES ('0265000', 'Sonstige Zinsen und Ãhnliche ErtrÃge');
-INSERT INTO gifi (accno,description) VALUES ('0265700', 'ZinsertrÃge-betriebliche Steuern');
-INSERT INTO gifi (accno,description) VALUES ('0265800', 'ZinsertrÃge-KÃrperschaftssteuer');
-INSERT INTO gifi (accno,description) VALUES ('0265900', 'Sons.Zinsen u.Ãhl.Ertr.a.verb.Unter');
-INSERT INTO gifi (accno,description) VALUES ('0266000', 'ErtrÃge aus Kursdifferenzen');
-INSERT INTO gifi (accno,description) VALUES ('0266500', 'ErtrÃge a.d.WÃhrungumst.a.d. Euro');
-INSERT INTO gifi (accno,description) VALUES ('0267000', 'DiskonertrÃge');
-INSERT INTO gifi (accno,description) VALUES ('0270000', 'Sonstige ErtrÃge');
-INSERT INTO gifi (accno,description) VALUES ('0270500', 'Sons.ErtrÃge betrieb. u. regelmÃÃig');
-INSERT INTO gifi (accno,description) VALUES ('0271000', 'Ertrag a.d.Zuschreib.d.AnlagevermÃg');
-INSERT INTO gifi (accno,description) VALUES ('0271500', 'Ertr.a.Zuschreib.d.UmlaufvermÃgens');
-INSERT INTO gifi (accno,description) VALUES ('0272000', 'Ertr.a.d.Abgang v.Gegens.d.Anlageve');
-INSERT INTO gifi (accno,description) VALUES ('0272500', 'Ertr.a.d.Abg.v.Gegenst.d.Umlaufverm');
-INSERT INTO gifi (accno,description) VALUES ('0273000', 'Ertr.a.Herab.d.Pauschal.z.Forderung');
-INSERT INTO gifi (accno,description) VALUES ('0273100', 'Ertr.a.Herab.d.Einzelw.z.Forderunge');
-INSERT INTO gifi (accno,description) VALUES ('0273200', 'Ertr. aus abgeschriebenen Forderung');
-INSERT INTO gifi (accno,description) VALUES ('0273500', 'Ertr.a.d.AuflÃsung v.RÃckstellungen');
-INSERT INTO gifi (accno,description) VALUES ('0273600', 'Ertr.a.d.steuerl.niedrig.Bewertung');
-INSERT INTO gifi (accno,description) VALUES ('0273700', 'Ertr.a.d..Aufl.v.Sonderp.m.RÃcklage');
-INSERT INTO gifi (accno,description) VALUES ('0273800', 'Ertr.a.d.Aufl.v.Sopo.m.RÃcklageant.');
-INSERT INTO gifi (accno,description) VALUES ('0273900', 'ErtrÃge Aufl. Sopo m.R.(Ansparafa)');
-INSERT INTO gifi (accno,description) VALUES ('0274000', 'ErtrÃge AuflÃsung Sopo (stfreie RÃ)');
-INSERT INTO gifi (accno,description) VALUES ('0274100', 'Ertr.a.d.Aufl.v.Sonderp.m.RÃcklagen');
-INSERT INTO gifi (accno,description) VALUES ('0274200', 'VersicherungsentschÃdigungen');
-INSERT INTO gifi (accno,description) VALUES ('0274300', 'InvestitionszuschÃsse-steuerpflicht');
-INSERT INTO gifi (accno,description) VALUES ('0274400', 'Investitionszulage-steuerfrei');
-INSERT INTO gifi (accno,description) VALUES ('0274500', 'ErtrÃge aus Kapitalherabsetzung');
-INSERT INTO gifi (accno,description) VALUES ('0279000', 'ErtrÃge aus VerlustÃbernahme');
-INSERT INTO gifi (accno,description) VALUES ('0279200', 'Erhalt.Gewinne aufgr.e.Gewinngemein');
-INSERT INTO gifi (accno,description) VALUES ('0279400', 'Erhalt.Gewinn aufgr.e.GAV-TeilGAV');
-INSERT INTO gifi (accno,description) VALUES ('0279500', 'Entnahme aus der KapitalrÃcklage');
-INSERT INTO gifi (accno,description) VALUES ('0279600', 'Entnahme a.d. gesetzlichen RÃcklage');
-INSERT INTO gifi (accno,description) VALUES ('0286000', 'Gewinnvortrag nach Verwendung');
-INSERT INTO gifi (accno,description) VALUES ('0286800', 'Verlustvortrag nach Verwendung');
-INSERT INTO gifi (accno,description) VALUES ('0286900', 'Vortrag auf neue Rechnungen');
-INSERT INTO gifi (accno,description) VALUES ('0287000', 'VorabausschÃttung');
-INSERT INTO gifi (accno,description) VALUES ('0289200', 'Verrechnete kalkulatorische Zinsen');
-INSERT INTO gifi (accno,description) VALUES ('0289300', 'Verrechnete kalkulatorische AfA');
-INSERT INTO gifi (accno,description) VALUES ('0299000', 'Aufwendung/ErtrÃge Umrechnungsdiff');
-INSERT INTO gifi (accno,description) VALUES ('0300000', 'Roh,-Hilfs,-und Betriebsstoffe');
-INSERT INTO gifi (accno,description) VALUES ('0309000', 'Energiestoffe (Fertigung)');
-INSERT INTO gifi (accno,description) VALUES ('0310000', 'Fremdleistungen');
-INSERT INTO gifi (accno,description) VALUES ('0315000', 'Leist.v.auslÃnd.Untern.(0-Regelung)');
-INSERT INTO gifi (accno,description) VALUES ('0320000', 'Wareneingang');
-INSERT INTO gifi (accno,description) VALUES ('0330000', 'Wareneingang 7% Vorsteuer');
-INSERT INTO gifi (accno,description) VALUES ('0340000', 'Wareneingang 16% Vorsteuer');
-INSERT INTO gifi (accno,description) VALUES ('0342000', 'Innergemein.Erwerb 7% VorSt u. Ust');
-INSERT INTO gifi (accno,description) VALUES ('0342500', 'Innergem.Erwerb 16% VorSt u. Ust');
-INSERT INTO gifi (accno,description) VALUES ('0355000', 'Steuerfreier innergem.Erwerb');
-INSERT INTO gifi (accno,description) VALUES ('0360000', 'Nicht abziehbare Vorsteuer');
-INSERT INTO gifi (accno,description) VALUES ('0370000', 'NachlÃsse');
-INSERT INTO gifi (accno,description) VALUES ('0371000', 'NachlÃsse 7% Vorsteuer');
-INSERT INTO gifi (accno,description) VALUES ('0372000', 'NachlÃsse 16% Vorsteuer');
-INSERT INTO gifi (accno,description) VALUES ('0373000', 'Erhaltene Skonti');
-INSERT INTO gifi (accno,description) VALUES ('0373100', 'Erhaltene Skonti 7% Vorsteuer');
-INSERT INTO gifi (accno,description) VALUES ('0373500', 'Erhaltene Skonti 16% Vorsteuer');
-INSERT INTO gifi (accno,description) VALUES ('0374000', 'Erhaltene Boni');
-INSERT INTO gifi (accno,description) VALUES ('0375000', 'Erhaltene Boni 7% Vorsteuer');
-INSERT INTO gifi (accno,description) VALUES ('0376000', 'Erhaltene Boni 16% Vorsteuer');
-INSERT INTO gifi (accno,description) VALUES ('0377000', 'Erhaltene Rabatte');
-INSERT INTO gifi (accno,description) VALUES ('0378000', 'Erhaltene Rabatte 7% Vorsteuer');
-INSERT INTO gifi (accno,description) VALUES ('0379000', 'Erhaltene Rabatte 16% Vorsteuer');
-INSERT INTO gifi (accno,description) VALUES ('0380000', 'Anschaffungsnebenkosten');
-INSERT INTO gifi (accno,description) VALUES ('0383000', 'Leergut');
-INSERT INTO gifi (accno,description) VALUES ('0385000', 'ZÃlle und Einfuhrabgaben');
-INSERT INTO gifi (accno,description) VALUES ('0396000', 'Bestandsver.Roh-,Hilfs-.Betriebs.');
-INSERT INTO gifi (accno,description) VALUES ('0397000', 'Bestand Roh-,Hilfs-,u.Betriebsstoff');
-INSERT INTO gifi (accno,description) VALUES ('0398000', 'Bestand Waren');
-INSERT INTO gifi (accno,description) VALUES ('0399000', 'Verrechnete Stoffkosten');
-INSERT INTO gifi (accno,description) VALUES ('0400000', 'Material-und Stoffverbrauch');
-INSERT INTO gifi (accno,description) VALUES ('0410000', 'LÃhne und GehÃlter');
-INSERT INTO gifi (accno,description) VALUES ('0412400', 'GeschÃftsfÃhr.gehÃlter GmbH-Gesell.');
-INSERT INTO gifi (accno,description) VALUES ('0412500', 'Ehegattengehalt');
-INSERT INTO gifi (accno,description) VALUES ('0412600', 'Tantiemen');
-INSERT INTO gifi (accno,description) VALUES ('0412700', 'GeschÃftsfÃhrergehÃlter');
-INSERT INTO gifi (accno,description) VALUES ('0412800', 'VergÃtung a.angestellte Mitunterneh');
-INSERT INTO gifi (accno,description) VALUES ('0413000', 'Gesetzlich soziale Aufwendungen');
-INSERT INTO gifi (accno,description) VALUES ('0413700', 'Gesetz.sozi.Aufw.f.Mitunternehmen');
-INSERT INTO gifi (accno,description) VALUES ('0413800', 'BeitrÃge zur Berufsgenossenschaftr');
-INSERT INTO gifi (accno,description) VALUES ('0414500', 'Freiwillige sozi.Aufw.lohnsteuerfr.');
-INSERT INTO gifi (accno,description) VALUES ('0414900', 'Pauschale Lohnsteuera.sons.BezÃge');
-INSERT INTO gifi (accno,description) VALUES ('0415000', 'KrankengeldzuschÃsse');
-INSERT INTO gifi (accno,description) VALUES ('0416000', 'Versorgungskasse');
-INSERT INTO gifi (accno,description) VALUES ('0416500', 'Aufwendung f.Altersversorgung');
-INSERT INTO gifi (accno,description) VALUES ('0417000', 'VermÃgenswirksame Leistungen');
-INSERT INTO gifi (accno,description) VALUES ('0417500', 'Fahrtkostenerst.Wohnung/ArbeitsstÃt');
-INSERT INTO gifi (accno,description) VALUES ('0419000', 'AushilfslÃhne');
-INSERT INTO gifi (accno,description) VALUES ('0419900', 'Lohnsteuer fÃr Aushilfe');
-INSERT INTO gifi (accno,description) VALUES ('0420000', 'Raumkosten');
-INSERT INTO gifi (accno,description) VALUES ('0421000', 'Miete');
-INSERT INTO gifi (accno,description) VALUES ('0422000', 'Pacht');
-INSERT INTO gifi (accno,description) VALUES ('0423000', 'Heizung');
-INSERT INTO gifi (accno,description) VALUES ('0424000', 'Gas,Strom, Wasser');
-INSERT INTO gifi (accno,description) VALUES ('0425000', 'Reinigung');
-INSERT INTO gifi (accno,description) VALUES ('0426000', 'Instandhaltung betrieb.RÃume');
-INSERT INTO gifi (accno,description) VALUES ('0427000', 'Abgaben f.betrieb.genutz.GrundstÃck');
-INSERT INTO gifi (accno,description) VALUES ('0428000', 'Sonstige Raumkosten');
-INSERT INTO gifi (accno,description) VALUES ('0430000', 'Nicht abziehbare Vorsteuer');
-INSERT INTO gifi (accno,description) VALUES ('0430100', 'Nicht abziehbare Vorsteuer 7%');
-INSERT INTO gifi (accno,description) VALUES ('0430500', 'Nicht abziehbare Vorsteuer 16%');
-INSERT INTO gifi (accno,description) VALUES ('0432000', 'Gewerbesteuer');
-INSERT INTO gifi (accno,description) VALUES ('0434000', 'Sonstige Betriebssteuern');
-INSERT INTO gifi (accno,description) VALUES ('0435000', 'Verbrauchssteuer');
-INSERT INTO gifi (accno,description) VALUES ('0435500', 'Ãkosteuer');
-INSERT INTO gifi (accno,description) VALUES ('0436000', 'Versicherungen');
-INSERT INTO gifi (accno,description) VALUES ('0437000', 'NettoprÃ.f.RÃckd.kÃnf.Versorgungsle');
-INSERT INTO gifi (accno,description) VALUES ('0438000', 'BeitrÃge');
-INSERT INTO gifi (accno,description) VALUES ('0439000', 'Sonstige Abgaben');
-INSERT INTO gifi (accno,description) VALUES ('0439600', 'Steuerl.abzugs.VerspÃ.u.Zwangsgelde');
-INSERT INTO gifi (accno,description) VALUES ('0450000', 'Fahrzugkosten');
-INSERT INTO gifi (accno,description) VALUES ('0451000', 'Kfz-Steuer');
-INSERT INTO gifi (accno,description) VALUES ('0452000', 'Kfz-Versicherungen');
-INSERT INTO gifi (accno,description) VALUES ('0453000', 'Laufende Kfz-Betriebskosten');
-INSERT INTO gifi (accno,description) VALUES ('0454000', 'Kfz-Reparaturen');
-INSERT INTO gifi (accno,description) VALUES ('0455000', 'Garagenmiete');
-INSERT INTO gifi (accno,description) VALUES ('0457000', 'Fremdfahrzeuge');
-INSERT INTO gifi (accno,description) VALUES ('0458000', 'Sonstige Kfz-Kosten');
-INSERT INTO gifi (accno,description) VALUES ('0460000', 'Werbe-und Reisekosten');
-INSERT INTO gifi (accno,description) VALUES ('0461000', 'Werbekosten');
-INSERT INTO gifi (accno,description) VALUES ('0463000', 'Geschenke bis 75 DM');
-INSERT INTO gifi (accno,description) VALUES ('0463500', 'Geschenke bis 75 DM');
-INSERT INTO gifi (accno,description) VALUES ('0463800', 'Geschenke ausschlieÃl.betrieb.genut');
-INSERT INTO gifi (accno,description) VALUES ('0464000', 'ReprÃsentationskosten');
-INSERT INTO gifi (accno,description) VALUES ('0465000', 'Bewirtungskosten');
-INSERT INTO gifi (accno,description) VALUES ('0465300', 'Aufmerksamkeiten');
-INSERT INTO gifi (accno,description) VALUES ('0465400', 'Nicht abzugsfÃhige Bewirtungskosten');
-INSERT INTO gifi (accno,description) VALUES ('0465500', 'Nicht abzugsfÃhige Betriebsausgaben');
-INSERT INTO gifi (accno,description) VALUES ('0466000', 'Reisekosten Arbeitnehmer');
-INSERT INTO gifi (accno,description) VALUES ('0466300', 'Reisekosten Arbeitn.m.Vorsteuerabzu');
-INSERT INTO gifi (accno,description) VALUES ('0466400', 'Reisekosten Arbeitn.Verpflegungmehr');
-INSERT INTO gifi (accno,description) VALUES ('0466600', 'Reisekosten Arbeitn.Ãbernachtungsau');
-INSERT INTO gifi (accno,description) VALUES ('0466800', 'Kilometerentgelderstattung Arbeitne');
-INSERT INTO gifi (accno,description) VALUES ('0467000', 'Reisekosten Unternehmer');
-INSERT INTO gifi (accno,description) VALUES ('0467400', 'Reisekosten Untern.Verpflegungsmehr');
-INSERT INTO gifi (accno,description) VALUES ('0467600', 'Reisekosten Untern.Ãbernachtungsauf');
-INSERT INTO gifi (accno,description) VALUES ('0467800', 'Kilometererstattungsgeld Unternehme');
-INSERT INTO gifi (accno,description) VALUES ('0470000', 'Kosten der Warenabgabe');
-INSERT INTO gifi (accno,description) VALUES ('0471000', 'Verpackungsmaterial');
-INSERT INTO gifi (accno,description) VALUES ('0473000', 'Ausgangsfracht');
-INSERT INTO gifi (accno,description) VALUES ('0475000', 'Transportversicherung');
-INSERT INTO gifi (accno,description) VALUES ('0476000', 'Verkaufsprovision');
-INSERT INTO gifi (accno,description) VALUES ('0478000', 'Fremdarbeiten');
-INSERT INTO gifi (accno,description) VALUES ('0479000', 'Aufwand fÃr GewÃhrleistungen');
-INSERT INTO gifi (accno,description) VALUES ('0480900', 'Sonstige Reparaturen u.Instandhalt.');
-INSERT INTO gifi (accno,description) VALUES ('0481000', 'Mietleasing');
-INSERT INTO gifi (accno,description) VALUES ('0481500', 'Kaufleasing');
-INSERT INTO gifi (accno,description) VALUES ('0482000', 'AfA a.Aufw.f.d.Inga.u.Erw.GeschÃfts');
-INSERT INTO gifi (accno,description) VALUES ('0482100', 'AfA a.Aufw.f.d.WÃhrungsumst.a.Euro');
-INSERT INTO gifi (accno,description) VALUES ('0482200', 'Abschreibungen a.immat.VermÃgensgeg');
-INSERT INTO gifi (accno,description) VALUES ('0482400', 'Abschreibung a.d.GeschÃft-o.Firmenw');
-INSERT INTO gifi (accno,description) VALUES ('0482600', 'AuÃerplan.AfA a.immat.VermÃgensgeg.');
-INSERT INTO gifi (accno,description) VALUES ('0483000', 'Abschreibungen auf Sachanlagen');
-INSERT INTO gifi (accno,description) VALUES ('0484000', 'AuÃerplanmÃÃig Abschr.a.Sachanlagen');
-INSERT INTO gifi (accno,description) VALUES ('0485000', 'Abschr.a.Sachanl.steuerl.Sondervors');
-INSERT INTO gifi (accno,description) VALUES ('0485500', 'Sofortabschreibung GWG');
-INSERT INTO gifi (accno,description) VALUES ('0486000', 'Abschreibungen auf aktivierte GWG');
-INSERT INTO gifi (accno,description) VALUES ('0487000', 'Abschreibungen auf Finanzanlagen');
-INSERT INTO gifi (accno,description) VALUES ('0487500', 'Abschr.a.Wertp.d.UmlaufvermÃgens');
-INSERT INTO gifi (accno,description) VALUES ('0490000', 'Sonstige betriebliche Aufwendungen');
-INSERT INTO gifi (accno,description) VALUES ('0490500', 'Sons.Aufw.betriebl. und regelmÃÃig');
-INSERT INTO gifi (accno,description) VALUES ('0490900', 'Fremdleistungen');
-INSERT INTO gifi (accno,description) VALUES ('0491000', 'Porto');
-INSERT INTO gifi (accno,description) VALUES ('0492000', 'Telefon');
-INSERT INTO gifi (accno,description) VALUES ('0492500', 'Telefax');
-INSERT INTO gifi (accno,description) VALUES ('0493000', 'BÃrobedarf');
-INSERT INTO gifi (accno,description) VALUES ('0494000', 'Zeitschriften, BÃcher');
-INSERT INTO gifi (accno,description) VALUES ('0494500', 'Fortbildungskosten');
-INSERT INTO gifi (accno,description) VALUES ('0494600', 'Freiwillige Sozialleistungen');
-INSERT INTO gifi (accno,description) VALUES ('0495000', 'Rechts- und Beratungskosten');
-INSERT INTO gifi (accno,description) VALUES ('0495500', 'BuchfÃhrungskosten');
-INSERT INTO gifi (accno,description) VALUES ('0495700', 'AbschluÃ- und PrÃfungskosten');
-INSERT INTO gifi (accno,description) VALUES ('0496000', 'Mieten fÃr Einrichtungen');
-INSERT INTO gifi (accno,description) VALUES ('0497000', 'Nebenkosten des Geldverkehrs');
-INSERT INTO gifi (accno,description) VALUES ('0498000', 'Betriebsbedarf');
-INSERT INTO gifi (accno,description) VALUES ('0498500', 'Werkzeuge und KleingerÃte');
-INSERT INTO gifi (accno,description) VALUES ('0498600', 'Sonstige Aufwendungen (Ausbuchung)');
-INSERT INTO gifi (accno,description) VALUES ('0499000', 'Kalkulatorischer Unternehmerlohn');
-INSERT INTO gifi (accno,description) VALUES ('0499200', 'Kalkulatorische Zinsen');
-INSERT INTO gifi (accno,description) VALUES ('0499300', 'Kalkulatorische Aschreibungen');
-INSERT INTO gifi (accno,description) VALUES ('0499600', 'Herstellungskosten');
-INSERT INTO gifi (accno,description) VALUES ('0499700', 'Verwaltungskosten');
-INSERT INTO gifi (accno,description) VALUES ('0499800', 'Vertriebskosten');
-INSERT INTO gifi (accno,description) VALUES ('0700000', 'Unfertige Erzeu.unfert.Leistungen');
-INSERT INTO gifi (accno,description) VALUES ('0705000', 'Unfertige Erzeugnisse');
-INSERT INTO gifi (accno,description) VALUES ('0708000', 'Unfertige Leistungen');
-INSERT INTO gifi (accno,description) VALUES ('0709000', 'In AusfÃhrung befindl. BauauftrÃge');
-INSERT INTO gifi (accno,description) VALUES ('0709500', 'In Arbeit befindliche AuftrÃge');
-INSERT INTO gifi (accno,description) VALUES ('0710000', 'Fertige Erzeugnisse und Waren');
-INSERT INTO gifi (accno,description) VALUES ('0711000', 'Fertige Erzeugnisse (Bestand)');
-INSERT INTO gifi (accno,description) VALUES ('0714000', 'Waren (Bestand)');
@@ Diff output truncated at 100000 characters. @@
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.