VicsamMSCRMContacts

Name	Type	Length	Is Key	Nullable	Description
customer_ID	int		K	No	customer_ID
createdon	datetime			Si	createdon
modifiedon	datetime			Si	modifiedon
contactid	nvarchar	36	K	No	contactid
firstname	nvarchar	128		Si	firstname
lastname	nvarchar	128		Si	lastname
business2	nvarchar	256		Si	business2
emailaddress1	nvarchar	128		Si	emailaddress1
emailaddress2	nvarchar	128		Si	emailaddress2
home2	nvarchar	256		Si	home2
jobtitle	nvarchar	128		Si	jobtitle
mobilephone	nvarchar	128		Si	mobilephone
parentcustomerid_value	nvarchar	36		Si	parentcustomerid_value
telephone1	nvarchar	32		Si	telephone1
telephone2	nvarchar	32		Si	telephone2
ts_update	timestamp			No	ts_update
flg_isdeleted	bit			No	flg_isdeleted
dat_ultvar	datetime2			Si	dat_ultvar
Id	int			No	Id