projekt kivitendo

    $filters{table}         = "oe";

    $filters{where}         = 'COALESCE(quotation, FALSE) AND (vendor_id IS NOT NULL)';

    $filters{trans_number}  = "partnumber";

    my %numberfield_hash = ( service        => 'servicenumber',

                             assembly       => 'assemblynumber',

                             assortment     => 'assortmentnumber',

                             part           => 'articlenumber'

                           );

    $filters{numberfield}   = $numberfield_hash{$type};