ALTER TABLE ITEMPROIMPOS ADD CDFILIALICMS60 VARCHAR2(04) NULL
/
 
ALTER TABLE ITEMPROIMPOS ADD NRLANCTONFICMS60 VARCHAR2(10) NULL
/
 
ALTER TABLE ITEMPROIMPOS ADD VRBCITENTR FLOAT NULL
/

ALTER TABLE ITEMPROIMPOS ADD VRIMPITENTR FLOAT NULL
/

ALTER TABLE ITEMPROIMPOS ADD VRBCITENTRFECP FLOAT NULL  
/

ALTER TABLE ITEMPROIMPOS ADD VRIMPITENTRFECP FLOAT NULL 
/

ALTER TABLE ITEMPROIMPOS ADD VRICMSSUBSTITUTO FLOAT NULL
/
 
ALTER TABLE ITEMPROIMPOS ADD VRALIQCONSFINAL FLOAT NULL
/

CREATE INDEX FIS00758_FK ON ITEMPROIMPOS (CDFILIALICMS60 ASC, NRLANCTONFICMS60 ASC)
/

ALTER TABLE ITEMPROIMPOS
   ADD CONSTRAINT FKFIS00758NOTAFISCAL FOREIGN KEY (CDFILIALICMS60, NRLANCTONFICMS60)
      REFERENCES NOTAFISCAL (CDFILIAL, NRLANCTONF)