Departments
Departments are a subdivision of cost centres and are used where specific costs or revenue need to be collated and reported on separately. For example, a cost centre could be a sales area such as North East or South West and different departments could be Administration and Training.
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 Departments WHERE Id = 1016 SELECT * FROM Departments WHERE Code = 'abc' SELECT * FROM Departments WHERE Name = 'abc' SELECT * FROM Departments WHERE DateTimeUpdated = '2018-02-28T15:23:46.277+01:00'
Columns
Name | Type | References | Description |
Id [KEY] | Long | Department record Id. | |
Code | String | Department code. | |
Name | String | Department name. | |
DateTimeUpdated | Datetime | The date and time this entity was last updated (UTC). |