Share via


Accounts

Use this list to centralize information about companies or organizations with which you do business.

column datatype Display Name Hidden Required Sealed PK FK
ContentTypeId ContentTypeId ContentTypeID True False True    
Title Text Accounts False True True    
_ModerationComments Note ApproverComments True False False    
File_x0020_Type Text FileType True False False    
EntryGUID Text EntryGUID True False True    
PrimaryContact Lookup PrimaryContact False False True   Contacts.Title
PrimaryContactID Integer PrimaryContactID True False True    
AcctOfficeLocation Text OfficeLocation True False True    
AcctFollowDueDate DateTime FollowupDueDate True False True    
AcctFollowStartDate DateTime FollowupStartDate True False True    
AcctReminderDateTime DateTime ReminderDateandTime True False True    
AcctSelmailAddess Choice Selectedmailingaddress True False True    
AcctBusStreet Note Street False False True    
AcctBusCity Text City False False True    
AcctBusState Text State/Province False False True    
AcctBusCountry Choice Country/Region False False True    
AcctBusZip Text Zip/Postalcode False False True    
AcctHomeStreet Note Street True False True    
AcctHomeCity Text City True False True    
AcctHomeState Text State/Province True False True    
AcctHomeCountry Choice Country/Region True False True    
AcctHomeZip Text Zip/Postalcode True False True    
AcctOtherStreet Note Street False False True    
AcctOtherCity Text City False False True    
AcctOtherState Text State/Province False False True    
AcctOtherCountry Choice Country/Region False False True    
AcctOtherZip Text Zip/Postalcode False False True    
AcctSelPhone0 Choice Selectphone True False True    
AcctCompmainphone Text Accountmainphone True False True    
Acctbusinessphone Text Phone False False True    
Acctbusinessphone2 Text Alternatephone False False True    
Acctbusinessfax Text Fax False False True    
AcctAssistant Text Assistantmanager True False True    
AcctMobile Text Mobile True False True    
AcctPager Text Pager True False True    
AcctCar Text Car True False True    
AcctCallback Text Callback True False True    
AcctPhoneHome Text Homephone True False True    
AcctPhoneHome2 Text Alternatehomephone True False True    
AcctPhoneHomeFax Text Fax True False True    
AcctPhoneOther Text Supportline False False True    
AcctPhoneOtherFax Text Alternatefax False False True    
AcctPhoneISDN Text ISDN True False True    
AcctPhonePrimary Text Phone True False True    
AcctPhoneRadio Text Radiophone True False True    
AcctPhoneTelex Text Telex True False True    
AcctPhoneTTY_TDD Text TTY/TDD True False True    
AcctReferredEntryId Text BCMAccount_AcctReferredEntryId True False True    
AcctDisplaySelectors Text BCMAccount_AcctDisplaySelectors True False True    
AcctSelEmail Choice SelectEmail True False True    
Acctemailprimary Text E-mail False False True    
AcctemailprimaryDisplayas Text E-maildisplayas True False True    
AcctEmail2 Text Alternatee-mail True False True    
AcctEmail2Displayas Text E-mail2displayas True False True    
AcctEmail3 Text E-mail3 True False True    
AcctEmail3Displayas Text E-mail3DisplayAs True False True    
AcctWebPageadd Text W ebsite False False True    
AcctActive Boolean Active False False True    
AcctAssignedTo User Assignedto False False True    
AcctCategory Choice Category True False True    
AcctPaymentStatus Choice Paymentstatus False False True    
AcctRating Choice Rating False False True    
AcctAreaofInterest Choice Areaofinterest True False True    
AcctSourceofLead Choice Sourceoflead True False True    
AcctAcctno Text Accountnumber False False True    
AcctRevenue Currency Revenue False False True    
AcctTerritory Choice Territory True False True    
AcctTickersymbol Text Tickersymbol True False True    
AcctTypeOfBusiness Choice Typeofbusiness True False True    
AcctPreferedMethod Choice Preferredmethodofcontact True False True    
AcctComments Note Comments False False True    
AcctTotalEmployee Text Employees False False True    
Acctsdonotcall Boolean Donotcall True False True    
AcctsdonotFax Boolean Donotfax True False True    
Acctsdonotmail Boolean Donotmail True False True    
Acctsdonotemail Boolean Donote-mail True False True    
AcctAgin Calculated AccountAge True False True    
IsImport Boolean IsImport True False True    
_MSIWS_SampleData Boolean _MSIWS_SampleData True False True    
ID Counter ID False False False yes  
ContentType Text ContentType False False False    
Modified DateTime Modified False False False    
Created DateTime Created False False False    
Author User CreatedBy False False False    
Editor User ModifiedBy False False False    
_HasCopyDestinations Boolean HasCopyDestinations True False True    
_CopySource Text CopySource True False True    
owshiddenversion Integer owshiddenversion True False False    
WorkflowVersion Integer WorkflowVersion True False False    
_UIVersion Integer UIVersion True False False    
_UIVersionString Text Version False False False    
Attachments Attachments Attachments False False False    
_ModerationStatus ModStat ApprovalStatus True False False    
Edit Computed Edit False False False    
LinkTitleNoMenu Computed Accounts False False True    
LinkFilenameNoMenu     False False False    
LinkTitle Computed Accounts False False True    
LinkTitleNoMenu     False False False    
_EditMenuTableStart     False False False    
LinkTitleNoMenu     False False False    
_EditMenuTableEnd     False False False    
SelectTitle Computed Select True False False    
InstanceID Integer InstanceID True False False    
Order Number Order True False False    
GUID Guid GUID True False False    
WorkflowInstanceID Guid W orkflowInstanceID True False False    
FileRef Lookup URLPath True False False   Docs.FullUrl
FileDirRef Lookup Path True False False   Docs.DirName
Last_x0020_Modified Lookup Modified True False False   Docs.TimeLastModified
Created_x0020_Date Lookup Created True False False   Docs.TimeCreated
FSObjType Lookup ItemType True False False   Docs.FSType
PermMask Computed EffectivePermissionsMask True False False    
FileLeafRef File Name True False False    
UniqueId Lookup UniqueId True False False   Docs.UniqueId
ProgId Lookup ProgId True False False   Docs.ProgId
ScopeId Lookup ScopeId True False False   Docs.ScopeId
HTML_x0020_File_x0020_Type Computed HTMLFileType True False False    
_EditMenuTableStart Computed EditMenuTableStart True False False    
ServerUrl     False False False    
FileDirRef     False False False    
PermMask     False False False    
_EditMenuTableEnd Computed EditMenuTableEnd True False False    
LinkFilenameNoMenu Computed Name True False False    
ServerUrl     False False False    
PermMask     False False False    
LinkFilename Computed Name True False False    
LinkFilenameNoMenu     False False False    
_EditMenuTableStart     False False False    
LinkFilenameNoMenu     False False False    
_EditMenuTableEnd     False False False    
DocIcon Computed Type False False False    
ServerUrl Computed ServerRelativeURL True False False    
EncodedAbsUrl Computed EncodedAbsoluteURL True False False    
BaseName Computed FileName True False False    
MetaInfo Lookup PropertyBag True False False   Docs.MetaInfo
_Level Integer Level True False False    
_IsCurrentVersion Boolean IsCurrentVersion True False False