by Hugh Johnson, Posted on 4/19/2018 2:21:24 PM
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.
|NominalRecordID||Text||Link to the BITransSplits table|
|BudgetID||Text||Link to the BINominalBudgets table|
|AccountRef||Text||Account reference / nominal code|
|AccountType||Text||"Normal", "Control", or "Bank"|
|Balance||Decimal Number||Account balance|
|Name||Text||Name of the nominal account|
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?