Explore the Pipedrive API data model

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

Activity

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

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
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	-	-

ActivityType

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

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
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	-	-

DealCustomField

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

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
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	-	-

OrganizationCustomField

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

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
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	-	-

PersonCustomField

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

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
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	-	-

Deal

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

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	int	-	-
AddTime	datetime	-	-
UpdateTime	datetime	-	-
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	-	-
IsArchived	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	long	-	-
FilesCount	int	-	-
NotesCount	int	-	-
FollowersCount	int	-	-
EmailMessagesCount	int	-	-
ActivitiesCount	int	-	-
DoneActivitiesCount	int	-	-
UndoneActivitiesCount	int	-	-
ParticipantsCount	int	-	-
ExpectedCloseDate	datetime	-	-
LastIncomingMailTime	datetime	-	-
LastOutgoingMailTime	datetime	-	-
Label	string	-	7 Dec 2022 If a single label is specified, we have the ID of the created label. If the deal has multiple labels, the IDs are comma-separated
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	-	-

DealModificationHistory

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

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

DealProduct

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

Column	Type	Relates to	Notes
RemoteID	string	-	-
DealRemoteID	string	Deal → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	int	-	-
Name	string	-	-
DealID	int	Deal → ID	-
ProductID	int	Product → ID	7 Sep 2023 We have observed records coming from PD with a null product_id value. This doesn't make sense, as it is supposed to be a deal-product relationship, however the rest of the data looks fine. Perhaps it relates to deleted products?
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	-	-

File

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

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
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	-	-

Lead

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

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
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	-	-

LeadLabel

Documentation: https://developers.pipedrive.com/docs/api/v1/LeadLabels#getLeadLabels

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

Note

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

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
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	-	-

Organization

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

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
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	-	-

Person

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

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
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	-	-

Pipeline

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

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
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	-	-

Product

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

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
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	-	-
WhenUpsertedIntoDataStore	datetime	-	-
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	-	-

SubscriptionPayment

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

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

User

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

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	int	-	-
Name	string	-	-
ActiveFlag	boolean	-	-
DefaultCurrency	string	-	-
TimezoneName	string	-	-
TimezoneOffset	string	-	-
Locale	string	-	-
Email	string	-	-
Created	datetime	-	-
Modified	datetime	-	7 Sep 2022 In Sep 2022, Pipedrive made the User.modified field available only to those with 'account settings access'
Lang	int	-	-
LastLogin	datetime	-	-
RoleID	int	-	-
HasCreatedCompany	boolean	-	-
Activated	boolean	-	-
IconUrl	string	-	-

ActivityParticipant

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

DealCustomFieldOption

Column	Type	Relates to	Notes
RemoteID	string	-	-
DealCustomFieldRemoteID	string	DealCustomField → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
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	-	-

OrganizationCustomFieldOption

Column	Type	Relates to	Notes
RemoteID	string	-	-
OrganizationCustomFieldRemoteID	string	OrganizationCustomField → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
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	-	-

PersonCustomFieldOption

Column	Type	Relates to	Notes
RemoteID	string	-	-
PersonCustomFieldRemoteID	string	PersonCustomField → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
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	-	-

DealCustomFieldValue

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

LeadCustomFieldValue

Column	Type	Relates to	Notes
RemoteID	string	-	-
LeadRemoteID	string	Lead → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
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	-

LeadLabelValue

Column	Type	Relates to	Notes
RemoteID	string	-	-
LeadRemoteID	string	Lead → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
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	-

OrganizationCustomFieldValue

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

PersonCustomFieldValue

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

PersonPhone

Column	Type	Relates to	Notes
RemoteID	string	-	-
PersonRemoteID	string	Person → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
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	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
Label	string	-	-
Value	string	-	-
Primary	boolean	-	-
PersonID	int	Person → ID	-
SortOrder	int	-	-

ProductPrice

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

DealCustomFieldValueOption

Column	Type	Relates to	Notes
RemoteID	string	-	-
DealCustomFieldValueRemoteID	string	DealCustomFieldValue → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
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	-	-

LeadCustomFieldValueOption

Column	Type	Relates to	Notes
RemoteID	string	-	-
LeadCustomFieldValueRemoteID	string	LeadCustomFieldValue → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
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	-	-

OrganizationCustomFieldValueOption

Column	Type	Relates to	Notes
RemoteID	string	-	-
OrganizationCustomFieldValueRemoteID	string	OrganizationCustomFieldValue → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
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	-	-

PersonCustomFieldValueOption

Column	Type	Relates to	Notes
RemoteID	string	-	-
PersonCustomFieldValueRemoteID	string	PersonCustomFieldValue → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
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	-	-