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. | |
| CompanyFileId | String |
CompanyFiles.ID | ID of the company file. Takes precedence over the CompanyFileId property. |