PDK Report Options (PDK70101)

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_ROPT

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1USERID SearchUser IDStringSTR15_User_ID15
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 NoStringPDK_Document_Number30
3PDK_End_Doc_No SearchPDK End Doc NoStringPDK_Document_Number30
4PASTPROJN SearchPA Start Project NumberStringSTR15_LBAU15
5PAENPROJN SearchPA End Project NumberStringSTR15_LBAU15
6Start_Contract_Number SearchStart Contract NumberStringSTR10_LBAU10
7End_Contract_Number SearchEnd Contract NumberStringSTR10_LBAU10
8PAStart_ID_Array_1 SearchPA Start ID Array[1]StringSTR1515
9PAStart_ID_Array_2 SearchPA Start ID Array[2]StringSTR1515
10PAStart_ID_Array_3 SearchPA Start ID Array[3]StringSTR1515
11PAStart_ID_Array_4 SearchPA Start ID Array[4]StringSTR1515
12PAStart_ID_Array_5 SearchPA Start ID Array[5]StringSTR1515
13PAStart_ID_Array_6 SearchPA Start ID Array[6]StringSTR1515
14PAStart_ID_Array_7 SearchPA Start ID Array[7]StringSTR1515
15PAStart_ID_Array_8 SearchPA Start ID Array[8]StringSTR1515
16PAStart_ID_Array_9 SearchPA Start ID Array[9]StringSTR1515
17PAStart_ID_Array_10 SearchPA Start ID Array[10]StringSTR1515
18PAEnd_ID_Array_1 SearchPA End ID Array[1]StringSTR1515
19PAEnd_ID_Array_2 SearchPA End ID Array[2]StringSTR1515
20PAEnd_ID_Array_3 SearchPA End ID Array[3]StringSTR1515
21PAEnd_ID_Array_4 SearchPA End ID Array[4]StringSTR1515
22PAEnd_ID_Array_5 SearchPA End ID Array[5]StringSTR1515
23PAEnd_ID_Array_6 SearchPA End ID Array[6]StringSTR1515
24PAEnd_ID_Array_7 SearchPA End ID Array[7]StringSTR1515
25PAEnd_ID_Array_8 SearchPA End ID Array[8]StringSTR1515
26PAEnd_ID_Array_9 SearchPA End ID Array[9]StringSTR1515
27PAEnd_ID_Array_10 SearchPA End ID Array[10]StringSTR1515
28PAStart_Name_Array_1 SearchPA Start Name Array[1]StringSTR3030
29PAStart_Name_Array_2 SearchPA Start Name Array[2]StringSTR3030
30PAStart_Name_Array_3 SearchPA Start Name Array[3]StringSTR3030
31PAStart_Name_Array_4 SearchPA Start Name Array[4]StringSTR3030
32PAStart_Name_Array_5 SearchPA Start Name Array[5]StringSTR3030
33PAStart_Name_Array_6 SearchPA Start Name Array[6]StringSTR3030
34PAStart_Name_Array_7 SearchPA Start Name Array[7]StringSTR3030
35PAStart_Name_Array_8 SearchPA Start Name Array[8]StringSTR3030
36PAStart_Name_Array_9 SearchPA Start Name Array[9]StringSTR3030
37PAStart_Name_Array_10 SearchPA Start Name Array[10]StringSTR3030
38PAEnd_Name_Array_1 SearchPA End Name Array[1]StringSTR3030
39PAEnd_Name_Array_2 SearchPA End Name Array[2]StringSTR3030
40PAEnd_Name_Array_3 SearchPA End Name Array[3]StringSTR3030
41PAEnd_Name_Array_4 SearchPA End Name Array[4]StringSTR3030
42PAEnd_Name_Array_5 SearchPA End Name Array[5]StringSTR3030
43PAEnd_Name_Array_6 SearchPA End Name Array[6]StringSTR3030
44PAEnd_Name_Array_7 SearchPA End Name Array[7]StringSTR3030
45PAEnd_Name_Array_8 SearchPA End Name Array[8]StringSTR3030
46PAEnd_Name_Array_9 SearchPA End Name Array[9]StringSTR3030
47PAEnd_Name_Array_10 SearchPA End Name Array[10]StringSTR3030
48STDATEIN SearchStart Date IncurredDateDT8
49ENDATEIN SearchEnd Date IncurredDateDATE6
50PASTDOCT SearchPA Start Doc TypeIntegerPA_DDL_Document_Type0
51PAENDOCT SearchPA End Doc TypeIntegerPA_DDL_Document_Type0
52IFFILXST SearchIf File ExistingIntegerGB0
53FILEXPNM SearchFile Export NameStringSTR255255
54EXPTTYPE SearchExport TypeIntegerINT0
55ASKECHTM SearchAsk Each TimeBooleanCB_Ask_Each_Time0
56PRNTOFIL SearchPrint to FileBooleanCB_Print_to_File0
57PRTOPRTR SearchPrint to PrinterBooleanCB_Print_to_Printer0
58PRTOSCRN SearchPrint to ScreenBooleanCB_Print_to_Screen0
59PRNTTYPE SearchPrint TypeIntegerGB0
60RPTGRIND SearchReport Group IndexIntegerINT0
61RTGRSBIN SearchReport Group Sub IndexCurrencyDLR1414
62RTPACHIN SearchReport Palette Choice IndexIntegerINT0
63REPORTID SearchReport IDIntegerINT_STORAGE0
64RPTGRNMS SearchReport Group NamesStringSTR2020
65PATU SearchPA Transaction UsageIntegerPA_DDL_Transaction_Usage0
66STRTNGDT SearchStarting DateDateDT8
67ENDINGDT SearchEnding DateDateDT8
68STTUDEF1 SearchStart User Defined 1StringSTR2020
69ENUSRDF1 SearchEnd User Defined 1StringSTR2020
70STTDOCDT SearchStart Document DateDateDT8
71ENDDOCDT SearchEnd Document DateDateDT8
72STTPSTDT SearchStart Post DateDateDATE6
73ENDPSTDT SearchEnd Post DateDateDATE6
74SORTBY SearchSort ByIntegerDDL_Sort_By0
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 ByIntegerINT0
96PAReport_Include SearchPA Report IncludeIntegerGB0

Leave a Reply

Your email address will not be published. Required fields are marked *