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