 --order 502649     
      /*
      CHANGE REPORT for Table PLANTPRODUCTSETTINGS
          - Adding column PUTUPTYPE
      ACTION is ALTER or modify Table PLANTPRODUCTSETTINGS
      */

ALTER TABLE PLANTPRODUCTSETTINGS ADD (PUTUPTYPE NUMBER DEFAULT 0 NOT NULL
					CONSTRAINT PutUpType_valid CHECK (PUTUPTYPE IN (0, 1, 2, 3, 4, 5)));


COMMENT ON COLUMN PLANTPRODUCTSETTINGS.PUTUPTYPE IS '0 = Not defined per plant, copy from product
1 = Put up per customer (Packingnote)
2 = Bulk put up
2 = Bundle tag
4 = Bulk put up scan per route
5 = Packer - Loose linen';

