Explore the Accelo API data model

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

Try our interactive ERD Or, browse below

Pulling data from the Accelo 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 Accelo 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.accelo.com/docs/#activities

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
DateCreated datetime - -
DateModified datetime - -
Standing string - -
InvoiceID long Invoice → ID -
RateCharged decimal - -
OwnerType string - -
OwnerID long - -
OwnerStaffID long Staff → ID -
OwnerAffiliationID long Affiliation → ID -
Confidential int - -
Details string - -
ContractPeriodID string -
  • 11 Aug 2024 Foreign Key - Refers to `ContractPeriod` (not implemented).
ThreadID long - -
DateStarted long -
  • 27 Aug 2024 For meetings this is the scheduled start date of the meeting, for other activities it is the date time was logged, returns null otherwise
DateEnded long -
  • 27 Aug 2024 For meetings, the date the meeting was scheduled to finish
WhenStarted datetime -
  • 27 Aug 2024 For meetings this is the scheduled start date of the meeting, for other activities it is the date time was logged, returns null otherwise
WhenEnded datetime -
  • 27 Aug 2024 For meetings, the date the meeting was scheduled to finish
Body string - -
Subject string - -
AgainstType string - -
AgainstID long - -
StaffID long Staff → ID -
AffiliationID long Affiliation → ID -
RequestID long -
  • 11 Aug 2024 Foreign Key - Refers to `Request` (not implemented).
JobID long Job → ID -
MilestoneID long Milestone → ID -
ContractID long -
  • 14 Jul 2025 Foreign Key - Refers to `Contract` (not implemented).
Task long -
  • 11 Aug 2024 Foreign Key - Refers to `Task` (not implemented).
Visibility string - -
Billable long - -
Nonbillable long - -
Medium string - -
ParentID long Activity → ID -
Rate long Rate → ID -
Staff long - -

Address

Documentation: https://api.accelo.com/docs/#addresses

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Full string - -
CustomID string - -
Title string - -
Street1 string - -
Street2 string - -
City string - -
StateID long State → ID -
CountryID long Country → ID -
Postal string - -
Physical string - -

Affiliation

Documentation: https://api.accelo.com/docs/#affiliations

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Mobile string - -
Email string - -
Fax string - -
Position string - -
Phone string - -
PostalAddress long - -
PhysicalAddress long - -
Company long Company → ID -
Contact long Contact → ID -
StatusID long AffiliationStatus → ID -
DateLastInteracted long - -
StaffBookmarked boolean - -
PortalAccess string - -
InvoiceMethod string - -
Standing string - -
DateCreated long - -
DateModified long - -

Asset

Documentation: https://api.accelo.com/docs/#assets

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Title string - -
AssetLinkID long - -
LinkStartDate datetime - -
LinkEndDate datetime - -
LinkedJobID long Job → ID -
LinkedIssueID long Issue → ID -
LinkedProspectID long Prospect → ID -
LinkedContractID long - -
Fax string - -
DateCreated long - -
AgainstType string - -
AgainstID long - -
AssetTypeID long - -
Affiliation long Affiliation → ID -
AffiliationID long - -
ManagerID long Staff → ID -
AddressID long Address → ID -
Standing string - -

AssetType

Documentation: https://api.accelo.com/docs/#list-asset-types

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

Company

Documentation: https://api.accelo.com/docs/#companies

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
CustomID string - -
Website string - -
Phone string - -
Fax string - -
DateLastInteracted long - -
Comments string - -
WhenLastInteracted datetime - -
PostalAddress long Address → ID -
CompanyStatusID long CompanyStatus → ID -
StaffBookmarked boolean - -
DefaultAffiliation long Affiliation → ID -
Standing string - -
DateCreated long - -
DateModified long - -

Contact

Documentation: https://api.accelo.com/docs/#contacts

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Firstname string - -
Lastname string - -
Username string - -
Middlename string - -
Title string - -
Timezone string - -
DateLastInteracted long - -
Comments string - -
WhenLastInteracted datetime - -
DefaultAffiliation long Affiliation → ID -
Standing string - -
DateCreated long - -
DateModified long - -

Contract

Documentation: https://api.accelo.com/docs/#contracts-retainers

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Title string - -
PeriodTemplateID long - -
DateCreated long - -
DateStarted long - -
DateExpires long - -
DatePeriodExpires long - -
Against string - -
AgainstID long - -
Value decimal - -
AutoRenew boolean - -
RenewDays string - -
SendInvoice string - -
Notes string - -
StaffBookmarked boolean - -
OwnerAffiliation long Affiliation → ID -
ContractType long ContractType → ID -
BillableAffiliation long Affiliation → ID -
Manager long Staff → ID -
Job long Job → ID -
Company long Company → ID -
ContractStatus long ContractStatus → ID -
Standing string - -

