Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 02a58c65

Von Moritz Bunkus vor fast 14 Jahren hinzugefügt

  • ID 02a58c655418aa2c4bcbda33e0e76b7cd433763d
  • Vorgänger 71dd004b
  • Nachfolger a921e75a

Kosmetik: Alignment

Unterschiede anzeigen:

sql/Germany-DATEV-SKR04EU-chart.sql
1 1
-- DATEV SKR04
2 2
-- IT Systems Service http://www.itsystemsservice.de
3 3
--
4
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);
5
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);
6
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);
7
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);
8
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);
9
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0500', 'Betriebs- und Gesch?ftsausstattung', 'A', 'A', 'AP_amount', '0500', 9, NULL, NULL, NULL, NULL, FALSE);
10
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);
11
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);
12
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0560', 'Sonst. Transportmittel', 'A', 'A', 'AP_amount', '0560', 9, NULL, NULL, NULL, NULL, FALSE);
13
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);
14
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);
15
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);
16
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.b.410EUR', 'A', 'A', 'AP_amount', '0670', 9, NULL, NULL, NULL, NULL, FALSE);
17
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', 'A', 'E', 'IC', '1000', 9, NULL, 4, NULL, NULL, FALSE);
18
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1140', 'Waren', 'A', 'E', 'IC', '1140', 9, NULL, 4, NULL, NULL, FALSE);
19
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1200', 'Ford. aus Lieferungen und Leistungen', 'A', 'A', 'AR', '1200', 0, NULL, NULL, NULL, NULL, FALSE);
20
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1215', 'Ford.a.LuL z.allg.USt-Satz', 'A', 'A', 'AR', '1215', 0, NULL, NULL, NULL, NULL, FALSE);
21
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1216', 'Ford.a.LuL z.erm.USt.-Satz (E?R)', 'A', 'A', 'AR', '1216', 0, NULL, NULL, NULL, NULL, FALSE);
22
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1217', 'Ford.a.steuerfr.od.nicht steuerb.LuL (E?R)', 'A', 'A', 'AR', '1217', 0, NULL, NULL, NULL, NULL, FALSE);
23
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1218', 'Ford.a.LuL gem.?24UStG(E?R)', 'A', 'A', 'AR', '1218', 0, NULL, NULL, NULL, NULL, FALSE);
24
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1219', 'Gegenkto. bei Aufteil.d.Ford.n.Steuers.(E?R)', 'A', 'A', '', '1219', 0, NULL, NULL, NULL, NULL, FALSE);
25
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1220', 'Ford.n.?11(1)2EStG f.?4/3 EStG', 'A', 'A', 'AR', '1220', 0, NULL, NULL, NULL, NULL, FALSE);
26
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1248', 'Pauschalwertbe.z.Ford.bis1J.', 'A', 'E', '', '1248', 0, NULL, 31, NULL, NULL, FALSE);
27
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1249', 'Pauschalwertbe.z.Ford.ueb1J.', 'A', 'E', '', '1249', 0, NULL, 31, NULL, NULL, FALSE);
28
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);
29
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);
30
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);
31
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 EG-Erwerb 7%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', '1402', 0, 61, NULL, NULL, 27, FALSE);
32
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 EG-Erwerb 16%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', '1403', 0, 61, NULL, NULL, 27, FALSE);
33
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);
34
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1407', 'Abziehb.Vorst.n.allgem.Durchschnittss?tzen UStVA Kz.63', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1407', 0, NULL, NULL, NULL, 27, FALSE);
35
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 n.?13b', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1408', 0, NULL, NULL, NULL, 27, FALSE);
36
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);
37
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);
38
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);
39
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);
40
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);
41
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);
42
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);
43
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);
44
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2100', 'Privatentnahme allgemein', 'A', 'Q', '', '2100', 0, NULL, NULL, NULL, NULL, FALSE);
45
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);
46
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);
47
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);
48
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. abzugsf?hig', 'A', 'Q', '', '2230', 0, NULL, NULL, NULL, NULL, FALSE);
49
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);
50
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2953', 'Satzungsm.R?cklagen 0% Vorbelast.EK02', 'A', 'Q', '', '2953', 0, NULL, NULL, NULL, NULL, FALSE);
51
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3151', 'Vblk.geg.Kreditinst.- Restlaufzeit b.1 Jahr', 'A', 'A', '', '3151', 0, NULL, NULL, NULL, NULL, FALSE);
52
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3160', 'Vblk.geg.Kreditinst.- Restlaufzeit 1 bis 5 Jahre', 'A', 'A', '', '3160', 0, NULL, NULL, NULL, NULL, FALSE);
53
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3170', 'Vblk.geg.Kreditinst.- Restlaufzeit gr?sser als 5 Jahre', 'A', 'A', '', '3170', 0, NULL, NULL, NULL, NULL, FALSE);
54
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);
55
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3305', 'Vblk.a.LuL z.allg.Umsatzsteuersatz (E?R)', 'A', 'L', 'AP', '3305', 0, NULL, NULL, NULL, NULL, FALSE);
56
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3306', 'Vblk.a.LuL zum erm.Umsatzsteuersatz (E?R)', 'A', 'L', 'AP', '3306', 0, NULL, NULL, NULL, NULL, FALSE);
57
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3307', 'Vblk.a.LuL ohne Vorsteuer (E?R)', 'A', 'L', 'AP', '3307', 0, NULL, NULL, NULL, NULL, FALSE);
58
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3309', 'Gegenkonto 1605-1607 b.Aufteilung d.Vblk.n.Steuers.(E?R)', 'A', 'L', '', '3309', 0, NULL, NULL, NULL, NULL, FALSE);
59
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);
60
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 EG-Erwerb 7%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', '3802', 0, NULL, NULL, NULL, 6, FALSE);
61
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 EG-Erwerb 16%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', '3803', 0, NULL, NULL, NULL, 28, FALSE);
62
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);
63
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3817', 'Umsatzsteuer a.i.anderen EG-Land stpfl.Lieferungen', 'A', ' ', '', '3817', 10, NULL, 0, NULL, NULL, FALSE);
64
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);
65
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);
66
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3833', 'Umsatzsteuer n.?13b UStG', 'A', 'I', '', '3833', 0, NULL, 33, NULL, 7, FALSE);
67
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);
68
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);
69
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);
70
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);
71
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);
72
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);
73
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-Ident-Nr.', 'A', 'I', 'AR_amount:IC_sale', '4135', 0, NULL, NULL, NULL, 1, TRUE);
74
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);
75
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);
76
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);
77
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);
78
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);
79
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 Inland stpfl. EG-Lieferung7%', 'A', 'I', 'AR_amount:IC_sale:IC_income', '4310', 12, 86, 1, NULL, 1, TRUE);
80
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4315', 'Erl?s Inland stpfl.EG-Lieferung 16%', 'A', 'I', 'AR_amount:IC_sale:IC_income', '4315', 13, 51, 1, NULL, 1, TRUE);
81
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 and.EG-Land steuerpfl.Lieferungen', 'A', 'I', 'AR_amount:IC_sale:IC_income', '4320', 10, NULL, 1, NULL, 1, FALSE);
82
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 16% USt.', 'A', 'I', 'AR_amount:IC_sale:IC_income', '4400', 3, 51, 1, NULL, 1, TRUE);
83
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);
84
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);
85
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4506', 'Provisionserl?se 7% USt.', 'A', 'I', 'AR_amount:IC_income', '4506', 2, 86, NULL, NULL, 2, FALSE);
86
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4508', 'Provisionserl?se 16% USt.', 'A', 'I', 'AR_amount:IC_income', '4508', 3, 51, NULL, NULL, 2, FALSE);
87
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);
88
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);
89
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);
90
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);
91
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);
92
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);
93
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);
94
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4605', 'Entnahme v. Gegenst.o.USt.', 'A', 'I', '', '4605', 0, NULL, 5, NULL, 2, FALSE);
95
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4610', 'Entnah.d.Untern.f.Zwecke ausserh.d.Untern.7%USt', 'A', 'I', 'AR_amount', '4610', 2, 86, 5, NULL, 3, TRUE);
96
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4619', 'Entnahme durch den Untern.f.Zwecke au?erhalb d.Untern.(Waren)o.USt', 'A', 'I', '', '4619', 0, NULL, 5, NULL, 3, FALSE);
97
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4620', 'Entnahme des Untern.f.Zwecke ausserh.d.Untern 16%(Waren)', 'A', 'I', 'AR_amount', '4620', 3, 51, 5, NULL, 3, TRUE);
98
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);
99
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4639', 'Verwendung v.Gegenst?nden f.Zwecke au?erhalb d.Untern.o.USt.', 'A', 'I', '', '4639', 0, NULL, NULL, NULL, 3, FALSE);
100
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.Gegens.f.Zwecke ausserh.d.Untern.16%USt.', 'A', 'I', '', '4640', 3, 51, 5, NULL, 3, TRUE);
101
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4645', 'Verwend.v.Gegenst.f.Zwecke au?erh.d.Untern.16%USt(Kfz-Nutzung)', 'A', 'I', '', '4645', 0, 0, 5, NULL, 3, TRUE);
102
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4646', 'Verwend.f.Gegenst.f.Zwecke au?erh.d.Untern.16%USt(Telefonnutzung)', 'A', 'I', '', '4646', 0, 0, 5, NULL, 3, TRUE);
103
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4660', 'Unentgeltl.Erbring.sons.Leis.16%USt', 'A', 'I', 'AR_amount', '4660', 3, 51, NULL, NULL, 3, TRUE);
104
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4670', 'Unentgeltl.Zuw.von Waren 7% Ust', 'A', 'I', '', '4670', 2, 86, 5, NULL, 3, TRUE);
105
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4679', 'Unentgeltl.Zuwendung v.Waren o.USt.', 'A', 'I', '', '4679', 0, NULL, 5, NULL, 3, FALSE);
106
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);
107
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.v.Gegens. 16% Ust', 'A', 'I', 'AR_amount', '4686', 3, 51, NULL, NULL, 3, TRUE);
108
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4689', 'Unentgeltl.Zuw.v.Gegens.ohne Ust', 'A', 'I', '', '4689', 0, NULL, 5, NULL, 3, FALSE);
109
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', 'A', 'I', '', '4690', 0, NULL, 5, NULL, 1, FALSE);
110
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);
111
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);
112
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);
113
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 16% USt.', 'A', 'I', '', '4720', 3, 51, 32, NULL, 1, TRUE);
114
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?.Inl.stpfl.EG-Lief. 7%USt', 'A', 'I', '', '4725', 12, 86, 32, NULL, 1, TRUE);
115
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?.Inl.stpfl.EG-Lief.16%USt', 'A', 'I', '', '4726', 13, 51, 32, NULL, 1, TRUE);
116
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?.and.EG Land stpfl.Liefer', 'A', 'I', '', '4727', 0, NULL, 32, NULL, 1, FALSE);
117
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);
118
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', 3, 51, 1, NULL, 1, FALSE);
119
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);
120
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 16% USt.', 'A', 'E', 'AR_paid', '4760', 3, 51, 1, NULL, 1, TRUE);
121
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);
122
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 16% Ust.', 'A', 'E', 'AR_paid', '4790', 3, 51, 1, NULL, 1, TRUE);
123
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..Leist.', 'A', 'E', '', '4800', 0, 0, 2, NULL, NULL, FALSE);
124
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4810', 'Bestandsver?nderung unf.Erz.', 'A', 'E', '', '4810', 0, 0, 2, NULL, NULL, FALSE);
125
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.unf.Leist.', 'A', 'E', '', '4815', 0, 0, 2, NULL, NULL, FALSE);
126
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);
127
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4830', 'Sonstige Ertr?ge', 'A', 'I', '', '4830', 3, 51, 33, NULL, 2, FALSE);
128
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);
129
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);
130
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4837', 'Betriebsfremde Ertr?ge nichtau?erorden', 'A', 'I', '', '4837', 0, NULL, 33, NULL, NULL, FALSE);
131
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4844', 'Erl?se a.Verk.Sachanlagen steuerfrei?4Nr.1aUStG(b.Buchverlust)', 'A', 'E', '', '4844', 0, NULL, NULL, NULL, 1, TRUE);
132
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4845', 'Erl?se aus Verk.Sachanlageverm?gen16% USt (bei Buchverlust)', 'A', 'E', '', '4845', 0, NULL, NULL, NULL, 2, TRUE);
133
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4848', 'Erl?se a.Verk.Sachanlagen steuerfrei?4Nr.1bUStG(b.Buchverlust)', 'A', 'E', '', '4848', 0, NULL, NULL, NULL, 1, TRUE);
134
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 Anlagenverk?ufen', 'A', 'I', 'AR_amount', '4849', 3, 51, NULL, NULL, 1, FALSE);
135
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);
136
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 aus Abgang von AV-Gegenst?nden', 'A', 'I', '', '4900', 0, NULL, 33, NULL, 2, FALSE);
137
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4905', 'Ertr.a.d.Abg.v.Gegenst.d.Umlaufverm', 'A', 'I', '', '4905', 0, NULL, 33, NULL, 2, FALSE);
138
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4910', 'Ertrag a.d.Zuschreib.d.Anlageverm?g', 'A', 'I', '', '4910', 0, NULL, 33, NULL, 2, FALSE);
139
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4915', 'Ertr.a.Zuschreib.d.Umlaufverm?gens', 'A', 'I', '', '4915', 0, NULL, 33, NULL, NULL, FALSE);
140
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4920', 'Ertr.a.Herabsetzung d.PWB zu Forderungen', 'A', 'I', '', '4920', 0, NULL, 33, NULL, 2, FALSE);
141
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4925', 'Ertr. aus abgeschriebenen Forderung', 'A', 'I', '', '4925', 0, NULL, 33, NULL, NULL, FALSE);
142
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4930', 'Ertr.a.d.Aufl?sung v.R?ckstellungen', 'A', 'I', '', '4930', 0, NULL, 33, NULL, NULL, FALSE);
143
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);
144
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 Aufl. Sopo m.R.(Ansparafa)', 'A', 'I', '', '4939', 0, NULL, 5, NULL, NULL, FALSE);
145
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);
146
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 16% Ust (Waren)', 'A', 'I', 'AR_amount', '4945', 3, 51, 5, NULL, 2, TRUE);
147
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 keine Waren', 'A', 'I', 'AR_amount', '4946', 0, 0, 5, NULL, 2, FALSE);
148
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);
149
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);
150
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);
151
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);
152
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);
153
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);
154
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5400', 'Wareneingang 16% Vorsteuer', 'A', 'E', 'AP_amount:IC_cogs', '5400', 9, NULL, 4, NULL, 8, TRUE);
155
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5420', 'Innergemein.Erwerb 7% VorSt u. Ust', 'A', 'E', 'AP_amount:IC_cogs', '5420', 0, 93, 4, NULL, 8, TRUE);
156
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5425', 'Innergem.Erwerb 16% VorSt u. Ust', 'A', 'E', 'AP_amount:IC_cogs', '5425', 0, 97, 4, NULL, 8, TRUE);
157
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.Identnr.16%VSt.u.16%USt.', 'A', 'E', 'AP_amount:IC_cogs', '5440', 19, 94, NULL, NULL, 8, TRUE);
158
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);
159
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);
160
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);
161
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);
162
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);
163
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);
164
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);
165
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);
166
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5650', 'Nicht abziehb.Vorsteuer 16%', 'A', 'E', '', '5650', 0, NULL, 5, NULL, 8, FALSE);
167
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5731', 'Erhaltene Skonti 7% Vorsteuer', 'A', 'I', 'AP_paid', '5731', 8, NULL, 4, NULL, NULL, TRUE);
168
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5735', 'Erhaltene Skonti 16% Vorsteuer', 'A', 'I', 'AP_paid', '5735', 9, NULL, 4, NULL, NULL, TRUE);
169
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5750', 'Erhaltene Boni 7% Vorsteuer', 'A', 'I', 'AP_paid', '5750', 8, NULL, 4, NULL, NULL, TRUE);
170
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5760', 'Erhaltene Boni 16% Vorsteuer', 'A', 'I', 'AP_paid', '5760', 9, NULL, 4, NULL, NULL, TRUE);
171
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5780', 'Erhaltene Rabatte 7% Vorsteuer', 'A', 'I', 'AP_paid', '5780', 8, NULL, 4, NULL, NULL, TRUE);
172
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5790', 'Erhaltene Rabatte 16% Vorsteuer', 'A', 'I', 'AP_paid', '5790', 9, NULL, 4, NULL, NULL, TRUE);
173
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);
174
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);
175
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);
176
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', 'A', 'E', 'IC_cogs', '5860', 0, NULL, 4, NULL, NULL, FALSE);
177
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5880', 'Bestandsver.Roh-,Hilfs-.Betriebs.sow.bez.Waren', 'A', 'E', '', '5880', 0, NULL, 2, NULL, NULL, FALSE);
178
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);
179
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', 8, NULL, 5, NULL, 8, TRUE);
180
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. 16% VSt.u.16%USt.', 'A', 'E', 'AP_amount', '5925', 9, NULL, 5, NULL, 8, TRUE);
181
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);
182
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);
183
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);
184
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);
185
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);
186
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6040', 'Lohnsteuer f?r Aushilfe', 'A', 'E', '', '6040', 0, NULL, 10, NULL, 10, FALSE);
187
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);
188
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);
189
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);
190
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6069', 'Pauschale Lohnsteuera.sons.Bez?ge (z.B.Fahrtkostenzu)', 'A', 'E', '', '6069', 0, NULL, NULL, NULL, NULL, FALSE);
191
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);
192
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);
193
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);
194
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);
195
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);
196
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);
197
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);
198
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);
199
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6205', 'Abschreibung a.d.Gesch?ft-o.Firmenw', 'A', 'E', '', '6205', 0, NULL, NULL, NULL, 25, FALSE);
200
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);
201
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);
202
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);
203
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);
204
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);
205
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);
206
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);
207
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);
208
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);
209
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);
210
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);
211
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);
212
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);
213
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);
214
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', 'A', 'E', '', '6270', NULL, NULL, NULL, NULL, NULL, FALSE);
215
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', 'A', 'E', '', '6275', 0, NULL, 17, NULL, NULL, FALSE);
216
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6280', 'Forderungsverlust-?bliche H?he', 'A', 'E', '', '6280', 0, NULL, 20, NULL, NULL, FALSE);
217
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.(?bliche H?he', 'A', 'E', '', '6281', 2, 86, 20, NULL, NULL, TRUE);
218
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.(?bliche H?he', 'A', 'E', '', '6285', 3, 51, 20, NULL, NULL, TRUE);
219
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);
220
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);
221
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);
222
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);
223
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6310', 'Miete', 'A', 'E', 'AP_amount', '6310', 9, NULL, 11, NULL, 11, FALSE);
224
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6315', 'Pacht', 'A', 'E', 'AP_amount', '6315', 0, NULL, NULL, NULL, 11, FALSE);
225
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);
226
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);
227
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, NULL, 11, 24, FALSE);
228
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);
229
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6338', 'Instandhlt.betriebl.R?ume in Geb.die nicht z.BV geh?ren', 'A', 'E', '', '6338', 0, NULL, NULL, NULL, 11, FALSE);
230
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6343', 'Abgaben f.betriebl.genutzten Grundbesitz,d.nicht z.BV geh?rt', 'A', 'E', '', '6343', 0, NULL, NULL, NULL, 11, FALSE);
231
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);
232
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);
233
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);
234
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);
235
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6358', 'Gr?ndst?cksaufwend.f.Geb?ude,die nicht z.Betriebsverm.geh?ren', 'A', 'E', '', '6358', 0, NULL, NULL, NULL, 24, FALSE);
236
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);
237
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.Geb?ude,die zum BV geh?ren', 'A', 'E', '', '6405', 0, NULL, NULL, NULL, 24, FALSE);
238
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);
239
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);
240
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);
241
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);
242
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);
243
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);
244
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);
245
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.Instandhalt.v.and.Anlagen u.Betriebs-u.Gesch?ftsausst.', 'A', 'E', 'AP_amount', '6470', 9, NULL, 18, NULL, 19, FALSE);
246
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);
247
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);
248
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);
249
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6499', 'Gewerbest.zu ber?cksicht.Mietleasing ?8 GewStG', 'A', 'E', '', '6499', 0, NULL, NULL, NULL, 24, FALSE);
250
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);
251
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6520', 'Kfz-Versicherungen', 'A', 'E', 'AP_amount', '6520', 0, NULL, 14, NULL, 16, FALSE);
252
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6530', 'Laufende Kfz-Betriebskosten', 'A', 'E', 'AP_amount', '6530', 9, NULL, 14, NULL, 17, FALSE);
253
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6540', 'Kfz-Reparaturen', 'A', 'E', 'AP_amount', '6540', 9, NULL, 14, NULL, 17, FALSE);
254
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);
255
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6560', 'Leasingfahrzeugkosten', 'A', 'E', 'AP_amount', '6560', 0, NULL, 14, NULL, 17, FALSE);
256
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);
257
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);
258
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);
259
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);
260
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, NULL, 15, 18, FALSE);
261
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);
262
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);
263
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);
264
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);
265
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);
266
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);
267
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);
268
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);
269
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);
270
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6663', 'Reisekosten Arbeitn.m.Vorsteuerabzu f.?ffentl.Verkehrsm.', 'A', 'E', 'AP_amount', '6663', 8, NULL, 15, NULL, 18, FALSE);
271
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);
272
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);
273
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);
274
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);
275
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6673', 'Reisek.Untern.m.Vorsteuerabzug (?ffentl.Verkehrsm.', 'A', 'E', 'AP_amount', '6673', 8, NULL, 15, NULL, 18, FALSE);
276
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);
277
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);
278
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6688', 'Fahrten zw.Wohn.und Arbeitsst?tte (nicht abziehb.Teil)', 'A', 'E', '', '6688', 0, NULL, NULL, NULL, 18, FALSE);
279
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 (Haben)', 'A', 'E', '', '6689', 0, NULL, NULL, NULL, 18, FALSE);
280
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);
281
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);
282
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);
283
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);
284
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);
285
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6780', 'Fremdarbeiten', 'A', 'E', 'AP_amount:IC_expense', '6780', 0, NULL, NULL, NULL, 24, FALSE);
286
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);
287
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);
288
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);
289
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6810', 'Telefax', 'A', 'E', 'AP_amount', '6810', 9, NULL, 20, NULL, 23, FALSE);
290
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);
291
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);
292
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);
293
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);
294
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);
295
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);
296
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);
297
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);
298
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6840', 'Mietleasing', 'A', 'E', 'AP_amount', '6840', 9, NULL, 20, NULL, 21, FALSE);
299
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);
300
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);
301
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);
302
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);
303
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6865', 'Nicht abziehbare Vorsteuer 7%', 'A', 'E', 'AP_paid', '6865', 0, NULL, 20, NULL, NULL, FALSE);
304
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 16%', 'A', 'E', 'AP_paid', '6870', 0, NULL, 20, NULL, NULL, FALSE);
305
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);
306
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);
307
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);
308
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);
309
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);
310
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6928', 'Einst.in SoPo m.R?cklageanteil (Existenzgr?ndungsr?cklage)', 'A', 'E', '', '6928', 0, NULL, NULL, NULL, NULL, FALSE);
311
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);
312
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6967', 'Betriebsfremde Aufwendungen soweit n.au?erord.', 'A', 'E', '', '6967', 0, NULL, 31, NULL, 24, FALSE);
313
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);
314
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);
315
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);
316
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);
317
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);
318
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);
319
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);
320
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);
321
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);
322
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);
323
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);
324
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);
325
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);
326
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);
327
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);
328
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);
329
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);
330
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);
331
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);
332
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);
333
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);
334
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);
335
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);
336
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);
337
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);
338
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);
339
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);
340
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7635', 'Zinsabschlagsteuer', 'A', 'E', '', '7635', 0, NULL, 35, NULL, NULL, FALSE);
341
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);
342
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7640', 'Stnachzahl.Vorj.v.Einkomm u.Ertrag', 'A', 'E', '', '7640', 0, NULL, 31, NULL, NULL, FALSE);
343
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7642', 'Sterstat.Vorj.Steuer v.Eink.u.Ertrag', 'A', 'I', '', '7642', 0, NULL, 33, NULL, NULL, FALSE);
344
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7644', 'Ertr.a.d.Aufl.v.R?cks.f.St.v.Ein.Er', 'A', 'I', '', '7644', 0, NULL, 33, NULL, NULL, FALSE);
345
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7650', 'Sonstige Betriebssteuern', 'A', 'E', '', '7650', 0, NULL, 12, NULL, 31, FALSE);
346
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);
347
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);
348
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);
349
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);
350
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7684', 'Grundsteuer f.Geb?ude,die nicht z.Betriebsverm?gen geh.', 'A', 'E', '', '7684', 0, NULL, NULL, NULL, NULL, FALSE);
351
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);
352
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);
353
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);
354
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);
4
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);
5
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);
6
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);
7
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);
8
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);
9
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0500', 'Betriebs- und Gesch?ftsausstattung',                                  'A', 'A', 'AP_amount',                              '0500', 9,    NULL, NULL, NULL, NULL, FALSE);
10
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);
11
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);
12
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0560', 'Sonst. Transportmittel',                                              'A', 'A', 'AP_amount',                              '0560', 9,    NULL, NULL, NULL, NULL, FALSE);
13
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);
14
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);
15
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);
16
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.b.410EUR',                                 'A', 'A', 'AP_amount',                              '0670', 9,    NULL, NULL, NULL, NULL, FALSE);
17
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',                                      'A', 'E', 'IC',                                     '1000', 9,    NULL, 4,    NULL, NULL, FALSE);
18
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1140', 'Waren',                                                               'A', 'E', 'IC',                                     '1140', 9,    NULL, 4,    NULL, NULL, FALSE);
19
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1200', 'Ford. aus Lieferungen und Leistungen',                                'A', 'A', 'AR',                                     '1200', 0,    NULL, NULL, NULL, NULL, FALSE);
20
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1215', 'Ford.a.LuL z.allg.USt-Satz',                                          'A', 'A', 'AR',                                     '1215', 0,    NULL, NULL, NULL, NULL, FALSE);
21
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1216', 'Ford.a.LuL z.erm.USt.-Satz (E?R)',                                    'A', 'A', 'AR',                                     '1216', 0,    NULL, NULL, NULL, NULL, FALSE);
22
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1217', 'Ford.a.steuerfr.od.nicht steuerb.LuL (E?R)',                          'A', 'A', 'AR',                                     '1217', 0,    NULL, NULL, NULL, NULL, FALSE);
23
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1218', 'Ford.a.LuL gem.?24UStG(E?R)',                                         'A', 'A', 'AR',                                     '1218', 0,    NULL, NULL, NULL, NULL, FALSE);
24
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1219', 'Gegenkto. bei Aufteil.d.Ford.n.Steuers.(E?R)',                        'A', 'A', '',                                       '1219', 0,    NULL, NULL, NULL, NULL, FALSE);
25
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1220', 'Ford.n.?11(1)2EStG f.?4/3 EStG',                                      'A', 'A', 'AR',                                     '1220', 0,    NULL, NULL, NULL, NULL, FALSE);
26
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1248', 'Pauschalwertbe.z.Ford.bis1J.',                                        'A', 'E', '',                                       '1248', 0,    NULL, 31,   NULL, NULL, FALSE);
27
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1249', 'Pauschalwertbe.z.Ford.ueb1J.',                                        'A', 'E', '',                                       '1249', 0,    NULL, 31,   NULL, NULL, FALSE);
28
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);
29
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);
30
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);
31
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 EG-Erwerb 7%',                               'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice',        '1402', 0,    61,   NULL, NULL, 27,   FALSE);
32
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 EG-Erwerb 16%',                              'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice',        '1403', 0,    61,   NULL, NULL, 27,   FALSE);
33
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);
34
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1407', 'Abziehb.Vorst.n.allgem.Durchschnittss?tzen UStVA Kz.63',              'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1407', 0,    NULL, NULL, NULL, 27,   FALSE);
35
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 n.?13b',                                         'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1408', 0,    NULL, NULL, NULL, 27,   FALSE);
36
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);
37
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);
38
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);
39
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);
40
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);
41
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);
42
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);
43
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);
44
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2100', 'Privatentnahme allgemein',                                            'A', 'Q', '',                                       '2100', 0,    NULL, NULL, NULL, NULL, FALSE);
45
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);
46
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);
47
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);
48
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. abzugsf?hig',                                'A', 'Q', '',                                       '2230', 0,    NULL, NULL, NULL, NULL, FALSE);
49
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);
50
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2953', 'Satzungsm.R?cklagen 0% Vorbelast.EK02',                               'A', 'Q', '',                                       '2953', 0,    NULL, NULL, NULL, NULL, FALSE);
51
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3151', 'Vblk.geg.Kreditinst.- Restlaufzeit b.1 Jahr',                         'A', 'A', '',                                       '3151', 0,    NULL, NULL, NULL, NULL, FALSE);
52
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3160', 'Vblk.geg.Kreditinst.- Restlaufzeit 1 bis 5 Jahre',                    'A', 'A', '',                                       '3160', 0,    NULL, NULL, NULL, NULL, FALSE);
53
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3170', 'Vblk.geg.Kreditinst.- Restlaufzeit gr?sser als 5 Jahre',              'A', 'A', '',                                       '3170', 0,    NULL, NULL, NULL, NULL, FALSE);
54
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);
55
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3305', 'Vblk.a.LuL z.allg.Umsatzsteuersatz (E?R)',                            'A', 'L', 'AP',                                     '3305', 0,    NULL, NULL, NULL, NULL, FALSE);
56
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3306', 'Vblk.a.LuL zum erm.Umsatzsteuersatz (E?R)',                           'A', 'L', 'AP',                                     '3306', 0,    NULL, NULL, NULL, NULL, FALSE);
57
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3307', 'Vblk.a.LuL ohne Vorsteuer (E?R)',                                     'A', 'L', 'AP',                                     '3307', 0,    NULL, NULL, NULL, NULL, FALSE);
58
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3309', 'Gegenkonto 1605-1607 b.Aufteilung d.Vblk.n.Steuers.(E?R)',            'A', 'L', '',                                       '3309', 0,    NULL, NULL, NULL, NULL, FALSE);
59
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);
60
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 EG-Erwerb 7%',                                       'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice',        '3802', 0,    NULL, NULL, NULL, 6,    FALSE);
61
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 EG-Erwerb 16%',                                      'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice',        '3803', 0,    NULL, NULL, NULL, 28,   FALSE);
62
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);
63
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3817', 'Umsatzsteuer a.i.anderen EG-Land stpfl.Lieferungen',                  'A', ' ', '',                                       '3817', 10,   NULL, 0,    NULL, NULL, FALSE);
64
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);
65
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);
66
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3833', 'Umsatzsteuer n.?13b UStG',                                            'A', 'I', '',                                       '3833', 0,    NULL, 33,   NULL, 7,    FALSE);
67
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);
68
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);
69
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);
70
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);
71
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);
72
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);
73
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-Ident-Nr.',            'A', 'I', 'AR_amount:IC_sale',                      '4135', 0,    NULL, NULL, NULL, 1,    TRUE);
74
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);
75
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);
76
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);
77
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);
78
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);
79
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 Inland stpfl. EG-Lieferung7%',                                 'A', 'I', 'AR_amount:IC_sale:IC_income',            '4310', 12,   86,   1,    NULL, 1,    TRUE);
80
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4315', 'Erl?s Inland stpfl.EG-Lieferung 16%',                                 'A', 'I', 'AR_amount:IC_sale:IC_income',            '4315', 13,   51,   1,    NULL, 1,    TRUE);
81
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 and.EG-Land steuerpfl.Lieferungen',                     'A', 'I', 'AR_amount:IC_sale:IC_income',            '4320', 10,   NULL, 1,    NULL, 1,    FALSE);
82
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 16% USt.',                                                     'A', 'I', 'AR_amount:IC_sale:IC_income',            '4400', 3,    51,   1,    NULL, 1,    TRUE);
83
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);
84
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);
85
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4506', 'Provisionserl?se 7% USt.',                                            'A', 'I', 'AR_amount:IC_income',                    '4506', 2,    86,   NULL, NULL, 2,    FALSE);
86
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4508', 'Provisionserl?se 16% USt.',                                           'A', 'I', 'AR_amount:IC_income',                    '4508', 3,    51,   NULL, NULL, 2,    FALSE);
87
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);
88
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);
89
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);
90
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);
91
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);
92
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);
93
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);
94
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4605', 'Entnahme v. Gegenst.o.USt.',                                          'A', 'I', '',                                       '4605', 0,    NULL, 5,    NULL, 2,    FALSE);
95
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4610', 'Entnah.d.Untern.f.Zwecke ausserh.d.Untern.7%USt',                     'A', 'I', 'AR_amount',                              '4610', 2,    86,   5,    NULL, 3,    TRUE);
96
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4619', 'Entnahme durch den Untern.f.Zwecke au?erhalb d.Untern.(Waren)o.USt',  'A', 'I', '',                                       '4619', 0,    NULL, 5,    NULL, 3,    FALSE);
97
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4620', 'Entnahme des Untern.f.Zwecke ausserh.d.Untern 16%(Waren)',            'A', 'I', 'AR_amount',                              '4620', 3,    51,   5,    NULL, 3,    TRUE);
98
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);
99
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4639', 'Verwendung v.Gegenst?nden f.Zwecke au?erhalb d.Untern.o.USt.',        'A', 'I', '',                                       '4639', 0,    NULL, NULL, NULL, 3,    FALSE);
100
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.Gegens.f.Zwecke ausserh.d.Untern.16%USt.',                     'A', 'I', '',                                       '4640', 3,    51,   5,    NULL, 3,    TRUE);
101
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4645', 'Verwend.v.Gegenst.f.Zwecke au?erh.d.Untern.16%USt(Kfz-Nutzung)',      'A', 'I', '',                                       '4645', 0,    0,    5,    NULL, 3,    TRUE);
102
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4646', 'Verwend.f.Gegenst.f.Zwecke au?erh.d.Untern.16%USt(Telefonnutzung)',   'A', 'I', '',                                       '4646', 0,    0,    5,    NULL, 3,    TRUE);
103
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4660', 'Unentgeltl.Erbring.sons.Leis.16%USt',                                 'A', 'I', 'AR_amount',                              '4660', 3,    51,   NULL, NULL, 3,    TRUE);
104
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4670', 'Unentgeltl.Zuw.von Waren 7% Ust',                                     'A', 'I', '',                                       '4670', 2,    86,   5,    NULL, 3,    TRUE);
105
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4679', 'Unentgeltl.Zuwendung v.Waren o.USt.',                                 'A', 'I', '',                                       '4679', 0,    NULL, 5,    NULL, 3,    FALSE);
106
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);
107
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.v.Gegens. 16% Ust',                                 'A', 'I', 'AR_amount',                              '4686', 3,    51,   NULL, NULL, 3,    TRUE);
108
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4689', 'Unentgeltl.Zuw.v.Gegens.ohne Ust',                                    'A', 'I', '',                                       '4689', 0,    NULL, 5,    NULL, 3,    FALSE);
109
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',                                            'A', 'I', '',                                       '4690', 0,    NULL, 5,    NULL, 1,    FALSE);
110
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);
111
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);
112
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);
113
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 16% USt.',                                           'A', 'I', '',                                       '4720', 3,    51,   32,   NULL, 1,    TRUE);
114
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?.Inl.stpfl.EG-Lief. 7%USt',                                 'A', 'I', '',                                       '4725', 12,   86,   32,   NULL, 1,    TRUE);
115
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?.Inl.stpfl.EG-Lief.16%USt',                                 'A', 'I', '',                                       '4726', 13,   51,   32,   NULL, 1,    TRUE);
116
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?.and.EG Land stpfl.Liefer',                                 'A', 'I', '',                                       '4727', 0,    NULL, 32,   NULL, 1,    FALSE);
117
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);
118
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', 3,    51,   1,    NULL, 1,    FALSE);
119
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);
120
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 16% USt.',                                              'A', 'E', 'AR_paid',                                '4760', 3,    51,   1,    NULL, 1,    TRUE);
121
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);
122
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 16% Ust.',                                           'A', 'E', 'AR_paid',                                '4790', 3,    51,   1,    NULL, 1,    TRUE);
123
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..Leist.',                                         'A', 'E', '',                                       '4800', 0,    0,    2,    NULL, NULL, FALSE);
124
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4810', 'Bestandsver?nderung unf.Erz.',                                        'A', 'E', '',                                       '4810', 0,    0,    2,    NULL, NULL, FALSE);
125
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.unf.Leist.',                                           'A', 'E', '',                                       '4815', 0,    0,    2,    NULL, NULL, FALSE);
126
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);
127
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4830', 'Sonstige Ertr?ge',                                                    'A', 'I', '',                                       '4830', 3,    51,   33,   NULL, 2,    FALSE);
128
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);
129
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);
130
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4837', 'Betriebsfremde Ertr?ge nichtau?erorden',                              'A', 'I', '',                                       '4837', 0,    NULL, 33,   NULL, NULL, FALSE);
131
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4844', 'Erl?se a.Verk.Sachanlagen steuerfrei?4Nr.1aUStG(b.Buchverlust)',      'A', 'E', '',                                       '4844', 0,    NULL, NULL, NULL, 1,    TRUE);
132
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4845', 'Erl?se aus Verk.Sachanlageverm?gen16% USt (bei Buchverlust)',         'A', 'E', '',                                       '4845', 0,    NULL, NULL, NULL, 2,    TRUE);
133
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4848', 'Erl?se a.Verk.Sachanlagen steuerfrei?4Nr.1bUStG(b.Buchverlust)',      'A', 'E', '',                                       '4848', 0,    NULL, NULL, NULL, 1,    TRUE);
134
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 Anlagenverk?ufen',                                         'A', 'I', 'AR_amount',                              '4849', 3,    51,   NULL, NULL, 1,    FALSE);
135
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);
136
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 aus Abgang von AV-Gegenst?nden',                              'A', 'I', '',                                       '4900', 0,    NULL, 33,   NULL, 2,    FALSE);
137
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4905', 'Ertr.a.d.Abg.v.Gegenst.d.Umlaufverm',                                 'A', 'I', '',                                       '4905', 0,    NULL, 33,   NULL, 2,    FALSE);
138
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4910', 'Ertrag a.d.Zuschreib.d.Anlageverm?g',                                 'A', 'I', '',                                       '4910', 0,    NULL, 33,   NULL, 2,    FALSE);
139
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4915', 'Ertr.a.Zuschreib.d.Umlaufverm?gens',                                  'A', 'I', '',                                       '4915', 0,    NULL, 33,   NULL, NULL, FALSE);
140
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4920', 'Ertr.a.Herabsetzung d.PWB zu Forderungen',                            'A', 'I', '',                                       '4920', 0,    NULL, 33,   NULL, 2,    FALSE);
141
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4925', 'Ertr. aus abgeschriebenen Forderung',                                 'A', 'I', '',                                       '4925', 0,    NULL, 33,   NULL, NULL, FALSE);
142
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4930', 'Ertr.a.d.Aufl?sung v.R?ckstellungen',                                 'A', 'I', '',                                       '4930', 0,    NULL, 33,   NULL, NULL, FALSE);
143
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);
144
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 Aufl. Sopo m.R.(Ansparafa)',                                  'A', 'I', '',                                       '4939', 0,    NULL, 5,    NULL, NULL, FALSE);
145
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);
146
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 16% Ust (Waren)',                                          'A', 'I', 'AR_amount',                              '4945', 3,    51,   5,    NULL, 2,    TRUE);
147
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 keine Waren',                            'A', 'I', 'AR_amount',                              '4946', 0,    0,    5,    NULL, 2,    FALSE);
148
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);
149
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);
150
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);
151
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);
152
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);
153
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);
154
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5400', 'Wareneingang 16% Vorsteuer',                                          'A', 'E', 'AP_amount:IC_cogs',                      '5400', 9,    NULL, 4,    NULL, 8,    TRUE);
155
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5420', 'Innergemein.Erwerb 7% VorSt u. Ust',                                  'A', 'E', 'AP_amount:IC_cogs',                      '5420', 0,    93,   4,    NULL, 8,    TRUE);
156
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5425', 'Innergem.Erwerb 16% VorSt u. Ust',                                    'A', 'E', 'AP_amount:IC_cogs',                      '5425', 0,    97,   4,    NULL, 8,    TRUE);
157
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.Identnr.16%VSt.u.16%USt.',    'A', 'E', 'AP_amount:IC_cogs',                      '5440', 19,   94,   NULL, NULL, 8,    TRUE);
158
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);
159
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);
160
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);
161
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);
162
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);
163
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);
164
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);
165
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);
166
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5650', 'Nicht abziehb.Vorsteuer 16%',                                         'A', 'E', '',                                       '5650', 0,    NULL, 5,    NULL, 8,    FALSE);
167
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5731', 'Erhaltene Skonti 7% Vorsteuer',                                       'A', 'I', 'AP_paid',                                '5731', 8,    NULL, 4,    NULL, NULL, TRUE);
168
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5735', 'Erhaltene Skonti 16% Vorsteuer',                                      'A', 'I', 'AP_paid',                                '5735', 9,    NULL, 4,    NULL, NULL, TRUE);
169
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5750', 'Erhaltene Boni 7% Vorsteuer',                                         'A', 'I', 'AP_paid',                                '5750', 8,    NULL, 4,    NULL, NULL, TRUE);
170
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5760', 'Erhaltene Boni 16% Vorsteuer',                                        'A', 'I', 'AP_paid',                                '5760', 9,    NULL, 4,    NULL, NULL, TRUE);
171
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5780', 'Erhaltene Rabatte 7% Vorsteuer',                                      'A', 'I', 'AP_paid',                                '5780', 8,    NULL, 4,    NULL, NULL, TRUE);
172
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5790', 'Erhaltene Rabatte 16% Vorsteuer',                                     'A', 'I', 'AP_paid',                                '5790', 9,    NULL, 4,    NULL, NULL, TRUE);
173
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);
174
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);
175
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);
176
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',                                             'A', 'E', 'IC_cogs',                                '5860', 0,    NULL, 4,    NULL, NULL, FALSE);
177
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5880', 'Bestandsver.Roh-,Hilfs-.Betriebs.sow.bez.Waren',                      'A', 'E', '',                                       '5880', 0,    NULL, 2,    NULL, NULL, FALSE);
178
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);
179
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', 8,    NULL, 5,    NULL, 8,    TRUE);
180
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. 16% VSt.u.16%USt.',                           'A', 'E', 'AP_amount',                              '5925', 9,    NULL, 5,    NULL, 8,    TRUE);
181
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);
182
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);
183
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);
184
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);
185
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);
186
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6040', 'Lohnsteuer f?r Aushilfe',                                             'A', 'E', '',                                       '6040', 0,    NULL, 10,   NULL, 10,   FALSE);
187
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);
188
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);
189
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);
190
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6069', 'Pauschale Lohnsteuera.sons.Bez?ge (z.B.Fahrtkostenzu)',               'A', 'E', '',                                       '6069', 0,    NULL, NULL, NULL, NULL, FALSE);
191
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);
192
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);
193
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);
194
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);
195
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);
196
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);
197
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);
198
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);
199
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6205', 'Abschreibung a.d.Gesch?ft-o.Firmenw',                                 'A', 'E', '',                                       '6205', 0,    NULL, NULL, NULL, 25,   FALSE);
200
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);
201
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);
202
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);
203
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);
204
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);
205
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);
206
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);
207
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);
208
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);
209
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);
210
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);
211
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);
212
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);
213
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);
214
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',                                    'A', 'E', '',                                       '6270', NULL, NULL, NULL, NULL, NULL, FALSE);
215
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',                                    'A', 'E', '',                                       '6275', 0,    NULL, 17,   NULL, NULL, FALSE);
216
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6280', 'Forderungsverlust-?bliche H?he',                                      'A', 'E', '',                                       '6280', 0,    NULL, 20,   NULL, NULL, FALSE);
217
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.(?bliche H?he',                             'A', 'E', '',                                       '6281', 2,    86,   20,   NULL, NULL, TRUE);
218
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.(?bliche H?he',                            'A', 'E', '',                                       '6285', 3,    51,   20,   NULL, NULL, TRUE);
219
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);
220
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);
221
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);
222
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);
223
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6310', 'Miete',                                                               'A', 'E', 'AP_amount',                              '6310', 9,    NULL, 11,   NULL, 11,   FALSE);
224
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6315', 'Pacht',                                                               'A', 'E', 'AP_amount',                              '6315', 0,    NULL, NULL, NULL, 11,   FALSE);
225
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);
226
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);
227
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, NULL, 11,   24,   FALSE);
228
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);
229
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6338', 'Instandhlt.betriebl.R?ume in Geb.die nicht z.BV geh?ren',             'A', 'E', '',                                       '6338', 0,    NULL, NULL, NULL, 11,   FALSE);
230
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6343', 'Abgaben f.betriebl.genutzten Grundbesitz,d.nicht z.BV geh?rt',        'A', 'E', '',                                       '6343', 0,    NULL, NULL, NULL, 11,   FALSE);
231
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);
232
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);
233
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);
234
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);
235
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6358', 'Gr?ndst?cksaufwend.f.Geb?ude,die nicht z.Betriebsverm.geh?ren',       'A', 'E', '',                                       '6358', 0,    NULL, NULL, NULL, 24,   FALSE);
236
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);
237
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.Geb?ude,die zum BV geh?ren',                         'A', 'E', '',                                       '6405', 0,    NULL, NULL, NULL, 24,   FALSE);
238
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);
239
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);
240
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);
241
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);
242
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);
243
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);
244
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);
245
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.Instandhalt.v.and.Anlagen u.Betriebs-u.Gesch?ftsausst.',        'A', 'E', 'AP_amount',                              '6470', 9,    NULL, 18,   NULL, 19,   FALSE);
246
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);
247
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);
248
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);
249
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6499', 'Gewerbest.zu ber?cksicht.Mietleasing ?8 GewStG',                      'A', 'E', '',                                       '6499', 0,    NULL, NULL, NULL, 24,   FALSE);
250
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);
251
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6520', 'Kfz-Versicherungen',                                                  'A', 'E', 'AP_amount',                              '6520', 0,    NULL, 14,   NULL, 16,   FALSE);
252
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6530', 'Laufende Kfz-Betriebskosten',                                         'A', 'E', 'AP_amount',                              '6530', 9,    NULL, 14,   NULL, 17,   FALSE);
253
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6540', 'Kfz-Reparaturen',                                                     'A', 'E', 'AP_amount',                              '6540', 9,    NULL, 14,   NULL, 17,   FALSE);
254
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);
255
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6560', 'Leasingfahrzeugkosten',                                               'A', 'E', 'AP_amount',                              '6560', 0,    NULL, 14,   NULL, 17,   FALSE);
256
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);
257
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);
258
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);
259
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);
260
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, NULL, 15,   18,   FALSE);
261
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);
262
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);
263
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);
264
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);
265
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);
266
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);
267
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);
268
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);
269
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);
270
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6663', 'Reisekosten Arbeitn.m.Vorsteuerabzu f.?ffentl.Verkehrsm.',            'A', 'E', 'AP_amount',                              '6663', 8,    NULL, 15,   NULL, 18,   FALSE);
271
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);
272
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);
273
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);
274
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);
275
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6673', 'Reisek.Untern.m.Vorsteuerabzug (?ffentl.Verkehrsm.',                  'A', 'E', 'AP_amount',                              '6673', 8,    NULL, 15,   NULL, 18,   FALSE);
276
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);
277
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);
278
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6688', 'Fahrten zw.Wohn.und Arbeitsst?tte (nicht abziehb.Teil)',              'A', 'E', '',                                       '6688', 0,    NULL, NULL, NULL, 18,   FALSE);
279
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 (Haben)',                          'A', 'E', '',                                       '6689', 0,    NULL, NULL, NULL, 18,   FALSE);
280
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);
281
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);
282
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);
283
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);
284
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);
285
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6780', 'Fremdarbeiten',                                                       'A', 'E', 'AP_amount:IC_expense',                   '6780', 0,    NULL, NULL, NULL, 24,   FALSE);
286
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);
287
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);
288
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);
289
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6810', 'Telefax',                                                             'A', 'E', 'AP_amount',                              '6810', 9,    NULL, 20,   NULL, 23,   FALSE);
290
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);
291
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);
292
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);
293
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);
294
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);
295
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);
296
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);
297
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);
298
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6840', 'Mietleasing',                                                         'A', 'E', 'AP_amount',                              '6840', 9,    NULL, 20,   NULL, 21,   FALSE);
299
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);
300
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);
301
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);
302
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);
303
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6865', 'Nicht abziehbare Vorsteuer 7%',                                       'A', 'E', 'AP_paid',                                '6865', 0,    NULL, 20,   NULL, NULL, FALSE);
304
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 16%',                                      'A', 'E', 'AP_paid',                                '6870', 0,    NULL, 20,   NULL, NULL, FALSE);
305
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);
306
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);
307
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);
308
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);
309
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);
310
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6928', 'Einst.in SoPo m.R?cklageanteil (Existenzgr?ndungsr?cklage)',          'A', 'E', '',                                       '6928', 0,    NULL, NULL, NULL, NULL, FALSE);
311
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);
312
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6967', 'Betriebsfremde Aufwendungen soweit n.au?erord.',                      'A', 'E', '',                                       '6967', 0,    NULL, 31,   NULL, 24,   FALSE);
313
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);
314
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);
315
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);
316
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);
317
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);
318
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);
319
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);
320
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);
321
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);
322
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);
323
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);
324
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);
325
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);
326
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);
327
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);
328
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);
329
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);
330
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);
331
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);
332
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);
333
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);
334
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);
335
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);
336
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);
337
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);
338
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);
339
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);
340
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7635', 'Zinsabschlagsteuer',                                                  'A', 'E', '',                                       '7635', 0,    NULL, 35,   NULL, NULL, FALSE);
341
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);
342
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7640', 'Stnachzahl.Vorj.v.Einkomm u.Ertrag',                                  'A', 'E', '',                                       '7640', 0,    NULL, 31,   NULL, NULL, FALSE);
343
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7642', 'Sterstat.Vorj.Steuer v.Eink.u.Ertrag',                                'A', 'I', '',                                       '7642', 0,    NULL, 33,   NULL, NULL, FALSE);
344
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7644', 'Ertr.a.d.Aufl.v.R?cks.f.St.v.Ein.Er',                                 'A', 'I', '',                                       '7644', 0,    NULL, 33,   NULL, NULL, FALSE);
345
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7650', 'Sonstige Betriebssteuern',                                            'A', 'E', '',                                       '7650', 0,    NULL, 12,   NULL, 31,   FALSE);
346
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);
347
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);
348
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);
349
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);
350
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7684', 'Grundsteuer f.Geb?ude,die nicht z.Betriebsverm?gen geh.',             'A', 'E', '',                                       '7684', 0,    NULL, NULL, NULL, NULL, FALSE);
351
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);
352
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);
353
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);
354
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);
355 355

  
356 356

  
357 357
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);
358
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);
358
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);
359 359
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);
360
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);
360
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);
361 361

  
362 362

  
363 363

  
364 364

  
365
INSERT INTO tax (rate, taxkey, taxdescription) values ('0','0','Keine Steuer');
366
INSERT INTO tax (rate, taxkey, taxdescription) values ('0','1','Umsatzsteuerfrei');
367
insert into tax VALUES ((select id from chart where accno = '3801'),'0.07','3801','2','Umsatzsteuer 7%');
368
INSERT INTO tax VALUES ((select id from chart where accno = '3805'),'0.16','3805','3','Umsatzsteuer 16%');
369
INSERT INTO tax VALUES ((select id from chart where accno = '1401'),'0.07','1401','8','Vorsteuer 7%');
370
insert into tax VALUES ((select id from chart where accno = '1405'),'0.16','1405','9','Vorsteuer 16%');
371
insert into tax (taxkey, taxdescription) values ('10','Im anderen EG-Staat steuerpfl. Lieferung');
372
insert into tax (taxkey, taxdescription) values ('11','Steuerfreie EG-Lief. an Abn. mit UStIdNr');
373
insert into tax (chart_id,rate,taxnumber, taxkey, taxdescription) values ((select id from chart where accno = '3802'),'0.07','3802','12','Steuerpflicht. EG-Lieferungen 7%');
374
insert into tax (chart_id,rate,taxnumber, taxkey, taxdescription) values ((select id from chart where accno = '3802'),'0.16','3803','13','Steuerpflicht. EG-Lieferungen 16%');
375
insert into tax (chart_id,rate,taxnumber, taxkey, taxdescription) values ((select id from chart where accno = '1402'),'0.07','1402','18','Steuerpflicht. EG-Erwerb 7%');
376
insert into tax (chart_id,rate,taxnumber, taxkey, taxdescription) values ((select id from chart where accno = '1402'),'0.16','1403','19','Steuerpflicht. EG-Erwerb 16%');
365
INSERT INTO tax (rate, taxkey, taxdescription)                    VALUES ('0','0','Keine Steuer');
366
INSERT INTO tax (rate, taxkey, taxdescription)                    VALUES ('0','1','Umsatzsteuerfrei');
367
INSERT INTO tax                                                   VALUES ((SELECT id FROM chart WHERE accno = '3801'),'0.07','3801','2','Umsatzsteuer 7%');
368
INSERT INTO tax                                                   VALUES ((SELECT id FROM chart WHERE accno = '3805'),'0.16','3805','3','Umsatzsteuer 16%');
369
INSERT INTO tax                                                   VALUES ((SELECT id FROM chart WHERE accno = '1401'),'0.07','1401','8','Vorsteuer 7%');
370
INSERT into tax                                                   VALUES ((SELECT id FROM chart WHERE accno = '1405'),'0.16','1405','9','Vorsteuer 16%');
371
INSERT into tax (taxkey, taxdescription)                          VALUES ('10','Im anderen EG-Staat steuerpfl. Lieferung');
372
INSERT into tax (taxkey, taxdescription)                          VALUES ('11','Steuerfreie EG-Lief. an Abn. mit UStIdNr');
373
INSERT into tax (chart_id,rate,taxnumber, taxkey, taxdescription) VALUES ((SELECT id FROM chart WHERE accno = '3802'),'0.07','3802','12','Steuerpflicht. EG-Lieferungen 7%');
374
INSERT into tax (chart_id,rate,taxnumber, taxkey, taxdescription) VALUES ((SELECT id FROM chart WHERE accno = '3802'),'0.16','3803','13','Steuerpflicht. EG-Lieferungen 16%');
375
INSERT into tax (chart_id,rate,taxnumber, taxkey, taxdescription) VALUES ((SELECT id FROM chart WHERE accno = '1402'),'0.07','1402','18','Steuerpflicht. EG-Erwerb 7%');
376
INSERT into tax (chart_id,rate,taxnumber, taxkey, taxdescription) VALUES ((SELECT id FROM chart WHERE accno = '1402'),'0.16','1403','19','Steuerpflicht. EG-Erwerb 16%');
377 377

  
378 378
-- Ergaenzungen fuer 19% UmSt. ab 1.01.2007
379 379
insert into taxkeys (chart_id, tax_id, taxkey_id, pos_ustva, startdate) select chart.id, tax.id, taxkey_id, pos_ustva, '1970-01-01' from chart LEFT JOIN tax on (tax.taxkey=chart.taxkey_id) WHERE taxkey_id is not null;

Auch abrufbar als: Unified diff