Lead table/entity reference

Note

Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.

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

Added by: Lead Management Solution

Messages

Message	Web API Operation	SDK class or method
Assign	PATCH /leads(leadid) Update ownerid property.	AssignRequest
Associate	Associate and disassociate entities	AssociateRequest or Associate
Create	POST /leads See Create	CreateRequest or Create
CreateMultiple	CreateMultiple	CreateMultipleRequest
Delete	DELETE /leads(leadid) See Delete	DeleteRequest or Delete
Disassociate	Associate and disassociate entities	DisassociateRequest or Disassociate
GrantAccess	GrantAccess	GrantAccessRequest
Merge	Merge	MergeRequest
ModifyAccess	ModifyAccess	ModifyAccessRequest
msdyn_GDPROptoutLead		Type generated by Power Platform CLI pac modelbuilder build command or use OrganizationRequest setting the required parameters for the message.
QualifyLead		QualifyLeadRequest
Retrieve	GET /leads(leadid) See Retrieve	RetrieveRequest or Retrieve
RetrieveMultiple	GET /leads See Query Data	RetrieveMultipleRequest or RetrieveMultiple
RetrievePrincipalAccess	RetrievePrincipalAccess	RetrievePrincipalAccessRequest
RetrieveSharedPrincipalsAndAccess	RetrieveSharedPrincipalsAndAccess	RetrieveSharedPrincipalsAndAccessRequest
RevokeAccess	RevokeAccess	RevokeAccessRequest
Rollup	Rollup	RollupRequest
SetState	PATCH /leads(leadid) Update statecode and statuscode properties.	SetStateRequest
Update	PATCH /leads(leadid) See Update	UpdateRequest or Update
UpdateMultiple	UpdateMultiple	UpdateMultipleRequest

Properties

Property	Value
CollectionSchemaName	Leads
DisplayCollectionName	Leads
DisplayName	Lead
EntitySetName	leads
IsBPFEntity	False
LogicalCollectionName	leads
LogicalName	lead
OwnershipType	UserOwned
PrimaryIdAttribute	leadid
PrimaryNameAttribute	fullname
SchemaName	Lead

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

• Address1_AddressId
• Address1_AddressTypeCode
• Address1_City
• Address1_Country
• Address1_County
• Address1_Fax
• Address1_Latitude
• Address1_Line1
• Address1_Line2
• Address1_Line3
• Address1_Longitude
• Address1_Name
• Address1_PostalCode
• Address1_PostOfficeBox
• Address1_ShippingMethodCode
• Address1_StateOrProvince
• Address1_Telephone1
• Address1_Telephone2
• Address1_Telephone3
• Address1_UPSZone
• Address1_UTCOffset
• Address2_AddressId
• Address2_AddressTypeCode
• Address2_City
• Address2_Country
• Address2_County
• Address2_Fax
• Address2_Latitude
• Address2_Line1
• Address2_Line2
• Address2_Line3
• Address2_Longitude
• Address2_Name
• Address2_PostalCode
• Address2_PostOfficeBox
• Address2_ShippingMethodCode
• Address2_StateOrProvince
• Address2_Telephone1
• Address2_Telephone2
• Address2_Telephone3
• Address2_UPSZone
• Address2_UTCOffset
• BudgetAmount
• BudgetStatus
• BusinessCard
• BusinessCardAttributes
• CampaignId
• CompanyName
• ConfirmInterest
• CustomerId
• CustomerIdType
• DecisionMaker
• Description
• DoNotBulkEMail
• DoNotEMail
• DoNotFax
• DoNotPhone
• DoNotPostalMail
• DoNotSendMM
• EMailAddress1
• EMailAddress2
• EMailAddress3
• EntityImage
• EstimatedAmount
• EstimatedCloseDate
• EstimatedValue
• EvaluateFit
• Fax
• FirstName
• FollowEmail
• ImportSequenceNumber
• IndustryCode
• InitialCommunication
• JobTitle
• LastName
• LastOnHoldTime
• LastUsedInCampaign
• LeadId
• LeadQualityCode
• LeadSourceCode
• MiddleName
• MobilePhone
• msdyn_gdproptout
• msdyn_LeadGrade
• msdyn_leadkpiid
• msdyn_LeadScore
• msdyn_LeadScoreTrend
• msdyn_PredictiveScoreId
• msdyn_salesassignmentresult
• msdyn_ScoreHistory
• msdyn_ScoreReasons
• msdyn_segmentid
• Need
• NumberOfEmployees
• OriginatingCaseId
• OverriddenCreatedOn
• OwnerId
• OwnerIdType
• Pager
• ParentAccountId
• ParentContactId
• ParticipatesInWorkflow
• PreferredContactMethodCode
• PriorityCode
• ProcessId
• PurchaseProcess
• PurchaseTimeFrame
• QualificationComments
• QualifyingOpportunityId
• RelatedObjectId
• Revenue
• SalesStage
• SalesStageCode
• Salutation
• ScheduleFollowUp_Prospect
• ScheduleFollowUp_Qualify
• SIC
• SLAId
• StageId
• StateCode
• StatusCode
• Subject
• TeamsFollowed
• Telephone1
• Telephone2
• Telephone3
• TimeZoneRuleVersionNumber
• TransactionCurrencyId
• TraversedPath
• UTCConversionTimeZoneCode
• WebSiteUrl
• YomiCompanyName
• YomiFirstName
• YomiLastName
• YomiMiddleName

Address1_AddressId

Property	Value
Description	Unique identifier for address 1.
DisplayName	Address 1: ID
IsValidForForm	False
IsValidForRead	True
LogicalName	address1_addressid
RequiredLevel	None
Type	Uniqueidentifier

Address1_AddressTypeCode

Property	Value
Description	Select the primary address type.
DisplayName	Address 1: Address Type
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_addresstypecode
RequiredLevel	None
Type	Picklist

Address1_AddressTypeCode Choices/Options

Value	Label	Description
1	Default Value

Address1_City

Property	Value
Description	Type the city for the primary address.
DisplayName	City
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_city
MaxLength	80
RequiredLevel	None
Type	String

Address1_Country

Property	Value
Description	Type the country or region for the primary address.
DisplayName	Country/Region
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_country
MaxLength	80
RequiredLevel	None
Type	String

Address1_County

Property	Value
Description	Type the county for the primary address.
DisplayName	Address 1: County
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_county
MaxLength	50
RequiredLevel	None
Type	String

Address1_Fax

Property	Value
Description	Type the fax number associated with the primary address.
DisplayName	Address 1: Fax
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_fax
MaxLength	50
RequiredLevel	None
Type	String

Address1_Latitude

Property	Value
Description	Type the latitude value for the primary address for use in mapping and other applications.
DisplayName	Address 1: Latitude
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_latitude
MaxValue	90
MinValue	-90
Precision	5
RequiredLevel	None
Type	Double

Address1_Line1

Property	Value
Description	Type the first line of the primary address.
DisplayName	Street 1
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_line1
MaxLength	250
RequiredLevel	None
Type	String

Address1_Line2

Property	Value
Description	Type the second line of the primary address.
DisplayName	Street 2
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_line2
MaxLength	250
RequiredLevel	None
Type	String

Address1_Line3

Property	Value
Description	Type the third line of the primary address.
DisplayName	Street 3
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_line3
MaxLength	250
RequiredLevel	None
Type	String

Address1_Longitude

Property	Value
Description	Type the longitude value for the primary address for use in mapping and other applications.
DisplayName	Address 1: Longitude
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_longitude
MaxValue	180
MinValue	-180
Precision	5
RequiredLevel	None
Type	Double

Address1_Name

Property	Value
Description	Type a descriptive name for the primary address, such as Corporate Headquarters.
DisplayName	Address 1: Name
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_name
MaxLength	100
RequiredLevel	None
Type	String

Address1_PostalCode

Property	Value
Description	Type the ZIP Code or postal code for the primary address.
DisplayName	ZIP/Postal Code
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_postalcode
MaxLength	20
RequiredLevel	None
Type	String

Address1_PostOfficeBox

Property	Value
Description	Type the post office box number of the primary address.
DisplayName	Address 1: Post Office Box
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_postofficebox
MaxLength	20
RequiredLevel	None
Type	String

Address1_ShippingMethodCode

Property	Value
Description	Select a shipping method for deliveries sent to this address.
DisplayName	Address 1: Shipping Method
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_shippingmethodcode
RequiredLevel	None
Type	Picklist

