ALTER TABLE FCT_CAPAPARAMFATMODCON ADD QTDIASAPURACAO NUMBER
/
ALTER TABLE FCT_CAPAPARAMFATMODCON ADD NRDIACALCVENC NUMBER
/
ALTER TABLE FCT_CAPAPARAMFATMODCON ADD QTDIASFATUVENC NUMBER
/
ALTER TABLE FCT_CAPAPARAMFATMODCON ADD IDTPCALCVENC CHAR(1)
/
ALTER TABLE FCT_CAPAPARAMFATMODCON ADD CONSTRAINT CKC_IDTPCALC_CAPAFATMODCON CHECK(IDTPCALCVENC IN ('1', '2'))
/
ALTER TABLE FCT_CAPAPARAMFATMODCON ADD IDMESCALCVENC CHAR(1)
/
ALTER TABLE FCT_CAPAPARAMFATMODCON ADD CONSTRAINT CKC_MESCALC_CAPAPARAMFATMODCON CHECK(IDMESCALCVENC IN ('1', '2', '3'))