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 Or, browse below

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

AccountingProperties

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

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
RowVersion string - -
ConversionDate datetime - -
CurrentFinancialYear int - -
LastMonthFinancialYear int - -

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 - -
BankingDetailsBSBNumber string - -
BankingDetailsBankAccountNumber string - -
BankingDetailsBankAccountName string - -
BankingDetailsCompanyTradingName string - -
BankingDetailsBankCode string - -
BankingDetailsCreateBankFiles boolean - -
BankingDetailsDirectEntryUserID string - -
BankingDetailsIncludeSelfBalancingTransaction boolean - -
BankingDetailsStatementParticulars string - -

AccountBudget

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

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
FinancialYear int - -
AccountUID guid - -
LastMonthInFinancialYear int - -

AccountRegister

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

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UID guid - -
AccountUID guid Account → UID -
Year int - -
Month int - -
Activity decimal - -
Adjustment decimal - -
YearEndActivity decimal - -
YearEndAdjustment decimal - -
UnitCount decimal - -

CompanyPreference

Documentation: https://developer.myob.com/api/myob-business-api/v2/company/preferences/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CompanyName string - -
CategoryTracking string - -
TransactionsCannotBeChangedMustBeReversed boolean - -
LockPeriodPriorTo datetime - -
UseAlphaAccountIdentifier boolean - -
PreferToReceiveMoneyIntoUndepositedFunds boolean - -
ReportTaxablePayments boolean - -
OnlineEmailingEnabled boolean - -
FromName string - -
ReplyToEmail string - -
SalesTermsPaymentIsDue string - -
SalesTermsDiscountDate int - -
SalesTermsBalanceDueDate int - -
SalesTermsDiscountForEarlyPayment decimal - -
SalesTermsMonthlyChargeForLatePayment decimal - -
SalesTermsPriceLevel string - -
SalesTermsUseCustomerTaxCode boolean - -
SalesTermsTaxCodeUID guid TaxCode → UID -
SalesTermsFreightTaxCode guid TaxCode → UID -
PurchasesTermsPaymentIsDue string - -
PurchasesTermsDiscountDate int - -
PurchasesTermsBalanceDueDate int - -
PurchasesTermsDiscountForEarlyPayment decimal - -
PurchasesTermsMonthlyChargeForLatePayment decimal - -
PurchasesTermsPriceLevel string - -
PurchasesTermsUseCustomerTaxCode boolean - -
PurchasesTermsTaxCodeUID guid TaxCode → UID -
PurchasesTermsFreightTaxCode guid TaxCode → UID -
UseTimesheetsFor string - -
WeekStartsOn string - -

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 - -
CurrentBalance decimal - -
CompanyName 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 -
SellingDetailsTermsPaymentIsDue string - -
SellingDetailsTermsDiscountDate int - -
SellingDetailsTermsBalanceDueDate int - -
SellingDetailsTermsDiscountForEarlyPayment decimal - -
SellingDetailsTermsMonthlyChargeForLatePayment decimal - -
SellingDetailsTermsVolumeDiscount decimal - -
SellingDetailsCreditLimit decimal - -
SellingDetailsCreditAvailable decimal - -
SellingDetailsCreditPastDue decimal - -
SellingDetailsCreditOnHold boolean - -
PaymentDetailsMethod string - -
PaymentDetailsCardNumber string - -
PaymentDetailsNameOnCard string - -
PaymentDetailsBSBNumber string - -
PaymentDetailsBankAccountNumber string - -
PaymentDetailsBankAccountName string - -
PaymentDetailsNotes string - -
CustomList1Label string - -
CustomList1Value string - -
CustomList2Label string - -
CustomList2Value string - -
CustomList3Label string - -
CustomList3Value string - -
CustomField1Label string - -
CustomField1Value string - -
CustomField2Label string - -
CustomField2Value string - -
CustomField3Label string - -
CustomField3Value string - -

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 - -

CustomList

