Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 9a194d6a

Von G. Richardson vor fast 13 Jahren hinzugefügt

  • ID 9a194d6adb43e503eba75d2604d8081095ca1414
  • Vorgänger f1d9d32e
  • Nachfolger 004ecc3f

Überreste von CT_tax entfernt

Wird nirgends mehr verwendet, bzw. sind die aufgerufenen
Funktionen dazu schon lange auskommentiert. Auch aus den
Kontenrahmen und Updatescripts entfernt, da beim Speichern
eines Kontos die CT_tax Information in link eh verloren geht.

Es gibt in rp.pl auch noch Referenzen auf die Berichte
"tax_collected" und "tax_paid", aber keine Menüpunkte oder
Druckvorlagen dazu, können die auch raus?

Unterschiede anzeigen:

SL/AM.pm
210 210 
  # sanity check, can't have AR with AR_...
211 211 
  if ($form->{AR} || $form->{AP} || $form->{IC}) {
212 212 
    map { delete $form->{$_} }
213 
      qw(AR_amount AR_tax AR_paid AP_amount AP_tax AP_paid IC_sale IC_cogs IC_taxpart IC_income IC_expense IC_taxservice CT_tax);
213 
      qw(AR_amount AR_tax AR_paid AP_amount AP_tax AP_paid IC_sale IC_cogs IC_taxpart IC_income IC_expense IC_taxservice);
214 214 
  }
215 215 

  		




  216
  216
  
    
  $form->{link} = "";


  		




  ......




  221
  221
  
    
                    $form->{IC},            $form->{IC_sale},


  		




  222
  222
  
    
                    $form->{IC_cogs},       $form->{IC_taxpart},


  		




  223
  223
  
    
                    $form->{IC_income},     $form->{IC_expense},


  		




  224
  
  
    
                    $form->{IC_taxservice}, $form->{CT_tax}


  		




  
  224
  
    
                    $form->{IC_taxservice}


  		




  225
  225
  
    
    ) {


  		




  226
  226
  
    
    $form->{link} .= "${item}:" if ($item);


  		




  227
  227
  
    
  }


  		












  

    
      SL/RP.pm
    
  





  1293
  1293
  
    
  $main::lxdebug->leave_sub();


  		




  1294
  1294
  
    
}


  		




  1295
  1295
  
    

  		




  1296
  
  
    
sub get_taxaccounts {


  		




  1297
  
  
    
  $main::lxdebug->enter_sub();


  		




  1298
  
  
    

  		




  1299
  
  
    
  my ($self, $myconfig, $form) = @_;


  		




  1300
  
  
    

  		




  1301
  
  
    
  # connect to database


  		




  1302
  
  
    
  my $dbh = $form->dbconnect($myconfig);


  		




  1303
  
  
    

  		




  1304
  
  
    
  # get tax accounts


  		




  1305
  
  
    
  my $query =


  		




  1306
  
  
    
    qq|SELECT c.accno, c.description, t.rate


  		




  1307
  
  
    
       FROM chart c, tax t


  		




  1308
  
  
    
       WHERE (c.link LIKE '%CT_tax%') AND (c.id = t.chart_id)


  		




  1309
  
  
    
       ORDER BY c.accno|;


  		




  1310
  
  
    
  $form->{taxaccounts} = selectall_hashref_query($form, $dbh, $query);


  		




  1311
  
  
    

  		




  1312
  
  
    
  $dbh->disconnect;


  		




  1313
  
  
    

  		




  1314
  
  
    
  $main::lxdebug->leave_sub();


  		




  1315
  
  
    
}


  		




  1316
  
  
    

  		




  1317
  1296
  
    
sub tax_report {


  		




  1318
  1297
  
    
  $main::lxdebug->enter_sub();


  		




  1319
  1298
  
    

  		












  

    
      bin/mozilla/am.pl
    
  





  560
  560
  
    
               : ( $link eq 'IC_income' )     ? $locale->text('Account Link IC_income')


  		




  561
  561
  
    
               : ( $link eq 'IC_expense' )    ? $locale->text('Account Link IC_expense')


  		




  562
  562
  
    
               : ( $link eq 'IC_taxservice' ) ? $locale->text('Account Link IC_taxservice')


  		




  563
  
  
    
#               : ( $link eq 'CT_tax' )        ? $locale->text('Account Link CT_tax')


  		




  564
  563
  
    
               : $locale->text('Unknown Link') . ': ' . $link;


  		




  565
  564
  
    
      $ca->{link} .= ($link ne '') ?  "[$link] ":'';


  		




  566
  565
  
    
    }


  		












  

    
      bin/mozilla/rp.pl
    
  





  158
  158
  
    
  my $is_bwa              = $::form->{report} eq "bwa";


  		




  159
  159
  
    
  my $is_balance_sheet    = $::form->{report} eq "balance_sheet";


  		




  160
  160
  
    
  my $is_trial_balance    = $::form->{report} eq "trial_balance";


  		




  161
  
  
    
  my $is_taxreport        = $::form->{report} =~ /^tax_/;


  		




  162
  
  
    
  my $is_nontaxable       = $::form->{report} =~ /^nontaxable_/;


  		




  163
  161
  
    
  my $is_aging            = $::form->{report} =~ /^a[rp]_aging$/;


  		




  164
  162
  
    
  my $is_payments         = $::form->{report} =~ /(receipts|payments)$/;


  		




  165
  163
  
    

  		




  166
  
  
    
