Revision a921e75a
Von Moritz Bunkus vor fast 14 Jahren hinzugefügt
| sql/Germany-DATEV-SKR04EU-chart.sql | ||
|---|---|---|
| 6 | 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 | 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 | 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);
|
|
| 9 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0500', 'Andere Anlagen, Betriebs- und Gesch?ftsausstattung', 'A', 'A', 'AP_amount', '0500', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 10 | 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 | 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);
|
|
| 12 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0560', 'Sonstige Transportmittel', 'A', 'A', 'AP_amount', '0560', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 13 | 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 | 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 | 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);
|
|
| 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?ter', '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 ('0675', 'Geringwertige Wirtschaftsgg?ter 150 - 1000 EUR (Sammelposten)', 'A', 'A', 'AP_amount', '0670', 9, NULL, NULL, 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 ('1000', 'Roh-, Hilfs- und Betriebsstoffe (Bestand)', 'A', 'E', 'IC', '1000', 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 ('1140', 'Waren (Bestand)', 'A', 'E', 'IC', '1140', 9, NULL, 4, 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 ('1200', 'Forderungen aus Lieferungen und Leistungen', 'A', 'A', 'AR', '1200', 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 ('1215', 'Forder. aus LuL zum allg. UST-Satz oder eines Kleinunternehmers (E?R)', 'A', 'A', 'AR', '1215', 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 ('1216', 'Forder. aus LuL zum erm??igten USTsatz (E?R)', 'A', 'A', 'AR', '1216', 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 ('1217', 'Forder. aus steuerfreien o. Nicht steuerbaren LuL (E?R)', 'A', 'A', 'AR', '1217', 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 ('1218', 'Forder. aus LuL nach Durchschnitzs?tzen ? 24 UStG (E?R)', 'A', 'A', 'AR', '1218', 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 ('1219', 'Gegenkonto 1215-1218 bei Auteilung d. Forder. nach Steuers?tzen (E?R)', 'A', 'A', '', '1219', 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 ('1220', 'Forder. nach ? 11 Abs. 1 Satz 2 EStG f?r ? 4/3 EStG', 'A', 'A', 'AR', '1220', 0, NULL, NULL, 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 ('1248', 'Pauschwertber. zu Forder. Restlzeit <1 Jahr', 'A', 'E', '', '1248', 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 ('1249', 'Pauschwertber. zu Forder. Restlzeit >1 Jahr', 'A', 'E', '', '1249', 0, NULL, 31, NULL, NULL, FALSE);
|
|
| 28 | 29 |
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 | 30 |
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 | 31 |
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);
|
|
| 32 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1402', 'Abziehbare Vorsteuer aus innergemeinschftl. Erwerb', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', '1402', 0, 61, NULL, NULL, 27, FALSE);
|
|
| 33 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1403', 'Abziehbare Vorsteuer aus innergemeinschftl. Erwerb 16%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', '1403', 0, 61, NULL, NULL, 27, FALSE);
|
|
| 34 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1404', 'Abziehbare Vorsteuer aus innergemeinschftl. Erwerb 19%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', '1403', 0, 61, NULL, NULL, 27, FALSE);
|
|
| 33 | 35 |
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 ('1406', 'Abziehbare Vorsteuer 19 %', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', 0, 0, 66, NULL, NULL, 27, FALSE);
|
|
| 37 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1407', 'Abziehbare Vorsteuer nach ? 13b UStG 19%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1407', 0, NULL, NULL, NULL, 27, FALSE);
|
|
| 38 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1408', 'Abziehbare Vorsteuer nach ? 13b UStG', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1408', 0, NULL, NULL, NULL, 27, FALSE);
|
|
| 39 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1409', 'Abziehbare Vorsteuer nach ? 13b UStG 16%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1408', 0, NULL, NULL, NULL, 27, FALSE);
|
|
| 40 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1432', 'abziehb. VorSt EU-Erwerb Neufzg.b.Lief. o. USt-IdNr.', 'A', 'E', 'AR_tax', '1483', 0, NULL, NULL, NULL, 27, FALSE);
|
|
| 36 | 41 |
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 | 42 |
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 | 43 |
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);
|
| ... | ... | |
| 41 | 46 |
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 | 47 |
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 | 48 |
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);
|
|
| 49 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2100', 'Privatentnahmen allgemein', 'A', 'Q', '', '2100', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 45 | 50 |
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 | 51 |
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 | 52 |
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);
|
|
| 53 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2230', 'Sonderausgaben unbeschr?nkt abzugsf?hig', 'A', 'Q', '', '2230', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 54 |
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);
|
|
| 55 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2950', 'Satzungsm??ige R?cklagen', 'A', 'Q', '', '2953', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 56 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3151', 'Verbindlk. geg Krditinst. - Restlzeit <1 Jahr ', 'A', 'A', '', '3151', 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 ('3160', 'Verbindlk. geg Krditinst. - Restlzeit 1 - 5 Jahre ', 'A', 'A', '', '3160', 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 ('3170', 'Verbindlk. geg Krditinst. - Restlzeit >5 Jahre', 'A', 'A', '', '3170', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 54 | 59 |
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);
|
|
| 60 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3305', 'Verbindlk. aus LuL zum allg. USTsatz (E?R)', 'A', 'L', 'AP', '3305', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 61 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3306', 'Verbindlk. aus LuL zum erm. USTsatz (E?R)', 'A', 'L', 'AP', '3306', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 62 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3307', 'Verbindlk. aus LuL ohne Vorsteuer (E?R)', 'A', 'L', 'AP', '3307', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 63 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3309', 'Gegenkonto 3305-3307 bei Auteilung d. Forder. nach Steuers?tzen (E?R)', 'A', 'L', '', '3309', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 59 | 64 |
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);
|
|
| 65 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3802', 'Umsatzsteuer aus innergemeinschftl. Erwerb', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', '3802', 0, NULL, NULL, NULL, 6, FALSE);
|
|
| 66 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3803', 'Umsatzsteuer aus innergemeinschftl. Erwerb 16%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', '3803', 0, NULL, NULL, NULL, 28, FALSE);
|
|
| 67 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3804', 'Umsatzsteuer aus innergemeinschftl. Erwerb 19%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', '3803', 0, NULL, NULL, NULL, 28, FALSE);
|
|
| 62 | 68 |
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);
|
|
| 69 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3806', 'Umsatzsteuer 19%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax', '3805', 0, 511, NULL, NULL, 6, FALSE);
|
|
| 70 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3817', 'Umsatzsteuer aus in anderen EG-Land stpfl. Lieferungen', 'A', ' ', '', '3817', 10, NULL, 0, NULL, NULL, FALSE);
|
|
| 64 | 71 |
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 | 72 |
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);
|
|
| 73 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3835', 'Umsatzsteuer nach ? 13b UStG', 'A', 'I', '', '3833', 0, NULL, 33, NULL, 7, FALSE);
|
|
| 74 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3836', 'Umsatzsteuer nach ? 13b UStG 16%', 'A', 'I', '', '3833', 0, NULL, 33, NULL, 7, FALSE);
|
|
| 75 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3837', 'Umsatzsteuer nach ? 13b UStG 19%', 'A', 'I', '', '3833', 0, NULL, 33, NULL, 7, FALSE);
|
|
| 67 | 76 |
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 | 77 |
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 | 78 |
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 | 79 |
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 | 80 |
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 | 81 |
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);
|
|
| 82 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4135', 'Steuerfr.innergem.Lief.v.Neufahrz.an Abn.o. USt-IdNr.', 'A', 'I', 'AR_amount:IC_sale', '4135', 0, NULL, NULL, NULL, 1, TRUE);
|
|
| 74 | 83 |
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 | 84 |
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 | 85 |
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 | 86 |
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);
|
|
| 87 |
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);
|
|
| 88 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4310', 'Erl?se aus im Inland strpfl. EG-Lieferungen 7%', 'A', 'I', 'AR_amount:IC_sale:IC_income', '4310', 12, 86, 1, NULL, 1, TRUE);
|
|
| 89 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4315', 'Erl?se aus im Inland strpfl. EG-Lieferungen 19%', 'A', 'I', 'AR_amount:IC_sale:IC_income', '4315', 13, 51, 1, NULL, 1, TRUE);
|
|
| 90 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4320', 'Erl?se aus im anderen EG-Land strpfl. Lieferungen', 'A', 'I', 'AR_amount:IC_sale:IC_income', '4320', 10, NULL, 1, NULL, 1, FALSE);
|
|
| 91 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4330', 'Erl?se aus im Inland strpfl. EG-Lieferungen 16%', 'A', 'I', 'AR_amount:IC_sale:IC_income', '4315', 13, 51, 1, NULL, 1, TRUE);
|
|
| 92 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4340', 'Erl?se 16% USt', 'A', 'I', 'AR_amount:IC_sale:IC_income', '4400', 5, 51, 1, NULL, 1, TRUE);
|
|
| 93 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4400', 'Erl?se 19% USt', 'A', 'I', 'AR_amount:IC_sale:IC_income', '4400', 3, 51, 1, NULL, 1, TRUE);
|
|
| 83 | 94 |
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 | 95 |
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);
|
|
| 96 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4566', 'Provisionserl?se 7% USt.', 'A', 'I', 'AR_amount:IC_income', '4506', 2, 86, NULL, NULL, 2, FALSE);
|
|
| 97 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4568', 'Provisionserl?se 16% USt', 'A', 'I', 'AR_amount:IC_income', '4508', 5, 51, NULL, NULL, 2, FALSE);
|
|
| 98 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4569', 'Provisionserl?se 19% USt', 'A', 'I', 'AR_amount:IC_income', '4508', 3, 51, NULL, NULL, 2, FALSE);
|
|
| 87 | 99 |
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 | 100 |
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 | 101 |
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);
|
| ... | ... | |
| 91 | 103 |
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 | 104 |
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 | 105 |
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);
|
|
| 106 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4605', 'Entnahme von Gegenst?nden o. USt', 'A', 'I', '', '4605', 0, NULL, 5, NULL, 2, FALSE);
|
|
| 107 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4610', 'Entnahme (Waren) d. Unternehmer f. Zwecke au?erh. des Untern. 7% USt','A', 'I', 'AR_amount', '4610', 2, 86, 5, NULL, 3, TRUE);
|
|
| 108 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4619', 'Entnahme (Waren) d. Unternehmer f. Zwecke au?erh. des Untern. o. USt','A', 'I', '', '4619', 0, NULL, 5, NULL, 3, FALSE);
|
|
| 109 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4620', 'Entnahme (Waren) d. Unternehmer f. Zwecke au?erh. des Untern. 19% USt', 'A', 'I', 'AR_amount', '4620', 3, 51, 5, NULL, 3, TRUE);
|
|
| 98 | 110 |
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);
|
|
| 111 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4637', 'Verwendung v.Gegenst?nden f.Zwecke au?erhalb d.Untern.o.USt.', 'A', 'I', '', '4639', 0, NULL, NULL, NULL, 3, FALSE);
|
|
| 112 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4640', 'Verw. v. Gegenst. f. Zwecke au?erh. des Untern. 19% USt', 'A', 'I', '', '4640', 3, 51, 5, NULL, 3, TRUE);
|
|
| 113 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4645', 'Verw. v. Gegenst. f. Zwecke au?erh. des Untern. 19% USt (Kfz-Nutzung)', 'A', 'I', '', '4645', 0, 0, 5, NULL, 3, TRUE);
|
|
| 114 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4646', 'Verw. v. Gegenst. f. Zwecke au?erh. des Untern. 19% USt (Tel-Nutzung)', 'A', 'I', '', '4646', 0, 0, 5, NULL, 3, TRUE);
|
|
| 115 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4660', 'Unentgeltl. Erbringung sonst. Leist. 19% USt', 'A', 'I', 'AR_amount', '4660', 3, 51, NULL, NULL, 3, TRUE);
|
|
| 116 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4670', 'Unentgeltl. Zuwend. Waren 19% USt', 'A', 'I', '', '4670', 2, 86, 5, NULL, 3, TRUE);
|
|
| 117 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4679', 'Unentgeltl. Zuwend. Waren o. USt', 'A', 'I', '', '4679', 0, NULL, 5, NULL, 3, FALSE);
|
|
| 106 | 118 |
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);
|
|
| 119 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4686', 'Unentgeltl. Zuwend. Gegenst. 19% USt', 'A', 'I', 'AR_amount', '4686', 3, 51, NULL, NULL, 3, TRUE);
|
|
| 120 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4689', 'Unentgeltl. Zuwend. Gegenst. o. USt', 'A', 'I', '', '4689', 0, NULL, 5, NULL, 3, FALSE);
|
|
| 121 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4690', 'Nicht steuerbare Ums?tze (Innenums?tze)', 'A', 'I', '', '4690', 0, NULL, 5, NULL, 1, FALSE);
|
|
| 110 | 122 |
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 | 123 |
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 | 124 |
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);
|
|
| 125 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4720', 'Erl?sschm?lerung 19% USt.', 'A', 'I', '', '4720', 3, 51, 32, NULL, 1, TRUE);
|
|
| 126 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4723', 'Erl?sschm?lerung 16% USt.', 'A', 'I', '', '4720', 5, 51, 32, NULL, 1, TRUE);
|
|
| 127 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4725', 'Erl?sschm?ler aus im inl. Stpflcht. EG-Lieferungen 7%USt', 'A', 'I', '', '4725', 12, 86, 32, NULL, 1, TRUE);
|
|
| 128 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4726', 'Erl?sschm?ler aus im inl. Stpflcht. EG-Lieferungen 19% USt', 'A', 'I', '', '4726', 13, 51, 32, NULL, 1, TRUE);
|
|
| 129 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4727', 'Erl?sschm?ler. im and. EG-land Stpflchtg. Lieferungen', 'A', 'I', '', '4727', 0, NULL, 32, NULL, 1, FALSE);
|
|
| 130 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4729', 'Erl?sschm?ler. aus im inl. Stpflcht. EG-Lieferungen 16% USt', 'A', 'I', '', '4727', 0, NULL, 32, NULL, 1, FALSE);
|
|
| 117 | 131 |
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);
|
|
| 132 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4735', 'Gew?hrte Skonti 16% USt', 'A', 'E', 'AR_paid', '4735', 5, 51, 1, NULL, 1, FALSE);
|
|
| 133 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4736', 'Gew?hrte Skonti 19% USt', 'A', 'E', 'AR_paid', '4735', 3, 51, 1, NULL, 1, FALSE);
|
|
| 134 |
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);
|
|
| 135 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4760', 'Gew?hrte Boni 19% USt', 'A', 'E', 'AR_paid', '4760', 3, 51, 1, NULL, 1, TRUE);
|
|
| 136 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4762', 'Gew?hrte Boni 16% USt', 'A', 'E', 'AR_paid', '4760', 5, 51, 1, NULL, 1, TRUE);
|
|
| 137 |
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);
|
|
| 138 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4790', 'Gew?hrte Rabatte 19% USt', 'A', 'E', 'AR_paid', '4790', 3, 51, 1, NULL, 1, TRUE);
|
|
| 139 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4792', 'Gew?hrte Rabatte 16% USt', 'A', 'E', 'AR_paid', '4790', 5, 51, 1, NULL, 1, TRUE);
|
|
| 140 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4800', 'Bestandsver?nd. fert. Erzeugnisse', 'A', 'E', '', '4800', 0, 0, 2, NULL, NULL, FALSE);
|
|
| 141 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4810', 'Bestandsver?nd. unfert. Erzeugnisse', 'A', 'E', '', '4810', 0, 0, 2, NULL, NULL, FALSE);
|
|
| 142 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4815', 'Bestandsver?nd. unfert. Leistungen', 'A', 'E', '', '4815', 0, 0, 2, NULL, NULL, FALSE);
|
|
| 126 | 143 |
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);
|
|
| 144 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4830', 'Sonstige betrbl. Ertr?ge', 'A', 'I', '', '4830', 3, 51, 33, NULL, 2, FALSE);
|
|
| 128 | 145 |
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 | 146 |
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);
|
|
| 147 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4837', 'Sonstige Ertr?ge betrfremd und regelm.', 'A', 'I', '', '4837', 0, NULL, 33, NULL, NULL, FALSE);
|
|
| 148 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6884', 'Erl?se a.Verk.Sachanlagen steuerfrei?4Nr.1aUStG(b.Buchverlust)', 'A', 'E', '', '4844', 0, NULL, NULL, NULL, 1, TRUE);
|
|
| 149 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6885', 'Erl?se aus Verk. Sachanl.verm. 19% USt (bei Buchverlust)', 'A', 'E', '', '4845', 0, NULL, NULL, NULL, 2, TRUE);
|
|
| 150 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6888', 'Erl?se a.Verk.Sachanlagen steuerfrei?4Nr.1bUStG(b.Buchverlust)', 'A', 'E', '', '4848', 0, NULL, NULL, NULL, 1, TRUE);
|
|
| 151 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4849', 'Erl?se aus Verk. Sachanl.verm. (bei Buchgewinn)', 'A', 'I', 'AR_amount', '4849', 3, 51, NULL, NULL, 1, FALSE);
|
|
| 135 | 152 |
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);
|
|
| 153 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4900', 'Ertr?ge Abgang Gegst. d. Anlageverm.', 'A', 'I', '', '4900', 0, NULL, 33, NULL, 2, FALSE);
|
|
| 154 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4905', 'Ertr?ge Abgang Gegst. d. Umlaufverm.', 'A', 'I', '', '4905', 0, NULL, 33, NULL, 2, FALSE);
|
|
| 155 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4910', 'Ertr?ge Zuschreibung d. Sachanl.verm.', 'A', 'I', '', '4910', 0, NULL, 33, NULL, 2, FALSE);
|
|
| 156 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4915', 'Ertr?ge Zuschreibung d. Umlaufverm.', 'A', 'I', '', '4915', 0, NULL, 33, NULL, NULL, FALSE);
|
|
| 157 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4920', 'Ertr?ge d. Herabs. Pauschwber. zu Forderungen', 'A', 'I', '', '4920', 0, NULL, 33, NULL, 2, FALSE);
|
|
| 158 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4925', 'Ertr?ge aus abgeschriebenen Forderungen', 'A', 'I', '', '4925', 0, NULL, 33, NULL, NULL, FALSE);
|
|
| 159 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4930', 'Ertr?ge aus Aufl?sung von R?ckstellungen', 'A', 'I', '', '4930', 0, NULL, 33, NULL, NULL, FALSE);
|
|
| 143 | 160 |
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);
|
|
| 161 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4939', 'Ertr?ge aus Aufl?sung SoPo mit R?cklagenanteil (AnsparAfA)', 'A', 'I', '', '4939', 0, NULL, 5, NULL, NULL, FALSE);
|
|
| 162 |
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);
|
|
| 163 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4945', 'Sachbez?ge 19% Ust (Waren)', 'A', 'I', 'AR_amount', '4945', 3, 51, 5, NULL, 2, TRUE);
|
|
| 164 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4946', 'Verrechnete sons. Sachbez?ge', 'A', 'I', 'AR_amount', '4946', 0, 0, 5, NULL, 2, FALSE);
|
|
| 148 | 165 |
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 | 166 |
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 | 167 |
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 | 168 |
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);
|
|
| 169 |
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 | 170 |
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);
|
|
| 171 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5400', 'Wareneingang 19% Vorsteuer', 'A', 'E', 'AP_amount:IC_cogs', '5400', 9, NULL, 4, NULL, 8, TRUE);
|
|
| 172 |
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', 18, 93, 4, NULL, 8, TRUE);
|
|
| 173 |
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 19% VorSt u. Ust', 'A', 'E', 'AP_amount:IC_cogs', '5425', 19, 97, 4, NULL, 8, TRUE);
|
|
| 174 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5440', 'Innergem.Erwerb v.Neufahrz.v.Lief.o.USt-IdNr. 19%VSt.u.19%USt.', 'A', 'E', 'AP_amount:IC_cogs', '5440', 19, 94, NULL, NULL, 8, TRUE);
|
|
| 158 | 175 |
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 | 176 |
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 | 177 |
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);
|
| ... | ... | |
| 163 | 180 |
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 | 181 |
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 | 182 |
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);
|
|
| 183 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5660', 'Nicht abziehb.Vorsteuer 19%', 'A', 'E', '', '5650', 0, NULL, 5, NULL, 8, FALSE);
|
|
| 167 | 184 |
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);
|
|
| 185 |
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', 7, NULL, 4, NULL, NULL, TRUE);
|
|
| 186 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5736', 'Erhaltene Skonti 19% Vorsteuer', 'A', 'I', 'AP_paid', '5735', 9, NULL, 4, NULL, NULL, TRUE);
|
|
| 169 | 187 |
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);
|
|
| 188 |
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 19% Vorsteuer', 'A', 'I', 'AP_paid', '5760', 9, NULL, 4, NULL, NULL, TRUE);
|
|
| 189 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5764', 'Erhaltene Boni 16% Vorsteuer', 'A', 'I', 'AP_paid', '5760', 7, NULL, 4, NULL, NULL, TRUE);
|
|
| 171 | 190 |
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);
|
|
| 191 |
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 19% Vorsteuer', 'A', 'I', 'AP_paid', '5790', 9, NULL, 4, NULL, NULL, TRUE);
|
|
| 192 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5794', 'Erhaltene Rabatte 16% Vorsteuer', 'A', 'I', 'AP_paid', '5790', 7, NULL, 4, NULL, NULL, TRUE);
|
|
| 173 | 193 |
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 | 194 |
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 | 195 |
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);
|
|
| 196 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5860', 'Verrechnete Stoffkosten (GegenKto 5000-99)', 'A', 'E', 'IC_cogs', '5860', 0, NULL, 4, NULL, NULL, FALSE);
|
|
| 197 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5880', 'Bestandsver?nd. Roh-, Hilfs-, Betriebsstoffe/Waren', 'A', 'E', '', '5880', 0, NULL, 2, NULL, NULL, FALSE);
|
|
| 178 | 198 |
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);
|
|
| 199 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5915', 'Leist.v.ausl?nd.Untern. 7% VSt.u.7%USt.', 'A', 'E', 'AP_amount', '5915', 18, NULL, 5, NULL, 8, TRUE);
|
|
| 200 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5925', 'Leist.v.ausl?nd.Untern. 19% VSt.u.19%USt.', 'A', 'E', 'AP_amount', '5925', 19, NULL, 5, NULL, 8, TRUE);
|
|
| 181 | 201 |
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 | 202 |
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 | 203 |
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 | 204 |
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 | 205 |
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);
|
|
| 206 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6040', 'Pauschale Steuer f?r Aushilfen', 'A', 'E', '', '6040', 0, NULL, 10, NULL, 10, FALSE);
|
|
| 187 | 207 |
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 | 208 |
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 | 209 |
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);
|
|
| 210 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6069', 'Pauschale Steuer auf sonst. Bez?ge (z.B. Fahrtkostenzuschuss)', 'A', 'E', '', '6069', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 191 | 211 |
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 | 212 |
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 | 213 |
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);
|
| ... | ... | |
| 196 | 216 |
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 | 217 |
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 | 218 |
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);
|
|
| 219 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6205', 'Abschreibung auf Gesch.- o. Firmenwert', 'A', 'E', '', '6205', 0, NULL, NULL, NULL, 25, FALSE);
|
|
| 200 | 220 |
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 | 221 |
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 | 222 |
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);
|
| ... | ... | |
| 211 | 231 |
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 | 232 |
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 | 233 |
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);
|
|
| 234 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6270', 'Abschreibungen auf Finanzanlagen (un?bl. hoch)', 'A', 'E', '', '6270', NULL, NULL, NULL, NULL, NULL, FALSE);
|
|
| 235 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6275', 'Abschr.a.Wertp.d.Umlaufverm?gens (un?bl. hoch)', 'A', 'E', '', '6275', 0, NULL, 17, NULL, NULL, FALSE);
|
|
| 236 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6280', 'Forderungsverlust (un?bl. hoch)', 'A', 'E', '', '6280', 0, NULL, 20, NULL, NULL, FALSE);
|
|
| 237 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6281', 'Forderungsverluste 7% USt (un?bl. hoch)', 'A', 'E', '', '6281', 2, 86, 20, NULL, NULL, TRUE);
|
|
| 238 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6285', 'Forderungsverluste 16% USt (un?bl. hoch)', 'A', 'E', '', '6285', 5, 51, 20, NULL, NULL, TRUE);
|
|
| 239 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6286', 'Forderungsverluste 19% USt (un?bl. hoch)', 'A', 'E', '', '6285', 3, 51, 20, NULL, NULL, TRUE);
|
|
| 240 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6287', 'Forderungsverluste 15% USt (un?bl. hoch)', 'A', 'E', '', '6285', 3, 51, 20, NULL, NULL, TRUE);
|
|
| 219 | 241 |
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 | 242 |
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 | 243 |
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 | 244 |
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);
|
|
| 245 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6310', 'Miete (unbewegl. WG)', 'A', 'E', 'AP_amount', '6310', 9, NULL, 11, NULL, 11, FALSE);
|
|
| 246 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6315', 'Pacht (unbewegl. WG)', 'A', 'E', 'AP_amount', '6315', 0, NULL, NULL, NULL, 11, FALSE);
|
|
| 225 | 247 |
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);
|
|
| 248 |
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);
|
|
| 249 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6330', 'Reinigung', 'A', 'E', 'AP_amount', '6330', 9, NULL, 11, NULL, 24, FALSE);
|
|
| 228 | 250 |
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 | 251 |
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 | 252 |
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 | 253 |
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 | 254 |
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 | 255 |
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);
|
|
| 256 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6405', 'Versicherungen f?r Geb?ude', 'A', 'E', '', '6405', 0, NULL, NULL, NULL, 24, FALSE);
|
|
| 238 | 257 |
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 | 258 |
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 | 259 |
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);
|
| ... | ... | |
| 242 | 261 |
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 | 262 |
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 | 263 |
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);
|
|
| 264 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6470', 'Rep u. Instandh. v. Betr.- u. Gesch?ftsausstattung', 'A', 'E', 'AP_amount', '6470', 9, NULL, 18, NULL, 19, FALSE);
|
|
| 246 | 265 |
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 | 266 |
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 | 267 |
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 | 268 |
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 | 269 |
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 | 270 |
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 | 271 |
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 | 272 |
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);
|
|
| 273 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6560', 'Mietleasing Kfz', 'A', 'E', 'AP_amount', '6560', 0, NULL, 14, NULL, 17, FALSE);
|
|
| 256 | 274 |
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 | 275 |
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 | 276 |
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 | 277 |
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);
|
|
| 278 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6600', 'Werbekosten', 'A', 'E', 'AP_amount', '6600', 9, NULL, 15, NULL, 18, FALSE);
|
|
| 261 | 279 |
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 | 280 |
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 | 281 |
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);
|
| ... | ... | |
| 267 | 285 |
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 | 286 |
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 | 287 |
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);
|
|
| 288 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6663', 'Reisekosten Arbeitnehmer, Reisekosten', 'A', 'E', 'AP_amount', '6663', 8, NULL, 15, NULL, 18, FALSE);
|
|
| 271 | 289 |
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 | 290 |
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 | 291 |
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 | 292 |
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);
|
|
| 293 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6673', 'Reisekosten Unternehmer, Reisekosten', 'A', 'E', 'AP_amount', '6673', 8, NULL, 15, NULL, 18, FALSE);
|
|
| 276 | 294 |
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 | 295 |
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);
|
|
| 296 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6689', 'Fahrten zw.Wohn.und Arbeitsst?tte (nicht abziehb.Teil)', 'A', 'E', '', '6688', 0, NULL, NULL, NULL, 18, FALSE);
|
|
| 297 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6690', 'Fahrten zw.Wohn.-und Arbeitsst?tte (Haben)', 'A', 'E', '', '6689', 0, NULL, NULL, NULL, 18, FALSE);
|
|
| 280 | 298 |
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 | 299 |
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 | 300 |
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 | 301 |
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 | 302 |
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);
|
|
| 303 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6780', 'Fremdarbeiten (Vertrieb)', 'A', 'E', 'AP_amount:IC_expense', '6780', 0, NULL, NULL, NULL, 24, FALSE);
|
|
| 286 | 304 |
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 | 305 |
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 | 306 |
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);
|
|
| 307 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6810', 'Telefax und Internet', 'A', 'E', 'AP_amount', '6810', 9, NULL, 20, NULL, 23, FALSE);
|
|
| 290 | 308 |
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);
|
|
| 309 |
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 | 310 |
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 | 311 |
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 | 312 |
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 | 313 |
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 | 314 |
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 | 315 |
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);
|
|
| 316 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6840', 'Mietleasing (bewegl. WG)', 'A', 'E', 'AP_amount', '6840', 9, NULL, 20, NULL, 21, FALSE);
|
|
| 299 | 317 |
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 | 318 |
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 | 319 |
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 | 320 |
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 | 321 |
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);
|
|
| 322 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6870', 'Nicht abziehbare Vorsteuer 19%', 'A', 'E', 'AP_paid', '6870', 0, NULL, 20, NULL, NULL, FALSE);
|
|
| 305 | 323 |
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 | 324 |
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 | 325 |
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 | 326 |
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 | 327 |
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 | 328 |
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);
|
|
| 329 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6967', 'Sonst. Aufwendungen betriebsfremd, regelm??ig', 'A', 'E', '', '6967', 0, NULL, 31, NULL, 24, FALSE);
|
|
| 313 | 330 |
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 | 331 |
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 | 332 |
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);
|
| ... | ... | |
| 339 | 356 |
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 | 357 |
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 | 358 |
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);
|
|
| 359 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7640', 'Gewerbestnachzahl.Vorj.v.Einkomm u.Ertrag', 'A', 'E', '', '7640', 0, NULL, 31, NULL, NULL, FALSE);
|
|
| 360 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7642', 'Gewerbesterstat.Vorj.Steuer v.Eink.u.Ertrag', 'A', 'I', '', '7642', 0, NULL, 33, NULL, NULL, FALSE);
|
|
| 361 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7644', 'Ertr?ge aus Aufl?sung v. GewSt.R?ckst.', 'A', 'I', '', '7644', 0, NULL, 33, NULL, NULL, FALSE);
|
|
| 362 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7650', 'Sonstige Steuern', 'A', 'E', '', '7650', 0, NULL, 12, NULL, 31, FALSE);
|
|
| 346 | 363 |
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 | 364 |
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 | 365 |
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);
|
|
| 366 |
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);
|
|
| 351 | 367 |
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 | 368 |
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 | 369 |
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);
|
| ... | ... | |
| 362 | 378 |
|
| 363 | 379 |
|
| 364 | 380 |
|
| 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%'); |
|
| 381 |
INSERT INTO tax (rate, taxkey, taxdescription) VALUES ('0','0','Keine Steuer');
|
|
| 382 |
INSERT INTO tax (rate, taxkey, taxdescription) VALUES ('0','1','Umsatzsteuerfrei');
|
|
| 383 |
INSERT INTO tax VALUES ((SELECT id FROM chart WHERE accno = '3801'),'0.07','3801','2','Umsatzsteuer'); |
|
| 384 |
INSERT INTO tax (chart_id, rate, taxnumber, taxkey, taxdescription) VALUES ((SELECT id FROM CHART WHERE accno='3806'), 0.19, '3806', 3, 'Umsatzsteuer'); |
|
| 385 |
INSERT INTO tax VALUES ((SELECT id FROM chart WHERE accno = '3805'),'0.16','3805','5','Umsatzsteuer'); |
|
| 386 |
INSERT INTO tax VALUES ((SELECT id FROM chart WHERE accno = '1401'),'0.07','1401','8','Vorsteuer'); |
|
| 387 |
INSERT INTO tax VALUES ((SELECT id FROM chart WHERE accno = '1405'),'0.16','1405','7','Vorsteuer'); |
|
| 388 |
INSERT INTO tax (chart_id, rate, taxnumber, taxkey, taxdescription) VALUES ((SELECT id FROM CHART WHERE accno='1406'), 0.19, '1406', 9, 'Vorsteuer'); |
|
| 389 |
INSERT INTO tax (taxkey, taxdescription) VALUES ('10','Im anderen EG-Staat steuerpfl. Lieferung');
|
|
| 390 |
INSERT INTO tax (taxkey, taxdescription) VALUES ('11','Steuerfreie EG-Lief. an Abn. mit UStIdNr');
|
|
| 391 |
INSERT INTO tax (chart_id, rate,taxnumber, taxkey, taxdescription) VALUES ((SELECT id FROM chart WHERE accno = '3802'),'0.07','3802','12','Steuerpflicht. EG-Lieferungen'); |
|
| 392 |
INSERT INTO tax (chart_id,rate,taxnumber, taxkey, taxdescription) VALUES ((SELECT id FROM chart WHERE accno = '3804'),'0.19','3804','13','Steuerpflicht. EG-Lieferungen%'); |
|
| 393 |
INSERT INTO tax (chart_id,rate,taxnumber, taxkey, taxdescription) VALUES ((SELECT id FROM chart WHERE accno = '3803'),'0.16','3803','15','Steuerpflicht. EG-Lieferungen%'); |
|
| 394 |
INSERT INTO tax (chart_id,rate,taxnumber, taxkey, taxdescription) VALUES ((SELECT id FROM chart WHERE accno = '1402'),'0.07','1402','18','Steuerpflicht. EG-Erwerb'); |
|
| 395 |
INSERT INTO tax (chart_id,rate,taxnumber, taxkey, taxdescription) VALUES ((SELECT id FROM chart WHERE accno = '1403'),'0.16','1403','17','Steuerpflicht. EG-Erwerb'); |
|
| 396 |
INSERT INTO tax (chart_id,rate,taxnumber, taxkey, taxdescription) VALUES ((SELECT id FROM chart WHERE accno = '1404'),'0.19','1404','19','Steuerpflicht. EG-Erwerb'); |
|
| 397 |
|
|
| 398 |
|
|
| 377 | 399 |
|
| 378 | 400 |
-- Ergaenzungen fuer 19% UmSt. ab 1.01.2007 |
| 379 | 401 |
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; |
| 380 | 402 |
insert into taxkeys (chart_id, tax_id, taxkey_id,startdate) SELECT 0, id, taxkey, '1970-01-01' FROM tax; |
| 381 |
INSERT INTO chart (accno, description, charttype, category, link, taxkey_id, pos_ustva, pos_eur) |
|
| 382 |
VALUES ('3806','Umsatzsteuer 19 %', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax', 0, 511,6);
|
|
| 383 |
INSERT INTO chart (accno, description, charttype, category, link, taxkey_id, pos_ustva, pos_eur) |
|
| 384 |
VALUES ('1406','Abziehbare Vorsteuer 19 %', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', 0, 66,27);
|
|
| 385 |
INSERT INTO tax (chart_id, rate, taxnumber, taxkey, taxdescription) VALUES ((SELECT id from CHART WHERE accno='3806'), 0.19, '3806', 3, 'Umsatzsteuer 19%'); |
|
| 386 |
INSERT INTO tax (chart_id, rate, taxnumber, taxkey, taxdescription) VALUES ((SELECT id from CHART WHERE accno='1406'), 0.19, '1406', 9, 'Vorsteuer 19%'); |
|
| 387 | 403 |
insert into taxkeys (chart_id, tax_id, taxkey_id, pos_ustva, startdate) select chart.id, (SELECT id from tax where taxdescription='Umsatzsteuer 19%'), 3, pos_ustva, '2007-01-01' from chart WHERE taxkey_id=3; |
| 388 | 404 |
insert into taxkeys (chart_id, tax_id, taxkey_id, pos_ustva, startdate) select chart.id, (SELECT id from tax where taxdescription='Vorsteuer 19%'), 9, pos_ustva, '2007-01-01' from chart WHERE taxkey_id=9; |
| 389 | 405 |
|
| 406 |
|
|
| 390 | 407 |
-- Buchungsgruppen |
| 391 | 408 |
|
| 392 | 409 |
INSERT INTO buchungsgruppen |
| ... | ... | |
| 396 | 413 |
income_accno_id_2, expense_accno_id_2, |
| 397 | 414 |
income_accno_id_3, expense_accno_id_3) |
| 398 | 415 |
VALUES |
| 399 |
('Standard 16%',
|
|
| 416 |
('Standard 19%',
|
|
| 400 | 417 |
-- 1140: Bestand Waren |
| 401 | 418 |
(SELECT id FROM chart WHERE accno = '1140'), |
| 402 |
-- 4400: Erl?se 16% USt.
|
|
| 403 |
-- 5400: Wareneingang 16% Vorsteuer
|
|
| 419 |
-- 4400: Erl?se 19% USt.
|
|
| 420 |
-- 5400: Wareneingang 19% Vorsteuer
|
|
| 404 | 421 |
(SELECT id FROM chart WHERE accno = '4400'), |
| 405 | 422 |
(SELECT id FROM chart WHERE accno = '5400'), |
| 406 | 423 |
-- 4125: Steuerfrei innergem. Lieferungen ?41bUStG |
| 407 |
-- 5550: Steuerfreier innergem.Erwerb |
|
| 424 |
-- 5550: Steuerfreier innergem. Erwerb
|
|
| 408 | 425 |
(SELECT id FROM chart WHERE accno = '4125'), |
| 409 | 426 |
(SELECT id FROM chart WHERE accno = '5550'), |
| 410 |
-- 4315: Erl?s Inland stpfl.EG-Lieferung 16%
|
|
| 411 |
-- 5425: Innergem.Erwerb 16% VorSt u. Ust
|
|
| 427 |
-- 4315: Erl?se aus im Inland strpflichtigen EG-Lieferungen 19%
|
|
| 428 |
-- 5425: Innergem.Erwerb 19% VorSt und Ust
|
|
| 412 | 429 |
(SELECT id FROM chart WHERE accno = '4315'), |
| 413 | 430 |
(SELECT id FROM chart WHERE accno = '5425'), |
| 414 | 431 |
-- 4150: Sonstige steuerfreie Ums?tze ?42-7UStG |
| ... | ... | |
| 426 | 443 |
('Standard 7%',
|
| 427 | 444 |
-- 1140: Bestand Waren |
| 428 | 445 |
(SELECT id FROM chart WHERE accno = '1140'), |
| 429 |
-- 4300: Erl?se 7%USt |
|
| 446 |
-- 4300: Erl?se 7% USt
|
|
| 430 | 447 |
-- 5300: Wareneingang 7% Vorsteuer |
| 431 | 448 |
(SELECT id FROM chart WHERE accno = '4300'), |
| 432 | 449 |
(SELECT id FROM chart WHERE accno = '5300'), |
| 433 | 450 |
-- 4125: Steuerfrei innergem. Lieferungen ?41bUStG |
| 434 |
-- 5550: Steuerfreier innergem.Erwerb |
|
| 451 |
-- 5550: Steuerfreier innergem. Erwerb
|
|
| 435 | 452 |
(SELECT id FROM chart WHERE accno = '4125'), |
| 436 | 453 |
(SELECT id FROM chart WHERE accno = '5550'), |
| 437 |
-- 4310: Erl?se Inland stpfl. EG-Lieferung7%
|
|
| 454 |
-- 4310: Erl?se aus im Inland strpfl. EG-Lieferungen 7%
|
|
| 438 | 455 |
-- 5420: Innergemein.Erwerb 7% VorSt u. Ust |
| 439 | 456 |
(SELECT id FROM chart WHERE accno = '4310'), |
| 440 | 457 |
(SELECT id FROM chart WHERE accno = '5420'), |
Auch abrufbar als: Unified diff
SKR04-Updates übernommen
Aus Bug 1298.