Explore the Salesforce API data model

Pulling data from the Salesforce API is only the first part of your reporting. You also need to understand the relationships between different endpoints - something that APIs typically fail to convey.

At SyncHub, we not only sync your Salesforce API endpoints down into a reportable format, we also describe their relationships (e.g. in terms of foreign keys) so that you can quickly get a grasp of your data and how it fits together. This page is intended as technical documentation of these relationships.

Account

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Name	string	-	-
Description	string	-	-
AccountNumber	string	-	-
Type	string	-	-
AccountSource	string	-	-
CleanStatus	string	-	-
ConnectionReceivedID	string	-	-
ConnectionSentID	string	-	-
DunsNumber	string	-	-
Fax	string	-	-
Industry	string	-	-
BillingCity	string	-	-
BillingCountry	string	-	-
BillingCountryCode	string	-	-
BillingGeocodeAccuracy	string	-	-
BillingLatitude	decimal	-	-
BillingLongitude	decimal	-	-
BillingPostalCode	string	-	-
BillingState	string	-	-
BillingStateCode	string	-	-
BillingStreet	string	-	-
ShippingCity	string	-	-
ShippingCountry	string	-	-
ShippingCountryCode	string	-	-
ShippingGeocodeAccuracy	string	-	-
ShippingLatitude	decimal	-	-
ShippingLongitude	decimal	-	-
ShippingPostalCode	string	-	-
ShippingState	string	-	-
ShippingStateCode	string	-	-
ShippingStreet	string	-	-
IsCustomerPortal	boolean	-	-
IsPartner	boolean	-	-
IsPersonAccount	boolean	-	-
AnnualRevenue	decimal	-	-
Jigsaw	string	-	-
LastActivityDate	datetime	-	-
ParentID	string	Account → ID	-
MasterRecordID	string	Account → ID	-
NaicsCode	string	-	-
NaicsDesc	string	-	-
NumberOfEmployees	int	-	-
OperatingHoursID	string	-	-
Ownership	string	-	-
Phone	string	-	-
PhotoUrl	string	-	-
Rating	string	-	-
Salutation	string	-	-
Sic	string	-	-
SicDesc	string	-	-
Site	string	-	-
TickerSymbol	string	-	-
Tradestyle	string	-	-
Website	string	-	-
YearStarted	string	-	-
LastModifiedByID	string	User → ID	-
CreatedByID	string	User → ID	-
CreatedDate	datetime	-	-
OwnerID	string	User → ID	-
SystemModstamp	datetime	-	-
LastModifiedDate	datetime	-	-

Asset

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Name	string	-	-
Description	string	-	-
ContactID	string	Contact → ID	-
AccountID	string	Account → ID	-
ParentID	string	Asset → ID	-
RootAssetID	string	Asset → ID	-
Product2ID	string	Product → ID	-
ProductCode	string	-	-
IsCompetitorProduct	boolean	-	-
SerialNumber	string	-	-
InstallDate	datetime	-	-
PurchaseDate	datetime	-	-
UsageEndDate	datetime	-	-
LifecycleStartDate	datetime	-	-
LifecycleEndDate	datetime	-	-
Status	string	-	-
Price	decimal	-	-
Quantity	decimal	-	-
AssetProvidedByID	string	-	-
AssetServicedByID	string	-	-
IsInternal	boolean	-	-
AssetLevel	int	-	-
StockKeepingUnit	string	-	-
HasLifecycleManagement	boolean	-	-
CurrentMrr	decimal	-	-
CurrentLifecycleEndDate	datetime	-	-
CurrentQuantity	decimal	-	-
CurrentAmount	decimal	-	-
TotalLifecycleAmount	decimal	-	-
Street	string	-	-
City	string	-	-
State	string	-	-
PostalCode	string	-	-
Country	string	-	-
Latitude	decimal	-	-
Longitude	decimal	-	-
GeocodeAccuracy	string	-	-
LastViewedDate	datetime	-	-
LastReferencedDate	datetime	-	-
LastModifiedByID	string	User → ID	-
CreatedByID	string	User → ID	-
CreatedDate	datetime	-	-
OwnerID	string	User → ID	-
SystemModstamp	datetime	-	-
LastModifiedDate	datetime	-	-

