From a2930f9ee294b1288488e8dec1a3092592dc8e97 Mon Sep 17 00:00:00 2001 From: Rolf Fluehmann Date: Mon, 21 Jul 2014 11:38:56 +0200 Subject: [PATCH] booking roundings to new standard-accounts Conflicts: SL/Controller/ClientConfig.pm SL/DB/MetaSetup/Default.pm locale/de/all --- SL/DB/MetaSetup/Default.pm | 2 + SL/Form.pm | 8 +- SL/IS.pm | 30 +- SL/OE.pm | 6 +- bin/mozilla/am.pl | 2 +- bin/mozilla/is.pl | 5 +- bin/mozilla/oe.pl | 10 +- locale/de/all | 3 + locale/en/all | 3 + sql/Switzerland-deutsch-MWST-2014-chart.sql | 463 +++++++++++++++++ ...witzerland-deutsch-ohneMWST-2014-chart.sql | 464 ++++++++++++++++++ templates/webpages/am/edit_accounts.html | 2 + .../client_config/_default_accounts.html | 10 + templates/webpages/is/form_footer.html | 8 +- templates/webpages/is/form_header.html | 2 + templates/webpages/oe/form_footer.html | 6 + 16 files changed, 1000 insertions(+), 24 deletions(-) create mode 100644 sql/Switzerland-deutsch-MWST-2014-chart.sql create mode 100644 sql/Switzerland-deutsch-ohneMWST-2014-chart.sql diff --git a/SL/DB/MetaSetup/Default.pm b/SL/DB/MetaSetup/Default.pm index e8340c80e..f17c71d34 100644 --- 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 35050a0c7..339d2bbd2 100644 --- 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 62ba10e18..7ac074616 100644 --- 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 36cbcd1b7..07484f9da 100644 --- 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 e9c1abc96..4d4465e7f 100644 --- 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 fdcf5e1c4..bbbd157a3 100644 --- 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 ea2cffadf..565a40310 100644 --- a/bin/mozilla/oe.pl +++ b/bin/mozilla/oe.pl @@ -535,9 +535,6 @@ sub form_footer { |; } } - -# $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 579c5d2e0..d44e3746d 100755 --- 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 bcbf3234a..65da4655c 100644 --- 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 index 000000000..a2fa115ba --- /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 . + +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 index 000000000..ecbbfd468 --- /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 . + +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 7555b8c3b..67ca10c15 100644 --- a/templates/webpages/am/edit_accounts.html +++ b/templates/webpages/am/edit_accounts.html @@ -27,6 +27,8 @@ $(function() { + +
diff --git a/templates/webpages/client_config/_default_accounts.html b/templates/webpages/client_config/_default_accounts.html index 0a6ec1e31..6c6396fc6 100644 --- a/templates/webpages/client_config/_default_accounts.html +++ b/templates/webpages/client_config/_default_accounts.html @@ -30,6 +30,16 @@ [% L.chart_picker('defaults.fxloss_accno_id', SELF.defaults.fxloss_accno_id, category='E,A', choose=1, style=style) %] + + [% LxERP.t8("Rounding Gain") %] + [% L.select_tag('defaults.rndgain_accno_id', SELF.accounts.rnd_gain, default=SELF.defaults.rndgain_accno_id, title_sub=\make_chart_title, style=style) %] + + + + [% LxERP.t8("Rounding Loss") %] + [% L.select_tag('defaults.rndloss_accno_id', SELF.accounts.rnd_loss, default=SELF.defaults.rndloss_accno_id, title_sub=\make_chart_title, style=style) %] + + [% LxERP.t8("Current assets account") %] [% L.chart_picker('defaults.ar_paid_accno_id', SELF.defaults.ar_paid_accno_id, type='AR_paid', choose=1, style=style) %] diff --git a/templates/webpages/is/form_footer.html b/templates/webpages/is/form_footer.html index 2c271dd61..60e349326 100644 --- a/templates/webpages/is/form_footer.html +++ b/templates/webpages/is/form_footer.html @@ -107,6 +107,13 @@ [%- END %] +[%- IF rounding %] + + [% 'Rounding' | $T8 %] + [% LxERP.format_amount(rounding, 2) %] + +[%- END %] + [%# tax %] [% FOREACH item = taxaccounts_array %] [% SET description_ref = item _ '_description' %] @@ -124,7 +131,6 @@ [%- END %] [%- END %] - [% 'Total' | $T8 %] [% LxERP.format_amount(invtotal, 2) %] diff --git a/templates/webpages/is/form_header.html b/templates/webpages/is/form_header.html index 2ccdf5f31..234a5e51f 100644 --- a/templates/webpages/is/form_header.html +++ b/templates/webpages/is/form_header.html @@ -160,6 +160,8 @@ + + [%- IF show_exchangerate %] diff --git a/templates/webpages/oe/form_footer.html b/templates/webpages/oe/form_footer.html index 0956f204f..fbeb52992 100644 --- a/templates/webpages/oe/form_footer.html +++ b/templates/webpages/oe/form_footer.html @@ -107,6 +107,12 @@ [% 'Subtotal' | $T8 %] [% LxERP.format_amount(invsubtotal, 2) %] +[%- END %] +[%- IF rounding %] + + [% 'Rounding' | $T8 %] + [% LxERP.format_amount(rounding, 2) %] + [%- END %] [% tax %] -- 2.20.1