Revision 9a194d6a
Von G. Richardson vor etwa 13 Jahren hinzugefügt
| SL/AM.pm | ||
|---|---|---|
| 210 | 210 |
# sanity check, can't have AR with AR_... |
| 211 | 211 |
if ($form->{AR} || $form->{AP} || $form->{IC}) {
|
| 212 | 212 |
map { delete $form->{$_} }
|
| 213 |
qw(AR_amount AR_tax AR_paid AP_amount AP_tax AP_paid IC_sale IC_cogs IC_taxpart IC_income IC_expense IC_taxservice CT_tax);
|
|
| 213 |
qw(AR_amount AR_tax AR_paid AP_amount AP_tax AP_paid IC_sale IC_cogs IC_taxpart IC_income IC_expense IC_taxservice); |
|
| 214 | 214 |
} |
| 215 | 215 |
|
| 216 | 216 |
$form->{link} = "";
|
| ... | ... | |
| 221 | 221 |
$form->{IC}, $form->{IC_sale},
|
| 222 | 222 |
$form->{IC_cogs}, $form->{IC_taxpart},
|
| 223 | 223 |
$form->{IC_income}, $form->{IC_expense},
|
| 224 |
$form->{IC_taxservice}, $form->{CT_tax}
|
|
| 224 |
$form->{IC_taxservice}
|
|
| 225 | 225 |
) {
|
| 226 | 226 |
$form->{link} .= "${item}:" if ($item);
|
| 227 | 227 |
} |
| SL/RP.pm | ||
|---|---|---|
| 1293 | 1293 |
$main::lxdebug->leave_sub(); |
| 1294 | 1294 |
} |
| 1295 | 1295 |
|
| 1296 |
sub get_taxaccounts {
|
|
| 1297 |
$main::lxdebug->enter_sub(); |
|
| 1298 |
|
|
| 1299 |
my ($self, $myconfig, $form) = @_; |
|
| 1300 |
|
|
| 1301 |
# connect to database |
|
| 1302 |
my $dbh = $form->dbconnect($myconfig); |
|
| 1303 |
|
|
| 1304 |
# get tax accounts |
|
| 1305 |
my $query = |
|
| 1306 |
qq|SELECT c.accno, c.description, t.rate |
|
| 1307 |
FROM chart c, tax t |
|
| 1308 |
WHERE (c.link LIKE '%CT_tax%') AND (c.id = t.chart_id) |
|
| 1309 |
ORDER BY c.accno|; |
|
| 1310 |
$form->{taxaccounts} = selectall_hashref_query($form, $dbh, $query);
|
|
| 1311 |
|
|
| 1312 |
$dbh->disconnect; |
|
| 1313 |
|
|
| 1314 |
$main::lxdebug->leave_sub(); |
|
| 1315 |
} |
|
| 1316 |
|
|
| 1317 | 1296 |
sub tax_report {
|
| 1318 | 1297 |
$main::lxdebug->enter_sub(); |
| 1319 | 1298 |
|
| bin/mozilla/am.pl | ||
|---|---|---|
| 560 | 560 |
: ( $link eq 'IC_income' ) ? $locale->text('Account Link IC_income')
|
| 561 | 561 |
: ( $link eq 'IC_expense' ) ? $locale->text('Account Link IC_expense')
|
| 562 | 562 |
: ( $link eq 'IC_taxservice' ) ? $locale->text('Account Link IC_taxservice')
|
| 563 |
# : ( $link eq 'CT_tax' ) ? $locale->text('Account Link CT_tax')
|
|
| 564 | 563 |
: $locale->text('Unknown Link') . ': ' . $link;
|
| 565 | 564 |
$ca->{link} .= ($link ne '') ? "[$link] ":'';
|
| 566 | 565 |
} |
| bin/mozilla/rp.pl | ||
|---|---|---|
| 158 | 158 |
my $is_bwa = $::form->{report} eq "bwa";
|
| 159 | 159 |
my $is_balance_sheet = $::form->{report} eq "balance_sheet";
|
| 160 | 160 |
my $is_trial_balance = $::form->{report} eq "trial_balance";
|
| 161 |
my $is_taxreport = $::form->{report} =~ /^tax_/;
|
|
| 162 |
my $is_nontaxable = $::form->{report} =~ /^nontaxable_/;
|
|
| 163 | 161 |
my $is_aging = $::form->{report} =~ /^a[rp]_aging$/;
|
| 164 | 162 |
my $is_payments = $::form->{report} =~ /(receipts|payments)$/;
|
| 165 | 163 |
|
| 166 |
# if (is_taxreport) {
|
|
| 167 |
# $::form->{db} = ($::form->{report} =~ /_collected/) ? "ar" : "ap";
|
|
| 168 |
# RP->get_taxaccounts(\%::myconfig, $::form); |
|
| 169 |
# } |
|
| 170 |
# |
|
| 171 |
# if ($is_nontaxable) {
|
|
| 172 |
# $::form->{db} = ($::form->{report} =~ /_sales/) ? "ar" : "ap";
|
|
| 173 |
# } |
|
| 174 |
|
|
| 175 | 164 |
my ($label, $nextsub, $vc); |
| 176 | 165 |
if ($is_aging) {
|
| 177 | 166 |
my $is_sales = $::form->{report} eq 'ar_aging';
|
| locale/de/all | ||
|---|---|---|
| 73 | 73 |
'Account Link AR_amount' => 'Forderungen Erlöskonto', |
| 74 | 74 |
'Account Link AR_paid' => 'Forderungen Zahlungseingang', |
| 75 | 75 |
'Account Link AR_tax' => 'Forderungen Steuer', |
| 76 |
'Account Link CT_tax' => 'Kunde/Lieferant Steuer', |
|
| 77 | 76 |
'Account Link IC' => 'Inventar', |
| 78 | 77 |
'Account Link IC_cogs' => 'Warenliste Aufwandskonto', |
| 79 | 78 |
'Account Link IC_expense' => 'Dienstleistungen Aufwandskonto', |
| locale/de_DE/all | ||
|---|---|---|
| 83 | 83 |
'Account Link AR_amount' => 'Forderungen Erlöskonto', |
| 84 | 84 |
'Account Link AR_paid' => 'Forderungen Zahlungseingang', |
| 85 | 85 |
'Account Link AR_tax' => 'Forderungen Steuer', |
| 86 |
'Account Link CT_tax' => 'Kunde/Lieferant Steuer', |
|
| 87 | 86 |
'Account Link IC' => 'Inventar', |
| 88 | 87 |
'Account Link IC_cogs' => 'Warenliste Aufwandskonto', |
| 89 | 88 |
'Account Link IC_expense' => 'Dienstleistungen Aufwandskonto', |
| locale/en/all | ||
|---|---|---|
| 83 | 83 |
'Account Link AR_amount' => '', |
| 84 | 84 |
'Account Link AR_paid' => '', |
| 85 | 85 |
'Account Link AR_tax' => '', |
| 86 |
'Account Link CT_tax' => '', |
|
| 87 | 86 |
'Account Link IC' => '', |
| 88 | 87 |
'Account Link IC_cogs' => '', |
| 89 | 88 |
'Account Link IC_expense' => '', |
| locale/fr/missing | ||
|---|---|---|
| 75 | 75 |
'Account Link AR_amount' => '', |
| 76 | 76 |
'Account Link AR_paid' => '', |
| 77 | 77 |
'Account Link AR_tax' => '', |
| 78 |
'Account Link CT_tax' => '', |
|
| 79 | 78 |
'Account Link IC' => '', |
| 80 | 79 |
'Account Link IC_cogs' => '', |
| 81 | 80 |
'Account Link IC_expense' => '', |
| sql/Austria-chart.sql | ||
|---|---|---|
| 62 | 62 |
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3500','VERBINDLICHKEITEN FINANZAMT','H','35','L','');
|
| 63 | 63 |
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3510','Finanzamt Verrechnung K?rperschaftssteuer','A','350-359','L','');
|
| 64 | 64 |
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3520','Finanzamt Verrechnung Umsatzsteuer','A','350-359','L','');
|
| 65 |
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3530','Mehrwertsteuer 0%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice:CT_tax');
|
|
| 66 |
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3531','Mehrwertsteuer 10%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice:CT_tax');
|
|
| 67 |
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3532','Mehrwertsteuer 20%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice:CT_tax');
|
|
| 68 |
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3540','Vorsteuer 0%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice:CT_tax');
|
|
| 69 |
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3541','Vorsteuer 10%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice:CT_tax');
|
|
| 70 |
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3542','Vorsteuer 20%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice:CT_tax');
|
|
| 65 |
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3530','Mehrwertsteuer 0%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
|
|
| 66 |
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3531','Mehrwertsteuer 10%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
|
|
| 67 |
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3532','Mehrwertsteuer 20%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
|
|
| 68 |
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3540','Vorsteuer 0%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
|
|
| 69 |
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3541','Vorsteuer 10%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
|
|
| 70 |
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3542','Vorsteuer 20%','A','350-359','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
|
|
| 71 | 71 |
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4000','UMSATZ','H','4','I','');
|
| 72 | 72 |
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4020','Verkauf - Hardware','A','40-44','I','AR_amount:IC_sale');
|
| 73 | 73 |
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4030','Verkauf - Software ','A','40-44','I','AR_amount:IC_sale');
|
| sql/France-chart.sql | ||
|---|---|---|
| 900 | 900 |
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('445500', 'TAXES SUR CA A DECAISSER', 'A', '', '', '');
|
| 901 | 901 |
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('706000', 'PRESTATIONS DE SERVICES', 'A', '', 'I', 'IC_income');
|
| 902 | 902 |
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('707000', 'VENTES DE MARCHANDISES', 'A', '', 'I', 'IC_sale');
|
| 903 |
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('445713', 'TVA COLLECTEE 19.6%', 'A', '', 'I', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax');
|
|
| 903 |
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('445713', 'TVA COLLECTEE 19.6%', 'A', '', 'I', 'AR_tax:IC_taxpart:IC_taxservice');
|
|
| 904 | 904 |
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('512020', 'BANQUE DEBIT', 'A', '', 'E', 'AP');
|
| 905 |
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('445711', 'TVA COLLECTEE 5.5%', 'A', '', 'I', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax');
|
|
| 906 |
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('445661', 'TVA DEDUCTIBLE 5.5%', 'A', '', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax');
|
|
| 905 |
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('445711', 'TVA COLLECTEE 5.5%', 'A', '', 'I', 'AR_tax:IC_taxpart:IC_taxservice');
|
|
| 906 |
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('445661', 'TVA DEDUCTIBLE 5.5%', 'A', '', 'E', 'AP_tax:IC_taxpart:IC_taxservice');
|
|
| 907 | 907 |
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('512010', 'BANQUE CREDIT', 'A', '', 'I', 'AR:AR_amount');
|
| 908 | 908 |
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('681730', 'STOCKS ET EN-COURS', 'A', '', 'A', 'IC');
|
| 909 | 909 |
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('580010', 'VIREMENT INTERNE', 'A', '', 'E', '');
|
| ... | ... | |
| 930 | 930 |
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('609400', 'D\'ETUDES & PRESTATIONS DE SERVICES', 'A', '', '', '');
|
| 931 | 931 |
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('625100', 'VOYAGES ET DEPLACEMENTS', 'A', '', 'E', 'AP_amount');
|
| 932 | 932 |
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('618300', 'DOCUMENTATION TECHNIQUE', 'A', '', 'E', 'AP_amount');
|
| 933 |
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('445663', 'TVA DEDUCTIBLE 19.6%', 'A', '', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax');
|
|
| 933 |
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('445663', 'TVA DEDUCTIBLE 19.6%', 'A', '', 'E', 'AP_tax:IC_taxpart:IC_taxservice');
|
|
| 934 | 934 |
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('601000', 'ACHATS STOCKES MAT. PREM. (FOURN.)', 'A', '', 'E', 'AP_amount:IC_cogs');
|
| 935 | 935 |
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('626000', 'FRAIS POSTAUX ET TELECOMMUNIC.', 'A', '', 'E', 'AP_amount');
|
| 936 | 936 |
INSERT INTO "chart" ("accno", "description", "charttype", "gifi_accno", "category", "link") VALUES ('512000', 'BANQUE', 'A', '', 'A', 'AR_paid:AP_paid');
|
| sql/Germany-DATEV-SKR03EU-chart.sql | ||
|---|---|---|
| 194 | 194 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0650', 'Vblk.geg.Kreditinst.- Restlaufzeit gr?sser als 5 Jahre', 'A', 'A', '', '0650', 0, NULL, NULL, NULL, NULL, FALSE);
|
| 195 | 195 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4510', 'Kfz-Steuer', 'A', 'E', 'AP_amount', '4510', 0, NULL, 19, NULL, 15, FALSE);
|
| 196 | 196 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4520', 'Kfz-Versicherungen', 'A', 'E', 'AP_amount', '4520', 0, NULL, 14, NULL, 16, FALSE);
|
| 197 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1771', 'Umsatzsteuer 7%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax', '1771', 0, NULL, NULL, NULL, 5, FALSE);
|
|
| 198 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1775', 'Umsatzsteuer 16%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax', '1775', 0, NULL, NULL, NULL, 6, FALSE);
|
|
| 197 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1771', 'Umsatzsteuer 7%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', '1771', 0, NULL, NULL, NULL, 5, FALSE);
|
|
| 198 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1775', 'Umsatzsteuer 16%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', '1775', 0, NULL, NULL, NULL, 6, FALSE);
|
|
| 199 | 199 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1767', 'Im anderen EG-Staat steuerpfl. Lieferung', 'A', ' ', '', '1767', 10, NULL, 0, NULL, NULL, FALSE);
|
| 200 | 200 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('0853', 'Satzungsm.R?cklagen 0% Vorbelast.(st.Einlagekto.)', 'A', 'Q', '', '0853', 0, NULL, NULL, NULL, NULL, FALSE);
|
| 201 | 201 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1607', 'Vblk.a.LuL ohne Vorsteuer (E?R)', 'A', 'L', 'AP', '1607', 0, NULL, NULL, NULL, NULL, FALSE);
|
| ... | ... | |
| 259 | 259 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('8922', 'Verwend.f.Gegenst.f.Zwecke au?erh.d.Untern.16%USt(Telefonnutzung)', 'A', 'I', '', '8922', 0, 0, 5, NULL, 3, TRUE);
|
| 260 | 260 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1000', 'Kasse', 'A', 'A', 'AR_paid:AP_paid', '1000', 0, NULL, NULL, NULL, NULL, FALSE);
|
| 261 | 261 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1572', 'Steuerpflicht. EG-Erwerb 7%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', '1572', 0, 61, NULL, NULL, 27, FALSE);
|
| 262 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1571', 'Abziehbare Vorsteuer 7%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1570', 0, 66, NULL, NULL, 27, FALSE);
|
|
| 262 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1571', 'Abziehbare Vorsteuer 7%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', '1570', 0, 66, NULL, NULL, 27, FALSE);
|
|
| 263 | 263 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1573', 'Steuerpflicht. EG-Erwerb 16%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', '1573', 0, 61, NULL, NULL, 27, FALSE);
|
| 264 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1575', 'Abziehbare Vorsteuer 16%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1570', 0, 66, NULL, NULL, 27, FALSE);
|
|
| 264 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1575', 'Abziehbare Vorsteuer 16%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', '1570', 0, 66, NULL, NULL, 27, FALSE);
|
|
| 265 | 265 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1772', 'Steuerpflicht. EG-Lieferungen 7%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', '1772', 0, NULL, NULL, NULL, 6, FALSE);
|
| 266 | 266 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1773', 'Steuerpflicht. EG-Lieferungen 16%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', '1773', 0, NULL, NULL, NULL, 28, FALSE);
|
| 267 | 267 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('2501', 'Ausserordentliche Ertr?ge finanzwirksam', 'A', 'I', '', '2501', 0, NULL, NULL, NULL, 5, FALSE);
|
| ... | ... | |
| 284 | 284 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3090', 'Energiestoffe (Fert.).', 'A', 'E', 'IC', '3090', 9, 0, 4, NULL, 8, FALSE);
|
| 285 | 285 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('4595', 'Fremdfahrzeuge', 'A', 'E', 'AP_amount', '4570', 0, NULL, 14, NULL, 17, FALSE);
|
| 286 | 286 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1450', 'Ford.a.LuL n.Durchschnittss.gem.?24UStG(E?R)', 'A', 'A', 'AR', '1448', 0, NULL, NULL, NULL, NULL, FALSE);
|
| 287 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1577', 'Abzieb.Vorst.n.allg.Durchschnittss.UStVA Kz.63', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1577', 0, NULL, NULL, NULL, 27, FALSE);
|
|
| 288 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1578', 'Abzieb.Vorst.n.?13b', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1578', 0, NULL, NULL, NULL, 27, FALSE);
|
|
| 287 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1577', 'Abzieb.Vorst.n.allg.Durchschnittss.UStVA Kz.63', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', '1577', 0, NULL, NULL, NULL, 27, FALSE);
|
|
| 288 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1578', 'Abzieb.Vorst.n.?13b', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', '1578', 0, NULL, NULL, NULL, 27, FALSE);
|
|
| 289 | 289 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1580', 'Gegenkonto Vorsteuer ?4/3 EStG', 'A', 'A', '', '1580', 0, NULL, NULL, NULL, NULL, FALSE);
|
| 290 | 290 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1581', 'Aufl?sung Vorst.a.Vorjahr ?4/3 EStG', 'A', 'A', '', '1581', 0, NULL, NULL, NULL, NULL, FALSE);
|
| 291 | 291 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1582', 'Vorst.aus Investitionen ?4/3 EStG', 'A', 'E', '', '1582', 0, NULL, NULL, NULL, 27, FALSE);
|
| ... | ... | |
| 395 | 395 |
insert into taxkeys (chart_id, tax_id, taxkey_id, pos_ustva, startdate) select chart.id, tax.id, taxkey_id, pos_ustva, '1970-01-01' from chart LEFT JOIN tax on (tax.taxkey=chart.taxkey_id) WHERE taxkey_id is not null; |
| 396 | 396 |
insert into taxkeys (chart_id, tax_id, taxkey_id,startdate) SELECT 0, id, taxkey, '1970-01-01' FROM tax; |
| 397 | 397 |
INSERT INTO chart (accno, description, charttype, category, link, taxkey_id, pos_ustva, pos_eur) |
| 398 |
VALUES ('1776','Umsatzsteuer 19 %', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax', 0, 511,6);
|
|
| 398 |
VALUES ('1776','Umsatzsteuer 19 %', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', 0, 511,6);
|
|
| 399 | 399 |
INSERT INTO chart (accno, description, charttype, category, link, taxkey_id, pos_ustva, pos_eur) |
| 400 |
VALUES ('1576','Abziehbare Vorsteuer 19 %', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', 0, 66,27);
|
|
| 400 |
VALUES ('1576','Abziehbare Vorsteuer 19 %', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', 0, 66,27);
|
|
| 401 | 401 |
INSERT INTO tax (chart_id, rate, taxnumber, taxkey, taxdescription) VALUES ((SELECT id from CHART WHERE accno='1776'), 0.19, '1776', 3, 'Umsatzsteuer 19%'); |
| 402 | 402 |
INSERT INTO tax (chart_id, rate, taxnumber, taxkey, taxdescription) VALUES ((SELECT id from CHART WHERE accno='1576'), 0.19, '1576', 9, 'Vorsteuer 19%'); |
| 403 | 403 |
insert into taxkeys (chart_id, tax_id, taxkey_id, pos_ustva, startdate) select chart.id, (SELECT id from tax where taxdescription='Umsatzsteuer 19%'), 3, pos_ustva, '2007-01-01' from chart WHERE taxkey_id=3; |
| sql/Germany-DATEV-SKR04EU-chart.sql | ||
|---|---|---|
| 28 | 28 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1249', 'Pauschwertber. zu Forder. Restlzeit >1 Jahr', 'A', 'E', '', '1249', 0, NULL, 31, NULL, NULL, FALSE);
|
| 29 | 29 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1370', 'Durchlaufende Posten', 'A', 'A', '', '1370', 0, NULL, NULL, NULL, NULL, FALSE);
|
| 30 | 30 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1374', 'Fremdgeld', 'A', 'A', '', '1374', 0, NULL, NULL, NULL, NULL, FALSE);
|
| 31 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1401', 'Abziehbare Vorsteuer 7%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1401', 0, 66, NULL, NULL, 27, FALSE);
|
|
| 31 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1401', 'Abziehbare Vorsteuer 7%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', '1401', 0, 66, NULL, NULL, 27, FALSE);
|
|
| 32 | 32 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1402', 'Abziehbare Vorsteuer aus innergemeinschftl. Erwerb', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', '1402', 0, 61, NULL, NULL, 27, FALSE);
|
| 33 | 33 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1403', 'Abziehbare Vorsteuer aus innergemeinschftl. Erwerb 16%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', '1403', 0, 61, NULL, NULL, 27, FALSE);
|
| 34 | 34 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1404', 'Abziehbare Vorsteuer aus innergemeinschftl. Erwerb 19%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', '1403', 0, 61, NULL, NULL, 27, FALSE);
|
| 35 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1405', 'Abziehbare Vorsteuer 16%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1405', 0, 66, NULL, NULL, 27, FALSE);
|
|
| 36 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1406', 'Abziehbare Vorsteuer 19 %', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', 0, 0, 66, NULL, NULL, 27, FALSE);
|
|
| 37 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1407', 'Abziehbare Vorsteuer nach ? 13b UStG 19%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1407', 0, NULL, NULL, NULL, 27, FALSE);
|
|
| 38 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1408', 'Abziehbare Vorsteuer nach ? 13b UStG', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1408', 0, NULL, NULL, NULL, 27, FALSE);
|
|
| 39 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1409', 'Abziehbare Vorsteuer nach ? 13b UStG 16%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', '1408', 0, NULL, NULL, NULL, 27, FALSE);
|
|
| 35 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1405', 'Abziehbare Vorsteuer 16%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', '1405', 0, 66, NULL, NULL, 27, FALSE);
|
|
| 36 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1406', 'Abziehbare Vorsteuer 19 %', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', 0, 0, 66, NULL, NULL, 27, FALSE);
|
|
| 37 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1407', 'Abziehbare Vorsteuer nach ? 13b UStG 19%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', '1407', 0, NULL, NULL, NULL, 27, FALSE);
|
|
| 38 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1408', 'Abziehbare Vorsteuer nach ? 13b UStG', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', '1408', 0, NULL, NULL, NULL, 27, FALSE);
|
|
| 39 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1409', 'Abziehbare Vorsteuer nach ? 13b UStG 16%', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', '1408', 0, NULL, NULL, NULL, 27, FALSE);
|
|
| 40 | 40 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1432', 'abziehb. VorSt EU-Erwerb Neufzg.b.Lief. o. USt-IdNr.', 'A', 'E', 'AR_tax', '1483', 0, NULL, NULL, NULL, 27, FALSE);
|
| 41 | 41 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1433', 'Bezahlte Einfuhrumsatzsteuer', 'A', 'E', '', '1433', 0, 62, NULL, NULL, NULL, FALSE);
|
| 42 | 42 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('1460', 'Geldtransit', 'A', 'A', '', '1460', 0, NULL, NULL, NULL, NULL, FALSE);
|
| ... | ... | |
| 61 | 61 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3306', 'Verbindlk. aus LuL zum erm. USTsatz (E?R)', 'A', 'L', 'AP', '3306', 0, NULL, NULL, NULL, NULL, FALSE);
|
| 62 | 62 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3307', 'Verbindlk. aus LuL ohne Vorsteuer (E?R)', 'A', 'L', 'AP', '3307', 0, NULL, NULL, NULL, NULL, FALSE);
|
| 63 | 63 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3309', 'Gegenkonto 3305-3307 bei Auteilung d. Forder. nach Steuers?tzen (E?R)', 'A', 'L', '', '3309', 0, NULL, NULL, NULL, NULL, FALSE);
|
| 64 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3801', 'Umsatzsteuer 7%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax', '3801', 0, NULL, NULL, NULL, 5, FALSE);
|
|
| 64 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3801', 'Umsatzsteuer 7%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', '3801', 0, NULL, NULL, NULL, 5, FALSE);
|
|
| 65 | 65 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3802', 'Umsatzsteuer aus innergemeinschftl. Erwerb', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', '3802', 0, NULL, NULL, NULL, 6, FALSE);
|
| 66 | 66 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3803', 'Umsatzsteuer aus innergemeinschftl. Erwerb 16%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', '3803', 0, NULL, NULL, NULL, 28, FALSE);
|
| 67 | 67 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3804', 'Umsatzsteuer aus innergemeinschftl. Erwerb 19%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', '3803', 0, NULL, NULL, NULL, 28, FALSE);
|
| 68 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3805', 'Umsatzsteuer 16%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax', '3805', 0, NULL, NULL, NULL, 6, FALSE);
|
|
| 69 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3806', 'Umsatzsteuer 19%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax', '3805', 0, 511, NULL, NULL, 6, FALSE);
|
|
| 68 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3805', 'Umsatzsteuer 16%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', '3805', 0, NULL, NULL, NULL, 6, FALSE);
|
|
| 69 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3806', 'Umsatzsteuer 19%', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', '3805', 0, 511, NULL, NULL, 6, FALSE);
|
|
| 70 | 70 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3817', 'Umsatzsteuer aus in anderen EG-Land stpfl. Lieferungen', 'A', ' ', '', '3817', 10, NULL, 0, NULL, NULL, FALSE);
|
| 71 | 71 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3820', 'Umsatzsteuer-Vorauszahlungen', 'A', 'E', '', '3820', 0, NULL, NULL, NULL, 28, FALSE);
|
| 72 | 72 |
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, pos_eur, datevautomatik) VALUES ('3830', 'Umsatzsteuer-Vorauszahlungen 1/11', 'A', 'E', '', '3830', 0, NULL, NULL, NULL, 28, FALSE);
|
| sql/Pg-upgrade/Pg-upgrade-2.2.0.31-2.2.0.32.pl | ||
|---|---|---|
| 26 | 26 |
if (!$count) {
|
| 27 | 27 |
$query = |
| 28 | 28 |
qq|INSERT INTO chart (accno, description, charttype, category, link, taxkey_id, pos_ustva, pos_eur) |
| 29 |
VALUES ('1776','Umsatzsteuer 19 %', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax', 0, 511,6)|;
|
|
| 29 |
VALUES ('1776','Umsatzsteuer 19 %', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', 0, 511,6)|;
|
|
| 30 | 30 |
$dbh->do($query) || mydberror($query); |
| 31 | 31 |
} |
| 32 | 32 |
$query = "SELECT COUNT(*) FROM chart " . |
| ... | ... | |
| 36 | 36 |
if (!$count) {
|
| 37 | 37 |
$query = |
| 38 | 38 |
qq|INSERT INTO chart (accno, description, charttype, category, link, taxkey_id, pos_ustva, pos_eur) |
| 39 |
VALUES ('1576','Abziehbare Vorsteuer 19 %', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', 0, 66,27)|;
|
|
| 39 |
VALUES ('1576','Abziehbare Vorsteuer 19 %', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', 0, 66,27)|;
|
|
| 40 | 40 |
$dbh->do($query) || mydberror($query); |
| 41 | 41 |
} |
| 42 | 42 |
|
| ... | ... | |
| 69 | 69 |
if (!$count) {
|
| 70 | 70 |
$query = |
| 71 | 71 |
qq|INSERT INTO chart (accno, description, charttype, category, link, taxkey_id, pos_ustva, pos_eur) |
| 72 |
VALUES ('3806','Umsatzsteuer 19 %', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax', 0, 511,6)|;
|
|
| 72 |
VALUES ('3806','Umsatzsteuer 19 %', 'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', 0, 511,6)|;
|
|
| 73 | 73 |
$dbh->do($query) || mydberror($query); |
| 74 | 74 |
} |
| 75 | 75 |
$query = "SELECT COUNT(*) FROM chart " . |
| ... | ... | |
| 79 | 79 |
if (!$count) {
|
| 80 | 80 |
$query = |
| 81 | 81 |
qq|INSERT INTO chart (accno, description, charttype, category, link, taxkey_id, pos_ustva, pos_eur) |
| 82 |
VALUES ('1406','Abziehbare Vorsteuer 19 %', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax', 0, 66,27)|;
|
|
| 82 |
VALUES ('1406','Abziehbare Vorsteuer 19 %', 'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', 0, 66,27)|;
|
|
| 83 | 83 |
$dbh->do($query) || mydberror($query); |
| 84 | 84 |
} |
| 85 | 85 |
|
| sql/Pg-upgrade2/ustva_setup_2007_update_chart_taxkeys_tax.sql | ||
|---|---|---|
| 18 | 18 |
) |
| 19 | 19 |
SELECT |
| 20 | 20 |
'1570','Anrechenbare Vorsteuer', |
| 21 |
'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax',
|
|
| 21 |
'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', |
|
| 22 | 22 |
0 |
| 23 | 23 |
WHERE EXISTS ( -- update only for SKR03 |
| 24 | 24 |
SELECT coa FROM defaults |
| ... | ... | |
| 33 | 33 |
) |
| 34 | 34 |
SELECT |
| 35 | 35 |
'1574','Abziehbare Vorsteuer aus innergem. Erwerb 19 %', |
| 36 |
'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice:CT_tax',
|
|
| 36 |
'A', 'E', 'AP_tax:IC_taxpart:IC_taxservice', |
|
| 37 | 37 |
0 |
| 38 | 38 |
WHERE EXISTS ( -- update only for SKR03 |
| 39 | 39 |
SELECT coa FROM defaults |
| ... | ... | |
| 48 | 48 |
) |
| 49 | 49 |
SELECT |
| 50 | 50 |
'1774','Umsatzsteuer aus innergem. Erwerb 19 %', |
| 51 |
'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice:CT_tax',
|
|
| 51 |
'A', 'I', 'AR_tax:IC_taxpart:IC_taxservice', |
|
| 52 | 52 |
0 |
| 53 | 53 |
WHERE EXISTS ( -- update only for SKR03 |
| 54 | 54 |
SELECT coa FROM defaults |
| sql/Swiss-German-chart.sql | ||
|---|---|---|
| 21 | 21 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21205','Leasing','A','21200','L','AP');
|
| 22 | 22 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21210','Kurzfristige Finanzverbindlichkeiten','H','21000','L','');
|
| 23 | 23 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21220','Andere kurzfristige Verbindlichkeiten','H','21000','L','');
|
| 24 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21222','MWST (3,6)','A','21220','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice:CT_tax');
|
|
| 24 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21222','MWST (3,6)','A','21220','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
|
|
| 25 | 25 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21229','Gewinnaussch?ttung','A','21220','L','');
|
| 26 | 26 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21230','Passive Rechnungsabgrenzung, kurzfristige R?ckstellungen','H','21000','L','');
|
| 27 | 27 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21235','R?ckstellungen','A','21230','L','');
|
| ... | ... | |
| 133 | 133 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('36002','Reise (Fahrt)','A','36000','I','IC_income');
|
| 134 | 134 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11117','MWST Vorsteuer auf Aufwand','A','11110','A','');
|
| 135 | 135 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21228','Geschuldete Steuern','A','21220','L','AP');
|
| 136 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21223','MWST (7,6)','A','21220','L','AR_tax:AP_tax:IC_taxpart:IC_expense:IC_taxservice:CT_tax');
|
|
| 136 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21223','MWST (7,6)','A','21220','L','AR_tax:AP_tax:IC_taxpart:IC_expense:IC_taxservice');
|
|
| 137 | 137 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('57001','AHV, IV, EO, ALV','A','57000','E','AP_amount:IC_income:IC_expense');
|
| 138 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21221','MWST (2,4)','A','21220','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice:CT_tax');
|
|
| 139 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21224','MWST (7.6) 1/2','A','21220','L','AR_tax:AP_tax:IC_taxpart:IC_expense:IC_taxservice:CT_tax');
|
|
| 138 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21221','MWST (2,4)','A','21220','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
|
|
| 139 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21224','MWST (7.6) 1/2','A','21220','L','AR_tax:AP_tax:IC_taxpart:IC_expense:IC_taxservice');
|
|
| 140 | 140 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('66001','Werbeaufwand','A','66000','E','AP_amount:IC_expense');
|
| 141 | 141 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('21217','Privat','A','21210','L','AP');
|
| 142 | 142 |
INSERT INTO chart (accno,description,charttype,gifi_accno,category,link) VALUES ('11101','Kasse','A','11100','A','AR_paid:AP_paid');
|
Auch abrufbar als: Unified diff
Überreste von CT_tax entfernt
Wird nirgends mehr verwendet, bzw. sind die aufgerufenen
Funktionen dazu schon lange auskommentiert. Auch aus den
Kontenrahmen und Updatescripts entfernt, da beim Speichern
eines Kontos die CT_tax Information in link eh verloren geht.
Es gibt in rp.pl auch noch Referenzen auf die Berichte
"tax_collected" und "tax_paid", aber keine Menüpunkte oder
Druckvorlagen dazu, können die auch raus?