Campaign

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Name	string	-	-
Description	string	-	-
ParentID	string	Campaign → ID	-
Type	string	-	-
Status	string	-	-
StartDate	datetime	-	-
EndDate	datetime	-	-
ExpectedRevenue	decimal	-	-
BudgetedCost	decimal	-	-
ActualCost	decimal	-	-
ExpectedResponse	decimal	-	-
NumberSent	decimal	-	-
IsActive	boolean	-	-
NumberOfLeads	decimal	-	-
NumberOfConvertedLeads	decimal	-	-
NumberOfContacts	decimal	-	-
NumberOfResponses	decimal	-	-
NumberOfOpportunities	decimal	-	-
NumberOfWonOpportunities	decimal	-	-
AmountAllOpportunities	decimal	-	-
AmountWonOpportunities	decimal	-	-
LastActivityDate	datetime	-	-
LastViewedDate	datetime	-	-
LastReferencedDate	datetime	-	-
CampaignMemberRecordTypeID	string	-	-
LastModifiedByID	string	User → ID	-
CreatedByID	string	User → ID	-
CreatedDate	datetime	-	-
OwnerID	string	User → ID	-
SystemModstamp	datetime	-	-
LastModifiedDate	datetime	-	-

Case

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Description	string	-	-
CaseNumber	string	-	-
ContactID	string	Contact → ID	-
CaseID	string	Case → ID	-
AssetID	string	Asset → ID	-
SourceID	string	-	-
ParentID	string	Case → ID	-
SuppliedName	string	-	-
SuppliedEmail	string	-	-
SuppliedPhone	string	-	-
SuppliedCompany	string	-	-
Type	string	-	-
Status	string	-	-
Reason	string	-	-
Origin	string	-	-
Subject	string	-	-
Priority	string	-	-
IsClosed	boolean	-	-
ClosedDate	datetime	-	-
IsEscalated	boolean	-	-
Comments	string	-	-
LastViewedDate	datetime	-	-
LastReferencedDate	datetime	-	-
MasterRecordID	string	Case → ID	-
LastModifiedByID	string	User → ID	-
CreatedByID	string	User → ID	-
CreatedDate	datetime	-	-
OwnerID	string	User → ID	-
SystemModstamp	datetime	-	-
LastModifiedDate	datetime	-	-

Contact

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Name	string	-	-
Description	string	-	-
AccountID	string	Account → ID	-
LastName	string	-	-
FirstName	string	-	-
Salutation	string	-	-
MailingStreet	string	-	-
MailingCity	string	-	-
MailingState	string	-	-
MailingPostalCode	string	-	-
MailingCountry	string	-	-
MailingLatitude	decimal	-	-
MailingLongitude	decimal	-	-
MailingGeocodeAccuracy	string	-	-
OtherStreet	string	-	-
OtherCity	string	-	-
OtherState	string	-	-
OtherPostalCode	string	-	-
OtherCountry	string	-	-
OtherLatitude	decimal	-	-
OtherLongitude	decimal	-	-
OtherGeocodeAccuracy	string	-	-
Phone	string	-	-
Fax	string	-	-
MobilePhone	string	-	-
HomePhone	string	-	-
OtherPhone	string	-	-
AssistantPhone	string	-	-
Email	string	-	-
Title	string	-	-
Department	string	-	-
AssistantName	string	-	-
LeadSource	string	-	-
Birthdate	datetime	-	-
ReportsToID	string	Contact → ID	-
EmailBouncedReason	string	-	-
EmailBouncedDate	datetime	-	-
IsEmailBounced	boolean	-	-
PhotoUrl	string	-	-
Jigsaw	string	-	-
JigsawContactID	string	-	-
CleanStatus	string	-	-
IndividualID	string	-	-
IsPriorityRecord	boolean	-	-
ContactSource	string	-	-
LastModifiedByID	string	User → ID	-
CreatedByID	string	User → ID	-
CreatedDate	datetime	-	-
OwnerID	string	User → ID	-
SystemModstamp	datetime	-	-
LastModifiedDate	datetime	-	-

