SY00801 - Resource Activity

Dynamics GP table SY00801 (Resource Activity) contains 8 columns including RULEID, RSRCID, RSRCSBID....

SQL Query Builder

SELECT * FROM SY00801

Select all

Column	Description	Type	Length	Shared With
RULEID	Rule ID	Integer	2	-
RSRCID	Resource ID	String	32	-
RSRCSBID	Resource SubID	String	22	-
CMPANYID	Company ID	Integer	2	27 tables
USERID	User ID	String	16	80 tables
RSCSTATE	Resource State	Integer	2	-
RSRDESC	Resource Description	String	22	-
USECT	Usage Count	Integer	2	-

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

USERID