Explore the Prospect CRM API data model

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

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

Address

Documentation: https://apidocs.prospect365.com/#/Get%20Endpoints/Addresses_Get

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
Description	string	-	-
AddressID	long	-	-
CreatedByUserID	string	User → UserCode	-
LastUpdatedByUserID	string	User → UserCode	-
AddressLine1	string	-	-
AddressLine2	string	-	-
AddressLine3	string	-	-
AddressLine4	string	-	-
AddressLine5	string	-	-
Country	string	-	-
Postcode	string	-	-
PostCodeType	string	-	-
RegionNumber	string	-	-
Outcode	string	-	-
PostcodeRegion	string	-	-
AddressBlock	string	-	-
Latitude	decimal	-	-
Longitude	decimal	-	-
Created	datetime	-	-
LastUpdated	datetime	-	-

Campaign

Documentation: https://apidocs.prospect365.com/#/Common%20Endpoints/Campaigns_Get

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
Description	string	-	-
CampaignID	long	-	-
StartDate	datetime	-	-
EndDate	datetime	-	-
TotalBudget	decimal	-	-
DetailedDescription	string	-	-
SystemObjectsKey	string	-	-
SearchTerms	string	-	-
RecordLink	string	-	-
ManagedByID	string	User → UserCode	-
LastUpdatedByUserID	string	User → UserCode	-
CreatedByUserID	string	User → UserCode	-
StatusFlag	string	-	-
Created	datetime	-	-
LastUpdated	datetime	-	-

CampaignActivity

Documentation: https://apidocs.prospect365.com/#/Common%20Endpoints/CampaignActivities_Get

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
Description	string	-	-
CampaignActivityID	long	-	-
CampaignID	long	Campaign → CampaignID	-
TargetStartDate	datetime	-	-
TargetEndDate	datetime	-	-
ActualStartDate	datetime	-	-
ActualEndDate	datetime	-	-
Cost	decimal	-	-
ObjectiveSummary	string	-	-
DetailedDescription	string	-	-
ActivityTypeID	string	-	-
SystemObjectsKey	string	-	-
SearchTerms	string	-	-
RecordLink	string	-	-
Analysis1	string	-	-
FilterRoleCodes	string	-	-
FilterProfile	string	-	-
FilterMailFlag	int	-	-
FilterFaxFlag	int	-	-
FilterEmailFlag	int	-	-
FilterSwapFlag	int	-	-
FilterEmailAddFlag	int	-	-
FilterWithLeads	int	-	-
FilterWithLeadsForCampaign	int	-	-
FilterWithLeadsForActivity	int	-	-
FilterWithoutLeads	int	-	-
FilterWithoutLeadsForCampaign	int	-	-
FilterWithoutLeadsForActivity	int	-	-
FilterLeftCompanyFlag	int	-	-
FilterEmailBounceFlag	int	-	-
FilterQuarantinedFlag	int	-	-
FilterNumberOfContacts	int	-	-
FilterOptIn	int	-	-
FilterMailchimp	int	-	-
MailchimpCampaignID	string	-	-
MailchimpTag	string	-	-
MailchimpSyncTime	datetime	-	-
CreatedFromActivityID	long	-	-
ExcludedActivityID	long	-	-
ManagedByID	string	User → UserCode	-
LastUpdatedByUserID	string	User → UserCode	-
CreatedByUserID	string	User → UserCode	-
StatusFlag	string	-	-
Created	datetime	-	-
LastUpdated	datetime	-	-

Company

Documentation: https://apidocs.prospect365.com/#/Common%20Endpoints/Companies_Get

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
Name	string	-	-
CompanyID	long	-	-
AccountManagerID	string	User → UserCode	-
LastUpdatedByUserID	string	User → UserCode	-
CreatedByUserID	string	User → UserCode	-
MergedWith	long	Company → CompanyID	-
TypeID	string	-	-
SystemObjectsKey	string	-	-
Source	string	-	-
Soundex	long	-	-
AlternateReference	string	-	-
SearchTerms	string	-	-
LongDescription	string	-	-
FirstOrder	datetime	-	-
Lapsed	datetime	-	-
Unlapsed	datetime	-	-
CombinedEntity	string	-	-
ImportSourceRunID	long	-	-
RequirePORef	boolean	-	-
RecordLink	string	-	-
SystemSearchTerms	string	-	-
StatusFlag	string	-	-
Created	datetime	-	-
LastUpdated	datetime	-	-