ContractPeriod

Documentation: https://api.accelo.com/docs/#the-contract-object

Column Type Relates to Notes
RemoteID string - -
ContractRemoteID string Contract → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
ContractID long Contract → ID -
DateCreated long - -
DateCommenced long - -
DateExpires long - -
DateClosed long - -
RateCharged decimal - -
UnapprovedBudgetUsed decimal - -
IncludeExpense boolean - -
IncludeUsageGraph boolean - -
IncludeMaterial boolean - -
BudgetType string - -
AllowanceType string - -
RateType string - -
RateID long Rate → ID -
ServiceItemID long - -
DurationType string - -
Rollover boolean - -
Standing string - -
ContractBudgetID long ContractBudget → ID -
BudgetUsedType string - -
BudgetUsedValue decimal - -
AllowanceBillable decimal - -
AllowanceCharged decimal - -

ContractBudget

Documentation: https://api.accelo.com/docs/#the-contract-object

Column Type Relates to Notes
RemoteID string - -
ContractPeriodRemoteID string ContractPeriod → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Value string - -
ProductCharged string - -
TimeCharged string - -
Time long - -
AgainstType string - -
AgainstID long - -

ContractType

Documentation: https://api.accelo.com/docs/#the-contract-object

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Parent long Contract → ID -
PeriodTemplateID long - -
Title string - -
Standing string - -
Ordering int - -
AutoRenew boolean - -
RenewDays string - -
SendInvoice string - -
InvoiceTemplateID long - -
ServiceTaxID long - -
ServiceTaxLedgerID long - -
AutoCompleteTask boolean - -

AssetCustomField

Documentation: https://api.accelo.com/docs/#extensions-custom-fields

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
FieldName string - -
FieldType string - -
LinkTypeID long AssetType → ID -

JobCustomField

Documentation: https://api.accelo.com/docs/#extensions-custom-fields

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
FieldName string - -
FieldType string - -
LinkTypeID long JobType → ID -

IssueCustomField

Documentation: https://api.accelo.com/docs/#extensions-custom-fields

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
FieldName string - -
FieldType string - -
LinkTypeID long -
  • 1 Aug 2024 Foreign Key - Refers to 'IssueType' (not implemented)

ProspectCustomField

Documentation: https://api.accelo.com/docs/#extensions-custom-fields

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
FieldName string - -
FieldType string - -
LinkTypeID long -
  • 1 Aug 2024 Foreign Key - Refers to 'ProspectType' (not implemented)

Division

Documentation: https://api.accelo.com/docs/#divisions

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Standing string - -
Title string - -

Expense

Documentation: https://api.accelo.com/docs/#expenses

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
DateIncurred datetime - -
Standing string - -
Title string - -
UnitCost decimal - -
Quantity decimal - -
Price decimal - -
ActivityID long Activity → ID -
TypeID long Expense → ID -
SubmitterID long Staff → ID -
Billable string - -
Reimbursable string - -
AgainstType string - -
AgainstID long - -
JobID long Job → ID -
ContractBudgetID long ContractBudget → ID -
IssueID long Issue → ID -

ExpenseType

Documentation: https://api.accelo.com/docs/#get-expense-type

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Standing string - -
Title string - -
LedgerID long -
  • 7 Aug 2024 Foreign Key - Refers to 'Ledger' (not implemented)
TaxID long -
  • 7 Aug 2024 Foreign Key - Refers to 'Taxes' (not implemented)

Filter

Documentation: https://api.accelo.com/docs/#filters

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Title string - -
Shared string - -
ObjectType string - -
StaffID long Staff → ID -

Group

Documentation: https://api.accelo.com/docs/#groups

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Standing string - -
Title string - -
ParentID long Group → ID -

Invoice

Documentation: https://api.accelo.com/docs/#invoices

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Amount decimal - -
Subject string - -
AgainstType string - -
AgainstID long - -
CompanyID long Company → ID -
JobID long Job → ID -
Notes string - -
InvoiceNumber string -
  • 1 Feb 2024 The Accelo docs say that this is an integer, however it also says that it is the representation of the external identifier from (e.g.) Xero, MYOB etc. These are not necessarily integers (e.g. Xero is a GUID) so we will hedge here and make it a string
