modified id of merchant table to char field