Explore the Pipedrive data model

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

Pulling data from Pipedrive 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 pull your Pipedrive 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.

Endpoints

Activity

Documentation: https://developers.pipedrive.com/docs/api/v1/#!/Activities

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Item string - -
CompanyID int - -
UserID int User → ID -
Done boolean - -
Type string - -
ReferenceType string - -
ReferenceID int - -
ConferenceMeetingClient string - -
ConferenceMeetingUrl string - -
DueDate datetime - -
DueTime datetime - -
Duration string - -
BusyFlag boolean - -
MarkedAsDoneTime datetime - -
LastNotificationTime datetime - -
LastNotificationUserID int User → ID -
NotificationLanguageID int - -
Subject string - -
PublicDescription string - -
CalendarSyncIncludeContext string - -
Location string - -
OrgID int Organization → ID -
PersonID int Person → ID -
DealID int Deal → ID -
LeadID guid - -
LeadTitle string - -
UpdateUserID int User → ID -
GcalEventID string - -
GoogleCalendarID string - -
GoogleCalendarEtag string - -
SourceTimezone string - -
RecRule string - -
RecRuleExtension string - -
RecMasterActivityID int - -
ConferenceMeetingID string - -
Note string - -
CreatedByUserID int User → ID -
LocationSubpremise string - -
LocationStreetNumber string - -
LocationRoute string - -
LocationSublocality string - -
LocationLocality string - -
LocationAdminAreaLevel1 string - -
LocationAdminAreaLevel2 string - -
LocationCountry string - -
LocationPostalCode string - -
LocationFormattedAddress string - -
OrgName string - -
PersonName string - -
DealTitle string - -
OwnerName string - -
PersonDropboxBcc string - -
DealDropboxBcc string - -
AssignedToUserID int User → ID -
FileID int File → ID -
AddTime datetime - -
UpdateTime datetime - -
ActiveFlag boolean - -

ActivityParticipant

Column Type Relates to Notes
RemoteID string - -
ActivityRemoteID string Activity → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PersonID int Person → ID -
PrimaryFlag boolean - -
ActivityID int Activity → ID -

ActivityType

Documentation: https://developers.pipedrive.com/docs/api/v1/#!/ActivityTypes

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
OrderNr int - -
KeyString string - -
IconKey string - -
Color string - -
IsCustomFlag boolean - -
AddTime datetime - -
UpdateTime datetime - -
ActiveFlag boolean - -

Deal

Documentation: https://developers.pipedrive.com/docs/api/v1/#!/Deals

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
CreatorUserID int User → ID -
UserID int User → ID -
PersonID int Person → ID -
OrgID int Organization → ID -
StageID int Stage → ID -
Title string - -
Value decimal - -
Currency string - -
StageChangeTime datetime - -
Active boolean - -
Deleted boolean - -
Status string - -
Probability string - -
NextActivityDate datetime - -
NextActivityTime datetime - -
NextActivityID int Activity → ID -
LastActivityID int Activity → ID -
LastActivityDate datetime - -
LostReason string - -
VisibleTo string - -
CloseTime datetime - -
PipelineID int Pipeline → ID -
WonTime datetime - -
FirstWonTime datetime - -
LostTime datetime - -
ProductsCount int - -
FilesCount int - -
NotesCount int - -
FollowersCount int - -
EmailMessagesCount int - -
ActivitiesCount int - -
DoneActivitiesCount int - -
UndoneActivitiesCount int - -
ParticipantsCount int - -
ExpectedCloseDate datetime - -
LastIncomingMailTime datetime - -
LastOutgoingMailTime datetime - -
Label string - -
RenewalType string - -
StageOrderNr int - -
PersonName string - -
OrgName string - -
NextActivitySubject string - -
NextActivityType string - -
NextActivityDuration string - -
NextActivityNote string - -
FormattedValue string - -
WeightedValue decimal - -
FormattedWeightedValue string - -
WeightedValueCurrency string - -
RottenTime datetime - -
OwnerName string - -
CcEmail string - -
OrgHidden boolean - -
PersonHidden boolean - -
AverageStageProgress int - -
LastActivity string - -
AddTime datetime - -
UpdateTime datetime - -
ActiveFlag boolean - -