Contact

Documentation: https://apidocs.prospect365.com/#/Common%20Endpoints/Contacts_Get

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ContactID	long	-	-
DivisionID	long	Division → DivisionID	-
AddressID	long	Address → AddressID	-
MainAddressID	long	Address → AddressID	-
DeliveryAddressID	long	Address → AddressID	-
Individual	int	-	-
RoleCode	string	-	-
Title	string	-	-
Forename	string	-	-
Surname	string	-	-
PreferredName	string	-	-
Salutation	string	-	-
JobTitle	string	-	-
Department	string	-	-
PhoneNumber	string	-	-
Fax	string	-	-
Email	string	-	-
EmailBounced	int	-	-
SecretaryName	string	-	-
SecretaryPhone	string	-	-
SecretaryEmail	string	-	-
MailFlag	int	-	-
FaxFlag	int	-	-
EmailFlag	int	-	-
SwapFlag	int	-	-
SpokeCode	string	-	-
SpokeDateTime	datetime	-	-
SurnameSoundex	int	-	-
ForenameSoundex	int	-	-
Source	string	-	-
AlternateReference	string	-	-
SearchTerms	string	-	-
CreatedByUserID	string	User → UserCode	-
LastUpdatedByUserID	string	User → UserCode	-
SystemObjectsKey	string	-	-
SearchCached	int	-	-
OptIn	int	-	-
MobilePhoneNumber	string	-	-
ImportSourceRunID	int	-	-
RecordLink	string	-	-
SystemSearchTerms	string	-	-
KlaviyoID	string	-	-
MergedWith	long	Contact → ContactID	-
AccountsID	string	-	-
SyncFieldHash	string	-	-
LastSyncError	string	-	-
NextTaskID	long	Task → TaskID	-
LastActivity	datetime	-	-
StatusFlag	string	-	-
Created	datetime	-	-
LastUpdated	datetime	-	-

Division

Documentation: https://apidocs.prospect365.com/#/Common%20Endpoints/Divisions_Get

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
Name	string	-	-
DivisionID	long	-	-
LastUpdatedByUserID	string	User → UserCode	-
CreatedByUserID	string	User → UserCode	-
CompanyID	long	Company → CompanyID	-
AddressID	long	Address → AddressID	-
MainAddressID	long	Address → AddressID	-
DeliveryAddressID	long	Address → AddressID	-
HiddenContactID	long	Contact → ContactID	-
NextTaskID	long	Task → TaskID	-
AccountManager	string	User → UserCode	-
MergedWith	long	Division → DivisionID	-
OperatingCompanyCode	string	-	-
SalesLedgerID	string	-	-
PhoneNumber	string	-	-
Fax	string	-	-
Employees	int	-	-
TurnoverID	string	-	-
StandardIndustryCode	string	-	-
Relationship	string	-	-
Website	string	-	-
LimitedID	string	-	-
FiscalYear	datetime	-	-
LastVerified	datetime	-	-
PriorityID	long	-	-
PurchaseLedgerID	string	-	-
MyStoreHideOtherCategories	int	-	-
UseSharedBaskets	int	-	-
TemporaryTaxCode	string	-	-
TemporaryCountryCode	string	-	-
TemporaryVatRegistrationCode	string	-	-
SystemObjectsKey	string	-	-
WowPermalink	string	-	-
Source	string	-	-
CashVatRegistrationCode	string	-	-
NameSoundex	long	-	-
AlternateReference	string	-	-
SearchTerms	string	-	-
SearchCached	int	-	-
LongDescription	string	-	-
CurrencyCode	string	-	-
Locale	string	-	-
DeliveryZoneCode	string	-	-
FirstActiveEngagement	datetime	-	-
LastActiveEngagement	datetime	-	-
EngagementDue	datetime	-	-
LastActivity	datetime	-	-
CustomerType	string	-	-
CombinedEntity	string	-	-
ImportSourceRunID	long	-	-
ExcludeRFMFlag	boolean	-	-
TerritoryCode	string	-	-
IsB2C	int	-	-
IsDistributor	boolean	-	-
RecordLink	string	-	-
SystemSearchTerms	string	-	-
SyncFieldHash	string	-	-
WebsiteDomain	string	-	-
StatusFlag	string	-	-
Created	datetime	-	-
LastUpdated	datetime	-	-

