Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 80b0139a

Von Rolf Fluehmann vor mehr als 8 Jahren hinzugefügt

  • ID 80b0139aec73863a8fa39e728bbf50b661c19e82
  • Vorgänger 33837b14
  • Nachfolger a2d4ad4c

Anpassungen im CH-Kontenplan und CH-Kontenzuordnung

Unterschiede anzeigen:

sql/Pg-upgrade2/defaults_add_rnd_accno_ids.sql
3 3 
-- @depends: release_3_1_0
4 4 
ALTER TABLE defaults ADD COLUMN rndgain_accno_id Integer;
5 5 
ALTER TABLE defaults ADD COLUMN rndloss_accno_id Integer;
6 
UPDATE defaults SET ( rndgain_accno_id , rndloss_accno_id ) = (
7 
  (SELECT id FROM chart WHERE accno = '6953' LIMIT 1),
8 
  (SELECT id FROM chart WHERE accno = '6943' LIMIT 1)
9 
) WHERE coa LIKE 'Switzerland%';
6 10 

  		












  

    
      sql/Switzerland-deutsch-MWST-2014-chart.sql
    
  





  17
  17
  
    
('1100', 'Forderungen aus Lieferungen und Leistungen','A','A','AR','1100',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),


  		




  18
  18
  
    
('114',  'Übrige kurzfristige Forderungen','H','','','114',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),


  		




  19
  19
  
    
('1140', 'Vorschüsse, kurzfristige Darlehen','A','A','AR','1140',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),


  		




  20
  
  
    
('1170', 'Vorsteuer auf Aufwand','A','A','','1170',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),


  		




  21
  
  
    
('1171', 'Vorsteuer auf Investitionen','A','A','','1171',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),


  		




  
  20
  
    
('1170', 'Vorsteuer auf Aufwand','A','A','AP_tax:IC_taxpart:IC_taxservice','1170',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),


  		




  
  21
  
    
('1171', 'Vorsteuer auf Investitionen','A','A','AP_tax:IC_taxpart:IC_taxservice','1171',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),


  		




  22
  22
  
    
('1176', 'Verrechnungssteuer','A','A','','1176',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),


  		




  23
  23
  
    
('120',  'Vorräte und nicht fakturierte Dienstleistungen','H','','','120',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),


  		




  24
  24
  
    
('1200', 'Handelswaren','A','A','IC','1200',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),


  		




  ......




  81
  81
  
    
('32',   'HANDELSERLÖSE','H','','','32',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),


  		




  82
  82
  
    
('3200', 'Handelserlöse 8%','A','I','AR_amount:IC_sale','3200',2,NULL,NULL,NULL,1,FALSE,'2011-01-01 00:00:00.000000'),


  		




  83
  83
  
    
('3201', 'Handelserlöse 2.5%','A','I','AR_amount:IC_sale','3201',3,NULL,NULL,NULL,1,FALSE,'2011-01-01 00:00:00.000000'),


  		




  
  84
  
    
('3202', 'Handelserlöse 0%','A','I','AR_amount:IC_sale','3202',1,NULL,NULL,NULL,1,FALSE,'2011-01-01 00:00:00.000000'),


  		




  84
  85
  
    
('34',   'DIENSTLEISTUNGSERLÖSE','H','','','34',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),


  		




  85
  86
  
    
('3400', 'Dienstleistungserlöse','A','I','AR_amount:IC_income','3400',2,NULL,NULL,NULL,1,FALSE,'2011-01-01 00:00:00.000000'),


  		




  86
  87
  
    
('36',   'ÜBRIGE ERLÖSE AUS LIEFERUNGEN UND LEISTUNGEN','H','','','36',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),


  		




  ......




  100
  101
  
    
('42',   'HANDELSWARENAUFWAND','H','','','42',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),


  		




  101
  102
  
    
('4200', 'Einkauf Handelswaren 8%','A','E','AP_amount:IC_cogs','4200',4,NULL,NULL,NULL,6,FALSE,'2011-01-01 00:00:00.000000'),


  		




  102
  103
  
    
