Explore the Scoro API data model

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

Try our interactive ERD Or, browse below

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

Endpoints

Activity

Documentation: https://api.scoro.com/api/v2#activitiesApiV2Docs

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
ActivityID long - -
ModifiedDate datetime - -
ParentID long Activity → ID -
IsGroup boolean - -
IsActive boolean - -
ProductID long Product → ID -

CalendarEvent

Documentation: https://api.scoro.com/api/v2#activitiesApiV2Docs

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Description string - -
EventID long - -
DeletedDate datetime - -
CreatedDate datetime - -
ModifiedDate datetime - -
Address string - -
CallLink string - -
EventName string - -
StatusName string - -
Status string - -
DurationPlanned string - -
BillableHours string - -
RelatedTaskID long Task → ID -
ActivityID long Activity → ID -
ProjectID long Project → ProjectID -
ProjectPhaseID long ProjectPhase → ID -
CompanyID long Contact → ID -
PersonID long Contact → ID -
InvoiceID long Invoice → ID -
OrderID long Order → ID -
QuoteID long Quote → ID -
PurchaseOrderID long PurchaseOrder → ID -
RentOrderID long - -
BillID long - -
OwnerID long User → ID -
CreatedUser long User → ID -
ModifiedUser long User → ID -
IsPersonal boolean - -
FullDayEvent boolean - -
HasViewPermissions boolean - -
HasModifyPermissions boolean - -
HasDeletePermissions boolean - -
StartDatetime datetime - -
EndDatetime datetime - -

Category

Documentation: https://api.scoro.com/api/v2#vatCodesApiV2Docs

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
CatID long - -
CatName string - -
Symbol string - -
ModifiedDate datetime - -

ClientProfile

Documentation: https://api.scoro.com/api/v2#clientProfilesApiV2Docs

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Discount string - -
Discount2 string - -
Discount3 string - -
VatCodeID long VATCode → VatCodeID -
DeadlineDays int - -
Fine string - -
Currency string - -
PaymentType string - -
LanguageID string - -
PriceListID long PriceList → ID -
CreatedDate datetime - -
ModifiedDate datetime - -

Contact

Documentation: https://api.scoro.com/api/v2#contactsApiV2Docs

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
ContactID long - -
Lastname string - -
SearchName string - -
ContactType string - -
IdCode string - -
Bankaccount string - -
Birthday datetime - -
Position string - -
Comments string - -
Sex string - -
Vatno string - -
Timezone string - -
ManagerEmail string - -
IsSupplier boolean - -
IsClient boolean - -
ManagerID long - -
ClientProfileID long ClientProfile → ID -
ReferenceNo string - -
CatID long Category → CatID -
CatName string - -
ContactPicture string - -
DeletedDate datetime - -
CreatedDate datetime - -
ModifiedDate datetime - -

CustomField

Documentation: https://api.scoro.com/api/v2#customFieldsApiV2Docs

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Name string - -
Type string - -
IsFilterable int - -

FinanceAccount

Documentation: https://api.scoro.com/api/v2#financeAccountsApiV2Docs

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
AccountSymbol string - -
ParentID long FinanceAccount → ID -
ParentName string - -
IsActive boolean - -
IsSalesAccount boolean - -
IsPurchasesAccount boolean - -
CreatedDate datetime - -
ModifiedDate datetime - -

Invoice

Documentation: https://api.scoro.com/api/v2#invoicesApiV2Docs

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Description string - -
Vat decimal - -
AddressCity string - -
AddressCountryCode string - -
AddressCountryName string - -
AddressCounty string - -
AddressMunicipality string - -
AddressStreet string - -
AddressZipCode string - -
ProjectName string - -
CurrencyRate decimal - -
ShipmentDate datetime - -
IsRoleBased boolean - -
LocalPriceListID long - -
No long - -
Discount decimal - -
Discount2 decimal - -
Discount3 decimal - -
Sum decimal - -
VatSum decimal - -
VatCodeID long VATCode → VatCodeID -
CompanyID long Contact → ContactID -
PersonID long Contact → ContactID -
CompanyAddressID long - -
InterestedPartyID long - -
InterestedPartyAddressID long - -
ProjectID long Project → ProjectID -
OwnerID long User → ID -
Currency string - -
OwnerEmail string - -
Date datetime - -
Deadline datetime - -
Status string - -
AccountID string - -
IsSent boolean - -
PaymentType string - -
Fine string - -
PrepaymentSum decimal - -
RealEstateID long - -
ReferenceNo string - -
CompanyName string - -
PersonName string - -
PaidSum decimal - -
PaymentFee decimal - -
ReceivableSum decimal - -
GenerationType string - -
ScheduledInvoiceID long Invoice → ID -
AccountingPeriodFrom datetime - -
AccountingPeriodTo datetime - -
PayNowLink string - -
DeletedDate datetime - -
CreatedDate datetime - -
ModifiedDate datetime - -