Documentation: https://developer.myob.com/api/myob-business-api/v2/company/custom-list/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ListID long - -
ListIndex long - -
IsSystem boolean - -
ListName string - -
ListType string - -
Value 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 EmployeePayrollDetail → UID -
EmployeePaymentDetailsUID guid EmployeePaymentDetail → UID -
EmployeeStandardPayUID guid EmployeeStandardPay → UID -
CurrentBalance decimal - -

EmployeePaymentDetail

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

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UID guid - -
EmployeeUID guid Employee → UID -
PaymentMethod string - -
BankStatementText string - -

EmployeePayrollDetail

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

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UID guid - -
EmployeeUID guid Employee → UID -
DateOfBirth datetime - -
Gender string - -
StartDate datetime - -
TerminationDate datetime - -
EmploymentBasis string - -
EmploymentCategory string - -
EmploymentStatus string - -
PaySlipDelivery string - -
PaySlipEmail string - -
PayBasis string - -
AnnualSalary decimal - -
HourlyRate decimal - -
PayFrequency string - -
HoursInWeeklyPayPeriod string - -
WagesExpenseAccountUID guid Account → UID -
SuperannuationFundUID guid - -
SuperannuationEmployeeMembershipNumber string - -
TaxFileNumber string - -
WithholdingVariationRate decimal - -
TotalRebatesPerYear decimal - -
ExtraTaxPerPay decimal - -
TaxCategoryUID guid PayrollCategory → UID -
TaxTableUID guid TaxTable → UID -
EmployeeBillingRateExcludingTax decimal - -
CostPerHour decimal - -

EmployeeStandardPay

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

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UID guid - -
PayFrequency string - -
Memo string - -
HoursPerPayFrequency decimal - -
EmployeeUID guid Employee → UID -
PayrollCategoryUID guid PayrollCategory → UID -
EmployeePayrollDetailsUID guid EmployeePayrollDetail → UID -

EmploymentClassification

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

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

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 -
BuyingDetailsLastPurchasePrice decimal - -
BuyingDetailsStandardCost decimal - -
BuyingDetailsBuyingUnitOfMeasure string - -
BuyingDetailsItemsPerBuyingUnit decimal - -
BuyingDetailsStandardCostTaxInclusive boolean - -
BuyingDetailsTaxCodeUID guid TaxCode → UID -
BuyingDetailsMinimumLevelForRestockingAlert decimal - -
BuyingDetailsRestockinSupplierUID guid Supplier → UID -
BuyingDetailsRestockingSupplierItemNumber string - -
BuyingDetailsRestockingDefaultOrderQuantity string - -
SellingDetailsBaseSellingPrice decimal - -
SellingDetailsSellingUnitOfMeasure string - -
SellingDetailsItemsPerBuyingUnit decimal - -
SellingDetailsTaxCodeUID guid TaxCode → UID -
SellingDetailsIsTaxInclusive boolean - -
SellingDetailsCalculateSalesTaxOn string - -
SellingDetailsPriceMatrixURI string - -
CustomList1Label string - -
CustomList1Value string - -
CustomList2Label string - -
CustomList2Value string - -
CustomList3Label string - -
CustomList3Value string - -
CustomField1Label string - -
CustomField1Value string - -
CustomField2Label string - -
CustomField2Value string - -
CustomField3Label string - -
CustomField3Value string - -

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 - -

JobRegister

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

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UID guid - -
JobUID guid Job → UID -
AccountUID guid Account → UID -
Year int - -
Month int - -
Activity decimal - -
YearEndActivity decimal - -
StartOfMonth datetime - -

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 - -
DateOccurred 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 - -

BalanceSheetReport

Documentation: https://developer.myob.com/api/myob-business-api/v2/report/balancesheetsummary/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
AsOfDate datetime - -
YearEndAdjust boolean - -

EmployeePayrollAdviceReport

Documentation: https://developer.myob.com/api/myob-business-api/v2/report/payroll_employee_pay_advice/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EmployeeUID guid Employee → UID -
EmployerName guid -
  • 10 Jul 2025 This should always be the name of our chosen tenant but it is included here in case that assumption is wrong and for completeness