('4201', 'Einkauf Handelswaren 2.5%','A','E','AP_amount:IC_cogs','4201',5,NULL,NULL,NULL,6,FALSE,'2011-01-01 00:00:00.000000'),


  		




  
  104
  
    
('4202', 'Einkauf Handelswaren 0%','A','E','AP_amount:IC_cogs','4202',1,NULL,NULL,NULL,6,FALSE,'2011-01-01 00:00:00.000000'),


  		




  103
  105
  
    
('4208', 'Bestandsänderungen Handelswaren','A','E','AP_amount:IC_cogs','4208',4,NULL,NULL,NULL,6,FALSE,'2011-01-01 00:00:00.000000'),


  		




  104
  106
  
    
('44',   'AUFWAND FÜR BEZOGENE DRITTLEISTUNGEN','H','','','44',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),


  		




  105
  107
  
    
('4400', 'Aufwand für Drittleistungen','A','E','AP_amount:IC_expense','4400',4,NULL,NULL,NULL,6,FALSE,'2011-01-01 00:00:00.000000'),


  		




  ......




  170
  172
  
    
('6900', 'Finanzaufwand','A','E','','6900',0,NULL,NULL,NULL,6,FALSE,'2011-01-01 00:00:00.000000'),


  		




  171
  173
  
    
('6940', 'Bankspesen','A','E','','6940',0,NULL,NULL,NULL,6,FALSE,'2011-01-01 00:00:00.000000'),


  		




  172
  174
  
    
('6942', 'Kursverluste','A','E','','6942',0,NULL,NULL,NULL,6,FALSE,'2011-01-01 00:00:00.000000'),


  		




  173
  
  
    
('6943', 'Rundungsaufwand','A','E','','6943',0,NULL,NULL,NULL,6,FALSE,'2011-01-01 00:00:00.000000'),


  		




  
  175
  
    
('6943', 'Rundungsaufwand','A','E','AP_amount:IC_cogs:IC_expense','6943',0,NULL,NULL,NULL,6,FALSE,'2011-01-01 00:00:00.000000'),


  		




  174
  176
  
    
('695',  'Finanzertrag','H','','','695',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),


  		




  175
  177
  
    
('6950', 'Finanzertrag','A','I','','6950',0,NULL,NULL,NULL,1,FALSE,'2011-01-01 00:00:00.000000'),


  		




  176
  178
  
    
('6952', 'Kursgewinne','A','I','','6952',0,NULL,NULL,NULL,1,FALSE,'2011-01-01 00:00:00.000000'),


  		




  177
  
  
    
('6953', 'Rundungsertrag','A','I','','6953',0,NULL,NULL,NULL,1,FALSE,'2011-01-01 00:00:00.000000'),


  		




  
  179
  
    
('6953', 'Rundungsertrag','A','I','AR_amount:IC_sale:IC_income','6953',0,NULL,NULL,NULL,1,FALSE,'2011-01-01 00:00:00.000000'),


  		




  178
  180
  
    
('6970', 'Mitgliederbeiträge','A','I','AR_amount:IC_income','6970',1,NULL,NULL,NULL,1,FALSE,'2011-01-01 00:00:00.000000'),


  		




  179
  181
  
    
('6980', 'Spenden','A','I','AR_amount:IC_income','6980',1,NULL,NULL,NULL,1,FALSE,'2011-01-01 00:00:00.000000'),


  		




  180
  182
  
    
