Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/WDC41300
Product: Advanced Security (3104)
Series:
Display Name: Field Level Security Master Group Display Name: Field Security Table Group
Physical Name: WDC41300
Technical Name: WDC_Field_Security_MSTR
Group Technical Name: WDC Field Security
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | Field_Security_ID  | Field Security ID | String | STR15_LBAU | 15 | |
| 2 | Field_Security_Descripti | Field Security Description | String | STR30 | 30 | |
| 3 | WDC_Dict | WDC Dict | Integer | INT | 0 | |
| 4 | WDC_Form | WDC Form | String | STR80 | 80 | |
| 5 | WDC_Window | WDC Window | String | STR80 | 80 | |
| 6 | WDC_Field | WDC Field | String | STR92 | 92 | |
| 7 | WDC_Table | WDC Table | String | STR80 | 80 | |
| 8 | WDC_Dictionary_Sort | WDC Dictionary Sort | String | STR240 | 240 | |
| 9 | WDC_Security_Mode | WDC Security Mode | Integer | DDL_WDC_Security_Mode | 0 | |
| 10 | Password_ID | Password ID | String | STR15_LBAU | 15 | |
| 11 | WDC_Conditional | WDC Conditional | Boolean | CB | 0 | |
| 12 | WDC_Script_Dict | WDC Script Dict | Integer | INT | 0 | |
| 13 | SEQNUMBR | Sequence Number | Long Integer | LI_Sequence_Number | 10 | |
| 14 | NOTEINDX | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['Field Level Security Master'].NOTEINDX AS 'Field Level Security Master-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
WDC41300 AS ['Field Level Security Master']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Field Level Security Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||
| 15 | CREATDDT | Created Date | Date | DT | 8 | |
| 16 | MODIFDT | Modified Date | Date | DT | 8 | |
| 17 | LSTUSRED | Last User to Edit | String | STR15 | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['Field Level Security Master'].LSTUSRED AS 'Field Level Security Master-Last User to Edit'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
WDC41300 AS ['Field Level Security Master']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Field Level Security Master'].LSTUSRED = ['Users Master'].USERID | ||||||
| 18 | WDC_Script | WDC Script | Text | TX32000 | 32000 | |