Edit

Inventory

Internal name Inventory

The inventory table is a subfile of Product, and stores the stock on hand of an item for each serial/batch and location combination.

ExpiryDThe expiry date for expiring batches
Identifier3131The serial/batch number of the item
LastModifiedTimeSDate and time the record was last altered
LocationT15The location
ProductSeqNThe sequencenumber of the product master record for the item
QtyNThe qty (stock on hand) of the item at this location. Use the SOHForLocation(location) function for the stock at a given location.
StockTakeNewQtyNThe total entered stock count for a stock take. Use the StocktakeNewQtyForLocation(location) function for the stock at a given location.
StockTakeStartQtyNThe total stock on hand when a stock take is commenced. Use the StocktakeStartQtyForLocation(location) function for the stock at a given location.