--ABS-169634
CREATE TABLE ERP_O_CLEANROOMUNIQUEITEM (
TRANSFER_ID        NUMBER NOT NULL,
TRANSFER_STATUS    NUMBER DEFAULT 0 NOT NULL,      
PRIMARYID          NUMBER NOT NULL,
OLD_CUSTOMERNUMBER NUMBER,    
NEW_CUSTOMERNUMBER NUMBER,       
OLD_WEARERNUMBER   NUMBER,   
NEW_WEARERNUMBER   NUMBER,
PRODUCTCODE        VARCHAR2(12),
SIZECODE           VARCHAR2(12),
SYSTEMUSER_ID      NUMBER NOT NULL, 
TIMESTAMP          DATE   NOT NULL);
ALTER TABLE ERP_O_CLEANROOMUNIQUEITEM
ADD CONSTRAINT PK_ERP_O_CLEANROOMUNIQUEITEM PRIMARY KEY (TRANSFER_ID);
ALTER TABLE ERP_O_CLEANROOMUNIQUEITEM ADD CONSTRAINT CHK_ERP_O_CLEANROOMUNIQUEITEM_STATUS CHECK (TRANSFER_STATUS IN (0,1));