BICurrencies - Sage 50 Accounts Currencies List


by Hugh Johnson, Posted on 4/17/2018 4:21:26 PM

 Sage 50, OData, currencies

BICurrencies - Sage 50 Accounts Currencies List

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.   

BICurrencies table

ColumnTypeDescription
CurrencyIDTextUnique key used by the OData feed
CodeText3-apha code e.g. "GBP"
RateDecimal NumberThe exchange rate (currency) / (base currency)
BaseCurrencyTrue/FalseWhether this is base currency

Notes: 

  1. All the amounts in the OData feed are presented in base amount.  
  2. The underlying currency of a customer transaction is determined by the customer account.
  3. This table is straight from Sage 50 Accounts with no changes
  4. The exchange rate is not a live rate, but the value currently held in Sage 50

BICurrencies relationships

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?

 

 


Copyright © 2019,
Accounting Insights Ltd.
All Rights Reserved.

Our Office :
Unit 4, Roof Garden Offices,
Clarehall Shopping Centre,
Dublin,
Ireland

+353 1 567 4069

[email protected]