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 TypeLength
1AGNGDTKN SearchAging Date TokenDDL_RM_Token_DatesInteger0
2RANGEBY SearchRange ByINTInteger0
3PRTDBRCD SearchPrint Detail Breakdown Reg CBCBBoolean0
4PRPSTJCB SearchPrint Posting Journal CBCBBoolean0
5PRSBDRCB SearchPrint Summary Breakdown Reg CBCBBoolean0
6ENDDOCDT SearchEnd Document DateDTDate8
7FILEXPNM SearchFile Export NameSTR255String255
8FINRPTNM SearchFinancial Report NameSTR30String30
9ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean0
10INCLGNDS SearchInclude LegendsCB_Include_LegendsBoolean0
11IFFILXST SearchIf File ExistingGBInteger0
12EXPTTYPE SearchExport TypeINTInteger0
13PRNTNOTS SearchPrint NotesCB_Print_NotesBoolean0
14CSTSRTBY SearchCustomer Sort ByDDL_Customer_Sort_ByInteger0
15PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean0
16PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean0
17PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean0
18PRNTTYPE SearchPrint TypeGBInteger0
19RPTGRIND SearchReport Group IndexINTInteger0
20RTGRSBIN SearchReport Group Sub IndexDLR14Currency14
21RTPACHIN SearchReport Palette Choice IndexINTInteger0
22SORTBY SearchSort ByDDL_Sort_ByInteger0
23ENFULNAM SearchEnd Full NameSTR40String40
24ENDADDCT SearchEnd Address ContactSTR60String60
25ENDCLSID SearchEnd Class IDSTR15_LBAUString15
26ENCUSTID SearchEnd Customer IDSTR15_RM_Customer_NumberString15
27ENCSTNAM SearchEnd Customer NameSTR64_Customer_NameString64
28ENDPHON1 SearchEnd Phone 1Phone_NumberString14
29ENSLSTER SearchEnd Sales TerritorySTR15_LBAUString15
30ENSPSNID SearchEnd Salesperson IDSTR15_LBAUString15
31ENDSHNAM SearchEnd Short NameSTR15String15
32ENDSTATE SearchEnd StateSTR30_StateString29
33ENUSRDF1 SearchEnd User Defined 1STR20String20
34ENDZIPCD SearchEnd Zip CodeSTR10String10
35ENDINGDT SearchEnding DateDTDate8
36ENCLDSCR SearchEnd Class DescriptionSTR30String30
37ENLSTNAM SearchEnd Last NameSTR20String20
38ENDVENDR SearchEnd VendorSTR15_Vendor_IDString15
39ENDEMPLY SearchEnd EmployeeSTR15_Employee_IDString15
40ENDCITY SearchEnd CitySTR35String35
41ENDOCNUM SearchEnd Document NumberSTR20String20
42ENDOCTYP SearchEnd Document TypeINT1Integer1
43ENDPEROD SearchEnd PeriodINT_STORAGEInteger0
44ENDPSTDT SearchEnd Post DateDATEDate6
45ENDBNMBR SearchEnd Batch NumberSTR15_LBAUString15
46ENBCHSRC SearchEnd Batch SourceSTR15String15
47ENTRXSRC SearchEnd TRX SourceSTR13String13
48ENRMTKDT SearchEnd RM Token DateDDL_RM_Token_DatesInteger0
49ENSLSAMT SearchEnd Sales AmountDLR19_RBSO_UTR$Currency19
50ENPRMRGN SearchEnd Profit MarginDLR19_RBSO_UTR$Currency19
51STRTFLNM SearchStart Full NameSTR40String40
52STRMTKDT SearchStart RM Token DateDDL_RM_Token_DatesInteger0
53STADDCTT SearchStart Address ContactSTR60String60
54STTCLSID SearchStart Class IDSTR15_LBAUString15
55STCUSTID SearchStart Customer IDSTR15_RM_Customer_NumberString15
56STCUSTNM SearchStart Customer NameSTR64_Customer_NameString64
57STRTDATE SearchStart DateDTDate8
58STRTNGDT SearchStarting DateDTDate8
59STTPHON1 SearchStart Phone 1Phone_NumberString14
60STSLSTER SearchStart Sales TerritorySTR15_LBAUString15
61STSPRSID SearchStart Salesperson IDSTR15_LBAUString15
62STTSHNAM SearchStart Short NameSTR15String15
63STTSTATE SearchStart StateSTR30_StateString29
64STTUDEF1 SearchStart User Defined 1STR20String20
65STRTZPCD SearchStart Zip CodeSTR10String10
66STCLSDSC SearchStart Class DescriptionSTR30String30
67STTLSTNM SearchStart Last NameSTR20String20
68STRTVNDR SearchStart VendorSTR15_Vendor_IDString15
69STRTEMPL SearchStart EmployeeSTR15_Employee_IDString15
70STRTCITY SearchStart CitySTR35String35
71STMTCYCL SearchStatement CycleDDL_Stmt_CycleInteger0
72ENSTCYCL SearchEnd Statement CycleDDL_Stmt_CycleInteger0
73STDOCNUM SearchStart Document NumberSTR20String20
74STTDOCTP SearchStart Document typeDDL_Document_TypeInteger0
75STTDOCDT SearchStart Document DateDTDate8
76STPERIOD SearchStart PeriodINT_STORAGEInteger0
77STTPSTDT SearchStart Post DateDATEDate6
78STBCHNUM SearchStart Batch NumberSTR15_LBAUString15
79STBCHSRC SearchStart Batch SourceSTR15String15
80STRXSRC SearchStart TRX SourceSTR13String13
81STPRMRGN SearchStart Profit MarginDLR19_RBSO_UTR$Currency19
82STSLSAMT SearchStart Sales AmountDLR19_RBSO_UTR$Currency19
83INACTIVE SearchInactiveCB_InactiveBoolean0
84BALNCTYP SearchBalance TypeGB_Bal_TypeInteger0
85ACTIVE SearchActiveCB_ActiveBoolean0
86HISTTYPE SearchHistory TypeGBInteger0
87TRANTOPR SearchTransferred to PRCBBoolean0
88PRNTDTLD SearchPrint Detailed CBBoolean0
89CUTOFDAT SearchCutoff DateDTDate8
90CRBLNCCB SearchCredit Balance CBCBBoolean0
91FLLYPDCB SearchFully Paid CBCBBoolean0
92NOACTVCB SearchNo Activity CBCBBoolean0
93ZROBALCB SearchZero Balance CBCBBoolean0
94PASTDUCB SearchPast Due CBCBBoolean0
95WHICHRPT SearchWhich ReportGBInteger0
96PERTYPGB SearchPeriod Type GBGBInteger0
97YEAR1 SearchYearYearInteger4
98STTACNUM SearchStart Account NumberAccount_NumberComposite 80
99STTACNUM_1 SearchStart Account Number:Account_Segment_Pool1Account_Segment_Pool1String6
100STTACNUM_2 SearchStart Account Number:Account_Segment_Pool2Account_Segment_Pool2String6
101STTACNUM_3 SearchStart Account Number:Account_Segment_Pool3Account_Segment_Pool3String6
102STTACNUM_4 SearchStart Account Number:Account_Segment_Pool4Account_Segment_Pool4String6
103STTACNUM_5 SearchStart Account Number:Account_Segment_Pool5Account_Segment_Pool5String6
104STTACNUM_6 SearchStart Account Number:Account_Segment_Pool6Account_Segment_Pool6String6
105STTACNUM_7 SearchStart Account Number:Account_Segment_Pool7Account_Segment_Pool7String6
106STTACNUM_8 SearchStart Account Number:Account_Segment_Pool8Account_Segment_Pool8String6
107STTACNUM_9 SearchStart Account Number:Account_Segment_Pool9Account_Segment_Pool9String6
108STTACNUM_10 SearchStart Account Number:Account_Segment_Pool10Account_Segment_Pool10String6
109EACCNBR SearchEnd Account NumberAccount_NumberComposite 80
110EACCNBR_1 SearchEnd Account Number:Account_Segment_Pool1Account_Segment_Pool1String6
111EACCNBR_2 SearchEnd Account Number:Account_Segment_Pool2Account_Segment_Pool2String6
112EACCNBR_3 SearchEnd Account Number:Account_Segment_Pool3Account_Segment_Pool3String6
113EACCNBR_4 SearchEnd Account Number:Account_Segment_Pool4Account_Segment_Pool4String6
114EACCNBR_5 SearchEnd Account Number:Account_Segment_Pool5Account_Segment_Pool5String6
115EACCNBR_6 SearchEnd Account Number:Account_Segment_Pool6Account_Segment_Pool6String6
116EACCNBR_7 SearchEnd Account Number:Account_Segment_Pool7Account_Segment_Pool7String6
117EACCNBR_8 SearchEnd Account Number:Account_Segment_Pool8Account_Segment_Pool8String6
118EACCNBR_9 SearchEnd Account Number:Account_Segment_Pool9Account_Segment_Pool9String6
119EACCNBR_10 SearchEnd Account Number:Account_Segment_Pool10Account_Segment_Pool10String6
120SEGMNTRG SearchUsing Segment RangeINTInteger0
121ENITMNBR SearchEnd Item NumberSTR30_Item_NumberString30
122ENDSERLT SearchEnd Serial/Lot NumberSTR20String20
123STTITNUM SearchStart Item NumberSTR30_Item_NumberString30
124STRTSRLT SearchStart Serial/Lot NumberSTR20String20
125TRXTYPE SearchTransaction TypeGBInteger0
126INCLTXDT SearchInclude Tax DetailsCBBoolean0
127INCLPYMT SearchInclude PaymentsCBBoolean0
128STQUOEXD SearchStart Quote Expiration DateDTDate8
129EDQUOEXD SearchEnd Quote Expiration DateDTDate8
130STREQDAT SearchStart Requested Ship DateDATEDate6
131ENDREQDT SearchEnd Requested Ship DateDATEDate6
132STTLOCCD SearchStart Location CodeSTR10_Location_CodeString10
133ENLOCNCD SearchEnd Location CodeSTR10_Location_CodeString10
134STMSTNMB SearchStart Master NumberLI_MasterNumberLong Integer9
135EDMASNMB SearchEnd Master NumberLI_MasterNumberLong Integer9
136STPRHDID SearchStart Process Hold IDSTR15_LBAUString15
137ENPRHDID SearchEnd Process Hold IDSTR15_LBAUString15
138STTDOCID SearchStart Document IDSTR15_LBAUString15
139ENDDOCID SearchEnd Document IDSTR15_LBAUString15
140STSOPTYP SearchStart SOP TypeDDL_SOP_TypeInteger0
141EDSOPTYP SearchEnd SOP TypeDDL_SOP_TypeInteger0
142DISCOMP SearchDisplay ComponentsCB_Kit_ComponentsBoolean0
143DISPRCHD SearchDisplay Process HoldsCB_Process_HoldsBoolean0
144DISSRLOT SearchDisplay Serial/Lot NumberCB_Serial_Lot_NumberBoolean0
145DISUSRDF SearchDisplay User DefinedCB_User_DefinedBoolean0
146EXCCOMP SearchExclude ComponentsCB_Kit_ComponentsBoolean0
147EXCFULFIL SearchExclude FulfilledCB_FulfilledBoolean0
148INCMCINF SearchInclude Multicurrency InfoCB_Include_Multicurrency_InfoBoolean0
149RPTXRATE SearchReporting Exchange RateDLR14_Exchange_RateCurrency (Variable)14
150RPRTCLMD SearchReporting Rate Calculation MethodDDL_Rate_Calculation_MethodInteger0
151PRTCURIN SearchPrint Currency InGBInteger0
152CONNAACT SearchConsolidate National Account ActivityCB_Conslidate_NA_ActivityBoolean0
153DateSensitivitySumSelect SearchDate Sensitivity Summary SelectGBInteger0
154SummaryYear SearchSummary YearYearInteger4
155DEX_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 *