Companies Schema
Companies lists centralize information about the organizations with which you do business.
Companies Columns
Column | Data Type | Display Name | Hidden | Required | Sealed | PK | FK |
---|---|---|---|---|---|---|---|
ContentTypeId |
ContentTypeId |
Content Type ID |
True |
False |
True |
no |
None |
Title |
Text |
Company |
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 |
EntryGUID |
Text |
EntryGUID |
True |
False |
True |
no |
None |
PrimaryContact |
Lookup |
Primary Contact |
False |
False |
True |
no |
Business Contacts.ContactFullname |
PrimaryContactID |
Integer |
PrimaryContactID |
True |
False |
True |
no |
None |
Location |
Text |
Office Location |
True |
False |
True |
no |
None |
AcctFollowDueDate |
DateTime |
Follow-up Due Date |
True |
False |
True |
no |
None |
AcctFollowStartDate |
DateTime |
Follow-up Start Date |
True |
False |
True |
no |
None |
AcctReminderDateTime |
DateTime |
Reminder Date and Time |
True |
False |
True |
no |
None |
AcctSelmailAddess |
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 |
True |
False |
True |
no |
None |
HomeAddressCity |
Text |
Home City |
True |
False |
True |
no |
None |
HomeAddressStateOrProvince |
Text |
Home State/Province |
True |
False |
True |
no |
None |
HomeAddressCountry |
Choice |
Home Country/Region |
True |
False |
True |
no |
None |
HomeAddressPostalCode |
Text |
Home Address ZIP/Postal Code |
True |
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 |
AcctSelPhone0 |
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 manager |
True |
False |
True |
no |
None |
CellPhone |
Text |
Mobile phone |
True |
False |
True |
no |
None |
PagerNumber |
Text |
Pager |
True |
False |
True |
no |
None |
CarNumber |
Text |
Car |
True |
False |
True |
no |
None |
CallbackNumber |
Text |
Callback |
True |
False |
True |
no |
None |
HomePhone |
Text |
Home phone |
True |
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 |
False |
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 |
ReferredBy |
Text |
BCMAccount_AcctReferredEntryId |
True |
False |
True |
no |
None |
AcctDisplaySelectors |
Text |
BCMAccount_AcctDisplaySelectors |
True |
False |
True |
no |
None |
AcctSelEmail |
Choice |
Select E-mail |
True |
False |
True |
no |
None |
Text |
False |
False |
True |
no |
None |
||
AcctemailprimaryDisplayas |
Text |
E-mail display as |
True |
False |
True |
no |
None |
Email2 |
Text |
Alternate e-mail |
True |
False |
True |
no |
None |
AcctEmail2Displayas |
Text |
E-mail 2 Display as |
True |
False |
True |
no |
None |
Email3 |
Text |
E-mail 3 |
True |
False |
True |
no |
None |
AcctEmail3Displayas |
Text |
E-mail 3 Display as |
True |
False |
True |
no |
None |
WebPage |
Text |
Web site |
False |
False |
True |
no |
None |
AcctActive |
Boolean |
Active |
False |
False |
True |
no |
None |
AcctAssignedTo |
User |
Assigned to |
False |
False |
True |
no |
None |
AcctCategory |
Choice |
Category |
True |
False |
True |
no |
None |
AcctPaymentStatus |
Choice |
Payment status |
False |
False |
True |
no |
None |
AcctRating |
Choice |
Rating |
False |
False |
True |
no |
None |
AcctAreaofInterest |
Choice |
Area of interest |
True |
False |
True |
no |
None |
AcctSourceofLead |
Choice |
Source of lead |
True |
False |
True |
no |
None |
AcctAcctno |
Text |
Company number |
False |
False |
True |
no |
None |
AcctRevenue |
Currency |
Revenue |
False |
False |
True |
no |
None |
AcctTerritory |
Choice |
Territory |
True |
False |
True |
no |
None |
AcctTickersymbol |
Text |
Ticker symbol |
True |
False |
True |
no |
None |
AcctTypeOfBusiness |
Choice |
Type of business |
True |
False |
True |
no |
None |
AcctPreferedMethod |
Choice |
Preferred method of contact |
True |
False |
True |
no |
None |
Comments |
Note |
Comments |
False |
False |
True |
no |
None |
AcctTotalEmployee |
Text |
Employees |
False |
False |
True |
no |
None |
Acctsdonotcall |
Boolean |
Do not call |
True |
False |
True |
no |
None |
AcctsdonotFax |
Boolean |
Do not fax |
True |
False |
True |
no |
None |
Acctsdonotmail |
Boolean |
Do not mail |
True |
False |
True |
no |
None |
Acctsdonotemail |
Boolean |
Do not e-mail |
True |
False |
True |
no |
None |
AcctAgin |
Calculated |
Company age |
True |
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 |
Company |
False |
False |
True |
no |
None |
LinkFilenameNoMenu |
N/A |
N/A |
False |
False |
False |
no |
None |
LinkTitle |
Computed |
Company |
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 |