SY01400 - Users Master
Dynamics GP table SY01400 (Users Master) contains 45 columns including USERID, USERNAME, Zoom_Fields_Font_Color....
SQL Query Builder
45 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| USERID | User ID | String | 16 | ||
| USERNAME | User Name | String | 32 | ||
| Zoom_Fields_Font_Color | Zoom Fields Font Color | Integer | 2 | ||
| Zoom_Fields_Font_Style | Zoom Fields Font Style | Integer | 2 | ||
| Editable_Fields_Backgrou | Editable Fields Background Color | Integer | 2 | ||
| Editable_Fields_Font_Col | Editable Fields Font Color | Integer | 2 | ||
| Editable_Fields_Pattern | Editable Fields Pattern | Integer | 2 | ||
| Editable_Fields_Pattern_ | Editable Fields Pattern Color | Integer | 2 | ||
| Scrolling_Fields_Backgro | Scrolling Fields Background Color | Integer | 2 | ||
| Scrolling_Fields_Font_Co | Scrolling Fields Font Color | Integer | 2 | ||
| Scrolling_Fields_Pattern | Scrolling Fields Pattern | Integer | 2 | ||
| Scrolling_Fields_PatCor | Scrolling Fields Pattern Color | Integer | 2 | ||
| Required_Fields_Font_Col | Required Fields Font Color | Integer | 2 | ||
| Required_Fields_Font_Sty | Required Fields Font Style | Integer | 2 | ||
| Internet_Browser | Internet Browser | String | 256 | ||
| Internet_Address | Internet Address | String | 256 | ||
| Internet_Type | Internet Type | Integer | 2 | ||
| Internet_Address_Name | Internet Address Name | String | 82 | ||
| PASSWORD | Password | String | 16 | ||
| USRCLASS | User Class | String | 16 | ||
| MDFRDENT | Method For Data Entry | Integer | 2 | ||
| MODIFDT | Modified Date | Date | 4 | ||
| CREATDDT | Created Date | Date | 4 | ||
| LSTUSRED | Last User to Edit | String | 16 | ||
| PRTOSCRN | Print to Screen | Boolean | 2 | ||
| PRTOPRTR | Print to Printer | Boolean | 2 | ||
| SHRQFLDS | Show Required Fields | Boolean | 2 | ||
| DISTPROC | Distributed Processes | Integer | 2 | ||
| HSCRLARW | Horizontal Scroll Arrows | Boolean | 2 | ||
| SOPTYPE | SOP Type1 = Quote2 = Order3 = Invoice4 = Return5 = Back Order6 = Fulfillment Order (In SBF, this value is not available.) | Integer | 2 | ||
SOP Document Type values (6) 1 = Quote2 = Order3 = Invoice4 = Return5 = Back Order6 = Fulfillment Order | |||||
| RELID | RelationID | Long Integer | 4 | ||
| SECACCS | Security Access | Long Integer | 4 | ||
| TODOOPEN | To Do Open | Boolean | 2 | ||
| TODOPERSOPEN | To Do Personal Open | Boolean | 2 | ||
| TODOPERSROLL | To Do Personal Roll | Boolean | 2 | ||
| PALETTETYPE | Palette Type | Integer | 2 | ||
| ORGANIZATIONALVIEW | Organizational View | Integer | 2 | ||
| ACCOUNTINGVIEW | Accounting View | Boolean | 2 | ||
| USERLANG | User Language ID | Integer | 2 | ||
| UserRole | UserRole | Integer | 2 | ||
| UserType | UserType | Integer | 2 | ||
| UserStatus | UserStatus | Integer | 2 | ||
| DateInactivated | DateInactivated | Date | 4 | ||
| Last_EWS_User_Name | Last EWS User Name | String | 238 | ||
| Last_EWS_Email_Address | Last EWS Email Address | String | 238 | ||
Related Tables
Tables that share columns with SY01400. Click "Join" to add to your query.