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:

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 TypeLength
1Field_Security_ID SearchField Security IDStringSTR15_LBAU15
2Field_Security_Descripti SearchField Security DescriptionStringSTR3030
3WDC_Dict SearchWDC DictIntegerINT0
4WDC_Form SearchWDC FormStringSTR8080
5WDC_Window SearchWDC WindowStringSTR8080
6WDC_Field SearchWDC FieldStringSTR9292
7WDC_Table SearchWDC TableStringSTR8080
8WDC_Dictionary_Sort SearchWDC Dictionary SortStringSTR240240
9WDC_Security_Mode SearchWDC Security ModeIntegerDDL_WDC_Security_Mode0
10Password_ID SearchPassword IDStringSTR15_LBAU15
11WDC_Conditional SearchWDC ConditionalBooleanCB0
12WDC_Script_Dict SearchWDC Script DictIntegerINT0
13SEQNUMBR SearchSequence NumberLong IntegerLI_Sequence_Number10
14NOTEINDX SearchNote IndexCurrencyDLR1414
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 DateDateDT8
16MODIFDT SearchModified DateDateDT8
17LSTUSRED SearchLast User to EditStringSTR1515
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 ScriptTextTX3200032000
azurecurveProductsAdvanced Security (3104)SystemField Level Security Master (WDC41300)

Leave a Reply

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