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). |