UserLaborCost

Documentation: https://api.scoro.com/api/v2#usersLaborCostApiV2Docs

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UserID long - -
Date string - -
HourCost decimal - -

Order

Documentation: https://api.scoro.com/api/v2#ordersApiV2Docs

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Description string - -
AddressCity string - -
AddressCountryCode string - -
AddressCountryName string - -
AddressCounty string - -
AddressMunicipality string - -
AddressStreet string - -
AddressZipCode string - -
CurrencyRate decimal - -
Vat decimal - -
ShipmentDate datetime - -
IsRoleBased boolean - -
LocalPriceListID long - -
No long - -
Discount decimal - -
Discount2 decimal - -
Discount3 decimal - -
Sum decimal - -
VatSum decimal - -
VatCodeID long VATCode → VatCodeID -
CompanyID long Contact → ContactID -
PersonID long Contact → ContactID -
CompanyAddressID long - -
InterestedPartyID long - -
InterestedPartyAddressID long - -
ProjectID long Project → ProjectID -
OwnerID long User → ID -
Currency string - -
Date datetime - -
Deadline datetime - -
Status string - -
AccountID string - -
IsSent boolean - -
QuoteID long Quote → ID -
DeletedDate datetime - -
CreatedDate datetime - -
ModifiedDate datetime - -

Prepayment

Documentation: https://api.scoro.com/api/v2#prepaymentsApiV2Docs

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Description string - -
QuoteID long Quote → ID -
OrderID long Order → ID -
PrepaymentPercent decimal - -
Fine string - -
Vat decimal - -
AddressCity string - -
AddressCountryCode string - -
AddressCountryName string - -
AddressCounty string - -
AddressMunicipality string - -
AddressStreet string - -
AddressZipCode string - -
ProjectName string - -
CurrencyRate decimal - -
ShipmentDate datetime - -
IsRoleBased boolean - -
LocalPriceListID long - -
No long - -
Discount decimal - -
Discount2 decimal - -
Discount3 decimal - -
Sum decimal - -
VatSum decimal - -
VatCodeID long VATCode → VatCodeID -
CompanyID long Contact → ContactID -
PersonID long Contact → ContactID -
CompanyAddressID long - -
InterestedPartyID long - -
ProjectID long Project → ProjectID -
OwnerID long User → ID -
Currency string - -
Date datetime - -
Deadline datetime - -
Status string - -
AccountID string - -
IsSent boolean - -
DeletedDate datetime - -
CreatedDate datetime - -
ModifiedDate datetime - -

Product

Documentation: https://api.scoro.com/api/v2#productsApiV2Docs

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Description string - -
ProductID long - -
Code string - -
Price decimal - -
BuyingPrice decimal - -
PriceList long PriceList → ID -
Description2 string - -
Unit string - -
Amount decimal - -
Amount2 decimal - -
Tag string - -
Url string - -
DefaultType string - -
UseSupplier boolean - -
DefaultDoerID long User → ID -
DefaultRoleID long UserRole → RoleID -
SupplierID long Contact → ID -
IsActive boolean - -
DeletedDate datetime - -
IsService boolean - -
NoDiscounts boolean - -
DefaultVatCodeID long VATCode → VatCodeID -
DefaultSalesTaxID long VATCode → VatCodeID -
DefaultPurchasesTaxID long VATCode → VatCodeID -
DepotsTotalAmounts decimal - -
AccountID string - -
SalesFinanceAccountID long - -
PurchasesFinanceAccountID long - -
CreatedDate datetime - -
ModifiedDate datetime - -

Project

