ALTER TABLE DADOSFISCREGRA ADD IDCONSMVAPMC VARCHAR2(01) DEFAULT '3'  
/ 

ALTER TABLE DADOSFISCREGRA ADD IDCONSCOMPBCPMC VARCHAR2(01) DEFAULT '3'
/

ALTER TABLE DADOSFISCNCM ADD IDCONSMVAPMC VARCHAR2(01) DEFAULT '3'
/

ALTER TABLE DADOSFISCNCM ADD IDCONSCOMPBCPMC VARCHAR2(01) DEFAULT '3'
/

ALTER TABLE DADOSFISCPROD ADD IDCONSMVAPMC VARCHAR2(01) DEFAULT '3'
/

ALTER TABLE DADOSFISCPROD ADD IDCONSCOMPBCPMC VARCHAR2(01) DEFAULT '3'
/

ALTER TABLE ALIQTEMP ADD IDCONSMVAPMC VARCHAR2(01)
/

ALTER TABLE ALIQTEMP ADD IDCONSCOMPBCPMC VARCHAR2(01)
/

ALTER TABLE ITEMPROIMPOS ADD IDCONSMVAPMC VARCHAR2(01)
/

ALTER TABLE ITEMPROIMPOS ADD IDCONSCOMPBCPMC VARCHAR2(01)
/

ALTER TABLE TRABITPROIMPOS ADD IDCONSMVAPMC VARCHAR2(01)
/

ALTER TABLE TRABITPROIMPOS ADD IDCONSCOMPBCPMC VARCHAR2(01)
/

ALTER TABLE ITEMPROIMPOSORIG ADD IDCONSMVAPMC VARCHAR2(01)
/

ALTER TABLE ITEMPROIMPOSORIG ADD IDCONSCOMPBCPMC VARCHAR2(01)
/

ALTER TABLE ITEMPRODUTO ADD IDUTILBCPMC VARCHAR2(01) DEFAULT 'N' NOT NULL 
	CONSTRAINT CKC_ITEMPRODUTO_IDUTILBCPMC CHECK (IDUTILBCPMC IN ('N', 'S'))