BC Integration: Mapping
Auf den Punkt
Auf dieser Seite können Sie überprüfen, welche Hubdrive-Felder mit welchem BC-Feld synchronisiert werden und umgekehrt.
Click Through
Im Folgenden finden Sie eine Liste der Tabellen, die von der Hubdrive BC Integration abgedeckt werden. Die Pfeile zeigen an, ob die Daten bidirektional oder unidirektional zwischen den Datenbanken abgebildet werden.
Hubdrive Tabellen | Logische Namen | Synchronisierung | BC Tabellen | Logische Namen |
---|---|---|---|---|
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
Im Folgenden finden Sie eine Übersicht über alle Felder, die von der BC Integration im Standard synchronisiert werden.
Hubdrive | Business Central | |||
---|---|---|---|---|
xrm1_employee |
dyn365bc_employee_hubdrive_bc_v1_0 | |||
Field | Display Name |
|
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 |
|
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) |
|
| |||
Field | Display Name |
|
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) |
|
| |||
Field | Display Name |
|
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) |
|
| |||
Field | Display Name |
|
Field | Display Name |
xrm1_time_entry_process_id | Process |
|
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 |
|
|
|||
Field | Display Name |
|
Field | Display Name |
xrm1_date_monday |
Date Monday Date Tuesday Date Wednesday Date Thursday Date Friday Date Saturday Date Sunday (Time Entry) |
Nimmt die Daten aus TimeSheetDetail und findet die zugehörige tägliche Übersicht in den verknüpften Tabellen (TimeSheet) |
dyn365bc_date | Date |
xrm1_bc_time_sheet_detail | BC TimeSheetDetail |
|
dyn365bc_timesheetdetail_hubdrive_bc_v1_0id | Time Sheet Detail (Guid) |