RM00102 - Customer Master Address File | Prospr - Dynamics GP Table Reference

RM00102 - Customer Master Address File

Query Builder

Select * from RM00102

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CUSTNMBR	Customer Number	String	16	View
ADRSCODE	Address Code	String	16	View
SLPRSNID	Salesperson ID	String	16	View
UPSZONE	UPS Zone	String	4	View
SHIPMTHD	Shipping Method	String	16	View
TAXSCHID	Tax Schedule ID	String	16	View
CNTCPRSN	Contact Person	String	62	View
ADDRESS1	Address 1	String	62	View
ADDRESS2	Address 2	String	62	View
ADDRESS3	Address 3	String	62	View
COUNTRY	Country	String	62	View
CITY	City	String	36	View
STATE	State	String	30	View
ZIP	Zip	String	12	View
PHONE1	Phone 1	String	22	View
PHONE2	Phone 2	String	22	View
PHONE3	Phone 3	String	22	View
FAX	Fax	String	22	View
MODIFDT	Modified Date	Date	4	View
CREATDDT	Created Date	Date	4	View
GPSFOINTEGRATIONID	GPSFO Integration ID	String	32	View
INTEGRATIONSOURCE	Integration Source	Integer	2	View
INTEGRATIONID	Integration ID	String	32	View
CCode	Country Code	String	8	View
DECLID	Declarant ID	String	16	View
LOCNCODE	Location Code	String	12	View
SALSTERR	Sales Territory	String	16	View
USERDEF1	User Defined 1	String	22	View
USERDEF2	User Defined 2	String	22	View
ShipToName	ShipToName	String	66	View
Print_Phone_NumberGB	Print Phone Number GB	Integer	2	View