Resource Activity (SY00801)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SY00801

Product: Microsoft Dynamics GP (0)
Series: System

Display Name: Resource Activity
Physical Name: SY00801
Technical Name: SY_ResourceActivity

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1RULEID SearchRule IDINT4Integer24
2RSRCID SearchResource IDSTR30String3230
3RSRCSBID SearchResource SubIDSTR20String2220
4CMPANYID SearchCompany IDINT5Integer24
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['Resource Activity'].CMPANYID AS 'Resource Activity-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       SY00801 AS ['Resource Activity']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['Resource Activity'].CMPANYID = ['Company Master'].CMPANYID
5USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Resource Activity'].USERID AS 'Resource Activity-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SY00801 AS ['Resource Activity']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Resource Activity'].USERID = ['Users Master'].USERID
6RSCSTATE SearchResource StateINT4Integer24
7RSRDESC SearchResource DescriptionSTR20String2220
8USECT SearchUsage CountINT5Integer24
9DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

Your email address will not be published. Required fields are marked *