Lead Entity Metadata

  • Article

[Applies to: Microsoft Dynamics CRM 2011]

The following information is for the lead entity in a default, uncustomized installation of Microsoft Dynamics CRM. The schema name and early bound class for this entity is Lead.

To view the entity metadata for your organization, install the Metadata Browser solution described in Browse the Metadata for Your Organization.

In This Topic

Entity Metadata

Privilege Metadata

Attribute Metadata

One-to-Many Relationships

Many-to-Many Relationships

Many-to-One Relationships

Entity Metadata

The following table shows the metadata for the lead entity.

Entity metadata property Value

OTC

4

EntityLogicalName

lead

DisplayName

Lead

OwnershipType

UserOwned

IsCustomizable

True

Description

Prospect or potential sales opportunity. Leads are converted into accounts, contacts, or opportunities when they are qualified. Otherwise, they are deleted or archived.

IsAvailableOffline

True

IsAuditEnabled

False

AutoRouteToOwnerQueue

False

CanBeInManyToMany

True

CanBePrimaryEntityInRelationship

True

CanBeRelatedEntityInRelationship

True

CanCreateAttributes

True

CanCreateCharts

True

CanCreateForms

True

CanCreateViews

True

CanModifyAdditionalSettings

True

CanTriggerWorkflow

True

IsActivity

False

IsActivityParty

True

IsChildEntity

False

IsConnectionsEnabled

canmodifyconnectionsettings

IsCustomEntity

False

IsDocumentManagementEnabled

True

IsDuplicateDetectionEnabled

True

IsEnabledForCharts

True

IsImportable

True

IsIntersect

False

IsMailMergeEnabled

True

IsManaged

True

IsMappable

True

IsReadingPaneEnabled

True

IsRenameable

True

IsValidForAdvancedFind

True

IsValidForQueue

False

IsVisibleInMobile

True

PrimaryIdAttribute

leadid

PrimaryNameAttribute

fullname

ReportViewName

FilteredLead

RecurrenceBaseEntityLogicalName

DisplayCollectionName

Leads

Privilege Metadata

The following table shows the privilege metadata for the lead entity.

PrivilegeName Id Type CanBeBasic CanBeDeep CanBeGlobal CanBeLocal

prvAppendLead

387d6489-cfcc-47d7-98af-5b7946d7691d

Append

True

True

True

True

prvAppendToLead

5e8d193d-184d-44be-92d8-0f3845d7a9eb

AppendTo

True

True

True

True

prvAssignLead

7755e1bc-6f11-465e-8ed0-a1616c5d32c4

Assign

True

True

True

True

prvCreateLead

a41f965b-2619-4c73-8625-da31945cccc7

Create

True

True

True

True

prvDeleteLead

b42d2f65-8929-455d-abe7-b4ec8367a8e1

Delete

True

True

True

True

prvReadLead

a8ecac53-09e8-4a13-b598-8d8c87bc3d33

Read

True

True

True

True

prvShareLead

9805ebd7-4a57-4558-a7ef-c0ba93d28c68

Share

True

True

True

True

prvWriteLead

cb4b339f-2b45-447e-bdd3-0bf4bbebc294

Write

True

True

True

True

Attribute Metadata

The following table shows the attribute metadata for the lead entity. See Internal Attributes for a list of attributes that are for internal use only.

LogicalName Description Type SchemaName IsCustomAttribute IsCustomizable RequiredLevel IsValidForCreate IsValidForRead IsValidForUpdate CanBeSecuredForCreate CanBeSecuredForRead CanBeSecuredForUpdate IsAuditEnabled IsManaged IsPrimaryId IsPrimaryName IsRenameable IsSecured IsValidForAdvancedFind DisplayName DeprecatedVersion

accountid

Unique identifier of the account with which the lead is associated.

Lookup

AccountId

False

True

None

False

True

False

False

False

False

True

True

False

False

False

False

False

Account

address1_addressid

Unique identifier for address 1.

Uniqueidentifier

Address1_AddressId

False

False

None

True

True

True

False

False

False

False

True

True

False

False

False

False

Address 1: ID

address1_addresstypecode

Type of address for address 1, such as billing, shipping, or primary address.

Picklist

Address1_AddressTypeCode

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

False

