View source for MYOB Endpoint: AccountsTable

== Overview ==

The MYOB '''AccountsTable''' [[MYOB Endpoints|endpoint]] allows you to access the chart of accounts located within MYOB. 

Note this endpoint is an alternate format of the [[MYOB Endpoint: Accounts|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 [[Field Type: GUID|guid field]] that provides the id of the data file as setup in OdataLink.

;DataFileName
:A [[Field Type: Text|text field]] provides the name of the data file as setup in OdataLink.

;DataFileCode
:A [[Field Type: Text|text field]] provides the code of the data file as setup in OdataLink.

;UID
:A [[Field Type: GUID|GUID field]] representing the internal id of an account. This field can be used to link to other endpoints.

;Name
:A [[Field Type: Text|text field]] used as the account name.

;DisplayID
:A [[Field Type: Text|text field]] used as the account number.

;Classification
:A [[Field Type: Text|text field]] that identifies the high-level type of account. Possible values are: 
::Asset
::Liability
::Equity
::Income
::CostOfSales
::Expense
::OtherIncome
::OtherExpense

;Type
:A [[Field Type: Text|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 [[Field Type: Integer|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 [[Field Type: Text|text field]] used as the account description.

;ParentAccountUID
:A [[Field Type: GUID|GUID field]] representing the internal id of the parent account. This field can be used to link to other endpoints.

;ParentAccountName
:A [[Field Type: Text|text field]] used as the name of the parent account.

;ParentAccountDisplayID
:A [[Field Type: Text|text field]] used as the account number of the parent account.

;IsActive
:A [[Field Type: Boolean|true/false value]] that indicates if the account is active and useable within MYOB.

;TaxCodeUID
:A [[Field Type: GUID|GUID field]] representing the internal id of the tax code. This field can be used to link to other endpoints.

;TaxCode
:A [[Field Type: Text|text field]] used as the code for the tax code (e.g. GST or FRE).

;Level
:A [[Field Type: Integer|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 [[Field Type: Decimal|decimal field]] that represents the original opening balance value for this account when first created.

;CurrentBalance
:A [[Field Type: Decimal|decimal field]] that represents the closing balance value for this account as at the end-of-time.

;BankingDetailsBSBNumber
:A [[Field Type: Text|text field]] used to store the BSB number.

;BankingDetailsBankAccountNumber
:A [[Field Type: Text|text field]] used to store the bank account number.

;BankingDetailsBankAccountName
:A [[Field Type: Text|text field]] used to store the bank account name.

;BankingDetailsCompanyTradingName
:A [[Field Type: Text|text field]] used to store the company trading name used on direct credit ABA files.

;BankingDetailsBankCode
:A [[Field Type: Text|text field]] used to store the bank code included on direct credit ABA files.

;BankingDetailsCreateBankFiles
:A [[Field Type: Boolean|true/false value]] used to indicate if this bank account is used for direct credit ABA files.

;BankingDetailsDirectEntryUserId
:A [[Field Type: Text|text field]] used to store the direct entry user id included on direct credit ABA files.

;BankingDetailsIncludeSelfBalancingTransaction
:A [[Field Type: Boolean|true/false value]] used to indicate if the direct credit ABA files will include a self balancing transaction line.

;BankingDetailsStatementParticulars
:A [[Field Type: Text|text field]] used to store the statement particulars included on direct credit ABA files.

;BankingDetailsStatementCode
:A [[Field Type: Text|text field]] used to store the statement code included on direct credit ABA files.

;BankingDetailsStatementReference
:A [[Field Type: Text|text field]] used to store the statement reference included on direct credit ABA files.

;IsHeader
:A [[Field Type: Boolean|true/false value]] that indicates if the account is a header or detail account.

;LastReconciledDate
:A [[Field Type: Date|date field]] that stores a date of the last time this account and all transactions attached were reconciled.

;ForeignCurrencyUID
:A [[Field Type: GUID|GUID field]] representing the internal id of currency. This field can be used to link to other endpoints.

;ForeignCurrencyCode
:A [[Field Type: Text|text field]] used as the currency ISO code.

;ForeignCurrencyName
:A [[Field Type: Text|text field]] used as the currency name.

;LastModified
:A [[Field Type: DateTimeOffset|date time field]] that stores the date/time this activity was last modified.

;RowVersion
:A [[Field Type: Row Version|row version field]].


== MYOB API ==

For a detailed run through of the endpoint, you can see the [https://developer.myob.com/api/accountright/v2/generalledger/account/ MYOB API].


== Related Fields ==

:[[MYOB Field: Accounts|Accounts]] 
:[[MYOB Field: Currencies|Currencies]] 
:[[MYOB Field: TaxCodes|TaxCodes]]


== Related Topics ==

:[[MYOB Models]]
:[[MYOB Endpoints]]