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

Cmdlets for Sage 200

ProductGroups

Table Specific Information

Select

Columns