Address1_ShippingMethodCode Choices/Options

Value	Label	Description
1	Default Value

Address1_StateOrProvince

Property	Value
Description	Type the state or province of the primary address.
DisplayName	State/Province
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_stateorprovince
MaxLength	50
RequiredLevel	None
Type	String

Address1_Telephone1

Property	Value
Description	Type the main phone number associated with the primary address.
DisplayName	Address 1: Telephone 1
FormatName	Phone
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_telephone1
MaxLength	50
RequiredLevel	None
Type	String

Address1_Telephone2

Property	Value
Description	Type a second phone number associated with the primary address.
DisplayName	Address 1: Telephone 2
FormatName	Phone
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_telephone2
MaxLength	50
RequiredLevel	None
Type	String

Address1_Telephone3

Property	Value
Description	Type a third phone number associated with the primary address.
DisplayName	Address 1: Telephone 3
FormatName	Phone
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_telephone3
MaxLength	50
RequiredLevel	None
Type	String

Address1_UPSZone

Property	Value
Description	Type the UPS zone of the primary address to make sure shipping charges are calculated correctly and deliveries are made promptly, if shipped by UPS.
DisplayName	Address 1: UPS Zone
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_upszone
MaxLength	4
RequiredLevel	None
Type	String

Address1_UTCOffset

Property	Value
Description	Select the time zone, or UTC offset, for this address so that other people can reference it when they contact someone at this address.
DisplayName	Address 1: UTC Offset
Format	TimeZone
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_utcoffset
MaxValue	1500
MinValue	-1500
RequiredLevel	None
Type	Integer

Address2_AddressId

Property	Value
Description	Unique identifier for address 2.
DisplayName	Address 2: ID
IsValidForForm	False
IsValidForRead	True
LogicalName	address2_addressid
RequiredLevel	None
Type	Uniqueidentifier

Address2_AddressTypeCode

Property	Value
Description	Select the secondary address type.
DisplayName	Address 2: Address Type
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_addresstypecode
RequiredLevel	None
Type	Picklist

Address2_AddressTypeCode Choices/Options

Value	Label	Description
1	Default Value

Address2_City

Property	Value
Description	Type the city for the secondary address.
DisplayName	Address 2: City
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_city
MaxLength	80
RequiredLevel	None
Type	String

Address2_Country

Property	Value
Description	Type the country or region for the secondary address.
DisplayName	Address 2: Country/Region
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_country
MaxLength	80
RequiredLevel	None
Type	String

Address2_County

Property	Value
Description	Type the county for the secondary address.
DisplayName	Address 2: County
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_county
MaxLength	50
RequiredLevel	None
Type	String

Address2_Fax

Property	Value
Description	Type the fax number associated with the secondary address.
DisplayName	Address 2: Fax
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_fax
MaxLength	50
RequiredLevel	None
Type	String

Address2_Latitude

Property	Value
Description	Type the latitude value for the secondary address for use in mapping and other applications.
DisplayName	Address 2: Latitude
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_latitude
MaxValue	90
MinValue	-90
Precision	5
RequiredLevel	None
Type	Double

Address2_Line1

Property	Value
Description	Type the first line of the secondary address.
DisplayName	Address 2: Street 1
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_line1
MaxLength	250
RequiredLevel	None
Type	String

Address2_Line2

Property	Value
Description	Type the second line of the secondary address.
DisplayName	Address 2: Street 2
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_line2
MaxLength	250
RequiredLevel	None
Type	String

Address2_Line3

Property	Value
Description	Type the third line of the secondary address.
DisplayName	Address 2: Street 3
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_line3
MaxLength	250
RequiredLevel	None
Type	String

Address2_Longitude

Property	Value
Description	Type the longitude value for the secondary address for use in mapping and other applications.
DisplayName	Address 2: Longitude
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_longitude
MaxValue	180
MinValue	-180
Precision	5
RequiredLevel	None
Type	Double

Address2_Name

Property	Value
Description	Type a descriptive name for the secondary address, such as Corporate Headquarters.
DisplayName	Address 2: Name
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_name
MaxLength	100
RequiredLevel	None
Type	String

Address2_PostalCode

Property	Value
Description	Type the ZIP Code or postal code for the secondary address.
DisplayName	Address 2: ZIP/Postal Code
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_postalcode
MaxLength	20
RequiredLevel	None
Type	String

Address2_PostOfficeBox

Property	Value
Description	Type the post office box number of the secondary address.
DisplayName	Address 2: Post Office Box
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_postofficebox
MaxLength	20
RequiredLevel	None
Type	String

Address2_ShippingMethodCode

Property	Value
Description	Select a shipping method for deliveries sent to this address.
DisplayName	Address 2: Shipping Method
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_shippingmethodcode
RequiredLevel	None
Type	Picklist

Address2_ShippingMethodCode Choices/Options

Value	Label	Description
1	Default Value

Address2_StateOrProvince

Property	Value
Description	Type the state or province of the secondary address.
DisplayName	Address 2: State/Province
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_stateorprovince
MaxLength	50
RequiredLevel	None
Type	String

Address2_Telephone1

Property	Value
Description	Type the main phone number associated with the secondary address.
DisplayName	Address 2: Telephone 1
FormatName	Phone
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_telephone1
MaxLength	50
RequiredLevel	None
Type	String

Address2_Telephone2

Property	Value
Description	Type a second phone number associated with the secondary address.
DisplayName	Address 2: Telephone 2
FormatName	Phone
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_telephone2
MaxLength	50
RequiredLevel	None
Type	String

Address2_Telephone3

Property	Value
Description	Type a third phone number associated with the secondary address.
DisplayName	Address 2: Telephone 3
FormatName	Phone
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_telephone3
MaxLength	50
RequiredLevel	None
Type	String

Address2_UPSZone

Property	Value
Description	Type the UPS zone of the secondary address to make sure shipping charges are calculated correctly and deliveries are made promptly, if shipped by UPS.
DisplayName	Address 2: UPS Zone
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_upszone
MaxLength	4
RequiredLevel	None
Type	String

Address2_UTCOffset

Property	Value
Description	Select the time zone, or UTC offset, for this address so that other people can reference it when they contact someone at this address.
DisplayName	Address 2: UTC Offset
Format	TimeZone
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_utcoffset
MaxValue	1500
MinValue	-1500
RequiredLevel	None
Type	Integer

BudgetAmount

Property	Value
Description	Information about the budget amount of the lead's company or organization.
DisplayName	Budget Amount
IsValidForForm	True
IsValidForRead	True
LogicalName	budgetamount
MaxValue	1000000000000
MinValue	0
Precision	2
PrecisionSource	2
RequiredLevel	None
Type	Money

BudgetStatus

Property	Value
Description	Information about the budget status of the lead's company or organization.
DisplayName	Budget
IsValidForForm	True
IsValidForRead	True
LogicalName	budgetstatus
RequiredLevel	None
Type	Picklist

BudgetStatus Choices/Options

Value	Label	Description
0	No Committed Budget
1	May Buy
2	Can Buy
3	Will Buy

BusinessCard

Added by: Sales Patch Version 2 Solution

Property	Value
Description	Stores Image of the Business Card
DisplayName	Business Card
Format	TextArea
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	businesscard
MaxLength	1073741823
RequiredLevel	None
Type	Memo

BusinessCardAttributes

Added by: Sales Patch Version 2 Solution

Property	Value
Description	Stores Business Card Control Properties.
DisplayName	BusinessCardAttributes
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	businesscardattributes
MaxLength	4000
RequiredLevel	None
Type	String

CampaignId

Added by: Marketing Solution

Property	Value
Description	Choose the campaign that the lead was generated from to track the effectiveness of marketing campaigns and identify communications received by the lead.
DisplayName	Source Campaign
IsValidForForm	True
IsValidForRead	True
LogicalName	campaignid
RequiredLevel	None
Targets	campaign
Type	Lookup

CompanyName

Property	Value
Description	Type the name of the company associated with the lead. This becomes the account name when the lead is qualified and converted to a customer account.
DisplayName	Company Name
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	companyname
MaxLength	100
RequiredLevel	Recommended
Type	String

ConfirmInterest

Property	Value
Description	Select whether the lead confirmed interest in your offerings. This helps in determining the lead quality.
DisplayName	Confirm Interest
IsValidForForm	True
IsValidForRead	True
LogicalName	confirminterest
RequiredLevel	None
Type	Boolean

ConfirmInterest Choices/Options

