projekt kivitendo

         -- duedate:

         (SELECT duedate FROM dunning WHERE dunning_id = ? LIMIT 1),

         'f',                   -- invoice

         ?,                     -- notes

         -- employee_id:

         (SELECT id FROM employee WHERE login = ?)

         ar.transdate,       ar.duedate,      ar.customer_id,

         ar.invnumber,       ar.ordnumber,    ar.cp_id,

         ar.amount,          ar.netamount,    ar.paid,

         ar.amount - ar.paid AS open_amount,

         ar.amount - ar.paid + da.fee + da.interest AS linetotal