Address 1: Address Type

address1_city

City name for address 1.

String

Address1_City

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

City

address1_country

Country/region name for address 1.

String

Address1_Country

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Country/Region

address1_county

County name for address 1.

String

Address1_County

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Address 1: County

address1_fax

Fax number for address 1.

String

Address1_Fax

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Address 1: Fax

address1_latitude

Latitude for address 1.

Double

Address1_Latitude

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Address 1: Latitude

address1_line1

First line for entering address 1 information.

String

Address1_Line1

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Street 1

address1_line2

Second line for entering address 1 information.

String

Address1_Line2

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Street 2

address1_line3

Third line for entering address 1 information.

String

Address1_Line3

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Street 3

address1_longitude

Longitude for address 1.

Double

Address1_Longitude

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Address 1: Longitude

address1_name

Name to enter for address 1.

String

Address1_Name

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Address 1: Name

address1_postalcode

ZIP Code or postal code for address 1.

String

Address1_PostalCode

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

ZIP/Postal Code

address1_postofficebox

Post office box number for address 1.

String

Address1_PostOfficeBox

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Address 1: Post Office Box

address1_shippingmethodcode

Method of shipment for address 1.

Picklist

Address1_ShippingMethodCode

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

False

Address 1: Shipping Method

address1_stateorprovince

State or province for address 1.

String

Address1_StateOrProvince

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

State/Province

address1_telephone1

First telephone number associated with address 1.

String

Address1_Telephone1

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Address 1: Telephone 1

address1_telephone2

Second telephone number associated with address 1.

String

Address1_Telephone2

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Address 1: Telephone 2

address1_telephone3

Third telephone number associated with address 1.

String

Address1_Telephone3

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Address 1: Telephone 3

address1_upszone

United Parcel Service (UPS) zone for address 1.

String

Address1_UPSZone

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Address 1: UPS Zone

address1_utcoffset

UTC offset for address 1. This is the difference between local time and standard Coordinated Universal Time.

Integer

Address1_UTCOffset

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

False

Address 1: UTC Offset

address2_addressid

Unique identifier for address 2.

Uniqueidentifier

Address2_AddressId

False

False

None

True

True

True

False

False

False

False

True

True

False

False

False

False

Address 2: ID

address2_addresstypecode

Type of address for address 2, such as billing, shipping, or primary address.

Picklist

Address2_AddressTypeCode

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

False

Address 2: Address Type

address2_city

City name for address 2.

String

Address2_City

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Address 2: City

address2_country

Country/region name for address 2.

String

Address2_Country

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Address 2: Country/Region

address2_county

County name for address 2.

String

Address2_County

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Address 2: County

address2_fax

Fax number for address 2.

String

Address2_Fax

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Address 2: Fax

address2_latitude

Latitude for address 2.

Double

Address2_Latitude

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Address 2: Latitude

address2_line1

First line for entering address 2 information.

String

Address2_Line1

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Address 2: Street 1

address2_line2

Second line for entering address 2 information.

String

Address2_Line2

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Address 2: Street 2

address2_line3

Third line for entering address 2 information.

String

Address2_Line3

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Address 2: Street 3

address2_longitude

Longitude for address 2.

Double

Address2_Longitude

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Address 2: Longitude

address2_name

Name to enter for address 2.

String

Address2_Name

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Address 2: Name

address2_postalcode

ZIP Code or postal code for address 2.

String

Address2_PostalCode

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Address 2: ZIP/Postal Code

address2_postofficebox

Post office box number for address 2.

String

Address2_PostOfficeBox

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Address 2: Post Office Box

address2_shippingmethodcode

Method of shipment for address 2.

Picklist

Address2_ShippingMethodCode

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

False

Address 2: Shipping Method

address2_stateorprovince

State or province for address 2.

String

Address2_StateOrProvince

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Address 2: State/Province

address2_telephone1

First telephone number associated with address 2.

String

Address2_Telephone1

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Address 2: Telephone 1

address2_telephone2

Second telephone number associated with address 2.

String

Address2_Telephone2

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Address 2: Telephone 2

address2_telephone3

Third telephone number associated with address 2.

String

Address2_Telephone3

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Address 2: Telephone 3

address2_upszone

United Parcel Service (UPS) zone for address 2.

