...is the view code:
select reverseflag, orderno, parentorder, labortime,
case when reverseflag is null then cast(0.0000 as decimal(10,4))
when "reverseflag"=-1 then cast(labortime*-1 as decimal(10,4))
when "reverseflag"=0 then cast(labortime as decimal(10,4))
else 0.0000 end
from...