pgsql/investigations/ar-creditmemo.sql

[Pman.Xtuple] / pgsql / x-dragon-cohead.sql

-- add a 'displayed' sales person.


alter table cohead add column cohead_display_salesrep_id INTEGER;

ALTER TABLE cohead add column cohead_pretax_discount numeric(16,4) NOT NULL DEFAULT 0;

ALTER TABLE cohead add column cohead_posttax_discount numeric(16,4) NOT NULL DEFAULT 0;
 
ALTER TABLE cohead ADD CONSTRAINT cohead_display_salesrep_fkey FOREIGN KEY (cohead_display_salesrep_id)
        REFERENCES salesrep(salesrep_id) MATCH SIMPLE
      ON UPDATE CASCADE ON DELETE NO ACTION;