String

Address2_UPSZone

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Address 2: UPS Zone

address2_utcoffset

UTC offset for address 2. This is the difference between local time and standard Coordinated Universal Time.

Integer

Address2_UTCOffset

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

False

Address 2: UTC Offset

budgetamount

Information about the budget amount of the lead's company or organization.

Money

BudgetAmount

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Budget Amount

budgetamount_base

Base currency equivalent of the estimated budget of the lead.

Money

BudgetAmount_Base

False

True

None

False

True

False

False

False

False

True

True

False

False

True

False

True

Budget Amount (Base)

budgetstatus

Information about the budget status of the lead's company or organization.

Picklist

BudgetStatus

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Budget

campaignid

Unique identifier of the source campaign associated with the lead.

Lookup

CampaignId

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Source Campaign

companyname

Name of the company with which the lead is associated.

String

CompanyName

False

True

Recommended

True

True

True

False

False

False

True

True

False

False

True

False

True

Company Name

confirminterest

Information about whether the lead confirmed interest in our offerings.

Boolean

ConfirmInterest

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Confirm Interest

contactid

Unique identifier of the contact with which the lead is associated.

Lookup

ContactId

False

True

None

False

True

False

False

False

False

True

True

False

False

False

False

False

Contact

createdby

Unique identifier of the user who created the lead.

Lookup

CreatedBy

False

True

None

False

True

False

False

False

False

False

True

False

False

True

False

True

Created By

createdon

Date and time when the lead was created.

DateTime

CreatedOn

False

True

None

False

True

False

False

False

False

False

True

False

False

True

False

True

Created On

createdonbehalfby

Unique identifier of the delegate user who created the lead.

Lookup

CreatedOnBehalfBy

False

True

None

False

True

False

False

False

False

False

True

False

False

True

False

True

Created By (Delegate)

customerid

Unique identifier for the account or contact associated with the lead.

Customer

CustomerId

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Customer

decisionmaker

Information about whether the lead is a decision maker.

Boolean

DecisionMaker

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Decision Maker?

description

Description of the lead.

Memo

Description

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Description

donotbulkemail

Information about whether to allow sending direct e-mail to the lead.

Boolean

DoNotBulkEMail

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Do not allow Bulk E-mails

donotemail

Information about whether to allow sending e-mail to the lead.

Boolean

DoNotEMail

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Do not allow E-mails

donotfax

Information about whether to allow sending fax transmittals to the lead.

Boolean

DoNotFax

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Do not allow Faxes

donotphone

Information about whether to allow phone calls to the lead.

Boolean

DoNotPhone

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Do not allow Phone Calls

donotpostalmail

Information about whether to allow sending postal mail to the lead.

Boolean

DoNotPostalMail

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Do not allow Mails

donotsendmm

Information regarding whether to allow sending marketing mail to the lead.

Boolean

DoNotSendMM

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Marketing Material

emailaddress1

First e-mail address for the lead.

String

EMailAddress1

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

E-mail

emailaddress2

Second e-mail address for the lead.

String

EMailAddress2

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

E-mail Address 2

emailaddress3

Third e-mail address for the lead.

String

EMailAddress3

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

E-mail Address 3

estimatedamount

Estimated value of the opportunity that was generated from the lead.

Money

EstimatedAmount

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Est. Value

estimatedamount_base

Base currency equivalent of the estimated value of the opportunity that was generated from the lead.

Money

EstimatedAmount_Base

False

True

None

False

True

False

False

False

False

True

True

False

False

True

False

True

Est. Value (Base)

estimatedclosedate

Estimated date on which the opportunity that was generated from the lead is expected to close.

DateTime

EstimatedCloseDate

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Est. Close Date

estimatedvalue

Estimated value of the opportunity that was generated from the lead.

Double

EstimatedValue

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Est. Value (deprecated)

evaluatefit

Information about whether the fit between the lead's requirements and our offerings was evaluated.

Boolean

EvaluateFit

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Evaluate Fit

exchangerate

Exchange rate for the currency associated with the lead with respect to the base currency.

Decimal

ExchangeRate

False

True

None

False

True

False

False

False

False

True

True

False

False

True

False

True

Exchange Rate

fax

Fax number for the lead.

String

