2024 is the year of the connector - vote here

Explore the MYOB Business API data model

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

Try our interactive ERD

Pulling data from the MYOB Business 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 MYOB Business 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://developer.myob.com/api/myob-business-api/v2/generalledger/account/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Description string - -
UID guid - -
LastModified datetime - -
IsActive boolean - -
DisplayID string - -
Classification string - -
Type string - -
Number int - -
ParentAccountUID guid Account → UID -
TaxCodeUID guid TaxCode → UID -
Level int - -
OpeningBalance decimal - -
CurrentBalance decimal - -
IsHeader boolean - -
LastReconciledDate datetime - -

Customer

Documentation: https://developer.myob.com/api/myob-business-api/v2/contact/customer/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UID guid - -
LastModified datetime - -
IsActive boolean - -
LastName string - -
FirstName string - -
IsIndividual boolean - -
DisplayID string - -
Notes string - -
SellingDetailsSaleLayout string - -
SellingDetailsPrintedFrom string - -
SellingDetailsInvoiceDelivery string - -
SellingDetailsItemPriceLevel string - -
SellingDetailsIncomeAccountUID guid Account → UID -
SellingDetailsReceiptMemo string - -
SellingDetailsSalesPersonUID guid Employee → UID -
SellingDetailsSaleComment string - -
SellingDetailsShippingMethod string - -
SellingDetailsHourlyBillingRate decimal - -
SellingDetailsABN string - -
SellingDetailsABNBranch string - -
SellingDetailsTaxCodeUID guid TaxCode → UID -
SellingDetailsFreightTaxCodeUID guid TaxCode → UID -

CustomerPayment

Documentation: https://developer.myob.com/api/myob-business-api/v2/sale/customerpayment/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UID guid - -
Date datetime - -
DepositTo string - -
AccountUID guid Account → UID -
CustomerUID guid Customer → UID -
ReceiptNumber string - -
AmountReceived decimal - -
PaymentMethod string - -
Memo string - -

Employee

Documentation: https://developer.myob.com/api/myob-business-api/v2/contact/employee/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UID guid - -
LastModified datetime - -
IsActive boolean - -
LastName string - -
FirstName string - -
IsIndividual boolean - -
DisplayID string - -
Notes string - -
EmployeePayrollDetailsUID guid -
  • 8 May 2024 Foreign Key: Refers to `EmployeePayrollDetails` (not implemented).
EmployeePaymentDetailsUID guid -
  • 8 May 2024 Foreign Key: Refers to `EmployeePaymentDetails` (not implemented).
EmployeeStandardPayUID guid -
  • 8 May 2024 Foreign Key: Refers to `EmployeeStandardPay` (not implemented).

InventoryItem

Documentation: https://developer.myob.com/api/myob-business-api/v2/inventory/item/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Description string - -
UID guid - -
LastModified datetime - -
IsActive boolean - -
Number string - -
UseDescription boolean - -
QuantityOnHand decimal - -
QuantityCommitted decimal - -
QuantityOnOrder decimal - -
QuantityAvailable decimal - -
AverageCost decimal - -
CurrentValue decimal - -
BaseSellingPrice decimal - -
IsBought boolean - -
IsSold boolean - -
IsInventoried boolean - -
ExpenseAccountUID guid Account → UID -
CostOfSalesAccountUID guid Account → UID -
IncomeAccountUID guid Account → UID -
AssetAccountUID guid Account → UID -
DefaultSellLocationUID guid InventoryLocation → UID -
DefaultReceiveLocationUID guid InventoryLocation → UID -

InventoryLocation

Documentation: https://developer.myob.com/api/myob-business-api/v2/inventory/location/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
UID guid - -
IsActive boolean - -
Identifier string - -
CanSell boolean - -
Notes string - -
AddressStreet string - -
AddressCity string - -
AddressState string - -
AddressPostCode string - -
AddressCountry string - -
AddressPhone1 string - -
AddressPhone2 string - -
AddressPhone3 string - -
AddressFax string - -
AddressEmail string - -
AddressWebsite string - -
AddressContactName string - -
AddressSalutation string - -

