From 55ad9cb097841161d5d39468423b3d8784918478 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Stephan=20K=C3=B6hler?= Date: Thu, 6 Apr 2006 11:02:17 +0000 Subject: [PATCH] Pg-update fuer r1016 (SQL-Fehler im SKR03) --- sql/Pg-upgrade/Pg-upgrade-2.2.0-2.2.0.1.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 sql/Pg-upgrade/Pg-upgrade-2.2.0-2.2.0.1.sql diff --git a/sql/Pg-upgrade/Pg-upgrade-2.2.0-2.2.0.1.sql b/sql/Pg-upgrade/Pg-upgrade-2.2.0-2.2.0.1.sql new file mode 100644 index 000000000..b7d70a655 --- /dev/null +++ b/sql/Pg-upgrade/Pg-upgrade-2.2.0-2.2.0.1.sql @@ -0,0 +1,8 @@ +-- +-- Fehler im SKR03 4250 Reinigung und 4610 Werbekosten +-- +UPDATE chart SET pos_bwa=11 WHERE accno IN ('4250'); +UPDATE chart SET pos_bilanz=null WHERE accno IN ('4250'); + +UPDATE chart SET pos_bwa=15 WHERE accno IN ('4610'); +UPDATE chart SET pos_bilanz=null WHERE accno IN ('4610'); -- 2.20.1