ALTER TABLE DOCARRECADPAG DROP CONSTRAINT CKC_IDTIPOGUIA_DOCARR
/
 
ALTER TABLE DOCARRECADPAG 
   ADD CONSTRAINT CKC_IDTIPOGUIA_DOCARR CHECK (IDTIPOGUIA IN ('I','O','D','F','P','A','M','G','S','N'))
/

ALTER TABLE DOCARRECADPAG ADD NRSEQMAPAPURESTNC   NUMBER  NULL
/

ALTER TABLE DOCARRECADPAG ADD NRSEQGUIAAPURNC     NUMBER  NULL
/

UPDATE DOCARRECADPAG
   SET IDTRANSMISSAO = 'N'
 WHERE IDTRANSMISSAO IS NULL
/
COMMIT
/

ALTER TABLE DOCARRECADPAG MODIFY IDTRANSMISSAO DEFAULT 'N' NOT NULL
/