PA Project Series Report Options (PA70101)

azurecurveProductsProject Accounting (258)ProjectPA Project Series Report Options (PA70101)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA70101

Product: Project Accounting (258)
Series: Project

Display Name: PA Project Series Report Options
Physical Name: PA70101
Technical Name: PA_Options_ROPT

Group Display Name: PA Report Options
Group Technical Name: PA Report Options

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1RPTGRIND SearchReport Group IndexINTInteger20
2RTPACHIN SearchReport Palette Choice IndexINTInteger20
3RTGRSBIN SearchReport Group Sub IndexDLR14Currency1014
4REPORTID SearchReport IDINT_STORAGEInteger20
5RPTGRNMS SearchReport Group NamesSTR20String2220
6ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean20
7PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean20
8PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean20
9PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean20
10EXPTTYPE SearchExport TypeINTInteger20
11FILEXPNM SearchFile Export NameSTR255String256255
12IFFILXST SearchIf File ExistingGBInteger20
13PRNTTYPE SearchPrint TypeGBInteger20
14SORTBY SearchSort ByDDL_Sort_ByInteger20
15RANGEBY SearchRange ByINTInteger20
16YEAR1 SearchYearYearInteger24
17PERIODID SearchPeriod IDINT3Integer23
18PATU SearchPA Transaction UsagePA_DDL_Transaction_UsageInteger20
19PAReport_Include SearchPA Report IncludeGBInteger20
20PARange_By_Array SearchPA Range By ArrayBooleanBoolean20
21PARange_By_Array_1 SearchPA Range By Array[1]BooleanBoolean20
22PARange_By_Array_2 SearchPA Range By Array[2]BooleanBoolean20
23PARange_By_Array_3 SearchPA Range By Array[3]BooleanBoolean20
24PARange_By_Array_4 SearchPA Range By Array[4]BooleanBoolean20
25PARange_By_Array_5 SearchPA Range By Array[5]BooleanBoolean20
26PARange_By_Array_6 SearchPA Range By Array[6]BooleanBoolean20
27PARange_By_Array_7 SearchPA Range By Array[7]BooleanBoolean20
28PARange_By_Array_8 SearchPA Range By Array[8]BooleanBoolean20
29PARange_By_Array_9 SearchPA Range By Array[9]BooleanBoolean20
30PARange_By_Array_10 SearchPA Range By Array[10]BooleanBoolean20
31PAExclude_Array SearchPA Exclude ArrayBooleanBoolean20
32PAExclude_Array_1 SearchPA Exclude Array[1]BooleanBoolean20
33PAExclude_Array_2 SearchPA Exclude Array[2]BooleanBoolean20
34PAExclude_Array_3 SearchPA Exclude Array[3]BooleanBoolean20
35PAExclude_Array_4 SearchPA Exclude Array[4]BooleanBoolean20
36PAExclude_Array_5 SearchPA Exclude Array[5]BooleanBoolean20
37PAExclude_Array_6 SearchPA Exclude Array[6]BooleanBoolean20
38PAExclude_Array_7 SearchPA Exclude Array[7]BooleanBoolean20
39PAExclude_Array_8 SearchPA Exclude Array[8]BooleanBoolean20
40PAExclude_Array_9 SearchPA Exclude Array[9]BooleanBoolean20
41PAExclude_Array_10 SearchPA Exclude Array[10]BooleanBoolean20
42PA_Net_Write_Down_In_Exc SearchPA Net Write Down In Excess OfDLR17_RBS0_UTR$Currency1017
43DETLDRPT SearchDetailed ReportCB_Detailed_ReportBoolean20
44MTHSLCTD SearchMonth SelectedMonthInteger20
45SUMDTTKN SearchSummary Date TokenINTInteger20
46SMRYDATE SearchSummary DateDTDate48
47PACashBudgetSalesLevel SearchPA Cash Budget Sales LevelGBInteger20
48PACashBudgetPctgLevels SearchPA Cash Budget Percentage LevelsINT5_%2Integer25
49PACashBudgetPctgLevels_1 SearchPA Cash Budget Percentage Levels[1]INT5_%2Integer25
50PACashBudgetPctgLevels_2 SearchPA Cash Budget Percentage Levels[2]INT5_%2Integer25
51PACashBudgetPctgLevels_3 SearchPA Cash Budget Percentage Levels[3]INT5_%2Integer25
52PACashBudgetStartingCash SearchPA Cash Budget Starting Cash PositionDLR17_RBS0_UTR$Currency1017
53PACashBudgetCashNeedsLev SearchPA Cash Budget Cash Needs LevelDLR17_RBS0_UTR$Currency1017
54PRPSTJCB SearchPrint Posting Journal CBCBBoolean20
55PRTDBRCD SearchPrint Detail Breakdown Reg CBCBBoolean20
56PRSBDRCB SearchPrint Summary Breakdown Reg CBCBBoolean20
57STRTYEAR SearchStart YearYearInteger24
58ENDYEAR SearchEnd YearYearInteger24
59STBCHNUM SearchStart Batch NumberSTR15_LBAUString1615
60ENDBNMBR SearchEnd Batch NumberSTR15_LBAUString1615
61STDOCN SearchStart Doc NoLong IntLong Integer48
62ENDOCN SearchEnd Doc NoLong IntLong Integer48
63STTPRJCLID SearchStart Project Class IDSTR15_Project_Class_IDString1615
64ENDPRJCLID SearchEnd Project Class IDSTR15_Project_Class_IDString1615
65PASTPROJN SearchPA Start Project NumberSTR15_LBAUString1615
66PAENPROJN SearchPA End Project NumberSTR15_LBAUString1615
67STTPROJID SearchStart Project IDSTR15_Project IDString1615
68ENDPROJID SearchEnd Project IDSTR15_Project IDString1615
69StartProjectMgrID SearchStart Project Mgr IDSTR15_Employee_IDString1615
70EndProjectMgrID SearchEnd Project Mgr IDSTR15_Employee_IDString1615
71StartBusinessMgrID SearchStart Business Mgr IDSTR15_Employee_IDString1615
72EndBusinessMgrID SearchEnd Business Mgr IDSTR15_Employee_IDString1615
73STRTDEPT SearchStart DepartmentSTR6_Payroll_CodeString86
74ENDDEPT SearchEnd DepartmentSTR6_Payroll_CodeString86
75STTCNTRCLID SearchStart Contract Class IDSTR15_Contract Class IDString1615
76ENDCNTRCLID SearchEnd Contract Class IDSTR15_Contract Class IDString1615
77Start_Contract_Number SearchStart Contract NumberSTR10_LBAUString1210
78End_Contract_Number SearchEnd Contract NumberSTR10_LBAUString1210
79STTCONTRID SearchStart Contract IDSTR15_Contract IDString1615
80ENDCONTRID SearchEnd Contract IDSTR15_Contract IDString1615
81STSPRSID SearchStart Salesperson IDSTR15_LBAUString1615
82ENSPSNID SearchEnd Salesperson IDSTR15_LBAUString1615
83STDATEIN SearchStart Date IncurredDTDate48
84ENDATEIN SearchEnd Date IncurredDATEDate46
85STREFDOC SearchStart Ref Doc NoLong IntLong Integer48
86ENREFDOC SearchEnd Ref Doc NoLong IntLong Integer48
87STDISTT SearchStart Dist TypePA_DDL_Distribution_TypeInteger20
88ENDISTT SearchEnd Dist TypePA_DDL_Distribution_TypeInteger20
89STACCNDX SearchStart Account IndexLI_14Long Integer414
90EDACCNDX SearchEnd Account IndexLI_14Long Integer414
91STRTNGDT SearchStarting DateDTDate48
92ENDINGDT SearchEnding DateDTDate48
93STTUDEF1 SearchStart User Defined 1STR20String2220
94ENUSRDF1 SearchEnd User Defined 1STR20String2220
95STTDOCDT SearchStart Document DateDTDate48
96ENDDOCDT SearchEnd Document DateDTDate48
97STTPSTDT SearchStart Post DateDATEDate46
98ENDPSTDT SearchEnd Post DateDATEDate46
99STRXSRC SearchStart TRX SourceSTR13String1413
100ENTRXSRC SearchEnd TRX SourceSTR13String1413
101STCUSTID SearchStart Customer IDSTR15_RM_Customer_NumberString1615
102ENCUSTID SearchEnd Customer IDSTR15_RM_Customer_NumberString1615
103STCUSTNM SearchStart Customer NameSTR64_Customer_NameString6664
104ENCSTNAM SearchEnd Customer NameSTR64_Customer_NameString6664
105PAStart_ID_Array SearchPA Start ID ArraySTR15String1615
106PAStart_ID_Array_1 SearchPA Start ID Array[1]STR15String1615
107PAStart_ID_Array_2 SearchPA Start ID Array[2]STR15String1615
108PAStart_ID_Array_3 SearchPA Start ID Array[3]STR15String1615
109PAStart_ID_Array_4 SearchPA Start ID Array[4]STR15String1615
110PAStart_ID_Array_5 SearchPA Start ID Array[5]STR15String1615
111PAStart_ID_Array_6 SearchPA Start ID Array[6]STR15String1615
112PAStart_ID_Array_7 SearchPA Start ID Array[7]STR15String1615
113PAStart_ID_Array_8 SearchPA Start ID Array[8]STR15String1615
114PAStart_ID_Array_9 SearchPA Start ID Array[9]STR15String1615
115PAStart_ID_Array_10 SearchPA Start ID Array[10]STR15String1615
116PAEnd_ID_Array SearchPA End ID ArraySTR15String1615
117PAEnd_ID_Array_1 SearchPA End ID Array[1]STR15String1615
118PAEnd_ID_Array_2 SearchPA End ID Array[2]STR15String1615
119PAEnd_ID_Array_3 SearchPA End ID Array[3]STR15String1615
120PAEnd_ID_Array_4 SearchPA End ID Array[4]STR15String1615
121PAEnd_ID_Array_5 SearchPA End ID Array[5]STR15String1615
122PAEnd_ID_Array_6 SearchPA End ID Array[6]STR15String1615
123PAEnd_ID_Array_7 SearchPA End ID Array[7]STR15String1615
124PAEnd_ID_Array_8 SearchPA End ID Array[8]STR15String1615
125PAEnd_ID_Array_9 SearchPA End ID Array[9]STR15String1615
126PAEnd_ID_Array_10 SearchPA End ID Array[10]STR15String1615
127PAStart_Name_Array SearchPA Start Name ArraySTR30String3230
128PAStart_Name_Array_1 SearchPA Start Name Array[1]STR30String3230
129PAStart_Name_Array_2 SearchPA Start Name Array[2]STR30String3230
130PAStart_Name_Array_3 SearchPA Start Name Array[3]STR30String3230
131PAStart_Name_Array_4 SearchPA Start Name Array[4]STR30String3230
132PAStart_Name_Array_5 SearchPA Start Name Array[5]STR30String3230
133PAStart_Name_Array_6 SearchPA Start Name Array[6]STR30String3230
134PAStart_Name_Array_7 SearchPA Start Name Array[7]STR30String3230
135PAStart_Name_Array_8 SearchPA Start Name Array[8]STR30String3230
136PAStart_Name_Array_9 SearchPA Start Name Array[9]STR30String3230
137PAStart_Name_Array_10 SearchPA Start Name Array[10]STR30String3230
138PAEnd_Name_Array SearchPA End Name ArraySTR30String3230
139PAEnd_Name_Array_1 SearchPA End Name Array[1]STR30String3230
140PAEnd_Name_Array_2 SearchPA End Name Array[2]STR30String3230
141PAEnd_Name_Array_3 SearchPA End Name Array[3]STR30String3230
142PAEnd_Name_Array_4 SearchPA End Name Array[4]STR30String3230
143PAEnd_Name_Array_5 SearchPA End Name Array[5]STR30String3230
144PAEnd_Name_Array_6 SearchPA End Name Array[6]STR30String3230
145PAEnd_Name_Array_7 SearchPA End Name Array[7]STR30String3230
146PAEnd_Name_Array_8 SearchPA End Name Array[8]STR30String3230
147PAEnd_Name_Array_9 SearchPA End Name Array[9]STR30String3230
148PAEnd_Name_Array_10 SearchPA End Name Array[10]STR30String3230
149PASTDOCT SearchPA Start Doc TypePA_DDL_Document_TypeInteger20
150PAENDOCT SearchPA End Doc TypePA_DDL_Document_TypeInteger20
151PAStart_PO_Number SearchPA Start PO NumberLong IntLong Integer48
152PAEnd_PO_Number SearchPA End PO NumberLong IntLong Integer48
153PAStart_TRX_Type SearchPA Start TRX TypePA_DDL_TRX_TypeInteger20
154PAEnd_TRX_Type SearchPA End TRX TypePA_DDL_TRX_TypeInteger20
155PRTCURIN SearchPrint Currency InGBInteger20
156RPTXRATE SearchReporting Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
157RPRTCLMD SearchReporting Rate Calculation MethodDDL_Rate_Calculation_MethodInteger20
158INCLUDEHOLDPO SearchInclude Hold POCB_Include_PO_HoldBoolean20
159INCLUDEHOLDPOONLY SearchInclude Hold PO OnlyCB_Include_PO_On_Hold_OnlyBoolean20
160Include_New SearchInclude NewCB_NewBoolean20
161Include_Released SearchInclude ReleasedCB_ReleasedBoolean20
162Include_Change_Order SearchInclude Change OrderCB_Change_OrderBoolean20
163Include_Received SearchInclude ReceivedCB_ReceivedBoolean20
164Include_Closed SearchInclude ClosedCB_ClosedBoolean20
165Include_Canceled SearchInclude CanceledCB_CanceledBoolean20
166INCRCPTS SearchInclude ReceiptsCB_ReceiptsBoolean20
167ENDVNDID SearchEnd Vendor IDSTR15_LBUString1615
168ENDVNDNM SearchEnd Vendor NameSTR64_Vendor_NameString6664
169ENDPOSTA SearchEnd PO StatusDDL_PO_StatusInteger20
170EndPOPRcptNum SearchEnd POP Receipt NumberSTR17_POP_NumberString1817
171DISSRLOT SearchDisplay Serial/Lot NumberCB_Serial_Lot_NumberBoolean20
172ENITMNBR SearchEnd Item NumberSTR30_Item_NumberString3230
173End_Promised_Date SearchEnd Promised DateDTDate48
174End_Required_Date SearchEnd Required DateDTDate48
175ENDLOCID SearchEnd Location IDSTR15_Location_IDString1615
176ENRCTDT SearchEnd Receipt DateDTDate48
177ENDBUYERID SearchEnd Buyer IDSTR15_User_IDString1615
178ENDLINEORIGIN SearchEnd Line OriginDDL_Line_OriginInteger20
179ENDRELEASEBYDATE SearchEnd Release By DateDATE_LDate40
180PAENDCOSTID SearchPA End Cost Category IDSTR15_Cost_Category_IDString1615
181ENAUCNCD SearchEnd Audit Control CodeSTR13_LBAUString1413
182Days_Overdue SearchDays OverdueCB_Days_OverdueBoolean20
183DATEOVERDUE SearchDate OverdueDTDate48
184COMPTYPE SearchCompare TypePOP_PO_Compare_TypeInteger20
185POP_Date_Selection1 SearchPA_Date_SelectionDDL_POP_DATE_SELECTIONInteger20
186INCLFUNC SearchInclude Functional CurrencyCB_Functional_CurrencyBoolean20
187INCMCINF SearchInclude Multicurrency InfoCB_Include_Multicurrency_InfoBoolean20
188STVNDRID SearchStart Vendor IDSTR15_LBUString1615
189STVNDNAM SearchStart Vendor NameSTR64_Vendor_NameString6664
190STRPOSTA SearchStart PO StatusDDL_PO_StatusInteger20
191STRPONUM SearchStart PO NumberSTR17_POP_NumberString1817
192StartPOPRcptNum SearchStart POP Receipt NumberSTR17_POP_NumberString1817
193ENDPONUM SearchEnd PO NumberSTR17_POP_NumberString1817
194STTITNUM SearchStart Item NumberSTR30_Item_NumberString3230
195Start_Promised_Date SearchStart Promised DateDTDate48
196Start_Required_Date SearchStart Required DateDTDate48
197STTLOCID SearchStart Location IDSTR15_Location_IDString1615
198STRCTDT SearchStart Receipt DateDTDate48
199STARTBUYERID SearchStart Buyer IDSTR15_User_IDString1615
200STARTLINEORIGIN SearchStart Line OriginDDL_Line_OriginInteger20
201STARTRELEASEBYDATE SearchStart Release By DateDATE_LDate40
202PASTTCOSTID SearchPA Start Cost Category IDSTR15_Cost_Category_IDString1615
203STTACNCD SearchStart Audit Control CodeSTR13_LBAUString1413
204DEX_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.

azurecurveProductsProject Accounting (258)ProjectPA Project Series Report Options (PA70101)

Leave a Reply

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