File

Documentation: https://developers.pipedrive.com/docs/api/v1/#!/Files

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
Description string - -
UserID int User → ID -
DealID int Deal → ID -
PersonID int Person → ID -
OrgID int Organization → ID -
ProductID int Product → ID -
ActivityID int Activity → ID -
LogID int - -
FileName string - -
FileType string - -
FileSize decimal - -
InlineFlag boolean - -
RemoteLocation string - -
FileRemoteID string - -
Cid string - -
S3Bucket string - -
MailMessageID string - -
MailTemplateID string - -
DealName string - -
PersonName string - -
PeopleName string - -
OrgName string - -
ProductName string - -
Url string - -
AddTime datetime - -
UpdateTime datetime - -
ActiveFlag boolean - -

Note

Documentation: https://developers.pipedrive.com/docs/api/v1/#!/Notes

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
UserID int User → ID -
DealID int Deal → ID -
PersonID int Person → ID -
OrgID int Organization → ID -
Content string - -
PinnedToDealFlag boolean - -
PinnedToPersonFlag boolean - -
PinnedToOrganizationFlag boolean - -
LastUpdateUserID int User → ID -
AddTime datetime - -
UpdateTime datetime - -
ActiveFlag boolean - -

Person

Documentation: https://developers.pipedrive.com/docs/api/v1/#!/Persons

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
CompanyID int - -
OwnerID int User → ID -
OrgID int Organization → ID -
FirstName string - -
LastName string - -
OpenDealsCount int - -
RelatedOpenDealsCount int - -
ClosedDealsCount int - -
RelatedClosedDealsCount int - -
ParticipantOpenDealsCount int - -
ParticipantClosedDealsCount int - -
EmailMessagesCount int - -
ActivitiesCount int - -
DoneActivitiesCount int - -
UndoneActivitiesCount int - -
FilesCount int - -
NotesCount int - -
FollowersCount int - -
WonDealsCount int - -
RelatedWonDealsCount int - -
LostDealsCount int - -
RelatedLostDealsCount int - -
FirstChar string - -
VisibleTo string - -
PictureID int - -
NextActivityDate datetime - -
NextActivityTime datetime - -
NextActivityID int Activity → ID -
LastActivityID int Activity → ID -
LastActivityDate datetime - -
LastIncomingMailTime datetime - -
LastOutgoingMailTime datetime - -
Label string - -
OrgName string - -
CcEmail string - -
OwnerName string - -
AddTime datetime - -
UpdateTime datetime - -
ActiveFlag boolean - -

PersonPhone

Column Type Relates to Notes
RemoteID string - -
PersonRemoteID string Person → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Label string - -
Value string - -
Primary boolean - -
PersonID int Person → ID -
SortOrder int - -

PersonEmail

Column Type Relates to Notes
RemoteID string - -
PersonRemoteID string Person → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Label string - -
Value string - -
Primary boolean - -
PersonID int Person → ID -
SortOrder int - -

User

Documentation: https://developers.pipedrive.com/docs/api/v1/#!/Users

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
ActiveFlag boolean - -
DefaultCurrency string - -
TimezoneName string - -
TimezoneOffset string - -
Locale string - -
Email string - -
Phone string - -
Created datetime - -
Modified datetime - -
Lang int - -
IsAdmin int - -
LastLogin datetime - -
SignupFlowVariation string - -
RoleID int - -
HasCreatedCompany boolean - -
Activated boolean - -
IconUrl string - -

Pipeline

Documentation: https://developers.pipedrive.com/docs/api/v1/#!/Pipelines

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
UrlTitle string - -
OrderNr int - -
Active boolean - -
DealProbability boolean - -
Selected boolean - -
AddTime datetime - -
UpdateTime datetime - -
ActiveFlag boolean - -

Product

Documentation: https://developers.pipedrive.com/docs/api/v1/#!/Products

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
Description string - -
Code string - -
Unit string - -
Tax decimal - -
Category string - -
Selectable boolean - -
FirstChar string - -
VisibleTo string -
  • 20 Nov 2020 1 = Owners & followers, 3 = Entire company, NULL = inherit from parent
