-- ABS-36825/ ABS-46126

COMMENT ON COLUMN DELIVERYVARIATIONS.SOILCOUNTSUBTYPE
  IS '0 - Not applicable 1 - Regular soil count 2 - Shortage 3 - Rejected 4 = Heavy Soil 5 = Clean Return 6 = Loss 7 = Inscan Default value 0 Note: option 6 is used in combination with Origin = 7 (Replacement) . Others are used in combination with Origin = 1 (soil count) .';

ALTER TABLE DELIVERYVARIATIONS
  DROP CONSTRAINT SOILCOUNTSUBTYPE_VALID;
ALTER TABLE DELIVERYVARIATIONS
  ADD CONSTRAINT SOILCOUNTSUBTYPE_VALID
  CHECK (SOILCOUNTSUBTYPE IN (0,1,2,3,4,5,6,7));