MYOB Endpoint: AccountsTable
Overview
The MYOB AccountsTable endpoint allows you to access the chart of accounts located within MYOB.
Note this endpoint is an alternate format of the Accounts endpoint. It provides a format that can more easily integrate with Tableau, SSIS and Azure Data Factory.
Fields
The following fields are available for the AccountsTable endpoint.
- DataFileID
- A guid field that provides the id of the data file as setup in OdataLink.
- DataFileName
- A text field provides the name of the data file as setup in OdataLink.
- DataFileCode
- A text field provides the code of the data file as setup in OdataLink.
- UID
- A GUID field representing the internal id of an account. This field can be used to link to other endpoints.
- Name
- A text field used as the account name.
- DisplayID
- A text field used as the account number.
- Classification
- A text field that identifies the high-level type of account. Possible values are:
- Asset
- Liability
- Equity
- Income
- CostOfSales
- Expense
- OtherIncome
- OtherExpense
- Type
- A text field that identifies the more detailed type of an account. Possible values are:
- AccountReceivable
- AccountsPayable
- Bank
- CostOfSales
- CreditCard
- Equity
- Expense
- FixedAsset
- Income
- LongTermLiability
- OtherAsset
- OtherCurrentAsset
- OtherCurrentLiability
- OtherExpense
- OtherIncome
- OtherLiability
- Number
- A integer field that represents the last digits of an account number that follows the dash. For example, 4-1234 will have a number of 1234.
- Description
- A text field used as the account description.
- ParentAccountUID
- A GUID field representing the internal id of the parent account. This field can be used to link to other endpoints.
- ParentAccountName
- A text field used as the name of the parent account.
- ParentAccountDisplayID
- A text field used as the account number of the parent account.
- IsActive
- A true/false value that indicates if the account is active and useable within MYOB.
- TaxCodeUID
- A GUID field representing the internal id of the tax code. This field can be used to link to other endpoints.
- TaxCode
- A text field used as the code for the tax code (e.g. GST or FRE).
- Level
- A integer field that represents the indentation level of the account within the MYOB chart of accounts. Possible values are between 1 and 4.
- OpeningBalance
- A decimal field that represents the original opening balance value for this account when first created.
- CurrentBalance
- A decimal field that represents the closing balance value for this account as at the end-of-time.
- BankingDetailsBSBNumber
- A text field used to store the BSB number.
- BankingDetailsBankAccountNumber
- A text field used to store the bank account number.
- BankingDetailsBankAccountName
- A text field used to store the bank account name.
- BankingDetailsCompanyTradingName
- A text field used to store the company trading name used on direct credit ABA files.
- BankingDetailsBankCode
- A text field used to store the bank code included on direct credit ABA files.
- BankingDetailsCreateBankFiles
- A true/false value used to indicate if this bank account is used for direct credit ABA files.
- BankingDetailsDirectEntryUserId
- A text field used to store the direct entry user id included on direct credit ABA files.
- BankingDetailsIncludeSelfBalancingTransaction
- A true/false value used to indicate if the direct credit ABA files will include a self balancing transaction line.
- BankingDetailsStatementParticulars
- A text field used to store the statement particulars included on direct credit ABA files.
- BankingDetailsStatementCode
- A text field used to store the statement code included on direct credit ABA files.
- BankingDetailsStatementReference
- A text field used to store the statement reference included on direct credit ABA files.
- IsHeader
- A true/false value that indicates if the account is a header or detail account.
- LastReconciledDate
- A date field that stores a date of the last time this account and all transactions attached were reconciled.
- ForeignCurrencyUID
- A GUID field representing the internal id of currency. This field can be used to link to other endpoints.
- ForeignCurrencyCode
- A text field used as the currency ISO code.
- ForeignCurrencyName
- A text field used as the currency name.
- LastModified
- A date time field that stores the date/time this activity was last modified.
- RowVersion
- A row version field.
MYOB API
For a detailed run through of the endpoint, you can see the MYOB API.
Related Fields