X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/88bb5aaaa09976ba6310116828121d28afe8ffc8..a6b4b406f0a9db0a1c719f4b7d5eb8265f90bf61:/SL/DATEV.pm diff --git a/SL/DATEV.pm b/SL/DATEV.pm index b748d30d2..21e192a08 100644 --- a/SL/DATEV.pm +++ b/SL/DATEV.pm @@ -355,7 +355,7 @@ sub _get_transactions { qq|SELECT ac.acc_trans_id, ac.transdate, ac.trans_id,ar.id, ac.amount, ac.taxkey, ar.invnumber, ar.duedate, ar.amount as umsatz, ct.name, - c.accno, c.taxkey_id as charttax, c.datevautomatik, c.id, c.link, + c.accno, c.taxkey_id as charttax, c.datevautomatik, c.id, ac.chart_link AS link, ar.invoice FROM acc_trans ac LEFT JOIN ar ON (ac.trans_id = ar.id) @@ -370,7 +370,7 @@ sub _get_transactions { SELECT ac.acc_trans_id, ac.transdate, ac.trans_id,ap.id, ac.amount, ac.taxkey, ap.invnumber, ap.duedate, ap.amount as umsatz, ct.name, - c.accno, c.taxkey_id as charttax, c.datevautomatik, c.id, c.link, + c.accno, c.taxkey_id as charttax, c.datevautomatik, c.id, ac.chart_link AS link, ap.invoice FROM acc_trans ac LEFT JOIN ap ON (ac.trans_id = ap.id) @@ -385,7 +385,7 @@ sub _get_transactions { SELECT ac.acc_trans_id, ac.transdate, ac.trans_id,gl.id, ac.amount, ac.taxkey, gl.reference AS invnumber, gl.transdate AS duedate, ac.amount as umsatz, gl.description AS name, - c.accno, c.taxkey_id as charttax, c.datevautomatik, c.id, c.link, + c.accno, c.taxkey_id as charttax, c.datevautomatik, c.id, ac.chart_link AS link, FALSE AS invoice FROM acc_trans ac LEFT JOIN gl ON (ac.trans_id = gl.id)