/*ORDER 502329*/      
      /*
      CHANGE REPORT for Table TEMPORARYDELIVERYSTOP
          - Adding column TEMPSTOPRENTFORDATE
          - Adding column STARTDATE
          - Adding column ENDDATE
      ACTION is ALTER or modify Table TEMPORARYDELIVERYSTOP
      */

ALTER TABLE TEMPORARYDELIVERYSTOP ADD (TEMPSTOPRENTFORDATE  VARCHAR2(1) DEFAULT 
    'N' NOT NULL
                                   CONSTRAINT YN_ValidationNew149
                                          CHECK (TEMPSTOPRENTFORDATE IN ('Y', 
    'N')));


ALTER TABLE TEMPORARYDELIVERYSTOP ADD (STARTDATE            DATE NULL);


ALTER TABLE TEMPORARYDELIVERYSTOP ADD (ENDDATE              DATE NULL);

