X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FSwitzerland-deutsch-ohneMWST-2014-chart.sql;h=cda2f76561b3f10dac9f850e85a12985475d076b;hb=1e67e523b192b0284630975dccb6ece2a897d9aa;hp=31d1b0e3741b5d753006e6b546f61e4d02b5d642;hpb=14d71a6d1215e4fc67136c060fd21cd6c59602af;p=kivitendo-erp.git diff --git a/sql/Switzerland-deutsch-ohneMWST-2014-chart.sql b/sql/Switzerland-deutsch-ohneMWST-2014-chart.sql index 31d1b0e37..cda2f7656 100644 --- a/sql/Switzerland-deutsch-ohneMWST-2014-chart.sql +++ b/sql/Switzerland-deutsch-ohneMWST-2014-chart.sql @@ -3,6 +3,8 @@ -- 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_er, datevautomatik, valid_from) VALUES