OwnerID int User → ID -
FilesCount int - -
FollowersCount int - -
AddTime datetime - -
UpdateTime datetime - -
ActiveFlag boolean - -

Stage

Documentation: https://developers.pipedrive.com/docs/api/v1/#!/Stages

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
OrderNr int - -
DealProbability int - -
PipelineID int Pipeline → ID -
RottenFlag boolean - -
RottenDays int - -
PipelineDealProbability boolean - -
AddTime datetime - -
UpdateTime datetime - -
ActiveFlag boolean - -

Organization

Documentation: https://developers.pipedrive.com/docs/api/v1/#!/Organizations

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
CompanyID int - -
OwnerID int - -
OpenDealsCount int - -
RelatedOpenDealsCount int - -
ClosedDealsCount int - -
RelatedClosedDealsCount int - -
EmailMessagesCount int - -
PeopleCount int - -
ActivitiesCount int - -
DoneActivitiesCount int - -
UndoneActivitiesCount int - -
FilesCount int - -
NotesCount int - -
FollowersCount int - -
WonDealsCount int - -
RelatedWonDealsCount int - -
LostDealsCount int - -
RelatedLostDealsCount int - -
CategoryID int - -
PictureID int - -
CountryCode string - -
FirstChar string - -
VisibleTo string - -
NextActivityDate datetime - -
NextActivityTime datetime - -
NextActivityID int Activity → ID -
LastActivityID int Activity → ID -
LastActivityDate datetime - -
Label string - -
Address string - -
AddressSubpremise string - -
AddressStreetNumber string - -
AddressRoute string - -
AddressSublocality string - -
AddressLocality string - -
AddressAdminAreaLevel1 string - -
AddressAdminAreaLevel2 string - -
AddressCountry string - -
AddressPostalCode string - -
AddressFormattedAddress string - -
CcEmail string - -
OwnerName string - -
EditName boolean - -
AddTime datetime - -
UpdateTime datetime - -
ActiveFlag boolean - -

ProductPrice

Column Type Relates to Notes
RemoteID string - -
ProductRemoteID string Product → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
ProductID int Product → ID -
Price decimal - -
Currency string - -
Cost decimal - -
OverheadCost decimal - -

DealCustomField

Documentation: https://developers.pipedrive.com/docs/api/v1/#!/DealFields

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int -
  • 21 Jan 2021 The ID field is empty for sub-fields (e.g. date_until, address_city, etc)
Name string - -
Key string -
  • 21 Jan 2021 The key field is present on all fields, and unique for each type (deal, person, etc). For built-in fields, it is a word like 'status' or 'datetime'. But for custom fields, it is a GUID. If the custom field has a sub-property, such as address_city, then this key is in the format [parentguid]_city.
OrderNr int - -
FieldType string - -
AddTime datetime - -
UpdateTime datetime - -
LastUpdatedByUserID int - -
ActiveFlag boolean - -
IsSubfield boolean - -

DealCustomFieldOption

Column Type Relates to Notes
RemoteID string - -
DealCustomFieldRemoteID string DealCustomField → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string -
  • 21 Jan 2021 The id field is of type string for e.g. the 'status' type. For non-system types, it is a unique ascending integer value
DealCustomFieldKey string DealCustomField → Key -
Label string - -

DealCustomFieldValue

Column Type Relates to Notes
RemoteID string - -
DealRemoteID string Deal → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DealCustomFieldKey string DealCustomField → Key -
DealID int Deal → ID -

DealCustomFieldValueOption

Column Type Relates to Notes
RemoteID string - -
DealCustomFieldValueRemoteID string DealCustomFieldValue → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DealCustomFieldOptionID string DealCustomFieldOption → ID
  • 21 Jan 2021 Most field values are just a string (ie. the actual value), but some (e.g. multi-choice / set) have the ID field provided
Value string - -
OrganisationID int Organization → ID -
PersonID int Person → ID -
UserID int User → ID
  • 15 Jan 2020 The options are denormalized - raw values, or foreign keys to complex entities such as Person or Organisation
TimezoneID int - -

