BC Integration: Mapping

Objective

On this page you can check Hubdrive fields synchronize with which BC field and vice-versa.

Mapping Details

Below is a list of the Tables which are covered by the Hubdrive BC Integration. Arrows indicate whether the Data is mapped bidirectionally or unidirectionally between the Databases.


Hubdrive Entities Logical Names Synchronization BC Entities Logical Names
Employee xrm1_employee
<->
 Employee Dyn365bc_employee_hubdrive_bc_v1_0
Skills xrm1_skill
<->
 Skill Code Dyn365bc_skillcode_hubdrive_bc_v1_0
Business Process xrm1_process
<->
 Project Dyn365bc_project_hubdrive_bc_v1_0
Time Sheet xrm1_time_sheet
<->
 TimeSheetHeader Dyn365bc_timesheetheader_hubdrive_bc_v1_0
Time Entry xrm1_time_entry
<->
 TimeSheetLine Dyn365bc_timesheetline_hubdrive_bc_v1_0
Daily Summary xrm1_time_summary_daily
<->
 TimeSheetDetail Dyn365bc_timesheetdetail_hubdrive_bc_v1_0

Fields mapped by Default

Below is an overview of all fields mapped by the BC HR Integration by default.



Hubdrive Business Central

xrm1_employee

dyn365bc_employee_hubdrive_bc_v1_0

Field Display Name
Synchronization
 Field Display Name
xrm1_first_name First Name
<->
 dyn365bc_firstname First name
xrm1_middle_name Middle Name
<->
 dyn365bc_middlename Middle name
xrm1_last_name Last Name
<->
 dyn365bc_lastname Last name
emailaddress Emailaddress
<->
 dyn365bc_companyemail Company Email
xrm1_telephone_work Mobile Phone
<->
 dyn365bc_phoneno Company Phone No
xrm1_iban IBAN
<->
 dyn365bc_iban IBAN
xrm1_bank_account_number Bank Account Number
<->
 dyn365bc_bankaccountno Bank Account No
xrm1_address_work_street Street
<->
 dyn365bc_address Address
xrm1_address_work_city City
<->
 dyn365bc_city City
xrm1_address_work_postal_code ZIP/Postal Code
<->
 dyn365bc_postcode Post Code
xrm1_gender_code Gender
<->
 dyn365bc_gender Gender
xrm1__employee_work_country_area_id Country/Region
<->
 dyn365bc_countryregioncode Country/Region Code
xrm1_start_date Start date
<->
 Employment date Employment date
xrm1_bc_employee BC Employee (LookUp) - Hidden
<-
 dyn365bc_employee_hubdrive_bc_v1_0Id Employee (Guid)
xrm1_bc_resource BC Resource (LookUp) - Hidden
<-
 dyn365bc_resourceno Resource No.
xrm1_bc_employment_contract BC Employment Contract (LookUp) - Hidden
<-
 dyn365bc_emplymtcontractcode Employment Contract Code

xrm1_skill

dyn365bc_skillcode_hubdrive_bc_v1_0

Field Display Name
Synchronization
 Field Display Name
xrm1_name Name
<->
 dyn365bc_code Code
xrm1_description Description
<->
 dyn365bc_description Description
xrm1_bc_skill BC Skill (LookUp) - Hidden
<->
 dyn365bc_skillcode_hubdrive_bc_v1_0Id Skill (Guid)

xrm1_process

dyn365bc_project_hubdrive_bc_v1_0

Field Display Name
Synchronization
 Field Display Name
xrm1_name Name
<->
 dyn365bc_description Description
xrm1_bc_employee_resource BC Employee Resource (LookUp) - Hidden
<-
 dyn365bc_personresponsible Person Responsible (Resource)
xrm1_process_resource.
xrm1_process_employee_id		 Process Assignment - Employee
<->
 dyn365bc_personresponsible Person Responsible
xrm1_bc_skill BC SkillCode
<->
 dyn365bc_skillcode_hubdrive_bc_v1_0Id Skill Code (Guid)

xrm1_time_sheet

dyn365bc_timesheetheader_hubdrive_bc_v1_0

Field Display Name
Synchronization
 Field Display Name
xrm1_time_sheet_employee_id Employee
<->
 dyn365bc_resourceno Resource No.
xrm1_start_date Start Date
<->
 dyn365bc_startingdate Starting Date
xrm1_end_date End Date
<->
 dyn365bc_endingdate Ending Date
xrm1_bc_time_sheet BC TimeSheet - Hidden
<->
 dyn365bc_timesheetheader_hubdrive_bc_v1_0Id Time Sheet Header (Guid)

xrm1_time_entry

dyn365bc_timesheetline_hubdrive_bc_v1_0

Field Display Name
Synchronization
 Field Display Name
xrm1_time_entry_process_id Process
<-
will only work if project exists as process in xrm1
 dyn365bc_jobno Project No.
xrm1_description Description
<->
 dyn365bc_description Description
xrm1_hours_total Total Hours
<->
 dyn365bc_totalquantity Total
statuscode Status Reason
<->
 dyn365bc_status Status
xrm1_bc_time_sheet_line BC TimeSheetLine - Hidden
<->
 dyn365bc_timesheetline_hubdrive_bc_v1_0id Time Sheet Line

xrm1_time_summary_daily

dyn365bc_timesheetdetail_hubdrive_bc_v1_0
Field Display Name
Synchronization
 Field Display Name

xrm1_date_monday
xrm1_date_tuesday
xrm1_date_wednesday
xrm1_date_thursday
xrm1_date_friday
xrm1_date_saturday
xrm1_date_sunday

 Date Monday
Date Tuesday
Date Wednesday
Date Thursday
Date Friday
Date Saturday
Date Sunday
(Time Entry)
<->
Takes the Date from the TimeSheetDetail
and finds the related daily summary
in the attached parent entities (TimeSheet)
 dyn365bc_date Date
xrm1_bc_time_sheet_detail BC TimeSheetDetail
<->
 dyn365bc_timesheetdetail_hubdrive_bc_v1_0id Time Sheet Detail (Guid)
HR