X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/56a7606e2639dab82e3ddcd5055267dc7da91620..c1716dbdeb0ba6d2cd9c708a2c54b9845e9532b4:/SL/SEPA.pm diff --git a/SL/SEPA.pm b/SL/SEPA.pm index d4967964e..38341eccd 100644 --- a/SL/SEPA.pm +++ b/SL/SEPA.pm @@ -178,7 +178,7 @@ sub retrieve_export { my ($columns, $joins); if ($params{details}) { - $columns = qq|, arap.invnumber, arap.invoice, vc.name AS vc_name, c.accno AS chart_accno, c.description AS chart_description|; + $columns = qq|, arap.invnumber, arap.invoice, arap.transdate AS reference_date, vc.name AS vc_name, c.accno AS chart_accno, c.description AS chart_description|; $joins = qq|LEFT JOIN ${arap} arap ON (sei.${arap}_id = arap.id) LEFT JOIN ${vc} vc ON (arap.${vc}_id = vc.id) LEFT JOIN chart c ON (sei.chart_id = c.id)|;