Revision 71dd004b
Von Moritz Bunkus vor fast 14 Jahren hinzugefügt
| sql/Germany-DATEV-SKR04EU-chart.sql | ||
|---|---|---|
| 1 |
-- DATEV SKR04 |
|
| 2 |
-- IT Systems Service http://www.itsystemsservice.de |
|
| 3 |
-- |
|
| 4 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0135', 'EDV-Software', 'A', 'A', 'AP_amount', '0135', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 5 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0150', 'Gesch?fts- oder Firmenwert', 'A', 'A', 'AP_amount', '0135', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 6 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0240', 'Gesch?ftsbauten', 'A', 'A', 'AP_amount', '0240', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 7 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0400', 'Techn. Anlagen und Maschinen', 'A', 'A', 'AP_amount', '0400', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 8 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0440', 'Maschinen', 'A', 'A', 'AP_amount', '0440', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 9 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0500', 'Betriebs- und Gesch?ftsausstattung', 'A', 'A', 'AP_amount', '0500', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 10 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0510', 'Andere Anlagen', 'A', 'A', 'AP_amount', '0510', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 11 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0520', 'PKW', 'A', 'A', 'AP_amount', '0440', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 12 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0560', 'Sonst. Transportmittel', 'A', 'A', 'AP_amount', '0560', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 13 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0650', 'B?roeinrichtung', 'A', 'A', 'AP_amount', '0650', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 14 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0640', 'Ladeneinrichtung', 'A', 'A', 'AP_amount', '0640', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 15 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0620', 'Werkzeuge', 'A', 'A', 'AP_amount', '0620', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 16 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0670', 'Geringwertige Wirtschaftsg.b.410EUR', 'A', 'A', 'AP_amount', '0670', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 17 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1000', 'Roh,-Hilfs,-und Betriebsstoffe', 'A', 'E', 'IC', '1000', 9, NULL, 4, NULL, NULL, FALSE);
|
|
| 18 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1140', 'Waren', 'A', 'E', 'IC', '1140', 9, NULL, 4, NULL, NULL, FALSE);
|
|
| 19 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1200', 'Ford. aus Lieferungen und Leistungen', 'A', 'A', 'AR', '1200', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 20 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1215', 'Ford.a.LuL z.allg.USt-Satz', 'A', 'A', 'AR', '1215', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 21 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1216', 'Ford.a.LuL z.erm.USt.-Satz (E?R)', 'A', 'A', 'AR', '1216', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 22 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1217', 'Ford.a.steuerfr.od.nicht steuerb.LuL (E?R)', 'A', 'A', 'AR', '1217', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 23 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1218', 'Ford.a.LuL gem.?24UStG(E?R)', 'A', 'A', 'AR', '1218', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 24 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1219', 'Gegenkto. bei Aufteil.d.Ford.n.Steuers.(E?R)', 'A', 'A', '', '1219', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 25 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1220', 'Ford.n.?11(1)2EStG f.?4/3 EStG', 'A', 'A', 'AR', '1220', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 26 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1248', 'Pauschalwertbe.z.Ford.bis1J.', 'A', 'E', '', '1248', 0, NULL, 31, NULL, NULL, FALSE);
|
|
| 27 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1249', 'Pauschalwertbe.z.Ford.ueb1J.', 'A', 'E', '', '1249', 0, NULL, 31, NULL, NULL, FALSE);
|
|
| 28 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1370', 'Durchlaufende Posten', 'A', 'A', '', '1370', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 29 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1374', 'Fremdgeld', 'A', 'A', '', '1374', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 30 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1401', 'Abziehbare Vorsteuer 7%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1401', 0, 66, NULL, NULL, 27, FALSE);
|
|
| 31 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1402', 'Abziehbare Vorsteuer aus EG-Erwerb 7%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', '1402', 0, 61, NULL, NULL, 27, FALSE);
|
|
| 32 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1403', 'Abziehbare Vorsteuer aus EG-Erwerb 16%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', '1403', 0, 61, NULL, NULL, 27, FALSE);
|
|
| 33 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1405', 'Abziehbare Vorsteuer 16%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1405', 0, 66, NULL, NULL, 27, FALSE);
|
|
| 34 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1407', 'Abziehb.Vorst.n.allgem.Durchschnittss?tzen UStVA Kz.63', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1407', 0, NULL, NULL, NULL, 27, FALSE);
|
|
| 35 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1408', 'Abziehbare Vorsteuer n.?13b', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1408', 0, NULL, NULL, NULL, 27, FALSE);
|
|
| 36 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1433', 'Bezahlte Einfuhrumsatzsteuer', 'A', 'E', '', '1433', 0, 62, NULL, NULL, NULL, FALSE);
|
|
| 37 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1460', 'Geldtransit', 'A', 'A', '', '1460', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 38 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1480', 'Gegenkonto Vorsteuer ?4/3 EStG', 'A', 'A', '', '1480', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 39 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1481', 'Aufl?sung Vorst.a.Vorjahr ?4/3 EStG', 'A', 'A', '', '1481', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 40 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1482', 'Vorst.aus Investitionen ?4/3 EStG', 'A', 'E', '', '1482', 0, NULL, NULL, NULL, 27, FALSE);
|
|
| 41 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1484', 'abziehb.VorSt EU-Erwerb Neufzg.b.Lief. o. USt.Ident.Nr', 'A', 'E', 'AR_tax', '1483', 0, NULL, NULL, NULL, 27, FALSE);
|
|
| 42 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1600', 'Kasse', 'A', 'A', 'AR_paid:AP_paid', '1600', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 43 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1800', 'Bank', 'A', 'A', 'AR_paid:AP_paid', '1800', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 44 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2100', 'Privatentnahme allgemein', 'A', 'Q', '', '2100', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 45 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2150', 'Privatsteuern', 'A', 'Q', '', '2150', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 46 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2180', 'Privateinlagen', 'A', 'Q', '', '2180', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 47 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2200', 'Sonderausgaben beschr?nkt abzugsf?hig', 'A', 'Q', '', '2200', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 48 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2230', 'Sonderausgaben unbeschr. abzugsf?hig', 'A', 'Q', '', '2230', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 49 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2250', 'Zuwendungen, Spenden', 'A', 'Q', '', '2250', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 50 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2953', 'Satzungsm.R?cklagen 0% Vorbelast.EK02', 'A', 'Q', '', '2953', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 51 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3151', 'Vblk.geg.Kreditinst.- Restlaufzeit b.1 Jahr', 'A', 'A', '', '3151', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 52 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3160', 'Vblk.geg.Kreditinst.- Restlaufzeit 1 bis 5 Jahre', 'A', 'A', '', '3160', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 53 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3170', 'Vblk.geg.Kreditinst.- Restlaufzeit gr?sser als 5 Jahre', 'A', 'A', '', '3170', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 54 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3300', 'Verbindlichkeiten aus Lief.u.Leist.', 'A', 'L', 'AP', '3300', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 55 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3305', 'Vblk.a.LuL z.allg.Umsatzsteuersatz (E?R)', 'A', 'L', 'AP', '3305', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 56 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3306', 'Vblk.a.LuL zum erm.Umsatzsteuersatz (E?R)', 'A', 'L', 'AP', '3306', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 57 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3307', 'Vblk.a.LuL ohne Vorsteuer (E?R)', 'A', 'L', 'AP', '3307', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 58 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3309', 'Gegenkonto 1605-1607 b.Aufteilung d.Vblk.n.Steuers.(E?R)', 'A', 'L', '', '3309', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 59 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3801', 'Umsatzsteuer 7%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax', '3801', 0, NULL, NULL, NULL, 5, FALSE);
|
|
| 60 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3802', 'Umsatzsteuer aus EG-Erwerb 7%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', '3802', 0, NULL, NULL, NULL, 6, FALSE);
|
|
| 61 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3803', 'Umsatzsteuer aus EG-Erwerb 16%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', '3803', 0, NULL, NULL, NULL, 28, FALSE);
|
|
| 62 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3805', 'Umsatzsteuer 16%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax', '3805', 0, NULL, NULL, NULL, 6, FALSE);
|
|
| 63 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3817', 'Umsatzsteuer a.i.anderen EG-Land stpfl.Lieferungen', 'A', ' ', '', '3817', 10, NULL, 0, NULL, NULL, FALSE);
|
|
| 64 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3820', 'Umsatzsteuer-Vorauszahlungen', 'A', 'E', '', '3820', 0, NULL, NULL, NULL, 28, FALSE);
|
|
| 65 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3830', 'Umsatzsteuer-Vorauszahlungen 1/11', 'A', 'E', '', '3830', 0, NULL, NULL, NULL, 28, FALSE);
|
|
| 66 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3833', 'Umsatzsteuer n.?13b UStG', 'A', 'I', '', '3833', 0, NULL, 33, NULL, 7, FALSE);
|
|
| 67 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3841', 'Umsatzsteuer Vorjahr', 'A', 'E', '', '3841', 0, NULL, NULL, NULL, 28, FALSE);
|
|
| 68 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3845', 'Umsatzsteuer fr?here Jahre', 'A', 'E', '', '3845', 0, NULL, NULL, NULL, 28, FALSE);
|
|
| 69 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4110', 'Sonstige steuerfreie Ums?tze Inland', 'A', 'I', 'AR_amount', '4110', 0, NULL, NULL, NULL, 1, TRUE);
|
|
| 70 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4120', 'Steuerfreie Ums?tze ?4Nr.1a UstG', 'A', 'I', 'AR_amount:IC_sale:IC_income', '4120', 0, 48, 1, NULL, 1, TRUE);
|
|
| 71 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4125', 'Steuerfrei innergem. Lieferungen ?41bUStG', 'A', 'I', 'AR_amount:IC_sale:IC_income', '4125', 0, 41, 1, NULL, 1, TRUE);
|
|
| 72 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4130', 'Liefe.d.1.Abnehm.bei innergem.Dreiecksg ?25b2UStG', 'A', 'I', 'AR_amount:IC_sale:IC_income', '4130', 0, NULL, NULL, NULL, 1, TRUE);
|
|
| 73 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4135', 'Steuerfr.innergem.Lief.v.Neufahrz.an Abn.o.USt-Ident-Nr.', 'A', 'I', 'AR_amount:IC_sale', '4135', 0, NULL, NULL, NULL, 1, TRUE);
|
|
| 74 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4150', 'Sonstige steuerfreie Ums?tze ?42-7UStG', 'A', 'I', 'AR_amount:IC_sale:IC_income', '4150', 0, NULL, NULL, NULL, 1, TRUE);
|
|
| 75 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4180', 'Erl?se,die mit den Durchschnittss?tzen d.?24UStG vers.werd.', 'A', 'I', 'AR_amount', '4180', NULL, NULL, NULL, NULL, 1, FALSE);
|
|
| 76 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4185', 'Erl?se als Kleinunternehmer i.S.d.?19(1)UStG', 'A', 'I', 'AR_amount', '4185', NULL, NULL, 1, NULL, 1, FALSE);
|
|
| 77 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4200', 'Erl?se', 'A', 'I', 'AR_amount:IC_sale:IC_income', '4200', 0, NULL, 1, NULL, 1, FALSE);
|
|
| 78 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4300', 'Erl?se 7%USt', 'A', 'I', 'AR_amount:IC_sale:IC_income', '4300', 2, 86, 1, NULL, 1, TRUE);
|
|
| 79 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4310', 'Erl?se Inland stpfl. EG-Lieferung7%', 'A', 'I', 'AR_amount:IC_sale:IC_income', '4310', 12, 86, 1, NULL, 1, TRUE);
|
|
| 80 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4315', 'Erl?s Inland stpfl.EG-Lieferung 16%', 'A', 'I', 'AR_amount:IC_sale:IC_income', '4315', 13, 51, 1, NULL, 1, TRUE);
|
|
| 81 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4320', 'Erl?se aus im and.EG-Land steuerpfl.Lieferungen', 'A', 'I', 'AR_amount:IC_sale:IC_income', '4320', 10, NULL, 1, NULL, 1, FALSE);
|
|
| 82 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4400', 'Erl?se 16% USt.', 'A', 'I', 'AR_amount:IC_sale:IC_income', '4400', 3, 51, 1, NULL, 1, TRUE);
|
|
| 83 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4500', 'Provisionserl?se', 'A', 'I', 'AR_amount:IC_income', '4500', 3, 51, 5, NULL, 2, FALSE);
|
|
| 84 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4504', 'Steuerfreie Ums?tze ?4Nr.8ff UstG', 'A', 'I', 'AR_amount', '4504', 0, 0, 1, NULL, NULL, TRUE);
|
|
| 85 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4506', 'Provisionserl?se 7% USt.', 'A', 'I', 'AR_amount:IC_income', '4506', 2, 86, NULL, NULL, 2, FALSE);
|
|
| 86 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4508', 'Provisionserl?se 16% USt.', 'A', 'I', 'AR_amount:IC_income', '4508', 3, 51, NULL, NULL, 2, FALSE);
|
|
| 87 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4510', 'Erl?se Abfallverwertung', 'A', 'I', 'AR_amount:IC_sale', '4510', 3, NULL, NULL, NULL, 2, FALSE);
|
|
| 88 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4520', 'Erl?s Leergut', 'A', 'I', 'AR_amount:IC_sale', '4520', 3, 51, 5, NULL, 2, FALSE);
|
|
| 89 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4580', 'Erl?se zum allg.Umsatzsteuersatz (E?R)', 'A', 'I', '', '4580', 0, 0, 1, NULL, 1, FALSE);
|
|
| 90 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4581', 'Erl?se zum erm?.Umsatzsteuersatz (E?R)', 'A', 'I', '', '4581', 0, 0, 1, NULL, 1, FALSE);
|
|
| 91 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4582', 'Erl?se steuerfrei u.nicht steuerbar (E?R)', 'A', 'I', '', '4582', 0, 0, 1, NULL, 1, FALSE);
|
|
| 92 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4589', 'Gegenkonto 8580-8582 b.Aufteilung d.Erl?se n.Steuers?tzen(E?R)', 'A', 'C', '', '4589', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 93 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4600', 'Unentgeltliche Wertabgaben', 'A', 'I', 'AR_amount', '4600', 0, NULL, NULL, NULL, 1, FALSE);
|
|
| 94 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4605', 'Entnahme v. Gegenst.o.USt.', 'A', 'I', '', '4605', 0, NULL, 5, NULL, 2, FALSE);
|
|
| 95 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4610', 'Entnah.d.Untern.f.Zwecke ausserh.d.Untern.7%USt', 'A', 'I', 'AR_amount', '4610', 2, 86, 5, NULL, 3, TRUE);
|
|
| 96 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4619', 'Entnahme durch den Untern.f.Zwecke au?erhalb d.Untern.(Waren)o.USt', 'A', 'I', '', '4619', 0, NULL, 5, NULL, 3, FALSE);
|
|
| 97 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4620', 'Entnahme des Untern.f.Zwecke ausserh.d.Untern 16%(Waren)', 'A', 'I', 'AR_amount', '4620', 3, 51, 5, NULL, 3, TRUE);
|
|
| 98 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4630', 'Verwendung v.Gegenst.f.Zwecke au?erhalb d.Unternehmens 7% USt.', 'A', 'I', 'AR_amount', '4630', 2, 86, 5, NULL, 3, TRUE);
|
|
| 99 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4639', 'Verwendung v.Gegenst?nden f.Zwecke au?erhalb d.Untern.o.USt.', 'A', 'I', '', '4639', 0, NULL, NULL, NULL, 3, FALSE);
|
|
| 100 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4640', 'Verw.v.Gegens.f.Zwecke ausserh.d.Untern.16%USt.', 'A', 'I', '', '4640', 3, 51, 5, NULL, 3, TRUE);
|
|
| 101 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4645', 'Verwend.v.Gegenst.f.Zwecke au?erh.d.Untern.16%USt(Kfz-Nutzung)', 'A', 'I', '', '4645', 0, 0, 5, NULL, 3, TRUE);
|
|
| 102 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4646', 'Verwend.f.Gegenst.f.Zwecke au?erh.d.Untern.16%USt(Telefonnutzung)', 'A', 'I', '', '4646', 0, 0, 5, NULL, 3, TRUE);
|
|
| 103 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4660', 'Unentgeltl.Erbring.sons.Leis.16%USt', 'A', 'I', 'AR_amount', '4660', 3, 51, NULL, NULL, 3, TRUE);
|
|
| 104 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4670', 'Unentgeltl.Zuw.von Waren 7% Ust', 'A', 'I', '', '4670', 2, 86, 5, NULL, 3, TRUE);
|
|
| 105 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4679', 'Unentgeltl.Zuwendung v.Waren o.USt.', 'A', 'I', '', '4679', 0, NULL, 5, NULL, 3, FALSE);
|
|
| 106 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4680', 'Unentgeltl.Zuw.v Waren 16% Ust', 'A', 'I', '', '4680', 3, 51, 5, NULL, 3, TRUE);
|
|
| 107 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4686', 'Unentgeltl.Zuwend.v.Gegens. 16% Ust', 'A', 'I', 'AR_amount', '4686', 3, 51, NULL, NULL, 3, TRUE);
|
|
| 108 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4689', 'Unentgeltl.Zuw.v.Gegens.ohne Ust', 'A', 'I', '', '4689', 0, NULL, 5, NULL, 3, FALSE);
|
|
| 109 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4690', 'Nicht steuerbare Ums?tze', 'A', 'I', '', '4690', 0, NULL, 5, NULL, 1, FALSE);
|
|
| 110 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4695', 'Umsatzsteuerverg?tungen', 'A', 'I', '', '4695', 0, NULL, NULL, NULL, 7, FALSE);
|
|
| 111 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4700', 'Erl?sschm?lerungen', 'A', 'I', '', '4700', 0, NULL, 32, NULL, 1, FALSE);
|
|
| 112 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4710', 'Erl?sschm?lerung 7% USt.', 'A', 'I', '', '4710', 2, 86, 32, NULL, 1, TRUE);
|
|
| 113 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4720', 'Erl?sschm?lerung 16% USt.', 'A', 'I', '', '4720', 3, 51, 32, NULL, 1, TRUE);
|
|
| 114 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4725', 'Erl?sschm?.Inl.stpfl.EG-Lief. 7%USt', 'A', 'I', '', '4725', 12, 86, 32, NULL, 1, TRUE);
|
|
| 115 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4726', 'Erl?sschm?.Inl.stpfl.EG-Lief.16%USt', 'A', 'I', '', '4726', 13, 51, 32, NULL, 1, TRUE);
|
|
| 116 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4727', 'Erl?sschm?.and.EG Land stpfl.Liefer', 'A', 'I', '', '4727', 0, NULL, 32, NULL, 1, FALSE);
|
|
| 117 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4731', 'Gew?hrte Skonti 7% USt', 'A', 'E', 'AR_paid', '4731', 2, 86, 1, NULL, 1, TRUE);
|
|
| 118 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4735', 'Gew?hrte Skonti 16% USt.', 'A', 'E', 'AR_paid', '4735', 3, 51, 1, NULL, 1, FALSE);
|
|
| 119 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4750', 'Gew?hrte Boni 7% USt.', 'A', 'E', 'AR_paid', '4750', 2, 86, 1, NULL, 1, TRUE);
|
|
| 120 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4760', 'Gew?hrte Boni 16% USt.', 'A', 'E', 'AR_paid', '4760', 3, 51, 1, NULL, 1, TRUE);
|
|
| 121 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4780', 'Gew?hrte Rabatte 7% USt.', 'A', 'E', 'AR_paid', '4780', 2, 86, 1, NULL, 1, TRUE);
|
|
| 122 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4790', 'Gew?hrte Rabatte 16% Ust.', 'A', 'E', 'AR_paid', '4790', 3, 51, 1, NULL, 1, TRUE);
|
|
| 123 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4800', 'Bestandsver?nd.fert..Leist.', 'A', 'E', '', '4800', 0, 0, 2, NULL, NULL, FALSE);
|
|
| 124 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4810', 'Bestandsver?nderung unf.Erz.', 'A', 'E', '', '4810', 0, 0, 2, NULL, NULL, FALSE);
|
|
| 125 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4815', 'Bestandsver?nd.unf.Leist.', 'A', 'E', '', '4815', 0, 0, 2, NULL, NULL, FALSE);
|
|
| 126 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4820', 'And.aktiv.Eigenleistungen', 'A', 'E', '', '4820', 0, 0, 3, NULL, NULL, FALSE);
|
|
| 127 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4830', 'Sonstige Ertr?ge', 'A', 'I', '', '4830', 3, 51, 33, NULL, 2, FALSE);
|
|
| 128 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4840', 'Ertr?ge aus Kursdifferenzen', 'A', 'I', '', '4840', 0, NULL, 33, NULL, 2, FALSE);
|
|
| 129 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4835', 'Sonstige Erl?se betriebl.u.regelm??', 'A', 'I', 'AR_amount', '4835', 3, 51, 5, NULL, 2, FALSE);
|
|
| 130 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4837', 'Betriebsfremde Ertr?ge nichtau?erorden', 'A', 'I', '', '4837', 0, NULL, 33, NULL, NULL, FALSE);
|
|
| 131 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4844', 'Erl?se a.Verk.Sachanlagen steuerfrei?4Nr.1aUStG(b.Buchverlust)', 'A', 'E', '', '4844', 0, NULL, NULL, NULL, 1, TRUE);
|
|
| 132 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4845', 'Erl?se aus Verk.Sachanlageverm?gen16% USt (bei Buchverlust)', 'A', 'E', '', '4845', 0, NULL, NULL, NULL, 2, TRUE);
|
|
| 133 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4848', 'Erl?se a.Verk.Sachanlagen steuerfrei?4Nr.1bUStG(b.Buchverlust)', 'A', 'E', '', '4848', 0, NULL, NULL, NULL, 1, TRUE);
|
|
| 134 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4849', 'Erl?se aus Anlagenverk?ufen', 'A', 'I', 'AR_amount', '4849', 3, 51, NULL, NULL, 1, FALSE);
|
|
| 135 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4860', 'Grundst?cksertr?ge', 'A', 'I', '', '4860', 3, 51, 33, NULL, NULL, FALSE);
|
|
| 136 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4900', 'Ertr?ge aus Abgang von AV-Gegenst?nden', 'A', 'I', '', '4900', 0, NULL, 33, NULL, 2, FALSE);
|
|
| 137 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4905', 'Ertr.a.d.Abg.v.Gegenst.d.Umlaufverm', 'A', 'I', '', '4905', 0, NULL, 33, NULL, 2, FALSE);
|
|
| 138 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4910', 'Ertrag a.d.Zuschreib.d.Anlageverm?g', 'A', 'I', '', '4910', 0, NULL, 33, NULL, 2, FALSE);
|
|
| 139 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4915', 'Ertr.a.Zuschreib.d.Umlaufverm?gens', 'A', 'I', '', '4915', 0, NULL, 33, NULL, NULL, FALSE);
|
|
| 140 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4920', 'Ertr.a.Herabsetzung d.PWB zu Forderungen', 'A', 'I', '', '4920', 0, NULL, 33, NULL, 2, FALSE);
|
|
| 141 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4925', 'Ertr. aus abgeschriebenen Forderung', 'A', 'I', '', '4925', 0, NULL, 33, NULL, NULL, FALSE);
|
|
| 142 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4930', 'Ertr.a.d.Aufl?sung v.R?ckstellungen', 'A', 'I', '', '4930', 0, NULL, 33, NULL, NULL, FALSE);
|
|
| 143 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4934', 'Ertr?ge a.d.Aufl?sung v.SoPo m.R?cklageant.(Exitenzgr?ndungszusch.)', 'A', 'I', '', '4934', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 144 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4939', 'Ertr?ge Aufl. Sopo m.R.(Ansparafa)', 'A', 'I', '', '4939', 0, NULL, 5, NULL, NULL, FALSE);
|
|
| 145 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4941', 'Sachbez?ge 7% Ust (Waren)', 'A', 'I', 'AR_amount', '4941', 2, 86, 5, NULL, 2, TRUE);
|
|
| 146 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4945', 'Sachbez?ge 16% Ust (Waren)', 'A', 'I', 'AR_amount', '4945', 3, 51, 5, NULL, 2, TRUE);
|
|
| 147 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4946', 'Verrechnete sons. Sachbez?ge keine Waren', 'A', 'I', 'AR_amount', '4946', 0, 0, 5, NULL, 2, FALSE);
|
|
| 148 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4960', 'Periodenfremde Ertr?ge nicht au?ero', 'A', 'I', '', '4960', 0, NULL, 33, NULL, NULL, FALSE);
|
|
| 149 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4970', 'Versicherungsentsch?digungen', 'A', 'I', '', '4970', 0, NULL, 33, NULL, 2, FALSE);
|
|
| 150 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4981', 'Steuerfr.Ertr?ge a.d.Aufl?s.v.SoPo m.R?cklageanteil', 'A', 'I', '', '4981', 0, NULL, NULL, NULL, 2, FALSE);
|
|
| 151 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4982', 'Sonst.steuerfreie Betriebseinnahmen', 'A', 'I', '', '4982', 0, NULL, NULL, NULL, 2, FALSE);
|
|
| 152 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5190', 'Energiestoffe (Fert.).', 'A', 'E', 'IC', '5190', 9, 0, 4, NULL, 8, FALSE);
|
|
| 153 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5300', 'Wareneingang 7% Vorsteuer', 'A', 'E', 'AP_amount:IC_cogs', '5300', 8, NULL, 4, NULL, 8, TRUE);
|
|
| 154 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5400', 'Wareneingang 16% Vorsteuer', 'A', 'E', 'AP_amount:IC_cogs', '5400', 9, NULL, 4, NULL, 8, TRUE);
|
|
| 155 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5420', 'Innergemein.Erwerb 7% VorSt u. Ust', 'A', 'E', 'AP_amount:IC_cogs', '5420', 0, 93, 4, NULL, 8, TRUE);
|
|
| 156 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5425', 'Innergem.Erwerb 16% VorSt u. Ust', 'A', 'E', 'AP_amount:IC_cogs', '5425', 0, 97, 4, NULL, 8, TRUE);
|
|
| 157 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5440', 'Innergem.Erwerb v.Neufahrz.v.Lief.o.USt.Identnr.16%VSt.u.16%USt.', 'A', 'E', 'AP_amount:IC_cogs', '5440', 19, 94, NULL, NULL, 8, TRUE);
|
|
| 158 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5550', 'Steuerfreier innergem.Erwerb', 'A', 'E', 'AP_amount:IC_cogs', '5550', 0, 91, NULL, NULL, 8, FALSE);
|
|
| 159 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5559', 'Steuerfreie Einfuhren', 'A', 'E', 'AP_amount:IC_cogs', '5559', 0, 91, NULL, NULL, 8, FALSE);
|
|
| 160 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5580', 'Wareneinkauf z.allg.Umsatzsteuersatz (E?R)', 'A', 'E', '', '5580', 0, 0, 4, NULL, 8, FALSE);
|
|
| 161 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5581', 'Wareneinkauf z.erm.Umsatzsteuersatz(E?R)', 'A', 'E', '', '5581', 0, 0, 4, NULL, 8, FALSE);
|
|
| 162 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5582', 'Wareneinkauf ohne Vorsteuerabzug(E?R)', 'A', 'E', '', '5582', 0, 0, 4, NULL, 8, FALSE);
|
|
| 163 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5589', 'Gegenkto.3580-3582 b.Aufteilung d.WE n.Steuers?tzen(E?R)', 'A', 'E', '', '5589', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 164 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5600', 'Nicht abziehbare Vorsteuer', 'A', 'E', '', '5600', 0, NULL, 5, NULL, 8, FALSE);
|
|
| 165 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5610', 'Nicht abziehb.Vorsteuer 7%', 'A', 'E', '', '5610', 0, NULL, 5, NULL, 8, FALSE);
|
|
| 166 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5650', 'Nicht abziehb.Vorsteuer 16%', 'A', 'E', '', '5650', 0, NULL, 5, NULL, 8, FALSE);
|
|
| 167 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5731', 'Erhaltene Skonti 7% Vorsteuer', 'A', 'I', 'AP_paid', '5731', 8, NULL, 4, NULL, NULL, TRUE);
|
|
| 168 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5735', 'Erhaltene Skonti 16% Vorsteuer', 'A', 'I', 'AP_paid', '5735', 9, NULL, 4, NULL, NULL, TRUE);
|
|
| 169 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5750', 'Erhaltene Boni 7% Vorsteuer', 'A', 'I', 'AP_paid', '5750', 8, NULL, 4, NULL, NULL, TRUE);
|
|
| 170 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5760', 'Erhaltene Boni 16% Vorsteuer', 'A', 'I', 'AP_paid', '5760', 9, NULL, 4, NULL, NULL, TRUE);
|
|
| 171 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5780', 'Erhaltene Rabatte 7% Vorsteuer', 'A', 'I', 'AP_paid', '5780', 8, NULL, 4, NULL, NULL, TRUE);
|
|
| 172 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5790', 'Erhaltene Rabatte 16% Vorsteuer', 'A', 'I', 'AP_paid', '5790', 9, NULL, 4, NULL, NULL, TRUE);
|
|
| 173 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5800', 'Bezugsnebenkosten', 'A', 'E', 'AP_amount:IC_cogs:IC_expense', '5800', 0, NULL, 4, NULL, 8, FALSE);
|
|
| 174 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5820', 'Leergut', 'A', 'E', 'AP_amount:IC_cogs', '5820', 0, NULL, 4, NULL, NULL, FALSE);
|
|
| 175 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5840', 'Z?lle und Einfuhrabgaben', 'A', 'E', 'AP_amount:IC_cogs', '5840', 0, NULL, 4, NULL, NULL, FALSE);
|
|
| 176 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5860', 'Verrechnete Stoffkosten', 'A', 'E', 'IC_cogs', '5860', 0, NULL, 4, NULL, NULL, FALSE);
|
|
| 177 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5880', 'Bestandsver.Roh-,Hilfs-.Betriebs.sow.bez.Waren', 'A', 'E', '', '5880', 0, NULL, 2, NULL, NULL, FALSE);
|
|
| 178 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5900', 'Fremdleistungen', 'A', 'E', 'AP_amount', '5900', 9, NULL, 5, NULL, 8, FALSE);
|
|
| 179 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5915', 'Leist.v.ausl?nd.Untern. 7% VSt.u.7%USt.', 'A', 'E', 'AP_amount', '5915', 8, NULL, 5, NULL, 8, TRUE);
|
|
| 180 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5925', 'Leist.v.ausl?nd.Untern. 16% VSt.u.16%USt.', 'A', 'E', 'AP_amount', '5925', 9, NULL, 5, NULL, 8, TRUE);
|
|
| 181 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6010', 'L?hne', 'A', 'E', '', '6010', 0, NULL, 10, NULL, 9, FALSE);
|
|
| 182 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6020', 'Geh?lter', 'A', 'E', '', '6020', 0, NULL, 10, NULL, NULL, FALSE);
|
|
| 183 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6026', 'Tantiemen', 'A', 'E', '', '6026', 0, NULL, 10, NULL, 9, FALSE);
|
|
| 184 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6027', 'Gesch?ftsf?hrergeh?lter', 'A', 'E', '', '6027', 0, NULL, 10, NULL, 9, FALSE);
|
|
| 185 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6030', 'Aushilfsl?hne', 'A', 'E', '', '6030', 0, NULL, 10, NULL, 9, FALSE);
|
|
| 186 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6040', 'Lohnsteuer f?r Aushilfe', 'A', 'E', '', '6040', 0, NULL, 10, NULL, 10, FALSE);
|
|
| 187 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6045', 'Bedienungsgelder', 'A', 'E', '', '6045', 0, NULL, 10, NULL, 9, FALSE);
|
|
| 188 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6050', 'Ehegattengehalt', 'A', 'E', '', '6050', 0, NULL, 10, NULL, NULL, FALSE);
|
|
| 189 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6060', 'Freiwillige sozi.Aufw.lohnsteuerpflichtig.', 'A', 'E', '', '6060', 0, NULL, 10, NULL, 10, FALSE);
|
|
| 190 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6069', 'Pauschale Lohnsteuera.sons.Bez?ge (z.B.Fahrtkostenzu)', 'A', 'E', '', '6069', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 191 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6070', 'Krankengeldzusch?sse', 'A', 'E', '', '6070', 0, NULL, 10, NULL, NULL, FALSE);
|
|
| 192 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6080', 'Verm?genswirksame Leistungen', 'A', 'E', '', '6080', 0, NULL, 10, NULL, 9, FALSE);
|
|
| 193 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6090', 'Fahrtkostenerst.Wohnung/Arbeitsst?t', 'A', 'E', '', '6090', 0, NULL, 10, NULL, NULL, FALSE);
|
|
| 194 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6110', 'Gesetzlich soziale Aufwendungen', 'A', 'E', '', '6110', 0, 0, 10, NULL, 10, FALSE);
|
|
| 195 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6120', 'Beitr?ge zur Berufsgenossenschaft', 'A', 'E', '', '6120', 0, NULL, 10, NULL, 10, FALSE);
|
|
| 196 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6130', 'Freiwillig soziale Aufwendungen lohnsteuerfrei', 'A', 'E', '', '6130', 0, NULL, 10, NULL, 10, FALSE);
|
|
| 197 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6147', 'Pauschale Lohnsteuer auf sonst.Bez?ge(z.B.Direktversicherung', 'A', 'E', '', '6147', 0, NULL, 10, NULL, 9, FALSE);
|
|
| 198 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6200', 'Abschreibungen a.immat.Verm?gensgeg', 'A', 'E', '', '6200', 0, NULL, NULL, NULL, 25, FALSE);
|
|
| 199 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6205', 'Abschreibung a.d.Gesch?ft-o.Firmenw', 'A', 'E', '', '6205', 0, NULL, NULL, NULL, 25, FALSE);
|
|
| 200 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6210', 'Au?erplan.AfA a.immat.Verm?gensgeg.', 'A', 'E', '', '6210', 0, NULL, 17, NULL, 25, FALSE);
|
|
| 201 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6221', 'Abschreibung auf Geb?ude', 'A', 'E', '', '6221', 0, NULL, 17, NULL, 25, FALSE);
|
|
| 202 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6220', 'Abschreibungen auf Sachanlagen (o.Kfz u.Geb.)', 'A', 'E', '', '6220', 0, NULL, 17, NULL, 25, FALSE);
|
|
| 203 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6222', 'Abschreibungen auf Kfz', 'A', 'E', '', '6222', 0, NULL, 17, NULL, 25, FALSE);
|
|
| 204 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6230', 'Au?erplanm??ig Abschr.a.Sachanlagen', 'A', 'E', '', '6230', 0, NULL, NULL, NULL, 25, FALSE);
|
|
| 205 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6231', 'Absetzung f.au?ergew.techn.u.wirtschaftl.AfA bei Geb?uden', 'A', 'E', '', '6231', 0, NULL, 17, NULL, 25, FALSE);
|
|
| 206 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6232', 'Absetzung f.au?ergew.techn.u.wirtschaftl.AfA des Kfz', 'A', 'E', '', '6232', 0, NULL, 17, NULL, 25, FALSE);
|
|
| 207 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6233', 'Absetzung f.au?ergew.techn.u.wirtschaftl.AfA sonst.WG', 'A', 'E', '', '6233', 0, NULL, 17, NULL, 25, FALSE);
|
|
| 208 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6240', 'Abschr.a.Sachanl.aufgr.steuerl.Sondervorschriften', 'A', 'E', '', '6240', 0, NULL, 17, NULL, 25, FALSE);
|
|
| 209 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6241', 'Sonderabschreibung nach ?7g(1)u.(2)EStG (ohne Kfz)', 'A', 'E', '', '6241', 0, NULL, 17, NULL, 25, FALSE);
|
|
| 210 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6242', 'Sonderabschreibung n.?7g(1)u.(2)EStG (f?r Kfz)', 'A', 'E', '', '6242', 0, NULL, 17, NULL, 25, FALSE);
|
|
| 211 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6250', 'Kaufleasing', 'A', 'E', 'AP_amount', '6250', 0, NULL, 20, NULL, 24, FALSE);
|
|
| 212 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6260', 'Sofortabschreibung GWG', 'A', 'E', 'AP_amount', '6260', 0, NULL, NULL, NULL, 26, FALSE);
|
|
| 213 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6262', 'Abschreibungen auf aktivierte GWG', 'A', 'E', '', '6262', 0, NULL, NULL, NULL, 25, FALSE);
|
|
| 214 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6270', 'Abschreibungen auf Finanzanlagen', 'A', 'E', '', '6270', NULL, NULL, NULL, NULL, NULL, FALSE);
|
|
| 215 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6275', 'Abschr.a.Wertp.d.Umlaufverm?gens', 'A', 'E', '', '6275', 0, NULL, 17, NULL, NULL, FALSE);
|
|
| 216 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6280', 'Forderungsverlust-?bliche H?he', 'A', 'E', '', '6280', 0, NULL, 20, NULL, NULL, FALSE);
|
|
| 217 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6281', 'Forderungsverluste 7% USt.(?bliche H?he', 'A', 'E', '', '6281', 2, 86, 20, NULL, NULL, TRUE);
|
|
| 218 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6285', 'Forderungsverluste 16% USt.(?bliche H?he', 'A', 'E', '', '6285', 3, 51, 20, NULL, NULL, TRUE);
|
|
| 219 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6300', 'Sonstige betriebliche Aufwendungen', 'A', 'E', 'AP_amount', '6300', 9, NULL, 20, NULL, 24, FALSE);
|
|
| 220 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6303', 'Fremdleistungen', 'A', 'E', 'AP_amount', '6303', 0, NULL, 20, NULL, 24, FALSE);
|
|
| 221 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6304', 'Sons.Aufw.betriebl. und regelm??ig', 'A', 'E', 'AP_amount', '6304', 9, NULL, NULL, NULL, 24, FALSE);
|
|
| 222 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6305', 'Raumkosten', 'A', 'E', 'AP_amount', '6305', 9, NULL, 11, NULL, NULL, FALSE);
|
|
| 223 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6310', 'Miete', 'A', 'E', 'AP_amount', '6310', 9, NULL, 11, NULL, 11, FALSE);
|
|
| 224 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6315', 'Pacht', 'A', 'E', 'AP_amount', '6315', 0, NULL, NULL, NULL, 11, FALSE);
|
|
| 225 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6320', 'Heizung', 'A', 'E', 'AP_amount', '6320', 9, NULL, 11, NULL, NULL, FALSE);
|
|
| 226 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6325', 'Gas,Strom, Wasser', 'A', 'E', 'AP_amount', '6325', 9, NULL, 11, NULL, 12, FALSE);
|
|
| 227 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6330', 'Reinigung', 'A', 'E', 'AP_amount', '6330', 9, NULL, NULL, 11, 24, FALSE);
|
|
| 228 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6335', 'Instandhaltung betrieb.R?ume', 'A', 'E', 'AP_amount', '6335', 9, NULL, 11, NULL, 13, FALSE);
|
|
| 229 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6338', 'Instandhlt.betriebl.R?ume in Geb.die nicht z.BV geh?ren', 'A', 'E', '', '6338', 0, NULL, NULL, NULL, 11, FALSE);
|
|
| 230 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6343', 'Abgaben f.betriebl.genutzten Grundbesitz,d.nicht z.BV geh?rt', 'A', 'E', '', '6343', 0, NULL, NULL, NULL, 11, FALSE);
|
|
| 231 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6345', 'Sonstige Raumkosten', 'A', 'E', 'AP_amount', '6345', 9, NULL, 11, NULL, 13, FALSE);
|
|
| 232 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6348', 'Aufwend.f.ein h?usliches Arbeitszimmer(abziehb.Anteil)', 'A', 'E', '', '6348', 0, NULL, NULL, NULL, 24, FALSE);
|
|
| 233 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6349', 'Aufwend.f.ein h?usliches Arbeitszimmer(nicht abziehb.Anteil)', 'A', 'E', '', '6349', 0, 0, 11, NULL, 24, FALSE);
|
|
| 234 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6350', 'Grundst?cksaufwendungen', 'A', 'E', '', '6350', 9, NULL, 31, NULL, NULL, FALSE);
|
|
| 235 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6358', 'Gr?ndst?cksaufwend.f.Geb?ude,die nicht z.Betriebsverm.geh?ren', 'A', 'E', '', '6358', 0, NULL, NULL, NULL, 24, FALSE);
|
|
| 236 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6390', 'Zuwend.,Spenden,steuerlich n.abziehbar', 'A', 'E', '', '6390', 0, NULL, 31, NULL, NULL, FALSE);
|
|
| 237 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6405', 'Versicherungen f.Geb?ude,die zum BV geh?ren', 'A', 'E', '', '6405', 0, NULL, NULL, NULL, 24, FALSE);
|
|
| 238 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6420', 'Beitr?ge', 'A', 'E', 'AP_amount', '6420', 0, NULL, NULL, NULL, 14, FALSE);
|
|
| 239 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6400', 'Versicherungen', 'A', 'E', 'AP_amount', '6400', 0, NULL, 13, NULL, 14, FALSE);
|
|
| 240 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6430', 'Sonstige Abgaben', 'A', 'E', 'AP_amount', '6430', 0, NULL, NULL, NULL, 14, FALSE);
|
|
| 241 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6436', 'Steuerl.abzugs.Versp?tungszuschl.u.Zwangsgelder', 'A', 'E', '', '6436', 0, NULL, NULL, NULL, 31, FALSE);
|
|
| 242 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6437', 'Steuerl.n.abzugsf.Versp?tungszuschl?ge u.Zwangsgelder', 'A', 'E', '', '6437', 0, NULL, NULL, NULL, 31, FALSE);
|
|
| 243 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6440', 'Ausgleichsabgabe i.S.d.Schwerbehinterdengesetzes', 'A', 'E', '', '6440', 0, NULL, 10, NULL, 10, FALSE);
|
|
| 244 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6460', 'Rep.u.Instandhaltungen v.techn.Anlagen u.Maschinen', 'A', 'E', 'AP_amount', '6460', 9, NULL, 18, NULL, 19, FALSE);
|
|
| 245 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6470', 'Rep.u.Instandhalt.v.and.Anlagen u.Betriebs-u.Gesch?ftsausst.', 'A', 'E', 'AP_amount', '6470', 9, NULL, 18, NULL, 19, FALSE);
|
|
| 246 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6495', 'Wartungskosten f?r Hard-u.Software', 'A', 'E', 'AP_amount:IC_expense', '6495', 9, NULL, 18, NULL, 19, FALSE);
|
|
| 247 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6490', 'Sonstige Reparaturen u.Instandhalt.', 'A', 'E', 'AP_amount', '6490', 9, NULL, NULL, NULL, 19, FALSE);
|
|
| 248 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6498', 'Mietleasing', 'A', 'E', 'AP_amount', '6498', 0, NULL, 20, NULL, 24, FALSE);
|
|
| 249 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6499', 'Gewerbest.zu ber?cksicht.Mietleasing ?8 GewStG', 'A', 'E', '', '6499', 0, NULL, NULL, NULL, 24, FALSE);
|
|
| 250 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6500', 'Fahrzeugkosten', 'A', 'E', 'AP_amount', '6500', 0, NULL, NULL, NULL, 17, FALSE);
|
|
| 251 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6520', 'Kfz-Versicherungen', 'A', 'E', 'AP_amount', '6520', 0, NULL, 14, NULL, 16, FALSE);
|
|
| 252 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6530', 'Laufende Kfz-Betriebskosten', 'A', 'E', 'AP_amount', '6530', 9, NULL, 14, NULL, 17, FALSE);
|
|
| 253 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6540', 'Kfz-Reparaturen', 'A', 'E', 'AP_amount', '6540', 9, NULL, 14, NULL, 17, FALSE);
|
|
| 254 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6550', 'Garagenmiete', 'A', 'E', 'AP_amount', '6550', 0, NULL, 14, NULL, 17, FALSE);
|
|
| 255 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6560', 'Leasingfahrzeugkosten', 'A', 'E', 'AP_amount', '6560', 0, NULL, 14, NULL, 17, FALSE);
|
|
| 256 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6570', 'Sonstige Kfz-Kosten', 'A', 'E', 'AP_amount', '6570', 9, NULL, 14, NULL, 17, FALSE);
|
|
| 257 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6580', 'Mautgeb?hren', 'A', 'E', '', '6580', 0, 0, 14, NULL, 17, FALSE);
|
|
| 258 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6590', 'Fahrzeugkosten f.Kfz,die nicht zum BV geh?ren', 'A', 'E', '', '6590', 0, NULL, NULL, NULL, 17, FALSE);
|
|
| 259 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6595', 'Fremdfahrzeuge', 'A', 'E', 'AP_amount', '6595', 0, NULL, 14, NULL, 17, FALSE);
|
|
| 260 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6600', 'Werbekosten', 'A', 'E', 'AP_amount', '6600', 9, NULL, NULL, 15, 18, FALSE);
|
|
| 261 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6610', 'Geschenke bis 35 EUR abzugsf?hig', 'A', 'E', 'AP_amount', '6610', 0, NULL, 15, NULL, 18, FALSE);
|
|
| 262 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6620', 'Geschenke ?ber 35EUR nicht abzugsf.', 'A', 'E', 'AP_amount', '6620', 0, NULL, 15, NULL, 18, FALSE);
|
|
| 263 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6625', 'Geschenke ausschlie?l.betrieb.genut', 'A', 'E', 'AP_amount', '6625', 9, NULL, NULL, NULL, 18, FALSE);
|
|
| 264 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6630', 'Repr?sentationskosten', 'A', 'E', 'AP_amount', '6630', 9, NULL, 15, NULL, 18, FALSE);
|
|
| 265 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6640', 'Bewirtungskosten', 'A', 'E', 'AP_amount', '6640', 9, NULL, 20, NULL, 18, FALSE);
|
|
| 266 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6643', 'Aufmerksamkeiten', 'A', 'E', 'AP_amount', '6643', 9, NULL, NULL, NULL, 18, FALSE);
|
|
| 267 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6644', 'Nicht abzugsf?hige Bewirtungskosten', 'A', 'E', 'AP_amount', '6644', 0, NULL, NULL, NULL, 18, FALSE);
|
|
| 268 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6645', 'Nicht abzugsf.Betriebsausg.a.Werbe-Repr?sentatisonk.etc.', 'A', 'E', 'AP_amount', '6645', 9, NULL, 15, NULL, 24, FALSE);
|
|
| 269 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6650', 'Reisekosten Arbeitnehmer', 'A', 'E', 'AP_amount', '6650', 9, NULL, 15, NULL, 18, FALSE);
|
|
| 270 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6663', 'Reisekosten Arbeitn.m.Vorsteuerabzu f.?ffentl.Verkehrsm.', 'A', 'E', 'AP_amount', '6663', 8, NULL, 15, NULL, 18, FALSE);
|
|
| 271 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6664', 'Reisekosten Arbeitn.Verpflegungmehr', 'A', 'E', 'AP_amount', '6664', 0, NULL, 15, NULL, 18, FALSE);
|
|
| 272 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6660', 'Reisekosten Arbeitn.?bernachtungsaufwand', 'A', 'E', 'AP_amount', '6660', 0, NULL, 15, NULL, 18, FALSE);
|
|
| 273 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6668', 'Kilometerentgelderstattung Arbeitnehmer', 'A', 'E', 'AP_amount', '6668', 0, NULL, 15, NULL, 18, FALSE);
|
|
| 274 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6670', 'Reisekosten Unternehmer', 'A', 'E', 'AP_amount', '6670', 9, NULL, 15, NULL, 18, FALSE);
|
|
| 275 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6673', 'Reisek.Untern.m.Vorsteuerabzug (?ffentl.Verkehrsm.', 'A', 'E', 'AP_amount', '6673', 8, NULL, 15, NULL, 18, FALSE);
|
|
| 276 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6674', 'Reisekosten Untern.Verpflegungsmehr', 'A', 'E', 'AP_amount', '6674', 0, NULL, 15, NULL, 18, FALSE);
|
|
| 277 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6680', 'Reisekosten Untern.?bernachtungsauf', 'A', 'E', 'AP_amount', '6680', 0, NULL, 15, NULL, 18, FALSE);
|
|
| 278 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6688', 'Fahrten zw.Wohn.und Arbeitsst?tte (nicht abziehb.Teil)', 'A', 'E', '', '6688', 0, NULL, NULL, NULL, 18, FALSE);
|
|
| 279 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6689', 'Fahrten zw.Wohn.-und Arbeitsst?tte (Haben)', 'A', 'E', '', '6689', 0, NULL, NULL, NULL, 18, FALSE);
|
|
| 280 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6700', 'Kosten der Warenabgabe', 'A', 'E', 'AP_amount:IC_cogs', '6700', 0, NULL, NULL, NULL, 24, FALSE);
|
|
| 281 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6710', 'Verpackungsmaterial', 'A', 'E', 'AP_amount:IC_cogs', '6710', 0, NULL, NULL, NULL, 24, FALSE);
|
|
| 282 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6740', 'Ausgangsfracht', 'A', 'E', 'AP_amount:IC_cogs', '6740', 0, NULL, NULL, NULL, 24, FALSE);
|
|
| 283 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6760', 'Transportversicherung', 'A', 'E', 'AP_amount:IC_cogs:IC_expense', '6760', 0, NULL, NULL, NULL, 24, FALSE);
|
|
| 284 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6770', 'Verkaufsprovision', 'A', 'E', 'AP_amount:IC_expense', '6770', 0, NULL, NULL, NULL, 24, FALSE);
|
|
| 285 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6780', 'Fremdarbeiten', 'A', 'E', 'AP_amount:IC_expense', '6780', 0, NULL, NULL, NULL, 24, FALSE);
|
|
| 286 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6790', 'Aufwand f?r Gew?hrleistungen', 'A', 'E', 'AP_amount:IC_expense', '6790', 0, NULL, 20, NULL, 24, FALSE);
|
|
| 287 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6800', 'Porto', 'A', 'E', 'AP_amount', '6800', 0, NULL, 20, NULL, 23, FALSE);
|
|
| 288 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6805', 'Telefon', 'A', 'E', 'AP_amount', '6805', 9, NULL, 20, NULL, 23, FALSE);
|
|
| 289 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6810', 'Telefax', 'A', 'E', 'AP_amount', '6810', 9, NULL, 20, NULL, 23, FALSE);
|
|
| 290 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6815', 'B?robedarf', 'A', 'E', 'AP_amount', '6815', 9, NULL, 20, NULL, 23, FALSE);
|
|
| 291 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6820', 'Zeitschriften, B?cher', 'A', 'E', 'AP_amount', '6820', 8, NULL, 20, NULL, 20, FALSE);
|
|
| 292 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6821', 'Fortbildungskosten', 'A', 'E', 'AP_amount', '6821', 9, NULL, NULL, NULL, 24, FALSE);
|
|
| 293 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6822', 'Freiwillige Sozialleistungen', 'A', 'E', 'AP_amount', '6822', 0, NULL, NULL, NULL, 9, FALSE);
|
|
| 294 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6825', 'Rechts- und Beratungskosten', 'A', 'E', 'AP_amount', '6825', 9, NULL, 20, NULL, 22, FALSE);
|
|
| 295 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6827', 'Abschlu?- und Pr?fungskosten', 'A', 'E', 'AP_amount', '6827', 9, NULL, 20, NULL, 22, FALSE);
|
|
| 296 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6830', 'Buchf?hrungskosten', 'A', 'E', 'AP_amount', '6830', 9, NULL, NULL, NULL, 24, FALSE);
|
|
| 297 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6835', 'Mieten f?r Einrichtungen', 'A', 'E', 'AP_amount', '6835', 9, NULL, 20, NULL, 21, FALSE);
|
|
| 298 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6840', 'Mietleasing', 'A', 'E', 'AP_amount', '6840', 9, NULL, 20, NULL, 21, FALSE);
|
|
| 299 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6845', 'Werkzeuge und Kleinger?te', 'A', 'E', 'AP_amount', '6845', 9, NULL, NULL, NULL, 19, FALSE);
|
|
| 300 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6850', 'Betriebsbedarf', 'A', 'E', 'AP_amount', '6850', 9, NULL, 20, NULL, 24, FALSE);
|
|
| 301 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6855', 'Nebenkosten des Geldverkehrs', 'A', 'E', '', '6855', 0, NULL, 20, NULL, 24, FALSE);
|
|
| 302 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6859', 'Aufwend.f.Abraum-u.Abfallbeseitigung', 'A', 'E', 'AP_amount', '6859', 9, NULL, 20, NULL, 24, FALSE);
|
|
| 303 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6865', 'Nicht abziehbare Vorsteuer 7%', 'A', 'E', 'AP_paid', '6865', 0, NULL, 20, NULL, NULL, FALSE);
|
|
| 304 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6870', 'Nicht abziehbare Vorsteuer 16%', 'A', 'E', 'AP_paid', '6870', 0, NULL, 20, NULL, NULL, FALSE);
|
|
| 305 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6860', 'Nicht abziehbare Vorsteuer', 'A', 'E', '', '6860', 0, NULL, 31, NULL, 24, FALSE);
|
|
| 306 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6880', 'Aufwendungen aus Kursdifferenzen', 'A', 'E', '', '6880', 0, NULL, 31, NULL, 24, FALSE);
|
|
| 307 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6895', 'Abg?nge Sachanlagen Restbuchwert', 'A', 'E', '', '6895', 0, NULL, 31, NULL, 2, FALSE);
|
|
| 308 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6900', 'Verluste aus Anlagenabgang', 'A', 'E', '', '6900', 0, NULL, 31, NULL, NULL, FALSE);
|
|
| 309 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6926', 'Einstellungen in SoPo m.R?cklageanteil (Ansparabschreibung)', 'A', 'E', '', '6926', 0, NULL, 20, NULL, NULL, FALSE);
|
|
| 310 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6928', 'Einst.in SoPo m.R?cklageanteil (Existenzgr?ndungsr?cklage)', 'A', 'E', '', '6928', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 311 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6960', 'Periodenfremde Aufwend.(soweit n.au?erordentlich', 'A', 'E', '', '6960', 0, NULL, 31, NULL, NULL, FALSE);
|
|
| 312 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6967', 'Betriebsfremde Aufwendungen soweit n.au?erord.', 'A', 'E', '', '6967', 0, NULL, 31, NULL, 24, FALSE);
|
|
| 313 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6970', 'Kalkulatorischer Unternehmerlohn', 'A', 'E', '', '6970', 0, NULL, 34, NULL, NULL, FALSE);
|
|
| 314 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6974', 'Kalkulatorische Zinsen', 'A', 'E', '', '6974', 0, NULL, 34, NULL, NULL, FALSE);
|
|
| 315 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6976', 'Kalkulatorische Aschreibungen', 'A', 'E', '', '6976', 0, NULL, 34, NULL, NULL, FALSE);
|
|
| 316 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6978', 'Kalkulatorische Wagnisse', 'A', 'E', '', '6978', 0, NULL, 34, NULL, NULL, FALSE);
|
|
| 317 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6979', 'Kalkulatorischer Lohn f.unentgeltl.Mitarbeiter', 'A', 'E', '', '6979', 0, NULL, 34, NULL, NULL, FALSE);
|
|
| 318 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7000', 'Ertr?ge aus Beteiligungen', 'A', 'I', '', '7000', 0, NULL, 33, NULL, NULL, FALSE);
|
|
| 319 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7100', 'Sonstige Zinsen und ?nliche Ertr?ge', 'A', 'I', '', '7100', 0, NULL, 32, NULL, 4, FALSE);
|
|
| 320 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7120', 'Zins?hnliche Ertr?ge', 'A', 'I', '', '7120', 0, NULL, 32, NULL, 4, FALSE);
|
|
| 321 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7130', 'Diskontertr?ge', 'A', 'I', '', '7130', 0, NULL, 32, NULL, 4, FALSE);
|
|
| 322 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7300', 'Zinsen und ?hnl.Aufwendungen', 'A', 'E', '', '7300', 0, NULL, 30, NULL, 29, FALSE);
|
|
| 323 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7305', 'Zinsaufwendung-betriebliche Steuern ?223aAO', 'A', 'E', '', '7305', 0, NULL, 30, NULL, 29, FALSE);
|
|
| 324 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7310', 'Zinsaufwendung f. kurzf.Verbindlichk', 'A', 'E', '', '7310', 0, NULL, 30, NULL, 29, FALSE);
|
|
| 325 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7320', 'Zinsaufwendung f. langf.Verbindlichk', 'A', 'E', '', '7320', 0, NULL, 30, NULL, 29, FALSE);
|
|
| 326 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7325', 'Zinsaufwend.f.Geb?ude,die z.Betriebsverm?gen geh?ren', 'A', 'E', '', '7325', 0, NULL, NULL, NULL, 29, FALSE);
|
|
| 327 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7326', 'Zinsen zur Finanzierung Anlageverm?gen', 'A', 'E', '', '7326', 0, NULL, NULL, NULL, 29, FALSE);
|
|
| 328 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7330', 'Zins?hnliche Aufwendungen', 'A', 'E', '', '7330', 0, NULL, 30, NULL, 29, FALSE);
|
|
| 329 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7340', 'Diskontaufwendung', 'A', 'E', '', '7340', 0, NULL, 30, NULL, NULL, FALSE);
|
|
| 330 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7400', 'Au?erordentliche Ertr?ge', 'A', 'I', '', '7400', 0, NULL, 33, NULL, 5, FALSE);
|
|
| 331 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7401', 'Ausserordentliche Ertr?ge finanzwirksam', 'A', 'I', '', '7401', 0, NULL, NULL, NULL, 5, FALSE);
|
|
| 332 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7450', 'Ausserordentliche Ertr?ge nicht finanzwirksam', 'A', 'I', '', '7450', 0, NULL, NULL, NULL, 5, FALSE);
|
|
| 333 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7500', 'Au?erordentliche Aufwendung', 'A', 'E', '', '7500', 0, NULL, 31, NULL, 30, FALSE);
|
|
| 334 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7600', 'K?rperschaftssteuer', 'A', 'E', '', '7600', 0, NULL, 35, NULL, NULL, FALSE);
|
|
| 335 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7608', 'Solidarit?tszuschlag', 'A', 'E', '', '7608', 0, NULL, 35, NULL, NULL, FALSE);
|
|
| 336 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7609', 'Solidarit?tszuschlag f?r Vorjahr', 'A', 'E', '', '7609', 0, NULL, 19, NULL, NULL, FALSE);
|
|
| 337 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7610', 'Gewerbesteuer', 'A', 'E', '', '7610', 0, NULL, 12, NULL, 31, FALSE);
|
|
| 338 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7632', 'Kapitalertragssteuer 20%', 'A', 'E', '', '7632', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 339 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7634', 'Anrechenb.Soli auf Kapitalertragssteuer 20%', 'A', 'E', '', '7634', 0, NULL, 35, NULL, NULL, FALSE);
|
|
| 340 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7635', 'Zinsabschlagsteuer', 'A', 'E', '', '7635', 0, NULL, 35, NULL, NULL, FALSE);
|
|
| 341 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7638', 'Anrechb.Solidari.zuschlag a.Zinsabschlagst.', 'A', 'E', '', '7638', 0, NULL, 35, NULL, NULL, FALSE);
|
|
| 342 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7640', 'Stnachzahl.Vorj.v.Einkomm u.Ertrag', 'A', 'E', '', '7640', 0, NULL, 31, NULL, NULL, FALSE);
|
|
| 343 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7642', 'Sterstat.Vorj.Steuer v.Eink.u.Ertrag', 'A', 'I', '', '7642', 0, NULL, 33, NULL, NULL, FALSE);
|
|
| 344 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7644', 'Ertr.a.d.Aufl.v.R?cks.f.St.v.Ein.Er', 'A', 'I', '', '7644', 0, NULL, 33, NULL, NULL, FALSE);
|
|
| 345 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7650', 'Sonstige Betriebssteuern', 'A', 'E', '', '7650', 0, NULL, 12, NULL, 31, FALSE);
|
|
| 346 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7675', 'Verbrauchssteuer', 'A', 'E', '', '7675', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 347 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7678', '?kosteuer', 'A', 'E', '', '7678', 0, NULL, 12, NULL, NULL, FALSE);
|
|
| 348 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7685', 'Kfz-Steuer', 'A', 'E', 'AP_amount', '7685', 0, NULL, 19, NULL, 15, FALSE);
|
|
| 349 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7680', 'Grundsteuer', 'A', 'E', '', '7680', 0, NULL, 19, NULL, NULL, FALSE);
|
|
| 350 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7684', 'Grundsteuer f.Geb?ude,die nicht z.Betriebsverm?gen geh.', 'A', 'E', '', '7684', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 351 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7690', 'Steuernachzahlung Vorj.f.sons.Steue', 'A', 'E', '', '7690', 0, NULL, 31, NULL, NULL, FALSE);
|
|
| 352 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7692', 'Steuererstattung Vorj.f.sons.Steuer', 'A', 'I', '', '7692', 0, NULL, 33, NULL, NULL, FALSE);
|
|
| 353 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7694', 'Ertr?ge a.d.Aufl.v. R?ck.f.sons.Ste', 'A', 'E', '', '7694', 0, NULL, 31, NULL, NULL, FALSE);
|
|
| 354 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7745', 'Entnahmen a.satzungsm??igen R?cklagen', 'A', 'E', '', '7745', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 355 |
|
|
| 356 |
|
|
| 357 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('9000', 'Saldenvortr?ge,Sachkonten', 'A', 'A', '', '9000', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 358 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('9008', 'Saldenvortr?ge,Debitoren', 'A', 'A', '', '9008', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 359 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('9009', 'Saldenvortr?ge,Kreditoren', 'A', 'L', '', '9009', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 360 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('9090', 'Summenvortragskonto', 'A', 'A', '', '9090', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 361 |
|
|
| 362 |
|
|
| 363 |
|
|
| 364 |
|
|
| 365 |
INSERT INTO tax (rate, taxkey, taxdescription) values ('0','0','Keine Steuer');
|
|
| 366 |
INSERT INTO tax (rate, taxkey, taxdescription) values ('0','1','Umsatzsteuerfrei');
|
|
| 367 |
insert into tax VALUES ((select id from chart where accno = '3801'),'0.07','3801','2','Umsatzsteuer 7%'); |
|
| 368 |
INSERT INTO tax VALUES ((select id from chart where accno = '3805'),'0.16','3805','3','Umsatzsteuer 16%'); |
|
| 369 |
INSERT INTO tax VALUES ((select id from chart where accno = '1401'),'0.07','1401','8','Vorsteuer 7%'); |
|
| 370 |
insert into tax VALUES ((select id from chart where accno = '1405'),'0.16','1405','9','Vorsteuer 16%'); |
|
| 371 |
insert into tax (taxkey, taxdescription) values ('10','Im anderen EG-Staat steuerpfl. Lieferung');
|
|
| 372 |
insert into tax (taxkey, taxdescription) values ('11','Steuerfreie EG-Lief. an Abn. mit UStIdNr');
|
|
| 373 |
insert into tax (chart_id,rate,taxnumber, taxkey, taxdescription) values ((select id from chart where accno = '3802'),'0.07','3802','12','Steuerpflicht. EG-Lieferungen 7%'); |
|
| 374 |
insert into tax (chart_id,rate,taxnumber, taxkey, taxdescription) values ((select id from chart where accno = '3802'),'0.16','3803','13','Steuerpflicht. EG-Lieferungen 16%'); |
|
| 375 |
insert into tax (chart_id,rate,taxnumber, taxkey, taxdescription) values ((select id from chart where accno = '1402'),'0.07','1402','18','Steuerpflicht. EG-Erwerb 7%'); |
|
| 376 |
insert into tax (chart_id,rate,taxnumber, taxkey, taxdescription) values ((select id from chart where accno = '1402'),'0.16','1403','19','Steuerpflicht. EG-Erwerb 16%'); |
|
| 377 |
|
|
| 378 |
-- Ergaenzungen fuer 19% UmSt. ab 1.01.2007 |
|
| 379 |
insert into taxkeys (chart_id, tax_id, taxkey_id, pos_ustva, startdate) select chart.id, tax.id, taxkey_id, pos_ustva, '1970-01-01' from chart LEFT JOIN tax on (tax.taxkey=chart.taxkey_id) WHERE taxkey_id is not null; |
|
| 380 |
insert into taxkeys (chart_id, tax_id, taxkey_id,startdate) SELECT 0, id, taxkey, '1970-01-01' FROM tax; |
|
| 381 |
INSERT INTO chart (accno, description, charttype, category, link, taxkey_id, pos_ustva, pos_eur) |
|
| 382 |
VALUES ('3806','Umsatzsteuer 19 %', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax', 0, 511,6);
|
|
| 383 |
INSERT INTO chart (accno, description, charttype, category, link, taxkey_id, pos_ustva, pos_eur) |
|
| 384 |
VALUES ('1406','Abziehbare Vorsteuer 19 %', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', 0, 66,27);
|
|
| 385 |
INSERT INTO tax (chart_id, rate, taxnumber, taxkey, taxdescription) VALUES ((SELECT id from CHART WHERE accno='3806'), 0.19, '3806', 3, 'Umsatzsteuer 19%'); |
|
| 386 |
INSERT INTO tax (chart_id, rate, taxnumber, taxkey, taxdescription) VALUES ((SELECT id from CHART WHERE accno='1406'), 0.19, '1406', 9, 'Vorsteuer 19%'); |
|
| 387 |
insert into taxkeys (chart_id, tax_id, taxkey_id, pos_ustva, startdate) select chart.id, (SELECT id from tax where taxdescription='Umsatzsteuer 19%'), 3, pos_ustva, '2007-01-01' from chart WHERE taxkey_id=3; |
|
| 388 |
insert into taxkeys (chart_id, tax_id, taxkey_id, pos_ustva, startdate) select chart.id, (SELECT id from tax where taxdescription='Vorsteuer 19%'), 9, pos_ustva, '2007-01-01' from chart WHERE taxkey_id=9; |
|
| 389 |
|
|
| 390 |
-- Buchungsgruppen |
|
| 391 |
|
|
| 392 |
INSERT INTO buchungsgruppen |
|
| 393 |
(description, inventory_accno_id, |
|
| 394 |
income_accno_id_0, expense_accno_id_0, |
|
| 395 |
income_accno_id_1, expense_accno_id_1, |
|
| 396 |
income_accno_id_2, expense_accno_id_2, |
|
| 397 |
income_accno_id_3, expense_accno_id_3) |
|
| 398 |
VALUES |
|
| 399 |
('Standard 16%',
|
|
| 400 |
-- 1140: Bestand Waren |
|
| 401 |
(SELECT id FROM chart WHERE accno = '1140'), |
|
| 402 |
-- 4400: Erl?se 16% USt. |
|
| 403 |
-- 5400: Wareneingang 16% Vorsteuer |
|
| 404 |
(SELECT id FROM chart WHERE accno = '4400'), |
|
| 405 |
(SELECT id FROM chart WHERE accno = '5400'), |
|
| 406 |
-- 4125: Steuerfrei innergem. Lieferungen ?41bUStG |
|
| 407 |
-- 5550: Steuerfreier innergem.Erwerb |
|
| 408 |
(SELECT id FROM chart WHERE accno = '4125'), |
|
| 409 |
(SELECT id FROM chart WHERE accno = '5550'), |
|
| 410 |
-- 4315: Erl?s Inland stpfl.EG-Lieferung 16% |
|
| 411 |
-- 5425: Innergem.Erwerb 16% VorSt u. Ust |
|
| 412 |
(SELECT id FROM chart WHERE accno = '4315'), |
|
| 413 |
(SELECT id FROM chart WHERE accno = '5425'), |
|
| 414 |
-- 4150: Sonstige steuerfreie Ums?tze ?42-7UStG |
|
| 415 |
-- 5559: Steuerfreie Einfuhren |
|
| 416 |
(SELECT id FROM chart WHERE accno = '4150'), |
|
| 417 |
(SELECT id FROM chart WHERE accno = '5559')); |
|
| 418 |
|
|
| 419 |
INSERT INTO buchungsgruppen |
|
| 420 |
(description, inventory_accno_id, |
|
| 421 |
income_accno_id_0, expense_accno_id_0, |
|
| 422 |
income_accno_id_1, expense_accno_id_1, |
|
| 423 |
income_accno_id_2, expense_accno_id_2, |
|
| 424 |
income_accno_id_3, expense_accno_id_3) |
|
| 425 |
VALUES |
|
| 426 |
('Standard 7%',
|
|
| 427 |
-- 1140: Bestand Waren |
|
| 428 |
(SELECT id FROM chart WHERE accno = '1140'), |
|
| 429 |
-- 4300: Erl?se 7%USt |
|
| 430 |
-- 5300: Wareneingang 7% Vorsteuer |
|
| 431 |
(SELECT id FROM chart WHERE accno = '4300'), |
|
| 432 |
(SELECT id FROM chart WHERE accno = '5300'), |
|
| 433 |
-- 4125: Steuerfrei innergem. Lieferungen ?41bUStG |
|
| 434 |
-- 5550: Steuerfreier innergem.Erwerb |
|
| 435 |
(SELECT id FROM chart WHERE accno = '4125'), |
|
| 436 |
(SELECT id FROM chart WHERE accno = '5550'), |
|
| 437 |
-- 4310: Erl?se Inland stpfl. EG-Lieferung7% |
|
| 438 |
-- 5420: Innergemein.Erwerb 7% VorSt u. Ust |
|
| 439 |
(SELECT id FROM chart WHERE accno = '4310'), |
|
| 440 |
(SELECT id FROM chart WHERE accno = '5420'), |
|
| 441 |
-- 4150: Sonstige steuerfreie Ums?tze ?42-7UStG |
|
| 442 |
-- 5559; Steuerfreie Einfuhren |
|
| 443 |
(SELECT id FROM chart WHERE accno = '4150'), |
|
| 444 |
(SELECT id FROM chart WHERE accno = '5559')); |
|
| 1 |
-- DATEV SKR04 |
|
| 2 |
-- IT Systems Service http://www.itsystemsservice.de |
|
| 3 |
-- |
|
| 4 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0135', 'EDV-Software', 'A', 'A', 'AP_amount', '0135', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 5 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0150', 'Gesch?fts- oder Firmenwert', 'A', 'A', 'AP_amount', '0135', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 6 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0240', 'Gesch?ftsbauten', 'A', 'A', 'AP_amount', '0240', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 7 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0400', 'Techn. Anlagen und Maschinen', 'A', 'A', 'AP_amount', '0400', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 8 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0440', 'Maschinen', 'A', 'A', 'AP_amount', '0440', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 9 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0500', 'Betriebs- und Gesch?ftsausstattung', 'A', 'A', 'AP_amount', '0500', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 10 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0510', 'Andere Anlagen', 'A', 'A', 'AP_amount', '0510', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 11 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0520', 'PKW', 'A', 'A', 'AP_amount', '0440', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 12 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0560', 'Sonst. Transportmittel', 'A', 'A', 'AP_amount', '0560', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 13 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0650', 'B?roeinrichtung', 'A', 'A', 'AP_amount', '0650', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 14 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0640', 'Ladeneinrichtung', 'A', 'A', 'AP_amount', '0640', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 15 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0620', 'Werkzeuge', 'A', 'A', 'AP_amount', '0620', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 16 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0670', 'Geringwertige Wirtschaftsg.b.410EUR', 'A', 'A', 'AP_amount', '0670', 9, NULL, NULL, NULL, NULL, FALSE);
|
|
| 17 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1000', 'Roh,-Hilfs,-und Betriebsstoffe', 'A', 'E', 'IC', '1000', 9, NULL, 4, NULL, NULL, FALSE);
|
|
| 18 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1140', 'Waren', 'A', 'E', 'IC', '1140', 9, NULL, 4, NULL, NULL, FALSE);
|
|
| 19 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1200', 'Ford. aus Lieferungen und Leistungen', 'A', 'A', 'AR', '1200', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 20 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1215', 'Ford.a.LuL z.allg.USt-Satz', 'A', 'A', 'AR', '1215', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 21 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1216', 'Ford.a.LuL z.erm.USt.-Satz (E?R)', 'A', 'A', 'AR', '1216', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 22 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1217', 'Ford.a.steuerfr.od.nicht steuerb.LuL (E?R)', 'A', 'A', 'AR', '1217', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 23 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1218', 'Ford.a.LuL gem.?24UStG(E?R)', 'A', 'A', 'AR', '1218', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 24 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1219', 'Gegenkto. bei Aufteil.d.Ford.n.Steuers.(E?R)', 'A', 'A', '', '1219', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 25 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1220', 'Ford.n.?11(1)2EStG f.?4/3 EStG', 'A', 'A', 'AR', '1220', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 26 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1248', 'Pauschalwertbe.z.Ford.bis1J.', 'A', 'E', '', '1248', 0, NULL, 31, NULL, NULL, FALSE);
|
|
| 27 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1249', 'Pauschalwertbe.z.Ford.ueb1J.', 'A', 'E', '', '1249', 0, NULL, 31, NULL, NULL, FALSE);
|
|
| 28 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1370', 'Durchlaufende Posten', 'A', 'A', '', '1370', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 29 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1374', 'Fremdgeld', 'A', 'A', '', '1374', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 30 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1401', 'Abziehbare Vorsteuer 7%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1401', 0, 66, NULL, NULL, 27, FALSE);
|
|
| 31 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1402', 'Abziehbare Vorsteuer aus EG-Erwerb 7%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', '1402', 0, 61, NULL, NULL, 27, FALSE);
|
|
| 32 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1403', 'Abziehbare Vorsteuer aus EG-Erwerb 16%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', '1403', 0, 61, NULL, NULL, 27, FALSE);
|
|
| 33 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1405', 'Abziehbare Vorsteuer 16%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1405', 0, 66, NULL, NULL, 27, FALSE);
|
|
| 34 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1407', 'Abziehb.Vorst.n.allgem.Durchschnittss?tzen UStVA Kz.63', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1407', 0, NULL, NULL, NULL, 27, FALSE);
|
|
| 35 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1408', 'Abziehbare Vorsteuer n.?13b', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1408', 0, NULL, NULL, NULL, 27, FALSE);
|
|
| 36 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1433', 'Bezahlte Einfuhrumsatzsteuer', 'A', 'E', '', '1433', 0, 62, NULL, NULL, NULL, FALSE);
|
|
| 37 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1460', 'Geldtransit', 'A', 'A', '', '1460', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 38 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1480', 'Gegenkonto Vorsteuer ?4/3 EStG', 'A', 'A', '', '1480', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 39 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1481', 'Aufl?sung Vorst.a.Vorjahr ?4/3 EStG', 'A', 'A', '', '1481', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 40 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1482', 'Vorst.aus Investitionen ?4/3 EStG', 'A', 'E', '', '1482', 0, NULL, NULL, NULL, 27, FALSE);
|
|
| 41 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1484', 'abziehb.VorSt EU-Erwerb Neufzg.b.Lief. o. USt.Ident.Nr', 'A', 'E', 'AR_tax', '1483', 0, NULL, NULL, NULL, 27, FALSE);
|
|
| 42 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1600', 'Kasse', 'A', 'A', 'AR_paid:AP_paid', '1600', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 43 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1800', 'Bank', 'A', 'A', 'AR_paid:AP_paid', '1800', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 44 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2100', 'Privatentnahme allgemein', 'A', 'Q', '', '2100', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 45 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2150', 'Privatsteuern', 'A', 'Q', '', '2150', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 46 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2180', 'Privateinlagen', 'A', 'Q', '', '2180', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 47 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2200', 'Sonderausgaben beschr?nkt abzugsf?hig', 'A', 'Q', '', '2200', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 48 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2230', 'Sonderausgaben unbeschr. abzugsf?hig', 'A', 'Q', '', '2230', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 49 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2250', 'Zuwendungen, Spenden', 'A', 'Q', '', '2250', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 50 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2953', 'Satzungsm.R?cklagen 0% Vorbelast.EK02', 'A', 'Q', '', '2953', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 51 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3151', 'Vblk.geg.Kreditinst.- Restlaufzeit b.1 Jahr', 'A', 'A', '', '3151', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 52 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3160', 'Vblk.geg.Kreditinst.- Restlaufzeit 1 bis 5 Jahre', 'A', 'A', '', '3160', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 53 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3170', 'Vblk.geg.Kreditinst.- Restlaufzeit gr?sser als 5 Jahre', 'A', 'A', '', '3170', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 54 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3300', 'Verbindlichkeiten aus Lief.u.Leist.', 'A', 'L', 'AP', '3300', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 55 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3305', 'Vblk.a.LuL z.allg.Umsatzsteuersatz (E?R)', 'A', 'L', 'AP', '3305', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 56 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3306', 'Vblk.a.LuL zum erm.Umsatzsteuersatz (E?R)', 'A', 'L', 'AP', '3306', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 57 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3307', 'Vblk.a.LuL ohne Vorsteuer (E?R)', 'A', 'L', 'AP', '3307', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 58 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3309', 'Gegenkonto 1605-1607 b.Aufteilung d.Vblk.n.Steuers.(E?R)', 'A', 'L', '', '3309', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 59 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3801', 'Umsatzsteuer 7%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax', '3801', 0, NULL, NULL, NULL, 5, FALSE);
|
|
| 60 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3802', 'Umsatzsteuer aus EG-Erwerb 7%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', '3802', 0, NULL, NULL, NULL, 6, FALSE);
|
|
| 61 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3803', 'Umsatzsteuer aus EG-Erwerb 16%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', '3803', 0, NULL, NULL, NULL, 28, FALSE);
|
|
| 62 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3805', 'Umsatzsteuer 16%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax', '3805', 0, NULL, NULL, NULL, 6, FALSE);
|
|
| 63 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3817', 'Umsatzsteuer a.i.anderen EG-Land stpfl.Lieferungen', 'A', ' ', '', '3817', 10, NULL, 0, NULL, NULL, FALSE);
|
|
| 64 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3820', 'Umsatzsteuer-Vorauszahlungen', 'A', 'E', '', '3820', 0, NULL, NULL, NULL, 28, FALSE);
|
|
| 65 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3830', 'Umsatzsteuer-Vorauszahlungen 1/11', 'A', 'E', '', '3830', 0, NULL, NULL, NULL, 28, FALSE);
|
|
| 66 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3833', 'Umsatzsteuer n.?13b UStG', 'A', 'I', '', '3833', 0, NULL, 33, NULL, 7, FALSE);
|
|
| 67 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3841', 'Umsatzsteuer Vorjahr', 'A', 'E', '', '3841', 0, NULL, NULL, NULL, 28, FALSE);
|
|
| 68 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3845', 'Umsatzsteuer fr?here Jahre', 'A', 'E', '', '3845', 0, NULL, NULL, NULL, 28, FALSE);
|
|
| 69 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4110', 'Sonstige steuerfreie Ums?tze Inland', 'A', 'I', 'AR_amount', '4110', 0, NULL, NULL, NULL, 1, TRUE);
|
|
| 70 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4120', 'Steuerfreie Ums?tze ?4Nr.1a UstG', 'A', 'I', 'AR_amount:IC_sale:IC_income', '4120', 0, 48, 1, NULL, 1, TRUE);
|
|
| 71 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4125', 'Steuerfrei innergem. Lieferungen ?41bUStG', 'A', 'I', 'AR_amount:IC_sale:IC_income', '4125', 0, 41, 1, NULL, 1, TRUE);
|
|
| 72 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4130', 'Liefe.d.1.Abnehm.bei innergem.Dreiecksg ?25b2UStG', 'A', 'I', 'AR_amount:IC_sale:IC_income', '4130', 0, NULL, NULL, NULL, 1, TRUE);
|
|
| 73 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4135', 'Steuerfr.innergem.Lief.v.Neufahrz.an Abn.o.USt-Ident-Nr.', 'A', 'I', 'AR_amount:IC_sale', '4135', 0, NULL, NULL, NULL, 1, TRUE);
|
|
| 74 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4150', 'Sonstige steuerfreie Ums?tze ?42-7UStG', 'A', 'I', 'AR_amount:IC_sale:IC_income', '4150', 0, NULL, NULL, NULL, 1, TRUE);
|
|
| 75 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4180', 'Erl?se,die mit den Durchschnittss?tzen d.?24UStG vers.werd.', 'A', 'I', 'AR_amount', '4180', NULL, NULL, NULL, NULL, 1, FALSE);
|
|
| 76 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4185', 'Erl?se als Kleinunternehmer i.S.d.?19(1)UStG', 'A', 'I', 'AR_amount', '4185', NULL, NULL, 1, NULL, 1, FALSE);
|
|
| 77 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4200', 'Erl?se', 'A', 'I', 'AR_amount:IC_sale:IC_income', '4200', 0, NULL, 1, NULL, 1, FALSE);
|
|
| 78 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4300', 'Erl?se 7%USt', 'A', 'I', 'AR_amount:IC_sale:IC_income', '4300', 2, 86, 1, NULL, 1, TRUE);
|
|
| 79 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4310', 'Erl?se Inland stpfl. EG-Lieferung7%', 'A', 'I', 'AR_amount:IC_sale:IC_income', '4310', 12, 86, 1, NULL, 1, TRUE);
|
|
| 80 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4315', 'Erl?s Inland stpfl.EG-Lieferung 16%', 'A', 'I', 'AR_amount:IC_sale:IC_income', '4315', 13, 51, 1, NULL, 1, TRUE);
|
|
| 81 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4320', 'Erl?se aus im and.EG-Land steuerpfl.Lieferungen', 'A', 'I', 'AR_amount:IC_sale:IC_income', '4320', 10, NULL, 1, NULL, 1, FALSE);
|
|
| 82 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4400', 'Erl?se 16% USt.', 'A', 'I', 'AR_amount:IC_sale:IC_income', '4400', 3, 51, 1, NULL, 1, TRUE);
|
|
| 83 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4500', 'Provisionserl?se', 'A', 'I', 'AR_amount:IC_income', '4500', 3, 51, 5, NULL, 2, FALSE);
|
|
| 84 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4504', 'Steuerfreie Ums?tze ?4Nr.8ff UstG', 'A', 'I', 'AR_amount', '4504', 0, 0, 1, NULL, NULL, TRUE);
|
|
| 85 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4506', 'Provisionserl?se 7% USt.', 'A', 'I', 'AR_amount:IC_income', '4506', 2, 86, NULL, NULL, 2, FALSE);
|
|
| 86 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4508', 'Provisionserl?se 16% USt.', 'A', 'I', 'AR_amount:IC_income', '4508', 3, 51, NULL, NULL, 2, FALSE);
|
|
| 87 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4510', 'Erl?se Abfallverwertung', 'A', 'I', 'AR_amount:IC_sale', '4510', 3, NULL, NULL, NULL, 2, FALSE);
|
|
| 88 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4520', 'Erl?s Leergut', 'A', 'I', 'AR_amount:IC_sale', '4520', 3, 51, 5, NULL, 2, FALSE);
|
|
| 89 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4580', 'Erl?se zum allg.Umsatzsteuersatz (E?R)', 'A', 'I', '', '4580', 0, 0, 1, NULL, 1, FALSE);
|
|
| 90 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4581', 'Erl?se zum erm?.Umsatzsteuersatz (E?R)', 'A', 'I', '', '4581', 0, 0, 1, NULL, 1, FALSE);
|
|
| 91 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4582', 'Erl?se steuerfrei u.nicht steuerbar (E?R)', 'A', 'I', '', '4582', 0, 0, 1, NULL, 1, FALSE);
|
|
| 92 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4589', 'Gegenkonto 8580-8582 b.Aufteilung d.Erl?se n.Steuers?tzen(E?R)', 'A', 'C', '', '4589', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 93 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4600', 'Unentgeltliche Wertabgaben', 'A', 'I', 'AR_amount', '4600', 0, NULL, NULL, NULL, 1, FALSE);
|
|
| 94 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4605', 'Entnahme v. Gegenst.o.USt.', 'A', 'I', '', '4605', 0, NULL, 5, NULL, 2, FALSE);
|
|
| 95 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4610', 'Entnah.d.Untern.f.Zwecke ausserh.d.Untern.7%USt', 'A', 'I', 'AR_amount', '4610', 2, 86, 5, NULL, 3, TRUE);
|
|
| 96 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4619', 'Entnahme durch den Untern.f.Zwecke au?erhalb d.Untern.(Waren)o.USt', 'A', 'I', '', '4619', 0, NULL, 5, NULL, 3, FALSE);
|
|
| 97 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4620', 'Entnahme des Untern.f.Zwecke ausserh.d.Untern 16%(Waren)', 'A', 'I', 'AR_amount', '4620', 3, 51, 5, NULL, 3, TRUE);
|
|
| 98 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4630', 'Verwendung v.Gegenst.f.Zwecke au?erhalb d.Unternehmens 7% USt.', 'A', 'I', 'AR_amount', '4630', 2, 86, 5, NULL, 3, TRUE);
|
|
| 99 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4639', 'Verwendung v.Gegenst?nden f.Zwecke au?erhalb d.Untern.o.USt.', 'A', 'I', '', '4639', 0, NULL, NULL, NULL, 3, FALSE);
|
|
| 100 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4640', 'Verw.v.Gegens.f.Zwecke ausserh.d.Untern.16%USt.', 'A', 'I', '', '4640', 3, 51, 5, NULL, 3, TRUE);
|
|
| 101 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4645', 'Verwend.v.Gegenst.f.Zwecke au?erh.d.Untern.16%USt(Kfz-Nutzung)', 'A', 'I', '', '4645', 0, 0, 5, NULL, 3, TRUE);
|
|
| 102 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4646', 'Verwend.f.Gegenst.f.Zwecke au?erh.d.Untern.16%USt(Telefonnutzung)', 'A', 'I', '', '4646', 0, 0, 5, NULL, 3, TRUE);
|
|
| 103 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4660', 'Unentgeltl.Erbring.sons.Leis.16%USt', 'A', 'I', 'AR_amount', '4660', 3, 51, NULL, NULL, 3, TRUE);
|
|
| 104 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4670', 'Unentgeltl.Zuw.von Waren 7% Ust', 'A', 'I', '', '4670', 2, 86, 5, NULL, 3, TRUE);
|
|
| 105 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4679', 'Unentgeltl.Zuwendung v.Waren o.USt.', 'A', 'I', '', '4679', 0, NULL, 5, NULL, 3, FALSE);
|
|
| 106 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4680', 'Unentgeltl.Zuw.v Waren 16% Ust', 'A', 'I', '', '4680', 3, 51, 5, NULL, 3, TRUE);
|
|
| 107 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4686', 'Unentgeltl.Zuwend.v.Gegens. 16% Ust', 'A', 'I', 'AR_amount', '4686', 3, 51, NULL, NULL, 3, TRUE);
|
|
| 108 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4689', 'Unentgeltl.Zuw.v.Gegens.ohne Ust', 'A', 'I', '', '4689', 0, NULL, 5, NULL, 3, FALSE);
|
|
| 109 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4690', 'Nicht steuerbare Ums?tze', 'A', 'I', '', '4690', 0, NULL, 5, NULL, 1, FALSE);
|
|
| 110 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4695', 'Umsatzsteuerverg?tungen', 'A', 'I', '', '4695', 0, NULL, NULL, NULL, 7, FALSE);
|
|
| 111 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4700', 'Erl?sschm?lerungen', 'A', 'I', '', '4700', 0, NULL, 32, NULL, 1, FALSE);
|
|
| 112 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4710', 'Erl?sschm?lerung 7% USt.', 'A', 'I', '', '4710', 2, 86, 32, NULL, 1, TRUE);
|
|
| 113 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4720', 'Erl?sschm?lerung 16% USt.', 'A', 'I', '', '4720', 3, 51, 32, NULL, 1, TRUE);
|
|
| 114 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4725', 'Erl?sschm?.Inl.stpfl.EG-Lief. 7%USt', 'A', 'I', '', '4725', 12, 86, 32, NULL, 1, TRUE);
|
|
| 115 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4726', 'Erl?sschm?.Inl.stpfl.EG-Lief.16%USt', 'A', 'I', '', '4726', 13, 51, 32, NULL, 1, TRUE);
|
|
| 116 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4727', 'Erl?sschm?.and.EG Land stpfl.Liefer', 'A', 'I', '', '4727', 0, NULL, 32, NULL, 1, FALSE);
|
|
| 117 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4731', 'Gew?hrte Skonti 7% USt', 'A', 'E', 'AR_paid', '4731', 2, 86, 1, NULL, 1, TRUE);
|
|
| 118 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4735', 'Gew?hrte Skonti 16% USt.', 'A', 'E', 'AR_paid', '4735', 3, 51, 1, NULL, 1, FALSE);
|
|
| 119 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4750', 'Gew?hrte Boni 7% USt.', 'A', 'E', 'AR_paid', '4750', 2, 86, 1, NULL, 1, TRUE);
|
|
| 120 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4760', 'Gew?hrte Boni 16% USt.', 'A', 'E', 'AR_paid', '4760', 3, 51, 1, NULL, 1, TRUE);
|
|
| 121 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4780', 'Gew?hrte Rabatte 7% USt.', 'A', 'E', 'AR_paid', '4780', 2, 86, 1, NULL, 1, TRUE);
|
|
| 122 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4790', 'Gew?hrte Rabatte 16% Ust.', 'A', 'E', 'AR_paid', '4790', 3, 51, 1, NULL, 1, TRUE);
|
|
| 123 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4800', 'Bestandsver?nd.fert..Leist.', 'A', 'E', '', '4800', 0, 0, 2, NULL, NULL, FALSE);
|
|
| 124 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4810', 'Bestandsver?nderung unf.Erz.', 'A', 'E', '', '4810', 0, 0, 2, NULL, NULL, FALSE);
|
|
| 125 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4815', 'Bestandsver?nd.unf.Leist.', 'A', 'E', '', '4815', 0, 0, 2, NULL, NULL, FALSE);
|
|
| 126 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4820', 'And.aktiv.Eigenleistungen', 'A', 'E', '', '4820', 0, 0, 3, NULL, NULL, FALSE);
|
|
| 127 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4830', 'Sonstige Ertr?ge', 'A', 'I', '', '4830', 3, 51, 33, NULL, 2, FALSE);
|
|
| 128 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4840', 'Ertr?ge aus Kursdifferenzen', 'A', 'I', '', '4840', 0, NULL, 33, NULL, 2, FALSE);
|
|
| 129 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4835', 'Sonstige Erl?se betriebl.u.regelm??', 'A', 'I', 'AR_amount', '4835', 3, 51, 5, NULL, 2, FALSE);
|
|
| 130 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4837', 'Betriebsfremde Ertr?ge nichtau?erorden', 'A', 'I', '', '4837', 0, NULL, 33, NULL, NULL, FALSE);
|
|
| 131 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4844', 'Erl?se a.Verk.Sachanlagen steuerfrei?4Nr.1aUStG(b.Buchverlust)', 'A', 'E', '', '4844', 0, NULL, NULL, NULL, 1, TRUE);
|
|
| 132 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4845', 'Erl?se aus Verk.Sachanlageverm?gen16% USt (bei Buchverlust)', 'A', 'E', '', '4845', 0, NULL, NULL, NULL, 2, TRUE);
|
|
| 133 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4848', 'Erl?se a.Verk.Sachanlagen steuerfrei?4Nr.1bUStG(b.Buchverlust)', 'A', 'E', '', '4848', 0, NULL, NULL, NULL, 1, TRUE);
|
|
| 134 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4849', 'Erl?se aus Anlagenverk?ufen', 'A', 'I', 'AR_amount', '4849', 3, 51, NULL, NULL, 1, FALSE);
|
|
| 135 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4860', 'Grundst?cksertr?ge', 'A', 'I', '', '4860', 3, 51, 33, NULL, NULL, FALSE);
|
|
| 136 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4900', 'Ertr?ge aus Abgang von AV-Gegenst?nden', 'A', 'I', '', '4900', 0, NULL, 33, NULL, 2, FALSE);
|
|
| 137 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4905', 'Ertr.a.d.Abg.v.Gegenst.d.Umlaufverm', 'A', 'I', '', '4905', 0, NULL, 33, NULL, 2, FALSE);
|
|
| 138 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4910', 'Ertrag a.d.Zuschreib.d.Anlageverm?g', 'A', 'I', '', '4910', 0, NULL, 33, NULL, 2, FALSE);
|
|
| 139 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4915', 'Ertr.a.Zuschreib.d.Umlaufverm?gens', 'A', 'I', '', '4915', 0, NULL, 33, NULL, NULL, FALSE);
|
|
| 140 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4920', 'Ertr.a.Herabsetzung d.PWB zu Forderungen', 'A', 'I', '', '4920', 0, NULL, 33, NULL, 2, FALSE);
|
|
| 141 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4925', 'Ertr. aus abgeschriebenen Forderung', 'A', 'I', '', '4925', 0, NULL, 33, NULL, NULL, FALSE);
|
|
| 142 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4930', 'Ertr.a.d.Aufl?sung v.R?ckstellungen', 'A', 'I', '', '4930', 0, NULL, 33, NULL, NULL, FALSE);
|
|
| 143 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4934', 'Ertr?ge a.d.Aufl?sung v.SoPo m.R?cklageant.(Exitenzgr?ndungszusch.)', 'A', 'I', '', '4934', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 144 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4939', 'Ertr?ge Aufl. Sopo m.R.(Ansparafa)', 'A', 'I', '', '4939', 0, NULL, 5, NULL, NULL, FALSE);
|
|
| 145 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4941', 'Sachbez?ge 7% Ust (Waren)', 'A', 'I', 'AR_amount', '4941', 2, 86, 5, NULL, 2, TRUE);
|
|
| 146 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4945', 'Sachbez?ge 16% Ust (Waren)', 'A', 'I', 'AR_amount', '4945', 3, 51, 5, NULL, 2, TRUE);
|
|
| 147 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4946', 'Verrechnete sons. Sachbez?ge keine Waren', 'A', 'I', 'AR_amount', '4946', 0, 0, 5, NULL, 2, FALSE);
|
|
| 148 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4960', 'Periodenfremde Ertr?ge nicht au?ero', 'A', 'I', '', '4960', 0, NULL, 33, NULL, NULL, FALSE);
|
|
| 149 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4970', 'Versicherungsentsch?digungen', 'A', 'I', '', '4970', 0, NULL, 33, NULL, 2, FALSE);
|
|
| 150 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4981', 'Steuerfr.Ertr?ge a.d.Aufl?s.v.SoPo m.R?cklageanteil', 'A', 'I', '', '4981', 0, NULL, NULL, NULL, 2, FALSE);
|
|
| 151 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4982', 'Sonst.steuerfreie Betriebseinnahmen', 'A', 'I', '', '4982', 0, NULL, NULL, NULL, 2, FALSE);
|
|
| 152 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5190', 'Energiestoffe (Fert.).', 'A', 'E', 'IC', '5190', 9, 0, 4, NULL, 8, FALSE);
|
|
| 153 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5300', 'Wareneingang 7% Vorsteuer', 'A', 'E', 'AP_amount:IC_cogs', '5300', 8, NULL, 4, NULL, 8, TRUE);
|
|
| 154 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5400', 'Wareneingang 16% Vorsteuer', 'A', 'E', 'AP_amount:IC_cogs', '5400', 9, NULL, 4, NULL, 8, TRUE);
|
|
| 155 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5420', 'Innergemein.Erwerb 7% VorSt u. Ust', 'A', 'E', 'AP_amount:IC_cogs', '5420', 0, 93, 4, NULL, 8, TRUE);
|
|
| 156 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5425', 'Innergem.Erwerb 16% VorSt u. Ust', 'A', 'E', 'AP_amount:IC_cogs', '5425', 0, 97, 4, NULL, 8, TRUE);
|
|
| 157 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5440', 'Innergem.Erwerb v.Neufahrz.v.Lief.o.USt.Identnr.16%VSt.u.16%USt.', 'A', 'E', 'AP_amount:IC_cogs', '5440', 19, 94, NULL, NULL, 8, TRUE);
|
|
| 158 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5550', 'Steuerfreier innergem.Erwerb', 'A', 'E', 'AP_amount:IC_cogs', '5550', 0, 91, NULL, NULL, 8, FALSE);
|
|
| 159 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5559', 'Steuerfreie Einfuhren', 'A', 'E', 'AP_amount:IC_cogs', '5559', 0, 91, NULL, NULL, 8, FALSE);
|
|
| 160 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5580', 'Wareneinkauf z.allg.Umsatzsteuersatz (E?R)', 'A', 'E', '', '5580', 0, 0, 4, NULL, 8, FALSE);
|
|
| 161 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5581', 'Wareneinkauf z.erm.Umsatzsteuersatz(E?R)', 'A', 'E', '', '5581', 0, 0, 4, NULL, 8, FALSE);
|
|
| 162 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5582', 'Wareneinkauf ohne Vorsteuerabzug(E?R)', 'A', 'E', '', '5582', 0, 0, 4, NULL, 8, FALSE);
|
|
| 163 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5589', 'Gegenkto.3580-3582 b.Aufteilung d.WE n.Steuers?tzen(E?R)', 'A', 'E', '', '5589', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 164 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5600', 'Nicht abziehbare Vorsteuer', 'A', 'E', '', '5600', 0, NULL, 5, NULL, 8, FALSE);
|
|
| 165 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5610', 'Nicht abziehb.Vorsteuer 7%', 'A', 'E', '', '5610', 0, NULL, 5, NULL, 8, FALSE);
|
|
| 166 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5650', 'Nicht abziehb.Vorsteuer 16%', 'A', 'E', '', '5650', 0, NULL, 5, NULL, 8, FALSE);
|
|
| 167 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5731', 'Erhaltene Skonti 7% Vorsteuer', 'A', 'I', 'AP_paid', '5731', 8, NULL, 4, NULL, NULL, TRUE);
|
|
| 168 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5735', 'Erhaltene Skonti 16% Vorsteuer', 'A', 'I', 'AP_paid', '5735', 9, NULL, 4, NULL, NULL, TRUE);
|
|
| 169 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5750', 'Erhaltene Boni 7% Vorsteuer', 'A', 'I', 'AP_paid', '5750', 8, NULL, 4, NULL, NULL, TRUE);
|
|
| 170 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5760', 'Erhaltene Boni 16% Vorsteuer', 'A', 'I', 'AP_paid', '5760', 9, NULL, 4, NULL, NULL, TRUE);
|
|
| 171 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5780', 'Erhaltene Rabatte 7% Vorsteuer', 'A', 'I', 'AP_paid', '5780', 8, NULL, 4, NULL, NULL, TRUE);
|
|
| 172 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5790', 'Erhaltene Rabatte 16% Vorsteuer', 'A', 'I', 'AP_paid', '5790', 9, NULL, 4, NULL, NULL, TRUE);
|
|
| 173 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5800', 'Bezugsnebenkosten', 'A', 'E', 'AP_amount:IC_cogs:IC_expense', '5800', 0, NULL, 4, NULL, 8, FALSE);
|
|
| 174 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5820', 'Leergut', 'A', 'E', 'AP_amount:IC_cogs', '5820', 0, NULL, 4, NULL, NULL, FALSE);
|
|
| 175 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5840', 'Z?lle und Einfuhrabgaben', 'A', 'E', 'AP_amount:IC_cogs', '5840', 0, NULL, 4, NULL, NULL, FALSE);
|
|
| 176 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5860', 'Verrechnete Stoffkosten', 'A', 'E', 'IC_cogs', '5860', 0, NULL, 4, NULL, NULL, FALSE);
|
|
| 177 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5880', 'Bestandsver.Roh-,Hilfs-.Betriebs.sow.bez.Waren', 'A', 'E', '', '5880', 0, NULL, 2, NULL, NULL, FALSE);
|
|
| 178 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5900', 'Fremdleistungen', 'A', 'E', 'AP_amount', '5900', 9, NULL, 5, NULL, 8, FALSE);
|
|
| 179 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5915', 'Leist.v.ausl?nd.Untern. 7% VSt.u.7%USt.', 'A', 'E', 'AP_amount', '5915', 8, NULL, 5, NULL, 8, TRUE);
|
|
| 180 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('5925', 'Leist.v.ausl?nd.Untern. 16% VSt.u.16%USt.', 'A', 'E', 'AP_amount', '5925', 9, NULL, 5, NULL, 8, TRUE);
|
|
| 181 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6010', 'L?hne', 'A', 'E', '', '6010', 0, NULL, 10, NULL, 9, FALSE);
|
|
| 182 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6020', 'Geh?lter', 'A', 'E', '', '6020', 0, NULL, 10, NULL, NULL, FALSE);
|
|
| 183 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6026', 'Tantiemen', 'A', 'E', '', '6026', 0, NULL, 10, NULL, 9, FALSE);
|
|
| 184 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6027', 'Gesch?ftsf?hrergeh?lter', 'A', 'E', '', '6027', 0, NULL, 10, NULL, 9, FALSE);
|
|
| 185 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6030', 'Aushilfsl?hne', 'A', 'E', '', '6030', 0, NULL, 10, NULL, 9, FALSE);
|
|
| 186 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6040', 'Lohnsteuer f?r Aushilfe', 'A', 'E', '', '6040', 0, NULL, 10, NULL, 10, FALSE);
|
|
| 187 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6045', 'Bedienungsgelder', 'A', 'E', '', '6045', 0, NULL, 10, NULL, 9, FALSE);
|
|
| 188 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6050', 'Ehegattengehalt', 'A', 'E', '', '6050', 0, NULL, 10, NULL, NULL, FALSE);
|
|
| 189 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6060', 'Freiwillige sozi.Aufw.lohnsteuerpflichtig.', 'A', 'E', '', '6060', 0, NULL, 10, NULL, 10, FALSE);
|
|
| 190 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6069', 'Pauschale Lohnsteuera.sons.Bez?ge (z.B.Fahrtkostenzu)', 'A', 'E', '', '6069', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 191 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6070', 'Krankengeldzusch?sse', 'A', 'E', '', '6070', 0, NULL, 10, NULL, NULL, FALSE);
|
|
| 192 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6080', 'Verm?genswirksame Leistungen', 'A', 'E', '', '6080', 0, NULL, 10, NULL, 9, FALSE);
|
|
| 193 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6090', 'Fahrtkostenerst.Wohnung/Arbeitsst?t', 'A', 'E', '', '6090', 0, NULL, 10, NULL, NULL, FALSE);
|
|
| 194 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6110', 'Gesetzlich soziale Aufwendungen', 'A', 'E', '', '6110', 0, 0, 10, NULL, 10, FALSE);
|
|
| 195 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6120', 'Beitr?ge zur Berufsgenossenschaft', 'A', 'E', '', '6120', 0, NULL, 10, NULL, 10, FALSE);
|
|
| 196 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6130', 'Freiwillig soziale Aufwendungen lohnsteuerfrei', 'A', 'E', '', '6130', 0, NULL, 10, NULL, 10, FALSE);
|
|
| 197 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6147', 'Pauschale Lohnsteuer auf sonst.Bez?ge(z.B.Direktversicherung', 'A', 'E', '', '6147', 0, NULL, 10, NULL, 9, FALSE);
|
|
| 198 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6200', 'Abschreibungen a.immat.Verm?gensgeg', 'A', 'E', '', '6200', 0, NULL, NULL, NULL, 25, FALSE);
|
|
| 199 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6205', 'Abschreibung a.d.Gesch?ft-o.Firmenw', 'A', 'E', '', '6205', 0, NULL, NULL, NULL, 25, FALSE);
|
|
| 200 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6210', 'Au?erplan.AfA a.immat.Verm?gensgeg.', 'A', 'E', '', '6210', 0, NULL, 17, NULL, 25, FALSE);
|
|
| 201 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6221', 'Abschreibung auf Geb?ude', 'A', 'E', '', '6221', 0, NULL, 17, NULL, 25, FALSE);
|
|
| 202 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6220', 'Abschreibungen auf Sachanlagen (o.Kfz u.Geb.)', 'A', 'E', '', '6220', 0, NULL, 17, NULL, 25, FALSE);
|
|
| 203 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6222', 'Abschreibungen auf Kfz', 'A', 'E', '', '6222', 0, NULL, 17, NULL, 25, FALSE);
|
|
| 204 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6230', 'Au?erplanm??ig Abschr.a.Sachanlagen', 'A', 'E', '', '6230', 0, NULL, NULL, NULL, 25, FALSE);
|
|
| 205 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6231', 'Absetzung f.au?ergew.techn.u.wirtschaftl.AfA bei Geb?uden', 'A', 'E', '', '6231', 0, NULL, 17, NULL, 25, FALSE);
|
|
| 206 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6232', 'Absetzung f.au?ergew.techn.u.wirtschaftl.AfA des Kfz', 'A', 'E', '', '6232', 0, NULL, 17, NULL, 25, FALSE);
|
|
| 207 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6233', 'Absetzung f.au?ergew.techn.u.wirtschaftl.AfA sonst.WG', 'A', 'E', '', '6233', 0, NULL, 17, NULL, 25, FALSE);
|
|
| 208 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6240', 'Abschr.a.Sachanl.aufgr.steuerl.Sondervorschriften', 'A', 'E', '', '6240', 0, NULL, 17, NULL, 25, FALSE);
|
|
| 209 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6241', 'Sonderabschreibung nach ?7g(1)u.(2)EStG (ohne Kfz)', 'A', 'E', '', '6241', 0, NULL, 17, NULL, 25, FALSE);
|
|
| 210 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6242', 'Sonderabschreibung n.?7g(1)u.(2)EStG (f?r Kfz)', 'A', 'E', '', '6242', 0, NULL, 17, NULL, 25, FALSE);
|
|
| 211 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6250', 'Kaufleasing', 'A', 'E', 'AP_amount', '6250', 0, NULL, 20, NULL, 24, FALSE);
|
|
| 212 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6260', 'Sofortabschreibung GWG', 'A', 'E', 'AP_amount', '6260', 0, NULL, NULL, NULL, 26, FALSE);
|
|
| 213 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6262', 'Abschreibungen auf aktivierte GWG', 'A', 'E', '', '6262', 0, NULL, NULL, NULL, 25, FALSE);
|
|
| 214 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6270', 'Abschreibungen auf Finanzanlagen', 'A', 'E', '', '6270', NULL, NULL, NULL, NULL, NULL, FALSE);
|
|
| 215 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6275', 'Abschr.a.Wertp.d.Umlaufverm?gens', 'A', 'E', '', '6275', 0, NULL, 17, NULL, NULL, FALSE);
|
|
| 216 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6280', 'Forderungsverlust-?bliche H?he', 'A', 'E', '', '6280', 0, NULL, 20, NULL, NULL, FALSE);
|
|
| 217 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6281', 'Forderungsverluste 7% USt.(?bliche H?he', 'A', 'E', '', '6281', 2, 86, 20, NULL, NULL, TRUE);
|
|
| 218 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6285', 'Forderungsverluste 16% USt.(?bliche H?he', 'A', 'E', '', '6285', 3, 51, 20, NULL, NULL, TRUE);
|
|
| 219 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6300', 'Sonstige betriebliche Aufwendungen', 'A', 'E', 'AP_amount', '6300', 9, NULL, 20, NULL, 24, FALSE);
|
|
| 220 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6303', 'Fremdleistungen', 'A', 'E', 'AP_amount', '6303', 0, NULL, 20, NULL, 24, FALSE);
|
|
| 221 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6304', 'Sons.Aufw.betriebl. und regelm??ig', 'A', 'E', 'AP_amount', '6304', 9, NULL, NULL, NULL, 24, FALSE);
|
|
| 222 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6305', 'Raumkosten', 'A', 'E', 'AP_amount', '6305', 9, NULL, 11, NULL, NULL, FALSE);
|
|
| 223 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6310', 'Miete', 'A', 'E', 'AP_amount', '6310', 9, NULL, 11, NULL, 11, FALSE);
|
|
| 224 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6315', 'Pacht', 'A', 'E', 'AP_amount', '6315', 0, NULL, NULL, NULL, 11, FALSE);
|
|
| 225 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6320', 'Heizung', 'A', 'E', 'AP_amount', '6320', 9, NULL, 11, NULL, NULL, FALSE);
|
|
| 226 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6325', 'Gas,Strom, Wasser', 'A', 'E', 'AP_amount', '6325', 9, NULL, 11, NULL, 12, FALSE);
|
|
| 227 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6330', 'Reinigung', 'A', 'E', 'AP_amount', '6330', 9, NULL, NULL, 11, 24, FALSE);
|
|
| 228 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6335', 'Instandhaltung betrieb.R?ume', 'A', 'E', 'AP_amount', '6335', 9, NULL, 11, NULL, 13, FALSE);
|
|
| 229 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6338', 'Instandhlt.betriebl.R?ume in Geb.die nicht z.BV geh?ren', 'A', 'E', '', '6338', 0, NULL, NULL, NULL, 11, FALSE);
|
|
| 230 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6343', 'Abgaben f.betriebl.genutzten Grundbesitz,d.nicht z.BV geh?rt', 'A', 'E', '', '6343', 0, NULL, NULL, NULL, 11, FALSE);
|
|
| 231 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6345', 'Sonstige Raumkosten', 'A', 'E', 'AP_amount', '6345', 9, NULL, 11, NULL, 13, FALSE);
|
|
| 232 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6348', 'Aufwend.f.ein h?usliches Arbeitszimmer(abziehb.Anteil)', 'A', 'E', '', '6348', 0, NULL, NULL, NULL, 24, FALSE);
|
|
| 233 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6349', 'Aufwend.f.ein h?usliches Arbeitszimmer(nicht abziehb.Anteil)', 'A', 'E', '', '6349', 0, 0, 11, NULL, 24, FALSE);
|
|
| 234 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6350', 'Grundst?cksaufwendungen', 'A', 'E', '', '6350', 9, NULL, 31, NULL, NULL, FALSE);
|
|
| 235 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6358', 'Gr?ndst?cksaufwend.f.Geb?ude,die nicht z.Betriebsverm.geh?ren', 'A', 'E', '', '6358', 0, NULL, NULL, NULL, 24, FALSE);
|
|
| 236 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6390', 'Zuwend.,Spenden,steuerlich n.abziehbar', 'A', 'E', '', '6390', 0, NULL, 31, NULL, NULL, FALSE);
|
|
| 237 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6405', 'Versicherungen f.Geb?ude,die zum BV geh?ren', 'A', 'E', '', '6405', 0, NULL, NULL, NULL, 24, FALSE);
|
|
| 238 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6420', 'Beitr?ge', 'A', 'E', 'AP_amount', '6420', 0, NULL, NULL, NULL, 14, FALSE);
|
|
| 239 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6400', 'Versicherungen', 'A', 'E', 'AP_amount', '6400', 0, NULL, 13, NULL, 14, FALSE);
|
|
| 240 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6430', 'Sonstige Abgaben', 'A', 'E', 'AP_amount', '6430', 0, NULL, NULL, NULL, 14, FALSE);
|
|
| 241 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6436', 'Steuerl.abzugs.Versp?tungszuschl.u.Zwangsgelder', 'A', 'E', '', '6436', 0, NULL, NULL, NULL, 31, FALSE);
|
|
| 242 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6437', 'Steuerl.n.abzugsf.Versp?tungszuschl?ge u.Zwangsgelder', 'A', 'E', '', '6437', 0, NULL, NULL, NULL, 31, FALSE);
|
|
| 243 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6440', 'Ausgleichsabgabe i.S.d.Schwerbehinterdengesetzes', 'A', 'E', '', '6440', 0, NULL, 10, NULL, 10, FALSE);
|
|
| 244 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6460', 'Rep.u.Instandhaltungen v.techn.Anlagen u.Maschinen', 'A', 'E', 'AP_amount', '6460', 9, NULL, 18, NULL, 19, FALSE);
|
|
| 245 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6470', 'Rep.u.Instandhalt.v.and.Anlagen u.Betriebs-u.Gesch?ftsausst.', 'A', 'E', 'AP_amount', '6470', 9, NULL, 18, NULL, 19, FALSE);
|
|
| 246 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6495', 'Wartungskosten f?r Hard-u.Software', 'A', 'E', 'AP_amount:IC_expense', '6495', 9, NULL, 18, NULL, 19, FALSE);
|
|
| 247 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6490', 'Sonstige Reparaturen u.Instandhalt.', 'A', 'E', 'AP_amount', '6490', 9, NULL, NULL, NULL, 19, FALSE);
|
|
| 248 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6498', 'Mietleasing', 'A', 'E', 'AP_amount', '6498', 0, NULL, 20, NULL, 24, FALSE);
|
|
| 249 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6499', 'Gewerbest.zu ber?cksicht.Mietleasing ?8 GewStG', 'A', 'E', '', '6499', 0, NULL, NULL, NULL, 24, FALSE);
|
|
| 250 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6500', 'Fahrzeugkosten', 'A', 'E', 'AP_amount', '6500', 0, NULL, NULL, NULL, 17, FALSE);
|
|
| 251 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6520', 'Kfz-Versicherungen', 'A', 'E', 'AP_amount', '6520', 0, NULL, 14, NULL, 16, FALSE);
|
|
| 252 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6530', 'Laufende Kfz-Betriebskosten', 'A', 'E', 'AP_amount', '6530', 9, NULL, 14, NULL, 17, FALSE);
|
|
| 253 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6540', 'Kfz-Reparaturen', 'A', 'E', 'AP_amount', '6540', 9, NULL, 14, NULL, 17, FALSE);
|
|
| 254 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6550', 'Garagenmiete', 'A', 'E', 'AP_amount', '6550', 0, NULL, 14, NULL, 17, FALSE);
|
|
| 255 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6560', 'Leasingfahrzeugkosten', 'A', 'E', 'AP_amount', '6560', 0, NULL, 14, NULL, 17, FALSE);
|
|
| 256 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6570', 'Sonstige Kfz-Kosten', 'A', 'E', 'AP_amount', '6570', 9, NULL, 14, NULL, 17, FALSE);
|
|
| 257 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6580', 'Mautgeb?hren', 'A', 'E', '', '6580', 0, 0, 14, NULL, 17, FALSE);
|
|
| 258 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6590', 'Fahrzeugkosten f.Kfz,die nicht zum BV geh?ren', 'A', 'E', '', '6590', 0, NULL, NULL, NULL, 17, FALSE);
|
|
| 259 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6595', 'Fremdfahrzeuge', 'A', 'E', 'AP_amount', '6595', 0, NULL, 14, NULL, 17, FALSE);
|
|
| 260 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6600', 'Werbekosten', 'A', 'E', 'AP_amount', '6600', 9, NULL, NULL, 15, 18, FALSE);
|
|
| 261 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6610', 'Geschenke bis 35 EUR abzugsf?hig', 'A', 'E', 'AP_amount', '6610', 0, NULL, 15, NULL, 18, FALSE);
|
|
| 262 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6620', 'Geschenke ?ber 35EUR nicht abzugsf.', 'A', 'E', 'AP_amount', '6620', 0, NULL, 15, NULL, 18, FALSE);
|
|
| 263 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6625', 'Geschenke ausschlie?l.betrieb.genut', 'A', 'E', 'AP_amount', '6625', 9, NULL, NULL, NULL, 18, FALSE);
|
|
| 264 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6630', 'Repr?sentationskosten', 'A', 'E', 'AP_amount', '6630', 9, NULL, 15, NULL, 18, FALSE);
|
|
| 265 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6640', 'Bewirtungskosten', 'A', 'E', 'AP_amount', '6640', 9, NULL, 20, NULL, 18, FALSE);
|
|
| 266 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6643', 'Aufmerksamkeiten', 'A', 'E', 'AP_amount', '6643', 9, NULL, NULL, NULL, 18, FALSE);
|
|
| 267 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6644', 'Nicht abzugsf?hige Bewirtungskosten', 'A', 'E', 'AP_amount', '6644', 0, NULL, NULL, NULL, 18, FALSE);
|
|
| 268 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6645', 'Nicht abzugsf.Betriebsausg.a.Werbe-Repr?sentatisonk.etc.', 'A', 'E', 'AP_amount', '6645', 9, NULL, 15, NULL, 24, FALSE);
|
|
| 269 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6650', 'Reisekosten Arbeitnehmer', 'A', 'E', 'AP_amount', '6650', 9, NULL, 15, NULL, 18, FALSE);
|
|
| 270 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6663', 'Reisekosten Arbeitn.m.Vorsteuerabzu f.?ffentl.Verkehrsm.', 'A', 'E', 'AP_amount', '6663', 8, NULL, 15, NULL, 18, FALSE);
|
|
| 271 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6664', 'Reisekosten Arbeitn.Verpflegungmehr', 'A', 'E', 'AP_amount', '6664', 0, NULL, 15, NULL, 18, FALSE);
|
|
| 272 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6660', 'Reisekosten Arbeitn.?bernachtungsaufwand', 'A', 'E', 'AP_amount', '6660', 0, NULL, 15, NULL, 18, FALSE);
|
|
| 273 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6668', 'Kilometerentgelderstattung Arbeitnehmer', 'A', 'E', 'AP_amount', '6668', 0, NULL, 15, NULL, 18, FALSE);
|
|
| 274 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6670', 'Reisekosten Unternehmer', 'A', 'E', 'AP_amount', '6670', 9, NULL, 15, NULL, 18, FALSE);
|
|
| 275 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6673', 'Reisek.Untern.m.Vorsteuerabzug (?ffentl.Verkehrsm.', 'A', 'E', 'AP_amount', '6673', 8, NULL, 15, NULL, 18, FALSE);
|
|
| 276 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6674', 'Reisekosten Untern.Verpflegungsmehr', 'A', 'E', 'AP_amount', '6674', 0, NULL, 15, NULL, 18, FALSE);
|
|
| 277 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6680', 'Reisekosten Untern.?bernachtungsauf', 'A', 'E', 'AP_amount', '6680', 0, NULL, 15, NULL, 18, FALSE);
|
|
| 278 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6688', 'Fahrten zw.Wohn.und Arbeitsst?tte (nicht abziehb.Teil)', 'A', 'E', '', '6688', 0, NULL, NULL, NULL, 18, FALSE);
|
|
| 279 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6689', 'Fahrten zw.Wohn.-und Arbeitsst?tte (Haben)', 'A', 'E', '', '6689', 0, NULL, NULL, NULL, 18, FALSE);
|
|
| 280 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6700', 'Kosten der Warenabgabe', 'A', 'E', 'AP_amount:IC_cogs', '6700', 0, NULL, NULL, NULL, 24, FALSE);
|
|
| 281 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6710', 'Verpackungsmaterial', 'A', 'E', 'AP_amount:IC_cogs', '6710', 0, NULL, NULL, NULL, 24, FALSE);
|
|
| 282 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6740', 'Ausgangsfracht', 'A', 'E', 'AP_amount:IC_cogs', '6740', 0, NULL, NULL, NULL, 24, FALSE);
|
|
| 283 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6760', 'Transportversicherung', 'A', 'E', 'AP_amount:IC_cogs:IC_expense', '6760', 0, NULL, NULL, NULL, 24, FALSE);
|
|
| 284 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6770', 'Verkaufsprovision', 'A', 'E', 'AP_amount:IC_expense', '6770', 0, NULL, NULL, NULL, 24, FALSE);
|
|
| 285 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6780', 'Fremdarbeiten', 'A', 'E', 'AP_amount:IC_expense', '6780', 0, NULL, NULL, NULL, 24, FALSE);
|
|
| 286 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6790', 'Aufwand f?r Gew?hrleistungen', 'A', 'E', 'AP_amount:IC_expense', '6790', 0, NULL, 20, NULL, 24, FALSE);
|
|
| 287 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6800', 'Porto', 'A', 'E', 'AP_amount', '6800', 0, NULL, 20, NULL, 23, FALSE);
|
|
| 288 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6805', 'Telefon', 'A', 'E', 'AP_amount', '6805', 9, NULL, 20, NULL, 23, FALSE);
|
|
| 289 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6810', 'Telefax', 'A', 'E', 'AP_amount', '6810', 9, NULL, 20, NULL, 23, FALSE);
|
|
| 290 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6815', 'B?robedarf', 'A', 'E', 'AP_amount', '6815', 9, NULL, 20, NULL, 23, FALSE);
|
|
| 291 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6820', 'Zeitschriften, B?cher', 'A', 'E', 'AP_amount', '6820', 8, NULL, 20, NULL, 20, FALSE);
|
|
| 292 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6821', 'Fortbildungskosten', 'A', 'E', 'AP_amount', '6821', 9, NULL, NULL, NULL, 24, FALSE);
|
|
| 293 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6822', 'Freiwillige Sozialleistungen', 'A', 'E', 'AP_amount', '6822', 0, NULL, NULL, NULL, 9, FALSE);
|
|
| 294 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6825', 'Rechts- und Beratungskosten', 'A', 'E', 'AP_amount', '6825', 9, NULL, 20, NULL, 22, FALSE);
|
|
| 295 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6827', 'Abschlu?- und Pr?fungskosten', 'A', 'E', 'AP_amount', '6827', 9, NULL, 20, NULL, 22, FALSE);
|
|
| 296 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6830', 'Buchf?hrungskosten', 'A', 'E', 'AP_amount', '6830', 9, NULL, NULL, NULL, 24, FALSE);
|
|
| 297 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6835', 'Mieten f?r Einrichtungen', 'A', 'E', 'AP_amount', '6835', 9, NULL, 20, NULL, 21, FALSE);
|
|
| 298 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6840', 'Mietleasing', 'A', 'E', 'AP_amount', '6840', 9, NULL, 20, NULL, 21, FALSE);
|
|
| 299 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6845', 'Werkzeuge und Kleinger?te', 'A', 'E', 'AP_amount', '6845', 9, NULL, NULL, NULL, 19, FALSE);
|
|
| 300 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6850', 'Betriebsbedarf', 'A', 'E', 'AP_amount', '6850', 9, NULL, 20, NULL, 24, FALSE);
|
|
| 301 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6855', 'Nebenkosten des Geldverkehrs', 'A', 'E', '', '6855', 0, NULL, 20, NULL, 24, FALSE);
|
|
| 302 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6859', 'Aufwend.f.Abraum-u.Abfallbeseitigung', 'A', 'E', 'AP_amount', '6859', 9, NULL, 20, NULL, 24, FALSE);
|
|
| 303 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6865', 'Nicht abziehbare Vorsteuer 7%', 'A', 'E', 'AP_paid', '6865', 0, NULL, 20, NULL, NULL, FALSE);
|
|
| 304 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6870', 'Nicht abziehbare Vorsteuer 16%', 'A', 'E', 'AP_paid', '6870', 0, NULL, 20, NULL, NULL, FALSE);
|
|
| 305 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6860', 'Nicht abziehbare Vorsteuer', 'A', 'E', '', '6860', 0, NULL, 31, NULL, 24, FALSE);
|
|
| 306 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6880', 'Aufwendungen aus Kursdifferenzen', 'A', 'E', '', '6880', 0, NULL, 31, NULL, 24, FALSE);
|
|
| 307 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6895', 'Abg?nge Sachanlagen Restbuchwert', 'A', 'E', '', '6895', 0, NULL, 31, NULL, 2, FALSE);
|
|
| 308 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6900', 'Verluste aus Anlagenabgang', 'A', 'E', '', '6900', 0, NULL, 31, NULL, NULL, FALSE);
|
|
| 309 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6926', 'Einstellungen in SoPo m.R?cklageanteil (Ansparabschreibung)', 'A', 'E', '', '6926', 0, NULL, 20, NULL, NULL, FALSE);
|
|
| 310 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6928', 'Einst.in SoPo m.R?cklageanteil (Existenzgr?ndungsr?cklage)', 'A', 'E', '', '6928', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 311 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6960', 'Periodenfremde Aufwend.(soweit n.au?erordentlich', 'A', 'E', '', '6960', 0, NULL, 31, NULL, NULL, FALSE);
|
|
| 312 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6967', 'Betriebsfremde Aufwendungen soweit n.au?erord.', 'A', 'E', '', '6967', 0, NULL, 31, NULL, 24, FALSE);
|
|
| 313 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6970', 'Kalkulatorischer Unternehmerlohn', 'A', 'E', '', '6970', 0, NULL, 34, NULL, NULL, FALSE);
|
|
| 314 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6974', 'Kalkulatorische Zinsen', 'A', 'E', '', '6974', 0, NULL, 34, NULL, NULL, FALSE);
|
|
| 315 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6976', 'Kalkulatorische Aschreibungen', 'A', 'E', '', '6976', 0, NULL, 34, NULL, NULL, FALSE);
|
|
| 316 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6978', 'Kalkulatorische Wagnisse', 'A', 'E', '', '6978', 0, NULL, 34, NULL, NULL, FALSE);
|
|
| 317 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('6979', 'Kalkulatorischer Lohn f.unentgeltl.Mitarbeiter', 'A', 'E', '', '6979', 0, NULL, 34, NULL, NULL, FALSE);
|
|
| 318 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7000', 'Ertr?ge aus Beteiligungen', 'A', 'I', '', '7000', 0, NULL, 33, NULL, NULL, FALSE);
|
|
| 319 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7100', 'Sonstige Zinsen und ?nliche Ertr?ge', 'A', 'I', '', '7100', 0, NULL, 32, NULL, 4, FALSE);
|
|
| 320 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7120', 'Zins?hnliche Ertr?ge', 'A', 'I', '', '7120', 0, NULL, 32, NULL, 4, FALSE);
|
|
| 321 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7130', 'Diskontertr?ge', 'A', 'I', '', '7130', 0, NULL, 32, NULL, 4, FALSE);
|
|
| 322 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7300', 'Zinsen und ?hnl.Aufwendungen', 'A', 'E', '', '7300', 0, NULL, 30, NULL, 29, FALSE);
|
|
| 323 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7305', 'Zinsaufwendung-betriebliche Steuern ?223aAO', 'A', 'E', '', '7305', 0, NULL, 30, NULL, 29, FALSE);
|
|
| 324 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7310', 'Zinsaufwendung f. kurzf.Verbindlichk', 'A', 'E', '', '7310', 0, NULL, 30, NULL, 29, FALSE);
|
|
| 325 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7320', 'Zinsaufwendung f. langf.Verbindlichk', 'A', 'E', '', '7320', 0, NULL, 30, NULL, 29, FALSE);
|
|
| 326 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7325', 'Zinsaufwend.f.Geb?ude,die z.Betriebsverm?gen geh?ren', 'A', 'E', '', '7325', 0, NULL, NULL, NULL, 29, FALSE);
|
|
| 327 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7326', 'Zinsen zur Finanzierung Anlageverm?gen', 'A', 'E', '', '7326', 0, NULL, NULL, NULL, 29, FALSE);
|
|
| 328 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7330', 'Zins?hnliche Aufwendungen', 'A', 'E', '', '7330', 0, NULL, 30, NULL, 29, FALSE);
|
|
| 329 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7340', 'Diskontaufwendung', 'A', 'E', '', '7340', 0, NULL, 30, NULL, NULL, FALSE);
|
|
| 330 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7400', 'Au?erordentliche Ertr?ge', 'A', 'I', '', '7400', 0, NULL, 33, NULL, 5, FALSE);
|
|
| 331 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7401', 'Ausserordentliche Ertr?ge finanzwirksam', 'A', 'I', '', '7401', 0, NULL, NULL, NULL, 5, FALSE);
|
|
| 332 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7450', 'Ausserordentliche Ertr?ge nicht finanzwirksam', 'A', 'I', '', '7450', 0, NULL, NULL, NULL, 5, FALSE);
|
|
| 333 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7500', 'Au?erordentliche Aufwendung', 'A', 'E', '', '7500', 0, NULL, 31, NULL, 30, FALSE);
|
|
| 334 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7600', 'K?rperschaftssteuer', 'A', 'E', '', '7600', 0, NULL, 35, NULL, NULL, FALSE);
|
|
| 335 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7608', 'Solidarit?tszuschlag', 'A', 'E', '', '7608', 0, NULL, 35, NULL, NULL, FALSE);
|
|
| 336 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7609', 'Solidarit?tszuschlag f?r Vorjahr', 'A', 'E', '', '7609', 0, NULL, 19, NULL, NULL, FALSE);
|
|
| 337 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7610', 'Gewerbesteuer', 'A', 'E', '', '7610', 0, NULL, 12, NULL, 31, FALSE);
|
|
| 338 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7632', 'Kapitalertragssteuer 20%', 'A', 'E', '', '7632', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 339 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7634', 'Anrechenb.Soli auf Kapitalertragssteuer 20%', 'A', 'E', '', '7634', 0, NULL, 35, NULL, NULL, FALSE);
|
|
| 340 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7635', 'Zinsabschlagsteuer', 'A', 'E', '', '7635', 0, NULL, 35, NULL, NULL, FALSE);
|
|
| 341 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7638', 'Anrechb.Solidari.zuschlag a.Zinsabschlagst.', 'A', 'E', '', '7638', 0, NULL, 35, NULL, NULL, FALSE);
|
|
| 342 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7640', 'Stnachzahl.Vorj.v.Einkomm u.Ertrag', 'A', 'E', '', '7640', 0, NULL, 31, NULL, NULL, FALSE);
|
|
| 343 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7642', 'Sterstat.Vorj.Steuer v.Eink.u.Ertrag', 'A', 'I', '', '7642', 0, NULL, 33, NULL, NULL, FALSE);
|
|
| 344 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7644', 'Ertr.a.d.Aufl.v.R?cks.f.St.v.Ein.Er', 'A', 'I', '', '7644', 0, NULL, 33, NULL, NULL, FALSE);
|
|
| 345 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7650', 'Sonstige Betriebssteuern', 'A', 'E', '', '7650', 0, NULL, 12, NULL, 31, FALSE);
|
|
| 346 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7675', 'Verbrauchssteuer', 'A', 'E', '', '7675', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 347 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7678', '?kosteuer', 'A', 'E', '', '7678', 0, NULL, 12, NULL, NULL, FALSE);
|
|
| 348 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7685', 'Kfz-Steuer', 'A', 'E', 'AP_amount', '7685', 0, NULL, 19, NULL, 15, FALSE);
|
|
| 349 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7680', 'Grundsteuer', 'A', 'E', '', '7680', 0, NULL, 19, NULL, NULL, FALSE);
|
|
| 350 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7684', 'Grundsteuer f.Geb?ude,die nicht z.Betriebsverm?gen geh.', 'A', 'E', '', '7684', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 351 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7690', 'Steuernachzahlung Vorj.f.sons.Steue', 'A', 'E', '', '7690', 0, NULL, 31, NULL, NULL, FALSE);
|
|
| 352 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7692', 'Steuererstattung Vorj.f.sons.Steuer', 'A', 'I', '', '7692', 0, NULL, 33, NULL, NULL, FALSE);
|
|
| 353 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7694', 'Ertr?ge a.d.Aufl.v. R?ck.f.sons.Ste', 'A', 'E', '', '7694', 0, NULL, 31, NULL, NULL, FALSE);
|
|
| 354 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('7745', 'Entnahmen a.satzungsm??igen R?cklagen', 'A', 'E', '', '7745', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 355 |
|
|
| 356 |
|
|
| 357 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('9000', 'Saldenvortr?ge,Sachkonten', 'A', 'A', '', '9000', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 358 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('9008', 'Saldenvortr?ge,Debitoren', 'A', 'A', '', '9008', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 359 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('9009', 'Saldenvortr?ge,Kreditoren', 'A', 'L', '', '9009', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 360 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('9090', 'Summenvortragskonto', 'A', 'A', '', '9090', 0, NULL, NULL, NULL, NULL, FALSE);
|
|
| 361 |
|
|
| 362 |
|
|
| 363 |
|
|
| 364 |
|
|
| 365 |
INSERT INTO tax (rate, taxkey, taxdescription) values ('0','0','Keine Steuer');
|
|
| 366 |
INSERT INTO tax (rate, taxkey, taxdescription) values ('0','1','Umsatzsteuerfrei');
|
|
| 367 |
insert into tax VALUES ((select id from chart where accno = '3801'),'0.07','3801','2','Umsatzsteuer 7%'); |
|
| 368 |
INSERT INTO tax VALUES ((select id from chart where accno = '3805'),'0.16','3805','3','Umsatzsteuer 16%'); |
|
| 369 |
INSERT INTO tax VALUES ((select id from chart where accno = '1401'),'0.07','1401','8','Vorsteuer 7%'); |
|
| 370 |
insert into tax VALUES ((select id from chart where accno = '1405'),'0.16','1405','9','Vorsteuer 16%'); |
|
| 371 |
insert into tax (taxkey, taxdescription) values ('10','Im anderen EG-Staat steuerpfl. Lieferung');
|
|
| 372 |
insert into tax (taxkey, taxdescription) values ('11','Steuerfreie EG-Lief. an Abn. mit UStIdNr');
|
|
| 373 |
insert into tax (chart_id,rate,taxnumber, taxkey, taxdescription) values ((select id from chart where accno = '3802'),'0.07','3802','12','Steuerpflicht. EG-Lieferungen 7%'); |
|
| 374 |
insert into tax (chart_id,rate,taxnumber, taxkey, taxdescription) values ((select id from chart where accno = '3802'),'0.16','3803','13','Steuerpflicht. EG-Lieferungen 16%'); |
|
| 375 |
insert into tax (chart_id,rate,taxnumber, taxkey, taxdescription) values ((select id from chart where accno = '1402'),'0.07','1402','18','Steuerpflicht. EG-Erwerb 7%'); |
|
| 376 |
insert into tax (chart_id,rate,taxnumber, taxkey, taxdescription) values ((select id from chart where accno = '1402'),'0.16','1403','19','Steuerpflicht. EG-Erwerb 16%'); |
|
| 377 |
|
|
| 378 |
-- Ergaenzungen fuer 19% UmSt. ab 1.01.2007 |
|
| 379 |
insert into taxkeys (chart_id, tax_id, taxkey_id, pos_ustva, startdate) select chart.id, tax.id, taxkey_id, pos_ustva, '1970-01-01' from chart LEFT JOIN tax on (tax.taxkey=chart.taxkey_id) WHERE taxkey_id is not null; |
|
| 380 |
insert into taxkeys (chart_id, tax_id, taxkey_id,startdate) SELECT 0, id, taxkey, '1970-01-01' FROM tax; |
|
| 381 |
INSERT INTO chart (accno, description, charttype, category, link, taxkey_id, pos_ustva, pos_eur) |
|
| 382 |
VALUES ('3806','Umsatzsteuer 19 %', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax', 0, 511,6);
|
|
| 383 |
INSERT INTO chart (accno, description, charttype, category, link, taxkey_id, pos_ustva, pos_eur) |
|
| 384 |
VALUES ('1406','Abziehbare Vorsteuer 19 %', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', 0, 66,27);
|
|
| 385 |
INSERT INTO tax (chart_id, rate, taxnumber, taxkey, taxdescription) VALUES ((SELECT id from CHART WHERE accno='3806'), 0.19, '3806', 3, 'Umsatzsteuer 19%'); |
|
| 386 |
INSERT INTO tax (chart_id, rate, taxnumber, taxkey, taxdescription) VALUES ((SELECT id from CHART WHERE accno='1406'), 0.19, '1406', 9, 'Vorsteuer 19%'); |
|
| 387 |
insert into taxkeys (chart_id, tax_id, taxkey_id, pos_ustva, startdate) select chart.id, (SELECT id from tax where taxdescription='Umsatzsteuer 19%'), 3, pos_ustva, '2007-01-01' from chart WHERE taxkey_id=3; |
|
| 388 |
insert into taxkeys (chart_id, tax_id, taxkey_id, pos_ustva, startdate) select chart.id, (SELECT id from tax where taxdescription='Vorsteuer 19%'), 9, pos_ustva, '2007-01-01' from chart WHERE taxkey_id=9; |
|
| 389 |
|
|
| 390 |
-- Buchungsgruppen |
|
| 391 |
|
|
| 392 |
INSERT INTO buchungsgruppen |
|
| 393 |
(description, inventory_accno_id, |
|
| 394 |
income_accno_id_0, expense_accno_id_0, |
|
| 395 |
income_accno_id_1, expense_accno_id_1, |
|
| 396 |
income_accno_id_2, expense_accno_id_2, |
|
| 397 |
income_accno_id_3, expense_accno_id_3) |
|
| 398 |
VALUES |
|
| 399 |
('Standard 16%',
|
|
| 400 |
-- 1140: Bestand Waren |
|
| 401 |
(SELECT id FROM chart WHERE accno = '1140'), |
|
| 402 |
-- 4400: Erl?se 16% USt. |
|
| 403 |
-- 5400: Wareneingang 16% Vorsteuer |
|
| 404 |
(SELECT id FROM chart WHERE accno = '4400'), |
|
| 405 |
(SELECT id FROM chart WHERE accno = '5400'), |
|
| 406 |
-- 4125: Steuerfrei innergem. Lieferungen ?41bUStG |
|
| 407 |
-- 5550: Steuerfreier innergem.Erwerb |
|
| 408 |
(SELECT id FROM chart WHERE accno = '4125'), |
|
| 409 |
(SELECT id FROM chart WHERE accno = '5550'), |
|
| 410 |
-- 4315: Erl?s Inland stpfl.EG-Lieferung 16% |
|
| 411 |
-- 5425: Innergem.Erwerb 16% VorSt u. Ust |
|
| 412 |
(SELECT id FROM chart WHERE accno = '4315'), |
|
| 413 |
(SELECT id FROM chart WHERE accno = '5425'), |
|
| 414 |
-- 4150: Sonstige steuerfreie Ums?tze ?42-7UStG |
|
| 415 |
-- 5559: Steuerfreie Einfuhren |
|
| 416 |
(SELECT id FROM chart WHERE accno = '4150'), |
|
| 417 |
(SELECT id FROM chart WHERE accno = '5559')); |
|
| 418 |
|
|
| 419 |
INSERT INTO buchungsgruppen |
|
| 420 |
(description, inventory_accno_id, |
|
| 421 |
income_accno_id_0, expense_accno_id_0, |
|
| 422 |
income_accno_id_1, expense_accno_id_1, |
|
| 423 |
income_accno_id_2, expense_accno_id_2, |
|
| 424 |
income_accno_id_3, expense_accno_id_3) |
|
| 425 |
VALUES |
|
| 426 |
('Standard 7%',
|
|
| 427 |
-- 1140: Bestand Waren |
|
| 428 |
(SELECT id FROM chart WHERE accno = '1140'), |
|
| 429 |
-- 4300: Erl?se 7%USt |
|
| 430 |
-- 5300: Wareneingang 7% Vorsteuer |
|
| 431 |
(SELECT id FROM chart WHERE accno = '4300'), |
|
| 432 |
(SELECT id FROM chart WHERE accno = '5300'), |
|
| 433 |
-- 4125: Steuerfrei innergem. Lieferungen ?41bUStG |
|
| 434 |
-- 5550: Steuerfreier innergem.Erwerb |
|
| 435 |
(SELECT id FROM chart WHERE accno = '4125'), |
|
| 436 |
(SELECT id FROM chart WHERE accno = '5550'), |
|
| 437 |
-- 4310: Erl?se Inland stpfl. EG-Lieferung7% |
|
| 438 |
-- 5420: Innergemein.Erwerb 7% VorSt u. Ust |
|
| 439 |
(SELECT id FROM chart WHERE accno = '4310'), |
|
| 440 |
(SELECT id FROM chart WHERE accno = '5420'), |
|
| 441 |
-- 4150: Sonstige steuerfreie Ums?tze ?42-7UStG |
|
| 442 |
-- 5559; Steuerfreie Einfuhren |
|
| 443 |
(SELECT id FROM chart WHERE accno = '4150'), |
|
| 444 |
(SELECT id FROM chart WHERE accno = '5559')); |
|
Auch abrufbar als: Unified diff
DOS style newlines in Unix style newlines umgewandelt