Home > Technical > Table Definitions > MULTILOCATIONSTOCK

MULTILOCATIONSTOCK

This table is used to store details about the stock at other locations. (To get stock at current location, use dblStockOnHand in STORERNG.)

Column

Type

Description

STRSTORECODE

VARCHAR(10)

The location that this stock information is for.

LINTITEMNUMBER

INT(4)

The item that this stock information is for.

ITEM.lintItemNumber

DBLSTOCKONHAND

DECIMAL(9)19,4

The quantity of stock for the item at the location.

DBLORDEREDQTY

DECIMAL(9)19,4

The quantity on order.

DBLALLOCATEDQTY

DECIMAL(9)19,4

The quantity of stock allocated for pending orders.

 

Primary Key: STRSTORECODE + LINTITEMNUMBER

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)