Field Level Security Master (WDC41300)

azurecurveProductsAdvanced Security (3104)SystemField Level Security Master (WDC41300)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/WDC41300

Product: Advanced Security (3104)
Series: System

Display Name: Field Level Security Master
Physical Name: WDC41300
Technical Name: WDC_Field_Security_MSTR

Group Display Name: Field Security Table Group
Group Technical Name: WDC Field Security

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Field_Security_ID SearchField Security IDSTR15_LBAUString1615
2Field_Security_Descripti SearchField Security DescriptionSTR30String3230
3WDC_Dict SearchWDC DictINTInteger20
4WDC_Form SearchWDC FormSTR80String8280
5WDC_Window SearchWDC WindowSTR80String8280
6WDC_Field SearchWDC FieldSTR92String9492
7WDC_Table SearchWDC TableSTR80String8280
8WDC_Dictionary_Sort SearchWDC Dictionary SortSTR240String242240
9WDC_Security_Mode SearchWDC Security ModeDDL_WDC_Security_ModeInteger20
10Password_ID SearchPassword IDSTR15_LBAUString1615
11WDC_Conditional SearchWDC ConditionalCBBoolean20
12WDC_Script_Dict SearchWDC Script DictINTInteger20
13SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer410
14NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['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
15CREATDDT SearchCreated DateDTDate48
16MODIFDT SearchModified DateDTDate48
17LSTUSRED SearchLast User to EditSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['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
18WDC_Script SearchWDC ScriptTX32000Text232000
19DEX_ROW_ID Searchintint1010

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.

azurecurveProductsAdvanced Security (3104)SystemField Level Security Master (WDC41300)

Leave a Reply

Your email address will not be published. Required fields are marked *