update clear pending to hide pending, increase trx id to 8 chars