Documentation: https://api.scoro.com/api/v2#projectsV2Docs

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProjectID long - -
No int - -
ProjectName string - -
CompanyID long Contact → ContactID -
IsPersonal boolean - -
IsPrivate boolean - -
Color string - -
Status string - -
StatusName string - -
ManagerID long User → ID -
ManagerEmail string - -
Date datetime - -
ModifiedDate datetime - -
Deadline datetime - -
DeletedDate datetime - -
Duration string - -
AccountID string - -
BudgetType string - -
StripDescription boolean - -
IsRoleBased boolean - -
LocalPriceListID long - -

PurchaseOrder

Documentation: https://api.scoro.com/api/v2#purchaseOrdersApiV2Docs

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Description string - -
QuoteID long Quote → ID -
OrderID long Order → ID -
RealEstateID long - -
DeliveryAddressID long - -
DeliveryDate datetime - -
AddressCity string - -
AddressCountryCode string - -
AddressCountryName string - -
AddressCounty string - -
AddressMunicipality string - -
AddressStreet string - -
AddressZipCode string - -
ProjectName string - -
CurrencyRate decimal - -
Vat decimal - -
ConfirmedDate datetime - -
No long - -
Discount decimal - -
Discount2 decimal - -
Discount3 decimal - -
Sum decimal - -
VatSum decimal - -
VatCodeID long VATCode → VatCodeID -
CompanyID long Contact → ContactID -
PersonID long Contact → ContactID -
CompanyAddressID long - -
InterestedPartyID long - -
InterestedPartyAddressID long - -
ProjectID long Project → ProjectID -
OwnerID long User → ID -
Currency string - -
OwnerEmail string - -
Date datetime - -
Status string - -
AccountID string - -
IsSent boolean - -
DeletedDate datetime - -
CreatedDate datetime - -
ModifiedDate datetime - -

Quote

Documentation: https://api.scoro.com/api/v2#quotesV2Docs

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Description string - -
AddressCity string - -
AddressCountryCode string - -
AddressCountryName string - -
AddressCounty string - -
AddressMunicipality string - -
AddressStreet string - -
AddressZipCode string - -
ProjectName string - -
CurrencyRate decimal - -
StatusName string - -
ShipmentDate datetime - -
IsRoleBased boolean - -
LocalPriceListID long - -
EstimatedDuration decimal -
  • 14 Feb 2024 Duration is in months
No decimal - -
Discount decimal - -
Discount2 decimal - -
Discount3 decimal - -
Sum decimal - -
VatSum decimal - -
VatCodeID long VATCode → VatCodeID -
CompanyID long Contact → ContactID -
PersonID long Contact → ContactID -
CompanyAddressID long - -
InterestedPartyID long - -
InterestedPartyAddressID long - -
ProjectID long Project → ProjectID -
OwnerID long User → ID -
Currency string - -
OwnerEmail string - -
Date datetime - -
Deadline datetime - -
Status string - -
AccountID string - -
IsSent boolean - -
ConfirmedDate datetime - -
EstimatedClosingDate datetime - -
DeletedDate datetime - -
CreatedDate datetime - -
ModifiedDate datetime - -

Role

Documentation: https://api.scoro.com/api/v2#rolesApiV2Docs

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
IsActive boolean - -
CreatedUser long User → ID -
ModifiedUser long User → ID -
CreatedDate datetime - -
ModifiedDate datetime - -

Task

Documentation: https://api.scoro.com/api/v2#tasksApiV2Docs

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Description string - -
EventID long - -
EventName string - -
DurationActual string - -
DurationPlanned string - -
BillableHours string - -
Status string - -
StatusName string - -
Sortorder int - -
PriorityID int - -
QuoteLineID long QuoteLine → ID -
EteID long - -
ActivityID long Activity → ID -
ActivityType string - -
ProjectID long Project → ProjectID -
ProjectPhaseID long ProjectPhase → ID -
CompanyID long Contact → ID -
PersonID long Contact → ID -
InvoiceID long Invoice → ID -
OrderID long Order → ID -
QuoteID long Quote → ID -
PurchaseOrderID long PurchaseOrder → ID -
RentOrderID long - -
BillID long - -
OwnerID long User → ID -
CreatedUser long User → ID -
ModifiedUser long User → ID -
IsCompleted boolean - -
IsPersonal boolean - -
DeletedDate datetime - -
StartDatetime datetime - -
DatetimeDue datetime - -
DatetimeCompleted datetime - -
HasViewPermissions boolean - -
HasModifyPermissions boolean - -
HasDeletePermissions boolean - -
CreatedDate datetime - -
ModifiedDate datetime - -

TimeEntry

