ALTER TABLE ITVENDACAN ADD CDFILIALEST VARCHAR2(4) NULL
/
 
ALTER TABLE ITVENDACAN ADD NRLANCESTQ VARCHAR2(10) NULL
/

CREATE INDEX VND00766_FK ON ITVENDACAN (CDFILIALEST ASC, NRLANCESTQ ASC)
/

ALTER TABLE ITVENDACAN
   ADD CONSTRAINT FKVND00766LANCTOEST FOREIGN KEY (CDFILIALEST, NRLANCESTQ)
      REFERENCES LANCTOESTOQ (CDFILIAL, NRLANCESTQ)