RM Report Options (RM00700)

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

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: RM Report Options
Physical Name: RM00700
Technical Name: RM_Options_ROPT

Group Display Name: Receivables Report Options Files
Group Technical Name: RM_Report_Options_Logical_File

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1AGNGDTKN SearchAging Date TokenDDL_RM_Token_DatesInteger20
2RANGEBY SearchRange ByINTInteger20
3PRTDBRCD SearchPrint Detail Breakdown Reg CBCBBoolean20
4PRPSTJCB SearchPrint Posting Journal CBCBBoolean20
5PRSBDRCB SearchPrint Summary Breakdown Reg CBCBBoolean20
6ENDDOCDT SearchEnd Document DateDTDate48
7FILEXPNM SearchFile Export NameSTR255String256255
8FINRPTNM SearchFinancial Report NameSTR30String3230
9ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean20
10INCLGNDS SearchInclude LegendsCB_Include_LegendsBoolean20
11IFFILXST SearchIf File ExistingGBInteger20
12EXPTTYPE SearchExport TypeINTInteger20
13PRNTNOTS SearchPrint NotesCB_Print_NotesBoolean20
14CSTSRTBY SearchCustomer Sort ByDDL_Customer_Sort_ByInteger20
15PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean20
16PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean20
17PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean20
18PRNTTYPE SearchPrint TypeGBInteger20
19RPTGRIND SearchReport Group IndexINTInteger20
20RTGRSBIN SearchReport Group Sub IndexDLR14Currency1014
21RTPACHIN SearchReport Palette Choice IndexINTInteger20
22SORTBY SearchSort ByDDL_Sort_ByInteger20
23ENFULNAM SearchEnd Full NameSTR40String4240
24ENDADDCT SearchEnd Address ContactSTR60String6260
25ENDCLSID SearchEnd Class IDSTR15_LBAUString1615
26ENCUSTID SearchEnd Customer IDSTR15_RM_Customer_NumberString1615
27ENCSTNAM SearchEnd Customer NameSTR64_Customer_NameString6664
28ENDPHON1 SearchEnd Phone 1Phone_NumberString2214
29ENSLSTER SearchEnd Sales TerritorySTR15_LBAUString1615
30ENSPSNID SearchEnd Salesperson IDSTR15_LBAUString1615
31ENDSHNAM SearchEnd Short NameSTR15String1615
32ENDSTATE SearchEnd StateSTR30_StateString3029
33ENUSRDF1 SearchEnd User Defined 1STR20String2220
34ENDZIPCD SearchEnd Zip CodeSTR10String1210
35ENDINGDT SearchEnding DateDTDate48
36ENCLDSCR SearchEnd Class DescriptionSTR30String3230
37ENLSTNAM SearchEnd Last NameSTR20String2220
38ENDVENDR SearchEnd VendorSTR15_Vendor_IDString1615
39ENDEMPLY SearchEnd EmployeeSTR15_Employee_IDString1615
40ENDCITY SearchEnd CitySTR35String3635
41ENDOCNUM SearchEnd Document NumberSTR20String2220
42ENDOCTYP SearchEnd Document TypeINT1Integer21
43ENDPEROD SearchEnd PeriodINT_STORAGEInteger20
44ENDPSTDT SearchEnd Post DateDATEDate46
45ENDBNMBR SearchEnd Batch NumberSTR15_LBAUString1615
46ENBCHSRC SearchEnd Batch SourceSTR15String1615
47ENTRXSRC SearchEnd TRX SourceSTR13String1413
48ENRMTKDT SearchEnd RM Token DateDDL_RM_Token_DatesInteger20
49ENSLSAMT SearchEnd Sales AmountDLR19_RBSO_UTR$Currency1019
50ENPRMRGN SearchEnd Profit MarginDLR19_RBSO_UTR$Currency1019
51STRTFLNM SearchStart Full NameSTR40String4240
52STRMTKDT SearchStart RM Token DateDDL_RM_Token_DatesInteger20
53STADDCTT SearchStart Address ContactSTR60String6260
54STTCLSID SearchStart Class IDSTR15_LBAUString1615
55STCUSTID SearchStart Customer IDSTR15_RM_Customer_NumberString1615
56STCUSTNM SearchStart Customer NameSTR64_Customer_NameString6664
57STRTDATE SearchStart DateDTDate48
58STRTNGDT SearchStarting DateDTDate48
59STTPHON1 SearchStart Phone 1Phone_NumberString2214
60STSLSTER SearchStart Sales TerritorySTR15_LBAUString1615
61STSPRSID SearchStart Salesperson IDSTR15_LBAUString1615
62STTSHNAM SearchStart Short NameSTR15String1615
63STTSTATE SearchStart StateSTR30_StateString3029
64STTUDEF1 SearchStart User Defined 1STR20String2220
65STRTZPCD SearchStart Zip CodeSTR10String1210
66STCLSDSC SearchStart Class DescriptionSTR30String3230
67STTLSTNM SearchStart Last NameSTR20String2220
68STRTVNDR SearchStart VendorSTR15_Vendor_IDString1615
69STRTEMPL SearchStart EmployeeSTR15_Employee_IDString1615
70STRTCITY SearchStart CitySTR35String3635
71STMTCYCL SearchStatement CycleDDL_Stmt_CycleInteger20
72ENSTCYCL SearchEnd Statement CycleDDL_Stmt_CycleInteger20
73STDOCNUM SearchStart Document NumberSTR20String2220
74STTDOCTP SearchStart Document typeDDL_Document_TypeInteger20
75STTDOCDT SearchStart Document DateDTDate48
76STPERIOD SearchStart PeriodINT_STORAGEInteger20
77STTPSTDT SearchStart Post DateDATEDate46
78STBCHNUM SearchStart Batch NumberSTR15_LBAUString1615
79STBCHSRC SearchStart Batch SourceSTR15String1615
80STRXSRC SearchStart TRX SourceSTR13String1413
81STPRMRGN SearchStart Profit MarginDLR19_RBSO_UTR$Currency1019
82STSLSAMT SearchStart Sales AmountDLR19_RBSO_UTR$Currency1019
83INACTIVE SearchInactiveCB_InactiveBoolean20
84BALNCTYP SearchBalance TypeGB_Bal_TypeInteger20
85ACTIVE SearchActiveCB_ActiveBoolean20
86HISTTYPE SearchHistory TypeGBInteger20
87TRANTOPR SearchTransferred to PRCBBoolean20
88PRNTDTLD SearchPrint Detailed CBBoolean20
89CUTOFDAT SearchCutoff DateDTDate48
90CRBLNCCB SearchCredit Balance CBCBBoolean20
91FLLYPDCB SearchFully Paid CBCBBoolean20
92NOACTVCB SearchNo Activity CBCBBoolean20
93ZROBALCB SearchZero Balance CBCBBoolean20
94PASTDUCB SearchPast Due CBCBBoolean20
95WHICHRPT SearchWhich ReportGBInteger20
96PERTYPGB SearchPeriod Type GBGBInteger20
97YEAR1 SearchYearYearInteger24
98STTACNUM SearchStart Account NumberAccount_NumberComposite 8080
99STTACNUM_1 SearchStart Account Number:Account_Segment_Pool1Account_Segment_Pool1String86
100STTACNUM_2 SearchStart Account Number:Account_Segment_Pool2Account_Segment_Pool2String86
101STTACNUM_3 SearchStart Account Number:Account_Segment_Pool3Account_Segment_Pool3String86
102STTACNUM_4 SearchStart Account Number:Account_Segment_Pool4Account_Segment_Pool4String86
103STTACNUM_5 SearchStart Account Number:Account_Segment_Pool5Account_Segment_Pool5String86
104STTACNUM_6 SearchStart Account Number:Account_Segment_Pool6Account_Segment_Pool6String86
105STTACNUM_7 SearchStart Account Number:Account_Segment_Pool7Account_Segment_Pool7String86
106STTACNUM_8 SearchStart Account Number:Account_Segment_Pool8Account_Segment_Pool8String86
107STTACNUM_9 SearchStart Account Number:Account_Segment_Pool9Account_Segment_Pool9String86
108STTACNUM_10 SearchStart Account Number:Account_Segment_Pool10Account_Segment_Pool10String86
109EACCNBR SearchEnd Account NumberAccount_NumberComposite 8080
110EACCNBR_1 SearchEnd Account Number:Account_Segment_Pool1Account_Segment_Pool1String86
111EACCNBR_2 SearchEnd Account Number:Account_Segment_Pool2Account_Segment_Pool2String86
112EACCNBR_3 SearchEnd Account Number:Account_Segment_Pool3Account_Segment_Pool3String86
113EACCNBR_4 SearchEnd Account Number:Account_Segment_Pool4Account_Segment_Pool4String86
114EACCNBR_5 SearchEnd Account Number:Account_Segment_Pool5Account_Segment_Pool5String86
115EACCNBR_6 SearchEnd Account Number:Account_Segment_Pool6Account_Segment_Pool6String86
116EACCNBR_7 SearchEnd Account Number:Account_Segment_Pool7Account_Segment_Pool7String86
117EACCNBR_8 SearchEnd Account Number:Account_Segment_Pool8Account_Segment_Pool8String86
118EACCNBR_9 SearchEnd Account Number:Account_Segment_Pool9Account_Segment_Pool9String86
119EACCNBR_10 SearchEnd Account Number:Account_Segment_Pool10Account_Segment_Pool10String86
120SEGMNTRG SearchUsing Segment RangeINTInteger20
121ENITMNBR SearchEnd Item NumberSTR30_Item_NumberString3230
122ENDSERLT SearchEnd Serial/Lot NumberSTR20String2220
123STTITNUM SearchStart Item NumberSTR30_Item_NumberString3230
124STRTSRLT SearchStart Serial/Lot NumberSTR20String2220
125TRXTYPE SearchTransaction TypeGBInteger20
126INCLTXDT SearchInclude Tax DetailsCBBoolean20
127INCLPYMT SearchInclude PaymentsCBBoolean20
128STQUOEXD SearchStart Quote Expiration DateDTDate48
129EDQUOEXD SearchEnd Quote Expiration DateDTDate48
130STREQDAT SearchStart Requested Ship DateDATEDate46
131ENDREQDT SearchEnd Requested Ship DateDATEDate46
132STTLOCCD SearchStart Location CodeSTR10_Location_CodeString1210
133ENLOCNCD SearchEnd Location CodeSTR10_Location_CodeString1210
134STMSTNMB SearchStart Master NumberLI_MasterNumberLong Integer49
135EDMASNMB SearchEnd Master NumberLI_MasterNumberLong Integer49
136STPRHDID SearchStart Process Hold IDSTR15_LBAUString1615
137ENPRHDID SearchEnd Process Hold IDSTR15_LBAUString1615
138STTDOCID SearchStart Document IDSTR15_LBAUString1615
139ENDDOCID SearchEnd Document IDSTR15_LBAUString1615
140STSOPTYP SearchStart SOP TypeDDL_SOP_TypeInteger20
141EDSOPTYP SearchEnd SOP TypeDDL_SOP_TypeInteger20
142DISCOMP SearchDisplay ComponentsCB_Kit_ComponentsBoolean20
143DISPRCHD SearchDisplay Process HoldsCB_Process_HoldsBoolean20
144DISSRLOT SearchDisplay Serial/Lot NumberCB_Serial_Lot_NumberBoolean20
145DISUSRDF SearchDisplay User DefinedCB_User_DefinedBoolean20
146EXCCOMP SearchExclude ComponentsCB_Kit_ComponentsBoolean20
147EXCFULFIL SearchExclude FulfilledCB_FulfilledBoolean20
148INCMCINF SearchInclude Multicurrency InfoCB_Include_Multicurrency_InfoBoolean20
149RPTXRATE SearchReporting Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
150RPRTCLMD SearchReporting Rate Calculation MethodDDL_Rate_Calculation_MethodInteger20
151PRTCURIN SearchPrint Currency InGBInteger20
152CONNAACT SearchConsolidate National Account ActivityCB_Conslidate_NA_ActivityBoolean20
153DateSensitivitySumSelect SearchDate Sensitivity Summary SelectGBInteger20
154SummaryYear SearchSummary YearYearInteger24
155DEX_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 *