Security Roles Master (SY09100)

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

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

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

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	SECURITYROLEID	Security Role ID	String	SecurityID	25
2	SECURITYROLENAME	Security Role Name	String	STR50	50
3	SECURITYROLEDESC	Security Role Description	String	STR255	255
4	SECROLETYPE	Security Role Type	Integer	Security Role Type	0
5	CRUSRID	Created User ID	String	STR15_User_ID	15
6	CREATDDT	Created Date	Date	DT	8
7	MDFUSRID	Modified User ID	String	STR15	15
	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
8	MODIFDT	Modified Date	Date	DT	8
9	Workflow_Status	Workflow Status	Integer	Workflow Status	0
10	SecurityRoleNameModified	Security Role Name Modified	String	STR50	50
11	SecurityRoleDescModified	Security Role Description Modified	String	STR255	255
12	WorkflowOriginCompany	Workflow Origin Company	String	STR5_IC_ID	5