by Hugh Johnson, Posted on 4/17/2018 3:53:45 PM
This article describes the BICountries table in the Suntico Sage 50 Accounts OData feed for Microsoft Power BI. This table is the list of countries from your Sage 50 Accounts system, enriched with some additional fields to support better geographical analysis of your sales data in Sage 50. You will need this table if you want to display your Sage 50 Accounts data as filled maps.
|CountryCode||Text||2-alpha country code e.g. "GB"|
|EuMember||True/False||Is the country a member of the EU?|
|Alpha3||Text||3-alpha country code e.g. "GBR"|
|Region||Text||Region - e.g. "Europe"|
|SubRegion||Text||Sub-Region - e.g. "Northern Europe"|
The BICountries table in the OData feed has relationships with the BICustomers table which contains the Sage 50 Accounts customers as shown below. You may expect this table also to be related to the BISuppliers table, but this would cause ambiguity in the transactional relationships via the BITransSplits table.
To try our this OData feed for your Sage 50 Accounts data, why not create your own Suntico BI trial account?