Revision 347f2cff
Von Moritz Bunkus vor mehr als 11 Jahren hinzugefügt
| sql/Pg-upgrade2/USTVA_at.pl | ||
|---|---|---|
| 1 | 1 |
# @tag: USTVA_at |
| 2 | 2 |
# @description: USTVA Report Daten fuer Oesterreich. Vielen Dank an Gerhard Winkler.. |
| 3 | 3 |
# @depends: USTVA_abstraction |
| 4 |
package SL::DBUpgrade2::USTVA_at; |
|
| 4 | 5 |
|
| 5 | 6 |
use strict; |
| 7 |
use utf8; |
|
| 6 | 8 |
|
| 7 |
use SL::DBUtils;
|
|
| 9 |
use parent qw(SL::DBUpgrade2::Base);
|
|
| 8 | 10 |
|
| 9 |
unless ( $main::form ) {
|
|
| 10 |
die("This script cannot be run from the command line.");
|
|
| 11 |
} |
|
| 11 |
sub run {
|
|
| 12 |
my ($self) = @_; |
|
| 12 | 13 |
|
| 13 |
if ( check_coa('Austria') ){
|
|
| 14 |
|
|
| 15 |
if ( coa_is_empty() ) {
|
|
| 16 |
print qq|Eine leere Datenbank mit Kontenrahmen ?sterreich vorgefunden. <br /> |
|
| 17 |
Die Aktualisierungen werden eingespielt...<br /> |
|
| 18 |
<b>Achtung: Dieses Update ist ungetestet und bedarf weiterer Konfiguration</b>|; |
|
| 19 |
|
|
| 20 |
return 1 |
|
| 21 |
&& clear_tables(( 'tax.report_variables', 'tax.report_headings', |
|
| 22 |
'tax.report_categorys', 'taxkeys', |
|
| 23 |
'tax', 'chart', |
|
| 24 |
'buchungsgruppen', |
|
| 25 |
)) |
|
| 26 |
&& do_copy_tax_report_structure() |
|
| 27 |
&& do_insert_chart() |
|
| 28 |
&& do_insert_tax() |
|
| 29 |
&& do_insert_taxkeys() |
|
| 30 |
&& do_insert_buchungsgruppen() |
|
| 31 |
; |
|
| 14 |
if (!$self->check_coa('Austria')) {
|
|
| 15 |
print qq|Nichts zu tun in diesem Kontenrahmen.|; |
|
| 16 |
return 1; |
|
| 32 | 17 |
} |
| 33 |
else {
|
|
| 34 |
print qq|Eine ?sterreichische Datenbank in der bereits Buchungss?tze enthalten sind, kann nicht aktualisiert werden.<br /> |
|
| 18 |
|
|
| 19 |
if (!$self->is_coa_empty) {
|
|
| 20 |
print qq|Eine österreichische Datenbank in der bereits Buchungssätze enthalten sind, kann nicht aktualisiert werden.<br /> |
|
| 35 | 21 |
Bitte eine neue Datenbank mit Kontenrahmen 'Austria' anlegen.|; |
| 36 | 22 |
return 1; |
| 37 | 23 |
} |
| 38 | 24 |
|
| 25 |
print qq|Eine leere Datenbank mit Kontenrahmen Österreich vorgefunden. <br /> |
|
| 26 |
Die Aktualisierungen werden eingespielt...<br /> |
|
| 27 |
<b>Achtung: Dieses Update ist ungetestet und bedarf weiterer Konfiguration</b>|; |
|
| 28 |
|
|
| 29 |
return |
|
| 30 |
$self->clear_tables('tax.report_variables', 'tax.report_headings',
|
|
| 31 |
'tax.report_categorys', 'taxkeys', |
|
| 32 |
'tax', 'chart', |
|
| 33 |
'buchungsgruppen') |
|
| 34 |
&& $self->do_copy_tax_report_structure() |
|
| 35 |
&& $self->do_insert_chart() |
|
| 36 |
&& $self->do_insert_tax() |
|
| 37 |
&& $self->do_insert_taxkeys() |
|
| 38 |
&& $self->do_insert_buchungsgruppen() |
|
| 39 |
; |
|
| 39 | 40 |
} |
| 40 |
else {
|
|
| 41 |
print qq|Nichts zu tun in diesem Kontenrahmen.|; |
|
| 42 |
return 1; |
|
| 43 |
} |
|
| 44 |
|
|
| 45 |
return 0; |
|
| 46 |
|
|
| 47 |
###################################################### |
|
| 48 |
|
|
| 49 |
sub mydberror {
|
|
| 50 |
my ($msg) = @_; |
|
| 51 |
die($dbup_locale->text("Database update error:") .
|
|
| 52 |
"<br>$msg<br>" . $DBI::errstr); |
|
| 53 |
} |
|
| 54 |
|
|
| 55 |
sub do_query {
|
|
| 56 |
my ($query, $may_fail) = @_; |
|
| 57 |
|
|
| 58 |
if (!$dbh->do($query)) {
|
|
| 59 |
mydberror($query) unless ($may_fail); |
|
| 60 |
$dbh->rollback(); |
|
| 61 |
$dbh->begin_work(); |
|
| 62 |
} |
|
| 63 |
} |
|
| 64 |
|
|
| 65 | 41 |
|
| 66 | 42 |
sub clear_tables {
|
| 67 |
|
|
| 68 |
my @clear = @_; |
|
| 43 |
my ($self, @clear) = @_; |
|
| 69 | 44 |
|
| 70 | 45 |
my @queries = ( |
| 71 | 46 |
q{ DELETE FROM tax.report_categorys; },
|
| ... | ... | |
| 73 | 48 |
q{ DELETE FROM tax.report_variables; },
|
| 74 | 49 |
); |
| 75 | 50 |
|
| 76 |
map({ do_query("DELETE FROM $_ ;", 0); } @clear);
|
|
| 51 |
map({ $self->db_query("DELETE FROM $_ ;", 0); } @clear);
|
|
| 77 | 52 |
|
| 78 | 53 |
return 1; |
| 79 | 54 |
|
| 80 | 55 |
} |
| 81 | 56 |
|
| 82 |
sub check_coa {
|
|
| 83 |
|
|
| 84 |
my ( $want_coa ) = @_; |
|
| 85 |
|
|
| 86 |
my $query = q{ SELECT count(*) FROM defaults WHERE coa = ? };
|
|
| 87 |
my ($have_coa) = selectrow_query($main::form, $dbh, $query, $want_coa); |
|
| 88 |
|
|
| 89 |
return $have_coa; |
|
| 90 |
|
|
| 91 |
} |
|
| 92 |
|
|
| 93 |
sub coa_is_empty {
|
|
| 94 |
|
|
| 95 |
my $query = q{ SELECT count(*)
|
|
| 96 |
FROM ar, ap, gl, invoice, acc_trans, customer, vendor, parts |
|
| 97 |
}; |
|
| 98 |
my ($empty) = selectrow_query($main::form, $dbh, $query); |
|
| 99 |
|
|
| 100 |
$empty = !$empty; |
|
| 101 |
|
|
| 102 |
return $empty; |
|
| 103 |
} |
|
| 104 |
|
|
| 105 |
|
|
| 106 | 57 |
sub do_copy_tax_report_structure {
|
| 58 |
my ($self) = @_; |
|
| 107 | 59 |
|
| 108 | 60 |
my @queries = ( |
| 109 | 61 |
"INSERT INTO tax.report_categorys (id, description, subdescription) VALUES (0, NULL, NULL)", |
| 110 | 62 |
"INSERT INTO tax.report_headings (id, category_id, type, description, subdescription) VALUES (0, 0, NULL, NULL, NULL)", |
| 111 | 63 |
); |
| 112 | 64 |
|
| 113 |
map({ do_query($_); } @queries);
|
|
| 65 |
map({ $self->db_query($_); } @queries);
|
|
| 114 | 66 |
|
| 115 | 67 |
|
| 116 | 68 |
my @copy_statements = ( |
| ... | ... | |
| 120 | 72 |
|
| 121 | 73 |
my @copy_data = ( |
| 122 | 74 |
[ |
| 123 |
"1;000;0;a) Gesamtbetrag der Bemessungsgrundlage f?r Lieferungen und sonstige Leistungen (ohne den nachstehend angef?hrten Eigenverbrauch) einschlie?lich Anzahlungen (jeweils ohne Umsatzsteuer);2;1970-01-01",
|
|
| 124 |
"2;001;0;zuz?glich Eigenverbrauch (?1 Abs. 1 Z 2, ? 3 Abs. 2 und ? 3a Abs. 1a);2;1970-01-01",
|
|
| 125 |
"3;021;0;abz?glich Ums?tze f?r die die Steuerschuld gem?? ? 19 Abs. 1 zweiter Satz sowie gem?? ? 19 Abs. 1a, Abs. 1b, Abs. 1c auf den Leistungsempf?nger ?bergegangen ist.;2;1970-01-01",
|
|
| 126 |
"4;011;0;a) ?6 Abs. 1 Z 1 iVm ? 7 (Ausfuhrlieferungen);2;1970-01-01",
|
|
| 127 |
"5;012;0;b) ?6 Abs. 1 Z 1 iVm ? 8 (Lohnveredelungen);2;1970-01-01",
|
|
| 128 |
"6;015;0;c) ?6 Abs. 1 Z 2 bis 6 sowie ? 23 Abs. 5 (Seeschifffahrt, Luftfahrt, grenz?berschreitende Personenbef?rderung, Diplomaten, Reisevorleistungen im Drittlandsgebiet usw.);2;1970-01-01",
|
|
| 129 |
"7;017;0;d) Art. 6 Abs. 1 (innergemeinschaftliche Lieferungen ohne die nachstehend gesondert anzuf?hrenden Fahrzeuglieferungen);2;1970-01-01",
|
|
| 130 |
"8;018;0;e) Art. 6 Abs. 1, sofern Lieferungen neuer Fahrzeuge an Abnehmer ohne UID-Nummer bzw. durch Fahrzeuglieferer gem?? Art. 2 erfolgen.;2;1970-01-01",
|
|
| 131 |
"9;019;0;a) ? 6 Abs. 1 Z 9 lit. a (Grundst?cksums?tze);2;1970-01-01",
|
|
| 132 |
"10;016;0;b) ?6 Abs. 1 Z 27 (Kleinunternehmer);2;1970-01-01",
|
|
| 133 |
"11;020;0;c) ? 6 Abs. 1 Z ___ (?brige steuerfreie Ums?tze ohne Vorsteuerabzug);2;1970-01-01",
|
|
| 75 |
"1;000;0;a) Gesamtbetrag der Bemessungsgrundlage für Lieferungen und sonstige Leistungen (ohne den nachstehend angeführten Eigenverbrauch) einschließlich Anzahlungen (jeweils ohne Umsatzsteuer);2;1970-01-01",
|
|
| 76 |
"2;001;0;zuzüglich Eigenverbrauch (§1 Abs. 1 Z 2, § 3 Abs. 2 und § 3a Abs. 1a);2;1970-01-01",
|
|
| 77 |
"3;021;0;abzüglich Umsätze für die die Steuerschuld gemäß § 19 Abs. 1 zweiter Satz sowie gemäß § 19 Abs. 1a, Abs. 1b, Abs. 1c auf den Leistungsempfänger übergegangen ist.;2;1970-01-01",
|
|
| 78 |
"4;011;0;a) §6 Abs. 1 Z 1 iVm § 7 (Ausfuhrlieferungen);2;1970-01-01",
|
|
| 79 |
"5;012;0;b) §6 Abs. 1 Z 1 iVm § 8 (Lohnveredelungen);2;1970-01-01",
|
|
| 80 |
"6;015;0;c) §6 Abs. 1 Z 2 bis 6 sowie § 23 Abs. 5 (Seeschifffahrt, Luftfahrt, grenzüberschreitende Personenbeförderung, Diplomaten, Reisevorleistungen im Drittlandsgebiet usw.);2;1970-01-01",
|
|
| 81 |
"7;017;0;d) Art. 6 Abs. 1 (innergemeinschaftliche Lieferungen ohne die nachstehend gesondert anzuführenden Fahrzeuglieferungen);2;1970-01-01",
|
|
| 82 |
"8;018;0;e) Art. 6 Abs. 1, sofern Lieferungen neuer Fahrzeuge an Abnehmer ohne UID-Nummer bzw. durch Fahrzeuglieferer gemäß Art. 2 erfolgen.;2;1970-01-01",
|
|
| 83 |
"9;019;0;a) § 6 Abs. 1 Z 9 lit. a (Grundstücksumsätze);2;1970-01-01",
|
|
| 84 |
"10;016;0;b) §6 Abs. 1 Z 27 (Kleinunternehmer);2;1970-01-01",
|
|
| 85 |
"11;020;0;c) § 6 Abs. 1 Z ___ (übrige steuerfreie Umsätze ohne Vorsteuerabzug);2;1970-01-01",
|
|
| 134 | 86 |
"12;022_links;0;20% Nominalsteuersatz;2;1970-01-01", |
| 135 | 87 |
"13;022_rechts;0;20% Nominalsteuersatz;2;1970-01-01", |
| 136 |
"14;029_links;0;10% erm??igter Steuersatz;2;1970-01-01",
|
|
| 137 |
"15;029_rechts;0;10% erm??igter Steuersatz;2;1970-01-01",
|
|
| 138 |
"16;025_links;0;12% f?r Weinums?tze durch landwirtschaftliche Betriebe;2;1970-01-01",
|
|
| 139 |
"17;025_rechts;0;12% f?r Weinums?tze durch landwirtschaftliche Betriebe;2;1970-01-01",
|
|
| 140 |
"18;035_links;0;16% f?r Jungholz und Mittelberg;2;1970-01-01",
|
|
| 141 |
"19;035_rechts;0;16% f?r Jungholz und Mittelberg;2;1970-01-01",
|
|
| 142 |
"20;052_links;0;10% Zusatzsteuer f?r pauschalierte land- und forstwirtschaftliche Betriebe;2;1970-01-01",
|
|
| 143 |
"21;052_rechts;0;10% Zusatzsteuer f?r pauschalierte land- und forstwirtschaftliche Betriebe;2;1970-01-01",
|
|
| 144 |
"22;038_links;0;8% Zusatzsteuer f?r pauschalierte land- und forstwirtschaftliche Betriebe;2;1970-01-01",
|
|
| 145 |
"23;038_rechts;0;8% Zusatzsteuer f?r pauschalierte land- und forstwirtschaftliche Betriebe;2;1970-01-01",
|
|
| 146 |
"24;056;0;Steuerschuld gem?? ? 11 Abs. 12 und 14, ? 16 Abs. 2 sowie gem?? Art. 7 Abs. 4;2;1970-01-01",
|
|
| 147 |
"25;057;0;Steuerschuld gem?? ? 19 Abs. 1 zweiter Satz, ? 19 Abs. 1c sowie gem?? Art. 25 Abs. 5;2;1970-01-01",
|
|
| 148 |
"26;048;0;Steuerschuld gem?? ? 19 Abs. 1a (Bauleistungen);2;1970-01-01",
|
|
| 149 |
"27;044;0;Steuerschuld gem?? ? 19 Abs. 1b (Sicherungseigentum, Vorbehaltseigentum und Grundst?cke im Zwangsversteigerungsverfahren);2;1970-01-01",
|
|
| 150 |
"28;070;0;Gesamtbetrag der Bemessungsgrundlagen f?r innergemeinschaftliche Erwerbe;2;1970-01-01",
|
|
| 151 |
"29;071;0;Davon Steuerfrei gem?? Art. 6 Abs 2;2;1970-01-01",
|
|
| 88 |
"14;029_links;0;10% ermäßigter Steuersatz;2;1970-01-01",
|
|
| 89 |
"15;029_rechts;0;10% ermäßigter Steuersatz;2;1970-01-01",
|
|
| 90 |
"16;025_links;0;12% für Weinumsätze durch landwirtschaftliche Betriebe;2;1970-01-01",
|
|
| 91 |
"17;025_rechts;0;12% für Weinumsätze durch landwirtschaftliche Betriebe;2;1970-01-01",
|
|
| 92 |
"18;035_links;0;16% für Jungholz und Mittelberg;2;1970-01-01",
|
|
| 93 |
"19;035_rechts;0;16% für Jungholz und Mittelberg;2;1970-01-01",
|
|
| 94 |
"20;052_links;0;10% Zusatzsteuer für pauschalierte land- und forstwirtschaftliche Betriebe;2;1970-01-01",
|
|
| 95 |
"21;052_rechts;0;10% Zusatzsteuer für pauschalierte land- und forstwirtschaftliche Betriebe;2;1970-01-01",
|
|
| 96 |
"22;038_links;0;8% Zusatzsteuer für pauschalierte land- und forstwirtschaftliche Betriebe;2;1970-01-01",
|
|
| 97 |
"23;038_rechts;0;8% Zusatzsteuer für pauschalierte land- und forstwirtschaftliche Betriebe;2;1970-01-01",
|
|
| 98 |
"24;056;0;Steuerschuld gemäß § 11 Abs. 12 und 14, § 16 Abs. 2 sowie gemäß Art. 7 Abs. 4;2;1970-01-01",
|
|
| 99 |
"25;057;0;Steuerschuld gemäß § 19 Abs. 1 zweiter Satz, § 19 Abs. 1c sowie gemäß Art. 25 Abs. 5;2;1970-01-01",
|
|
| 100 |
"26;048;0;Steuerschuld gemäß § 19 Abs. 1a (Bauleistungen);2;1970-01-01",
|
|
| 101 |
"27;044;0;Steuerschuld gemäß § 19 Abs. 1b (Sicherungseigentum, Vorbehaltseigentum und Grundstücke im Zwangsversteigerungsverfahren);2;1970-01-01",
|
|
| 102 |
"28;070;0;Gesamtbetrag der Bemessungsgrundlagen für innergemeinschaftliche Erwerbe;2;1970-01-01",
|
|
| 103 |
"29;071;0;Davon Steuerfrei gemäß Art. 6 Abs 2;2;1970-01-01",
|
|
| 152 | 104 |
"30;072_links;0;20% Nominalsteuersatz;2;1970-01-01", |
| 153 | 105 |
"31;072_rechts;0;20% Nominalsteuersatz;2;1970-01-01", |
| 154 |
"32;073_links;0;10% erm??igter Steuersatz;2;1970-01-01",
|
|
| 155 |
"33;073_rechts;0;10% erm??igter Steuersatz;2;1970-01-01",
|
|
| 156 |
"34;075_links;0;16% f?r Jungholz und Mittelberg;2;1970-01-01",
|
|
| 157 |
"35;075_rechts;0;16% f?r Jungholz und Mittelberg;2;1970-01-01",
|
|
| 158 |
"36;076;0;Erwerbe gem?? Art. 3 Abs. 8 zweiter Satz, die im Mitgliedstaat des Bestimmungslandes besteuert worden sind;2;1970-01-01",
|
|
| 159 |
"37;077;0;Erwerbe gem?? Art. 3 Abs. 8 zweiter Satz, die gem?? Art. 25 Abs. 2 im Inland als besteuert gelten;2;1970-01-01",
|
|
| 160 |
"38;060;0;Gesamtbetrag der Vorsteuern (ohne die nachstehend gesondert anzuf?hrenden Betr?ge);2;1970-01-01",
|
|
| 161 |
"39;061;0;Vorsteuern betreffend die entrichtete Einfuhrumsatzsteuer (?12 Abs. 1 Z 2 lit.a);2;1970-01-01",
|
|
| 162 |
"40;083;0;Vorsteuern betreffend die am Abgabenkonto verbuchte Einfuhrumsatzsteuer (?12 Abs. 1 Z 2 lit.b);2;1970-01-01",
|
|
| 106 |
"32;073_links;0;10% ermäßigter Steuersatz;2;1970-01-01",
|
|
| 107 |
"33;073_rechts;0;10% ermäßigter Steuersatz;2;1970-01-01",
|
|
| 108 |
"34;075_links;0;16% für Jungholz und Mittelberg;2;1970-01-01",
|
|
| 109 |
"35;075_rechts;0;16% für Jungholz und Mittelberg;2;1970-01-01",
|
|
| 110 |
"36;076;0;Erwerbe gemäß Art. 3 Abs. 8 zweiter Satz, die im Mitgliedstaat des Bestimmungslandes besteuert worden sind;2;1970-01-01",
|
|
| 111 |
"37;077;0;Erwerbe gemäß Art. 3 Abs. 8 zweiter Satz, die gemäß Art. 25 Abs. 2 im Inland als besteuert gelten;2;1970-01-01",
|
|
| 112 |
"38;060;0;Gesamtbetrag der Vorsteuern (ohne die nachstehend gesondert anzuführenden Beträge);2;1970-01-01",
|
|
| 113 |
"39;061;0;Vorsteuern betreffend die entrichtete Einfuhrumsatzsteuer (§12 Abs. 1 Z 2 lit.a);2;1970-01-01",
|
|
| 114 |
"40;083;0;Vorsteuern betreffend die am Abgabenkonto verbuchte Einfuhrumsatzsteuer (§12 Abs. 1 Z 2 lit.b);2;1970-01-01",
|
|
| 163 | 115 |
"41;065;0;Vorsteuern aus dem innergemeinschaftlichen Erwerb;2;1970-01-01", |
| 164 |
"42;066;0;Vorsteuern betreffend der Steuerschuld gem?? ? 19 Abs. 1c sowie gem?? Art. 25 Abs. 5;2;1970-01-01",
|
|
| 165 |
"43;082;0;Vorsteuern betreffend der Steuerschuld gem?? ? 19 Abs. 1a (Bauleistungen);2;1970-01-01",
|
|
| 166 |
"44;087;0;Vorsteuern betreffend die Steuerschuld gem?? ? 19 Abs. 1b (Sicherungseigentum, Vorbehaltseigentum und Grundst?cke im Zwangsversteigerungsverfahren);2;1970-01-01",
|
|
| 167 |
"45;064;0;Vorsteuern gem?? ?12 Abs. 16 und Vorsteuern f?r innergemeinschaftliche Lieferungen neuer Fahrzeuge von Fahrzeuglieferanten gem?? Art. 2;2;1970-01-01",
|
|
| 168 |
"46;062;0;Davon gem?? ? 12 Abs. 3 iVm Abs. 4 und 5;2;1970-01-01",
|
|
| 169 |
"47;063;0;Berichtigung gem?? ? 12 Abs. 10 und 11;2;1970-01-01",
|
|
| 170 |
"48;067;0;Berichtigung gem?? ? 16;2;1970-01-01",
|
|
| 116 |
"42;066;0;Vorsteuern betreffend der Steuerschuld gemäß § 19 Abs. 1c sowie gemäß Art. 25 Abs. 5;2;1970-01-01",
|
|
| 117 |
"43;082;0;Vorsteuern betreffend der Steuerschuld gemäß § 19 Abs. 1a (Bauleistungen);2;1970-01-01",
|
|
| 118 |
"44;087;0;Vorsteuern betreffend die Steuerschuld gemäß § 19 Abs. 1b (Sicherungseigentum, Vorbehaltseigentum und Grundstücke im Zwangsversteigerungsverfahren);2;1970-01-01",
|
|
| 119 |
"45;064;0;Vorsteuern gemäß §12 Abs. 16 und Vorsteuern für innergemeinschaftliche Lieferungen neuer Fahrzeuge von Fahrzeuglieferanten gemäß Art. 2;2;1970-01-01",
|
|
| 120 |
"46;062;0;Davon gemäß § 12 Abs. 3 iVm Abs. 4 und 5;2;1970-01-01",
|
|
| 121 |
"47;063;0;Berichtigung gemäß § 12 Abs. 10 und 11;2;1970-01-01",
|
|
| 122 |
"48;067;0;Berichtigung gemäß § 16;2;1970-01-01",
|
|
| 171 | 123 |
"49;090;0;Sonstige Berichtigungen;2;1970-01-01", |
| 172 | 124 |
"50;095;0;Zahllast/Gutschrift;2;1970-01-01", |
| 173 | 125 |
], |
| 174 | 126 |
); |
| 175 | 127 |
|
| 176 | 128 |
for my $statement ( 0 .. $#copy_statements ) {
|
| 177 |
my $query = $iconv->convert($copy_statements[$statement]);
|
|
| 178 |
my $sth = $dbh->prepare($query) || mydberror($query);
|
|
| 129 |
my $query = $copy_statements[$statement];
|
|
| 130 |
my $sth = $self->dbh->prepare($query) || $self->db_error($query);
|
|
| 179 | 131 |
|
| 180 | 132 |
for my $copy_line ( 0 .. $#{$copy_data[$statement]} ) {
|
| 181 | 133 |
#print $copy_data[$statement][$copy_line] . "<br />" |
| 182 |
$sth->execute(split m/;/, $iconv->convert($copy_data[$statement][$copy_line]), -1) || mydberror($query);
|
|
| 134 |
$sth->execute(split m/;/, $copy_data[$statement][$copy_line], -1) || $self->db_error($query);
|
|
| 183 | 135 |
} #/ |
| 184 | 136 |
$sth->finish(); |
| 185 | 137 |
} |
| ... | ... | |
| 187 | 139 |
} |
| 188 | 140 |
|
| 189 | 141 |
sub do_insert_chart {
|
| 142 |
my ($self) = @_; |
|
| 190 | 143 |
|
| 191 | 144 |
my @copy_statements = ( |
| 192 |
"INSERT INTO chart VALUES (1, '0000', 'AUFWENDUNGEN F?R INGANGSETZEN UND ERWEITERN DES BETRIEBES', 'H', 'A', '', '00', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.276724', NULL, NULL, NULL);",
|
|
| 145 |
"INSERT INTO chart VALUES (1, '0000', 'AUFWENDUNGEN FÜR INGANGSETZEN UND ERWEITERN DES BETRIEBES', 'H', 'A', '', '00', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.276724', NULL, NULL, NULL);",
|
|
| 193 | 146 |
"INSERT INTO chart VALUES (2, '0010', 'Firmenwert', 'A', 'A', 'AP_amount', '015', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.28365', NULL, NULL, NULL);", |
| 194 |
"INSERT INTO chart VALUES (3, '0100', 'IMMATERIELLE VERM?GENSGEGENST?NDE', 'H', 'A', '', '01', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.288542', NULL, NULL, NULL);",
|
|
| 147 |
"INSERT INTO chart VALUES (3, '0100', 'IMMATERIELLE VERMÖGENSGEGENSTÄNDE', 'H', 'A', '', '01', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.288542', NULL, NULL, NULL);",
|
|
| 195 | 148 |
"INSERT INTO chart VALUES (4, '0110', 'Rechte', 'A', 'A', 'AP_amount', '011', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.291937', NULL, NULL, NULL);", |
| 196 |
"INSERT INTO chart VALUES (5, '0200', 'GRUNDST?CKE', 'H', 'A', '', '02-03', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.294929', NULL, NULL, NULL);",
|
|
| 197 |
"INSERT INTO chart VALUES (6, '0210', 'unbebaute Grundst?cke', 'A', 'A', 'AP_amount', '020', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.297958', NULL, NULL, NULL);",
|
|
| 198 |
"INSERT INTO chart VALUES (7, '0220', 'bebaute Grundst?cke', 'A', 'A', 'AP_amount', '021', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.300987', NULL, NULL, NULL);",
|
|
| 199 |
"INSERT INTO chart VALUES (8, '0229', 'kum. Abschreibung bebaute Grundst?cke', 'A', 'A', '', '039', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.304114', NULL, NULL, NULL);",
|
|
| 149 |
"INSERT INTO chart VALUES (5, '0200', 'GRUNDSTÜCKE', 'H', 'A', '', '02-03', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.294929', NULL, NULL, NULL);",
|
|
| 150 |
"INSERT INTO chart VALUES (6, '0210', 'unbebaute Grundstücke', 'A', 'A', 'AP_amount', '020', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.297958', NULL, NULL, NULL);",
|
|
| 151 |
"INSERT INTO chart VALUES (7, '0220', 'bebaute Grundstücke', 'A', 'A', 'AP_amount', '021', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.300987', NULL, NULL, NULL);",
|
|
| 152 |
"INSERT INTO chart VALUES (8, '0229', 'kum. Abschreibung bebaute Grundstücke', 'A', 'A', '', '039', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.304114', NULL, NULL, NULL);",
|
|
| 200 | 153 |
"INSERT INTO chart VALUES (10, '0410', 'Maschinen', 'A', 'A', 'AP_amount', '041', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.312216', NULL, NULL, NULL);", |
| 201 | 154 |
"INSERT INTO chart VALUES (11, '0419', 'kum. Abschreibung Maschinen', 'A', 'A', '', '069', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.316198', NULL, NULL, NULL);", |
| 202 | 155 |
"INSERT INTO chart VALUES (12, '0500', 'FAHRZEUGE', 'H', 'A', '', '06', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.319978', NULL, NULL, NULL);", |
| 203 | 156 |
"INSERT INTO chart VALUES (13, '0510', 'Fahrzeuge', 'A', 'A', 'AP_amount', '063', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.323002', NULL, NULL, NULL);", |
| 204 | 157 |
"INSERT INTO chart VALUES (14, '0519', 'kum. Abschreibung Fahrzeuge', 'A', 'A', '', '069', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.326041', NULL, NULL, NULL);", |
| 205 |
"INSERT INTO chart VALUES (15, '0600', 'BETRIEBS- UND GESCH?FTSAUSSTATTUNG', 'H', 'A', '', '06', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.330691', NULL, NULL, NULL);",
|
|
| 206 |
"INSERT INTO chart VALUES (16, '0620', 'B?roeinrichtungen', 'A', 'A', 'AP_amount', '066', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.33373', NULL, NULL, NULL);",
|
|
| 207 |
"INSERT INTO chart VALUES (17, '0625', 'kum. Abschreibung Betriebs- und Gesch?ftsausstattung', 'A', 'A', '', '069', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.336939', NULL, NULL, NULL);",
|
|
| 158 |
"INSERT INTO chart VALUES (15, '0600', 'BETRIEBS- UND GESCHÄFTSAUSSTATTUNG', 'H', 'A', '', '06', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.330691', NULL, NULL, NULL);",
|
|
| 159 |
"INSERT INTO chart VALUES (16, '0620', 'Büroeinrichtungen', 'A', 'A', 'AP_amount', '066', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.33373', NULL, NULL, NULL);",
|
|
| 160 |
"INSERT INTO chart VALUES (17, '0625', 'kum. Abschreibung Betriebs- und Geschäftsausstattung', 'A', 'A', '', '069', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.336939', NULL, NULL, NULL);",
|
|
| 208 | 161 |
"INSERT INTO chart VALUES (18, '0700', 'GELEISTETE ANZAHLUNGEN', 'H', 'A', '', '07', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.340614', NULL, NULL, NULL);", |
| 209 | 162 |
"INSERT INTO chart VALUES (19, '0800', 'FINANZANLAGEN', 'H', 'A', '', '08-09', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.3436', NULL, NULL, NULL);", |
| 210 | 163 |
"INSERT INTO chart VALUES (20, '0810', 'Beteiligungen', 'A', 'A', 'AP_amount', '081', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.346638', NULL, NULL, NULL);", |
| 211 | 164 |
"INSERT INTO chart VALUES (21, '0820', 'Wertpapiere', 'A', 'A', 'AP_amount', '080', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.351452', NULL, NULL, NULL);", |
| 212 | 165 |
"INSERT INTO chart VALUES (22, '1100', 'ROHSTOFFE', 'H', 'A', '', '1', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.354419', NULL, NULL, NULL);", |
| 213 |
"INSERT INTO chart VALUES (23, '1120', 'Vorr?te - Rohstoffe', 'A', 'A', 'IC', '110-119', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.357447', NULL, NULL, NULL);",
|
|
| 166 |
"INSERT INTO chart VALUES (23, '1120', 'Vorräte - Rohstoffe', 'A', 'A', 'IC', '110-119', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.357447', NULL, NULL, NULL);",
|
|
| 214 | 167 |
"INSERT INTO chart VALUES (24, '1200', 'BEZOGENE TEILE', 'H', 'A', '', '1', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.360423', NULL, NULL, NULL);", |
| 215 |
"INSERT INTO chart VALUES (25, '1220', 'Vorr?te - bezogene Teile', 'A', 'A', 'IC', '120-129', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.363627', NULL, NULL, NULL);",
|
|
| 168 |
"INSERT INTO chart VALUES (25, '1220', 'Vorräte - bezogene Teile', 'A', 'A', 'IC', '120-129', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.363627', NULL, NULL, NULL);",
|
|
| 216 | 169 |
"INSERT INTO chart VALUES (26, '1300', 'HILFS- UND BETRIEBSSTOFFE', 'H', 'A', '', '1', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.368083', NULL, NULL, NULL);", |
| 217 | 170 |
"INSERT INTO chart VALUES (27, '1320', 'Hilfsstoffe', 'A', 'A', 'IC', '130-134', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.372229', NULL, NULL, NULL);", |
| 218 | 171 |
"INSERT INTO chart VALUES (28, '1350', 'Betriebssstoffe', 'A', 'A', 'IC', '135-139', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.375303', NULL, NULL, NULL);", |
| 219 | 172 |
"INSERT INTO chart VALUES (29, '1400', 'UNFERTIGE ERZEUGNISSE', 'H', 'A', '', '1', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.378277', NULL, NULL, NULL);", |
| 220 |
"INSERT INTO chart VALUES (30, '1420', 'Vorr?te - unfertige Erzeugnisse', 'A', 'A', 'IC', '140-149', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.381463', NULL, NULL, NULL);",
|
|
| 173 |
"INSERT INTO chart VALUES (30, '1420', 'Vorräte - unfertige Erzeugnisse', 'A', 'A', 'IC', '140-149', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.381463', NULL, NULL, NULL);",
|
|
| 221 | 174 |
"INSERT INTO chart VALUES (31, '1500', 'FERTIGE ERZEUGNISSE', 'H', 'A', '', '1', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.384434', NULL, NULL, NULL);", |
| 222 |
"INSERT INTO chart VALUES (34, '1540', 'Vorr?te - Gruppe C', 'A', 'A', 'IC', '150-159', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.395426', NULL, NULL, NULL);",
|
|
| 175 |
"INSERT INTO chart VALUES (34, '1540', 'Vorräte - Gruppe C', 'A', 'A', 'IC', '150-159', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.395426', NULL, NULL, NULL);",
|
|
| 223 | 176 |
"INSERT INTO chart VALUES (35, '1600', 'WAREN', 'H', 'A', '', '1', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.39872', NULL, NULL, NULL);", |
| 224 | 177 |
"INSERT INTO chart VALUES (36, '1700', 'NOCH NICHT ABGERECHNETE LEISTUNGEN', 'H', 'A', '', '1', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.401807', NULL, NULL, NULL);", |
| 225 | 178 |
"INSERT INTO chart VALUES (37, '1800', 'GELEISTETE ANZAHLUNGEN', 'H', 'A', '', '1', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.404851', NULL, NULL, NULL);", |
| ... | ... | |
| 230 | 183 |
"INSERT INTO chart VALUES (43, '2320', 'sonstige Forderungen', 'A', 'A', 'AP_amount', '23-24', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.428868', NULL, NULL, NULL);", |
| 231 | 184 |
"INSERT INTO chart VALUES (44, '2500', 'FORDERUNGEN AUS ABGABENVERRECHNUNG', 'H', 'A', '', '2', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.432042', NULL, NULL, NULL);", |
| 232 | 185 |
"INSERT INTO chart VALUES (46, '2600', 'WERTPAPIERE UND ANTEILE', 'H', 'A', '', '2', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.438205', NULL, NULL, NULL);", |
| 233 |
"INSERT INTO chart VALUES (47, '2620', 'Wertpapiere Umlaufverm?gen', 'A', 'A', 'AP_amount', '26', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.441382', NULL, NULL, NULL);",
|
|
| 186 |
"INSERT INTO chart VALUES (47, '2620', 'Wertpapiere Umlaufvermögen', 'A', 'A', 'AP_amount', '26', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.441382', NULL, NULL, NULL);",
|
|
| 234 | 187 |
"INSERT INTO chart VALUES (48, '2700', 'KASSABESTAND', 'H', 'A', '', '2', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.444391', NULL, NULL, NULL);", |
| 235 | 188 |
"INSERT INTO chart VALUES (50, '2800', 'SCHECKS, GUTHABEN BEI KREDITINSTITUTEN', 'H', 'A', '', '2', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.45237', NULL, NULL, NULL);", |
| 236 | 189 |
"INSERT INTO chart VALUES (53, '3100', 'LANGFRISTIGE VERBINDLICHKEITEN', 'H', 'L', '', '3', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.461985', NULL, NULL, NULL);", |
| ... | ... | |
| 239 | 192 |
"INSERT INTO chart VALUES (58, '3500', 'VERBINDLICHKEITEN FINANZAMT', 'H', 'L', '', '35', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.480487', NULL, NULL, NULL);", |
| 240 | 193 |
"INSERT INTO chart VALUES (105, '7611', 'Reinigungsmaterial', 'A', 'E', 'AP_amount', '', 9, NULL, 11, 3, NULL, false, '2006-01-28 18:22:52.649072', '2006-02-03 15:26:38.591173', NULL, NULL);", |
| 241 | 194 |
"INSERT INTO chart VALUES (163, '7340', 'Reisekosten', 'A', 'E', 'AP_amount', '', 9, NULL, NULL, 3, NULL, false, '2006-02-03 15:38:11.636188', NULL, NULL, NULL);", |
| 242 |
"INSERT INTO chart VALUES (74, '4600', 'SONSTIGE ERL?SE', 'H', 'I', '', '4', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.539718', NULL, NULL, NULL);",
|
|
| 195 |
"INSERT INTO chart VALUES (74, '4600', 'SONSTIGE ERLÖSE', 'H', 'I', '', '4', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.539718', NULL, NULL, NULL);",
|
|
| 243 | 196 |
"INSERT INTO chart VALUES (95, '7120', 'Grundsteuer', 'A', 'E', '', '', 0, NULL, 12, 3, NULL, false, '2006-01-28 18:22:52.612982', '2006-02-03 15:07:18.076256', NULL, NULL);", |
| 244 | 197 |
"INSERT INTO chart VALUES (94, '7110', 'Ertragssteuern', 'A', 'E', '', '', 0, NULL, 12, 3, NULL, false, '2006-01-28 18:22:52.60961', '2006-02-03 15:07:57.018877', NULL, NULL);", |
| 245 | 198 |
"INSERT INTO chart VALUES (159, '7130', 'Gewerbl. Sozialversicherung', 'A', 'E', 'AP_amount', '', 0, NULL, 12, 3, NULL, false, '2006-02-03 15:16:10.635938', NULL, NULL, NULL);", |
| ... | ... | |
| 253 | 206 |
"INSERT INTO chart VALUES (89, '6710', 'freiwilliger Sozialaufwand', 'A', 'E', '', '660-665', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.592541', NULL, NULL, NULL);", |
| 254 | 207 |
"INSERT INTO chart VALUES (90, '7000', 'ABSCHREIBUNGEN', 'H', 'E', '', '7', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.595566', NULL, NULL, NULL);", |
| 255 | 208 |
"INSERT INTO chart VALUES (91, '7010', 'Abschreibungen', 'A', 'E', '', '700', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.598657', NULL, NULL, NULL);", |
| 256 |
"INSERT INTO chart VALUES (92, '7020', 'geringwertige Wirtschaftsg?ter', 'A', 'E', 'AP_amount', '701-708', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.601829', NULL, NULL, NULL);",
|
|
| 209 |
"INSERT INTO chart VALUES (92, '7020', 'geringwertige Wirtschaftsgüter', 'A', 'E', 'AP_amount', '701-708', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.601829', NULL, NULL, NULL);",
|
|
| 257 | 210 |
"INSERT INTO chart VALUES (93, '7100', 'SONSTIGE STEUERN', 'H', 'E', '', '71', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.604871', NULL, NULL, NULL);", |
| 258 | 211 |
"INSERT INTO chart VALUES (96, '7200', 'INSTANDHALTUNGSAUFWAND', 'H', 'E', '', '7', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.6171', NULL, NULL, NULL);", |
| 259 | 212 |
"INSERT INTO chart VALUES (98, '7300', 'TRANSPORTKOSTEN', 'H', 'L', '', '73', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.623721', NULL, NULL, NULL);", |
| 260 | 213 |
"INSERT INTO chart VALUES (100, '7400', 'MIET-,PACHT-,LEASING-, LIZENZAUFWAND', 'H', 'E', '', '74', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.631869', NULL, NULL, NULL);", |
| 261 | 214 |
"INSERT INTO chart VALUES (113, '7710', 'Sachversicherung', 'A', 'E', 'AP_amount', '', 0, NULL, 13, NULL, NULL, false, '2006-01-28 18:22:52.677258', '2006-02-03 15:19:30.793109', NULL, NULL);", |
| 262 | 215 |
"INSERT INTO chart VALUES (103, '7600', 'VERWALTUNGSKOSTEN', 'H', 'E', '', '76', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.641023', NULL, NULL, NULL);", |
| 263 |
"INSERT INTO chart VALUES (161, '7780', 'Beitr?ge zur Berufsvertretung', 'A', 'E', 'AP_amount', '', 0, NULL, NULL, 3, NULL, false, '2006-02-03 15:33:11.055578', NULL, NULL, NULL);",
|
|
| 216 |
"INSERT INTO chart VALUES (161, '7780', 'Beiträge zur Berufsvertretung', 'A', 'E', 'AP_amount', '', 0, NULL, NULL, 3, NULL, false, '2006-02-03 15:33:11.055578', NULL, NULL, NULL);",
|
|
| 264 | 217 |
"INSERT INTO chart VALUES (102, '7420', 'Betriebsk. und ant. AfA Garage + Werkst.', 'A', 'E', 'AP_amount', '', 0, NULL, NULL, 3, NULL, false, '2006-01-28 18:22:52.637918', '2006-02-03 15:41:13.126408', NULL, NULL);", |
| 265 |
"INSERT INTO chart VALUES (112, '7700', 'VERSICHERUNGEN UND ?BRIGE AUFW?NDUNGEN', 'H', 'E', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.674186', '2006-02-03 15:44:43.301845', NULL, NULL);",
|
|
| 266 |
"INSERT INTO chart VALUES (114, '8000', 'FINANZERTR?GE UND FINANZAUFW?NDUNGEN', 'H', 'L', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.680743', '2006-02-03 15:45:08.299546', NULL, NULL);",
|
|
| 267 |
"INSERT INTO chart VALUES (33, '1530', 'Vorr?te Gruppe B', 'A', 'A', 'IC', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.392343', '2006-02-03 16:25:53.167131', NULL, NULL);",
|
|
| 218 |
"INSERT INTO chart VALUES (112, '7700', 'VERSICHERUNGEN UND ÜBRIGE AUFWÄNDUNGEN', 'H', 'E', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.674186', '2006-02-03 15:44:43.301845', NULL, NULL);",
|
|
| 219 |
"INSERT INTO chart VALUES (114, '8000', 'FINANZERTRÄGE UND FINANZAUFWÄNDUNGEN', 'H', 'L', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.680743', '2006-02-03 15:45:08.299546', NULL, NULL);",
|
|
| 220 |
"INSERT INTO chart VALUES (33, '1530', 'Vorräte Gruppe B', 'A', 'A', 'IC', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.392343', '2006-02-03 16:25:53.167131', NULL, NULL);",
|
|
| 268 | 221 |
"INSERT INTO chart VALUES (120, '9020', 'nicht einbezahltes Kapital', 'A', 'Q', '', '919', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.700926', NULL, NULL, NULL);", |
| 269 |
"INSERT INTO chart VALUES (121, '9200', 'KAPITALR?CKLAGEN', 'H', 'Q', '', '9', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.703925', NULL, NULL, NULL);",
|
|
| 270 |
"INSERT INTO chart VALUES (122, '9210', 'freie R?cklage', 'A', 'Q', '', '920-929', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.708819', NULL, NULL, NULL);",
|
|
| 222 |
"INSERT INTO chart VALUES (121, '9200', 'KAPITALRÜCKLAGEN', 'H', 'Q', '', '9', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.703925', NULL, NULL, NULL);",
|
|
| 223 |
"INSERT INTO chart VALUES (122, '9210', 'freie Rücklage', 'A', 'Q', '', '920-929', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.708819', NULL, NULL, NULL);",
|
|
| 271 | 224 |
"INSERT INTO chart VALUES (123, '9300', 'GEWINN', 'H', 'Q', '', '939', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.712247', NULL, NULL, NULL);", |
| 272 | 225 |
"INSERT INTO chart VALUES (124, '9310', 'Gewinnvortrag Vorjahr', 'A', 'Q', '', '980', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.716177', NULL, NULL, NULL);", |
| 273 | 226 |
"INSERT INTO chart VALUES (125, '9320', 'Jahresgewinn', 'A', 'Q', '', '985', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.719991', NULL, NULL, NULL);", |
| 274 |
"INSERT INTO chart VALUES (126, '9400', 'R?CKSTELLUNGEN', 'H', 'L', '', '3', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.723021', NULL, NULL, NULL);",
|
|
| 275 |
"INSERT INTO chart VALUES (127, '9420', 'Abfertigungsr?ckstellung', 'A', 'L', '', '300', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.726006', NULL, NULL, NULL);",
|
|
| 276 |
"INSERT INTO chart VALUES (128, '9430', 'Urlaubsr?ckstellung', 'A', 'L', '', '304-309', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.730698', NULL, NULL, NULL);",
|
|
| 227 |
"INSERT INTO chart VALUES (126, '9400', 'RÜCKSTELLUNGEN', 'H', 'L', '', '3', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.723021', NULL, NULL, NULL);",
|
|
| 228 |
"INSERT INTO chart VALUES (127, '9420', 'Abfertigungsrückstellung', 'A', 'L', '', '300', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.726006', NULL, NULL, NULL);",
|
|
| 229 |
"INSERT INTO chart VALUES (128, '9430', 'Urlaubsrückstellung', 'A', 'L', '', '304-309', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.730698', NULL, NULL, NULL);",
|
|
| 277 | 230 |
"INSERT INTO chart VALUES (129, '9700', 'EINLAGEN STILLER GESELLSCHAFTER', 'H', 'Q', '', '9', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.73381', NULL, NULL, NULL);", |
| 278 | 231 |
"INSERT INTO chart VALUES (71, '4300', 'UMSATZ DIENSTLEISTUNGEN', 'H', 'I', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.529746', '2006-01-28 18:34:28.843136', NULL, NULL);", |
| 279 |
"INSERT INTO chart VALUES (9, '0300', 'BETRIEBS- UND GESCH?FTSGEB?UDE', 'H', 'A', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.308885', '2006-02-02 09:31:17.849895', NULL, NULL);",
|
|
| 232 |
"INSERT INTO chart VALUES (9, '0300', 'BETRIEBS- UND GESCHÄFTSGEBÄUDE', 'H', 'A', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.308885', '2006-02-02 09:31:17.849895', NULL, NULL);",
|
|
| 280 | 233 |
"INSERT INTO chart VALUES (45, '2530', 'sonstige Forderungen aus Abgebenverrechnung', 'A', 'A', 'AP_amount', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.435243', '2006-02-02 09:59:42.729713', NULL, NULL);", |
| 281 |
"INSERT INTO chart VALUES (67, '4000', 'BETRIEBLICHE ERTR?GE', 'H', 'I', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.513926', '2006-02-02 10:05:21.278993', NULL, NULL);",
|
|
| 282 |
"INSERT INTO chart VALUES (75, '4630', 'Erl?se aus Abgang vom Anlageverm?gen', 'A', 'I', 'AR_amount:IC_income', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.542817', '2006-02-02 10:09:41.959462', NULL, NULL);",
|
|
| 283 |
"INSERT INTO chart VALUES (131, '4450', 'Erl?sschm?lerung durch Skontoaufwand', 'A', 'I', 'AR_amount', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.740526', '2006-02-02 10:20:51.822294', NULL, NULL);",
|
|
| 284 |
"INSERT INTO chart VALUES (144, '4640', 'Ertr?ge aus Abgang vom Anlageverm?gen', 'A', 'I', 'AR_amount:IC_income', '', 0, NULL, NULL, NULL, NULL, false, '2006-02-02 10:24:49.118289', '2006-02-02 10:25:34.716838', NULL, NULL);",
|
|
| 285 |
"INSERT INTO chart VALUES (118, '9000', 'KAPITAL, UNVERSTEUERTE R?CKLAGEN, ABSCHLUSS- UND EVIDENZKONTEN', 'H', 'Q', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.694841', '2006-02-02 10:28:27.424046', NULL, NULL);",
|
|
| 234 |
"INSERT INTO chart VALUES (67, '4000', 'BETRIEBLICHE ERTRÄGE', 'H', 'I', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.513926', '2006-02-02 10:05:21.278993', NULL, NULL);",
|
|
| 235 |
"INSERT INTO chart VALUES (75, '4630', 'Erlöse aus Abgang vom Anlagevermögen', 'A', 'I', 'AR_amount:IC_income', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.542817', '2006-02-02 10:09:41.959462', NULL, NULL);",
|
|
| 236 |
"INSERT INTO chart VALUES (131, '4450', 'Erlösschmälerung durch Skontoaufwand', 'A', 'I', 'AR_amount', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.740526', '2006-02-02 10:20:51.822294', NULL, NULL);",
|
|
| 237 |
"INSERT INTO chart VALUES (144, '4640', 'Erträge aus Abgang vom Anlagevermögen', 'A', 'I', 'AR_amount:IC_income', '', 0, NULL, NULL, NULL, NULL, false, '2006-02-02 10:24:49.118289', '2006-02-02 10:25:34.716838', NULL, NULL);",
|
|
| 238 |
"INSERT INTO chart VALUES (118, '9000', 'KAPITAL, UNVERSTEUERTE RÜCKLAGEN, ABSCHLUSS- UND EVIDENZKONTEN', 'H', 'Q', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.694841', '2006-02-02 10:28:27.424046', NULL, NULL);",
|
|
| 286 | 239 |
"INSERT INTO chart VALUES (147, '9410', 'Privatentnahme', 'A', 'Q', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-02-02 11:52:04.383364', NULL, NULL, NULL);", |
| 287 | 240 |
"INSERT INTO chart VALUES (76, '5000', 'MATERIALAUFWAND', 'H', 'E', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.545768', '2006-02-02 12:02:53.065559', NULL, NULL);", |
| 288 | 241 |
"INSERT INTO chart VALUES (160, '7140', 'Fremdenverkehrsabgabe', 'A', 'E', 'AP_amount', '', 0, NULL, 12, 3, NULL, false, '2006-02-03 15:16:52.380825', NULL, NULL, NULL);", |
| 289 | 242 |
"INSERT INTO chart VALUES (99, '7310', 'Frachtaufwand durch Dritte', 'A', 'E', 'AP_amount:IC_expense', '', 9, NULL, NULL, 3, NULL, false, '2006-01-28 18:22:52.628717', '2006-02-03 15:22:49.082217', NULL, NULL);", |
| 290 | 243 |
"INSERT INTO chart VALUES (152, '7320', 'KFZ-Aufwand', 'A', 'E', 'AP_amount:IC_expense', '', 9, NULL, NULL, 3, NULL, false, '2006-02-02 12:22:18.511562', '2006-02-03 15:23:31.584235', NULL, NULL);", |
| 291 | 244 |
"INSERT INTO chart VALUES (80, '5600', 'VERBRAUCH BRENN- UND TREIBSTOFFE, ENERGIE UND WASSER', 'H', 'I', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.56006', '2006-02-02 12:17:24.198896', NULL, NULL);", |
| 292 |
"INSERT INTO chart VALUES (109, '7390', 'Porto und Postgeb?hren', 'A', 'E', 'AP_amount:IC_expense', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.661848', '2006-02-02 12:28:47.456197', NULL, NULL);",
|
|
| 245 |
"INSERT INTO chart VALUES (109, '7390', 'Porto und Postgebühren', 'A', 'E', 'AP_amount:IC_expense', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.661848', '2006-02-02 12:28:47.456197', NULL, NULL);",
|
|
| 293 | 246 |
"INSERT INTO chart VALUES (101, '7410', 'Miete und Pachtaufwand', 'A', 'E', 'AP_amount', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.634888', '2006-02-02 12:29:27.184902', NULL, NULL);", |
| 294 | 247 |
"INSERT INTO chart VALUES (107, '7620', 'Zeitungen und Zeitschriften', 'A', 'E', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.655683', '2006-02-02 12:32:43.287819', NULL, NULL);", |
| 295 | 248 |
"INSERT INTO chart VALUES (106, '7670', 'Werbung und Marketing', 'A', 'E', 'AP_amount', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.652584', '2006-02-02 12:33:37.934111', NULL, NULL);", |
| 296 |
"INSERT INTO chart VALUES (110, '7680', 'Repr?sentationsaufwand', 'A', 'E', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.665034', '2006-02-02 12:35:16.950252', NULL, NULL);",
|
|
| 249 |
"INSERT INTO chart VALUES (110, '7680', 'Repräsentationsaufwand', 'A', 'E', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.665034', '2006-02-02 12:35:16.950252', NULL, NULL);",
|
|
| 297 | 250 |
"INSERT INTO chart VALUES (111, '7750', 'Rechtsberatung', 'A', 'E', 'AP_amount', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.671109', '2006-02-02 12:36:56.116865', NULL, NULL);", |
| 298 | 251 |
"INSERT INTO chart VALUES (153, '7755', 'Steuerberatung', 'A', 'E', 'AP_amount', '', 0, NULL, NULL, NULL, NULL, false, '2006-02-02 12:37:35.558667', NULL, NULL, NULL);", |
| 299 |
"INSERT INTO chart VALUES (115, '8280', 'Bankzinsen und Geb?hren', 'A', 'E', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.683783', '2006-02-02 12:41:44.274229', NULL, NULL);",
|
|
| 300 |
"INSERT INTO chart VALUES (117, '8110', 'Ertr?ge aus Zinsen', 'A', 'I', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.691802', '2006-02-02 12:42:41.520779', NULL, NULL);",
|
|
| 301 |
"INSERT INTO chart VALUES (132, '8050', 'Ertr?ge aus Wertpapieren', 'A', 'E', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.743602', '2006-02-02 12:44:29.033245', NULL, NULL);",
|
|
| 302 |
"INSERT INTO chart VALUES (104, '7610', 'B?romaterial', 'A', 'E', 'AP_amount', '', 9, NULL, 11, 3, NULL, false, '2006-01-28 18:22:52.644151', '2006-02-03 15:25:38.53287', NULL, NULL);",
|
|
| 303 |
"INSERT INTO chart VALUES (116, '8010', 'Ertr?ge aus Beteiligungen', 'A', 'I', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.688643', '2006-02-02 12:47:19.930787', NULL, NULL);",
|
|
| 304 |
"INSERT INTO chart VALUES (119, '9010', 'Kapital, Gesch?ftsanteile', 'A', 'Q', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.69788', '2006-02-02 12:48:41.514201', NULL, NULL);",
|
|
| 252 |
"INSERT INTO chart VALUES (115, '8280', 'Bankzinsen und Gebühren', 'A', 'E', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.683783', '2006-02-02 12:41:44.274229', NULL, NULL);",
|
|
| 253 |
"INSERT INTO chart VALUES (117, '8110', 'Erträge aus Zinsen', 'A', 'I', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.691802', '2006-02-02 12:42:41.520779', NULL, NULL);",
|
|
| 254 |
"INSERT INTO chart VALUES (132, '8050', 'Erträge aus Wertpapieren', 'A', 'E', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.743602', '2006-02-02 12:44:29.033245', NULL, NULL);",
|
|
| 255 |
"INSERT INTO chart VALUES (104, '7610', 'Büromaterial', 'A', 'E', 'AP_amount', '', 9, NULL, 11, 3, NULL, false, '2006-01-28 18:22:52.644151', '2006-02-03 15:25:38.53287', NULL, NULL);",
|
|
| 256 |
"INSERT INTO chart VALUES (116, '8010', 'Erträge aus Beteiligungen', 'A', 'I', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.688643', '2006-02-02 12:47:19.930787', NULL, NULL);",
|
|
| 257 |
"INSERT INTO chart VALUES (119, '9010', 'Kapital, Geschäftsanteile', 'A', 'Q', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.69788', '2006-02-02 12:48:41.514201', NULL, NULL);",
|
|
| 305 | 258 |
"INSERT INTO chart VALUES (108, '7380', 'Telefonkosten, Internetkosten', 'A', 'E', 'AP_amount', '', 9, NULL, 11, 3, NULL, false, '2006-01-28 18:22:52.658721', '2006-02-03 15:24:27.553821', NULL, NULL);", |
| 306 |
"INSERT INTO chart VALUES (32, '1520', 'Vorr?te Gruppe A', 'A', 'A', 'IC', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.389168', '2006-02-03 16:26:08.72507', NULL, NULL);",
|
|
| 259 |
"INSERT INTO chart VALUES (32, '1520', 'Vorräte Gruppe A', 'A', 'A', 'IC', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.389168', '2006-02-03 16:26:08.72507', NULL, NULL);",
|
|
| 307 | 260 |
"INSERT INTO chart VALUES (52, '2820', 'Bankguthaben', 'A', 'A', 'AR_paid:AP_paid', '', 0, NULL, NULL, 1, NULL, false, '2006-01-28 18:22:52.458922', '2006-02-04 15:00:18.424069', NULL, NULL);", |
| 308 |
"INSERT INTO chart VALUES (59, '3550', 'Finanzamt Verrechnung K?rperschaftssteuer', 'A', 'L', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.483655', '2006-02-08 20:09:47.697565', NULL, NULL);",
|
|
| 261 |
"INSERT INTO chart VALUES (59, '3550', 'Finanzamt Verrechnung Körperschaftssteuer', 'A', 'L', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.483655', '2006-02-08 20:09:47.697565', NULL, NULL);",
|
|
| 309 | 262 |
"INSERT INTO chart VALUES (60, '3540', 'Finanzamt Verrechnung Umsatzsteuer', 'A', 'L', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.48865', '2006-02-08 20:15:23.622013', NULL, NULL);", |
| 310 | 263 |
"INSERT INTO chart VALUES (78, '5030', 'Warengruppe 1 10 %', 'A', 'E', 'AP_amount:IC_cogs', '', 7, NULL, 4, 2, NULL, false, '2006-01-28 18:22:52.553586', '2006-02-08 20:31:31.539794', NULL, NULL);", |
| 311 | 264 |
"INSERT INTO chart VALUES (79, '5040', 'Warengruppe 2 20%', 'A', 'E', 'AP_amount:IC_cogs', '', 9, NULL, 4, 2, NULL, false, '2006-01-28 18:22:52.55679', '2006-02-03 14:44:38.100283', NULL, NULL);", |
| 312 | 265 |
"INSERT INTO chart VALUES (155, '5210', 'Sonst. Verbrauchsmaterial', 'A', 'E', 'AP_amount', '', 9, NULL, 4, 3, NULL, false, '2006-02-03 14:49:06.01478', '2006-02-03 14:54:51.813269', NULL, NULL);", |
| 313 | 266 |
"INSERT INTO chart VALUES (146, '9850', 'Schlussbilanz', 'A', 'L', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-02-02 10:36:45.059659', '2006-02-02 10:38:05.014595', NULL, NULL);", |
| 314 |
"INSERT INTO chart VALUES (150, '5640', 'Verbrauch von sonstigen ?len und Schmierstoffen', 'A', 'E', 'AP_amount', '', 9, NULL, 4, 1, 19, false, '2006-02-02 12:07:52.512006', '2006-02-03 15:01:09.867763', NULL, NULL);",
|
|
| 315 |
"INSERT INTO chart VALUES (130, '9810', 'Er?ffnungsbilanz', 'A', 'L', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.736825', '2006-02-02 10:37:49.001565', NULL, NULL);",
|
|
| 267 |
"INSERT INTO chart VALUES (150, '5640', 'Verbrauch von sonstigen Ölen und Schmierstoffen', 'A', 'E', 'AP_amount', '', 9, NULL, 4, 1, 19, false, '2006-02-02 12:07:52.512006', '2006-02-03 15:01:09.867763', NULL, NULL);",
|
|
| 268 |
"INSERT INTO chart VALUES (130, '9810', 'Eröffnungsbilanz', 'A', 'L', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.736825', '2006-02-02 10:37:49.001565', NULL, NULL);",
|
|
| 316 | 269 |
"INSERT INTO chart VALUES (164, '9800', 'BILANZKONTEN', 'H', 'L', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-03-06 22:23:47.795675', NULL, NULL, NULL);", |
| 317 | 270 |
"INSERT INTO chart VALUES (148, '5620', 'Verbrauch von Treibstoffen (Diesel)', 'A', 'E', 'AP_amount', '', 9, NULL, 4, 2, 17, false, '2006-02-02 11:59:26.297394', '2006-02-03 15:00:02.362976', NULL, NULL);", |
| 318 |
"INSERT INTO chart VALUES (149, '5630', 'Verbrauch von Treib- und Schmierstoffen f?r Motors?gen', 'A', 'E', 'AP_amount', '', 9, NULL, 4, 1, 19, false, '2006-02-02 12:01:05.969406', '2006-02-03 15:00:30.512596', NULL, NULL);",
|
|
| 319 |
"INSERT INTO chart VALUES (158, '5650', 'gasf?rmige Brennstoffe', 'A', 'E', 'AP_amount', '', 9, NULL, 4, 2, 12, false, '2006-02-03 15:02:36.649746', NULL, NULL, NULL);",
|
|
| 271 |
"INSERT INTO chart VALUES (149, '5630', 'Verbrauch von Treib- und Schmierstoffen für Motorsägen', 'A', 'E', 'AP_amount', '', 9, NULL, 4, 1, 19, false, '2006-02-02 12:01:05.969406', '2006-02-03 15:00:30.512596', NULL, NULL);",
|
|
| 272 |
"INSERT INTO chart VALUES (158, '5650', 'gasförmige Brennstoffe', 'A', 'E', 'AP_amount', '', 9, NULL, 4, 2, 12, false, '2006-02-03 15:02:36.649746', NULL, NULL, NULL);",
|
|
| 320 | 273 |
"INSERT INTO chart VALUES (156, '5710', 'Warenbezugskosten', 'A', 'E', 'AP_amount', '', 9, NULL, 4, 2, 8, false, '2006-02-03 14:56:21.395879', NULL, NULL, NULL);", |
| 321 | 274 |
"INSERT INTO chart VALUES (157, '5750', 'Fremdarbeit', 'A', 'E', 'AP_amount', '', 9, NULL, 4, 2, NULL, false, '2006-02-03 14:58:23.887944', NULL, NULL, NULL);", |
| 322 | 275 |
"INSERT INTO chart VALUES (154, '5310', 'Arbeitskleidung', 'A', 'E', 'AP_amount', '', 9, NULL, 4, 1, NULL, false, '2006-02-03 14:48:10.349391', '2006-02-03 16:23:46.154559', NULL, NULL);", |
| 323 | 276 |
"INSERT INTO chart VALUES (151, '5510', 'Verbrauchswerkzeug', 'A', 'E', 'AP_amount', '', 9, NULL, 4, 2, NULL, false, '2006-02-02 12:19:18.193535', '2006-02-03 14:51:29.573924', NULL, NULL);", |
| 324 | 277 |
"INSERT INTO chart VALUES (81, '5610', 'Energie (Strom und Wasser)', 'A', 'E', 'AP_amount', '', 9, NULL, 4, 2, NULL, false, '2006-01-28 18:22:52.563249', '2006-02-03 14:59:32.292173', NULL, NULL);", |
| 325 | 278 |
"INSERT INTO chart VALUES (97, '7210', 'Reparatur und Instandhaltung', 'A', 'E', 'AP_amount', '', 9, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.620315', '2006-02-03 15:14:08.186799', NULL, NULL);", |
| 326 |
"INSERT INTO chart VALUES (72, '4320', 'Erl?se Beratung', 'A', 'I', 'AR_amount:IC_sale:IC_income', '', 3, 51, 1, 1, 2, false, '2006-01-28 18:22:52.533226', '2006-02-04 23:05:45.241847', NULL, NULL);",
|
|
| 327 |
"INSERT INTO chart VALUES (73, '4330', 'Erl?se Programmierung', 'A', 'I', 'AR_amount:IC_sale:IC_income', '', 3, 51, 1, 1, 1, false, '2006-01-28 18:22:52.536409', '2006-02-04 23:06:03.959353', NULL, NULL);",
|
|
| 328 |
"INSERT INTO chart VALUES (69, '4030', 'Erl?se - Softwareverkauf', 'A', 'I', 'AR_amount:IC_sale', '', 2, 86, 1, 1, 1, false, '2006-01-28 18:22:52.521819', '2006-02-02 10:06:58.91888', NULL, NULL);",
|
|
| 329 |
"INSERT INTO chart VALUES (70, '4040', 'Erl?se - Ersatzteilverkauf', 'A', 'I', 'AR_amount:IC_sale', '', 3, 51, 1, 1, 1, false, '2006-01-28 18:22:52.524987', '2006-02-02 10:07:34.327738', NULL, NULL);",
|
|
| 279 |
"INSERT INTO chart VALUES (72, '4320', 'Erlöse Beratung', 'A', 'I', 'AR_amount:IC_sale:IC_income', '', 3, 51, 1, 1, 2, false, '2006-01-28 18:22:52.533226', '2006-02-04 23:05:45.241847', NULL, NULL);",
|
|
| 280 |
"INSERT INTO chart VALUES (73, '4330', 'Erlöse Programmierung', 'A', 'I', 'AR_amount:IC_sale:IC_income', '', 3, 51, 1, 1, 1, false, '2006-01-28 18:22:52.536409', '2006-02-04 23:06:03.959353', NULL, NULL);",
|
|
| 281 |
"INSERT INTO chart VALUES (69, '4030', 'Erlöse - Softwareverkauf', 'A', 'I', 'AR_amount:IC_sale', '', 2, 86, 1, 1, 1, false, '2006-01-28 18:22:52.521819', '2006-02-02 10:06:58.91888', NULL, NULL);",
|
|
| 282 |
"INSERT INTO chart VALUES (70, '4040', 'Erlöse - Ersatzteilverkauf', 'A', 'I', 'AR_amount:IC_sale', '', 3, 51, 1, 1, 1, false, '2006-01-28 18:22:52.524987', '2006-02-02 10:07:34.327738', NULL, NULL);",
|
|
| 330 | 283 |
"INSERT INTO chart VALUES (57, '3310', 'Verbindlichkeiten aus Lieferungen & Leistungen', 'A', 'L', 'AP', '', 0, NULL, NULL, 1, NULL, false, '2006-01-28 18:22:52.477485', '2006-02-02 18:12:21.634302', NULL, NULL);", |
| 331 | 284 |
"INSERT INTO chart VALUES (51, '2810', 'Schecks', 'A', 'A', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.455807', NULL, NULL, NULL);", |
| 332 |
"INSERT INTO chart VALUES (55, '3120', 'Kredite von Eigent?mern', 'A', 'L', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.471098', NULL, NULL, NULL);",
|
|
| 285 |
"INSERT INTO chart VALUES (55, '3120', 'Kredite von Eigentümern', 'A', 'L', '', '', 0, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.471098', NULL, NULL, NULL);",
|
|
| 333 | 286 |
"INSERT INTO chart VALUES (49, '2710', 'Kassa', 'A', 'A', 'AR_paid', '', 0, NULL, NULL, 1, NULL, false, '2006-01-28 18:22:52.449148', '2006-02-04 14:59:14.410329', NULL, NULL);", |
| 334 | 287 |
"INSERT INTO chart VALUES (77, '5020', 'Warengruppe 0', 'A', 'E', 'IC:IC_cogs:AP_amount', '', 7, NULL, NULL, NULL, 8, false, '2006-01-28 18:22:52.550381', '2006-02-08 20:30:42.871241', NULL, NULL);", |
| 335 |
"INSERT INTO chart VALUES (68, '4020', 'Erl?se - Hardwareverkauf', 'A', 'I', 'AR_amount:IC_sale', '', 2, 86, 1, 1, 1, false, '2006-01-28 18:22:52.51796', '2006-02-04 23:05:12.810823', NULL, NULL);",
|
|
| 288 |
"INSERT INTO chart VALUES (68, '4020', 'Erlöse - Hardwareverkauf', 'A', 'I', 'AR_amount:IC_sale', '', 2, 86, 1, 1, 1, false, '2006-01-28 18:22:52.51796', '2006-02-04 23:05:12.810823', NULL, NULL);",
|
|
| 336 | 289 |
"INSERT INTO chart VALUES (40, '2010', 'Forderungen Lieferung & Leistung', 'A', 'A', 'AR', '200-207', NULL, NULL, NULL, NULL, NULL, false, '2006-01-28 18:22:52.41697', NULL, NULL, NULL);", |
| 337 | 290 |
"INSERT INTO chart VALUES (65, '2510', 'Vorsteuer 10%', 'A', 'E', 'AR_tax:AP_tax:IC_taxpart:IC_taxservice', NULL, 0, 66, NULL, NULL, NULL, false, '2006-01-28 18:22:52.505337', '2006-02-02 17:38:40.373624', NULL, NULL);", |
| 338 | 291 |
"INSERT INTO chart VALUES (64, '2512', 'Vorsteuer 12%', 'A', 'E', 'AR_tax:AP_tax:IC_taxpart:IC_taxservice', NULL, 0, 66, NULL, NULL, NULL, false, '2006-01-28 18:22:52.502023', '2006-02-08 20:14:19.543049', NULL, NULL);", |
| ... | ... | |
| 343 | 296 |
"insert into chart (accno,description,charttype,gifi_accno,category,link) values ('0400','MASCHINEN','H','04-05','A','');",
|
| 344 | 297 |
"insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7411','Lizenzen','A','748-749','E','AP_amount');",
|
| 345 | 298 |
"insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7631','Internetkosten','A','738-739','E','AP_amount:IC_expense');",
|
| 346 |
"insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7632','Reise- und Repr?sentationsaufwand','A','734-735','E','');",
|
|
| 347 |
"insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7634','Registrierungsgeb?hren','A','748-749','E','AP_amount');",
|
|
| 348 |
"insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8020','Bankzinsen und Geb?hren','A','80-83','E','');",
|
|
| 299 |
"insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7632','Reise- und Repräsentationsaufwand','A','734-735','E','');",
|
|
| 300 |
"insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7634','Registrierungsgebühren','A','748-749','E','AP_amount');",
|
|
| 301 |
"insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8020','Bankzinsen und Gebühren','A','80-83','E','');",
|
|
| 349 | 302 |
|
| 350 | 303 |
|
| 351 | 304 |
); |
| 352 | 305 |
|
| 353 | 306 |
for my $statement ( 0 .. $#copy_statements ) {
|
| 354 |
my $query = $iconv->convert($copy_statements[$statement]);
|
|
| 307 |
my $query = $copy_statements[$statement];
|
|
| 355 | 308 |
#print $query . "<br />"; # Diagnose only! |
| 356 |
do_query($query, 0);
|
|
| 309 |
$self->db_query($query, 0);
|
|
| 357 | 310 |
} |
| 358 | 311 |
|
| 359 | 312 |
return 1; |
| 360 | 313 |
} |
| 361 | 314 |
sub do_insert_tax {
|
| 315 |
my ($self) = @_; |
|
| 362 | 316 |
|
| 363 | 317 |
my @copy_statements = ( |
| 364 | 318 |
"INSERT INTO tax (chart_id, taxnumber, taxkey, taxdescription, itime, mtime, rate, id) VALUES (65, '2510', 7, 'Vorsteuer 10%', '2006-01-30 11:08:23.332857', '2006-02-08 20:28:09.63567', 0.10000, 173);", |
| ... | ... | |
| 374 | 328 |
); |
| 375 | 329 |
|
| 376 | 330 |
for my $statement ( 0 .. $#copy_statements ) {
|
| 377 |
my $query = $iconv->convert($copy_statements[$statement]);
|
|
| 331 |
my $query = $copy_statements[$statement];
|
|
| 378 | 332 |
#print $query . "<br />"; # Diagnose only! |
| 379 |
do_query($query, 0);
|
|
| 333 |
$self->db_query($query, 0);
|
|
| 380 | 334 |
} |
| 381 | 335 |
return 1; |
| 382 | 336 |
} |
| 383 | 337 |
|
| 384 | 338 |
sub do_insert_taxkeys {
|
| 339 |
my ($self) = @_; |
|
| 385 | 340 |
|
| 386 | 341 |
my @copy_statements = ( |
| 387 | 342 |
"INSERT INTO taxkeys VALUES (230, 69, 177, 2, NULL, '1970-01-01');", |
| ... | ... | |
| 496 | 451 |
); |
| 497 | 452 |
|
| 498 | 453 |
for my $statement ( 0 .. $#copy_statements ) {
|
| 499 |
my $query = $iconv->convert($copy_statements[$statement]);
|
|
| 454 |
my $query = $copy_statements[$statement];
|
|
| 500 | 455 |
#print $query . "<br />"; # Diagnose only! |
| 501 |
do_query($query, 0);
|
|
| 456 |
$self->db_query($query, 0);
|
|
| 502 | 457 |
} |
| 503 | 458 |
|
| 504 | 459 |
return 1; |
| ... | ... | |
| 506 | 461 |
} |
| 507 | 462 |
|
| 508 | 463 |
sub do_insert_buchungsgruppen {
|
| 464 |
my ($self) = @_; |
|
| 509 | 465 |
|
| 510 | 466 |
my @copy_statements = ( |
| 511 |
"INSERT INTO buchungsgruppen VALUES (256, 'Erl?se aus Dienstleistungen', 23, 72, 99, 72, 77, 72, 77, 72, 77, 3);",
|
|
| 512 |
"INSERT INTO buchungsgruppen VALUES (254, 'Erl?se aus Warenlieferungen', 23, 68, 77, 72, 77, 72, 77, 72, 77, 2);",
|
|
| 513 |
"INSERT INTO buchungsgruppen VALUES (255, 'Erl?se aus Dienstleistungen', 23, 72, 77, 72, 77, 72, 77, 72, 77, 1);",
|
|
| 467 |
"INSERT INTO buchungsgruppen VALUES (256, 'Erlöse aus Dienstleistungen', 23, 72, 99, 72, 77, 72, 77, 72, 77, 3);",
|
|
| 468 |
"INSERT INTO buchungsgruppen VALUES (254, 'Erlöse aus Warenlieferungen', 23, 68, 77, 72, 77, 72, 77, 72, 77, 2);",
|
|
| 469 |
"INSERT INTO buchungsgruppen VALUES (255, 'Erlöse aus Dienstleistungen', 23, 72, 77, 72, 77, 72, 77, 72, 77, 1);",
|
|
| 514 | 470 |
); |
| 515 | 471 |
|
| 516 | 472 |
for my $statement ( 0 .. $#copy_statements ) {
|
| 517 |
my $query = $iconv->convert($copy_statements[$statement]);
|
|
| 473 |
my $query = $copy_statements[$statement];
|
|
| 518 | 474 |
#print $query . "<br />"; # Diagnose only! |
| 519 |
do_query($query, 0);
|
|
| 475 |
$self->db_query($query, 0);
|
|
| 520 | 476 |
} |
| 521 | 477 |
|
| 522 |
return 1; |
|
| 478 |
return 1;
|
|
| 523 | 479 |
} |
| 524 | 480 |
|
| 525 |
|
|
| 526 |
|
|
| 481 |
1; |
|
Auch abrufbar als: Unified diff
Perl-Datenbank-Upgradescripte auf Objektorientierung & strict umgestellt