RM00301 - RM Salesperson Master | Prospr - Dynamics GP Table Reference

RM00301 - RM Salesperson Master

Select * from RM00301

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
SLPRSNID	Salesperson ID	String	16	View
EMPLOYID	Employee ID	String	16	View
VENDORID	Vendor ID	String	16	View
SLPRSNFN	Salespersons First Name	String	16	View
SPRSNSMN	Salespersons Middle Name	String	16	View
SPRSNSLN	Salespersons Last Name	String	22	View
ADDRESS1	Address 1	String	62	View
ADDRESS2	Address 2	String	62	View
ADDRESS3	Address 3	String	62	View
CITY	City	String	36	View
STATE	State	String	30	View
ZIP	Zip	String	12	View
COUNTRY	Country	String	62	View
PHONE1	Phone 1	String	22	View
PHONE2	Phone 2	String	22	View
PHONE3	Phone 3	String	22	View
FAX	Fax	String	22	View
INACTIVE	Inactive	Boolean	2	View
SALSTERR	Sales Territory	String	16	View
COMMCODE	Commission Code	String	16	View
COMPRCNT	Commission Percent	Integer	2	View
STDCPRCT	Standard Commission Percent	Integer	2	View
COMAPPTO	Commission Applied To	Integer	2	View
COSTTODT	Cost To Date	Currency	10	View
CSTLSTYR	Cost Last Year	Currency	10	View
TTLCOMTD	Total Commissions To Date	Currency	10	View
TTLCOMLY	Total Commissions Last Year	Currency	10	View
COMSLTDT	Commissioned Sales To Date	Currency	10	View
COMSLLYR	Commissioned Sales Last Year	Currency	10	View
NCOMSLTD	Non-Commissioned Sales To Date	Currency	10	View
NCOMSLYR	Non-Commissioned Sales Last Year	Currency	10	View
KPCALHST	Keep Calendar History	Boolean	2	View
KPERHIST	Keep Period History	Boolean	2	View
NOTEINDX	Note Index	Currency	10	View
MODIFDT	Modified Date	Date	4	View
CREATDDT	Created Date	Date	4	View
COMMDEST	Commission Destination	Integer	2	View