X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/57463eed482c9f107a6bb35d8b24d666175570a3..dd0ba7b9a6f931ce13ced906d9cc6cb3e7c3ea3a:/SL/SEPA.pm

diff --git a/SL/SEPA.pm b/SL/SEPA.pm
index 9a2978314..32e763cdb 100644
--- a/SL/SEPA.pm
+++ b/SL/SEPA.pm
@@ -21,7 +21,7 @@ sub retrieve_open_invoices {
 
   my $query =
     qq|
-       SELECT ${arap}.id, ${arap}.invnumber, ${arap}.${vc}_id, ${arap}.amount AS invoice_amount, ${arap}.invoice,
+       SELECT ${arap}.id, ${arap}.invnumber, ${arap}.${vc}_id as vc_id, ${arap}.amount AS invoice_amount, ${arap}.invoice,
          vc.name AS vcname, vc.language_id, ${arap}.duedate as duedate,
 
          COALESCE(vc.iban, '') <> '' AND COALESCE(vc.bic, '') <> '' AS vc_bank_info_ok,