Fax

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Fax

firstname

First name for the lead.

String

FirstName

False

True

Recommended

True

True

True

False

False

False

True

True

False

False

True

False

True

First Name

fullname

Full name for the lead.

String

FullName

False

True

None

False

True

False

False

False

False

True

True

False

True

True

False

True

Name

importsequencenumber

Unique identifier of the data import or data migration that created this record.

Integer

ImportSequenceNumber

False

True

None

True

True

False

False

False

False

True

True

False

False

True

False

True

Import Sequence Number

industrycode

Type of industry with which the company or organization of the lead is associated.

Picklist

IndustryCode

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Industry

initialcommunication

Information about whether initial communication was established.

Picklist

InitialCommunication

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Initial Communication

isautocreate

Information about whether the contact was auto-created when promoting an email or an appointment.

Boolean

IsAutoCreate

False

True

None

False

False

False

False

False

False

True

True

False

False

False

False

False

Auto-created

isprivate

Indicates whether the lead is private or visible to the entire organization.

Boolean

IsPrivate

False

False

None

False

False

False

False

False

False

False

True

False

False

False

False

False

Is Private

jobtitle

Job title of the lead.

String

JobTitle

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Job Title

lastname

Last name for the lead.

String

LastName

False

True

ApplicationRequired

True

True

True

False

False

False

True

True

False

False

True

False

True

Last Name

lastusedincampaign

Date and time when the lead was last contacted as a part of a marketing campaign.

DateTime

LastUsedInCampaign

False

True

None

False

True

True

False

False

False

True

True

False

False

True

False

True

Last Campaign Date

leadid

Unique identifier of the lead.

Uniqueidentifier

LeadId

False

True

SystemRequired

True

True

False

False

False

False

False

True

True

False

True

False

True

Lead

leadqualitycode

Quality of the lead, such as hot, warm, or cold.

Picklist

LeadQualityCode

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Rating

leadsourcecode

Source of the lead.

Picklist

LeadSourceCode

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Lead Source

masterid

Unique identifier of the master lead for merge.

Lookup

MasterId

False

True

None

False

True

False

False

False

False

True

True

False

False

False

False

False

Master ID

merged

Information regarding whether the account has been merged with a master lead.

Boolean

Merged

False

True

None

False

True

False

False

False

False

True

True

False

False

True

False

True

Merged

middlename

Middle name for the lead.

String

MiddleName

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Middle Name

mobilephone

Mobile phone number for the lead.

String

MobilePhone

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Mobile Phone

modifiedby

Unique identifier of the user who last modified the lead.

Lookup

ModifiedBy

False

True

None

False

True

False

False

False

False

False

True

False

False

True

False

True

Modified By

modifiedon

Date and time when the lead was last modified.

DateTime

ModifiedOn

False

True

None

False

True

False

False

False

False

False

True

False

False

True

False

True

Modified On

modifiedonbehalfby

Unique identifier of the delegate user who last modified the lead.

Lookup

ModifiedOnBehalfBy

False

True

None

False

True

False

False

False

False

False

True

False

False

True

False

True

Modified By (Delegate)

need

Information about the needs of the lead's company or organization.

Picklist

Need

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Need

numberofemployees

Number of employees at the lead's company.

Integer

NumberOfEmployees

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

No. of Employees

overriddencreatedon

Date and time that the record was migrated.

DateTime

OverriddenCreatedOn

False

True

None

True

True

False

False

False

False

True

True

False

False

True

False

True

Record Created On

ownerid

Unique identifier of the user or team who owns the lead record.

Owner

OwnerId

False

True

SystemRequired

True

True

False

False

False

False

True

True

False

False

True

False

True

Owner

owningbusinessunit

Unique identifier of the business unit that owns the lead.

Lookup

OwningBusinessUnit

False

True

None

False

True

False

False

False

False

False

True

False

False

False

False

False

Owning Business Unit

owningteam

Unique identifier of the team who owns the lead.

Lookup

OwningTeam

False

True

None

False

True

False

False

False

False

False

True

False

False

False

False

False

Owning Team

owninguser

Unique identifier of the user who owns the lead.

Lookup

OwningUser

False

True

None

False

True

False

False

False

False

False

True

False

False

False

False

False

Owning User

pager

