Staying with rate table and transaction table. Need to figure out whether to do a scheduled task or a trigger.