X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/fc44ab06e84d2546c7eb9c7c5f0586db17f01242..476d2c57a3d2a344009ae3a38fb0e5c84f91914d:/SL/Taxkeys.pm diff --git a/SL/Taxkeys.pm b/SL/Taxkeys.pm index d921a9056..a682dc22c 100644 --- a/SL/Taxkeys.pm +++ b/SL/Taxkeys.pm @@ -60,7 +60,7 @@ sub get_tax_info { if (!$self->{handles}->{get_tax_info}) { $self->{queries}->{get_tax_info} = qq| - SELECT t.rate AS taxrate, t.taxnumber, t.taxdescription, t.chart_id AS taxchart_id, + SELECT t.rate AS taxrate, c.accno as taxnumber, t.taxdescription, t.chart_id AS taxchart_id, c.accno AS taxaccno, c.description AS taxaccount FROM taxkeys tk LEFT JOIN tax t ON (tk.tax_id = t.id)