Contract

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Description	string	-	-
AccountID	string	Account → ID	-
Pricebook2ID	string	Pricebook → ID	-
OwnerExpirationNotice	string	-	-
StartDate	datetime	-	-
EndDate	datetime	-	-
ContractTerm	int	-	-
Status	string	-	-
CompanySignedID	string	User → ID	-
CompanySignedDate	datetime	-	-
CustomerSignedID	string	User → ID	-
CustomerSignedTitle	string	-	-
CustomerSignedDate	datetime	-	-
SpecialTerms	string	-	-
ActivatedByID	string	User → ID	-
ActivatedDate	datetime	-	-
StatusCode	string	-	-
ContractNumber	string	-	-
BillingStreet	string	-	-
BillingCity	string	-	-
BillingState	string	-	-
BillingPostalCode	string	-	-
BillingCountry	string	-	-
BillingLatitude	decimal	-	-
BillingLongitude	decimal	-	-
BillingGeocodeAccuracy	string	-	-
LastApprovedDate	datetime	-	-
LastActivityDate	datetime	-	-
LastViewedDate	datetime	-	-
LastReferencedDate	datetime	-	-
LastModifiedByID	string	User → ID	-
CreatedByID	string	User → ID	-
CreatedDate	datetime	-	-
OwnerID	string	User → ID	-
SystemModstamp	datetime	-	-
LastModifiedDate	datetime	-	-

CustomFieldType

Documentation: https://developer.salesforce.com/docs/atlas.en-us.api_tooling.meta/api_tooling/tooling_api_objects_customfield.htm

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Description	string	-	-
TableEnumOrID	string	EntityDefinition → QualifiedApiName	-
Label	string	-	-
FullName	string	-	-
Type	string	-	-
DefaultValue	string	-	-
Length	int	-	-
Precision	int	-	-
Scale	int	-	-
Unique	boolean	-	-
ExternalID	boolean	-	-
CaseSensitive	boolean	-	-
LastModifiedByID	string	User → ID	-
CreatedByID	string	User → ID	-
DeveloperName	string	-	-
LastModifiedDate	datetime	-	-

CustomObject

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Name	string	-	-
EntityDefinitionID	string	EntityDefinition → QualifiedApiName	-
LastModifiedByID	string	User → ID	-
CreatedByID	string	User → ID	-
CreatedDate	datetime	-	-
OwnerID	string	User → ID	-
SystemModstamp	datetime	-	-
LastModifiedDate	datetime	-	-

EntityDefinition

Documentation: https://developer.salesforce.com/docs/atlas.en-us.api_tooling.meta/api_tooling/tooling_api_objects_entitydefinition.htm

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
QualifiedApiName	string	-	-
DeveloperName	string	-	-
KeyPrefix	string	-	-
PublisherID	string	-	-
LastModifiedDate	datetime	-	-
RemoteEntityName	string	-	-

Event

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Description	string	-	-
WhoID	string	-	-
WhatID	string	-	-
Subject	string	-	-
Location	string	-	-
IsAllDayEvent	boolean	-	-
ActivityDateTime	datetime	-	-
ActivityDate	datetime	-	-
DurationInMinutes	int	-	-
StartDateTime	datetime	-	-
EndDateTime	datetime	-	-
EndDate	datetime	-	-
AccountID	string	Account → ID	-
IsPrivate	boolean	-	-
ShowAs	string	-	-
IsChild	boolean	-	-
IsGroupEvent	boolean	-	-
GroupEventType	string	-	-
IsArchived	boolean	-	-
RecurrenceActivityID	string	-	-
IsRecurrence	boolean	-	-
RecurrenceStartDateTime	datetime	-	-
RecurrenceEndDateOnly	datetime	-	-
RecurrenceTimeZoneSidKey	string	-	-
RecurrenceType	string	-	-
RecurrenceInterval	int	-	-
RecurrenceDayOfWeekMask	int	-	-
RecurrenceDayOfMonth	int	-	-
RecurrenceInstance	string	-	-
RecurrenceMonthOfYear	string	-	-
ReminderDateTime	datetime	-	-
IsReminderSet	boolean	-	-
EventSubtype	string	-	-
IsRecurrence2Exclusion	boolean	-	-
Recurrence2PatternText	string	-	-
Recurrence2PatternVersion	string	-	-
IsRecurrence2	boolean	-	-
IsRecurrence2Exception	boolean	-	-
Recurrence2PatternStartDate	datetime	-	-
Recurrence2PatternTimeZone	string	-	-
ServiceAppointmentID	string	-	-
LastModifiedByID	string	User → ID	-
CreatedByID	string	User → ID	-
CreatedDate	datetime	-	-
OwnerID	string	User → ID	-
SystemModstamp	datetime	-	-
LastModifiedDate	datetime	-	-