PayPeriodStartDate datetime - -
ChequeNumber string - -
PayPeriodEndDate datetime - -
PaymentDate datetime - -
PayFrequency string - -
AnnualSalary decimal - -
GrossPay decimal - -
NetPay decimal - -
HourlyRate decimal - -
DateOfBirth datetime - -
SuperannuationFundUID guid SuperannuationFund → UID -
EmploymentClassificationUID guid EmploymentClassification → UID -

JournalTransactionHistoryReport

Documentation: https://developer.myob.com/api/myob-business-api/v2/report/journal-transaction-history/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
UID guid - -
DisplayID string - -
Purchase string - -
OperationType string - -
DateOccurred datetime - -
DatePosted datetime - -
SourceTransactionUID guid JournalTransaction → UID -
GroupUID guid - -

ProfitAndLossReportByFiscalYear

Documentation: https://developer.myob.com/api/myob-business-api/v2/report/profitandlosssummary/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
StartDate datetime - -
EndDate datetime - -
ReportingBasis string - -
YearEndAdjust boolean - -
URI string - -

ProfitAndLossReportByMonth

Documentation: https://developer.myob.com/api/myob-business-api/v2/report/profitandlosssummary/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
StartDate datetime - -
EndDate datetime - -
ReportingBasis string - -
YearEndAdjust boolean - -
URI string - -

TaxCodeReportByFiscalYear

Documentation: https://developer.myob.com/api/myob-business-api/v2/report/taxcodesummary/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
StartDate datetime - -
EndDate datetime - -
ReportingBasis string - -
YearEndAdjust boolean - -
URI string - -

TaxCodeReportByMonth

Documentation: https://developer.myob.com/api/myob-business-api/v2/report/taxcodesummary/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
StartDate datetime - -
EndDate datetime - -
ReportingBasis string - -
YearEndAdjust boolean - -
URI string - -

TransactionCodingReport

Documentation: https://developer.myob.com/api/myob-business-api/v2/report/transactioncodingsummary/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Year int - -
Month int - -
TotalReceived int - -
Uncoded int - -
AutoCoded int - -

SaleInvoiceMiscellaneous

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

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 - -
CustomerPurchaseOrderNumber string - -
TotalTax decimal - -
TotalAmount decimal - -
Subtotal decimal - -
IsTaxInclusive boolean - -
AppliedToDate decimal - -
ReferralSource string - -
LastPaymentDate datetime - -
JournalMemo string - -
BalanceDueAmount decimal - -
Status string - -
CustomerUID guid Customer → UID -
CategoryUID guid -
  • 11 Sep 2025 Foreign Key - Refers to Category(GeneralLedger) (not implemented)
SalesPersonUID guid Employee → UID -
PaymentIsDue string - -
DiscountDate decimal - -
BalanceDueDate decimal - -
DiscountForEarlyPayment decimal - -
MonthlyChargeForLatePayment decimal - -
Discount decimal - -
FinanceCharge decimal - -
DiscountExpiryDate datetime - -
DueDate datetime - -

SaleInvoiceTimeBilling

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

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 - -
CustomerPurchaseOrderNumber string - -
PromisedDate datetime - -
BalanceDueAmount decimal - -
Status string - -
ShipToAddress string - -
IsTaxInclusive boolean - -
Subtotal decimal - -
Freight decimal - -
TotalTax decimal - -
TotalAmount decimal - -
Comment string - -
ShippingMethod string - -
JournalMemo string - -
ReferralSource string - -
InvoiceDeliveryStatus string - -
LastPaymentDate datetime - -
CanApplySurcharge boolean - -
OnlinePaymentMethod string - -
OrderUID guid -
  • 11 Sep 2025 Foreign Key - Refers to either SaleItemOrder or SaleServiceOrder (not implemented)
CustomerUID guid Customer → UID -
CategoryUID guid -
  • 11 Sep 2025 Foreign Key - Refers to Category(GeneralLedger) (not implemented)
