Explore the WorkflowMax API data model

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

Try our interactive ERD Or, browse below

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

Account

Documentation: https://api-docs.workflowmax.com/account

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Code string - -
Type string - -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

Client

Documentation: https://api-docs.workflowmax.com/client

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
ClientManagerUUID string Staff → Uuid -
JobManagerUUID string Staff → Uuid -
ExportCode string - -
ReferralSource string - -
Prospect boolean - -
Archived boolean - -
Favourite boolean - -
ContactDetailsEmail string - -
ContactDetailsPhone string - -
ContactDetailsFax string - -
ContactDetailsWebsite string - -
BillingDetailsBusinessStructureUUID string -
  • 16 Feb 2025 Foreign Key - Refers to 'BusinessStructure' (not implemented).
BillingDetailsClientTypeUUID string -
  • 16 Feb 2025 Foreign Key - Refers to 'ClientType' (not implemented).
BillingDetailsBalanceDate datetime - -
BillingDetailsMarkup decimal - -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

ClientContact

Documentation: https://api-docs.workflowmax.com/client-contact

Column Type Relates to Notes
RemoteID string - -
ClientRemoteID string Client → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
ClientUUID string Client → Uuid -
FirstName string - -
LastName string - -
Salutation string - -
Addressee string - -
Mobile string - -
Email string - -
Phone string - -
Favourite boolean - -
Archived boolean - -
DeletedAt datetime - -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

ClientGroup

Documentation: https://api-docs.workflowmax.com/client-group

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Taxable boolean - -
Favourite boolean - -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

Cost

Documentation: https://api-docs.workflowmax.com/cost

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
CostCode string - -
Note string - -
Type string - -
Billable boolean - -
UnitCost decimal - -
UnitPrice decimal - -
IncomeAccount string - -
CostOfSaleAccount string - -
SupplierUuid string Supplier → Uuid -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

CustomField

Documentation: https://api-docs.workflowmax.com/custom-field

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Type string - -
Mandatory boolean - -
ClientEnabled boolean - -
ClientOrder int - -
ContactEnabled boolean - -
ContactOrder int - -
SupplierEnabled boolean - -
SupplierOrder int - -
JobEnabled boolean - -
JobOrder int - -
LeadEnabled boolean - -
LeadOrder int - -
JobTaskEnabled boolean - -
JobTaskOrder int - -
JobCostEnabled boolean - -
JobCostOrder int - -
TimesheetEnabled boolean - -
TimesheetOrder int - -
QuoteEnabled boolean - -
QuoteOrder int - -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

Invoice

Documentation: https://api-docs.workflowmax.com/invoice

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
InvoiceNumber string - -
ClientUUID string Client → Uuid -
ContactUUID string ClientContact → Uuid -
Date datetime - -
DueDate datetime - -
Sent boolean - -
Status string - -
Type string - -
Mode string - -
ProgressDate datetime - -
FixedPrice boolean - -
AmountExTax decimal - -
AmountIncTax decimal - -
AmountPaid decimal - -
DatePaid datetime - -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

Job

Documentation: https://api-docs.workflowmax.com/job-1

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Description string - -
JobNumber string - -
ClientOrderNumber string - -
Budget decimal - -
ClientUUID string Client → Uuid -
ClientContactUUID string ClientContact → Uuid -
JobStatusUUID string JobStatus → Uuid -
JobCategoryUUID string JobCategory → Uuid -
Priority string - -
TaskInvoiceRate string - -
ExcludeEstimatedBillings boolean - -
EstimatedBillings decimal - -
CapacityReducing boolean - -
ClientManagerUUID string Staff → Uuid -
JobManagerUUID string Staff → Uuid -
StartDate datetime - -
DueDate datetime - -
CompletedDate datetime - -
DeletedAt datetime - -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

JobCategory

Documentation: https://api-docs.workflowmax.com/job/get-job-categories

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Description string - -
IncomeAccount string Account → Code -
CostOfSaleAccount string Account → Code -
DeletedAt datetime - -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

JobStatus

Documentation: https://api-docs.workflowmax.com/job/get-v2-job-status

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Type string - -
ShowInMyJobs boolean - -
ShowInSchedule boolean - -
LockCosts boolean - -
LockTimesheets boolean - -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

JobTask

