Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PDK70101
Product: Project Accounting (258)
Series:
Display Name: PDK Report Options
Physical Name: PDK70101
Technical Name: PDK_Options_ROPTSeq 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 Report Options'].USERID AS 'PDK Report Options-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
PDK70101 AS ['PDK Report Options']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['PDK Report Options'].USERID = ['Users Master'].USERID2 PDK_Start_Doc_No PDK Start Doc No String PDK_Document_Number 30 3 PDK_End_Doc_No PDK End Doc No String PDK_Document_Number 30 4 PASTPROJN PA Start Project Number String STR15_LBAU 15 5 PAENPROJN PA End Project Number String STR15_LBAU 15 6 Start_Contract_Number Start Contract Number String STR10_LBAU 10 7 End_Contract_Number End Contract Number String STR10_LBAU 10 8 PAStart_ID_Array_1 PA Start ID Array[1] String STR15 15 9 PAStart_ID_Array_2 PA Start ID Array[2] String STR15 15 10 PAStart_ID_Array_3 PA Start ID Array[3] String STR15 15 11 PAStart_ID_Array_4 PA Start ID Array[4] String STR15 15 12 PAStart_ID_Array_5 PA Start ID Array[5] String STR15 15 13 PAStart_ID_Array_6 PA Start ID Array[6] String STR15 15 14 PAStart_ID_Array_7 PA Start ID Array[7] String STR15 15 15 PAStart_ID_Array_8 PA Start ID Array[8] String STR15 15 16 PAStart_ID_Array_9 PA Start ID Array[9] String STR15 15 17 PAStart_ID_Array_10 PA Start ID Array[10] String STR15 15 18 PAEnd_ID_Array_1 PA End ID Array[1] String STR15 15 19 PAEnd_ID_Array_2 PA End ID Array[2] String STR15 15 20 PAEnd_ID_Array_3 PA End ID Array[3] String STR15 15 21 PAEnd_ID_Array_4 PA End ID Array[4] String STR15 15 22 PAEnd_ID_Array_5 PA End ID Array[5] String STR15 15 23 PAEnd_ID_Array_6 PA End ID Array[6] String STR15 15 24 PAEnd_ID_Array_7 PA End ID Array[7] String STR15 15 25 PAEnd_ID_Array_8 PA End ID Array[8] String STR15 15 26 PAEnd_ID_Array_9 PA End ID Array[9] String STR15 15 27 PAEnd_ID_Array_10 PA End ID Array[10] String STR15 15 28 PAStart_Name_Array_1 PA Start Name Array[1] String STR30 30 29 PAStart_Name_Array_2 PA Start Name Array[2] String STR30 30 30 PAStart_Name_Array_3 PA Start Name Array[3] String STR30 30 31 PAStart_Name_Array_4 PA Start Name Array[4] String STR30 30 32 PAStart_Name_Array_5 PA Start Name Array[5] String STR30 30 33 PAStart_Name_Array_6 PA Start Name Array[6] String STR30 30 34 PAStart_Name_Array_7 PA Start Name Array[7] String STR30 30 35 PAStart_Name_Array_8 PA Start Name Array[8] String STR30 30 36 PAStart_Name_Array_9 PA Start Name Array[9] String STR30 30 37 PAStart_Name_Array_10 PA Start Name Array[10] String STR30 30 38 PAEnd_Name_Array_1 PA End Name Array[1] String STR30 30 39 PAEnd_Name_Array_2 PA End Name Array[2] String STR30 30 40 PAEnd_Name_Array_3 PA End Name Array[3] String STR30 30 41 PAEnd_Name_Array_4 PA End Name Array[4] String STR30 30 42 PAEnd_Name_Array_5 PA End Name Array[5] String STR30 30 43 PAEnd_Name_Array_6 PA End Name Array[6] String STR30 30 44 PAEnd_Name_Array_7 PA End Name Array[7] String STR30 30 45 PAEnd_Name_Array_8 PA End Name Array[8] String STR30 30 46 PAEnd_Name_Array_9 PA End Name Array[9] String STR30 30 47 PAEnd_Name_Array_10 PA End Name Array[10] String STR30 30 48 STDATEIN Start Date Incurred Date DT 8 49 ENDATEIN End Date Incurred Date DATE 6 50 PASTDOCT PA Start Doc Type Integer PA_DDL_Document_Type 0 51 PAENDOCT PA End Doc Type Integer PA_DDL_Document_Type 0 52 IFFILXST If File Existing Integer GB 0 53 FILEXPNM File Export Name String STR255 255 54 EXPTTYPE Export Type Integer INT 0 55 ASKECHTM Ask Each Time Boolean CB_Ask_Each_Time 0 56 PRNTOFIL Print to File Boolean CB_Print_to_File 0 57 PRTOPRTR Print to Printer Boolean CB_Print_to_Printer 0 58 PRTOSCRN Print to Screen Boolean CB_Print_to_Screen 0 59 PRNTTYPE Print Type Integer GB 0 60 RPTGRIND Report Group Index Integer INT 0 61 RTGRSBIN Report Group Sub Index Currency DLR14 14 62 RTPACHIN Report Palette Choice Index Integer INT 0 63 REPORTID Report ID Integer INT_STORAGE 0 64 RPTGRNMS Report Group Names String STR20 20 65 PATU PA Transaction Usage Integer PA_DDL_Transaction_Usage 0 66 STRTNGDT Starting Date Date DT 8 67 ENDINGDT Ending Date Date DT 8 68 STTUDEF1 Start User Defined 1 String STR20 20 69 ENUSRDF1 End User Defined 1 String STR20 20 70 STTDOCDT Start Document Date Date DT 8 71 ENDDOCDT End Document Date Date DT 8 72 STTPSTDT Start Post Date Date DATE 6 73 ENDPSTDT End Post Date Date DATE 6 74 SORTBY Sort By Integer DDL_Sort_By 0 75 PARange_By_Array_1 PA Range By Array[1] Boolean Boolean 0 76 PARange_By_Array_2 PA Range By Array[2] Boolean Boolean 0 77 PARange_By_Array_3 PA Range By Array[3] Boolean Boolean 0 78 PARange_By_Array_4 PA Range By Array[4] Boolean Boolean 0 79 PARange_By_Array_5 PA Range By Array[5] Boolean Boolean 0 80 PARange_By_Array_6 PA Range By Array[6] Boolean Boolean 0 81 PARange_By_Array_7 PA Range By Array[7] Boolean Boolean 0 82 PARange_By_Array_8 PA Range By Array[8] Boolean Boolean 0 83 PARange_By_Array_9 PA Range By Array[9] Boolean Boolean 0 84 PARange_By_Array_10 PA Range By Array[10] Boolean Boolean 0 85 PAExclude_Array_1 PA Exclude Array[1] Boolean Boolean 0 86 PAExclude_Array_2 PA Exclude Array[2] Boolean Boolean 0 87 PAExclude_Array_3 PA Exclude Array[3] Boolean Boolean 0 88 PAExclude_Array_4 PA Exclude Array[4] Boolean Boolean 0 89 PAExclude_Array_5 PA Exclude Array[5] Boolean Boolean 0 90 PAExclude_Array_6 PA Exclude Array[6] Boolean Boolean 0 91 PAExclude_Array_7 PA Exclude Array[7] Boolean Boolean 0 92 PAExclude_Array_8 PA Exclude Array[8] Boolean Boolean 0 93 PAExclude_Array_9 PA Exclude Array[9] Boolean Boolean 0 94 PAExclude_Array_10 PA Exclude Array[10] Boolean Boolean 0 95 RANGEBY Range By Integer INT 0 96 PAReport_Include PA Report Include Integer GB 0