Infor CRM Mappings
Overview
The following fields, grouped by their tables in Sugar Market, are pulled down from Infor CRM into Sugar Market.
Accounts
|
Infor Field |
Sugar Market Field |
|
-- |
AccountID (primary key) |
|
Infor's Account ID (primary key) |
ID |
|
AccountName |
AccountName |
|
AccountManager (foreign key) |
OwnerID (foreign key) |
|
Address1 |
BillingStreet / ShippingStreet |
|
City |
BillingCity / ShippingCity |
|
Country |
BillingCountry / ShippingCountry |
|
PostalCode |
BillingZip / ShippingZip |
|
State |
BillingState / ShippingState |
Contacts and Leads
Sugar Market does not have a Leads table, but they are differentiated in the Contacts table by the CRMType field.
|
Infor Field |
Sugar Market Field |
|
-- |
ContactID (primary key) |
|
Infor's Contact ID (primary key) |
ID |
|
Infor's Account ID (foreign key) |
AccountID (foreign key) |
|
AccountManager (foreign key) |
OwnerID (foreign key) |
|
-- |
CRMType |
|
-- |
CreatedDate |
|
-- |
LastUpdate |
|
CreateDate |
ExternalCRMCreatedDate |
|
ModifyDate1 |
ExternalCRMUpdatedDate |
|
FirstName |
FirstName |
|
LastName |
LastName |
|
|
|
|
DoNotEmail |
OpOut |
|
(Does not map) |
Source |
|
LeadSource: Description |
LeadSource |
|
Title |
Title |
|
WorkPhone |
Phone |
|
HomePhone (If Workphone has no value) |
Phone |
|
Mobile |
MobilePhone |
|
Address1 |
MailingStreet |
|
Address2 |
MailingStreet2 |
|
City |
MailingCity |
|
State |
MailingState |
|
PostalCode |
MailingZip |
|
Country |
MailingCountry |
1 The ModifyDate field is the field that Sugar Market uses to determine if the record has been updated since the last successful sync to evaluate if the record needs to be synced.
Opportunities
|
Infor Field |
Sugar Market Field |
|
-- |
OpportunityID (primary key) |
|
Infor's Opportunity ID (primary key) |
ID |
|
Infor's Account ID (foreign key) |
AccountID (foreign key) |
|
AccountManager (foreign key) |
OwnerID (foreign key) |
|
Leadsource: Description |
LeadSource |
|
Description |
Description |
|
Description |
OpportunityName |
|
Stage |
Stage |
Users
|
Infor Field |
Sugar Market Field |
|
-- |
UserID (primary key) |
|
Infor's user ID (primary key) |
ID |
|
FirstName |
First_name |
|
LastName |
Last_name |
|
Username |
Username |
|
FirstName+LastName |
Name |
|
Address1 |
Address1 |
|
Address2 |
Address2 |
|
City |
City |
|
State |
State |
|
PostalCode |
Zip |
|
Country |
Country |
|
Title |
JobTitle |
|
Phone |
Phone_Number |
|
Cell |
Mobile |
|
Salutation |
Prefix |
Push Only - Sugar Market's Task to Infor's Activity
|
Infor Field |
Sugar Market Field |
|
-- |
TaskID (primary key) |
|
Infor's Activity ID (primary key) |
ID |
|
Infor's Contact ID (foreign key) |
ContactID (foreign key) |
|
ContactName |
Contact.FirstName + Contact.LastName |
|
StartDate |
DueDate |
|
OriginalDate |
DueDate |
|
Notes |
Comments |
|
LongNotes |
Comments |
|
Description |
Subject |
Note: If Sugar Market Task.Status is set as "Complete" through a Sugar Market automation we'll push the Status up as "Complete", otherwise we will push the task up as "ToDo."
Custom Entities
DELETEHISTORYLOG (Recycle Bin)
|
CRM Field |
Type\Size |
Relationship |
|
DELETEHISTORYLOGID |
char(12) |
Direct |
|
ENTITYID |
varchar(100) |
Lookup (Contact\Lead\Account) |
|
ENTITYTYPE |
varchar(50) |
Contact\Lead\Account |
|
PROCESSED |
varchar(5) |
Direct |
|
PROCESSEDDATE |
datetime |
Direct |
|
PROCESSNOTES |
varchar(500) |
N\A |
SF_CAMPAIGNER (Campaigns)
|
CRM Field |
Type\Size |
Relationship |
|
SF_CAMPAIGNERID |
char(12) |
Direct |
|
SUBJECT |
varchar(500) |
Direct |
|
STATUS |
smallint |
Direct |
|
FROMEMAIL |
varchar(150) |
Direct |
|
POSTDATE |
datetime |
Direct |
|
TOEMAIL |
varchar(4000) |
Direct |
|
CAMPAIGNNAME |
varchar(100) |
Direct |
|
CAMPAIGNERTYPE |
varchar(50) |
Direct |
|
CAMPAIGNERLIST |
varchar(200) |
Direct |
|
SENDER |
varchar(150) |
Direct |
|
DISPLAYNAME |
varchar(100) |
Direct |
|
PARENTID |
smallint |
Direct |
|
ACTIVATED |
smallint |
Direct |
|
TRIGGERHOUR |
smallint |
Direct |
|
TRIGGERMINUTE |
smallint |
Direct |
|
TRIGGERDAYS |
smallint |
Direct |
|
RECURRINGFREQUENCY |
varchar(20) |
Direct |
|
RECURRINGSTOP |
datetime |
Direct |
|
ASSETID |
smallint |
Direct |
|
HIDECAMPAIGN |
varchar(5) |
Direct |
|
NOUNSUB |
varchar(5) |
Direct |
|
TEXTONLY |
varchar(5) |
Direct |
|
ABTEST |
varchar(5) |
Direct |
|
HEADER1 |
varchar(200) |
Direct |
|
ACTIVATEDDATE |
datetime |
Direct |
|
SUBJECTB |
varchar(500) |
Direct |
|
SENDNOTIFICATION |
varchar(5) |
Direct |
|
INSTANTRELEASE |
varchar(5) |
Direct |
|
ALLOWDUPLICATES |
varchar(5) |
Direct |
|
SENDTRIGGERNOTIFICATION |
varchar(5) |
Direct |
|
NOTIFICATIONLIST |
varchar(500) |
Direct |
|
DYNAMICCONTENT |
varchar(5) |
Direct |
|
DYNAMICTYPE |
varchar(50) |
Direct |
|
THROTTLETRIGGERDAYS |
smallint |
Direct |
|
THROTTLEDRIPDAYS |
smallint |
Direct |
|
FOLDERID |
smallint |
Direct |
|
SENDTOEXCLUDE |
varchar(32) |
Direct |
|
ENABLERSSFEED |
varchar(10) |
Direct |
|
BODYTEXT |
text |
Direct |
|
BODYTEXTB |
text |
Direct |
|
BODY1 |
text |
Direct |
|
BODYB |
text |
Direct |
|
CAMPAIGNERID |
int |
Direct |
|
RECURRING |
int |
Direct |
SF_CAMPAIGNERLINKCLICK (Link Clicks)
|
CRM Field |
Type\Size |
Relationship |
|
SF_CAMPAIGNERLINKCLICKID |
char(12) |
Direct |
|
SF_CAMPAIGNERID |
char(12) |
Direct |
|
CLICKDATE |
datetime |
Direct |
|
WEBSESSIONID |
varchar(150) |
Direct |
|
RURL |
varchar(500) |
Direct |
|
LINKORDER |
smallint |
Direct |
|
TOEMAIL |
varchar(500) |
Direct |
|
SF_CAMPAIGNERLINKID |
smallint |
Direct |
|
CAMPAIGNERLINKCLICKID |
char(12) |
Direct |
|
SF_CAMPAIGNACTUALID |
varchar(32) |
Direct |
|
CAMPAIGNACTUALID |
int |
Direct |
|
EMAIL_CAMPAIGN |
varchar(12) |
Direct |
SF_CONFIG (Journey View Configuration)
|
CRM Field |
Type\Size |
Relationship |
|
SF_CONFIGID |
char(12) |
N\A |
|
SFNAME |
varchar(100) |
N\A |
|
SFVALUE |
nvarchar(255) |
N\A |
SF_DIALOG (Landing Pages)
|
CRM Field |
Type\Size |
Relationship |
|
NAME |
varchar(80) |
Direct |
|
COMPLETED_DATE |
datetime |
Direct |
|
CONTACT |
varchar(12) |
Direct |
|
DIALOG_ID |
int |
Direct |
|
DIALOG_NAME |
varchar(255) |
Direct |
|
DIALOG_RESPONSE |
text |
Direct |
|
LEAD |
varchar(12) |
Lookup (Contac\Lead) |
|
START_FORM_ID |
int |
Direct |
SF_EVENT (Events)
|
CRM Field |
Type\Size |
Relationship |
|
SF_EVENTID |
char(12) |
Direct |
|
NAME |
varchar(80) |
Direct |
|
ATTENDED |
varchar(1) |
Direct |
|
CONTACT |
varchar(12) |
Direct |
|
DURATION |
int |
Direct |
|
EVENT_DATE |
datetime |
Direct |
|
EVENT_LOCATION |
varchar(255) |
Direct |
|
EVENT_NAME |
varchar(255) |
Direct |
|
LEAD |
varchar(12) |
Direct |
|
LEAD_SOURCE |
varchar(255) |
Direct |
|
REGISTERED |
varchar(1) |
Direct |
SF_WEBACTIVITY (Webactivity Parent Session)
|
CRM Field |
Type\Size |
Relationship |
|
HEMISPHERE |
varchar(10) |
Direct |
|
BROWSERLANGUAGE |
varchar(100) |
Direct |
|
JAVAENABLED |
smallint |
Direct |
|
RESOLUTION |
varchar(16) |
Direct |
|
COLORDEPTH |
varchar(4) |
Direct |
|
PIXELDEPTH |
varchar(4) |
Direct |
|
OPERATINGSYSTEM |
varchar(16) |
Direct |
|
USERAGENT |
varchar(64) |
Direct |
|
JAVASCRIPTVERSION |
varchar(8) |
Direct |
|
IDENTIFIEDBY |
varchar(16) |
Direct |
|
REFERRERDOMAIN |
varchar(50) |
Direct |
|
REFERRERKEYWORDS |
varchar(1000) |
Direct |
|
REFERRERQUERY |
varchar(1000) |
Direct |
|
REFERRERREFERRER |
varchar(1000) |
Direct |
|
LONGITUDE |
float |
Direct |
|
LATITUDE |
float |
Direct |
|
AREACODE |
smallint |
Direct |
|
CITY |
varchar(100) |
Direct |
|
COUNTRYCODE |
varchar(50) |
Direct |
|
COUNTRYNAME |
varchar(50) |
Direct |
|
DMA_CODE |
smallint |
Direct |
|
POSTALCODE |
varchar(25) |
Direct |
|
REGION |
varchar(50) |
Direct |
|
ALERTCRM |
smallint |
Direct |
|
ALERTBEGIN |
smallint |
Direct |
|
ALERTEND |
varchar(10) |
Direct |
|
OWNERID |
smallint |
Direct |
|
ORGANIZATIONNAME |
varchar(100) |
Direct |
|
SCORING |
smallint |
Direct |
|
CHAT |
smallint |
Direct |
|
ISP |
varchar(100) |
Direct |
|
TOUCHPOINT |
varchar(100) |
Direct |
|
DIALOGSESSION |
varchar(150) |
Direct |
|
CLIENTIP |
varchar(50) |
Direct |
|
STARTDATE |
datetime |
Direct |
|
TIMEZONE |
varchar(10) |
Direct |
|
ACCOUNTID |
varchar(12) |
Direct |
|
SECCODEID |
char(12) |
Direct |
|
WEBACTIVITYID |
int |
Direct |
SF_WEBACTIVITYDETAIL (Webactivity Session Details)
|
CRM Field |
Type\Size |
Relationship |
|
SF_WEBACTIVITYDETAILID |
char(12) |
Direct |
|
SF_WEBACTIVITYID |
char(12) |
Direct |
|
WEBINTERACTIONID |
varchar(100) |
Direct |
|
WEBSESSIONID |
varchar(100) |
Direct |
|
INTERACTIONDATE |
datetime |
Direct |
|
PROTOCOL |
varchar(250) |
Direct |
|
HOSTNAME |
varchar(250) |
Direct |
|
PATH |
varchar(250) |
Direct |
|
TITLE |
varchar(250) |
Direct |
|
REFERRER |
varchar(1000) |
Direct |
|
PARAMETERS |
varchar(250) |
Direct |
|
ENTRYPAGE |
varchar(1) |
Direct |
|
EXITPAGE |
varchar(1) |
Direct |
|
DURATION |
float |
Direct |
|
WEBACTIVITYDETAILID |
int |
Direct |
CAMPAIGNTARGET (Individual Email Sends)
|
CRM Field |
Type\Size |
Relationship |
|
CAMPAIGNTARGETID |
char(12) |
NOT |
|
CAMPAIGNID |
char(12) |
NOT |
|
ENTITYID |
char(12) |
NULL |
|
TARGETTYPE |
varchar(32) |
NULL |
|
GROUPNAME |
varchar(32) |
NULL |
|
INITIALTARGET |
char(1) |
NULL |
|
STAGE |
varchar(64) |
NULL |
|
STATUS |
varchar(32) |
NULL |
|
C_OPEN |
int |
NULL |
|
DELIVERYSTATUS |
int |
NULL |
|
FRIENDFORWARD |
int |
NULL |