PDK Report Options (PDK70101)

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
Physical Name: PDK70101
Technical Name: PDK_Options_ROPT

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 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
2PDK_Start_Doc_No SearchPDK Start Doc NoPDK_Document_NumberString30
3PDK_End_Doc_No SearchPDK End Doc NoPDK_Document_NumberString30
4PASTPROJN SearchPA Start Project NumberSTR15_LBAUString15
5PAENPROJN SearchPA End Project NumberSTR15_LBAUString15
6Start_Contract_Number SearchStart Contract NumberSTR10_LBAUString10
7End_Contract_Number SearchEnd Contract NumberSTR10_LBAUString10
8PAStart_ID_Array_1 SearchPA Start ID Array[1]STR15String15
9PAStart_ID_Array_2 SearchPA Start ID Array[2]STR15String15
10PAStart_ID_Array_3 SearchPA Start ID Array[3]STR15String15
11PAStart_ID_Array_4 SearchPA Start ID Array[4]STR15String15
12PAStart_ID_Array_5 SearchPA Start ID Array[5]STR15String15
13PAStart_ID_Array_6 SearchPA Start ID Array[6]STR15String15
14PAStart_ID_Array_7 SearchPA Start ID Array[7]STR15String15
15PAStart_ID_Array_8 SearchPA Start ID Array[8]STR15String15
16PAStart_ID_Array_9 SearchPA Start ID Array[9]STR15String15
17PAStart_ID_Array_10 SearchPA Start ID Array[10]STR15String15
18PAEnd_ID_Array_1 SearchPA End ID Array[1]STR15String15
19PAEnd_ID_Array_2 SearchPA End ID Array[2]STR15String15
20PAEnd_ID_Array_3 SearchPA End ID Array[3]STR15String15
21PAEnd_ID_Array_4 SearchPA End ID Array[4]STR15String15
22PAEnd_ID_Array_5 SearchPA End ID Array[5]STR15String15
23PAEnd_ID_Array_6 SearchPA End ID Array[6]STR15String15
24PAEnd_ID_Array_7 SearchPA End ID Array[7]STR15String15
25PAEnd_ID_Array_8 SearchPA End ID Array[8]STR15String15
26PAEnd_ID_Array_9 SearchPA End ID Array[9]STR15String15
27PAEnd_ID_Array_10 SearchPA End ID Array[10]STR15String15
28PAStart_Name_Array_1 SearchPA Start Name Array[1]STR30String30
29PAStart_Name_Array_2 SearchPA Start Name Array[2]STR30String30
30PAStart_Name_Array_3 SearchPA Start Name Array[3]STR30String30
31PAStart_Name_Array_4 SearchPA Start Name Array[4]STR30String30
32PAStart_Name_Array_5 SearchPA Start Name Array[5]STR30String30
33PAStart_Name_Array_6 SearchPA Start Name Array[6]STR30String30
34PAStart_Name_Array_7 SearchPA Start Name Array[7]STR30String30
35PAStart_Name_Array_8 SearchPA Start Name Array[8]STR30String30
36PAStart_Name_Array_9 SearchPA Start Name Array[9]STR30String30
37PAStart_Name_Array_10 SearchPA Start Name Array[10]STR30String30
38PAEnd_Name_Array_1 SearchPA End Name Array[1]STR30String30
39PAEnd_Name_Array_2 SearchPA End Name Array[2]STR30String30
40PAEnd_Name_Array_3 SearchPA End Name Array[3]STR30String30
41PAEnd_Name_Array_4 SearchPA End Name Array[4]STR30String30
42PAEnd_Name_Array_5 SearchPA End Name Array[5]STR30String30
43PAEnd_Name_Array_6 SearchPA End Name Array[6]STR30String30
44PAEnd_Name_Array_7 SearchPA End Name Array[7]STR30String30
45PAEnd_Name_Array_8 SearchPA End Name Array[8]STR30String30
46PAEnd_Name_Array_9 SearchPA End Name Array[9]STR30String30
47PAEnd_Name_Array_10 SearchPA End Name Array[10]STR30String30
48STDATEIN SearchStart Date IncurredDTDate8
49ENDATEIN SearchEnd Date IncurredDATEDate6
50PASTDOCT SearchPA Start Doc TypePA_DDL_Document_TypeInteger0
51PAENDOCT SearchPA End Doc TypePA_DDL_Document_TypeInteger0
52IFFILXST SearchIf File ExistingGBInteger0
53FILEXPNM SearchFile Export NameSTR255String255
54EXPTTYPE SearchExport TypeINTInteger0
55ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean0
56PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean0
57PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean0
58PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean0
59PRNTTYPE SearchPrint TypeGBInteger0
60RPTGRIND SearchReport Group IndexINTInteger0
61RTGRSBIN SearchReport Group Sub IndexDLR14Currency14
62RTPACHIN SearchReport Palette Choice IndexINTInteger0
63REPORTID SearchReport IDINT_STORAGEInteger0
64RPTGRNMS SearchReport Group NamesSTR20String20
65PATU SearchPA Transaction UsagePA_DDL_Transaction_UsageInteger0
66STRTNGDT SearchStarting DateDTDate8
67ENDINGDT SearchEnding DateDTDate8
68STTUDEF1 SearchStart User Defined 1STR20String20
69ENUSRDF1 SearchEnd User Defined 1STR20String20
70STTDOCDT SearchStart Document DateDTDate8
71ENDDOCDT SearchEnd Document DateDTDate8
72STTPSTDT SearchStart Post DateDATEDate6
73ENDPSTDT SearchEnd Post DateDATEDate6
74SORTBY SearchSort ByDDL_Sort_ByInteger0
75PARange_By_Array_1 SearchPA Range By Array[1]BooleanBoolean0
76PARange_By_Array_2 SearchPA Range By Array[2]BooleanBoolean0
77PARange_By_Array_3 SearchPA Range By Array[3]BooleanBoolean0
78PARange_By_Array_4 SearchPA Range By Array[4]BooleanBoolean0
79PARange_By_Array_5 SearchPA Range By Array[5]BooleanBoolean0
80PARange_By_Array_6 SearchPA Range By Array[6]BooleanBoolean0
81PARange_By_Array_7 SearchPA Range By Array[7]BooleanBoolean0
82PARange_By_Array_8 SearchPA Range By Array[8]BooleanBoolean0
83PARange_By_Array_9 SearchPA Range By Array[9]BooleanBoolean0
84PARange_By_Array_10 SearchPA Range By Array[10]BooleanBoolean0
85PAExclude_Array_1 SearchPA Exclude Array[1]BooleanBoolean0
86PAExclude_Array_2 SearchPA Exclude Array[2]BooleanBoolean0
87PAExclude_Array_3 SearchPA Exclude Array[3]BooleanBoolean0
88PAExclude_Array_4 SearchPA Exclude Array[4]BooleanBoolean0
89PAExclude_Array_5 SearchPA Exclude Array[5]BooleanBoolean0
90PAExclude_Array_6 SearchPA Exclude Array[6]BooleanBoolean0
91PAExclude_Array_7 SearchPA Exclude Array[7]BooleanBoolean0
92PAExclude_Array_8 SearchPA Exclude Array[8]BooleanBoolean0
93PAExclude_Array_9 SearchPA Exclude Array[9]BooleanBoolean0
94PAExclude_Array_10 SearchPA Exclude Array[10]BooleanBoolean0
95RANGEBY SearchRange ByINTInteger0
96PAReport_Include SearchPA Report IncludeGBInteger0
97DEX_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 *