Pager number for the lead.

String

Pager

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Pager

parentaccountid

Unique identifier of the parent account with which the lead is associated.

Lookup

ParentAccountId

False

True

None

True

True

True

False

False

False

True

True

False

False

False

False

True

Parent Account for lead

parentcontactid

Contact that is matched to the lead.

Lookup

ParentContactId

False

True

None

True

True

True

False

False

False

True

True

False

False

False

False

True

Parent Contact for lead

participatesinworkflow

Information about whether the lead participates in workflow rules.

Boolean

ParticipatesInWorkflow

False

True

None

True

True

True

False

False

False

True

True

False

False

False

False

False

Participates in Workflow

preferredcontactmethodcode

Preferred contact method for the lead.

Picklist

PreferredContactMethodCode

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Preferred Method of Contact

prioritycode

Priority of the lead.

Picklist

PriorityCode

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

False

Priority

purchaseprocess

The type of purchase process for this lead.

Picklist

PurchaseProcess

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Purchase Process

purchasetimeframe

The time frame that this lead is likely to make a purchase in.

Picklist

PurchaseTimeFrame

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Purchase Timeframe

qualificationcomments

Comments about the qualification of the lead.

Memo

QualificationComments

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Qualification Comments

qualifyingopportunityid

Unique identifier of the opportunity that the lead qualified to.

Lookup

QualifyingOpportunityId

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Qualifying Opportunity

revenue

Revenue amount for the lead.

Money

Revenue

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Annual Revenue

revenue_base

Base currency equivalent of the revenue amount for the lead.

Money

Revenue_Base

False

True

None

False

True

False

False

False

False

True

True

False

False

True

False

True

Annual Revenue (Base)

salesstage

The sales stage of the lead.

Picklist

SalesStage

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Sales Stage

salesstagecode

Current stage of the sales process for the lead.

Picklist

SalesStageCode

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

False

Sales Stage Code

salutation

Salutation for correspondence with the lead.

String

Salutation

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Salutation

schedulefollowup_prospect

Information about whether a prospecting follow up meeting was scheduled with the lead.

DateTime

ScheduleFollowUp_Prospect

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Schedule Follow Up (Prospect)

schedulefollowup_qualify

Information about whether a qualifying follow up meeting was scheduled with the lead.

DateTime

ScheduleFollowUp_Qualify

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Schedule Follow Up (Qualify)

sic

Standard Industrial Classification (SIC) code for the lead.

String

SIC

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

SIC Code

statecode

Status of the lead.

State

StateCode

False

True

SystemRequired

False

True

False

False

False

False

True

True

False

False

True

False

True

Status

statuscode

Reason for the status of the lead.

Status

StatusCode

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Status Reason

subject

Subject associated with the lead.

String

Subject

False

True

ApplicationRequired

True

True

True

False

False

False

True

True

False

False

True

False

True

Topic

telephone1

First telephone number for the lead.

String

Telephone1

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Business Phone

telephone2

Second telephone number for the lead.

String

Telephone2

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Home Phone

telephone3

Third telephone number for the lead.

String

Telephone3

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Other Phone

timezoneruleversionnumber

For internal use only.

Integer

TimeZoneRuleVersionNumber

False

True

None

True

True

True

False

False

False

False

True

False

False

False

False

False

Time Zone Rule Version Number

transactioncurrencyid

Unique identifier of the currency associated with the lead.

Lookup

TransactionCurrencyId

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Currency

utcconversiontimezonecode

Time zone code that was in use when the record was created.

Integer

UTCConversionTimeZoneCode

False

True

None

True

True

True

False

False

False

False

True

False

False

False

False

False

UTC Conversion Time Zone Code

versionnumber

Version number of the lead.

BigInt

VersionNumber

False

False

None

False

True

False

False

False

False

False

True

False

False

False

False

False

Version Number

websiteurl

Web site URL for the lead.

String

WebSiteUrl

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Web Site

yomicompanyname

Name of the company with which the lead is associated.

String

YomiCompanyName

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Yomi Company Name

yomifirstname

Hiragana or Katakana phonetic guide for the lead first name, used for Yomi sorting.

String

YomiFirstName

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Yomi First Name

yomifullname

Hiragana or Katakana phonetic guide for the lead full name, used for Yomi sorting.