Lead

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Name	string	-	-
Description	string	-	-
LastName	string	-	-
FirstName	string	-	-
Salutation	string	-	-
Title	string	-	-
Company	string	-	-
Street	string	-	-
City	string	-	-
State	string	-	-
PostalCode	string	-	-
Country	string	-	-
Latitude	decimal	-	-
Longitude	decimal	-	-
GeocodeAccuracy	string	-	-
Phone	string	-	-
MobilePhone	string	-	-
Fax	string	-	-
Email	string	-	-
Website	string	-	-
LeadSource	string	-	-
Status	string	-	-
Industry	string	-	-
Rating	string	-	-
AnnualRevenue	decimal	-	-
NumberOfEmployees	int	-	-
IsConverted	boolean	-	-
ConvertedDate	datetime	-	-
ConvertedLeadID	string	Lead → ID	-
ConvertedContactID	string	Contact → ID	-
ConvertedOpportunityID	string	Opportunity → ID	-
IsUnreadByOwner	boolean	-	-
LastActivityDate	datetime	-	-
LastViewedDate	datetime	-	-
LastReferencedDate	datetime	-	-
Jigsaw	string	-	-
JigsawContactID	string	-	-
CleanStatus	string	-	-
CompanyDunsNumber	string	-	-
DandbCompanyID	string	-	-
EmailBouncedReason	string	-	-
EmailBouncedDate	datetime	-	-
IndividualID	string	-	-
IsPriorityRecord	boolean	-	-
MasterRecordID	string	Lead → ID	-
LastModifiedByID	string	User → ID	-
CreatedByID	string	User → ID	-
CreatedDate	datetime	-	-
OwnerID	string	User → ID	-
SystemModstamp	datetime	-	-
LastModifiedDate	datetime	-	-

Opportunity

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Name	string	-	-
Description	string	-	-
AccountID	string	Account → ID	-
IsPrivate	boolean	-	-
StageName	string	-	-
Amount	decimal	-	-
Probability	decimal	-	-
ExpectedRevenue	decimal	-	-
TotalOpportunityQuantity	decimal	-	-
CloseDate	datetime	-	-
Type	string	-	-
NextStep	string	-	-
LeadSource	string	-	-
IsClosed	boolean	-	-
IsWon	boolean	-	-
ForecastCategory	string	-	-
ForecastCategoryName	string	-	-
CampaignID	string	-	-
HasOpportunityLineItem	boolean	-	-
Pricebook2ID	string	-	-
PushCount	int	-	-
LastStageChangeDate	datetime	-	-
FiscalQuarter	int	-	-
FiscalYear	int	-	-
Fiscal	string	-	-
ContactID	string	-	-
HasOpenActivity	boolean	-	-
HasOverdueTask	boolean	-	-
LastAmountChangedHistoryID	string	-	-
LastCloseDateChangedHistoryID	string	-	-
LastModifiedByID	string	User → ID	-
CreatedByID	string	User → ID	-
CreatedDate	datetime	-	-
OwnerID	string	User → ID	-
SystemModstamp	datetime	-	-
LastModifiedDate	datetime	-	-

Order

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Description	string	-	-
ContractID	string	Contract → ID	-
AccountID	string	Account → ID	-
Pricebook2ID	string	Pricebook → ID	-
OriginalOrderID	string	Order → ID	-
EffectiveDate	datetime	-	-
EndDate	datetime	-	-
IsReductionOrder	boolean	-	-
Status	string	-	-
CustomerAuthorizedByID	string	-	-
CustomerAuthorizedDate	datetime	-	-
CompanyAuthorizedByID	string	-	-
CompanyAuthorizedDate	datetime	-	-
Type	string	-	-
BillingStreet	string	-	-
BillingCity	string	-	-
BillingState	string	-	-
BillingPostalCode	string	-	-
BillingCountry	string	-	-
BillingLatitude	decimal	-	-
BillingLongitude	decimal	-	-
BillingGeocodeAccuracy	string	-	-
LastModifiedByID	string	User → ID	-
CreatedByID	string	User → ID	-
CreatedDate	datetime	-	-
OwnerID	string	User → ID	-
SystemModstamp	datetime	-	-
LastModifiedDate	datetime	-	-

