Home > Technical > Table Definitions > ITEMSTOCKBAY

ITEMSTOCKBAY

This contains the current stock bay information for an item. The records in STOCKBAYHDR and STOCKBAYDTL provide the basis for the updates to this table.

Column

Type

Description

LINTITEMNUMBER

INT

The number of the item in the stock bay.
ITEM.lintItemNumber

STRSTORECODE

VARCHAR(10)

The location where the item is held.
TRADUNIT.strTradeCode

STRBAY

VARCHAR(10)

The stock bay where the item is held

INTTYPE

INT

Not currently used.

DTMWHEN

DATETIME

The date/time the record was created/updated.

 

Primary Key: LINTITEMNUMBER + STRSTORECODE + STRBAY

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