MYOB Endpoint: AccountsTable
Jump to navigation
Jump to search
Overview
The MYOB Accounts 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 Accounts 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