Explore the AroFlo API data model

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

Try our interactive ERD Or, browse below

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

Asset

Documentation: https://apidocs.aroflo.com/#e2152679-9188-4997-bbc4-38639b44fb7c

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Assetid string - -
OrganisationID string Organisation → Orgid -
ClientID string - -
Customerid string -
  • 22 Sep 2021 All data observed during development shows this coming down as a date - a strange value for a 'customerid'
SupplierID string -
  • 26 Oct 2025 Cannot find data - assuming similar to the client property
AssetCategoryID string - -
Odotype string - -
Modelnumber string - -
Serialnumber string - -
Quantity decimal - -
Barcode string - -
Manufacturer string - -
Assetname string - -
Cost decimal - -
Odo decimal - -
Archived boolean - -
Ordercode string - -
Datecreated datetime - -

Bill

Documentation: https://apidocs.aroflo.com/#2abf26f4-3763-442a-86e2-bf11dcaa0798

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
Billid string - -
Lastupdateddatetimeutc datetime - -
Dateinvoiced datetime - -
Billnumber string - -
WorkOrderID string -
  • 17 Jul 2024 Foreign Key - Refers to `WorkOrder` (not implemented, looks like due to lack of filtering).
OrganisationID string Organisation → Orgid -
Totalinc decimal - -
SupplierID string Supplier → Supplierid -
Totalex decimal - -
Status string - -
IsTaxInclusive int - -
Surchargeamount decimal - -
Totalgst decimal - -
PurchaseOrderID string PurchaseOrder → Purchaseorderid -
Duedate datetime - -
LastUpdatedUserID string User → Userid -

BusinessUnit

Documentation: https://apidocs.aroflo.com/#b7df0fa1-ae48-4d7f-83d3-b554ba001f67

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Orgid string - -
Mailingaddressaddressline1 string - -
Mailingaddressaddressline2 string - -
Mailingaddresspostcode string - -
Mailingaddresssuburb string - -
Mailingaddresscountry string - -
Mailingaddressstate string - -
Addressaddressline1 string - -
Addressaddressline2 string - -
Addresspostcode string - -
Addresssuburb string - -
Addresscountry string - -
Addressstate string - -
Surname string - -
Shortname string - -
Termsnote string - -
Phone string - -
Terms string - -
Firstname string - -
Email string - -
Abn string - -
Businessunitname string - -
Usecustompriorities boolean - -
Archived boolean - -
Fax string - -
Website string - -
Mobile string - -

Client

Documentation: https://apidocs.aroflo.com/#c2f173ac-eb07-4f21-9bce-e0e42e87625d

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Clientid string - -
Firstname string - -
Surname string - -
Shortname string - -
Email string - -
Phone string - -
Abn string - -
Fax string - -
Mobile string - -
Datetimeinserted datetime - -
Termsnote string - -
Terms string - -
Postable boolean - -
Usecustompriorities boolean - -
Dateinserted datetime - -
Clientname string - -
Website string - -
Datecreated datetime - -
MailingAddressCountry string - -
MailingAddressPostcode string - -
MailingAddressline1 string - -
MailingAddressline2 string - -
MailingAddressState string - -
MailingAddressSuburb string - -
AddressCountry string - -
AddressPostcode string - -
Addressline1 string - -
Addressline2 string - -
AddressState string - -
AddressSuburb string - -
TransactionTermID string TransactionTerm → Transactiontermid -

Contact

Documentation: https://apidocs.aroflo.com/#ec1674af-f488-4618-af0d-5a98a5e39e21

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Userid string - -
Createddatetimeutc datetime - -
Surname string - -
Phone string - -
Orgid string Organisation → Orgid -
Contacttype string - -
Email string - -
Email2 string - -
Givennames string - -
Accesstype string - -
Username string - -
Fax string - -
Mobile string - -
Archived boolean - -

Document

Documentation: https://apidocs.aroflo.com/#ec1674af-f488-4618-af0d-5a98a5e39e21

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Documentid string - -
Sizeinbytes int - -
Uploadeddatetime datetime - -
UploadedByUserID string User → Userid -
Categoryid string Category → Categoryid -
Filter string - -
Comment string - -
Url string - -

