# Lead: Lead - Name: `Lead` - Catalog: `Salesforce` - Schema: `Salesforce` - Primary Keys: `id` - Label: Lead ## Table Columns The columns of the table `Lead` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AnnualRevenue` | `decimal` | Annual Revenue | ☐ | | | `City` | `string` | City | ☐ | | | `CleanStatus` | `string` | Clean Status | ☐ | | | `Company` | `string` | Company | ☐ | | | `CompanyDunsNumber` | `string` | Company DUNS Number | ☐ | | | `ConvertedAccountId` | `string` | Converted Account ID | ☐ | | | `ConvertedContactId` | `string` | Converted Contact ID | ☐ | | | `ConvertedDate` | `datetime` | Converted Date | ☐ | | | `ConvertedOpportunityId` | `string` | Converted Opportunity ID | ☐ | | | `Country` | `string` | Country | ☐ | | | `CreatedById` | `string` | Created by ID | ☐ | | | `CreatedDate` | `datetime` | Date Created | ☐ | | | `CurrentGenerators__c` | `string` | Current Generators | ☐ | | | `DandbCompanyId` | `string` | D&B Company ID | ☐ | | | `Description` | `string` | Description | ☐ | | | `Email` | `string` | Email | ☐ | | | `EmailBouncedDate` | `datetime` | Email Bounced Date | ☐ | | | `EmailBouncedReason` | `string` | Email Bounced Reason | ☐ | | | `Fax` | `string` | Fax | ☐ | | | `FirstName` | `string` | First Name | ☐ | | | `GeocodeAccuracy` | `string` | Geocode Accuracy | ☐ | | | `Id` | `string` | ID | ☐ | | | `Industry` | `string` | Industry | ☐ | | | `IsConverted` | `boolean` | Is Converted | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `IsUnreadByOwner` | `boolean` | Is Unread by Owner | ☐ | | | `Jigsaw` | `string` | Jigsaw | ☐ | | | `JigsawContactId` | `string` | Jigsaw Contact ID | ☐ | | | `LastActivityDate` | `datetime` | Date Last Activity | ☐ | | | `LastModifiedById` | `string` | Last Modified by ID | ☐ | | | `LastModifiedDate` | `datetime` | Date Last Modified | ☐ | | | `LastName` | `string` | Last Name | ☐ | | | `LastReferencedDate` | `datetime` | Last Referenced Date | ☐ | | | `LastViewedDate` | `datetime` | Last Viewed Date | ☐ | | | `Latitude` | `double` | Latitude | ☐ | | | `LeadSource` | `string` | Lead Source | ☐ | | | `Longitude` | `double` | Longitude | ☐ | | | `MasterRecordId` | `string` | Master Record ID | ☐ | | | `MobilePhone` | `string` | Mobile Phone | ☐ | | | `Name` | `string` | Name | ☐ | | | `NumberOfEmployees` | `int32` | Number of Employees | ☐ | | | `NumberofLocations__c` | `double` | Number of Locations | ☐ | | | `OwnerId` | `string` | Owner ID | ☐ | | | `Phone` | `string` | Phone | ☐ | | | `PhotoUrl` | `string` | Photo (URL) | ☐ | | | `PostalCode` | `string` | Postal Code | ☐ | | | `Primary__c` | `string` | Primary | ☐ | | | `ProductInterest__c` | `string` | Product Interest | ☐ | | | `Rating` | `string` | Rating | ☐ | | | `Salutation` | `string` | Salutation | ☐ | | | `SICCode__c` | `string` | SIC Code | ☐ | | | `State` | `string` | State | ☐ | | | `Status` | `string` | Status | ☐ | | | `Street` | `string` | Street | ☐ | | | `SystemModstamp` | `datetime` | System Modstamp | ☐ | | | `Title` | `string` | Title | ☐ | | | `Website` | `string` | Website | ☐ | |