More Query scripts, all assignments done

gonna fix my transaction views and make scripts for the rest, then i
think i am pretty much done. just some report stuff to do