Power BI Connector for Microsoft Dynamics CRM

Build 25.0.9454

Lead

This is a table representing the Lead entities in Dynamics CRM.

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier of the lead.

AccountId_Id String True

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

AccountId_LogicalName String True

AccountId_Name String True

Address1_AddressId String False

Unique identifier for address 1.

Address1_AddressTypeCode String False

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

Address1_City String False

City name for address 1.

Address1_Country String False

Country/region name for address 1.

Address1_County String False

County name for address 1.

Address1_Fax String False

Fax number for address 1.

Address1_Latitude Double False

Latitude for address 1.

Address1_Line1 String False

First line for entering address 1 information.

Address1_Line2 String False

Second line for entering address 1 information.

Address1_Line3 String False

Third line for entering address 1 information.

Address1_Longitude Double False

Longitude for address 1.

Address1_Name String False

Name to enter for address 1.

Address1_PostalCode String False

ZIP Code or postal code for address 1.

Address1_PostOfficeBox String False

Post office box number for address 1.

Address1_ShippingMethodCode String False

Method of shipment for address 1.

Address1_StateOrProvince String False

State or province for address 1.

Address1_Telephone1 String False

First telephone number associated with address 1.

Address1_Telephone2 String False

Second telephone number associated with address 1.

Address1_Telephone3 String False

Third telephone number associated with address 1.

Address1_UPSZone String False

United Parcel Service (UPS) zone for address 1.

Address1_UTCOffset Integer False

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

Address2_AddressId String False

Unique identifier for address 2.

Address2_AddressTypeCode String False

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

Address2_City String False

City name for address 2.

Address2_Country String False

Country/region name for address 2.

Address2_County String False

County name for address 2.

Address2_Fax String False

Fax number for address 2.

Address2_Latitude Double False

Latitude for address 2.

Address2_Line1 String False

First line for entering address 2 information.

Address2_Line2 String False

Second line for entering address 2 information.

Address2_Line3 String False

Third line for entering address 2 information.

Address2_Longitude Double False

Longitude for address 2.

Address2_Name String False

Name to enter for address 2.

Address2_PostalCode String False

ZIP Code or postal code for address 2.

Address2_PostOfficeBox String False

Post office box number for address 2.

Address2_ShippingMethodCode String False

Method of shipment for address 2.

Address2_StateOrProvince String False

State or province for address 2.

Address2_Telephone1 String False

First telephone number associated with address 2.

Address2_Telephone2 String False

Second telephone number associated with address 2.

Address2_Telephone3 String False

Third telephone number associated with address 2.

Address2_UPSZone String False

United Parcel Service (UPS) zone for address 2.

Address2_UTCOffset Integer False

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

CampaignId_Id String False

Unique identifier of the source campaign associated with the lead.

CampaignId_LogicalName String False

CampaignId_Name String False

CompanyName String False

Name of the company with which the lead is associated.

ContactId_Id String True

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

ContactId_LogicalName String True

ContactId_Name String True

CreatedBy_Id String True

Unique identifier of the user who created the lead.

CreatedBy_LogicalName String True

CreatedBy_Name String True

CreatedOn Datetime True

Date and time when the lead was created.

CreatedOnBehalfBy_Id String True

Unique identifier of the delegate user who created the lead.

CreatedOnBehalfBy_LogicalName String True

CreatedOnBehalfBy_Name String True

CustomerId_Id String False

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

CustomerId_LogicalName String False

CustomerId_Name String False

Description String False

Description of the lead.

DoNotBulkEMail Boolean False

Information about whether to allow sending direct email to the lead.

DoNotEMail Boolean False

Information about whether to allow sending email to the lead.

DoNotFax Boolean False

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

DoNotPhone Boolean False

Information about whether to allow phone calls to the lead.

DoNotPostalMail Boolean False

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

DoNotSendMM Boolean False

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

EMailAddress1 String False

First email address for the lead.

EMailAddress2 String False

Second email address for the lead.

EMailAddress3 String False

Third email address for the lead.

EstimatedAmount Double False

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

EstimatedAmount_Base Double True

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

EstimatedCloseDate Datetime False

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

EstimatedValue Double False

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

ExchangeRate Double True

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

Fax String False

Fax number for the lead.

FirstName String False

First name for the lead.

FullName String True

Full name for the lead.

ImportSequenceNumber Integer False

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

IndustryCode String False

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

JobTitle String False

Job title of the lead.

LastName String False

Last name for the lead.

LastUsedInCampaign Datetime False

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

LeadId String False

Unique identifier of the lead.

LeadQualityCode String False

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

LeadSourceCode String False

Source of the lead.

MasterId_Id String True

Unique identifier of the master lead for merge.

MasterId_LogicalName String True

MasterId_Name String True

Merged Boolean True

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

MiddleName String False

Middle name for the lead.

MobilePhone String False

Mobile phone number for the lead.

ModifiedBy_Id String True

Unique identifier of the user who last modified the lead.

ModifiedBy_LogicalName String True

ModifiedBy_Name String True

ModifiedOn Datetime True

Date and time when the lead was last modified.

ModifiedOnBehalfBy_Id String True

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

ModifiedOnBehalfBy_LogicalName String True

ModifiedOnBehalfBy_Name String True

NumberOfEmployees Integer False

Number of employees at the lead's company.

OverriddenCreatedOn Datetime False

Date and time that the record was migrated.

OwnerId_Id String False

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

OwnerId_LogicalName String False

OwnerId_Name String False

OwningBusinessUnit_Id String True

Unique identifier of the business unit that owns the lead.

OwningBusinessUnit_LogicalName String True

OwningBusinessUnit_Name String True

OwningTeam_Id String True

Unique identifier of the team who owns the lead.

OwningTeam_LogicalName String True

OwningTeam_Name String True

OwningUser_Id String True

Unique identifier of the user who owns the lead.

OwningUser_LogicalName String True

OwningUser_Name String True

Pager String False

Pager number for the lead.

ParticipatesInWorkflow Boolean False

Information about whether the lead participates in workflow rules.

PreferredContactMethodCode String False

Preferred contact method for the lead.

PriorityCode String False

Priority of the lead.

Revenue Double False

Revenue amount for the lead.

Revenue_Base Double True

Base currency equivalent of the revenue amount for the lead.

SalesStageCode String False

Current stage of the sales process for the lead.

Salutation String False

Salutation for correspondence with the lead.

SIC String False

Standard Industrial Classification (SIC) code for the lead.

StateCode String True

Status of the lead.

StatusCode String False

Reason for the status of the lead.

Subject String False

Subject associated with the lead.

Telephone1 String False

First telephone number for the lead.

Telephone2 String False

Second telephone number for the lead.

Telephone3 String False

Third telephone number for the lead.

TimeZoneRuleVersionNumber Integer False

For internal use only.

TransactionCurrencyId_Id String False

Unique identifier of the currency associated with the lead.

TransactionCurrencyId_LogicalName String False

TransactionCurrencyId_Name String False

UTCConversionTimeZoneCode Integer False

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

WebSiteUrl String False

Web site URL for the lead.

YomiCompanyName String False

Name of the company with which the lead is associated.

YomiFirstName String False

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

YomiFullName String True

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

YomiLastName String False

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

YomiMiddleName String False

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

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454