('7',    'BETRIEBLICHER NEBENERFOLG','H','','','7',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),


  		




  ......




  212
  214
  
    
) VALUES (


  		




  213
  215
  
    
  'Standard 8%',(SELECT id FROM chart WHERE accno = '1200'),


  		




  214
  216
  
    
  (SELECT id FROM chart WHERE accno = '3200'), (SELECT id FROM chart WHERE accno = '4200'),


  		




  215
  
  
    
  (SELECT id FROM chart WHERE accno = '3200'), (SELECT id FROM chart WHERE accno = '4200'),


  		




  216
  
  
    
  (SELECT id FROM chart WHERE accno = '3200'), (SELECT id FROM chart WHERE accno = '4200'),


  		




  217
  
  
    
  (SELECT id FROM chart WHERE accno = '3200'), (SELECT id FROM chart WHERE accno = '4200')


  		




  
  217
  
    
  (SELECT id FROM chart WHERE accno = '3202'), (SELECT id FROM chart WHERE accno = '4202'),


  		




  
  218
  
    
  (SELECT id FROM chart WHERE accno = '3202'), (SELECT id FROM chart WHERE accno = '4202'),


  		




  
  219
  
    
  (SELECT id FROM chart WHERE accno = '3202'), (SELECT id FROM chart WHERE accno = '4202')


  		




  218
  220
  
    
),(


  		




  219
  221
  
    
  'Standard 2.5%',(SELECT id FROM chart WHERE accno = '1200'),


  		




  220
  222
  
    
  (SELECT id FROM chart WHERE accno = '3201'), (SELECT id FROM chart WHERE accno = '4201'),


  		




  221
  
  
    
  (SELECT id FROM chart WHERE accno = '3201'), (SELECT id FROM chart WHERE accno = '4201'),


  		




  222
  
  
    
  (SELECT id FROM chart WHERE accno = '3201'), (SELECT id FROM chart WHERE accno = '4201'),


  		




  223
  
  
    
  (SELECT id FROM chart WHERE accno = '3201'), (SELECT id FROM chart WHERE accno = '4201')


  		




  
  223
  
    
  (SELECT id FROM chart WHERE accno = '3202'), (SELECT id FROM chart WHERE accno = '4202'),


  		




  
  224
  
    
  (SELECT id FROM chart WHERE accno = '3202'), (SELECT id FROM chart WHERE accno = '4202'),


  		




  
  225
  
    
  (SELECT id FROM chart WHERE accno = '3202'), (SELECT id FROM chart WHERE accno = '4202')


  		




  224
  226
  
    
);


  		




  225
  227
  
    

  		




  226
  228
  
    

  		




  ......




  240
  242
  
    
(1, 'Mehrwertsteuerfrei', 0);


  		




  241
  243
  
    

  		




  242
  244
  
    
INSERT INTO tax (taxkey, taxdescription, rate, taxnumber, chart_id) VALUES


  		




  243
  
  
    
(2, 'MWST 8% Ertrag', 0.08000, '2200', (SELECT id FROM chart WHERE accno='2200')),


  		




  244
  
  
    
(3, 'MWST 2.5% Ertrag', 0.02500, '2201', (SELECT id FROM chart WHERE accno='2201')),


  		




  245
  
  
    
(4, 'MWST 8% Aufwand', 0.08000, '1170', (SELECT id FROM chart WHERE accno='1170')),


  		




  246
  
  
    
(5, 'MWST 2.5% Aufwand', 0.02500, '1170', (SELECT id FROM chart WHERE accno='1170')),


  		




  247
  
  
    
(6, 'MWST 8% Investitionen', 0.08000, '1171', (SELECT id FROM chart WHERE accno='1171')),


  		




  248
  
  
    
(7, 'MWST 2.5% Investitionen', 0.02500, '1171', (SELECT id FROM chart WHERE accno='1171'));


  		




  
  245
  
    
(2, 'MWST', 0.08000, '2200', (SELECT id FROM chart WHERE accno='2200')),


  		




  
  246
  
    
(3, 'MWST', 0.02500, '2201', (SELECT id FROM chart WHERE accno='2201')),


  		




  
  247
  
    
(4, 'MWST Aufwand', 0.08000, '1170', (SELECT id FROM chart WHERE accno='1170')),


  		




  
  248
  
    
(5, 'MWST Aufwand', 0.02500, '1170', (SELECT id FROM chart WHERE accno='1170')),


  		




  
  249
  
    
(6, 'MWST Investitionen', 0.08000, '1171', (SELECT id FROM chart WHERE accno='1171')),


  		




  
  250
  
    