InventoryCategory

Documentation: https://apidocs.aroflo.com/#d356d600-973d-45a8-b8f4-f9c3ffd44620

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Categoryid string - -
Lastupdateddatetimeutc datetime - -
Issoritem boolean - -
Usebustockalert boolean - -
Marginon string - -
Usechstockalert boolean - -
Useusersstockalert boolean - -
Listorder long - -
ParentCategoryID string InventoryCategory → Categoryid -
Defaultmargin string - -
Bustockalertlevel int - -
Userstockalertlevel int - -
Quoteusing string - -
Chstockalertlevel int - -
Categoryname string - -

Invoice

Documentation: https://apidocs.aroflo.com/#91d24c8f-fd75-45a6-ad4b-d8ec4ad5a3c2

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
Invoiceid string - -
Lastupdateddatetime datetime - -
Status string - -
Custon string - -
Duedate datetime - -
Dateinvoiced datetime - -
Totalinc decimal - -
Invoicenumber string - -
IsTaxInclusive boolean - -
Partinvoice boolean - -
Totalex decimal - -
Surchargeamount decimal - -
Totalgst decimal - -
Deliverystatus string - -
UpdatedByUserID string User → Userid -
AddressLine1 string - -
AddressLine2 string - -
AddressSuburb string - -
AddressPostCode string - -
AddressState string - -
TaskID string Task → Taskid -
ProjectID string - -
OrganisationID string Organisation → Orgid -
ClientID string Client → Clientid -

Item

Documentation: https://apidocs.aroflo.com/#629ae67b-3699-4f1e-a7d9-0bb523c0b08c

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
CategoryID string - -
Itemid string - -
Flexcost decimal - -
Manufacturer string - -
Invcmarginon string - -
Supplier string - -
UseSimplePricing int - -
Taskmarginon string - -
SellQte decimal - -
Invcmargin decimal - -
Costex decimal - -
Partnumber string - -
SellInvc decimal - -
SellTask decimal - -
Taskmargin decimal - -

Location

Documentation: https://apidocs.aroflo.com/#1775c3a3-d001-4ed7-b8cb-e1a571e9c006

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Locationid string - -
Gpslat decimal - -
Gpslong decimal - -
Postcode string - -
SiteContact string - -
State string - -
Suburb string - -
SiteEmail string - -
SitePhone string - -
Locationname string - -
Country string - -
Address string - -
Archived boolean - -
ClientID string Client → Clientid -
SupplierID string Supplier → Supplierid -
BusinessUnitID string BusinessUnit → Orgid -

Organisation

Column Type Relates to Notes
RemoteID string - -
AssetRemoteID string Asset → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Orgid string - -
Orgname string - -

Payment

Documentation: https://apidocs.aroflo.com/#b19e6be1-9a5d-40e7-b26f-0d80dc119d9f

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Paymentid string - -
Datepaid datetime - -
Datelinkprocessed datetime - -
Totalamount decimal - -
Bankaccountnumber string - -
Bankname string - -
Paymentmethodname string - -
Chequenumber string - -
Linkedtoid string - -
LinkedToInvoiceID string Invoice → Invoiceid -
Notes string - -
Surchargeamount decimal - -
Bankcode string - -
Amount decimal - -
Reference string - -
ReceivedByUserID string User → Userid -
Surchargepercentage decimal - -
Bankbranch string - -

Project

Documentation: https://apidocs.aroflo.com/#0314e707-0ad0-4360-83d8-06fe24e56962

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
Projectid string - -
Locationid string Location → Locationid -
Contact string - -
Startdate datetime - -
ProjectType string - -
Enddate datetime - -
Status string - -
Closeddate datetime - -
Refno string - -
Manager string - -
Custon string - -
Projectnumber string - -
Projectname string - -
Substatusid string Substatus → Substatusid -
ManagerUserID string User → Userid -
InsertedByUserID string User → Userid -
ContactUserID string User → Userid -
Projecttypeid string - -
Orgid string Organisation → Orgid -
Estpercentagenostage decimal - -

