modify for charge
fix for db_query usage
update for db_query
add transno field