Value	Label	Description
1	No
0	Yes

DefaultValue: 0

CustomerId

Property	Value
Description	Select the customer account or contact to provide a quick link to additional customer details, such as account information, activities, and opportunities.
DisplayName	Customer
IsValidForForm	True
IsValidForRead	True
LogicalName	customerid
RequiredLevel	None
Targets	account,contact
Type	Customer

CustomerIdType

Added by: Active Solution Solution

Property	Value
Description
DisplayName	Customer Type
IsValidForForm	False
IsValidForRead	True
LogicalName	customeridtype
RequiredLevel	None
Type	EntityName

DecisionMaker

Property	Value
Description	Select whether your notes include information about who makes the purchase decisions at the lead's company.
DisplayName	Decision Maker?
IsValidForForm	True
IsValidForRead	True
LogicalName	decisionmaker
RequiredLevel	None
Type	Boolean

DecisionMaker Choices/Options

Value	Label	Description
1	completed
0	mark complete

DefaultValue: 0

Description

Property	Value
Description	Type additional information to describe the lead, such as an excerpt from the company's website.
DisplayName	Description
Format	TextArea
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	description
MaxLength	2000
RequiredLevel	None
Type	Memo

DoNotBulkEMail

Property	Value
Description	Select whether the lead accepts bulk email sent through marketing campaigns or quick campaigns. If Do Not Allow is selected, the lead can be added to marketing lists, but will be excluded from the email.
DisplayName	Do not allow Bulk Emails
IsValidForForm	True
IsValidForRead	True
LogicalName	donotbulkemail
RequiredLevel	None
Type	Boolean

DoNotBulkEMail Choices/Options

Value	Label	Description
1	Do Not Allow
0	Allow

DefaultValue: 0

DoNotEMail

Property	Value
Description	Select whether the lead allows direct email sent from Microsoft Dynamics 365.
DisplayName	Do not allow Emails
IsValidForForm	True
IsValidForRead	True
LogicalName	donotemail
RequiredLevel	None
Type	Boolean

DoNotEMail Choices/Options

Value	Label	Description
1	Do Not Allow
0	Allow

DefaultValue: 0

DoNotFax

Property	Value
Description	Select whether the lead allows faxes.
DisplayName	Do not allow Faxes
IsValidForForm	True
IsValidForRead	True
LogicalName	donotfax
RequiredLevel	None
Type	Boolean

DoNotFax Choices/Options

Value	Label	Description
1	Do Not Allow
0	Allow

DefaultValue: 0

DoNotPhone

Property	Value
Description	Select whether the lead allows phone calls.
DisplayName	Do not allow Phone Calls
IsValidForForm	True
IsValidForRead	True
LogicalName	donotphone
RequiredLevel	None
Type	Boolean

DoNotPhone Choices/Options

Value	Label	Description
1	Do Not Allow
0	Allow

DefaultValue: 0

DoNotPostalMail

Property	Value
Description	Select whether the lead allows direct mail.
DisplayName	Do not allow Mails
IsValidForForm	True
IsValidForRead	True
LogicalName	donotpostalmail
RequiredLevel	None
Type	Boolean

DoNotPostalMail Choices/Options

Value	Label	Description
1	Do Not Allow
0	Allow

DefaultValue: 0

DoNotSendMM

Property	Value
Description	Select whether the lead accepts marketing materials, such as brochures or catalogs. Leads that opt out can be excluded from marketing initiatives.
DisplayName	Marketing Material
IsValidForForm	True
IsValidForRead	True
LogicalName	donotsendmm
RequiredLevel	None
Type	Boolean

DoNotSendMM Choices/Options

Value	Label	Description
1	Do Not Send
0	Send

DefaultValue: 0

EMailAddress1

Property	Value
Description	Type the primary email address for the lead.
DisplayName	Email
FormatName	Email
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	emailaddress1
MaxLength	100
RequiredLevel	None
Type	String

EMailAddress2

Property	Value
Description	Type the secondary email address for the lead.
DisplayName	Email Address 2
FormatName	Email
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	emailaddress2
MaxLength	100
RequiredLevel	None
Type	String

EMailAddress3

Property	Value
Description	Type a third email address for the lead.
DisplayName	Email Address 3
FormatName	Email
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	emailaddress3
MaxLength	100
RequiredLevel	None
Type	String

EntityImage

Added by: Active Solution Solution

Property	Value
Description	Shows the default image for the record.
DisplayName	Entity Image
IsPrimaryImage	True
IsValidForForm	False
IsValidForRead	True
LogicalName	entityimage
MaxHeight	144
MaxWidth	144
RequiredLevel	None
Type	Image

EstimatedAmount

Property	Value
Description	Type the estimated revenue value that this lead will generate to assist in sales forecasting and planning.
DisplayName	Est. Value
IsValidForForm	True
IsValidForRead	True
LogicalName	estimatedamount
MaxValue	1000000000000
MinValue	0
Precision	2
PrecisionSource	2
RequiredLevel	None
Type	Money

EstimatedCloseDate

Property	Value
DateTimeBehavior	DateOnly
Description	Enter the expected close date for the lead, so that the sales team can schedule timely follow-up meetings to move the prospect to the next sales stage.
DisplayName	Est. Close Date
Format	DateOnly
IsValidForForm	True
IsValidForRead	True
LogicalName	estimatedclosedate
RequiredLevel	None
Type	DateTime

EstimatedValue

Property	Value
Description	Type a numeric value of the lead's estimated value, such as a product quantity, if no revenue amount can be specified in the Est. Value field. This can be used for sales forecasting and planning.
DisplayName	Est. Value (deprecated)
IsValidForForm	True
IsValidForRead	True
LogicalName	estimatedvalue
MaxValue	1000000000
MinValue	0
Precision	2
RequiredLevel	None
Type	Double

EvaluateFit

Property	Value
Description	Select whether the fit between the lead's requirements and your offerings was evaluated.
DisplayName	Evaluate Fit
IsValidForForm	True
IsValidForRead	True
LogicalName	evaluatefit
RequiredLevel	None
Type	Boolean

EvaluateFit Choices/Options

Value	Label	Description
1	No
0	Yes

DefaultValue: 0

Fax

Property	Value
Description	Type the fax number for the primary contact for the lead.
DisplayName	Fax
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	fax
MaxLength	50
RequiredLevel	None
Type	String

FirstName

Property	Value
Description	Type the first name of the primary contact for the lead to make sure the prospect is addressed correctly in sales calls, email, and marketing campaigns.
DisplayName	First Name
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	firstname
MaxLength	50
RequiredLevel	Recommended
Type	String

FollowEmail

Property	Value
Description	Information about whether to allow following email activity like opens, attachment views and link clicks for emails sent to the lead.
DisplayName	Follow Email Activity
IsValidForForm	True
IsValidForRead	True
LogicalName	followemail
RequiredLevel	None
Type	Boolean

FollowEmail Choices/Options

Value	Label	Description
1	Allow
0	Do Not Allow

DefaultValue: 1

ImportSequenceNumber

Property	Value
Description	Sequence number of the import that created this record.
DisplayName	Import Sequence Number
Format	None
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
LogicalName	importsequencenumber
MaxValue	2147483647
MinValue	-2147483648
RequiredLevel	None
Type	Integer

IndustryCode

Property	Value
Description	Select the primary industry in which the lead's business is focused, for use in marketing segmentation and demographic analysis.
DisplayName	Industry
IsValidForForm	True
IsValidForRead	True
LogicalName	industrycode
RequiredLevel	None
Type	Picklist

IndustryCode Choices/Options

Value	Label	Description
1	Accounting
2	Agriculture and Non-petrol Natural Resource Extraction
3	Broadcasting Printing and Publishing
4	Brokers
5	Building Supply Retail
6	Business Services
7	Consulting
8	Consumer Services
9	Design, Direction and Creative Management
10	Distributors, Dispatchers and Processors
11	Doctor's Offices and Clinics
12	Durable Manufacturing
13	Eating and Drinking Places
14	Entertainment Retail
15	Equipment Rental and Leasing
16	Financial
17	Food and Tobacco Processing
18	Inbound Capital Intensive Processing
19	Inbound Repair and Services
20	Insurance
21	Legal Services
22	Non-Durable Merchandise Retail
23	Outbound Consumer Service
24	Petrochemical Extraction and Distribution
25	Service Retail
26	SIG Affiliations
27	Social Services
28	Special Outbound Trade Contractors
29	Specialty Realty
30	Transportation
31	Utility Creation and Distribution
32	Vehicle Retail
33	Wholesale