PurchaseOrder

Documentation: https://apidocs.aroflo.com/#5eb6f285-8137-40fe-9fe1-1bd49df9c89f

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Purchaseorderid string - -
PurchasedByUserID string User → Userid -
Supplierinvoicenumber string - -
Status string - -
Purchasedate datetime - -
Ordernumber string - -
Duedate datetime - -
Dateinvoiced datetime - -
Deliverybydate string - -
Totalex decimal - -
Totalinc decimal - -
Deliverybydatetime datetime - -
Deliveryinstructions string - -
Datereceived datetime - -
IsTaxInclusive boolean - -
Acceptancestatus string - -
AddressLine1 string - -
AddressLine2 string - -
AddressSuburb string - -
AddressPostCode string - -
AddressState string - -
OrganisationID string Organisation → Orgid -
SupplierID string Supplier → Supplierid -

Quote

Documentation: https://apidocs.aroflo.com/#9465b233-6b0a-424b-8c18-43a449dd130a

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
Quoteid string - -
Totalprofitmarginpercent decimal - -
Duedatetime datetime - -
Duedate datetime - -
Rejecteddatetime datetime - -
Rejecteddate datetime - -
Approveddatetime datetime - -
Approveddate datetime - -
Createddatetime datetime - -
Createddate datetime - -
Acceptancedatetime datetime - -
Acceptancedate datetime - -
Acceptanceexpirydatetime datetime - -
Acceptanceexpirydate datetime - -
EstimatorUserID string User → Userid -
Totalhours decimal - -
Status string - -
Totaltax decimal - -
Type string - -
Projectid string Project → Projectid -
Taskid string Task → Taskid -
Jobnumber string - -
Labourcostex decimal - -
Quoteurl string - -
Totalprofit decimal - -
Acceptancestatus string - -
Addresspostcode string - -
Addressstate string - -
Addresssuburb string - -
Address1 string - -
Address2 string - -
Exclusions string - -
Substatusid string Substatus → Substatusid -
Contactname string - -
Orgid string Organisation → Orgid -
Totalex decimal - -
Overallmarkuppercent decimal - -
Subtotal decimal - -
Refno string - -
Quotename string - -
Custon string - -
Totalinc decimal - -
Taskdescription string - -
Materialcostex decimal - -
Clientid string Client → Clientid -
Acceptedbyuserid string User → Userid -
Istaxinclusive boolean - -
Allowancecostex decimal - -
Contactphone string - -

Schedule

Documentation: https://apidocs.aroflo.com/#9bc5a3d8-3884-4542-b5ab-56c0cb59cd4e

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Scheduleid string - -
OrganisationID string Organisation → Orgid -
InsertedByUserID string User → Userid -
ScheduledToUserID string User → Userid -
TaskID string Task → Taskid -
PeriodicID string - -
GroupID string - -
Startdatetime datetime - -
Enddatetime datetime - -
Ishidden boolean - -
Islocked boolean - -
Inserteddatetimeutc datetime - -
Hours decimal - -
Note string - -

Stage

Documentation: https://apidocs.aroflo.com/#5a0f6a65-3201-4040-bb28-e154e4a6e3c1

Column Type Relates to Notes
RemoteID string - -
ProjectRemoteID string Project → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Stageid string - -
Stagename string - -
Status string - -
Startdate datetime - -
Enddate datetime - -
EstimatedPercentage decimal - -
Projectid string Project → Projectid -
Locationid string Location → Locationid -
Substatusid string Substatus → Substatusid -

Substatus

Documentation: https://apidocs.aroflo.com/#a2d71904-aba0-49e3-8f6d-e9f89f747c42

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
Substatusid string - -
Substatustype string - -
Listorder int - -
OrganisationID string Organisation → Orgid -
Substatus string - -
Backgroundcolour string - -
Archived boolean - -

Supplier

