SSIS Components for Sage 200

Build 20.0.7587

ProductGroups

Product groups are used to group stock items together with similar characteristics or requirements. Product Groups provide several default settings for stock items and, have their own unique code and description.

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 ProductGroups WHERE Id=34632
SELECT * FROM ProductGroups WHERE Code='NONS'
SELECT * FROM ProductGroups WHERE Description='Non Stock Item'
SELECT * FROM ProductGroups WHERE ProductType='EnumStockItemTypeMisc'
SELECT * FROM ProductGroups WHERE CanLevelsGoNegative=false
SELECT * FROM ProductGroups WHERE DateTimeUpdated='2018-02-28T15:23:46.310+01:00'

Columns

Name Type References Description
Id [KEY] Long Product group Id.
Code String Product group code.
Description String Product group description.
ProductType String Product group type. See product_types
CanLevelsGoNegative Bool Can stock levels go negative.
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