Document

Documentation: https://apidocs.prospect365.com/#/Common%20Endpoints/Documents_Get

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
Description	string	-	-
DocumentID	long	-	-
FileName	string	-	-
ContactID	long	Contact → ContactID	-
DivisionID	long	Division → DivisionID	-
LeadID	long	Lead → LeadID	-
ProblemID	long	Problem → ProblemID	-
OriginalDocumentID	long	Document → DocumentID	-
QuoteID	long	Quote → QuoteID	-
TaskID	long	Task → TaskID	-
MailMergeID	long	-	-
ContractScheduleID	long	-	-
InventoryID	long	-	-
AutomationStepID	long	-	-
DocumentTypeCode	string	-	-
Email	int	-	-
ShowOnWeb	int	-	-
StorageType	int	-	-
Direction	int	-	-
SaveConversation	int	-	-
SearchText	string	-	-
EmailSubject	string	-	-
ToAddress	string	-	-
ToAddresses	string	-	-
FromAddress	string	-	-
CcAddresses	string	-	-
BccAddresses	string	-	-
Attachments	string	-	-
OriginalFileFullPath	string	-	-
FileExtension	string	-	-
ContentPreview	string	-	-
Locale	string	-	-
EmailHash	string	-	-
Priority	int	-	-
HtmlContent	string	-	-
EmailMessageID	string	-	-
EmailStatus	string	-	-
PreviewImage	string	-	-
PreviewLabel	string	-	-
PreviewHash	string	-	-
Pinned	boolean	-	-
Important	boolean	-	-
BodyLength	long	-	-
SystemObjectsKey	string	-	-
RecordLink	string	-	-
User	string	User → UserCode	-
LastUpdatedByUserID	string	User → UserCode	-
CreatedByUserID	string	User → UserCode	-
StatusFlag	string	-	-
Created	datetime	-	-
LastUpdated	datetime	-	-

Enquiry

Documentation: https://apidocs.prospect365.com/#/Get%20Endpoints/Enquiries_Get

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
Description	string	-	-
EnquiryID	long	-	-
Forename	string	-	-
Surname	string	-	-
StatusID	string	-	-
Title	string	-	-
JobTitle	string	-	-
Email	string	-	-
CompanyName	string	-	-
Website	string	-	-
PhoneNumber	string	-	-
MobileNumber	string	-	-
FormData	string	-	-
Source	string	-	-
SourceTypeCode	string	-	-
TerritoryCode	string	-	-
AddressLine1	string	-	-
AddressLine2	string	-	-
AddressLine3	string	-	-
AddressLine4	string	-	-
AddressLine5	string	-	-
Postcode	string	-	-
Country	string	-	-
UtmSource	string	-	-
UtmMedium	string	-	-
UtmCampaign	string	-	-
UtmTerm	string	-	-
UtmContent	string	-	-
ConvertedDate	datetime	-	-
AssignedDate	datetime	-	-
LeadID	long	Lead → LeadID	-
ContactID	long	Contact → ContactID	-
DivisionID	long	Division → DivisionID	-
CampaignActivityID	long	CampaignActivity → CampaignActivityID	-
ProblemID	long	Problem → ProblemID	-
NextTaskID	long	Task → TaskID	-
ConvertedBy	string	User → UserCode	-
AssignedTo	string	User → UserCode	-
LastUpdatedBy	string	User → UserCode	-
CreatedBy	string	User → UserCode	-
EnquiryFormID	long	-	-
StatusFlag	string	-	-
Created	datetime	-	-
LastUpdated	datetime	-	-

Lead

