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. |