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 TypeLength
1RPTGRIND SearchReport Group IndexINTInteger0
2RTPACHIN SearchReport Palette Choice IndexINTInteger0
3RTGRSBIN SearchReport Group Sub IndexDLR14Currency14
4REPORTID SearchReport IDINT_STORAGEInteger0
5RPTGRNMS SearchReport Group NamesSTR20String20
6ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean0
7PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean0
8PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean0
9PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean0
10EXPTTYPE SearchExport TypeINTInteger0
11FILEXPNM SearchFile Export NameSTR255String255
12IFFILXST SearchIf File ExistingGBInteger0
13PRNTTYPE SearchPrint TypeGBInteger0
14SORTBY SearchSort ByDDL_Sort_ByInteger0
15RANGEBY SearchRange ByINTInteger0
16YEAR1 SearchYearYearInteger4
17PERIODID SearchPeriod IDINT3Integer3
18PATU SearchPA Transaction UsagePA_DDL_Transaction_UsageInteger0
19PAReport_Include SearchPA Report IncludeGBInteger0
20PARange_By_Array SearchPA Range By ArrayBooleanBoolean0
21PARange_By_Array_1 SearchPA Range By Array[1]BooleanBoolean0
22PARange_By_Array_2 SearchPA Range By Array[2]BooleanBoolean0
23PARange_By_Array_3 SearchPA Range By Array[3]BooleanBoolean0
24PARange_By_Array_4 SearchPA Range By Array[4]BooleanBoolean0
25PARange_By_Array_5 SearchPA Range By Array[5]BooleanBoolean0
26PARange_By_Array_6 SearchPA Range By Array[6]BooleanBoolean0
27PARange_By_Array_7 SearchPA Range By Array[7]BooleanBoolean0
28PARange_By_Array_8 SearchPA Range By Array[8]BooleanBoolean0
29PARange_By_Array_9 SearchPA Range By Array[9]BooleanBoolean0
30PARange_By_Array_10 SearchPA Range By Array[10]BooleanBoolean0
31PAExclude_Array SearchPA Exclude ArrayBooleanBoolean0
32PAExclude_Array_1 SearchPA Exclude Array[1]BooleanBoolean0
33PAExclude_Array_2 SearchPA Exclude Array[2]BooleanBoolean0
34PAExclude_Array_3 SearchPA Exclude Array[3]BooleanBoolean0
35PAExclude_Array_4 SearchPA Exclude Array[4]BooleanBoolean0
36PAExclude_Array_5 SearchPA Exclude Array[5]BooleanBoolean0
37PAExclude_Array_6 SearchPA Exclude Array[6]BooleanBoolean0
38PAExclude_Array_7 SearchPA Exclude Array[7]BooleanBoolean0
39PAExclude_Array_8 SearchPA Exclude Array[8]BooleanBoolean0
40PAExclude_Array_9 SearchPA Exclude Array[9]BooleanBoolean0
41PAExclude_Array_10 SearchPA Exclude Array[10]BooleanBoolean0
42PA_Net_Write_Down_In_Exc SearchPA Net Write Down In Excess OfDLR17_RBS0_UTR$Currency17
43DETLDRPT SearchDetailed ReportCB_Detailed_ReportBoolean0
44MTHSLCTD SearchMonth SelectedMonthInteger0
45SUMDTTKN SearchSummary Date TokenINTInteger0
46SMRYDATE SearchSummary DateDTDate8
47PACashBudgetSalesLevel SearchPA Cash Budget Sales LevelGBInteger0
48PACashBudgetPctgLevels SearchPA Cash Budget Percentage LevelsINT5_%2Integer5
49PACashBudgetPctgLevels_1 SearchPA Cash Budget Percentage Levels[1]INT5_%2Integer5
50PACashBudgetPctgLevels_2 SearchPA Cash Budget Percentage Levels[2]INT5_%2Integer5
51PACashBudgetPctgLevels_3 SearchPA Cash Budget Percentage Levels[3]INT5_%2Integer5
52PACashBudgetStartingCash SearchPA Cash Budget Starting Cash PositionDLR17_RBS0_UTR$Currency17
53PACashBudgetCashNeedsLev SearchPA Cash Budget Cash Needs LevelDLR17_RBS0_UTR$Currency17
54PRPSTJCB SearchPrint Posting Journal CBCBBoolean0
55PRTDBRCD SearchPrint Detail Breakdown Reg CBCBBoolean0
56PRSBDRCB SearchPrint Summary Breakdown Reg CBCBBoolean0
57STRTYEAR SearchStart YearYearInteger4
58ENDYEAR SearchEnd YearYearInteger4
59STBCHNUM SearchStart Batch NumberSTR15_LBAUString15
60ENDBNMBR SearchEnd Batch NumberSTR15_LBAUString15
61STDOCN SearchStart Doc NoLong IntLong Integer8
62ENDOCN SearchEnd Doc NoLong IntLong Integer8
63STTPRJCLID SearchStart Project Class IDSTR15_Project_Class_IDString15
64ENDPRJCLID SearchEnd Project Class IDSTR15_Project_Class_IDString15
65PASTPROJN SearchPA Start Project NumberSTR15_LBAUString15
66PAENPROJN SearchPA End Project NumberSTR15_LBAUString15
67STTPROJID SearchStart Project IDSTR15_Project IDString15
68ENDPROJID SearchEnd Project IDSTR15_Project IDString15
69StartProjectMgrID SearchStart Project Mgr IDSTR15_Employee_IDString15
70EndProjectMgrID SearchEnd Project Mgr IDSTR15_Employee_IDString15
71StartBusinessMgrID SearchStart Business Mgr IDSTR15_Employee_IDString15
72EndBusinessMgrID SearchEnd Business Mgr IDSTR15_Employee_IDString15
73STRTDEPT SearchStart DepartmentSTR6_Payroll_CodeString6
74ENDDEPT SearchEnd DepartmentSTR6_Payroll_CodeString6
75STTCNTRCLID SearchStart Contract Class IDSTR15_Contract Class IDString15
76ENDCNTRCLID SearchEnd Contract Class IDSTR15_Contract Class IDString15
77Start_Contract_Number SearchStart Contract NumberSTR10_LBAUString10
78End_Contract_Number SearchEnd Contract NumberSTR10_LBAUString10
79STTCONTRID SearchStart Contract IDSTR15_Contract IDString15
80ENDCONTRID SearchEnd Contract IDSTR15_Contract IDString15
81STSPRSID SearchStart Salesperson IDSTR15_LBAUString15
82ENSPSNID SearchEnd Salesperson IDSTR15_LBAUString15
83STDATEIN SearchStart Date IncurredDTDate8
84ENDATEIN SearchEnd Date IncurredDATEDate6
85STREFDOC SearchStart Ref Doc NoLong IntLong Integer8
86ENREFDOC SearchEnd Ref Doc NoLong IntLong Integer8
87STDISTT SearchStart Dist TypePA_DDL_Distribution_TypeInteger0
88ENDISTT SearchEnd Dist TypePA_DDL_Distribution_TypeInteger0
89STACCNDX SearchStart Account IndexLI_14Long Integer14
90EDACCNDX SearchEnd Account IndexLI_14Long Integer14
91STRTNGDT SearchStarting DateDTDate8
92ENDINGDT SearchEnding DateDTDate8
93STTUDEF1 SearchStart User Defined 1STR20String20
94ENUSRDF1 SearchEnd User Defined 1STR20String20
95STTDOCDT SearchStart Document DateDTDate8
96ENDDOCDT SearchEnd Document DateDTDate8
97STTPSTDT SearchStart Post DateDATEDate6
98ENDPSTDT SearchEnd Post DateDATEDate6
99STRXSRC SearchStart TRX SourceSTR13String13
100ENTRXSRC SearchEnd TRX SourceSTR13String13
101STCUSTID SearchStart Customer IDSTR15_RM_Customer_NumberString15
102ENCUSTID SearchEnd Customer IDSTR15_RM_Customer_NumberString15
103STCUSTNM SearchStart Customer NameSTR64_Customer_NameString64
104ENCSTNAM SearchEnd Customer NameSTR64_Customer_NameString64
105PAStart_ID_Array SearchPA Start ID ArraySTR15String15
106PAStart_ID_Array_1 SearchPA Start ID Array[1]STR15String15
107PAStart_ID_Array_2 SearchPA Start ID Array[2]STR15String15
108PAStart_ID_Array_3 SearchPA Start ID Array[3]STR15String15
109PAStart_ID_Array_4 SearchPA Start ID Array[4]STR15String15
110PAStart_ID_Array_5 SearchPA Start ID Array[5]STR15String15
111PAStart_ID_Array_6 SearchPA Start ID Array[6]STR15String15
112PAStart_ID_Array_7 SearchPA Start ID Array[7]STR15String15
113PAStart_ID_Array_8 SearchPA Start ID Array[8]STR15String15
114PAStart_ID_Array_9 SearchPA Start ID Array[9]STR15String15
115PAStart_ID_Array_10 SearchPA Start ID Array[10]STR15String15
116PAEnd_ID_Array SearchPA End ID ArraySTR15String15
117PAEnd_ID_Array_1 SearchPA End ID Array[1]STR15String15
118PAEnd_ID_Array_2 SearchPA End ID Array[2]STR15String15
119PAEnd_ID_Array_3 SearchPA End ID Array[3]STR15String15
120PAEnd_ID_Array_4 SearchPA End ID Array[4]STR15String15
121PAEnd_ID_Array_5 SearchPA End ID Array[5]STR15String15
122PAEnd_ID_Array_6 SearchPA End ID Array[6]STR15String15
123PAEnd_ID_Array_7 SearchPA End ID Array[7]STR15String15
124PAEnd_ID_Array_8 SearchPA End ID Array[8]STR15String15
125PAEnd_ID_Array_9 SearchPA End ID Array[9]STR15String15
126PAEnd_ID_Array_10 SearchPA End ID Array[10]STR15String15
127PAStart_Name_Array SearchPA Start Name ArraySTR30String30
128PAStart_Name_Array_1 SearchPA Start Name Array[1]STR30String30
129PAStart_Name_Array_2 SearchPA Start Name Array[2]STR30String30
130PAStart_Name_Array_3 SearchPA Start Name Array[3]STR30String30
131PAStart_Name_Array_4 SearchPA Start Name Array[4]STR30String30
132PAStart_Name_Array_5 SearchPA Start Name Array[5]STR30String30
133PAStart_Name_Array_6 SearchPA Start Name Array[6]STR30String30
134PAStart_Name_Array_7 SearchPA Start Name Array[7]STR30String30
135PAStart_Name_Array_8 SearchPA Start Name Array[8]STR30String30
136PAStart_Name_Array_9 SearchPA Start Name Array[9]STR30String30
137PAStart_Name_Array_10 SearchPA Start Name Array[10]STR30String30
138PAEnd_Name_Array SearchPA End Name ArraySTR30String30
139PAEnd_Name_Array_1 SearchPA End Name Array[1]STR30String30
140PAEnd_Name_Array_2 SearchPA End Name Array[2]STR30String30
141PAEnd_Name_Array_3 SearchPA End Name Array[3]STR30String30
142PAEnd_Name_Array_4 SearchPA End Name Array[4]STR30String30
143PAEnd_Name_Array_5 SearchPA End Name Array[5]STR30String30
144PAEnd_Name_Array_6 SearchPA End Name Array[6]STR30String30
145PAEnd_Name_Array_7 SearchPA End Name Array[7]STR30String30
146PAEnd_Name_Array_8 SearchPA End Name Array[8]STR30String30
147PAEnd_Name_Array_9 SearchPA End Name Array[9]STR30String30
148PAEnd_Name_Array_10 SearchPA End Name Array[10]STR30String30
149PASTDOCT SearchPA Start Doc TypePA_DDL_Document_TypeInteger0
150PAENDOCT SearchPA End Doc TypePA_DDL_Document_TypeInteger0
151PAStart_PO_Number SearchPA Start PO NumberLong IntLong Integer8
152PAEnd_PO_Number SearchPA End PO NumberLong IntLong Integer8
153PAStart_TRX_Type SearchPA Start TRX TypePA_DDL_TRX_TypeInteger0
154PAEnd_TRX_Type SearchPA End TRX TypePA_DDL_TRX_TypeInteger0
155PRTCURIN SearchPrint Currency InGBInteger0
156RPTXRATE SearchReporting Exchange RateDLR14_Exchange_RateCurrency (Variable)14
157RPRTCLMD SearchReporting Rate Calculation MethodDDL_Rate_Calculation_MethodInteger0
158INCLUDEHOLDPO SearchInclude Hold POCB_Include_PO_HoldBoolean0
159INCLUDEHOLDPOONLY SearchInclude Hold PO OnlyCB_Include_PO_On_Hold_OnlyBoolean0
160Include_New SearchInclude NewCB_NewBoolean0
161Include_Released SearchInclude ReleasedCB_ReleasedBoolean0
162Include_Change_Order SearchInclude Change OrderCB_Change_OrderBoolean0
163Include_Received SearchInclude ReceivedCB_ReceivedBoolean0
164Include_Closed SearchInclude ClosedCB_ClosedBoolean0
165Include_Canceled SearchInclude CanceledCB_CanceledBoolean0
166INCRCPTS SearchInclude ReceiptsCB_ReceiptsBoolean0
167ENDVNDID SearchEnd Vendor IDSTR15_LBUString15
168ENDVNDNM SearchEnd Vendor NameSTR64_Vendor_NameString64
169ENDPOSTA SearchEnd PO StatusDDL_PO_StatusInteger0
170EndPOPRcptNum SearchEnd POP Receipt NumberSTR17_POP_NumberString17
171DISSRLOT SearchDisplay Serial/Lot NumberCB_Serial_Lot_NumberBoolean0
172ENITMNBR SearchEnd Item NumberSTR30_Item_NumberString30
173End_Promised_Date SearchEnd Promised DateDTDate8
174End_Required_Date SearchEnd Required DateDTDate8
175ENDLOCID SearchEnd Location IDSTR15_Location_IDString15
176ENRCTDT SearchEnd Receipt DateDTDate8
177ENDBUYERID SearchEnd Buyer IDSTR15_User_IDString15
178ENDLINEORIGIN SearchEnd Line OriginDDL_Line_OriginInteger0
179ENDRELEASEBYDATE SearchEnd Release By DateDATE_LDate0
180PAENDCOSTID SearchPA End Cost Category IDSTR15_Cost_Category_IDString15
181ENAUCNCD SearchEnd Audit Control CodeSTR13_LBAUString13
182Days_Overdue SearchDays OverdueCB_Days_OverdueBoolean0
183DATEOVERDUE SearchDate OverdueDTDate8
184COMPTYPE SearchCompare TypePOP_PO_Compare_TypeInteger0
185POP_Date_Selection1 SearchPA_Date_SelectionDDL_POP_DATE_SELECTIONInteger0
186INCLFUNC SearchInclude Functional CurrencyCB_Functional_CurrencyBoolean0
187INCMCINF SearchInclude Multicurrency InfoCB_Include_Multicurrency_InfoBoolean0
188STVNDRID SearchStart Vendor IDSTR15_LBUString15
189STVNDNAM SearchStart Vendor NameSTR64_Vendor_NameString64
190STRPOSTA SearchStart PO StatusDDL_PO_StatusInteger0
191STRPONUM SearchStart PO NumberSTR17_POP_NumberString17
192StartPOPRcptNum SearchStart POP Receipt NumberSTR17_POP_NumberString17
193ENDPONUM SearchEnd PO NumberSTR17_POP_NumberString17
194STTITNUM SearchStart Item NumberSTR30_Item_NumberString30
195Start_Promised_Date SearchStart Promised DateDTDate8
196Start_Required_Date SearchStart Required DateDTDate8
197STTLOCID SearchStart Location IDSTR15_Location_IDString15
198STRCTDT SearchStart Receipt DateDTDate8
199STARTBUYERID SearchStart Buyer IDSTR15_User_IDString15
200STARTLINEORIGIN SearchStart Line OriginDDL_Line_OriginInteger0
201STARTRELEASEBYDATE SearchStart Release By DateDATE_LDate0
202PASTTCOSTID SearchPA Start Cost Category IDSTR15_Cost_Category_IDString15
203STTACNCD SearchStart Audit Control CodeSTR13_LBAUString13
204DEX_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.

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

Leave a Reply

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