BankingTransactions

Return a list of bank statement transactions 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, Date, Description, IsCredit, StatementDate, Status, Amount, AccountID, AccountDisplayID, AccountName. All the other columns and operators are processed client side.

SELECT * FROM BankingTransactions WHERE ID = "6d35e53a-5070-432d-b9ec-f4791e353352"
SELECT * FROM BankingTransactions WHERE IsCredit = true
SELECT * FROM BankingTransactions WHERE Amount = 1400 OR Amount = 1800

Columns


Name	Type	Description
ID [KEY]	Uuid	Unique identifier in the form of a guid.
Date	Datetime	Transaction date.
Description	String	Description text for the transaction.
IsCredit	Boolean	True or false.
StatementDate	Datetime	Date when the BankStatement was pulled into AccountRight.
Status	String	One of: Uncoded, Coded, Hidden.
Amount	Decimal	Dollar amount of the withdrawal or deposit.
URI	String	Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web.
RowVersion	String	Number value that changes upon a record update, can be used for change control but does does not preserve a date or a time.
AccountID	Uuid	Unique identifier for the account in the form of a guid.
AccountDisplayID	String	Account code. Format includes separator ie 4-1100
AccountName	String	Name of the account.
AccountURI	String	Uniform resource identifier associated with the account object.
CompanyFileId	String	The ID of the company file. Takes precedence over the CompanyFileId connection property.

JDBC Driver for MYOB

BankingTransactions

Table Specific Information

Select

Columns