ALTER TABLE ITDETALORCAMESGOP ADD IDORIGPERC VARCHAR2(30) NULL
/
ALTER TABLE ITDETALORCAMESGOP ADD CONSTRAINT CKC_IDORIGPERC_ITDETORCAMESGOP CHECK (IDORIGPERC IS NULL OR (IDORIGPERC IN ('GERAL','UNIDADE')))
/
ALTER TABLE ITORCAMESGOP ADD IDORIGPERC VARCHAR2(30) NULL
/
ALTER TABLE ITORCAMESGOP ADD CONSTRAINT	CKC_IDORIGPERC_ITORCAMESGOP CHECK  (IDORIGPERC IS NULL OR (IDORIGPERC IN ('GERAL','UNIDADE')))
/
ALTER TABLE FILIAL ADD IDUTILPERCFILGOP VARCHAR2(01) NULL
/
ALTER TABLE CONSISTORCAMENTO ADD VRCONSUMOITEM  NUMBER   NULL