Documentation: https://api-docs.workflowmax.com/job-task

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Description string - -
TaskUUID string Task → Uuid -
Label string - -
Billable boolean - -
CustomBillableRate decimal - -
CompletedAt datetime - -
StartDate datetime - -
EndDate datetime - -
EstimatedMinutes int - -
ActualMinutes int - -
Order int - -
JobUUID string Job → Uuid -
PhaseUUID string JobPhase → Uuid -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

Lead

Documentation: https://api-docs.workflowmax.com/lead-1

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Description string - -
Status string - -
Date datetime - -
ClientUUID string Client → Uuid -
ContactUUID string ClientContact → Uuid -
LeadCategoryUUID string LeadCategory → Uuid -
EstimatedValue decimal - -
EstimatedStartDate datetime - -
EstimatedDuration int - -
WonLostDate datetime - -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

LeadCategory

Documentation: https://api-docs.workflowmax.com/lead/get-v2-lead-categories

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
DeletedAt datetime - -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

PurchaseOrder

Documentation: https://api-docs.workflowmax.com/po-2

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
SupplierUUID string Supplier → Uuid -
PurchaseOrderNumber string - -
Status string - -
BillingStatus string - -
StockReceiptStatus string - -
DeliveryAddress string - -
Date datetime - -
Sent boolean - -
AmountExTax decimal - -
AmountIncTax decimal - -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

PurchaseOrderBill

Documentation: https://api-docs.workflowmax.com/po-bill-2

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PurchaseOrderUUID string PurchaseOrder → Uuid -
Date datetime - -
DueDate datetime - -
ReceiptDate datetime - -
SupplierBillNumber string - -
Status string - -
StockReceiptID string - -
AmountExTax decimal - -
AmountIncTax decimal - -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

PurchaseOrderStockReceipt

Documentation: https://api-docs.workflowmax.com/po-stock-receipt-2

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PurchaseOrderUUID string PurchaseOrder → Uuid -
StockReceiptNote string - -
StockReceiptID string - -
SupplierBillNumber string - -
Date datetime - -
BillDate datetime - -
DueDate datetime - -
AmountExTax decimal - -
AmountIncTax decimal - -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

Quote

Documentation: https://api-docs.workflowmax.com/quote

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
QuoteName string - -
QuoteNumber string - -
JobMasterQuote boolean - -
Type string - -
OptionItemsExplanation string - -
ClientUUID string Client → Uuid -
ContactUUID string ClientContact → Uuid -
SalespersonUUID string Staff → Uuid -
ValidFrom datetime - -
ValidTo datetime - -
Sent boolean - -
Status string - -
AcceptedDeclinedDate datetime - -
Budget decimal - -
FixedPrice boolean - -
AmountExTax decimal - -
AmountIncTax decimal - -
CostAmountExTax decimal - -
LeadUUID string Lead → Uuid -
JobUUID string Job → Uuid -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

Role

Documentation: https://api-docs.workflowmax.com/role

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

Staff

Documentation: https://api-docs.workflowmax.com/staff

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
FirstName string - -
LastName string - -
CurrentlyWorking boolean - -
BaseRate decimal - -
BillableRate decimal - -
Director boolean - -
FreeEarner boolean - -
FullTimeEquivalent decimal - -
PayrollCode string - -
Notes string - -
Role string - -
ContactEmail string - -
ContactMobile string - -
ContactPhone string - -
ContactAddress string - -
CapacityProductivityRate string - -
CapacityMonday string - -
CapacityTuesday string - -
CapacityWednesday string - -
CapacityThursday string - -
CapacityFriday string - -
DeletedAt datetime - -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

Supplier

Documentation: https://api-docs.workflowmax.com/supplier

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
ExportCode string - -
Status string - -
Starred boolean - -
ContactEmail string - -
ContactPhone string - -
ContactFax string - -
ContactWebsite string - -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

SupplierContact

Documentation: https://api-docs.workflowmax.com/supplier-contacts

Column Type Relates to Notes
RemoteID string - -
SupplierRemoteID string Supplier → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
SupplierUUID string Supplier → Uuid -
FirstName string - -
LastName string - -
Phone string - -
Mobile string - -
Email string - -
Position string - -
Primary boolean - -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

Task

Documentation: https://api-docs.workflowmax.com/task

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Description string - -
BaseRate decimal - -
BillableRate decimal - -
ExportCode string - -
IncomeAccount string - -
DeletedAt datetime - -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

Timesheet

