projekt kivitendo

INSERT INTO ar (id, invnumber, transdate, gldate, customer_id,
taxincluded, amount, netamount, paid, duedate,
invoice, currency_id, notes,
employee_id)
VALUES (
?, -- id
?, -- invnumber
current_date, -- transdate
current_date, -- gldate
-- customer_id:
(SELECT ar.customer_id
FROM dunning dn
LEFT JOIN ar ON (dn.trans_id = ar.id)
WHERE dn.dunning_id = ?
LIMIT 1),
'f', -- taxincluded
?, -- amount
?, -- netamount
0, -- paid
-- duedate:
(SELECT duedate FROM dunning WHERE dunning_id = ? LIMIT 1),
'f', -- invoice
(SELECT id FROM currencies WHERE name = ?), -- curr
?, -- notes
-- employee_id:
(SELECT id FROM employee WHERE login = ?)
) (1895, 15008, 5723, 0.11, 0.11, 5723, EUR, Automatisch erzeugte Rechnung für Gebühren und Zinsen zu Mahnung 5723, werner)
ERROR: null value in column "taxzone_id" violates not-null constraint