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