kivitendo/sql/Pg-upgrade2/marge_initial.sql @ 7b1da9c3
| 4d8a6515 | Philip Reetz | -- @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);
|