ALTER TABLE FATURAMENTOROP ADD VRFATDEVCANC FLOAT NULL
/

ALTER TABLE PERCITEMDETALGOP ADD CDDESPADMFAT VARCHAR2(10) NULL
/

ALTER TABLE PERCITEMDETALGOP ADD CDORCAMENTOMO VARCHAR2(10) NULL
/

ALTER TABLE PERCITDETALFILGOP ADD CDDESPADMFAT VARCHAR2(10) NULL
/

ALTER TABLE PERCITDETALFILGOP ADD CDORCAMENTOMO VARCHAR2(10) NULL
/

ALTER TABLE DESPESASROP DROP CONSTRAINT CKC_IDTPLANCROP_DESPESASROP
/

ALTER TABLE DESPESASROP ADD CONSTRAINT CKC_IDTPLANCROP_DESPESASROP CHECK (IDTPLANCROP IS NULL OR (IDTPLANCROP IN ('DESPESA', 'MAOOBRA', 'DEPRECIACAO', 'AJUSTECT', 'TAXAADM')))
/

ALTER TABLE DESPESASROP DROP CONSTRAINT CKC_IDTIPODESP_DESPESASROP
/

ALTER TABLE DESPESASROP ADD CONSTRAINT CKC_IDTIPODESP_DESPESASROP CHECK (IDTIPODESP IS NULL OR (IDTIPODESP IN ('MANUAL', 'CONTA_PAGAR', 'CONTABIL', 'LANC_ENTRADA', 'CONTA_RECEBER', 'DEBITO', 'CREDITO')))
/

ALTER TABLE DESPESASROP ADD CDAJUSTECT VARCHAR2(04) NULL
/

ALTER TABLE DESPESASROP ADD CDTPCREDDEBBCO VARCHAR2(04) NULL
/

ALTER TABLE RETIRADADRO DROP CONSTRAINT CKC_IDTPLANCROP_RETIRADADRO
/

ALTER TABLE RETIRADADRO ADD CONSTRAINT CKC_IDTPLANCROP_RETIRADADRO CHECK (IDTPLANCROP IN ('RETIRADA_ESTOQ', 'RETIRADA_PLA', 'CUSTO', 'RETNAOCONSOLID', 'RETCONSOLID'))
/

ALTER TABLE LOGOPERAGES MODIFY DSOPERACAO VARCHAR2(4000)
/