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 TypeSQL DB LengthKeyable Length
1USERID SearchUser IDSTR15_User_IDString1615
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_LBString1615
3USRCLASS SearchUser ClassSTR15_User_ClassString1615
4CMPNYNAM SearchCompany NameSTR64_Company_NameString6664
5CMPANYID SearchCompany IDINT5Integer24
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_IDString1615
7PDK_User_Type SearchPDK User TypePDK_User_TypeInteger20
8CARDNAME SearchCard NameSTR15_Card_NameString1615
9MANAGER SearchManagerSTR15_Employee_IDString1615
10SUPERVISOR SearchSupervisorSTR30String3230
11MDFRDENT SearchMethod For Data EntryGBInteger20
12PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean20
13PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean20
14Import_Access SearchImport AccessCB_Import_AccessBoolean20
15Modifier_Access SearchModifier AccessCB_Modifier_AccessBoolean20
16Report_Writer_Access SearchReport Writer AccessCB_Report_Writer_Access.Boolean20
17Zoom_Fields_Font_Color SearchZoom Fields Font ColorDDL_Font_ColorInteger20
18Zoom_Fields_Font_Style SearchZoom Fields Font StyleDDL_Zoom_Font_StyleInteger20
19Editable_Fields_Backgrou SearchEditable Fields Background ColorDDL_Background_ColorInteger20
20Editable_Fields_Font_Col SearchEditable Fields Font ColorDDL_Font_ColorInteger20
21PDK_Edit_Fields_Pattern SearchPDK Editable Fields PatternDDL_Field_PatternInteger20
22Editable_Fields_Pattern_ SearchEditable Fields Pattern ColorDDL_Pattern_ColorInteger20
23Scrolling_Fields_Backgro SearchScrolling Fields Background ColorDDL_Background_ColorInteger20
24Scrolling_Fields_Font_Co SearchScrolling Fields Font ColorDDL_Font_ColorInteger20
25PDK_Scrol_Fields_Pattern SearchPDK Scrolling Fields PatternDDL_Field_PatternInteger20
26Scrolling_Fields_PatCor SearchScrolling Fields Pattern ColorDDL_Pattern_ColorInteger20
27Required_Fields_Font_Col SearchRequired Fields Font ColorDDL_Required_Font_ColorInteger20
28Required_Fields_Font_Sty SearchRequired Fields Font StyleDDL_Required_Font_StyleInteger20
29SHRQFLDS SearchShow Required FieldsCBBoolean20
30Internet_Browser SearchInternet BrowserSTR255String256255
31Internet_Type SearchInternet TypeINTInteger20
32Internet_Address SearchInternet AddressSTR255String256255
33Internet_Address_Name SearchInternet Address NameSTR80String8280
34HSCRLARW SearchHorizontal Scroll ArrowsCB_HZ_Scroll_SwitchBoolean20
35PAfileemplreim SearchPA Files Empl ExpensePA_CB_Files_Empl_ExpenseBoolean20
36PAALLWCHGBLLTYPEEE SearchPA Allow Change in Bill Type - EEPA_CB_Allow_Change_Billing_TypeBoolean20
37PAALLWCHGBLLTYPETS SearchPA Allow Change in Bill Type - TSPA_CB_Allow_Change_Billing_TypeBoolean20
38PAALLDEEEEv20 SearchPA Allow Description Entry - EEPA_CB_Allow_Description_EntryBoolean20
39PAADETSv20 SearchPA Allow Description Entry - TSPA_CB_Allow_Description_EntryBoolean20
40PAAllowChangeDepartment SearchPA Allow Change DepartmentPA_CB_Allow_CHG_DepartmentBoolean20
41PAChangeJobTitle SearchPA Allow Change Job TitlePA_CB_Allow_CHG_Job_TitleBoolean20
42PAAllow_ChangePaycode SearchPA Allow Change PaycodePA_CB_Allow_CHG_PayCodeBoolean20
43PDK_Administrator_EE SearchPDK Administrator EEPDK_CB_Administrator_EEBoolean20
44PDK_Administrator_TS SearchPDK Administrator TSPDK_CB_Administrator_TSBoolean20
45PDK_Mgr_Approve_TS SearchPDK Mgr Approve TSPDK_CB_Mgr_Approve_TSBoolean20
46PDK_Mgr_Approve_EE SearchPDK Mgr Approve EEPDK_CB_Mgr_Approve_EEBoolean20
47PDK_Sup_Approve_TS SearchPDK Sup Approve TSPDK_CB_Sup_Approve_TSBoolean20
48PDK_Sup_Approve_EE SearchPDK Sup Approve EEPDK_CB_Sup_Approve_EEBoolean20
49PDK_EitherOr_OK_EE SearchPDK Either/Or OK EEPDK_CB_Either_Or_OKBoolean20
50PDK_EitherOr_OK_TS SearchPDK Either/Or OK TSPDK_CB_Either_Or_OKBoolean20
51PDKBATCHTS SearchPDK_Batch_Prefix_TSSTR9_Batch_PrefixString109
52PDKBATCHEE SearchPDK_Batch_Prefix_EESTR9_Batch_PrefixString109
53PAAssign_LookupTS SearchPA Assign Lookup - TSPA_CB_Use_Assign_LookupBoolean20
54PAAssign_LookupEE SearchPA Assign Lookup - EEPA_CB_Use_Assign_LookupBoolean20
55PDK_MC_Synchronize SearchPDK MC SynchronizeINT2_U0Integer22
56PDKTimesheetEntryForm SearchPDK Timesheet Entry FormGBInteger20
57PAExpenseType SearchPA Expense TypePA_DDL_Expense_TypeInteger20
58PAPaymentMethod SearchPA Payment MethodPA_DDL_Payment_MethodInteger20
59UseEETemplate SearchUseEETemplateCBBoolean20
60UseTSTemplate SearchUseTSTemplateCBBoolean20
61AutoFillTS SearchAutoFillTSCBBoolean20
62AutoFillEE SearchAutoFillEECBBoolean20
63PALLWNONEPROJTS SearchPA Allow Entry of None Project - TSPA_CB_Allow_Entry_None_ProjectBoolean20
64PALLOWNONEPROJEE SearchPA Allow Entry of None Project - EEPA_CB_Allow_Entry_None_ProjectBoolean20
65PAAllowEditsTS SearchPA Allow Edits - TSPA_CB_Allow_Edits_TSBoolean20
66PAAllowEditsEE SearchPA Allow Edits - EEPA_CB_Allow_Edits_EEBoolean20
67PAAllowAddsTS SearchPA Allow Adds - TSPA_CB_Allow_Adds_TSBoolean20
68PAAllowAddsEE SearchPA Allow Adds - EEPA_CB_Allow_Adds_EEBoolean20
69DEX_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.

Leave a Reply

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