Documentation: https://api.scoro.com/api/v2#timeEntriesApiV2Docs

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Description string - -
TimeEntryID long - -
Title string - -
TimeEntryType string - -
Duration string -
  • 19 Dec 2024 Duration is a time span, e.g. 00:30:00 for 30 minutes
BillableDuration string - -
UserID long User → ID -
ActivityID long Activity → ID -
InvoiceLineID long InvoiceLine → ID -
EventType string - -
EventID long - -
TaskID long Task → ID -
CalendarEventID long CalendarEvent → EventID -
IsCompleted boolean - -
IsConfirmed boolean - -
IsBillable boolean - -
IsLocked boolean - -
IsSubmitted boolean - -
HasViewPermissions boolean - -
HasModifyPermissions boolean - -
HasDeletePermissions boolean - -
StartDatetime datetime - -
EndDatetime datetime - -
CompletedDatetime datetime - -
TimeEntryDate datetime - -
SubmittedDate datetime - -
DeletedDate datetime - -
CreatedDate datetime - -
ModifiedDate datetime - -

User

Documentation: https://api.scoro.com/api/v2#usersApiV2Docs

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Username string - -
Firstname string - -
Lastname string - -
FullName string - -
Initials string - -
Email string - -
Status string - -
Category string - -
Position string - -
Hidden boolean - -
RoleID long UserRole → RoleID -
CountryID string - -
Comment string - -
Gsm string - -
Timezone string - -
Birthday datetime - -
CreatedDate datetime - -
ModifiedDate datetime - -

UserGroup

Documentation: https://api.scoro.com/api/v2#userGroupsApiV2Docs

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
GroupID long - -
GroupName string - -
Comment string - -
Hidden boolean - -

UserRole

Documentation: https://api.scoro.com/api/v2#userRolesApiV2Docs

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
RoleID long - -
RoleName string - -

VATCode

Documentation: https://api.scoro.com/api/v2#vatCodesApiV2Docs

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
VatCodeID long - -
VatCode string - -
VatName string - -
IsSales boolean - -
IsPurchases boolean - -
IsActive boolean - -
IsNotApplicable boolean - -
Percent decimal - -

ContactCustomField

Column Type Relates to Notes
RemoteID string - -
ContactRemoteID string Contact → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string CustomField → ID -
ContactID long Contact → ID -
Value string - -

CustomFieldModule

Column Type Relates to Notes
RemoteID string - -
CustomFieldRemoteID string CustomField → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CustomFieldID string CustomField → ID -
ModuleName string - -
Status string - -

InvoiceLine

Documentation: https://api.scoro.com/api/v2#invoiceLinesApiV2Docs

Column Type Relates to Notes
RemoteID string - -
InvoiceRemoteID string Invoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
InvoiceID long Invoice → ID -
VatCodeID long VATCode → VatCodeID -
DoerEmail string - -
RoleName string - -
ProductID long Product → ID -
Comment string - -
Comment2 string - -
Price decimal - -
Amount decimal - -
Amount2 decimal - -
Discount decimal - -
Sum decimal - -
Vat decimal - -
Unit string - -
FinanceObjectID long - -
FinanceAccountID long - -
FinanceAccountIdsymbol string - -
Cost decimal - -
IsInternal boolean - -
SupplierID long Contact → ContactID -
DoerID long User → ID -
RoleID long Role → ID -
ProjectID long Project → ProjectID -

InvoiceCustomField

Column Type Relates to Notes
RemoteID string - -
InvoiceRemoteID string Invoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string CustomField → ID -
InvoiceID long Invoice → ID -
Value string - -

OrderLine

Documentation: https://api.scoro.com/api/v2#orderLinesApiV2Docs

Column Type Relates to Notes
RemoteID string - -
OrderRemoteID string Order → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
OrderID long Order → ID -
ProductID long Product → ID -
Comment string - -
Comment2 string - -
Price decimal - -
Amount decimal - -
Amount2 decimal - -
Discount decimal - -
Sum decimal - -
Vat decimal - -
Unit string - -
FinanceObjectID long - -
VatCodeID long VATCode → VatCodeID -
FinanceAccountID long FinanceAccount → ID -
Cost decimal - -
IsInternal boolean - -
SupplierID long Contact → ContactID -
DoerID long User → ID -
RoleID long Role → ID -
ProjectID long Project → ProjectID -

OrderCustomField

