-- ABS-32852/ ABS-37743

ALTER TABLE STOCKROOM ADD (ALLOWPREQALTERNATIVESUPPLIER NUMBER DEFAULT 0 NOT NULL);
 
COMMENT ON COLUMN STOCKROOM.ALLOWPREQALTERNATIVESUPPLIER
  IS 'This attribute indicates whether an option ‘Alternative Supplier’ will be available in the ‘Purchase Requisition’ dialog. Possible values:
0 = Not available
1 = Available
The attribute is in fact only relevant when the module ADVANCEDPURCHASING is in the license';

ALTER TABLE STOCKROOM
  ADD CONSTRAINT ALLOWPREQALTSUPP_VALID1_1
  CHECK (ALLOWPREQALTERNATIVESUPPLIER IN (0, 1));