Documentation: https://apidocs.prospect365.com/#/Common%20Endpoints/Leads_Get

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
Description	string	-	-
LeadID	long	-	-
ContactID	long	Contact → ContactID	-
DivisionID	long	Division → DivisionID	-
AddressID	long	Address → AddressID	-
PipelineID	string	-	-
NextTaskID	long	Task → TaskID	-
SalesPersonID	string	User → UserCode	-
MergedWith	long	Lead → LeadID	-
SourceActivityID	long	-	-
SourceID	string	-	-
StatusID	string	-	-
StatusDetailID	string	-	-
SizeID	string	-	-
MarginID	string	-	-
Analysis1ID	string	-	-
TypeID	string	-	-
ObjectiveID	string	-	-
Guttometer	int	-	-
Postponed	int	-	-
ProblemCount	int	-	-
SearchCached	int	-	-
EstimatedCloseYear	int	-	-
EstimatedCloseMonth	int	-	-
SpokeCode	string	-	-
SituationSummary	string	-	-
SourceOther	string	-	-
SystemObjectsKey	string	-	-
AlternateReference	string	-	-
SearchTerms	string	-	-
CombinedEntity	string	-	-
UtmSource	string	-	-
UtmMedium	string	-	-
UtmName	string	-	-
UtmTerm	string	-	-
UtmContent	string	-	-
RecordLink	string	-	-
AutocalculateValue	boolean	-	-
Value	decimal	-	-
WeightedValue	decimal	-	-
WorstValue	decimal	-	-
LikelyValue	decimal	-	-
BestValue	decimal	-	-
MarginValue	decimal	-	-
EstimatedClose	datetime	-	-
StatusChanged	datetime	-	-
LastSpoke	datetime	-	-
FirstActiveEngagement	datetime	-	-
LastActiveEngagement	datetime	-	-
CloseDate	datetime	-	-
CreatedByUserID	string	User → UserCode	-
LastUpdatedByUserID	string	User → UserCode	-
ResponsibleUser	string	User → UserCode	-
OwnerID	string	User → UserCode	-
StatusFlag	string	-	-
Created	datetime	-	-
LastUpdated	datetime	-	-

Problem

Documentation: https://apidocs.prospect365.com/#/Common%20Endpoints/Problems_Get

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
Description	string	-	-
ProblemID	long	-	-
StatusChanged	datetime	-	-
LastSpoke	datetime	-	-
FirstActiveEngagement	datetime	-	-
LastActiveEngagement	datetime	-	-
CloseDate	datetime	-	-
OwnerID	string	User → UserCode	-
ResponsibleUserID	string	User → UserCode	-
CreatedByUserID	string	User → UserCode	-
LastUpdatedByUserID	string	User → UserCode	-
ContactID	long	Contact → ContactID	-
LeadID	long	Lead → LeadID	-
DivisionID	long	Division → DivisionID	-
AddressID	long	Address → AddressID	-
MergedWith	long	Problem → ProblemID	-
NextTaskID	long	Task → TaskID	-
InventoryID	long	-	-
Type1ID	string	-	-
Type2ID	string	-	-
Type3ID	string	-	-
Type4ID	string	-	-
Type5ID	string	-	-
Analysis1ID	string	-	-
Analysis2ID	string	-	-
Analysis3ID	string	-	-
Analysis4ID	string	-	-
Analysis5ID	string	-	-
SupplierReference	string	-	-
CustomerReference	string	-	-
SerialNumber	string	-	-
SourceID	string	-	-
Priority	int	-	-
StatusID	string	-	-
StatusDetailID	string	-	-
SpokeCode	string	-	-
SearchTerms	string	-	-
SituationSummary	string	-	-
SystemObjectsKey	string	-	-
SearchCached	int	-	-
PipelineID	string	-	-
RecordLink	string	-	-
StatusFlag	string	-	-
Created	datetime	-	-
LastUpdated	datetime	-	-

ProductItem

