CRM Contact

Table

CRM Contact

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

#	Name	Type
1	ContactId (ContactId)	GUID	ExternalName: contactid ExternalType: Uniqueidentifier ExternalAccess: Insert Description: Unique identifier of the contact.
2	DefaultPriceLevelId (DefaultPriceLevelId)	GUID	ExternalName: defaultpricelevelid ExternalType: Lookup Description: Choose the default price list associated with the contact to make sure the correct product prices for this customer are applied in sales opportunities, quotes, and orders. TableRelation: "CRM Pricelevel".PriceLevelId
3	CustomerSizeCode (CustomerSizeCode)	Option	DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: customersizecode ExternalType: Picklist Description: Select the size of the contact's company for segmentation and reporting purposes.
4	CustomerTypeCode (CustomerTypeCode)	Option	DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: customertypecode ExternalType: Picklist Description: Select the category that best describes the relationship between the contact and your organization.
5	PreferredContactMethodCode (PreferredContactMethodCode)	Option	[Any,Email,Phone,Fax,Mail] OptionOrdinalValues: [1;2;3;4;5] InitValue: Any ExternalName: preferredcontactmethodcode ExternalType: Picklist Description: Select the preferred method of contact.
6	LeadSourceCode (LeadSourceCode)	Option	DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: leadsourcecode ExternalType: Picklist Description: Select the primary marketing source that directed the contact to your organization.
7	OwningBusinessUnit (OwningBusinessUnit)	GUID	ExternalName: owningbusinessunit ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the business unit that owns the contact. TableRelation: "CRM Businessunit".BusinessUnitId
8	OwningUser (OwningUser)	GUID	ExternalName: owninguser ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the user who owns the contact. TableRelation: "CRM Systemuser".SystemUserId
9	PaymentTermsCode (PaymentTermsCode)	Option	[ ,Net30,2%10Net30,Net45,Net60] OptionOrdinalValues: [-1;1;2;3;4] InitValue: [ ] ExternalName: paymenttermscode ExternalType: Picklist Description: Select the payment terms to indicate when the customer needs to pay the total amount.
10	ShippingMethodCode (ShippingMethodCode)	Option	DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: shippingmethodcode ExternalType: Picklist Description: Select a shipping method for deliveries sent to this address.
11	AccountId (AccountId)	GUID	ExternalName: accountid ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the account with which the contact is associated. TableRelation: "CRM Account".AccountId
12	ParticipatesInWorkflow (ParticipatesInWorkflow)	Boolean	ExternalName: participatesinworkflow ExternalType: Boolean Description: Shows whether the contact participates in workflow rules.
13	IsBackofficeCustomer (IsBackofficeCustomer)	Boolean	ExternalName: isbackofficecustomer ExternalType: Boolean Description: Select whether the contact exists in a separate accounting or other system, such as Microsoft Dynamics GP or another ERP database, for use in integration processes.
14	Salutation (Salutation)	Text100	ExternalName: salutation ExternalType: String Description: Type the salutation of the contact to make sure the contact is addressed correctly in sales calls, email messages, and marketing campaigns.
15	JobTitle (JobTitle)	Text100	ExternalName: jobtitle ExternalType: String Description: Type the job title of the contact to make sure the contact is addressed correctly in sales calls, email, and marketing campaigns.
16	FirstName (FirstName)	Text50	ExternalName: firstname ExternalType: String Description: Type the contact's first name to make sure the contact is addressed correctly in sales calls, email, and marketing campaigns.
17	Department (Department)	Text100	ExternalName: department ExternalType: String Description: Type the department or business unit where the contact works in the parent company or business.
18	NickName (NickName)	Text50	ExternalName: nickname ExternalType: String Description: Type the contact's nickname.
19	MiddleName (MiddleName)	Text50	ExternalName: middlename ExternalType: String Description: Type the contact's middle name or initial to make sure the contact is addressed correctly.
20	LastName (LastName)	Text50	ExternalName: lastname ExternalType: String Description: Type the contact's last name to make sure the contact is addressed correctly in sales calls, email, and marketing campaigns.
21	Suffix (Suffix)	Text10	ExternalName: suffix ExternalType: String Description: Type the suffix used in the contact's name, such as Jr. or Sr. to make sure the contact is addressed correctly in sales calls, email, and marketing campaigns.
22	YomiFirstName (YomiFirstName)	Text150	ExternalName: yomifirstname ExternalType: String Description: Type the phonetic spelling of the contact's first name, if the name is specified in Japanese, to make sure the name is pronounced correctly in phone calls with the contact.
23	FullName (FullName)	Text160	ExternalName: fullname ExternalType: String ExternalAccess: Read Description: Combines and shows the contact's first and last names so that the full name can be displayed in views and reports.
24	YomiMiddleName (YomiMiddleName)	Text150	ExternalName: yomimiddlename ExternalType: String Description: Type the phonetic spelling of the contact's middle name, if the name is specified in Japanese, to make sure the name is pronounced correctly in phone calls with the contact.
25	YomiLastName (YomiLastName)	Text150	ExternalName: yomilastname ExternalType: String Description: Type the phonetic spelling of the contact's last name, if the name is specified in Japanese, to make sure the name is pronounced correctly in phone calls with the contact.
26	Anniversary (Anniversary)	Date	ExternalName: anniversary ExternalType: DateTime Description: Enter the date of the contact's wedding or service anniversary for use in customer gift programs or other communications.
27	BirthDate (BirthDate)	Date	ExternalName: birthdate ExternalType: DateTime Description: Enter the contact's birthday for use in customer gift programs or other communications.
28	GovernmentId (GovernmentId)	Text50	ExternalName: governmentid ExternalType: String Description: Type the passport number or other government ID for the contact for use in documents or reports.
29	YomiFullName (YomiFullName)	Text250	ExternalName: yomifullname ExternalType: String ExternalAccess: Read Description: Shows the combined Yomi first and last names of the contact so that the full phonetic name can be displayed in views and reports.
30	Description (Description)	BLOB [Memo]	ExternalName: description ExternalType: Memo Description: Type additional information to describe the contact, such as an excerpt from the company's website.
31	EmployeeId (EmployeeId)	Text50	ExternalName: employeeid ExternalType: String Description: Type the employee ID or number for the contact for reference in orders, service cases, or other communications with the contact's organization.
32	GenderCode (GenderCode)	Option	[ ,Male,Female] OptionOrdinalValues: [-1;1;2] InitValue: [ ] ExternalName: gendercode ExternalType: Picklist Description: Select the contact's gender to make sure the contact is addressed correctly in sales calls, email, and marketing campaigns.
33	AnnualIncome (AnnualIncome)	Decimal	ExternalName: annualincome ExternalType: Money Description: Type the contact's annual income for use in profiling and financial analysis.
34	HasChildrenCode (HasChildrenCode)	Option	DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: haschildrencode ExternalType: Picklist Description: Select whether the contact has any children for reference in follow-up phone calls and other communications.
35	EducationCode (EducationCode)	Option	DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: educationcode ExternalType: Picklist Description: Select the contact's highest level of education for use in segmentation and analysis.
36	WebSiteUrl (WebSiteUrl)	Text200 [URL]	ExternalName: websiteurl ExternalType: String Description: Type the contact's professional or personal website or blog URL.
37	FamilyStatusCode (FamilyStatusCode)	Option	[ ,Single,Married,Divorced,Widowed] OptionOrdinalValues: [-1;1;2;3;4] InitValue: [ ] ExternalName: familystatuscode ExternalType: Picklist Description: Select the marital status of the contact for reference in follow-up phone calls and other communications.
38	FtpSiteUrl (FtpSiteUrl)	Text200 [URL]	ExternalName: ftpsiteurl ExternalType: String Description: Type the URL for the contact's FTP site to enable users to access data and share documents.
39	EMailAddress1 (EMailAddress1)	Text100 [E-Mail]	ExternalName: emailaddress1 ExternalType: String Description: Type the primary email address for the contact.
40	SpousesName (SpousesName)	Text100	ExternalName: spousesname ExternalType: String Description: Type the name of the contact's spouse or partner for reference during calls, events, or other communications with the contact.
41	AssistantName (AssistantName)	Text100	ExternalName: assistantname ExternalType: String Description: Type the name of the contact's assistant.
42	EMailAddress2 (EMailAddress2)	Text100 [E-Mail]	ExternalName: emailaddress2 ExternalType: String Description: Type the secondary email address for the contact.
43	AssistantPhone (AssistantPhone)	Text50	ExternalName: assistantphone ExternalType: String Description: Type the phone number for the contact's assistant.
44	EMailAddress3 (EMailAddress3)	Text100 [E-Mail]	ExternalName: emailaddress3 ExternalType: String Description: Type an alternate email address for the contact.
45	DoNotPhone (DoNotPhone)	Boolean	ExternalName: donotphone ExternalType: Boolean Description: Select whether the contact accepts phone calls. If Do Not Allow is selected, the contact will be excluded from any phone call activities distributed in marketing campaigns.
46	ManagerName (ManagerName)	Text100	ExternalName: managername ExternalType: String Description: Type the name of the contact's manager for use in escalating issues or other follow-up communications with the contact.
47	ManagerPhone (ManagerPhone)	Text50	ExternalName: managerphone ExternalType: String Description: Type the phone number for the contact's manager.
48	DoNotFax (DoNotFax)	Boolean	ExternalName: donotfax ExternalType: Boolean Description: Select whether the contact allows faxes. If Do Not Allow is selected, the contact will be excluded from any fax activities distributed in marketing campaigns.
49	DoNotEMail (DoNotEMail)	Boolean	ExternalName: donotemail ExternalType: Boolean Description: Select whether the contact allows direct email sent from Microsoft Dynamics CRM. If Do Not Allow is selected, Microsoft Dynamics CRM will not send the email.
50	DoNotPostalMail (DoNotPostalMail)	Boolean	ExternalName: donotpostalmail ExternalType: Boolean Description: Select whether the contact allows direct mail. If Do Not Allow is selected, the contact will be excluded from letter activities distributed in marketing campaigns.
51	DoNotBulkEMail (DoNotBulkEMail)	Boolean	ExternalName: donotbulkemail ExternalType: Boolean Description: Select whether the contact accepts bulk email sent through marketing campaigns or quick campaigns. If Do Not Allow is selected, the contact can be added to marketing lists, but will be excluded from the email.
52	DoNotBulkPostalMail (DoNotBulkPostalMail)	Boolean	ExternalName: donotbulkpostalmail ExternalType: Boolean Description: Select whether the contact accepts bulk postal mail sent through marketing campaigns or quick campaigns. If Do Not Allow is selected, the contact can be added to marketing lists, but will be excluded from the letters.
53	AccountRoleCode (AccountRoleCode)	Option	[ ,DecisionMaker,Employee,Influencer] OptionOrdinalValues: [-1;1;2;3] InitValue: [ ] ExternalName: accountrolecode ExternalType: Picklist Description: Select the contact's role within the company or sales process, such as decision maker, employee, or influencer.
54	TerritoryCode (TerritoryCode)	Option	DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: territorycode ExternalType: Picklist Description: Select a region or territory for the contact for use in segmentation and analysis.
55	CreditLimit (CreditLimit)	Decimal	ExternalName: creditlimit ExternalType: Money Description: Type the credit limit of the contact for reference when you address invoice and accounting issues with the customer.
56	CreatedOn (CreatedOn)	DateTime	ExternalName: createdon ExternalType: DateTime ExternalAccess: Read Description: Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics CRM options.
57	CreditOnHold (CreditOnHold)	Boolean	ExternalName: creditonhold ExternalType: Boolean Description: Select whether the contact is on a credit hold, for reference when addressing invoice and accounting issues.
58	CreatedBy (CreatedBy)	GUID	ExternalName: createdby ExternalType: Lookup ExternalAccess: Read Description: Shows who created the record. TableRelation: "CRM Systemuser".SystemUserId
59	ModifiedOn (ModifiedOn)	DateTime	ExternalName: modifiedon ExternalType: DateTime ExternalAccess: Read Description: Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics CRM options.
60	ModifiedBy (ModifiedBy)	GUID	ExternalName: modifiedby ExternalType: Lookup ExternalAccess: Read Description: Shows who last updated the record. TableRelation: "CRM Systemuser".SystemUserId
61	NumberOfChildren (NumberOfChildren)	Integer	MaxValue: 1000000000 ExternalName: numberofchildren ExternalType: Integer Description: Type the number of children the contact has for reference in follow-up phone calls and other communications.
62	ChildrensNames (ChildrensNames)	Text250	ExternalName: childrensnames ExternalType: String Description: Type the names of the contact's children for reference in communications and client programs.
63	VersionNumber (VersionNumber)	BigInteger	ExternalName: versionnumber ExternalType: BigInt ExternalAccess: Read Description: Version number of the contact.
64	MobilePhone (MobilePhone)	Text50	ExternalName: mobilephone ExternalType: String Description: Type the mobile phone number for the contact.
65	Pager (Pager)	Text50	ExternalName: pager ExternalType: String Description: Type the pager number for the contact.
66	Telephone1 (Telephone1)	Text50	ExternalName: telephone1 ExternalType: String Description: Type the main phone number for this contact.
67	Telephone2 (Telephone2)	Text50	ExternalName: telephone2 ExternalType: String Description: Type a second phone number for this contact.
68	Telephone3 (Telephone3)	Text50	ExternalName: telephone3 ExternalType: String Description: Type a third phone number for this contact.
69	Fax (Fax)	Text50	ExternalName: fax ExternalType: String Description: Type the fax number for the contact.
70	Aging30 (Aging30)	Decimal	ExternalName: aging30 ExternalType: Money ExternalAccess: Read Description: For system use only.
71	StateCode (StateCode)	Option	[Active,Inactive] OptionOrdinalValues: [0;1] InitValue: Active ExternalName: statecode ExternalType: State ExternalAccess: Modify Description: Shows whether the contact is active or inactive. Inactive contacts are read-only and can't be edited unless they are reactivated.
72	Aging60 (Aging60)	Decimal	ExternalName: aging60 ExternalType: Money ExternalAccess: Read Description: For system use only.
73	StatusCode (StatusCode)	Option	[ ,Active,Inactive] OptionOrdinalValues: [-1;1;2] InitValue: [ ] ExternalName: statuscode ExternalType: Status Description: Select the contact's status.
74	Aging90 (Aging90)	Decimal	ExternalName: aging90 ExternalType: Money ExternalAccess: Read Description: For system use only.
75	ParentContactId (ParentContactId)	GUID	ExternalName: parentcontactid ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the parent contact. TableRelation: "CRM Contact".ContactId
76	ParentContactIdName (ParentContactIdName)	Text160	ExternalName: parentcontactidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Contact".FullName WHERE (ContactId=FIELD(ParentContactId)))	FlowField
77	AccountIdName (AccountIdName)	Text160	ExternalName: accountidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Account".Name WHERE (AccountId=FIELD(AccountId)))	FlowField
78	DefaultPriceLevelIdName (DefaultPriceLevelIdName)	Text100	ExternalName: defaultpricelevelidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Pricelevel".Name WHERE (PriceLevelId=FIELD(DefaultPriceLevelId)))	FlowField
79	Address1_AddressId (Address1_AddressId)	GUID	ExternalName: address1_addressid ExternalType: Uniqueidentifier Description: Unique identifier for address 1.
80	Address1_AddressTypeCode (Address1_AddressTypeCode)	Option	[ ,BillTo,ShipTo,Primary,Other] OptionOrdinalValues: [-1;1;2;3;4] InitValue: [ ] ExternalName: address1_addresstypecode ExternalType: Picklist Description: Select the primary address type.
81	Address1_Name (Address1_Name)	Text200	ExternalName: address1_name ExternalType: String Description: Type a descriptive name for the primary address, such as Corporate Headquarters.
82	Address1_PrimaryContactName (Address1_PrimaryContactName)	Text100	ExternalName: address1_primarycontactname ExternalType: String Description: Type the name of the main contact at the account's primary address.
83	Address1_Line1 (Address1_Line1)	Text250	ExternalName: address1_line1 ExternalType: String Description: Type the first line of the primary address.
84	Address1_Line2 (Address1_Line2)	Text250	ExternalName: address1_line2 ExternalType: String Description: Type the second line of the primary address.
85	Address1_Line3 (Address1_Line3)	Text250	ExternalName: address1_line3 ExternalType: String Description: Type the third line of the primary address.
86	Address1_City (Address1_City)	Text80	ExternalName: address1_city ExternalType: String Description: Type the city for the primary address.
87	Address1_StateOrProvince (Address1_StateOrProvince)	Text50	ExternalName: address1_stateorprovince ExternalType: String Description: Type the state or province of the primary address.
88	Address1_County (Address1_County)	Text50	ExternalName: address1_county ExternalType: String Description: Type the county for the primary address.
89	Address1_Country (Address1_Country)	Text80	ExternalName: address1_country ExternalType: String Description: Type the country or region for the primary address.
90	Address1_PostOfficeBox (Address1_PostOfficeBox)	Text20	ExternalName: address1_postofficebox ExternalType: String Description: Type the post office box number of the primary address.
91	Address1_PostalCode (Address1_PostalCode)	Text20	ExternalName: address1_postalcode ExternalType: String Description: Type the ZIP Code or postal code for the primary address.
92	Address1_UTCOffset (Address1_UTCOffset)	Integer	MinValue: -1500 MaxValue: 1500 ExternalName: address1_utcoffset ExternalType: Integer Description: Select the time zone, or UTC offset, for this address so that other people can reference it when they contact someone at this address.
93	Address1_FreightTermsCode (Address1_FreightTermsCode)	Option	[ ,FOB,NoCharge] OptionOrdinalValues: [-1;1;2] InitValue: [ ] ExternalName: address1_freighttermscode ExternalType: Picklist Description: Select the freight terms for the primary address to make sure shipping orders are processed correctly.
94	Address1_UPSZone (Address1_UPSZone)	Text4	ExternalName: address1_upszone ExternalType: String Description: Type the UPS zone of the primary address to make sure shipping charges are calculated correctly and deliveries are made promptly, if shipped by UPS.
95	Address1_Latitude (Address1_Latitude)	Decimal	ExternalName: address1_latitude ExternalType: Double Description: Type the latitude value for the primary address for use in mapping and other applications.
96	Address1_Telephone1 (Address1_Telephone1)	Text50	ExternalName: address1_telephone1 ExternalType: String Description: Type the main phone number associated with the primary address.
97	Address1_Longitude (Address1_Longitude)	Decimal	ExternalName: address1_longitude ExternalType: Double Description: Type the longitude value for the primary address for use in mapping and other applications.
98	Address1_ShippingMethodCode (Address1_ShippingMethodCode)	Option	[ ,Airborne,DHL,FedEx,UPS,PostalMail,FullLoad,WillCall] OptionOrdinalValues: [-1;1;2;3;4;5;6;7] InitValue: [ ] ExternalName: address1_shippingmethodcode ExternalType: Picklist Description: Select a shipping method for deliveries sent to this address.
99	Address1_Telephone2 (Address1_Telephone2)	Text50	ExternalName: address1_telephone2 ExternalType: String Description: Type a second phone number associated with the primary address.
100	Address1_Telephone3 (Address1_Telephone3)	Text50	ExternalName: address1_telephone3 ExternalType: String Description: Type a third phone number associated with the primary address.
101	Address1_Fax (Address1_Fax)	Text50	ExternalName: address1_fax ExternalType: String Description: Type the fax number associated with the primary address.
102	Address2_AddressId (Address2_AddressId)	GUID	ExternalName: address2_addressid ExternalType: Uniqueidentifier Description: Unique identifier for address 2.
103	Address2_AddressTypeCode (Address2_AddressTypeCode)	Option	DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: address2_addresstypecode ExternalType: Picklist Description: Select the secondary address type.
104	Address2_Name (Address2_Name)	Text100	ExternalName: address2_name ExternalType: String Description: Type a descriptive name for the secondary address, such as Corporate Headquarters.
105	Address2_PrimaryContactName (Address2_PrimaryContactName)	Text100	ExternalName: address2_primarycontactname ExternalType: String Description: Type the name of the main contact at the account's secondary address.
106	Address2_Line1 (Address2_Line1)	Text250	ExternalName: address2_line1 ExternalType: String Description: Type the first line of the secondary address.
107	Address2_Line2 (Address2_Line2)	Text250	ExternalName: address2_line2 ExternalType: String Description: Type the second line of the secondary address.
108	Address2_Line3 (Address2_Line3)	Text250	ExternalName: address2_line3 ExternalType: String Description: Type the third line of the secondary address.
109	Address2_City (Address2_City)	Text80	ExternalName: address2_city ExternalType: String Description: Type the city for the secondary address.
110	Address2_StateOrProvince (Address2_StateOrProvince)	Text50	ExternalName: address2_stateorprovince ExternalType: String Description: Type the state or province of the secondary address.
111	Address2_County (Address2_County)	Text50	ExternalName: address2_county ExternalType: String Description: Type the county for the secondary address.
112	Address2_Country (Address2_Country)	Text80	ExternalName: address2_country ExternalType: String Description: Type the country or region for the secondary address.
113	Address2_PostOfficeBox (Address2_PostOfficeBox)	Text20	ExternalName: address2_postofficebox ExternalType: String Description: Type the post office box number of the secondary address.
114	Address2_PostalCode (Address2_PostalCode)	Text20	ExternalName: address2_postalcode ExternalType: String Description: Type the ZIP Code or postal code for the secondary address.
115	Address2_UTCOffset (Address2_UTCOffset)	Integer	MinValue: -1500 MaxValue: 1500 ExternalName: address2_utcoffset ExternalType: Integer Description: Select the time zone, or UTC offset, for this address so that other people can reference it when they contact someone at this address.
116	Address2_FreightTermsCode (Address2_FreightTermsCode)	Option	DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: address2_freighttermscode ExternalType: Picklist Description: Select the freight terms for the secondary address to make sure shipping orders are processed correctly.
117	Address2_UPSZone (Address2_UPSZone)	Text4	ExternalName: address2_upszone ExternalType: String Description: Type the UPS zone of the secondary address to make sure shipping charges are calculated correctly and deliveries are made promptly, if shipped by UPS.
118	Address2_Latitude (Address2_Latitude)	Decimal	ExternalName: address2_latitude ExternalType: Double Description: Type the latitude value for the secondary address for use in mapping and other applications.
119	Address2_Telephone1 (Address2_Telephone1)	Text50	ExternalName: address2_telephone1 ExternalType: String Description: Type the main phone number associated with the secondary address.
120	Address2_Longitude (Address2_Longitude)	Decimal	ExternalName: address2_longitude ExternalType: Double Description: Type the longitude value for the secondary address for use in mapping and other applications.
121	Address2_ShippingMethodCode (Address2_ShippingMethodCode)	Option	DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: address2_shippingmethodcode ExternalType: Picklist Description: Select a shipping method for deliveries sent to this address.
122	Address2_Telephone2 (Address2_Telephone2)	Text50	ExternalName: address2_telephone2 ExternalType: String Description: Type a second phone number associated with the secondary address.
123	Address2_Telephone3 (Address2_Telephone3)	Text50	ExternalName: address2_telephone3 ExternalType: String Description: Type a third phone number associated with the secondary address.
124	Address2_Fax (Address2_Fax)	Text50	ExternalName: address2_fax ExternalType: String Description: Type the fax number associated with the secondary address.
125	CreatedByName (CreatedByName)	Text200	ExternalName: createdbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedBy)))	FlowField
126	ModifiedByName (ModifiedByName)	Text200	ExternalName: modifiedbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedBy)))	FlowField
127	OwnerId (OwnerId)	GUID	ExternalName: ownerid ExternalType: Owner Description: Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. TableRelation: IF (OwnerIdType=CONST(systemuser)) "CRM Systemuser".SystemUserId ELSE IF (OwnerIdType=CONST(team)) "CRM Team".TeamId;
128	OwnerIdType (OwnerIdType)	Option	[ ,systemuser,team] ExternalName: owneridtype ExternalType: EntityName
129	PreferredSystemUserId (PreferredSystemUserId)	GUID	ExternalName: preferredsystemuserid ExternalType: Lookup Description: Choose the regular or preferred customer service representative for reference when scheduling service activities for the contact. TableRelation: "CRM Systemuser".SystemUserId
130	MasterId (MasterId)	GUID	ExternalName: masterid ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the master contact for merge. TableRelation: "CRM Contact".ContactId
131	PreferredAppointmentDayCode (PreferredAppointmentDayCode)	Option	[ ,Sunday,Monday,Tuesday,Wednesday,Thursday,Friday,Saturday] OptionOrdinalValues: [-1;0;1;2;3;4;5;6] InitValue: [ ] ExternalName: preferredappointmentdaycode ExternalType: Picklist Description: Select the preferred day of the week for service appointments.
132	PreferredAppointmentTimeCode (PreferredAppointmentTimeCode)	Option	[Morning,Afternoon,Evening] OptionOrdinalValues: [1;2;3] InitValue: Morning ExternalName: preferredappointmenttimecode ExternalType: Picklist Description: Select the preferred time of day for service appointments.
133	DoNotSendMM (DoNotSendMM)	Boolean	ExternalName: donotsendmm ExternalType: Boolean Description: Select whether the contact accepts marketing materials, such as brochures or catalogs. Contacts that opt out can be excluded from marketing initiatives.
134	ParentCustomerId (ParentCustomerId)	GUID	ExternalName: parentcustomerid ExternalType: Customer Description: Select the parent account or parent contact for the contact to provide a quick link to additional details, such as financial information, activities, and opportunities. TableRelation: IF (ParentCustomerIdType=CONST(account)) "CRM Account".AccountId ELSE IF (ParentCustomerIdType=CONST(contact)) "CRM Contact".ContactId;
135	Merged (Merged)	Boolean	ExternalName: merged ExternalType: Boolean ExternalAccess: Read Description: Shows whether the account has been merged with a master contact.
136	ExternalUserIdentifier (ExternalUserIdentifier)	Text50	ExternalName: externaluseridentifier ExternalType: String Description: Identifier for an external user.
137	LastUsedInCampaign (LastUsedInCampaign)	Date	ExternalName: lastusedincampaign ExternalType: DateTime ExternalAccess: Modify Description: Shows the date when the contact was last included in a marketing campaign or quick campaign.
138	MasterContactIdName (MasterContactIdName)	Text160	ExternalName: mastercontactidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Contact".FullName WHERE (ContactId=FIELD(MasterId)))	FlowField
139	PreferredSystemUserIdName (PreferredSystemUserIdName)	Text200	ExternalName: preferredsystemuseridname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(PreferredSystemUserId)))	FlowField
140	ParentCustomerIdType (ParentCustomerIdType)	Option	[ ,account,contact] ExternalName: parentcustomeridtype ExternalType: EntityName
141	TransactionCurrencyId (TransactionCurrencyId)	GUID	ExternalName: transactioncurrencyid ExternalType: Lookup Description: Choose the local currency for the record to make sure budgets are reported in the correct currency. TableRelation: "CRM Transactioncurrency".TransactionCurrencyId
142	OverriddenCreatedOn (OverriddenCreatedOn)	Date	ExternalName: overriddencreatedon ExternalType: DateTime ExternalAccess: Insert Description: Date and time that the record was migrated.
143	ExchangeRate (ExchangeRate)	Decimal	ExternalName: exchangerate ExternalType: Decimal ExternalAccess: Read Description: Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency.
144	ImportSequenceNumber (ImportSequenceNumber)	Integer	ExternalName: importsequencenumber ExternalType: Integer ExternalAccess: Insert Description: Unique identifier of the data import or data migration that created this record.
145	TimeZoneRuleVersionNumber (TimeZoneRuleVersionNumber)	Integer	MinValue: -1 ExternalName: timezoneruleversionnumber ExternalType: Integer Description: For internal use only.
146	UTCConversionTimeZoneCode (UTCConversionTimeZoneCode)	Integer	MinValue: -1 ExternalName: utcconversiontimezonecode ExternalType: Integer Description: Time zone code that was in use when the record was created.
147	AnnualIncome_Base (AnnualIncome_Base)	Decimal	ExternalName: annualincome_base ExternalType: Money ExternalAccess: Read Description: Shows the Annual Income field converted to the system's default base currency. The calculations use the exchange rate specified in the Currencies area.
148	CreditLimit_Base (CreditLimit_Base)	Decimal	ExternalName: creditlimit_base ExternalType: Money ExternalAccess: Read Description: Shows the Credit Limit field converted to the system's default base currency for reporting purposes. The calculations use the exchange rate specified in the Currencies area.
149	Aging60_Base (Aging60_Base)	Decimal	ExternalName: aging60_base ExternalType: Money ExternalAccess: Read Description: Shows the Aging 60 field converted to the system's default base currency. The calculations use the exchange rate specified in the Currencies area.
150	Aging90_Base (Aging90_Base)	Decimal	ExternalName: aging90_base ExternalType: Money ExternalAccess: Read Description: Shows the Aging 90 field converted to the system's default base currency. The calculations use the exchange rate specified in the Currencies area.
151	Aging30_Base (Aging30_Base)	Decimal	ExternalName: aging30_base ExternalType: Money ExternalAccess: Read Description: Shows the Aging 30 field converted to the system's default base currency. The calculations use the exchange rate specified in the Currencies area.
152	TransactionCurrencyIdName (TransactionCurrencyIdName)	Text100	ExternalName: transactioncurrencyidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Transactioncurrency".CurrencyName WHERE (TransactionCurrencyId=FIELD(TransactionCurrencyId)))	FlowField
153	CreatedOnBehalfBy (CreatedOnBehalfBy)	GUID	ExternalName: createdonbehalfby ExternalType: Lookup ExternalAccess: Read Description: Shows who created the record on behalf of another user. TableRelation: "CRM Systemuser".SystemUserId
154	CreatedOnBehalfByName (CreatedOnBehalfByName)	Text200	ExternalName: createdonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedOnBehalfBy)))	FlowField
155	ModifiedOnBehalfBy (ModifiedOnBehalfBy)	GUID	ExternalName: modifiedonbehalfby ExternalType: Lookup ExternalAccess: Read Description: Shows who last updated the record on behalf of another user. TableRelation: "CRM Systemuser".SystemUserId
156	ModifiedOnBehalfByName (ModifiedOnBehalfByName)	Text200	ExternalName: modifiedonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedOnBehalfBy)))	FlowField
157	OwningTeam (OwningTeam)	GUID	ExternalName: owningteam ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the team who owns the contact. TableRelation: "CRM Team".TeamId
158	StageId (StageId)	GUID	ExternalName: stageid ExternalType: Uniqueidentifier Description: Shows the ID of the stage.
159	ProcessId (ProcessId)	GUID	ExternalName: processid ExternalType: Uniqueidentifier Description: Shows the ID of the process.
160	Address2_Composite (Address2_Composite)	BLOB [Memo]	ExternalName: address2_composite ExternalType: Memo ExternalAccess: Read Description: Shows the complete secondary address.
161	Address1_Composite (Address1_Composite)	BLOB [Memo]	ExternalName: address1_composite ExternalType: Memo ExternalAccess: Read Description: Shows the complete primary address.
162	EntityImageId (EntityImageId)	GUID	ExternalName: entityimageid ExternalType: Uniqueidentifier ExternalAccess: Read Description: For internal use only.
163	TraversedPath (TraversedPath)	Text250	ExternalName: traversedpath ExternalType: String Description: For internal use only.
164	Address3_Country (Address3_Country)	Text80	ExternalName: address3_country ExternalType: String Description: the country or region for the 3rd address.
165	Address3_Line1 (Address3_Line1)	Text250	ExternalName: address3_line1 ExternalType: String Description: the first line of the 3rd address.
166	Address3_Line2 (Address3_Line2)	Text250	ExternalName: address3_line2 ExternalType: String Description: the second line of the 3rd address.
167	Address3_Line3 (Address3_Line3)	Text250	ExternalName: address3_line3 ExternalType: String Description: the third line of the 3rd address.
168	Address3_PostalCode (Address3_PostalCode)	Text20	ExternalName: address3_postalcode ExternalType: String Description: the ZIP Code or postal code for the 3rd address.
169	Address3_PostOfficeBox (Address3_PostOfficeBox)	Text20	ExternalName: address3_postofficebox ExternalType: String Description: the post office box number of the 3rd address.
170	Address3_StateOrProvince (Address3_StateOrProvince)	Text50	ExternalName: address3_stateorprovince ExternalType: String Description: the state or province of the third address.
171	Address3_City (Address3_City)	Text80	ExternalName: address3_city ExternalType: String Description: Type the city for the 3rd address.
172	Business2 (Business2)	Text50	ExternalName: business2 ExternalType: String Description: Type a second business phone number for this contact.
173	Callback (Callback)	Text50	ExternalName: callback ExternalType: String Description: Type a callback phone number for this contact.
174	Company (Company)	Text50	ExternalName: company ExternalType: String Description: Type the company phone of the contact.
175	Home2 (Home2)	Text50	ExternalName: home2 ExternalType: String Description: Type a second home phone number for this contact.
176	Address3_AddressId (Address3_AddressId)	GUID	ExternalName: address3_addressid ExternalType: Uniqueidentifier Description: Unique identifier for address 3.
177	Address3_Composite (Address3_Composite)	BLOB [Memo]	ExternalName: address3_composite ExternalType: Memo ExternalAccess: Read Description: Shows the complete third address.
178	Address3_Fax (Address3_Fax)	Text50	ExternalName: address3_fax ExternalType: String Description: Type the fax number associated with the third address.
179	Address3_FreightTermsCode (Address3_FreightTermsCode)	Option	[ ,DefaultValue] OptionOrdinalValues: [-1;1] InitValue: [ ] ExternalName: address3_freighttermscode ExternalType: Picklist Description: Select the freight terms for the third address to make sure shipping orders are processed correctly.
180	Address3_Latitude (Address3_Latitude)	Decimal	ExternalName: address3_latitude ExternalType: Double Description: Type the latitude value for the third address for use in mapping and other applications.
181	Address3_Longitude (Address3_Longitude)	Decimal	ExternalName: address3_longitude ExternalType: Double Description: Type the longitude value for the third address for use in mapping and other applications.
182	Address3_Name (Address3_Name)	Text200	ExternalName: address3_name ExternalType: String Description: Type a descriptive name for the third address, such as Corporate Headquarters.
183	Address3_PrimaryContactName (Address3_PrimaryContactName)	Text100	ExternalName: address3_primarycontactname ExternalType: String Description: Type the name of the main contact at the account's third address.
184	Address3_ShippingMethodCode (Address3_ShippingMethodCode)	Option	[ ,DefaultValue] OptionOrdinalValues: [-1;1] InitValue: [ ] ExternalName: address3_shippingmethodcode ExternalType: Picklist Description: Select a shipping method for deliveries sent to this address.
185	Address3_Telephone1 (Address3_Telephone1)	Text50	ExternalName: address3_telephone1 ExternalType: String Description: Type the main phone number associated with the third address.
186	Address3_Telephone2 (Address3_Telephone2)	Text50	ExternalName: address3_telephone2 ExternalType: String Description: Type a second phone number associated with the third address.
187	Address3_Telephone3 (Address3_Telephone3)	Text50	ExternalName: address3_telephone3 ExternalType: String Description: Type a third phone number associated with the primary address.
188	Address3_UPSZone (Address3_UPSZone)	Text4	ExternalName: address3_upszone ExternalType: String Description: Type the UPS zone of the third address to make sure shipping charges are calculated correctly and deliveries are made promptly, if shipped by UPS.
189	Address3_UTCOffset (Address3_UTCOffset)	Integer	MinValue: -1500 MaxValue: 1500 ExternalName: address3_utcoffset ExternalType: Integer Description: Select the time zone, or UTC offset, for this address so that other people can reference it when they contact someone at this address.
190	Address3_County (Address3_County)	Text50	ExternalName: address3_county ExternalType: String Description: Type the county for the third address.
191	Address3_AddressTypeCode (Address3_AddressTypeCode)	Option	[ ,DefaultValue] OptionOrdinalValues: [-1;1] InitValue: [ ] ExternalName: address3_addresstypecode ExternalType: Picklist Description: Select the third address type.

