|
-- @tag: marge_initial
|
|
-- @description: Anzeigen des Ertrages pro Position bei Rechnungen und Auftraegen
|
|
-- @depends: status_history
|
|
ALTER TABLE ar add column marge_total NUMERIC(15,5);
|
|
ALTER TABLE ar add column marge_percent NUMERIC(15,5);
|
|
|
|
ALTER TABLE oe add column marge_total NUMERIC(15,5);
|
|
ALTER TABLE oe add column marge_percent NUMERIC(15,5);
|
|
|
|
ALTER TABLE invoice add column marge_total NUMERIC(15,5);
|
|
ALTER TABLE invoice add column marge_percent NUMERIC(15,5);
|
|
ALTER TABLE invoice add column lastcost NUMERIC(15,5);
|
|
|
|
ALTER TABLE orderitems add column marge_total NUMERIC(15,5);
|
|
ALTER TABLE orderitems add column marge_percent NUMERIC(15,5);
|
|
ALTER TABLE orderitems add column lastcost NUMERIC(15,5);
|