Accounts

Return, update, create and delete accounts for an AccountRight company file.

Table Specific Information

Select

MYOB allows a subset of columns to be used in the WHERE clause of a SELECT query. These columns may be used with the following operators: =, !=, >, <, >=, <=. In addition, queries with multiple criterias can be executed by combining the criteria with AND and OR operators. These columns support the above comparison types for server side filtering: ID, Classification, CurrentBalance, Description, DisplayID, IsActive, IsHeader, Level, Name, Number, OpeningBalance, Type, LastReconciledDate, BankingBSBNumber, BankingAccountName, BankingAccountNumber, BankingCode, BankingCompanyTradingName, BankingCreateBankFiles, BankingDirectEntryUserId, BankingIncludeSelfBalancingTransaction, BankingStatementParticulars, ForeignCurrencyID, ForeignCurrencyCode, ForeignCurrencyCurrencyName, ParentAccountID, ParentAccountDisplayID, ParentAccountName, TaxCodeID, TaxCodeCode. All the other columns and operators are processed client side.

SELECT * FROM Accounts WHERE ID = REPLACE
SELECT * FROM Accounts WHERE Classification = "criteria"
SELECT * FROM Accounts WHERE CurrentBalance = 40.72729281968018

Insert

The following attributes are required when performing an insert: Number, Type, TaxCodeID.

INSERT INTO Accounts(Number, Type, TaxCodeID) VALUES(101, "bank", "2619bed9-3750-45b5-b353-18f5651beb01")

Columns


Name	Type	ReadOnly	Description
ID [KEY]	Uuid	False	Unique identifier in the form of a guid.
Classification	String	False	The account classification can be one of the following: (1) Asset, (2) Liability, (3) Equity, (4) Income, (5) CostOfSales, (6) Expense, (8) OtherIncome, (9) OtherExpense.
CurrentBalance	Decimal	True	Current balance of the account. Note that this balance will include all future-dated activity.
Description	String	False	A description of the account.
DisplayID	String	False	Account code format includes separator ie 1-1100
IsActive	Boolean	False	True indicates the account is active. False indicates the account is inactive. A user marks an account as inactive when they no longer need to record transactions to it
IsHeader	Boolean	False	True indicates the account is a header account.Header accounts are used to organise, group and subtotal accounts in the Accounts List and reports. False indicates the account is a detail account. Only detail accounts can be assigned to transactions.
Level	Integer	False	The hierarchial level of the account in the Accounts List. Possible values are 1, 2, 3, 4. The highest level accounts are level 1, the lowest 4. You can only assign levels 2 to 4 to a new account.
Name	String	False	Name of the account.
Number	Integer	False	Account number for example 1150. Must be a unique four-digit number that does not include the account type classification number and account separator.
OpeningBalance	Decimal	False	Balance of the account as at the conversion date set for the company file.
Type	String	False	Depending on the classification of the account (e.g. asset), you can define the account's type, see here for more information on account types.
LastReconciledDate	Datetime	True	Shows the date that the Account was last reconciled. This will return as null if the Account has never been reconciled.
URI	String	True	Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web.
RowVersion	String	True	Number value that changes upon a record update, can be used for change control but does does not preserve a date or a time.
BankingBSBNumber	String	False	BSB as provided by the financial institution.
BankingAccountName	String	False	Bank account name setup.
BankingAccountNumber	Integer	False	Account number as provided by the financial institution.
BankingCode	String	False	Bank code as provided by the financial institution.
BankingCompanyTradingName	String	False	Company trading name if applicable for bank account.
BankingCreateBankFiles	Boolean	False	True indicates the bank account will be used to create bank files (ABA). False indicates the bank account will not be used to create bank files.
BankingDirectEntryUserId	String	False	Direct entry user id as provided by the financial institution.
BankingIncludeSelfBalancingTransaction	Boolean	False	True indicates the bank account requires a self balancing transaction. False indicates the bank account does not require a self balancing transaction.
BankingStatementParticulars	String	False	Statement particulars assigned to the bank account.
ForeignCurrencyID	Uuid	True	Unique identifier in the form of a guid.
ForeignCurrencyCode	String	True	The currency code.
ForeignCurrencyCurrencyName	String	True	The full name of the currency.
ForeignCurrencyURI	String	True	Uniform resource identifier associated with the purchase.
ParentAccountID	Uuid	False	Unique identifier for the account in the form of a guid.
ParentAccountDisplayID	String	True	Account code. Format includes separator ie 4-1100
ParentAccountName	String	True	Name of the account.
ParentAccountURI	String	True	Uniform resource identifier associated with the account object.
TaxCodeID	Uuid	False	Unique guid identifier belonging to the assigned tax code.
TaxCodeCode	String	True	3 digit tax code.
TaxCodeURI	String	True	Uniform resource identifier associated with the tax code object.
CompanyFileId	String	True	The ID of the company file. Takes precedence over the CompanyFileId connection property.

JDBC Driver for MYOB

Accounts

Table Specific Information

Select

Insert

Columns