Security Tasks Master (SY09000)

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

Product: Microsoft Dynamics GP (0)
Series: System

Display Name: Security Tasks Master
Physical Name: SY09000
Technical Name: sySecurityMSTRTask

Group Display Name: Security Setup
Group Technical Name: Security Setup

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1SECURITYTASKID SearchSecurity Task IDSecurityIDString25
2SECURITYTASKNAME SearchSecurity Task NameSTR50String50
3SECURITYTASKDESC SearchSecurity Task DescriptionSTR255String255
4SECURITYTASKCATEGORY SearchSecurity Task CategorySecurity Task CategoryInteger0
5DEFSECTASK SearchDefault Security TaskCBBoolean0
6CRUSRID SearchCreated User IDSTR15_User_IDString15
7CREATDDT SearchCreated DateDTDate8
8MDFUSRID SearchModified User IDSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Security Tasks Master'].MDFUSRID AS 'Security Tasks Master-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SY09000 AS ['Security Tasks Master']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Security Tasks Master'].MDFUSRID = ['Users Master'].USERID
9MODIFDT SearchModified DateDTDate8
10DEX_ROW_ID Searchintint10

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 *