BISupplierCurrencies - Sage 50 Accounts Supplier Currencies table


by Hugh Johnson, Posted on 4/19/2018 9:16:56 AM

 Power BI Desktop, OData, currencies, suppliers, Sage 50 Accounts

BISupplierCurrencies - Sage 50 Accounts Supplier Currencies table

Sage 50 Accounts OData feed for Power BI

This article describes the BISupplierCurrencies table in the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.    This table is a duplicate of the BICurrencies table and included to avoid relational ambiguity between BISuppliers, BICustomers and BITransSplits.

This table is essential if you want to analyse your Sage 50 purchases by currency.

BISupplierCurrencies table

ColumnTypeDescription
SupplierCurrencyIDTextLink to BISuppliers table
SupplierCodeText3-alpha currency code
NameTextCurrency descriptive name
RateDecimal NumberExchange Rate (currency(/(base currency)
BaseCurrencyTrue/FalseWhether the currency is the base currency

BISupplierCurrencies relationships

The BISupplierCurrencies table in the OData feed is related to the BISuppliers table via the [SupplierCurrencyID].

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]