ALTER TABLE CODFISCOPERSN ADD VRALIQREDBC FLOAT NULL
/
ALTER TABLE DETALHEAPURSN ADD VRFATUSEMSTRED FLOAT NULL
/

ALTER TABLE DETALHEAPURSN ADD VRIMPSEMSTRED FLOAT NULL
/

ALTER TABLE DETALHEAPURSN ADD VRIMPSEMSTPARC FLOAT NULL
/

ALTER TABLE DETALHEAPURSN ADD VRALIQICMS FLOAT NULL
/

ALTER TABLE DETALHEAPURSN ADD VRCOMPBCSEMSETRED FLOAT NULL
/

ALTER TABLE DETALHEAPURSN ADD VRDEDUZBCSEMSTRED FLOAT NULL
/

UPDATE DETALHEAPURSN 
SET VRIMPSEMSTPARC  = VRIMPOSTOSEMST
WHERE VRIMPSEMSTPARC IS NULL
/

COMMIT
/

ALTER TABLE ITDETALHEAPURSN ADD VRCOMPBCSEMSETRED FLOAT NULL
/

ALTER TABLE ITDETALHEAPURSN ADD VRDEDUZBCSEMSTRED FLOAT NULL
/