TDV Adapter for Sage 200

Build 22.0.8462


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


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'


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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462