CurrencyID long - -
Tax decimal - -
Outstanding decimal - -
OwnerID long Staff → ID -
ModifiedBy long Staff → ID -
DateRaised long - -
DateModified long - -
DateDue long - -
AffiliationContact long Contact → ID -
Affiliation long Affiliation → ID -
AffiliationID long Affiliation → ID -
CreatorID long Staff → ID -
Standing string - -

InvoiceItem

Documentation: https://api.accelo.com/docs/#invoices

Column Type Relates to Notes
RemoteID string - -
InvoiceRemoteID string Invoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Description string - -
Type string - -
Quantity decimal - -
Rate decimal - -
Total decimal - -
Tax decimal - -
InvoiceID long Invoice → ID -
LedgerID long - -
TaxID long - -
Ordering long - -
LineItemLedger long - -
LineItemTax decimal - -

Issue

Documentation: https://api.accelo.com/docs/#issues-tickets

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Description string - -
Title string - -
CustomID string - -
AgainstType string - -
AgainstID long - -
CompanyID long Company → ID -
DateLastInteracted long - -
DateDue long - -
WhenLastInteracted datetime - -
WhenDue datetime - -
IssueType long - -
Class long - -
IssuePriority long - -
Resolution long - -
ResolutionDetail string - -
Affiliation long Affiliation → ID -
StatusID long IssueStatus → ID -
DateSubmitted long - -
WhenSubmitted datetime - -
SubmittedBy long Staff → ID -
DateOpened long - -
WhenOpened datetime - -
OpenedBy long Staff → ID -
DateResolved long - -
WhenResolved datetime - -
ResolvedBy long Staff → ID -
DateClosed long - -
WhenClosed datetime - -
ClosedBy long Staff → ID -
ReferrerID long - -
ReferrerType string - -
StaffBookmarked boolean - -
BillableSeconds long - -
Company long Company → ID -
Assignee long Staff → ID -
Contract long - -
IssueObjectBudget long - -
Standing string - -
DateCreated long - -
DateModified long - -

Job

Documentation: https://api.accelo.com/docs/#jobs

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Title string - -
AgainstType string - -
AgainstID int - -
CustomID string - -
Paused int - -
StaffBookmarked boolean - -
DateLastInteracted long - -
DateStarted long - -
DateCommenced long - -
DateDue long - -
DateCompleted long - -
Type int - -
Manager long Staff → ID -
ModifiedBy long Staff → ID -
Rate long Rate → ID -
Company long Company → ID -
JobObjectBudget long - -
JobContract long - -
JobObjectSchedule long - -
Affiliation long - -
StatusID long JobStatus → ID -
JobTypeID long JobType → ID -
Standing string - -
DateCreated long - -
DateModified long - -

JobType

Documentation: https://api.accelo.com/docs/#jobs

Column Type Relates to Notes
RemoteID string - -
JobRemoteID string Job → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Title string - -
Standing string - -
Ordering int - -

Milestone

Documentation: https://api.accelo.com/docs/#milestones

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Description string - -
DateCreated datetime - -
DateModified datetime - -
Standing string - -
Title string - -
DateStarted long - -
DateCommenced long - -
DateDue long - -
DateCompleted long - -
Job long Job → ID -
Manager long Staff → ID -
Status long -
  • 7 Aug 2024 Foreign Key - Refers to 'Statuses' (not implemented)
Parent long Milestone → ID -
Rate long Rate → ID -
RateCharged decimal - -
MilestoneObjectBudget long ObjectBudget → ID -

ObjectBudget

Documentation: https://api.accelo.com/docs/#the-object-budget

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
AgainstType string - -
AgainstID long - -
JobID long Job → ID -
TaskID long Task → ID -
MilestoneID long Milestone → ID -
IsBillable string - -
ServiceTimeEstimate decimal - -
ServiceTime decimal - -
ServiceTimeSubtotalEstimate decimal - -
ServicePriceEstimate decimal - -
ServicePrice decimal - -
ServicePriceSubtotalEstimate decimal - -
ServicePriceSubtotal decimal - -
ExpensePrice decimal - -
MaterialCost decimal - -
MaterialCostSubtotal decimal - -
MaterialPrice decimal - -
MaterialPriceSubtotal decimal - -
Billable decimal - -
BillableSubtotal decimal - -
Nonbillable decimal - -
NonbillableSubtotal decimal - -
Logged decimal - -
LoggedSubtotal decimal - -
Charged decimal - -
ChargedSubtotal decimal - -
RemainingSubtotal decimal - -

Payment

