ALTER TABLE OM_PRODUTO_ORG_ELEMENTO ADD DSOBSERVACAO VARCHAR2(4000)
/

ALTER TABLE INTEGRACAOFILI DROP CONSTRAINT PK_INTEGRACAOFILI 
/

DROP INDEX PK_INTEGRACAOFILI 
/
 
ALTER TABLE INTEGRACAOFILI ADD CONSTRAINT PK_INTEGRACAOFILI PRIMARY KEY (CDFILIAL, CDINTEGRACAO, IDTOKEN)
/

ALTER TABLE PARFILIALROP DROP CONSTRAINT CKC_IDDATADEVOLROP_PARFILROP
/
        
ALTER TABLE PARFILIALROP ADD CONSTRAINT CKC_IDDATADEVOLROP_PARFILROP CHECK (IDDATADEVOLROP IN ('SAIDA_NF_ORIGEM', 'SAIDA_NF', 'REFE_NF_ORIGEM'))