Warehouses
All stock within Sage 200, regardless of type (Stock, Service/labour, or Miscellaneous), requires a holding location. By default, the HOME warehouse is created within Sage 200, you can then create your own warehouses.
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 Warehouses WHERE Id = 34626 SELECT * FROM Warehouses WHERE Name = 'Supplied Direct' SELECT * FROM Warehouses WHERE DateTimeUpdated = '2018-02-28T15:23:46.190+01:00'
Columns
Name | Type | References | Description |
Id [KEY] | Long | Warehouse record Id. | |
Name | String | Warehouse name. | |
DateTimeUpdated | Datetime | The date and time this entity was last updated (UTC). |