Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SY01400
Product: Microsoft Dynamics GP (0)
Series: System
Display Name: Users Master Group Display Name: Users Master
Physical Name: SY01400
Technical Name: SY_Users_MSTR
Group Technical Name: Users Master
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | USERID ![]() | User ID | STR15_User_ID | String | 15 | |
2 | USERNAME ![]() | User Name | STR30 | String | 30 | |
3 | Zoom_Fields_Font_Color ![]() | Zoom Fields Font Color | DDL_Font_Color | Integer | 0 | |
4 | Zoom_Fields_Font_Style ![]() | Zoom Fields Font Style | DDL_Zoom_Font_Style | Integer | 0 | |
5 | Editable_Fields_Backgrou ![]() | Editable Fields Background Color | DDL_Background_Color | Integer | 0 | |
6 | Editable_Fields_Font_Col ![]() | Editable Fields Font Color | DDL_Font_Color | Integer | 0 | |
7 | Editable_Fields_Pattern ![]() | Editable Fields Pattern | DDL_Field_Pattern | Integer | 0 | |
8 | Editable_Fields_Pattern_ ![]() | Editable Fields Pattern Color | DDL_Pattern_Color | Integer | 0 | |
9 | Scrolling_Fields_Backgro ![]() | Scrolling Fields Background Color | DDL_Background_Color | Integer | 0 | |
10 | Scrolling_Fields_Font_Co ![]() | Scrolling Fields Font Color | DDL_Font_Color | Integer | 0 | |
11 | Scrolling_Fields_Pattern ![]() | Scrolling Fields Pattern | DDL_Field_Pattern | Integer | 0 | |
12 | Scrolling_Fields_PatCor ![]() | Scrolling Fields Pattern Color | DDL_Pattern_Color | Integer | 0 | |
13 | Required_Fields_Font_Col ![]() | Required Fields Font Color | DDL_Required_Font_Color | Integer | 0 | |
14 | Required_Fields_Font_Sty ![]() | Required Fields Font Style | DDL_Required_Font_Style | Integer | 0 | |
15 | Internet_Browser ![]() | Internet Browser | STR255 | String | 255 | |
16 | Internet_Address ![]() | Internet Address | STR255 | String | 255 | |
17 | Internet_Type ![]() | Internet Type | INT | Integer | 0 | |
18 | Internet_Address_Name ![]() | Internet Address Name | STR80 | String | 80 | |
19 | PASSWORD ![]() | Password | STR15_LB | String | 15 | |
20 | USRCLASS ![]() | User Class | STR15_User_Class | String | 15 | |
21 | MDFRDENT ![]() | Method For Data Entry | GB | Integer | 0 | |
22 | MODIFDT ![]() | Modified Date | DT | Date | 8 | |
23 | CREATDDT ![]() | Created Date | DT | Date | 8 | |
24 | LSTUSRED ![]() | Last User to Edit | STR15 | String | 15 | |
25 | PRTOSCRN ![]() | Print to Screen | CB_Print_to_Screen | Boolean | 0 | |
26 | PRTOPRTR ![]() | Print to Printer | CB_Print_to_Printer | Boolean | 0 | |
27 | SHRQFLDS ![]() | Show Required Fields | CB | Boolean | 0 | |
28 | DISTPROC ![]() | Distributed Processes | GB | Integer | 0 | |
29 | HSCRLARW ![]() | Horizontal Scroll Arrows | CB_HZ_Scroll_Switch | Boolean | 0 | |
30 | SOPTYPE ![]() | SOP Type | DDL_SOP_Type | Integer | 0 | |
31 | RELID ![]() | RelationID | Long Int | Long Integer | 8 | |
32 | SECACCS ![]() | Security Access | ML_Security_Access | Long Integer | 0 | |
33 | TODOOPEN ![]() | To Do Open | CB_To_Do_Open | Boolean | 0 | |
34 | TODOPERSOPEN ![]() | To Do Personal Open | CB_To_Do_Personal_Open | Boolean | 0 | |
35 | TODOPERSROLL ![]() | To Do Personal Roll | CB_To_Do_Personal_Roll | Boolean | 0 | |
36 | PALETTETYPE ![]() | Palette Type | GB | Integer | 0 | |
37 | ORGANIZATIONALVIEW ![]() | Organizational View | GB | Integer | 0 | |
38 | ACCOUNTINGVIEW ![]() | Accounting View | CB_AccountingView | Boolean | 0 | |
39 | USERLANG ![]() | User Language ID | INT | Integer | 0 | |
40 | UserRole ![]() | UserRole | DDL_UserRoles | Integer | 0 | |
41 | UserType ![]() | UserType | UserTypeDDL | Integer | 0 | |
42 | UserStatus ![]() | UserStatus | UserStatusDDL | Integer | 0 | |
43 | DateInactivated ![]() | DateInactivated | DATE | Date | 6 | |
44 | Last_EWS_User_Name ![]() | Last EWS User Name | STR238 | String | 0 | |
45 | Last_EWS_Email_Address ![]() | Last EWS Email Address | STR238 | String | 0 | |
46 | WCUser ![]() | Web Client User | CB | Boolean | 0 | |
47 | ADObjectGuid ![]() | ADObjectGuid | GUIDString | String | 36 | |
48 | SQLLoginID ![]() | SQLLoginID | User_ID | String | 15 | |
49 | WindowCommandDisplay ![]() | Window Command Display | DDL_Window_Command_Display | Integer | 0 | |
50 | DEX_ROW_ID ![]() | int | int | 10 | ||
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. |