projekt kivitendo

    qq|  o.transaction_description, | .

    qq|  o.marge_total, o.marge_percent, | .

    qq|  o.itime::DATE AS insertdate, | .

    qq|  ex.$rate AS exchangerate, | .

    qq|  pt.description AS payment_terms, | .

    qq|  pr.projectnumber AS globalprojectnumber, | .

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

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

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

    qq|$periodic_invoices_joins | .

    qq|WHERE (o.quotation = ?) |;

  push(@values, $quotation);

    "insertdate"              => "o.itime",

    "taxzone"                 => "tz.description",

    "payment_terms"           => "pt.description",

  );

  if ($form->{sort} && grep($form->{sort}, keys(%allowed_sort_columns))) {

    $sortorder = $allowed_sort_columns{$form->{sort}} . " ${sortdir}"  . ", o.itime ${sortdir}";

    "curr",                    "employee",

    "salesman",

    "shipvia",                 "globalprojectnumber",

    "delivered",               "periodic_invoices",

    "marge_total",             "marge_percent",

    "vcnumber",                "ustid",

    'shipvia'                 => { 'text' => $locale->text('Ship via'), },

    'globalprojectnumber'     => { 'text' => $locale->text('Project Number'), },

    'transaction_description' => { 'text' => $locale->text('Transaction description'), },

    'open'                    => { 'text' => $locale->text('Open'), },

    'delivered'               => { 'text' => $locale->text('Delivery Order created'), },

    'marge_total'             => { 'text' => $locale->text('Ertrag'), },

    %column_defs_cvars,

  );

    my $sortdir                 = $form->{sort} eq $name ? 1 - $form->{sortdir} : $form->{sortdir};

    $column_defs{$name}->{link} = $href . "&sort=$name&sortdir=$sortdir";

  }

         <input name="l_transaction_description" id="l_transaction_description" class="checkbox" type="checkbox" value="Y"[% IF INSTANCE_CONF.get_require_transaction_description_ps %] checked[% END %]>

         <label for="l_transaction_description">[% 'Transaction description' | $T8 %]</label>

        </td>

       </tr>

       <tr>

        <td>