String

YomiFullName

False

True

None

False

True

False

False

False

False

True

True

False

False

True

False

True

Yomi Full Name

yomilastname

Hiragana or Katakana phonetic guide for the lead last name, used for Yomi sorting.

String

YomiLastName

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Yomi Last Name

yomimiddlename

Hiragana or Katakana phonetic guide for the lead middle name, used for Yomi sorting.

String

YomiMiddleName

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Yomi Middle Name

Internal Attributes

The following table contains the attributes that are intended for internal use only, if you have the Microsoft Dynamics CRM December 2012 Service Update without Product Updates installed or you have Microsoft Dynamics CRM 2011 Update Rollup 12 installed. For more information, see Updated User Experience for Sales and Customer Service and Product Update Functionality.

Attribute logical name

budgetamount

budgetamount_base

budgetstatus

companyname

confirminterest

decisionmaker

evaluatefit

initialcommunication

need

parentaccountid

parentcontactid

purchaseprocess

purchasetimeframe

qualificationcomments

qualifyingopportunityid

salesstage

schedulefollowup_qualify

schedulefollup_prospect

One-to-Many Relationships

The following table shows the entities that are the referencing entity in a one-to-many relationship with the lead entity.

Relationship schema name Referencing entity

account_originating_lead

account

lead_activity_parties

activityparty

Lead_ActivityPointers

activitypointer

Lead_Annotation

annotation

Lead_Appointments

appointment

Lead_AsyncOperations

asyncoperation

Lead_BulkDeleteFailures

bulkdeletefailure

SourceLead_BulkOperationLogs

bulkoperationlog

CreatedLead_BulkOperationLogs

bulkoperationlog

lead_connections2

connection

lead_connections1

connection

contact_originating_lead

contact

Lead_DuplicateMatchingRecord

duplicaterecord

Lead_DuplicateBaseRecord

duplicaterecord

Lead_Emails

email

Lead_Faxes

fax

lead_master_lead

lead

lead_addresses

leadaddress

Lead_Letters

letter

opportunity_originating_lead

opportunity

Lead_Phonecalls

phonecall

lead_PostFollows

postfollow

lead_PostRegardings

postregarding

lead_PostRoles

postrole

lead_principalobjectattributeaccess

principalobjectattributeaccess

Lead_ProcessSessions

processsession

Lead_RecurringAppointmentMasters

recurringappointmentmaster

Lead_ServiceAppointments

serviceappointment

Lead_SharepointDocumentLocation

sharepointdocumentlocation

Lead_Tasks

task

userentityinstancedata_lead

userentityinstancedata

Many-to-Many Relationships

The following table shows the many-to-many relationships for the lead entity.

Relationship schema name Entity1 Entity2 Intersect entity

accountleads_association

account

lead

accountleads

contactleads_association

contact

lead

contactleads

leadcompetitors_association

lead

competitor

leadcompetitors

leadproduct_association

lead

product

leadproduct

listlead_association

list

lead

listmember

For information about using intersect entities, see Retrieve Records for Many-To-Many Relationships Using Intersect Entities.

Many-to-One Relationships

The following table shows the entities that are the referenced entity in a many-to-one relationship with the lead entity.

Relationship schema name Referenced entity

business_unit_leads

businessunit

campaign_leads

campaign

lead_customer_accounts

account

lead_customer_contacts

contact

lead_master_lead

lead

lead_owning_team

team

lead_owning_user

systemuser

lead_parent_account

account

lead_parent_contact

contact

lead_qualifying_opportunity

opportunity

lk_lead_createdonbehalfby

systemuser

lk_lead_modifiedonbehalfby

systemuser

lk_leadbase_createdby

systemuser

lk_leadbase_modifiedby

systemuser

owner_leads

owner

transactioncurrency_lead

transactioncurrency

See Also

Reference

EntityMetadata
AttributeMetadata
OneToManyRelationshipMetadata
ManyToManyRelationshipMetadata

Concepts

Lead Entity Messages and Methods
Lead Entity OptionSet Attribute Metadata
Lead Entity Privileges

Microsoft Dynamics CRM 2011
Send comments about this topic to Microsoft.
© 2013 Microsoft Corporation. All rights reserved.