-- ABS-49247/ ABS-51049

---STAY table---
INSERT INTO STAY
  (STAY_ID, STAYTYPE, STAYNR, SYSTEMUSER_ID, TIMESTAMP, FACTORYDESCRIPTION)
  VALUES
  (SEQ_STAY.NEXTVAL, 1, 41,  GETMINSYSTEMUSER(), SYSDATE, 'Inscan / Clean Return');
COMMIT;

INSERT INTO STAY_DESC
 (STAY_ID, LANGUAGE_ID, DESCRIPTION, SYSTEMUSER_ID, TIMESTAMP)
SELECT S.STAY_ID, L.LANGUAGE_ID, S.FACTORYDESCRIPTION, GETMINSYSTEMUSER(), SYSDATE 
FROM STAY S, LANGUAGES L
WHERE L.TRANSLATEDESCRIPTION = 'Y'
AND S.STAYTYPE = 1 AND S.STAYNR = 41;
COMMIT;

---MULTIREADSCANBATCHCONTENTS table---
ALTER TABLE MULTIREADSCANBATCHCONTENTS MODIFY (UNIQUEITEMBATCHNUMBER VARCHAR2(24));

---SCAN table---
ALTER TABLE SCAN MODIFY (BATCHNUMBER VARCHAR2(24));

---UNIQUEITEM table---
ALTER TABLE UNIQUEITEM MODIFY (BATCHNUMBER VARCHAR2(24));