Documentation: https://apidocs.aroflo.com/#893437d3-1458-406c-8e6e-7ed3fe8e3260

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Suppliertype string - -
Suppliername string - -
Supplierid string - -
Firstname string - -
Surname string - -
Shortname string - -
Email string - -
Phone string - -
Abn string - -
Fax string - -
Mobile string - -
Datetimeinserted datetime - -
Termsnote string - -
Terms string - -
Postable boolean - -
Dateinserted datetime - -
Website string - -
Datecreated datetime - -

Task

Documentation: https://apidocs.aroflo.com/#8a035593-4198-4c58-b653-6c9241dc31cf

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
ProjectID string Project → Projectid -
Taskid string - -
Lastupdateddatetimeutc datetime - -
ContactID string Contact → Userid -
Completeddatetime datetime - -
Priority string - -
Gpslongitude decimal - -
Gpslatitude decimal - -
Requestdatetime datetime - -
Lastupdatedutc datetime - -
Status string - -
Refcode string - -
Duedate datetime - -
Jobnumber string - -
Taskname string - -
Readtaskdatetime datetime - -
Completeddate datetime - -
Custon string - -
Readtask boolean - -
Duedatetime datetime - -
Linkprocessed boolean - -
WebappEncodedID string - -
ClientID string Client → Clientid -
OrganisationID string Organisation → Orgid -
SubstatusID string Substatus → Substatusid -
TaskTypeID string TaskType → Tasktypeid -
LocationID string - -

TaskSalesPerson

Documentation: https://apidocs.aroflo.com/#250ed7e0-1597-451d-a7ad-663bc2427e83

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

TaskAssignedHistory

Documentation: https://apidocs.aroflo.com/#2fd66716-6dee-42eb-aa33-b1101422a8b9

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TaskID string Task → Taskid -
UserID string User → Userid -
Timeunassigned string - -
OrgID string Organisation → Orgid -
Readtaskdatetime datetime - -
Dateunassigned datetime - -
Dateassigned datetime - -
Readtask boolean - -

TaskNote

Documentation: https://apidocs.aroflo.com/#cd1572cb-f3f1-48f4-9227-cea0efe01882

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TaskID string Task → Taskid -
Noteid string - -
Filter string - -
Note string - -
Content string - -
Sticky boolean - -
Userid string User → Userid -
Timeposted datetime - -
Dateposted datetime - -

TaskAsset

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TaskID string Task → Taskid -
Assetid string Asset → Assetid -

TaskExpense

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
TaskID string Task → Taskid -
Lineid string - -
UserID string User → Userid -
Overheadallocation string - -
Cost decimal - -
Sell decimal - -
Quantity decimal - -
Dateused datetime - -

TaskLabour

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TaskID string Task → Taskid -
Lineid string - -
UserID string User → Userid -
Labverified boolean - -
Worktype string - -
Workdatetimestart datetime - -
Workdatetimeend datetime - -
Lablinkprocesseddatetime datetime - -
Endtime datetime - -
Lablinkprocesseddate datetime - -
Deleted int -
  • 31 Aug 2021 The deleted field comes down as an integer, not a true/false boolean
Lablinkprocessed boolean - -
Cost decimal - -
Starttime datetime - -
Deleteddate datetime - -
Hours decimal - -
Sell decimal - -
Labeodapproved boolean - -
Note string - -
Lablocked boolean - -
Workdate datetime - -
Deleteddatetime datetime - -

TaskMaterial

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TaskID string Task → Taskid -
Lineid string - -
Matlinkprocesseddatetime datetime - -
Matlinkprocesseddate datetime - -
Quantity decimal - -
Matlinkprocessed boolean - -
Purchaseorderisordered boolean - -
Deleted boolean - -
Cost decimal - -
Deleteddate datetime - -
Sell decimal - -
Purchaseorderqtybilled string - -
Partnumber string - -
Purchaseorderqtyordered string - -
Deletedtime string - -
Dateused datetime - -
Itemid string Item → Itemid -
Isinventory boolean - -
Deleteddatetime datetime - -

TaskType

