# LeadCleanInfo: Lead Clean Info - Name: `LeadCleanInfo` - Catalog: `Salesforce` - Schema: `Salesforce` - Primary Keys: `id` - Label: Lead Clean Info ## Table Columns The columns of the table `LeadCleanInfo` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AnnualRevenue` | `decimal` | Annual Revenue | ☐ | | | `City` | `string` | City | ☐ | | | `CleanedByJob` | `boolean` | Cleaned by Job | ☐ | | | `CleanedByUser` | `boolean` | Cleaned by User | ☐ | | | `CompanyDunsNumber` | `string` | Company DUNS Number | ☐ | | | `CompanyName` | `string` | Company Name | ☐ | | | `ContactStatusDataDotCom` | `string` | Contact Status Data.com | ☐ | | | `Country` | `string` | Country | ☐ | | | `CreatedById` | `string` | Created by ID | ☐ | | | `CreatedDate` | `datetime` | Date Created | ☐ | | | `DandBCompanyDunsNumber` | `string` | D&B Company DUNS Number | ☐ | | | `DataDotComCompanyId` | `string` | Data.com Company ID | ☐ | | | `DataDotComId` | `string` | Data.com ID | ☐ | | | `Email` | `string` | Email | ☐ | | | `FirstName` | `string` | First Name | ☐ | | | `GeocodeAccuracy` | `string` | Geocode Accuracy | ☐ | | | `Id` | `string` | ID | ☐ | | | `Industry` | `string` | Industry | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `IsDifferentAnnualRevenue` | `boolean` | Is Different Annual Revenue | ☐ | | | `IsDifferentCity` | `boolean` | Is Different City | ☐ | | | `IsDifferentCompanyDunsNumber` | `boolean` | Is Different Company DUNS Number | ☐ | | | `IsDifferentCompanyName` | `boolean` | Is Different Company Name | ☐ | | | `IsDifferentCountry` | `boolean` | Is Different Country | ☐ | | | `IsDifferentCountryCode` | `boolean` | Is Different Country Code | ☐ | | | `IsDifferentDandBCompanyDunsNumber` | `boolean` | Is Different D&B Company DUNS Number | ☐ | | | `IsDifferentEmail` | `boolean` | Is Different Email | ☐ | | | `IsDifferentFirstName` | `boolean` | Is Different First Name | ☐ | | | `IsDifferentIndustry` | `boolean` | Is Different Industry | ☐ | | | `IsDifferentLastName` | `boolean` | Is Different Last Name | ☐ | | | `IsDifferentNumberOfEmployees` | `boolean` | Is Different Number of Employees | ☐ | | | `IsDifferentPhone` | `boolean` | Is Different Phone | ☐ | | | `IsDifferentPostalCode` | `boolean` | Is Different Postal Code | ☐ | | | `IsDifferentState` | `boolean` | Is Different State | ☐ | | | `IsDifferentStateCode` | `boolean` | Is Different State Code | ☐ | | | `IsDifferentStreet` | `boolean` | Is Different Street | ☐ | | | `IsDifferentTitle` | `boolean` | Is Different Title | ☐ | | | `IsFlaggedWrongAddress` | `boolean` | Is Flagged Wrong Address | ☐ | | | `IsFlaggedWrongAnnualRevenue` | `boolean` | Is Flagged Wrong Annual Revenue | ☐ | | | `IsFlaggedWrongCompanyDunsNumber` | `boolean` | Is Flagged Wrong Company DUNS Number | ☐ | | | `IsFlaggedWrongCompanyName` | `boolean` | Is Flagged Wrong Company Name | ☐ | | | `IsFlaggedWrongEmail` | `boolean` | Is Flagged Wrong Email | ☐ | | | `IsFlaggedWrongIndustry` | `boolean` | Is Flagged Wrong Industry | ☐ | | | `IsFlaggedWrongName` | `boolean` | Is Flagged Wrong Name | ☐ | | | `IsFlaggedWrongNumberOfEmployees` | `boolean` | Is Flagged Wrong Number of Employees | ☐ | | | `IsFlaggedWrongPhone` | `boolean` | Is Flagged Wrong Phone | ☐ | | | `IsFlaggedWrongTitle` | `boolean` | Is Flagged Wrong Title | ☐ | | | `IsInactive` | `boolean` | Is Inactive | ☐ | | | `IsReviewedAddress` | `boolean` | Is Reviewed Address | ☐ | | | `IsReviewedAnnualRevenue` | `boolean` | Is Reviewed Annual Revenue | ☐ | | | `IsReviewedCompanyDunsNumber` | `boolean` | Is Reviewed Company DUNS Number | ☐ | | | `IsReviewedCompanyName` | `boolean` | Is Reviewed Company Name | ☐ | | | `IsReviewedDandBCompanyDunsNumber` | `boolean` | Is Reviewed D&B Company DUNS Number | ☐ | | | `IsReviewedEmail` | `boolean` | Is Reviewed Email | ☐ | | | `IsReviewedIndustry` | `boolean` | Is Reviewed Industry | ☐ | | | `IsReviewedName` | `boolean` | Is Reviewed Name | ☐ | | | `IsReviewedNumberOfEmployees` | `boolean` | Is Reviewed Number of Employees | ☐ | | | `IsReviewedPhone` | `boolean` | Is Reviewed Phone | ☐ | | | `IsReviewedTitle` | `boolean` | Is Reviewed Title | ☐ | | | `LastMatchedDate` | `datetime` | Last Matched Date | ☐ | | | `LastModifiedById` | `string` | Last Modified by ID | ☐ | | | `LastModifiedDate` | `datetime` | Date Last Modified | ☐ | | | `LastName` | `string` | Last Name | ☐ | | | `LastStatusChangedById` | `string` | Last Status Changed by ID | ☐ | | | `LastStatusChangedDate` | `datetime` | Last Status Changed Date | ☐ | | | `Latitude` | `double` | Latitude | ☐ | | | `LeadId` | `string` | Lead ID | ☐ | | | `Longitude` | `double` | Longitude | ☐ | | | `Name` | `string` | Name | ☐ | | | `NumberOfEmployees` | `int32` | Number of Employees | ☐ | | | `Phone` | `string` | Phone | ☐ | | | `PostalCode` | `string` | Postal Code | ☐ | | | `State` | `string` | State | ☐ | | | `Street` | `string` | Street | ☐ | | | `SystemModstamp` | `datetime` | System Modstamp | ☐ | | | `Title` | `string` | Title | ☐ | |