RM00700 - RM Report Options | Prospr - Dynamics GP Table Reference

RM00700 - RM Report Options

Query Builder

Select * from RM00700

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
AGNGDTKN	Aging Date Token	Integer	2	View
RANGEBY	Range By	Integer	2	View
PRTDBRCD	Print Detail Breakdown Reg CB	Boolean	2	View
PRPSTJCB	Print Posting Journal CB	Boolean	2	View
PRSBDRCB	Print Summary Breakdown Reg CB	Boolean	2	View
ENDDOCDT	End Document Date	Date	4	View
FILEXPNM	File Export Name	String	256	View
FINRPTNM	Financial Report Name	String	32	View
ASKECHTM	Ask Each Time	Boolean	2	View
INCLGNDS	Include Legends	Boolean	2	View
IFFILXST	If File Existing	Integer	2	View
EXPTTYPE	Export Type	Integer	2	View
PRNTNOTS	Print Notes	Boolean	2	View
CSTSRTBY	Customer Sort By	Integer	2	View
PRNTOFIL	Print to File	Boolean	2	View
PRTOPRTR	Print to Printer	Boolean	2	View
PRTOSCRN	Print to Screen	Boolean	2	View
PRNTTYPE	Print Type	Integer	2	View
RPTGRIND	Report Group Index	Integer	2	View
RTGRSBIN	Report Group Sub Index	Currency	10	View
RTPACHIN	Report Palette Choice Index	Integer	2	View
SORTBY	Sort By	Integer	2	View
ENFULNAM	End Full Name	String	42	View
ENDADDCT	End Address Contact	String	62	View
ENDCLSID	End Class ID	String	16	View
ENCUSTID	End Customer ID	String	16	View
ENCSTNAM	End Customer Name	String	66	View
ENDPHON1	End Phone 1	String	22	View
ENSLSTER	End Sales Territory	String	16	View
ENSPSNID	End Salesperson ID	String	16	View
ENDSHNAM	End Short Name	String	16	View
ENDSTATE	End State	String	30	View
ENUSRDF1	End User Defined 1	String	22	View
ENDZIPCD	End Zip Code	String	12	View
ENDINGDT	Ending Date	Date	4	View
ENCLDSCR	End Class Description	String	32	View
ENLSTNAM	End Last Name	String	22	View
ENDVENDR	End Vendor	String	16	View
ENDEMPLY	End Employee	String	16	View
ENDCITY	End City	String	36	View
ENDOCNUM	End Document Number	String	22	View
ENDOCTYP	End Document Type	Integer	2	View
ENDPEROD	End Period	Integer	2	View
ENDPSTDT	End Post Date	Date	4	View
ENDBNMBR	End Batch Number	String	16	View
ENBCHSRC	End Batch Source	String	16	View
ENTRXSRC	End TRX Source	String	14	View
ENRMTKDT	End RM Token Date	Integer	2	View
ENSLSAMT	End Sales Amount	Currency	10	View
ENPRMRGN	End Profit Margin	Currency	10	View
STRTFLNM	Start Full Name	String	42	View
STRMTKDT	Start RM Token Date	Integer	2	View
STADDCTT	Start Address Contact	String	62	View
STTCLSID	Start Class ID	String	16	View
STCUSTID	Start Customer ID	String	16	View
STCUSTNM	Start Customer Name	String	66	View
STRTDATE	Start Date	Date	4	View
STRTNGDT	Starting Date	Date	4	View
STTPHON1	Start Phone 1	String	22	View
STSLSTER	Start Sales Territory	String	16	View
STSPRSID	Start Salesperson ID	String	16	View
STTSHNAM	Start Short Name	String	16	View
STTSTATE	Start State	String	30	View
STTUDEF1	Start User Defined 1	String	22	View
STRTZPCD	Start Zip Code	String	12	View
STCLSDSC	Start Class Description	String	32	View
STTLSTNM	Start Last Name	String	22	View
STRTVNDR	Start Vendor	String	16	View
STRTEMPL	Start Employee	String	16	View
STRTCITY	Start City	String	36	View
STMTCYCL	Statement Cycle 1. No Statement 2. Weekly 3. Biweekly 4. Semi Monthly 5. Monthly 6. Bimonthly 7. Quarterly	Integer	2	View
ENSTCYCL	End Statement Cycle	Integer	2	View
STDOCNUM	Start Document Number	String	22	View
STTDOCTP	Start Document type	Integer	2	View
STTDOCDT	Start Document Date	Date	4	View
STPERIOD	Start Period	Integer	2	View
STTPSTDT	Start Post Date	Date	4	View
STBCHNUM	Start Batch Number	String	16	View
STBCHSRC	Start Batch Source	String	16	View
STRXSRC	Start TRX Source	String	14	View
STPRMRGN	Start Profit Margin	Currency	10	View
STSLSAMT	Start Sales Amount	Currency	10	View
INACTIVE	Inactive	Boolean	2	View
BALNCTYP	Balance Type	Integer	2	View
ACTIVE	Active 0 = False, for inactive records 1 = True, for active records	Boolean	2	View
HISTTYPE	History Type	Integer	2	View
TRANTOPR	Transferred to PR	Boolean	2	View
PRNTDTLD	Print Detailed	Boolean	2	View
CUTOFDAT	Cutoff Date	Date	4	View
CRBLNCCB	Credit Balance CB	Boolean	2	View
FLLYPDCB	Fully Paid CB	Boolean	2	View
NOACTVCB	No Activity CB	Boolean	2	View
ZROBALCB	Zero Balance CB	Boolean	2	View
PASTDUCB	Past Due CB	Boolean	2	View
WHICHRPT	Which Report	Integer	2	View
PERTYPGB	Period Type GB	Integer	2	View
YEAR1	Year	Integer	2	View
STTACNUM_1	Start Account Number:Account_Segment_Pool1	String	10	View
STTACNUM_2	Start Account Number:Account_Segment_Pool2	String	10	View
STTACNUM_3	Start Account Number:Account_Segment_Pool3	String	10	View
STTACNUM_4	Start Account Number:Account_Segment_Pool4	String	10	View
STTACNUM_5	Start Account Number:Account_Segment_Pool5	String	10	View
EACCNBR_1	End Account Number:Account_Segment_Pool1	String	10	View
EACCNBR_2	End Account Number:Account_Segment_Pool2	String	10	View
EACCNBR_3	End Account Number:Account_Segment_Pool3	String	10	View
EACCNBR_4	End Account Number:Account_Segment_Pool4	String	10	View
EACCNBR_5	End Account Number:Account_Segment_Pool5	String	10	View
SEGMNTRG	Using Segment Range	Integer	2	View
ENITMNBR	End Item Number	String	32	View
ENDSERLT	End Serial/Lot Number	String	22	View
STTITNUM	Start Item Number	String	32	View
STRTSRLT	Start Serial/Lot Number	String	22	View
TRXTYPE	Transaction Type	Integer	2	View
INCLTXDT	Include Tax Details	Boolean	2	View
INCLPYMT	Include Payments	Boolean	2	View
STQUOEXD	Start Quote Expiration Date	Date	4	View
EDQUOEXD	End Quote Expiration Date	Date	4	View
STREQDAT	Start Requested Ship Date	Date	4	View
ENDREQDT	End Requested Ship Date	Date	4	View
STTLOCCD	Start Location Code	String	12	View
ENLOCNCD	End Location Code	String	12	View
STMSTNMB	Start Master Number	Long Integer	4	View
EDMASNMB	End Master Number	Long Integer	4	View
STPRHDID	Start Process Hold ID	String	16	View
ENPRHDID	End Process Hold ID	String	16	View
STTDOCID	Start Document ID	String	16	View
ENDDOCID	End Document ID	String	16	View
STSOPTYP	Start SOP Type	Integer	2	View
EDSOPTYP	End SOP Type	Integer	2	View
DISCOMP	Display Components	Boolean	2	View
DISPRCHD	Display Process Holds	Boolean	2	View
DISSRLOT	Display Serial/Lot Number	Boolean	2	View
DISUSRDF	Display User Defined	Boolean	2	View
EXCCOMP	Exclude Components	Boolean	2	View
EXCFULFIL	Exclude Fulfilled	Boolean	2	View
INCMCINF	Include Multicurrency Info	Boolean	2	View
RPTXRATE	Reporting Exchange Rate	Currency (Variable)	10	View
RPRTCLMD	Reporting Rate Calculation Method	Integer	2	View
PRTCURIN	Print Currency In	Integer	2	View
CONNAACT	Consolidate National Account Activity	Boolean	2	View
DateSensitivitySumSelect	Date Sensitivity Summary Select	Integer	2	View
SummaryYear	Summary Year	Integer	2	View

RM00700 - RM Report Options

Query Builder

Customer Service

Information

My Account

Contact Us