InitialCommunication

Property	Value
Description	Choose whether someone from the sales team contacted this lead earlier.
DisplayName	Initial Communication
IsValidForForm	True
IsValidForRead	True
LogicalName	initialcommunication
RequiredLevel	None
Type	Picklist

InitialCommunication Choices/Options

Value	Label	Description
0	Contacted
1	Not Contacted

JobTitle

Property	Value
Description	Type the job title of the primary contact for this lead to make sure the prospect is addressed correctly in sales calls, email, and marketing campaigns.
DisplayName	Job Title
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	jobtitle
MaxLength	100
RequiredLevel	None
Type	String

LastName

Property	Value
Description	Type the last name of the primary contact for the lead to make sure the prospect is addressed correctly in sales calls, email, and marketing campaigns.
DisplayName	Last Name
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	lastname
MaxLength	50
RequiredLevel	ApplicationRequired
Type	String

LastOnHoldTime

Property	Value
DateTimeBehavior	UserLocal
Description	Contains the date and time stamp of the last on hold time.
DisplayName	Last On Hold Time
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	lastonholdtime
RequiredLevel	None
Type	DateTime

LastUsedInCampaign

Property	Value
DateTimeBehavior	UserLocal
Description	Shows the date when the lead was last included in a marketing campaign or quick campaign.
DisplayName	Last Campaign Date
Format	DateOnly
IsValidForCreate	False
IsValidForForm	True
IsValidForRead	True
LogicalName	lastusedincampaign
RequiredLevel	None
Type	DateTime

LeadId

Property	Value
Description	Unique identifier of the lead.
DisplayName	Lead
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
LogicalName	leadid
RequiredLevel	SystemRequired
Type	Uniqueidentifier

LeadQualityCode

Property	Value
Description	Select a rating value to indicate the lead's potential to become a customer.
DisplayName	Rating
IsValidForForm	True
IsValidForRead	True
LogicalName	leadqualitycode
RequiredLevel	None
Type	Picklist

LeadQualityCode Choices/Options

Value	Label	Description
1	Hot
2	Warm
3	Cold

LeadSourceCode

Property	Value
Description	Select the primary marketing source that prompted the lead to contact you.
DisplayName	Lead Source
IsValidForForm	True
IsValidForRead	True
LogicalName	leadsourcecode
RequiredLevel	None
Type	Picklist

LeadSourceCode Choices/Options

Value	Label	Description
1	Advertisement
2	Employee Referral
3	External Referral
4	Partner
5	Public Relations
6	Seminar
7	Trade Show
8	Web
9	Word of Mouth
10	Other

MiddleName

Property	Value
Description	Type the middle name or initial of the primary contact for the lead to make sure the prospect is addressed correctly.
DisplayName	Middle Name
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	middlename
MaxLength	50
RequiredLevel	None
Type	String

MobilePhone

Property	Value
Description	Type the mobile phone number for the primary contact for the lead.
DisplayName	Mobile Phone
FormatName	Phone
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	mobilephone
MaxLength	20
RequiredLevel	None
Type	String

msdyn_gdproptout

Added by: SI Common Solution

Property	Value
Description	Describes whether lead is opted out or not
DisplayName	GDPR Optout
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_gdproptout
RequiredLevel	None
Type	Boolean

msdyn_gdproptout Choices/Options

Value	Label	Description
1	Yes
0	No

DefaultValue: 0

msdyn_LeadGrade

Added by: Predictive Lead Scoring Solution

Property	Value
Description
DisplayName	(Deprecated) Lead Grade
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_leadgrade
RequiredLevel	None
Type	Picklist

msdyn_LeadGrade Choices/Options

Value	Label	Description
0	Grade A
1	Grade B
2	Grade C
3	Grade D

msdyn_leadkpiid

Added by: Relationship analytics Solution

Property	Value
Description	LeadKPIId
DisplayName	KPI
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_leadkpiid
RequiredLevel	None
Targets	msdyn_leadkpiitem
Type	Lookup

msdyn_LeadScore

Added by: Predictive Lead Scoring Solution

Property	Value
Description
DisplayName	(Deprecated) Lead Score
Format	None
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_leadscore
MaxValue	2147483647
MinValue	-2147483648
RequiredLevel	None
Type	Integer

msdyn_LeadScoreTrend

Added by: Predictive Lead Scoring Solution

Property	Value
Description
DisplayName	(Deprecated) Lead Score Trend
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_leadscoretrend
RequiredLevel	None
Type	Picklist

msdyn_LeadScoreTrend Choices/Options

Value	Label	Description
0	Improving
1	Steady
2	Declining
3	Not enough info

msdyn_PredictiveScoreId

Added by: Predictive Scoring Common Solution

Property	Value
Description	Predictive score
DisplayName	Predictive Score
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_predictivescoreid
RequiredLevel	None
Targets	msdyn_predictivescore
Type	Lookup

msdyn_salesassignmentresult

Added by: Assignment Rules Solution

Property	Value
Description	Result of the assignment rule process
DisplayName	Assignment Rule Result
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_salesassignmentresult
RequiredLevel	None
Type	Picklist

msdyn_salesassignmentresult Choices/Options

Value	Label	Description
0	Succeeded
1	Failed

msdyn_ScoreHistory

Added by: Predictive Lead Scoring Solution

Property	Value
Description
DisplayName	(Deprecated) Score History
Format	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_scorehistory
MaxLength	2000
RequiredLevel	None
Type	Memo

msdyn_ScoreReasons

Added by: Predictive Lead Scoring Solution

Property	Value
Description
DisplayName	(Deprecated) Score Reasons
Format	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_scorereasons
MaxLength	2000
RequiredLevel	None
Type	Memo

msdyn_segmentid

Added by: Segment solution Solution

Property	Value
Description	Unique identifier for Segment associated with Lead.
DisplayName	Segment Id
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_segmentid
RequiredLevel	None
Targets	msdyn_segment
Type	Lookup

Need

Property	Value
Description	Choose how high the level of need is for the lead's company.
DisplayName	Need
IsValidForForm	True
IsValidForRead	True
LogicalName	need
RequiredLevel	None
Type	Picklist

Need Choices/Options

Value	Label	Description
0	Must have
1	Should have
2	Good to have
3	No need

NumberOfEmployees

Property	Value
Description	Type the number of employees that work at the company associated with the lead, for use in marketing segmentation and demographic analysis.
DisplayName	No. of Employees
Format	None
IsValidForForm	True
IsValidForRead	True
LogicalName	numberofemployees
MaxValue	1000000
MinValue	0
RequiredLevel	None
Type	Integer

OriginatingCaseId

Added by: Service Solution

Property	Value
Description	This attribute is used for Sample Service Business Processes.
DisplayName	Originating Case
IsValidForForm	True
IsValidForRead	True
LogicalName	originatingcaseid
RequiredLevel	None
Targets	incident
Type	Lookup

OverriddenCreatedOn

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time that the record was migrated.
DisplayName	Record Created On
Format	DateOnly
IsValidForForm	False
IsValidForRead	True
IsValidForUpdate	False
LogicalName	overriddencreatedon
RequiredLevel	None
Type	DateTime

OwnerId

Property	Value
Description	Owner Id
DisplayName	Owner
IsValidForForm	True
IsValidForRead	True
LogicalName	ownerid
RequiredLevel	SystemRequired
Targets	systemuser,team
Type	Owner

OwnerIdType

Added by: Active Solution Solution

Property	Value
Description	Owner Id Type
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	owneridtype
RequiredLevel	SystemRequired
Type	EntityName

Pager

Property	Value
Description	Type the pager number for the primary contact for the lead.
DisplayName	Pager
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	pager
MaxLength	20
RequiredLevel	None
Type	String

ParentAccountId

Property	Value
Description	Choose an account to connect this lead to, so that the relationship is visible in reports and analytics.
DisplayName	Parent Account for lead
IsValidForForm	True
IsValidForRead	True
LogicalName	parentaccountid
RequiredLevel	None
Targets	account
Type	Lookup

ParentContactId

Property	Value
Description	Choose a contact to connect this lead to, so that the relationship is visible in reports and analytics.
DisplayName	Parent Contact for lead
IsValidForForm	True
IsValidForRead	True
LogicalName	parentcontactid
RequiredLevel	None
Targets	contact
Type	Lookup

