Home > Technical > Table Definitions > ITEMBAY

ITEMBAY

These records record the stock bays where items are held.

Column

Type

Description

LINTITEMNUMBER

INT(4)

The item this modifier belongs to.

ITEM.lintItemNumber

STRTRADECODE

VARCHAR(10)

The location where the stock is held.

TRADUNIT.strTradeCode

DTMWHEN

DATETIME(8)

The date the record was created.

CTRCODE

INT(4)

A unique number assigned by the system.

STRBAY

VARCHAR(10)

The stock bay where the item is kept.

 

Primary Key: LINTITEMNUMBER + STRTRADECODE + DTMWHEN + CTRCODE

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