(7, 'MWST Investitionen', 0.02500, '1171', (SELECT id FROM chart WHERE accno='1171'));


  		




  249
  251
  
    

  		




  250
  252
  
    

  		




  251
  253
  
    
DELETE FROM taxkeys;


  		












  

    
      sql/Switzerland-deutsch-ohneMWST-2014-chart.sql
    
  





  17
  17
  
    
('1100', 'Forderungen aus Lieferungen und Leistungen','A','A','AR','1100',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),


  		




  18
  18
  
    
('114',  'Übrige kurzfristige Forderungen','H','','','114',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),


  		




  19
  19
  
    
('1140', 'Vorschüsse, kurzfristige Darlehen','A','A','AR','1140',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),


  		




  20
  
  
    
('1170', 'Vorsteuer auf Aufwand','A','A','','1170',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),


  		




  21
  
  
    
('1171', 'Vorsteuer auf Investitionen','A','A','','1171',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),


  		




  
  20
  
    
('1170', 'Vorsteuer auf Aufwand','A','A','AP_tax:IC_taxpart:IC_taxservice','1170',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),


  		




  
  21
  
    
('1171', 'Vorsteuer auf Investitionen','A','A','AP_tax:IC_taxpart:IC_taxservice','1171',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),


  		




  22
  22
  
    
('1176', 'Verrechnungssteuer','A','A','','1176',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),


  		




  23
  23
  
    
('120',  'Vorräte und nicht fakturierte Dienstleistungen','H','','','120',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),


  		




  24
  24
  
    
('1200', 'Handelswaren','A','A','IC','1200',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),


  		




  ......




  168
  168
  
    
('6900', 'Finanzaufwand','A','E','','6900',0,NULL,NULL,NULL,6,FALSE,'2011-01-01 00:00:00.000000'),


  		




  169
  169
  
    
('6940', 'Bankspesen','A','E','','6940',0,NULL,NULL,NULL,6,FALSE,'2011-01-01 00:00:00.000000'),


  		




  170
  170
  
    
('6942', 'Kursverluste','A','E','','6942',0,NULL,NULL,NULL,6,FALSE,'2011-01-01 00:00:00.000000'),


  		




  171
  
  
    
('6943', 'Rundungsaufwand','A','E','','6943',0,NULL,NULL,NULL,6,FALSE,'2011-01-01 00:00:00.000000'),


  		




  
  171
  
    
('6943', 'Rundungsaufwand','A','E','AP_amount:IC_cogs:IC_expense','6943',0,NULL,NULL,NULL,6,FALSE,'2011-01-01 00:00:00.000000'),


  		




  172
  172
  
    
('695',  'Finanzertrag','H','','','695',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),


  		




  173
  173
  
    
('6950', 'Finanzertrag','A','I','','6950',0,NULL,NULL,NULL,1,FALSE,'2011-01-01 00:00:00.000000'),


  		




  174
  174
  
    
('6952', 'Kursgewinne','A','I','','6952',0,NULL,NULL,NULL,1,FALSE,'2011-01-01 00:00:00.000000'),


  		




  175
  
  
    
('6953', 'Rundungsertrag','A','I','','6953',0,NULL,NULL,NULL,1,FALSE,'2011-01-01 00:00:00.000000'),


  		




  
  175
  
    
('6953', 'Rundungsertrag','A','I','AR_amount:IC_sale:IC_income','6953',0,NULL,NULL,NULL,1,FALSE,'2011-01-01 00:00:00.000000'),


  		




  176
  176
  
    
('6970', 'Mitgliederbeiträge','A','I','AR_amount:IC_income','6970',0,NULL,NULL,NULL,1,FALSE,'2011-01-01 00:00:00.000000'),


  		




  177
  177
  
    
('6980', 'Spenden','A','I','AR_amount:IC_income','6980',0,NULL,NULL,NULL,1,FALSE,'2011-01-01 00:00:00.000000'),


  		




  178
  178
  
    
