ALTER TABLE ITEMVENDA ADD IDOBSERVACAOAD VARCHAR2(1) DEFAULT 'N' NOT NULL
   CONSTRAINT CKC_IDOBSERVACAOAD_ITEMVENDA CHECK (IDOBSERVACAOAD IN ('S','N')) NOVALIDATE
/

ALTER TABLE ITCOMANDAVEN ADD IDOBSERVACAOAD VARCHAR2(1) DEFAULT 'N' NOT NULL
   CONSTRAINT CKC_IDOBSERVACAOAD_ITCOMANDAVE CHECK (IDOBSERVACAOAD IN ('S','N')) NOVALIDATE
/

ALTER TABLE ITEMVENDAEST ADD DSOBSITVENDAEST VARCHAR2(2000) NULL
/