Documentation: https://api.accelo.com/docs/#payments

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
DateCreated datetime - -
Direction string - -
Amount decimal - -
ReceiptID long - -
MethodID long - -
CurrencyID long - -
CreatedByStaffID long Staff → ID -
AgainstType string - -
AgainstID long - -
InvoiceID long Invoice → ID -
PurchaseID long -
  • 7 Aug 2024 Foreign Key - Refers to 'Purchases' (not implemented)

Prospect

Documentation: https://api.accelo.com/docs/#prospects-sales

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Title string - -
DateActioned long - -
WhenActioned datetime - -
DateDue long - -
WhenDue datetime - -
DateLastInteracted long - -
WhenLastInteracted datetime - -
Value decimal - -
Success boolean - -
Comments string - -
Progress decimal - -
ValueWeighted long - -
StaffBookmarked boolean - -
WonByID long Staff → ID -
CancelledByID long Staff → ID -
AbandonedByID long Staff → ID -
Manager long Staff → ID -
StatusID long ProspectStatus → ID -
Affiliation long Affiliation → ID -
ProspectTypeID long - -
ProspectProbabilityID long - -
Weighting long - -
Standing string - -
DateCreated long - -
DateModified long - -

Rate

Documentation: https://api.accelo.com/docs/#rates

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Title string - -
Object string - -
Charged decimal - -
Standing string - -

Staff

Documentation: https://api.accelo.com/docs/#staff

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Firtname string - -
Surname string - -
FinancialLevel string - -
Title string - -
Email string - -
Mobile string - -
Phone string - -
Fax string - -
Position string - -
Username string - -
Timezone string - -
StaffRate decimal - -
StaffCostRate decimal - -
Standing string - -

AffiliationStatus

Documentation: https://api.accelo.com/docs/#statuses

Column Type Relates to Notes
RemoteID string - -
AffiliationRemoteID string Affiliation → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Title string - -
Color string - -
Ordering long - -
Standing string - -

CompanyStatus

Documentation: https://api.accelo.com/docs/#statuses

Column Type Relates to Notes
RemoteID string - -
CompanyRemoteID string Company → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Title string - -
Color string - -
Ordering long - -
Standing string - -

ContractStatus

Documentation: https://api.accelo.com/docs/#statuses

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Title string - -
Color string - -
Ordering long - -
Standing string - -

IssueStatus

Documentation: https://api.accelo.com/docs/#statuses

Column Type Relates to Notes
RemoteID string - -
IssueRemoteID string Issue → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Title string - -
Color string - -
Ordering long - -
Standing string - -

JobStatus

Documentation: https://api.accelo.com/docs/#statuses

Column Type Relates to Notes
RemoteID string - -
JobRemoteID string Job → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Title string - -
Color string - -
Ordering long - -
Standing string - -

ProspectStatus

Documentation: https://api.accelo.com/docs/#statuses

Column Type Relates to Notes
RemoteID string - -
ProspectRemoteID string Prospect → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Title string - -
Color string - -
Ordering long - -
Standing string - -

TaskStatus

Documentation: https://api.accelo.com/docs/#statuses

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Title string - -
Color string - -
Ordering long - -
Standing string - -

Tag

Documentation: https://api.accelo.com/docs/#tags

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

Task

Documentation: https://api.accelo.com/docs/#tasks

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Description string - -
Title string - -
Billable long - -
Nonbillable long - -
Logged long - -
Budgeted long - -
Remaining long - -
StaffBookmarked boolean - -
DateCommenced long - -
DateAccepted long - -
DateDue long - -
DateCompleted long - -
AgainstID long - -
AgainstType string - -
CreatorType string - -
Creator long Staff → ID -
TaskTypeTitle string - -
TaskTypeStanding string - -
TaskTypeOrdering long - -
Manager long Staff → ID -
Contact long Contact → ID -
Affiliation long Affiliation → ID -
StatusID long TaskStatus → ID -
Company long Company → ID -
Issue long Issue → ID -
TaskJob long Job → ID -
TaskObjectSchedule long - -
TaskObjectScheduleID long - -
RateID long Rate → ID -
RateCharged decimal - -
Ordering long - -
Standing string - -
DateCreated long - -
DateModified long - -

ActivityTimeAllocation

Documentation: https://api.accelo.com/docs/#the-time-allocation-object

Column Type Relates to Notes
RemoteID string - -
ActivityRemoteID string Activity → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
ActivityID long Activity → ID -
AgainstType string - -
AgainstID long - -
Standing string - -
Billable long - -
Nonbillable long - -
Charged decimal - -
Comments string - -
DateCreated long - -
DateLocked long - -

ActivityPriority

Documentation: https://api.accelo.com/docs/#the-activity-priority