('7',    'BETRIEBLICHER NEBENERFOLG','H','','','7',0,NULL,NULL,NULL,NULL,FALSE,'2011-01-01 00:00:00.000000'),


  		




  ......




  208
  208
  
    
  income_accno_id_2, expense_accno_id_2,


  		




  209
  209
  
    
  income_accno_id_3, expense_accno_id_3


  		




  210
  210
  
    
) VALUES (


  		




  211
  
  
    
  'Standard 8%',(SELECT id FROM chart WHERE accno = '1200'),


  		




  212
  
  
    
  (SELECT id FROM chart WHERE accno = '3200'), (SELECT id FROM chart WHERE accno = '4200'),


  		




  213
  
  
    
  (SELECT id FROM chart WHERE accno = '3200'), (SELECT id FROM chart WHERE accno = '4200'),


  		




  214
  
  
    
  (SELECT id FROM chart WHERE accno = '3200'), (SELECT id FROM chart WHERE accno = '4200'),


  		




  215
  
  
    
  (SELECT id FROM chart WHERE accno = '3200'), (SELECT id FROM chart WHERE accno = '4200')


  		




  216
  
  
    
),(


  		




  217
  
  
    
  'Standard 2.5%',(SELECT id FROM chart WHERE accno = '1200'),


  		




  
  211
  
    
  'Standard',(SELECT id FROM chart WHERE accno = '1200'),


  		




  218
  212
  
    
  (SELECT id FROM chart WHERE accno = '3200'), (SELECT id FROM chart WHERE accno = '4200'),


  		




  219
  213
  
    
  (SELECT id FROM chart WHERE accno = '3200'), (SELECT id FROM chart WHERE accno = '4200'),


  		




  220
  214
  
    
  (SELECT id FROM chart WHERE accno = '3200'), (SELECT id FROM chart WHERE accno = '4200'),


  		




  ......




  238
  232
  
    
(1, 'Mehrwertsteuerfrei', 0);


  		




  239
  233
  
    

  		




  240
  234
  
    
INSERT INTO tax (taxkey, taxdescription, rate, taxnumber, chart_id) VALUES


  		




  241
  
  
    
(2, 'MWST 8% Ertrag', 0.08000, '2200', (SELECT id FROM chart WHERE accno='2200')),


  		




  242
  
  
    
(3, 'MWST 2.5% Ertrag', 0.02500, '2201', (SELECT id FROM chart WHERE accno='2201')),


  		




  243
  
  
    
(4, 'MWST 8% Aufwand', 0.08000, '1170', (SELECT id FROM chart WHERE accno='1170')),


  		




  244
  
  
    
(5, 'MWST 2.5% Aufwand', 0.02500, '1170', (SELECT id FROM chart WHERE accno='1170')),


  		




  245
  
  
    
(6, 'MWST 8% Investitionen', 0.08000, '1171', (SELECT id FROM chart WHERE accno='1171')),


  		




  246
  
  
    
(7, 'MWST 2.5% Investitionen', 0.02500, '1171', (SELECT id FROM chart WHERE accno='1171'));


  		




  
  235
  
    
(2, 'MWST', 0.08000, '2200', (SELECT id FROM chart WHERE accno='2200')),


  		




  
  236
  
    
(3, 'MWST', 0.02500, '2201', (SELECT id FROM chart WHERE accno='2201')),


  		




  
  237
  
    
(4, 'MWST Aufwand', 0.08000, '1170', (SELECT id FROM chart WHERE accno='1170')),


  		




  
  238
  
    
(5, 'MWST Aufwand', 0.02500, '1170', (SELECT id FROM chart WHERE accno='1170')),


  		




  
  239
  
    
(6, 'MWST Investitionen', 0.08000, '1171', (SELECT id FROM chart WHERE accno='1171')),


  		




  
  240
  
    
(7, 'MWST Investitionen', 0.02500, '1171', (SELECT id FROM chart WHERE accno='1171'));


  		




  247
  241
  
    

  		




  248
  242
  
    

  		




  249
  243
  
    
DELETE FROM taxkeys;


  		












Auch abrufbar als:  Unified diff