-- ABS-153861 Settlement - Needs a way of identifying where settlement was started from WebX or ABSSolute client DLG / ABS-153873


ALTER TABLE ROUTECONTROL ADD (SETTLEMENTORIGIN NUMBER DEFAULT 0 NOT NULL CONSTRAINT CHK_ROUTECONTROL_SETTLEMENTORIGIN CHECK (SETTLEMENTORIGIN IN (0, 1, 2, 3)));

COMMENT ON COLUMN ROUTECONTROL.SETTLEMENTORIGIN IS '0 = Not Specified
1 = ABSSolute Client
2 = Web Client X
3 = Scheduled Processes
';
