Skip to content
English
Customer portal
Go to One Click Contractor
  • There are no suggestions because the search field is empty.

CompanyCam - Data Mapping

Overview of data field mapping between CompanyCam and One Click Contractor

The following is a detailed listing of the data fields and how they map between CompanyCam and One Click.

User Object Linking

User

  • OCC Field: crm_id | SF Field: User.user_id
  • OCC Field: email | SF Field: User.email_address

Job Object

Job

  • OCC Field: customer_name | SF Field: Project.name
  • OCC Field: name | SF Field: Project.name
  • OCC Field: email | SF Field: NOT USED
  • OCC Field: lead_source | SF Field: NOT USED
  • OCC Field: metadata.cc_project_id | SF Field: Project.id
  • OCC Field: metadata.cc_company_id | SF Field: Project.company_id
  • OCC Field: metadata.cc_creator_id | SF Field: Project.creator_id
  • OCC Field: metadata.cc_INTEGRATION_id | SF Field: Integration specific IDs are also stored for JobNimbus and JobProgress

Job Address (address = Project.address)

Job Address

  • OCC Field: line_1 | SF Field: address.street_address_1
  • OCC Field: line_2 | SF Field: address.street_address_2
  • OCC Field: city | SF Field: address.city
  • OCC Field: state | SF Field: address.state
  • OCC Field: postal_code | SF Field: address.postal_code

Job Phone (NOT USED)

Job Appointments (NOT USED)

Notes (NOT USED)