projects / kivitendo-erp.git / commitdiff
? search:
summary | shortlog | log | commit | commitdiff | tree
raw | patch | inline | side by side (parent: 8f2af1b)
booking roundings to new standard-accounts
authorRolf Fluehmann <rolf.fluehmann@revamp-it.ch>
Mon, 21 Jul 2014 09:38:56 +0000 (11:38 +0200)
committerRolf Fluehmann <rolf.fluehmann@revamp-it.ch>
Fri, 16 Oct 2015 11:26:04 +0000 (13:26 +0200)
Conflicts:
SL/Controller/ClientConfig.pm
SL/DB/MetaSetup/Default.pm
locale/de/all

16 files changed:
SL/DB/MetaSetup/Default.pm patch | blob | history
SL/Form.pm patch | blob | history
SL/IS.pm patch | blob | history
SL/OE.pm patch | blob | history
bin/mozilla/am.pl patch | blob | history
bin/mozilla/is.pl patch | blob | history
bin/mozilla/oe.pl patch | blob | history
locale/de/all patch | blob | history
locale/en/all patch | blob | history
sql/Switzerland-deutsch-MWST-2014-chart.sql [new file with mode: 0644] patch | blob
sql/Switzerland-deutsch-ohneMWST-2014-chart.sql [new file with mode: 0644] patch | blob
templates/webpages/am/edit_accounts.html patch | blob | history
templates/webpages/client_config/_default_accounts.html patch | blob | history
templates/webpages/is/form_footer.html patch | blob | history
templates/webpages/is/form_header.html patch | blob | history
templates/webpages/oe/form_footer.html patch | blob | history

