Revision 2fc0c33e
Von Udo Spallek vor fast 18 Jahren hinzugefügt
| sql/Pg-upgrade2/COA_Account_Settings001.sql | ||
|---|---|---|
|
-- @tag: COA_Account_Settings001
|
||
|
-- @description: Aktualisierung des SKR03
|
||
|
-- @depends: release_2_4_2
|
||
|
|
||
|
UPDATE taxkeys
|
||
|
SET pos_ustva='861',
|
||
|
tax_id=(SELECT id FROM tax WHERE taxkey='2'),
|
||
|
taxkey_id='2'
|
||
|
WHERE startdate='1970-01-01'
|
||
|
AND chart_id = (SELECT id FROM chart WHERE accno ='1771')
|
||
|
AND
|
||
|
EXISTS ( -- update only for SKR03
|
||
|
SELECT coa FROM defaults
|
||
|
WHERE defaults.coa='Germany-DATEV-SKR03EU'
|
||
|
);
|
||
|
|
||
Auch abrufbar als: Unified diff
Solved Bug 579