projects / kivitendo-erp.git / blobdiff
? search:
summary | shortlog | log | commit | commitdiff | tree
raw | inline | side by side
Consolidation and extended test runs
[kivitendo-erp.git] / sql / Switzerland-deutsch-keineMWST-chart.sql
diff --git a/sql/Switzerland-deutsch-keineMWST-chart.sql b/sql/Switzerland-deutsch-keineMWST-chart.sql
deleted file mode 100644 (file)
index 4dd3751..0000000
--- a/sql/Switzerland-deutsch-keineMWST-chart.sql
+++ /dev/null
@@ -1,329 +0,0 @@
--- deutschsprachiger KMU-Kontenplan nach Sterchi für Firmen in der Schweiz, die nicht mehrwertsteuerpflichtig sind
--- Erstellt am 24.7.2013
--- Redaktion: Andreas Rudin, http://www.revamp-it.ch
-
-
-
-INSERT INTO buchungsgruppen (id, description, inventory_accno_id, income_accno_id_0, expense_accno_id_0, income_accno_id_1, expense_accno_id_1, income_accno_id_2, expense_accno_id_2, income_accno_id_3, expense_accno_id_3) VALUES
-(1,'Standard',13,50,67,50,67,50,67,50,67);
-
-
-INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik, itime, mtime, new_chart_id, valid_from) VALUES
-(1,1,'AKTIVEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(2,10,'UMLAUFSVERMÖGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(3,100,'Flüssige Mittel','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(4,1000,'Kasse','A','A','AR_paid:AP_paid',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(5,1010,'Post','A','A','AR_paid:AP_paid',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(6,1020,'Bank','A','A','AR_paid:AP_paid',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(7,110,'Forderungen','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(8,1100,'Debitoren','A','A','AR',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(9,1170,'Vorsteuer auf Aufwand','A','A','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(10,1171,'Vorsteuer auf Investitionen','A','A','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(11,1176,'Guthaben aus Verrechnungssteuer','A','A','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(12,120,'Vorräte und angefangene Arbeiten','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(13,1200,'Warenvorräte','A','A','IC',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(14,1280,'Angefangene Arbeiten','A','A','IC',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(15,130,'Aktive Rechnungsabgrenzung','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(16,1300,'Aktive Rechnungsabgrenzung','A','A','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(17,14,'ANLAGEVERMÖGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(18,1450,'Mobiliar und Einrichtungen','A','A','IC',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(19,1460,'Büromaschinen, EDV','A','A','IC',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(20,180,'AKTIVIERTER AUFWAND UND AKTIVE BERICHTIGUNGSPOSTEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(21,1800,'Gründungsaufwand','A','A','IC_expense',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(22,1801,'Entwicklungsaufwand','A','A','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(23,2,'PASSIVEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(24,20,'FREMDKAPITAL KURZFRISTIG','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(25,200,'Kurzfristige Verbindlichkeiten aus Lieferungen und Leistungen','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(26,2000,'Lieferanten','A','L','AP',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(27,210,'Kurzfristige Finanzverbindlichkeiten','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(28,2101,'Personalaufwand','A','L','AP',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(29,2102,'Sozialversicherungen','A','L','AP',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(30,2105,'Leasing','A','L','AP',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(31,2110,'Gesellschafter','A','L','AP',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(32,2111,'Privat','A','L','AP',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(33,220,'Andere kurzfristige Verbindlichkeiten','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(34,2200,'MWST(2,5)','A','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice:CT_tax',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(35,2201,'MWST(8,0)','A','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice:CT_tax',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(36,2210,'Geschuldete Steuern','A','L','AP',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(37,230,'Passive Rechnungsabgrenzung, kurzfristige Rückstellungen','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(38,2300,'Passive Rechnungsabgrenzung','A','L','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(39,2330,'Rückstellungen','A','L','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(40,24,'FREMDKAPITAL LANGFRISTIG','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(41,2400,'Gesellschafter','A','L','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(42,28,'EIGENKAPITAL','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(43,2800,'Stammkapital','A','Q','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(44,290,'Reserven, Bilanzgewinn','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(45,2900,'Reserven','A','Q','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(46,2990,'Gewinnvortrag','A','Q','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(47,2991,'Jahresgewinn','A','Q','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(48,3,'BETRIEBSERTRAG AUS LIEFERUNGEN UND LEISTUNGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(49,30,'PRODUKTIONSERTRAG','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(50,3000,'Ertrag Produktion','A','I','AR_amount:IC_sale',NULL,0,NULL,NULL,NULL,1,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(51,32,'HANDELSERTRAG','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(52,3200,'Ertrag Handel','A','I','AR_amount:IC_sale',NULL,0,NULL,NULL,NULL,1,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(53,34,'DIENSTLEISTUNGSERTRAG','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(54,3400,'Ertrag Dienstleistung','A','I','AR_amount:IC_income',NULL,0,NULL,NULL,NULL,1,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(55,36,'ÜBRIGER ERTRAG','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(56,3600,'diverser Ertrag','A','I','IC_income',NULL,0,NULL,NULL,NULL,2,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(57,37,'EIGENLEISTUNGEN UND EIGENVERBRAUCH','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(58,3700,'Eigenleistungen','A','I','',NULL,0,NULL,NULL,NULL,2,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(59,38,'BESTANDESÄNDERUNGEN ANGEFANGENE UND FERTIGGESTELLTE ARBEITEN AUS PRODUKTION UND DIENSTLEISTUNG','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(60,3800,'Bestandesänderungen','A','I','',NULL,0,NULL,NULL,NULL,2,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(61,39,'ERTRAGSMINDERUNGEN AUS PRODUKTIONS-, HANDELS- UND DIENSTLEISTUNGSERTRÄGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(62,3900,'Skonti','A','E','IC_sale:IC_cogs:IC_income:IC_expense',NULL,0,NULL,NULL,NULL,1,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(63,3901,'Rabatte, Preisnachlässe','A','E','IC_sale:IC_cogs:IC_income:IC_expense',NULL,0,NULL,NULL,NULL,1,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(64,3905,'Verluste aus Forderungen','A','E','IC_sale:IC_cogs:IC_income:IC_expense',NULL,0,NULL,NULL,NULL,1,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(65,4,'AUFWAND FÜR MATERIAL, WAREN UND DIENSTLEISTUNGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(66,40,'MATERIALAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(67,4000,'Materialeinkauf','A','E','AP_amount:IC_cogs',NULL,0,NULL,NULL,NULL,8,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(68,42,'HANDELSWARENAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(69,4200,'Einkauf Handelswaren','A','E','AP_amount:IC_cogs',NULL,0,NULL,NULL,NULL,8,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(70,4208,'Bestandsänderungen Handelswaren','A','E','AP_amount:IC_cogs',NULL,0,NULL,NULL,NULL,8,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(71,44,'AUFWAND FÜR DRITTLEISTUNGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(72,4400,'Aufwand für Drittleistungen','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,8,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(73,46,'ÜBRIGER AUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(74,47,'DIREKTE EINKAUFSSPESEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(75,4700,'Einkaufsspesen','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,8, 'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(76,48,'BESTANDESVERÄNDERUNGEN, MATERIAL- UND WARENVERLUSTE','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(77,4800,'Bestandesänderungen','A','E','',NULL,0,NULL,NULL,NULL,8,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(78,49,'AUFWANDMINDERUNGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(79,4900,'Skonti, Rabatte, Preisnachlässe','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,8,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(80,5,'PERSONALAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(81,5000,'Löhne und Gehälter','A','E','IC_expense',NULL,0,NULL,NULL,NULL,9,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(82,5001,'Erfolgsbeteiligungen','A','E','IC_expense',NULL,0,NULL,NULL,NULL,9,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(83,5005,'Leistungen von Sozialversicherung','A','I','IC_income',NULL,0,NULL,NULL,NULL,9,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(84,507,'SOZIALVERSICHERUNGSAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(85,5070,'AHV, IV, EO, ALV','A','E','AP_amount:IC_income:IC_expense',NULL,0,NULL,NULL,NULL,10,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(86,5071,'FAK','A','E','AP_amount:IC_income:IC_expense',NULL,0,NULL,NULL,NULL,10,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(87,5072,'Berufliche Vorsorge','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,10,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(88,5073,'Unfallversicherung','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,10,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(89,5074,'Krankentaggeldversicherung','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,10,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(90,508,'ÜBRIGER PERSONALAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(91,5083,'Spesen','A','E','IC_expense',NULL,0,NULL,NULL,NULL,9,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(92,5089,'Sonstiger Personalaufwand','A','E','IC_expense',NULL,0,NULL,NULL,NULL,9,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(93,509,'ARBEITSLEISTUNGEN DRITTER','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(94,6,'ÜBRIGER BETRIEBSAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(95,600,'RAUMAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(96,6000,'Miete','A','E','IC_expense',NULL,0,NULL,NULL,NULL,11,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(97,6040,'Reinigung','A','E','IC_expense',NULL,0,NULL,NULL,NULL,11,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(98,6050,'Übriger Raumaufwand','A','E','IC_expense',NULL,0,NULL,NULL,NULL,11,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(99,610,'UNTERHALT, REPARATUREN, ERSATZ, LEASINGAUFWAND MOBILE SACHANLAGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(100,6100,'Unterhalt','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,13,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(101,620,'FAHRZEUG- UND TRANSPORTAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(102,6200,'Fahrzeugaufwand','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,17,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(103,6201,'Transportaufwand','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,17,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(104,630,'SACHVERSICHERUNGEN, ABGABEN, GEBÜHREN, BEWILLIGUNGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(105,6300,'Betriebsversicherungen','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,14,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(106,650,'VERWALTUNGS- UND INFORMATIKAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(107,6500,'Büromaterial','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,23,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(108,6510,'Telefon, Fax, Internet','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,23,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(109,6520,'Porti','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,23,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(110,6530,'Fachliteratur','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,20,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(111,6540,'Informatikaufwand','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,23,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(112,6590,'Übriger Verwaltungsaufwand','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,24,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(113,660,'WERBEAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(114,6600,'Werbeaufwand','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,18,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(115,670,'ÜBRIGER BETRIEBSAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(116,6750,'Übriger Betriebsaufwand','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,24,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(117,680,'FINANZAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(118,6800,'Finanzaufwand','A','E','',NULL,0,NULL,NULL,NULL,29,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(119,685,'FINANZERTRAG','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(120,6850,'Finanzertrag','A','I','',NULL,0,NULL,NULL,NULL,4,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(121,690,'ABSCHREIBUNGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(122,6900,'Abschreibungen','A','E','',NULL,0,NULL,NULL,NULL,25,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(123,8,'AUSSERORDENTLICHER UND BETRIEBSFREMDER ERFOLG, STEUERN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(124,8000,'Ausserordentlicher Ertrag','A','I','',NULL,0,NULL,NULL,NULL,5,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(125,8100,'Ausserordentlicher Aufwand','A','E','',NULL,0,NULL,NULL,NULL,30,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(126,89,'STEUERAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(127,8900,'Steuern','A','E','',NULL,0,NULL,NULL,NULL,31,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(128,9,'ABSCHLUSS','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(129,90,'ERFOLGSRECHNUNG','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(130,92,'BILANZ','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(131,9200,'Eröffnungsbilanz','A','E','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(132,93,'GEWINNVERWENDUNG','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(133,95,'JAHRESERGEBNISSE','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL),
-(134,99,'SAMMEL- UND FEHLBUCHUNGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2013-01-01 00:00:00.000000',NULL,NULL,NULL);
-
-
-DELETE FROM defaults;
-
-INSERT INTO defaults (inventory_accno_id, income_accno_id, expense_accno_id, fxgain_accno_id, fxloss_accno_id, invnumber, sonumber, weightunit, businessnumber, version, curr, closedto, revtrans, ponumber, sqnumber, rfqnumber, customernumber, vendornumber, audittrail, articlenumber, servicenumber, coa, itime, mtime, rmanumber, cnnumber, accounting_method, inventory_system, profit_determination) VALUES
-(13,50,67,120,118,0,0,'kg','','3.0.0','CHF:EUR',NULL,'f',0,0,0,0,0,'f',0,0,'Switzerland-deutsch-keineMWST','2013-01-01 00:00:00.000000',NULL,0,0,'accrual','periodic','balance');
-
-INSERT INTO tax (rate, taxkey, taxdescription, itime, mtime, id) VALUES
-(0,0,'Keine Steuer','2013-01-01 00:00:00.000000',NULL,0),
-(0,1,'mehrwertsteuerfrei','2013-01-01 00:00:00.000000',NULL,1);
-
-INSERT INTO tax (chart_id, rate, taxnumber, taxkey, taxdescription, itime, mtime, id) VALUES
-(35,0.08000,2201,2,'MWST 8% Verkauf','2013-01-01 00:00:00.000000',NULL,2),
-(34,0.02500,2200,3,'MWST 2.5% Verkauf','2013-01-01 00:00:00.000000',NULL,3),
-(9,0.08000,1170,4,'MWST 8% Aufwand','2013-01-01 00:00:00.000000',NULL,4),
-(9,0.02500,1170,5,'MWST 2.5% Aufwand','2013-01-01 00:00:00.000000',NULL,5),
-(10,0.08000,1171,6,'MWST 8% Investitionen','2013-01-01 00:00:00.000000',NULL,6),
-(10,0.02500,1171,7,'MWST 2.5% Investitionen','2013-01-01 00:00:00.000000',NULL,7);
-
-
-DELETE FROM tax_zones;
-
-INSERT INTO tax_zones (id, description) VALUES
-(0,'Inland'),
-(1,'EU mit USt-ID Nummer'),
-(2,'EU ohne USt-ID Nummer'),
-(3,'Ausserhalb EU');
-
-
-INSERT INTO taxkeys (id, chart_id, tax_id, taxkey_id, pos_ustva, startdate) VALUES
-(1,1,0,0,NULL,'2013-01-01'),
-(2,2,0,0,NULL,'2013-01-01'),
-(3,3,0,0,NULL,'2013-01-01'),
-(4,4,0,0,NULL,'2013-01-01'),
-(5,5,0,0,NULL,'2013-01-01'),
-(6,6,0,0,NULL,'2013-01-01'),
-(7,7,0,0,NULL,'2013-01-01'),
-(8,8,0,0,NULL,'2013-01-01'),
-(9,9,0,0,NULL,'2013-01-01'),
-(10,10,0,0,NULL,'2013-01-01'),
-(11,11,0,0,NULL,'2013-01-01'),
-(12,12,0,0,NULL,'2013-01-01'),
-(13,13,0,0,NULL,'2013-01-01'),
-(14,14,0,0,NULL,'2013-01-01'),
-(15,15,0,0,NULL,'2013-01-01'),
-(16,16,0,0,NULL,'2013-01-01'),
-(17,17,0,0,NULL,'2013-01-01'),
-(18,18,0,0,NULL,'2013-01-01'),
-(19,19,0,0,NULL,'2013-01-01'),
-(20,20,0,0,NULL,'2013-01-01'),
-(21,21,0,0,NULL,'2013-01-01'),
-(22,22,0,0,NULL,'2013-01-01'),
-(23,23,0,0,NULL,'2013-01-01'),
-(24,24,0,0,NULL,'2013-01-01'),
-(25,25,0,0,NULL,'2013-01-01'),
-(26,26,0,0,NULL,'2013-01-01'),
-(27,27,0,0,NULL,'2013-01-01'),
-(28,28,0,0,NULL,'2013-01-01'),
-(29,29,0,0,NULL,'2013-01-01'),
-(30,30,0,0,NULL,'2013-01-01'),
-(31,31,0,0,NULL,'2013-01-01'),
-(32,32,0,0,NULL,'2013-01-01'),
-(33,33,0,0,NULL,'2013-01-01'),
-(34,34,0,0,NULL,'2013-01-01'),
-(35,35,0,0,NULL,'2013-01-01'),
-(36,36,0,0,NULL,'2013-01-01'),
-(37,37,0,0,NULL,'2013-01-01'),
-(38,38,0,0,NULL,'2013-01-01'),
-(39,39,0,0,NULL,'2013-01-01'),
-(40,40,0,0,NULL,'2013-01-01'),
-(41,41,0,0,NULL,'2013-01-01'),
-(42,42,0,0,NULL,'2013-01-01'),
-(43,43,0,0,NULL,'2013-01-01'),
-(44,44,0,0,NULL,'2013-01-01'),
-(45,45,0,0,NULL,'2013-01-01'),
-(46,46,0,0,NULL,'2013-01-01'),
-(47,47,0,0,NULL,'2013-01-01'),
-(48,48,0,0,NULL,'2013-01-01'),
-(49,49,0,0,NULL,'2013-01-01'),
-(50,50,0,0,NULL,'2013-01-01'),
-(51,51,0,0,NULL,'2013-01-01'),
-(52,52,0,0,NULL,'2013-01-01'),
-(53,53,0,0,NULL,'2013-01-01'),
-(54,54,0,0,NULL,'2013-01-01'),
-(55,55,0,0,NULL,'2013-01-01'),
-(56,56,0,0,NULL,'2013-01-01'),
-(57,57,0,0,NULL,'2013-01-01'),
-(58,58,0,0,NULL,'2013-01-01'),
-(59,59,0,0,NULL,'2013-01-01'),
-(60,60,0,0,NULL,'2013-01-01'),
-(61,61,0,0,NULL,'2013-01-01'),
-(62,62,0,0,NULL,'2013-01-01'),
-(63,63,0,0,NULL,'2013-01-01'),
-(64,64,0,0,NULL,'2013-01-01'),
-(65,65,0,0,NULL,'2013-01-01'),
-(66,66,0,0,NULL,'2013-01-01'),
-(67,67,0,0,NULL,'2013-01-01'),
-(68,68,0,0,NULL,'2013-01-01'),
-(69,69,0,0,NULL,'2013-01-01'),
-(70,70,0,0,NULL,'2013-01-01'),
-(71,71,0,0,NULL,'2013-01-01'),
-(72,72,0,0,NULL,'2013-01-01'),
-(73,73,0,0,NULL,'2013-01-01'),
-(74,74,0,0,NULL,'2013-01-01'),
-(75,75,0,0,NULL,'2013-01-01'),
-(76,76,0,0,NULL,'2013-01-01'),
-(77,77,0,0,NULL,'2013-01-01'),
-(78,78,0,0,NULL,'2013-01-01'),
-(79,79,0,0,NULL,'2013-01-01'),
-(80,80,0,0,NULL,'2013-01-01'),
-(81,81,0,0,NULL,'2013-01-01'),
-(82,82,0,0,NULL,'2013-01-01'),
-(83,83,0,0,NULL,'2013-01-01'),
-(84,84,0,0,NULL,'2013-01-01'),
-(85,85,0,0,NULL,'2013-01-01'),
-(86,86,0,0,NULL,'2013-01-01'),
-(87,87,0,0,NULL,'2013-01-01'),
-(88,88,0,0,NULL,'2013-01-01'),
-(89,89,0,0,NULL,'2013-01-01'),
-(90,90,0,0,NULL,'2013-01-01'),
-(91,91,0,0,NULL,'2013-01-01'),
-(92,92,0,0,NULL,'2013-01-01'),
-(93,93,0,0,NULL,'2013-01-01'),
-(94,94,0,0,NULL,'2013-01-01'),
-(95,95,0,0,NULL,'2013-01-01'),
-(96,96,0,0,NULL,'2013-01-01'),
-(97,97,0,0,NULL,'2013-01-01'),
-(98,98,0,0,NULL,'2013-01-01'),
-(99,99,0,0,NULL,'2013-01-01'),
-(100,100,0,0,NULL,'2013-01-01'),
-(101,101,0,0,NULL,'2013-01-01'),
-(102,102,0,0,NULL,'2013-01-01'),
-(103,103,0,0,NULL,'2013-01-01'),
-(104,104,0,0,NULL,'2013-01-01'),
-(105,105,0,0,NULL,'2013-01-01'),
-(106,106,0,0,NULL,'2013-01-01'),
-(107,107,0,0,NULL,'2013-01-01'),
-(108,108,0,0,NULL,'2013-01-01'),
-(109,109,0,0,NULL,'2013-01-01'),
-(110,110,0,0,NULL,'2013-01-01'),
-(111,111,0,0,NULL,'2013-01-01'),
-(112,112,0,0,NULL,'2013-01-01'),
-(113,113,0,0,NULL,'2013-01-01'),
-(114,114,0,0,NULL,'2013-01-01'),
-(115,115,0,0,NULL,'2013-01-01'),
-(116,116,0,0,NULL,'2013-01-01'),
-(117,117,0,0,NULL,'2013-01-01'),
-(118,118,0,0,NULL,'2013-01-01'),
-(119,119,0,0,NULL,'2013-01-01'),
-(120,120,0,0,NULL,'2013-01-01'),
-(121,121,0,0,NULL,'2013-01-01'),
-(122,122,0,0,NULL,'2013-01-01'),
-(123,123,0,0,NULL,'2013-01-01'),
-(124,124,0,0,NULL,'2013-01-01'),
-(125,125,0,0,NULL,'2013-01-01'),
-(126,126,0,0,NULL,'2013-01-01'),
-(127,127,0,0,NULL,'2013-01-01'),
-(128,128,0,0,NULL,'2013-01-01'),
-(129,129,0,0,NULL,'2013-01-01'),
-(130,130,0,0,NULL,'2013-01-01'),
-(131,131,0,0,NULL,'2013-01-01'),
-(132,132,0,0,NULL,'2013-01-01'),
-(133,133,0,0,NULL,'2013-01-01'),
-(134,134,0,0,NULL,'2013-01-01');
-
-
-DELETE FROM units;
-
-INSERT INTO units (name, base_unit, factor, type) VALUES
-('Stck',NULL,0.00000,'dimension'),
-('mg',NULL,0.00000,'dimension'),
-('g','mg',1000.00000,'dimension'),
-('kg','g',1000.00000,'dimension'),
-('t','kg',1000.00000,'dimension'),
-('ml',NULL,0.00000,'dimension'),
-('L','ml',1000.00000,'dimension'),
-('pauschal',NULL,0.00000,'service'),
-('min',NULL,0.00000,'service'),
-('Std','min',60.00000,'service'),
-('Tag','Std',8.00000,'service'),
-('Wo',NULL,0.00000,'service'),
-('Mt','Wo',4.00000,'service'),
-('Jahr','Mt',12.00000,'service');
-
Unnamed repository; edit this file 'description' to name the repository.