--Order 20013877.110

---ROUTETRANSACTION table---

ALTER TABLE ROUTETRANSACTION
	ADD (NUMBERVALUE6         NUMBER NULL ,
	          NUMBERVALUE7         NUMBER NULL ,
	          NUMBERVALUE8         NUMBER NULL ,
	          NUMBERVALUE9         NUMBER NULL ,
	          NUMBERVALUE10         NUMBER NULL ,
	          PROCESSEDBYUSER_ID NUMBER NULL,
	          PROCESSEDTIMESTAMP DATE NULL,
	          PROCESSEDSTATUS NUMBER DEFAULT 0 NOT NULL CONSTRAINT PROCESSEDSTATUS_valid CHECK (PROCESSEDSTATUS IN (0, 1, 2, 3, 4)),
	          PROCESSERRORMESSAGE VARCHAR2(300) NULL,
	          WORKORDERNUMBER NUMBER NULL);

COMMENT ON COLUMN ROUTETRANSACTION.PROCESSEDSTATUS IS '0 = New
1 = In progress
2 = Processed (completed)
3 = Error (not processed)
4 = Rejected (not processed)';