Excel Add-In for Salesforce

Build 25.0.9434

LeadCleanInfo

Schema file for LeadCleanInfo.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier for the record.

IsDeleted Bool True

Indicates whether the record has been moved to the Recycle Bin.

Name String False

Name of the record.

CurrencyIsoCode String False

ISO code for the currency in which the revenue amount is expressed.

CreatedDate Datetime True

Date and time when the record was created.

CreatedById String True

User.Id

ID of the user who created the record.

LastModifiedById String True

User.Id

ID of the user who last modified the record.

LeadId String True

Lead.Id

ID of the Lead associated with this record.

LastMatchedDate Datetime True

Date associated with LastMatched.

LastStatusChangedDate Datetime True

Date associated with LastStatusChanged.

LastStatusChangedById String True

User.Id

ID of the LastStatusChangedBy associated with this record.

IsInactive Bool False

Indicates whether the record has the Inactive characteristic.

FirstName String True

First name of the contact or person account.

LastName String True

Last name of the contact or person account. Required for person accounts.

Email String True

Email address for the contact or person account.

Phone String True

Phone number for the contact or account.

Street String True

Street address.

City String True

City portion of the address.

State String True

State or province portion of the address.

PostalCode String True

Postal code portion of the address.

Country String True

Country portion of the address.

Latitude Double True

Used with Longitude to specify the precise geolocation of an address.

Longitude Double True

Used with Latitude to specify the precise geolocation of an address.

GeocodeAccuracy String True

Accuracy level of the geocode for the address.

Title String True

Title of the contact or person, for example CEO or Vice President.

AnnualRevenue Decimal True

Estimated annual revenue of the account.

NumberOfEmployees Int True

Number of employees working at the company represented by this account.

Industry String True

Industry that the account belongs to.

CompanyName String True

Field containing CompanyName information.

CompanyDunsNumber String True

The D-U-N-S number for the company.

ContactStatusDataDotCom String True

Field containing ContactStatusDataDotCom information.

IsReviewedName Bool False

Indicates whether the record has the ReviewedName characteristic.

IsReviewedEmail Bool False

Indicates whether the record has the ReviewedEmail characteristic.

IsReviewedPhone Bool False

Indicates whether the record has the ReviewedPhone characteristic.

IsReviewedAddress Bool False

Indicates whether the record has the ReviewedAddress characteristic.

IsReviewedTitle Bool False

Indicates whether the record has the ReviewedTitle characteristic.

IsReviewedAnnualRevenue Bool False

Indicates whether the record has the ReviewedAnnualRevenue characteristic.

IsReviewedNumberOfEmployees Bool False

Indicates whether the record has the ReviewedNumberOfEmployees characteristic.

IsReviewedIndustry Bool False

Indicates whether the record has the ReviewedIndustry characteristic.

IsReviewedCompanyName Bool False

Indicates whether the record has the ReviewedCompanyName characteristic.

IsReviewedCompanyDunsNumber Bool False

Indicates whether the record has the ReviewedCompanyDunsNumber characteristic.

IsReviewedDandBCompanyDunsNumber Bool False

Indicates whether the record has the ReviewedDandBCompanyDunsNumber characteristic.

IsDifferentFirstName Bool True

Indicates whether the record has the DifferentFirstName characteristic.

IsDifferentLastName Bool True

Indicates whether the record has the DifferentLastName characteristic.

IsDifferentEmail Bool True

Indicates whether the record has the DifferentEmail characteristic.

IsDifferentPhone Bool True

Indicates whether the record has the DifferentPhone characteristic.

IsDifferentStreet Bool True

Indicates whether the record has the DifferentStreet characteristic.

IsDifferentCity Bool True

Indicates whether the record has the DifferentCity characteristic.

IsDifferentState Bool True

Indicates whether the record has the DifferentState characteristic.

IsDifferentPostalCode Bool True

Indicates whether the record has the DifferentPostalCode characteristic.

IsDifferentCountry Bool True

Indicates whether the record has the DifferentCountry characteristic.

IsDifferentTitle Bool True

Indicates whether the record has the DifferentTitle characteristic.

IsDifferentAnnualRevenue Bool True

Indicates whether the record has the DifferentAnnualRevenue characteristic.

IsDifferentNumberOfEmployees Bool True

Indicates whether the record has the DifferentNumberOfEmployees characteristic.

IsDifferentIndustry Bool True

Indicates whether the record has the DifferentIndustry characteristic.

IsDifferentCompanyName Bool True

Indicates whether the record has the DifferentCompanyName characteristic.

IsDifferentCompanyDunsNumber Bool True

Indicates whether the record has the DifferentCompanyDunsNumber characteristic.

IsDifferentDandBCompanyDunsNumber Bool True

Indicates whether the record has the DifferentDandBCompanyDunsNumber characteristic.

IsDifferentStateCode Bool True

Indicates whether the record has the DifferentStateCode characteristic.

IsDifferentCountryCode Bool True

Indicates whether the record has the DifferentCountryCode characteristic.

CleanedByJob Bool True

Field containing CleanedByJob information.

CleanedByUser Bool True

Field containing CleanedByUser information.

DandBCompanyDunsNumber String True

DandBCompanyDuns identification number.

DataDotComCompanyId String True

ID of the DataDotComCompany associated with this record.

IsFlaggedWrongName Bool False

Indicates whether the record has the FlaggedWrongName characteristic.

IsFlaggedWrongEmail Bool False

Indicates whether the record has the FlaggedWrongEmail characteristic.

IsFlaggedWrongPhone Bool False

Indicates whether the record has the FlaggedWrongPhone characteristic.

IsFlaggedWrongAddress Bool False

Indicates whether the record has the FlaggedWrongAddress characteristic.

IsFlaggedWrongTitle Bool False

Indicates whether the record has the FlaggedWrongTitle characteristic.

IsFlaggedWrongAnnualRevenue Bool False

Indicates whether the record has the FlaggedWrongAnnualRevenue characteristic.

IsFlaggedWrongNumberOfEmployees Bool False

Indicates whether the record has the FlaggedWrongNumberOfEmployees characteristic.

IsFlaggedWrongIndustry Bool False

Indicates whether the record has the FlaggedWrongIndustry characteristic.

IsFlaggedWrongCompanyName Bool False

Indicates whether the record has the FlaggedWrongCompanyName characteristic.

IsFlaggedWrongCompanyDunsNumber Bool False

Indicates whether the record has the FlaggedWrongCompanyDunsNumber characteristic.

DataDotComId String True

ID of the DataDotCom associated with this record.

SOQL String False

Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query.

ExternalIdColumn String False

Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called.

FilterScope String False

Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team.

SystemModstamp Datetime True

Date and time when the record was last modified by a user or by an automated process.

LastModifiedDate Datetime True

Date and time when the record was last modified.

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