ParticipatesInWorkflow

Property	Value
Description	Shows whether the lead participates in workflow rules.
DisplayName	Participates in Workflow
IsValidForForm	False
IsValidForRead	True
LogicalName	participatesinworkflow
RequiredLevel	None
Type	Boolean

ParticipatesInWorkflow Choices/Options

Value	Label	Description
1	Yes
0	No

DefaultValue: 0

PreferredContactMethodCode

Property	Value
Description	Select the preferred method of contact.
DisplayName	Preferred Method of Contact
IsValidForForm	True
IsValidForRead	True
LogicalName	preferredcontactmethodcode
RequiredLevel	None
Type	Picklist

PreferredContactMethodCode Choices/Options

Value	Label	Description
1	Any
2	Email
3	Phone
4	Fax
5	Mail

PriorityCode

Property	Value
Description	Select the priority so that preferred customers or critical issues are handled quickly.
DisplayName	Priority
IsValidForForm	True
IsValidForRead	True
LogicalName	prioritycode
RequiredLevel	None
Type	Picklist

PriorityCode Choices/Options

Value	Label	Description
1	Default Value

ProcessId

Property	Value
Description	Contains the id of the process associated with the entity.
DisplayName	Process Id
IsValidForForm	False
IsValidForRead	True
LogicalName	processid
RequiredLevel	None
Type	Uniqueidentifier

PurchaseProcess

Property	Value
Description	Choose whether an individual or a committee will be involved in the purchase process for the lead.
DisplayName	Purchase Process
IsValidForForm	True
IsValidForRead	True
LogicalName	purchaseprocess
RequiredLevel	None
Type	Picklist

PurchaseProcess Choices/Options

Value	Label	Description
0	Individual
1	Committee
2	Unknown

PurchaseTimeFrame

Property	Value
Description	Choose how long the lead will likely take to make the purchase, so the sales team will be aware.
DisplayName	Purchase Timeframe
IsValidForForm	True
IsValidForRead	True
LogicalName	purchasetimeframe
RequiredLevel	None
Type	Picklist

PurchaseTimeFrame Choices/Options

Value	Label	Description
0	Immediate
1	This Quarter
2	Next Quarter
3	This Year
4	Unknown

QualificationComments

Property	Value
Description	Type comments about the qualification or scoring of the lead.
DisplayName	Qualification Comments
Format	TextArea
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	qualificationcomments
MaxLength	2000
RequiredLevel	None
Type	Memo

QualifyingOpportunityId

Added by: Sales Solution

Property	Value
Description	Choose the opportunity that the lead was qualified on and then converted to.
DisplayName	Qualifying Opportunity
IsValidForForm	True
IsValidForRead	True
LogicalName	qualifyingopportunityid
RequiredLevel	None
Targets	opportunity
Type	Lookup

RelatedObjectId

Added by: Marketing Solution

Property	Value
Description	Related Campaign Response.
DisplayName	Related Campaign Response
IsValidForForm	True
IsValidForRead	True
IsValidForUpdate	False
LogicalName	relatedobjectid
RequiredLevel	None
Targets	campaignresponse
Type	Lookup

Revenue

Property	Value
Description	Type the annual revenue of the company associated with the lead to provide an understanding of the prospect's business.
DisplayName	Annual Revenue
IsValidForForm	True
IsValidForRead	True
LogicalName	revenue
MaxValue	100000000000000
MinValue	0
Precision	2
PrecisionSource	2
RequiredLevel	None
Type	Money

SalesStage

Property	Value
Description	Select the sales stage of this lead to aid the sales team in their efforts to convert this lead to an opportunity.
DisplayName	Sales Stage
IsValidForForm	True
IsValidForRead	True
LogicalName	salesstage
RequiredLevel	None
Type	Picklist

SalesStage Choices/Options

Value	Label	Description
0	Qualify

SalesStageCode

Property	Value
Description	Select the sales process stage for the lead to help determine the probability of the lead converting to an opportunity.
DisplayName	Sales Stage Code
IsValidForForm	True
IsValidForRead	True
LogicalName	salesstagecode
RequiredLevel	None
Type	Picklist

SalesStageCode Choices/Options

Value	Label	Description
1	Default Value

Salutation

Property	Value
Description	Type the salutation of the primary contact for this lead to make sure the prospect is addressed correctly in sales calls, email messages, and marketing campaigns.
DisplayName	Salutation
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	salutation
MaxLength	100
RequiredLevel	None
Type	String

ScheduleFollowUp_Prospect

Property	Value
DateTimeBehavior	UserLocal
Description	Enter the date and time of the prospecting follow-up meeting with the lead.
DisplayName	Schedule Follow Up (Prospect)
Format	DateOnly
IsValidForForm	True
IsValidForRead	True
LogicalName	schedulefollowup_prospect
RequiredLevel	None
Type	DateTime

ScheduleFollowUp_Qualify

Property	Value
DateTimeBehavior	UserLocal
Description	Enter the date and time of the qualifying follow-up meeting with the lead.
DisplayName	Schedule Follow Up (Qualify)
Format	DateOnly
IsValidForForm	True
IsValidForRead	True
LogicalName	schedulefollowup_qualify
RequiredLevel	None
Type	DateTime

SIC

Property	Value
Description	Type the Standard Industrial Classification (SIC) code that indicates the lead's primary industry of business for use in marketing segmentation and demographic analysis.
DisplayName	SIC Code
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	sic
MaxLength	20
RequiredLevel	None
Type	String

SLAId

Property	Value
Description	Choose the service level agreement (SLA) that you want to apply to the Lead record.
DisplayName	SLA
IsValidForForm	True
IsValidForRead	True
LogicalName	slaid
RequiredLevel	None
Targets	sla
Type	Lookup

StageId

Property	Value
Description	Contains the id of the stage where the entity is located.
DisplayName	(Deprecated) Stage Id
IsValidForForm	False
IsValidForRead	True
LogicalName	stageid
RequiredLevel	None
Type	Uniqueidentifier

StateCode

Property	Value
Description	Shows whether the lead is open, qualified, or disqualified. Qualified and disqualified leads are read-only and can't be edited unless they are reactivated.
DisplayName	Status
IsValidForCreate	False
IsValidForForm	True
IsValidForRead	True
LogicalName	statecode
RequiredLevel	SystemRequired
Type	State

StateCode Choices/Options

Value	Label	DefaultStatus	InvariantName
0	Open	1	Open
1	Qualified	3	Qualified
2	Disqualified	4	Disqualified

StatusCode

Property	Value
Description	Select the lead's status.
DisplayName	Status Reason
IsValidForForm	True
IsValidForRead	True
LogicalName	statuscode
RequiredLevel	None
Type	Status

StatusCode Choices/Options

Value	Label	State
1	New	0
2	Contacted	0
3	Qualified	1
4	Lost	2
5	Cannot Contact	2
6	No Longer Interested	2
7	Canceled	2

Subject

Property	Value
Description	Type a subject or descriptive name, such as the expected order, company name, or marketing source list, to identify the lead.
DisplayName	Topic
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	subject
MaxLength	300
RequiredLevel	ApplicationRequired
Type	String

TeamsFollowed

Added by: Sales Patch Solution

Property	Value
Description	Number of users or conversations followed the record
DisplayName	TeamsFollowed
Format	None
IsValidForForm	False
IsValidForRead	True
LogicalName	teamsfollowed
MaxValue	2147483647
MinValue	-2147483648
RequiredLevel	None
Type	Integer

Telephone1

Property	Value
Description	Type the work phone number for the primary contact for the lead.
DisplayName	Business Phone
FormatName	Phone
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	telephone1
MaxLength	50
RequiredLevel	None
Type	String

Telephone2

Property	Value
Description	Type the home phone number for the primary contact for the lead.
DisplayName	Home Phone
FormatName	Phone
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	telephone2
MaxLength	50
RequiredLevel	None
Type	String

Telephone3

Property	Value
Description	Type an alternate phone number for the primary contact for the lead.
DisplayName	Other Phone
FormatName	Phone
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	telephone3
MaxLength	50
RequiredLevel	None
Type	String

TimeZoneRuleVersionNumber

Property	Value
Description	For internal use only.
DisplayName	Time Zone Rule Version Number
Format	None
IsValidForForm	False
IsValidForRead	True
LogicalName	timezoneruleversionnumber
MaxValue	2147483647
MinValue	-1
RequiredLevel	None
Type	Integer

