CostCentres
Cost centres are typically used to aid collating related costs and reporting on a specific segment of an organisation i.e. a company division such as sales or production.
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 CostCentres WHERE Id = 1015 SELECT * FROM CostCentres WHERE Code = 'abc' SELECT * FROM CostCentres WHERE Name = 'abc' SELECT * FROM CostCentres WHERE DateTimeUpdated = '2018-02-28T15:23:46.230+01:00'
Columns
Name | Type | References | Description |
Id [KEY] | Long | Cost centre record Id. | |
Code | String | Cost centre code. | |
Name | String | Cost centre name. | |
DateTimeUpdated | Datetime | The date and time this entity was last updated (UTC). |