ALTER TABLE LANCROPFILIAL DROP CONSTRAINT CKC_IDTPLANCROP
/
ALTER TABLE LANCROPFILIAL ADD CONSTRAINT CKC_IDTPLANCROP_LANCROPFILIAL CHECK (IDTPLANCROP IN ('FS','FE','CC','CS','DE','DD','DM','CD','II','IF','IM','ES','AJ','RE','RP','CP','RA','PP','CM','PV','PQ','FF','C1','C2','I1','I2','IP','A1','R1','R2','SG','S1','S2','RT','SS','SC','FN','M1','CO', 'EP','FD', 'IV', 'DC', 'DB', 'MR','BP','VN'))
/
ALTER TABLE ETLDRO ADD (
  VRVOLUMENEGOCIOETLDRO DOUBLE PRECISION DEFAULT NULL NULL, 
  VRTXADMNF DOUBLE PRECISION DEFAULT NULL NULL, 
  VRTXADMMED DOUBLE PRECISION DEFAULT NULL NULL, 
  VRTXADMORCADO DOUBLE PRECISION DEFAULT NULL NULL, 
  NRDIAUTIL NUMBER(10) DEFAULT NULL NULL, 
  NRDIAREALIZADO NUMBER(10) DEFAULT NULL NULL
)
/
ALTER TABLE ETLDRODADOSAGRU ADD (
  VRENTRADACOMPRAS DOUBLE PRECISION DEFAULT NULL NULL, 
  VROUTRASENTRADAS DOUBLE PRECISION DEFAULT NULL NULL, 
  VRSAIDADEVOLUCAO DOUBLE PRECISION DEFAULT NULL NULL, 
  VROUTRASSAIDAS DOUBLE PRECISION DEFAULT NULL NULL, 
  VRPERENTRCOMPMED DOUBLE PRECISION DEFAULT NULL NULL, 
  VRPERENTRCOMPNF DOUBLE PRECISION DEFAULT NULL NULL, 
  VRPEROUTENTRMED DOUBLE PRECISION DEFAULT NULL NULL, 
  VRPEROUTENTRNF DOUBLE PRECISION DEFAULT NULL NULL
)