SSIS Components for Sage 200

Build 20.0.7587

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

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