ALTER TABLE FCT_CAPAPARAMFATESC ADD IDMUNIPRESTSERV VARCHAR2(1)
/

ALTER TABLE FCT_CAPAPARAMFATESC ADD CONSTRAINT CKC_IDMUNIPRESTSERV_PARFAT CHECK (IDMUNIPRESTSERV IN ('U','T'))
/

ALTER TABLE FCT_CAPAPARAMFATESC ADD IDTIPONATUOPER VARCHAR2(1)
/

ALTER TABLE FCT_CAPAPARAMFATESC ADD CONSTRAINT CKC_IDTIPONATUOPER_PARFAT CHECK (IDTIPONATUOPER IN ('F','V'))
/

ALTER TABLE FCT_CAPAPARAMFATESC ADD IDNATUOPER VARCHAR2(2)
/


ALTER TABLE FCT_CONTRATO ADD IDMUNIPRESTSERV VARCHAR2(1)
/

ALTER TABLE FCT_CONTRATO ADD CONSTRAINT CKC_IDMUNIPRESTSERV_CONT CHECK (IDMUNIPRESTSERV IN ('U','T'))
/


ALTER TABLE FCT_NEGOCIACAOCONTRATO ADD IDNATUOPER VARCHAR2(2)
/


ALTER TABLE FCT_MEDICAOFATURA ADD IDNATUOPER VARCHAR2(2)
/


ALTER TABLE FCT_FATURACONT ADD IDNATUOPER VARCHAR2(2)
/