#  if (is_taxreport) {


  		




  167
  
  
    
#    $::form->{db} = ($::form->{report} =~ /_collected/) ? "ar" : "ap";


  		




  168
  
  
    
#    RP->get_taxaccounts(\%::myconfig, $::form);


  		




  169
  
  
    
#  }


  		




  170
  
  
    
#


  		




  171
  
  
    
#  if ($is_nontaxable) {


  		




  172
  
  
    
#    $::form->{db} = ($::form->{report} =~ /_sales/) ? "ar" : "ap";


  		




  173
  
  
    
#  }


  		




  174
  
  
    

  		




  175
  164
  
    
  my ($label, $nextsub, $vc);


  		




  176
  165
  
    
  if ($is_aging) {


  		




  177
  166
  
    
    my $is_sales  = $::form->{report} eq 'ar_aging';


  		












  

    
      locale/de/all
    
  





  73
  73
  
    
  'Account Link AR_amount'      => 'Forderungen Erlöskonto',


  		




  74
  74
  
    
  'Account Link AR_paid'        => 'Forderungen Zahlungseingang',


  		




  75
  75
  
    
  'Account Link AR_tax'         => 'Forderungen Steuer',


  		




  76
  
  
    
  'Account Link CT_tax'         => 'Kunde/Lieferant Steuer',


  		




  77
  76
  
    
  'Account Link IC'             => 'Inventar',


  		




  78
  77
  
    
  'Account Link IC_cogs'        => 'Warenliste Aufwandskonto',


  		




  79
  78
  
    
  'Account Link IC_expense'     => 'Dienstleistungen Aufwandskonto',


  		












  

    
      locale/de_DE/all
    
  





  83
  83
  
    
  'Account Link AR_amount'      => 'Forderungen Erlöskonto',


  		




  84
  84
  
    
  'Account Link AR_paid'        => 'Forderungen Zahlungseingang',


  		




  85
  85
  
    
  'Account Link AR_tax'         => 'Forderungen Steuer',


  		




  86
  
  
    
  'Account Link CT_tax'         => 'Kunde/Lieferant Steuer',


  		




  87
  86
  
    
  'Account Link IC'             => 'Inventar',


  		




  88
  87
  
    
  'Account Link IC_cogs'        => 'Warenliste Aufwandskonto',


  		




  89
  88
  
    
  'Account Link IC_expense'     => 'Dienstleistungen Aufwandskonto',


  		












  

    
      locale/en/all
    
  





  83
  83
  
    
  'Account Link AR_amount'      => '',


  		




  84
  84
  
    
  'Account Link AR_paid'        => '',


  		




  85
  85
  
    
  'Account Link AR_tax'         => '',


  		




  86
  
  
    
  'Account Link CT_tax'         => '',


  		




  87
  86
  
    
  'Account Link IC'             => '',


  		




  88
  87
  
    
  'Account Link IC_cogs'        => '',


  		




  89
  88
  
    
  'Account Link IC_expense'     => '',


  		












  

    
      locale/fr/missing
    
  





  75
  75
  
    
  'Account Link AR_amount'      => '',


  		




  76
  76
  
    
  'Account Link AR_paid'        => '',


  		




  77
  77
  
    
  'Account Link AR_tax'         => '',


  		




  78
  
  
    
  'Account Link CT_tax'         => '',


  		




  79
  78
  
    
  'Account Link IC'             => '',


  		




  80
  79
  
    
  'Account Link IC_cogs'        => '',


  		




  81
  80
  
    
  'Account Link IC_expense'     => '',


  		












  

    
      sql/Austria-chart.sql
    
  





  62
  62
  
    
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3500','VERBINDLICHKEITEN FINANZAMT','H','35','L','');


  		




  63
  63
  
    
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3510','Finanzamt Verrechnung K?rperschaftssteuer','A','350-359','L','');


  		




  64
  64
  
    
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3520','Finanzamt Verrechnung Umsatzsteuer','A','350-359','L','');


  		




  65
  
  
    
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3530','Mehrwertsteuer 0%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice:CT_tax');


  		




  66
  
  
    
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3531','Mehrwertsteuer 10%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice:CT_tax');


  		




  67
  
  
    
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3532','Mehrwertsteuer 20%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice:CT_tax');


  		




  68
  
  
    
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3540','Vorsteuer 0%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice:CT_tax');


  		




  69
  
  
    
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3541','Vorsteuer 10%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice:CT_tax');


  		




  70
  
  
    
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3542','Vorsteuer 20%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice:CT_tax');


  		




  
  65
  
    
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3530','Mehrwertsteuer 0%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');


  		




  
  66
  
    
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3531','Mehrwertsteuer 10%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');


  		




  
  67
  
    
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3532','Mehrwertsteuer 20%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');


  		




  
  68
  
    
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3540','Vorsteuer 0%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');


  		




  
  69
  
    
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3541','Vorsteuer 10%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');


  		




  
  70
  
    
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3542','Vorsteuer 20%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');


  		




  71
  71
  
    
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4000','UMSATZ','H','4','I','');


  		




  72
  72
  
    
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4020','Verkauf - Hardware','A','40-44','I','AR_amount:IC_sale');


  		




  73
  73
  
    
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4030','Verkauf - Software ','A','40-44','I','AR_amount:IC_sale');


  		












  

    
      sql/France-chart.sql
    
  





  900
  900
  
    
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('445500', 'TAXES SUR CA A DECAISSER', 'A', '', '', '');


  		




  901
  901
  
    
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('706000', 'PRESTATIONS DE SERVICES', 'A', '', 'I', 'IC_income');


  		




  902
  902
  
    
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('707000', 'VENTES DE MARCHANDISES', 'A', '', 'I', 'IC_sale');


  		




  903
  
  
    
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('445713', 'TVA COLLECTEE 19.6%', 'A', '', 'I', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax');


  		




  
  903
  
    
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('445713', 'TVA COLLECTEE 19.6%', 'A', '', 'I', 'AR_tax:IC_taxpart:IC_taxservice');


  		




  904
  904
  
    
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('512020', 'BANQUE DEBIT', 'A', '', 'E', 'AP');


  		




  905
  
  
    
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('445711', 'TVA COLLECTEE  5.5%', 'A', '', 'I', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax');


  		




  906
  
  
    
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('445661', 'TVA DEDUCTIBLE  5.5%', 'A', '', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax');


  		




  
  905
  
    
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('445711', 'TVA COLLECTEE  5.5%', 'A', '', 'I', 'AR_tax:IC_taxpart:IC_taxservice');


  		




  
  906
  
    
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('445661', 'TVA DEDUCTIBLE  5.5%', 'A', '', 'E', 'AP_tax:IC_taxpart:IC_taxservice');


  		




  907
  907
  
    
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('512010', 'BANQUE CREDIT', 'A', '', 'I', 'AR:AR_amount');


  		




  908
  908
  
    
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('681730', 'STOCKS ET EN-COURS', 'A', '', 'A', 'IC');


  		




  909
  909
  
    
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('580010', 'VIREMENT INTERNE', 'A', '', 'E', '');


  		




  ......




  930
  930
  
    
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('609400', 'D\'ETUDES & PRESTATIONS DE SERVICES', 'A', '', '', '');


  		




  931
  931
  
    
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('625100', 'VOYAGES ET DEPLACEMENTS', 'A', '', 'E', 'AP_amount');


  		




  932
  932
  
    
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('618300', 'DOCUMENTATION TECHNIQUE', 'A', '', 'E', 'AP_amount');


  		




  933
  
  
    
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('445663', 'TVA DEDUCTIBLE 19.6%', 'A', '', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax');


  		




  
  933
  
    
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('445663', 'TVA DEDUCTIBLE 19.6%', 'A', '', 'E', 'AP_tax:IC_taxpart:IC_taxservice');


  		




  934
  934
  
    
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('601000', 'ACHATS STOCKES MAT. PREM. (FOURN.)', 'A', '', 'E', 'AP_amount:IC_cogs');


  		




  935
  935
  
    
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('626000', 'FRAIS POSTAUX ET TELECOMMUNIC.', 'A', '', 'E', 'AP_amount');


  		




  936
  936
  
    
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('512000', 'BANQUE', 'A', '', 'A', 'AR_paid:AP_paid');


  		












  

    
      sql/Germany-DATEV-SKR03EU-chart.sql
    
  





  194
  194
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0650', 'Vblk.geg.Kreditinst.- Restlaufzeit gr?sser als 5 Jahre', 'A', 'A', '', '0650', 0, NULL, NULL, NULL, NULL, FALSE);


  		




  195
  195
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4510', 'Kfz-Steuer', 'A', 'E', 'AP_amount', '4510', 0, NULL, 19, NULL, 15, FALSE);


  		




  196
  196
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4520', 'Kfz-Versicherungen', 'A', 'E', 'AP_amount', '4520', 0, NULL, 14, NULL, 16, FALSE);


  		




  197
  
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1771', 'Umsatzsteuer 7%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax', '1771', 0, NULL, NULL, NULL, 5, FALSE);


  		




  198
  
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1775', 'Umsatzsteuer 16%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax', '1775', 0, NULL, NULL, NULL, 6, FALSE);


  		




  
  197
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1771', 'Umsatzsteuer 7%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', '1771', 0, NULL, NULL, NULL, 5, FALSE);


  		




  
  198
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1775', 'Umsatzsteuer 16%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', '1775', 0, NULL, NULL, NULL, 6, FALSE);


  		




  199
  199
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1767', 'Im anderen EG-Staat steuerpfl. Lieferung', 'A', ' ', '', '1767', 10, NULL, 0, NULL, NULL, FALSE);


  		




  200
  200
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0853', 'Satzungsm.R?cklagen 0% Vorbelast.(st.Einlagekto.)', 'A', 'Q', '', '0853', 0, NULL, NULL, NULL, NULL, FALSE);


  		




  201
  201
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1607', 'Vblk.a.LuL ohne Vorsteuer (E?R)', 'A', 'L', 'AP', '1607', 0, NULL, NULL, NULL, NULL, FALSE);


  		




  ......




  259
  259
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('8922', 'Verwend.f.Gegenst.f.Zwecke au?erh.d.Untern.16%USt(Telefonnutzung)', 'A', 'I', '', '8922', 0, 0, 5, NULL, 3, TRUE);


  		




  260
  260
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1000', 'Kasse', 'A', 'A', 'AR_paid:AP_paid', '1000', 0, NULL, NULL, NULL, NULL, FALSE);


  		




  261
  261
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1572', 'Steuerpflicht. EG-Erwerb 7%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', '1572', 0, 61, NULL, NULL, 27, FALSE);


  		




  262
  
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1571', 'Abziehbare Vorsteuer 7%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1570', 0, 66, NULL, NULL, 27, FALSE);


  		




  
  262
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1571', 'Abziehbare Vorsteuer 7%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', '1570', 0, 66, NULL, NULL, 27, FALSE);


  		




  263
  263
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1573', 'Steuerpflicht. EG-Erwerb 16%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', '1573', 0, 61, NULL, NULL, 27, FALSE);


  		




  264
  
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1575', 'Abziehbare Vorsteuer 16%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1570', 0, 66, NULL, NULL, 27, FALSE);


  		




  
  264
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1575', 'Abziehbare Vorsteuer 16%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', '1570', 0, 66, NULL, NULL, 27, FALSE);


  		




  265
  265
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1772', 'Steuerpflicht. EG-Lieferungen 7%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', '1772', 0, NULL, NULL, NULL, 6, FALSE);


  		




  266
  266
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1773', 'Steuerpflicht. EG-Lieferungen 16%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', '1773', 0, NULL, NULL, NULL, 28, FALSE);


  		




  267
  267
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2501', 'Ausserordentliche Ertr?ge finanzwirksam', 'A', 'I', '', '2501', 0, NULL, NULL, NULL, 5, FALSE);


  		




  ......




  284
  284
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3090', 'Energiestoffe (Fert.).', 'A', 'E', 'IC', '3090', 9, 0, 4, NULL, 8, FALSE);


  		




  285
  285
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4595', 'Fremdfahrzeuge', 'A', 'E', 'AP_amount', '4570', 0, NULL, 14, NULL, 17, FALSE);


  		




  286
  286
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1450', 'Ford.a.LuL n.Durchschnittss.gem.?24UStG(E?R)', 'A', 'A', 'AR', '1448', 0, NULL, NULL, NULL, NULL, FALSE);


  		




  287
  
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1577', 'Abzieb.Vorst.n.allg.Durchschnittss.UStVA Kz.63', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1577', 0, NULL, NULL, NULL, 27, FALSE);


  		




  288
  
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1578', 'Abzieb.Vorst.n.?13b', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1578', 0, NULL, NULL, NULL, 27, FALSE);


  		




  
  287
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1577', 'Abzieb.Vorst.n.allg.Durchschnittss.UStVA Kz.63', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', '1577', 0, NULL, NULL, NULL, 27, FALSE);


  		




  
  288
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1578', 'Abzieb.Vorst.n.?13b', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', '1578', 0, NULL, NULL, NULL, 27, FALSE);


  		




  289
  289
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1580', 'Gegenkonto Vorsteuer ?4/3 EStG', 'A', 'A', '', '1580', 0, NULL, NULL, NULL, NULL, FALSE);


  		




  290
  290
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1581', 'Aufl?sung Vorst.a.Vorjahr ?4/3 EStG', 'A', 'A', '', '1581', 0, NULL, NULL, NULL, NULL, FALSE);


  		




  291
  291
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1582', 'Vorst.aus Investitionen ?4/3 EStG', 'A', 'E', '', '1582', 0, NULL, NULL, NULL, 27, FALSE);


  		




  ......




  395
  395
  
    
insert into taxkeys (chart_id, tax_id, taxkey_id, pos_ustva, startdate) select chart.id, tax.id, taxkey_id, pos_ustva, '1970-01-01' from chart LEFT JOIN tax on (tax.taxkey=chart.taxkey_id) WHERE taxkey_id is not null;


  		




  396
  396
  
    
insert into taxkeys (chart_id, tax_id, taxkey_id,startdate) SELECT 0, id, taxkey, '1970-01-01' FROM tax;


  		




  397
  397
  
    
INSERT INTO chart (accno, description, charttype, category, link, taxkey_id, pos_ustva, pos_eur)


  		




  398
  
  
    
      VALUES ('1776','Umsatzsteuer 19 %', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax', 0, 511,6);


  		




  
  398
  
    
      VALUES ('1776','Umsatzsteuer 19 %', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', 0, 511,6);


  		




  399
  399
  
    
INSERT INTO chart (accno, description, charttype, category, link, taxkey_id, pos_ustva, pos_eur)


  		




  400
  
  
    
      VALUES ('1576','Abziehbare Vorsteuer 19 %', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', 0, 66,27);


  		




  
  400
  
    
      VALUES ('1576','Abziehbare Vorsteuer 19 %', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', 0, 66,27);


  		




  401
  401
  
    
INSERT INTO tax (chart_id, rate, taxnumber, taxkey, taxdescription) VALUES ((SELECT id from CHART WHERE accno='1776'), 0.19, '1776', 3, 'Umsatzsteuer 19%');


  		




  402
  402
  
    
INSERT INTO tax (chart_id, rate, taxnumber, taxkey, taxdescription) VALUES ((SELECT id from CHART WHERE accno='1576'), 0.19, '1576', 9, 'Vorsteuer 19%');


  		




  403
  403
  
    
insert into taxkeys (chart_id, tax_id, taxkey_id, pos_ustva, startdate) select chart.id, (SELECT id from tax where taxdescription='Umsatzsteuer 19%'), 3, pos_ustva, '2007-01-01' from chart WHERE taxkey_id=3;


  		












  

    
      sql/Germany-DATEV-SKR04EU-chart.sql
    
  





  28
  28
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1249', 'Pauschwertber. zu Forder. Restlzeit >1 Jahr',                              'A', 'E',         '',                                       '1249', 0,    NULL, 31,   NULL, NULL, FALSE);


  		




  29
  29
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1370', 'Durchlaufende Posten',                                                     'A', 'A',         '',                                       '1370', 0,    NULL, NULL, NULL, NULL, FALSE);


  		




  30
  30
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1374', 'Fremdgeld',                                                                'A', 'A',         '',                                       '1374', 0,    NULL, NULL, NULL, NULL, FALSE);


  		




  31
  
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1401', 'Abziehbare Vorsteuer 7%',                                                  'A', 'E',         'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1401', 0,    66,   NULL, NULL, 27,   FALSE);


  		




  
  31
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1401', 'Abziehbare Vorsteuer 7%',                                                  'A', 'E',         'AP_tax:IC_taxpart:IC_taxservice', '1401', 0,    66,   NULL, NULL, 27,   FALSE);


  		




  32
  32
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1402', 'Abziehbare Vorsteuer aus innergemeinschftl. Erwerb',                       'A', 'E',         'AP_tax:IC_taxpart:IC_taxservice',        '1402', 0,    61,   NULL, NULL, 27,   FALSE);


  		




  33
  33
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1403', 'Abziehbare Vorsteuer aus innergemeinschftl. Erwerb 16%',                   'A', 'E',         'AP_tax:IC_taxpart:IC_taxservice',        '1403', 0,    61,   NULL, NULL, 27,   FALSE);


  		




  34
  34
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1404', 'Abziehbare Vorsteuer aus innergemeinschftl. Erwerb 19%',                   'A', 'E',         'AP_tax:IC_taxpart:IC_taxservice',        '1403', 0,    61,   NULL, NULL, 27,   FALSE);


  		




  35
  
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1405', 'Abziehbare Vorsteuer 16%',                                                 'A', 'E',         'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1405', 0,    66,   NULL, NULL, 27,   FALSE);


  		




  36
  
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1406', 'Abziehbare Vorsteuer 19 %',                                                'A', 'E',         'AP_tax:IC_taxpart:IC_taxservice:CT_tax', 0,      0,    66,   NULL, NULL, 27,   FALSE);


  		




  37
  
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1407', 'Abziehbare Vorsteuer nach ? 13b UStG 19%',                                 'A', 'E',         'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1407', 0,    NULL, NULL, NULL, 27,   FALSE);


  		




  38
  
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1408', 'Abziehbare Vorsteuer nach ? 13b UStG',                                     'A', 'E',         'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1408', 0,    NULL, NULL, NULL, 27,   FALSE);


  		




  39
  
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1409', 'Abziehbare Vorsteuer nach ? 13b UStG 16%',                                 'A', 'E',         'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1408', 0,    NULL, NULL, NULL, 27,   FALSE);


  		




  
  35
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1405', 'Abziehbare Vorsteuer 16%',                                                 'A', 'E',         'AP_tax:IC_taxpart:IC_taxservice', '1405', 0,    66,   NULL, NULL, 27,   FALSE);


  		




  
  36
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1406', 'Abziehbare Vorsteuer 19 %',                                                'A', 'E',         'AP_tax:IC_taxpart:IC_taxservice', 0,      0,    66,   NULL, NULL, 27,   FALSE);


  		




  
  37
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1407', 'Abziehbare Vorsteuer nach ? 13b UStG 19%',                                 'A', 'E',         'AP_tax:IC_taxpart:IC_taxservice', '1407', 0,    NULL, NULL, NULL, 27,   FALSE);


  		




  
  38
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1408', 'Abziehbare Vorsteuer nach ? 13b UStG',                                     'A', 'E',         'AP_tax:IC_taxpart:IC_taxservice', '1408', 0,    NULL, NULL, NULL, 27,   FALSE);


  		




  
  39
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1409', 'Abziehbare Vorsteuer nach ? 13b UStG 16%',                                 'A', 'E',         'AP_tax:IC_taxpart:IC_taxservice', '1408', 0,    NULL, NULL, NULL, 27,   FALSE);


  		




  40
  40
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1432', 'abziehb. VorSt EU-Erwerb Neufzg.b.Lief. o. USt-IdNr.',                     'A', 'E',         'AR_tax',                                 '1483', 0,    NULL, NULL, NULL, 27,   FALSE);


  		




  41
  41
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1433', 'Bezahlte Einfuhrumsatzsteuer',                                             'A', 'E',         '',                                       '1433', 0,    62,   NULL, NULL, NULL, FALSE);


  		




  42
  42
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1460', 'Geldtransit',                                                              'A', 'A',         '',                                       '1460', 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);


  		




  62
  62
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3307', 'Verbindlk. aus LuL ohne Vorsteuer (E?R)',                                  'A', 'L',         'AP',                                     '3307', 0,    NULL, NULL, NULL, NULL, FALSE);


  		




  63
  63
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3309', 'Gegenkonto 3305-3307 bei Auteilung d. Forder. nach Steuers?tzen (E?R)',    'A', 'L',         '',                                       '3309', 0,    NULL, NULL, NULL, NULL, FALSE);


  		




  64
  
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3801', 'Umsatzsteuer 7%',                                                          'A', 'I',         'AR_tax:IC_taxpart:IC_taxservice:CT_tax', '3801', 0,    NULL, NULL, NULL, 5,    FALSE);


  		




  
  64
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3801', 'Umsatzsteuer 7%',                                                          'A', 'I',         'AR_tax:IC_taxpart:IC_taxservice', '3801', 0,    NULL, NULL, NULL, 5,    FALSE);


  		




  65
  65
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3802', 'Umsatzsteuer aus innergemeinschftl. Erwerb',                               'A', 'I',         'AR_tax:IC_taxpart:IC_taxservice',        '3802', 0,    NULL, NULL, NULL, 6,    FALSE);


  		




  66
  66
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3803', 'Umsatzsteuer aus innergemeinschftl. Erwerb 16%',                           'A', 'I',         'AR_tax:IC_taxpart:IC_taxservice',        '3803', 0,    NULL, NULL, NULL, 28,   FALSE);


  		




  67
  67
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3804', 'Umsatzsteuer aus innergemeinschftl. Erwerb 19%',                           'A', 'I',         'AR_tax:IC_taxpart:IC_taxservice',        '3803', 0,    NULL, NULL, NULL, 28,   FALSE);


  		




  68
  
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3805', 'Umsatzsteuer 16%',                                                         'A', 'I',         'AR_tax:IC_taxpart:IC_taxservice:CT_tax', '3805', 0,    NULL, NULL, NULL, 6,    FALSE);


  		




  69
  
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3806', 'Umsatzsteuer 19%',                                                         'A', 'I',         'AR_tax:IC_taxpart:IC_taxservice:CT_tax', '3805', 0,    511,  NULL, NULL, 6,    FALSE);


  		




  
  68
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3805', 'Umsatzsteuer 16%',                                                         'A', 'I',         'AR_tax:IC_taxpart:IC_taxservice', '3805', 0,    NULL, NULL, NULL, 6,    FALSE);


  		




  
  69
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3806', 'Umsatzsteuer 19%',                                                         'A', 'I',         'AR_tax:IC_taxpart:IC_taxservice', '3805', 0,    511,  NULL, NULL, 6,    FALSE);


  		




  70
  70
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3817', 'Umsatzsteuer aus in anderen EG-Land stpfl. Lieferungen',                   'A', ' ',         '',                                       '3817', 10,   NULL, 0,    NULL, NULL, FALSE);


  		




  71
  71
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3820', 'Umsatzsteuer-Vorauszahlungen',                                             'A', 'E',         '',                                       '3820', 0,    NULL, NULL, NULL, 28,   FALSE);


  		




  72
  72
  
    
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3830', 'Umsatzsteuer-Vorauszahlungen 1/11',                                        'A', 'E',         '',                                       '3830', 0,    NULL, NULL, NULL, 28,   FALSE);


  		












  

    
      sql/Pg-upgrade/Pg-upgrade-2.2.0.31-2.2.0.32.pl
    
  





  26
  26
  
    
  if (!$count) {


  		




  27
  27
  
    
    $query =


  		




  28
  28
  
    
      qq|INSERT INTO chart (accno, description, charttype, category, link, taxkey_id, pos_ustva, pos_eur)


  		




  29
  
  
    
      VALUES ('1776','Umsatzsteuer 19 %', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax', 0, 511,6)|;


  		




  
  29
  
    
      VALUES ('1776','Umsatzsteuer 19 %', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', 0, 511,6)|;


  		




  30
  30
  
    
    $dbh->do($query) || mydberror($query);


  		




  31
  31
  
    
  }


  		




  32
  32
  
    
  $query = "SELECT COUNT(*) FROM chart " .


  		




  ......




  36
  36
  
    
  if (!$count) {


  		




  37
  37
  
    
    $query =


  		




  38
  38
  
    
      qq|INSERT INTO chart (accno, description, charttype, category, link, taxkey_id, pos_ustva, pos_eur)


  		




  39
  
  
    
      VALUES ('1576','Abziehbare Vorsteuer 19 %', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', 0, 66,27)|;


  		




  
  39
  
    
      VALUES ('1576','Abziehbare Vorsteuer 19 %', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', 0, 66,27)|;


  		




  40
  40
  
    
    $dbh->do($query) || mydberror($query);


  		




  41
  41
  
    
  }


  		




  42
  42
  
    

  		




  ......




  69
  69
  
    
  if (!$count) {


  		




  70
  70
  
    
    $query =


  		




  71
  71
  
    
      qq|INSERT INTO chart (accno, description, charttype, category, link, taxkey_id, pos_ustva, pos_eur)


  		




  72
  
  
    
      VALUES ('3806','Umsatzsteuer 19 %', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax', 0, 511,6)|;


  		




  
  72
  
    
      VALUES ('3806','Umsatzsteuer 19 %', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', 0, 511,6)|;


  		




  73
  73
  
    
    $dbh->do($query) || mydberror($query);


  		




  74
  74
  
    
  }


  		




  75
  75
  
    
  $query = "SELECT COUNT(*) FROM chart " .


  		




  ......




  79
  79
  
    
  if (!$count) {


  		




  80
  80
  
    
    $query =


  		




  81
  81
  
    
      qq|INSERT INTO chart (accno, description, charttype, category, link, taxkey_id, pos_ustva, pos_eur)


  		




  82
  
  
    
      VALUES ('1406','Abziehbare Vorsteuer 19 %', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', 0, 66,27)|;


  		




  
  82
  
    
      VALUES ('1406','Abziehbare Vorsteuer 19 %', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', 0, 66,27)|;


  		




  83
  83
  
    
    $dbh->do($query) || mydberror($query);


  		




  84
  84
  
    
  }


  		




  85
  85
  
    

  		












  

    
      sql/Pg-upgrade2/ustva_setup_2007_update_chart_taxkeys_tax.sql
    
  





  18
  18
  
    
  )


  		




  19
  19
  
    
SELECT


  		




  20
  20
  
    
  '1570','Anrechenbare Vorsteuer',


  		




  21
  
  
    
  'A',         'E',       'AP_tax:IC_taxpart:IC_taxservice:CT_tax',


  		




  
  21
  
    
  'A',         'E',       'AP_tax:IC_taxpart:IC_taxservice',


  		




  22
  22
  
    
  0


  		




  23
  23
  
    
WHERE EXISTS ( -- update only for SKR03


  		




  24
  24
  
    
    SELECT coa FROM defaults


  		




  ......




  33
  33
  
    
  )


  		




  34
  34
  
    
SELECT


  		




  35
  35
  
    
  '1574','Abziehbare Vorsteuer aus innergem. Erwerb 19 %',


  		




  36
  
  
    
  'A',         'E',       'AP_tax:IC_taxpart:IC_taxservice:CT_tax',


  		




  
  36
  
    
  'A',         'E',       'AP_tax:IC_taxpart:IC_taxservice',


  		




  37
  37
  
    
  0


  		




  38
  38
  
    
WHERE EXISTS ( -- update only for SKR03


  		




  39
  39
  
    
    SELECT coa FROM defaults


  		




  ......




  48
  48
  
    
  )


  		




  49
  49
  
    
SELECT


  		




  50
  50
  
    
  '1774','Umsatzsteuer aus innergem. Erwerb 19 %',


  		




  51
  
  
    
  'A',         'I',       'AR_tax:IC_taxpart:IC_taxservice:CT_tax',


  		




  
  51
  
    
  'A',         'I',       'AR_tax:IC_taxpart:IC_taxservice',


  		




  52
  52
  
    
  0


  		




  53
  53
  
    
WHERE EXISTS ( -- update only for SKR03


  		




  54
  54
  
    
    SELECT coa FROM defaults


  		












  

    
      sql/Swiss-German-chart.sql
    
  





  21
  21
  
    
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21205','Leasing','A','21200','L','AP');


  		




  22
  22
  
    
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21210','Kurzfristige Finanzverbindlichkeiten','H','21000','L','');


  		




  23
  23
  
    
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21220','Andere kurzfristige Verbindlichkeiten','H','21000','L','');


  		




  24
  
  
    
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21222','MWST (3,6)','A','21220','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice:CT_tax');


  		




  
  24
  
    
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21222','MWST (3,6)','A','21220','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');


  		




  25
  25
  
    
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21229','Gewinnaussch?ttung','A','21220','L','');


  		




  26
  26
  
    
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21230','Passive Rechnungsabgrenzung, kurzfristige R?ckstellungen','H','21000','L','');


  		




  27
  27
  
    
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21235','R?ckstellungen','A','21230','L','');


  		




  ......




  133
  133
  
    
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('36002','Reise (Fahrt)','A','36000','I','IC_income');


  		




  134
  134
  
    
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11117','MWST Vorsteuer auf Aufwand','A','11110','A','');


  		




  135
  135
  
    
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21228','Geschuldete Steuern','A','21220','L','AP');


  		




  136
  
  
    
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21223','MWST (7,6)','A','21220','L','AR_tax:AP_tax:IC_taxpart:IC_expense:IC_taxservice:CT_tax');


  		




  
  136
  
    
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21223','MWST (7,6)','A','21220','L','AR_tax:AP_tax:IC_taxpart:IC_expense:IC_taxservice');


  		




  137
  137
  
    
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('57001','AHV, IV, EO, ALV','A','57000','E','AP_amount:IC_income:IC_expense');


  		




  138
  
  
    
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21221','MWST (2,4)','A','21220','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice:CT_tax');


  		




  139
  
  
    
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21224','MWST (7.6) 1/2','A','21220','L','AR_tax:AP_tax:IC_taxpart:IC_expense:IC_taxservice:CT_tax');


  		




  
  138
  
    
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21221','MWST (2,4)','A','21220','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');


  		




  
  139
  
    
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21224','MWST (7.6) 1/2','A','21220','L','AR_tax:AP_tax:IC_taxpart:IC_expense:IC_taxservice');


  		




  140
  140
  
    
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('66001','Werbeaufwand','A','66000','E','AP_amount:IC_expense');


  		




  141
  141
  
    
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21217','Privat','A','21210','L','AP');


  		




  142
  142
  
    
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11101','Kasse','A','11100','A','AR_paid:AP_paid');


  		












Auch abrufbar als:  Unified diff