--- ABS-151681 LST To be able to end the route on the phone without having scanned and touched the customer under certain conditions

ALTER TABLE REASONCODE  
      ADD (NOSCANDELIVERY VARCHAR2(1) DEFAULT 'N' NULL CHECK (NOSCANDELIVERY IN ('Y','N')));
      COMMENT ON COLUMN REASONCODE.NOSCANDELIVERY IS 'Only used with module ROUTEASSISTANTANDROID.';
      
ALTER TABLE STOP 
      ADD (NOSCANREASONCODE_ID NUMBER NULL);
      
ALTER TABLE STOP      
      ADD CONSTRAINT STOP_NOSCANREASONCODE_ID FOREIGN KEY (NOSCANREASONCODE_ID)
      REFERENCES REASONCODE (REASONCODE_ID) ON DELETE SET NULL;
      
CREATE INDEX XIF8STOP ON STOP (NOSCANREASONCODE_ID ASC);
