Purchasing Report Options (PM70500)

azurecurve Products Microsoft Dynamics GP (0)PurchasingPurchasing Report Options (PM70500)

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

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: Purchasing Report Options
Physical Name: PM70500
Technical Name: PM_Options_ROPT

Group Display Name: Payables Report Options Logical File
Group Technical Name: PM_Reports_Options_Logical_Files

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	ASKECHTM	Ask Each Time	Boolean	CB_Ask_Each_Time	0
5	EXPTTYPE	Export Type	Integer	INT	0
6	FILEXPNM	File Export Name	String	STR255	255
7	IFFILXST	If File Existing	Integer	GB	0
8	FINRPTNM	Financial Report Name	String	STR30	30
9	PRNTOFIL	Print to File	Boolean	CB_Print_to_File	0
10	PRTOPRTR	Print to Printer	Boolean	CB_Print_to_Printer	0
11	PRTOSCRN	Print to Screen	Boolean	CB_Print_to_Screen	0
12	SORTBY	Sort By	Integer	DDL_Sort_By	0
13	SORTBY2	Sort By 2	Integer	DDL_Sort_By	0
14	HISTTYPE	History Type	Integer	GB	0
15	PYMNTDAT	Payment Date	Date	DT	8
16	VOIDONLY	Voided Only	Boolean	CB_Voided_Only	0
17	EXCLVOID	Exclude Voided	Boolean	CB_Exclude_Voided	0
18	Include_Canceled	Include Canceled	Boolean	CB_Canceled	0
19	DATEOVERDUE	Date Overdue	Date	DT	8
20	Days_Overdue	Days Overdue	Boolean	CB_Days_Overdue	0
21	POP_Date_Selection	POP_Date_Selection	Integer	DDL_POP_DATE_SELECTION	0
22	Include_Closed	Include Closed	Boolean	CB_Closed	0
23	Include_Released	Include Released	Boolean	CB_Released	0
24	AGEBY	Age By	Integer	GB_Age_By	0
25	COMPTYPE	Compare Type	Integer	POP_PO_Compare_Type	0
26	STVNDRID	Start Vendor ID	String	STR15_LBU	15
27	STVNDNAM	Start Vendor Name	String	STR64_Vendor_Name	64
28	STVNDCLS	Start Vendor Class	String	STR10_LBU	10
29	STTSTATE	Start State	String	STR30_State	29
30	STRTZPCD	Start Zip Code	String	STR10	10
31	STRTPHON	Start Phone	String	Phone_Number	14
32	STRTUDEF	Start User Defined	String	STR20	20
33	STTCNTCT	Start Contact	String	STR60	60
34	Start_PO_Date	Start PO Date	Date	DT	8
35	STTSHNAM	Start Short Name	String	STR15	15
36	STTLOCID	Start Location ID	String	STR15_Location_ID	15
37	Start_Promised_Date	Start Promised Date	Date	DT	8
38	Start_Required_Date	Start Required Date	Date	DT	8
39	STVNSTUS	Start Vendor Status	Integer	DDL_Vendor_Status	0
40	STT1099T	Start 1099 Type	Integer	1099_Type	0
41	STPERIOD	Start Period	Integer	INT_STORAGE	0
42	STRTYEAR	Start Year	Integer	Year	4
43	STTABYTD	Start Amount Billed YTD	Currency	DLR19_RBS0_STR$	19
44	STRTPRTY	Start Priority	String	STR3	3
45	STTDUEDT	Start Due Date	Date	DT	8
46	STDISCDT	Start Discount Date	Date	DT	8
47	ALORANGE	All Or Range	Integer	GB	0
48	STTACNCD	Start Audit Control Code	String	STR13_LBAU	13
49	STDOCNUM	Start Document Number	String	STR20	20
50	STTDOCDT	Start Document Date	Date	DT	8
51	STDOCTYP	Start Document Type	Integer	INT1	1
52	STVCHNUM	Start Voucher Number	String	STR20_LBAU	20
53	STTITNUM	Start Item Number	String	STR30_Item_Number	30
54	STCHKNUM	Start Check Number	String	STR20	20
55	STTCHKDT	Start Check Date	Date	DT	8
56	STCHBKID	Start Checkbook ID	String	STR15_LBU	15
57	STBCHSRC	Start Batch Source	String	STR15	15
58	STBCHNUM	Start Batch Number	String	STR15_LBAU	15
59	STPSTDDT	Start Posted Date	Date	DT	8
60	STCLSDSC	Start Class Description	String	STR30	30
61	ENDVNDID	End Vendor ID	String	STR15_LBU	15
62	ENDVNDNM	End Vendor Name	String	STR64_Vendor_Name	64
63	ENDVNCLS	End Vendor Class	String	STR10_LBU	10
64	ENDSTATE	End State	String	STR30_State	29
65	ENDZIPCD	End Zip Code	String	STR10	10
66	ENPHONBR	End Phone Number	String	Phone_Number	14
67	End_PO_Date	End PO Date	Date	DT	8
68	ENUSRDEF	End User Defined	String	STR20	20
69	ENDLOCID	End Location ID	String	STR15_Location_ID	15
70	ENITMNBR	End Item Number	String	STR30_Item_Number	30
71	End_Required_Date	End Required Date	Date	DT	8
72	End_Promised_Date	End Promised Date	Date	DT	8
73	ENDVNDCT	End Vendor Contact	String	STR60	60
74	ENDSHNAM	End Short Name	String	STR15	15
75	ENVNSTTS	End Vendor Status	Integer	DDL_Vendor_Status	0
76	E1099TYP	End 1099 Type	Integer	1099_Type	0
77	ENDPEROD	End Period	Integer	INT_STORAGE	0
78	ENDYEAR	End Year	Integer	Year	4
79	ENAMBYTD	End Amount Billed YTD	Currency	DLR19_RBS0_STR$	19
80	ENPRYRTY	End Priority	String	STR3	3
81	ENDDUEDT	End Due Date	Date	DT	8
82	ENDISCDT	End Discount Date	Date	DT	8
83	ALORNGE2	All Or Range2	Integer	GB	0
84	ENAUCNCD	End Audit Control Code	String	STR13_LBAU	13
85	ENDOCNUM	End Document Number	String	STR20	20
86	ENDDOCDT	End Document Date	Date	DT	8
87	ENDOCTYP	End Document Type	Integer	INT1	1
88	ENVCHNUM	End Voucher Number	String	STR20_LBAU	20
89	ENCHKNUM	End Check Number	String	STR20	20
90	ENDCHKDT	End Check Date	Date	DT	8
91	ENCHBKID	End Checkbook ID	String	STR15_LBU	15
92	ENBCHSRC	End Batch Source	String	STR15	15
93	ENDBNMBR	End Batch Number	String	STR15_LBAU	15
94	ENPSTDDT	End Posted Date	Date	DT	8
95	ENCLDSCR	End Class Description	String	STR30	30
96	AGNGDATE	Aging Date	Date	DT	8
97	PBSDCDTK	Payables Start Document Date Token	Integer	DDL_Payables_Complete_Date_Tokens	0
98	PBSDUDTK	Payables Start Due Date Token	Integer	DDL_Payables_Complete_Date_Tokens	0
99	PBSDSDTK	Payables Start Discount Date Token	Integer	DDL_Payables_Complete_Date_Tokens	0
100	PBSCHDTK	Payables Start Check Date Token	Integer	DDL_Payables_Complete_Date_Tokens	0
101	PBSPTDTK	Payables Start Posted Date Token	Integer	DDL_Payables_Complete_Date_Tokens	0
102	PBEDCDTK	Payables End Document Date Token	Integer	DDL_Payables_Complete_Date_Tokens	0
103	PBEDUDTK	Payables End Due Date Token	Integer	DDL_Payables_Complete_Date_Tokens	0
104	PBEDSDTK	Payables End Discount Date Token	Integer	DDL_Payables_Complete_Date_Tokens	0
105	PBECHDTK	Payables End Check Date Token	Integer	DDL_Payables_Complete_Date_Tokens	0
106	PBEPDTKN	Payables End Posted Date Token	Integer	DDL_Payables_Complete_Date_Tokens	0
107	PBCDTTKN	Payables Complete Date Tokens	Integer	DDL_Payables_Complete_Date_Tokens	0
108	DETLDRPT	Detailed Report	Boolean	CB_Detailed_Report	0
109	SINGACT	Single Account	Boolean	Boolean	0
110	STTACNUM	Start Account Number	Account_Number	Composite	80
111	STTACNUM_1	Start Account Number:Account_Segment_Pool1	String	Account_Segment_Pool1	6
112	STTACNUM_2	Start Account Number:Account_Segment_Pool2	String	Account_Segment_Pool2	6
113	STTACNUM_3	Start Account Number:Account_Segment_Pool3	String	Account_Segment_Pool3	6
114	STTACNUM_4	Start Account Number:Account_Segment_Pool4	String	Account_Segment_Pool4	6
115	STTACNUM_5	Start Account Number:Account_Segment_Pool5	String	Account_Segment_Pool5	6
116	STTACNUM_6	Start Account Number:Account_Segment_Pool6	String	Account_Segment_Pool6	6
117	STTACNUM_7	Start Account Number:Account_Segment_Pool7	String	Account_Segment_Pool7	6
118	STTACNUM_8	Start Account Number:Account_Segment_Pool8	String	Account_Segment_Pool8	6
119	STTACNUM_9	Start Account Number:Account_Segment_Pool9	String	Account_Segment_Pool9	6
120	STTACNUM_10	Start Account Number:Account_Segment_Pool10	String	Account_Segment_Pool10	6
121	EACCNBR_1	End Account Number:Account_Segment_Pool1	String	Account_Segment_Pool1	6
122	EACCNBR	End Account Number	Account_Number	Composite	80
123	EACCNBR_2	End Account Number:Account_Segment_Pool2	String	Account_Segment_Pool2	6
124	EACCNBR_3	End Account Number:Account_Segment_Pool3	String	Account_Segment_Pool3	6
125	EACCNBR_4	End Account Number:Account_Segment_Pool4	String	Account_Segment_Pool4	6
126	EACCNBR_5	End Account Number:Account_Segment_Pool5	String	Account_Segment_Pool5	6
127	EACCNBR_6	End Account Number:Account_Segment_Pool6	String	Account_Segment_Pool6	6
128	EACCNBR_7	End Account Number:Account_Segment_Pool7	String	Account_Segment_Pool7	6
129	EACCNBR_8	End Account Number:Account_Segment_Pool8	String	Account_Segment_Pool8	6
130	EACCNBR_9	End Account Number:Account_Segment_Pool9	String	Account_Segment_Pool9	6
131	EACCNBR_10	End Account Number:Account_Segment_Pool10	String	Account_Segment_Pool10	6
132	STRPONUM	Start PO Number	String	STR17_POP_Number	17
133	ENDPONUM	End PO Number	String	STR17_POP_Number	17
134	EndPOPRcptNum	End POP Receipt Number	String	STR17_POP_Number	17
135	StartPOPRcptNum	Start POP Receipt Number	String	STR17_POP_Number	17
136	STRCREAT	Start Created By	String	User_ID	15
137	STRCTDT	Start Receipt Date	Date	DT	8
138	ENRCTDT	End Receipt Date	Date	DT	8
139	STRCTNUM	Start Receipt Number	String	STR20_Document_Number	20
140	ENRCTNBR	End Receipt Number	String	STR20_Document_Number	20
141	ENDCREATE	End Created By	String	User_ID	15
142	STRPOSTA	Start PO Status	Integer	DDL_PO_Status	0
143	ENDPOSTA	End PO Status	Integer	DDL_PO_Status	0
144	INCRCPTS	Include Receipts	Boolean	CB_Receipts	0
145	DISSRLOT	Display Serial/Lot Number	Boolean	CB_Serial_Lot_Number	0
146	STRXSRC	Start TRX Source	String	STR13	13
147	ENTRXSRC	End TRX Source	String	STR13	13
148	CRBLNCCB	Credit Balance CB	Boolean	CB	0
149	FLLYPDCB	Fully Paid CB	Boolean	CB	0
150	ZROBALCB	Zero Balance CB	Boolean	CB	0
151	EXCLZBAL	Exclude Zero Balance	Boolean	CB_Zero_Balance	0
152	NOACTVCB	No Activity CB	Boolean	CB	0
153	Unposted_Applied_CR_Docs	Unposted Applied Credit Documents CB	Boolean	CB	0
154	Multicurrency_Information	Multicurrency Information CB	Boolean	CB_Include_Multicurrency_Info	0
155	Include_Distribution_Typ	Include Distribution Type	Long Integer	MS_Include_Distribution_Type	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	PRTCURIN	Print Currency In	Integer	GB	0
159	INCLFUNC	Include Functional Currency	Boolean	CB_Functional_Currency	0
160	STARTLINEORIGIN	Start Line Origin	Integer	DDL_Line_Origin	0
161	ENDLINEORIGIN	End Line Origin	Integer	DDL_Line_Origin	0
162	STARTBUYERID	Start Buyer ID	String	STR15_User_ID	15
163	ENDBUYERID	End Buyer ID	String	STR15_User_ID	15
164	INCLUDEHOLDPO	Include Hold PO	Boolean	CB_Include_PO_Hold	0
165	INCLUDEHOLDPOONLY	Include Hold PO Only	Boolean	CB_Include_PO_On_Hold_Only	0
166	STARTRELEASEBYDATE	Start Release By Date	Date	DATE_L	0
167	ENDRELEASEBYDATE	End Release By Date	Date	DATE_L	0
168	Include_New	Include New	Boolean	CB_New	0
169	Include_Change_Order	Include Change Order	Boolean	CB_Change_Order	0
170	Include_Received	Include Received	Boolean	CB_Received	0
171	SummaryYear	Summary Year	Integer	Year	4
172	DateSensitivitySumSelect	Date Sensitivity Summary Select	Integer	GB	0
173	StartProjNum	Start Project Number	String	STR15_LBAU	15
174	EndProjNum	End Project Number	String	STR15_LBAU	15
175	StartCostCatID	Start Cost Category ID	String	STR15_LBAU	15
176	EndCostCatID	End Cost Category ID	String	STR15_LBAU	15
177	IncludeApprovedPOsOnly	Include Approved POs Only	Boolean	CB_IncludeApprovedPOsOnly	0
178	MISC	Misc	Boolean	CB_Misc	0
179	INTEREST	Interest	Boolean	CB_Interest	0
180	DIVIDEND	Dividend	Boolean	CB_Dividend	0

azurecurve Products Microsoft Dynamics GP (0)PurchasingPurchasing Report Options (PM70500)

Leave a Reply Cancel reply