

ALTER TABLE PRODUCTLISTPERDISTRIBPOINT
	ADD (RECALCMINSTOCKQTY NUMBER DEFAULT  0 NOT NULL CONSTRAINT  RECMINSTOCKQTY_valid CHECK (RECALCMINSTOCKQTY IN ('0', '1')),
	     MINSTOCKQTY NUMBER DEFAULT  0 NOT NULL  CONSTRAINT  MINSTOCKQTY_valid CHECK (MINSTOCKQTY BETWEEN 0 AND 9999),
	     MAXSSTOCKQTY NUMBER DEFAULT  0 NOT NULL  CONSTRAINT  MAXSSTOCKQTY_valid CHECK (MAXSSTOCKQTY BETWEEN 0 AND 9999));

COMMENT ON COLUMN PRODUCTLISTPERDISTRIBPOINT.RECALCMINSTOCKQTY IS '0 = not applicable / do not calculate
1 = recalculate minimum stock quantities
';
