BICountries - Sage 50 Accounts Countries List


by Hugh Johnson, Posted on 4/17/2018 3:53:45 PM

 Sage 50, OData, Maps

BICountries - Sage 50 Accounts Countries List

Sage 50 Accounts OData feed for Power BI

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.

BICountries table

ColumnTypeDescription
CountryCodeText2-alpha country code e.g. "GB"
NameTextCountry name
EuMemberTrue/FalseIs the country a member of the EU?
Alpha3Text3-alpha country code e.g. "GBR"
RegionTextRegion - e.g. "Europe"
SubRegionTextSub-Region - e.g. "Northern Europe"

Notes: 

  1. [CountryCode] provides the key to the BICustomers table
  2. [Alpha3] is an enrichment to the standard Sage 50 Accounts data to support improved mapping.  Put simply, the Bing Maps engine in Power BI does not recognise the 2-alpha country code, but does recognise the 3-alpha code.

BICountries relationships

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?

 

 


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]