Salesforce Required Objects and Fields

For Salesforce CRM customers, the following standard objects and fields are required in order to build your organization’s data pipeline properly. These are Salesforce API field names and may differ from the field labels displayed in the Salesforce UI.

Some fields depend on org configuration: CurrencyIsoCode requires multi-currency, the State Code and Country Code fields require State and Country/Territory Picklists, and RecordTypeId requires record types. If a feature isn’t enabled in your org, the related field won’t exist and can be disregarded.

* indicates the field is a system field. Systems fields will be received via the API when object level access is granted

Account

• AccountSource
• AnnualRevenue
• BillingCity
• BillingCountry
• BillingCountryCode
• BillingGeocodeAccuracy
• BillingLatitude
• BillingLongitude
• BillingPostalCode
• BillingState
• BillingStateCode
• BillingStreet
• CreatedById*
• CreatedDate*
• CurrencyIsoCode
• Description
• Id*
• Industry
• IsDeleted*
• Jigsaw
• JigsawCompanyId
• LastActivityDate*
• LastModifiedById*
• LastModifiedDate*
• LastReferencedDate*
• LastViewedDate*
• MasterRecordId*
• Name
• NumberOfEmployees
• OwnerId
• ParentId
• Phone
• PhotoUrl
• RecordTypeId
• ShippingCity
• ShippingCountry
• ShippingCountryCode
• ShippingGeocodeAccuracy
• ShippingLatitude
• ShippingLongitude
• ShippingPostalCode
• ShippingState
• ShippingStateCode
• ShippingStreet
• Sic
• SicDesc
• SystemModstamp*
• Type
• Website

Campaign

• ActualCost
• BudgetedCost
• CreatedById*
• CreatedDate*
• CurrencyIsoCode
• EndDate
• Id*
• IsActive
• IsDeleted*
• LastActivityDate*
• LastModifiedDate*
• Name
• OwnerId
• ParentId
• StartDate
• Status
• SystemModstamp*
• Type

Campaign Member

• CampaignId
• CompanyOrAccount
• ContactId
• CreatedById*
• CreatedDate*
• Email
• FirstRespondedDate
• HasResponded
• Id*
• IsDeleted*
• LastModifiedDate*
• LeadId
• LeadOrContactId
• LeadSource
• Status
• SystemModstamp*
• TypeemModstamp
• Type

Contact

• AccountId
• CreatedDate*
• CurrencyIsoCode
• Department
• Email
• FirstName
• Id*
• IsDeleted*
• LastActivityDate*
• LastModifiedDate*
• LastName
• LeadSource
• MailingCity
• MailingCountry
• MailingCountryCode
• MailingGeocodeAccuracy
• MailingLatitude
• MailingLongitude
• MailingPostalCode
• MailingState
• MailingStateCode
• MailingStreet
• MasterRecordId*
• Name
• OwnerId
• Phone
• SystemModstamp*
• Title

Contact History

History objects are read-only and maintained by Salesforce. Access is controlled at the object level through record visibility and field history tracking settings rather than field-level security, so individual fields on these objects cannot be granted separately.

• ContactId
• CreatedById
• CreatedDate
• DataType
• Field
• Id
• IsDeleted
• NewValue
• OldValue

Group

• DeveloperName
• Id*
• LastModifiedDate*
• Name
• SystemModstamp*
• Type

Lead

• City
• Company
• ConvertedAccountId*
• ConvertedContactId*
• ConvertedDate*
• ConvertedOpportunityId*
• Country
• CountryCode
• CreatedById*
• CreatedDate*
• CurrencyIsoCode
• Email
• FirstName
• GeocodeAccuracy
• Id*
• Industry
• IsConverted*
• IsDeleted*
• LastActivityDate*
• LastModifiedDate*
• LastName
• Latitude
• LeadSource
• Longitude
• MasterRecordId*
• Name
• NumberOfEmployees
• OwnerId
• Phone
• PostalCode
• State
• StateCode
• Status
• Street
• SystemModstamp*
• Title
• Website

Lead History

History objects are read-only and maintained by Salesforce. Access is controlled at the object level through record visibility and field history tracking settings rather than field-level security, so individual fields on these objects cannot be granted separately.

• CreatedById
• CreatedDate
• DataType
• Field
• Id
• IsDeleted
• LeadId
• NewValue
• OldValue

Opportunity

• AccountId
• Amount
• CampaignId
• CloseDate
• ContactId
• CreatedById*
• CreatedDate*
• CurrencyIsoCode
• ForecastCategory
• HasOpportunityLineItem
• Id*
• IsClosed
• IsDeleted*
• IsWon
• LastActivityDate*
• LastModifiedDate*
• LeadSource
• Name
• OwnerId
• Probability
• StageName
• SystemModstamp*
• Type

Opportunity Contact Role

• Id*
• ContactId
• CreatedById*
• IsDeleted*
• IsPrimary
• LastModifiedById*
• LastModifiedDate*
• OpportunityId
• Role
• CreatedDate*
• SystemModstamp*

Opportunity Field History

History objects are read-only and maintained by Salesforce. Access is controlled at the object level through record visibility and field history tracking settings rather than field-level security, so individual fields on these objects cannot be granted separately.

• CreatedById
• CreatedDate
• DataType
• Field
• Id
• IsDeleted
• NewValue
• OldValue
• OpportunityId

Opportunity History

History objects are read-only and maintained by Salesforce. Access is controlled at the object level through record visibility and field history tracking settings rather than field-level security, so individual fields on these objects cannot be granted separately.

• Amount
• CloseDate
• CreatedById
• CreatedDate
• CurrencyIsoCode
• ExpectedRevenue
• ForecastCategory
• Id
• IsDeleted
• OpportunityId
• PrevAmount
• PrevCloseDate
• Probability
• StageName
• SystemModstamp

OpportunityLineItem

• CreatedById*
• CreatedDate*
• CurrencyIsoCode
• Id*
• IsDeleted*
• LastModifiedDate*
• Name
• OpportunityId
• Product2Id
• ProductCode
• Quantity
• SystemModstamp*
• TotalPrice
• UnitPrice

Product2

• Id*
• Family
• Name
• LastModifiedDate*
• SystemModstamp*

Profile

• Id*
• Name
• LastModifiedDate*
• SystemModstamp*

Record Type

• DeveloperName
• Id*
• IsActive
• LastModifiedDate*
• Name
• SobjectType
• SystemModstamp*

Task

• AccountId
• ActivityDate
• CallDisposition
• CompletedDateTime
• CreatedById*
• CreatedDate*
• Description
• Id*
• IsArchived
• IsClosed
• IsDeleted*
• LastModifiedDate*
• OwnerId
• RecordTypeId
• Status
• Subject
• SystemModstamp*
• TaskSubtype
• Type
• WhatId
• WhoId

User

• Department
• Email
• Id*
• IsActive
• LastModifiedDate*
• Name
• ProfileId
• SystemModstamp*
• Title
• UserRoleId

User Role

• Id*
• LastModifiedDate*
• Name
• SystemModstamp*