BusinessExchangeRates
Query BusinessExchangeRates in Sage Business Cloud Accounting.
Table Specific Information
Query the available BusinessExchangeRates
Select
The driver uses the Sage Accounting API to process search criteria that refer to CurrencyId column. The driver processes other filters client-side within the driver.
- CurrencyId supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM BusinessExchangeRates WHERE CurrencyId = 'USD'
Update
Updates are performed based on Id.
UPDATE BusinessExchangeRates SET Rate = 1.5 WHERE CurrencyId = 'USD'
Delete
You must specify the Id of the BusinessExchangeRates to delete it.
DELETE FROM BusinessExchangeRates WHERE CurrencyId = 'USD'
Columns
Name | Type | ReadOnly | References | Description |
CurrencyId [KEY] | String | False |
Currencies.Id |
The unique identifier for the item |
UpdatedAt | Datetime | True |
The datetime when the item was last updated | |
Rate | String | False |
The exchange rate | |
DisplayedAs | String | False |
Display text for the item | |
CreatedAt | Datetime | True |
The datetime when the item was created | |
BaseCurrencyId | String | False |
Currencies.Id |
The unique identifier for the item |
InverseRate | String | False |
The inverse exchange rate |