ALTER TABLE FCT_CAPAPARAMFATCON ADD QTDIASAPURACAO NUMBER
/
ALTER TABLE FCT_CAPAPARAMFATCON ADD NRDIACALCVENC NUMBER
/
ALTER TABLE FCT_CAPAPARAMFATCON ADD QTDIASFATUVENC NUMBER
/
ALTER TABLE FCT_CAPAPARAMFATCON ADD IDTPCALCVENC CHAR(1)
/
ALTER TABLE FCT_CAPAPARAMFATCON ADD CONSTRAINT CKC_IDTPCALC_CAPAPARAMFATCON CHECK(IDTPCALCVENC IN ('1', '2'))
/
ALTER TABLE FCT_CAPAPARAMFATCON ADD IDMESCALCVENC CHAR(1)
/
ALTER TABLE FCT_CAPAPARAMFATCON ADD CONSTRAINT CKC_MESCALC_CAPAPARAMFATCON CHECK(IDMESCALCVENC IN ('1', '2', '3'))

