Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 546fc6e5

Von Moritz Bunkus vor fast 14 Jahren hinzugefügt

  • ID 546fc6e58b1452db259cc01eea122f11e6595ec9
  • Vorgänger a921e75a
  • Nachfolger f6a51edf

Falsche Zuordnung zweier Konten bzgl. BWA

Fix für Bug 1277.

Unterschiede anzeigen:

sql/Germany-DATEV-SKR03EU-chart.sql
73 73 
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4220', 'Pacht', 'A', 'E', 'AP_amount', '4220', 0, NULL, NULL, NULL, 11, FALSE);
74 74 
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4230', 'Heizung', 'A', 'E', 'AP_amount', '4230', 9, NULL, 11, NULL, NULL, FALSE);
75 75 
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4240', 'Gas,Strom, Wasser', 'A', 'E', 'AP_amount', '4240', 9, NULL, 11, NULL, 12, FALSE);
76 
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4250', 'Reinigung', 'A', 'E', 'AP_amount', '4250', 9, NULL, NULL, 11, 24, FALSE);
76 
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4250', 'Reinigung', 'A', 'E', 'AP_amount', '4250', 9, NULL, 11, NULL, 24, FALSE);
77 77 
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4260', 'Instandhaltung betrieb.R?ume', 'A', 'E', 'AP_amount', '4260', 9, NULL, 11, NULL, 13, FALSE);
78 78 
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4280', 'Sonstige Raumkosten', 'A', 'E', 'AP_amount', '4280', 9, NULL, 11, NULL, 13, FALSE);
79 79 
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4301', 'Nicht abziehbare Vorsteuer 7%', 'A', 'E', 'AP_paid', '4301', 0, NULL, 20, NULL, NULL, FALSE);
......
94 94 
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4570', 'Leasingfahrzeugkosten', 'A', 'E', 'AP_amount', '4570', 0, NULL, 14, NULL, 17, FALSE);
95 95 
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4580', 'Sonstige Kfz-Kosten', 'A', 'E', 'AP_amount', '4580', 9, NULL, 14, NULL, 17, FALSE);
96 96 
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4600', 'Werbe-und Reisekosten', 'A', 'E', 'AP_amount', '4600', 9, NULL, 15, NULL, 18, FALSE);
97 
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4610', 'Werbekosten', 'A', 'E', 'AP_amount', '4610', 9, NULL, NULL, 15, 18, FALSE);
97 
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4610', 'Werbekosten', 'A', 'E', 'AP_amount', '4610', 9, NULL, 15, NULL, 18, FALSE);
98 98 
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4638', 'Geschenke ausschlie?l.betrieb.genut', 'A', 'E', 'AP_amount', '4638', 9, NULL, NULL, NULL, 18, FALSE);
99 99 
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4640', 'Repr?sentationskosten', 'A', 'E', 'AP_amount', '4640', 9, NULL, 15, NULL, 18, FALSE);
100 100 
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4650', 'Bewirtungskosten', 'A', 'E', 'AP_amount', '4650', 9, NULL, 20, NULL, 18, FALSE);
sql/Pg-upgrade2/skr03_04_bwa_zuordnung_konten_4250_4610.sql
1 
-- @tag: skr03_04_bwa_zuordnung_konten_4250_4610
2 
-- @description: Fehler in der BWA-Zuordnung
3 
-- @depends: release_2_6_1
4 
-- @charset: utf-8
5 

  		




  
  6
  
    
-- SKR03


  		




  
  7
  
    
UPDATE chart


  		




  
  8
  
    
  SET pos_bwa = 11, pos_bilanz = NULL


  		




  
  9
  
    
  WHERE (accno = '4250')


  		




  
  10
  
    
    AND ((SELECT coa FROM defaults LIMIT 1) = 'Germany-DATEV-SKR03EU');


  		




  
  11
  
    

  		




  
  12
  
    
UPDATE chart


  		




  
  13
  
    
  SET pos_bwa = 15, pos_bilanz = NULL


  		




  
  14
  
    
  WHERE (accno = '4610')


  		




  
  15
  
    
    AND ((SELECT coa FROM defaults LIMIT 1) = 'Germany-DATEV-SKR03EU');


  		




  
  16
  
    

  		




  
  17
  
    
-- SKR04


  		




  
  18
  
    
UPDATE chart


  		




  
  19
  
    
  SET pos_bwa = 11, pos_bilanz = NULL


  		




  
  20
  
    
  WHERE (accno = '6330')


  		




  
  21
  
    
    AND ((SELECT coa FROM defaults LIMIT 1) = 'Germany-DATEV-SKR04EU');


  		




  
  22
  
    

  		




  
  23
  
    
UPDATE chart


  		




  
  24
  
    
  SET pos_bwa = 15, pos_bilanz = NULL


  		




  
  25
  
    
  WHERE (accno = '6600')


  		




  
  26
  
    
    AND ((SELECT coa FROM defaults LIMIT 1) = 'Germany-DATEV-SKR04EU');


  		




  
  27
  
    

  		












Auch abrufbar als:  Unified diff