Column Type Relates to Notes
RemoteID string - -
OrderRemoteID string Order → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string CustomField → ID -
OrderID long Order → ID -
Value string - -

PrepaymentLine

Documentation: https://api.scoro.com/api/v2#prepaymentLinesApiV2Docs

Column Type Relates to Notes
RemoteID string - -
PrepaymentRemoteID string Prepayment → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
PrepaymentID long Prepayment → ID -
ProductID long Product → ID -
Comment string - -
Comment2 string - -
Price decimal - -
Amount decimal - -
Amount2 decimal - -
Discount decimal - -
Sum decimal - -
VatCodeID long VATCode → VatCodeID -
Vat decimal - -
Unit string - -
FinanceObjectID long - -
FinanceAccountID long - -
Cost decimal - -
IsInternal boolean - -
SupplierID long Contact → ContactID -
DoerID long User → ID -
RoleID long UserRole → RoleID -
ProjectID long Project → ProjectID -

ProjectPhase

Documentation: https://api.scoro.com/api/v2#projectPhasesV2Docs

Column Type Relates to Notes
RemoteID string - -
ProjectRemoteID string Project → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
ProjectID long Project → ProjectID -
QuoteLineID long QuoteLine → ID -
Ordering int - -
Type string - -
Title string - -
StartDate datetime - -
EndDate datetime - -

ProjectCustomField

Column Type Relates to Notes
RemoteID string - -
ProjectRemoteID string Project → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string CustomField → ID -
ProjectID long Project → ProjectID -
Value string - -

PurchaseOrderLine

Documentation: https://api.scoro.com/api/v2#purchaseOrderLinesApiV2Docs

Column Type Relates to Notes
RemoteID string - -
PurchaseOrderRemoteID string PurchaseOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
PurchaseOrderID long PurchaseOrder → ID -
VatCodeID long VATCode → VatCodeID -
IsSettled boolean - -
ProductID long Product → ID -
Comment string - -
Comment2 string - -
Price decimal - -
Amount decimal - -
Amount2 decimal - -
Discount decimal - -
Sum decimal - -
Vat decimal - -
Unit string - -
FinanceObjectID long - -
FinanceAccountID long - -
ProjectID long Project → ProjectID -

PurchaseOrderCustomField

Column Type Relates to Notes
RemoteID string - -
PurchaseOrderRemoteID string PurchaseOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string CustomField → ID -
PurchaseOrderID long PurchaseOrder → ID -
Value string - -

QuoteLine

Documentation: https://api.scoro.com/api/v2#quoteLinesV2Docs

Column Type Relates to Notes
RemoteID string - -
QuoteRemoteID string Quote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
QuoteID long Quote → ID -
VatCodeID long VATCode → VatCodeID -
IsConfirmed boolean - -
DoerEmail string - -
RoleName string - -
ProductID long Product → ID -
Comment string - -
Comment2 string - -
Price decimal - -
Amount decimal - -
Amount2 decimal - -
Discount decimal - -
Sum decimal - -
Vat decimal - -
Unit string - -
FinanceObjectID long - -
FinanceAccountID long - -
Cost decimal - -
IsInternal boolean - -
SupplierID long Contact → ContactID -
DoerID long User → ID -
RoleID long UserRole → RoleID -
ProjectID long Project → ProjectID -

QuoteCustomField

Column Type Relates to Notes
RemoteID string - -
QuoteRemoteID string Quote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string CustomField → ID -
QuoteID long Quote → ID -
Value string - -

QuoteLineCustomField

Column Type Relates to Notes
RemoteID string - -
QuoteLineRemoteID string QuoteLine → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string CustomField → ID -
QuoteLineID long QuoteLine → ID -
Value string - -

RolePriceList

Column Type Relates to Notes
RemoteID string - -
RoleRemoteID string Role → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
RoleID long Role → ID -
PriceListID long PriceList → ID
  • 15 Jan 2025 Price list endpoint currently unimplemented
SellingPrice decimal - -
Currency string - -

RoleUser

Column Type Relates to Notes
RemoteID string - -
RoleRemoteID string Role → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
RoleID long Role → ID -
UserID long User → ID -

TaskRelatedUser

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TaskID long Task → ID -
UserID long User → ID -

TaskCustomField

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string CustomField → ID -
TaskID long Task → ID -
Value string - -
Type string - -

Need more?

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

Connect your own Scoro data Querying Scoro using regular SQL