SalesPersonUID guid Employee → UID -
FreightTaxCodeUID guid TaxCode → UID -
PaymentIsDue string - -
DiscountDate decimal - -
BalanceDueDate decimal - -
DiscountForEarlyPayment decimal - -
MonthlyChargeForLatePayment decimal - -
Discount decimal - -
FinanceCharge decimal - -
DiscountExpiryDate datetime - -
DueDate 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 - -
Name string - -
UID guid - -
LastModified datetime - -
IsActive boolean - -
LastName string - -
FirstName string - -
CompanyName string - -
IsIndividual boolean - -
DisplayID string - -
Notes string - -
CurrentBalance decimal - -
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 -
PaymentDetailsMethod string - -
PaymentDetailsCardNumber string - -
PaymentDetailsNameOnCard string - -
PaymentDetailsBSBNumber string - -
PaymentDetailsBankAccountNumber string - -
PaymentDetailsBankAccountName string - -
PaymentDetailsNotes string - -
CustomList1Label string - -
CustomList1Value string - -
CustomList2Label string - -
CustomList2Value string - -
CustomList3Label string - -
CustomList3Value string - -
CustomField1Label string - -
CustomField1Value string - -
CustomField2Label string - -
CustomField2Value string - -
CustomField3Label string - -
CustomField3Value string - -

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 - -

TaxTable

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

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

Activity

Documentation: https://developer.myob.com/api/myob-business-api/v2/timebilling/activity/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Description string - -
UID guid - -
DisplayID string - -
Type string - -
Status string - -
URI string - -
LastModified datetime - -
IsActive boolean - -
UseDescriptionOnSales boolean - -
Rate string - -
ActivityRateExcludingTax decimal - -
IncomeAccountUID guid Account → UID -
TaxCodeUID guid TaxCode → UID -

ActivitySlip

Documentation: https://developer.myob.com/api/myob-business-api/v2/timebilling/activity-slip/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UID guid - -
DisplayID string - -
Date datetime - -
ProviderUID guid - -
ProviderType string - -
SupplierUID guid Supplier → UID -
EmployeeUID guid Employee → UID -
CustomerUID guid Customer → UID -
ActivityUID guid Activity → UID -
JobUID guid Job → UID -
PayrollCategoryUID guid PayrollCategory → UID -
LastModified datetime - -
UnitCount decimal - -
Rate decimal - -
AdjustmentAmount decimal - -
AlreadyBilledAmount decimal - -
AdjustmentCount decimal - -
AlreadyBilledCount decimal - -
Notes string - -
StartStopDescription string - -
PaidToEmployeeAmount string - -
StartTime datetime - -
EndTime datetime - -

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 - -

AccountBudgetMonth

Column Type Relates to Notes
RemoteID string - -
AccountBudgetRemoteID string AccountBudget → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
AccountUID guid AccountBudget → AccountUID -
Year int - -
Month int - -
Amount decimal - -

CompanyEmailPreference

Column Type Relates to Notes
RemoteID string - -
CompanyPreferenceRemoteID string CompanyPreference → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PreferencesRemoteID string CompanyPreference → CompanyName -
Category string - -
EmailType string - -
Subject string - -
Message string - -

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 - -

CustomerIdentifier

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 -
Label string - -
Value 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 -

CustomListValue

Column Type Relates to Notes
RemoteID string - -
CustomListRemoteID string CustomList → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ListID long CustomList → ListID -
Value string - -

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 - -

EmployeeCustomField

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 -
Iterator int - -
Label string - -
Value string - -

EmployeeIdentifier

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 -
Iterator int - -
Label string - -
Value string - -

EmployeeCustomList

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 -
Iterator int - -
Label string - -
Value string - -

EmployeePaymentDetailsBankAccount

Column Type Relates to Notes
RemoteID string - -
EmployeePaymentDetailRemoteID string EmployeePaymentDetail → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EmployeePaymentDetailsUID guid EmployeePaymentDetail → UID -
BankAccountNumber string - -
BSBNumber string - -
BankAccountName string - -
Value decimal - -
Unit string - -

EmployeePayrollDetailsEntitlement

Column Type Relates to Notes
RemoteID string - -
EmployeePayrollDetailRemoteID string EmployeePayrollDetail → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EmployeePayrollDetailsUID guid EmployeePayrollDetail → UID -
EntitlementCategoryUID guid PayrollCategory → UID -
Rate decimal - -
Amount decimal - -
Percentage decimal - -
CarryOver decimal - -
YearToDate decimal - -
Total decimal - -
IsAssigned boolean - -

