projekt kivitendo

         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