WarehouseHoldings
All stock within Sage 200 regardless of type (Stock, Service/labour, or Miscellaneous), require a holding location. The location indicates where an item is stored and the stock level settings for each product in the warehouse i.e. the re-order level, the minimum and maximum stock levels. Items with a type of 'Stock' have levels recorded for each warehouse location and the levels are used when allocating, issuing and receiving stock. If the stock setting UseMultipleLocations is true, a product can be linked to multiple warehouse holdings. You cannot delete the last warehouse holding associated with a product.
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 WarehouseHoldings WHERE Id = 34738 SELECT * FROM WarehouseHoldings WHERE WarehouseId = 34629 SELECT * FROM WarehouseHoldings WHERE ProductId = 34737 SELECT * FROM WarehouseHoldings WHERE ReorderLevel = 0 SELECT * FROM WarehouseHoldings WHERE MinimumLevel = 0 SELECT * FROM WarehouseHoldings WHERE MaximumLevel = 0 SELECT * FROM WarehouseHoldings WHERE ConfirmedQtyInStock = 0 SELECT * FROM WarehouseHoldings WHERE UnconfirmedQtyInStock = 0 SELECT * FROM WarehouseHoldings WHERE QuantityInStock = 0 SELECT * FROM WarehouseHoldings WHERE QuantityAllocatedStock = 0 SELECT * FROM WarehouseHoldings WHERE QuantityAllocatedSop = 0 SELECT * FROM WarehouseHoldings WHERE QuantityAllocatedBom = 0 SELECT * FROM WarehouseHoldings WHERE QuantityAllocated = 0 SELECT * FROM WarehouseHoldings WHERE DateTimeUpdated = '2019-08-01T18:00:33.140+02:00'
Columns
Name | Type | References | Description |
Id [KEY] | Long | Warehouse holding record Id. | |
WarehouseId | Long |
Warehouses.Id | Warehouse record Id. See warehouses |
ProductId | Long |
Products.Id | Product record Id. See products |
ReorderLevel | Decimal | Reorder stock level. | |
MinimumLevel | Decimal | Minimum stock quantity level. | |
MaximumLevel | Decimal | Maximum stock quantity level. | |
ConfirmedQtyInStock | Decimal | Confirmed stock quantity. | |
UnconfirmedQtyInStock | Decimal | Unconfirmed stock quantity. | |
QuantityInStock | Decimal | Total confirmed and unconfirmed stock quantity. | |
QuantityAllocatedStock | Decimal | Allocated stock quantity. | |
QuantityAllocatedSop | Decimal | Allocated sales order quantity. | |
QuantityAllocatedBom | Decimal | Allocated bill of materials quantity. | |
QuantityAllocated | Decimal | Total Allocated stock, sop and bom quantity. | |
DateTimeUpdated | Datetime | The date and time this entity was last updated (UTC). |