Keys

#	Fields
0	ContactId (ContactId)		Clustered: Yes
1	FullName (FullName)

Table Relations To Other Tables

Field	Related Table	Related Field
ParentCustomerId (ParentCustomerId)	CRM Account	AccountId (AccountId)	TableRelation: IF (ParentCustomerIdType=CONST(account)) "CRM Account".AccountId ELSE IF (ParentCustomerIdType=CONST(contact)) "CRM Contact".ContactId;	1..n
OwningBusinessUnit (OwningBusinessUnit)	CRM Businessunit	BusinessUnitId (BusinessUnitId)	TableRelation: "CRM Businessunit".BusinessUnitId	1..n
ParentCustomerId (ParentCustomerId)	CRM Contact	ContactId (ContactId)	TableRelation: IF (ParentCustomerIdType=CONST(account)) "CRM Account".AccountId ELSE IF (ParentCustomerIdType=CONST(contact)) "CRM Contact".ContactId;	1..n
DefaultPriceLevelId (DefaultPriceLevelId)	CRM Pricelevel	PriceLevelId (PriceLevelId)	TableRelation: "CRM Pricelevel".PriceLevelId	1..n
ModifiedOnBehalfBy (ModifiedOnBehalfBy)	CRM Systemuser	SystemUserId (SystemUserId)	TableRelation: "CRM Systemuser".SystemUserId	1..n
OwningTeam (OwningTeam)	CRM Team	TeamId (TeamId)	TableRelation: "CRM Team".TeamId	1..n
TransactionCurrencyId (TransactionCurrencyId)	CRM Transactioncurrency	TransactionCurrencyId (TransactionCurrencyId)	TableRelation: "CRM Transactioncurrency".TransactionCurrencyId	1..n

