Hi All
I am newbie for CRM and works with CRM database first time.
I am looking for datasources for following entities (user, department and location) columns and can relate each other with column key like departmentcode & locationcode.
I have done some intitiatives to find/map them thru dependancy and reference column keys (primary & foreign) using SQL queries. But it is quite diffucult to find/map the columns due to CRM structure.
| User Columns |
| employeeID |
| AccountName |
| firstName |
| lastName |
| managerEmployeeID |
| managerSamAccountName |
| positionTitle |
| positionID |
| departmentCode |
| locationCode |
| phoneMobile |
| costCentre |
| userType |
| startDate |
| endDate |
| status |
| Department Columns |
| departmentCode |
| departmentName |
| parentCode |
| status |
| effectiveDate |
| departmentLevel |
| Location Columns |
| locationCode |
| locationlocation |
| streetAddress |
| suburb |
| city |
| country |
| postCode |
Is some one can help/guide with to locate above datasources in CRM database. CRM version is 2016.
Thanks in Advance
