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

azurecurve Products Project Accounting (258)ProjectPA Project Series Report Options (PA70101)

Leave a Reply Cancel reply