consolidated transacted resource table into transactions table