Documentation: https://api-docs.workflowmax.com/timesheet

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Date datetime - -
Time int - -
Note string - -
Billable boolean - -
SubmittedAt datetime - -
JobUuid string Job → Uuid -
JobTaskUuid string JobTask → Uuid -
StaffUuid string Staff → Uuid -
WipBaseRate decimal - -
WipCostAmount decimal - -
WipStandardRate decimal - -
WipStandardAmount decimal - -
WipChargeRate decimal - -
WipChargeAmount decimal - -
WipInvoiceInvoiceUUID string Invoice → Uuid -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

ClientAddress

Column Type Relates to Notes
RemoteID string - -
ClientRemoteID string Client → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ClientUUID string Client → Uuid -
LineNumber int - -
Type string - -
Default boolean - -
Address string - -
City string - -
State string - -
PostalCode string - -
Country string - -

ClientBillingCustomRate

Column Type Relates to Notes
RemoteID string - -
ClientRemoteID string Client → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ClientUUID string Client → Uuid -
TaskUUID string Task → Uuid -
BillableRate decimal - -

ClientBillingTaxNumber

Column Type Relates to Notes
RemoteID string - -
ClientRemoteID string Client → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
ClientUUID string Client → Uuid -
LineNumber int - -
Number string - -

ClientLinkedGroup

Column Type Relates to Notes
RemoteID string - -
ClientRemoteID string Client → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ClientUUID string Client → Uuid -
Uuid string ClientGroup → Uuid -

ClientRelationship

Column Type Relates to Notes
RemoteID string - -
ClientRemoteID string Client → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ClientUUID string Client → Uuid -
Uuid string - -
RelatedClientUUID string Client → Uuid -
Type string - -
StartDate datetime - -
EndDate datetime - -

ClientCustomField

Column Type Relates to Notes
RemoteID string - -
ClientRemoteID string Client → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ClientUUID string Client → Uuid -
Uuid string CustomField → Uuid -
Value string - -

ClientNote

Column Type Relates to Notes
RemoteID string - -
ClientRemoteID string Client → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
ClientUUID string Client → Uuid -
Title string - -
Date datetime - -
Phase string - -
CreatedByFirstName string - -
CreatedByLastName string - -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

ClientDocument

Column Type Relates to Notes
RemoteID string - -
ClientRemoteID string Client → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ClientUUID string Client → Uuid -
Title string - -
FileName string - -
FileSize long - -
Note string - -
Phase string - -
DownloadURL string - -
UploadedByName string - -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

ClientContactCustomField

Column Type Relates to Notes
RemoteID string - -
ClientContactRemoteID string ClientContact → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ClientContactUUID string ClientContact → Uuid -
Uuid string CustomField → Uuid -
Value string - -

ClientGroupClient

Column Type Relates to Notes
RemoteID string - -
ClientGroupRemoteID string ClientGroup → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ClientGroupUUID string ClientGroup → Uuid -
Uuid string Client → Uuid -

CostSaleTax

Column Type Relates to Notes
RemoteID string - -
CostRemoteID string Cost → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CostUUID string Cost → Uuid -
LineNumber int - -
TaxName string - -
Rate decimal - -

CostPurchaseTax

Column Type Relates to Notes
RemoteID string - -
CostRemoteID string Cost → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CostUUID string Cost → Uuid -
LineNumber int - -
TaxName string - -
Rate decimal - -

CustomFieldOption

Column Type Relates to Notes
RemoteID string - -
CustomFieldRemoteID string CustomField → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CustomFieldUUID string CustomField → Uuid -
LineNumber int - -
Option string - -

InvoiceJob

Column Type Relates to Notes
RemoteID string - -
InvoiceRemoteID string Invoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InvoiceUUID string Invoice → Uuid -
Uuid string Client → Uuid -

InvoiceNote

Column Type Relates to Notes
RemoteID string - -
InvoiceRemoteID string Invoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
InvoiceUUID string Invoice → Uuid -
Title string - -
Phase string - -
Date datetime - -
CreatedByUUID string Staff → Uuid -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

InvoicePayment

Column Type Relates to Notes
RemoteID string - -
InvoiceRemoteID string Invoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InvoiceUUID string Invoice → Uuid -
LineNumber int - -
CreatedAt datetime - -
UpdatedAt datetime - -
Date datetime - -
Amount decimal - -
Reference string - -
AccountUUID string - -

JobCustomField

Column Type Relates to Notes
RemoteID string - -
JobRemoteID string Job → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
JobUUID string Job → Uuid -
Uuid string CustomField → Uuid -
Value string - -