diff --git a/SL/DB/MetaSetup/Default.pm b/SL/DB/MetaSetup/Default.pm
index e8340c8..f17c71d 100644 (file)
--- a/SL/DB/MetaSetup/Default.pm
+++ b/SL/DB/MetaSetup/Default.pm
@@ -85,6 +85,8 @@ __PACKAGE__->meta->columns(
   revtrans                                  => { type => 'boolean', default => 'false' },
   rfqnumber                                 => { type => 'text' },
   rmanumber                                 => { type => 'text' },
+  rndgain_accno_id                          => { type => 'integer'},
+  rndloss_accno_id                          => { type => 'integer'},
   sales_delivery_order_show_delete          => { type => 'boolean', default => 'true' },
   sales_order_show_delete                   => { type => 'boolean', default => 'true' },
   sales_purchase_order_ship_missing_column  => { type => 'boolean', default => 'false' },
diff --git a/SL/Form.pm b/SL/Form.pm
index 35050a0..339d2bb 100644 (file)
--- a/SL/Form.pm
+++ b/SL/Form.pm
@@ -2882,7 +2882,9 @@ sub create_links {
            d.closedto, d.revtrans,
            (SELECT cu.name FROM currencies cu WHERE cu.id=d.currency_id) AS defaultcurrency,
            (SELECT c.accno FROM chart c WHERE d.fxgain_accno_id = c.id) AS fxgain_accno,
-           (SELECT c.accno FROM chart c WHERE d.fxloss_accno_id = c.id) AS fxloss_accno
+           (SELECT c.accno FROM chart c WHERE d.fxloss_accno_id = c.id) AS fxloss_accno,
+           (SELECT c.accno FROM chart c WHERE d.rndgain_accno_id = c.id) AS rndgain_accno,
+           (SELECT c.accno FROM chart c WHERE d.rndloss_accno_id = c.id) AS rndloss_accno
          FROM defaults d|;
     $ref = selectfirst_hashref_query($self, $dbh, $query);
     map { $self->{$_} = $ref->{$_} } keys %$ref;
@@ -2895,7 +2897,9 @@ sub create_links {
             current_date AS transdate, d.closedto, d.revtrans,
             (SELECT cu.name FROM currencies cu WHERE cu.id=d.currency_id) AS defaultcurrency,
             (SELECT c.accno FROM chart c WHERE d.fxgain_accno_id = c.id) AS fxgain_accno,
-            (SELECT c.accno FROM chart c WHERE d.fxloss_accno_id = c.id) AS fxloss_accno
+            (SELECT c.accno FROM chart c WHERE d.fxloss_accno_id = c.id) AS fxloss_accno,
+           (SELECT c.accno FROM chart c WHERE d.rndgain_accno_id = c.id) AS rndgain_accno,
+           (SELECT c.accno FROM chart c WHERE d.rndloss_accno_id = c.id) AS rndloss_accno
           FROM defaults d|;
     $ref = selectfirst_hashref_query($self, $dbh, $query);
     map { $self->{$_} = $ref->{$_} } keys %$ref;
diff --git a/SL/IS.pm b/SL/IS.pm
index 62ba10e..7ac0746 100644 (file)
--- a/SL/IS.pm
+++ b/SL/IS.pm
@@ -966,9 +966,12 @@ SQL
     }
   }
 
-  $form->{amount}{ $form->{id} }{ $form->{AR} } = $netamount + $tax;
-  $form->{paid} =
-    $form->round_amount($form->{paid} * $form->{exchangerate} + $diff, 2);
+  # Invoice Summary includes Rounding
+  my $totalamount = $netamount + $tax;
+  my $rounding = $form->round_amount( $form->round_amount( $totalamount, 2, 1 ) - $totalamount, 2 );
+  my $rnd_accno = $rounding == 0 ? 0 : $rounding > 0 ? $form->{rndgain_accno} : $form->{rndloss_accno};
+  $form->{amount}{ $form->{id} }{ $form->{AR} } = $totalamount = $form->round_amount( $totalamount, 2, 1 );
+  $form->{paid} = $form->round_amount($form->{paid} * $form->{exchangerate} + $diff, 2);
 
   # reverse AR
   $form->{amount}{ $form->{id} }{ $form->{AR} } *= -1;
@@ -986,9 +989,7 @@ SQL
   foreach my $trans_id (keys %{ $form->{amount_cogs} }) {
     foreach my $accno (keys %{ $form->{amount_cogs}{$trans_id} }) {
       next unless ($form->{expense_inventory} =~ /\Q$accno\E/);
-
       $form->{amount_cogs}{$trans_id}{$accno} = $form->round_amount($form->{amount_cogs}{$trans_id}{$accno}, 2);
-
       if (!$payments_only && ($form->{amount_cogs}{$trans_id}{$accno} != 0)) {
         $query =
           qq|INSERT INTO acc_trans (trans_id, chart_id, amount, transdate, tax_id, taxkey, project_id, chart_link)
@@ -1001,7 +1002,6 @@ SQL
 
     foreach my $accno (keys %{ $form->{amount_cogs}{$trans_id} }) {
       $form->{amount_cogs}{$trans_id}{$accno} = $form->round_amount($form->{amount_cogs}{$trans_id}{$accno}, 2);
-
       if (!$payments_only && ($form->{amount_cogs}{$trans_id}{$accno} != 0)) {
         $query =
           qq|INSERT INTO acc_trans (trans_id, chart_id, amount, transdate, tax_id, taxkey, project_id, chart_link)
@@ -1015,9 +1015,7 @@ SQL
   foreach my $trans_id (keys %{ $form->{amount} }) {
     foreach my $accno (keys %{ $form->{amount}{$trans_id} }) {
       next unless ($form->{expense_inventory} =~ /\Q$accno\E/);
-
       $form->{amount}{$trans_id}{$accno} = $form->round_amount($form->{amount}{$trans_id}{$accno}, 2);
-
       if (!$payments_only && ($form->{amount}{$trans_id}{$accno} != 0)) {
         $query =
           qq|INSERT INTO acc_trans (trans_id, chart_id, amount, transdate, tax_id, taxkey, project_id, chart_link)
@@ -1043,10 +1041,8 @@ SQL
         $form->{amount}{$trans_id}{$accno} = 0;
       }
     }
-
     foreach my $accno (keys %{ $form->{amount}{$trans_id} }) {
       $form->{amount}{$trans_id}{$accno} = $form->round_amount($form->{amount}{$trans_id}{$accno}, 2);
-
       if (!$payments_only && ($form->{amount}{$trans_id}{$accno} != 0)) {
         $query =
           qq|INSERT INTO acc_trans (trans_id, chart_id, amount, transdate, tax_id, taxkey, project_id, chart_link)
@@ -1071,6 +1067,14 @@ SQL
         do_query($form, $dbh, $query, @values);
       }
     }
+    if (!$payments_only && ($rnd_accno != 0)) {
+      $query =
+        qq|INSERT INTO acc_trans (trans_id, chart_id, amount, transdate, tax_id, taxkey, project_id, chart_link)
+             VALUES (?, (SELECT id FROM chart WHERE accno = ?), ?, ?, (SELECT id FROM tax WHERE taxkey=0), 0, ?, (SELECT link FROM chart WHERE accno = ?))|;
+      @values = (conv_i($trans_id), $rnd_accno, $rounding, conv_date($form->{invdate}), conv_i($project_id), $rnd_accno);
+      do_query($form, $dbh, $query, @values);
+      $rnd_accno = 0;
+    }
   }
 
   # deduct payment differences from diff
@@ -1233,7 +1237,7 @@ SQL
     return;
   }
 
-  $amount = $netamount + $tax;
+  $amount = $form->round_amount( $netamount + $tax, 2, 1);
 
   # save AR record
   #erweiterung fuer lieferscheinnummer (donumber) 12.02.09 jb
@@ -1871,7 +1875,9 @@ sub retrieve_invoice {
          (SELECT c.accno FROM chart c WHERE d.income_accno_id = c.id)    AS income_accno,
          (SELECT c.accno FROM chart c WHERE d.expense_accno_id = c.id)   AS expense_accno,
          (SELECT c.accno FROM chart c WHERE d.fxgain_accno_id = c.id)    AS fxgain_accno,
-         (SELECT c.accno FROM chart c WHERE d.fxloss_accno_id = c.id)    AS fxloss_accno
+         (SELECT c.accno FROM chart c WHERE d.fxloss_accno_id = c.id)    AS fxloss_accno,
+         (SELECT c.accno FROM chart c WHERE d.rndgain_accno_id = c.id)    AS rndgain_accno,
+         (SELECT c.accno FROM chart c WHERE d.rndloss_accno_id = c.id)    AS rndloss_accno
          ${query_transdate}
        FROM defaults d|;
 
diff --git a/SL/OE.pm b/SL/OE.pm
index 36cbcd1..07484f9 100644 (file)
--- a/SL/OE.pm
+++ b/SL/OE.pm
@@ -625,7 +625,7 @@ SQL
   my $tax = 0;
   map { $tax += $form->round_amount($taxaccounts{$_}, 2) } keys %taxaccounts;
 
-  $amount = $form->round_amount($netamount + $tax, 2);
+  $amount = $form->round_amount($netamount + $tax + $form->{invtotal}, 2, 1);
   $netamount = $form->round_amount($netamount, 2);
 
   if ($form->{currency} eq $form->{defaultcurrency}) {
@@ -891,7 +891,9 @@ sub retrieve {
                      (SELECT c.accno FROM chart c WHERE d.income_accno_id    = c.id) AS income_accno,
                      (SELECT c.accno FROM chart c WHERE d.expense_accno_id   = c.id) AS expense_accno,
                      (SELECT c.accno FROM chart c WHERE d.fxgain_accno_id    = c.id) AS fxgain_accno,
-                     (SELECT c.accno FROM chart c WHERE d.fxloss_accno_id    = c.id) AS fxloss_accno
+                     (SELECT c.accno FROM chart c WHERE d.fxloss_accno_id    = c.id) AS fxloss_accno,
+                     (SELECT c.accno FROM chart c WHERE d.rndgain_accno_id    = c.id) AS rndgain_accno,
+                     (SELECT c.accno FROM chart c WHERE d.rndloss_accno_id    = c.id) AS rndloss_accno
               $query_add
               FROM defaults d|;
   my $ref = selectfirst_hashref_query($form, $dbh, $query);
diff --git a/bin/mozilla/am.pl b/bin/mozilla/am.pl
index e9c1abc..4d4465e 100644 (file)
--- a/bin/mozilla/am.pl
+++ b/bin/mozilla/am.pl
@@ -584,7 +584,7 @@ sub delete_account {
   $form->{title} = $locale->text('Delete Account');
 
   foreach my $id (
-    qw(inventory_accno_id income_accno_id expense_accno_id fxgain_accno_id fxloss_accno_id)
+    qw(inventory_accno_id income_accno_id expense_accno_id fxgain_accno_id fxloss_accno_id rndgain_accno_id rndloss_accno_id)
     ) {
     if ($form->{id} == $form->{$id}) {
       $form->error($locale->text('Cannot delete default account!'));
diff --git a/bin/mozilla/is.pl b/bin/mozilla/is.pl
index fdcf5e1..bbbd157 100644 (file)
--- a/bin/mozilla/is.pl
+++ b/bin/mozilla/is.pl
@@ -462,7 +462,10 @@ sub form_footer {
       }
     }
   }
-  $form->{invtotal} = $form->round_amount($form->{invtotal}, 2, 1);
+
+  my $total = $form->round_amount( $form->{invtotal}, 2, 1 );
+  $form->{rounding} = $form->round_amount( $total-$form->{invtotal}, 2 );
+  $form->{invtotal} = $total;
 
   # follow ups
   if ($form->{id}) {
diff --git a/bin/mozilla/oe.pl b/bin/mozilla/oe.pl
index ea2cffa..565a403 100644 (file)
--- a/bin/mozilla/oe.pl
+++ b/bin/mozilla/oe.pl
@@ -535,9 +535,6 @@ sub form_footer {
               </tr> |;
       }
     }
-
-#    $form->{invsubtotal} = $form->format_amount(\%myconfig, $form->{invsubtotal}, 2, 0); # template does this
-
   } else {
     foreach my $item (split / /, $form->{taxaccounts}) {
       if ($form->{"${item}_base"}) {
@@ -559,7 +556,10 @@ sub form_footer {
     }
   }
 
-  $form->{oldinvtotal} = $form->{invtotal};
+  # beware numeric effects
+  $form->{oldinvtotal} = $form->round_amount( $form->{invtotal},2,1 );
+  $form->{rounding} = $form->round_amount( $form->{oldinvtotal}-$form->{invtotal}, 2 );
+  $form->{invtotal} = $form->{oldinvtotal};
 
   $TMPL_VAR{ALL_DELIVERY_TERMS} = SL::DB::Manager::DeliveryTerm->get_all_sorted();
 
@@ -625,7 +625,7 @@ sub update {
     if ($form->{type} =~ /^sales/) {
       IS->retrieve_item(\%myconfig, \%$form);
       $mode = 'IS';
-    } else {
+  } else {
       IR->retrieve_item(\%myconfig, \%$form);
       $mode = 'IR';
     }
diff --git a/locale/de/all b/locale/de/all
index 579c5d2..d44e374 100755 (executable)
--- a/locale/de/all
+++ b/locale/de/all
@@ -2243,6 +2243,9 @@ $self->{texts} = {
   'Risk'                        => 'Risiko',
   'Risk levels'                 => 'Risikograde',
   'Risks'                       => 'Risikograde',
+  'Rounding'                    => 'Rundung',
+  'Rounding Gain'               => 'Rundungserträge',
+  'Rounding Loss'               => 'Rundungsaufwendungen',
   'Row'                         => 'Zeile',
   'Row #1: amount has to be different from zero.' => 'Zeile #1: Der Wert darf nicht 0 sein.',
   'Row number'                  => 'Zeilennummer',
diff --git a/locale/en/all b/locale/en/all
index bcbf323..65da465 100644 (file)
--- a/locale/en/all
+++ b/locale/en/all
@@ -1780,6 +1780,9 @@ $self->{texts} = {
   'Revenues EU without UStId'   => '',
   'Review of Aging list'        => '',
   'Right'                       => '',
+  'Rounding'                    => '',
+  'Rounding Gain'               => '',
+  'Rounding Loss'               => '',
   'Row #1: amount has to be different from zero.' => '',
   'Row number'                  => '',
   'Row was created from current record' => '',
diff --git a/sql/Switzerland-deutsch-MWST-2014-chart.sql b/sql/Switzerland-deutsch-MWST-2014-chart.sql
new file mode 100644 (file)
index 0000000..a2fa115
--- /dev/null
+++ b/sql/Switzerland-deutsch-MWST-2014-chart.sql
@@ -0,0 +1,463 @@
+-- deutschsprachiger Kontenplan nach Schweizer Kontenrahmen KMU für Firmen in der Schweiz, die mehrwertsteuerpflichtig sind
+-- Erstellt am 4.6.2014
+-- Grundlage: Revision OR Stand 1.1.2013, insbesondere Art. 957a Abs. 2 
+-- Redaktion: Andreas Rudin, http://www.revamp-it.ch
+-- Copyright 2014 Andreas Rudin
+
+-- This file is part of kivitendo.
+-- kivitendo is free software; you can redistribute it and/or modify
+-- it under the terms of the GNU General Public License as published by
+-- the Free Software Foundation; either version 2 of the License, or
+-- (at your option) any later version.
+--
+-- kivitendo is distributed in the hope that it will be useful,
+-- but WITHOUT ANY WARRANTY; without even the implied warranty of
+-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+-- GNU General Public License for more details.
+-- You should have received a copy of the GNU General Public License
+-- along with kivitendo. If not, see <http://www.gnu.org/licenses/>.
+
+DELETE FROM buchungsgruppen;
+
+INSERT INTO buchungsgruppen (id, description, inventory_accno_id, income_accno_id_0, expense_accno_id_0, income_accno_id_1, expense_accno_id_1, income_accno_id_2, expense_accno_id_2, income_accno_id_3, expense_accno_id_3) VALUES
+(1,'Standard',16,72,90,72,90,72,90,72,90);
+
+
+DELETE FROM chart;
+
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik, itime, mtime, new_chart_id, valid_from) VALUES
+(1,1,'AKTIVEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(2,10,'UMLAUFSVERMÖGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(3,100,'Flüssige Mittel','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(4,1000,'Kasse','A','A','AR_paid:AP_paid',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(5,1020,'Postfinance oder Bank1','A','A','AR_paid:AP_paid',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(6,1021,'Bank2','A','A','AR_paid:AP_paid',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(7,106,'Kurzfristig gehaltene Aktiven mit Börsenkurs','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(8,110,'Forderungen aus Lieferungen und Leistungen','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(9,1100,'Forderungen aus Lieferungen und Leistungen','A','A','AR',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(10,114,'Übrige kurzfristige Forderungen','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(11,1140,'Vorschüsse, kurzfristige Darlehen','A','A','AR',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(12,1170,'Vorsteuer auf Aufwand','A','A','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(13,1171,'Vorsteuer auf Investitionen','A','A','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(14,1176,'Verrechnungssteuer','A','A','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(15,120,'Vorräte und nicht fakturierte Dienstleistungen','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(16,1200,'Handelswaren','A','A','IC',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(17,1210,'Rohstoffe','A','A','IC',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(18,1280,'Nicht fakturierte Dienstleistungen','A','A','IC',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(19,1290,'Angefangene Arbeiten','A','A','IC',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(20,130,'Aktive Rechnungsabgrenzungen','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(21,1300,'Aktive Rechnungsabgrenzungen','A','A','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(22,14,'ANLAGEVERMÖGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(23,140,'Finanzanlagen','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(24,148,'Beteiligungen','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(25,150,'Mobile Sachanlagen','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(26,1500,'Maschinen und Apparate','A','A','IC',NULL,6,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(27,1510,'Mobiliar und Einrichtungen','A','A','IC',NULL,6,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(28,1520,'Büromaschinen, Informatik','A','A','IC',NULL,6,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(29,1530,'Fahrzeuge','A','A','IC',NULL,6,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(30,1540,'Werkzeuge und Geräte','A','A','IC',NULL,6,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(31,160,'Immobile Sachanlagen','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(32,170,'Immaterielle Werte','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(33,180,'Nicht einbezahltes Grund- Gesellschafter- oder Stiftungskapital','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(34,2,'PASSIVEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(35,20,'KURZFRISTIGES FREMDKAPITAL','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(36,200,'Verbindlichkeiten aus Lieferungen und Leistungen','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(37,2000,'Verbindlichkeiten aus Lieferungen und Leistungen','A','L','AP',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(38,2001,'Übrige Kreditoren','A','L','AP',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(39,2030,'Anzahlungen von Kundinnen und Kunden','A','L','AR_paid:AP_paid',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(40,210,'Kurzfristige verzinsliche Verbindlichkeiten','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(41,2100,'Bankverbindlichkeiten','A','L','AR_paid:AP_paid',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(42,2140,'Übrige verzinsliche Verbindlichkeiten','A','L','AP',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(43,220,'Übrige kurzfristige Verbindlichkeiten','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(44,2200,'Geschuldete MWST(2,5)','A','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice:CT_tax',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(45,2201,'Geschuldete MWST(8,0)','A','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice:CT_tax',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(46,2206,'Verrechnungssteuer','A','L','AP',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(47,2210,'Geschuldete Steuern','A','L','AP',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(48,2250,'Personalaufwand','A','L','AP',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(49,2270,'Verbindlichkeiten Sozialversicherungen und Vorsorgeeinrichtungen','A','L','AP',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(50,230,'Passive Rechnungsabgrenzungen und kurzfristige Rückstellungen','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(51,2300,'Passive Rechnungsabgrenzungen','A','L','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(52,2330,'Kurzfristige Rückstellungen','A','L','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(53,24,'LANGFRISTIGES FREMDKAPITAL','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(54,240,'Langfristige verzinsliche Verbindlichkeiten','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),(55,2400,'Bankverbindlichkeiten','A','L','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(56,2450,'Langfristige verzinsliche Darlehen','A','L','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(57,250,'Übrige langfristige Verbindlichkeiten','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(58,2500,'Zinslose Darlehen','A','L','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(59,260,'Rückstellungen sowie vom Gesetz vorgesehene ähnliche Positionen','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(60,28,'EIGENKAPITAL','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(61,280,'Grund-, Gesellschafter- oder Stiftungskapital','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(62,2800,'Stammkapital','A','Q','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(63,290,'Reserven, Jahresgewinn oder Jahresverlust','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(64,2900,'Gesetzliche Kapitalreserve','A','Q','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(65,2950,'Gesetzliche Gewinnreserve','A','Q','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(66,2960,'Freiwillige Gewinnreserve','A','Q','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(67,2970,'Gewinn- oder Verlustvortrag','A','Q','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(68,2979,'Jahresgewinn oder -verlust','A','Q','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(69,2980,'Eigene Kapitalanteile','A','Q','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(70,3,'BETRIEBLICHER ERTRAG AUS LIEFERUNGEN UND LEISTUNGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(71,30,'PRODUKTIONSERLÖSE','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(72,3000,'Produktionserlöse','A','I','AR_amount:IC_sale',NULL,2,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(73,32,'HANDELSERLÖSE','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(74,3200,'Handelserlöse','A','I','AR_amount:IC_sale',NULL,2,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(75,34,'DIENSTLEISTUNGSERLÖSE','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(76,3400,'Dienstleistungserlöse','A','I','AR_amount:IC_income',NULL,2,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(77,36,'ÜBRIGE ERLÖSE AUS LIEFERUNGEN UND LEISTUNGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(78,3600,'Übrige Erlöse aus Lieferungen und Leistungen','A','I','IC_income',NULL,2,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(79,37,'EIGENLEISTUNGEN UND EIGENVERBRAUCH','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(80,3700,'Eigenleistungen','A','I','',NULL,2,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(81,38,'ERLÖSMINDERUNGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(82,3800,'Skonti','A','E','IC_sale:IC_cogs:IC_income:IC_expense',NULL,2,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(83,3801,'Rabatte, Preisnachlässe','A','E','IC_sale:IC_cogs:IC_income:IC_expense',NULL,2,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(84,3805,'Verluste aus Forderungen','A','E','IC_sale:IC_cogs:IC_income:IC_expense',NULL,2,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(85,3809,'MWST - nur Saldosteuersatz','A','E','IC_sale:IC_cogs:IC_income:IC_expense',NULL,0,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(86,39,'BESTANDESÄNDERUNGEN AN UNFERTIGEN UND FERTIGEN ERZEUGNISSEN SOWIE AN NICHT FAKTURIERTEN DIENSTLEISTUNGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(87,3900,'Bestandesänderungen','A','I','',NULL,2,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(88,4,'AUFWAND FÜR MATERIAL, HANDELSWAREN, DIENSTLEISTUNGEN UND ENERGIE','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(89,40,'MATERIALAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(90,4000,'Materialeinkauf','A','E','AP_amount:IC_cogs',NULL,4,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(91,42,'HANDELSWARENAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(92,4200,'Einkauf Handelswaren','A','E','AP_amount:IC_cogs',NULL,4,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(93,4208,'Bestandsänderungen Handelswaren','A','E','AP_amount:IC_cogs',NULL,4,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(94,44,'AUFWAND FÜR BEZOGENE DRITTLEISTUNGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(95,4400,'Aufwand für Drittleistungen','A','E','AP_amount:IC_expense',NULL,4,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(96,45,'ENERGIEAUFWAND ZUR LEISTUNGSERSTELLUNG','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(97,4500,'Energieaufwand zur Leistungserstellung','A','E','AP_amount:IC_expense',NULL,4,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(98,46,'ÜBRIGER AUFWAND FÜR MATERIAL, HANDELSWAREN UND DIENSTLEISTUNGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(99,47,'DIREKTE EINKAUFSSPESEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(100,4700,'Einkaufsspesen','A','E','AP_amount:IC_expense',NULL,4,NULL,NULL,NULL,6, 'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(101,48,'BESTANDESÄNDERUNGEN UND MATERIAL-/WARENVERLUSTE','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(102,4800,'Bestandesänderungen','A','E','',NULL,4,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(103,49,'EINKAUFSPREISMINDERUNGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(104,4900,'Skonti, Rabatte, Preisnachlässe','A','I','AP_amount:IC_expense',NULL,4,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(105,5,'PERSONALAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(106,500,'Löhne und Gehälter','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(107,5000,'Löhne und Gehälter','A','E','IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(108,5001,'Erfolgsbeteiligungen','A','E','IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(109,5005,'Leistungen von Sozialversicherungen','A','I','IC_income',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(110,57,'SOZIALVERSICHERUNGSAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(111,5700,'AHV, IV, EO, ALV','A','E','AP_amount:IC_income:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(112,5710,'FAK','A','E','AP_amount:IC_income:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(113,5720,'Berufliche Vorsorge','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(114,5730,'Unfallversicherung','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(115,5740,'Krankentaggeldversicherung','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(116,5790,'Quellensteuer','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(117,58,'ÜBRIGER PERSONALAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(118,5800,'Aufwand für Personaleinstellung','A','E','IC_expense',NULL,6,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(119,5810,'Weiterbildungskosten','A','E','IC_expense',NULL,1,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(120,5830,'Spesen','A','E','IC_expense',NULL,6,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(121,5880,'Sonstiger Personalaufwand','A','E','IC_expense',NULL,6,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(122,59,'LEISTUNGEN DRITTER','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(123,6,'ÜBRIGER BETRIEBLICHER AUFWAND, ABSCHREIBUNGEN UND WERTBERICHTIGUNGEN SOWIE FINANZERGEBNIS','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(124,60,'RAUMAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(125,6000,'Miete','A','E','IC_expense',NULL,6,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(126,6040,'Reinigung','A','E','IC_expense',NULL,6,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(127,6050,'Übriger Raumaufwand','A','E','IC_expense',NULL,6,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(128,61,'UNTERHALT, REPARATUREN, ERSATZ, LEASING, MOBILE SACHANLAGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(129,6100,'Unterhalt','A','E','AP_amount:IC_expense',NULL,6,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(130,62,'FAHRZEUG- UND TRANSPORTAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(131,6200,'Fahrzeugaufwand','A','E','AP_amount:IC_expense',NULL,6,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(132,6201,'Transportaufwand','A','E','AP_amount:IC_expense',NULL,6,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(133,63,'SACHVERSICHERUNGEN, ABGABEN, GEBÜHREN, BEWILLIGUNGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(134,6300,'Betriebsversicherungen','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(135,6360,'Abgaben, Gebühren und Bewilligungen','A','E','AP_amount:IC_expense',NULL,1,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(136,64,'ENERGIE- UND ENTSORGUNGSAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(137,6400,'Strom, Gas, Wasser','A','E','AP_amount:IC_expense',NULL,6,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(138,6460,'Entsorgungsaufwand','A','E','AP_amount:IC_expense',NULL,6,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(139,65,'VERWALTUNGS- UND INFORMATIKAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(140,6500,'Büromaterial, Drucksachen','A','E','AP_amount:IC_expense',NULL,6,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(141,6503,'Fachliteratur','A','E','AP_amount:IC_expense',NULL,6,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(142,6510,'Telefon, Fax, Porti Internet','A','E','AP_amount:IC_expense',NULL,6,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(143,6520,'Beiträge, Spenden','A','E','AP_amount:IC_expense',NULL,1,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(144,6530,'Buchführungs- und Beratungsaufwand','A','E','AP_amount:IC_expense',NULL,6,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(145,6540,'Verwaltungsrat, GV, Revision','A','E','AP_amount:IC_expense',NULL,6,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(146,6570,'Informatikaufwand','A','E','AP_amount:IC_expense',NULL,6,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(147,6590,'Übriger Verwaltungsaufwand','A','E','AP_amount:IC_expense',NULL,6,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(148,66,'WERBEAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(149,6600,'Werbeaufwand','A','E','AP_amount:IC_expense',NULL,6,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(150,67,'SONSTIGER BETRIEBLICHER AUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(151,6720,'Forschung und Entwicklung','A','E','AP_amount:IC_expense',NULL,6,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(152,6790,'Übriger Betriebsaufwand','A','E','AP_amount:IC_expense',NULL,6,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(153,68,'ABSCHREIBUNGEN UND WERTBERICHTIGUNGEN AUF POSITIONEN DES ANLAGEVERMÖGENS','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(154,6800,'Abschreibungen Finanzanlagen','A','E','',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(155,6810,'Abschreibungen Beteiligungen','A','E','',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(156,6820,'Abschreibungen mobile Sachanlagen','A','E','',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(157,6840,'Abschreibungen immaterielle Anlagen','A','E','',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(158,69,'FINANZAUFWAND UND FINANZERTRAG','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(159,690,'Finanzaufwand','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(160,6900,'Finanzaufwand','A','E','',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(161,6940,'Bankspesen','A','E','',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(162,6942,'Kursverluste','A','E','',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(163,6943,'Rundungsaufwand','A','E','',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(164,695,'Finanzertrag','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(165,6950,'Finanzertrag','A','I','',NULL,0,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(166,6952,'Kursgewinne','A','I','',NULL,0,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(167,6953,'Rundungsertrag','A','I','',NULL,0,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(168,6970,'Mitgliederbeiträge','A','I','AR_amount:IC_income',NULL,1,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(169,6980,'Spenden','A','I','AR_amount:IC_income',NULL,1,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),(170,7,'BETRIEBLICHER NEBENERFOLG','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(171,70,'ERFOLG AUS NEBENBETRIEBEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(172,75,'ERFOLG AUS BETRIEBLICHEN LIEGENSCHAFTEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(173,8,'BETRIEBSFREMDER, AUSSERORDENTLICHER, EINMALIGER UND PERIODENFREMDER AUFWAND UND ERTRAG','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(174,80,'BETRIEBSFREMDER AUFWAND UND BETRIEBSFREMDER ERTRAG','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(175,8000,'Betriebsfremder Aufwand','A','E','AP_amount:IC_cogs',NULL,4,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(176,8100,'Betriebsfremder Ertrag','A','I','AR_amount:IC_sale',NULL,2,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(177,85,'AUSSERORDENTLICHER, EINMALIGER AUFWAND UND ERTRAG','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(178,8500,'Ausserordentlicher Aufwand','A','E','AP_amount:IC_cogs',NULL,4,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(179,8510,'Ausserordentlicher Ertrag','A','I','AR_amount:IC_sale',NULL,2,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(180,87,'PERIODENFREMDER AUFWAND UND ERTRAG','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(181,8700,'Periodenfremder Aufwand','A','E','AP_amount:IC_cogs',NULL,4,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(182,8710,'Periodenfremder Ertrag','A','I','AR_amount:IC_sale',NULL,2,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(183,89,'DIREKTE STEUERN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(184,8900,'Direkte Steuern','A','E','',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(185,9,'ABSCHLUSS','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(186,90,'ERFOLGSRECHNUNG','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(187,91,'BILANZ','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(188,9100,'Eröffnungsbilanz','A','E','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(189,92,'GEWINNVERWENDUNG','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(190,95,'JAHRESERGEBNISSE','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(191,99,'HILFSKONTEN NEBENBÜCHER','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL);
+
+
+DELETE FROM defaults;
+
+INSERT INTO defaults (inventory_accno_id, income_accno_id, expense_accno_id, fxgain_accno_id, fxloss_accno_id, invnumber, sonumber, weightunit, businessnumber, version, curr, closedto, revtrans, ponumber, sqnumber, rfqnumber, customernumber, vendornumber, audittrail, articlenumber, servicenumber, coa, itime, mtime, rmanumber, cnnumber, accounting_method, inventory_system, profit_determination) VALUES
+(16,72,90,166,162,0,0,'kg','','3.1.0 CH','CHF:EUR',NULL,'f',0,0,0,0,0,'f',0,0,'Switzerland-deutsch-MWST','2014-01-01 00:00:00.000000',NULL,0,0,'accrual','periodic','balance');
+
+
+DELETE FROM tax;
+
+INSERT INTO tax (rate, taxkey, taxdescription, itime, mtime, id) VALUES
+(0,0,'Keine Steuer','2014-01-01 00:00:00.000000',NULL,0),
+(0,1,'mehrwertsteuerfrei','2014-01-01 00:00:00.000000',NULL,1);
+
+INSERT INTO tax (chart_id, rate, taxnumber, taxkey, taxdescription, itime, mtime, id) VALUES
+(45,0.08000,2201,2,'MWST 8% Verkauf','2014-01-01 00:00:00.000000',NULL,2),
+(44,0.02500,2200,3,'MWST 2.5% Verkauf','2014-01-01 00:00:00.000000',NULL,3),
+(12,0.08000,1170,4,'MWST 8% Aufwand','2014-01-01 00:00:00.000000',NULL,4),
+(12,0.02500,1170,5,'MWST 2.5% Aufwand','2014-01-01 00:00:00.000000',NULL,5),
+(13,0.08000,1171,6,'MWST 8% Investitionen','2014-01-01 00:00:00.000000',NULL,6),
+(13,0.02500,1171,7,'MWST 2.5% Investitionen','2014-01-01 00:00:00.000000',NULL,7);
+
+
+DELETE FROM tax_zones;
+
+INSERT INTO tax_zones (id, description) VALUES
+(0,'Schweiz'),
+(1,'EU mit USt-ID Nummer'),
+(2,'EU ohne USt-ID Nummer'),
+(3,'Ausserhalb EU');
+
+
+DELETE FROM taxkeys;
+
+INSERT INTO taxkeys (id, chart_id, tax_id, taxkey_id, pos_ustva, startdate) VALUES
+(0,0,0,0,NULL,'2014-01-01'),
+(1,1,0,0,NULL,'2014-01-01'),
+(2,2,0,0,NULL,'2014-01-01'),
+(3,3,0,0,NULL,'2014-01-01'),
+(4,4,0,0,NULL,'2014-01-01'),
+(5,5,0,0,NULL,'2014-01-01'),
+(6,6,0,0,NULL,'2014-01-01'),
+(7,7,0,0,NULL,'2014-01-01'),
+(8,8,0,0,NULL,'2014-01-01'),
+(9,9,0,0,NULL,'2014-01-01'),
+(10,10,0,0,NULL,'2014-01-01'),
+(11,11,0,0,NULL,'2014-01-01'),
+(12,12,0,0,NULL,'2014-01-01'),
+(13,13,0,0,NULL,'2014-01-01'),
+(14,14,0,0,NULL,'2014-01-01'),
+(15,15,0,0,NULL,'2014-01-01'),
+(16,16,0,0,NULL,'2014-01-01'),
+(17,17,0,0,NULL,'2014-01-01'),
+(18,18,0,0,NULL,'2014-01-01'),
+(19,19,0,0,NULL,'2014-01-01'),
+(20,20,0,0,NULL,'2014-01-01'),
+(21,21,0,0,NULL,'2014-01-01'),
+(22,22,0,0,NULL,'2014-01-01'),
+(23,23,0,0,NULL,'2014-01-01'),
+(24,24,0,0,NULL,'2014-01-01'),
+(25,25,0,0,NULL,'2014-01-01'),
+(26,26,0,0,NULL,'2014-01-01'),
+(27,27,0,0,NULL,'2014-01-01'),
+(28,28,0,0,NULL,'2014-01-01'),
+(29,29,0,0,NULL,'2014-01-01'),
+(30,30,0,0,NULL,'2014-01-01'),
+(31,31,0,0,NULL,'2014-01-01'),
+(32,32,0,0,NULL,'2014-01-01'),
+(33,33,0,0,NULL,'2014-01-01'),
+(34,34,0,0,NULL,'2014-01-01'),
+(35,35,0,0,NULL,'2014-01-01'),
+(36,36,0,0,NULL,'2014-01-01'),
+(37,37,0,0,NULL,'2014-01-01'),
+(38,38,0,0,NULL,'2014-01-01'),
+(39,39,0,0,NULL,'2014-01-01'),
+(40,40,0,0,NULL,'2014-01-01'),
+(41,41,0,0,NULL,'2014-01-01'),
+(42,42,0,0,NULL,'2014-01-01'),
+(43,43,0,0,NULL,'2014-01-01'),
+(44,44,0,0,NULL,'2014-01-01'),
+(45,45,0,0,NULL,'2014-01-01'),
+(46,46,0,0,NULL,'2014-01-01'),
+(47,47,0,0,NULL,'2014-01-01'),
+(48,48,0,0,NULL,'2014-01-01'),
+(49,49,0,0,NULL,'2014-01-01'),
+(50,50,0,0,NULL,'2014-01-01'),
+(51,51,0,0,NULL,'2014-01-01'),
+(52,52,0,0,NULL,'2014-01-01'),
+(53,53,0,0,NULL,'2014-01-01'),
+(54,54,0,0,NULL,'2014-01-01'),
+(55,55,0,0,NULL,'2014-01-01'),
+(56,56,0,0,NULL,'2014-01-01'),
+(57,57,0,0,NULL,'2014-01-01'),
+(58,58,0,0,NULL,'2014-01-01'),
+(59,59,0,0,NULL,'2014-01-01'),
+(60,60,0,0,NULL,'2014-01-01'),
+(61,61,0,0,NULL,'2014-01-01'),
+(62,62,0,0,NULL,'2014-01-01'),
+(63,63,0,0,NULL,'2014-01-01'),
+(64,64,0,0,NULL,'2014-01-01'),
+(65,65,0,0,NULL,'2014-01-01'),
+(66,66,0,0,NULL,'2014-01-01'),
+(67,67,0,0,NULL,'2014-01-01'),
+(68,68,0,0,NULL,'2014-01-01'),
+(69,69,0,0,NULL,'2014-01-01'),
+(70,70,0,0,NULL,'2014-01-01'),
+(71,71,0,0,NULL,'2014-01-01'),
+(72,72,0,0,NULL,'2014-01-01'),
+(73,73,0,0,NULL,'2014-01-01'),
+(74,74,0,0,NULL,'2014-01-01'),
+(75,75,0,0,NULL,'2014-01-01'),
+(76,76,0,0,NULL,'2014-01-01'),
+(77,77,0,0,NULL,'2014-01-01'),
+(78,78,0,0,NULL,'2014-01-01'),
+(79,79,0,0,NULL,'2014-01-01'),
+(80,80,0,0,NULL,'2014-01-01'),
+(81,81,0,0,NULL,'2014-01-01'),
+(82,82,0,0,NULL,'2014-01-01'),
+(83,83,0,0,NULL,'2014-01-01'),
+(84,84,0,0,NULL,'2014-01-01'),
+(85,85,0,0,NULL,'2014-01-01'),
+(86,86,0,0,NULL,'2014-01-01'),
+(87,87,0,0,NULL,'2014-01-01'),
+(88,88,0,0,NULL,'2014-01-01'),
+(89,89,0,0,NULL,'2014-01-01'),
+(90,90,0,0,NULL,'2014-01-01'),
+(91,91,0,0,NULL,'2014-01-01'),
+(92,92,0,0,NULL,'2014-01-01'),
+(93,93,0,0,NULL,'2014-01-01'),
+(94,94,0,0,NULL,'2014-01-01'),
+(95,95,0,0,NULL,'2014-01-01'),
+(96,96,0,0,NULL,'2014-01-01'),
+(97,97,0,0,NULL,'2014-01-01'),
+(98,98,0,0,NULL,'2014-01-01'),
+(99,99,0,0,NULL,'2014-01-01'),
+(100,100,0,0,NULL,'2014-01-01'),
+(101,101,0,0,NULL,'2014-01-01'),
+(102,102,0,0,NULL,'2014-01-01'),
+(103,103,0,0,NULL,'2014-01-01'),
+(104,104,0,0,NULL,'2014-01-01'),
+(105,105,0,0,NULL,'2014-01-01'),
+(106,106,0,0,NULL,'2014-01-01'),
+(107,107,0,0,NULL,'2014-01-01'),
+(108,108,0,0,NULL,'2014-01-01'),
+(109,109,0,0,NULL,'2014-01-01'),
+(110,110,0,0,NULL,'2014-01-01'),
+(111,111,0,0,NULL,'2014-01-01'),
+(112,112,0,0,NULL,'2014-01-01'),
+(113,113,0,0,NULL,'2014-01-01'),
+(114,114,0,0,NULL,'2014-01-01'),
+(115,115,0,0,NULL,'2014-01-01'),
+(116,116,0,0,NULL,'2014-01-01'),
+(117,117,0,0,NULL,'2014-01-01'),
+(118,118,0,0,NULL,'2014-01-01'),
+(119,119,0,0,NULL,'2014-01-01'),
+(120,120,0,0,NULL,'2014-01-01'),
+(121,121,0,0,NULL,'2014-01-01'),
+(122,122,0,0,NULL,'2014-01-01'),
+(123,123,0,0,NULL,'2014-01-01'),
+(124,124,0,0,NULL,'2014-01-01'),
+(125,125,0,0,NULL,'2014-01-01'),
+(126,126,0,0,NULL,'2014-01-01'),
+(127,127,0,0,NULL,'2014-01-01'),
+(128,128,0,0,NULL,'2014-01-01'),
+(129,129,0,0,NULL,'2014-01-01'),
+(130,130,0,0,NULL,'2014-01-01'),
+(131,131,0,0,NULL,'2014-01-01'),
+(132,132,0,0,NULL,'2014-01-01'),
+(133,133,0,0,NULL,'2014-01-01'),
+(134,134,0,0,NULL,'2014-01-01'),
+(135,135,0,0,NULL,'2014-01-01'),
+(136,136,0,0,NULL,'2014-01-01'),
+(137,137,0,0,NULL,'2014-01-01'),
+(138,138,0,0,NULL,'2014-01-01'),
+(139,139,0,0,NULL,'2014-01-01'),
+(140,140,0,0,NULL,'2014-01-01'),
+(141,141,0,0,NULL,'2014-01-01'),
+(142,142,0,0,NULL,'2014-01-01'),
+(143,143,0,0,NULL,'2014-01-01'),
+(144,144,0,0,NULL,'2014-01-01'),
+(145,145,0,0,NULL,'2014-01-01'),
+(146,146,0,0,NULL,'2014-01-01'),
+(147,147,0,0,NULL,'2014-01-01'),
+(148,148,0,0,NULL,'2014-01-01'),
+(149,149,0,0,NULL,'2014-01-01'),
+(150,150,0,0,NULL,'2014-01-01'),
+(151,151,0,0,NULL,'2014-01-01'),
+(152,152,0,0,NULL,'2014-01-01'),
+(153,153,0,0,NULL,'2014-01-01'),
+(154,154,0,0,NULL,'2014-01-01'),
+(155,155,0,0,NULL,'2014-01-01'),
+(156,156,0,0,NULL,'2014-01-01'),
+(157,157,0,0,NULL,'2014-01-01'),
+(158,158,0,0,NULL,'2014-01-01'),
+(159,159,0,0,NULL,'2014-01-01'),
+(160,160,0,0,NULL,'2014-01-01'),
+(161,161,0,0,NULL,'2014-01-01'),
+(162,162,0,0,NULL,'2014-01-01'),
+(163,163,0,0,NULL,'2014-01-01'),
+(164,164,0,0,NULL,'2014-01-01'),
+(165,165,0,0,NULL,'2014-01-01'),
+(166,166,0,0,NULL,'2014-01-01'),
+(167,167,0,0,NULL,'2014-01-01'),
+(168,168,0,0,NULL,'2014-01-01'),
+(169,169,0,0,NULL,'2014-01-01'),
+(170,170,0,0,NULL,'2014-01-01'),
+(171,171,0,0,NULL,'2014-01-01'),
+(172,172,0,0,NULL,'2014-01-01'),
+(173,173,0,0,NULL,'2014-01-01'),
+(174,174,0,0,NULL,'2014-01-01'),
+(175,175,0,0,NULL,'2014-01-01'),
+(176,176,0,0,NULL,'2014-01-01'),
+(177,177,0,0,NULL,'2014-01-01'),
+(178,178,0,0,NULL,'2014-01-01'),
+(179,179,0,0,NULL,'2014-01-01'),
+(180,180,0,0,NULL,'2014-01-01'),
+(181,181,0,0,NULL,'2014-01-01'),
+(182,182,0,0,NULL,'2014-01-01'),
+(183,183,0,0,NULL,'2014-01-01'),
+(184,184,0,0,NULL,'2014-01-01'),
+(185,185,0,0,NULL,'2014-01-01'),
+(186,186,0,0,NULL,'2014-01-01'),
+(187,187,0,0,NULL,'2014-01-01'),
+(188,188,0,0,NULL,'2014-01-01'),
+(189,189,0,0,NULL,'2014-01-01'),
+(190,190,0,0,NULL,'2014-01-01'),
+(191,191,0,0,NULL,'2014-01-01');
+
+DELETE FROM units;
+
+INSERT INTO units (name, base_unit, factor, type) VALUES
+('Stck',NULL,0.00000,'dimension'),
+('mg',NULL,0.00000,'dimension'),
+('g','mg',1000.00000,'dimension'),
+('kg','g',1000.00000,'dimension'),
+('t','kg',1000.00000,'dimension'),
+('ml',NULL,0.00000,'dimension'),
+('L','ml',1000.00000,'dimension'),
+('pauschal',NULL,0.00000,'service'),
+('Min',NULL,0.00000,'service'),
+('Std','Min',60.00000,'service'),
+('Tag','Std',8.00000,'service'),
+('Wo',NULL,0.00000,'service'),
+('Mt','Wo',4.00000,'service'),
+('Jahr','Mt',12.00000,'service');
+
diff --git a/sql/Switzerland-deutsch-ohneMWST-2014-chart.sql b/sql/Switzerland-deutsch-ohneMWST-2014-chart.sql
new file mode 100644 (file)
index 0000000..ecbbfd4
--- /dev/null
+++ b/sql/Switzerland-deutsch-ohneMWST-2014-chart.sql
@@ -0,0 +1,464 @@
+-- deutschsprachiger Kontenplan nach Schweizer Kontenrahmen KMU für Firmen in der Schweiz, die nicht mehrwertsteuerpflichtig sind
+-- Erstellt am 4.6.2014
+-- Grundlage: Revision OR Stand 1.1.2013, insbesondere Art. 957a Abs. 2 
+-- Redaktion: Andreas Rudin, http://www.revamp-it.ch
+-- Copyright 2014 Andreas Rudin
+
+-- This file is part of kivitendo.
+-- kivitendo is free software; you can redistribute it and/or modify
+-- it under the terms of the GNU General Public License as published by
+-- the Free Software Foundation; either version 2 of the License, or
+-- (at your option) any later version.
+--
+-- kivitendo is distributed in the hope that it will be useful,
+-- but WITHOUT ANY WARRANTY; without even the implied warranty of
+-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+-- GNU General Public License for more details.
+-- You should have received a copy of the GNU General Public License
+-- along with kivitendo. If not, see <http://www.gnu.org/licenses/>.
+
+DELETE FROM buchungsgruppen;
+
+INSERT INTO buchungsgruppen (id, description, inventory_accno_id, income_accno_id_0, expense_accno_id_0, income_accno_id_1, expense_accno_id_1, income_accno_id_2, expense_accno_id_2, income_accno_id_3, expense_accno_id_3) VALUES
+(1,'Standard',16,72,90,72,90,72,90,72,90);
+
+
+DELETE FROM chart;
+
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik, itime, mtime, new_chart_id, valid_from) VALUES
+(1,1,'AKTIVEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(2,10,'UMLAUFSVERMÖGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(3,100,'Flüssige Mittel','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(4,1000,'Kasse','A','A','AR_paid:AP_paid',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(5,1020,'Postfinance oder Bank1','A','A','AR_paid:AP_paid',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(6,1021,'Bank2','A','A','AR_paid:AP_paid',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(7,106,'Kurzfristig gehaltene Aktiven mit Börsenkurs','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(8,110,'Forderungen aus Lieferungen und Leistungen','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(9,1100,'Forderungen aus Lieferungen und Leistungen','A','A','AR',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(10,114,'Übrige kurzfristige Forderungen','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(11,1140,'Vorschüsse, kurzfristige Darlehen','A','A','AR',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(12,1170,'Vorsteuer auf Aufwand','A','A','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(13,1171,'Vorsteuer auf Investitionen','A','A','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(14,1176,'Verrechnungssteuer','A','A','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(15,120,'Vorräte und nicht fakturierte Dienstleistungen','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(16,1200,'Handelswaren','A','A','IC',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(17,1210,'Rohstoffe','A','A','IC',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(18,1280,'Nicht fakturierte Dienstleistungen','A','A','IC',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(19,1290,'Angefangene Arbeiten','A','A','IC',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(20,130,'Aktive Rechnungsabgrenzungen','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(21,1300,'Aktive Rechnungsabgrenzungen','A','A','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(22,14,'ANLAGEVERMÖGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(23,140,'Finanzanlagen','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(24,148,'Beteiligungen','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(25,150,'Mobile Sachanlagen','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(26,1500,'Maschinen und Apparate','A','A','IC',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(27,1510,'Mobiliar und Einrichtungen','A','A','IC',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(28,1520,'Büromaschinen, Informatik','A','A','IC',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(29,1530,'Fahrzeuge','A','A','IC',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(30,1540,'Werkzeuge und Geräte','A','A','IC',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(31,160,'Immobile Sachanlagen','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(32,170,'Immaterielle Werte','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(33,180,'Nicht einbezahltes Grund- Gesellschafter- oder Stiftungskapital','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(34,2,'PASSIVEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(35,20,'KURZFRISTIGES FREMDKAPITAL','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(36,200,'Verbindlichkeiten aus Lieferungen und Leistungen','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(37,2000,'Verbindlichkeiten aus Lieferungen und Leistungen','A','L','AP',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(38,2001,'Übrige Kreditoren','A','L','AP',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(39,2030,'Anzahlungen von Kundinnen und Kunden','A','L','AR_paid:AP_paid',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(40,210,'Kurzfristige verzinsliche Verbindlichkeiten','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(41,2100,'Bankverbindlichkeiten','A','L','AR_paid:AP_paid',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(42,2140,'Übrige verzinsliche Verbindlichkeiten','A','L','AP',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(43,220,'Übrige kurzfristige Verbindlichkeiten','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(44,2200,'Geschuldete MWST(2,5)','A','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice:CT_tax',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(45,2201,'Geschuldete MWST(8,0)','A','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice:CT_tax',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(46,2206,'Verrechnungssteuer','A','L','AP',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(47,2210,'Geschuldete Steuern','A','L','AP',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(48,2250,'Personalaufwand','A','L','AP',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(49,2270,'Verbindlichkeiten Sozialversicherungen und Vorsorgeeinrichtungen','A','L','AP',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(50,230,'Passive Rechnungsabgrenzungen und kurzfristige Rückstellungen','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(51,2300,'Passive Rechnungsabgrenzungen','A','L','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(52,2330,'Kurzfristige Rückstellungen','A','L','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(53,24,'LANGFRISTIGES FREMDKAPITAL','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(54,240,'Langfristige verzinsliche Verbindlichkeiten','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),(55,2400,'Bankverbindlichkeiten','A','L','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(56,2450,'Langfristige verzinsliche Darlehen','A','L','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(57,250,'Übrige langfristige Verbindlichkeiten','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(58,2500,'Zinslose Darlehen','A','L','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(59,260,'Rückstellungen sowie vom Gesetz vorgesehene ähnliche Positionen','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(60,28,'EIGENKAPITAL','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(61,280,'Grund-, Gesellschafter- oder Stiftungskapital','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(62,2800,'Stammkapital','A','Q','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(63,290,'Reserven, Jahresgewinn oder Jahresverlust','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(64,2900,'Gesetzliche Kapitalreserve','A','Q','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(65,2950,'Gesetzliche Gewinnreserve','A','Q','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(66,2960,'Freiwillige Gewinnreserve','A','Q','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(67,2970,'Gewinn- oder Verlustvortrag','A','Q','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(68,2979,'Jahresgewinn oder -verlust','A','Q','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(69,2980,'Eigene Kapitalanteile','A','Q','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(70,3,'BETRIEBLICHER ERTRAG AUS LIEFERUNGEN UND LEISTUNGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(71,30,'PRODUKTIONSERLÖSE','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(72,3000,'Produktionserlöse','A','I','AR_amount:IC_sale',NULL,0,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(73,32,'HANDELSERLÖSE','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(74,3200,'Handelserlöse','A','I','AR_amount:IC_sale',NULL,0,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(75,34,'DIENSTLEISTUNGSERLÖSE','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(76,3400,'Dienstleistungserlöse','A','I','AR_amount:IC_income',NULL,0,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(77,36,'ÜBRIGE ERLÖSE AUS LIEFERUNGEN UND LEISTUNGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(78,3600,'Übrige Erlöse aus Lieferungen und Leistungen','A','I','IC_income',NULL,0,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(79,37,'EIGENLEISTUNGEN UND EIGENVERBRAUCH','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(80,3700,'Eigenleistungen','A','I','',NULL,0,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(81,38,'ERLÖSMINDERUNGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(82,3800,'Skonti','A','E','IC_sale:IC_cogs:IC_income:IC_expense',NULL,0,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(83,3801,'Rabatte, Preisnachlässe','A','E','IC_sale:IC_cogs:IC_income:IC_expense',NULL,0,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(84,3805,'Verluste aus Forderungen','A','E','IC_sale:IC_cogs:IC_income:IC_expense',NULL,0,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(85,3809,'MWST - nur Saldosteuersatz','A','E','IC_sale:IC_cogs:IC_income:IC_expense',NULL,0,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(86,39,'BESTANDESÄNDERUNGEN AN UNFERTIGEN UND FERTIGEN ERZEUGNISSEN SOWIE AN NICHT FAKTURIERTEN DIENSTLEISTUNGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(87,3900,'Bestandesänderungen','A','I','',NULL,0,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(88,4,'AUFWAND FÜR MATERIAL, HANDELSWAREN, DIENSTLEISTUNGEN UND ENERGIE','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(89,40,'MATERIALAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(90,4000,'Materialeinkauf','A','E','AP_amount:IC_cogs',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(91,42,'HANDELSWARENAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(92,4200,'Einkauf Handelswaren','A','E','AP_amount:IC_cogs',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(93,4208,'Bestandsänderungen Handelswaren','A','E','AP_amount:IC_cogs',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(94,44,'AUFWAND FÜR BEZOGENE DRITTLEISTUNGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(95,4400,'Aufwand für Drittleistungen','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(96,45,'ENERGIEAUFWAND ZUR LEISTUNGSERSTELLUNG','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(97,4500,'Energieaufwand zur Leistungserstellung','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(98,46,'ÜBRIGER AUFWAND FÜR MATERIAL, HANDELSWAREN UND DIENSTLEISTUNGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(99,47,'DIREKTE EINKAUFSSPESEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(100,4700,'Einkaufsspesen','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,6, 'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(101,48,'BESTANDESÄNDERUNGEN UND MATERIAL-/WARENVERLUSTE','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(102,4800,'Bestandesänderungen','A','E','',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(103,49,'EINKAUFSPREISMINDERUNGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(104,4900,'Skonti, Rabatte, Preisnachlässe','A','I','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(105,5,'PERSONALAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(106,500,'Löhne und Gehälter','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(107,5000,'Löhne und Gehälter','A','E','IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(108,5001,'Erfolgsbeteiligungen','A','E','IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(109,5005,'Leistungen von Sozialversicherungen','A','I','IC_income',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(110,57,'SOZIALVERSICHERUNGSAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(111,5700,'AHV, IV, EO, ALV','A','E','AP_amount:IC_income:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(112,5710,'FAK','A','E','AP_amount:IC_income:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(113,5720,'Berufliche Vorsorge','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(114,5730,'Unfallversicherung','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(115,5740,'Krankentaggeldversicherung','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(116,5790,'Quellensteuer','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(117,58,'ÜBRIGER PERSONALAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(118,5800,'Aufwand für Personaleinstellung','A','E','IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(119,5810,'Weiterbildungskosten','A','E','IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(120,5830,'Spesen','A','E','IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(121,5880,'Sonstiger Personalaufwand','A','E','IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(122,59,'LEISTUNGEN DRITTER','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(123,6,'ÜBRIGER BETRIEBLICHER AUFWAND, ABSCHREIBUNGEN UND WERTBERICHTIGUNGEN SOWIE FINANZERGEBNIS','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(124,60,'RAUMAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(125,6000,'Miete','A','E','IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(126,6040,'Reinigung','A','E','IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(127,6050,'Übriger Raumaufwand','A','E','IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(128,61,'UNTERHALT, REPARATUREN, ERSATZ, LEASING, MOBILE SACHANLAGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(129,6100,'Unterhalt','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(130,62,'FAHRZEUG- UND TRANSPORTAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(131,6200,'Fahrzeugaufwand','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(132,6201,'Transportaufwand','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(133,63,'SACHVERSICHERUNGEN, ABGABEN, GEBÜHREN, BEWILLIGUNGEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(134,6300,'Betriebsversicherungen','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(135,6360,'Abgaben, Gebühren und Bewilligungen','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(136,64,'ENERGIE- UND ENTSORGUNGSAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(137,6400,'Strom, Gas, Wasser','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(138,6460,'Entsorgungsaufwand','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(139,65,'VERWALTUNGS- UND INFORMATIKAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(140,6500,'Büromaterial, Drucksachen','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(141,6503,'Fachliteratur','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(142,6510,'Telefon, Fax, Porti Internet','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(143,6520,'Beiträge, Spenden','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(144,6530,'Buchführungs- und Beratungsaufwand','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(145,6540,'Verwaltungsrat, GV, Revision','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(146,6570,'Informatikaufwand','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(147,6590,'Übriger Verwaltungsaufwand','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(148,66,'WERBEAUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(149,6600,'Werbeaufwand','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(150,67,'SONSTIGER BETRIEBLICHER AUFWAND','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(151,6720,'Forschung und Entwicklung','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(152,6790,'Übriger Betriebsaufwand','A','E','AP_amount:IC_expense',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(153,68,'ABSCHREIBUNGEN UND WERTBERICHTIGUNGEN AUF POSITIONEN DES ANLAGEVERMÖGENS','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(154,6800,'Abschreibungen Finanzanlagen','A','E','',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(155,6810,'Abschreibungen Beteiligungen','A','E','',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(156,6820,'Abschreibungen mobile Sachanlagen','A','E','',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(157,6840,'Abschreibungen immaterielle Anlagen','A','E','',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(158,69,'FINANZAUFWAND UND FINANZERTRAG','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(159,690,'Finanzaufwand','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(160,6900,'Finanzaufwand','A','E','',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(161,6940,'Bankspesen','A','E','',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(162,6942,'Kursverluste','A','E','',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(163,6943,'Rundungsaufwand','A','E','',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(164,695,'Finanzertrag','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(165,6950,'Finanzertrag','A','I','',NULL,0,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(166,6952,'Kursgewinne','A','I','',NULL,0,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(167,6953,'Rundungsertrag','A','I','',NULL,0,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(168,6970,'Mitgliederbeiträge','A','I','AR_amount:IC_income',NULL,0,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(169,6980,'Spenden','A','I','AR_amount:IC_income',NULL,0,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(170,7,'BETRIEBLICHER NEBENERFOLG','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(171,70,'ERFOLG AUS NEBENBETRIEBEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(172,75,'ERFOLG AUS BETRIEBLICHEN LIEGENSCHAFTEN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(173,8,'BETRIEBSFREMDER, AUSSERORDENTLICHER, EINMALIGER UND PERIODENFREMDER AUFWAND UND ERTRAG','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(174,80,'BETRIEBSFREMDER AUFWAND UND BETRIEBSFREMDER ERTRAG','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(175,8000,'Betriebsfremder Aufwand','A','E','AP_amount:IC_cogs',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(176,8100,'Betriebsfremder Ertrag','A','I','AR_amount:IC_sale',NULL,0,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(177,85,'AUSSERORDENTLICHER, EINMALIGER AUFWAND UND ERTRAG','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(178,8500,'Ausserordentlicher Aufwand','A','E','AP_amount:IC_cogs',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(179,8510,'Ausserordentlicher Ertrag','A','I','AR_amount:IC_sale',NULL,0,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(180,87,'PERIODENFREMDER AUFWAND UND ERTRAG','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(181,8700,'Periodenfremder Aufwand','A','E','AP_amount:IC_cogs',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(182,8710,'Periodenfremder Ertrag','A','I','AR_amount:IC_sale',NULL,0,NULL,NULL,NULL,1,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(183,89,'DIREKTE STEUERN','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(184,8900,'Direkte Steuern','A','E','',NULL,0,NULL,NULL,NULL,6,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(185,9,'ABSCHLUSS','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(186,90,'ERFOLGSRECHNUNG','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(187,91,'BILANZ','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(188,9100,'Eröffnungsbilanz','A','E','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(189,92,'GEWINNVERWENDUNG','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(190,95,'JAHRESERGEBNISSE','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL),
+(191,99,'HILFSKONTEN NEBENBÜCHER','H','','',NULL,0,NULL,NULL,NULL,NULL,'f','2014-01-01 00:00:00.000000',NULL,NULL,NULL);
+
+
+DELETE FROM defaults;
+
+INSERT INTO defaults (inventory_accno_id, income_accno_id, expense_accno_id, fxgain_accno_id, fxloss_accno_id, invnumber, sonumber, weightunit, businessnumber, version, curr, closedto, revtrans, ponumber, sqnumber, rfqnumber, customernumber, vendornumber, audittrail, articlenumber, servicenumber, coa, itime, mtime, rmanumber, cnnumber, accounting_method, inventory_system, profit_determination) VALUES
+(16,72,90,166,162,0,0,'kg','','3.1.0 CH','CHF:EUR',NULL,'f',0,0,0,0,0,'f',0,0,'Switzerland-deutsch-ohneMWST','2014-01-01 00:00:00.000000',NULL,0,0,'accrual','periodic','balance');
+
+
+DELETE FROM tax;
+
+INSERT INTO tax (rate, taxkey, taxdescription, itime, mtime, id) VALUES
+(0,0,'Keine Steuer','2014-01-01 00:00:00.000000',NULL,0),
+(0,1,'mehrwertsteuerfrei','2014-01-01 00:00:00.000000',NULL,1);
+
+INSERT INTO tax (chart_id, rate, taxnumber, taxkey, taxdescription, itime, mtime, id) VALUES
+(45,0.08000,2201,2,'MWST 8% Verkauf','2014-01-01 00:00:00.000000',NULL,2),
+(44,0.02500,2200,3,'MWST 2.5% Verkauf','2014-01-01 00:00:00.000000',NULL,3),
+(12,0.08000,1170,4,'MWST 8% Aufwand','2014-01-01 00:00:00.000000',NULL,4),
+(12,0.02500,1170,5,'MWST 2.5% Aufwand','2014-01-01 00:00:00.000000',NULL,5),
+(13,0.08000,1171,6,'MWST 8% Investitionen','2014-01-01 00:00:00.000000',NULL,6),
+(13,0.02500,1171,7,'MWST 2.5% Investitionen','2014-01-01 00:00:00.000000',NULL,7);
+
+
+DELETE FROM tax_zones;
+
+INSERT INTO tax_zones (id, description) VALUES
+(0,'Schweiz'),
+(1,'EU mit USt-ID Nummer'),
+(2,'EU ohne USt-ID Nummer'),
+(3,'Ausserhalb EU');
+
+
+DELETE FROM taxkeys;
+
+INSERT INTO taxkeys (id, chart_id, tax_id, taxkey_id, pos_ustva, startdate) VALUES
+(0,0,0,0,NULL,'2014-01-01'),
+(1,1,0,0,NULL,'2014-01-01'),
+(2,2,0,0,NULL,'2014-01-01'),
+(3,3,0,0,NULL,'2014-01-01'),
+(4,4,0,0,NULL,'2014-01-01'),
+(5,5,0,0,NULL,'2014-01-01'),
+(6,6,0,0,NULL,'2014-01-01'),
+(7,7,0,0,NULL,'2014-01-01'),
+(8,8,0,0,NULL,'2014-01-01'),
+(9,9,0,0,NULL,'2014-01-01'),
+(10,10,0,0,NULL,'2014-01-01'),
+(11,11,0,0,NULL,'2014-01-01'),
+(12,12,0,0,NULL,'2014-01-01'),
+(13,13,0,0,NULL,'2014-01-01'),
+(14,14,0,0,NULL,'2014-01-01'),
+(15,15,0,0,NULL,'2014-01-01'),
+(16,16,0,0,NULL,'2014-01-01'),
+(17,17,0,0,NULL,'2014-01-01'),
+(18,18,0,0,NULL,'2014-01-01'),
+(19,19,0,0,NULL,'2014-01-01'),
+(20,20,0,0,NULL,'2014-01-01'),
+(21,21,0,0,NULL,'2014-01-01'),
+(22,22,0,0,NULL,'2014-01-01'),
+(23,23,0,0,NULL,'2014-01-01'),
+(24,24,0,0,NULL,'2014-01-01'),
+(25,25,0,0,NULL,'2014-01-01'),
+(26,26,0,0,NULL,'2014-01-01'),
+(27,27,0,0,NULL,'2014-01-01'),
+(28,28,0,0,NULL,'2014-01-01'),
+(29,29,0,0,NULL,'2014-01-01'),
+(30,30,0,0,NULL,'2014-01-01'),
+(31,31,0,0,NULL,'2014-01-01'),
+(32,32,0,0,NULL,'2014-01-01'),
+(33,33,0,0,NULL,'2014-01-01'),
+(34,34,0,0,NULL,'2014-01-01'),
+(35,35,0,0,NULL,'2014-01-01'),
+(36,36,0,0,NULL,'2014-01-01'),
+(37,37,0,0,NULL,'2014-01-01'),
+(38,38,0,0,NULL,'2014-01-01'),
+(39,39,0,0,NULL,'2014-01-01'),
+(40,40,0,0,NULL,'2014-01-01'),
+(41,41,0,0,NULL,'2014-01-01'),
+(42,42,0,0,NULL,'2014-01-01'),
+(43,43,0,0,NULL,'2014-01-01'),
+(44,44,0,0,NULL,'2014-01-01'),
+(45,45,0,0,NULL,'2014-01-01'),
+(46,46,0,0,NULL,'2014-01-01'),
+(47,47,0,0,NULL,'2014-01-01'),
+(48,48,0,0,NULL,'2014-01-01'),
+(49,49,0,0,NULL,'2014-01-01'),
+(50,50,0,0,NULL,'2014-01-01'),
+(51,51,0,0,NULL,'2014-01-01'),
+(52,52,0,0,NULL,'2014-01-01'),
+(53,53,0,0,NULL,'2014-01-01'),
+(54,54,0,0,NULL,'2014-01-01'),
+(55,55,0,0,NULL,'2014-01-01'),
+(56,56,0,0,NULL,'2014-01-01'),
+(57,57,0,0,NULL,'2014-01-01'),
+(58,58,0,0,NULL,'2014-01-01'),
+(59,59,0,0,NULL,'2014-01-01'),
+(60,60,0,0,NULL,'2014-01-01'),
+(61,61,0,0,NULL,'2014-01-01'),
+(62,62,0,0,NULL,'2014-01-01'),
+(63,63,0,0,NULL,'2014-01-01'),
+(64,64,0,0,NULL,'2014-01-01'),
+(65,65,0,0,NULL,'2014-01-01'),
+(66,66,0,0,NULL,'2014-01-01'),
+(67,67,0,0,NULL,'2014-01-01'),
+(68,68,0,0,NULL,'2014-01-01'),
+(69,69,0,0,NULL,'2014-01-01'),
+(70,70,0,0,NULL,'2014-01-01'),
+(71,71,0,0,NULL,'2014-01-01'),
+(72,72,0,0,NULL,'2014-01-01'),
+(73,73,0,0,NULL,'2014-01-01'),
+(74,74,0,0,NULL,'2014-01-01'),
+(75,75,0,0,NULL,'2014-01-01'),
+(76,76,0,0,NULL,'2014-01-01'),
+(77,77,0,0,NULL,'2014-01-01'),
+(78,78,0,0,NULL,'2014-01-01'),
+(79,79,0,0,NULL,'2014-01-01'),
+(80,80,0,0,NULL,'2014-01-01'),
+(81,81,0,0,NULL,'2014-01-01'),
+(82,82,0,0,NULL,'2014-01-01'),
+(83,83,0,0,NULL,'2014-01-01'),
+(84,84,0,0,NULL,'2014-01-01'),
+(85,85,0,0,NULL,'2014-01-01'),
+(86,86,0,0,NULL,'2014-01-01'),
+(87,87,0,0,NULL,'2014-01-01'),
+(88,88,0,0,NULL,'2014-01-01'),
+(89,89,0,0,NULL,'2014-01-01'),
+(90,90,0,0,NULL,'2014-01-01'),
+(91,91,0,0,NULL,'2014-01-01'),
+(92,92,0,0,NULL,'2014-01-01'),
+(93,93,0,0,NULL,'2014-01-01'),
+(94,94,0,0,NULL,'2014-01-01'),
+(95,95,0,0,NULL,'2014-01-01'),
+(96,96,0,0,NULL,'2014-01-01'),
+(97,97,0,0,NULL,'2014-01-01'),
+(98,98,0,0,NULL,'2014-01-01'),
+(99,99,0,0,NULL,'2014-01-01'),
+(100,100,0,0,NULL,'2014-01-01'),
+(101,101,0,0,NULL,'2014-01-01'),
+(102,102,0,0,NULL,'2014-01-01'),
+(103,103,0,0,NULL,'2014-01-01'),
+(104,104,0,0,NULL,'2014-01-01'),
+(105,105,0,0,NULL,'2014-01-01'),
+(106,106,0,0,NULL,'2014-01-01'),
+(107,107,0,0,NULL,'2014-01-01'),
+(108,108,0,0,NULL,'2014-01-01'),
+(109,109,0,0,NULL,'2014-01-01'),
+(110,110,0,0,NULL,'2014-01-01'),
+(111,111,0,0,NULL,'2014-01-01'),
+(112,112,0,0,NULL,'2014-01-01'),
+(113,113,0,0,NULL,'2014-01-01'),
+(114,114,0,0,NULL,'2014-01-01'),
+(115,115,0,0,NULL,'2014-01-01'),
+(116,116,0,0,NULL,'2014-01-01'),
+(117,117,0,0,NULL,'2014-01-01'),
+(118,118,0,0,NULL,'2014-01-01'),
+(119,119,0,0,NULL,'2014-01-01'),
+(120,120,0,0,NULL,'2014-01-01'),
+(121,121,0,0,NULL,'2014-01-01'),
+(122,122,0,0,NULL,'2014-01-01'),
+(123,123,0,0,NULL,'2014-01-01'),
+(124,124,0,0,NULL,'2014-01-01'),
+(125,125,0,0,NULL,'2014-01-01'),
+(126,126,0,0,NULL,'2014-01-01'),
+(127,127,0,0,NULL,'2014-01-01'),
+(128,128,0,0,NULL,'2014-01-01'),
+(129,129,0,0,NULL,'2014-01-01'),
+(130,130,0,0,NULL,'2014-01-01'),
+(131,131,0,0,NULL,'2014-01-01'),
+(132,132,0,0,NULL,'2014-01-01'),
+(133,133,0,0,NULL,'2014-01-01'),
+(134,134,0,0,NULL,'2014-01-01'),
+(135,135,0,0,NULL,'2014-01-01'),
+(136,136,0,0,NULL,'2014-01-01'),
+(137,137,0,0,NULL,'2014-01-01'),
+(138,138,0,0,NULL,'2014-01-01'),
+(139,139,0,0,NULL,'2014-01-01'),
+(140,140,0,0,NULL,'2014-01-01'),
+(141,141,0,0,NULL,'2014-01-01'),
+(142,142,0,0,NULL,'2014-01-01'),
+(143,143,0,0,NULL,'2014-01-01'),
+(144,144,0,0,NULL,'2014-01-01'),
+(145,145,0,0,NULL,'2014-01-01'),
+(146,146,0,0,NULL,'2014-01-01'),
+(147,147,0,0,NULL,'2014-01-01'),
+(148,148,0,0,NULL,'2014-01-01'),
+(149,149,0,0,NULL,'2014-01-01'),
+(150,150,0,0,NULL,'2014-01-01'),
+(151,151,0,0,NULL,'2014-01-01'),
+(152,152,0,0,NULL,'2014-01-01'),
+(153,153,0,0,NULL,'2014-01-01'),
+(154,154,0,0,NULL,'2014-01-01'),
+(155,155,0,0,NULL,'2014-01-01'),
+(156,156,0,0,NULL,'2014-01-01'),
+(157,157,0,0,NULL,'2014-01-01'),
+(158,158,0,0,NULL,'2014-01-01'),
+(159,159,0,0,NULL,'2014-01-01'),
+(160,160,0,0,NULL,'2014-01-01'),
+(161,161,0,0,NULL,'2014-01-01'),
+(162,162,0,0,NULL,'2014-01-01'),
+(163,163,0,0,NULL,'2014-01-01'),
+(164,164,0,0,NULL,'2014-01-01'),
+(165,165,0,0,NULL,'2014-01-01'),
+(166,166,0,0,NULL,'2014-01-01'),
+(167,167,0,0,NULL,'2014-01-01'),
+(168,168,0,0,NULL,'2014-01-01'),
+(169,169,0,0,NULL,'2014-01-01'),
+(170,170,0,0,NULL,'2014-01-01'),
+(171,171,0,0,NULL,'2014-01-01'),
+(172,172,0,0,NULL,'2014-01-01'),
+(173,173,0,0,NULL,'2014-01-01'),
+(174,174,0,0,NULL,'2014-01-01'),
+(175,175,0,0,NULL,'2014-01-01'),
+(176,176,0,0,NULL,'2014-01-01'),
+(177,177,0,0,NULL,'2014-01-01'),
+(178,178,0,0,NULL,'2014-01-01'),
+(179,179,0,0,NULL,'2014-01-01'),
+(180,180,0,0,NULL,'2014-01-01'),
+(181,181,0,0,NULL,'2014-01-01'),
+(182,182,0,0,NULL,'2014-01-01'),
+(183,183,0,0,NULL,'2014-01-01'),
+(184,184,0,0,NULL,'2014-01-01'),
+(185,185,0,0,NULL,'2014-01-01'),
+(186,186,0,0,NULL,'2014-01-01'),
+(187,187,0,0,NULL,'2014-01-01'),
+(188,188,0,0,NULL,'2014-01-01'),
+(189,189,0,0,NULL,'2014-01-01'),
+(190,190,0,0,NULL,'2014-01-01'),
+(191,191,0,0,NULL,'2014-01-01');
+
+DELETE FROM units;
+
+INSERT INTO units (name, base_unit, factor, type) VALUES
+('Stck',NULL,0.00000,'dimension'),
+('mg',NULL,0.00000,'dimension'),
+('g','mg',1000.00000,'dimension'),
+('kg','g',1000.00000,'dimension'),
+('t','kg',1000.00000,'dimension'),
+('ml',NULL,0.00000,'dimension'),
+('L','ml',1000.00000,'dimension'),
+('pauschal',NULL,0.00000,'service'),
+('Min',NULL,0.00000,'service'),
+('Std','Min',60.00000,'service'),
+('Tag','Std',8.00000,'service'),
+('Wo',NULL,0.00000,'service'),
+('Mt','Wo',4.00000,'service'),
+('Jahr','Mt',12.00000,'service');
+
diff --git a/templates/webpages/am/edit_accounts.html b/templates/webpages/am/edit_accounts.html
index 7555b8c..67ca10c 100644 (file)
--- a/templates/webpages/am/edit_accounts.html
+++ b/templates/webpages/am/edit_accounts.html
@@ -27,6 +27,8 @@ $(function() {
 <input type="hidden" name="expense_accno_id"   value="[% HTML.escape(expense_accno_id) %]">
 <input type="hidden" name="fxgain_accno_id"    value="[% HTML.escape(fxgain_accno_id) %]">
 <input type="hidden" name="fxloss_accno_id"    value="[% HTML.escape(fxloss_accno_id) %]">
+<input type="hidden" name="rndgain_accno_id"    value="[% HTML.escape(rndgain_accno_id) %]">
+<input type="hidden" name="rndloss_accno_id"    value="[% HTML.escape(rndloss_accno_id) %]">
 
 <fieldset>
   <legend>
diff --git a/templates/webpages/client_config/_default_accounts.html b/templates/webpages/client_config/_default_accounts.html
index 0a6ec1e..6c6396f 100644 (file)
--- a/templates/webpages/client_config/_default_accounts.html
+++ b/templates/webpages/client_config/_default_accounts.html
@@ -30,6 +30,16 @@
    <td>[% L.chart_picker('defaults.fxloss_accno_id', SELF.defaults.fxloss_accno_id, category='E,A', choose=1, style=style) %]<td>
   </tr>
 
+  <tr>
+   <td align="right">[% LxERP.t8("Rounding Gain") %]</td>
+   <td>[% L.select_tag('defaults.rndgain_accno_id', SELF.accounts.rnd_gain, default=SELF.defaults.rndgain_accno_id, title_sub=\make_chart_title, style=style) %]</td>
+  </tr>
+
+  <tr>
+   <td align="right">[% LxERP.t8("Rounding Loss") %]</td>
+   <td>[% L.select_tag('defaults.rndloss_accno_id', SELF.accounts.rnd_loss, default=SELF.defaults.rndloss_accno_id, title_sub=\make_chart_title, style=style) %]</td>
+  </tr>
+
   <tr>
    <td align="right">[% LxERP.t8("Current assets account") %]</td>
    <td>[% L.chart_picker('defaults.ar_paid_accno_id', SELF.defaults.ar_paid_accno_id, type='AR_paid', choose=1, style=style) %]<td>
diff --git a/templates/webpages/is/form_footer.html b/templates/webpages/is/form_footer.html
index 2c271dd..60e3493 100644 (file)
--- a/templates/webpages/is/form_footer.html
+++ b/templates/webpages/is/form_footer.html
@@ -107,6 +107,13 @@
        </tr>
 [%- END %]
 
+[%- IF rounding %]
+        <tr>
+          <th align='right'>[% 'Rounding' | $T8 %]</th>
+          <td align='right'>[% LxERP.format_amount(rounding, 2) %]</td>
+        </tr>
+[%- END %]
+
 [%# tax %]
 [% FOREACH item = taxaccounts_array %]
 [% SET description_ref = item _ '_description' %]
@@ -124,7 +131,6 @@
        </tr>
   [%- END %]
 [%- END %]
-
         <tr>
          <th align="right">[% 'Total' | $T8 %]</th>
          <td align="right">[% LxERP.format_amount(invtotal, 2) %]</td>
diff --git a/templates/webpages/is/form_header.html b/templates/webpages/is/form_header.html
index 2ccdf5f..234a5e5 100644 (file)
--- a/templates/webpages/is/form_header.html
+++ b/templates/webpages/is/form_header.html
@@ -160,6 +160,8 @@
           <td>
             <input type="hidden" name="fxgain_accno" value="[% fxgain_accno %]">
             <input type="hidden" name="fxloss_accno" value="[% fxloss_accno %]">
+            <input type="hidden" name="rndgain_accno" value="[% rndgain_accno %]">
+            <input type="hidden" name="rndloss_accno" value="[% rndloss_accno %]">
           </td>
         </tr>
 [%- IF show_exchangerate %]
diff --git a/templates/webpages/oe/form_footer.html b/templates/webpages/oe/form_footer.html
index 0956f20..fbeb529 100644 (file)
--- a/templates/webpages/oe/form_footer.html
+++ b/templates/webpages/oe/form_footer.html
@@ -107,6 +107,12 @@
                 <th align='right'>[% 'Subtotal' | $T8 %]</th>
                 <td align='right'>[% LxERP.format_amount(invsubtotal, 2) %]</td>
               </tr>
+[%- END %]
+[%- IF rounding %]
+              <tr>
+                <th align='right'>[% 'Rounding' | $T8 %]</th>
+                <td align='right'>[% LxERP.format_amount(rounding, 2) %]</td>
+              </tr>
 [%- END %]
               [% tax %]
               <tr>
Unnamed repository; edit this file 'description' to name the repository.