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