TransactionCurrencyId

Property	Value
Description	Choose the local currency for the record to make sure budgets are reported in the correct currency.
DisplayName	Currency
IsValidForForm	True
IsValidForRead	True
LogicalName	transactioncurrencyid
RequiredLevel	None
Targets	transactioncurrency
Type	Lookup

TraversedPath

Property	Value
Description	A comma separated list of string values representing the unique identifiers of stages in a Business Process Flow Instance in the order that they occur.
DisplayName	(Deprecated) Traversed Path
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	traversedpath
MaxLength	1250
RequiredLevel	None
Type	String

UTCConversionTimeZoneCode

Property	Value
Description	Time zone code that was in use when the record was created.
DisplayName	UTC Conversion Time Zone Code
Format	None
IsValidForForm	False
IsValidForRead	True
LogicalName	utcconversiontimezonecode
MaxValue	2147483647
MinValue	-1
RequiredLevel	None
Type	Integer

WebSiteUrl

Property	Value
Description	Type the website URL for the company associated with this lead.
DisplayName	Website
FormatName	Url
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	websiteurl
MaxLength	200
RequiredLevel	None
Type	String

YomiCompanyName

Property	Value
Description	Type the phonetic spelling of the lead's company name, if the name is specified in Japanese, to make sure the name is pronounced correctly in phone calls with the prospect.
DisplayName	Yomi Company Name
FormatName	PhoneticGuide
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	yomicompanyname
MaxLength	100
RequiredLevel	None
Type	String

YomiFirstName

Property	Value
Description	Type the phonetic spelling of the lead's first name, if the name is specified in Japanese, to make sure the name is pronounced correctly in phone calls with the prospect.
DisplayName	Yomi First Name
FormatName	PhoneticGuide
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	yomifirstname
MaxLength	150
RequiredLevel	None
Type	String

YomiLastName

Property	Value
Description	Type the phonetic spelling of the lead's last name, if the name is specified in Japanese, to make sure the name is pronounced correctly in phone calls with the prospect.
DisplayName	Yomi Last Name
FormatName	PhoneticGuide
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	yomilastname
MaxLength	150
RequiredLevel	None
Type	String

YomiMiddleName

Property	Value
Description	Type the phonetic spelling of the lead's middle name, if the name is specified in Japanese, to make sure the name is pronounced correctly in phone calls with the prospect.
DisplayName	Yomi Middle Name
FormatName	PhoneticGuide
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	yomimiddlename
MaxLength	150
RequiredLevel	None
Type	String

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.

• AccountId
• AccountIdName
• AccountIdYomiName
• Address1_Composite
• Address2_Composite
• BudgetAmount_Base
• CampaignIdName
• ContactId
• ContactIdName
• ContactIdYomiName
• CreatedBy
• CreatedByName
• CreatedByYomiName
• CreatedOn
• CreatedOnBehalfBy
• CreatedOnBehalfByName
• CreatedOnBehalfByYomiName
• CustomerIdName
• CustomerIdYomiName
• EntityImage_Timestamp
• EntityImage_URL
• EntityImageId
• EstimatedAmount_Base
• ExchangeRate
• FullName
• IsAutoCreate
• IsPrivate
• MasterId
• MasterLeadIdName
• MasterLeadIdYomiName
• Merged
• ModifiedBy
• ModifiedByName
• ModifiedByYomiName
• ModifiedOn
• ModifiedOnBehalfBy
• ModifiedOnBehalfByName
• ModifiedOnBehalfByYomiName
• msdyn_leadkpiidName
• msdyn_PredictiveScoreIdName
• msdyn_segmentidName
• OnHoldTime
• OriginatingCaseIdName
• OwnerIdName
• OwnerIdYomiName
• OwningBusinessUnit
• OwningBusinessUnitName
• OwningTeam
• OwningUser
• ParentAccountIdName
• ParentAccountIdYomiName
• ParentContactIdName
• ParentContactIdYomiName
• QualifyingOpportunityIdName
• RelatedObjectIdName
• Revenue_Base
• SLAInvokedId
• SLAInvokedIdName
• SLAName
• TimeSpentByMeOnEmailAndMeetings
• TransactionCurrencyIdName
• VersionNumber
• YomiFullName

AccountId

Property	Value
Description	Unique identifier of the account with which the lead is associated.
DisplayName	Account
IsValidForForm	False
IsValidForRead	True
LogicalName	accountid
RequiredLevel	None
Targets	account
Type	Lookup

AccountIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	accountidname
MaxLength	100
RequiredLevel	None
Type	String

AccountIdYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	accountidyominame
MaxLength	100
RequiredLevel	None
Type	String

Address1_Composite

Property	Value
Description	Shows the complete primary address.
DisplayName	Address 1
Format	TextArea
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_composite
MaxLength	1000
RequiredLevel	None
Type	Memo

Address2_Composite

Property	Value
Description	Shows the complete secondary address.
DisplayName	Address 2
Format	TextArea
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_composite
MaxLength	1000
RequiredLevel	None
Type	Memo

BudgetAmount_Base

Property	Value
Description	Value of the Budget Amount in base currency.
DisplayName	Budget Amount (Base)
IsValidForForm	True
IsValidForRead	True
LogicalName	budgetamount_base
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	2
RequiredLevel	None
Type	Money

CampaignIdName

Added by: Marketing Solution

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	campaignidname
MaxLength	100
RequiredLevel	None
Type	String

ContactId

Property	Value
Description	Unique identifier of the contact with which the lead is associated.
DisplayName	Contact
IsValidForForm	False
IsValidForRead	True
LogicalName	contactid
RequiredLevel	None
Targets	contact
Type	Lookup

ContactIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	contactidname
MaxLength	100
RequiredLevel	None
Type	String

ContactIdYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	contactidyominame
MaxLength	100
RequiredLevel	None
Type	String

CreatedBy

Property	Value
Description	Shows who created the record.
DisplayName	Created By
IsValidForForm	True
IsValidForRead	True
LogicalName	createdby
RequiredLevel	None
Targets	systemuser
Type	Lookup

CreatedByName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	createdbyname
MaxLength	100
RequiredLevel	None
Type	String

CreatedByYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	createdbyyominame
MaxLength	100
RequiredLevel	None
Type	String

CreatedOn

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time when the record was created.
DisplayName	Created On
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	createdon
RequiredLevel	None
Type	DateTime

CreatedOnBehalfBy

Property	Value
Description	Shows who created the record on behalf of another user.
DisplayName	Created By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	createdonbehalfby
RequiredLevel	None
Targets	systemuser
Type	Lookup

CreatedOnBehalfByName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	createdonbehalfbyname
MaxLength	100
RequiredLevel	None
Type	String

CreatedOnBehalfByYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	createdonbehalfbyyominame
MaxLength	100
RequiredLevel	None
Type	String

CustomerIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	customeridname
MaxLength	160
RequiredLevel	ApplicationRequired
Type	String

CustomerIdYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	customeridyominame
MaxLength	450
RequiredLevel	ApplicationRequired
Type	String

EntityImage_Timestamp

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	entityimage_timestamp
MaxValue	9223372036854775807
MinValue	-9223372036854775808
RequiredLevel	None
Type	BigInt

EntityImage_URL

Property	Value
Description
DisplayName
FormatName	Url
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	entityimage_url
MaxLength	200
RequiredLevel	None
Type	String

EntityImageId

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	entityimageid
RequiredLevel	None
Type	Uniqueidentifier

EstimatedAmount_Base

Property	Value
Description	Value of the Est. Value in base currency.
DisplayName	Est. Value (Base)
IsValidForForm	True
IsValidForRead	True
LogicalName	estimatedamount_base
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	2
RequiredLevel	None
Type	Money

ExchangeRate

Added by: Active Solution Solution

Property	Value
Description	Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency.
DisplayName	Exchange Rate
IsValidForForm	True
IsValidForRead	True
LogicalName	exchangerate
MaxValue	100000000000
MinValue	0.000000000001
Precision	12
RequiredLevel	None
Type	Decimal

FullName

Property	Value
Description	Combines and shows the lead's first and last names so the full name can be displayed in views and reports.
DisplayName	Name
FormatName	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	fullname
MaxLength	160
RequiredLevel	None
Type	String

IsAutoCreate

Property	Value
Description	Information about whether the contact was auto-created when promoting an email or an appointment.
DisplayName	Auto-created
IsValidForForm	False
IsValidForRead	False
LogicalName	isautocreate
RequiredLevel	None
Type	Boolean

