Netsuite CRM Mappings
CRM Mappings
The following fields, grouped by their tables in Sugar Market, are pulled down from Netsuite CRM into Sugar Market.
Accounts
|
Netsuite Field |
Sugar Market Field |
|
-- |
AccountID (primary key) |
|
Netsuite's Account ID (primary key) |
ID |
|
CompanyName |
AccountName |
|
RegardingObjectId (foreign key) (if multiple owners, we pull the first Netsuite owner) |
OwnerID (foreign key) |
|
Addr1 |
MailingStreet |
|
State |
MailingState |
|
City |
MailingCity |
|
Zip |
MailingZip |
Contacts and Leads
Sugar Market does not have a Leads table, but they are differentiated in the Contacts table by the CRMType field.
|
Netsuite Field |
Sugar Market Field |
|
-- |
ContactID (primary key) |
|
Netsuite's Contact ID (primary key) |
ID |
|
Netsuite's Account ID (foreign key) |
AccountID (foreign key) |
|
OwnerID (foreign key) |
OwnerID (foreign key) |
|
-- |
CRMType |
|
-- |
CreatedDate |
|
-- |
LastUpdate |
|
DateCreated |
ExternalCRMCreatedDate |
|
LastModifiedDate1 |
ExternalCRMUpdatedDate |
|
FirstName |
FirstName |
|
LastName |
LastName |
|
|
|
|
GlobalSubscriptionStatus |
OpOut |
|
(Does not map) |
Source |
|
Title |
Title |
|
Phone |
Phone |
|
MobilePhone |
MobilePhone |
|
Addr1 |
MailingStreet |
|
State |
MailingState |
|
City |
MailingCity |
|
Zip |
MailingZip |
1 The LastModifiedDate 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
|
Netsuite Field |
Sugar Market Field |
|
-- |
OpportunityID (primary key) |
|
Netsuite's Opportunity ID (primary key) |
ID |
|
PrimaryCompanyID (foreign key) |
AccountID (foreign key) |
|
PrimaryPersonID (foreign key) |
ContactID (foreign key) |
|
AssignedUserID (foreign key) |
OwnerID (foreign key) |
|
Title |
OpportunityName |
|
Title |
Description |
|
Status |
Stage |
|
ProjectedTotal |
Amount |
|
Probability |
Probability |
Users
|
Netsuite Field |
Sugar Market Field |
|
-- |
UserID (primary key) |
|
Netsuite's user ID (primary key) |
ID |
|
FirstName |
First_name |
|
LastName |
Last_name |
|
FirstName + LastName |
Name |
|
|
Username |
|
|
|
|
GiveAccess |
Status |
|
Address1 |
Address1 |
|
Address2 |
Address2 |
|
City |
City |
|
State |
State |
|
Zip |
Zip |
|
Country |
Country |
|
Title |
JobTitle |
|
Phone |
Phone_Number |
|
Cell |
MobilePhone |
|
Salutation |
Salutation |
Push Only - Sugar Market's Task to Netsuite's Activity
|
Netsuite Field |
Sugar Market Field |
|
-- |
TaskID (primary key) |
|
Netsuite's Activity ID (primary key) |
ID |
|
PrimaryPersonID (foreign key) |
ContactID (foreign key) |
|
CreatedDate |
Create_Date |
|
StartDate |
DueDate |
|
DueDate |
DueDate |
|
Message |
DescriptionText |
|
Title |
Subject |
|
TaskPriority |
Priority |
|
TaskStatus |
Status |