JobCost

Column Type Relates to Notes
RemoteID string - -
JobRemoteID string Job → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
JobUUID string Job → Uuid -
CostUUID string Cost → Uuid -
Date datetime - -
Quantity decimal - -
Actual boolean - -
UnitPrice decimal - -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

JobNote

Column Type Relates to Notes
RemoteID string - -
JobRemoteID string Job → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
JobUUID string Job → Uuid -
Title string - -
PhaseUUID string JobPhase → Uuid -
Date datetime - -
CreatedByUUID string Staff → Uuid -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

JobDocument

Column Type Relates to Notes
RemoteID string - -
JobRemoteID string Job → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
JobUUID string Job → Uuid -
Title string - -
FileName string - -
FileSize long - -
DownloadURL string - -
PhaseUUID string JobPhase → Uuid -
UploadedByUUID string Staff → Uuid -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

JobStaffAssigned

Column Type Relates to Notes
RemoteID string - -
JobRemoteID string Job → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
JobUUID string Job → Uuid -
Uuid string Staff → Uuid -
CustomBillableRate decimal - -

JobPhase

Column Type Relates to Notes
RemoteID string - -
JobRemoteID string Job → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Description string - -
JobUUID string Job → Uuid -
Order int - -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

JobMilestone

Column Type Relates to Notes
RemoteID string - -
JobRemoteID string Job → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
JobUUID string Job → Uuid -
LineNumber int - -
Date datetime - -
PhaseUUID string JobPhase → Uuid -
CompletedAt datetime - -
CompletedByUUID string Staff → Uuid -

JobQuote

Column Type Relates to Notes
RemoteID string - -
JobRemoteID string Job → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
JobUUID string Job → Uuid -
Uuid string Quote → Uuid -

JobInvoice

Column Type Relates to Notes
RemoteID string - -
JobRemoteID string Job → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
JobUUID string Job → Uuid -
Uuid string Invoice → Uuid -

JobPurchaseOrder

Column Type Relates to Notes
RemoteID string - -
JobRemoteID string Job → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
JobUUID string Job → Uuid -
Uuid string PurchaseOrder → Uuid -

JobTaskToDo

Column Type Relates to Notes
RemoteID string - -
JobTaskRemoteID string JobTask → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
JobTaskUUID string JobTask → Uuid -
Uuid string - -
Order int - -
Completed boolean - -
CompletedByUUID string Staff → Uuid -
CreatedAt datetime - -
UpdatedAt datetime - -

JobTaskStaff

Column Type Relates to Notes
RemoteID string - -
JobTaskRemoteID string JobTask → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
JobTaskUUID string JobTask → Uuid -
Uuid string Staff → Uuid -
AllocatedTime long - -

JobTaskCustomField

Column Type Relates to Notes
RemoteID string - -
JobTaskRemoteID string JobTask → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
JobTaskUUID string JobTask → Uuid -
Uuid string CustomField → Uuid -
Value string - -

JobTaskNote

Column Type Relates to Notes
RemoteID string - -
JobTaskRemoteID string JobTask → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
JobTaskUUID string JobTask → Uuid -
Title string - -
Date datetime - -
CreatedByUUID string Staff → Uuid -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

JobTaskTimesheet

Column Type Relates to Notes
RemoteID string - -
JobTaskRemoteID string JobTask → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
JobTaskUUID string JobTask → Uuid -
Uuid string Timesheet → Uuid -

LeadCustomField

Column Type Relates to Notes
RemoteID string - -
LeadRemoteID string Lead → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
LeadUUID string Lead → Uuid -
Uuid string CustomField → Uuid -
Value string - -

LeadNote

Column Type Relates to Notes
RemoteID string - -
LeadRemoteID string Lead → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
LeadUUID string Lead → Uuid -
Title string - -
Phase string - -
Date datetime - -
CreatedByUUID string Staff → Uuid -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

LeadDocument

Column Type Relates to Notes
RemoteID string - -
LeadRemoteID string Lead → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
LeadUUID string Lead → Uuid -
Title string - -
FileName string - -
FileSize long - -
Note string - -
Phase string - -
DownloadURL string - -
UploadedByUUID string Staff → Uuid -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

LeadActivity

