projekt kivitendo

    qq|  a.marge_total, a.marge_percent, | .

    qq|  a.transaction_description, | .

    qq|  pr.projectnumber AS globalprojectnumber, | .

    qq|  e.name AS employee, | .

    qq|  e2.name AS salesman, | .

    qq|  tz.description AS taxzone, | .

    qq|LEFT JOIN project pr ON (a.globalproject_id = pr.id)| .

    qq|LEFT JOIN tax_zones tz ON (tz.id = c.taxzone_id)| .

    qq|LEFT JOIN payment_terms pt ON (pt.id = c.payment_id)| .

    qq|LEFT JOIN department d ON (d.id = a.department_id)|;

  my $where = "1 = 1";

  @columns =

    qw(transdate id type invnumber ordnumber name netamount tax amount paid

       datepaid due duedate transaction_description notes salesman employee shippingpoint shipvia

  my @hidden_variables = map { "l_${_}" } @columns;

  push @hidden_variables, "l_subtotal", qw(open closed customer invnumber ordnumber transaction_description notes project_id transdatefrom transdateto);

    'taxzone'                 => { 'text' => $locale->text('Steuersatz'), },

    'payment_terms'           => { 'text' => $locale->text('Payment Terms'), },

    'charts'                  => { 'text' => $locale->text('Buchungskonto'), },

  );

  foreach my $name (qw(id transdate duedate invnumber ordnumber name datepaid employee shippingpoint shipvia transaction_description)) {