Cmdlets for Sage Business Cloud Accounting

Build 24.0.9062

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

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