Column Type Relates to Notes
RemoteID string - -
LeadRemoteID string Lead → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
LeadUUID string Lead → Uuid -
DueDate datetime - -
Subject string - -
CreatedBy string - -
Completed boolean - -
AssigneeUUID string Staff → Uuid -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

LeadQuote

Column Type Relates to Notes
RemoteID string - -
LeadRemoteID string Lead → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
LeadUUID string Lead → Uuid -
Uuid string Quote → Uuid -

PurchaseOrderJob

Column Type Relates to Notes
RemoteID string - -
PurchaseOrderRemoteID string PurchaseOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PurchaseOrderUUID string PurchaseOrder → Uuid -
JobUUID string Job → Uuid -

PurchaseOrderCost

Column Type Relates to Notes
RemoteID string - -
PurchaseOrderRemoteID string PurchaseOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PurchaseOrderUUID string PurchaseOrder → Uuid -
JobUUID string Job → Uuid -
JobCostUUID string JobCost → Uuid -
CostUUID string Cost → Uuid -
Quantity decimal - -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

PurchaseOrderNote

Column Type Relates to Notes
RemoteID string - -
PurchaseOrderRemoteID string PurchaseOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
PurchaseOrderUUID string PurchaseOrder → Uuid -
Title string - -
Phase string - -
Date datetime - -
CreatedByUUID string Staff → Uuid -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

PurchaseOrderDocument

Column Type Relates to Notes
RemoteID string - -
PurchaseOrderRemoteID string PurchaseOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PurchaseOrderUUID string PurchaseOrder → Uuid -
Title string - -
FileName string - -
FileSize long - -
Note string - -
DownloadURL string - -
UploadedByUUID string Staff → Uuid -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

PurchaseOrderBillTax

Column Type Relates to Notes
RemoteID string - -
PurchaseOrderBillRemoteID string PurchaseOrderBill → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PurchaseOrderBillUUID string PurchaseOrderBill → Uuid -
LineNumber int - -
TaxName string - -
Rate decimal - -

PurchaseOrderBillCost

Column Type Relates to Notes
RemoteID string - -
PurchaseOrderBillRemoteID string PurchaseOrderBill → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
PurchaseOrderBillUUID string PurchaseOrderBill → Uuid -
Additional boolean - -
PurchaseOrderCostUUID string PurchaseOrderCost → Uuid -
PurchaseOrderAdditionalCostUUID string - -
Quantity decimal - -
UnitCost decimal - -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

PurchaseOrderStockReceiptTax

Column Type Relates to Notes
RemoteID string - -
PurchaseOrderStockReceiptRemoteID string PurchaseOrderStockReceipt → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PurchaseOrderStockReceiptUUID string PurchaseOrderStockReceipt → Uuid -
LineNumber int - -
TaxName string - -
Rate decimal - -

PurchaseOrderStockReceiptCost

Column Type Relates to Notes
RemoteID string - -
PurchaseOrderStockReceiptRemoteID string PurchaseOrderStockReceipt → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
PurchaseOrderStockReceiptUUID string PurchaseOrderStockReceipt → Uuid -
Additional boolean - -
PurchaseOrderCostUUID string PurchaseOrderCost → Uuid -
PurchaseOrderAdditionalCostUUID string - -
Quantity decimal - -
UnitCost decimal - -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

QuotePhase

Column Type Relates to Notes
RemoteID string - -
QuoteRemoteID string Quote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Description string - -
QuoteUUID string Quote → Uuid -
JobPhaseUUID string JobPhase → Uuid -
Order int - -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

QuoteTask

Column Type Relates to Notes
RemoteID string - -
QuoteRemoteID string Quote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
QuoteUUID string Quote → Uuid -
Optional boolean - -
Accepted boolean - -
Time int - -
StaffRates decimal - -
FixedPrice boolean - -
CostAmount decimal - -
Amount decimal - -
Order int - -
TaskUUID string Task → Uuid -
JobTaskUUID string JobTask → Uuid -
QuotePhaseUUID string QuotePhase → Uuid -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

QuoteCost

Column Type Relates to Notes
RemoteID string - -
QuoteRemoteID string Quote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
QuoteUUID string Quote → Uuid -
CostUUID string Cost → Uuid -
JobCostUUID string JobCost → Uuid -
QuotePhaseUUID string QuotePhase → Uuid -
Quantity decimal - -
UnitPrice decimal - -
Optional boolean - -
Accepted boolean - -
FixedPrice boolean - -
Amount decimal - -
Order int - -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

QuoteCustomField

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

