ALTER TABLE VENDITEMPED ADD IDCANCCOMISPED  VARCHAR2(01) DEFAULT 'N'
	      CONSTRAINT CKC_IDCANCCOMISPED_VENDITEMPED CHECK (IDCANCCOMISPED  IN ('S','N'))
/

ALTER TABLE VENDITEMPED ADD DSMOTCANCCOMISPED VARCHAR2(350) NULL 
/