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 TypeSQL DB LengthKeyable Length
1SECURITYTASKID SearchSecurity Task IDSecurityIDString2625
2SECURITYTASKNAME SearchSecurity Task NameSTR50String5250
3SECURITYTASKDESC SearchSecurity Task DescriptionSTR255String256255
4SECURITYTASKCATEGORY SearchSecurity Task CategorySecurity Task CategoryInteger20
5DEFSECTASK SearchDefault Security TaskCBBoolean20
6CRUSRID SearchCreated User IDSTR15_User_IDString1615
7CREATDDT SearchCreated DateDTDate48
8MDFUSRID SearchModified User IDSTR15String1615
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 DateDTDate48
10DEX_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 *