Appointment data mappings
The mappings in the table below are used to synchronize appointment data between Outlook and Sage CRM in Classic Outlook Integration.
|
Outlook |
Sage CRM (Translation) |
Sage CRM (Column) |
|---|---|---|
|
Start Time |
Date/Time |
comm_datetime |
|
End Time |
End Time |
comm_todatetime |
|
Subject |
Subject |
comm_subject |
|
Location |
Location |
comm_location |
|
Body |
Details |
comm_note |
|
Status |
Status |
comm_status |
|
Importance |
Priority |
comm_priority |
|
Organizer |
Organizer |
comm_organizer or user_emailaddress |
|
Company |
Company |
comp_name |
|
Person |
Person |
pers_firstname+pers_lastname (and other columns) |
|
All Day Event |
All Day Event in Outlook becomes an All Day Event in Sage CRM (midnight to 23:59). |
|
|
Reminder |
Reminder |
comm_notifydelta |
|
Attendee |
User |
user_emailaddress |
|
% Complete |
Percent Complete |
comm_percentcomplet |
