RM Report Options (RM00700)

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

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

Leave a Reply Cancel reply