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 criteria 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 | References | 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 |
Currencies.ID |
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 |
Accounts.ID |
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 |
TaxCodes.ID |
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. |