ALTER TABLE CONTARECEBER ADD IDREPFOSCNC VARCHAR2(01) DEFAULT 'N' NOT NULL
/

ALTER TABLE CONTARECEBER ADD CONSTRAINT CKC_IDREPFOSCNC CHECK (IDREPFOSCNC IN ('R', 'N')) 
/
ALTER TABLE TIPORECE ADD IDCONTAPREVCNC VARCHAR2(01) DEFAULT 'N' NOT NULL
/

ALTER TABLE TIPORECE ADD CONSTRAINT CKC_IDCONTAPREVCNC CHECK (IDCONTAPREVCNC IN ('S', 'N'))
/