Job

Documentation: https://developer.myob.com/api/myob-business-api/v2/generalledger/job/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Description string - -
UID guid - -
LastModified datetime - -
IsActive boolean - -
Number string - -
IsHeader boolean - -
ParentJobUID guid Job → UID -
LinkedCustomerUID guid Customer → UID -
PercentComplete decimal - -
StartDate datetime - -
FinishDate datetime - -
Contact string - -
Manager string - -
TrackReimbursables boolean - -

JournalTransaction

Documentation: https://developer.myob.com/api/myob-business-api/v2/generalledger/journaltransaction/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
UID guid - -
DatePosted datetime - -
DisplayID string - -
JournalType string - -
SourceTransactionType string - -
SourceTransactionUID guid -
  • 13 May 2024 Unfortunately I can't add an FK to this UID due to the different transaction types (ItemInvoice, ServiceInvoice, etc) as they aren't specified in the SourceTransaction (just 'Invoice' etc

PayrollCategory

Documentation: https://developer.myob.com/api/myob-business-api/v2/payroll/payroll-category/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
UID guid - -
Type string - -
StpCategory string - -

Person

Documentation: https://developer.myob.com/api/myob-business-api/v2/contact/personal/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UID guid - -
LastModified datetime - -
IsActive boolean - -
CompanyName string - -
LastName string - -
FirstName string - -
IsIndividual boolean - -
DisplayID string - -
Notes string - -
CurrentBalance decimal - -

PurchaseItemBill

Documentation: https://developer.myob.com/api/myob-business-api/v2/purchase/bill/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UID guid - -
Date datetime - -
Number string - -
SupplierInvoiceNumber string - -
SupplierUID guid Supplier → UID -
ShipToAddress string - -
TermsPaymentIsDue string - -
TermsDiscountDate int - -
TermsBalanceDueDate int - -
TermsDiscountForEarlyPayment decimal - -
TermsMonthlyChargeForLatePayment decimal - -
TermsDiscountExpiryDate datetime - -
TermsDiscount decimal - -
TermsDueDate datetime - -
IsTaxInclusive boolean - -
IsReportable boolean - -
Subtotal decimal - -
Freight decimal - -
FreightTaxCodeUID guid TaxCode → UID -
TotalTax decimal - -
TotalAmount decimal - -
CategoryUID guid -
  • 9 May 2024 Foreign Key - Assuming refers to `Category` (not implemented, unable to create data).
Comment string - -
ShippingMethod string - -
PromisedDate datetime - -
JournalMemo string - -
BillDeliveryStatus string - -
AppliedToDate decimal - -
BalanceDueAmount decimal - -
Status string - -
LastPaymentDate datetime - -
PurchaseOrderUID guid -
  • 13 May 2024 Unfortunately we can't have an FK here because there's nothing in the response which tells us what 'type' of order this is (Item, Service, etc). You might assume that it would be the same as this type of PurchaseBill but I have confirmed you can convert an ItemOrder to an ItemBill and then change the type on either and it doesn't update the other

PurchaseItemOrder

Documentation: https://developer.myob.com/api/myob-business-api/v2/sale/quote/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UID guid - -
Date datetime - -
Number string - -
SupplierInvoiceNumber string - -
SupplierUID guid Supplier → UID -
ShipToAddress string - -
TermsPaymentIsDue string - -
TermsDiscountDate int - -
TermsBalanceDueDate int - -
TermsDiscountForEarlyPayment decimal - -
TermsDiscountExpiryDate datetime - -
TermsDiscount decimal - -
TermsDueDate datetime - -
IsTaxInclusive boolean - -
IsReportable boolean - -
Subtotal decimal - -
Freight decimal - -
FreightTaxCodeUID guid TaxCode → UID -
TotalTax decimal - -
TotalAmount decimal - -
CategoryUID guid -
  • 9 May 2024 Foreign Key - Assuming refers to `Category` (not implemented, unable to create data).
Comment string - -
ShippingMethod string - -
JournalMemo string - -
PromisedDate datetime - -
AppliedToDate decimal - -
OrderDeliveryStatus string - -
BalanceDueAmount decimal - -
Status string - -
LastPaymentDate datetime - -

PurchaseServiceBill

Documentation: https://developer.myob.com/api/myob-business-api/v2/purchase/bill/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UID guid - -
Date datetime - -
Number string - -
SupplierInvoiceNumber string - -
SupplierUID guid Supplier → UID -
ShipToAddress string - -
TermsPaymentIsDue string - -
TermsDiscountDate int - -
TermsBalanceDueDate int - -
TermsDiscountForEarlyPayment decimal - -
TermsMonthlyChargeForLatePayment decimal - -
TermsDiscountExpiryDate datetime - -
TermsDiscount decimal - -
TermsDueDate datetime - -
IsTaxInclusive boolean - -
IsReportable boolean - -
Subtotal decimal - -
Freight decimal - -
FreightTaxCodeUID guid TaxCode → UID -
TotalTax decimal - -
TotalAmount decimal - -
CategoryUID guid -
  • 9 May 2024 Foreign Key - Assuming refers to `Category` (not implemented, unable to create data).
Comment string - -
ShippingMethod string - -
PromisedDate datetime - -
JournalMemo string - -
BillDeliveryStatus string - -
AppliedToDate decimal - -
BalanceDueAmount decimal - -
Status string - -
LastPaymentDate datetime - -
PurchaseOrderUID guid -
  • 13 May 2024 Unfortunately we can't have an FK here because there's nothing in the response which tells us what 'type' of order this is (Item, Service, etc). You might assume that it would be the same as this type of PurchaseBill but I have confirmed you can convert an ItemOrder to an ItemBill and then change the type on either and it doesn't update the other

PurchaseServiceOrder

Documentation: https://developer.myob.com/api/myob-business-api/v2/purchase/order/order_service/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UID guid - -
Date datetime - -
Number string - -
SupplierInvoiceNumber string - -
SupplierUID guid Supplier → UID -
ShipToAddress string - -
TermsPaymentIsDue string - -
TermsDiscountDate int - -
TermsBalanceDueDate int - -
TermsDiscountForEarlyPayment decimal - -
TermsDiscountExpiryDate datetime - -
TermsDiscount decimal - -
TermsDueDate datetime - -
IsTaxInclusive boolean - -
IsReportable boolean - -
Subtotal decimal - -
Freight decimal - -
FreightTaxCodeUID guid TaxCode → UID -
TotalTax decimal - -
TotalAmount decimal - -
CategoryUID guid -
  • 9 May 2024 Foreign Key - Assuming refers to `Category` (not implemented, unable to create data).
Comment string - -
ShippingMethod string - -
JournalMemo string - -
PromisedDate datetime - -
AppliedToDate decimal - -
OrderDeliveryStatus string - -
BalanceDueAmount decimal - -
Status string - -
LastPaymentDate datetime - -

SaleItemInvoice

Documentation: https://developer.myob.com/api/myob-business-api/v2/sale/invoice/invoice_item/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UID guid - -
Date datetime - -
LastModified datetime - -
Number string - -
CustomerPurchaseOrderNumber string - -
CustomerUID guid Customer → UID -
PromisedDate datetime - -
BalanceDueAmount decimal - -
Status string - -
ShipToAddress string - -
TermsPaymentIsDue string - -
TermsDiscountDate int - -
TermsBalanceDueDate int - -
TermsDiscountForEarlyPayment decimal - -
TermsMonthlyChargeForLatePayment decimal - -
TermsDiscountExpiryDate datetime - -
TermsDiscount decimal - -
TermsDueDate datetime - -
TermsFinanceCharge decimal - -
IsTaxInclusive boolean - -
Subtotal decimal - -
Freight decimal - -
FreightTaxCodeUID guid TaxCode → UID -
TotalTax decimal - -
TotalAmount decimal - -
CategoryUID guid -
  • 9 May 2024 Foreign Key - Assuming refers to `Category` (not implemented, unable to create data).
SalespersonUID guid Employee → UID -
Comment string - -
ShippingMethod string - -
JournalMemo string - -
ReferralSource string - -
InvoiceDeliveryStatus string - -
LastPaymentDate datetime - -
CanApplySurcharge boolean - -
OrderUID guid -
  • 13 May 2024 Foreign Key: Assumed refers to `SaleOrder` (not implemented, unable to create data).
OnlinePaymentMethod string - -
CurrencyExchangeRate decimal - -

SaleItemQuote

Documentation: https://developer.myob.com/api/myob-business-api/v2/sale/quote/quote_item/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UID guid - -
LastModified datetime - -
Date datetime - -
Number string - -
ShipToAddress string - -
CustomerPurchaseOrderNumber string - -
CustomerUID guid Customer → UID -
TermsPaymentIsDue string - -
TermsDiscountDate int - -
TermsBalanceDueDate int - -
TermsDiscountForEarlyPayment decimal - -
TermsMonthlyChargeForLatePayment decimal - -
TermsDiscountExpiryDate datetime - -
TermsDiscount decimal - -
TermsDueDate datetime - -
TermsFinanceCharge decimal - -
IsTaxInclusive boolean - -
Subtotal decimal - -
Freight decimal - -
FreightTaxCodeUID guid TaxCode → UID -
TotalTax decimal - -
TotalAmount decimal - -
CategoryUID guid -
  • 13 May 2024 Foreign Key - Assuming refers to `Category` (not implemented, unable to create data).
SalespersonUID guid Employee → UID -
Comment string - -
ShippingMethod string - -
JournalMemo string - -
PromisedDate datetime - -
DeliveryStatus string - -
ReferralSource string - -
BalanceDueAmount decimal - -
Status string - -

SaleServiceInvoice

Documentation: https://developer.myob.com/api/myob-business-api/v2/sale/invoice/invoice_service/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UID guid - -
Date datetime - -
LastModified datetime - -
Number string - -
CustomerPurchaseOrderNumber string - -
CustomerUID guid Customer → UID -
PromisedDate datetime - -
BalanceDueAmount decimal - -
Status string - -
ShipToAddress string - -
TermsPaymentIsDue string - -
TermsDiscountDate int - -
TermsBalanceDueDate int - -
TermsDiscountForEarlyPayment decimal - -
TermsMonthlyChargeForLatePayment decimal - -
TermsDiscountExpiryDate datetime - -
TermsDiscount decimal - -
TermsDueDate datetime - -
TermsFinanceCharge decimal - -
IsTaxInclusive boolean - -
Subtotal decimal - -
Freight decimal - -
FreightTaxCodeUID guid TaxCode → UID -
TotalTax decimal - -
TotalAmount decimal - -
CategoryUID guid -
  • 9 May 2024 Foreign Key - Assuming refers to `Category` (not implemented, unable to create data).
SalespersonUID guid Employee → UID -
Comment string - -
ShippingMethod string - -
JournalMemo string - -
ReferralSource string - -
InvoiceDeliveryStatus string - -
LastPaymentDate datetime - -
CanApplySurcharge boolean - -
OrderUID guid -
  • 13 May 2024 Foreign Key: Assumed refers to `SaleOrder` (not implemented, unable to create data).
OnlinePaymentMethod string - -
CurrencyExchangeRate decimal - -

SaleServiceQuote

Documentation: https://developer.myob.com/api/myob-business-api/v2/sale/quote/quote_item/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UID guid - -
LastModified datetime - -
Date datetime - -
Number string - -
ShipToAddress string - -
CustomerPurchaseOrderNumber string - -
CustomerUID guid Customer → UID -
TermsPaymentIsDue string - -
TermsDiscountDate int - -
TermsBalanceDueDate int - -
TermsDiscountForEarlyPayment decimal - -
TermsMonthlyChargeForLatePayment decimal - -
TermsDiscountExpiryDate datetime - -
TermsDiscount decimal - -
TermsDueDate datetime - -
TermsFinanceCharge decimal - -
IsTaxInclusive boolean - -
Subtotal decimal - -
Freight decimal - -
FreightTaxCodeUID guid TaxCode → UID -
TotalTax decimal - -
TotalAmount decimal - -
CategoryUID guid -
  • 13 May 2024 Foreign Key - Assuming refers to `Category` (not implemented, unable to create data).
SalespersonUID guid Employee → UID -
Comment string - -
ShippingMethod string - -
JournalMemo string - -
PromisedDate datetime - -
DeliveryStatus string - -
ReferralSource string - -
BalanceDueAmount decimal - -
Status string - -

SuperannuationFund

Documentation: https://developer.myob.com/api/myob-business-api/v2/payroll/superannuationfund/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
UID guid - -
EmployerMembershipNumber string - -
PhoneNumber string - -
Website string - -

Supplier

Documentation: https://developer.myob.com/api/myob-business-api/v2/contact/supplier/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UID guid - -
LastModified datetime - -
IsActive boolean - -
LastName string - -
FirstName string - -
IsIndividual boolean - -
DisplayID string - -
Notes string - -
BuyingDetailPurchaseLayout string - -
BuyingDetailPrintedFrom string - -
BuyingDetailPurchaseOrderDelivery string - -
BuyingDetailExpenseAccountUID guid Account → UID -
BuyingDetailPaymentMemo string - -
BuyingDetailPurchaseComment string - -
BuyingDetailSupplierBillingRate decimal - -
BuyingDetailShippingMethod string - -
BuyingDetailIsReportable boolean - -
BuyingDetailCostPerHour decimal - -
BuyingDetailABN string - -
BuyingDetailABNBranch string - -
BuyingDetailTaxCodeUID guid TaxCode → UID -
BuyingDetailFreightTaxCodeUID guid TaxCode → UID -

SupplierPayment

Documentation: https://developer.myob.com/api/myob-business-api/v2/purchase/supplierpayment/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UID guid - -
Date datetime - -
PayFrom string - -
AccountUID guid Account → UID -
SupplierUID guid Supplier → UID -
PayeeAddress string - -
StatementParticulars string - -
PaymentNumber string - -
AmountPaid decimal - -
Memo string - -
DeliveryStatus string - -

TaxCode

Documentation: https://developer.myob.com/api/myob-business-api/v2/generalledger/taxcode/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
UID guid - -
LastModified datetime - -
Code string - -
Type string - -
Rate decimal - -
IsRateNegative boolean - -
TaxCollectedAccountUID guid Account → UID -
TaxPaidAccountUID guid Account → UID -
WithholdingCreditAccountUID guid Account → UID -
WithholdingPayableAccountUID guid Account → UID -
ImportDutyPayableAccountUID guid Account → UID -
LinkedSupplierUID guid Supplier → UID -
LuxuryCarTaxThreshold decimal - -

Timesheet

Documentation: https://developer.myob.com/api/myob-business-api/v2/payroll/timesheet/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EmployeeUID guid - -
From datetime - -
Until datetime - -

CustomerAddress

Column Type Relates to Notes
RemoteID string - -
CustomerRemoteID string Customer → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CustomerUID guid Customer → UID -
Location int - -
Street string - -
City string - -
State string - -
PostCode string - -
Country string - -
Phone1 string - -
Phone2 string - -
Phone3 string - -
Fax string - -
Email string - -
Website string - -
ContactName string - -
Salutation string - -

CustomerPaymentInvoice

Column Type Relates to Notes
RemoteID string - -
CustomerPaymentRemoteID string CustomerPayment → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CustomerPaymentUID guid CustomerPayment → UID -
RowID int - -
AmountApplied decimal - -
InvoiceUID guid - -
Type string - -
SaleServiceInvoiceUID guid SaleServiceInvoice → UID -
SaleItemInvoiceUID guid SaleItemInvoice → UID -

EmployeeAddress

Column Type Relates to Notes
RemoteID string - -
EmployeeRemoteID string Employee → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EmployeeUID guid Employee → UID -
Location int - -
Street string - -
City string - -
State string - -
PostCode string - -
Country string - -
Phone1 string - -
Phone2 string - -
Phone3 string - -
Fax string - -
Email string - -
Website string - -
ContactName string - -
Salutation string - -

JournalTransactionLine

Column Type Relates to Notes
RemoteID string - -
JournalTransactionRemoteID string JournalTransaction → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
JournalTransactionUID guid JournalTransaction → UID -
LineNumber int - -
AccountUID guid Account → UID -
Amount decimal - -
IsCredit boolean - -
JobUID guid Job → UID -
LineDescription string - -
ReconciledDate datetime - -
UnitCount decimal - -

PersonAddress

Column Type Relates to Notes
RemoteID string - -
PersonRemoteID string Person → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PersonUID guid Person → UID -
Location int - -
Street string - -
City string - -
State string - -
PostCode string - -
Country string - -
Phone1 string - -
Phone2 string - -
Phone3 string - -
Fax string - -
Email string - -
Website string - -
ContactName string - -
Salutation string - -

PurchaseItemBillLine

Column Type Relates to Notes
RemoteID string - -
PurchaseItemBillRemoteID string PurchaseItemBill → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
PurchaseItemBillUID guid PurchaseItemBill → UID -
RowID int - -
Type string - -
BillQuantity decimal - -
ReceivedQuantity decimal - -
BackorderQuantity decimal - -
Total decimal - -
UnitPrice decimal - -
UnitOfMeasure string - -
UnitCount decimal - -
DiscountPercent decimal - -
JobUID guid Job → UID -
TaxCodeUID guid TaxCode → UID -
ItemUID guid InventoryItem → UID -
AccountUID guid Account → UID -
LocationUID guid InventoryLocation → UID -

PurchaseItemOrderLine

Column Type Relates to Notes
RemoteID string - -
PurchaseItemOrderRemoteID string PurchaseItemOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
PurchaseItemOrderUID guid PurchaseItemOrder → UID -
RowID int - -
Type string - -
BillQuantity decimal - -
ReceivedQuantity decimal - -
UnitPrice decimal - -
DiscountPercent decimal - -
Total decimal - -
ItemUID guid InventoryItem → UID -
JobUID guid Job → UID -
TaxCodeUID guid TaxCode → UID -
LocationUID guid InventoryLocation → UID -

PurchaseServiceBillLine

Column Type Relates to Notes
RemoteID string - -
PurchaseServiceBillRemoteID string PurchaseServiceBill → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
PurchaseServiceBillUID guid PurchaseServiceBill → UID -
RowID int - -
Type string - -
UnitOfMeasure string - -
UnitCount decimal - -
UnitPrice decimal - -
DiscountPercent decimal - -
Total decimal - -
AccountUID guid Account → UID -
JobUID guid Job → UID -
TaxCodeUID guid TaxCode → UID -

PurchaseServiceOrderLine

Column Type Relates to Notes
RemoteID string - -
PurchaseServiceOrderRemoteID string PurchaseServiceOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
PurchaseServiceOrderUID guid PurchaseServiceOrder → UID -
RowID int - -
Type string - -
Total decimal - -
AccountUID guid Account → UID -
JobUID guid Job → UID -
TaxCodeUID guid TaxCode → UID -

SaleItemInvoiceLine

Column Type Relates to Notes
RemoteID string - -
SaleItemInvoiceRemoteID string SaleItemInvoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
SaleItemInvoiceUID guid SaleItemInvoice → UID -
RowID int - -
Type string - -
UnitOfMeasure string - -
UnitCount decimal - -
UnitPrice decimal - -
DiscountPercent decimal - -
Total decimal - -
AccountUID guid Account → UID -
JobUID guid Job → UID -
TaxCodeUID guid TaxCode → UID -

SaleItemQuoteLine

Column Type Relates to Notes
RemoteID string - -
SaleItemQuoteRemoteID string SaleItemQuote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
SaleItemQuoteUID guid SaleItemQuote → UID -
RowID int - -
Type string - -
ShipQuantity decimal - -
UnitPrice decimal - -
UnitOfMeasure string - -
UnitCount decimal - -
DiscountPercent decimal - -
Total decimal - -
ItemUID guid InventoryItem → UID -
AccountUID guid Account → UID -
JobUID guid Job → UID -
TaxCodeUID guid TaxCode → UID -

SaleServiceInvoiceLine

Column Type Relates to Notes
RemoteID string - -
SaleServiceInvoiceRemoteID string SaleServiceInvoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
SaleServiceInvoiceUID guid SaleServiceInvoice → UID -
RowID int - -
Type string - -
UnitOfMeasure string - -
UnitCount decimal - -
UnitPrice decimal - -
DiscountPercent decimal - -
Total decimal - -
AccountUID guid Account → UID -
JobUID guid Job → UID -
TaxCodeUID guid TaxCode → UID -

SaleServiceQuoteLine

Column Type Relates to Notes
RemoteID string - -
SaleServiceQuoteRemoteID string SaleServiceQuote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
SaleServiceQuoteUID guid SaleServiceQuote → UID -
RowID int - -
Type string - -
UnitOfMeasure string - -
UnitCount decimal - -
UnitPrice decimal - -
DiscountPercent decimal - -
Total decimal - -
AccountUID guid Account → UID -
JobUID guid Job → UID -
TaxCodeUID guid TaxCode → UID -

SupplierAddress

Column Type Relates to Notes
RemoteID string - -
SupplierRemoteID string Supplier → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
SupplierUID guid Supplier → UID -
Location int - -
Street string - -
City string - -
State string - -
PostCode string - -
Country string - -
Phone1 string - -
Phone2 string - -
Phone3 string - -
Fax string - -
Email string - -
Website string - -
ContactName string - -
Salutation string - -

SupplierPaymentLine

Column Type Relates to Notes
RemoteID string - -
SupplierPaymentRemoteID string SupplierPayment → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
SupplierPaymentUID guid SupplierPayment → UID -
RowID int - -
Type string - -
AmountApplied decimal - -
PurchaseUID guid - -
PurchaseServiceOrderUID guid PurchaseServiceOrder → UID -
PurchaseItemOrderUID guid PurchaseItemOrder → UID -
PurchaseServiceBillUID guid PurchaseServiceBill → UID -
PurchaseItemBillUID guid PurchaseItemBill → UID -

TimesheetLine

Column Type Relates to Notes
RemoteID string - -
TimesheetRemoteID string Timesheet → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Notes string - -
LineNumber int - -
PayrollCategoryUID guid - -
JobUID guid - -
ActivityUID guid - -
CustomerUID guid - -

TimesheetEntry

Column Type Relates to Notes
RemoteID string - -
TimesheetLineRemoteID string TimesheetLine → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Date datetime - -
Hours decimal - -
Processed boolean - -

Need more?

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

Connect your own MYOB Business data Interactive ERD Querying MYOB Business using regular SQL