JDBC Driver for MYOB

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462