RM00201 - RM_Class_MSTR | Prospr - Dynamics GP Table Reference

RM00201 - RM_Class_MSTR

Query Builder

Select * from RM00201

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CLASSID	Class ID	String	16	View
CLASDSCR	Class Description	String	32	View
CRLMTTYP	Credit Limit Type	Integer	2	View
CRLMTAMT	Credit Limit Amount	Currency	10	View
CRLMTPER	Credit Limit Period	Integer	2	View
CRLMTPAM	Credit Limit Period Amount	Currency	10	View
DEFLTCLS	Default Class	Boolean	2	View
BALNCTYP	Balance Type	Integer	2	View
CHEKBKID	Checkbook ID	String	16	View
BANKNAME	Bank Name	String	32	View
TAXSCHID	Tax Schedule ID	String	16	View
SHIPMTHD	Shipping Method	String	16	View
PYMTRMID	Payment Terms ID	String	22	View
CUSTDISC	Customer Discount	Integer	2	View
CSTPRLVL	Customer Price Level	String	12	View
MINPYTYP	Minimum Payment Type	Integer	2	View
MINPYDLR	Minimum Payment Dollar	Currency	10	View
MINPYPCT	Minimum Payment Percent	Integer	2	View
MXWOFTYP	Maximum Writeoff Type	Integer	2	View
MXWROFAM	Max Writeoff Amount	Currency	10	View
FINCHARG	Finance Charge	Boolean	2	View
FNCHATYP	Finance Charge Amt Type	Integer	2	View
FINCHDLR	Finance Charge Dollar	Currency	10	View
FNCHPCNT	Finance Charge Percent	Integer	2	View
PRCLEVEL	PriceLevel	String	12	View
CURNCYID	Currency ID	String	16	View
RATETPID	Rate Type ID	String	16	View
DEFCACTY	Default Cash Account Type 0. Checkbook 1. Customer	Integer	2	View
RMCSHACC	RM Cash Account Index	Long Integer	4	View
RMARACC	RM AR Account Index	Long Integer	4	View
RMCOSACC	RM Cost Of Sales Account Index	Long Integer	4	View
RMIVACC	RM IV Account Index	Long Integer	4	View
RMSLSACC	RM Sales Account Index	Long Integer	4	View
RMAVACC	RM Discounts Avail Account Index	Long Integer	4	View
RMTAKACC	RM Discounts Taken Account Index	Long Integer	4	View
RMFCGACC	RM Finance Charge Account Index	Long Integer	4	View
RMWRACC	RM Writeoff Account Index	Long Integer	4	View
RMSORACC	RM Sales Order Returns Account Index	Long Integer	4	View
SALSTERR	Sales Territory	String	16	View
SLPRSNID	Salesperson ID	String	16	View
STMTCYCL	Statement Cycle 1. No Statement 2. Weekly 3. Biweekly 4. Semi Monthly 5. Monthly 6. Bimonthly 7. Quarterly	Integer	2	View
SNDSTMNT	Send Statement	Boolean	2	View
INACTIVE	Inactive	Boolean	2	View
KPCALHST	Keep Calendar History	Boolean	2	View
KPDSTHST	Keep Distribution History	Boolean	2	View
KPERHIST	Keep Period History	Boolean	2	View
KPTRXHST	Keep Trx History	Boolean	2	View
NOTEINDX	Note Index	Currency	10	View
MODIFDT	Modified Date	Date	4	View
CREATDDT	Created Date	Date	4	View
Revalue_Customer	Revalue Customer	Boolean	2	View
Post_Results_To	Post Results To	Integer	2	View
DISGRPER	Discount Grace Period	Integer	2	View
DUEGRPER	Due Date Grace Period	Integer	2	View
ORDERFULFILLDEFAULT	Order Fulfillment Shortage Default	Integer	2	View
CUSTPRIORITY	Customer Priority	Integer	2	View
RMOvrpymtWrtoffAcctIdx	RM Overpayment Writeoff Account Index	Long Integer	4	View
CBVAT	Cash Based VAT	Boolean	2	View
INCLUDEINDP	Include in Demand Planning	Boolean	2	View

RM00201 - RM_Class_MSTR

Query Builder

Customer Service

Information

My Account

Contact Us