Purchasing 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 NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1RPTGRIND SearchReport Group IndexIntegerINT0
2RTPACHIN SearchReport Palette Choice IndexIntegerINT0
3RTGRSBIN SearchReport Group Sub IndexCurrencyDLR1414
4ASKECHTM SearchAsk Each TimeBooleanCB_Ask_Each_Time0
5EXPTTYPE SearchExport TypeIntegerINT0
6FILEXPNM SearchFile Export NameStringSTR255255
7IFFILXST SearchIf File ExistingIntegerGB0
8FINRPTNM SearchFinancial Report NameStringSTR3030
9PRNTOFIL SearchPrint to FileBooleanCB_Print_to_File0
10PRTOPRTR SearchPrint to PrinterBooleanCB_Print_to_Printer0
11PRTOSCRN SearchPrint to ScreenBooleanCB_Print_to_Screen0
12SORTBY SearchSort ByIntegerDDL_Sort_By0
13SORTBY2 SearchSort By 2IntegerDDL_Sort_By0
14HISTTYPE SearchHistory TypeIntegerGB0
15PYMNTDAT SearchPayment DateDateDT8
16VOIDONLY SearchVoided OnlyBooleanCB_Voided_Only0
17EXCLVOID SearchExclude VoidedBooleanCB_Exclude_Voided0
18Include_Canceled SearchInclude CanceledBooleanCB_Canceled0
19DATEOVERDUE SearchDate OverdueDateDT8
20Days_Overdue SearchDays OverdueBooleanCB_Days_Overdue0
21POP_Date_Selection SearchPOP_Date_SelectionIntegerDDL_POP_DATE_SELECTION0
22Include_Closed SearchInclude ClosedBooleanCB_Closed0
23Include_Released SearchInclude ReleasedBooleanCB_Released0
24AGEBY SearchAge ByIntegerGB_Age_By0
25COMPTYPE SearchCompare TypeIntegerPOP_PO_Compare_Type0
26STVNDRID SearchStart Vendor IDStringSTR15_LBU15
27STVNDNAM SearchStart Vendor NameStringSTR64_Vendor_Name64
28STVNDCLS SearchStart Vendor ClassStringSTR10_LBU10
29STTSTATE SearchStart StateStringSTR30_State29
30STRTZPCD SearchStart Zip CodeStringSTR1010
31STRTPHON SearchStart PhoneStringPhone_Number14
32STRTUDEF SearchStart User DefinedStringSTR2020
33STTCNTCT SearchStart ContactStringSTR6060
34Start_PO_Date SearchStart PO DateDateDT8
35STTSHNAM SearchStart Short NameStringSTR1515
36STTLOCID SearchStart Location IDStringSTR15_Location_ID15
37Start_Promised_Date SearchStart Promised DateDateDT8
38Start_Required_Date SearchStart Required DateDateDT8
39STVNSTUS SearchStart Vendor StatusIntegerDDL_Vendor_Status0
40STT1099T SearchStart 1099 TypeInteger1099_Type0
41STPERIOD SearchStart PeriodIntegerINT_STORAGE0
42STRTYEAR SearchStart YearIntegerYear4
43STTABYTD SearchStart Amount Billed YTDCurrencyDLR19_RBS0_STR$19
44STRTPRTY SearchStart PriorityStringSTR33
45STTDUEDT SearchStart Due DateDateDT8
46STDISCDT SearchStart Discount DateDateDT8
47ALORANGE SearchAll Or RangeIntegerGB0
48STTACNCD SearchStart Audit Control CodeStringSTR13_LBAU13
49STDOCNUM SearchStart Document NumberStringSTR2020
50STTDOCDT SearchStart Document DateDateDT8
51STDOCTYP SearchStart Document TypeIntegerINT11
52STVCHNUM SearchStart Voucher NumberStringSTR20_LBAU20
53STTITNUM SearchStart Item NumberStringSTR30_Item_Number30
54STCHKNUM SearchStart Check NumberStringSTR2020
55STTCHKDT SearchStart Check DateDateDT8
56STCHBKID SearchStart Checkbook IDStringSTR15_LBU15
57STBCHSRC SearchStart Batch SourceStringSTR1515
58STBCHNUM SearchStart Batch NumberStringSTR15_LBAU15
59STPSTDDT SearchStart Posted DateDateDT8
60STCLSDSC SearchStart Class DescriptionStringSTR3030
61ENDVNDID SearchEnd Vendor IDStringSTR15_LBU15
62ENDVNDNM SearchEnd Vendor NameStringSTR64_Vendor_Name64
63ENDVNCLS SearchEnd Vendor ClassStringSTR10_LBU10
64ENDSTATE SearchEnd StateStringSTR30_State29
65ENDZIPCD SearchEnd Zip CodeStringSTR1010
66ENPHONBR SearchEnd Phone NumberStringPhone_Number14
67End_PO_Date SearchEnd PO DateDateDT8
68ENUSRDEF SearchEnd User DefinedStringSTR2020
69ENDLOCID SearchEnd Location IDStringSTR15_Location_ID15
70ENITMNBR SearchEnd Item NumberStringSTR30_Item_Number30
71End_Required_Date SearchEnd Required DateDateDT8
72End_Promised_Date SearchEnd Promised DateDateDT8
73ENDVNDCT SearchEnd Vendor ContactStringSTR6060
74ENDSHNAM SearchEnd Short NameStringSTR1515
75ENVNSTTS SearchEnd Vendor StatusIntegerDDL_Vendor_Status0
76E1099TYP SearchEnd 1099 TypeInteger1099_Type0
77ENDPEROD SearchEnd PeriodIntegerINT_STORAGE0
78ENDYEAR SearchEnd YearIntegerYear4
79ENAMBYTD SearchEnd Amount Billed YTDCurrencyDLR19_RBS0_STR$19
80ENPRYRTY SearchEnd PriorityStringSTR33
81ENDDUEDT SearchEnd Due DateDateDT8
82ENDISCDT SearchEnd Discount DateDateDT8
83ALORNGE2 SearchAll Or Range2IntegerGB0
84ENAUCNCD SearchEnd Audit Control CodeStringSTR13_LBAU13
85ENDOCNUM SearchEnd Document NumberStringSTR2020
86ENDDOCDT SearchEnd Document DateDateDT8
87ENDOCTYP SearchEnd Document TypeIntegerINT11
88ENVCHNUM SearchEnd Voucher NumberStringSTR20_LBAU20
89ENCHKNUM SearchEnd Check NumberStringSTR2020
90ENDCHKDT SearchEnd Check DateDateDT8
91ENCHBKID SearchEnd Checkbook IDStringSTR15_LBU15
92ENBCHSRC SearchEnd Batch SourceStringSTR1515
93ENDBNMBR SearchEnd Batch NumberStringSTR15_LBAU15
94ENPSTDDT SearchEnd Posted DateDateDT8
95ENCLDSCR SearchEnd Class DescriptionStringSTR3030
96AGNGDATE SearchAging DateDateDT8
97PBSDCDTK SearchPayables Start Document Date TokenIntegerDDL_Payables_Complete_Date_Tokens0
98PBSDUDTK SearchPayables Start Due Date TokenIntegerDDL_Payables_Complete_Date_Tokens0
99PBSDSDTK SearchPayables Start Discount Date TokenIntegerDDL_Payables_Complete_Date_Tokens0
100PBSCHDTK SearchPayables Start Check Date TokenIntegerDDL_Payables_Complete_Date_Tokens0
101PBSPTDTK SearchPayables Start Posted Date TokenIntegerDDL_Payables_Complete_Date_Tokens0
102PBEDCDTK SearchPayables End Document Date TokenIntegerDDL_Payables_Complete_Date_Tokens0
103PBEDUDTK SearchPayables End Due Date TokenIntegerDDL_Payables_Complete_Date_Tokens0
104PBEDSDTK SearchPayables End Discount Date TokenIntegerDDL_Payables_Complete_Date_Tokens0
105PBECHDTK SearchPayables End Check Date TokenIntegerDDL_Payables_Complete_Date_Tokens0
106PBEPDTKN SearchPayables End Posted Date TokenIntegerDDL_Payables_Complete_Date_Tokens0
107PBCDTTKN SearchPayables Complete Date TokensIntegerDDL_Payables_Complete_Date_Tokens0
108DETLDRPT SearchDetailed ReportBooleanCB_Detailed_Report0
109SINGACT SearchSingle AccountBooleanBoolean0
110STTACNUM SearchStart Account NumberAccount_NumberComposite 80
111STTACNUM_1 SearchStart Account Number:Account_Segment_Pool1StringAccount_Segment_Pool16
112STTACNUM_2 SearchStart Account Number:Account_Segment_Pool2StringAccount_Segment_Pool26
113STTACNUM_3 SearchStart Account Number:Account_Segment_Pool3StringAccount_Segment_Pool36
114STTACNUM_4 SearchStart Account Number:Account_Segment_Pool4StringAccount_Segment_Pool46
115STTACNUM_5 SearchStart Account Number:Account_Segment_Pool5StringAccount_Segment_Pool56
116STTACNUM_6 SearchStart Account Number:Account_Segment_Pool6StringAccount_Segment_Pool66
117STTACNUM_7 SearchStart Account Number:Account_Segment_Pool7StringAccount_Segment_Pool76
118STTACNUM_8 SearchStart Account Number:Account_Segment_Pool8StringAccount_Segment_Pool86
119STTACNUM_9 SearchStart Account Number:Account_Segment_Pool9StringAccount_Segment_Pool96
120STTACNUM_10 SearchStart Account Number:Account_Segment_Pool10StringAccount_Segment_Pool106
121EACCNBR_1 SearchEnd Account Number:Account_Segment_Pool1StringAccount_Segment_Pool16
122EACCNBR SearchEnd Account NumberAccount_NumberComposite 80
123EACCNBR_2 SearchEnd Account Number:Account_Segment_Pool2StringAccount_Segment_Pool26
124EACCNBR_3 SearchEnd Account Number:Account_Segment_Pool3StringAccount_Segment_Pool36
125EACCNBR_4 SearchEnd Account Number:Account_Segment_Pool4StringAccount_Segment_Pool46
126EACCNBR_5 SearchEnd Account Number:Account_Segment_Pool5StringAccount_Segment_Pool56
127EACCNBR_6 SearchEnd Account Number:Account_Segment_Pool6StringAccount_Segment_Pool66
128EACCNBR_7 SearchEnd Account Number:Account_Segment_Pool7StringAccount_Segment_Pool76
129EACCNBR_8 SearchEnd Account Number:Account_Segment_Pool8StringAccount_Segment_Pool86
130EACCNBR_9 SearchEnd Account Number:Account_Segment_Pool9StringAccount_Segment_Pool96
131EACCNBR_10 SearchEnd Account Number:Account_Segment_Pool10StringAccount_Segment_Pool106
132STRPONUM SearchStart PO NumberStringSTR17_POP_Number17
133ENDPONUM SearchEnd PO NumberStringSTR17_POP_Number17
134EndPOPRcptNum SearchEnd POP Receipt NumberStringSTR17_POP_Number17
135StartPOPRcptNum SearchStart POP Receipt NumberStringSTR17_POP_Number17
136STRCREAT SearchStart Created ByStringUser_ID15
137STRCTDT SearchStart Receipt DateDateDT8
138ENRCTDT SearchEnd Receipt DateDateDT8
139STRCTNUM SearchStart Receipt NumberStringSTR20_Document_Number20
140ENRCTNBR SearchEnd Receipt NumberStringSTR20_Document_Number20
141ENDCREATE SearchEnd Created ByStringUser_ID15
142STRPOSTA SearchStart PO StatusIntegerDDL_PO_Status0
143ENDPOSTA SearchEnd PO StatusIntegerDDL_PO_Status0
144INCRCPTS SearchInclude ReceiptsBooleanCB_Receipts0
145DISSRLOT SearchDisplay Serial/Lot NumberBooleanCB_Serial_Lot_Number0
146STRXSRC SearchStart TRX SourceStringSTR1313
147ENTRXSRC SearchEnd TRX SourceStringSTR1313
148CRBLNCCB SearchCredit Balance CBBooleanCB0
149FLLYPDCB SearchFully Paid CBBooleanCB0
150ZROBALCB SearchZero Balance CBBooleanCB0
151EXCLZBAL SearchExclude Zero BalanceBooleanCB_Zero_Balance0
152NOACTVCB SearchNo Activity CBBooleanCB0
153Unposted_Applied_CR_Docs SearchUnposted Applied Credit Documents CBBooleanCB0
154Multicurrency_Information SearchMulticurrency Information CBBooleanCB_Include_Multicurrency_Info0
155Include_Distribution_Typ SearchInclude Distribution TypeLong IntegerMS_Include_Distribution_Type0
156RPTXRATE SearchReporting Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
157RPRTCLMD SearchReporting Rate Calculation MethodIntegerDDL_Rate_Calculation_Method0
158PRTCURIN SearchPrint Currency InIntegerGB0
159INCLFUNC SearchInclude Functional CurrencyBooleanCB_Functional_Currency0
160STARTLINEORIGIN SearchStart Line OriginIntegerDDL_Line_Origin0
161ENDLINEORIGIN SearchEnd Line OriginIntegerDDL_Line_Origin0
162STARTBUYERID SearchStart Buyer IDStringSTR15_User_ID15
163ENDBUYERID SearchEnd Buyer IDStringSTR15_User_ID15
164INCLUDEHOLDPO SearchInclude Hold POBooleanCB_Include_PO_Hold0
165INCLUDEHOLDPOONLY SearchInclude Hold PO OnlyBooleanCB_Include_PO_On_Hold_Only0
166STARTRELEASEBYDATE SearchStart Release By DateDateDATE_L0
167ENDRELEASEBYDATE SearchEnd Release By DateDateDATE_L0
168Include_New SearchInclude NewBooleanCB_New0
169Include_Change_Order SearchInclude Change OrderBooleanCB_Change_Order0
170Include_Received SearchInclude ReceivedBooleanCB_Received0
171SummaryYear SearchSummary YearIntegerYear4
172DateSensitivitySumSelect SearchDate Sensitivity Summary SelectIntegerGB0
173StartProjNum SearchStart Project NumberStringSTR15_LBAU15
174EndProjNum SearchEnd Project NumberStringSTR15_LBAU15
175StartCostCatID SearchStart Cost Category IDStringSTR15_LBAU15
176EndCostCatID SearchEnd Cost Category IDStringSTR15_LBAU15
177IncludeApprovedPOsOnly SearchInclude Approved POs OnlyBooleanCB_IncludeApprovedPOsOnly0
178MISC SearchMiscBooleanCB_Misc0
179INTEREST SearchInterestBooleanCB_Interest0
180DIVIDEND SearchDividendBooleanCB_Dividend0

Leave a Reply

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