SOR field mapping
The tables below list the fields in SOR that are mapped to the corresponding WorkZone fields. Additionally, you can see the where the fields are shown WorkZone Client.
Contact
| SOR | WorkZone | WorkZone Client | Additional information |
|---|---|---|---|
| SorId |
NameCode |
ID/ID |
|
|
|
NameType |
|
Configured to the contact type H, SOR (SOR-unit) |
|
EntityName |
Name1 |
Navn 1/Name 1 |
The maximum field length is 150 characters in WorkZone. |
| FirstFromDate |
StartDate |
Contact start date |
The contact is valid from this date. |
| UpdatedAt | UpdatedAt | Last updated | The field is used to evaluate if a contact needs to be updated. The WorkZone field will be updated by OData, not by the WorkZone Contact update module. |
| AccessCode | Write acces | Write access is set to the user that runs the SOR integration, by default it is CONTACTSYNCUSER. | |
| ToDate | EndDate | Contact end date |
Address
| SOR addressee | WorkZone | WorkZone Client | Additional information |
|---|---|---|---|
|
PostalAddressStreetName + PostalAddressStreetBuildingId + PostalAddressFloorId + PostalAddressSuiteId + PostalAddressAdditionalAddressInfo |
Address1 |
The maximum field length is 150 characters in WorkZone. |
|
| PostalAddressPostCodeId | Postcode | Postcode | |
| PostalAddressCountryIdCode | Country | Country | |
| VirtualAddressTelephoneNumber | Phone | Phone | |
| VirtualAddressEmailAddress |