Products
Products are used to track stock within Sage 200. This is not just for physical items, but also for items that are ordered direct from suppliers, services, and time or labour that can be included on customer invoices.
Table Specific Information
Select
The driver uses the Sage 200c Standard Online API to process search criteria. All filters are processed server side except: WarehouseHoldings columns.
Supported operators are: =, < , <= , > , >= , != , AND, LIKE , IS NULL , IS NOT NULL.
For example, the following queries are processed server side:
SELECT * FROM Products WHERE Id = 34737 SELECT * FROM Products WHERE Code = 'M' SELECT * FROM Products WHERE Name = 'M' SELECT * FROM Products WHERE Description = 'abc' SELECT * FROM Products WHERE Barcode = 'abc' SELECT * FROM Products WHERE AllowSalesOrder = true SELECT * FROM Products WHERE ProductGroupId = 34633 SELECT * FROM Products WHERE TaxCodeId = 1731 SELECT * FROM Products WHERE DateTimeUpdated = '2019-08-01T18:00:33.140+02:00'
Columns
| Name | Type | References | Description |
| Id [KEY] | Long | Product record Id. | |
| Code | String | Product code. | |
| Name | String | Product name. | |
| Description | String | Product description. | |
| Barcode | String | Product barcode. | |
| AllowSalesOrder | Bool | Allowed on a sales order. | |
| ProductGroupId | Long | Product group record Id. See product_groups | |
| TaxCodeId | Long | Tax code record Id. See tax_codes | |
| WarehouseHoldings | String | If stock setting UseMultipleLocations is true, you must specify warehouse holding(s) when creating products. If stock setting UseMultipleLocations is false, then new product will be automatically linked to the default (home) warehouse. See warehouse_holdings | |
| DateTimeUpdated | Datetime | The date and time this entity was last updated (UTC). |