CData Python Connector for Sage 200

Build 20.0.7587

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

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587