Currencies
Create, update, delete, and query currencies used in SuiteCRM financial trackings
Table Specific Information
Select
You can query the Currencies table using any criteria in the WHERE clause. The connector will use the SuiteCRM API to filter the results.
SELECT * FROM Currencies WHERE [Conversion Rate] > 2.34
Insert
Create a Currency by specifying any writable column.
INSERT INTO Currencies ([Iso 4217 Code], [Currency Name]) VALUES ('CAD', 'Canadian Dollar')
Update
You can update any Currency column that is writable, by specifying the Id.
UPDATE Currencies SET [Conversion Rate] = 1.18 WHERE Id = 'Test123'
Delete
Delete a Currency by specifying the Id.
DELETE FROM Currencies WHERE Id = 'Test123'
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
The unique identifer of the currency. |
| ConversionRate | Double | False |
Conversion rate factor (relative to stored value). |
| CreatedById | String | False |
Id of the user who created the record. |
| CreatedByName | String | False |
Id of the user who created the record. |
| CurrencyName | String | False |
Name of the currency. |
| CurrencySymbol | String | False |
Symbol representing the currency. |
| DateCreated | Datetime | False |
Date the record was created. |
| DateModified | Datetime | False |
Date the record was last modified. |
| Deleted | Bool | False |
Record deletion indicator. |
| hide | String | True |
Hide status of the currency |
| ISO4217Code | String | False |
3-letter identifier specified by ISO 4217 (e.g., USD). |
| Status | String | False |
Currency status. |
| unhide | String | True |
Unhide status of the currency |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Rows@Next | String |
Identifier for the next page of results. Do not set this value manually. |