OrderItem

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Description	string	-	-
Product2ID	string	Product → ID	-
OrderID	string	Order → ID	-
PricebookEntryID	string	PricebookEntry → ID	-
OriginalOrderItemID	string	OrderItem → ID	-
AvailableQuantity	decimal	-	-
Quantity	decimal	-	-
UnitPrice	decimal	-	-
ListPrice	decimal	-	-
TotalPrice	decimal	-	-
ServiceDate	datetime	-	-
EndDate	datetime	-	-
OrderItemNumber	string	-	-
LastModifiedByID	string	User → ID	-
CreatedByID	string	User → ID	-
CreatedDate	datetime	-	-
OwnerID	string	User → ID	-
SystemModstamp	datetime	-	-
LastModifiedDate	datetime	-	-

Organization

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Name	string	-	-
Division	string	-	-
Street	string	-	-
City	string	-	-
State	string	-	-
PostalCode	string	-	-
Country	string	-	-
Latitude	decimal	-	-
Longitude	decimal	-	-
GeocodeAccuracy	string	-	-
Phone	string	-	-
Fax	string	-	-
PrimaryContact	string	-	-
DefaultLocaleSidKey	string	-	-
TimeZoneSidKey	string	-	-
LanguageLocaleKey	string	-	-
ReceivesInfoEmails	boolean	-	-
ReceivesAdminInfoEmails	boolean	-	-
PreferencesRequireOpportunityProducts	boolean	-	-
PreferencesEmailSenderIdCompliance	boolean	-	-
PreferencesTransactionSecurityPolicy	boolean	-	-
PreferencesConsentManagementEnabled	boolean	-	-
PreferencesAutoSelectIndividualOnMerge	boolean	-	-
PreferencesLightningLoginEnabled	boolean	-	-
PreferencesOnlyLLPermUserAllowed	boolean	-	-
FiscalYearStartMonth	int	-	-
UsesStartDateAsFiscalYearName	boolean	-	-
DefaultAccountAccess	string	-	-
DefaultContactAccess	string	-	-
DefaultOpportunityAccess	string	-	-
DefaultLeadAccess	string	-	-
DefaultCaseAccess	string	-	-
DefaultCalendarAccess	string	-	-
DefaultPricebookAccess	string	-	-
DefaultCampaignAccess	string	-	-
ComplianceBccEmail	string	-	-
UiSkin	string	-	-
SignupCountryIsoCode	string	-	-
TrialExpirationDate	datetime	-	-
NumKnowledgeService	int	-	-
OrganizationType	string	-	-
NamespacePrefix	string	-	-
InstanceName	string	-	-
IsSandbox	boolean	-	-
WebToCaseDefaultOrigin	string	-	-
MonthlyPageViewsUsed	int	-	-
MonthlyPageViewsEntitlement	int	-	-
IsReadOnly	boolean	-	-
LastModifiedByID	string	User → ID	-
CreatedByID	string	User → ID	-
CreatedDate	datetime	-	-
OwnerID	string	User → ID	-
SystemModstamp	datetime	-	-
LastModifiedDate	datetime	-	-

Pricebook

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Name	string	-	-
Description	string	-	-
IsActive	boolean	-	-
IsArchived	boolean	-	-
IsStandard	boolean	-	-
LastViewedDate	datetime	-	-
LastReferencedDate	datetime	-	-
LastModifiedByID	string	User → ID	-
CreatedByID	string	User → ID	-
CreatedDate	datetime	-	-
OwnerID	string	User → ID	-
SystemModstamp	datetime	-	-
LastModifiedDate	datetime	-	-

PricebookEntry

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Name	string	-	-
Pricebook2ID	string	Pricebook → ID	-
Product2ID	string	Product → ID	-
UnitPrice	decimal	-	-
IsActive	boolean	-	-
UseStandardPrice	boolean	-	-
ProductCode	string	-	-
IsArchived	boolean	-	-
LastModifiedByID	string	User → ID	-
CreatedByID	string	User → ID	-
CreatedDate	datetime	-	-
OwnerID	string	User → ID	-
SystemModstamp	datetime	-	-
LastModifiedDate	datetime	-	-

