Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision f6a51edf

Von Moritz Bunkus vor fast 14 Jahren hinzugefügt

  • ID f6a51edf9a1aed8a362c97b6a0afca7f107d5837
  • Vorgänger 546fc6e5
  • Nachfolger 676de51d

Falsche Kontenklasse für Konten 3151, 3160, 3170 im SKR04

Fix für Bug 1449.

Unterschiede anzeigen:

sql/Germany-DATEV-SKR04EU-chart.sql
53 53 
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2230', 'Sonderausgaben unbeschr?nkt abzugsf?hig',                             'A', 'Q', '',                                       '2230', 0,    NULL, NULL, NULL, NULL, FALSE);
54 54 
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2250', 'Zuwendungen, Spenden',                                                'A', 'Q', '',                                       '2250', 0,    NULL, NULL, NULL, NULL, FALSE);
55 55 
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2950', 'Satzungsm??ige R?cklagen',                                            'A', 'Q', '',                                       '2953', 0,    NULL, NULL, NULL, NULL, FALSE);
56 
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3151', 'Verbindlk. geg Krditinst. - Restlzeit <1 Jahr ',                      'A', 'A', '',                                       '3151', 0,    NULL, NULL, NULL, NULL, FALSE);
57 
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3160', 'Verbindlk. geg Krditinst. - Restlzeit 1 - 5 Jahre ',                  'A', 'A', '',                                       '3160', 0,    NULL, NULL, NULL, NULL, FALSE);
58 
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3170', 'Verbindlk. geg Krditinst. - Restlzeit >5 Jahre',                      'A', 'A', '',                                       '3170', 0,    NULL, NULL, NULL, NULL, FALSE);
56 
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3151', 'Verbindlk. geg Krditinst. - Restlzeit <1 Jahr ',                      'A', 'L', '',                                       '3151', 0,    NULL, NULL, NULL, NULL, FALSE);
57 
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3160', 'Verbindlk. geg Krditinst. - Restlzeit 1 - 5 Jahre ',                  'A', 'L', '',                                       '3160', 0,    NULL, NULL, NULL, NULL, FALSE);
58 
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3170', 'Verbindlk. geg Krditinst. - Restlzeit >5 Jahre',                      'A', 'L', '',                                       '3170', 0,    NULL, NULL, NULL, NULL, FALSE);
59 59 
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3300', 'Verbindlichkeiten aus Lief.u.Leist.',                                 'A', 'L', 'AP',                                     '3300', 0,    NULL, NULL, NULL, NULL, FALSE);
60 60 
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3305', 'Verbindlk. aus LuL zum allg. USTsatz (E?R)',                          'A', 'L', 'AP',                                     '3305', 0,    NULL, NULL, NULL, NULL, FALSE);
61 61 
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3306', 'Verbindlk. aus LuL zum erm. USTsatz (E?R)',                           'A', 'L', 'AP',                                     '3306', 0,    NULL, NULL, NULL, NULL, FALSE);
sql/Pg-upgrade2/skr04_fix_category_3151_3160_3170.sql
1 
-- @tag: skr04_fix_category_3151_3160_3170
2 
-- @description: Falscher Kontentyp von 3151, 3160, 3170 im SKR04
3 
-- @depends: release_2_6_1
4 
-- @charset: utf-8
5 
UPDATE chart
6 
  SET category = 'L'
7 
  WHERE (accno IN ('3151', '3160', '3170'))
8 
    AND ((SELECT coa FROM defaults LIMIT 1) = 'Germany-DATEV-SKR04EU');

Auch abrufbar als: Unified diff