Explore the Salesforce API data model

See how the various Salesforce endpoints relate to each other, using our handy Entity Relationship Diagram

Free trial Book a demo

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.

What can you do with your Salesforce data?

Connect your AI chatbots & agentic workflows

Our Universal MCP Server lets you query your Salesforce data using Claude, ChatGPT or your favourite AI tool.

Empower your BI dashboards

Our Salesforce Connector connects your Salesforce data to favourite reporting tools.

Your business runs on more than just Salesforce

We connect to over over 70+ cloud services, letting you manage the data needs of your entire business in a single location.

Endpoints

Browse the data model below, or if you'd prefer, we also have an interactive ERD over here.

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 - -

OpportunityLineItem

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
LastViewedDate datetime - -
LastReferencedDate datetime - -
OpportunityID string Opportunity → ID -
PricebookEntryID string PricebookEntry → ID -
Product2ID string Product → ID -
TotalPrice decimal - -
ListPrice decimal - -
UnitPrice decimal - -
ProductCode string - -
SortOrder int - -
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 - -

Quote

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Name string - -
Description string - -
LastViewedDate datetime - -
LastReferencedDate datetime - -
OpportunityID string Opportunity → ID -
Pricebook2ID string Pricebook → ID -
ContactID string Contact → ID -
ContractID string Contract → ID -
AccountID string Account → ID -
QuoteNumber string - -
Status string - -
IsSyncing boolean - -
Subtotal decimal - -
TotalPrice decimal - -
LineItemCount int - -
ExpirationDate string - -
BillingStreet string - -
BillingCity string - -
BillingState string - -
BillingPostalCode string - -
BillingCountry string - -
BillingLatitude decimal - -
BillingLongitude decimal - -
BillingGeocodeAccuracy string - -
ShippingStreet string - -
ShippingCity string - -
ShippingState string - -
ShippingPostalCode string - -
ShippingCountry string - -
ShippingLatitude decimal - -
ShippingLongitude decimal - -
ShippingGeocodeAccuracy string - -
QuoteToStreet string - -
QuoteToCity string - -
QuoteToState string - -
QuoteToPostalCode string - -
QuoteToCountry string - -
QuoteToLatitude decimal - -
QuoteToLongitude decimal - -
QuoteToGeocodeAccuracy string - -
AdditionalStreet string - -
AdditionalCity string - -
AdditionalState string - -
AdditionalPostalCode string - -
AdditionalCountry string - -
AdditionalLatitude decimal - -
AdditionalLongitude decimal - -
AdditionalGeocodeAccuracy string - -
BillingName string - -
ShippingName string - -
QuoteToName string - -
AdditionalName string - -
Email string - -
Phone string - -
Fax string - -
Discount decimal - -
GrandTotal decimal - -
CanCreateQuoteLineItems boolean - -
LastModifiedByID string User → ID -
CreatedByID string User → ID -
CreatedDate datetime - -
OwnerID string User → ID -
SystemModstamp datetime - -
LastModifiedDate datetime - -

QuoteLineItem

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
LastViewedDate datetime - -
LastReferencedDate datetime - -
QuoteID string Quote → ID -
PricebookEntryID string PricebookEntry → ID -
OpportunityLineItemID string OpportunityLineItem → ID -
Product2ID string Product → ID -
Quantity decimal - -
UnitPrice decimal - -
ListPrice decimal - -
TotalPrice decimal - -
Subtotal decimal - -
Discount decimal - -
SortOrder int - -
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 - -

OpportunityLineItemCustomFieldValue

Column Type Relates to Notes
RemoteID string - -
OpportunityLineItemRemoteID string OpportunityLineItem → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
OpportunityLineItemID string OpportunityLineItem → 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 - -

QuoteCustomFieldValue

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

QuoteLineItemCustomFieldValue

Column Type Relates to Notes
RemoteID string - -
QuoteLineItemRemoteID string QuoteLineItem → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
QuoteLineItemID string QuoteLineItem → 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 - -

Need more?

SYNCHUB lives and breathes APIs and data. Keep exploring using the links below.

Connect your own Salesforce data Querying Salesforce using regular SQL