ALTER TABLE NOTAFISCAL ADD IDNFDEVOOLCX VARCHAR2(1)
   CONSTRAINT CKC_IDNFDEVOOLCX_NF CHECK (IDNFDEVOOLCX IS NULL OR (IDNFDEVOOLCX IN ('S','N')))
/

CREATE INDEX UN_ENDPARTSPED_01 ON TMP_ENDPARTSPED (INSCRICAO ASC)
/ 