ALTER TABLE VENDA ADD IDVENDEXPORT VARCHAR2(1) DEFAULT 'N' NOT NULL
/
ALTER TABLE VENDA ADD CONSTRAINT CKC_VENDA_IDVENDEXPORT CHECK (IDVENDEXPORT IN ('S', 'N'))
/
ALTER TABLE VENDA ADD CODEXTVEND NUMBER
/
ALTER TABLE REDUCAOZ ADD IDREDUZEXPORT VARCHAR2(1) DEFAULT 'N' NOT NULL
/
ALTER TABLE REDUCAOZ ADD CONSTRAINT CKC_VENDA_IDREDUZEXPORT CHECK (IDREDUZEXPORT IN ('S', 'N'))
/
ALTER TABLE OPERADOR ADD CODEXTOPER NUMBER
/
ALTER TABLE VENDEDOR ADD CODEXTVENDE NUMBER