Revision 3774d83b
Von Moritz Bunkus vor mehr als 11 Jahren hinzugefügt
| sql/Germany-DATEV-SKR04EU-chart.sql | ||
|---|---|---|
| 2 | 2 |
-- IT Systems Service http://www.itsystemsservice.de |
| 3 | 3 |
-- |
| 4 | 4 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0135', 'EDV-Software', 'A', 'A', 'AP_amount', '0135', 9, NULL, NULL, NULL, NULL, FALSE);
|
| 5 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0150', 'Gesch?fts- oder Firmenwert', 'A', 'A', 'AP_amount', '0135', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 6 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0240', 'Gesch?ftsbauten', 'A', 'A', 'AP_amount', '0240', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 5 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0150', 'Geschäfts- oder Firmenwert', 'A', 'A', 'AP_amount', '0135', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 6 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0240', 'Geschäftsbauten', 'A', 'A', 'AP_amount', '0240', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 7 | 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', 'Andere Anlagen, 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 | 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 |
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);
|
|
| 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?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);
|
|
| 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 | 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 | 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 | 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);
|
|
| 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 | 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 | 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);
|
| 29 | 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);
|
| ... | ... | |
| 34 | 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);
|
| 35 | 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', '1405', 0, 66, NULL, NULL, 27, FALSE);
|
| 36 | 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', 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', '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', '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', '1408', 0, NULL, 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', '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', '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', '1408', 0, NULL, NULL, NULL, 27, FALSE);
|
|
| 40 | 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);
|
| 41 | 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);
|
| 42 | 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);
|
| 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);
|
|
| 44 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1481', 'Aufl?sung Vorst.a.Vorjahr ?4/3 EStG', 'A', 'A', '', '1481', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 45 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1482', 'Vorst.aus Investitionen ?4/3 EStG', 'A', 'E', '', '1482', 0, NULL, NULL, NULL, 27, FALSE);
|
|
| 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);
|
|
| 44 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1481', 'Auflösung Vorst.a.Vorjahr §4/3 EStG', 'A', 'A', '', '1481', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 45 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1482', 'Vorst.aus Investitionen §4/3 EStG', 'A', 'E', '', '1482', 0, NULL, NULL, NULL, 27, FALSE);
|
|
| 46 | 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);
|
| 47 | 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);
|
| 48 | 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);
|
| 49 | 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);
|
| 50 | 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);
|
| 51 | 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);
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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 | 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);
|
|
| 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 | 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', 'L', '', '3151', 0, NULL, NULL, NULL, NULL, FALSE);
|
| 57 | 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', 'L', '', '3160', 0, NULL, NULL, NULL, NULL, FALSE);
|
| 58 | 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', 'L', '', '3170', 0, NULL, NULL, NULL, NULL, FALSE);
|
| 59 | 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);
|
| 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);
|
|
| 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);
|
|
| 64 | 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', '3801', 0, NULL, NULL, NULL, 5, FALSE);
|
| 65 | 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 | 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);
|
| ... | ... | |
| 70 | 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);
|
| 71 | 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);
|
| 72 | 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);
|
| 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);
|
|
| 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);
|
|
| 76 | 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);
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 82 | 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);
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 102 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4581', 'Erl?se zum erm?.Umsatzsteuersatz (E?R)', 'A', 'I', '', '4581', 0, 0, 1, NULL, 1, FALSE);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 102 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4581', 'Erlöse zum ermä.Umsatzsteuersatz (EÜR)', 'A', 'I', '', '4581', 0, 0, 1, NULL, 1, FALSE);
|
|
| 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);
|
|
| 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);
|
|
| 105 | 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);
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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 | 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 | 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 | 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);
|
| 118 | 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);
|
| 119 | 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 | 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 143 | 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);
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 168 | 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);
|
| 169 | 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);
|
| 170 | 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);
|
| ... | ... | |
| 174 | 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);
|
| 175 | 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);
|
| 176 | 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);
|
| 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);
|
|
| 178 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5581', 'Wareneinkauf z.erm.Umsatzsteuersatz(E?R)', 'A', 'E', '', '5581', 0, 0, 4, NULL, 8, FALSE);
|
|
| 179 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5582', 'Wareneinkauf ohne Vorsteuerabzug(E?R)', 'A', 'E', '', '5582', 0, 0, 4, NULL, 8, FALSE);
|
|
| 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);
|
|
| 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);
|
|
| 178 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5581', 'Wareneinkauf z.erm.Umsatzsteuersatz(EÜR)', 'A', 'E', '', '5581', 0, 0, 4, NULL, 8, FALSE);
|
|
| 179 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5582', 'Wareneinkauf ohne Vorsteuerabzug(EÜR)', 'A', 'E', '', '5582', 0, 0, 4, NULL, 8, FALSE);
|
|
| 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);
|
|
| 181 | 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);
|
| 182 | 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);
|
| 183 | 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);
|
| ... | ... | |
| 192 | 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);
|
| 193 | 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);
|
| 194 | 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);
|
| 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);
|
|
| 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);
|
|
| 196 | 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);
|
|
| 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);
|
|
| 198 | 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);
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 203 | 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);
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 207 | 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);
|
| 208 | 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);
|
| 209 | 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);
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 214 | 214 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6110', 'Gesetzlich soziale Aufwendungen', 'A', 'E', '', '6110', 0, 0, 10, NULL, 10, FALSE);
|
| 215 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6120', 'Beitr?ge zur Berufsgenossenschaft', 'A', 'E', '', '6120', 0, NULL, 10, NULL, 10, FALSE);
|
|
| 215 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6120', 'Beiträge zur Berufsgenossenschaft', 'A', 'E', '', '6120', 0, NULL, 10, NULL, 10, FALSE);
|
|
| 216 | 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);
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 219 | 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);
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 222 | 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);
|
| 223 | 223 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6222', 'Abschreibungen auf Kfz', 'A', 'E', '', '6222', 0, NULL, 17, NULL, 25, FALSE);
|
| 224 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6230', 'Au?erplanm??ig Abschr.a.Sachanlagen', 'A', 'E', '', '6230', 0, NULL, NULL, NULL, 25, FALSE);
|
|
| 225 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6231', 'Absetzung f.au?ergew.techn.u.wirtschaftl.AfA bei Geb?uden', 'A', 'E', '', '6231', 0, NULL, 17, NULL, 25, FALSE);
|
|
| 226 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6232', 'Absetzung f.au?ergew.techn.u.wirtschaftl.AfA des Kfz', 'A', 'E', '', '6232', 0, NULL, 17, NULL, 25, FALSE);
|
|
| 227 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6233', 'Absetzung f.au?ergew.techn.u.wirtschaftl.AfA sonst.WG', 'A', 'E', '', '6233', 0, NULL, 17, NULL, 25, FALSE);
|
|
| 224 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6230', 'Außerplanmäßig Abschr.a.Sachanlagen', 'A', 'E', '', '6230', 0, NULL, NULL, NULL, 25, FALSE);
|
|
| 225 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6231', 'Absetzung f.außergew.techn.u.wirtschaftl.AfA bei Gebäuden', 'A', 'E', '', '6231', 0, NULL, 17, NULL, 25, FALSE);
|
|
| 226 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6232', 'Absetzung f.außergew.techn.u.wirtschaftl.AfA des Kfz', 'A', 'E', '', '6232', 0, NULL, 17, NULL, 25, FALSE);
|
|
| 227 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6233', 'Absetzung f.außergew.techn.u.wirtschaftl.AfA sonst.WG', 'A', 'E', '', '6233', 0, NULL, 17, NULL, 25, FALSE);
|
|
| 228 | 228 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6240', 'Abschr.a.Sachanl.aufgr.steuerl.Sondervorschriften', 'A', 'E', '', '6240', 0, NULL, 17, NULL, 25, FALSE);
|
| 229 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6241', 'Sonderabschreibung nach ?7g(1)u.(2)EStG (ohne Kfz)', 'A', 'E', '', '6241', 0, NULL, 17, NULL, 25, FALSE);
|
|
| 230 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6242', 'Sonderabschreibung n.?7g(1)u.(2)EStG (f?r Kfz)', 'A', 'E', '', '6242', 0, NULL, 17, NULL, 25, FALSE);
|
|
| 229 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6241', 'Sonderabschreibung nach §7g(1)u.(2)EStG (ohne Kfz)', 'A', 'E', '', '6241', 0, NULL, 17, NULL, 25, FALSE);
|
|
| 230 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6242', 'Sonderabschreibung n.§7g(1)u.(2)EStG (für Kfz)', 'A', 'E', '', '6242', 0, NULL, 17, NULL, 25, FALSE);
|
|
| 231 | 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);
|
| 232 | 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);
|
| 233 | 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);
|
| 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);
|
|
| 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);
|
|
| 241 | 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);
|
| 242 | 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);
|
| 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);
|
|
| 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);
|
|
| 244 | 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);
|
| 245 | 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 | 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);
|
| 247 | 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);
|
| 248 | 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 | 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);
|
| 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);
|
|
| 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);
|
|
| 251 | 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);
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 255 | 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);
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 258 | 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);
|
| 259 | 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);
|
| 260 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6436', 'Steuerl.abzugs.Versp?tungszuschl.u.Zwangsgelder', 'A', 'E', '', '6436', 0, NULL, NULL, NULL, 31, FALSE);
|
|
| 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);
|
|
| 260 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6436', 'Steuerl.abzugs.Verspätungszuschl.u.Zwangsgelder', 'A', 'E', '', '6436', 0, NULL, NULL, NULL, 31, FALSE);
|
|
| 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);
|
|
| 262 | 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);
|
| 263 | 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);
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 266 | 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);
|
| 267 | 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);
|
| 268 | 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);
|
| ... | ... | |
| 272 | 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);
|
| 273 | 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);
|
| 274 | 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);
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 277 | 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);
|
| 278 | 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);
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 282 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6630', 'Repr?sentationskosten', 'A', 'E', 'AP_amount', '6630', 9, NULL, 15, NULL, 18, FALSE);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 282 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6630', 'Repräsentationskosten', 'A', 'E', 'AP_amount', '6630', 9, NULL, 15, NULL, 18, FALSE);
|
|
| 283 | 283 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6640', 'Bewirtungskosten', 'A', 'E', 'AP_amount', '6640', 9, NULL, 20, NULL, 18, FALSE);
|
| 284 | 284 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6643', 'Aufmerksamkeiten', 'A', 'E', 'AP_amount', '6643', 9, NULL, NULL, NULL, 18, FALSE);
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 287 | 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);
|
| 288 | 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);
|
| 289 | 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);
|
| 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);
|
|
| 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);
|
|
| 291 | 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);
|
| 292 | 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);
|
| 293 | 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);
|
| 294 | 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);
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 298 | 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);
|
| 299 | 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);
|
| 300 | 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);
|
| 301 | 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);
|
| 302 | 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);
|
| 303 | 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);
|
| 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);
|
|
| 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);
|
|
| 305 | 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);
|
| 306 | 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);
|
| 307 | 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);
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 310 | 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);
|
| 311 | 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);
|
| 312 | 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);
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 316 | 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);
|
| 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);
|
|
| 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);
|
|
| 318 | 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);
|
| 319 | 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);
|
| 320 | 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);
|
| ... | ... | |
| 322 | 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);
|
| 323 | 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);
|
| 324 | 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);
|
| 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);
|
|
| 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);
|
|
| 326 | 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);
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 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);
|
|
| 330 | 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);
|
| 331 | 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);
|
| 332 | 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);
|
| 333 | 333 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6978', 'Kalkulatorische Wagnisse', 'A', 'E', '', '6978', 0, NULL, 34, NULL, NULL, FALSE);
|
| 334 | 334 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6979', 'Kalkulatorischer Lohn f.unentgeltl.Mitarbeiter', 'A', 'E', '', '6979', 0, NULL, 34, NULL, NULL, FALSE);
|
| 335 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7000', 'Ertr?ge aus Beteiligungen', 'A', 'I', '', '7000', 0, NULL, 33, NULL, NULL, FALSE);
|
|
| 336 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7100', 'Sonstige Zinsen und ?nliche Ertr?ge', 'A', 'I', '', '7100', 0, NULL, 32, NULL, 4, FALSE);
|
|
| 337 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7120', 'Zins?hnliche Ertr?ge', 'A', 'I', '', '7120', 0, NULL, 32, NULL, 4, FALSE);
|
|
| 338 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7130', 'Diskontertr?ge', 'A', 'I', '', '7130', 0, NULL, 32, NULL, 4, FALSE);
|
|
| 339 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7300', 'Zinsen und ?hnl.Aufwendungen', 'A', 'E', '', '7300', 0, NULL, 30, NULL, 29, FALSE);
|
|
| 340 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7305', 'Zinsaufwendung-betriebliche Steuern ?223aAO', 'A', 'E', '', '7305', 0, NULL, 30, NULL, 29, FALSE);
|
|
| 335 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7000', 'Erträge aus Beteiligungen', 'A', 'I', '', '7000', 0, NULL, 33, NULL, NULL, FALSE);
|
|
| 336 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7100', 'Sonstige Zinsen und änliche Erträge', 'A', 'I', '', '7100', 0, NULL, 32, NULL, 4, FALSE);
|
|
| 337 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7120', 'Zinsähnliche Erträge', 'A', 'I', '', '7120', 0, NULL, 32, NULL, 4, FALSE);
|
|
| 338 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7130', 'Diskonterträge', 'A', 'I', '', '7130', 0, NULL, 32, NULL, 4, FALSE);
|
|
| 339 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7300', 'Zinsen und ähnl.Aufwendungen', 'A', 'E', '', '7300', 0, NULL, 30, NULL, 29, FALSE);
|
|
| 340 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7305', 'Zinsaufwendung-betriebliche Steuern §223aAO', 'A', 'E', '', '7305', 0, NULL, 30, NULL, 29, FALSE);
|
|
| 341 | 341 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7310', 'Zinsaufwendung f. kurzf.Verbindlichk', 'A', 'E', '', '7310', 0, NULL, 30, NULL, 29, FALSE);
|
| 342 | 342 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7320', 'Zinsaufwendung f. langf.Verbindlichk', 'A', 'E', '', '7320', 0, NULL, 30, NULL, 29, FALSE);
|
| 343 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7325', 'Zinsaufwend.f.Geb?ude,die z.Betriebsverm?gen geh?ren', 'A', 'E', '', '7325', 0, NULL, NULL, NULL, 29, FALSE);
|
|
| 344 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7326', 'Zinsen zur Finanzierung Anlageverm?gen', 'A', 'E', '', '7326', 0, NULL, NULL, NULL, 29, FALSE);
|
|
| 345 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7330', 'Zins?hnliche Aufwendungen', 'A', 'E', '', '7330', 0, NULL, 30, NULL, 29, FALSE);
|
|
| 343 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7325', 'Zinsaufwend.f.Gebäude,die z.Betriebsvermögen gehören', 'A', 'E', '', '7325', 0, NULL, NULL, NULL, 29, FALSE);
|
|
| 344 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7326', 'Zinsen zur Finanzierung Anlagevermögen', 'A', 'E', '', '7326', 0, NULL, NULL, NULL, 29, FALSE);
|
|
| 345 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7330', 'Zinsähnliche Aufwendungen', 'A', 'E', '', '7330', 0, NULL, 30, NULL, 29, FALSE);
|
|
| 346 | 346 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7340', 'Diskontaufwendung', 'A', 'E', '', '7340', 0, NULL, 30, NULL, NULL, FALSE);
|
| 347 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7400', 'Au?erordentliche Ertr?ge', 'A', 'I', '', '7400', 0, NULL, 33, NULL, 5, FALSE);
|
|
| 348 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7401', 'Ausserordentliche Ertr?ge finanzwirksam', 'A', 'I', '', '7401', 0, NULL, NULL, NULL, 5, FALSE);
|
|
| 349 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7450', 'Ausserordentliche Ertr?ge nicht finanzwirksam', 'A', 'I', '', '7450', 0, NULL, NULL, NULL, 5, FALSE);
|
|
| 350 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7500', 'Au?erordentliche Aufwendung', 'A', 'E', '', '7500', 0, NULL, 31, NULL, 30, FALSE);
|
|
| 351 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7600', 'K?rperschaftssteuer', 'A', 'E', '', '7600', 0, NULL, 35, NULL, NULL, FALSE);
|
|
| 352 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7608', 'Solidarit?tszuschlag', 'A', 'E', '', '7608', 0, NULL, 35, NULL, NULL, FALSE);
|
|
| 353 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7609', 'Solidarit?tszuschlag f?r Vorjahr', 'A', 'E', '', '7609', 0, NULL, 19, NULL, NULL, FALSE);
|
|
| 347 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7400', 'Außerordentliche Erträge', 'A', 'I', '', '7400', 0, NULL, 33, NULL, 5, FALSE);
|
|
| 348 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7401', 'Ausserordentliche Erträge finanzwirksam', 'A', 'I', '', '7401', 0, NULL, NULL, NULL, 5, FALSE);
|
|
| 349 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7450', 'Ausserordentliche Erträge nicht finanzwirksam', 'A', 'I', '', '7450', 0, NULL, NULL, NULL, 5, FALSE);
|
|
| 350 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7500', 'Außerordentliche Aufwendung', 'A', 'E', '', '7500', 0, NULL, 31, NULL, 30, FALSE);
|
|
| 351 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7600', 'Körperschaftssteuer', 'A', 'E', '', '7600', 0, NULL, 35, NULL, NULL, FALSE);
|
|
| 352 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7608', 'Solidaritätszuschlag', 'A', 'E', '', '7608', 0, NULL, 35, NULL, NULL, FALSE);
|
|
| 353 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7609', 'Solidaritätszuschlag für Vorjahr', 'A', 'E', '', '7609', 0, NULL, 19, NULL, NULL, FALSE);
|
|
| 354 | 354 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7610', 'Gewerbesteuer', 'A', 'E', '', '7610', 0, NULL, 12, NULL, 31, FALSE);
|
| 355 | 355 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7632', 'Kapitalertragssteuer 20%', 'A', 'E', '', '7632', 0, NULL, NULL, NULL, NULL, FALSE);
|
| 356 | 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);
|
| ... | ... | |
| 358 | 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);
|
| 359 | 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 | 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);
|
|
| 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 | 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);
|
| 363 | 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);
|
| 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);
|
|
| 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);
|
|
| 365 | 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);
|
| 366 | 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);
|
| 367 | 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);
|
| 368 | 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);
|
| 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);
|
|
| 370 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7745', 'Entnahmen a.satzungsm??igen R?cklagen', 'A', 'E', '', '7745', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 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);
|
|
| 370 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7745', 'Entnahmen a.satzungsmäßigen Rücklagen', 'A', 'E', '', '7745', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 371 | 371 |
|
| 372 | 372 |
|
| 373 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('9000', 'Saldenvortr?ge,Sachkonten', 'A', 'A', '', '9000', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 374 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('9008', 'Saldenvortr?ge,Debitoren', 'A', 'A', '', '9008', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 375 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('9009', 'Saldenvortr?ge,Kreditoren', 'A', 'L', '', '9009', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 373 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('9000', 'Saldenvorträge,Sachkonten', 'A', 'A', '', '9000', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 374 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('9008', 'Saldenvorträge,Debitoren', 'A', 'A', '', '9008', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 375 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('9009', 'Saldenvorträge,Kreditoren', 'A', 'L', '', '9009', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 376 | 376 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('9090', 'Summenvortragskonto', 'A', 'A', '', '9090', 0, NULL, NULL, NULL, NULL, FALSE);
|
| 377 | 377 |
|
| 378 | 378 |
|
| ... | ... | |
| 418 | 418 |
('Standard 19%',
|
| 419 | 419 |
-- 1140: Bestand Waren |
| 420 | 420 |
(SELECT id FROM chart WHERE accno = '1140'), |
| 421 |
-- 4400: Erl?se 19% USt.
|
|
| 421 |
-- 4400: Erlöse 19% USt.
|
|
| 422 | 422 |
-- 5400: Wareneingang 19% Vorsteuer |
| 423 | 423 |
(SELECT id FROM chart WHERE accno = '4400'), |
| 424 | 424 |
(SELECT id FROM chart WHERE accno = '5400'), |
| 425 |
-- 4125: Steuerfrei innergem. Lieferungen ?41bUStG
|
|
| 425 |
-- 4125: Steuerfrei innergem. Lieferungen §41bUStG
|
|
| 426 | 426 |
-- 5550: Steuerfreier innergem. Erwerb |
| 427 | 427 |
(SELECT id FROM chart WHERE accno = '4125'), |
| 428 | 428 |
(SELECT id FROM chart WHERE accno = '5550'), |
| 429 |
-- 4315: Erl?se aus im Inland strpflichtigen EG-Lieferungen 19%
|
|
| 429 |
-- 4315: Erlöse aus im Inland strpflichtigen EG-Lieferungen 19%
|
|
| 430 | 430 |
-- 5425: Innergem.Erwerb 19% VorSt und Ust |
| 431 | 431 |
(SELECT id FROM chart WHERE accno = '4315'), |
| 432 | 432 |
(SELECT id FROM chart WHERE accno = '5425'), |
| 433 |
-- 4150: Sonstige steuerfreie Ums?tze ?42-7UStG
|
|
| 433 |
-- 4150: Sonstige steuerfreie Umsätze §42-7UStG
|
|
| 434 | 434 |
-- 5559: Steuerfreie Einfuhren |
| 435 | 435 |
(SELECT id FROM chart WHERE accno = '4150'), |
| 436 | 436 |
(SELECT id FROM chart WHERE accno = '5559')); |
| ... | ... | |
| 445 | 445 |
('Standard 7%',
|
| 446 | 446 |
-- 1140: Bestand Waren |
| 447 | 447 |
(SELECT id FROM chart WHERE accno = '1140'), |
| 448 |
-- 4300: Erl?se 7% USt
|
|
| 448 |
-- 4300: Erlöse 7% USt
|
|
| 449 | 449 |
-- 5300: Wareneingang 7% Vorsteuer |
| 450 | 450 |
(SELECT id FROM chart WHERE accno = '4300'), |
| 451 | 451 |
(SELECT id FROM chart WHERE accno = '5300'), |
| 452 |
-- 4125: Steuerfrei innergem. Lieferungen ?41bUStG
|
|
| 452 |
-- 4125: Steuerfrei innergem. Lieferungen §41bUStG
|
|
| 453 | 453 |
-- 5550: Steuerfreier innergem. Erwerb |
| 454 | 454 |
(SELECT id FROM chart WHERE accno = '4125'), |
| 455 | 455 |
(SELECT id FROM chart WHERE accno = '5550'), |
| 456 |
-- 4310: Erl?se aus im Inland strpfl. EG-Lieferungen 7%
|
|
| 456 |
-- 4310: Erlöse aus im Inland strpfl. EG-Lieferungen 7%
|
|
| 457 | 457 |
-- 5420: Innergemein.Erwerb 7% VorSt u. Ust |
| 458 | 458 |
(SELECT id FROM chart WHERE accno = '4310'), |
| 459 | 459 |
(SELECT id FROM chart WHERE accno = '5420'), |
| 460 |
-- 4150: Sonstige steuerfreie Ums?tze ?42-7UStG
|
|
| 460 |
-- 4150: Sonstige steuerfreie Umsätze §42-7UStG
|
|
| 461 | 461 |
-- 5559; Steuerfreie Einfuhren |
| 462 | 462 |
(SELECT id FROM chart WHERE accno = '4150'), |
| 463 | 463 |
(SELECT id FROM chart WHERE accno = '5559')); |
Auch abrufbar als: Unified diff
Alle ISO-8859-15-codierten Files nach UTF-8 encodieren