Product

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Name	string	-	-
Description	string	-	-
ProductCode	string	-	-
IsActive	boolean	-	-
Family	string	-	-
ExternalDataSourceID	string	-	-
ExternalID	string	-	-
DisplayUrl	string	-	-
QuantityUnitOfMeasure	string	-	-
StockKeepingUnit	string	-	-
Type	string	-	-
ProductClass	string	-	-
LastViewedDate	datetime	-	-
LastReferencedDate	datetime	-	-
IsArchived	boolean	-	-
LastModifiedByID	string	User → ID	-
CreatedByID	string	User → ID	-
CreatedDate	datetime	-	-
OwnerID	string	User → ID	-
SystemModstamp	datetime	-	-
LastModifiedDate	datetime	-	-

TaskObject

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Description	string	-	-
WhoID	string	-	-
WhatID	string	-	-
Subject	string	-	-
ActivityDate	datetime	-	-
Status	string	-	-
Priority	string	-	-
IsHighPriority	boolean	-	-
IsClosed	boolean	-	-
IsArchived	boolean	-	-
CallDurationInSeconds	int	-	-
CallType	string	-	-
CallDisposition	string	-	-
CallObject	string	-	-
ReminderDateTime	datetime	-	-
IsReminderSet	boolean	-	-
RecurrenceActivityID	string	-	-
IsRecurrence	boolean	-	-
RecurrenceStartDateOnly	datetime	-	-
RecurrenceEndDateOnly	datetime	-	-
RecurrenceTimeZoneSidKey	string	-	-
RecurrenceType	string	-	-
RecurrenceInterval	int	-	-
RecurrenceDayOfWeekMask	int	-	-
RecurrenceDayOfMonth	int	-	-
RecurrenceInstance	string	-	-
RecurrenceMonthOfYear	string	-	-
RecurrenceRegeneratedType	string	-	-
TaskObjectSubtype	string	-	-
CompletedDateTime	datetime	-	-
LastModifiedByID	string	User → ID	-
CreatedByID	string	User → ID	-
CreatedDate	datetime	-	-
OwnerID	string	User → ID	-
SystemModstamp	datetime	-	-
LastModifiedDate	datetime	-	-

User

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Name	string	-	-
Username	string	-	-
LastName	string	-	-
FirstName	string	-	-
CompanyName	string	-	-
Division	string	-	-
Department	string	-	-
Title	string	-	-
Street	string	-	-
City	string	-	-
State	string	-	-
PostalCode	string	-	-
Country	string	-	-
Latitude	decimal	-	-
Longitude	decimal	-	-
GeocodeAccuracy	string	-	-
Email	string	-	-
Phone	string	-	-
Fax	string	-	-
MobilePhone	string	-	-
Alias	string	-	-
CommunityNickname	string	-	-
BadgeText	string	-	-
IsActive	boolean	-	-
TimeZoneSidKey	string	-	-
UserRoleID	string	-	-
LocaleSidKey	string	-	-
EmailEncodingKey	string	-	-
ProfileID	string	-	-
UserType	string	-	-
LanguageLocaleKey	string	-	-
EmployeeNumber	string	-	-
DelegatedApproverID	string	-	-
ManagerID	string	-	-
LastLoginDate	datetime	-	-
LastPasswordChangeDate	datetime	-	-
NumberOfFailedLogins	int	-	-
ForecastEnabled	boolean	-	-
ContactID	string	Contact → ID	-
AccountID	string	Account → ID	-
CallCenterID	string	-	-
Extension	string	-	-
FederationIdentifier	string	-	-
AboutMe	string	-	-
FullPhotoUrl	string	-	-
SmallPhotoUrl	string	-	-
MediumPhotoUrl	string	-	-
IsExtIndicatorVisible	boolean	-	-
OutOfOfficeMessage	string	-	-
DigestFrequency	string	-	-
DefaultGroupNotificationFrequency	string	-	-
JigsawImportLimitOverride	string	-	-
LastViewedDate	datetime	-	-
LastReferencedDate	datetime	-	-
BannerPhotoUrl	string	-	-
SmallBannerPhotoUrl	string	-	-
MediumBannerPhotoUrl	string	-	-
IsProfilePhotoActive	boolean	-	-
IndividualID	string	-	-
LastModifiedByID	string	User → ID	-
CreatedByID	string	User → ID	-
CreatedDate	datetime	-	-
OwnerID	string	User → ID	-
SystemModstamp	datetime	-	-
LastModifiedDate	datetime	-	-

AccountCustomFieldValue