Documentation: https://apidocs.prospect365.com/#/Common%20Endpoints/ProductItems_Get

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
Description	string	-	-
ProductItemID	string	-	-
Obsolete	string	-	-
LastUpdatedByUserID	string	User → UserCode	-
CreatedByUserID	string	User → UserCode	-
OperatingCompanyCode	string	-	-
CategoryID	string	-	-
QuantityType	string	-	-
VatCode	string	-	-
PurchaseCurrencyID	string	-	-
CatalogueCode	string	-	-
CatalogueReference	string	-	-
WebValidation	string	-	-
SystemObjectsKey	string	-	-
ExtendedDescription	string	-	-
InternalNotes	string	-	-
Pack	string	-	-
AlternateReference1	string	-	-
AlternateReference2	string	-	-
AlternateReference3	string	-	-
AlternateReference4	string	-	-
UnitDescription	string	-	-
PurchaseAnalysis	string	-	-
SalesAnalysis	string	-	-
WarrantyDefault	string	-	-
DefaultWarehouse	string	-	-
UnitWeightDescription	string	-	-
UnitVolumeDescription	string	-	-
Type	string	-	-
WebProductReference	string	-	-
WebDescription	string	-	-
WebExtendedDescription	string	-	-
Barcode	string	-	-
VariationDescription	string	-	-
Specification	string	-	-
Manufacturer	string	-	-
ManufacturerReference	string	-	-
BinLocation	string	-	-
CostCentre	string	-	-
Department	string	-	-
DeliveryChargeType	string	-	-
DefaultSupersededBy	string	-	-
PreferredSupplier	string	-	-
SearchTerms	string	-	-
ImageVersion	long	-	-
ImageName	string	-	-
RestrictionID	long	-	-
PackID	string	-	-
UnitWeightDisplay	string	-	-
UnitVolumeDisplay	string	-	-
MagicMatrixCategoryID	string	-	-
ImageAltText	string	-	-
InventoryTypeCode	string	-	-
InventoryStatusCode	string	-	-
ProductCostCentreCode	string	-	-
SystemSearchTerms	string	-	-
Taxable	decimal	-	-
AllowLineDiscount	int	-	-
AllowOverallDiscount	int	-	-
AllowSettlementDiscount	int	-	-
DiscountMatrixID	string	-	-
ParentProductID	string	-	-
TemplateProductItemID	string	-	-
ProductFamilyID	string	-	-
AccountsID	guid	-	-
ImageAccountsID	string	-	-
SellingPrice	decimal	-	-
CostPrice	decimal	-	-
PurchaseCostPrice	decimal	-	-
Sequence	int	-	-
QuantityDecimal	int	-	-
QuantityFactor	int	-	-
AllowSplit	int	-	-
Stocked	int	-	-
SellDecimals	int	-	-
CostDecimals	int	-	-
Warranty	int	-	-
UnitWeightDecimals	int	-	-
UnitVolumeDecimals	int	-	-
WebCatalog	int	-	-
WebAllowSplit	int	-	-
HazardousSubstance	int	-	-
IsTemplate	int	-	-
ExcludeFromOverallPromotion	int	-	-
SupersededQuantityMultiply	int	-	-
IsSizedProduct	int	-	-
IsTrackedProduct	int	-	-
SupersededQuantityRatio	decimal	-	-
CreateInventory	boolean	-	-
Sellable	boolean	-	-
IsAssembly	boolean	-	-
WetTax	boolean	-	-
SalePrice	decimal	-	-
NextPrice	decimal	-	-
UnitWeight	decimal	-	-
UnitVolume	decimal	-	-
QuantityAvailable	decimal	-	-
MinimumUnitQuantity	decimal	-	-
Width	decimal	-	-
Height	decimal	-	-
Depth	decimal	-	-
MinimumStockLevel	decimal	-	-
MaximumStockLevel	decimal	-	-
ReorderStockLevel	decimal	-	-
LowStockValue	decimal	-	-
QuantityOvercommitted	decimal	-	-
QuantityOvercommittedPreseason	decimal	-	-
QuantityAvailablePreseason	decimal	-	-
TotalAvailablePreseason	decimal	-	-
DecimalQuantityAvailable	decimal	-	-
DecimalTotalAvailable	decimal	-	-
DecimalCostPrice	decimal	-	-
DecimalSellingPrice	decimal	-	-
DecimalPurchaseCostPrice	decimal	-	-
OptionValue1	string	-	-
OptionValue2	string	-	-
OptionValue3	string	-	-
SaleFrom	datetime	-	-
SaleTo	datetime	-	-
NextPriceStart	datetime	-	-
DateNextAvailable	datetime	-	-
Sku	string	-	-
Created	datetime	-	-
LastUpdated	datetime	-	-

