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 TypeSQL DB LengthKeyable Length
1USERID SearchUser IDSTR15_User_IDString1615
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_NumberString3230
3PDK_End_Doc_No SearchPDK End Doc NoPDK_Document_NumberString3230
4PASTPROJN SearchPA Start Project NumberSTR15_LBAUString1615
5PAENPROJN SearchPA End Project NumberSTR15_LBAUString1615
6Start_Contract_Number SearchStart Contract NumberSTR10_LBAUString1210
7End_Contract_Number SearchEnd Contract NumberSTR10_LBAUString1210
8PAStart_ID_Array_1 SearchPA Start ID Array[1]STR15String1615
9PAStart_ID_Array_2 SearchPA Start ID Array[2]STR15String1615
10PAStart_ID_Array_3 SearchPA Start ID Array[3]STR15String1615
11PAStart_ID_Array_4 SearchPA Start ID Array[4]STR15String1615
12PAStart_ID_Array_5 SearchPA Start ID Array[5]STR15String1615
13PAStart_ID_Array_6 SearchPA Start ID Array[6]STR15String1615
14PAStart_ID_Array_7 SearchPA Start ID Array[7]STR15String1615
15PAStart_ID_Array_8 SearchPA Start ID Array[8]STR15String1615
16PAStart_ID_Array_9 SearchPA Start ID Array[9]STR15String1615
17PAStart_ID_Array_10 SearchPA Start ID Array[10]STR15String1615
18PAEnd_ID_Array_1 SearchPA End ID Array[1]STR15String1615
19PAEnd_ID_Array_2 SearchPA End ID Array[2]STR15String1615
20PAEnd_ID_Array_3 SearchPA End ID Array[3]STR15String1615
21PAEnd_ID_Array_4 SearchPA End ID Array[4]STR15String1615
22PAEnd_ID_Array_5 SearchPA End ID Array[5]STR15String1615
23PAEnd_ID_Array_6 SearchPA End ID Array[6]STR15String1615
24PAEnd_ID_Array_7 SearchPA End ID Array[7]STR15String1615
25PAEnd_ID_Array_8 SearchPA End ID Array[8]STR15String1615
26PAEnd_ID_Array_9 SearchPA End ID Array[9]STR15String1615
27PAEnd_ID_Array_10 SearchPA End ID Array[10]STR15String1615
28PAStart_Name_Array_1 SearchPA Start Name Array[1]STR30String3230
29PAStart_Name_Array_2 SearchPA Start Name Array[2]STR30String3230
30PAStart_Name_Array_3 SearchPA Start Name Array[3]STR30String3230
31PAStart_Name_Array_4 SearchPA Start Name Array[4]STR30String3230
32PAStart_Name_Array_5 SearchPA Start Name Array[5]STR30String3230
33PAStart_Name_Array_6 SearchPA Start Name Array[6]STR30String3230
34PAStart_Name_Array_7 SearchPA Start Name Array[7]STR30String3230
35PAStart_Name_Array_8 SearchPA Start Name Array[8]STR30String3230
36PAStart_Name_Array_9 SearchPA Start Name Array[9]STR30String3230
37PAStart_Name_Array_10 SearchPA Start Name Array[10]STR30String3230
38PAEnd_Name_Array_1 SearchPA End Name Array[1]STR30String3230
39PAEnd_Name_Array_2 SearchPA End Name Array[2]STR30String3230
40PAEnd_Name_Array_3 SearchPA End Name Array[3]STR30String3230
41PAEnd_Name_Array_4 SearchPA End Name Array[4]STR30String3230
42PAEnd_Name_Array_5 SearchPA End Name Array[5]STR30String3230
43PAEnd_Name_Array_6 SearchPA End Name Array[6]STR30String3230
44PAEnd_Name_Array_7 SearchPA End Name Array[7]STR30String3230
45PAEnd_Name_Array_8 SearchPA End Name Array[8]STR30String3230
46PAEnd_Name_Array_9 SearchPA End Name Array[9]STR30String3230
47PAEnd_Name_Array_10 SearchPA End Name Array[10]STR30String3230
48STDATEIN SearchStart Date IncurredDTDate48
49ENDATEIN SearchEnd Date IncurredDATEDate46
50PASTDOCT SearchPA Start Doc TypePA_DDL_Document_TypeInteger20
51PAENDOCT SearchPA End Doc TypePA_DDL_Document_TypeInteger20
52IFFILXST SearchIf File ExistingGBInteger20
53FILEXPNM SearchFile Export NameSTR255String256255
54EXPTTYPE SearchExport TypeINTInteger20
55ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean20
56PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean20
57PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean20
58PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean20
59PRNTTYPE SearchPrint TypeGBInteger20
60RPTGRIND SearchReport Group IndexINTInteger20
61RTGRSBIN SearchReport Group Sub IndexDLR14Currency1014
62RTPACHIN SearchReport Palette Choice IndexINTInteger20
63REPORTID SearchReport IDINT_STORAGEInteger20
64RPTGRNMS SearchReport Group NamesSTR20String2220
65PATU SearchPA Transaction UsagePA_DDL_Transaction_UsageInteger20
66STRTNGDT SearchStarting DateDTDate48
67ENDINGDT SearchEnding DateDTDate48
68STTUDEF1 SearchStart User Defined 1STR20String2220
69ENUSRDF1 SearchEnd User Defined 1STR20String2220
70STTDOCDT SearchStart Document DateDTDate48
71ENDDOCDT SearchEnd Document DateDTDate48
72STTPSTDT SearchStart Post DateDATEDate46
73ENDPSTDT SearchEnd Post DateDATEDate46
74SORTBY SearchSort ByDDL_Sort_ByInteger20
75PARange_By_Array_1 SearchPA Range By Array[1]BooleanBoolean20
76PARange_By_Array_2 SearchPA Range By Array[2]BooleanBoolean20
77PARange_By_Array_3 SearchPA Range By Array[3]BooleanBoolean20
78PARange_By_Array_4 SearchPA Range By Array[4]BooleanBoolean20
79PARange_By_Array_5 SearchPA Range By Array[5]BooleanBoolean20
80PARange_By_Array_6 SearchPA Range By Array[6]BooleanBoolean20
81PARange_By_Array_7 SearchPA Range By Array[7]BooleanBoolean20
82PARange_By_Array_8 SearchPA Range By Array[8]BooleanBoolean20
83PARange_By_Array_9 SearchPA Range By Array[9]BooleanBoolean20
84PARange_By_Array_10 SearchPA Range By Array[10]BooleanBoolean20
85PAExclude_Array_1 SearchPA Exclude Array[1]BooleanBoolean20
86PAExclude_Array_2 SearchPA Exclude Array[2]BooleanBoolean20
87PAExclude_Array_3 SearchPA Exclude Array[3]BooleanBoolean20
88PAExclude_Array_4 SearchPA Exclude Array[4]BooleanBoolean20
89PAExclude_Array_5 SearchPA Exclude Array[5]BooleanBoolean20
90PAExclude_Array_6 SearchPA Exclude Array[6]BooleanBoolean20
91PAExclude_Array_7 SearchPA Exclude Array[7]BooleanBoolean20
92PAExclude_Array_8 SearchPA Exclude Array[8]BooleanBoolean20
93PAExclude_Array_9 SearchPA Exclude Array[9]BooleanBoolean20
94PAExclude_Array_10 SearchPA Exclude Array[10]BooleanBoolean20
95RANGEBY SearchRange ByINTInteger20
96PAReport_Include SearchPA Report IncludeGBInteger20
97DEX_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 *