In the wotrans table, the department number appears in the wotr_dept_num column for parts posted by SYSTEM as the rop_user_id. If the user is a person, however, the department number field is blank. I use the data in the SQL table frequently and being able to group or sort transactions by department would be helpful sometimes. For now, I have to manually add in the department numbers to the vehicle transactions and this is time-consuming to say the least.
Thanks for the feedback, Eric. We’ve created an internal issue for this problem and will be working on this over the next few weeks.