BICurrencies - Sage 50 Accounts Currencies List
by Hugh Johnson, Posted on 4/17/2018 4:21:26 PM
Sage 50, OData, currencies
Sage 50 Accounts OData feed for Power BI
This article describes the BICurrencies table in the Suntico Sage 50 Accounts OData feed for Microsoft Power BI. This table is the list of currencies from your Sage 50 Accounts system.
|CurrencyID||Text||Unique key used by the OData feed|
|Code||Text||3-apha code e.g. "GBP"|
|Rate||Decimal Number||The exchange rate (currency) / (base currency)|
|BaseCurrency||True/False||Whether this is base currency|
- All the amounts in the OData feed are presented in base amount.
- The underlying currency of a customer transaction is determined by the customer account.
- This table is straight from Sage 50 Accounts with no changes
- The exchange rate is not a live rate, but the value currently held in Sage 50
The BICurrencies table in the OData feed is related to the BICustomers table as shown below.
To try our this OData feed for your Sage 50 Accounts data, why not create your own Suntico BI trial account?