UPDATE TBNFS_PARCELAMENTO A SET A.REPRESENTANTE_COMISSAO = COALESCE(A.REPRESENTANTE_COMISSAO,0.00) WHERE A.REPRESENTANTE_COMISSAO IS NULL^

ALTER TABLE TBNFS_PARCELAMENTO ALTER COLUMN REPRESENTANTE_COMISSAO TYPE NUMERIC(18,5)^

ALTER TABLE TBCOMISSAO ALTER COLUMN PERCENTUAL_ORIGINAL TYPE NUMERIC(18,5)^

ALTER TABLE TBCOMISSAO ALTER COLUMN PERCENTUAL_COMISSAO TYPE NUMERIC(18,5)^

ALTER TABLE TBCOMISSAO ADD OBSERVACAO VARCHAR(500) CHARACTER SET UTF8 COLLATE UTF8 ^
