WDC51100 - Advanced Security User Lookup

Dynamics GP table WDC51100 (Advanced Security User Lookup) contains 5 columns including WDC_Entity_ID, USRCLASS, CMPANYID....

SQL Query Builder

SELECT * FROM WDC51100

Select all

Column	Description	Type	Length	Shared With
WDC_Entity_ID	WDC Entity ID	Long Integer	4	-
USRCLASS	User Class	String	16	3 tables
CMPANYID	Company ID	Integer	2	27 tables
USERID	User ID	String	16	80 tables
ACTIVE	Active0 = False, for inactive records1 = True, for active records	Boolean	2	3 tables

Tables that share columns with WDC51100. Click "Join" to add to your query.

USERID

USRCLASS

ACTIVE