IsAutoCreate Choices/Options

Value	Label	Description
1	Yes
0	No

DefaultValue: 0

IsPrivate

Property	Value
Description	Indicates whether the lead is private or visible to the entire organization.
DisplayName	Is Private
IsValidForForm	False
IsValidForRead	False
LogicalName	isprivate
RequiredLevel	None
Type	Boolean

IsPrivate Choices/Options

Value	Label	Description
1	Yes
0	No

DefaultValue: 0

MasterId

Property	Value
Description	Unique identifier of the master lead for merge.
DisplayName	Master ID
IsValidForForm	False
IsValidForRead	True
LogicalName	masterid
RequiredLevel	None
Targets	lead
Type	Lookup

MasterLeadIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	masterleadidname
MaxLength	100
RequiredLevel	None
Type	String

MasterLeadIdYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	masterleadidyominame
MaxLength	100
RequiredLevel	None
Type	String

Merged

Property	Value
Description	Tells whether the lead has been merged with another lead.
DisplayName	Merged
IsValidForForm	True
IsValidForRead	True
LogicalName	merged
RequiredLevel	None
Type	Boolean

Merged Choices/Options

Value	Label	Description
1	Yes
0	No

DefaultValue: 0

ModifiedBy

Property	Value
Description	Shows who last updated the record.
DisplayName	Modified By
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedby
RequiredLevel	None
Targets	systemuser
Type	Lookup

ModifiedByName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedbyname
MaxLength	100
RequiredLevel	None
Type	String

ModifiedByYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedbyyominame
MaxLength	100
RequiredLevel	None
Type	String

ModifiedOn

Property	Value
DateTimeBehavior	UserLocal
Description	Date and time when the record was modified.
DisplayName	Modified On
Format	DateAndTime
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedon
RequiredLevel	None
Type	DateTime

ModifiedOnBehalfBy

Property	Value
Description	Shows who last updated the record on behalf of another user.
DisplayName	Modified By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedonbehalfby
RequiredLevel	None
Targets	systemuser
Type	Lookup

ModifiedOnBehalfByName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedonbehalfbyname
MaxLength	100
RequiredLevel	None
Type	String

ModifiedOnBehalfByYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedonbehalfbyyominame
MaxLength	100
RequiredLevel	None
Type	String

msdyn_leadkpiidName

Added by: Relationship analytics Solution

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	msdyn_leadkpiidname
MaxLength	100
RequiredLevel	None
Type	String

msdyn_PredictiveScoreIdName

Added by: Predictive Scoring Common Solution

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	msdyn_predictivescoreidname
MaxLength	128
RequiredLevel	None
Type	String

msdyn_segmentidName

Added by: Segment solution Solution

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	msdyn_segmentidname
MaxLength	100
RequiredLevel	None
Type	String

OnHoldTime

Property	Value
Description	Shows how long, in minutes, that the record was on hold.
DisplayName	On Hold Time (Minutes)
Format	None
IsValidForForm	True
IsValidForRead	True
LogicalName	onholdtime
MaxValue	2147483647
MinValue	-2147483648
RequiredLevel	None
Type	Integer

OriginatingCaseIdName

Added by: Service Solution

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	originatingcaseidname
MaxLength	100
RequiredLevel	None
Type	String

OwnerIdName

Property	Value
Description	Name of the owner
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	owneridname
MaxLength	100
RequiredLevel	SystemRequired
Type	String

OwnerIdYomiName

Property	Value
Description	Yomi name of the owner
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	owneridyominame
MaxLength	100
RequiredLevel	SystemRequired
Type	String

OwningBusinessUnit

Property	Value
Description	Unique identifier for the business unit that owns the record
DisplayName	Owning Business Unit
IsValidForForm	True
IsValidForRead	True
LogicalName	owningbusinessunit
RequiredLevel	None
Targets	businessunit
Type	Lookup

OwningBusinessUnitName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	owningbusinessunitname
MaxLength	100
RequiredLevel	SystemRequired
Type	String

OwningTeam

Property	Value
Description	Unique identifier for the team that owns the record.
DisplayName	Owning Team
IsValidForForm	False
IsValidForRead	True
LogicalName	owningteam
RequiredLevel	None
Targets	team
Type	Lookup

OwningUser

Property	Value
Description	Unique identifier for the user that owns the record.
DisplayName	Owning User
IsValidForForm	False
IsValidForRead	True
LogicalName	owninguser
RequiredLevel	None
Targets	systemuser
Type	Lookup

ParentAccountIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	parentaccountidname
MaxLength	100
RequiredLevel	None
Type	String

ParentAccountIdYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	parentaccountidyominame
MaxLength	100
RequiredLevel	None
Type	String

ParentContactIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	parentcontactidname
MaxLength	100
RequiredLevel	None
Type	String

ParentContactIdYomiName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	parentcontactidyominame
MaxLength	100
RequiredLevel	None
Type	String

QualifyingOpportunityIdName

Added by: Sales Solution

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	qualifyingopportunityidname
MaxLength	100
RequiredLevel	None
Type	String

RelatedObjectIdName

Added by: Marketing Solution

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	relatedobjectidname
MaxLength	200
RequiredLevel	None
Type	String

Revenue_Base

Property	Value
Description	Value of the Annual Revenue in base currency.
DisplayName	Annual Revenue (Base)
IsValidForForm	True
IsValidForRead	True
LogicalName	revenue_base
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	2
RequiredLevel	None
Type	Money

SLAInvokedId

Property	Value
Description	Last SLA that was applied to this case. This field is for internal use only.
DisplayName	Last SLA applied
IsValidForForm	False
IsValidForRead	True
LogicalName	slainvokedid
RequiredLevel	None
Targets	sla
Type	Lookup

SLAInvokedIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	slainvokedidname
MaxLength	100
RequiredLevel	None
Type	String

SLAName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	slaname
MaxLength	100
RequiredLevel	None
Type	String

TimeSpentByMeOnEmailAndMeetings

Property	Value
Description	Total time spent for emails (read and write) and meetings by me in relation to the lead record.
DisplayName	Time Spent by me
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	timespentbymeonemailandmeetings
MaxLength	1250
RequiredLevel	None
Type	String

TransactionCurrencyIdName

Property	Value
Description
DisplayName
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	transactioncurrencyidname
MaxLength	100
RequiredLevel	None
Type	String

VersionNumber

Property	Value
Description	Version Number
DisplayName	Version Number
IsValidForForm	False
IsValidForRead	True
LogicalName	versionnumber
MaxValue	9223372036854775807
MinValue	-9223372036854775808
RequiredLevel	None
Type	BigInt

YomiFullName

Property	Value
Description	Combines and shows the lead's Yomi first and last names so the full phonetic name can be displayed in views and reports.
DisplayName	Yomi Full Name
FormatName	PhoneticGuide
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	yomifullname
MaxLength	450
RequiredLevel	None
Type	String

One-To-Many Relationships

Listed by SchemaName.

• lead_addresses
• lead_master_lead
• account_originating_lead
• contact_originating_lead
• lead_BulkOperations
• lead_CampaignResponses
• CreatedLead_BulkOperationLogs
• SourceLead_BulkOperationLogs
• lead_OpportunityCloses
• lead_OrderCloses
• lead_QuoteCloses
• opportunity_originating_lead
• lk_leadtoopportunitysalesprocess_leadid
• msdyn_lead_msdyn_salesroutingrun_targetobject

lead_addresses

Same as the lead_addresses many-to-one relationship for the leadaddress table/entity.

Property	Value
ReferencingEntity	leadaddress
ReferencingAttribute	parentid
IsHierarchical	False
IsCustomizable	True
ReferencedEntityNavigationPropertyName	lead_addresses
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration	Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade

lead_master_lead

Same as the lead_master_lead many-to-one relationship for the lead table/entity.

Property	Value
ReferencingEntity	lead
ReferencingAttribute	masterid
IsHierarchical	False
IsCustomizable	True
ReferencedEntityNavigationPropertyName	lead_master_lead
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration	Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade

account_originating_lead

Same as the account_originating_lead many-to-one relationship for the account table/entity.

Property	Value
ReferencingEntity	account
ReferencingAttribute	originatingleadid
IsHierarchical	False
IsCustomizable	True
ReferencedEntityNavigationPropertyName	account_originating_lead
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration	Assign: NoCascade Delete: RemoveLink Merge: Cascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade

