--ABS-168245

--OUTOFCIRCULATIONHISTORY

ALTER TABLE OUTOFCIRCULATIONHISTORY ADD (ORIGIN NUMBER DEFAULT 0 NOT NULL 
CONSTRAINT CHK_OUTOFCIRCULATIONHISTORY_ORIGIN CHECK (ORIGIN IN (0,1,2,3,4,5,6,7,8,9,10)),
CREATIONSYSTEMUSER_ID NUMBER,
CREATIONTIMESTAMP TIMESTAMP
);
COMMENT ON COLUMN OUTOFCIRCULATIONHISTORY.ORIGIN IS 
'0= Not defined - default 
1= Return to stock / rag (Take items out of circ dialog)
2= Return to stock / rag in batch
3= Settlement
4= Route Returns
5= PL/SQL Return Unique Item To Stock
6= RouteAssistant Upload
7= PL/SQL MultiRead.RagScanInBatch
8= Process Rag after grace period
9= Garment Dispense
10=Cancelled loss recharge in loss charge monitor';


