ALTER TABLE FCT_CONTRATO ADD IDSITUACAORESCISAO VARCHAR2(1)
/

ALTER TABLE FCT_CONTRATO ADD CONSTRAINT CKC_IDSITURESCISAO_CONTRATO CHECK (IDSITUACAORESCISAO IN ('C', 'S'))
/

ALTER TABLE FCT_CONTRATO ADD IDTPEXCLUSAOPARCELA VARCHAR2(1)
/