Revision 3774d83b
Von Moritz Bunkus vor mehr als 11 Jahren hinzugefügt
| sql/Swiss-German-chart.sql | ||
|---|---|---|
| 2 | 2 |
-- adapted to numeric representation of chart no. |
| 3 | 3 |
-- contributed by Martin Krung |
| 4 | 4 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('10000','AKTIVEN','H','1','A','');
|
| 5 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11000','UMLAUFSVERM?GEN','H','10000','A','');
|
|
| 6 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11100','Fl?ssige Mittel','H','11000','A','');
|
|
| 5 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11000','UMLAUFSVERMÖGEN','H','10000','A','');
|
|
| 6 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11100','Flüssige Mittel','H','11000','A','');
|
|
| 7 | 7 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11102','Bank CS Kt. 177929-11','A','11100','A','AR_paid:AP_paid');
|
| 8 | 8 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11110','Forderungen','H','11000','A','');
|
| 9 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11120','Vorr?te und angefangene Arbeiten','H','11000','A','');
|
|
| 9 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11120','Vorräte und angefangene Arbeiten','H','11000','A','');
|
|
| 10 | 10 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11128','Angefangene Arbeiten','A','11120','A','');
|
| 11 | 11 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11130','Aktive Rechnungsabgrenzung','A','11000','A','');
|
| 12 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('14000','ANLAGEVERM?GEN','H','10000','A','');
|
|
| 12 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('14000','ANLAGEVERMÖGEN','H','10000','A','');
|
|
| 13 | 13 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('18000','AKTIVIERTER AUFWAND UND AKTIVE BERICHTIGUNGSPOSTEN','H','10000','A','');
|
| 14 | 14 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('18182','Entwicklungsaufwand','A','18000','A','');
|
| 15 | 15 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('20000','PASSIVEN','H','2','L','');
|
| ... | ... | |
| 22 | 22 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21210','Kurzfristige Finanzverbindlichkeiten','H','21000','L','');
|
| 23 | 23 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21220','Andere kurzfristige Verbindlichkeiten','H','21000','L','');
|
| 24 | 24 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21222','MWST (3,6)','A','21220','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
|
| 25 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21229','Gewinnaussch?ttung','A','21220','L','');
|
|
| 26 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21230','Passive Rechnungsabgrenzung, kurzfristige R?ckstellungen','H','21000','L','');
|
|
| 27 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21235','R?ckstellungen','A','21230','L','');
|
|
| 25 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21229','Gewinnausschüttung','A','21220','L','');
|
|
| 26 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21230','Passive Rechnungsabgrenzung, kurzfristige Rückstellungen','H','21000','L','');
|
|
| 27 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21235','Rückstellungen','A','21230','L','');
|
|
| 28 | 28 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('24000','FREMDKAPITAL LANGFRISTIG','H','20000','L','');
|
| 29 | 29 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('24256','Gesellschafter','A','24000','L','');
|
| 30 | 30 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('28000','EIGENKAPITAL','H','20000','Q','');
|
| ... | ... | |
| 36 | 36 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('30000','BETRIEBSERTRAG AUS LIEFERUNGEN UND LEISTUNGEN','H','30000','I','');
|
| 37 | 37 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('31000','PRODUKTIONSERTRAG','H','30000','I','');
|
| 38 | 38 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('31001','Computer','A','31000','I','AR_amount:IC_sale');
|
| 39 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('31005','?brige Produkte','A','31000','I','AR_amount:IC_sale');
|
|
| 39 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('31005','Übrige Produkte','A','31000','I','AR_amount:IC_sale');
|
|
| 40 | 40 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('32000','HANDELSERTRAG','H','30000','I','');
|
| 41 | 41 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('32001','Hardware','A','32000','I','AR_amount:IC_sale');
|
| 42 | 42 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('32002','Software OSS','A','32000','I','AR_amount:IC_sale');
|
| 43 | 43 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('32003','Software kommerz.','A','32000','I','AR_amount:IC_sale');
|
| 44 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('32005','?brige','A','32000','I','AR_amount:IC_sale');
|
|
| 44 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('32005','Übrige','A','32000','I','AR_amount:IC_sale');
|
|
| 45 | 45 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('34000','DIENSTLEISTUNGSERTRAG','H','30000','I','');
|
| 46 | 46 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('34001','Beratung','A','34000','I','AR_amount:IC_income');
|
| 47 | 47 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('34002','Installation','A','34000','I','AR_amount:IC_income');
|
| 48 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('36000','?BRIGER ERTRAG','H','30000','I','');
|
|
| 48 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('36000','ÜBRIGER ERTRAG','H','30000','I','');
|
|
| 49 | 49 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('37000','EIGENLEISTUNGEN UND EIGENVERBRAUCH','H','30000','I','');
|
| 50 | 50 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('37001','Eigenleistungen','A','37000','I','');
|
| 51 | 51 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('37002','Eigenverbrauch','A','37000','I','');
|
| 52 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('38000','BESTANDES?NDERUNGEN ANGEFANGENE UND FERTIGGESTELLTE ARBEITUNG AUS PRODUKTION UND DIENSTLEISTUNG','H','30000','I','');
|
|
| 53 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('38001','Bestandes?nderungen','A','38000','I','');
|
|
| 54 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('39000','ERTRAGSMINDERUNGEN AUS PRODUKTIONS-, HANDELS- UND DIENSTLEISTUNGSERTR?GEN','H','30000','I','');
|
|
| 55 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('40000','AUFWAND F?R MATERIAL, WAREN UND DIENSTLEISTUNGEN','H','40000','E','');
|
|
| 52 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('38000','BESTANDESÄNDERUNGEN ANGEFANGENE UND FERTIGGESTELLTE ARBEITUNG AUS PRODUKTION UND DIENSTLEISTUNG','H','30000','I','');
|
|
| 53 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('38001','Bestandesänderungen','A','38000','I','');
|
|
| 54 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('39000','ERTRAGSMINDERUNGEN AUS PRODUKTIONS-, HANDELS- UND DIENSTLEISTUNGSERTRÄGEN','H','30000','I','');
|
|
| 55 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('40000','AUFWAND FÜR MATERIAL, WAREN UND DIENSTLEISTUNGEN','H','40000','E','');
|
|
| 56 | 56 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('41000','MATERIALAUFWAND','H','40000','E','');
|
| 57 | 57 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('41001','Computer','A','41000','E','AP_amount:IC_cogs');
|
| 58 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('41005','?brige Produkte','A','41000','E','AP_amount:IC_cogs');
|
|
| 58 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('41005','Übrige Produkte','A','41000','E','AP_amount:IC_cogs');
|
|
| 59 | 59 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('42000','HANDELSWARENAUFWAND','H','40000','E','');
|
| 60 | 60 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('42001','Hardware','A','42000','E','AP_amount:IC_cogs');
|
| 61 | 61 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('42002','Software OSS','A','32000','I','AP_amount:IC_cogs');
|
| 62 | 62 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('42003','Software kommerz.','A','42000','I','AP_amount:IC_cogs');
|
| 63 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('42005','?brige','A','42000','E','AP_amount:IC_cogs');
|
|
| 64 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('44000','AUFWAND F?R DRITTLEISTUNGEN','H','40000','E','');
|
|
| 65 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('46000','?BRIGER AUFWAND','H','40000','E','');
|
|
| 63 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('42005','Übrige','A','42000','E','AP_amount:IC_cogs');
|
|
| 64 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('44000','AUFWAND FÜR DRITTLEISTUNGEN','H','40000','E','');
|
|
| 65 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('46000','ÜBRIGER AUFWAND','H','40000','E','');
|
|
| 66 | 66 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('47000','DIREKTE EINKAUFSSPESEN','H','40000','E','');
|
| 67 | 67 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('47001','Einkaufsspesen','A','47000','E','AP_amount:IC_expense');
|
| 68 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('48000','BESTANDESVER?NDERUNGEN, MATERIAL- UND WARENVERLUSTE','H','40000','E','');
|
|
| 69 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('48001','Bestandes?nderungen','A','48000','E','');
|
|
| 68 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('48000','BESTANDESVERÄNDERUNGEN, MATERIAL- UND WARENVERLUSTE','H','40000','E','');
|
|
| 69 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('48001','Bestandesänderungen','A','48000','E','');
|
|
| 70 | 70 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('49000','AUFWANDMINDERUNGEN','H','40000','E','');
|
| 71 | 71 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('49005','Aufwandminderungen','A','49000','E','AP_amount:IC_expense');
|
| 72 | 72 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('50000','PERSONALAUFWAND','H','50000','E','');
|
| 73 | 73 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('57000','SOZIALVERSICHERUNGSAUFWAND','H','50000','E','');
|
| 74 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('58000','?BRIGER PERSONALAUFWAND','H','58000','A','');
|
|
| 74 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('58000','ÜBRIGER PERSONALAUFWAND','H','58000','A','');
|
|
| 75 | 75 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('58005','Sonstiger Personalaufwand','A','58000','E','');
|
| 76 | 76 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('59000','ARBEITSLEISTUNGEN DRITTER','H','50000','E','');
|
| 77 | 77 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('60000','SONSTIGER BETRIEBSAUFWAND','H','60000','E','');
|
| ... | ... | |
| 80 | 80 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('61901','Unterhalt','A','61900','E','AP_amount');
|
| 81 | 81 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('62000','FAHRZEUG- UND TRANSPORTAUFWAND','H','60000','E','');
|
| 82 | 82 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('62002','Transportaufwand','A','62000','E','AP_amount');
|
| 83 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('63000','SACHVERSICHERUNGEN, ABGABEN, GEB?HREN, BEWILLIGUNGEN','H','60000','E','');
|
|
| 83 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('63000','SACHVERSICHERUNGEN, ABGABEN, GEBÜHREN, BEWILLIGUNGEN','H','60000','E','');
|
|
| 84 | 84 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('65000','VERWALTUNGS- UND INFORMATIKAUFWAND','H','60000','E','');
|
| 85 | 85 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('66000','WERBEAUFWAND','H','60000','E','');
|
| 86 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('67000','?BRIGER BETRIEBSAUFWAND','H','60000','E','');
|
|
| 87 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('67001','?briger Betriebsaufwand','A','67000','E','');
|
|
| 86 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('67000','ÜBRIGER BETRIEBSAUFWAND','H','60000','E','');
|
|
| 87 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('67001','Übriger Betriebsaufwand','A','67000','E','');
|
|
| 88 | 88 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('68000','FINANZERFOLG','H','60000','E','');
|
| 89 | 89 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('68001','Finanzaufwand','A','68000','E','');
|
| 90 | 90 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('68002','Bankspesen','A','68000','E','');
|
| ... | ... | |
| 101 | 101 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('92000','BILANZ','H','92000','A','');
|
| 102 | 102 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('93000','GEWINNVERWENDUNG','H','93000','A','');
|
| 103 | 103 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('99000','SAMMEL- UND FEHLBUCHUNGEN','H','99000','A','');
|
| 104 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11121','Warenvorr?te','A','11120','A','IC');
|
|
| 105 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('44001','Aufwand f?r Drittleistungen','A','44000','E','AP_amount:IC_expense');
|
|
| 104 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11121','Warenvorräte','A','11120','A','IC');
|
|
| 105 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('44001','Aufwand für Drittleistungen','A','44000','E','AP_amount:IC_expense');
|
|
| 106 | 106 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('63001','Betriebsversicherungen','A','63000','E','AP_amount:IC_expense');
|
| 107 | 107 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('57004','Unfallversicherung','A','57000','E','AP_amount:IC_expense');
|
| 108 | 108 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('57005','Krankentaggeldversicherung','A','57000','E','AP_amount:IC_expense');
|
| 109 | 109 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('57003','Berufliche Vorsorge','A','57000','E','AP_amount:IC_expense');
|
| 110 | 110 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('57002','FAK','A','57000','E','AP_amount:IC_income:IC_expense');
|
| 111 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('65009','?briger Verwaltungsaufwand','A','65000','E','AP_amount:IC_expense');
|
|
| 111 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('65009','Übriger Verwaltungsaufwand','A','65000','E','AP_amount:IC_expense');
|
|
| 112 | 112 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('65003','Porti','A','65000','E','AP_amount:IC_expense');
|
| 113 | 113 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('65002','Telekomm','A','65000','E','AP_amount:IC_expense');
|
| 114 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('65001','B?romaterial','A','65000','E','AP_amount:IC_expense');
|
|
| 115 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('18181','Gr?ndungsaufwand','A','18000','A','IC_expense');
|
|
| 116 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('50001','L?hne und Geh?lter','A','50000','E','IC_expense');
|
|
| 114 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('65001','Büromaterial','A','65000','E','AP_amount:IC_expense');
|
|
| 115 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('18181','Gründungsaufwand','A','18000','A','IC_expense');
|
|
| 116 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('50001','Löhne und Gehälter','A','50000','E','IC_expense');
|
|
| 117 | 117 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('50002','Erfolgsbeteiligungen','A','50000','E','IC_expense');
|
| 118 | 118 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21216','Gesellschafter','A','21210','L','AP');
|
| 119 | 119 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('62001','Fahrzeugaufwand','A','62000','E','AP_amount:IC_expense');
|
| 120 | 120 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('58003','Spesen','A','58000','E','IC_expense');
|
| 121 | 121 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('65004','Fachliteratur','A','65000','E','AP_amount:IC_expense');
|
| 122 | 122 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('39001','Skonti','A','39000','I','IC_sale:IC_cogs:IC_income:IC_expense');
|
| 123 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('39002','Rabatte, Preisnachl?sse','A','39000','I','IC_sale:IC_cogs:IC_income:IC_expense');
|
|
| 123 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('39002','Rabatte, Preisnachlässe','A','39000','I','IC_sale:IC_cogs:IC_income:IC_expense');
|
|
| 124 | 124 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('36005','Kursgewinn','A','39000','I','IC_sale:IC_cogs:IC_income');
|
| 125 | 125 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('39006','Kursverlust','A','39000','E','IC_sale:IC_cogs:IC_expense');
|
| 126 | 126 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('39005','Verluste aus Forderungen','A','39000','E','IC_sale:IC_cogs:IC_expense');
|
| 127 | 127 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('14151','Mobiliar und Einrichtungen','A','14150','A','IC');
|
| 128 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('14152','B?romaschinen, EDV','A','14150','A','IC');
|
|
| 128 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('14152','Büromaschinen, EDV','A','14150','A','IC');
|
|
| 129 | 129 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11119','Verrechnungssteuer','A','11110','A','');
|
| 130 | 130 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11118','MWST Vorsteuer auf Investitionen','A','11110','A','');
|
| 131 | 131 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('36004','Versand','A','36000','I','IC_income');
|
| ... | ... | |
| 146 | 146 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11111','Debitoren','A','11110','A','AR');
|
| 147 | 147 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('61001','Miete','A','61000','E','IC_expense');
|
| 148 | 148 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('61002','Reinigung','A','61000','E','IC_expense');
|
| 149 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('61005','?briger Raumaufwand','A','61000','E','IC_expense');
|
|
| 149 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('61005','Übriger Raumaufwand','A','61000','E','IC_expense');
|
|
| 150 | 150 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('36003','Essen','A','36000','I','IC_income');
|
| 151 | 151 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21231','Passive Rechnungsabgrenzung','A','21230','L','');
|
| 152 | 152 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('67002','Produkteentwicklung','A','67000','E','');
|
Auch abrufbar als: Unified diff
Alle ISO-8859-15-codierten Files nach UTF-8 encodieren