PDK Users (PDK40001)

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

Product: Project Accounting (258)
Series: System

Display Name: PDK Users
Physical Name: PDK40001
Technical Name: PDK_Users

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1USERID SearchUser IDSTR15_User_IDString15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['PDK Users'].USERID AS 'PDK Users-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       PDK40001 AS ['PDK Users']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['PDK Users'].USERID = ['Users Master'].USERID
2PASSWORD SearchPasswordSTR15_LBString15
3USRCLASS SearchUser ClassSTR15_User_ClassString15
4CMPNYNAM SearchCompany NameSTR64_Company_NameString64
5CMPANYID SearchCompany IDINT5Integer4
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['PDK Users'].CMPANYID AS 'PDK Users-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       PDK40001 AS ['PDK Users']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['PDK Users'].CMPANYID = ['Company Master'].CMPANYID
6EMPLOYID SearchEmployee IDSTR15_Employee_IDString15
7PDK_User_Type SearchPDK User TypePDK_User_TypeInteger0
8CARDNAME SearchCard NameSTR15_Card_NameString15
9MANAGER SearchManagerSTR15_Employee_IDString15
10SUPERVISOR SearchSupervisorSTR30String30
11MDFRDENT SearchMethod For Data EntryGBInteger0
12PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean0
13PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean0
14Import_Access SearchImport AccessCB_Import_AccessBoolean0
15Modifier_Access SearchModifier AccessCB_Modifier_AccessBoolean0
16Report_Writer_Access SearchReport Writer AccessCB_Report_Writer_Access.Boolean0
17Zoom_Fields_Font_Color SearchZoom Fields Font ColorDDL_Font_ColorInteger0
18Zoom_Fields_Font_Style SearchZoom Fields Font StyleDDL_Zoom_Font_StyleInteger0
19Editable_Fields_Backgrou SearchEditable Fields Background ColorDDL_Background_ColorInteger0
20Editable_Fields_Font_Col SearchEditable Fields Font ColorDDL_Font_ColorInteger0
21PDK_Edit_Fields_Pattern SearchPDK Editable Fields PatternDDL_Field_PatternInteger0
22Editable_Fields_Pattern_ SearchEditable Fields Pattern ColorDDL_Pattern_ColorInteger0
23Scrolling_Fields_Backgro SearchScrolling Fields Background ColorDDL_Background_ColorInteger0
24Scrolling_Fields_Font_Co SearchScrolling Fields Font ColorDDL_Font_ColorInteger0
25PDK_Scrol_Fields_Pattern SearchPDK Scrolling Fields PatternDDL_Field_PatternInteger0
26Scrolling_Fields_PatCor SearchScrolling Fields Pattern ColorDDL_Pattern_ColorInteger0
27Required_Fields_Font_Col SearchRequired Fields Font ColorDDL_Required_Font_ColorInteger0
28Required_Fields_Font_Sty SearchRequired Fields Font StyleDDL_Required_Font_StyleInteger0
29SHRQFLDS SearchShow Required FieldsCBBoolean0
30Internet_Browser SearchInternet BrowserSTR255String255
31Internet_Type SearchInternet TypeINTInteger0
32Internet_Address SearchInternet AddressSTR255String255
33Internet_Address_Name SearchInternet Address NameSTR80String80
34HSCRLARW SearchHorizontal Scroll ArrowsCB_HZ_Scroll_SwitchBoolean0
35PAfileemplreim SearchPA Files Empl ExpensePA_CB_Files_Empl_ExpenseBoolean0
36PAALLWCHGBLLTYPEEE SearchPA Allow Change in Bill Type - EEPA_CB_Allow_Change_Billing_TypeBoolean0
37PAALLWCHGBLLTYPETS SearchPA Allow Change in Bill Type - TSPA_CB_Allow_Change_Billing_TypeBoolean0
38PAALLDEEEEv20 SearchPA Allow Description Entry - EEPA_CB_Allow_Description_EntryBoolean0
39PAADETSv20 SearchPA Allow Description Entry - TSPA_CB_Allow_Description_EntryBoolean0
40PAAllowChangeDepartment SearchPA Allow Change DepartmentPA_CB_Allow_CHG_DepartmentBoolean0
41PAChangeJobTitle SearchPA Allow Change Job TitlePA_CB_Allow_CHG_Job_TitleBoolean0
42PAAllow_ChangePaycode SearchPA Allow Change PaycodePA_CB_Allow_CHG_PayCodeBoolean0
43PDK_Administrator_EE SearchPDK Administrator EEPDK_CB_Administrator_EEBoolean0
44PDK_Administrator_TS SearchPDK Administrator TSPDK_CB_Administrator_TSBoolean0
45PDK_Mgr_Approve_TS SearchPDK Mgr Approve TSPDK_CB_Mgr_Approve_TSBoolean0
46PDK_Mgr_Approve_EE SearchPDK Mgr Approve EEPDK_CB_Mgr_Approve_EEBoolean0
47PDK_Sup_Approve_TS SearchPDK Sup Approve TSPDK_CB_Sup_Approve_TSBoolean0
48PDK_Sup_Approve_EE SearchPDK Sup Approve EEPDK_CB_Sup_Approve_EEBoolean0
49PDK_EitherOr_OK_EE SearchPDK Either/Or OK EEPDK_CB_Either_Or_OKBoolean0
50PDK_EitherOr_OK_TS SearchPDK Either/Or OK TSPDK_CB_Either_Or_OKBoolean0
51PDKBATCHTS SearchPDK_Batch_Prefix_TSSTR9_Batch_PrefixString9
52PDKBATCHEE SearchPDK_Batch_Prefix_EESTR9_Batch_PrefixString9
53PAAssign_LookupTS SearchPA Assign Lookup - TSPA_CB_Use_Assign_LookupBoolean0
54PAAssign_LookupEE SearchPA Assign Lookup - EEPA_CB_Use_Assign_LookupBoolean0
55PDK_MC_Synchronize SearchPDK MC SynchronizeINT2_U0Integer2
56PDKTimesheetEntryForm SearchPDK Timesheet Entry FormGBInteger0
57PAExpenseType SearchPA Expense TypePA_DDL_Expense_TypeInteger0
58PAPaymentMethod SearchPA Payment MethodPA_DDL_Payment_MethodInteger0
59UseEETemplate SearchUseEETemplateCBBoolean0
60UseTSTemplate SearchUseTSTemplateCBBoolean0
61AutoFillTS SearchAutoFillTSCBBoolean0
62AutoFillEE SearchAutoFillEECBBoolean0
63PALLWNONEPROJTS SearchPA Allow Entry of None Project - TSPA_CB_Allow_Entry_None_ProjectBoolean0
64PALLOWNONEPROJEE SearchPA Allow Entry of None Project - EEPA_CB_Allow_Entry_None_ProjectBoolean0
65PAAllowEditsTS SearchPA Allow Edits - TSPA_CB_Allow_Edits_TSBoolean0
66PAAllowEditsEE SearchPA Allow Edits - EEPA_CB_Allow_Edits_EEBoolean0
67PAAllowAddsTS SearchPA Allow Adds - TSPA_CB_Allow_Adds_TSBoolean0
68PAAllowAddsEE SearchPA Allow Adds - EEPA_CB_Allow_Adds_EEBoolean0
69DEX_ROW_ID Searchintint10

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.

Leave a Reply

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