EmployeePayrollDetailsDeduction

Column Type Relates to Notes
RemoteID string - -
EmployeePayrollDetailRemoteID string EmployeePayrollDetail → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EmployeePayrollDetailsUID guid EmployeePayrollDetail → UID -
UID guid PayrollCategory → UID -
Rate decimal - -
Amount decimal - -
Percentage decimal - -
Limit decimal - -
YearToDateAmount decimal - -

EmployeePayrollDetailsTimeBillingRate

Column Type Relates to Notes
RemoteID string - -
EmployeePayrollDetailRemoteID string EmployeePayrollDetail → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EmployeePayrollDetailsUID guid EmployeePayrollDetail → UID -
PayrollCategoryUID guid PayrollCategory → UID -
Rate decimal - -

EmployeePayrollDetailsSuperannuationCategory

Column Type Relates to Notes
RemoteID string - -
EmployeePayrollDetailRemoteID string EmployeePayrollDetail → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EmployeePayrollDetailsUID guid EmployeePayrollDetail → UID -
UID guid PayrollCategory → UID -

EmployeePayrollDetailsEmployerExpense

Column Type Relates to Notes
RemoteID string - -
EmployeePayrollDetailRemoteID string EmployeePayrollDetail → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EmployeePayrollDetailsUID guid EmployeePayrollDetail → UID -
UID guid PayrollCategory → UID -

EmployeePayrollDetailsWageCategory

Column Type Relates to Notes
RemoteID string - -
EmployeePayrollDetailRemoteID string EmployeePayrollDetail → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EmployeePayrollDetailsUID guid EmployeePayrollDetail → UID -
UID guid PayrollCategory → UID -

EmployeePayrollDetailsEmploymentClassification

Column Type Relates to Notes
RemoteID string - -
EmployeePayrollDetailRemoteID string EmployeePayrollDetail → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EmployeePayrollDetailsUID guid EmployeePayrollDetail → UID -
UID guid EmploymentClassification → UID -

EmployeeStandardPayPayrollCategory

Column Type Relates to Notes
RemoteID string - -
EmployeeStandardPayRemoteID string EmployeeStandardPay → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EmployeeStandardPayUID guid EmployeeStandardPay → UID -
PayrollCategoryUID guid PayrollCategory → UID -
JobUID guid Job → UID -
HoursPerPayPeriod decimal - -
Rate decimal - -
Amount decimal - -
IsCalculated boolean - -

InventoryItemLocationDetail

Column Type Relates to Notes
RemoteID string - -
InventoryItemRemoteID string InventoryItem → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InventoryItemUID guid InventoryItem → UID -
LocationUID guid InventoryLocation → UID -
QuantityOnHand decimal - -

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 - -

PayrollCategoryWageDetail

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

Column Type Relates to Notes
RemoteID string - -
PayrollCategoryRemoteID string PayrollCategory → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UID guid PayrollCategory → UID -
WageType string - -
OverriddenWagesExpenseAccountUID guid Account → UID -
PayRate string - -
RegularRateMultiplier decimal - -
FixedHourlyRate decimal - -
AutomaticallyAdjustBaseAmounts boolean - -

PayrollCategoryEntitlementDetail

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

Column Type Relates to Notes
RemoteID string - -
PayrollCategoryRemoteID string PayrollCategory → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UID guid PayrollCategory → UID -
PrintOnPayAdvice boolean - -
CarryEntitlementOverToNextYear boolean - -
CalculationBasisType string - -
CalculationBasisPercentageOf decimal - -
CalculationBasisPayrollCategoryUID guid PayrollCategory → UID -
CalculationBasisFixedHoursOf decimal - -
CalculationBasisAccrualPeriod string - -

PayrollCategoryDeductionDetail

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

