ALTER TABLE VENDAREST ADD NRCHAVEPEDGALE VARCHAR2(100) 
/

ALTER TABLE COMANDAVEN ADD NRIDPEDIDOSID VARCHAR2(15)
/

ALTER TABLE COMANDAVEN ADD CDLOJASID VARCHAR2(4)
/

ALTER TABLE COMANDAVEN ADD DSORIGEMPEDSID VARCHAR2(50)
/

ALTER TABLE COMANDAVEN ADD DSSEGMENTOSID VARCHAR2(20)
/

ALTER TABLE COMANDAVEN ADD IDFUNCPEDSID VARCHAR2(1)
/

ALTER TABLE CAIXA ADD IDINTDLVVOXLINE VARCHAR2(1) DEFAULT 'N'
	CONSTRAINT CKC_IDINTDLVVOXLINE_CAIXA CHECK (IDINTDLVVOXLINE IN ('S','N'))
/

ALTER TABLE CAIXA ADD DSDIRDLVVOXLINE VARCHAR2(250)
/

ALTER TABLE CAIXA ADD NRTIMERIMPCUP VARCHAR2(4) DEFAULT '30'  NULL
/

ALTER TABLE CAIXA ADD NRTIMERHRAGEN VARCHAR2(4) DEFAULT '60'  NULL
/

ALTER TABLE LOJA ADD IDIMPSEGVIASAN VARCHAR2(1) DEFAULT 'N' NOT NULL
	CONSTRAINT CKC_IDIMPSEGVIASAN_LOJA CHECK (IDIMPSEGVIASAN IN ('S', 'N'))
/