Documentation: https://apidocs.aroflo.com/#8ff2c823-1ffa-4347-8903-5be8c2d67c83

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
Tasktypeid string - -
Tasktype string - -
Archived boolean - -

Timesheet

Documentation: https://apidocs.aroflo.com/#0b518062-47b5-453c-933f-388ba72626d2

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Timesheetid string - -
UserID string User → Userid -
InsertedByUserID string User → Userid -
VerifiedByUserID string User → Userid -
WhenVerified datetime - -
TaskID string Task → Taskid -
WorktypeID string WorkType → Worktypeid -
TrackingCenterID string TrackingCentre → Trackingcentreid -
OverheadID string - -
OverheadUnit string - -
OverheadName string - -
OverheadType string - -
GroupID string - -
TSGroupID string - -
Chargerate decimal - -
Costrate decimal - -
Inserteddatetimeutc datetime - -
Cost decimal - -
Hours decimal - -
Hourlyrate decimal - -
Note string - -
Startdatetime datetime - -
Finishdatetime datetime - -
Type string - -
Charge decimal - -
Workdate datetime - -
Resourceoverheadrate decimal - -

TrackingCentre

Documentation: https://apidocs.aroflo.com/#9133b520-0dc3-4de0-893c-bc4c8f857bfd

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Trackingcentreid string - -
BusinessUnitID string BusinessUnit → Orgid -
Datecreated datetime - -
Archive boolean - -
Allowlabour boolean - -
Allowasset boolean - -
Datearchived datetime - -
Allowfreight boolean - -
Allowmaterial boolean - -
Allowexpense boolean - -

TransactionTerm

Documentation: https://apidocs.aroflo.com/#3bd1ffc3-4cd2-4323-a185-c5ceb35a5fc5

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Transactiontermid string - -
Listorder int - -
Transactionterm string - -
Termdays int - -
Archived boolean - -

User

Documentation: https://apidocs.aroflo.com/#273aed78-4ce9-48c2-848d-946f6f486618

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Userid string - -
OrganisationID string Organisation → Orgid -
UserPositionID string UserPosition → Positionid -
Surname string - -
Phone string - -
Email string - -
Email2 string - -
Fax string - -
Mobile string - -
Givennames string - -
Accesstype string - -
Username string - -
Archived boolean - -

UserPosition

Documentation: https://apidocs.aroflo.com/#45fa54b0-9ae9-4ee6-ac97-886f0fbdae43

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Position string - -
Listorder int - -
OrganisationID string Organisation → Orgid -
Archive boolean - -
Positionid string - -

WorkType

Column Type Relates to Notes
RemoteID string - -
TimesheetRemoteID string Timesheet → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Worktypeid string - -
Worktyperatetype string - -
Worktype string - -
Worktypedescription string - -

AssetCustomField

Column Type Relates to Notes
RemoteID string - -
AssetRemoteID string Asset → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Fieldid string - -
Assetid string Asset → Assetid -
Value string - -
Archived boolean - -
Type string - -

BillLineItem

Column Type Relates to Notes
RemoteID string - -
BillRemoteID string Bill → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
BillID string Bill → Billid -
Lineid string - -
Accountcode string - -
Total decimal - -
Price decimal - -
Itemtype string - -
Taxamount decimal - -
Taskid string Task → Taskid -
Taxcode string - -
Qty decimal - -
Itemid string Item → Itemid -
Ordercode string - -
Taxrate decimal - -

BillNote

Column Type Relates to Notes
RemoteID string - -
BillRemoteID string Bill → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
BillID string Bill → Billid -
Noteid string - -
Timeposted datetime - -
Filter string - -
Content string - -
UserID string User → Userid -

BillTask

Column Type Relates to Notes
RemoteID string - -
BillRemoteID string Bill → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
BillID string Bill → Billid -
Taskid string Task → Taskid -

ClientOrganisation

Column Type Relates to Notes
RemoteID string - -
ClientRemoteID string Client → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ClientID string Client → Clientid -
OrganisationID string Organisation → Orgid -

ClientCustomField