Column Type Relates to Notes
RemoteID string - -
PayrollCategoryRemoteID string PayrollCategory → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UID guid PayrollCategory → UID -
PayableAccountUID guid Account → UID -
CalculationBasisType string - -
CalculationBasisPercentageOf decimal - -
CalculationBasisPayrollCategoryUID guid PayrollCategory → UID -
CalculationBasisFixedDollarsOf decimal - -
CalculationBasisAccrualPeriod string - -
LimitType string - -
LimitPercentageOf decimal - -
LimitPayrollCategoryUID guid PayrollCategory → UID -
LimitFixedDollarsOf decimal - -
LimitAccrualPeriod string - -

PayrollCategoryExpenseDetail

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

Column Type Relates to Notes
RemoteID string - -
PayrollCategoryRemoteID string PayrollCategory → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UID guid PayrollCategory → UID -
ExpenseAccountUID guid Account → UID -
PayableAccountUID guid Account → UID -
PrintOnPayAdvice boolean - -
Threshold decimal - -
CalculationBasisType string - -
CalculationBasisPercentageOf decimal - -
CalculationBasisPayrollCategoryUID guid PayrollCategory → UID -
CalculationBasisFixedDollarsOf decimal - -
CalculationBasisAccrualPeriod string - -
LimitType string - -
LimitPercentageOf decimal - -
LimitPayrollCategoryUID guid PayrollCategory → UID -
LimitFixedDollarsOf decimal - -
LimitAccrualPeriod string - -

PayrollCategorySuperannuationDetail

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

Column Type Relates to Notes
RemoteID string - -
PayrollCategoryRemoteID string PayrollCategory → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UID guid PayrollCategory → UID -
ExpenseAccountUID guid Account → UID -
PayableAccountUID guid Account → UID -
ContributionType string - -
PrintOnPayAdvice boolean - -
Exclusion decimal - -
Threshold decimal - -
CalculationBasisType string - -
CalculationBasisPercentageOf decimal - -
CalculationBasisPayrollCategoryUID guid PayrollCategory → UID -
CalculationBasisFixedDollarsOf decimal - -
CalculationBasisAccrualPeriod string - -
LimitType string - -
LimitPercentageOf decimal - -
LimitPayrollCategoryUID guid PayrollCategory → UID -
LimitFixedDollarsOf decimal - -
LimitAccrualPeriod string - -

PayrollCategoryTaxDetail

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

Column Type Relates to Notes
RemoteID string - -
PayrollCategoryRemoteID string PayrollCategory → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UID guid PayrollCategory → UID -
PayableAccountUID guid Account → UID -
TaxTableRevisionDate datetime - -

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 -

BalanceSheetAccount

Column Type Relates to Notes
RemoteID string - -
BalanceSheetReportRemoteID string BalanceSheetReport → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
BalanceSheetRemoteID string BalanceSheetReport → RemoteID -
AccountTotal decimal - -
AccountUID guid Account → UID -

EmployeePayrollAdviceReportLine

Column Type Relates to Notes
RemoteID string - -
EmployeePayrollAdviceReportRemoteID string EmployeePayrollAdviceReport → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PayrollCategoryUID guid PayrollCategory → UID -
Hours int - -
CalculationRate decimal - -
Amount decimal - -
YearToDate decimal - -

JournalTransactionHistoryLine

Column Type Relates to Notes
RemoteID string - -
JournalTransactionHistoryReportRemoteID string JournalTransactionHistoryReport → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
JournalTransactionHistoryUID guid JournalTransactionHistoryReport → UID -
Iterator int - -
AccountUID guid Account → UID -
JobUID guid Job → UID -
Amount decimal - -
IsCredit boolean - -
LineDescription string - -
UnitCount decimal - -
ReconciledDate datetime - -

ProfitAndLossReportByFiscalYearAccount

Column Type Relates to Notes
RemoteID string - -
ProfitAndLossReportByFiscalYearRemoteID string ProfitAndLossReportByFiscalYear → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
AccountTotal decimal - -
AccountUID guid Account → UID -

ProfitAndLossReportByMonthAccount

Column Type Relates to Notes
RemoteID string - -
ProfitAndLossReportByMonthRemoteID string ProfitAndLossReportByMonth → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
AccountTotal decimal - -
AccountUID guid Account → UID -

