NominalReportCategories
Nominal report categories are used in financial statements (PL, Balance Sheet) to group nominal codes under headings and to determine whether the nominal code value is reported on the layout for the Balance Sheet (Asset and Liability) or Profit and Loss (Income and Expense).
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 NominalReportCategories WHERE Id = 2258 SELECT * FROM NominalReportCategories WHERE AccountReportType = 'ProfitLoss' SELECT * FROM NominalReportCategories WHERE Code = '1' SELECT * FROM NominalReportCategories WHERE Description = 'Sales' SELECT * FROM NominalReportCategories WHERE AccountReportCategoryType = 'NominalReportingCategoryTypeIncome' SELECT * FROM NominalReportCategories WHERE DateTimeUpdated = '2018-02-28T15:23:45.960+01:00'
Columns
| Name | Type | References | Description |
| Id [KEY] | Long | Nominal report category record Id. | |
| AccountReportType | String | The type of the report.. See financial_report_layout_types | |
| Code | String | Nominal report category code. | |
| Description | String | Nominal report category description. | |
| AccountReportCategoryType | String | The type of the report category. See nominal_report_category_types | |
| DateTimeUpdated | Datetime | The date and time this entity was last updated (UTC). |