Business Contacts Schema

This content is outdated and is no longer being maintained. It is provided as a courtesy for individuals who are still using these technologies. This page may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.

Business Contacts centralizes information about the people with whom you do business.

Business Contacts Columns

Column	Data Type	Display Name	Hidden	Required	Sealed	PK	FK
ContentTypeId	ContentTypeId	Content Type ID	True	False	True	no	None
Title	Text	Last Name	False	True	True	no	None
_ModerationComments	Note	Approver Comments	True	False	False	no	None
File_x0020_Type	Text	File Type	True	False	False	no	None
ParentAccount	Lookup	Company	False	False	True	no	Companies.Title
ParentAccountID	Integer	ParentAccountID	True	False	True	no	None
EntryGUID	Text	EntryGUID	True	False	True	no	None
ContactTitle	Choice	Title	False	False	True	no	None
FirstName	Text	First name	False	False	True	no	None
MiddleName	Text	Middle name	False	False	True	no	None
ContactSuffix	Choice	Suffix	False	False	True	no	None
JobTitle	Text	Job title	False	False	True	no	None
ContactSelmailAddess	Choice	Selected mailing address	True	False	True	no	None
WorkAddress	Note	Street	False	False	True	no	None
WorkCity	Text	City	False	False	True	no	None
WorkState	Text	State/Province	False	False	True	no	None
WorkCountry	Choice	Country/Region	False	False	True	no	None
WorkZip	Text	ZIP/Postal Code	False	False	True	no	None
HomeAddressStreet	Note	Home Street	False	False	True	no	None
HomeAddressCity	Text	Home City	False	False	True	no	None
HomeAddressStateOrProvince	Text	Home State/Province	False	False	True	no	None
HomeAddressCountry	Choice	Home Country/Region	False	False	True	no	None
HomeAddressPostalCode	Text	Home ZIP/Postal Code	False	False	True	no	None
OtherAddressStreet	Note	Other Street	False	False	True	no	None
OtherAddressCity	Text	Other City	False	False	True	no	None
OtherAddressStateOrProvince	Text	Other State/Province	False	False	True	no	None
OtherAddressCountry	Choice	Other Country/ Region	False	False	True	no	None
OtherAddressPostalCode	Text	Other ZIP/Postal Code	False	False	True	no	None
ContactSelPhone0	Choice	Select phone	True	False	True	no	None
CompanyNumber	Text	Company main phone	True	False	True	no	None
WorkPhone	Text	Primary phone	False	False	True	no	None
Business2Number	Text	Alternate phone	False	False	True	no	None
WorkFax	Text	Fax	False	False	True	no	None
AssistantsName	Text	Assistant	False	False	True	no	None
CellPhone	Text	Mobile phone	False	False	True	no	None
PagerNumber	Text	Pager	False	False	True	no	None
CarNumber	Text	Car	True	False	True	no	None
CallbackNumber	Text	Callback	True	False	True	no	None
HomePhone	Text	Home phone	False	False	True	no	None
Home2Number	Text	Alternate home phone	True	False	True	no	None
HomeFaxNumber	Text	Fax	True	False	True	no	None
OtherNumber	Text	Customer support	True	False	True	no	None
OtherFaxNumber	Text	Alternate fax	False	False	True	no	None
ISDNNumber	Text	ISDN	True	False	True	no	None
PrimaryNumber	Text	Primary phone	True	False	True	no	None
RadioNumber	Text	Radio phone	True	False	True	no	None
TelexNumber	Text	Telex	True	False	True	no	None
TTYTDDNumber	Text	TTY/TDD	True	False	True	no	None
ContactSelEmail	Choice	Select E-mail	True	False	True	no	None
Email	Text	E-mail	False	False	True	no	None
ContactemailprimaryDisplayas	Text	E-mail display as	True	False	True	no	None
Email2	Text	Alternate e-mail	False	False	True	no	None
ContactEmail2Displayas	Text	E-mail 2 Display as	True	False	True	no	None
Email3	Text	E-mail 3	True	False	True	no	None
ContactEmail3Displayas	Text	E-mail 3 Display as	True	False	True	no	None
ContactWebPageadd	Text	Web site	False	False	True	no	None
IMAddress	Text	IM address	False	False	True	no	None
ContactActive	Boolean	Active	False	False	True	no	None
ContactAssignedTo	User	Assigned to	False	False	True	no	None
ContactCategory	Choice	Category	True	False	True	no	None
ContactPaymentStatus	Choice	Payment status	False	False	True	no	None
ContactRating	Choice	Contact rating	True	False	True	no	None
ContactAreaofInterest	Choice	Area of interest	True	False	True	no	None
ContactSourceofLead	Choice	Source of lead	False	False	True	no	None
ol_Department	Text	Department	False	False	True	no	None
Office	Text	Office/Branch	False	False	True	no	None
Nickname	Text	Nickname	False	False	True	no	None
Profession	Text	Profession	False	False	True	no	None
ManagersName	Text	Manager	False	False	True	no	None
Birthday	DateTime	Birthday	False	False	True	no	None
SpouseName	Text	Spouse/Partner	False	False	True	no	None
Hobbies	Text	Hobbies	False	False	True	no	None
ChildrensNames	Text	Children	False	False	True	no	None
Anniversary	DateTime	Anniversary	False	False	True	no	None
ContactPreferredmethod	Choice	Preferred method of contact	True	False	True	no	None
ContactMarkAsLead	Boolean	Lead	False	False	True	no	None
ContactGroup	MultiChoice	Contact Group	False	False	False	no	None
Contactdonotcall	Boolean	Do not call	True	False	True	no	None
Contactdonotemail	Boolean	Do not e-mail	True	False	True	no	None
Contactdonotmail	Boolean	Do not send letter	True	False	True	no	None
Contactdonotfax	Boolean	Do not fax	True	False	True	no	None
Comments	Note	Comments	False	False	True	no	None
ContactFullname	Text	Full name	False	False	True	no	None
ContactAgin	Calculated	JustDay	True	False	True	no	None
EmailSubscriber	Boolean	Send to E-mail	False	False	True	no	None
AltEmailSubscriber	Boolean	Send to Alternate E-mail	False	False	True	no	None
SMSSubscriber	Boolean	Send to SMS	False	False	True	no	None
IsImport	Boolean	IsImport	True	False	True	no	None
_MSIWS_SampleData	Boolean	_MSIWS_SampleData	True	False	True	no	None
ID	Counter	ID	False	False	False	yes	None
ContentType	Text	Content Type	False	False	False	no	None
Modified	DateTime	Modified	False	False	False	no	None
Created	DateTime	Created	False	False	False	no	None
Author	User	Created By	False	False	False	no	None
Editor	User	Modified By	False	False	False	no	None
_HasCopyDestinations	Boolean	Has Copy Destinations	True	False	True	no	None
_CopySource	Text	Copy Source	True	False	True	no	None
owshiddenversion	Integer	owshiddenversion	True	False	False	no	None
WorkflowVersion	Integer	Workflow Version	True	False	False	no	None
_UIVersion	Integer	UI Version	True	False	False	no	None
_UIVersionString	Text	Version	False	False	False	no	None
Attachments	Attachments	Attachments	False	False	False	no	None
_ModerationStatus	ModStat	Approval Status	True	False	False	no	None
Edit	Computed	Edit	False	False	False	no	None
LinkTitleNoMenu	Computed	Last Name	False	False	True	no	None
LinkFilenameNoMenu	N/A	N/A	False	False	False	no	None
LinkTitle	Computed	Last Name	False	False	True	no	None
LinkTitleNoMenu	N/A	N/A	False	False	False	no	None
_EditMenuTableStart	N/A	N/A	False	False	False	no	None
LinkTitleNoMenu	N/A	N/A	False	False	False	no	None
_EditMenuTableEnd	N/A	N/A	False	False	False	no	None
SelectTitle	Computed	Select	True	False	False	no	None
InstanceID	Integer	Instance ID	True	False	False	no	None
Order	Number	Order	True	False	False	no	None
GUID	Guid	GUID	True	False	False	no	None
WorkflowInstanceID	Guid	Workflow Instance ID	True	False	False	no	None
FileRef	Lookup	URL Path	True	False	False	no	Docs.FullUrl
FileDirRef	Lookup	Path	True	False	False	no	Docs.DirName
Last_x0020_Modified	Lookup	Modified	True	False	False	no	Docs.TimeLastModified
Created_x0020_Date	Lookup	Created	True	False	False	no	Docs.TimeCreated
FSObjType	Lookup	Item Type	True	False	False	no	Docs.FSType
PermMask	Computed	Effective Permissions Mask	True	False	False	no	None
FileLeafRef	File	Name	True	False	False	no	None
UniqueId	Lookup	Unique Id	True	False	False	no	Docs.UniqueId
ProgId	Lookup	ProgId	True	False	False	no	Docs.ProgId
ScopeId	Lookup	ScopeId	True	False	False	no	Docs.ScopeId
HTML_x0020_File_x0020_Type	Computed	HTML File Type	True	False	False	no	None
_EditMenuTableStart	Computed	Edit Menu Table Start	True	False	False	no	None
ServerUrl	N/A	N/A	False	False	False	no	None
FileDirRef	N/A	N/A	False	False	False	no	None
PermMask	N/A	N/A	False	False	False	no	None
_EditMenuTableEnd	Computed	Edit Menu Table End	True	False	False	no	None
LinkFilenameNoMenu	Computed	Name	True	False	False	no	None
ServerUrl	N/A	N/A	False	False	False	no	None
PermMask	N/A	N/A	False	False	False	no	None
LinkFilename	Computed	Name	True	False	False	no	None
LinkFilenameNoMenu	N/A	N/A	False	False	False	no	None
_EditMenuTableStart	N/A	N/A	False	False	False	no	None
LinkFilenameNoMenu	N/A	N/A	False	False	False	no	None
_EditMenuTableEnd	N/A	N/A	False	False	False	no	None
DocIcon	Computed	Type	False	False	False	no	None
ServerUrl	Computed	Server Relative URL	True	False	False	no	None
EncodedAbsUrl	Computed	Encoded Absolute URL	True	False	False	no	None
BaseName	Computed	File Name	True	False	False	no	None
MetaInfo	Lookup	Property Bag	True	False	False	no	Docs.MetaInfo
_Level	Integer	Level	True	False	False	no	None
_IsCurrentVersion	Boolean	Is Current Version	True	False	False	no	None