Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA70101
Product: Project Accounting (258)
Series:
Display Name: PA Project Series Report Options Group Display Name: PA Report Options
Physical Name: PA70101
Technical Name: PA_Options_ROPT
Group Technical Name: PA Report Options
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length |
---|---|---|---|---|---|
1 | RPTGRIND | Report Group Index | Integer | INT | 0 |
2 | RTPACHIN | Report Palette Choice Index | Integer | INT | 0 |
3 | RTGRSBIN | Report Group Sub Index | Currency | DLR14 | 14 |
4 | REPORTID | Report ID | Integer | INT_STORAGE | 0 |
5 | RPTGRNMS | Report Group Names | String | STR20 | 20 |
6 | ASKECHTM | Ask Each Time | Boolean | CB_Ask_Each_Time | 0 |
7 | PRTOSCRN | Print to Screen | Boolean | CB_Print_to_Screen | 0 |
8 | PRTOPRTR | Print to Printer | Boolean | CB_Print_to_Printer | 0 |
9 | PRNTOFIL | Print to File | Boolean | CB_Print_to_File | 0 |
10 | EXPTTYPE | Export Type | Integer | INT | 0 |
11 | FILEXPNM | File Export Name | String | STR255 | 255 |
12 | IFFILXST | If File Existing | Integer | GB | 0 |
13 | PRNTTYPE | Print Type | Integer | GB | 0 |
14 | SORTBY | Sort By | Integer | DDL_Sort_By | 0 |
15 | RANGEBY | Range By | Integer | INT | 0 |
16 | YEAR1 | Year | Integer | Year | 4 |
17 | PERIODID | Period ID | Integer | INT3 | 3 |
18 | PATU | PA Transaction Usage | Integer | PA_DDL_Transaction_Usage | 0 |
19 | PAReport_Include | PA Report Include | Integer | GB | 0 |
20 | PARange_By_Array_1 | PA Range By Array[1] | Boolean | Boolean | 0 |
21 | PARange_By_Array | PA Range By Array | Boolean | Boolean | 0 |
22 | PARange_By_Array_2 | PA Range By Array[2] | Boolean | Boolean | 0 |
23 | PARange_By_Array_3 | PA Range By Array[3] | Boolean | Boolean | 0 |
24 | PARange_By_Array_4 | PA Range By Array[4] | Boolean | Boolean | 0 |
25 | PARange_By_Array_5 | PA Range By Array[5] | Boolean | Boolean | 0 |
26 | PARange_By_Array_6 | PA Range By Array[6] | Boolean | Boolean | 0 |
27 | PARange_By_Array_7 | PA Range By Array[7] | Boolean | Boolean | 0 |
28 | PARange_By_Array_8 | PA Range By Array[8] | Boolean | Boolean | 0 |
29 | PARange_By_Array_9 | PA Range By Array[9] | Boolean | Boolean | 0 |
30 | PARange_By_Array_10 | PA Range By Array[10] | Boolean | Boolean | 0 |
31 | PAExclude_Array_1 | PA Exclude Array[1] | Boolean | Boolean | 0 |
32 | PAExclude_Array_2 | PA Exclude Array[2] | Boolean | Boolean | 0 |
33 | PAExclude_Array | PA Exclude Array | Boolean | Boolean | 0 |
34 | PAExclude_Array_3 | PA Exclude Array[3] | Boolean | Boolean | 0 |
35 | PAExclude_Array_4 | PA Exclude Array[4] | Boolean | Boolean | 0 |
36 | PAExclude_Array_5 | PA Exclude Array[5] | Boolean | Boolean | 0 |
37 | PAExclude_Array_6 | PA Exclude Array[6] | Boolean | Boolean | 0 |
38 | PAExclude_Array_7 | PA Exclude Array[7] | Boolean | Boolean | 0 |
39 | PAExclude_Array_8 | PA Exclude Array[8] | Boolean | Boolean | 0 |
40 | PAExclude_Array_9 | PA Exclude Array[9] | Boolean | Boolean | 0 |
41 | PAExclude_Array_10 | PA Exclude Array[10] | Boolean | Boolean | 0 |
42 | PA_Net_Write_Down_In_Exc | PA Net Write Down In Excess Of | Currency | DLR17_RBS0_UTR$ | 17 |
43 | DETLDRPT | Detailed Report | Boolean | CB_Detailed_Report | 0 |
44 | MTHSLCTD | Month Selected | Integer | Month | 0 |
45 | SUMDTTKN | Summary Date Token | Integer | INT | 0 |
46 | SMRYDATE | Summary Date | Date | DT | 8 |
47 | PACashBudgetSalesLevel | PA Cash Budget Sales Level | Integer | GB | 0 |
48 | PACashBudgetPctgLevels_1 | PA Cash Budget Percentage Levels[1] | Integer | INT5_%2 | 5 |
49 | PACashBudgetPctgLevels_2 | PA Cash Budget Percentage Levels[2] | Integer | INT5_%2 | 5 |
50 | PACashBudgetPctgLevels | PA Cash Budget Percentage Levels | INT5_%2 | Integer | 5 |
51 | PACashBudgetPctgLevels_3 | PA Cash Budget Percentage Levels[3] | Integer | INT5_%2 | 5 |
52 | PACashBudgetStartingCash | PA Cash Budget Starting Cash Position | Currency | DLR17_RBS0_UTR$ | 17 |
53 | PACashBudgetCashNeedsLev | PA Cash Budget Cash Needs Level | Currency | DLR17_RBS0_UTR$ | 17 |
54 | PRPSTJCB | Print Posting Journal CB | Boolean | CB | 0 |
55 | PRTDBRCD | Print Detail Breakdown Reg CB | Boolean | CB | 0 |
56 | PRSBDRCB | Print Summary Breakdown Reg CB | Boolean | CB | 0 |
57 | STRTYEAR | Start Year | Integer | Year | 4 |
58 | ENDYEAR | End Year | Integer | Year | 4 |
59 | STBCHNUM | Start Batch Number | String | STR15_LBAU | 15 |
60 | ENDBNMBR | End Batch Number | String | STR15_LBAU | 15 |
61 | STDOCN | Start Doc No | Long Integer | Long Int | 8 |
62 | ENDOCN | End Doc No | Long Integer | Long Int | 8 |
63 | STTPRJCLID | Start Project Class ID | String | STR15_Project_Class_ID | 15 |
64 | ENDPRJCLID | End Project Class ID | String | STR15_Project_Class_ID | 15 |
65 | PASTPROJN | PA Start Project Number | String | STR15_LBAU | 15 |
66 | PAENPROJN | PA End Project Number | String | STR15_LBAU | 15 |
67 | STTPROJID | Start Project ID | String | STR15_Project ID | 15 |
68 | ENDPROJID | End Project ID | String | STR15_Project ID | 15 |
69 | StartProjectMgrID | Start Project Mgr ID | String | STR15_Employee_ID | 15 |
70 | EndProjectMgrID | End Project Mgr ID | String | STR15_Employee_ID | 15 |
71 | StartBusinessMgrID | Start Business Mgr ID | String | STR15_Employee_ID | 15 |
72 | EndBusinessMgrID | End Business Mgr ID | String | STR15_Employee_ID | 15 |
73 | STRTDEPT | Start Department | String | STR6_Payroll_Code | 6 |
74 | ENDDEPT | End Department | String | STR6_Payroll_Code | 6 |
75 | STTCNTRCLID | Start Contract Class ID | String | STR15_Contract Class ID | 15 |
76 | ENDCNTRCLID | End Contract Class ID | String | STR15_Contract Class ID | 15 |
77 | Start_Contract_Number | Start Contract Number | String | STR10_LBAU | 10 |
78 | End_Contract_Number | End Contract Number | String | STR10_LBAU | 10 |
79 | STTCONTRID | Start Contract ID | String | STR15_Contract ID | 15 |
80 | ENDCONTRID | End Contract ID | String | STR15_Contract ID | 15 |
81 | STSPRSID | Start Salesperson ID | String | STR15_LBAU | 15 |
82 | ENSPSNID | End Salesperson ID | String | STR15_LBAU | 15 |
83 | STDATEIN | Start Date Incurred | Date | DT | 8 |
84 | ENDATEIN | End Date Incurred | Date | DATE | 6 |
85 | STREFDOC | Start Ref Doc No | Long Integer | Long Int | 8 |
86 | ENREFDOC | End Ref Doc No | Long Integer | Long Int | 8 |
87 | STDISTT | Start Dist Type | Integer | PA_DDL_Distribution_Type | 0 |
88 | ENDISTT | End Dist Type | Integer | PA_DDL_Distribution_Type | 0 |
89 | STACCNDX | Start Account Index | Long Integer | LI_14 | 14 |
90 | EDACCNDX | End Account Index | Long Integer | LI_14 | 14 |
91 | STRTNGDT | Starting Date | Date | DT | 8 |
92 | ENDINGDT | Ending Date | Date | DT | 8 |
93 | STTUDEF1 | Start User Defined 1 | String | STR20 | 20 |
94 | ENUSRDF1 | End User Defined 1 | String | STR20 | 20 |
95 | STTDOCDT | Start Document Date | Date | DT | 8 |
96 | ENDDOCDT | End Document Date | Date | DT | 8 |
97 | STTPSTDT | Start Post Date | Date | DATE | 6 |
98 | ENDPSTDT | End Post Date | Date | DATE | 6 |
99 | STRXSRC | Start TRX Source | String | STR13 | 13 |
100 | ENTRXSRC | End TRX Source | String | STR13 | 13 |
101 | STCUSTID | Start Customer ID | String | STR15_RM_Customer_Number | 15 |
102 | ENCUSTID | End Customer ID | String | STR15_RM_Customer_Number | 15 |
103 | STCUSTNM | Start Customer Name | String | STR64_Customer_Name | 64 |
104 | ENCSTNAM | End Customer Name | String | STR64_Customer_Name | 64 |
105 | PAStart_ID_Array_1 | PA Start ID Array[1] | String | STR15 | 15 |
106 | PAStart_ID_Array_2 | PA Start ID Array[2] | String | STR15 | 15 |
107 | PAStart_ID_Array_3 | PA Start ID Array[3] | String | STR15 | 15 |
108 | PAStart_ID_Array | PA Start ID Array | STR15 | String | 15 |
109 | PAStart_ID_Array_4 | PA Start ID Array[4] | String | STR15 | 15 |
110 | PAStart_ID_Array_5 | PA Start ID Array[5] | String | STR15 | 15 |
111 | PAStart_ID_Array_6 | PA Start ID Array[6] | String | STR15 | 15 |
112 | PAStart_ID_Array_7 | PA Start ID Array[7] | String | STR15 | 15 |
113 | PAStart_ID_Array_8 | PA Start ID Array[8] | String | STR15 | 15 |
114 | PAStart_ID_Array_9 | PA Start ID Array[9] | String | STR15 | 15 |
115 | PAStart_ID_Array_10 | PA Start ID Array[10] | String | STR15 | 15 |
116 | PAEnd_ID_Array_1 | PA End ID Array[1] | String | STR15 | 15 |
117 | PAEnd_ID_Array_2 | PA End ID Array[2] | String | STR15 | 15 |
118 | PAEnd_ID_Array_3 | PA End ID Array[3] | String | STR15 | 15 |
119 | PAEnd_ID_Array_4 | PA End ID Array[4] | String | STR15 | 15 |
120 | PAEnd_ID_Array | PA End ID Array | STR15 | String | 15 |
121 | PAEnd_ID_Array_5 | PA End ID Array[5] | String | STR15 | 15 |
122 | PAEnd_ID_Array_6 | PA End ID Array[6] | String | STR15 | 15 |
123 | PAEnd_ID_Array_7 | PA End ID Array[7] | String | STR15 | 15 |
124 | PAEnd_ID_Array_8 | PA End ID Array[8] | String | STR15 | 15 |
125 | PAEnd_ID_Array_9 | PA End ID Array[9] | String | STR15 | 15 |
126 | PAEnd_ID_Array_10 | PA End ID Array[10] | String | STR15 | 15 |
127 | PAStart_Name_Array_1 | PA Start Name Array[1] | String | STR30 | 30 |
128 | PAStart_Name_Array_2 | PA Start Name Array[2] | String | STR30 | 30 |
129 | PAStart_Name_Array_3 | PA Start Name Array[3] | String | STR30 | 30 |
130 | PAStart_Name_Array_4 | PA Start Name Array[4] | String | STR30 | 30 |
131 | PAStart_Name_Array_5 | PA Start Name Array[5] | String | STR30 | 30 |
132 | PAStart_Name_Array | PA Start Name Array | STR30 | String | 30 |
133 | PAStart_Name_Array_6 | PA Start Name Array[6] | String | STR30 | 30 |
134 | PAStart_Name_Array_7 | PA Start Name Array[7] | String | STR30 | 30 |
135 | PAStart_Name_Array_8 | PA Start Name Array[8] | String | STR30 | 30 |
136 | PAStart_Name_Array_9 | PA Start Name Array[9] | String | STR30 | 30 |
137 | PAStart_Name_Array_10 | PA Start Name Array[10] | String | STR30 | 30 |
138 | PAEnd_Name_Array_1 | PA End Name Array[1] | String | STR30 | 30 |
139 | PAEnd_Name_Array_2 | PA End Name Array[2] | String | STR30 | 30 |
140 | PAEnd_Name_Array_3 | PA End Name Array[3] | String | STR30 | 30 |
141 | PAEnd_Name_Array_4 | PA End Name Array[4] | String | STR30 | 30 |
142 | PAEnd_Name_Array_5 | PA End Name Array[5] | String | STR30 | 30 |
143 | PAEnd_Name_Array_6 | PA End Name Array[6] | String | STR30 | 30 |
144 | PAEnd_Name_Array | PA End Name Array | STR30 | String | 30 |
145 | PAEnd_Name_Array_7 | PA End Name Array[7] | String | STR30 | 30 |
146 | PAEnd_Name_Array_8 | PA End Name Array[8] | String | STR30 | 30 |
147 | PAEnd_Name_Array_9 | PA End Name Array[9] | String | STR30 | 30 |
148 | PAEnd_Name_Array_10 | PA End Name Array[10] | String | STR30 | 30 |
149 | PASTDOCT | PA Start Doc Type | Integer | PA_DDL_Document_Type | 0 |
150 | PAENDOCT | PA End Doc Type | Integer | PA_DDL_Document_Type | 0 |
151 | PAStart_PO_Number | PA Start PO Number | Long Integer | Long Int | 8 |
152 | PAEnd_PO_Number | PA End PO Number | Long Integer | Long Int | 8 |
153 | PAStart_TRX_Type | PA Start TRX Type | Integer | PA_DDL_TRX_Type | 0 |
154 | PAEnd_TRX_Type | PA End TRX Type | Integer | PA_DDL_TRX_Type | 0 |
155 | PRTCURIN | Print Currency In | Integer | GB | 0 |
156 | RPTXRATE | Reporting Exchange Rate | Currency (Variable) | DLR14_Exchange_Rate | 14 |
157 | RPRTCLMD | Reporting Rate Calculation Method | Integer | DDL_Rate_Calculation_Method | 0 |
158 | INCLUDEHOLDPO | Include Hold PO | Boolean | CB_Include_PO_Hold | 0 |
159 | INCLUDEHOLDPOONLY | Include Hold PO Only | Boolean | CB_Include_PO_On_Hold_Only | 0 |
160 | Include_New | Include New | Boolean | CB_New | 0 |
161 | Include_Released | Include Released | Boolean | CB_Released | 0 |
162 | Include_Change_Order | Include Change Order | Boolean | CB_Change_Order | 0 |
163 | Include_Received | Include Received | Boolean | CB_Received | 0 |
164 | Include_Closed | Include Closed | Boolean | CB_Closed | 0 |
165 | Include_Canceled | Include Canceled | Boolean | CB_Canceled | 0 |
166 | INCRCPTS | Include Receipts | Boolean | CB_Receipts | 0 |
167 | ENDVNDID | End Vendor ID | String | STR15_LBU | 15 |
168 | ENDVNDNM | End Vendor Name | String | STR64_Vendor_Name | 64 |
169 | ENDPOSTA | End PO Status | Integer | DDL_PO_Status | 0 |
170 | EndPOPRcptNum | End POP Receipt Number | String | STR17_POP_Number | 17 |
171 | DISSRLOT | Display Serial/Lot Number | Boolean | CB_Serial_Lot_Number | 0 |
172 | ENITMNBR | End Item Number | String | STR30_Item_Number | 30 |
173 | End_Promised_Date | End Promised Date | Date | DT | 8 |
174 | End_Required_Date | End Required Date | Date | DT | 8 |
175 | ENDLOCID | End Location ID | String | STR15_Location_ID | 15 |
176 | ENRCTDT | End Receipt Date | Date | DT | 8 |
177 | ENDBUYERID | End Buyer ID | String | STR15_User_ID | 15 |
178 | ENDLINEORIGIN | End Line Origin | Integer | DDL_Line_Origin | 0 |
179 | ENDRELEASEBYDATE | End Release By Date | Date | DATE_L | 0 |
180 | PAENDCOSTID | PA End Cost Category ID | String | STR15_Cost_Category_ID | 15 |
181 | ENAUCNCD | End Audit Control Code | String | STR13_LBAU | 13 |
182 | Days_Overdue | Days Overdue | Boolean | CB_Days_Overdue | 0 |
183 | DATEOVERDUE | Date Overdue | Date | DT | 8 |
184 | COMPTYPE | Compare Type | Integer | POP_PO_Compare_Type | 0 |
185 | POP_Date_Selection1 | PA_Date_Selection | Integer | DDL_POP_DATE_SELECTION | 0 |
186 | INCLFUNC | Include Functional Currency | Boolean | CB_Functional_Currency | 0 |
187 | INCMCINF | Include Multicurrency Info | Boolean | CB_Include_Multicurrency_Info | 0 |
188 | STVNDRID | Start Vendor ID | String | STR15_LBU | 15 |
189 | STVNDNAM | Start Vendor Name | String | STR64_Vendor_Name | 64 |
190 | STRPOSTA | Start PO Status | Integer | DDL_PO_Status | 0 |
191 | STRPONUM | Start PO Number | String | STR17_POP_Number | 17 |
192 | StartPOPRcptNum | Start POP Receipt Number | String | STR17_POP_Number | 17 |
193 | ENDPONUM | End PO Number | String | STR17_POP_Number | 17 |
194 | STTITNUM | Start Item Number | String | STR30_Item_Number | 30 |
195 | Start_Promised_Date | Start Promised Date | Date | DT | 8 |
196 | Start_Required_Date | Start Required Date | Date | DT | 8 |
197 | STTLOCID | Start Location ID | String | STR15_Location_ID | 15 |
198 | STRCTDT | Start Receipt Date | Date | DT | 8 |
199 | STARTBUYERID | Start Buyer ID | String | STR15_User_ID | 15 |
200 | STARTLINEORIGIN | Start Line Origin | Integer | DDL_Line_Origin | 0 |
201 | STARTRELEASEBYDATE | Start Release By Date | Date | DATE_L | 0 |
202 | PASTTCOSTID | PA Start Cost Category ID | String | STR15_Cost_Category_ID | 15 |
203 | STTACNCD | Start Audit Control Code | String | STR13_LBAU | 13 |