Tables
The driver models the data in MYOB into a list of tables that can be queried using standard SQL statements.
Generally, querying MYOB tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.
CData JDBC Driver for MYOB Tables
| Name | Description |
| AccountBudgets | Return and update general ledger account budgets. |
| Accounts | Return, update, create and delete accounts for an AccountRight company file. |
| Activities | Return, update, create and delete a list of time billing activities for an AccountRight company file. |
| ActivitySlips | Return, update, create and delete a list of time billing activity slips for an AccountRight company file. |
| Contacts | Return all contact types for an AccountRight company file. |
| CreditRefunds | Return, create and delete credit notes refunded to customers for an AccountRight company file. |
| CreditSettlements | Return, create and delete settled customer credits for an AccountRight company file. |
| CustomerPayments | Return, create and delete customer payments for an AccountRight company file. |
| DebitRefunds | Return all purchase bill types for an AccountRight company file. |
| DebitSettlements | Return, create and delete debit settlements for an AccountRight company file. |
| EmployeePaymentDetails | Return and update employee payment details on employee contact cards for an AccountRight company file. |
| EmployeePayrollDetails | Return and update employee payroll details on employee contact cards for an AccountRight company file. |
| EmployeeStandardPay | Return and update employee standard pay details on employee contact cards for an AccountRight company file. |
| InventoryAdjustments | Return, update, create and delete inventory adjustments for an AccountRight company file. |
| ItemPriceMatrices | Return and update the item price matrix for multiple customer selling prices. |
| Items | Return, update, create and delete inventory items for an AccountRight company file. |
| JobBudgets | Return and update job budgets. |
| Jobs | Return, update, create and delete a job for an AccountRight company file. |
| Journals | Return, update, create and delete general journal transactions for an AccountRight company file. |
| PayrollWages | Return, update, create and delete payroll categories of type wage for an AccountRight company file. |
| PurchaseBills | Return all purchase bill types for an AccountRight company file. |
| PurchaseOrders | Return all purchase order types for an AccountRight company file. |
| ReceivingTransactions | Return, update, create and delete receive money transactions for an AccountRight company file. |
| SaleInvoices | Return all sale invoice types for an AccountRight company file. |
| SaleOrders | Returns all sale order types for an AccountRight company file. |
| SaleQuotes | Return all sale quote types for an AccountRight company file. |
| SpendingTransactions | Return, update, create and delete spend money transactions for an AccountRight company file. |
| SupplierPayments | Return, create and delete supplier payments for an AccountRight company file. |
| TaxCodes | Tax codes for an AccountRight company file. |
| TimesheetLineEntries | Return timesheet entries for an AccountRight company file |
| TimesheetLineItems | Return timesheet entries for an AccountRight company file |
| Timesheets | Return timesheet entries for an AccountRight company file |
| TransferringTransactions | Return, update, create and delete transfer money transactions for an AccountRight company file. |