BISuppliers - Sage 50 Accounts Suppliers table


by Hugh Johnson, Posted on 4/18/2018 9:36:19 PM

 OData, Sage 50 Accounts

BISuppliers - Sage 50 Accounts Suppliers table

Sage 50 Accounts OData feed for Power BI

This article describes the BISuppliers table in the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.  The table is derived from the underlying Sage 50 Accounts PURCHASE_LEDGER ODBC table. 

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

BISuppliers table

ColumnTypeDescription
SupplierIDTextLink to related tables
AccountOnHoldTrue/FalseWhether the account is on hold
AccountRefTextSupplier Account Ref from Sage 50
AccountStatusTextSupplier Account Status from Sage 50
Address1TextSupplier address line 1
Address2TextSupplier address line 2
Address3TextSupplier address line 3
Address4TextSupplier address line 4
Address5TextSupplier address line 5
BalanceDecimal NumberAccount balance
CreditLimitDecimal NumberAccount credit limit
DefNomCodeTextDefault nominal code
FirstInvoiceDate/TimeDate of first invoice
LastInvDateDate/TimeDate of last invoice
LastPayDateDate/TimeDate of last payment
NameTextSupplier name
CountryCodeText2-alpha country code
DeptNameTextDefault supplier department
SupplierCurrencyIDTextLink to BISupplierCurrencies table
PaymentDueDaysWhole NumberDefault due days for supplier invoices
DeptNumberTextDefault supplier department number

BISuppliers relationships

The BISuppliers table in the OData feed is related to the BISupplierCurrencies table via the [SupplierCurrencyID], the BITransSplits table via the [SupplierID], aand the BIPurchaseOrders table via the [SupplierID].

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]