Lead Entity Metadata
[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 |
||
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 |
|
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.