-- ABS-30106/ ABS-46104

---PRODUCT table---
ALTER TABLE PRODUCT ADD (CLEANROOMBATCHPAIRSCAN VARCHAR2(1) DEFAULT 'N' NOT NULL
                                                CONSTRAINT YN_VALIDATIONFIELD381 CHECK (CLEANROOMBATCHPAIRSCAN IN ('Y','N')));


---PLANTPRODUCTSETTINGS table---
ALTER TABLE PLANTPRODUCTSETTINGS ADD (CLEANROOMBATCHPAIRSCAN VARCHAR2(1) DEFAULT 'N' NOT NULL
                                                CONSTRAINT YN_VALIDATIONFIELD382 CHECK (CLEANROOMBATCHPAIRSCAN IN ('Y','N')));