TaxCodeReportByFiscalYearItem

Column Type Relates to Notes
RemoteID string - -
TaxCodeReportByFiscalYearRemoteID string TaxCodeReportByFiscalYear → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
SalesTotal decimal - -
PurchasesTotal decimal - -
TaxCollected decimal - -
TaxPaid decimal - -
TaxRate decimal - -
TaxCodeUID guid TaxCode → UID -

TaxCodeReportByMonthItem

Column Type Relates to Notes
RemoteID string - -
TaxCodeReportByMonthRemoteID string TaxCodeReportByMonth → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
SalesTotal decimal - -
PurchasesTotal decimal - -
TaxCollected decimal - -
TaxPaid decimal - -
TaxRate decimal - -
TaxCodeUID guid TaxCode → UID -

SaleInvoiceMiscellaneousLine

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

SaleInvoiceTimeBillingLine

Column Type Relates to Notes
RemoteID string - -
SaleInvoiceTimeBillingRemoteID string SaleInvoiceTimeBilling → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
SaleInvoiceTimeBillingUID guid SaleInvoiceTimeBilling → UID -
RowID int - -
Type string - -
Date datetime - -
Hours decimal - -
Units decimal - -
ItemUID guid - -
Rate decimal - -
Total decimal - -
JobUID guid Job → UID -
ActivityUID guid Activity → 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 - -
ShipQuantity decimal - -
UnitPriceForeign decimal - -
CostOfGoodsSold decimal - -
TotalForeign decimal - -
AccountUID guid Account → UID -
JobUID guid Job → UID -
TaxCodeUID guid TaxCode → UID -
LocationUID guid InventoryLocation → UID -
ItemUID guid InventoryItem → 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 - -

SupplierIdentifier

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 -
Label string - -
Value 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 Activity → UID -
CustomerUID guid - -

PayrollCategoryWageDetailExemption

Column Type Relates to Notes
RemoteID string - -
PayrollCategoryWageDetailRemoteID string PayrollCategoryWageDetail → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PayrollCategoryWageDetailUID guid PayrollCategoryWageDetail → UID -
UID guid PayrollCategory → UID -

PayrollCategoryEntitlementDetailLinkedCategory

Column Type Relates to Notes
RemoteID string - -
PayrollCategoryEntitlementDetailRemoteID string PayrollCategoryEntitlementDetail → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PayrollCategoryEntitlementDetailUID guid PayrollCategoryEntitlementDetail → UID -
UID guid PayrollCategory → UID -

PayrollCategoryEntitlementDetailExemption

Column Type Relates to Notes
RemoteID string - -
PayrollCategoryEntitlementDetailRemoteID string PayrollCategoryEntitlementDetail → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PayrollCategoryEntitlementDetailUID guid PayrollCategoryEntitlementDetail → UID -
UID guid PayrollCategory → UID -

PayrollCategoryDeductionDetailExemption

Column Type Relates to Notes
RemoteID string - -
PayrollCategoryDeductionDetailRemoteID string PayrollCategoryDeductionDetail → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PayrollCategoryDeductionDetailUID guid PayrollCategoryDeductionDetail → UID -
UID guid PayrollCategory → UID -

PayrollCategoryExpenseDetailExemption

Column Type Relates to Notes
RemoteID string - -
PayrollCategoryExpenseDetailRemoteID string PayrollCategoryExpenseDetail → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PayrollCategoryDeductionDetailUID guid PayrollCategoryExpenseDetail → UID -
UID guid PayrollCategory → UID -

PayrollCategorySuperannuationDetailExemption

Column Type Relates to Notes
RemoteID string - -
PayrollCategorySuperannuationDetailRemoteID string PayrollCategorySuperannuationDetail → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PayrollCategoryDeductionDetailUID guid PayrollCategorySuperannuationDetail → UID -
UID guid PayrollCategory → UID -

TimesheetEntry

Column Type Relates to Notes
RemoteID string - -
TimesheetLineRemoteID string TimesheetLine → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
LineNumber int - -
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 Querying MYOB Business using regular SQL