update column table for transactions