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

azurecurve Products Microsoft Dynamics GP (0)SalesRM Report Options (RM00700)

Leave a Reply Cancel reply