projects
/
kivitendo-erp.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
DeliveryOrder-Controller: rebase fix, qw
[kivitendo-erp.git]
/
sql
/
Pg-upgrade2
/
COA_Account_Settings002.sql
1
-- @tag: COA_Account_Settings002
2
-- @description: Aktualisierung des SKR03, Bugfix 617
3
-- @depends: release_2_4_2
4
5
UPDATE chart
6
SET pos_eur='6'
7
WHERE
8
accno = '1771'
9
AND
10
EXISTS ( -- update only for SKR03
11
SELECT coa FROM defaults
12
WHERE defaults.coa='Germany-DATEV-SKR03EU'
13
);
14