contact_originating_lead

Same as the contact_originating_lead many-to-one relationship for the contact table/entity.

Property	Value
ReferencingEntity	contact
ReferencingAttribute	originatingleadid
IsHierarchical	False
IsCustomizable	True
ReferencedEntityNavigationPropertyName	contact_originating_lead
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration	Assign: NoCascade Delete: RemoveLink Merge: Cascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade

lead_BulkOperations

Added by: Marketing Solution

Same as the lead_BulkOperations many-to-one relationship for the bulkoperation table/entity.

Property	Value
ReferencingEntity	bulkoperation
ReferencingAttribute	regardingobjectid
IsHierarchical	False
IsCustomizable	True
ReferencedEntityNavigationPropertyName	lead_BulkOperations
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration	Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade

lead_CampaignResponses

Added by: Marketing Solution

Same as the lead_CampaignResponses many-to-one relationship for the campaignresponse table/entity.

Property	Value
ReferencingEntity	campaignresponse
ReferencingAttribute	regardingobjectid
IsHierarchical	False
IsCustomizable	True
ReferencedEntityNavigationPropertyName	lead_CampaignResponses
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration	Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade

CreatedLead_BulkOperationLogs

Added by: Marketing Solution

Same as the CreatedLead_BulkOperationLogs many-to-one relationship for the bulkoperationlog table/entity.

Property	Value
ReferencingEntity	bulkoperationlog
ReferencingAttribute	createdobjectid
IsHierarchical	False
IsCustomizable	False
ReferencedEntityNavigationPropertyName	CreatedLead_BulkOperationLogs
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration	Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade

SourceLead_BulkOperationLogs

Added by: Marketing Solution

Same as the SourceLead_BulkOperationLogs many-to-one relationship for the bulkoperationlog table/entity.

Property	Value
ReferencingEntity	bulkoperationlog
ReferencingAttribute	regardingobjectid
IsHierarchical	False
IsCustomizable	False
ReferencedEntityNavigationPropertyName	SourceLead_BulkOperationLogs
AssociatedMenuConfiguration	Behavior: UseCollectionName Group: Details Label: Order:
CascadeConfiguration	Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade

lead_OpportunityCloses

Added by: Sales Solution

Same as the lead_OpportunityCloses many-to-one relationship for the opportunityclose table/entity.

Property	Value
ReferencingEntity	opportunityclose
ReferencingAttribute	regardingobjectid
IsHierarchical	False
IsCustomizable	True
ReferencedEntityNavigationPropertyName	lead_OpportunityCloses
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration	Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade

lead_OrderCloses

Added by: Sales Solution

Same as the lead_OrderCloses many-to-one relationship for the orderclose table/entity.

Property	Value
ReferencingEntity	orderclose
ReferencingAttribute	regardingobjectid
IsHierarchical	False
IsCustomizable	True
ReferencedEntityNavigationPropertyName	lead_OrderCloses
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration	Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade

lead_QuoteCloses

Added by: Sales Solution

Same as the lead_QuoteCloses many-to-one relationship for the quoteclose table/entity.

Property	Value
ReferencingEntity	quoteclose
ReferencingAttribute	regardingobjectid
IsHierarchical	False
IsCustomizable	True
ReferencedEntityNavigationPropertyName	lead_QuoteCloses
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration	Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade

opportunity_originating_lead

Added by: Sales Solution

Same as the opportunity_originating_lead many-to-one relationship for the opportunity table/entity.

Property	Value
ReferencingEntity	opportunity
ReferencingAttribute	originatingleadid
IsHierarchical	False
IsCustomizable	True
ReferencedEntityNavigationPropertyName	opportunity_originating_lead
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration	Assign: NoCascade Delete: RemoveLink Merge: Cascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade

lk_leadtoopportunitysalesprocess_leadid

Added by: Sales Solution

Same as the lk_leadtoopportunitysalesprocess_leadid many-to-one relationship for the leadtoopportunitysalesprocess table/entity.

Property	Value
ReferencingEntity	leadtoopportunitysalesprocess
ReferencingAttribute	leadid
IsHierarchical	False
IsCustomizable	True
ReferencedEntityNavigationPropertyName	lead_leadtoopportunitysalesprocess
AssociatedMenuConfiguration	Behavior: UseCollectionName Group: Details Label: Order:
CascadeConfiguration	Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade

msdyn_lead_msdyn_salesroutingrun_targetobject

Added by: Assignment Rules Solution

Same as the msdyn_lead_msdyn_salesroutingrun_targetobject many-to-one relationship for the msdyn_salesroutingrun table/entity.

Property	Value
ReferencingEntity	msdyn_salesroutingrun
ReferencingAttribute	msdyn_targetobject
IsHierarchical	False
IsCustomizable	True
ReferencedEntityNavigationPropertyName	msdyn_lead_msdyn_salesroutingrun_targetobject
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order: 10000
CascadeConfiguration	Assign: NoCascade Delete: Cascade Merge: Cascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade

Many-To-One Relationships

Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.

• lead_customer_accounts
• lead_customer_contacts
• lead_master_lead
• lead_parent_account
• lead_parent_contact
• CampaignResponse_Lead
• campaign_leads
• lead_qualifying_opportunity
• msdyn_msdyn_predictivescore_lead
• msdyn_msdyn_segment_lead

lead_customer_accounts

Added by: System Solution Solution

See the lead_customer_accounts one-to-many relationship for the account table/entity.

lead_customer_contacts

Added by: System Solution Solution

See the lead_customer_contacts one-to-many relationship for the contact table/entity.

lead_master_lead

See the lead_master_lead one-to-many relationship for the lead table/entity.

lead_parent_account

Added by: System Solution Solution

See the lead_parent_account one-to-many relationship for the account table/entity.

lead_parent_contact

Added by: System Solution Solution

See the lead_parent_contact one-to-many relationship for the contact table/entity.

CampaignResponse_Lead

Added by: Marketing Solution

See the CampaignResponse_Lead one-to-many relationship for the campaignresponse table/entity.

campaign_leads

Added by: Marketing Solution

See the campaign_leads one-to-many relationship for the campaign table/entity.

lead_qualifying_opportunity

Added by: Sales Solution

See the lead_qualifying_opportunity one-to-many relationship for the opportunity table/entity.

msdyn_msdyn_predictivescore_lead

Added by: Predictive Scoring Common Solution

See the msdyn_msdyn_predictivescore_lead one-to-many relationship for the msdyn_predictivescore table/entity.

msdyn_msdyn_segment_lead

Added by: Segment solution Solution

See the msdyn_msdyn_segment_lead one-to-many relationship for the msdyn_segment table/entity.

Many-To-Many Relationships

Relationship details provided where the Lead table is the first table in the relationship. Listed by SchemaName.

• accountleads_association
• contactleads_association
• listlead_association
• BulkOperation_Leads
• CampaignActivity_Leads
• leadproduct_association
• leadcompetitors_association

accountleads_association

See the accountleads_association many-to-many relationship for the account table/entity.

contactleads_association

See the contactleads_association many-to-many relationship for the contact table/entity.

listlead_association

See the listlead_association many-to-many relationship for the list table/entity.

BulkOperation_Leads

See the BulkOperation_Leads many-to-many relationship for the bulkoperation table/entity.

CampaignActivity_Leads

See the CampaignActivity_Leads many-to-many relationship for the campaignactivity table/entity.

leadproduct_association

IntersectEntityName: leadproduct

Table 1

Property	Value
IntersectAttribute	leadid
IsCustomizable	False
LogicalName	lead
NavigationPropertyName	leadproduct_association
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:

Table 2

Property	Value
LogicalName	product
IntersectAttribute	productid
NavigationPropertyName	leadproduct_association
AssociatedMenuConfiguration	Behavior: DoNotDisplay Group: Details Label: Order:

leadcompetitors_association

IntersectEntityName: leadcompetitors

Table 1

Property	Value
IntersectAttribute	leadid
IsCustomizable	False
LogicalName	lead
NavigationPropertyName	leadcompetitors_association
AssociatedMenuConfiguration	Behavior: UseCollectionName Group: Details Label: Order: 40

Table 2

Property	Value
LogicalName	competitor
IntersectAttribute	competitorid
NavigationPropertyName	leadcompetitors_association
AssociatedMenuConfiguration	Behavior: UseCollectionName Group: Sales Label: Order: 40

Related information

Dataverse table/entity reference
Web API Reference