-- ABS-29178

---STOCKROOM table---
ALTER TABLE STOCKROOM DROP COLUMN CHECKINLOCATION_ID;
ALTER TABLE STOCKROOM DROP COLUMN PREWASHLOCATION_ID;
ALTER TABLE STOCKROOM DROP COLUMN WMSOVERFLOWLOCATION_ID;

---STOCKROOMLOCATION table---
ALTER TABLE STOCKROOMLOCATION ADD (STANDARDCHECKINLOCATION VARCHAR2(1) DEFAULT 'N' NOT NULL
                                        CONSTRAINT YN_VALIDATIONFIELD290 CHECK (STANDARDCHECKINLOCATION IN ('Y', 'N')),
                                   STANDARDPREWASHLOCATION VARCHAR2(1) DEFAULT 'N' NOT NULL
                                        CONSTRAINT YN_VALIDATIONFIELD291 CHECK (STANDARDPREWASHLOCATION IN ('Y', 'N')),
                                   STANDARDWMSOVERFLOWLOCATION VARCHAR2(1) DEFAULT 'N' NOT NULL
                                        CONSTRAINT YN_VALIDATIONFIELD292 CHECK (STANDARDWMSOVERFLOWLOCATION IN ('Y', 'N'))
                                   );

COMMENT ON COLUMN STOCKROOMLOCATION.STANDARDCHECKINLOCATION
  IS 'This attribute indicates if this location is the standard check-in location for the stockroom it belongs to.';
COMMENT ON COLUMN STOCKROOMLOCATION.STANDARDPREWASHLOCATION
  IS 'This attribute indicates if this location is the standard prewash location for the stockroom it belongs to.';
COMMENT ON COLUMN STOCKROOMLOCATION.STANDARDWMSOVERFLOWLOCATION
  IS 'This attribute indicates if this location is the standard WMS overflow location for the stockroom it belongs to.';