ALTER TABLE PARAVEND ADD IDUTILFID4ALL VARCHAR2(1) DEFAULT 'N' NOT NULL
   CONSTRAINT CKC_IDUTILFID4ALL_PARAVEND CHECK (IDUTILFID4ALL IN ('S','N'))
/

ALTER TABLE PARAVEND ADD CDURLWSFID4ALL VARCHAR2(250) NULL
/

ALTER TABLE VENDA ADD NRCPFFID4ALL VARCHAR2(20) NULL
/ 

ALTER TABLE VENDA ADD CDPROMOFID4ALL VARCHAR2(50) NULL
/

ALTER TABLE VENDA ADD VRDESCCASH4ALL FLOAT NULL
/

ALTER TABLE VENDA ADD VRDESCPROMO4ALL FLOAT NULL
/

ALTER TABLE VENDA ADD IDENVIOFID4ALL VARCHAR2(1) NULL
   CONSTRAINT CKC_IDENVIOFID4ALL_VENDA CHECK (IDENVIOFID4ALL IN ('S','N'))
/

ALTER TABLE COMANDAVEN ADD NRCPFFID4ALL VARCHAR2(20) NULL
/

ALTER TABLE COMANDAVEN ADD CDPROMOFID4ALL VARCHAR2(50) NULL
/

ALTER TABLE COMANDAVEN ADD VRDESCCASH4ALL FLOAT NULL
/

ALTER TABLE COMANDAVEN ADD VRDESCPROMO4ALL FLOAT NULL
/