TDV Adapter for MYOB

Build 24.0.9060

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060