Return a list of bank statement transactions for an AccountRight company file.
Table Specific Information
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
|ID [KEY]||Uuid||Unique identifier in the form of a guid.|
|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.|