ALTER TABLE VENDA ADD DSEMAILENVCUPOM VARCHAR2(50)
/

ALTER TABLE VENDA ADD IDSITENVCUPOM VARCHAR2(01) DEFAULT 'U' NOT NULL
/

ALTER TABLE VENDA ADD CONSTRAINT CKC_IDSITENVCUPOM_VENDA CHECK (IDSITENVCUPOM IN ('U', 'N', 'E', 'A'))
/

ALTER TABLE VENDA ADD DTHRENVCUPOM DATE
/

ALTER TABLE VENDA ADD DSRETENVCUPOM VARCHAR2(100)
/

ALTER TABLE PARAMGERAL ADD DSMSGCUPOMEMAIL VARCHAR2(250)
/

ALTER TABLE PARAMGERAL ADD HRENVCUPOMEMAIL VARCHAR2(04)
/

ALTER TABLE PARAMGERAL ADD DSDIRPROJENVCUP VARCHAR2(255)
/

ALTER TABLE CAIXA ADD IDENVCUPOMEMAIL VARCHAR2(01) DEFAULT 'N'
/

ALTER TABLE CAIXA  ADD CONSTRAINT CKC_IDENVCUPOMEMAIL_CAIXA CHECK (IDENVCUPOMEMAIL IN ('S', 'N'))
/