X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/e1bf8f8f3366b79d63cc5e2ee39ccb60cd893e1f..bd0dfb5f4e2c2fb2e402827ca0aa0d33135895fd:/sql/Germany-DATEV-SKR04EU-chart.sql?ds=inline

diff --git a/sql/Germany-DATEV-SKR04EU-chart.sql b/sql/Germany-DATEV-SKR04EU-chart.sql
index 1da01245f..80833c1f0 100644
--- a/sql/Germany-DATEV-SKR04EU-chart.sql
+++ b/sql/Germany-DATEV-SKR04EU-chart.sql
@@ -2,169 +2,169 @@
 -- IT Systems Service http://www.itsystemsservice.de
 --
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0135', 'EDV-Software',                                                             'A', 'A',         'AP_amount',                              '0135', 9,    NULL, NULL, NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0150', 'Geschäfts- oder Firmenwert',                                               'A', 'A',         'AP_amount',                              '0135', 9,    NULL, NULL, NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0240', 'Geschäftsbauten',                                                          'A', 'A',         'AP_amount',                              '0240', 9,    NULL, NULL, NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0150', 'GeschÃ¤fts- oder Firmenwert',                                               'A', 'A',         'AP_amount',                              '0135', 9,    NULL, NULL, NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0240', 'GeschÃ¤ftsbauten',                                                          'A', 'A',         'AP_amount',                              '0240', 9,    NULL, NULL, NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0400', 'Techn. Anlagen und Maschinen',                                             'A', 'A',         'AP_amount',                              '0400', 9,    NULL, NULL, NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0440', 'Maschinen',                                                                'A', 'A',         'AP_amount',                              '0440', 9,    NULL, NULL, NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0500', 'Andere Anlagen, Betriebs- und Geschäftsausstattung',                       'A', 'A',         'AP_amount',                              '0500', 9,    NULL, NULL, NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0500', 'Andere Anlagen, Betriebs- und GeschÃ¤ftsausstattung',                       'A', 'A',         'AP_amount',                              '0500', 9,    NULL, NULL, NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0510', 'Andere Anlagen',                                                           'A', 'A',         'AP_amount',                              '0510', 9,    NULL, NULL, NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0520', 'PKW',                                                                      'A', 'A',         'AP_amount',                              '0440', 9,    NULL, NULL, NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0560', 'Sonstige Transportmittel',                                                 'A', 'A',         'AP_amount',                              '0560', 9,    NULL, NULL, NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0650', 'Büroeinrichtung',                                                          'A', 'A',         'AP_amount',                              '0650', 9,    NULL, NULL, NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0650', 'BÃ¼roeinrichtung',                                                          'A', 'A',         'AP_amount',                              '0650', 9,    NULL, NULL, NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0640', 'Ladeneinrichtung',                                                         'A', 'A',         'AP_amount',                              '0640', 9,    NULL, NULL, NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0620', 'Werkzeuge',                                                                'A', 'A',         'AP_amount',                              '0620', 9,    NULL, NULL, NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0670', 'Geringwertige Wirtschaftsgüter',                                           'A', 'A',         'AP_amount',                              '0670', 9,    NULL, NULL, NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0675', 'Geringwertige Wirtschaftsggüter 150 - 1000 EUR (Sammelposten)',            'A', 'A',         'AP_amount',                              '0670', 9,    NULL, NULL, NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0670', 'Geringwertige WirtschaftsgÃ¼ter',                                           'A', 'A',         'AP_amount',                              '0670', 9,    NULL, NULL, NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0675', 'Geringwertige WirtschaftsggÃ¼ter 150 - 1000 EUR (Sammelposten)',            'A', 'A',         'AP_amount',                              '0670', 9,    NULL, NULL, NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1000', 'Roh-, Hilfs- und Betriebsstoffe (Bestand)',                                'A', 'E',         'IC',                                     '1000', 9,    NULL, 4,    NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1140', 'Waren (Bestand)',                                                          'A', 'E',         'IC',                                     '1140', 9,    NULL, 4,    NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1200', 'Forderungen aus Lieferungen und Leistungen',                               'A', 'A',         'AR',                                     '1200', 0,    NULL, NULL, NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1215', 'Forder. aus LuL zum allg. UST-Satz oder eines Kleinunternehmers (EÜR)',    'A', 'A',         'AR',                                     '1215', 0,    NULL, NULL, NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1216', 'Forder. aus LuL zum ermäßigten USTsatz (EÜR)',                             'A', 'A',         'AR',                                     '1216', 0,    NULL, NULL, NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1217', 'Forder. aus steuerfreien o. Nicht steuerbaren LuL (EÜR)',                  'A', 'A',         'AR',                                     '1217', 0,    NULL, NULL, NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1218', 'Forder. aus LuL nach Durchschnitzsätzen § 24 UStG (EÜR)',                  'A', 'A',         'AR',                                     '1218', 0,    NULL, NULL, NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1219', 'Gegenkonto 1215-1218 bei Auteilung d. Forder. nach Steuersätzen (EÜR)',    'A', 'A',         '',                                       '1219', 0,    NULL, NULL, NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1220', 'Forder. nach § 11 Abs. 1 Satz 2 EStG für § 4/3 EStG',                      'A', 'A',         'AR',                                     '1220', 0,    NULL, NULL, NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1215', 'Forder. aus LuL zum allg. UST-Satz oder eines Kleinunternehmers (EÃR)',    'A', 'A',         'AR',                                     '1215', 0,    NULL, NULL, NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1216', 'Forder. aus LuL zum ermÃ¤Ãigten USTsatz (EÃR)',                             'A', 'A',         'AR',                                     '1216', 0,    NULL, NULL, NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1217', 'Forder. aus steuerfreien o. Nicht steuerbaren LuL (EÃR)',                  'A', 'A',         'AR',                                     '1217', 0,    NULL, NULL, NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1218', 'Forder. aus LuL nach DurchschnitzsÃ¤tzen Â§ 24 UStG (EÃR)',                  'A', 'A',         'AR',                                     '1218', 0,    NULL, NULL, NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1219', 'Gegenkonto 1215-1218 bei Auteilung d. Forder. nach SteuersÃ¤tzen (EÃR)',    'A', 'A',         '',                                       '1219', 0,    NULL, NULL, NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1220', 'Forder. nach Â§ 11 Abs. 1 Satz 2 EStG fÃ¼r Â§ 4/3 EStG',                      'A', 'A',         'AR',                                     '1220', 0,    NULL, NULL, NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1248', 'Pauschwertber. zu Forder. Restlzeit <1 Jahr',                              'A', 'E',         '',                                       '1248', 0,    NULL, 31,   NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1249', 'Pauschwertber. zu Forder. Restlzeit >1 Jahr',                              'A', 'E',         '',                                       '1249', 0,    NULL, 31,   NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1370', 'Durchlaufende Posten',                                                     'A', 'A',         '',                                       '1370', 0,    NULL, NULL, NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1374', 'Fremdgeld',                                                                'A', 'A',         '',                                       '1374', 0,    NULL, NULL, NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1401', 'Abziehbare Vorsteuer 7%',                                                  'A', 'E',         'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1401', 0,    66,   NULL, NULL, 27,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1401', 'Abziehbare Vorsteuer 7%',                                                  'A', 'E',         'AP_tax:IC_taxpart:IC_taxservice', '1401', 0,    66,   NULL, NULL, 27,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1402', 'Abziehbare Vorsteuer aus innergemeinschftl. Erwerb',                       'A', 'E',         'AP_tax:IC_taxpart:IC_taxservice',        '1402', 0,    61,   NULL, NULL, 27,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1403', 'Abziehbare Vorsteuer aus innergemeinschftl. Erwerb 16%',                   'A', 'E',         'AP_tax:IC_taxpart:IC_taxservice',        '1403', 0,    61,   NULL, NULL, 27,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1404', 'Abziehbare Vorsteuer aus innergemeinschftl. Erwerb 19%',                   'A', 'E',         'AP_tax:IC_taxpart:IC_taxservice',        '1403', 0,    61,   NULL, NULL, 27,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1405', 'Abziehbare Vorsteuer 16%',                                                 'A', 'E',         'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1405', 0,    66,   NULL, NULL, 27,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1406', 'Abziehbare Vorsteuer 19 %',                                                'A', 'E',         'AP_tax:IC_taxpart:IC_taxservice:CT_tax', 0,      0,    66,   NULL, NULL, 27,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1407', 'Abziehbare Vorsteuer nach § 13b UStG 19%',                                 'A', 'E',         'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1407', 0,    NULL, NULL, NULL, 27,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1408', 'Abziehbare Vorsteuer nach § 13b UStG',                                     'A', 'E',         'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1408', 0,    NULL, NULL, NULL, 27,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1409', 'Abziehbare Vorsteuer nach § 13b UStG 16%',                                 'A', 'E',         'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1408', 0,    NULL, NULL, NULL, 27,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1405', 'Abziehbare Vorsteuer 16%',                                                 'A', 'E',         'AP_tax:IC_taxpart:IC_taxservice', '1405', 0,    66,   NULL, NULL, 27,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1406', 'Abziehbare Vorsteuer 19 %',                                                'A', 'E',         'AP_tax:IC_taxpart:IC_taxservice', 0,      0,    66,   NULL, NULL, 27,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1407', 'Abziehbare Vorsteuer nach Â§ 13b UStG 19%',                                 'A', 'E',         'AP_tax:IC_taxpart:IC_taxservice', '1407', 0,    NULL, NULL, NULL, 27,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1408', 'Abziehbare Vorsteuer nach Â§ 13b UStG',                                     'A', 'E',         'AP_tax:IC_taxpart:IC_taxservice', '1408', 0,    NULL, NULL, NULL, 27,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1409', 'Abziehbare Vorsteuer nach Â§ 13b UStG 16%',                                 'A', 'E',         'AP_tax:IC_taxpart:IC_taxservice', '1408', 0,    NULL, NULL, NULL, 27,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1432', 'abziehb. VorSt EU-Erwerb Neufzg.b.Lief. o. USt-IdNr.',                     'A', 'E',         'AR_tax',                                 '1483', 0,    NULL, NULL, NULL, 27,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1433', 'Bezahlte Einfuhrumsatzsteuer',                                             'A', 'E',         '',                                       '1433', 0,    62,   NULL, NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1460', 'Geldtransit',                                                              'A', 'A',         '',                                       '1460', 0,    NULL, NULL, NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1480', 'Gegenkonto Vorsteuer §4/3 EStG',                                           'A', 'A',         '',                                       '1480', 0,    NULL, NULL, NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1481', 'Auflösung Vorst.a.Vorjahr §4/3 EStG',                                      'A', 'A',         '',                                       '1481', 0,    NULL, NULL, NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1482', 'Vorst.aus Investitionen §4/3 EStG',                                        'A', 'E',         '',                                       '1482', 0,    NULL, NULL, NULL, 27,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1480', 'Gegenkonto Vorsteuer Â§4/3 EStG',                                           'A', 'A',         '',                                       '1480', 0,    NULL, NULL, NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1481', 'AuflÃ¶sung Vorst.a.Vorjahr Â§4/3 EStG',                                      'A', 'A',         '',                                       '1481', 0,    NULL, NULL, NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1482', 'Vorst.aus Investitionen Â§4/3 EStG',                                        'A', 'E',         '',                                       '1482', 0,    NULL, NULL, NULL, 27,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1484', 'abziehb.VorSt EU-Erwerb Neufzg.b.Lief. o. USt.Ident.Nr',                   'A', 'E',         'AR_tax',                                 '1483', 0,    NULL, NULL, NULL, 27,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1600', 'Kasse',                                                                    'A', 'A',         'AR_paid:AP_paid',                        '1600', 0,    NULL, NULL, NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1800', 'Bank',                                                                     'A', 'A',         'AR_paid:AP_paid',                        '1800', 0,    NULL, NULL, NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2100', 'Privatentnahmen allgemein',                                                'A', 'Q',         '',                                       '2100', 0,    NULL, NULL, NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2150', 'Privatsteuern',                                                            'A', 'Q',         '',                                       '2150', 0,    NULL, NULL, NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2180', 'Privateinlagen',                                                           'A', 'Q',         '',                                       '2180', 0,    NULL, NULL, NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2200', 'Sonderausgaben beschränkt abzugsfähig',                                    'A', 'Q',         '',                                       '2200', 0,    NULL, NULL, NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2230', 'Sonderausgaben unbeschränkt abzugsfähig',                                  'A', 'Q',         '',                                       '2230', 0,    NULL, NULL, NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2200', 'Sonderausgaben beschrÃ¤nkt abzugsfÃ¤hig',                                    'A', 'Q',         '',                                       '2200', 0,    NULL, NULL, NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2230', 'Sonderausgaben unbeschrÃ¤nkt abzugsfÃ¤hig',                                  'A', 'Q',         '',                                       '2230', 0,    NULL, NULL, NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2250', 'Zuwendungen, Spenden',                                                     'A', 'Q',         '',                                       '2250', 0,    NULL, NULL, NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2950', 'Satzungsmäßige Rücklagen',                                                 'A', 'Q',         '',                                       '2953', 0,    NULL, NULL, NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2950', 'SatzungsmÃ¤Ãige RÃ¼cklagen',                                                 'A', 'Q',         '',                                       '2953', 0,    NULL, NULL, NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3151', 'Verbindlk. geg Krditinst. - Restlzeit <1 Jahr ',                           'A', 'L',         '',                                       '3151', 0,    NULL, NULL, NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3160', 'Verbindlk. geg Krditinst. - Restlzeit 1 - 5 Jahre ',                       'A', 'L',         '',                                       '3160', 0,    NULL, NULL, NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3170', 'Verbindlk. geg Krditinst. - Restlzeit >5 Jahre',                           'A', 'L',         '',                                       '3170', 0,    NULL, NULL, NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3300', 'Verbindlichkeiten aus Lief.u.Leist.',                                      'A', 'L',         'AP',                                     '3300', 0,    NULL, NULL, NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3305', 'Verbindlk. aus LuL zum allg. USTsatz (EÜR)',                               'A', 'L',         'AP',                                     '3305', 0,    NULL, NULL, NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3306', 'Verbindlk. aus LuL zum erm. USTsatz (EÜR)',                                'A', 'L',         'AP',                                     '3306', 0,    NULL, NULL, NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3307', 'Verbindlk. aus LuL ohne Vorsteuer (EÜR)',                                  'A', 'L',         'AP',                                     '3307', 0,    NULL, NULL, NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3309', 'Gegenkonto 3305-3307 bei Auteilung d. Forder. nach Steuersätzen (EÜR)',    'A', 'L',         '',                                       '3309', 0,    NULL, NULL, NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3801', 'Umsatzsteuer 7%',                                                          'A', 'I',         'AR_tax:IC_taxpart:IC_taxservice:CT_tax', '3801', 0,    NULL, NULL, NULL, 5,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3305', 'Verbindlk. aus LuL zum allg. USTsatz (EÃR)',                               'A', 'L',         'AP',                                     '3305', 0,    NULL, NULL, NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3306', 'Verbindlk. aus LuL zum erm. USTsatz (EÃR)',                                'A', 'L',         'AP',                                     '3306', 0,    NULL, NULL, NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3307', 'Verbindlk. aus LuL ohne Vorsteuer (EÃR)',                                  'A', 'L',         'AP',                                     '3307', 0,    NULL, NULL, NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3309', 'Gegenkonto 3305-3307 bei Auteilung d. Forder. nach SteuersÃ¤tzen (EÃR)',    'A', 'L',         '',                                       '3309', 0,    NULL, NULL, NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3801', 'Umsatzsteuer 7%',                                                          'A', 'I',         'AR_tax:IC_taxpart:IC_taxservice', '3801', 0,    NULL, NULL, NULL, 5,    FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3802', 'Umsatzsteuer aus innergemeinschftl. Erwerb',                               'A', 'I',         'AR_tax:IC_taxpart:IC_taxservice',        '3802', 0,    NULL, NULL, NULL, 6,    FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3803', 'Umsatzsteuer aus innergemeinschftl. Erwerb 16%',                           'A', 'I',         'AR_tax:IC_taxpart:IC_taxservice',        '3803', 0,    NULL, NULL, NULL, 28,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3804', 'Umsatzsteuer aus innergemeinschftl. Erwerb 19%',                           'A', 'I',         'AR_tax:IC_taxpart:IC_taxservice',        '3803', 0,    NULL, NULL, NULL, 28,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3805', 'Umsatzsteuer 16%',                                                         'A', 'I',         'AR_tax:IC_taxpart:IC_taxservice:CT_tax', '3805', 0,    NULL, NULL, NULL, 6,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3806', 'Umsatzsteuer 19%',                                                         'A', 'I',         'AR_tax:IC_taxpart:IC_taxservice:CT_tax', '3805', 0,    511,  NULL, NULL, 6,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3805', 'Umsatzsteuer 16%',                                                         'A', 'I',         'AR_tax:IC_taxpart:IC_taxservice', '3805', 0,    NULL, NULL, NULL, 6,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3806', 'Umsatzsteuer 19%',                                                         'A', 'I',         'AR_tax:IC_taxpart:IC_taxservice', '3805', 0,    511,  NULL, NULL, 6,    FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3817', 'Umsatzsteuer aus in anderen EG-Land stpfl. Lieferungen',                   'A', ' ',         '',                                       '3817', 10,   NULL, 0,    NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3820', 'Umsatzsteuer-Vorauszahlungen',                                             'A', 'E',         '',                                       '3820', 0,    NULL, NULL, NULL, 28,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3830', 'Umsatzsteuer-Vorauszahlungen 1/11',                                        'A', 'E',         '',                                       '3830', 0,    NULL, NULL, NULL, 28,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3835', 'Umsatzsteuer nach § 13b UStG',                                             'A', 'I',         '',                                       '3833', 0,    NULL, 33,   NULL, 7,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3836', 'Umsatzsteuer nach § 13b UStG 16%',                                         'A', 'I',         '',                                       '3833', 0,    NULL, 33,   NULL, 7,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3837', 'Umsatzsteuer nach § 13b UStG 19%',                                         'A', 'I',         '',                                       '3833', 0,    NULL, 33,   NULL, 7,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3835', 'Umsatzsteuer nach Â§ 13b UStG',                                             'A', 'I',         '',                                       '3833', 0,    NULL, 33,   NULL, 7,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3836', 'Umsatzsteuer nach Â§ 13b UStG 16%',                                         'A', 'I',         '',                                       '3833', 0,    NULL, 33,   NULL, 7,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3837', 'Umsatzsteuer nach Â§ 13b UStG 19%',                                         'A', 'I',         '',                                       '3833', 0,    NULL, 33,   NULL, 7,    FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3841', 'Umsatzsteuer Vorjahr',                                                     'A', 'E',         '',                                       '3841', 0,    NULL, NULL, NULL, 28,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3845', 'Umsatzsteuer frühere Jahre',                                               'A', 'E',         '',                                       '3845', 0,    NULL, NULL, NULL, 28,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4110', 'Sonstige steuerfreie Umsätze Inland',                                      'A', 'I',         'AR_amount',                              '4110', 0,    NULL, NULL, NULL, 1,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4120', 'Steuerfreie Umsätze §4Nr.1a UstG',                                         'A', 'I',         'AR_amount:IC_sale:IC_income',            '4120', 0,    48,   1,    NULL, 1,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4125', 'Steuerfrei innergem. Lieferungen §41bUStG',                                'A', 'I',         'AR_amount:IC_sale:IC_income',            '4125', 0,    41,   1,    NULL, 1,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4130', 'Liefe.d.1.Abnehm.bei innergem.Dreiecksg §25b2UStG',                        'A', 'I',         'AR_amount:IC_sale:IC_income',            '4130', 0,    NULL, NULL, NULL, 1,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3845', 'Umsatzsteuer frÃ¼here Jahre',                                               'A', 'E',         '',                                       '3845', 0,    NULL, NULL, NULL, 28,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4110', 'Sonstige steuerfreie UmsÃ¤tze Inland',                                      'A', 'I',         'AR_amount',                              '4110', 0,    NULL, NULL, NULL, 1,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4120', 'Steuerfreie UmsÃ¤tze Â§4Nr.1a UstG',                                         'A', 'I',         'AR_amount:IC_sale:IC_income',            '4120', 0,    48,   1,    NULL, 1,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4125', 'Steuerfrei innergem. Lieferungen Â§41bUStG',                                'A', 'I',         'AR_amount:IC_sale:IC_income',            '4125', 0,    41,   1,    NULL, 1,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4130', 'Liefe.d.1.Abnehm.bei innergem.Dreiecksg Â§25b2UStG',                        'A', 'I',         'AR_amount:IC_sale:IC_income',            '4130', 0,    NULL, NULL, NULL, 1,    TRUE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4135', 'Steuerfr.innergem.Lief.v.Neufahrz.an Abn.o. USt-IdNr.',                    'A', 'I',         'AR_amount:IC_sale',                      '4135', 0,    NULL, NULL, NULL, 1,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4150', 'Sonstige steuerfreie Umsätze §42-7UStG',                                   'A', 'I',         'AR_amount:IC_sale:IC_income',            '4150', 0,    NULL, NULL, NULL, 1,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4180', 'Erlöse,die mit den Durchschnittssätzen d.§24UStG vers.werd.',              'A', 'I',         'AR_amount',                              '4180', NULL, NULL, NULL, NULL, 1,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4185', 'Erlöse als Kleinunternehmer i.S.d.§19(1)UStG',                             'A', 'I',         'AR_amount',                              '4185', NULL, NULL, 1,    NULL, 1,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4200', 'Erlöse',                                                                   'A', 'I',         'AR_amount:IC_sale:IC_income',            '4200', 0,    NULL, 1,    NULL, 1,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4300', 'Erlöse 7% USt',                                                            'A', 'I',         'AR_amount:IC_sale:IC_income',            '4300', 2,    86,   1,    NULL, 1,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4310', 'Erlöse aus im Inland strpfl. EG-Lieferungen 7%',                           'A', 'I',         'AR_amount:IC_sale:IC_income',            '4310', 12,   86,   1,    NULL, 1,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4315', 'Erlöse aus im Inland strpfl. EG-Lieferungen 19%',                          'A', 'I',         'AR_amount:IC_sale:IC_income',            '4315', 13,   51,   1,    NULL, 1,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4320', 'Erlöse aus im anderen EG-Land strpfl. Lieferungen',                        'A', 'I',         'AR_amount:IC_sale:IC_income',            '4320', 10,   NULL, 1,    NULL, 1,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4330', 'Erlöse aus im Inland strpfl. EG-Lieferungen 16%',                          'A', 'I',         'AR_amount:IC_sale:IC_income',            '4315', 13,   51,   1,    NULL, 1,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4340', 'Erlöse 16% USt',                                                           'A', 'I',         'AR_amount:IC_sale:IC_income',            '4400', 5,    51,   1,    NULL, 1,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4400', 'Erlöse 19% USt',                                                           'A', 'I',         'AR_amount:IC_sale:IC_income',            '4400', 3,    51,   1,    NULL, 1,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4500', 'Provisionserlöse',                                                         'A', 'I',         'AR_amount:IC_income',                    '4500', 3,    51,   5,    NULL, 2,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4504', 'Steuerfreie Umsätze §4Nr.8ff UstG',                                        'A', 'I',         'AR_amount',                              '4504', 0,    0,    1,    NULL, NULL, TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4566', 'Provisionserlöse 7% USt.',                                                 'A', 'I',         'AR_amount:IC_income',                    '4506', 2,    86,   NULL, NULL, 2,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4568', 'Provisionserlöse 16% USt',                                                 'A', 'I',         'AR_amount:IC_income',                    '4508', 5,    51,   NULL, NULL, 2,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4569', 'Provisionserlöse 19% USt',                                                 'A', 'I',         'AR_amount:IC_income',                    '4508', 3,    51,   NULL, NULL, 2,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4510', 'Erlöse Abfallverwertung',                                                  'A', 'I',         'AR_amount:IC_sale',                      '4510', 3,    NULL, NULL, NULL, 2,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4520', 'Erlös Leergut',                                                            'A', 'I',         'AR_amount:IC_sale',                      '4520', 3,    51,   5,    NULL, 2,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4580', 'Erlöse zum allg.Umsatzsteuersatz (EÜR)',                                   'A', 'I',         '',                                       '4580', 0,    0,    1,    NULL, 1,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4581', 'Erlöse zum ermä.Umsatzsteuersatz (EÜR)',                                   'A', 'I',         '',                                       '4581', 0,    0,    1,    NULL, 1,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4582', 'Erlöse steuerfrei u.nicht steuerbar (EÜR)',                                'A', 'I',         '',                                       '4582', 0,    0,    1,    NULL, 1,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4589', 'Gegenkonto 8580-8582 b.Aufteilung d.Erlöse n.Steuersätzen(EÜR)',           'A', 'C',         '',                                       '4589', 0,    NULL, NULL, NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4150', 'Sonstige steuerfreie UmsÃ¤tze Â§42-7UStG',                                   'A', 'I',         'AR_amount:IC_sale:IC_income',            '4150', 0,    NULL, NULL, NULL, 1,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4180', 'ErlÃ¶se,die mit den DurchschnittssÃ¤tzen d.Â§24UStG vers.werd.',              'A', 'I',         'AR_amount',                              '4180', NULL, NULL, NULL, NULL, 1,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4185', 'ErlÃ¶se als Kleinunternehmer i.S.d.Â§19(1)UStG',                             'A', 'I',         'AR_amount',                              '4185', NULL, NULL, 1,    NULL, 1,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4200', 'ErlÃ¶se',                                                                   'A', 'I',         'AR_amount:IC_sale:IC_income',            '4200', 0,    NULL, 1,    NULL, 1,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4300', 'ErlÃ¶se 7% USt',                                                            'A', 'I',         'AR_amount:IC_sale:IC_income',            '4300', 2,    86,   1,    NULL, 1,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4310', 'ErlÃ¶se aus im Inland strpfl. EG-Lieferungen 7%',                           'A', 'I',         'AR_amount:IC_sale:IC_income',            '4310', 12,   86,   1,    NULL, 1,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4315', 'ErlÃ¶se aus im Inland strpfl. EG-Lieferungen 19%',                          'A', 'I',         'AR_amount:IC_sale:IC_income',            '4315', 13,   51,   1,    NULL, 1,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4320', 'ErlÃ¶se aus im anderen EG-Land strpfl. Lieferungen',                        'A', 'I',         'AR_amount:IC_sale:IC_income',            '4320', 10,   NULL, 1,    NULL, 1,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4330', 'ErlÃ¶se aus im Inland strpfl. EG-Lieferungen 16%',                          'A', 'I',         'AR_amount:IC_sale:IC_income',            '4315', 13,   51,   1,    NULL, 1,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4340', 'ErlÃ¶se 16% USt',                                                           'A', 'I',         'AR_amount:IC_sale:IC_income',            '4400', 5,    51,   1,    NULL, 1,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4400', 'ErlÃ¶se 19% USt',                                                           'A', 'I',         'AR_amount:IC_sale:IC_income',            '4400', 3,    51,   1,    NULL, 1,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4500', 'ProvisionserlÃ¶se',                                                         'A', 'I',         'AR_amount:IC_income',                    '4500', 3,    51,   5,    NULL, 2,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4504', 'Steuerfreie UmsÃ¤tze Â§4Nr.8ff UstG',                                        'A', 'I',         'AR_amount',                              '4504', 0,    0,    1,    NULL, NULL, TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4566', 'ProvisionserlÃ¶se 7% USt.',                                                 'A', 'I',         'AR_amount:IC_income',                    '4506', 2,    86,   NULL, NULL, 2,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4568', 'ProvisionserlÃ¶se 16% USt',                                                 'A', 'I',         'AR_amount:IC_income',                    '4508', 5,    51,   NULL, NULL, 2,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4569', 'ProvisionserlÃ¶se 19% USt',                                                 'A', 'I',         'AR_amount:IC_income',                    '4508', 3,    51,   NULL, NULL, 2,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4510', 'ErlÃ¶se Abfallverwertung',                                                  'A', 'I',         'AR_amount:IC_sale',                      '4510', 3,    NULL, NULL, NULL, 2,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4520', 'ErlÃ¶s Leergut',                                                            'A', 'I',         'AR_amount:IC_sale',                      '4520', 3,    51,   5,    NULL, 2,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4580', 'ErlÃ¶se zum allg.Umsatzsteuersatz (EÃR)',                                   'A', 'I',         '',                                       '4580', 0,    0,    1,    NULL, 1,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4581', 'ErlÃ¶se zum ermÃ¤.Umsatzsteuersatz (EÃR)',                                   'A', 'I',         '',                                       '4581', 0,    0,    1,    NULL, 1,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4582', 'ErlÃ¶se steuerfrei u.nicht steuerbar (EÃR)',                                'A', 'I',         '',                                       '4582', 0,    0,    1,    NULL, 1,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4589', 'Gegenkonto 8580-8582 b.Aufteilung d.ErlÃ¶se n.SteuersÃ¤tzen(EÃR)',           'A', 'C',         '',                                       '4589', 0,    NULL, NULL, NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4600', 'Unentgeltliche Wertabgaben',                                               'A', 'I',         'AR_amount',                              '4600', 0,    NULL, NULL, NULL, 1,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4605', 'Entnahme von Gegenständen o. USt',                                         'A', 'I',         '',                                       '4605', 0,    NULL, 5,    NULL, 2,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4610', 'Entnahme (Waren) d. Unternehmer f. Zwecke außerh. des Untern. 7% USt','A', 'I', 'AR_amount', '4610', 2,    86,   5,    NULL, 3,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4619', 'Entnahme (Waren) d. Unternehmer f. Zwecke außerh. des Untern. o. USt','A', 'I', '',          '4619', 0,    NULL, 5,    NULL, 3,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4620', 'Entnahme (Waren) d. Unternehmer f. Zwecke außerh. des Untern. 19% USt',    'A', 'I',         'AR_amount',                              '4620', 3,    51,   5,    NULL, 3,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4630', 'Verwendung v.Gegenst.f.Zwecke außerhalb d.Unternehmens 7% USt.',           'A', 'I',         'AR_amount',                              '4630', 2,    86,   5,    NULL, 3,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4637', 'Verwendung v.Gegenständen f.Zwecke außerhalb d.Untern.o.USt.',             'A', 'I',         '',                                       '4639', 0,    NULL, NULL, NULL, 3,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4640', 'Verw. v. Gegenst. f. Zwecke außerh. des Untern. 19% USt',                  'A', 'I',         '',                                       '4640', 3,    51,   5,    NULL, 3,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4645', 'Verw. v. Gegenst. f. Zwecke außerh. des Untern. 19% USt (Kfz-Nutzung)',    'A', 'I',         '',                                       '4645', 0,    0,    5,    NULL, 3,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4646', 'Verw. v. Gegenst. f. Zwecke außerh. des Untern. 19% USt (Tel-Nutzung)',    'A', 'I',         '',                                       '4646', 0,    0,    5,    NULL, 3,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4605', 'Entnahme von GegenstÃ¤nden o. USt',                                         'A', 'I',         '',                                       '4605', 0,    NULL, 5,    NULL, 2,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4610', 'Entnahme (Waren) d. Unternehmer f. Zwecke auÃerh. des Untern. 7% USt','A', 'I', 'AR_amount', '4610', 2,    86,   5,    NULL, 3,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4619', 'Entnahme (Waren) d. Unternehmer f. Zwecke auÃerh. des Untern. o. USt','A', 'I', '',          '4619', 0,    NULL, 5,    NULL, 3,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4620', 'Entnahme (Waren) d. Unternehmer f. Zwecke auÃerh. des Untern. 19% USt',    'A', 'I',         'AR_amount',                              '4620', 3,    51,   5,    NULL, 3,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4630', 'Verwendung v.Gegenst.f.Zwecke auÃerhalb d.Unternehmens 7% USt.',           'A', 'I',         'AR_amount',                              '4630', 2,    86,   5,    NULL, 3,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4637', 'Verwendung v.GegenstÃ¤nden f.Zwecke auÃerhalb d.Untern.o.USt.',             'A', 'I',         '',                                       '4639', 0,    NULL, NULL, NULL, 3,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4640', 'Verw. v. Gegenst. f. Zwecke auÃerh. des Untern. 19% USt',                  'A', 'I',         '',                                       '4640', 3,    51,   5,    NULL, 3,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4645', 'Verw. v. Gegenst. f. Zwecke auÃerh. des Untern. 19% USt (Kfz-Nutzung)',    'A', 'I',         '',                                       '4645', 0,    0,    5,    NULL, 3,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4646', 'Verw. v. Gegenst. f. Zwecke auÃerh. des Untern. 19% USt (Tel-Nutzung)',    'A', 'I',         '',                                       '4646', 0,    0,    5,    NULL, 3,    TRUE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4660', 'Unentgeltl. Erbringung sonst. Leist. 19% USt',                             'A', 'I',         'AR_amount',                              '4660', 3,    51,   NULL, NULL, 3,    TRUE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4670', 'Unentgeltl. Zuwend. Waren 19% USt',                                        'A', 'I',         '',                                       '4670', 2,    86,   5,    NULL, 3,    TRUE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4679', 'Unentgeltl. Zuwend. Waren o. USt',                                         'A', 'I',         '',                                       '4679', 0,    NULL, 5,    NULL, 3,    FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4680', 'Unentgeltl.Zuw.v Waren 16% Ust',                                           'A', 'I',         '',                                       '4680', 3,    51,   5,    NULL, 3,    TRUE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4686', 'Unentgeltl. Zuwend. Gegenst. 19% USt',                                     'A', 'I',         'AR_amount',                              '4686', 3,    51,   NULL, NULL, 3,    TRUE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4689', 'Unentgeltl. Zuwend. Gegenst. o. USt',                                      'A', 'I',         '',                                       '4689', 0,    NULL, 5,    NULL, 3,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4690', 'Nicht steuerbare Umsätze (Innenumsätze)',                                  'A', 'I',         '',                                       '4690', 0,    NULL, 5,    NULL, 1,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4695', 'Umsatzsteuervergütungen',                                                  'A', 'I',         '',                                       '4695', 0,    NULL, NULL, NULL, 7,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4700', 'Erlösschmälerungen',                                                       'A', 'I',         '',                                       '4700', 0,    NULL, 32,   NULL, 1,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4710', 'Erlösschmälerung 7% USt.',                                                 'A', 'I',         '',                                       '4710', 2,    86,   32,   NULL, 1,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4720', 'Erlösschmälerung 19% USt.',                                                'A', 'I',         '',                                       '4720', 3,    51,   32,   NULL, 1,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4723', 'Erlösschmälerung 16% USt.',                                                'A', 'I',         '',                                       '4720', 5,    51,   32,   NULL, 1,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4725', 'Erlösschmäler aus im inl. Stpflcht. EG-Lieferungen 7%USt',                 'A', 'I',         '',                                       '4725', 12,   86,   32,   NULL, 1,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4726', 'Erlösschmäler aus im inl. Stpflcht. EG-Lieferungen 19% USt',               'A', 'I',         '',                                       '4726', 13,   51,   32,   NULL, 1,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4727', 'Erlösschmäler. im and. EG-land Stpflchtg. Lieferungen',                    'A', 'I',         '',                                       '4727', 0,    NULL, 32,   NULL, 1,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4729', 'Erlösschmäler. aus im inl. Stpflcht. EG-Lieferungen 16% USt',              'A', 'I',         '',                                       '4727', 0,    NULL, 32,   NULL, 1,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4731', 'Gewährte Skonti 7% USt',                                                   'A', 'E',         'AR_paid',                                '4731', 2,    86,   1,    NULL, 1,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4735', 'Gewährte Skonti 16% USt',                                                  'A', 'E',         'AR_paid',                                '4735', 5,    51,   1,    NULL, 1,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4736', 'Gewährte Skonti 19% USt',                                                  'A', 'E',         'AR_paid',                                '4735', 3,    51,   1,    NULL, 1,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4750', 'Gewährte Boni 7% USt',                                                     'A', 'E',         'AR_paid',                                '4750', 2,    86,   1,    NULL, 1,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4760', 'Gewährte Boni 19% USt',                                                    'A', 'E',         'AR_paid',                                '4760', 3,    51,   1,    NULL, 1,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4762', 'Gewährte Boni 16% USt',                                                    'A', 'E',         'AR_paid',                                '4760', 5,    51,   1,    NULL, 1,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4780', 'Gewährte Rabatte 7% USt',                                                  'A', 'E',         'AR_paid',                                '4780', 2,    86,   1,    NULL, 1,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4790', 'Gewährte Rabatte 19% USt',                                                 'A', 'E',         'AR_paid',                                '4790', 3,    51,   1,    NULL, 1,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4792', 'Gewährte Rabatte 16% USt',                                                 'A', 'E',         'AR_paid',                                '4790', 5,    51,   1,    NULL, 1,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4800', 'Bestandsveränd. fert. Erzeugnisse',                                        'A', 'E',         '',                                       '4800', 0,    0,    2,    NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4810', 'Bestandsveränd. unfert. Erzeugnisse',                                      'A', 'E',         '',                                       '4810', 0,    0,    2,    NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4815', 'Bestandsveränd. unfert. Leistungen',                                       'A', 'E',         '',                                       '4815', 0,    0,    2,    NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4690', 'Nicht steuerbare UmsÃ¤tze (InnenumsÃ¤tze)',                                  'A', 'I',         '',                                       '4690', 0,    NULL, 5,    NULL, 1,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4695', 'UmsatzsteuervergÃ¼tungen',                                                  'A', 'I',         '',                                       '4695', 0,    NULL, NULL, NULL, 7,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4700', 'ErlÃ¶sschmÃ¤lerungen',                                                       'A', 'I',         '',                                       '4700', 0,    NULL, 32,   NULL, 1,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4710', 'ErlÃ¶sschmÃ¤lerung 7% USt.',                                                 'A', 'I',         '',                                       '4710', 2,    86,   32,   NULL, 1,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4720', 'ErlÃ¶sschmÃ¤lerung 19% USt.',                                                'A', 'I',         '',                                       '4720', 3,    51,   32,   NULL, 1,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4723', 'ErlÃ¶sschmÃ¤lerung 16% USt.',                                                'A', 'I',         '',                                       '4720', 5,    51,   32,   NULL, 1,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4725', 'ErlÃ¶sschmÃ¤ler aus im inl. Stpflcht. EG-Lieferungen 7%USt',                 'A', 'I',         '',                                       '4725', 12,   86,   32,   NULL, 1,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4726', 'ErlÃ¶sschmÃ¤ler aus im inl. Stpflcht. EG-Lieferungen 19% USt',               'A', 'I',         '',                                       '4726', 13,   51,   32,   NULL, 1,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4727', 'ErlÃ¶sschmÃ¤ler. im and. EG-land Stpflchtg. Lieferungen',                    'A', 'I',         '',                                       '4727', 0,    NULL, 32,   NULL, 1,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4729', 'ErlÃ¶sschmÃ¤ler. aus im inl. Stpflcht. EG-Lieferungen 16% USt',              'A', 'I',         '',                                       '4727', 0,    NULL, 32,   NULL, 1,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4731', 'GewÃ¤hrte Skonti 7% USt',                                                   'A', 'E',         'AR_paid',                                '4731', 2,    86,   1,    NULL, 1,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4735', 'GewÃ¤hrte Skonti 16% USt',                                                  'A', 'E',         'AR_paid',                                '4735', 5,    51,   1,    NULL, 1,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4736', 'GewÃ¤hrte Skonti 19% USt',                                                  'A', 'E',         'AR_paid',                                '4735', 3,    51,   1,    NULL, 1,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4750', 'GewÃ¤hrte Boni 7% USt',                                                     'A', 'E',         'AR_paid',                                '4750', 2,    86,   1,    NULL, 1,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4760', 'GewÃ¤hrte Boni 19% USt',                                                    'A', 'E',         'AR_paid',                                '4760', 3,    51,   1,    NULL, 1,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4762', 'GewÃ¤hrte Boni 16% USt',                                                    'A', 'E',         'AR_paid',                                '4760', 5,    51,   1,    NULL, 1,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4780', 'GewÃ¤hrte Rabatte 7% USt',                                                  'A', 'E',         'AR_paid',                                '4780', 2,    86,   1,    NULL, 1,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4790', 'GewÃ¤hrte Rabatte 19% USt',                                                 'A', 'E',         'AR_paid',                                '4790', 3,    51,   1,    NULL, 1,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4792', 'GewÃ¤hrte Rabatte 16% USt',                                                 'A', 'E',         'AR_paid',                                '4790', 5,    51,   1,    NULL, 1,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4800', 'BestandsverÃ¤nd. fert. Erzeugnisse',                                        'A', 'E',         '',                                       '4800', 0,    0,    2,    NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4810', 'BestandsverÃ¤nd. unfert. Erzeugnisse',                                      'A', 'E',         '',                                       '4810', 0,    0,    2,    NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4815', 'BestandsverÃ¤nd. unfert. Leistungen',                                       'A', 'E',         '',                                       '4815', 0,    0,    2,    NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4820', 'And.aktiv.Eigenleistungen',                                                'A', 'E',         '',                                       '4820', 0,    0,    3,    NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4830', 'Sonstige betrbl. Erträge',                                                 'A', 'I',         '',                                       '4830', 3,    51,   33,   NULL, 2,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4840', 'Erträge aus Kursdifferenzen',                                              'A', 'I',         '',                                       '4840', 0,    NULL, 33,   NULL, 2,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4835', 'Sonstige Erlöse betriebl.u.regelmäß',                                      'A', 'I',         'AR_amount',                              '4835', 3,    51,   5,    NULL, 2,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4837', 'Sonstige Erträge betrfremd und regelm.',                                   'A', 'I',         '',                                       '4837', 0,    NULL, 33,   NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6884', 'Erlöse a.Verk.Sachanlagen steuerfrei§4Nr.1aUStG(b.Buchverlust)',           'A', 'E',         '',                                       '4844', 0,    NULL, NULL, NULL, 1,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6885', 'Erlöse aus Verk. Sachanl.verm. 19% USt (bei Buchverlust)',                 'A', 'E',         '',                                       '4845', 0,    NULL, NULL, NULL, 2,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6888', 'Erlöse a.Verk.Sachanlagen steuerfrei§4Nr.1bUStG(b.Buchverlust)',           'A', 'E',         '',                                       '4848', 0,    NULL, NULL, NULL, 1,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4849', 'Erlöse aus Verk. Sachanl.verm. (bei Buchgewinn)',                          'A', 'I',         'AR_amount',                              '4849', 3,    51,   NULL, NULL, 1,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4860', 'Grundstückserträge',                                                       'A', 'I',         '',                                       '4860', 3,    51,   33,   NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4900', 'Erträge Abgang Gegst. d. Anlageverm.',                                     'A', 'I',         '',                                       '4900', 0,    NULL, 33,   NULL, 2,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4905', 'Erträge Abgang Gegst. d. Umlaufverm.',                                     'A', 'I',         '',                                       '4905', 0,    NULL, 33,   NULL, 2,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4910', 'Erträge Zuschreibung d. Sachanl.verm.',                                    'A', 'I',         '',                                       '4910', 0,    NULL, 33,   NULL, 2,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4915', 'Erträge Zuschreibung d. Umlaufverm.',                                      'A', 'I',         '',                                       '4915', 0,    NULL, 33,   NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4920', 'Erträge d. Herabs. Pauschwber. zu Forderungen',                            'A', 'I',         '',                                       '4920', 0,    NULL, 33,   NULL, 2,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4925', 'Erträge aus abgeschriebenen Forderungen',                                  'A', 'I',         '',                                       '4925', 0,    NULL, 33,   NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4930', 'Erträge aus Auflösung von Rückstellungen',                                 'A', 'I',         '',                                       '4930', 0,    NULL, 33,   NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4934', 'Erträge a.d.Auflösung v.SoPo m.Rücklageant.(Exitenzgründungszusch.)',      'A', 'I',         '',                                       '4934', 0,    NULL, NULL, NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4939', 'Erträge aus Auflösung SoPo mit Rücklagenanteil (AnsparAfA)',               'A', 'I',         '',                                       '4939', 0,    NULL, 5,    NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4941', 'Sachbezüge 7% USt (Waren)',                                                'A', 'I',         'AR_amount',                              '4941', 2,    86,   5,    NULL, 2,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4945', 'Sachbezüge 19% Ust (Waren)',                                               'A', 'I',         'AR_amount',                              '4945', 3,    51,   5,    NULL, 2,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4946', 'Verrechnete sons. Sachbezüge',                                             'A', 'I',         'AR_amount',                              '4946', 0,    0,    5,    NULL, 2,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4960', 'Periodenfremde Erträge nicht außero',                                      'A', 'I',         '',                                       '4960', 0,    NULL, 33,   NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4970', 'Versicherungsentschädigungen',                                             'A', 'I',         '',                                       '4970', 0,    NULL, 33,   NULL, 2,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4981', 'Steuerfr.Erträge a.d.Auflös.v.SoPo m.Rücklageanteil',                      'A', 'I',         '',                                       '4981', 0,    NULL, NULL, NULL, 2,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4830', 'Sonstige betrbl. ErtrÃ¤ge',                                                 'A', 'I',         '',                                       '4830', 3,    51,   33,   NULL, 2,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4840', 'ErtrÃ¤ge aus Kursdifferenzen',                                              'A', 'I',         '',                                       '4840', 0,    NULL, 33,   NULL, 2,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4835', 'Sonstige ErlÃ¶se betriebl.u.regelmÃ¤Ã',                                      'A', 'I',         'AR_amount',                              '4835', 3,    51,   5,    NULL, 2,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4837', 'Sonstige ErtrÃ¤ge betrfremd und regelm.',                                   'A', 'I',         '',                                       '4837', 0,    NULL, 33,   NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6884', 'ErlÃ¶se a.Verk.Sachanlagen steuerfreiÂ§4Nr.1aUStG(b.Buchverlust)',           'A', 'E',         '',                                       '4844', 0,    NULL, NULL, NULL, 1,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6885', 'ErlÃ¶se aus Verk. Sachanl.verm. 19% USt (bei Buchverlust)',                 'A', 'E',         '',                                       '4845', 0,    NULL, NULL, NULL, 2,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6888', 'ErlÃ¶se a.Verk.Sachanlagen steuerfreiÂ§4Nr.1bUStG(b.Buchverlust)',           'A', 'E',         '',                                       '4848', 0,    NULL, NULL, NULL, 1,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4849', 'ErlÃ¶se aus Verk. Sachanl.verm. (bei Buchgewinn)',                          'A', 'I',         'AR_amount',                              '4849', 3,    51,   NULL, NULL, 1,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4860', 'GrundstÃ¼cksertrÃ¤ge',                                                       'A', 'I',         '',                                       '4860', 3,    51,   33,   NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4900', 'ErtrÃ¤ge Abgang Gegst. d. Anlageverm.',                                     'A', 'I',         '',                                       '4900', 0,    NULL, 33,   NULL, 2,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4905', 'ErtrÃ¤ge Abgang Gegst. d. Umlaufverm.',                                     'A', 'I',         '',                                       '4905', 0,    NULL, 33,   NULL, 2,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4910', 'ErtrÃ¤ge Zuschreibung d. Sachanl.verm.',                                    'A', 'I',         '',                                       '4910', 0,    NULL, 33,   NULL, 2,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4915', 'ErtrÃ¤ge Zuschreibung d. Umlaufverm.',                                      'A', 'I',         '',                                       '4915', 0,    NULL, 33,   NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4920', 'ErtrÃ¤ge d. Herabs. Pauschwber. zu Forderungen',                            'A', 'I',         '',                                       '4920', 0,    NULL, 33,   NULL, 2,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4925', 'ErtrÃ¤ge aus abgeschriebenen Forderungen',                                  'A', 'I',         '',                                       '4925', 0,    NULL, 33,   NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4930', 'ErtrÃ¤ge aus AuflÃ¶sung von RÃ¼ckstellungen',                                 'A', 'I',         '',                                       '4930', 0,    NULL, 33,   NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4934', 'ErtrÃ¤ge a.d.AuflÃ¶sung v.SoPo m.RÃ¼cklageant.(ExitenzgrÃ¼ndungszusch.)',      'A', 'I',         '',                                       '4934', 0,    NULL, NULL, NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4939', 'ErtrÃ¤ge aus AuflÃ¶sung SoPo mit RÃ¼cklagenanteil (AnsparAfA)',               'A', 'I',         '',                                       '4939', 0,    NULL, 5,    NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4941', 'SachbezÃ¼ge 7% USt (Waren)',                                                'A', 'I',         'AR_amount',                              '4941', 2,    86,   5,    NULL, 2,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4945', 'SachbezÃ¼ge 19% Ust (Waren)',                                               'A', 'I',         'AR_amount',                              '4945', 3,    51,   5,    NULL, 2,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4946', 'Verrechnete sons. SachbezÃ¼ge',                                             'A', 'I',         'AR_amount',                              '4946', 0,    0,    5,    NULL, 2,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4960', 'Periodenfremde ErtrÃ¤ge nicht auÃero',                                      'A', 'I',         '',                                       '4960', 0,    NULL, 33,   NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4970', 'VersicherungsentschÃ¤digungen',                                             'A', 'I',         '',                                       '4970', 0,    NULL, 33,   NULL, 2,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4981', 'Steuerfr.ErtrÃ¤ge a.d.AuflÃ¶s.v.SoPo m.RÃ¼cklageanteil',                      'A', 'I',         '',                                       '4981', 0,    NULL, NULL, NULL, 2,    FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4982', 'Sonst.steuerfreie Betriebseinnahmen',                                      'A', 'I',         '',                                       '4982', 0,    NULL, NULL, NULL, 2,    FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5190', 'Energiestoffe (Fert.)',                                                    'A', 'E',         'IC',                                     '5190', 9,    0,    4,    NULL, 8,    FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5300', 'Wareneingang 7% Vorsteuer',                                                'A', 'E',         'AP_amount:IC_cogs',                      '5300', 8,    NULL, 4,    NULL, 8,    TRUE);
@@ -174,10 +174,10 @@ INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, ta
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5440', 'Innergem.Erwerb v.Neufahrz.v.Lief.o.USt-IdNr. 19%VSt.u.19%USt.',           'A', 'E',         'AP_amount:IC_cogs',                      '5440', 19,   94,   NULL, NULL, 8,    TRUE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5550', 'Steuerfreier innergem.Erwerb',                                             'A', 'E',         'AP_amount:IC_cogs',                      '5550', 0,    91,   NULL, NULL, 8,    FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5559', 'Steuerfreie Einfuhren',                                                    'A', 'E',         'AP_amount:IC_cogs',                      '5559', 0,    91,   NULL, NULL, 8,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5580', 'Wareneinkauf z.allg.Umsatzsteuersatz (EÜR)',                               'A', 'E',         '',                                       '5580', 0,    0,    4,    NULL, 8,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5581', 'Wareneinkauf z.erm.Umsatzsteuersatz(EÜR)',                                 'A', 'E',         '',                                       '5581', 0,    0,    4,    NULL, 8,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5582', 'Wareneinkauf ohne Vorsteuerabzug(EÜR)',                                    'A', 'E',         '',                                       '5582', 0,    0,    4,    NULL, 8,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5589', 'Gegenkto.3580-3582 b.Aufteilung d.WE n.Steuersätzen(EüR)',                 'A', 'E',         '',                                       '5589', 0,    NULL, NULL, NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5580', 'Wareneinkauf z.allg.Umsatzsteuersatz (EÃR)',                               'A', 'E',         '',                                       '5580', 0,    0,    4,    NULL, 8,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5581', 'Wareneinkauf z.erm.Umsatzsteuersatz(EÃR)',                                 'A', 'E',         '',                                       '5581', 0,    0,    4,    NULL, 8,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5582', 'Wareneinkauf ohne Vorsteuerabzug(EÃR)',                                    'A', 'E',         '',                                       '5582', 0,    0,    4,    NULL, 8,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5589', 'Gegenkto.3580-3582 b.Aufteilung d.WE n.SteuersÃ¤tzen(EÃ¼R)',                 'A', 'E',         '',                                       '5589', 0,    NULL, NULL, NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5600', 'Nicht abziehbare Vorsteuer',                                               'A', 'E',         '',                                       '5600', 0,    NULL, 5,    NULL, 8,    FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5610', 'Nicht abziehb.Vorsteuer 7%',                                               'A', 'E',         '',                                       '5610', 0,    NULL, 5,    NULL, 8,    FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5660', 'Nicht abziehb.Vorsteuer 19%',                                              'A', 'E',         '',                                       '5650', 0,    NULL, 5,    NULL, 8,    FALSE);
@@ -192,77 +192,77 @@ INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, ta
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5794', 'Erhaltene Rabatte 16% Vorsteuer',                                          'A', 'I',         'AP_paid',                                '5790', 7,    NULL, 4,    NULL, NULL, TRUE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5800', 'Bezugsnebenkosten',                                                        'A', 'E',         'AP_amount:IC_cogs:IC_expense',           '5800', 0,    NULL, 4,    NULL, 8,    FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5820', 'Leergut',                                                                  'A', 'E',         'AP_amount:IC_cogs',                      '5820', 0,    NULL, 4,    NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5840', 'Zölle und Einfuhrabgaben',                                                 'A', 'E',         'AP_amount:IC_cogs',                      '5840', 0,    NULL, 4,    NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5840', 'ZÃ¶lle und Einfuhrabgaben',                                                 'A', 'E',         'AP_amount:IC_cogs',                      '5840', 0,    NULL, 4,    NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5860', 'Verrechnete Stoffkosten (GegenKto 5000-99)',                               'A', 'E',         'IC_cogs',                                '5860', 0,    NULL, 4,    NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5880', 'Bestandsveränd. Roh-, Hilfs-,  Betriebsstoffe/Waren',                      'A', 'E',         '',                                       '5880', 0,    NULL, 2,    NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5880', 'BestandsverÃ¤nd. Roh-, Hilfs-,  Betriebsstoffe/Waren',                      'A', 'E',         '',                                       '5880', 0,    NULL, 2,    NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5900', 'Fremdleistungen',                                                          'A', 'E',         'AP_amount',                              '5900', 9,    NULL, 5,    NULL, 8,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5915', 'Leist.v.ausländ.Untern. 7% VSt.u.7%USt.',                                  'A', 'E',         'AP_amount',                              '5915', 18,   NULL, 5,    NULL, 8,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5925', 'Leist.v.ausländ.Untern. 19% VSt.u.19%USt.',                                'A', 'E',         'AP_amount',                              '5925', 19,   NULL, 5,    NULL, 8,    TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6010', 'Löhne',                                                                    'A', 'E',         '',                                       '6010', 0,    NULL, 10,   NULL, 9,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6020', 'Gehälter',                                                                 'A', 'E',         '',                                       '6020', 0,    NULL, 10,   NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5915', 'Leist.v.auslÃ¤nd.Untern. 7% VSt.u.7%USt.',                                  'A', 'E',         'AP_amount',                              '5915', 18,   NULL, 5,    NULL, 8,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5925', 'Leist.v.auslÃ¤nd.Untern. 19% VSt.u.19%USt.',                                'A', 'E',         'AP_amount',                              '5925', 19,   NULL, 5,    NULL, 8,    TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6010', 'LÃ¶hne',                                                                    'A', 'E',         '',                                       '6010', 0,    NULL, 10,   NULL, 9,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6020', 'GehÃ¤lter',                                                                 'A', 'E',         '',                                       '6020', 0,    NULL, 10,   NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6026', 'Tantiemen',                                                                'A', 'E',         '',                                       '6026', 0,    NULL, 10,   NULL, 9,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6027', 'Geschäftsführergehälter',                                                  'A', 'E',         '',                                       '6027', 0,    NULL, 10,   NULL, 9,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6030', 'Aushilfslöhne',                                                            'A', 'E',         '',                                       '6030', 0,    NULL, 10,   NULL, 9,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6040', 'Pauschale Steuer für Aushilfen',                                           'A', 'E',         '',                                       '6040', 0,    NULL, 10,   NULL, 10,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6027', 'GeschÃ¤ftsfÃ¼hrergehÃ¤lter',                                                  'A', 'E',         '',                                       '6027', 0,    NULL, 10,   NULL, 9,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6030', 'AushilfslÃ¶hne',                                                            'A', 'E',         '',                                       '6030', 0,    NULL, 10,   NULL, 9,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6040', 'Pauschale Steuer fÃ¼r Aushilfen',                                           'A', 'E',         '',                                       '6040', 0,    NULL, 10,   NULL, 10,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6045', 'Bedienungsgelder',                                                         'A', 'E',         '',                                       '6045', 0,    NULL, 10,   NULL, 9,    FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6050', 'Ehegattengehalt',                                                          'A', 'E',         '',                                       '6050', 0,    NULL, 10,   NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6060', 'Freiwillige sozi.Aufw.lohnsteuerpflichtig.',                               'A', 'E',         '',                                       '6060', 0,    NULL, 10,   NULL, 10,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6069', 'Pauschale Steuer auf sonst. Bezüge (z.B. Fahrtkostenzuschuss)',            'A', 'E',         '',                                       '6069', 0,    NULL, NULL, NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6070', 'Krankengeldzuschüsse',                                                     'A', 'E',         '',                                       '6070', 0,    NULL, 10,   NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6080', 'Vermögenswirksame Leistungen',                                             'A', 'E',         '',                                       '6080', 0,    NULL, 10,   NULL, 9,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6090', 'Fahrtkostenerst.Wohnung/Arbeitsstät',                                      'A', 'E',         '',                                       '6090', 0,    NULL, 10,   NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6069', 'Pauschale Steuer auf sonst. BezÃ¼ge (z.B. Fahrtkostenzuschuss)',            'A', 'E',         '',                                       '6069', 0,    NULL, NULL, NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6070', 'KrankengeldzuschÃ¼sse',                                                     'A', 'E',         '',                                       '6070', 0,    NULL, 10,   NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6080', 'VermÃ¶genswirksame Leistungen',                                             'A', 'E',         '',                                       '6080', 0,    NULL, 10,   NULL, 9,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6090', 'Fahrtkostenerst.Wohnung/ArbeitsstÃ¤t',                                      'A', 'E',         '',                                       '6090', 0,    NULL, 10,   NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6110', 'Gesetzlich soziale Aufwendungen',                                          'A', 'E',         '',                                       '6110', 0,    0,    10,   NULL, 10,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6120', 'Beiträge zur Berufsgenossenschaft',                                        'A', 'E',         '',                                       '6120', 0,    NULL, 10,   NULL, 10,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6120', 'BeitrÃ¤ge zur Berufsgenossenschaft',                                        'A', 'E',         '',                                       '6120', 0,    NULL, 10,   NULL, 10,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6130', 'Freiwillig soziale Aufwendungen lohnsteuerfrei',                           'A', 'E',         '',                                       '6130', 0,    NULL, 10,   NULL, 10,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6147', 'Pauschale Lohnsteuer auf sonst.Bezüge(z.B.Direktversicherung',             'A', 'E',         '',                                       '6147', 0,    NULL, 10,   NULL, 9,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6200', 'Abschreibungen a.immat.Vermögensgeg',                                      'A', 'E',         '',                                       '6200', 0,    NULL, NULL, NULL, 25,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6147', 'Pauschale Lohnsteuer auf sonst.BezÃ¼ge(z.B.Direktversicherung',             'A', 'E',         '',                                       '6147', 0,    NULL, 10,   NULL, 9,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6200', 'Abschreibungen a.immat.VermÃ¶gensgeg',                                      'A', 'E',         '',                                       '6200', 0,    NULL, NULL, NULL, 25,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6205', 'Abschreibung auf Gesch.- o. Firmenwert',                                   'A', 'E',         '',                                       '6205', 0,    NULL, NULL, NULL, 25,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6210', 'Außerplan.AfA a.immat.Vermögensgeg.',                                      'A', 'E',         '',                                       '6210', 0,    NULL, 17,   NULL, 25,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6221', 'Abschreibung auf Gebäude',                                                 'A', 'E',         '',                                       '6221', 0,    NULL, 17,   NULL, 25,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6210', 'AuÃerplan.AfA a.immat.VermÃ¶gensgeg.',                                      'A', 'E',         '',                                       '6210', 0,    NULL, 17,   NULL, 25,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6221', 'Abschreibung auf GebÃ¤ude',                                                 'A', 'E',         '',                                       '6221', 0,    NULL, 17,   NULL, 25,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6220', 'Abschreibungen auf Sachanlagen (o.Kfz u.Geb.)',                            'A', 'E',         '',                                       '6220', 0,    NULL, 17,   NULL, 25,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6222', 'Abschreibungen auf Kfz',                                                   'A', 'E',         '',                                       '6222', 0,    NULL, 17,   NULL, 25,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6230', 'Außerplanmäßig Abschr.a.Sachanlagen',                                      'A', 'E',         '',                                       '6230', 0,    NULL, NULL, NULL, 25,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6231', 'Absetzung f.außergew.techn.u.wirtschaftl.AfA bei Gebäuden',                'A', 'E',         '',                                       '6231', 0,    NULL, 17,   NULL, 25,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6232', 'Absetzung f.außergew.techn.u.wirtschaftl.AfA des Kfz',                     'A', 'E',         '',                                       '6232', 0,    NULL, 17,   NULL, 25,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6233', 'Absetzung f.außergew.techn.u.wirtschaftl.AfA sonst.WG',                    'A', 'E',         '',                                       '6233', 0,    NULL, 17,   NULL, 25,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6230', 'AuÃerplanmÃ¤Ãig Abschr.a.Sachanlagen',                                      'A', 'E',         '',                                       '6230', 0,    NULL, NULL, NULL, 25,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6231', 'Absetzung f.auÃergew.techn.u.wirtschaftl.AfA bei GebÃ¤uden',                'A', 'E',         '',                                       '6231', 0,    NULL, 17,   NULL, 25,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6232', 'Absetzung f.auÃergew.techn.u.wirtschaftl.AfA des Kfz',                     'A', 'E',         '',                                       '6232', 0,    NULL, 17,   NULL, 25,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6233', 'Absetzung f.auÃergew.techn.u.wirtschaftl.AfA sonst.WG',                    'A', 'E',         '',                                       '6233', 0,    NULL, 17,   NULL, 25,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6240', 'Abschr.a.Sachanl.aufgr.steuerl.Sondervorschriften',                        'A', 'E',         '',                                       '6240', 0,    NULL, 17,   NULL, 25,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6241', 'Sonderabschreibung nach §7g(1)u.(2)EStG (ohne Kfz)',                       'A', 'E',         '',                                       '6241', 0,    NULL, 17,   NULL, 25,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6242', 'Sonderabschreibung n.§7g(1)u.(2)EStG (für Kfz)',                           'A', 'E',         '',                                       '6242', 0,    NULL, 17,   NULL, 25,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6241', 'Sonderabschreibung nach Â§7g(1)u.(2)EStG (ohne Kfz)',                       'A', 'E',         '',                                       '6241', 0,    NULL, 17,   NULL, 25,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6242', 'Sonderabschreibung n.Â§7g(1)u.(2)EStG (fÃ¼r Kfz)',                           'A', 'E',         '',                                       '6242', 0,    NULL, 17,   NULL, 25,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6250', 'Kaufleasing',                                                              'A', 'E',         'AP_amount',                              '6250', 0,    NULL, 20,   NULL, 24,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6260', 'Sofortabschreibung GWG',                                                   'A', 'E',         'AP_amount',                              '6260', 0,    NULL, NULL, NULL, 26,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6262', 'Abschreibungen auf aktivierte GWG',                                        'A', 'E',         '',                                       '6262', 0,    NULL, NULL, NULL, 25,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6270', 'Abschreibungen auf Finanzanlagen (unübl. hoch)',                           'A', 'E',         '',                                       '6270', NULL, NULL, NULL, NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6275', 'Abschr.a.Wertp.d.Umlaufvermögens (unübl. hoch)',                           'A', 'E',         '',                                       '6275', 0,    NULL, 17,   NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6280', 'Forderungsverlust (unübl. hoch)',                                          'A', 'E',         '',                                       '6280', 0,    NULL, 20,   NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6281', 'Forderungsverluste 7% USt (unübl. hoch)',                                  'A', 'E',         '',                                       '6281', 2,    86,   20,   NULL, NULL, TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6285', 'Forderungsverluste 16% USt (unübl. hoch)',                                 'A', 'E',         '',                                       '6285', 5,    51,   20,   NULL, NULL, TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6286', 'Forderungsverluste 19% USt (unübl. hoch)',                                 'A', 'E',         '',                                       '6285', 3,    51,   20,   NULL, NULL, TRUE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6287', 'Forderungsverluste 15% USt (unübl. hoch)',                                 'A', 'E',         '',                                       '6285', 3,    51,   20,   NULL, NULL, TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6270', 'Abschreibungen auf Finanzanlagen (unÃ¼bl. hoch)',                           'A', 'E',         '',                                       '6270', NULL, NULL, NULL, NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6275', 'Abschr.a.Wertp.d.UmlaufvermÃ¶gens (unÃ¼bl. hoch)',                           'A', 'E',         '',                                       '6275', 0,    NULL, 17,   NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6280', 'Forderungsverlust (unÃ¼bl. hoch)',                                          'A', 'E',         '',                                       '6280', 0,    NULL, 20,   NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6281', 'Forderungsverluste 7% USt (unÃ¼bl. hoch)',                                  'A', 'E',         '',                                       '6281', 2,    86,   20,   NULL, NULL, TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6285', 'Forderungsverluste 16% USt (unÃ¼bl. hoch)',                                 'A', 'E',         '',                                       '6285', 5,    51,   20,   NULL, NULL, TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6286', 'Forderungsverluste 19% USt (unÃ¼bl. hoch)',                                 'A', 'E',         '',                                       '6285', 3,    51,   20,   NULL, NULL, TRUE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6287', 'Forderungsverluste 15% USt (unÃ¼bl. hoch)',                                 'A', 'E',         '',                                       '6285', 3,    51,   20,   NULL, NULL, TRUE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6300', 'Sonstige betriebliche Aufwendungen',                                       'A', 'E',         'AP_amount',                              '6300', 9,    NULL, 20,   NULL, 24,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6303', 'Fremdleistungen',                                                          'A', 'E',         'AP_amount',                              '6303', 0,    NULL, 20,   NULL, 24,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6304', 'Sons.Aufw.betriebl. und regelmäßig',                                       'A', 'E',         'AP_amount',                              '6304', 9,    NULL, NULL, NULL, 24,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6304', 'Sons.Aufw.betriebl. und regelmÃ¤Ãig',                                       'A', 'E',         'AP_amount',                              '6304', 9,    NULL, NULL, NULL, 24,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6305', 'Raumkosten',                                                               'A', 'E',         'AP_amount',                              '6305', 9,    NULL, 11,   NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6310', 'Miete (unbewegl. WG)',                                                     'A', 'E',         'AP_amount',                              '6310', 9,    NULL, 11,   NULL, 11,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6315', 'Pacht (unbewegl. WG)',                                                     'A', 'E',         'AP_amount',                              '6315', 0,    NULL, NULL, NULL, 11,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6320', 'Heizung',                                                                  'A', 'E',         'AP_amount',                              '6320', 9,    NULL, 11,   NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6325', 'Gas,Strom, Wasser',                                                        'A', 'E',         'AP_amount',                              '6325', 9,    NULL, 11,   NULL, 12,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6330', 'Reinigung',                                                                'A', 'E',         'AP_amount',                              '6330', 9,    NULL, 11,   NULL, 24,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6335', 'Instandhaltung betrieb.Räume',                                             'A', 'E',         'AP_amount',                              '6335', 9,    NULL, 11,   NULL, 13,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6335', 'Instandhaltung betrieb.RÃ¤ume',                                             'A', 'E',         'AP_amount',                              '6335', 9,    NULL, 11,   NULL, 13,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6345', 'Sonstige Raumkosten',                                                      'A', 'E',         'AP_amount',                              '6345', 9,    NULL, 11,   NULL, 13,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6348', 'Aufwend.f.ein häusliches Arbeitszimmer(abziehb.Anteil)',                   'A', 'E',         '',                                       '6348', 0,    NULL, NULL, NULL, 24,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6349', 'Aufwend.f.ein häusliches Arbeitszimmer(nicht abziehb.Anteil)',             'A', 'E',         '',                                       '6349', 0,    0,    11,   NULL, 24,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6350', 'Grundstücksaufwendungen',                                                  'A', 'E',         '',                                       '6350', 9,    NULL, 31,   NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6348', 'Aufwend.f.ein hÃ¤usliches Arbeitszimmer(abziehb.Anteil)',                   'A', 'E',         '',                                       '6348', 0,    NULL, NULL, NULL, 24,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6349', 'Aufwend.f.ein hÃ¤usliches Arbeitszimmer(nicht abziehb.Anteil)',             'A', 'E',         '',                                       '6349', 0,    0,    11,   NULL, 24,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6350', 'GrundstÃ¼cksaufwendungen',                                                  'A', 'E',         '',                                       '6350', 9,    NULL, 31,   NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6390', 'Zuwend.,Spenden,steuerlich n.abziehbar',                                   'A', 'E',         '',                                       '6390', 0,    NULL, 31,   NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6405', 'Versicherungen für Gebäude',                                               'A', 'E',         '',                                       '6405', 0,    NULL, NULL, NULL, 24,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6420', 'Beiträge',                                                                 'A', 'E',         'AP_amount',                              '6420', 0,    NULL, NULL, NULL, 14,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6405', 'Versicherungen fÃ¼r GebÃ¤ude',                                               'A', 'E',         '',                                       '6405', 0,    NULL, NULL, NULL, 24,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6420', 'BeitrÃ¤ge',                                                                 'A', 'E',         'AP_amount',                              '6420', 0,    NULL, NULL, NULL, 14,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6400', 'Versicherungen',                                                           'A', 'E',         'AP_amount',                              '6400', 0,    NULL, 13,   NULL, 14,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6430', 'Sonstige Abgaben',                                                         'A', 'E',         'AP_amount',                              '6430', 0,    NULL, NULL, NULL, 14,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6436', 'Steuerl.abzugs.Verspätungszuschl.u.Zwangsgelder',                          'A', 'E',         '',                                       '6436', 0,    NULL, NULL, NULL, 31,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6437', 'Steuerl.n.abzugsf.Verspätungszuschläge u.Zwangsgelder',                    'A', 'E',         '',                                       '6437', 0,    NULL, NULL, NULL, 31,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6436', 'Steuerl.abzugs.VerspÃ¤tungszuschl.u.Zwangsgelder',                          'A', 'E',         '',                                       '6436', 0,    NULL, NULL, NULL, 31,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6437', 'Steuerl.n.abzugsf.VerspÃ¤tungszuschlÃ¤ge u.Zwangsgelder',                    'A', 'E',         '',                                       '6437', 0,    NULL, NULL, NULL, 31,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6440', 'Ausgleichsabgabe i.S.d.Schwerbehinterdengesetzes',                         'A', 'E',         '',                                       '6440', 0,    NULL, 10,   NULL, 10,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6460', 'Rep.u.Instandhaltungen v.techn.Anlagen u.Maschinen',                       'A', 'E',         'AP_amount',                              '6460', 9,    NULL, 18,   NULL, 19,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6470', 'Rep u. Instandh. v. Betr.- u. Geschäftsausstattung',                       'A', 'E',         'AP_amount',                              '6470', 9,    NULL, 18,   NULL, 19,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6495', 'Wartungskosten für Hard-u.Software',                                       'A', 'E',         'AP_amount:IC_expense',                   '6495', 9,    NULL, 18,   NULL, 19,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6470', 'Rep u. Instandh. v. Betr.- u. GeschÃ¤ftsausstattung',                       'A', 'E',         'AP_amount',                              '6470', 9,    NULL, 18,   NULL, 19,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6495', 'Wartungskosten fÃ¼r Hard-u.Software',                                       'A', 'E',         'AP_amount:IC_expense',                   '6495', 9,    NULL, 18,   NULL, 19,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6490', 'Sonstige Reparaturen u.Instandhalt.',                                      'A', 'E',         'AP_amount',                              '6490', 9,    NULL, NULL, NULL, 19,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6498', 'Mietleasing',                                                              'A', 'E',         'AP_amount',                              '6498', 0,    NULL, 20,   NULL, 24,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6500', 'Fahrzeugkosten',                                                           'A', 'E',         'AP_amount',                              '6500', 0,    NULL, NULL, NULL, 17,   FALSE);
@@ -272,49 +272,49 @@ INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, ta
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6550', 'Garagenmiete',                                                             'A', 'E',         'AP_amount',                              '6550', 0,    NULL, 14,   NULL, 17,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6560', 'Mietleasing Kfz',                                                          'A', 'E',         'AP_amount',                              '6560', 0,    NULL, 14,   NULL, 17,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6570', 'Sonstige Kfz-Kosten',                                                      'A', 'E',         'AP_amount',                              '6570', 9,    NULL, 14,   NULL, 17,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6580', 'Mautgebühren',                                                             'A', 'E',         '',                                       '6580', 0,    0,    14,   NULL, 17,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6590', 'Fahrzeugkosten f.Kfz,die nicht zum BV gehören',                            'A', 'E',         '',                                       '6590', 0,    NULL, NULL, NULL, 17,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6580', 'MautgebÃ¼hren',                                                             'A', 'E',         '',                                       '6580', 0,    0,    14,   NULL, 17,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6590', 'Fahrzeugkosten f.Kfz,die nicht zum BV gehÃ¶ren',                            'A', 'E',         '',                                       '6590', 0,    NULL, NULL, NULL, 17,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6595', 'Fremdfahrzeuge',                                                           'A', 'E',         'AP_amount',                              '6595', 0,    NULL, 14,   NULL, 17,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6600', 'Werbekosten',                                                              'A', 'E',         'AP_amount',                              '6600', 9,    NULL, 15,   NULL, 18,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6610', 'Geschenke bis 35 EUR abzugsfähig',                                         'A', 'E',         'AP_amount',                              '6610', 0,    NULL, 15,   NULL, 18,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6620', 'Geschenke über 35EUR nicht abzugsf.',                                      'A', 'E',         'AP_amount',                              '6620', 0,    NULL, 15,   NULL, 18,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6625', 'Geschenke ausschließl.betrieb.genut',                                      'A', 'E',         'AP_amount',                              '6625', 9,    NULL, NULL, NULL, 18,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6630', 'Repräsentationskosten',                                                    'A', 'E',         'AP_amount',                              '6630', 9,    NULL, 15,   NULL, 18,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6610', 'Geschenke bis 35 EUR abzugsfÃ¤hig',                                         'A', 'E',         'AP_amount',                              '6610', 0,    NULL, 15,   NULL, 18,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6620', 'Geschenke Ã¼ber 35EUR nicht abzugsf.',                                      'A', 'E',         'AP_amount',                              '6620', 0,    NULL, 15,   NULL, 18,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6625', 'Geschenke ausschlieÃl.betrieb.genut',                                      'A', 'E',         'AP_amount',                              '6625', 9,    NULL, NULL, NULL, 18,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6630', 'ReprÃ¤sentationskosten',                                                    'A', 'E',         'AP_amount',                              '6630', 9,    NULL, 15,   NULL, 18,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6640', 'Bewirtungskosten',                                                         'A', 'E',         'AP_amount',                              '6640', 9,    NULL, 20,   NULL, 18,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6643', 'Aufmerksamkeiten',                                                         'A', 'E',         'AP_amount',                              '6643', 9,    NULL, NULL, NULL, 18,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6644', 'Nicht abzugsfähige Bewirtungskosten',                                      'A', 'E',         'AP_amount',                              '6644', 0,    NULL, NULL, NULL, 18,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6645', 'Nicht abzugsf.Betriebsausg.a.Werbe-Repräsentatisonk.etc.',                 'A', 'E',         'AP_amount',                              '6645', 9,    NULL, 15,   NULL, 24,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6644', 'Nicht abzugsfÃ¤hige Bewirtungskosten',                                      'A', 'E',         'AP_amount',                              '6644', 0,    NULL, NULL, NULL, 18,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6645', 'Nicht abzugsf.Betriebsausg.a.Werbe-ReprÃ¤sentatisonk.etc.',                 'A', 'E',         'AP_amount',                              '6645', 9,    NULL, 15,   NULL, 24,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6650', 'Reisekosten Arbeitnehmer',                                                 'A', 'E',         'AP_amount',                              '6650', 9,    NULL, 15,   NULL, 18,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6663', 'Reisekosten Arbeitnehmer, Reisekosten',                                    'A', 'E',         'AP_amount',                              '6663', 8,    NULL, 15,   NULL, 18,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6664', 'Reisekosten Arbeitn.Verpflegungmehr',                                      'A', 'E',         'AP_amount',                              '6664', 0,    NULL, 15,   NULL, 18,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6660', 'Reisekosten Arbeitn.Übernachtungsaufwand',                                 'A', 'E',         'AP_amount',                              '6660', 0,    NULL, 15,   NULL, 18,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6660', 'Reisekosten Arbeitn.Ãbernachtungsaufwand',                                 'A', 'E',         'AP_amount',                              '6660', 0,    NULL, 15,   NULL, 18,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6668', 'Kilometerentgelderstattung Arbeitnehmer',                                  'A', 'E',         'AP_amount',                              '6668', 0,    NULL, 15,   NULL, 18,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6670', 'Reisekosten Unternehmer',                                                  'A', 'E',         'AP_amount',                              '6670', 9,    NULL, 15,   NULL, 18,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6673', 'Reisekosten Unternehmer, Reisekosten',                                     'A', 'E',         'AP_amount',                              '6673', 8,    NULL, 15,   NULL, 18,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6674', 'Reisekosten Untern.Verpflegungsmehr',                                      'A', 'E',         'AP_amount',                              '6674', 0,    NULL, 15,   NULL, 18,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6680', 'Reisekosten Untern.Übernachtungsauf',                                      'A', 'E',         'AP_amount',                              '6680', 0,    NULL, 15,   NULL, 18,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6689', 'Fahrten zw.Wohn.und Arbeitsstätte (nicht abziehb.Teil)',                   'A', 'E',         '',                                       '6688', 0,    NULL, NULL, NULL, 18,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6690', 'Fahrten zw.Wohn.-und Arbeitsstätte (Haben)',                               'A', 'E',         '',                                       '6689', 0,    NULL, NULL, NULL, 18,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6680', 'Reisekosten Untern.Ãbernachtungsauf',                                      'A', 'E',         'AP_amount',                              '6680', 0,    NULL, 15,   NULL, 18,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6689', 'Fahrten zw.Wohn.und ArbeitsstÃ¤tte (nicht abziehb.Teil)',                   'A', 'E',         '',                                       '6688', 0,    NULL, NULL, NULL, 18,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6690', 'Fahrten zw.Wohn.-und ArbeitsstÃ¤tte (Haben)',                               'A', 'E',         '',                                       '6689', 0,    NULL, NULL, NULL, 18,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6700', 'Kosten der Warenabgabe',                                                   'A', 'E',         'AP_amount:IC_cogs',                      '6700', 0,    NULL, NULL, NULL, 24,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6710', 'Verpackungsmaterial',                                                      'A', 'E',         'AP_amount:IC_cogs',                      '6710', 0,    NULL, NULL, NULL, 24,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6740', 'Ausgangsfracht',                                                           'A', 'E',         'AP_amount:IC_cogs',                      '6740', 0,    NULL, NULL, NULL, 24,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6760', 'Transportversicherung',                                                    'A', 'E',         'AP_amount:IC_cogs:IC_expense',           '6760', 0,    NULL, NULL, NULL, 24,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6770', 'Verkaufsprovision',                                                        'A', 'E',         'AP_amount:IC_expense',                   '6770', 0,    NULL, NULL, NULL, 24,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6780', 'Fremdarbeiten (Vertrieb)',                                                 'A', 'E',         'AP_amount:IC_expense',                   '6780', 0,    NULL, NULL, NULL, 24,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6790', 'Aufwand für Gewährleistungen',                                             'A', 'E',         'AP_amount:IC_expense',                   '6790', 0,    NULL, 20,   NULL, 24,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6790', 'Aufwand fÃ¼r GewÃ¤hrleistungen',                                             'A', 'E',         'AP_amount:IC_expense',                   '6790', 0,    NULL, 20,   NULL, 24,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6800', 'Porto',                                                                    'A', 'E',         'AP_amount',                              '6800', 0,    NULL, 20,   NULL, 23,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6805', 'Telefon',                                                                  'A', 'E',         'AP_amount',                              '6805', 9,    NULL, 20,   NULL, 23,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6810', 'Telefax und Internet',                                                     'A', 'E',         'AP_amount',                              '6810', 9,    NULL, 20,   NULL, 23,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6815', 'Bürobedarf',                                                               'A', 'E',         'AP_amount',                              '6815', 9,    NULL, 20,   NULL, 23,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6820', 'Zeitschriften, Bücher',                                                    'A', 'E',         'AP_amount',                              '6820', 8,    NULL, 20,   NULL, 20,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6815', 'BÃ¼robedarf',                                                               'A', 'E',         'AP_amount',                              '6815', 9,    NULL, 20,   NULL, 23,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6820', 'Zeitschriften, BÃ¼cher',                                                    'A', 'E',         'AP_amount',                              '6820', 8,    NULL, 20,   NULL, 20,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6821', 'Fortbildungskosten',                                                       'A', 'E',         'AP_amount',                              '6821', 9,    NULL, NULL, NULL, 24,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6822', 'Freiwillige Sozialleistungen',                                             'A', 'E',         'AP_amount',                              '6822', 0,    NULL, NULL, NULL, 9,    FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6825', 'Rechts- und Beratungskosten',                                              'A', 'E',         'AP_amount',                              '6825', 9,    NULL, 20,   NULL, 22,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6827', 'Abschluß- und Prüfungskosten',                                             'A', 'E',         'AP_amount',                              '6827', 9,    NULL, 20,   NULL, 22,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6830', 'Buchführungskosten',                                                       'A', 'E',         'AP_amount',                              '6830', 9,    NULL, NULL, NULL, 24,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6835', 'Mieten für Einrichtungen',                                                 'A', 'E',         'AP_amount',                              '6835', 9,    NULL, 20,   NULL, 21,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6827', 'AbschluÃ- und PrÃ¼fungskosten',                                             'A', 'E',         'AP_amount',                              '6827', 9,    NULL, 20,   NULL, 22,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6830', 'BuchfÃ¼hrungskosten',                                                       'A', 'E',         'AP_amount',                              '6830', 9,    NULL, NULL, NULL, 24,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6835', 'Mieten fÃ¼r Einrichtungen',                                                 'A', 'E',         'AP_amount',                              '6835', 9,    NULL, 20,   NULL, 21,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6840', 'Mietleasing (bewegl. WG)',                                                 'A', 'E',         'AP_amount',                              '6840', 9,    NULL, 20,   NULL, 21,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6845', 'Werkzeuge und Kleingeräte',                                                'A', 'E',         'AP_amount',                              '6845', 9,    NULL, NULL, NULL, 19,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6845', 'Werkzeuge und KleingerÃ¤te',                                                'A', 'E',         'AP_amount',                              '6845', 9,    NULL, NULL, NULL, 19,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6850', 'Betriebsbedarf',                                                           'A', 'E',         'AP_amount',                              '6850', 9,    NULL, 20,   NULL, 24,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6855', 'Nebenkosten des Geldverkehrs',                                             'A', 'E',         '',                                       '6855', 0,    NULL, 20,   NULL, 24,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6859', 'Aufwend.f.Abraum-u.Abfallbeseitigung',                                     'A', 'E',         'AP_amount',                              '6859', 9,    NULL, 20,   NULL, 24,   FALSE);
@@ -322,35 +322,35 @@ INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, ta
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6870', 'Nicht abziehbare Vorsteuer 19%',                                           'A', 'E',         'AP_paid',                                '6870', 0,    NULL, 20,   NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6860', 'Nicht abziehbare Vorsteuer',                                               'A', 'E',         '',                                       '6860', 0,    NULL, 31,   NULL, 24,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6880', 'Aufwendungen aus Kursdifferenzen',                                         'A', 'E',         '',                                       '6880', 0,    NULL, 31,   NULL, 24,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6895', 'Abgänge Sachanlagen Restbuchwert',                                         'A', 'E',         '',                                       '6895', 0,    NULL, 31,   NULL, 2,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6895', 'AbgÃ¤nge Sachanlagen Restbuchwert',                                         'A', 'E',         '',                                       '6895', 0,    NULL, 31,   NULL, 2,    FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6900', 'Verluste aus Anlagenabgang',                                               'A', 'E',         '',                                       '6900', 0,    NULL, 31,   NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6926', 'Einstellungen in SoPo m.Rücklageanteil (Ansparabschreibung)',              'A', 'E',         '',                                       '6926', 0,    NULL, 20,   NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6960', 'Periodenfremde Aufwend.(soweit n.außerordentlich',                         'A', 'E',         '',                                       '6960', 0,    NULL, 31,   NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6967', 'Sonst. Aufwendungen betriebsfremd, regelmäßig',                            'A', 'E',         '',                                       '6967', 0,    NULL, 31,   NULL, 24,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6926', 'Einstellungen in SoPo m.RÃ¼cklageanteil (Ansparabschreibung)',              'A', 'E',         '',                                       '6926', 0,    NULL, 20,   NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6960', 'Periodenfremde Aufwend.(soweit n.auÃerordentlich',                         'A', 'E',         '',                                       '6960', 0,    NULL, 31,   NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6967', 'Sonst. Aufwendungen betriebsfremd, regelmÃ¤Ãig',                            'A', 'E',         '',                                       '6967', 0,    NULL, 31,   NULL, 24,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6970', 'Kalkulatorischer Unternehmerlohn',                                         'A', 'E',         '',                                       '6970', 0,    NULL, 34,   NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6974', 'Kalkulatorische Zinsen',                                                   'A', 'E',         '',                                       '6974', 0,    NULL, 34,   NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6976', 'Kalkulatorische Aschreibungen',                                            'A', 'E',         '',                                       '6976', 0,    NULL, 34,   NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6978', 'Kalkulatorische Wagnisse',                                                 'A', 'E',         '',                                       '6978', 0,    NULL, 34,   NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6979', 'Kalkulatorischer Lohn f.unentgeltl.Mitarbeiter',                           'A', 'E',         '',                                       '6979', 0,    NULL, 34,   NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7000', 'Erträge aus Beteiligungen',                                                'A', 'I',         '',                                       '7000', 0,    NULL, 33,   NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7100', 'Sonstige Zinsen und änliche Erträge',                                      'A', 'I',         '',                                       '7100', 0,    NULL, 32,   NULL, 4,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7120', 'Zinsähnliche Erträge',                                                     'A', 'I',         '',                                       '7120', 0,    NULL, 32,   NULL, 4,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7130', 'Diskonterträge',                                                           'A', 'I',         '',                                       '7130', 0,    NULL, 32,   NULL, 4,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7300', 'Zinsen und ähnl.Aufwendungen',                                             'A', 'E',         '',                                       '7300', 0,    NULL, 30,   NULL, 29,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7305', 'Zinsaufwendung-betriebliche Steuern §223aAO',                              'A', 'E',         '',                                       '7305', 0,    NULL, 30,   NULL, 29,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7000', 'ErtrÃ¤ge aus Beteiligungen',                                                'A', 'I',         '',                                       '7000', 0,    NULL, 33,   NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7100', 'Sonstige Zinsen und Ã¤nliche ErtrÃ¤ge',                                      'A', 'I',         '',                                       '7100', 0,    NULL, 32,   NULL, 4,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7120', 'ZinsÃ¤hnliche ErtrÃ¤ge',                                                     'A', 'I',         '',                                       '7120', 0,    NULL, 32,   NULL, 4,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7130', 'DiskontertrÃ¤ge',                                                           'A', 'I',         '',                                       '7130', 0,    NULL, 32,   NULL, 4,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7300', 'Zinsen und Ã¤hnl.Aufwendungen',                                             'A', 'E',         '',                                       '7300', 0,    NULL, 30,   NULL, 29,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7305', 'Zinsaufwendung-betriebliche Steuern Â§223aAO',                              'A', 'E',         '',                                       '7305', 0,    NULL, 30,   NULL, 29,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7310', 'Zinsaufwendung f. kurzf.Verbindlichk',                                     'A', 'E',         '',                                       '7310', 0,    NULL, 30,   NULL, 29,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7320', 'Zinsaufwendung f. langf.Verbindlichk',                                     'A', 'E',         '',                                       '7320', 0,    NULL, 30,   NULL, 29,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7325', 'Zinsaufwend.f.Gebäude,die z.Betriebsvermögen gehören',                     'A', 'E',         '',                                       '7325', 0,    NULL, NULL, NULL, 29,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7326', 'Zinsen zur Finanzierung Anlagevermögen',                                   'A', 'E',         '',                                       '7326', 0,    NULL, NULL, NULL, 29,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7330', 'Zinsähnliche Aufwendungen',                                                'A', 'E',         '',                                       '7330', 0,    NULL, 30,   NULL, 29,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7325', 'Zinsaufwend.f.GebÃ¤ude,die z.BetriebsvermÃ¶gen gehÃ¶ren',                     'A', 'E',         '',                                       '7325', 0,    NULL, NULL, NULL, 29,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7326', 'Zinsen zur Finanzierung AnlagevermÃ¶gen',                                   'A', 'E',         '',                                       '7326', 0,    NULL, NULL, NULL, 29,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7330', 'ZinsÃ¤hnliche Aufwendungen',                                                'A', 'E',         '',                                       '7330', 0,    NULL, 30,   NULL, 29,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7340', 'Diskontaufwendung',                                                        'A', 'E',         '',                                       '7340', 0,    NULL, 30,   NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7400', 'Außerordentliche Erträge',                                                 'A', 'I',         '',                                       '7400', 0,    NULL, 33,   NULL, 5,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7401', 'Ausserordentliche Erträge finanzwirksam',                                  'A', 'I',         '',                                       '7401', 0,    NULL, NULL, NULL, 5,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7450', 'Ausserordentliche Erträge nicht finanzwirksam',                            'A', 'I',         '',                                       '7450', 0,    NULL, NULL, NULL, 5,    FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7500', 'Außerordentliche Aufwendung',                                              'A', 'E',         '',                                       '7500', 0,    NULL, 31,   NULL, 30,   FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7600', 'Körperschaftssteuer',                                                      'A', 'E',         '',                                       '7600', 0,    NULL, 35,   NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7608', 'Solidaritätszuschlag',                                                     'A', 'E',         '',                                       '7608', 0,    NULL, 35,   NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7609', 'Solidaritätszuschlag für Vorjahr',                                         'A', 'E',         '',                                       '7609', 0,    NULL, 19,   NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7400', 'AuÃerordentliche ErtrÃ¤ge',                                                 'A', 'I',         '',                                       '7400', 0,    NULL, 33,   NULL, 5,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7401', 'Ausserordentliche ErtrÃ¤ge finanzwirksam',                                  'A', 'I',         '',                                       '7401', 0,    NULL, NULL, NULL, 5,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7450', 'Ausserordentliche ErtrÃ¤ge nicht finanzwirksam',                            'A', 'I',         '',                                       '7450', 0,    NULL, NULL, NULL, 5,    FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7500', 'AuÃerordentliche Aufwendung',                                              'A', 'E',         '',                                       '7500', 0,    NULL, 31,   NULL, 30,   FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7600', 'KÃ¶rperschaftssteuer',                                                      'A', 'E',         '',                                       '7600', 0,    NULL, 35,   NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7608', 'SolidaritÃ¤tszuschlag',                                                     'A', 'E',         '',                                       '7608', 0,    NULL, 35,   NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7609', 'SolidaritÃ¤tszuschlag fÃ¼r Vorjahr',                                         'A', 'E',         '',                                       '7609', 0,    NULL, 19,   NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7610', 'Gewerbesteuer',                                                            'A', 'E',         '',                                       '7610', 0,    NULL, 12,   NULL, 31,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7632', 'Kapitalertragssteuer 20%',                                                 'A', 'E',         '',                                       '7632', 0,    NULL, NULL, NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7634', 'Anrechenb.Soli auf Kapitalertragssteuer 20%',                              'A', 'E',         '',                                       '7634', 0,    NULL, 35,   NULL, NULL, FALSE);
@@ -358,21 +358,21 @@ INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, ta
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7638', 'Anrechb.Solidari.zuschlag a.Zinsabschlagst.',                              'A', 'E',         '',                                       '7638', 0,    NULL, 35,   NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7640', 'Gewerbestnachzahl.Vorj.v.Einkomm u.Ertrag',                                'A', 'E',         '',                                       '7640', 0,    NULL, 31,   NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7642', 'Gewerbesterstat.Vorj.Steuer v.Eink.u.Ertrag',                              'A', 'I',         '',                                       '7642', 0,    NULL, 33,   NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7644', 'Erträge aus Auflösung v. GewSt.Rückst.',                                   'A', 'I',         '',                                       '7644', 0,    NULL, 33,   NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7644', 'ErtrÃ¤ge aus AuflÃ¶sung v. GewSt.RÃ¼ckst.',                                   'A', 'I',         '',                                       '7644', 0,    NULL, 33,   NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7650', 'Sonstige Steuern',                                                         'A', 'E',         '',                                       '7650', 0,    NULL, 12,   NULL, 31,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7675', 'Verbrauchssteuer',                                                         'A', 'E',         '',                                       '7675', 0,    NULL, NULL, NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7678', 'Ökosteuer',                                                                'A', 'E',         '',                                       '7678', 0,    NULL, 12,   NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7678', 'Ãkosteuer',                                                                'A', 'E',         '',                                       '7678', 0,    NULL, 12,   NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7680', 'Grundsteuer',                                                              'A', 'E',         '',                                       '7680', 0,    NULL, 19,   NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7685', 'Kfz-Steuer',                                                               'A', 'E',         'AP_amount',                              '7685', 0,    NULL, 19,   NULL, 15,   FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7690', 'Steuernachzahlung Vorj.f.sons.Steue',                                      'A', 'E',         '',                                       '7690', 0,    NULL, 31,   NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7692', 'Steuererstattung Vorj.f.sons.Steuer',                                      'A', 'I',         '',                                       '7692', 0,    NULL, 33,   NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7694', 'Erträge a.d.Aufl.v. Rück.f.sons.Ste',                                      'A', 'E',         '',                                       '7694', 0,    NULL, 31,   NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7745', 'Entnahmen a.satzungsmäßigen Rücklagen',                                    'A', 'E',         '',                                       '7745', 0,    NULL, NULL, NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7694', 'ErtrÃ¤ge a.d.Aufl.v. RÃ¼ck.f.sons.Ste',                                      'A', 'E',         '',                                       '7694', 0,    NULL, 31,   NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7745', 'Entnahmen a.satzungsmÃ¤Ãigen RÃ¼cklagen',                                    'A', 'E',         '',                                       '7745', 0,    NULL, NULL, NULL, NULL, FALSE);
 
 
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('9000', 'Saldenvorträge,Sachkonten', 'A', 'A', '', '9000', 0, NULL, NULL, NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('9008', 'Saldenvorträge,Debitoren',  'A', 'A', '', '9008', 0, NULL, NULL, NULL, NULL, FALSE);
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('9009', 'Saldenvorträge,Kreditoren', 'A', 'L', '', '9009', 0, NULL, NULL, NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('9000', 'SaldenvortrÃ¤ge,Sachkonten', 'A', 'A', '', '9000', 0, NULL, NULL, NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('9008', 'SaldenvortrÃ¤ge,Debitoren',  'A', 'A', '', '9008', 0, NULL, NULL, NULL, NULL, FALSE);
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('9009', 'SaldenvortrÃ¤ge,Kreditoren', 'A', 'L', '', '9009', 0, NULL, NULL, NULL, NULL, FALSE);
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('9090', 'Summenvortragskonto',       'A', 'A', '', '9090', 0, NULL, NULL, NULL, NULL, FALSE);
 
 
@@ -386,8 +386,8 @@ INSERT INTO tax                                                     VALUES ((SEL
 INSERT INTO tax                                                     VALUES ((SELECT id FROM chart WHERE accno = '1401'),'0.07','1401','8','Vorsteuer');
 INSERT INTO tax                                                     VALUES ((SELECT id FROM chart WHERE accno = '1405'),'0.16','1405','7','Vorsteuer');
 INSERT INTO tax (chart_id, rate, taxnumber, taxkey, taxdescription) VALUES ((SELECT id FROM CHART WHERE accno='1406'), 0.19, '1406', 9, 'Vorsteuer');
-INSERT INTO tax (taxkey, taxdescription)                            VALUES ('10','Im anderen EG-Staat steuerpfl. Lieferung');
-INSERT INTO tax (taxkey, taxdescription)                            VALUES ('11','Steuerfreie EG-Lief. an Abn. mit UStIdNr');
+INSERT INTO tax (rate, taxkey, taxdescription)                      VALUES (0, '10','Im anderen EG-Staat steuerpfl. Lieferung');
+INSERT INTO tax (rate, taxkey, taxdescription)                      VALUES (0, '11','Steuerfreie EG-Lief. an Abn. mit UStIdNr');
 INSERT INTO tax (chart_id, rate,taxnumber, taxkey, taxdescription)  VALUES ((SELECT id FROM chart WHERE accno = '3802'),'0.07','3802','12','Steuerpflicht. EG-Lieferungen');
 INSERT INTO tax (chart_id,rate,taxnumber, taxkey, taxdescription)   VALUES ((SELECT id FROM chart WHERE accno = '3804'),'0.19','3804','13','Steuerpflicht. EG-Lieferungen%');
 INSERT INTO tax (chart_id,rate,taxnumber, taxkey, taxdescription)   VALUES ((SELECT id FROM chart WHERE accno = '3803'),'0.16','3803','15','Steuerpflicht. EG-Lieferungen%');
@@ -418,19 +418,19 @@ INSERT INTO buchungsgruppen
   ('Standard 19%',
    -- 1140: Bestand Waren
    (SELECT id FROM chart WHERE accno = '1140'),
-   -- 4400: Erlöse 19% USt.
+   -- 4400: ErlÃ¶se 19% USt.
    -- 5400: Wareneingang 19% Vorsteuer
    (SELECT id FROM chart WHERE accno = '4400'),
    (SELECT id FROM chart WHERE accno = '5400'),
-   -- 4125: Steuerfrei innergem. Lieferungen §41bUStG
+   -- 4125: Steuerfrei innergem. Lieferungen Â§41bUStG
    -- 5550: Steuerfreier innergem. Erwerb
    (SELECT id FROM chart WHERE accno = '4125'),
    (SELECT id FROM chart WHERE accno = '5550'),
-   -- 4315: Erlöse aus im Inland strpflichtigen EG-Lieferungen 19%
+   -- 4315: ErlÃ¶se aus im Inland strpflichtigen EG-Lieferungen 19%
    -- 5425: Innergem.Erwerb 19% VorSt und Ust
    (SELECT id FROM chart WHERE accno = '4315'),
    (SELECT id FROM chart WHERE accno = '5425'),
-   -- 4150: Sonstige steuerfreie Umsätze §42-7UStG
+   -- 4150: Sonstige steuerfreie UmsÃ¤tze Â§42-7UStG
    -- 5559: Steuerfreie Einfuhren
    (SELECT id FROM chart WHERE accno = '4150'),
    (SELECT id FROM chart WHERE accno = '5559'));
@@ -445,19 +445,19 @@ INSERT INTO buchungsgruppen
   ('Standard 7%',
    -- 1140: Bestand Waren
    (SELECT id FROM chart WHERE accno = '1140'),
-   -- 4300: Erlöse 7% USt
+   -- 4300: ErlÃ¶se 7% USt
    -- 5300: Wareneingang 7% Vorsteuer
    (SELECT id FROM chart WHERE accno = '4300'),
    (SELECT id FROM chart WHERE accno = '5300'),
-   -- 4125: Steuerfrei innergem. Lieferungen §41bUStG
+   -- 4125: Steuerfrei innergem. Lieferungen Â§41bUStG
    -- 5550: Steuerfreier innergem. Erwerb
    (SELECT id FROM chart WHERE accno = '4125'),
    (SELECT id FROM chart WHERE accno = '5550'),
-   -- 4310: Erlöse aus im Inland strpfl. EG-Lieferungen 7%
+   -- 4310: ErlÃ¶se aus im Inland strpfl. EG-Lieferungen 7%
    -- 5420: Innergemein.Erwerb 7% VorSt u. Ust
    (SELECT id FROM chart WHERE accno = '4310'),
    (SELECT id FROM chart WHERE accno = '5420'),
-   -- 4150: Sonstige steuerfreie Umsätze §42-7UStG
+   -- 4150: Sonstige steuerfreie UmsÃ¤tze Â§42-7UStG
    -- 5559; Steuerfreie Einfuhren
    (SELECT id FROM chart WHERE accno = '4150'),
    (SELECT id FROM chart WHERE accno = '5559'));
