projekt kivitendo

		LEFT Join tax t ON (a.taxkey = t.taxkey)

		WHERE a.trans_id = $self->{id}

		AND a.fx_transaction = '0'

    $sth = $dbh->prepare($query);

    $sth->execute || $self->dberror($query);

    $self->{exchangerate} =

      $self->get_exchangerate($dbh, $self->{currency}, $self->{transdate},

                              $fld);

    # store amounts in {acc_trans}{$key} for multiple accounts

    while (my $ref = $sth->fetchrow_hashref(NAME_lc)) {

      $ref->{exchangerate} =

        $self->get_exchangerate($dbh, $self->{currency}, $ref->{transdate},

                                $fld);

      push @{ $self->{acc_trans}{ $xkeyref{ $ref->{accno} } } }, $ref;

    }