OrganizationCustomField

Documentation: https://developers.pipedrive.com/docs/api/v1/#!/OrganizationFields

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int -
  • 21 Jan 2021 The ID field is empty for sub-fields (e.g. date_until, address_city, etc)
Name string - -
Key string -
  • 21 Jan 2021 The key field is present on all fields, and unique for each type (deal, person, etc). For built-in fields, it is a word like 'status' or 'datetime'. But for custom fields, it is a GUID. If the custom field has a sub-property, such as address_city, then this key is in the format [parentguid]_city.
OrderNr int - -
FieldType string - -
AddTime datetime - -
UpdateTime datetime - -
LastUpdatedByUserID int - -
ActiveFlag boolean - -
IsSubfield boolean - -

OrganizationCustomFieldOption

Column Type Relates to Notes
RemoteID string - -
OrganizationCustomFieldRemoteID string OrganizationCustomField → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string -
  • 21 Jan 2021 The id field is of type string for e.g. the 'status' type. For non-system types, it is a unique ascending integer value
OrganizationCustomFieldKey string OrganizationCustomField → Key -
Label string - -

OrganizationCustomFieldValue

Column Type Relates to Notes
RemoteID string - -
OrganizationRemoteID string Organization → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
OrganizationCustomFieldKey string OrganizationCustomField → Key -
OrganizationID int Organization → ID -

OrganizationCustomFieldValueOption

Column Type Relates to Notes
RemoteID string - -
OrganizationCustomFieldValueRemoteID string OrganizationCustomFieldValue → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
OrganizationCustomFieldOptionID string OrganizationCustomFieldOption → ID
  • 29 Jan 2021 Most field values are just a string (ie. the actual value), but some (e.g. multi-choice / set) have the ID field provided
Value string - -
OrganisationID int Organization → ID -
PersonID int Person → ID -
UserID int User → ID
  • 29 Jan 2021 The options are denormalized - raw values, or foreign keys to complex entities such as Person or Organisation
TimezoneID int - -

PersonCustomField

Documentation: https://developers.pipedrive.com/docs/api/v1/#!/PersonFields

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int -
  • 21 Jan 2021 The ID field is empty for sub-fields (e.g. date_until, address_city, etc)
Name string - -
Key string -
  • 21 Jan 2021 The key field is present on all fields, and unique for each type (deal, person, etc). For built-in fields, it is a word like 'status' or 'datetime'. But for custom fields, it is a GUID. If the custom field has a sub-property, such as address_city, then this key is in the format [parentguid]_city.
OrderNr int - -
FieldType string - -
AddTime datetime - -
UpdateTime datetime - -
LastUpdatedByUserID int - -
ActiveFlag boolean - -
IsSubfield boolean - -

PersonCustomFieldOption

Column Type Relates to Notes
RemoteID string - -
PersonCustomFieldRemoteID string PersonCustomField → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string -
  • 21 Jan 2021 The id field is of type string for e.g. the 'status' type. For non-system types, it is a unique ascending integer value
PersonCustomFieldKey string PersonCustomField → Key -
Label string - -

PersonCustomFieldValue

Column Type Relates to Notes
RemoteID string - -
PersonRemoteID string Person → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PersonCustomFieldKey string PersonCustomField → Key -
PersonID int Person → ID -

PersonCustomFieldValueOption

Column Type Relates to Notes
RemoteID string - -
PersonCustomFieldValueRemoteID string PersonCustomFieldValue → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PersonCustomFieldOptionID string PersonCustomFieldOption → ID
  • 10 Feb 2021 Most field values are just a string (ie. the actual value), but some (e.g. multi-choice / set) have the ID field provided
Value string - -
OrganisationID int Organization → ID -
PersonID int Person → ID -
UserID int User → ID
  • 10 Feb 2021 The options are denormalized - raw values, or foreign keys to complex entities such as Person or Organisation
TimezoneID int - -

DealModificationHistory

Documentation: https://developers.pipedrive.com/docs/api/v1/#!/Deals/getDealUpdates

