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 IndexINTInteger0
2RTPACHIN SearchReport Palette Choice IndexINTInteger0
3RTGRSBIN SearchReport Group Sub IndexDLR14Currency14
4ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean0
5EXPTTYPE SearchExport TypeINTInteger0
6FILEXPNM SearchFile Export NameSTR255String255
7IFFILXST SearchIf File ExistingGBInteger0
8FINRPTNM SearchFinancial Report NameSTR30String30
9PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean0
10PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean0
11PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean0
12SORTBY SearchSort ByDDL_Sort_ByInteger0
13SORTBY2 SearchSort By 2DDL_Sort_ByInteger0
14HISTTYPE SearchHistory TypeGBInteger0
15PYMNTDAT SearchPayment DateDTDate8
16VOIDONLY SearchVoided OnlyCB_Voided_OnlyBoolean0
17EXCLVOID SearchExclude VoidedCB_Exclude_VoidedBoolean0
18Include_Canceled SearchInclude CanceledCB_CanceledBoolean0
19DATEOVERDUE SearchDate OverdueDTDate8
20Days_Overdue SearchDays OverdueCB_Days_OverdueBoolean0
21POP_Date_Selection SearchPOP_Date_SelectionDDL_POP_DATE_SELECTIONInteger0
22Include_Closed SearchInclude ClosedCB_ClosedBoolean0
23Include_Released SearchInclude ReleasedCB_ReleasedBoolean0
24AGEBY SearchAge ByGB_Age_ByInteger0
25COMPTYPE SearchCompare TypePOP_PO_Compare_TypeInteger0
26STVNDRID SearchStart Vendor IDSTR15_LBUString15
27STVNDNAM SearchStart Vendor NameSTR64_Vendor_NameString64
28STVNDCLS SearchStart Vendor ClassSTR10_LBUString10
29STTSTATE SearchStart StateSTR30_StateString29
30STRTZPCD SearchStart Zip CodeSTR10String10
31STRTPHON SearchStart PhonePhone_NumberString14
32STRTUDEF SearchStart User DefinedSTR20String20
33STTCNTCT SearchStart ContactSTR60String60
34Start_PO_Date SearchStart PO DateDTDate8
35STTSHNAM SearchStart Short NameSTR15String15
36STTLOCID SearchStart Location IDSTR15_Location_IDString15
37Start_Promised_Date SearchStart Promised DateDTDate8
38Start_Required_Date SearchStart Required DateDTDate8
39STVNSTUS SearchStart Vendor StatusDDL_Vendor_StatusInteger0
40STT1099T SearchStart 1099 Type1099_TypeInteger0
41STPERIOD SearchStart PeriodINT_STORAGEInteger0
42STRTYEAR SearchStart YearYearInteger4
43STTABYTD SearchStart Amount Billed YTDDLR19_RBS0_STR$Currency19
44STRTPRTY SearchStart PrioritySTR3String3
45STTDUEDT SearchStart Due DateDTDate8
46STDISCDT SearchStart Discount DateDTDate8
47ALORANGE SearchAll Or RangeGBInteger0
48STTACNCD SearchStart Audit Control CodeSTR13_LBAUString13
49STDOCNUM SearchStart Document NumberSTR20String20
50STTDOCDT SearchStart Document DateDTDate8
51STDOCTYP SearchStart Document TypeINT1Integer1
52STVCHNUM SearchStart Voucher NumberSTR20_LBAUString20
53STTITNUM SearchStart Item NumberSTR30_Item_NumberString30
54STCHKNUM SearchStart Check NumberSTR20String20
55STTCHKDT SearchStart Check DateDTDate8
56STCHBKID SearchStart Checkbook IDSTR15_LBUString15
57STBCHSRC SearchStart Batch SourceSTR15String15
58STBCHNUM SearchStart Batch NumberSTR15_LBAUString15
59STPSTDDT SearchStart Posted DateDTDate8
60STCLSDSC SearchStart Class DescriptionSTR30String30
61ENDVNDID SearchEnd Vendor IDSTR15_LBUString15
62ENDVNDNM SearchEnd Vendor NameSTR64_Vendor_NameString64
63ENDVNCLS SearchEnd Vendor ClassSTR10_LBUString10
64ENDSTATE SearchEnd StateSTR30_StateString29
65ENDZIPCD SearchEnd Zip CodeSTR10String10
66ENPHONBR SearchEnd Phone NumberPhone_NumberString14
67End_PO_Date SearchEnd PO DateDTDate8
68ENUSRDEF SearchEnd User DefinedSTR20String20
69ENDLOCID SearchEnd Location IDSTR15_Location_IDString15
70ENITMNBR SearchEnd Item NumberSTR30_Item_NumberString30
71End_Required_Date SearchEnd Required DateDTDate8
72End_Promised_Date SearchEnd Promised DateDTDate8
73ENDVNDCT SearchEnd Vendor ContactSTR60String60
74ENDSHNAM SearchEnd Short NameSTR15String15
75ENVNSTTS SearchEnd Vendor StatusDDL_Vendor_StatusInteger0
76E1099TYP SearchEnd 1099 Type1099_TypeInteger0
77ENDPEROD SearchEnd PeriodINT_STORAGEInteger0
78ENDYEAR SearchEnd YearYearInteger4
79ENAMBYTD SearchEnd Amount Billed YTDDLR19_RBS0_STR$Currency19
80ENPRYRTY SearchEnd PrioritySTR3String3
81ENDDUEDT SearchEnd Due DateDTDate8
82ENDISCDT SearchEnd Discount DateDTDate8
83ALORNGE2 SearchAll Or Range2GBInteger0
84ENAUCNCD SearchEnd Audit Control CodeSTR13_LBAUString13
85ENDOCNUM SearchEnd Document NumberSTR20String20
86ENDDOCDT SearchEnd Document DateDTDate8
87ENDOCTYP SearchEnd Document TypeINT1Integer1
88ENVCHNUM SearchEnd Voucher NumberSTR20_LBAUString20
89ENCHKNUM SearchEnd Check NumberSTR20String20
90ENDCHKDT SearchEnd Check DateDTDate8
91ENCHBKID SearchEnd Checkbook IDSTR15_LBUString15
92ENBCHSRC SearchEnd Batch SourceSTR15String15
93ENDBNMBR SearchEnd Batch NumberSTR15_LBAUString15
94ENPSTDDT SearchEnd Posted DateDTDate8
95ENCLDSCR SearchEnd Class DescriptionSTR30String30
96AGNGDATE SearchAging DateDTDate8
97PBSDCDTK SearchPayables Start Document Date TokenDDL_Payables_Complete_Date_TokensInteger0
98PBSDUDTK SearchPayables Start Due Date TokenDDL_Payables_Complete_Date_TokensInteger0
99PBSDSDTK SearchPayables Start Discount Date TokenDDL_Payables_Complete_Date_TokensInteger0
100PBSCHDTK SearchPayables Start Check Date TokenDDL_Payables_Complete_Date_TokensInteger0
101PBSPTDTK SearchPayables Start Posted Date TokenDDL_Payables_Complete_Date_TokensInteger0
102PBEDCDTK SearchPayables End Document Date TokenDDL_Payables_Complete_Date_TokensInteger0
103PBEDUDTK SearchPayables End Due Date TokenDDL_Payables_Complete_Date_TokensInteger0
104PBEDSDTK SearchPayables End Discount Date TokenDDL_Payables_Complete_Date_TokensInteger0
105PBECHDTK SearchPayables End Check Date TokenDDL_Payables_Complete_Date_TokensInteger0
106PBEPDTKN SearchPayables End Posted Date TokenDDL_Payables_Complete_Date_TokensInteger0
107PBCDTTKN SearchPayables Complete Date TokensDDL_Payables_Complete_Date_TokensInteger0
108DETLDRPT SearchDetailed ReportCB_Detailed_ReportBoolean0
109SINGACT SearchSingle AccountBooleanBoolean0
110STTACNUM SearchStart Account NumberAccount_NumberComposite 80
111STTACNUM_1 SearchStart Account Number:Account_Segment_Pool1Account_Segment_Pool1String6
112STTACNUM_2 SearchStart Account Number:Account_Segment_Pool2Account_Segment_Pool2String6
113STTACNUM_3 SearchStart Account Number:Account_Segment_Pool3Account_Segment_Pool3String6
114STTACNUM_4 SearchStart Account Number:Account_Segment_Pool4Account_Segment_Pool4String6
115STTACNUM_5 SearchStart Account Number:Account_Segment_Pool5Account_Segment_Pool5String6
116STTACNUM_6 SearchStart Account Number:Account_Segment_Pool6Account_Segment_Pool6String6
117STTACNUM_7 SearchStart Account Number:Account_Segment_Pool7Account_Segment_Pool7String6
118STTACNUM_8 SearchStart Account Number:Account_Segment_Pool8Account_Segment_Pool8String6
119STTACNUM_9 SearchStart Account Number:Account_Segment_Pool9Account_Segment_Pool9String6
120STTACNUM_10 SearchStart Account Number:Account_Segment_Pool10Account_Segment_Pool10String6
121EACCNBR SearchEnd Account NumberAccount_NumberComposite 80
122EACCNBR_1 SearchEnd Account Number:Account_Segment_Pool1Account_Segment_Pool1String6
123EACCNBR_2 SearchEnd Account Number:Account_Segment_Pool2Account_Segment_Pool2String6
124EACCNBR_3 SearchEnd Account Number:Account_Segment_Pool3Account_Segment_Pool3String6
125EACCNBR_4 SearchEnd Account Number:Account_Segment_Pool4Account_Segment_Pool4String6
126EACCNBR_5 SearchEnd Account Number:Account_Segment_Pool5Account_Segment_Pool5String6
127EACCNBR_6 SearchEnd Account Number:Account_Segment_Pool6Account_Segment_Pool6String6
128EACCNBR_7 SearchEnd Account Number:Account_Segment_Pool7Account_Segment_Pool7String6
129EACCNBR_8 SearchEnd Account Number:Account_Segment_Pool8Account_Segment_Pool8String6
130EACCNBR_9 SearchEnd Account Number:Account_Segment_Pool9Account_Segment_Pool9String6
131EACCNBR_10 SearchEnd Account Number:Account_Segment_Pool10Account_Segment_Pool10String6
132STRPONUM SearchStart PO NumberSTR17_POP_NumberString17
133ENDPONUM SearchEnd PO NumberSTR17_POP_NumberString17
134EndPOPRcptNum SearchEnd POP Receipt NumberSTR17_POP_NumberString17
135StartPOPRcptNum SearchStart POP Receipt NumberSTR17_POP_NumberString17
136STRCREAT SearchStart Created ByUser_IDString15
137STRCTDT SearchStart Receipt DateDTDate8
138ENRCTDT SearchEnd Receipt DateDTDate8
139STRCTNUM SearchStart Receipt NumberSTR20_Document_NumberString20
140ENRCTNBR SearchEnd Receipt NumberSTR20_Document_NumberString20
141ENDCREATE SearchEnd Created ByUser_IDString15
142STRPOSTA SearchStart PO StatusDDL_PO_StatusInteger0
143ENDPOSTA SearchEnd PO StatusDDL_PO_StatusInteger0
144INCRCPTS SearchInclude ReceiptsCB_ReceiptsBoolean0
145DISSRLOT SearchDisplay Serial/Lot NumberCB_Serial_Lot_NumberBoolean0
146STRXSRC SearchStart TRX SourceSTR13String13
147ENTRXSRC SearchEnd TRX SourceSTR13String13
148CRBLNCCB SearchCredit Balance CBCBBoolean0
149FLLYPDCB SearchFully Paid CBCBBoolean0
150ZROBALCB SearchZero Balance CBCBBoolean0
151EXCLZBAL SearchExclude Zero BalanceCB_Zero_BalanceBoolean0
152NOACTVCB SearchNo Activity CBCBBoolean0
153Unposted_Applied_CR_Docs SearchUnposted Applied Credit Documents CBCBBoolean0
154Multicurrency_Information SearchMulticurrency Information CBCB_Include_Multicurrency_InfoBoolean0
155Include_Distribution_Typ SearchInclude Distribution TypeMS_Include_Distribution_TypeLong Integer0
156RPTXRATE SearchReporting Exchange RateDLR14_Exchange_RateCurrency (Variable)14
157RPRTCLMD SearchReporting Rate Calculation MethodDDL_Rate_Calculation_MethodInteger0
158PRTCURIN SearchPrint Currency InGBInteger0
159INCLFUNC SearchInclude Functional CurrencyCB_Functional_CurrencyBoolean0
160STARTLINEORIGIN SearchStart Line OriginDDL_Line_OriginInteger0
161ENDLINEORIGIN SearchEnd Line OriginDDL_Line_OriginInteger0
162STARTBUYERID SearchStart Buyer IDSTR15_User_IDString15
163ENDBUYERID SearchEnd Buyer IDSTR15_User_IDString15
164INCLUDEHOLDPO SearchInclude Hold POCB_Include_PO_HoldBoolean0
165INCLUDEHOLDPOONLY SearchInclude Hold PO OnlyCB_Include_PO_On_Hold_OnlyBoolean0
166STARTRELEASEBYDATE SearchStart Release By DateDATE_LDate0
167ENDRELEASEBYDATE SearchEnd Release By DateDATE_LDate0
168Include_New SearchInclude NewCB_NewBoolean0
169Include_Change_Order SearchInclude Change OrderCB_Change_OrderBoolean0
170Include_Received SearchInclude ReceivedCB_ReceivedBoolean0
171SummaryYear SearchSummary YearYearInteger4
172DateSensitivitySumSelect SearchDate Sensitivity Summary SelectGBInteger0
173StartProjNum SearchStart Project NumberSTR15_LBAUString15
174EndProjNum SearchEnd Project NumberSTR15_LBAUString15
175StartCostCatID SearchStart Cost Category IDSTR15_LBAUString15
176EndCostCatID SearchEnd Cost Category IDSTR15_LBAUString15
177IncludeApprovedPOsOnly SearchInclude Approved POs OnlyCB_IncludeApprovedPOsOnlyBoolean0
178MISC SearchMiscCB_MiscBoolean0
179INTEREST SearchInterestCB_InterestBoolean0
180DIVIDEND SearchDividendCB_DividendBoolean0
181DEX_ROW_ID Searchintint10

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 *