Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SY01406
Product: Microsoft Dynamics GP (0)
Series: System
Display Name: Users Master Staging Group Display Name: Users Master
Physical Name: SY01406
Technical Name: SY_User_MSTR_Staging
Group Technical Name: Users Master
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | USERID  | User ID | String | STR15_User_ID | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['Users Master Staging'].USERID AS 'Users Master Staging-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SY01406 AS ['Users Master Staging']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Users Master Staging'].USERID = ['Users Master'].USERID | ||||||
| 2 | USERNAME | User Name | String | STR30 | 30 | |
| 3 | PASSWORD | Password | String | STR15_LB | 15 | |
| 4 | USRCLASS | User Class | String | STR15_User_Class | 15 | |
| 5 | ORGANIZATIONALVIEW | Organizational View | Integer | GB | 0 | |
| 6 | ACCOUNTINGVIEW | Accounting View | Boolean | CB_AccountingView | 0 | |
| 7 | UserType | UserType | Integer | UserTypeDDL | 0 | |
| 8 | UserStatus | UserStatus | Integer | UserStatusDDL | 0 | |
| 9 | WCUser | Web Client User | Boolean | CB | 0 | |
| 10 | ADObjectGuid | ADObjectGuid | String | GUIDString | 36 | |
| 11 | SQLLoginID | SQLLoginID | String | User_ID | 15 | |
| 12 | User_Role | User Role | Integer | INT | 0 | |