Table Relations From Other Tables

From Table	From Field
CRM Account	PrimaryContactId (PrimaryContactId)	TableRelation: "CRM Contact".ContactId	1..n
CRM Contact	ParentCustomerId (ParentCustomerId)	TableRelation: IF (ParentCustomerIdType=CONST(account)) "CRM Account".AccountId ELSE IF (ParentCustomerIdType=CONST(contact)) "CRM Contact".ContactId;	1..n
CRM Contract	BillingCustomerId (BillingCustomerId)	TableRelation: IF (BillingCustomerIdType=CONST(account)) "CRM Account".AccountId ELSE IF (BillingCustomerIdType=CONST(contact)) "CRM Contact".ContactId;	1..n
CRM Customeraddress	ParentId (ParentId)	TableRelation: IF (ParentIdTypeCode=CONST(account)) "CRM Account".AccountId ELSE IF (ParentIdTypeCode=CONST(contact)) "CRM Contact".ContactId;	1..n
CRM Incident	PrimaryContactId (PrimaryContactId)	TableRelation: "CRM Contact".ContactId	1..n
CRM Invoice	CustomerId (CustomerId)	TableRelation: IF (CustomerIdType=CONST(account)) "CRM Account".AccountId ELSE IF (CustomerIdType=CONST(contact)) "CRM Contact".ContactId;	1..n
CRM Opportunity	ParentContactId (ParentContactId)	TableRelation: "CRM Contact".ContactId	1..n
CRM Post	RegardingObjectId (RegardingObjectId)	TableRelation: IF (RegardingObjectTypeCode=CONST(systemuser)) "CRM Systemuser".SystemUserId ELSE IF (RegardingObjectTypeCode=CONST(account)) "CRM Account".AccountId ELSE IF (RegardingObjectTypeCode=CONST(contact)) "CRM Contact".ContactId ELSE IF (RegardingObjectTypeCode=CONST(opportunity)) "CRM Opportunity".OpportunityId ELSE IF (RegardingObjectTypeCode=CONST(post)) "CRM Post".PostId ELSE IF (RegardingObjectTypeCode=CONST(transactioncurrency)) "CRM Transactioncurrency".TransactionCurrencyId ELSE IF (RegardingObjectTypeCode=CONST(pricelevel)) "CRM Pricelevel".PriceLevelId ELSE IF (RegardingObjectTypeCode=CONST(productpricelevel)) "CRM Productpricelevel".ProductPriceLevelId ELSE IF (RegardingObjectTypeCode=CONST(product)) "CRM Product".ProductId ELSE IF (RegardingObjectTypeCode=CONST(incident)) "CRM Incident".IncidentId ELSE IF (RegardingObjectTypeCode=CONST(incidentresolution)) "CRM Incidentresolution".ActivityId ELSE IF (RegardingObjectTypeCode=CONST(quote)) "CRM Quote".QuoteId ELSE IF (RegardingObjectTypeCode=CONST(quotedetail)) "CRM Quotedetail".QuoteDetailId ELSE IF (RegardingObjectTypeCode=CONST(salesorder)) "CRM Salesorder".SalesOrderId ELSE IF (RegardingObjectTypeCode=CONST(salesorderdetail)) "CRM Salesorderdetail".SalesOrderDetailId ELSE IF (RegardingObjectTypeCode=CONST(invoice)) "CRM Invoice".InvoiceId ELSE IF (RegardingObjectTypeCode=CONST(invoicedetail)) "CRM Invoicedetail".InvoiceDetailId ELSE IF (RegardingObjectTypeCode=CONST(contract)) "CRM Contract".ContractId ELSE IF (RegardingObjectTypeCode=CONST(team)) "CRM Team".TeamId ELSE IF (RegardingObjectTypeCode=CONST(customeraddress)) "CRM Customeraddress".CustomerAddressId ELSE IF (RegardingObjectTypeCode=CONST(uom)) "CRM Uom".UoMId ELSE IF (RegardingObjectTypeCode=CONST(uomschedule)) "CRM Uomschedule".UoMScheduleId ELSE IF (RegardingObjectTypeCode=CONST(organization)) "CRM Organization".OrganizationId ELSE IF (RegardingObjectTypeCode=CONST(businessunit)) "CRM Businessunit".BusinessUnitId ELSE IF (RegardingObjectTypeCode=CONST(discount)) "CRM Discount".DiscountId ELSE IF (RegardingObjectTypeCode=CONST(discounttype)) "CRM Discounttype".DiscountTypeId;	1..n
CRM Quote	CustomerId (CustomerId)	TableRelation: IF (CustomerIdType=CONST(account)) "CRM Account".AccountId ELSE IF (CustomerIdType=CONST(contact)) "CRM Contact".ContactId;	1..n
CRM Salesorder	CustomerId (CustomerId)	TableRelation: IF (CustomerIdType=CONST(account)) "CRM Account".AccountId ELSE IF (CustomerIdType=CONST(contact)) "CRM Contact".ContactId;	1..n

Diagrams

Tables A-Z

a

b

c

d

e

f

g

h

i

j

l

m

n

o

p

q

r

s

t

u

v

w

x

z

Table

CRM Contact

Fields

Keys

Table Relations To Other Tables

Table Relations From Other Tables