Difference between revisions of "Supported Data Points"

From ODBClink wiki
Jump to navigation Jump to search
 
(2 intermediate revisions by the same user not shown)
Line 12: Line 12:
* MYOX_Accounts
* MYOX_Accounts
* MYOX_Activities
* MYOX_Activities
* MYOX_BankingStatements
* MYOX_Cards
* MYOB_CardAddresses
* MYOX_CardCustomLists
* MYOX_CardIdentifiers
* MYOX_Categories
* MYOX_Categories
* MYOX_CategoryRegister
* MYOX_CategoryRegister
* MYOX_Company
* MYOX_Company
* MYOX_CreditRefunds
* MYOX_CreditSettlements
* MYOX_CreditSettlementLines
* MYOX_CurrentUserAccess
* MYOX_CustomerAddresses
* MYOX_CustomerAddresses
* MYOX_CustomerCustomLists
* MYOX_CustomerCustomLists
Line 21: Line 30:
* MYOX_CustomerPayments
* MYOX_CustomerPayments
* MYOX_CustomerPaymentLines
* MYOX_CustomerPaymentLines
* MYOX_DebitRefunds
* MYOX_DebitSettlements
* MYOX_DebitSettlementLines
* MYOX_DeductionExemptions
* MYOX_DeductionExemptions
* MYOX_Deductions
* MYOX_Deductions
Line 29: Line 41:
* MYOX_EmployerExpenseExemptions
* MYOX_EmployerExpenseExemptions
* MYOX_EmployerExpenses
* MYOX_EmployerExpenses
* MYOX_EmployeePaymentDetails
* MYOX_EmployeePaymentDetailAccounts
* MYOX_EmployeeStandardPays
* MYOX_EmployeeStandardPayLines
* [[MYOX_EmployeePayrollAdviceReports]]
* [[MYOX_EmployeePayrollAdviceReportLines]]
* MYOX_EmployeePayrollDetails
* MYOX_EmployeePayrollDetailDeductions
* MYOX_EmployeePayrollDetailEmployerExpenses
* MYOX_EmployeePayrollDetailEntitlements
* MYOX_EmployeePayrollDetailSuperannuations
* MYOX_EmployeePayrollDetailWages
* MYOX_EmploymentClassifications
* MYOX_EntitlementExemptions
* MYOX_EntitlementExemptions
* MYOX_Entitlements
* MYOX_Entitlements
* MYOX_EntitlementWages
* MYOX_EntitlementWages
* MYOX_FormTemplates
* MYOX_GeneralJournals
* MYOX_GeneralJournals
* MYOX_GeneralJournalLines
* MYOX_GeneralJournalLines
Line 38: Line 64:
* MYOX_ItemCustomLists
* MYOX_ItemCustomLists
* MYOX_Items
* MYOX_Items
* MYOX_ItemPriceMatrixDetails
* MYOX_ItemPriceMatrixDetailLines
* MYOX_ItemPurchaseLines
* MYOX_ItemPurchaseLines
* MYOX_ItemPurchases
* MYOX_ItemPurchases
Line 56: Line 84:
* MYOX_MiscellaneousSalesOrderLines
* MYOX_MiscellaneousSalesOrderLines
* MYOX_MiscellaneousSalesOrders
* MYOX_MiscellaneousSalesOrders
* MYOX_PayrollCategories
* MYOX_PayrollTaxes
* MYOX_PayrollTaxes
* MYOX_PersonalCards
* MYOX_PersonalCards
Line 83: Line 112:
* MYOX_SuperannuationExemptions
* MYOX_SuperannuationExemptions
* MYOX_Superannuations
* MYOX_Superannuations
* MYOX_SuperannuationFunds
* MYOX_SupplierAddresses
* MYOX_SupplierAddresses
* MYOX_SupplierCustomLists
* MYOX_SupplierCustomLists
Line 88: Line 118:
* MYOX_Suppliers
* MYOX_Suppliers
* MYOX_TaxCodes
* MYOX_TaxCodes
* MYOX_TaxTables
* MYOX_TimeBillingSales
* MYOX_TimeBillingSales
* MYOX_TimeBillingSaleLines
* MYOX_TimeBillingSaleLines
Line 109: Line 140:
Please [http://accountingaddons.com.au/contact-us/ contact us] for more information.
Please [http://accountingaddons.com.au/contact-us/ contact us] for more information.


== Supported data points for AccountRight classic ==
== Supported data points for MYOB AccountRight classic ==


All data points for MYOB AccountRight classic or older are supported. For a complete list, we recommend you check the ODBC user_guide.pdf that comes with the MYOB ODBC driver.
All data points for [[MYOB AccountRight Classic]] are supported. For a complete list, we recommend you check the ODBC user_guide.pdf that comes with the MYOB ODBC driver.

Latest revision as of 22:49, 3 June 2019

Overview

ODBClink supports many data points, end points or tables.

Supported End Points for MYOB AccountRight live

ODBClink supports the following data points for AccountRight live. This list will continue to grow as new customers request access to specific data and as MYOB provides access to these new data points.

  • MYOX_AccountBudgets
  • MYOX_AccountingProperties
  • MYOX_AccountRegister
  • MYOX_Accounts
  • MYOX_Activities
  • MYOX_BankingStatements
  • MYOX_Cards
  • MYOB_CardAddresses
  • MYOX_CardCustomLists
  • MYOX_CardIdentifiers
  • MYOX_Categories
  • MYOX_CategoryRegister
  • MYOX_Company
  • MYOX_CreditRefunds
  • MYOX_CreditSettlements
  • MYOX_CreditSettlementLines
  • MYOX_CurrentUserAccess
  • MYOX_CustomerAddresses
  • MYOX_CustomerCustomLists
  • MYOX_CustomerIdentifiers
  • MYOX_Customers
  • MYOX_CustomerPayments
  • MYOX_CustomerPaymentLines
  • MYOX_DebitRefunds
  • MYOX_DebitSettlements
  • MYOX_DebitSettlementLines
  • MYOX_DeductionExemptions
  • MYOX_Deductions
  • MYOX_EmployeeAddresses
  • MYOX_EmployeeCustomLists
  • MYOX_EmployeeIdentifiers
  • MYOX_Employees
  • MYOX_EmployerExpenseExemptions
  • MYOX_EmployerExpenses
  • MYOX_EmployeePaymentDetails
  • MYOX_EmployeePaymentDetailAccounts
  • MYOX_EmployeeStandardPays
  • MYOX_EmployeeStandardPayLines
  • MYOX_EmployeePayrollAdviceReports
  • MYOX_EmployeePayrollAdviceReportLines
  • MYOX_EmployeePayrollDetails
  • MYOX_EmployeePayrollDetailDeductions
  • MYOX_EmployeePayrollDetailEmployerExpenses
  • MYOX_EmployeePayrollDetailEntitlements
  • MYOX_EmployeePayrollDetailSuperannuations
  • MYOX_EmployeePayrollDetailWages
  • MYOX_EmploymentClassifications
  • MYOX_EntitlementExemptions
  • MYOX_Entitlements
  • MYOX_EntitlementWages
  • MYOX_FormTemplates
  • MYOX_GeneralJournals
  • MYOX_GeneralJournalLines
  • MYOX_InventoryAdjustmentLines
  • MYOX_InventoryAdjustments
  • MYOX_ItemCustomLists
  • MYOX_Items
  • MYOX_ItemPriceMatrixDetails
  • MYOX_ItemPriceMatrixDetailLines
  • MYOX_ItemPurchaseLines
  • MYOX_ItemPurchases
  • MYOX_ItemSaleLines
  • MYOX_ItemSales
  • MYOX_ItemSalesOrderLines
  • MYOX_ItemSalesOrders
  • MYOX_JobBudgets
  • MYOX_JobRegister
  • MYOX_Jobs
  • MYOX_JournalTransactionLines
  • MYOX_JournalTransactions
  • MYOX_LinkedAccounts
  • MYOX_MiscellaneousPurchaseLines
  • MYOX_MiscellaneousPurchases
  • MYOX_MiscellaneousSaleLines
  • MYOX_MiscellaneousSales
  • MYOX_MiscellaneousSalesOrderLines
  • MYOX_MiscellaneousSalesOrders
  • MYOX_PayrollCategories
  • MYOX_PayrollTaxes
  • MYOX_PersonalCards
  • MYOX_PersonalCardAddresses
  • MYOX_PersonalCardCustomLists
  • MYOX_PersonalCardIdentifiers
  • MYOX_Preferences
  • MYOX_ProfessionalPurchaseLines
  • MYOX_ProfessionalPurchases
  • MYOX_ProfessionalSaleLines
  • MYOX_ProfessionalSales
  • MYOX_ProfessionalSalesOrderLines
  • MYOX_ProfessionalSalesOrders
  • MYOX_Purchases
  • MYOX_ReceiveMoney
  • MYOX_ReceiveMoneyLines
  • MYOX_Sales
  • MYOX_SalesOrders
  • MYOX_ServicePurchaseLines
  • MYOX_ServicePurchases
  • MYOX_ServiceSaleLines
  • MYOX_ServiceSales
  • MYOX_ServiceSalesOrderLines
  • MYOX_ServiceSalesOrders
  • MYOX_SpendMoney
  • MYOX_SpendMoneyLines
  • MYOX_SuperannuationExemptions
  • MYOX_Superannuations
  • MYOX_SuperannuationFunds
  • MYOX_SupplierAddresses
  • MYOX_SupplierCustomLists
  • MYOX_SupplierIdentifiers
  • MYOX_Suppliers
  • MYOX_TaxCodes
  • MYOX_TaxTables
  • MYOX_TimeBillingSales
  • MYOX_TimeBillingSaleLines
  • MYOX_TimeBillingSalesOrders
  • MYOX_TimeBillingSalesOrderLines
  • MYOX_Timesheets
  • MYOX_TransferMoney
  • MYOX_WageExemptions
  • MYOX_Wages

Full List available in API

Here is the list of available end points from MYOB

If you require a table that is not supported by ODBClink but is available in the API then you have three options,

  1. Purchase tables for a once off fee of $330 each table.
  2. Purchase an annual subscription of the Pro Edition to choose 1 additional end point added.
  3. Purchase an annual subscription of the Ultimate Edition to choose 2 additional end points added.

Please contact us for more information.

Supported data points for MYOB AccountRight classic

All data points for MYOB AccountRight Classic are supported. For a complete list, we recommend you check the ODBC user_guide.pdf that comes with the MYOB ODBC driver.