JDBC Driver for Sage 200

Build 24.0.9062

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062