Column	Type	Relates to	Notes
RemoteID	string	-	-
AccountRemoteID	string	Account → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
AccountID	string	Account → ID	-
CustomFieldTypeID	string	CustomFieldType → ID	-
StringValue	string	-	-
GeoLatitudeValue	decimal	-	-
GeoLongitudeValue	decimal	-	-
DecimalValue	decimal	-	-
DateTimeValue	datetime	-	-
IntValue	int	-	-
BoolValue	boolean	-	-

AssetCustomFieldValue

Column	Type	Relates to	Notes
RemoteID	string	-	-
AssetRemoteID	string	Asset → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
AssetID	string	Asset → ID	-
CustomFieldTypeID	string	CustomFieldType → ID	-
StringValue	string	-	-
GeoLatitudeValue	decimal	-	-
GeoLongitudeValue	decimal	-	-
DecimalValue	decimal	-	-
DateTimeValue	datetime	-	-
IntValue	int	-	-
BoolValue	boolean	-	-

CampaignCustomFieldValue

Column	Type	Relates to	Notes
RemoteID	string	-	-
CampaignRemoteID	string	Campaign → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
CampaignID	string	Campaign → ID	-
CustomFieldTypeID	string	CustomFieldType → ID	-
StringValue	string	-	-
GeoLatitudeValue	decimal	-	-
GeoLongitudeValue	decimal	-	-
DecimalValue	decimal	-	-
DateTimeValue	datetime	-	-
IntValue	int	-	-
BoolValue	boolean	-	-

CaseCustomFieldValue

Column	Type	Relates to	Notes
RemoteID	string	-	-
CaseRemoteID	string	Case → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
CaseID	string	Case → ID	-
CustomFieldTypeID	string	CustomFieldType → ID	-
StringValue	string	-	-
GeoLatitudeValue	decimal	-	-
GeoLongitudeValue	decimal	-	-
DecimalValue	decimal	-	-
DateTimeValue	datetime	-	-
IntValue	int	-	-
BoolValue	boolean	-	-

ContactCustomFieldValue

Column	Type	Relates to	Notes
RemoteID	string	-	-
ContactRemoteID	string	Contact → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ContactID	string	Contact → ID	-
CustomFieldTypeID	string	CustomFieldType → ID	-
StringValue	string	-	-
GeoLatitudeValue	decimal	-	-
GeoLongitudeValue	decimal	-	-
DecimalValue	decimal	-	-
DateTimeValue	datetime	-	-
IntValue	int	-	-
BoolValue	boolean	-	-

ContractCustomFieldValue

Column	Type	Relates to	Notes
RemoteID	string	-	-
ContractRemoteID	string	Contract → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ContractID	string	Contract → ID	-
CustomFieldTypeID	string	CustomFieldType → ID	-
StringValue	string	-	-
GeoLatitudeValue	decimal	-	-
GeoLongitudeValue	decimal	-	-
DecimalValue	decimal	-	-
DateTimeValue	datetime	-	-
IntValue	int	-	-
BoolValue	boolean	-	-

CustomObjectCustomFieldValue

Column	Type	Relates to	Notes
RemoteID	string	-	-
CustomObjectRemoteID	string	CustomObject → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
CustomObjectID	string	CustomObject → ID	-
CustomFieldTypeID	string	CustomFieldType → ID	-
StringValue	string	-	-
GeoLatitudeValue	decimal	-	-
GeoLongitudeValue	decimal	-	-
DecimalValue	decimal	-	-
DateTimeValue	datetime	-	-
IntValue	int	-	-
BoolValue	boolean	-	-

EventCustomFieldValue

Column	Type	Relates to	Notes
RemoteID	string	-	-
EventRemoteID	string	Event → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
EventID	string	Event → ID	-
CustomFieldTypeID	string	CustomFieldType → ID	-
StringValue	string	-	-
GeoLatitudeValue	decimal	-	-
GeoLongitudeValue	decimal	-	-
DecimalValue	decimal	-	-
DateTimeValue	datetime	-	-
IntValue	int	-	-
BoolValue	boolean	-	-

LeadCustomFieldValue

Column	Type	Relates to	Notes
RemoteID	string	-	-
LeadRemoteID	string	Lead → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
LeadID	string	Lead → ID	-
CustomFieldTypeID	string	CustomFieldType → ID	-
StringValue	string	-	-
GeoLatitudeValue	decimal	-	-
GeoLongitudeValue	decimal	-	-
DecimalValue	decimal	-	-
DateTimeValue	datetime	-	-
IntValue	int	-	-
BoolValue	boolean	-	-

