X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FCT.pm;h=fa1f914773542ebdfcb41ad033a766f290300d1e;hb=1734e1ad21eea72ffe4f3ac606cc4a33f97bd5f5;hp=b7ae9a50407f5a1383c9a62aabfda267caf95cd2;hpb=9dc87ef78822b92f0e8271ec733048fbec6ce4d5;p=kivitendo-erp.git

diff --git a/SL/CT.pm b/SL/CT.pm
index b7ae9a504..fa1f91477 100644
--- a/SL/CT.pm
+++ b/SL/CT.pm
@@ -308,7 +308,8 @@ sub get_bank_info {
   my $table        = $params{vc} eq 'customer' ? 'customer' : 'vendor';
   my @ids          = ref $params{id} eq 'ARRAY' ? @{ $params{id} } : ($params{id});
   my $placeholders = join ", ", ('?') x scalar @ids;
-  my $query        = qq|SELECT id, name, account_number, bank, bank_code, iban, bic
+  my $c_mandate    = $params{vc} eq 'customer' ? ', mandator_id, mandate_date_of_signature' : '';
+  my $query        = qq|SELECT id, name, account_number, bank, bank_code, iban, bic ${c_mandate}
                         FROM ${table}
                         WHERE id IN (${placeholders})|;