Column Type Relates to Notes
RemoteID string - -
DealRemoteID string Deal → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
ItemID int - -
DealID int Deal → ID -
UserID int User → ID -
FieldKey string - -
OldValue string - -
NewValue string - -
IsBulkUpdateFlag boolean - -
LogTime datetime - -
ChangeSource string - -
ChangeSourceUserAgent string - -
AddTime datetime - -
UpdateTime datetime - -
ActiveFlag boolean - -

Lead

Documentation: https://developers.pipedrive.com/docs/api/v1/Leads#getLeads

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Title string - -
Amount decimal - -
Currency string - -
CreatorID int User → ID -
OwnerID int User → ID -
ExpectedCloseDate datetime - -
VisibleTo string -
  • 30 Apr 2022 Possible values differ according to Pipedrive plan type
PersonID int Person → ID -
OrganizationID int Organization → ID -
SourceName string - -
WasSeen boolean - -
NextActivityID int Activity → ID -
LastActivityID int Activity → ID -
AddTime datetime - -
UpdateTime datetime - -
IsArchived boolean - -

LeadCustomFieldValue

Column Type Relates to Notes
RemoteID string - -
LeadRemoteID string Lead → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DealCustomFieldKey string DealCustomField → Key
  • 30 Jul 2021 Lead custom fields are leveraged from the Deals custom fields
LeadID guid Lead → ID -

LeadCustomFieldValueOption

Column Type Relates to Notes
RemoteID string - -
LeadCustomFieldValueRemoteID string LeadCustomFieldValue → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
LeadCustomFieldOptionID string DealCustomFieldOption → ID
  • 30 Jul 2021 Lead custom fields are leveraged from the Deals custom fields
Value string - -
OrganisationID int Organization → ID -
PersonID int Person → ID -
UserID int User → ID
  • 15 Jan 2020 The options are denormalized - raw values, or foreign keys to complex entities such as Person or Organisation
TimezoneID int - -

DealProduct

Documentation: https://developers.pipedrive.com/docs/api/v1/Deals#getDealProducts

Column Type Relates to Notes
RemoteID string - -
DealRemoteID string Deal → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
DealID int Deal → ID -
ProductID int Product → ID -
OrderNr string - -
ProductVariationID int - -
ItemPrice decimal - -
DiscountPercentage decimal - -
Duration decimal - -
DurationUnit string - -
SumNoDiscount decimal - -
Sum decimal - -
Currency string - -
EnabledFlag boolean - -
LastEdit datetime - -
Comments string - -
Tax decimal - -
SumFormatted string - -
QuantityFormatted string - -
Quantity decimal - -
AddTime datetime - -
UpdateTime datetime - -
ActiveFlag boolean - -

Subscription

Documentation: https://developers.pipedrive.com/docs/api/v1/Subscriptions

Column Type Relates to Notes
RemoteID string - -
DealRemoteID string Deal → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Description string - -
UserID int User → ID -
DealID int Deal → ID -
IsActive boolean - -
CycleAmount decimal - -
CyclesCount decimal - -
Infinite boolean - -
Currency string - -
StartDate datetime - -
EndDate datetime - -
LifetimeValue decimal - -
CadenceType string - -
FinalStatus string - -
AddTime datetime - -
UpdateTime datetime - -
ActiveFlag boolean - -

SubscriptionPayment

Documentation: https://developers.pipedrive.com/docs/api/v1/Subscriptions

Column Type Relates to Notes
RemoteID string - -
SubscriptionRemoteID string Subscription → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Description string - -
SubscriptionID int Subscription → ID -
DealID int Deal → ID -
IsActive boolean - -
Amount decimal - -
Currency string - -
ChangeAmount decimal - -
DueAt datetime - -
RevenueMovementType string - -
PaymentType string - -
AddTime datetime - -
UpdateTime datetime - -
ActiveFlag boolean - -

LeadLabel

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Name string - -
Color string - -
AddTime datetime - -
UpdateTime datetime - -

LeadLabelValue

Column Type Relates to Notes
RemoteID string - -
LeadRemoteID string Lead → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
LeadLabelID guid LeadLabel → ID
  • 30 Jul 2021 Lead custom fields are leveraged from the Deals custom fields
LeadID guid Lead → ID -

Need more?

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