[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb:[2645] trunk/sql/coa
- Subject: SF.net SVN: ledger-smb:[2645] trunk/sql/coa
- From: ..hidden..
- Date: Fri, 12 Jun 2009 02:02:55 +0000
Revision: 2645
http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2645&view=rev
Author: einhverfr
Date: 2009-06-12 02:02:55 +0000 (Fri, 12 Jun 2009)
Log Message:
-----------
German chart conversions
Modified Paths:
--------------
trunk/sql/coa/cz/chart/General.sql
trunk/sql/coa/de/chart/DATEV-SKR03.sql
trunk/sql/coa/de/chart/General.sql
trunk/sql/coa/de/chart/SKR03.sql
Modified: trunk/sql/coa/cz/chart/General.sql
===================================================================
--- trunk/sql/coa/cz/chart/General.sql 2009-06-12 01:39:22 UTC (rev 2644)
+++ trunk/sql/coa/cz/chart/General.sql 2009-06-12 02:02:55 UTC (rev 2645)
@@ -6,6 +6,7 @@
-- customized for http://www.ledgersmb.org/
-- encoding UTF-8
--
+-- Needs to be converted to use new framework. Not working.
INSERT INTO chart VALUES (10001, '1000', 'Dlouhodobà nehmotnà majetek', 'A', 'A', 'AP_amount', '', false);
INSERT INTO chart VALUES (10033, '3200', 'UmÄleckà dÃla a sbÃrky', 'A', 'A', 'AP_amount', '', false);
Modified: trunk/sql/coa/de/chart/DATEV-SKR03.sql
===================================================================
--- trunk/sql/coa/de/chart/DATEV-SKR03.sql 2009-06-12 01:39:22 UTC (rev 2644)
+++ trunk/sql/coa/de/chart/DATEV-SKR03.sql 2009-06-12 02:02:55 UTC (rev 2645)
@@ -1,223 +1,224 @@
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','','');
+SELECT account_heading_save(NULL, '0000000', '', NULL);
+SELECT account_save(NULL,'0002700','EDV-Software','0002700','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0010000','Fabrikbauten','0010000','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0011000','Garagen','0011000','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0011100','AuÃenanlagen','0011100','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0011200','Hof-und Wegebefestigung','0011200','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0011500','Andere Bauten','0011500','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0016500','GeschÃftsbauten','0016500','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0008500','GrundstÃckswert eige.bebau.Grundst.','0008500','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0009000','GeschÃftsbauten','0009000','A', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '0016000', 'Bauten auf fremden GrundstÃcken', NULL);
+SELECT account_save(NULL,'0017000','Fabrikbauten','0017000','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0017500','Garagen','0017500','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0017600','AuÃenanlage','0017600','A', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '0020000', 'Techn.Anlagen und Maschinen', NULL);
+SELECT account_save(NULL,'0021000','Maschinen','0021000','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0022000','Maschinengebundene Werkzeuge','0022000','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0024000','Maschinelle Anlagen','0024000','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0028000','Betriebsvorrichtung','0028000','A', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '0030000', 'Andere Anlagen,Betrieb-und GeschÃftsaus', NULL);
+SELECT account_save(NULL,'0031000','Andere Anlagen','0031000','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0032000','PKW','0032000','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0035000','LKW','0035000','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0040000','Betriebsausstattung','0040000','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0041000','GeschÃftsausstattung','0041000','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0042000','BÃroeinrichtung','0042000','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0043000','Ladeneinrichtung','0043000','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0048000','Geringwertige Wirtschaftsg.b.410EUR','0048000','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0049000','Sons.Betriebs- GeschÃftsausstattung','0049000','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0050400','Ant.a.herr.o.m.Mehrh.bet.Ges.schaft','0050400','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0051300','Typisch stille Beteiligungen','0051300','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0063100','- Restlaufzeit bis 1 Jahr','0063100','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0051600','Atypische stille Beteiligungen','0051600','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0064000','- Restlaufzeit 1 bis 5 Jahre','0064000','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0065000','- Restlaufzeit grÃÃer als 5 Jahre','0065000','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0099600','Pauschalwertb.m.Restlaufzeit v. 1J.','0099600','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0140000','Ford. a.Lieferungen und Leistungen','0140000','A', NULL, false,string_to_array('AR', ':'));
+SELECT account_save(NULL,'0080000','Gezeichnetes Kapital','0080000','Q', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0150000','Sonstige VermÃgensgegenstÃnde','0150000','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0153000','Forderungen gegen Personal','0153000','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0154500','Umsatzsteuerforderungen','0154500','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0100000','Kasse','0100000','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'0120000','Bank','0120000','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'0096300','KÃrperschaftssteuerrÃckstellung','0096300','Q', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0095500','SteuerrÃckstellung','0095500','Q', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0095700','GewerbesteuerrÃckstellung','0095700','Q', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0080100','Ausst.Einl.a.d.gezeichnete Kapital','0080100','Q', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0084000','KapitalrÃcklage','0084000','Q', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0086000','Gewinnvortrag vor Verwendung','0086000','Q', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0086900','Vortrag auf neue Rechnungen','0086900','Q', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '0000500', 'Sachanlagen', NULL);
+SELECT account_heading_save(NULL, '0050000', 'Finanzanlagen', NULL);
+SELECT account_save(NULL,'0051000','Beteiligungen','0051000','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0063000','Verbindl.gegenÃber Kreditinstituten','0063000','L', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '0060000', 'Verbindlichkeiten', NULL);
+SELECT account_save(NULL,'0086800','Verlustvortrag vor Verwendung','0086800','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0097000','Sonstige RÃckstellungen','0097000','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0097400','RÃckstellungen fÃr GewÃhrleistungen','0097400','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0097700','RÃcks.f.AbschluÃ-u.PrÃfungskosten','0097700','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0097800','AufwandsrÃckstellungen','0097800','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0098000','Aktive Rechnungsabgrenzung','0098000','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0099000','Passive Rechnungsabgrenzung','0099000','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0099200','Wertberichtigungen','0099200','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0099800','Einzelwertber.m.Restlaufzeit v.1 J.','0099800','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0146000','Zweifelhafte Forderungen','0146000','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0151000','Geleistete Anzahlung auf VorrÃte','0151000','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0151100','Geleistete Anzahlungen 7%','0151100','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0151700','Geleistete Anzahlung 16%','0151700','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0152500','Kautionen','0152500','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0154000','SteuerÃberzahlungen','0154000','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0157000','Abziehbare Vorsteuer','0157000','A', NULL, false,string_to_array('AR_tax:AP_tax', ':'));
+SELECT account_save(NULL,'0160000','Verbindlichkeiten aus Lief.u.Leist.','0160000','L', NULL, false,string_to_array('AP', ':'));
+SELECT account_save(NULL,'0174100','Verbindl.a.Lohn-und Kirchensteuer','0174100','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0178000','Umsatzsteuer-Vorauszahlungen','0178000','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0178100','Umsatzsteuer-Vorauszahlung 1/11','0178100','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0178900','Umsatzsteuer laufendes Jahr','0178900','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0179000','Umsatzsteuer Vorjahr','0179000','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0179100','Umsatzsteuer frÃhere Jahre','0179100','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0180000','Privatentnahme allgemein','0180000','Q', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0189000','Privateinlagen','0189000','Q', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0210000','Zinsen und Ãhnl.Aufwendungen','0210000','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0211000','Zinsaufwendung f.kurzf.Verbindlichk','0211000','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0212000','Zinsaufwendung f.langf.Verbindlichk','0212000','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0221000','Kapitalertragssteuer','0221000','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0231000','AnlagenabgÃnge - bei Buchverlust','0231000','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0231500','AnlagenabgÃnge-Buchgewinn','0231500','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0237500','Grundsteuer','0237500','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0245000','Einstell.i.d.Pauschalwertbe.z.Forde','0245000','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0245100','Einstell.i.d.Einzelwertb.z.Forderun','0245100','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0250000','AuÃerordentliche ErtrÃge','0250000','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0251000','Betriebsfremde ErtrÃge n.auÃerorden','0251000','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0252000','Periodenfremde ErtrÃge nicht auÃero','0252000','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0270000','Sonstige ErtrÃge','0270000','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0272000','Ertr.a.d.Abgang v.Gegens.d.Anlageve','0272000','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0272500','Ertr.a.d.Abg.v.Gegenst.d.Umlaufverm','0272500','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0273000','Ertr.a.Herab.d.Pauschal.z.Forderung','0273000','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0273100','Ertr.a.Herab.d.Einzelw.z.Forderunge','0273100','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0273200','Ertr. aus abgeschriebenen Forderung','0273200','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0274200','VersicherungsentschÃdigungen','0274200','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0286000','Gewinnvortrag nach Verwendung','0286000','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0286800','Verlustvortrag nach Verwendung','0286800','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0286900','Vortrag auf neue Rechnungen','0286900','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0375000','Erhaltene Boni 7% Vorsteuer','0375000','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0376000','Erhaltene Boni 16% Vorsteuer','0376000','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0380000','Anschaffungsnebenkosten','0380000','E', NULL, false,string_to_array('IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'0383000','Leergut','0383000','E', NULL, false,string_to_array('IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'0385000','ZÃlle und Einfuhrabgaben','0385000','E', NULL, false,string_to_array('IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'0396000','Bestandsver.Roh-,Hilfs-.Betriebs.','0396000','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0397000','Bestand Roh-,Hilfs-,u.Betriebsstoff','0397000','A', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'0398000','Bestand Waren','0398000','E', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'0399000','Verrechnete Stoffkosten','0399000','E', NULL, false,string_to_array('IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'0400000','Material-und Stoffverbrauch','0400000','E', NULL, false,string_to_array('IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'0410000','LÃhne und GehÃlter','0410000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0412500','Ehegattengehalt','0412500','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0340000','Wareneingang 16% Vorsteuer','0340000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0342000','Innergemein.Erwerb 7% VorSt u. Ust','0342000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0342500','Innergem.Erwerb 16% VorSt u. Ust','0342500','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0373100','Erhaltene Skonti 7% Vorsteuer','0373100','I', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'0373500','Erhaltene Skonti 16% Vorsteuer','0373500','I', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'0330000','Wareneingang 7% Vorsteuer','0330000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0413000','Gesetzlich soziale Aufwendungen','0413000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0413800','BeitrÃge zur Berufsgenossenschaftr','0413800','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0414500','Freiwillige sozi.Aufw.lohnsteuerfr.','0414500','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0414900','Pauschale Lohnsteuera.sons.BezÃge','0414900','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0416500','Aufwendung f.Altersversorgung','0416500','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0417000','VermÃgenswirksame Leistungen','0417000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0420000','Raumkosten','0420000','E', NULL, false,string_to_array('AP_amount:AP_tax', ':'));
+SELECT account_save(NULL,'0417500','Fahrtkostenerst.Wohnung/ArbeitsstÃt','0417500','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0419000','AushilfslÃhne','0419000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0419900','Lohnsteuer fÃr Aushilfe','0419900','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0159000','Durchlaufende Posten','0159000','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0422000','Pacht','0422000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0423000','Heizung','0423000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0424000','Gas,Strom, Wasser','0424000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0425000','Reinigung','0425000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0426000','Instandhaltung betrieb.RÃume','0426000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0428000','Sonstige Raumkosten','0428000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0432000','Gewerbesteuer','0432000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0434000','Sonstige Betriebssteuern','0434000','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0436000','Versicherungen','0436000','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0438000','BeitrÃge','0438000','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0439000','Sonstige Abgaben','0439000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0450000','Fahrzugkosten','0450000','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0451000','Kfz-Steuer','0451000','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0452000','Kfz-Versicherungen','0452000','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0453000','Laufende Kfz-Betriebskosten','0453000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0454000','Kfz-Reparaturen','0454000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0455000','Garagenmiete','0455000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0457000','Fremdfahrzeuge','0457000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0458000','Sonstige Kfz-Kosten','0458000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0461000','Werbekosten','0461000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0463000','Geschenke bis 40 EUR','0463000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0463500','Geschenke Ãber 40 EUR','0463500','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0464000','ReprÃsentationskosten','0464000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0465000','Bewirtungskosten','0465000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0465400','Nicht abzugsfÃhige Bewirtungskosten','0465400','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0465500','Nicht abzugsfÃhige Betriebsausgaben','0465500','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0466300','Reisekosten Arbeitn.m.Vorsteuerabzu','0466300','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0466600','Reisekosten Arbeitn.Ãbernachtungsau','0466600','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0466800','Kilometerentgelderstattung Arbeitne','0466800','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0467400','Reisekosten Untern.Verpflegungsmehr','0467400','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0467600','Reisekosten Untern.Ãbernachtungsauf','0467600','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0467800','Kilometererstattungsgeld Unternehme','0467800','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0470000','Kosten der Warenabgabe','0470000','E', NULL, false,string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'0471000','Verpackungsmaterial','0471000','E', NULL, false,string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'0473000','Ausgangsfracht','0473000','E', NULL, false,string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'0475000','Transportversicherung','0475000','E', NULL, false,string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'0476000','Verkaufsprovision','0476000','E', NULL, false,string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'0478000','Fremdarbeiten','0478000','E', NULL, false,string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'0479000','Aufwand fÃr GewÃhrleistungen','0479000','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0480900','Sonstige Reparaturen u.Instandhalt.','0480900','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0481000','Mietleasing','0481000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0481500','Kaufleasing','0481500','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0482000','AfA a.Aufw.f.d.Inga.u.Erw.GeschÃfts','0482000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0482100','AfA a.Aufw.f.d.WÃhrungsumst.a.Euro','0482100','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0483000','Abschreibungen auf Sachanlagen','0483000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0485500','Sofortabschreibung GWG','0485500','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0491000','Porto','0491000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0492000','Telefon','0492000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0492500','Telefax','0492500','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0493000','BÃrobedarf','0493000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0494000','Zeitschriften, BÃcher','0494000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0494500','Fortbildungskosten','0494500','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0494600','Freiwillige Sozialleistungen','0494600','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0495000','Rechts- und Beratungskosten','0495000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0495500','BuchfÃhrungskosten','0495500','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0495700','AbschluÃ- und PrÃfungskosten','0495700','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0496000','Mieten fÃr Einrichtungen','0496000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0497000','Nebenkosten des Geldverkehrs','0497000','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0498000','Betriebsbedarf','0498000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0498500','Werkzeuge und KleingerÃte','0498500','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0498600','Sonstige Aufwendungen (Ausbuchung)','0498600','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'0700000','Unfertige Erzeu.unfert.Leistungen','0700000','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0136000','Geldtransit','0136000','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0705000','Unfertige Erzeugnisse','0705000','A', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'0708000','Unfertige Leistungen','0708000','A', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'0711000','Fertige Erzeugnisse (Bestand)','0711000','A', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'0714000','Waren (Bestand)','0714000','A', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'0873100','GewÃhrte Skonti 7% USt','0873100','I', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'0873500','GewÃhrte Skonti 16% USt.','0873500','I', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'0875000','GewÃhrte Boni 7% USt.','0875000','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0876000','GewÃhrte Boni 16% USt.','0876000','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0882000','ErlÃse aus AnlageverkÃufen 16%Ust','0882000','I', NULL, false,string_to_array('IC_sale', ':'));
+SELECT account_save(NULL,'0895500','UmsatzsteuervergÃtungen','0895500','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0890500','Entnahme v. Gegenst.o.USt.','0890500','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0900000','SaldenvertrÃge,Sachkonten','0900000','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0900800','SaldenvertrÃge,Debitoren','0900800','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0900900','SaldenvertrÃge,Kreditoren','0900900','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0266000','ErtrÃge aus Kursdifferenzen','0266000','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0215000','Aufwendungen aus Kursdifferenzen','0215000','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0850000','ProvisionserlÃse','0850000','I', NULL, false,string_to_array('AR_amount:IC_income', ':'));
+SELECT account_save(NULL,'0157100','Abziebare Vorsteuer 7%','0157100','A', NULL, false,string_to_array('AP_tax', ':'));
+SELECT account_save(NULL,'0157500','Abziehbare Vorsteuer 16%','0157500','A', NULL, false,string_to_array('AP_tax:AP_paid', ':'));
+SELECT account_save(NULL,'0177100','Umsatzsteuer 7%','0177100','L', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'0177500','Umsatzsteuer 16%','0177500','L', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'0830000','ErlÃse 7%USt','0830000','I', NULL, false,string_to_array('AR_amount:IC_sale:IC_income', ':'));
+SELECT account_save(NULL,'0840000','ErlÃse 16% USt.','0840000','I', NULL, false,string_to_array('AR_amount:IC_sale:IC_income', ':'));
+SELECT account_heading_save(NULL, '950', 'RÃckstellungen', NULL);
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '0398000'));
Modified: trunk/sql/coa/de/chart/General.sql
===================================================================
--- trunk/sql/coa/de/chart/General.sql 2009-06-12 01:39:22 UTC (rev 2644)
+++ trunk/sql/coa/de/chart/General.sql 2009-06-12 02:02:55 UTC (rev 2645)
@@ -28,184 +28,184 @@
-- 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','');
+SELECT account_heading_save(NULL,'0000','ANLAGEVERMÃGEN', NULL));
+SELECT account_save(NULL,'0100','Konzessionen & Lizenzen','A','A0', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0135','EDV-Programme','A','A0', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0440','Maschinen','A','A0', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0500','Betriebsausstattung','A','A0', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0520','PKW','A','A0', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0650','BÃroeinrichtung','A','A0', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'0670','GWG','A','A0', NULL, false,string_to_array('', ':'));
-- 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');
+SELECT account_heading_save(NULL,'1100','WARENBESTAND', NULL));
+SELECT account_save(NULL,'1140','Warenbestand','A','A1-1', NULL, false,string_to_array('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','');
+SELECT account_heading_save(NULL,'1200','FORDERUNGEN', NULL));
+SELECT account_save(NULL,'1201','Geleistete Anzahlungen','A','A1-2', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1210','Forderungen ohne Kontokorrent','A','A1-2', NULL, false,string_to_array('AR', ':'));
+SELECT account_save(NULL,'1300','Sonstige Forderungen','A','A1-2', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1400','Anrechenbare Vorsteuer','A','A1-2', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'1401','Anrechenbare Vorsteuer 7%','A','A1-2', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'1402','Vorsteuer ig Erwerb','A','A1-2', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'1403','Vorsteuer ig Erwerb 16%','A','A1-2', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'1405','Anrechenbare Vorsteuer 16%','A','A1-2', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'1406','Anrechenbare Vorsteuer 15%','A','A1-2', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'1433','bezahlte Einfuhrumsatzsteuer','A','A1-2', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'1370','UngeklÃrte Posten','A','A1-2', NULL, false,string_to_array('', ':'));
-- 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','');
+SELECT account_heading_save(NULL,'1600','LIQUIDE MITTEL', NULL));
+SELECT account_save(NULL,'1601','Kasse','A','A1-3', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1700','Postgiro','A','A1-3', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1800','Bank','A','A1-3', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1810','Bank USD','A','A1-3', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1820','Kreditkarten','A','A1-3', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1890','Geldtransit','A','A1-3', NULL, false,string_to_array('', ':'));
-- A1-4
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1900','Aktive Rechnungsabgrenzung','A','A1-4','A','');
+SELECT account_save(NULL,'1900','Aktive Rechnungsabgrenzung','A','A1-4', NULL, false,string_to_array('', ':'));
-- 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','');
+SELECT account_heading_save(NULL,'2000','EIGENKAPITAL', NULL));
+SELECT account_save(NULL,'2001','Eigenkapital','Q','P0', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2100','Privatentnahmen','Q','P0', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2150','Privatsteuern','Q','P0', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2180','Privateinlagen','Q','P0', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2200','Sonderausgaben beschr.abzugsf.','Q','P0', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2900','Gezeichnetes Kapital','Q','P0', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2910','Ausstehende Einlagen','Q','P0', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2970','Gewinnvortrag vor Verwendung','Q','P0', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2978','Verlustvortrag vor Verwendung','Q','P0', NULL, false,string_to_array('', ':'));
-- 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','');
+SELECT account_heading_save(NULL,'3000','RÃCKSTELLUNGEN', NULL));
+SELECT account_save(NULL,'3030','GewerbesteuerrÃckstellung','L','P1', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3070','Sonstige RÃckstellungen','L','P1', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3095','RÃckstellung fÃr Abschlusskosten','L','P1', NULL, false,string_to_array('', ':'));
-- 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','');
+SELECT account_heading_save(NULL,'3100','FREMDKAPITAL LANGFRISTIG', NULL));
+SELECT account_save(NULL,'3160','Bankdarlehen','L','P2', NULL, false,string_to_array('', ':'));
-- 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');
+SELECT account_heading_save(NULL,'3200','FREMDKAPITAL KURZFRISTIG', NULL));
+SELECT account_save(NULL,'3280','Erhaltene Anzahlungen','L','P3', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3310','Kreditoren ohne Kontokorrent','L','P3', NULL, false,string_to_array('AP', ':'));
+SELECT account_save(NULL,'3500','Sonstige Verbindlichkeiten','L','P3', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3560','Darlehen','L','P3', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3700','Verbindl. Betr.steuern u.Abgaben','L','P3', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3720','Verbindlichkeiten LÃhne und GehÃlter','L','P3', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3730','Verbindlichkeiten Lohnsteuer','L','P3', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3740','Verbindlichkeiten Sozialversicherung','L','P3', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3800','Umsatzsteuer','L','P3', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'3801','Umsatzsteuer 7%','L','P3', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'3802','Umsatzsteuer ig. Erwerb','L','P3', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'3803','Umsatzsteuer ig. Erwerb 16%','L','P3', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'3805','Umsatzsteuer 16%','L','P3', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'3806','Umsatzsteuer 15%','L','P3', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'3815','Umsatzsteuer nicht fÃllig 16%','L','P3', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'3816','Umsatzsteuer nicht fÃllig 15%','L','P3', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'3820','Umsatzsteuer-Vorauszahlungen','L','P3', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'3841','Umsatzsteuer Vorjahr','L','P3', NULL, false,string_to_array('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','');
+SELECT account_save(NULL,'3900','Aktive Rechnungsabgrenzung','L','P4', NULL, false,string_to_array('', ':'));
-- 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');
+SELECT account_heading_save(NULL,'5100','WARENEINGANG', NULL));
+SELECT account_save(NULL,'5200','Wareneingang ohne Vorsteuer','E','K0', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'5300','Wareneingang 7%','E','K0', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'5400','Wareneingang 15%','E','K0', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'5420','ig.Erwerb 7% VoSt. und 7% USt.','E','K0', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'5425','ig.Erwerb 15% VoSt. und 15% USt.','E','K0', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'5731','Erhaltene Skonti 7% Vorsteuer','E','K0', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'5736','Erhaltene Skonti 15% Vorsteuer','E','K0', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'5800','Anschaffungsnebenkosten','E','K0', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'5900','Fremdarbeiten','E','K0', NULL, false,string_to_array('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','');
+SELECT account_heading_save(NULL,'6000','PERSONALKOSTEN', NULL));
+SELECT account_heading_save(NULL,'6001','Personalkosten', NULL));
+SELECT account_save(NULL,'6010','LÃhne','E','K1', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'6020','GehÃlter','E','K1', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'6030','AushilfslÃhne','E','K1', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'6040','Lohnsteuer Aushilfen','E','K1', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'6080','VermÃgenswirksame Leistungen','E','K1', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'6090','Fahrtkostenerst.Whg./ArbeitsstÃtte','E','K1', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'6110','Sozialversicherung','E','K1', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'6120','Berufsgenossenschaft','E','K1', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'6130','Freiw. Soz. Aufw. LSt- u. Soz.Vers.frei','E','K1', NULL, false,string_to_array('', ':'));
-- 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');
+SELECT account_heading_save(NULL,'6300','RAUMKOSTEN', NULL));
+SELECT account_save(NULL,'6310','Miete','E','K2', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'6315','Pacht','E','K2', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'6320','Heizung','E','K2', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'6325','Gas Strom Wasser','E','K2', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'6330','Reinigung','E','K2', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'6335','Instandhaltung betriebliche RÃume','E','K2', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'6345','Sonstige Raumkosten','E','K2', NULL, false,string_to_array('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');
+SELECT account_heading_save(NULL,'6400','SONSTIGE KOSTEN', NULL));
+SELECT account_save(NULL,'6402','Abschreibungen','E','K3', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'6403','Kaufleasing','E','K3', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'6404','Sofortabschreibung GWG','E','K3', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'6405','Sonstige Kosten','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6410','Versicherung','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6420','BeitrÃge und GebÃhren','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6430','Sonstige Abgaben','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6470','Rep. und Instandhaltung BGA','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6520','Kfz-Versicherung','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6530','Lfd. Kfz-Kosten','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6540','Kfz-Reparaturen','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6560','Fremdfahrzeuge','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6570','Sonstige Kfz-Kosten','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6600','Werbung','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6610','Kundengeschenke bis DM 75.','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6620','Kundengeschenke Ãber DM 75.-','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6630','ReprÃsentationkosten','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6640','Bewirtungskosten','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6644','Nicht abzugsf.Bewirtungskosten','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6650','Reisekosten Arbeitnehmer','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6660','Reisekosten Arbeitnehmer 12.3%','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6665','Reisekosten Arbeitnehmer 9.8%','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6670','Reisekosten Unternehmer','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6680','Reisekosten Unternehmer 12.3%','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6685','Reisekosten Unternehmer 9.8%','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6688','Reisekosten Unternehmer 5.7%','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6690','Km-Geld-Erstattung 8.2%','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6710','Verpackungsmaterial','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6740','Ausgangsfrachten','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6780','Fremdarbeiten','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6800','Porto','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6805','Telefon','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6815','BÃrobedarf','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6820','Zeitschriften & BÃcher','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6825','Rechts- und Beratungskosten','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6835','Mieten fÃr Einrichtungen','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6840','Mietleasing','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6845','Werkzeuge und KleingerÃte','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6850','Betriebsbedarf','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6852','GastÃttenbedarf','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6855','Nebenkosten des Geldverkehrs','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6880','Aufwendungen aus Kursdifferenzen','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'6885','ErlÃse aus Anlageverk.(Buchverlust)','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'7610','Gewerbesteuer','E','K3', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'7685','Kfz-Steuer','E','K3', NULL, false,string_to_array('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');
+SELECT account_heading_save(NULL, '8100', 'ERTRÃGE', NULL);
+SELECT account_save(NULL,'8120','Steuerfreie UmsÃtze 4 Nr. 1a UStG.','I','E', NULL, false,string_to_array('AR_amount:IC_sale:IC_income', ':'));
+SELECT account_save(NULL,'8125','Steuerfreie ig. Lieferungen 1b UStG.','I','E', NULL, false,string_to_array('AR_amount:IC_sale:IC_income', ':'));
+SELECT account_save(NULL,'8200','ErlÃse ohne Umsatzsteuer','I','E', NULL, false,string_to_array('AR_amount:IC_sale:IC_income', ':'));
+SELECT account_save(NULL,'8300','ErlÃse 7% Umsatzsteuer','I','E', NULL, false,string_to_array('AR_amount:IC_sale:IC_income', ':'));
+SELECT account_save(NULL,'8400','ErlÃse 15% Umsatzsteuer','I','E', NULL, false,string_to_array('AR_amount:IC_sale:IC_income', ':'));
+SELECT account_save(NULL,'8500','ProvisionserlÃse','I','E', NULL, false,string_to_array('AR_amount:IC_sale:IC_income', ':'));
+SELECT account_save(NULL,'8630','Entnahme sonstg. Leistungen 7% USt.','I','E', NULL, false,string_to_array('AR_amount:IC_sale:IC_income', ':'));
+SELECT account_save(NULL,'8640','Entnahme sonstg. Leistungen 15% USt.','I','E', NULL, false,string_to_array('AR_amount:IC_sale:IC_income', ':'));
+SELECT account_save(NULL,'8731','Gew. Skonti 7% USt.','I','E', NULL, false,string_to_array('AR_amount:IC_sale:IC_income', ':'));
+SELECT account_save(NULL,'8736','Gew. Skonti 15% USt.','I','E', NULL, false,string_to_array('AR_amount:IC_sale:IC_income', ':'));
+SELECT account_save(NULL,'8840','ErtrÃge aus Kursdifferenzen','I','E', NULL, false,string_to_array('AR_amount:IC_sale:IC_income', ':'));
+SELECT account_save(NULL,'8845','ErlÃse aus Anlageverk. (Buchgewinn)','I','E', NULL, false,string_to_array('AR_amount:IC_sale:IC_income', ':'));
+SELECT account_save(NULL,'8900','ErtrÃge aus Abgang von Anlageverm.','I','E', NULL, false,string_to_array('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','');
+SELECT account_heading_save(NULL,'9300','NEUTRALE AUFWENDUNGEN', NULL));
+SELECT account_save(NULL,'9310','Zinsen kurzfr. Verbindlichkeiten','E','NA', NULL, false,string_to_array('', ':'));
@@ Diff output truncated at 100000 characters. @@
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.