Quote

Documentation: https://apidocs.prospect365.com/#/Common%20Endpoints/Quotes_Get

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
Description	string	-	-
QuoteID	long	-	-
ContactID	long	Contact → ContactID	-
LeadID	long	Lead → LeadID	-
ProblemID	long	Problem → ProblemID	-
DivisionID	long	Division → DivisionID	-
DeliveryAddressID	long	Address → AddressID	-
CreatedContact	long	Contact → ContactID	-
AuthorisedByContactID	long	Contact → ContactID	-
SelectedAuthoriserContactID	long	Contact → ContactID	-
SplitSourceQuoteID	long	Quote → QuoteID	-
DeliveryChargeProductItemID	long	-	-
SalesPersonID	string	User → UserCode	-
CreatedByUserID	string	User → UserCode	-
LastUpdatedByUserID	string	User → UserCode	-
OperatingCompanyCode	string	-	-
QuoteType	string	-	-
CurrencyCode	string	-	-
CustomerOrderReference	string	-	-
CustomerCostCentre	string	-	-
SourceID	string	-	-
SourceActivity	long	-	-
SourceOther	string	-	-
WarehouseCode	string	-	-
DefaultJobCode	string	-	-
DefaultJobAnalysisCode	string	-	-
AuthorisedBy	string	-	-
CardAuthorisationCode	string	-	-
CardTransactionReference	string	-	-
CardTransactionInfo	string	-	-
PaymentType	string	-	-
CorrelationID	string	-	-
PayerID	string	-	-
TemporaryToken	string	-	-
IsoPaymentCurrency	string	-	-
DomainCode	string	-	-
WebsiteDomain	string	-	-
IpAddress	string	-	-
DocumentReference	string	-	-
AlternateReference	string	-	-
ResellerOrderReference	string	-	-
SearchTerms	string	-	-
PlugInOnHold	string	-	-
TargetSalesLedger	string	-	-
VatRegistrationCode	string	-	-
AuthorisationStatusFlag	string	-	-
AuthorisationComment	string	-	-
SystemObjectsKey	string	-	-
Outcode	string	-	-
Region	string	-	-
BatchReference	string	-	-
OrderStatus	string	-	-
AddressBlock	string	-	-
CombinedEntity	string	-	-
SubEntity	string	-	-
DeliveryChargeID	string	-	-
SplitSourceGroup	string	-	-
SalesOrderGroupCode	string	-	-
PriceList	string	-	-
PriceBandID	long	-	-
AuthorisorLocation	string	-	-
AuthorisorIP	string	-	-
ExpectedPaymentMethod	string	-	-
Memo	string	-	-
TaxCode	string	-	-
RecordLink	string	-	-
Priority	int	-	-
SurchargeDescription	string	-	-
UnitVolumeDesc	string	-	-
UnitWeightDesc	string	-	-
OrderType	string	-	-
ProjectCode	string	-	-
SalesLedgerOrderPlacedOnID	string	-	-
ReceiptTransactionReference	string	-	-
OrderNumber	string	-	-
OrderedBy	string	-	-
AccountsID	string	-	-
StatusID	long	-	-
Repeat	int	-	-
VersionNumber	int	-	-
ForeignMultiplyFlag	int	-	-
ForeignCurrencyDecimals	int	-	-
CompoundOverallDiscount	int	-	-
ReserveStock	int	-	-
OnHold	int	-	-
SearchCached	int	-	-
Urgent	int	-	-
NoPartDelivery	int	-	-
DefaultDiscount	int	-	-
Value	long	-	-
GrossValue	long	-	-
CostValue	long	-	-
Tax	long	-	-
ForeignExchangeRate	long	-	-
ForeignValue	long	-	-
ForeignGrossValue	long	-	-
ForeignTaxValue	long	-	-
OverallDiscountValue	long	-	-
ForeignOverallDiscountValue	long	-	-
SettlementValue1	long	-	-
SettlementValue2	long	-	-
ForeignSettlementValue1	long	-	-
ForeignSettlementValue2	long	-	-
CardValue	decimal	-	-
SurchargeValue	decimal	-	-
SurchargeTax	decimal	-	-
TotalVolume	decimal	-	-
TotalWeight	decimal	-	-
OverallDiscountPercentage	decimal	-	-
SettlementDiscountPercentage1	decimal	-	-
SettlementDiscountPercentage2	decimal	-	-
SettlementDays1	decimal	-	-
SettlementDays2	decimal	-	-
ExchangeRateBaseToForeign	decimal	-	-
ExchangeRateForeignToBase	decimal	-	-
MarginPercentage	decimal	-	-
MarkupPercentage	decimal	-	-
DeliveryChargeBaseValue	decimal	-	-
DeliveryChargeValue	decimal	-	-
DeliveryChargeTaxRate	decimal	-	-
DeliveryChargeTaxValue	decimal	-	-
DecimalHomeNetValue	decimal	-	-
DecimalForeignNetValue	decimal	-	-
DecimalHomeGrossValue	decimal	-	-
DecimalForeignGrossValue	decimal	-	-
DecimalHomeTaxValue	decimal	-	-
DecimalForeignTaxValue	decimal	-	-
DecimalHomeCostValue	decimal	-	-
DecimalMargin	decimal	-	-
DecimalMarkup	decimal	-	-
DecimalBaseMarginValue	decimal	-	-
DecimalForeignCostValue	decimal	-	-
DecimalForeignMarginValue	decimal	-	-
DecimalBaseDiscountValue	decimal	-	-
DecimalForeignDiscountValue	decimal	-	-
PostDeliveryAddress	boolean	-	-
DeliveryChargeValid	boolean	-	-
OverrideAutoAllocation	boolean	-	-
SessionID	string	-	-
AuthorisedOn	datetime	-	-
AuthorisationDate	datetime	-	-
CardTransactionDate	datetime	-	-
AmendedDate	datetime	-	-
OrderDate	datetime	-	-
EndDate	datetime	-	-
OrderDueDate	datetime	-	-
QuoteDate	datetime	-	-
DeliveryCutoff	datetime	-	-
DeliveryEstimatedDate	datetime	-	-
ProcessingStarted	datetime	-	-
StatusFlag	string	-	-
Created	datetime	-	-
LastUpdated	datetime	-	-

