Tableau Connector for Sage 200

Build 24.0.9060

Currencies

Sage 200 works in multiple currencies and each company can configure up to 99 currencies to use, and all can be configured to use a single exchange rate, period exchange rates, or both. One currency must be configured as the base currency and this cannot be changed once transactions have been entered. If a currency is configured as amendable, the exchange rate can be modified when entering transactions.

Table Specific Information

Select

The driver uses the Sage 200c Standard Online API to process search criteria. All filters are processed server side except: CurrencyIsoCode,CurrencyIsoCodeName columns.

Supported operators are: =, < , <= , > , >= , != , AND, LIKE , IS NULL , IS NOT NULL.

For example, the following queries are processed server side:

SELECT * FROM Currencies WHERE Id = 2103
SELECT * FROM Currencies WHERE Symbol = '£'
SELECT * FROM Currencies WHERE Name = 'Pound Sterling'
SELECT * FROM Currencies WHERE CoreCurrencyRate = 1
SELECT * FROM Currencies WHERE EuroCurrencyRate = 0.714285
SELECT * FROM Currencies WHERE CurrencyIsoCodeId = 49
SELECT * FROM Currencies WHERE IsBaseCurrency = true
SELECT * FROM Currencies WHERE IsEuroCurrency = false
SELECT * FROM Currencies WHERE DateTimeUpdated = '2018-02-28T15:23:46.243+01:00'

Columns

Name Type References Description
Id [KEY] Long Currency record Id.
Symbol String Currency symbol.
Name String Currency name.
CoreCurrencyRate Decimal Currency rate in use against base.
EuroCurrencyRate Decimal Euro rate.
CurrencyIsoCodeId Long ISO Currency Code Record Id. See currency_iso_codes
CurrencyIsoCode String ISO Currency Code Record Id. See currency_iso_codes
CurrencyIsoCodeName String ISO Currency Code Record Id. See currency_iso_codes
IsBaseCurrency Bool Flag to indicate if the currency is the base currency.
IsEuroCurrency Bool Flag to indicate if the currency is Euro.
DateTimeUpdated Datetime The date and time this entity was last updated (UTC).

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