Prospect
Schema file for Prospect.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Unique identifier for the record. | |
| CreatedById | String | True |
User.Id |
ID of the user who created the record. |
| CreatedDate | Datetime | True |
Date and time when the record was created. | |
| LastModifiedById | String | True |
User.Id |
ID of the user who last modified the record. |
| Title | String | False |
Title of the contact or person, for example CEO or Vice President. | |
| Description | String | False |
Text description of the record. | |
| GenderIdentity | String | False |
Field containing GenderIdentity information. | |
| Street | String | False |
Street address. | |
| City | String | False |
City portion of the address. | |
| State | String | False |
State or province portion of the address. | |
| PostalCode | String | False |
Postal code portion of the address. | |
| Country | String | False |
Country portion of the address. | |
| Latitude | Double | False |
Used with Longitude to specify the precise geolocation of an address. | |
| Longitude | Double | False |
Used with Latitude to specify the precise geolocation of an address. | |
| GeocodeAccuracy | String | False |
Accuracy level of the geocode for the address. | |
| Phone | String | False |
Phone number for the contact or account. | |
| String | False |
Email address for the contact or person account. | ||
| LeadSource | String | False |
Source from which the lead was obtained. | |
| Industry | String | False |
Industry that the account belongs to. | |
| Company | String | False |
Field containing Company information. | |
| AnnualRevenue | Decimal | False |
Estimated annual revenue of the account. | |
| CurrencyIsoCode | String | False |
ISO code for the currency in which the revenue amount is expressed. | |
| NumberOfEmployees | Int | False |
Number of employees working at the company represented by this account. | |
| ProspectStatus | String | False |
Status of the Prospect. | |
| LastName | String | False |
Last name of the contact or person account. Required for person accounts. | |
| FirstName | String | False |
First name of the contact or person account. | |
| Salutation | String | False |
Honorific abbreviation, word, or phrase to be used in front of the name in greetings. | |
| Name | String | True |
Name of the record. | |
| IsDeleted | Bool | True |
Indicates whether the record has been moved to the Recycle Bin. | |
| ProspectRecordName | String | True |
Field containing ProspectRecordName information. | |
| IsConverted | Bool | False |
Indicates whether the lead has been converted. | |
| ConvertedDate | Date | True |
Date associated with Converted. | |
| ConvertedLeadId | String | True |
Lead.Id |
ID of the ConvertedLead associated with this record. |
| ConvertedAccountId | String | True |
Account.Id |
ID of the ConvertedAccount associated with this record. |
| ConvertedContactId | String | True |
Contact.Id |
ID of the ConvertedContact associated with this record. |
| ConvertedOpportunityId | String | True |
Opportunity.Id |
ID of the ConvertedOpportunity 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. |