ALTER TABLE ITRETROBILL ADD (
  QTSERVICOFAT DOUBLE PRECISION NOT NULL, 
  QTSERVICOSBYUT DOUBLE PRECISION NOT NULL, 
  VRPRECOANT DOUBLE PRECISION NOT NULL, 
  VRPRECOATU DOUBLE PRECISION NOT NULL, 
  QTSERVICOSBYNUT DOUBLE PRECISION NOT NULL, 
  VRTOTSBYNUTANT DOUBLE PRECISION NOT NULL, 
  VRTOTSBYNUTATU DOUBLE PRECISION NOT NULL, 
  VRDESCCONDANT DOUBLE PRECISION NOT NULL, 
  VRDESCCONDATU DOUBLE PRECISION NOT NULL, 
  VRDESCFIXOANT DOUBLE PRECISION NOT NULL, 
  VRDESCFIXOATU DOUBLE PRECISION DEFAULT NULL NULL, 
  VRDESCDESVANT DOUBLE PRECISION DEFAULT NULL NULL, 
  VRDESCDESVATU DOUBLE PRECISION DEFAULT NULL NULL
)
/
CREATE INDEX COC00624_FK ON ITRETROBILL(CDFILIAL, CDCIA, NRSERVICOCIAFILI, CDCLASSE, CDCICLO, NRDELIVERY, NRORG)