projekt kivitendo

        i.id AS invoice_id,

        i.description, i.longdescription, i.qty, i.fxsellprice AS sellprice, i.parts_id AS id, i.unit, i.deliverydate, i.project_id, i.serialnumber,

        i.price_factor_id, i.price_factor, i.marge_price_factor, i.discount,

        FROM invoice i

        JOIN parts p ON (i.parts_id = p.id)

  my $query =

    qq|SELECT

         p.id, p.partnumber, p.description, p.lastcost AS sellprice, p.listprice,

         p.notes AS partnotes, p.notes AS longdescription, p.not_discountable,

         p.inventory_accno_id, p.price_factor_id,