JDBC Driver for MYOB

Build 22.0.8462

BankAccounts

Return the bank 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, FinancialInstitution, BankAccountName, BSB, BankAccountNumber, CardName, CardNumber, AccountID, AccountDisplayID, AccountName, LastReconciledDate. All the other columns and operators are processed client side.

SELECT * FROM BankAccounts WHERE ID = REPLACE
SELECT * FROM BankAccounts WHERE FinancialInstitution = "ANZ"

Columns

Name Type Description
ID [KEY] Uuid Unique identifier in the form of a guid.
FinancialInstitution String The code for the Financial Institution.
BankAccountName String Bank account name setup.
BSB String BSB as provided by the financial institution.
BankAccountNumber Integer Account number as provided by the financial institution.
CardName String The name on the credit card.
CardNumber String The credit card number.
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.
BankLinkStatus String The status of the Bankfeed connection.
LastReconciledDate Datetime Shows the date that the Account was last reconciled. This will return as null if the Account has never been reconciled.
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.
CompanyFileId String 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