Column Type Relates to Notes
RemoteID string - -
ActivityRemoteID string Activity → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
ActivityID long Activity → ID -
Title string - -
Level int - -

ActivityClass

Documentation: https://api.accelo.com/docs/#the-activity-class

Column Type Relates to Notes
RemoteID string - -
ActivityRemoteID string Activity → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
ActivityID long Activity → ID -
Title string - -
Parent long - -
Status string - -

ActivityStaffInteraction

Documentation: https://api.accelo.com/docs/#activity-interactions

Column Type Relates to Notes
RemoteID string - -
ActivityRemoteID string Activity → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InteractID long - -
ActivityID long Activity → ID -
StaffID long Staff → ID -

ActivityContactInteraction

Documentation: https://api.accelo.com/docs/#activity-interactions

Column Type Relates to Notes
RemoteID string - -
ActivityRemoteID string Activity → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InteractID long - -
ActivityID long Activity → ID -
ContactID long Contact → ID -

Country

Documentation: https://api.accelo.com/docs/#addresses

Column Type Relates to Notes
RemoteID string - -
AddressRemoteID string Address → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Title string - -
Prefix string - -
Suffix string - -
PostcodeName string - -
StateName string - -
PostcodeRequired string - -
StateRequired string - -

State

Documentation: https://api.accelo.com/docs/#addresses

Column Type Relates to Notes
RemoteID string - -
AddressRemoteID string Address → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Title string - -
Timezone string - -
Abbreviation string - -
Ordering int - -
CountryID long Country → ID -

AssetCustomFieldValue

Column Type Relates to Notes
RemoteID string - -
AssetRemoteID string Asset → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
AssetID long Asset → ID -
AssetCustomFieldID long AssetCustomField → ID -
Value string - -

AssetCustomFieldOption

Column Type Relates to Notes
RemoteID string - -
AssetCustomFieldRemoteID string AssetCustomField → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CustomFieldID long AssetCustomField → ID -
LineNumber int - -
Value string - -

JobCustomFieldOption

Column Type Relates to Notes
RemoteID string - -
JobCustomFieldRemoteID string JobCustomField → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CustomFieldID long JobCustomField → ID -
LineNumber int - -
Value string - -

IssueCustomFieldOption

Column Type Relates to Notes
RemoteID string - -
IssueCustomFieldRemoteID string IssueCustomField → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CustomFieldID long IssueCustomField → ID -
LineNumber int - -
Value string - -

ProspectCustomFieldOption

Column Type Relates to Notes
RemoteID string - -
ProspectCustomFieldRemoteID string ProspectCustomField → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CustomFieldID long ProspectCustomField → ID -
LineNumber int - -
Value string - -

IssueCustomFieldValue

Column Type Relates to Notes
RemoteID string - -
IssueRemoteID string Issue → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
IssueID long Issue → ID -
IssueCustomFieldID long IssueCustomField → ID -
Value string - -

JobCustomFieldValue

Column Type Relates to Notes
RemoteID string - -
JobRemoteID string Job → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
JobID long Job → ID -
JobCustomFieldID long JobCustomField → ID -
Value string - -

JobProfileFieldValue

Documentation: https://api.accelo.com/docs/#the-profile-value-object

Column Type Relates to Notes
RemoteID string - -
JobRemoteID string Job → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
LinkID long Job → ID -
FieldID long JobProfileField → ID -
FieldName string - -
FieldType string - -
Value string - -
ValueType string - -
DateModified long - -
ModifiedBy long Staff → ID -
LinkType string - -

JobProfileField

Documentation: https://api.accelo.com/docs/#the-profile-field-object

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Description string - -
ParentID long - -
FieldName string - -
FieldType string - -
LinkType string - -
Required string - -
Exported string - -
Confidential string - -
Restrictions string - -
LookupType string - -

ProspectType

Documentation: https://api.accelo.com/docs/#prospects-sales

Column Type Relates to Notes
RemoteID string - -
ProspectRemoteID string Prospect → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Parent long - -
Title string - -
Standing string - -
Ordering long - -

ProspectProbability

Documentation: https://api.accelo.com/docs/#prospects-sales

Column Type Relates to Notes
RemoteID string - -
ProspectRemoteID string Prospect → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Value long - -
Title string - -
Ordering long - -

ProspectCustomFieldValue

Column Type Relates to Notes
RemoteID string - -
ProspectRemoteID string Prospect → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
ProspectID long Prospect → ID -
ProspectCustomFieldID long ProspectCustomField → ID -
Value string - -

Need more?

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

Connect your own Accelo data Querying Accelo using regular SQL