RM40101 - RM Module Setup File | Prospr - Dynamics GP Table Reference

RM40101 - RM Module Setup File

Query Builder

Select * from RM40101

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
SETUPKEY	Setup Key	Integer	2	View
AGEBY	Age By	Integer	2	View
AGPEREND_1	Aging Periods End[1]	Integer	2	View
AGPEREND_2	Aging Periods End[2]	Integer	2	View
AGPEREND_3	Aging Periods End[3]	Integer	2	View
AGPEREND_4	Aging Periods End[4]	Integer	2	View
AGPEREND_5	Aging Periods End[5]	Integer	2	View
AGPEREND_6	Aging Periods End[6]	Integer	2	View
AGPEREND_7	Aging Periods End[7]	Integer	2	View
AGPERUSD	Aging Periods Used	Integer	2	View
CRLMPSWD	Credit Limit Password	String	12	View
CUSTHPWD	Customer Hold Password	String	12	View
WRTFPSWD	Writeoff Password	String	12	View
WVFCHPWD	Waived Finance Charge Password	String	12	View
PRTHATRB	Print Historical Aged Trial Balance	Boolean	2	View
CPDFINCH	Compound Finance Charge	Boolean	2	View
RMTRKDAV	RM Track Discounts Available	Boolean	2	View
RMPCAIPD	RM Pay Commissions After Invoice Paid	Boolean	2	View
NSFCHDEF	NSF Charge Default	Currency	10	View
APLBYDEF	Apply By Default	Integer	2	View
LDFNCHGD	Last Date Finance Charged	Date	4	View
LDSTPRTD	Last Date Statements Printed	Date	4	View
LDBLFAGD	Last Date Balance Forward Aged	Date	4	View
LDOITAGD	Last Date Open Items Aged	Date	4	View
LDPTRRMV	Last Date Paid Transactions Removal	Date	4	View
LSTYECAL	Last Year End Calendar	Date	4	View
LSTYEFSC	Last Year End Fiscal	Date	4	View
USRDFPR1	User Defined Prompt 1	String	16	View
USRDRPR2	User Defined Prompt 2	String	16	View
FRTSCHID	Freight Schedule ID	String	16	View
SLSCHDID	Sales Schedule ID	String	16	View
MSCSCHID	Misc Schedule ID	String	16	View
CHEKBKID	Checkbook ID	String	16	View
SALESCB	Sales CB	Boolean	2	View
DISCNTCB	Discount CB	Boolean	2	View
FREIGHT	Freight	Boolean	2	View
MISC	Misc	Boolean	2	View
TAX	Tax	Boolean	2	View
RMVDSTTY_1	RM Valid Dist Types[1]	Long Integer	4	View
RMVDSTTY_2	RM Valid Dist Types[2]	Long Integer	4	View
RMVDSTTY_3	RM Valid Dist Types[3]	Long Integer	4	View
RMVDSTTY_4	RM Valid Dist Types[4]	Long Integer	4	View
RMVDSTTY_5	RM Valid Dist Types[5]	Long Integer	4	View
RMVDSTTY_6	RM Valid Dist Types[6]	Long Integer	4	View
RMVDSTTY_7	RM Valid Dist Types[7]	Long Integer	4	View
RMVDSTTY_8	RM Valid Dist Types[8]	Long Integer	4	View
RMVDSTTY_9	RM Valid Dist Types[9]	Long Integer	4	View
LDCMTRNS	Last Date Commissions Transferred	Date	4	View
PRCLEVEL	PriceLevel	String	12	View
RMDFTyp	RM Document Format Type	Integer	2	View
DelUPDoc	Delete Unposted Printed Docs	Boolean	2	View
PrntTaxDetDoc	Print Tax Details On Documents	Boolean	2	View
RPRNTSTTMNTS	Reprint Statements	Boolean	2	View
ATAPPLFNNCCHRGSFRST	Auto Apply Finance Charges First	Boolean	2	View
EmailStmtStatusRecipient	Email Statements Status Recipient	String	82	View
DateSensitivitySumView	Date Sensitivity Summary View	Integer	2	View
PRNTDCUR	Print Dual Currencies	Boolean	2	View
AGEUNAPPLDCR	Age Unapplied Credit Amounts	Boolean	2	View
WriteoffCreditMemoNumber	Writeoff Credit Memo Number	String	22	View
WriteoffDebitMemoNumber	Writeoff Debit Memo Number	String	22	View
USRDRPR3	User Defined Prompt 3	String	16	View
USRDRPR4	User Defined Prompt 4	String	16	View

RM40101 - RM Module Setup File

Query Builder

Customer Service

Information

My Account

Contact Us