Companies 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.

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
Email	Text	E-mail	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