For Salesforce CRM customers, the following standard objects and fields are required in order to build your organization’s data pipeline properly:
Account
- account_source
- annual_revenue
- billing_city
- billing_country
- billing_country_code
- billing_geocode_accuracy
- billing_latitude
- billing_longitude
- billing_postal_code
- billing_state
- billing_state_code
- billing_street
- created_by_id
- created_date
- currency_iso_code
- description
- id
- industry
- is_deleted
- jigsaw
- jigsaw_company_id
- last_activity_date
- last_modified_by_id
- last_modified_date
- last_referenced_date
- last_viewed_date
- master_record_id
- name
- number_of_employees
- owner_id
- parent_id
- phone
- photo_url
- record_type_id
- shipping_city
- shipping_country
- shipping_country_code
- shipping_geocode_accuracy
- shipping_latitude
- shipping_longitude
- shipping_postal_code
- shipping_state
- shipping_state_code
- shipping_street
- sic
- sic_desc
- system_modstamp
- type
- website
Campaign
- actual_cost
- budgeted_cost
- created_by_id
- created_date
- currency_iso_code
- end_date
- id
- is_active
- is_deleted
- last_activity_date
- last_modified_date
- name
- owner_id
- parent_id
- start_date
- status
- system_modstamp
- type
Campaign Member
- campaign_id
- company_or_account
- contact_id
- created_by_id
- created_date
- first_responded_date
- has_responded
- id
- is_deleted
- last_modified_date
- lead_id
- lead_or_contact_id
- lead_source
- status
- system_modstamp
- type
Contact
- account_id
- created_date
- currency_iso_code
- department
- first_name
- id
- is_deleted
- last_activity_date
- last_modified_date
- last_name
- lead_source
- mailing_city
- mailing_country
- mailing_country_code
- mailing_geocode_accuracy
- mailing_latitude
- mailing_longitude
- mailing_postal_code
- mailing_state
- mailing_state_code
- mailing_street
- master_record_id
- name
- owner_id
- phone
- system_modstamp
- title
Contact History (for Funnels product)
- contact_id
- created_by_id
- created_date
- data_type
- field
- id
- is_deleted
- new_value
- old_value
Group
- developer_name
- id
- last_modified_date
- name
- system_modstamp
- type
Lead
- city
- company
- converted_account_id
- converted_contact_id
- converted_date
- converted_opportunity_id
- country
- country_code
- created_by_id
- created_date
- currency_iso_code
- first_name
- geocode_accuracy
- id
- industry
- is_converted
- is_deleted
- last_activity_date
- last_modified_date
- last_name
- latitude
- lead_source
- longitude
- master_record_id
- name
- number_of_employees
- owner_id
- phone
- postal_code
- state
- state_code
- status
- street
- system_modstamp
- title
- website
Lead History
- created_by_id
- created_date
- data_type
- field
- id
- is_deleted
- lead_id
- new_value
- old_value
Opportunity
- account_id
- amount
- campaign_id
- close_date
- contact_id
- created_by_id
- created_date
- currency_iso_code
- forecast_category
- has_opportunity_line_item
- id
- is_closed
- is_deleted
- is_won
- last_activity_date
- last_modified_date
- lead_source
- name
- owner_id
- probability
- stage_name
- system_modstamp
- type
Opportunity Contact Role
- id
- contact_id
- created_by_id
- is_deleted
- is_primary
- last_modified_by_id
- last_modified_date
- opportunity_id
- role
- created_date
- system_modstamp
Opportunity Field History (for Funnels product)
- created_by_id
- created_date
- data_type
- field
- id
- is_deleted
- new_value
- old_value
- opportunity_id
Opportunity History
- amount
- close_date
- created_by_id
- created_date
- currency_iso_code
- expected_revenue
- forecast_category
- id
- is_deleted
- opportunity_id
- prev_amount
- prev_close_date
- probability
- stage_name
- system_modstamp
Opportunity Line Item
- created_by_id
- created_date
- currency_iso_code
- id
- is_deleted
- last_modified_date
- name
- opportunity_id
- product_2_id
- product_code
- quantity
- system_modstamp
- total_price
- unit_price
Product
- id
- family
- name
- last_modified_date
- system_modstamp
Profile
- id
- name
- last_modified_date
- system_modstamp
Record Type
- developer_name
- id
- is_active
- last_modified_date
- name
- sobject_type
- system_modstamp
Task
- account_id
- activity_date
- call_disposition
- completed_date_time
- created_by_id
- created_date
- description
- id
- is_archived
- is_closed
- is_deleted
- last_modified_date
- owner_id
- record_type_id
- status
- subject
- system_modstamp
- task_subtype
- type
- what_id
- who_id
User
- department
- id
- is_active
- last_modified_date
- name
- profile_id
- system_modstamp
- title
- user_role_id
User Role
- id
- last_modified_date
- name
- system_modstamp