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 Group Display Name: Receivables Report Options Files
Physical Name: RM00700
Technical Name: RM_Options_ROPT
Group Technical Name: RM_Report_Options_Logical_File
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | AGNGDTKN ![]() | Aging Date Token | DDL_RM_Token_Dates | Integer | 0 | |
2 | RANGEBY ![]() | Range By | INT | Integer | 0 | |
3 | PRTDBRCD ![]() | Print Detail Breakdown Reg CB | CB | Boolean | 0 | |
4 | PRPSTJCB ![]() | Print Posting Journal CB | CB | Boolean | 0 | |
5 | PRSBDRCB ![]() | Print Summary Breakdown Reg CB | CB | Boolean | 0 | |
6 | ENDDOCDT ![]() | End Document Date | DT | Date | 8 | |
7 | FILEXPNM ![]() | File Export Name | STR255 | String | 255 | |
8 | FINRPTNM ![]() | Financial Report Name | STR30 | String | 30 | |
9 | ASKECHTM ![]() | Ask Each Time | CB_Ask_Each_Time | Boolean | 0 | |
10 | INCLGNDS ![]() | Include Legends | CB_Include_Legends | Boolean | 0 | |
11 | IFFILXST ![]() | If File Existing | GB | Integer | 0 | |
12 | EXPTTYPE ![]() | Export Type | INT | Integer | 0 | |
13 | PRNTNOTS ![]() | Print Notes | CB_Print_Notes | Boolean | 0 | |
14 | CSTSRTBY ![]() | Customer Sort By | DDL_Customer_Sort_By | Integer | 0 | |
15 | PRNTOFIL ![]() | Print to File | CB_Print_to_File | Boolean | 0 | |
16 | PRTOPRTR ![]() | Print to Printer | CB_Print_to_Printer | Boolean | 0 | |
17 | PRTOSCRN ![]() | Print to Screen | CB_Print_to_Screen | Boolean | 0 | |
18 | PRNTTYPE ![]() | Print Type | GB | Integer | 0 | |
19 | RPTGRIND ![]() | Report Group Index | INT | Integer | 0 | |
20 | RTGRSBIN ![]() | Report Group Sub Index | DLR14 | Currency | 14 | |
21 | RTPACHIN ![]() | Report Palette Choice Index | INT | Integer | 0 | |
22 | SORTBY ![]() | Sort By | DDL_Sort_By | Integer | 0 | |
23 | ENFULNAM ![]() | End Full Name | STR40 | String | 40 | |
24 | ENDADDCT ![]() | End Address Contact | STR60 | String | 60 | |
25 | ENDCLSID ![]() | End Class ID | STR15_LBAU | String | 15 | |
26 | ENCUSTID ![]() | End Customer ID | STR15_RM_Customer_Number | String | 15 | |
27 | ENCSTNAM ![]() | End Customer Name | STR64_Customer_Name | String | 64 | |
28 | ENDPHON1 ![]() | End Phone 1 | Phone_Number | String | 14 | |
29 | ENSLSTER ![]() | End Sales Territory | STR15_LBAU | String | 15 | |
30 | ENSPSNID ![]() | End Salesperson ID | STR15_LBAU | String | 15 | |
31 | ENDSHNAM ![]() | End Short Name | STR15 | String | 15 | |
32 | ENDSTATE ![]() | End State | STR30_State | String | 29 | |
33 | ENUSRDF1 ![]() | End User Defined 1 | STR20 | String | 20 | |
34 | ENDZIPCD ![]() | End Zip Code | STR10 | String | 10 | |
35 | ENDINGDT ![]() | Ending Date | DT | Date | 8 | |
36 | ENCLDSCR ![]() | End Class Description | STR30 | String | 30 | |
37 | ENLSTNAM ![]() | End Last Name | STR20 | String | 20 | |
38 | ENDVENDR ![]() | End Vendor | STR15_Vendor_ID | String | 15 | |
39 | ENDEMPLY ![]() | End Employee | STR15_Employee_ID | String | 15 | |
40 | ENDCITY ![]() | End City | STR35 | String | 35 | |
41 | ENDOCNUM ![]() | End Document Number | STR20 | String | 20 | |
42 | ENDOCTYP ![]() | End Document Type | INT1 | Integer | 1 | |
43 | ENDPEROD ![]() | End Period | INT_STORAGE | Integer | 0 | |
44 | ENDPSTDT ![]() | End Post Date | DATE | Date | 6 | |
45 | ENDBNMBR ![]() | End Batch Number | STR15_LBAU | String | 15 | |
46 | ENBCHSRC ![]() | End Batch Source | STR15 | String | 15 | |
47 | ENTRXSRC ![]() | End TRX Source | STR13 | String | 13 | |
48 | ENRMTKDT ![]() | End RM Token Date | DDL_RM_Token_Dates | Integer | 0 | |
49 | ENSLSAMT ![]() | End Sales Amount | DLR19_RBSO_UTR$ | Currency | 19 | |
50 | ENPRMRGN ![]() | End Profit Margin | DLR19_RBSO_UTR$ | Currency | 19 | |
51 | STRTFLNM ![]() | Start Full Name | STR40 | String | 40 | |
52 | STRMTKDT ![]() | Start RM Token Date | DDL_RM_Token_Dates | Integer | 0 | |
53 | STADDCTT ![]() | Start Address Contact | STR60 | String | 60 | |
54 | STTCLSID ![]() | Start Class ID | STR15_LBAU | String | 15 | |
55 | STCUSTID ![]() | Start Customer ID | STR15_RM_Customer_Number | String | 15 | |
56 | STCUSTNM ![]() | Start Customer Name | STR64_Customer_Name | String | 64 | |
57 | STRTDATE ![]() | Start Date | DT | Date | 8 | |
58 | STRTNGDT ![]() | Starting Date | DT | Date | 8 | |
59 | STTPHON1 ![]() | Start Phone 1 | Phone_Number | String | 14 | |
60 | STSLSTER ![]() | Start Sales Territory | STR15_LBAU | String | 15 | |
61 | STSPRSID ![]() | Start Salesperson ID | STR15_LBAU | String | 15 | |
62 | STTSHNAM ![]() | Start Short Name | STR15 | String | 15 | |
63 | STTSTATE ![]() | Start State | STR30_State | String | 29 | |
64 | STTUDEF1 ![]() | Start User Defined 1 | STR20 | String | 20 | |
65 | STRTZPCD ![]() | Start Zip Code | STR10 | String | 10 | |
66 | STCLSDSC ![]() | Start Class Description | STR30 | String | 30 | |
67 | STTLSTNM ![]() | Start Last Name | STR20 | String | 20 | |
68 | STRTVNDR ![]() | Start Vendor | STR15_Vendor_ID | String | 15 | |
69 | STRTEMPL ![]() | Start Employee | STR15_Employee_ID | String | 15 | |
70 | STRTCITY ![]() | Start City | STR35 | String | 35 | |
71 | STMTCYCL ![]() | Statement Cycle | DDL_Stmt_Cycle | Integer | 0 | |
72 | ENSTCYCL ![]() | End Statement Cycle | DDL_Stmt_Cycle | Integer | 0 | |
73 | STDOCNUM ![]() | Start Document Number | STR20 | String | 20 | |
74 | STTDOCTP ![]() | Start Document type | DDL_Document_Type | Integer | 0 | |
75 | STTDOCDT ![]() | Start Document Date | DT | Date | 8 | |
76 | STPERIOD ![]() | Start Period | INT_STORAGE | Integer | 0 | |
77 | STTPSTDT ![]() | Start Post Date | DATE | Date | 6 | |
78 | STBCHNUM ![]() | Start Batch Number | STR15_LBAU | String | 15 | |
79 | STBCHSRC ![]() | Start Batch Source | STR15 | String | 15 | |
80 | STRXSRC ![]() | Start TRX Source | STR13 | String | 13 | |
81 | STPRMRGN ![]() | Start Profit Margin | DLR19_RBSO_UTR$ | Currency | 19 | |
82 | STSLSAMT ![]() | Start Sales Amount | DLR19_RBSO_UTR$ | Currency | 19 | |
83 | INACTIVE ![]() | Inactive | CB_Inactive | Boolean | 0 | |
84 | BALNCTYP ![]() | Balance Type | GB_Bal_Type | Integer | 0 | |
85 | ACTIVE ![]() | Active | CB_Active | Boolean | 0 | |
86 | HISTTYPE ![]() | History Type | GB | Integer | 0 | |
87 | TRANTOPR ![]() | Transferred to PR | CB | Boolean | 0 | |
88 | PRNTDTLD ![]() | Print Detailed | CB | Boolean | 0 | |
89 | CUTOFDAT ![]() | Cutoff Date | DT | Date | 8 | |
90 | CRBLNCCB ![]() | Credit Balance CB | CB | Boolean | 0 | |
91 | FLLYPDCB ![]() | Fully Paid CB | CB | Boolean | 0 | |
92 | NOACTVCB ![]() | No Activity CB | CB | Boolean | 0 | |
93 | ZROBALCB ![]() | Zero Balance CB | CB | Boolean | 0 | |
94 | PASTDUCB ![]() | Past Due CB | CB | Boolean | 0 | |
95 | WHICHRPT ![]() | Which Report | GB | Integer | 0 | |
96 | PERTYPGB ![]() | Period Type GB | GB | Integer | 0 | |
97 | YEAR1 ![]() | Year | Year | Integer | 4 | |
98 | STTACNUM ![]() | Start Account Number | Account_Number | Composite | 80 | |
99 | STTACNUM_1 ![]() | Start Account Number:Account_Segment_Pool1 | Account_Segment_Pool1 | String | 6 | |
100 | STTACNUM_2 ![]() | Start Account Number:Account_Segment_Pool2 | Account_Segment_Pool2 | String | 6 | |
101 | STTACNUM_3 ![]() | Start Account Number:Account_Segment_Pool3 | Account_Segment_Pool3 | String | 6 | |
102 | STTACNUM_4 ![]() | Start Account Number:Account_Segment_Pool4 | Account_Segment_Pool4 | String | 6 | |
103 | STTACNUM_5 ![]() | Start Account Number:Account_Segment_Pool5 | Account_Segment_Pool5 | String | 6 | |
104 | STTACNUM_6 ![]() | Start Account Number:Account_Segment_Pool6 | Account_Segment_Pool6 | String | 6 | |
105 | STTACNUM_7 ![]() | Start Account Number:Account_Segment_Pool7 | Account_Segment_Pool7 | String | 6 | |
106 | STTACNUM_8 ![]() | Start Account Number:Account_Segment_Pool8 | Account_Segment_Pool8 | String | 6 | |
107 | STTACNUM_9 ![]() | Start Account Number:Account_Segment_Pool9 | Account_Segment_Pool9 | String | 6 | |
108 | STTACNUM_10 ![]() | Start Account Number:Account_Segment_Pool10 | Account_Segment_Pool10 | String | 6 | |
109 | EACCNBR ![]() | End Account Number | Account_Number | Composite | 80 | |
110 | EACCNBR_1 ![]() | End Account Number:Account_Segment_Pool1 | Account_Segment_Pool1 | String | 6 | |
111 | EACCNBR_2 ![]() | End Account Number:Account_Segment_Pool2 | Account_Segment_Pool2 | String | 6 | |
112 | EACCNBR_3 ![]() | End Account Number:Account_Segment_Pool3 | Account_Segment_Pool3 | String | 6 | |
113 | EACCNBR_4 ![]() | End Account Number:Account_Segment_Pool4 | Account_Segment_Pool4 | String | 6 | |
114 | EACCNBR_5 ![]() | End Account Number:Account_Segment_Pool5 | Account_Segment_Pool5 | String | 6 | |
115 | EACCNBR_6 ![]() | End Account Number:Account_Segment_Pool6 | Account_Segment_Pool6 | String | 6 | |
116 | EACCNBR_7 ![]() | End Account Number:Account_Segment_Pool7 | Account_Segment_Pool7 | String | 6 | |
117 | EACCNBR_8 ![]() | End Account Number:Account_Segment_Pool8 | Account_Segment_Pool8 | String | 6 | |
118 | EACCNBR_9 ![]() | End Account Number:Account_Segment_Pool9 | Account_Segment_Pool9 | String | 6 | |
119 | EACCNBR_10 ![]() | End Account Number:Account_Segment_Pool10 | Account_Segment_Pool10 | String | 6 | |
120 | SEGMNTRG ![]() | Using Segment Range | INT | Integer | 0 | |
121 | ENITMNBR ![]() | End Item Number | STR30_Item_Number | String | 30 | |
122 | ENDSERLT ![]() | End Serial/Lot Number | STR20 | String | 20 | |
123 | STTITNUM ![]() | Start Item Number | STR30_Item_Number | String | 30 | |
124 | STRTSRLT ![]() | Start Serial/Lot Number | STR20 | String | 20 | |
125 | TRXTYPE ![]() | Transaction Type | GB | Integer | 0 | |
126 | INCLTXDT ![]() | Include Tax Details | CB | Boolean | 0 | |
127 | INCLPYMT ![]() | Include Payments | CB | Boolean | 0 | |
128 | STQUOEXD ![]() | Start Quote Expiration Date | DT | Date | 8 | |
129 | EDQUOEXD ![]() | End Quote Expiration Date | DT | Date | 8 | |
130 | STREQDAT ![]() | Start Requested Ship Date | DATE | Date | 6 | |
131 | ENDREQDT ![]() | End Requested Ship Date | DATE | Date | 6 | |
132 | STTLOCCD ![]() | Start Location Code | STR10_Location_Code | String | 10 | |
133 | ENLOCNCD ![]() | End Location Code | STR10_Location_Code | String | 10 | |
134 | STMSTNMB ![]() | Start Master Number | LI_MasterNumber | Long Integer | 9 | |
135 | EDMASNMB ![]() | End Master Number | LI_MasterNumber | Long Integer | 9 | |
136 | STPRHDID ![]() | Start Process Hold ID | STR15_LBAU | String | 15 | |
137 | ENPRHDID ![]() | End Process Hold ID | STR15_LBAU | String | 15 | |
138 | STTDOCID ![]() | Start Document ID | STR15_LBAU | String | 15 | |
139 | ENDDOCID ![]() | End Document ID | STR15_LBAU | String | 15 | |
140 | STSOPTYP ![]() | Start SOP Type | DDL_SOP_Type | Integer | 0 | |
141 | EDSOPTYP ![]() | End SOP Type | DDL_SOP_Type | Integer | 0 | |
142 | DISCOMP ![]() | Display Components | CB_Kit_Components | Boolean | 0 | |
143 | DISPRCHD ![]() | Display Process Holds | CB_Process_Holds | Boolean | 0 | |
144 | DISSRLOT ![]() | Display Serial/Lot Number | CB_Serial_Lot_Number | Boolean | 0 | |
145 | DISUSRDF ![]() | Display User Defined | CB_User_Defined | Boolean | 0 | |
146 | EXCCOMP ![]() | Exclude Components | CB_Kit_Components | Boolean | 0 | |
147 | EXCFULFIL ![]() | Exclude Fulfilled | CB_Fulfilled | Boolean | 0 | |
148 | INCMCINF ![]() | Include Multicurrency Info | CB_Include_Multicurrency_Info | Boolean | 0 | |
149 | RPTXRATE ![]() | Reporting Exchange Rate | DLR14_Exchange_Rate | Currency (Variable) | 14 | |
150 | RPRTCLMD ![]() | Reporting Rate Calculation Method | DDL_Rate_Calculation_Method | Integer | 0 | |
151 | PRTCURIN ![]() | Print Currency In | GB | Integer | 0 | |
152 | CONNAACT ![]() | Consolidate National Account Activity | CB_Conslidate_NA_Activity | Boolean | 0 | |
153 | DateSensitivitySumSelect ![]() | Date Sensitivity Summary Select | GB | Integer | 0 | |
154 | SummaryYear ![]() | Summary Year | Year | Integer | 4 | |
155 | DEX_ROW_ID ![]() | int | int | 10 | ||
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. |