Task

Documentation: https://apidocs.prospect365.com/#/Get%20Endpoints/Tasks_Get

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
Name	string	-	-
Description	string	-	-
TaskID	long	-	-
TaskTypeID	string	-	-
TaskTimeZone	string	-	-
Outcome	string	-	-
Priority	int	-	-
Flagged	boolean	-	-
Pinned	boolean	-	-
TaskDateUtc	datetime	-	-
ClosedDate	datetime	-	-
DivisionID	long	Division → DivisionID	-
ContactID	long	Contact → ContactID	-
LeadID	long	Lead → LeadID	-
ProblemID	long	Problem → ProblemID	-
EnquiryID	long	Enquiry → EnquiryID	-
AssignedTo	string	User → UserCode	-
CreatedBy	string	User → UserCode	-
LastUpdatedBy	string	User → UserCode	-
ClosedBy	string	User → UserCode	-
StatusFlag	string	-	-
Created	datetime	-	-
LastUpdated	datetime	-	-

User

Documentation: https://apidocs.prospect365.com/#/Get%20Endpoints/Users_Get

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
UserCode	string	-	-
Created	datetime	-	-
Obsolete	string	-	-
UserName	string	-	-
ContactID	long	Contact → ContactID	-
EmailAddress	string	-	-
Sequence	int	-	-
DictionaryCode	string	-	-
AccountManager	int	-	-
GroupCode	string	-	-
PhoneNumber	string	-	-
JobTitle	string	-	-
WebsiteLogin	int	-	-
DefaultSignature	string	-	-
SystemUser	boolean	-	-
AccountsID	string	-	-
TerritoryCode	string	-	-
MobilePhoneNumber	string	-	-