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 TypeSQL DB LengthKeyable Length
1RPTGRIND SearchReport Group IndexINTInteger20
2RTPACHIN SearchReport Palette Choice IndexINTInteger20
3RTGRSBIN SearchReport Group Sub IndexDLR14Currency1014
4ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean20
5EXPTTYPE SearchExport TypeINTInteger20
6FILEXPNM SearchFile Export NameSTR255String256255
7IFFILXST SearchIf File ExistingGBInteger20
8FINRPTNM SearchFinancial Report NameSTR30String3230
9PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean20
10PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean20
11PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean20
12SORTBY SearchSort ByDDL_Sort_ByInteger20
13SORTBY2 SearchSort By 2DDL_Sort_ByInteger20
14HISTTYPE SearchHistory TypeGBInteger20
15PYMNTDAT SearchPayment DateDTDate48
16VOIDONLY SearchVoided OnlyCB_Voided_OnlyBoolean20
17EXCLVOID SearchExclude VoidedCB_Exclude_VoidedBoolean20
18Include_Canceled SearchInclude CanceledCB_CanceledBoolean20
19DATEOVERDUE SearchDate OverdueDTDate48
20Days_Overdue SearchDays OverdueCB_Days_OverdueBoolean20
21POP_Date_Selection SearchPOP_Date_SelectionDDL_POP_DATE_SELECTIONInteger20
22Include_Closed SearchInclude ClosedCB_ClosedBoolean20
23Include_Released SearchInclude ReleasedCB_ReleasedBoolean20
24AGEBY SearchAge ByGB_Age_ByInteger20
25COMPTYPE SearchCompare TypePOP_PO_Compare_TypeInteger20
26STVNDRID SearchStart Vendor IDSTR15_LBUString1615
27STVNDNAM SearchStart Vendor NameSTR64_Vendor_NameString6664
28STVNDCLS SearchStart Vendor ClassSTR10_LBUString1210
29STTSTATE SearchStart StateSTR30_StateString3029
30STRTZPCD SearchStart Zip CodeSTR10String1210
31STRTPHON SearchStart PhonePhone_NumberString2214
32STRTUDEF SearchStart User DefinedSTR20String2220
33STTCNTCT SearchStart ContactSTR60String6260
34Start_PO_Date SearchStart PO DateDTDate48
35STTSHNAM SearchStart Short NameSTR15String1615
36STTLOCID SearchStart Location IDSTR15_Location_IDString1615
37Start_Promised_Date SearchStart Promised DateDTDate48
38Start_Required_Date SearchStart Required DateDTDate48
39STVNSTUS SearchStart Vendor StatusDDL_Vendor_StatusInteger20
40STT1099T SearchStart 1099 Type1099_TypeInteger20
41STPERIOD SearchStart PeriodINT_STORAGEInteger20
42STRTYEAR SearchStart YearYearInteger24
43STTABYTD SearchStart Amount Billed YTDDLR19_RBS0_STR$Currency1019
44STRTPRTY SearchStart PrioritySTR3String43
45STTDUEDT SearchStart Due DateDTDate48
46STDISCDT SearchStart Discount DateDTDate48
47ALORANGE SearchAll Or RangeGBInteger20
48STTACNCD SearchStart Audit Control CodeSTR13_LBAUString1413
49STDOCNUM SearchStart Document NumberSTR20String2220
50STTDOCDT SearchStart Document DateDTDate48
51STDOCTYP SearchStart Document TypeINT1Integer21
52STVCHNUM SearchStart Voucher NumberSTR20_LBAUString2220
53STTITNUM SearchStart Item NumberSTR30_Item_NumberString3230
54STCHKNUM SearchStart Check NumberSTR20String2220
55STTCHKDT SearchStart Check DateDTDate48
56STCHBKID SearchStart Checkbook IDSTR15_LBUString1615
57STBCHSRC SearchStart Batch SourceSTR15String1615
58STBCHNUM SearchStart Batch NumberSTR15_LBAUString1615
59STPSTDDT SearchStart Posted DateDTDate48
60STCLSDSC SearchStart Class DescriptionSTR30String3230
61ENDVNDID SearchEnd Vendor IDSTR15_LBUString1615
62ENDVNDNM SearchEnd Vendor NameSTR64_Vendor_NameString6664
63ENDVNCLS SearchEnd Vendor ClassSTR10_LBUString1210
64ENDSTATE SearchEnd StateSTR30_StateString3029
65ENDZIPCD SearchEnd Zip CodeSTR10String1210
66ENPHONBR SearchEnd Phone NumberPhone_NumberString2214
67End_PO_Date SearchEnd PO DateDTDate48
68ENUSRDEF SearchEnd User DefinedSTR20String2220
69ENDLOCID SearchEnd Location IDSTR15_Location_IDString1615
70ENITMNBR SearchEnd Item NumberSTR30_Item_NumberString3230
71End_Required_Date SearchEnd Required DateDTDate48
72End_Promised_Date SearchEnd Promised DateDTDate48
73ENDVNDCT SearchEnd Vendor ContactSTR60String6260
74ENDSHNAM SearchEnd Short NameSTR15String1615
75ENVNSTTS SearchEnd Vendor StatusDDL_Vendor_StatusInteger20
76E1099TYP SearchEnd 1099 Type1099_TypeInteger20
77ENDPEROD SearchEnd PeriodINT_STORAGEInteger20
78ENDYEAR SearchEnd YearYearInteger24
79ENAMBYTD SearchEnd Amount Billed YTDDLR19_RBS0_STR$Currency1019
80ENPRYRTY SearchEnd PrioritySTR3String43
81ENDDUEDT SearchEnd Due DateDTDate48
82ENDISCDT SearchEnd Discount DateDTDate48
83ALORNGE2 SearchAll Or Range2GBInteger20
84ENAUCNCD SearchEnd Audit Control CodeSTR13_LBAUString1413
85ENDOCNUM SearchEnd Document NumberSTR20String2220
86ENDDOCDT SearchEnd Document DateDTDate48
87ENDOCTYP SearchEnd Document TypeINT1Integer21
88ENVCHNUM SearchEnd Voucher NumberSTR20_LBAUString2220
89ENCHKNUM SearchEnd Check NumberSTR20String2220
90ENDCHKDT SearchEnd Check DateDTDate48
91ENCHBKID SearchEnd Checkbook IDSTR15_LBUString1615
92ENBCHSRC SearchEnd Batch SourceSTR15String1615
93ENDBNMBR SearchEnd Batch NumberSTR15_LBAUString1615
94ENPSTDDT SearchEnd Posted DateDTDate48
95ENCLDSCR SearchEnd Class DescriptionSTR30String3230
96AGNGDATE SearchAging DateDTDate48
97PBSDCDTK SearchPayables Start Document Date TokenDDL_Payables_Complete_Date_TokensInteger20
98PBSDUDTK SearchPayables Start Due Date TokenDDL_Payables_Complete_Date_TokensInteger20
99PBSDSDTK SearchPayables Start Discount Date TokenDDL_Payables_Complete_Date_TokensInteger20
100PBSCHDTK SearchPayables Start Check Date TokenDDL_Payables_Complete_Date_TokensInteger20
101PBSPTDTK SearchPayables Start Posted Date TokenDDL_Payables_Complete_Date_TokensInteger20
102PBEDCDTK SearchPayables End Document Date TokenDDL_Payables_Complete_Date_TokensInteger20
103PBEDUDTK SearchPayables End Due Date TokenDDL_Payables_Complete_Date_TokensInteger20
104PBEDSDTK SearchPayables End Discount Date TokenDDL_Payables_Complete_Date_TokensInteger20
105PBECHDTK SearchPayables End Check Date TokenDDL_Payables_Complete_Date_TokensInteger20
106PBEPDTKN SearchPayables End Posted Date TokenDDL_Payables_Complete_Date_TokensInteger20
107PBCDTTKN SearchPayables Complete Date TokensDDL_Payables_Complete_Date_TokensInteger20
108DETLDRPT SearchDetailed ReportCB_Detailed_ReportBoolean20
109SINGACT SearchSingle AccountBooleanBoolean20
110STTACNUM SearchStart Account NumberAccount_NumberComposite 8080
111STTACNUM_1 SearchStart Account Number:Account_Segment_Pool1Account_Segment_Pool1String86
112STTACNUM_2 SearchStart Account Number:Account_Segment_Pool2Account_Segment_Pool2String86
113STTACNUM_3 SearchStart Account Number:Account_Segment_Pool3Account_Segment_Pool3String86
114STTACNUM_4 SearchStart Account Number:Account_Segment_Pool4Account_Segment_Pool4String86
115STTACNUM_5 SearchStart Account Number:Account_Segment_Pool5Account_Segment_Pool5String86
116STTACNUM_6 SearchStart Account Number:Account_Segment_Pool6Account_Segment_Pool6String86
117STTACNUM_7 SearchStart Account Number:Account_Segment_Pool7Account_Segment_Pool7String86
118STTACNUM_8 SearchStart Account Number:Account_Segment_Pool8Account_Segment_Pool8String86
119STTACNUM_9 SearchStart Account Number:Account_Segment_Pool9Account_Segment_Pool9String86
120STTACNUM_10 SearchStart Account Number:Account_Segment_Pool10Account_Segment_Pool10String86
121EACCNBR SearchEnd Account NumberAccount_NumberComposite 8080
122EACCNBR_1 SearchEnd Account Number:Account_Segment_Pool1Account_Segment_Pool1String86
123EACCNBR_2 SearchEnd Account Number:Account_Segment_Pool2Account_Segment_Pool2String86
124EACCNBR_3 SearchEnd Account Number:Account_Segment_Pool3Account_Segment_Pool3String86
125EACCNBR_4 SearchEnd Account Number:Account_Segment_Pool4Account_Segment_Pool4String86
126EACCNBR_5 SearchEnd Account Number:Account_Segment_Pool5Account_Segment_Pool5String86
127EACCNBR_6 SearchEnd Account Number:Account_Segment_Pool6Account_Segment_Pool6String86
128EACCNBR_7 SearchEnd Account Number:Account_Segment_Pool7Account_Segment_Pool7String86
129EACCNBR_8 SearchEnd Account Number:Account_Segment_Pool8Account_Segment_Pool8String86
130EACCNBR_9 SearchEnd Account Number:Account_Segment_Pool9Account_Segment_Pool9String86
131EACCNBR_10 SearchEnd Account Number:Account_Segment_Pool10Account_Segment_Pool10String86
132STRPONUM SearchStart PO NumberSTR17_POP_NumberString1817
133ENDPONUM SearchEnd PO NumberSTR17_POP_NumberString1817
134EndPOPRcptNum SearchEnd POP Receipt NumberSTR17_POP_NumberString1817
135StartPOPRcptNum SearchStart POP Receipt NumberSTR17_POP_NumberString1817
136STRCREAT SearchStart Created ByUser_IDString1615
137STRCTDT SearchStart Receipt DateDTDate48
138ENRCTDT SearchEnd Receipt DateDTDate48
139STRCTNUM SearchStart Receipt NumberSTR20_Document_NumberString2220
140ENRCTNBR SearchEnd Receipt NumberSTR20_Document_NumberString2220
141ENDCREATE SearchEnd Created ByUser_IDString1615
142STRPOSTA SearchStart PO StatusDDL_PO_StatusInteger20
143ENDPOSTA SearchEnd PO StatusDDL_PO_StatusInteger20
144INCRCPTS SearchInclude ReceiptsCB_ReceiptsBoolean20
145DISSRLOT SearchDisplay Serial/Lot NumberCB_Serial_Lot_NumberBoolean20
146STRXSRC SearchStart TRX SourceSTR13String1413
147ENTRXSRC SearchEnd TRX SourceSTR13String1413
148CRBLNCCB SearchCredit Balance CBCBBoolean20
149FLLYPDCB SearchFully Paid CBCBBoolean20
150ZROBALCB SearchZero Balance CBCBBoolean20
151EXCLZBAL SearchExclude Zero BalanceCB_Zero_BalanceBoolean20
152NOACTVCB SearchNo Activity CBCBBoolean20
153Unposted_Applied_CR_Docs SearchUnposted Applied Credit Documents CBCBBoolean20
154Multicurrency_Information SearchMulticurrency Information CBCB_Include_Multicurrency_InfoBoolean20
155Include_Distribution_Typ SearchInclude Distribution TypeMS_Include_Distribution_TypeLong Integer40
156RPTXRATE SearchReporting Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
157RPRTCLMD SearchReporting Rate Calculation MethodDDL_Rate_Calculation_MethodInteger20
158PRTCURIN SearchPrint Currency InGBInteger20
159INCLFUNC SearchInclude Functional CurrencyCB_Functional_CurrencyBoolean20
160STARTLINEORIGIN SearchStart Line OriginDDL_Line_OriginInteger20
161ENDLINEORIGIN SearchEnd Line OriginDDL_Line_OriginInteger20
162STARTBUYERID SearchStart Buyer IDSTR15_User_IDString1615
163ENDBUYERID SearchEnd Buyer IDSTR15_User_IDString1615
164INCLUDEHOLDPO SearchInclude Hold POCB_Include_PO_HoldBoolean20
165INCLUDEHOLDPOONLY SearchInclude Hold PO OnlyCB_Include_PO_On_Hold_OnlyBoolean20
166STARTRELEASEBYDATE SearchStart Release By DateDATE_LDate40
167ENDRELEASEBYDATE SearchEnd Release By DateDATE_LDate40
168Include_New SearchInclude NewCB_NewBoolean20
169Include_Change_Order SearchInclude Change OrderCB_Change_OrderBoolean20
170Include_Received SearchInclude ReceivedCB_ReceivedBoolean20
171SummaryYear SearchSummary YearYearInteger24
172DateSensitivitySumSelect SearchDate Sensitivity Summary SelectGBInteger20
173StartProjNum SearchStart Project NumberSTR15_LBAUString1615
174EndProjNum SearchEnd Project NumberSTR15_LBAUString1615
175StartCostCatID SearchStart Cost Category IDSTR15_LBAUString1615
176EndCostCatID SearchEnd Cost Category IDSTR15_LBAUString1615
177IncludeApprovedPOsOnly SearchInclude Approved POs OnlyCB_IncludeApprovedPOsOnlyBoolean20
178MISC SearchMiscCB_MiscBoolean20
179INTEREST SearchInterestCB_InterestBoolean20
180DIVIDEND SearchDividendCB_DividendBoolean20
181DEX_ROW_ID Searchintint1010

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.

Leave a Reply

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