OpportunityCustomFieldValue

Column	Type	Relates to	Notes
RemoteID	string	-	-
OpportunityRemoteID	string	Opportunity → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
OpportunityID	string	Opportunity → ID	-
CustomFieldTypeID	string	CustomFieldType → ID	-
StringValue	string	-	-
GeoLatitudeValue	decimal	-	-
GeoLongitudeValue	decimal	-	-
DecimalValue	decimal	-	-
DateTimeValue	datetime	-	-
IntValue	int	-	-
BoolValue	boolean	-	-

OrderCustomFieldValue

Column	Type	Relates to	Notes
RemoteID	string	-	-
OrderRemoteID	string	Order → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
OrderID	string	Order → ID	-
CustomFieldTypeID	string	CustomFieldType → ID	-
StringValue	string	-	-
GeoLatitudeValue	decimal	-	-
GeoLongitudeValue	decimal	-	-
DecimalValue	decimal	-	-
DateTimeValue	datetime	-	-
IntValue	int	-	-
BoolValue	boolean	-	-

OrderItemCustomFieldValue

Column	Type	Relates to	Notes
RemoteID	string	-	-
OrderItemRemoteID	string	OrderItem → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
OrderItemID	string	OrderItem → ID	-
CustomFieldTypeID	string	CustomFieldType → ID	-
StringValue	string	-	-
GeoLatitudeValue	decimal	-	-
GeoLongitudeValue	decimal	-	-
DecimalValue	decimal	-	-
DateTimeValue	datetime	-	-
IntValue	int	-	-
BoolValue	boolean	-	-

PricebookCustomFieldValue

Column	Type	Relates to	Notes
RemoteID	string	-	-
PricebookRemoteID	string	Pricebook → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
PricebookID	string	Pricebook → ID	-
CustomFieldTypeID	string	CustomFieldType → ID	-
StringValue	string	-	-
GeoLatitudeValue	decimal	-	-
GeoLongitudeValue	decimal	-	-
DecimalValue	decimal	-	-
DateTimeValue	datetime	-	-
IntValue	int	-	-
BoolValue	boolean	-	-

PricebookEntryCustomFieldValue

Column	Type	Relates to	Notes
RemoteID	string	-	-
PricebookEntryRemoteID	string	PricebookEntry → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
PricebookEntryID	string	PricebookEntry → ID	-
CustomFieldTypeID	string	CustomFieldType → ID	-
StringValue	string	-	-
GeoLatitudeValue	decimal	-	-
GeoLongitudeValue	decimal	-	-
DecimalValue	decimal	-	-
DateTimeValue	datetime	-	-
IntValue	int	-	-
BoolValue	boolean	-	-

ProductCustomFieldValue

Column	Type	Relates to	Notes
RemoteID	string	-	-
ProductRemoteID	string	Product → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ProductID	string	Product → ID	-
CustomFieldTypeID	string	CustomFieldType → ID	-
StringValue	string	-	-
GeoLatitudeValue	decimal	-	-
GeoLongitudeValue	decimal	-	-
DecimalValue	decimal	-	-
DateTimeValue	datetime	-	-
IntValue	int	-	-
BoolValue	boolean	-	-

TaskObjectCustomFieldValue

Column	Type	Relates to	Notes
RemoteID	string	-	-
TaskObjectRemoteID	string	TaskObject → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TaskObjectID	string	TaskObject → ID	-
CustomFieldTypeID	string	CustomFieldType → ID	-
StringValue	string	-	-
GeoLatitudeValue	decimal	-	-
GeoLongitudeValue	decimal	-	-
DecimalValue	decimal	-	-
DateTimeValue	datetime	-	-
IntValue	int	-	-
BoolValue	boolean	-	-

UserCustomFieldValue

Column	Type	Relates to	Notes
RemoteID	string	-	-
UserRemoteID	string	User → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
UserID	string	User → ID	-
CustomFieldTypeID	string	CustomFieldType → ID	-
StringValue	string	-	-
GeoLatitudeValue	decimal	-	-
GeoLongitudeValue	decimal	-	-
DecimalValue	decimal	-	-
DateTimeValue	datetime	-	-
IntValue	int	-	-
BoolValue	boolean	-	-