--ABS-154407
ALTER TABLE SORTINGDEFINITION
  DROP CONSTRAINT SORTFIELD_VALID;
  
ALTER TABLE SORTINGDEFINITION
  ADD CONSTRAINT SORTFIELD_VALID
  CHECK (SORTFIELD BETWEEN 1 AND 19);

COMMENT ON COLUMN SORTINGDEFINITION.SORTFIELD
  IS '1 = Department Number 2 = Wearer Number 3 = Wearer Name 4 = Customer Employee Number 5 = Bank/Locker 6 = Gender 7 = Product Code 8 = Size Code 9 = Delivery Point 10 = Garment Dispenser Code 11 = Customer/Laundry Owned 12 = Ordernumber 13 = Bank 14 = ProductSortGroup 15 = LockerSortGroup 16 = DistributionPointNumber 17 = Size sequence 18 = Season Active 19 = Finishing code sort address';
