Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/WDC41101
Product: Advanced Security (3104)
Series: System
Display Name: Advanced Security Setup Group Display Name: Advanced Security Table Group
Physical Name: WDC41101
Technical Name: WDC_Security_SETP
Group Technical Name: WDC Security
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | SQL DB Length | Keyable Length |
---|---|---|---|---|---|---|
1 | DUMYRCRD ![]() | Dummy Record | Boolean | Boolean | 2 | 0 |
2 | WDC_Security_Checkbox_1 ![]() | WDC Security Checkbox[1] | CB | Boolean | 2 | 0 |
3 | WDC_Security_Checkbox ![]() | WDC Security Checkbox | CB | Boolean | 2 | 0 |
4 | WDC_Security_Checkbox_2 ![]() | WDC Security Checkbox[2] | CB | Boolean | 2 | 0 |
5 | DTAPTHNM ![]() | Data Pathname | Pathname | String | 256 | 255 |
6 | USERID ![]() | User ID | STR15_User_ID | String | 16 | 15 |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['Advanced Security Setup'].USERID AS 'Advanced Security Setup-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
WDC41101 AS ['Advanced Security Setup']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Advanced Security Setup'].USERID = ['Users Master'].USERID | ||||||
7 | WDC_Security_Checkbox_3 ![]() | WDC Security Checkbox[3] | CB | Boolean | 2 | 0 |
8 | CMPANYID ![]() | Company ID | INT5 | Integer | 2 | 4 |
Key to the Company Master (SY01500).
Click to show/hideSELECT
['Advanced Security Setup'].CMPANYID AS 'Advanced Security Setup-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
WDC41101 AS ['Advanced Security Setup']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['Advanced Security Setup'].CMPANYID = ['Company Master'].CMPANYID | ||||||
9 | WDC_Security_Checkbox_4 ![]() | WDC Security Checkbox[4] | CB | Boolean | 2 | 0 |
10 | MESSAGE ![]() | Message | STR50 | String | 52 | 50 |
11 | WDC_Security_Checkbox_5 ![]() | WDC Security Checkbox[5] | CB | Boolean | 2 | 0 |
12 | WDC_Security_Checkbox_6 ![]() | WDC Security Checkbox[6] | CB | Boolean | 2 | 0 |
13 | CREATDDT ![]() | Created Date | DT | Date | 4 | 8 |
14 | WDC_Security_Checkbox_7 ![]() | WDC Security Checkbox[7] | CB | Boolean | 2 | 0 |
15 | MODIFDT ![]() | Modified Date | DT | Date | 4 | 8 |
16 | WDC_Security_Checkbox_8 ![]() | WDC Security Checkbox[8] | CB | Boolean | 2 | 0 |
17 | LSTUSRED ![]() | Last User to Edit | STR15 | String | 16 | 15 |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['Advanced Security Setup'].LSTUSRED AS 'Advanced Security Setup-Last User to Edit'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
WDC41101 AS ['Advanced Security Setup']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Advanced Security Setup'].LSTUSRED = ['Users Master'].USERID | ||||||
18 | WDC_Security_Checkbox_9 ![]() | WDC Security Checkbox[9] | CB | Boolean | 2 | 0 |
19 | WDC_Security_Checkbox_10 ![]() | WDC Security Checkbox[10] | CB | Boolean | 2 | 0 |
20 | WDC_Security_Checkbox_11 ![]() | WDC Security Checkbox[11] | CB | Boolean | 2 | 0 |
21 | WDC_Security_Checkbox_12 ![]() | WDC Security Checkbox[12] | CB | Boolean | 2 | 0 |
22 | WDC_Security_Checkbox_13 ![]() | WDC Security Checkbox[13] | CB | Boolean | 2 | 0 |
23 | WDC_Security_Checkbox_14 ![]() | WDC Security Checkbox[14] | CB | Boolean | 2 | 0 |
24 | WDC_Security_Checkbox_15 ![]() | WDC Security Checkbox[15] | CB | Boolean | 2 | 0 |
25 | WDC_Security_Checkbox_16 ![]() | WDC Security Checkbox[16] | CB | Boolean | 2 | 0 |
26 | WDC_Security_Checkbox_17 ![]() | WDC Security Checkbox[17] | CB | Boolean | 2 | 0 |
27 | WDC_Security_Checkbox_18 ![]() | WDC Security Checkbox[18] | CB | Boolean | 2 | 0 |
28 | WDC_Security_Checkbox_19 ![]() | WDC Security Checkbox[19] | CB | Boolean | 2 | 0 |
29 | WDC_Security_Checkbox_20 ![]() | WDC Security Checkbox[20] | CB | Boolean | 2 | 0 |
30 | WDC_Security_Checkbox_21 ![]() | WDC Security Checkbox[21] | CB | Boolean | 2 | 0 |
31 | WDC_Security_Checkbox_22 ![]() | WDC Security Checkbox[22] | CB | Boolean | 2 | 0 |
32 | WDC_Security_Checkbox_23 ![]() | WDC Security Checkbox[23] | CB | Boolean | 2 | 0 |
33 | WDC_Security_Checkbox_24 ![]() | WDC Security Checkbox[24] | CB | Boolean | 2 | 0 |
34 | WDC_Security_Checkbox_25 ![]() | WDC Security Checkbox[25] | CB | Boolean | 2 | 0 |
35 | WDC_Security_Checkbox_26 ![]() | WDC Security Checkbox[26] | CB | Boolean | 2 | 0 |
36 | WDC_Security_Checkbox_27 ![]() | WDC Security Checkbox[27] | CB | Boolean | 2 | 0 |
37 | WDC_Security_Checkbox_28 ![]() | WDC Security Checkbox[28] | CB | Boolean | 2 | 0 |
38 | WDC_Security_Checkbox_29 ![]() | WDC Security Checkbox[29] | CB | Boolean | 2 | 0 |
39 | WDC_Security_Checkbox_30 ![]() | WDC Security Checkbox[30] | CB | Boolean | 2 | 0 |
40 | DEX_ROW_ID ![]() | int | int | 10 | 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. |