Security Roles Master (SY09100)

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

Product: Microsoft Dynamics GP (0)
Series: System

Display Name: Security Roles Master
Physical Name: SY09100
Technical Name: sySecurityMSTRRole

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1SECURITYROLEID SearchSecurity Role IDSecurityIDString2625
2SECURITYROLENAME SearchSecurity Role NameSTR50String5250
3SECURITYROLEDESC SearchSecurity Role DescriptionSTR255String256255
4SECROLETYPE SearchSecurity Role TypeSecurity Role TypeInteger20
5CRUSRID SearchCreated User IDSTR15_User_IDString1615
6CREATDDT SearchCreated DateDTDate48
7MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Security Roles Master'].MDFUSRID AS 'Security Roles Master-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SY09100 AS ['Security Roles Master']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Security Roles Master'].MDFUSRID = ['Users Master'].USERID
8MODIFDT SearchModified DateDTDate48
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 *