X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FSwitzerland-deutsch-MWST-2014-chart.sql;h=19f9dc7e9871c39fc034ef6c9103685be1cdb4d2;hb=6f70e84036bcb3dcf1eee43e0d46f27529d4d733;hp=3fab61a7baa9fe5e29b93cce8d1e3348392c49b8;hpb=5fbbcc264d55bb7b7f9f66a431d87d95d5857093;p=kivitendo-erp.git

diff --git a/sql/Switzerland-deutsch-MWST-2014-chart.sql b/sql/Switzerland-deutsch-MWST-2014-chart.sql
index 3fab61a7b..19f9dc7e9 100644
--- a/sql/Switzerland-deutsch-MWST-2014-chart.sql
+++ b/sql/Switzerland-deutsch-MWST-2014-chart.sql
@@ -3,9 +3,11 @@
 -- Korrigiert: November 2015
 -- Grundlage: Revision OR Stand 1.1.2013, insbesondere Art. 957a Abs. 2
 
+ALTER TABLE chart ADD COLUMN pos_er INTEGER;
+
 DELETE FROM chart;
 
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik, valid_from) VALUES
+INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_er, datevautomatik, valid_from) VALUES
 ('1',    'AKTIVEN','H','','','1',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),
 ('10',   'UMLAUFSVERMÖGEN','H','','','10',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),
 ('100',  'Flüssige Mittel','H','','','100',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),