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