BINominalRecords - Sage 50 Accounts Nominal Records


by Hugh Johnson, Posted on 4/19/2018 2:21:24 PM

 OData, Sage 50 Accounts

BINominalRecords - Sage 50 Accounts Nominal Records

Sage 50 Accounts OData feed for Power BI

The BINominalRecords table is part of the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.  This table provides a list of all of the nominal accounts (sometimes called "general ledger accounts") that form the company's chart of accounts.

This table is essential if you want to perform profit & loss or balance sheet analysis.  

BINominalRecords table

ColumnTypeDescription
NominalRecordIDTextLink to the BITransSplits table
BudgetIDTextLink to the BINominalBudgets table
AccountRefTextAccount reference / nominal code
AccountTypeText"Normal", "Control", or "Bank"
BalanceDecimal NumberAccount balance
NameTextName of the nominal account

BINominalRecords relationships

The BINominalRecords table in the OData feed is related to the BITransSplits table and the BINominalBudgets 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]