ALTER TABLE FORNECEDOR ADD IDTRIBCPFOLHA VARCHAR2(01) DEFAULT 'N' NOT NULL
   CONSTRAINT CKC_IDTRIBCPFOLHA_FORNECEDOR CHECK(IDTRIBCPFOLHA IN ('S','N'))
/

ALTER TABLE FORNECEDOR ADD IDPRODPARTPAA VARCHAR2(01) DEFAULT 'N' NOT NULL
   CONSTRAINT CKC_IDPRODPARTPAA_FORNECEDOR CHECK(IDPRODPARTPAA IN ('S','N'))
/

ALTER TABLE FORNECEDOR ADD IDPRODISENT VARCHAR2(01) DEFAULT 'N' NOT NULL
   CONSTRAINT CKC_IDPRODISENT_FORNECEDOR CHECK(IDPRODISENT IN ('S','N'))
/

ALTER TABLE FORNECEDOR ADD IDASSOCDESP VARCHAR2(01) DEFAULT 'N' NOT NULL
   CONSTRAINT CKC_IDASSOCDESP_FORNECEDOR CHECK (IDASSOCDESP IN ('S','N'))
/

ALTER TABLE FORNECEDOR ADD VRALIQRETDESP FLOAT NULL
/

ALTER TABLE FORNECEDOR ADD CDPROCESSO NUMBER NULL
/

ALTER TABLE FORNECEDOR ADD VRALIQNRETDESP FLOAT NULL
/
 
ALTER TABLE IMPOSTO ADD IDTPIMPFILHO VARCHAR2(02) DEFAULT '00' NOT NULL
   CONSTRAINT CKC_IDTPIMPFILHO_IMPOSTO CHECK(IDTPIMPFILHO IN ('00','01','02','03','04','05','06'))
/

   
ALTER TABLE NOTAFISCAL ADD IDTPREPASSEDESP VARCHAR2(01) DEFAULT '0' NOT NULL
   CONSTRAINT CKC_IDTPREPASSEDESP_NOTAFISCAL CHECK (IDTPREPASSEDESP IN ('0','1','2','3','4','5'))
/

ALTER TABLE NOTAFISCAL ADD DSRECURSODESP VARCHAR2(20) NULL
/