Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PDK40001
Product: Project Accounting (258)
Series:
Display Name: PDK Users
Physical Name: PDK40001
Technical Name: PDK_UsersSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 USERID 
User ID String STR15_User_ID 15 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'].USERID2 PASSWORD Password String STR15_LB 15 3 USRCLASS User Class String STR15_User_Class 15 4 CMPNYNAM Company Name String STR64_Company_Name 64 5 CMPANYID Company ID Integer INT5 4 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'].CMPANYID6 EMPLOYID Employee ID String STR15_Employee_ID 15 7 PDK_User_Type PDK User Type Integer PDK_User_Type 0 8 CARDNAME Card Name String STR15_Card_Name 15 9 MANAGER Manager String STR15_Employee_ID 15 10 SUPERVISOR Supervisor String STR30 30 11 MDFRDENT Method For Data Entry Integer GB 0 12 PRTOPRTR Print to Printer Boolean CB_Print_to_Printer 0 13 PRTOSCRN Print to Screen Boolean CB_Print_to_Screen 0 14 Import_Access Import Access Boolean CB_Import_Access 0 15 Modifier_Access Modifier Access Boolean CB_Modifier_Access 0 16 Report_Writer_Access Report Writer Access Boolean CB_Report_Writer_Access. 0 17 Zoom_Fields_Font_Color Zoom Fields Font Color Integer DDL_Font_Color 0 18 Zoom_Fields_Font_Style Zoom Fields Font Style Integer DDL_Zoom_Font_Style 0 19 Editable_Fields_Backgrou Editable Fields Background Color Integer DDL_Background_Color 0 20 Editable_Fields_Font_Col Editable Fields Font Color Integer DDL_Font_Color 0 21 PDK_Edit_Fields_Pattern PDK Editable Fields Pattern Integer DDL_Field_Pattern 0 22 Editable_Fields_Pattern_ Editable Fields Pattern Color Integer DDL_Pattern_Color 0 23 Scrolling_Fields_Backgro Scrolling Fields Background Color Integer DDL_Background_Color 0 24 Scrolling_Fields_Font_Co Scrolling Fields Font Color Integer DDL_Font_Color 0 25 PDK_Scrol_Fields_Pattern PDK Scrolling Fields Pattern Integer DDL_Field_Pattern 0 26 Scrolling_Fields_PatCor Scrolling Fields Pattern Color Integer DDL_Pattern_Color 0 27 Required_Fields_Font_Col Required Fields Font Color Integer DDL_Required_Font_Color 0 28 Required_Fields_Font_Sty Required Fields Font Style Integer DDL_Required_Font_Style 0 29 SHRQFLDS Show Required Fields Boolean CB 0 30 Internet_Browser Internet Browser String STR255 255 31 Internet_Type Internet Type Integer INT 0 32 Internet_Address Internet Address String STR255 255 33 Internet_Address_Name Internet Address Name String STR80 80 34 HSCRLARW Horizontal Scroll Arrows Boolean CB_HZ_Scroll_Switch 0 35 PAfileemplreim PA Files Empl Expense Boolean PA_CB_Files_Empl_Expense 0 36 PAALLWCHGBLLTYPEEE PA Allow Change in Bill Type - EE Boolean PA_CB_Allow_Change_Billing_Type 0 37 PAALLWCHGBLLTYPETS PA Allow Change in Bill Type - TS Boolean PA_CB_Allow_Change_Billing_Type 0 38 PAALLDEEEEv20 PA Allow Description Entry - EE Boolean PA_CB_Allow_Description_Entry 0 39 PAADETSv20 PA Allow Description Entry - TS Boolean PA_CB_Allow_Description_Entry 0 40 PAAllowChangeDepartment PA Allow Change Department Boolean PA_CB_Allow_CHG_Department 0 41 PAChangeJobTitle PA Allow Change Job Title Boolean PA_CB_Allow_CHG_Job_Title 0 42 PAAllow_ChangePaycode PA Allow Change Paycode Boolean PA_CB_Allow_CHG_PayCode 0 43 PDK_Administrator_EE PDK Administrator EE Boolean PDK_CB_Administrator_EE 0 44 PDK_Administrator_TS PDK Administrator TS Boolean PDK_CB_Administrator_TS 0 45 PDK_Mgr_Approve_TS PDK Mgr Approve TS Boolean PDK_CB_Mgr_Approve_TS 0 46 PDK_Mgr_Approve_EE PDK Mgr Approve EE Boolean PDK_CB_Mgr_Approve_EE 0 47 PDK_Sup_Approve_TS PDK Sup Approve TS Boolean PDK_CB_Sup_Approve_TS 0 48 PDK_Sup_Approve_EE PDK Sup Approve EE Boolean PDK_CB_Sup_Approve_EE 0 49 PDK_EitherOr_OK_EE PDK Either/Or OK EE Boolean PDK_CB_Either_Or_OK 0 50 PDK_EitherOr_OK_TS PDK Either/Or OK TS Boolean PDK_CB_Either_Or_OK 0 51 PDKBATCHTS PDK_Batch_Prefix_TS String STR9_Batch_Prefix 9 52 PDKBATCHEE PDK_Batch_Prefix_EE String STR9_Batch_Prefix 9 53 PAAssign_LookupTS PA Assign Lookup - TS Boolean PA_CB_Use_Assign_Lookup 0 54 PAAssign_LookupEE PA Assign Lookup - EE Boolean PA_CB_Use_Assign_Lookup 0 55 PDK_MC_Synchronize PDK MC Synchronize Integer INT2_U0 2 56 PDKTimesheetEntryForm PDK Timesheet Entry Form Integer GB 0 57 PAExpenseType PA Expense Type Integer PA_DDL_Expense_Type 0 58 PAPaymentMethod PA Payment Method Integer PA_DDL_Payment_Method 0 59 UseEETemplate UseEETemplate Boolean CB 0 60 UseTSTemplate UseTSTemplate Boolean CB 0 61 AutoFillTS AutoFillTS Boolean CB 0 62 AutoFillEE AutoFillEE Boolean CB 0 63 PALLWNONEPROJTS PA Allow Entry of None Project - TS Boolean PA_CB_Allow_Entry_None_Project 0 64 PALLOWNONEPROJEE PA Allow Entry of None Project - EE Boolean PA_CB_Allow_Entry_None_Project 0 65 PAAllowEditsTS PA Allow Edits - TS Boolean PA_CB_Allow_Edits_TS 0 66 PAAllowEditsEE PA Allow Edits - EE Boolean PA_CB_Allow_Edits_EE 0 67 PAAllowAddsTS PA Allow Adds - TS Boolean PA_CB_Allow_Adds_TS 0 68 PAAllowAddsEE PA Allow Adds - EE Boolean PA_CB_Allow_Adds_EE 0