Business Contacts Schema
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 |
Text |
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 |