Column Type Relates to Notes
RemoteID string - -
ClientRemoteID string Client → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Fieldid string - -
Clientid string Client → Clientid -
Value string - -
Archived boolean - -
Type string - -

InvoiceLine

Column Type Relates to Notes
RemoteID string - -
InvoiceRemoteID string Invoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
InvoiceID string Invoice → Invoiceid -
Lineid string - -
TaskID string Task → Taskid -
Accountcode string - -
Trackingcentreid string - -
Qtybilled decimal - -
Total decimal - -
Price decimal - -
Itemtype string - -
Transactioncode string - -
Qtyused decimal - -
Taxamount decimal - -
Itemid string Item → Itemid -
Ordercode string - -
Taxcode string - -
Taxrate decimal - -

LocationCustomField

Column Type Relates to Notes
RemoteID string - -
LocationRemoteID string Location → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Fieldid string - -
Locationid string Location → Locationid -
Value string - -
Archived boolean - -
Type string - -

ProjectCustomField

Column Type Relates to Notes
RemoteID string - -
ProjectRemoteID string Project → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Fieldid string - -
Projectid string Project → Projectid -
Value string - -
Archived boolean - -
Type string - -

PurchaseOrderTask

Column Type Relates to Notes
RemoteID string - -
PurchaseOrderRemoteID string PurchaseOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PurchaseOrderID string PurchaseOrder → Purchaseorderid -
Taskid string Task → Taskid -

PurchaseOrderLine

Column Type Relates to Notes
RemoteID string - -
PurchaseOrderRemoteID string PurchaseOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
PurchaseOrderID string PurchaseOrder → Purchaseorderid -
Lineid string - -
Accountcode string - -
Qtybilled decimal - -
Total decimal - -
Price decimal - -
Qtyordered decimal - -
Partno string - -
Transactioncode string - -
Taxamount decimal - -
Taskid string Task → Taskid -
Cost decimal - -
Taskisused boolean - -
Taxcode string - -
Taskqtyused decimal - -
Itemid string Item → Itemid -
Taxrate decimal - -
Trackingcentreid string TrackingCentre → Trackingcentreid -

PurchaseOrderProject

Column Type Relates to Notes
RemoteID string - -
PurchaseOrderRemoteID string PurchaseOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PurchaseOrderID string PurchaseOrder → Purchaseorderid -
Projectid string - -

QuoteLine

Column Type Relates to Notes
RemoteID string - -
QuoteRemoteID string Quote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Quoteid string Quote → Quoteid -
Lineid string - -
Parentlineid string QuoteLine → Lineid -
Trackingcentreid string TrackingCentre → Trackingcentreid -
Itemid string Item → Itemid -
Item string - -
Itemtype string - -
Worktypevalue decimal - -
Worktype string - -
Optiongroupname string - -
Partno string - -
Isapproved boolean - -
Totalex decimal - -
Labourunitrate decimal - -
Cost decimal - -
Taxcode string - -
Qty decimal - -
Totaltax decimal - -
Isoptional boolean - -
Takeoffname string - -
Taxrate decimal - -
Labourtrackingcentreid string - -
Totalinc decimal - -
Sell decimal - -
Labourtotal decimal - -
Markup decimal - -
Labourmarkup decimal - -

SupplierOrganisation

Column Type Relates to Notes
RemoteID string - -
SupplierRemoteID string Supplier → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
SupplierID string Supplier → Supplierid -
OrganisationID string Organisation → Orgid -

TaskCustomField

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Fieldid string - -
Taskid string Task → Taskid -
Value string - -
Archived boolean - -
Type string - -

TaskTypeBusinessUnit

Column Type Relates to Notes
RemoteID string - -
TaskTypeRemoteID string TaskType → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Orgid string - -
Tasktypeid string TaskType → Tasktypeid -

UserCustomField

Column Type Relates to Notes
RemoteID string - -
UserRemoteID string User → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Fieldid string - -
Userid string User → Userid -
Value string - -
Archived boolean - -
Type string - -

Need more?

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

Connect your own AroFlo data Querying AroFlo using regular SQL