--RASA-203/ABS-47324
---MOBILEDEVICE table---
ALTER TABLE MOBILEDEVICE ADD (LOADOFFCYCLECUSTOMERS VARCHAR2(1) DEFAULT 'N' NOT NULL
	CONSTRAINT YN_VALIDATIONFIELD359 CHECK (LOADOFFCYCLECUSTOMERS IN ('Y','N'))
	);


---ROUTETRANSACTION table---
ALTER TABLE ROUTETRANSACTION ADD (CUSTOMER_LINK_ID NUMBER NULL);

CREATE INDEX XIF13ROUTETRANSACTION ON ROUTETRANSACTION (CUSTOMER_LINK_ID ASC);

ALTER TABLE ROUTETRANSACTION
  ADD CONSTRAINT ROUTETRANSACTION_CUST FOREIGN KEY (CUSTOMER_LINK_ID)
  REFERENCES CUSTOMER_LINK (CUSTOMER_LINK_ID) ON DELETE SET NULL;