NominalCodes
Nominal accounts are fundamental to the successful management of company finances. The value of every transaction entered into Sage 200 is posted to a nominal account and, is where the revenue and expenditure of the business is recorded. Nominal accounts include a code, and cost centre and a department.
Table Specific Information
Select
The driver uses the Sage 200c Standard Online API to process all search criteria.
Supported operators are: =, < , <= , > , >= , != , AND, LIKE , IS NULL , IS NOT NULL.
For example, the following queries are processed server side:
SELECT * FROM NominalCodes WHERE Id = 2317 SELECT * FROM NominalCodes WHERE Name = 'Freehold Property' SELECT * FROM NominalCodes WHERE Reference = '0010' SELECT * FROM NominalCodes WHERE CostCentreId = 1015 SELECT * FROM NominalCodes WHERE CostCentreCode = 'abc' SELECT * FROM NominalCodes WHERE DepartmentId = 1016 SELECT * FROM NominalCodes WHERE DepartmentCode = 'abc' SELECT * FROM NominalCodes WHERE NominalAccountType = 'NominalAccountTypePosting' SELECT * FROM NominalCodes WHERE AccountStatusType = 'AccountStatusActive' SELECT * FROM NominalCodes WHERE ReportCategoryId = 2289 SELECT * FROM NominalCodes WHERE DisplayBalancesInSelectionList = false SELECT * FROM NominalCodes WHERE BalanceYearToDate = 123.3 SELECT * FROM NominalCodes WHERE DateTimeUpdated = '2018-02-28T15:23:46.717+01:00'
Columns
Name | Type | References | Description |
Id [KEY] | Long | Nominal code record Id. | |
Name | String | Nominal code name. | |
Reference | String | Nominal code reference. | |
CostCentreId | Long |
CostCentres.Id | Nominal code cost centre record Id. See cost_centres |
CostCentreCode | String | Cost centre code. | |
DepartmentId | Long |
Departments.Id | Nominal code department record Id. See departments |
DepartmentCode | String | Department code. | |
NominalAccountType | String | The type of the nominal code. See nominal_account_types | |
AccountStatusType | String | The status of the nominal code (Sage 200c Standard and versions of Professional released after February 2018). For example, this can either be 'Active' or 'Hidden'. See account_status_types | |
ReportCategoryId | Long | Financial report category record Id. See nominal_report_categories | |
DisplayBalancesInSelectionList | Bool | Whether balances for the nominal code can be shown in selection lists. | |
BalanceYearToDate | Decimal | The nominal account balance, if balances can be shown for the nominal account. | |
DateTimeUpdated | Datetime | The date and time this entity was last updated (UTC). |