JDBC Driver for MYOB

Build 22.0.8462

Currencies

View currencies within an Accountright Live 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, Code, CurrencyName, CurrencyRate. All the other columns and operators are processed client side.

SELECT * FROM Currencies WHERE Code = "AED"
SELECT * FROM Currencies WHERE CurrencyName = "Emirati Dirham"

Columns

Name Type Description
ID [KEY] Uuid Unique identifier in the form of a guid.
Code String Three letter ISO 4217 code for this currency.
CurrencyName String Full currency name.
CurrencyRate Decimal Conversion rate from local currency.
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.
URI String Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web.
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