QuoteNote

Column Type Relates to Notes
RemoteID string - -
QuoteRemoteID string Quote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
QuoteUUID string Quote → Uuid -
Title string - -
Phase string - -
Date datetime - -
CreatedByUUID string Staff → Uuid -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

QuoteDocument

Column Type Relates to Notes
RemoteID string - -
QuoteRemoteID string Quote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
QuoteUUID string Quote → Uuid -
Title string - -
FileName string - -
FileSize long - -
Note string - -
Phase string - -
DownloadURL string - -
UploadedByUUID string Staff → Uuid -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

StaffCustomTaskRate

Column Type Relates to Notes
RemoteID string - -
StaffRemoteID string Staff → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
StaffUUID string Staff → Uuid -
TaskUUID string - -
BaseRate decimal - -
BillableRate decimal - -

StaffHistoricRate

Column Type Relates to Notes
RemoteID string - -
StaffRemoteID string Staff → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
StaffUUID string Staff → Uuid -
AppliedUpToDate datetime - -
BillableRate decimal - -

SupplierAddress

Column Type Relates to Notes
RemoteID string - -
SupplierRemoteID string Supplier → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
SupplierUUID string Supplier → Uuid -
LineNumber int - -
Type string - -
Address string - -
Street string - -
City string - -
State string - -
PostalCode string - -
Country string - -

SupplierCustomField

Column Type Relates to Notes
RemoteID string - -
SupplierRemoteID string Supplier → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
SupplierUUID string Supplier → Uuid -
Uuid string CustomField → Uuid -
Value string - -

SupplierNote

Column Type Relates to Notes
RemoteID string - -
SupplierRemoteID string Supplier → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
SupplierUUID string Supplier → Uuid -
Title string - -
Phase string - -
Note string - -
CreatedByUUID string Staff → Uuid -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

SupplierDocument

Column Type Relates to Notes
RemoteID string - -
SupplierRemoteID string Supplier → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
SupplierUUID string Supplier → Uuid -
Title string - -
FileName string - -
FileSize long - -
Note string - -
Phase string - -
DownloadURL string - -
UploadedBy string - -
Uuid string - -
CreatedAt datetime - -
UpdatedAt datetime - -

SupplierContactCustomField

Column Type Relates to Notes
RemoteID string - -
SupplierContactRemoteID string SupplierContact → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
SupplierContactUUID string SupplierContact → Uuid -
Uuid string CustomField → Uuid -
Value string - -

TaskCustomClientRate

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TaskUUID string Task → Uuid -
ClientUUID string Client → Uuid -
BillableRate decimal - -

TaskCustomStaffRate

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TaskUUID string Task → Uuid -
StaffUUID string Staff → Uuid -
BaseRate decimal - -
BillableRate decimal - -

TaskHistoricRate

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TaskUUID string Task → Uuid -
LineNumber int - -
AppliedUpTo datetime - -
BillableRate decimal - -

TaskTax

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TaskUUID string Task → Uuid -
LineNumber int - -
TaxName string - -
Rate decimal - -

TimesheetCustomField

Column Type Relates to Notes
RemoteID string - -
TimesheetRemoteID string Timesheet → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TimesheetUUID string Timesheet → Uuid -
Uuid string CustomField → Uuid -
Value string - -

JobTaskNoteComment

Column Type Relates to Notes
RemoteID string - -
JobTaskNoteRemoteID string JobTaskNote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
JobTaskNoteUUID string JobTaskNote → Uuid -
LineNumber int - -
CreatedAt datetime - -
UpdatedAt datetime - -
CreatedByUUID string Staff → Uuid -
Comment string - -

PurchaseOrderBillCostTax

Column Type Relates to Notes
RemoteID string - -
PurchaseOrderBillCostRemoteID string PurchaseOrderBillCost → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PurchaseOrderBillCostUUID string PurchaseOrderBillCost → Uuid -
LineNumber int - -
TaxName string - -
Rate decimal - -

PurchaseOrderStockReceiptCostTax

Column Type Relates to Notes
RemoteID string - -
PurchaseOrderStockReceiptCostRemoteID string PurchaseOrderStockReceiptCost → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PurchaseOrderStockReceiptCostUUID string PurchaseOrderStockReceiptCost → Uuid -
LineNumber int - -
TaxName string - -
Rate decimal - -

Need more?

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

Connect your own WorkflowMax data Querying WorkflowMax using regular SQL