employee's table in great plains 5

[waely]

hi,
does anyone know where I can find the employee's table and their status (active or inactive)in great plains 5 sql?

thanks in advance,
waely

 

[winthropdc]

This would still be in the same table as now.

The UPR_MSTR (UPR00100) table and the Inactive (INACTIVE) field.

David Musgrave [MSFT]
Senior Development Consultant
MBS Services - Asia Pacific

Microsoft Business Solutions

http://www.microsoft.com/BusinessSolutions

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.

 

[waely]

thanks David, but I didn't find all the names. is there another table that might have this data?

thanks