Home > Technical > Table Definitions > STOCKBAYDTL

STOCKBAYDTL

When changes are made to the stock bays in which an item is held, a stock bay transaction needs to be created. This is the detail table which holds the items in a transaction. STOCKBAYHDR contains the header record of the transaction.

Column Type Description
LINTTRANSCODE INT The transaction number to which this record belongs.
CTRCODE INT A unique number assigned by the system.
INTACTION INT Indicates whether the item is being added or deleted from the stock bay. 1=Add, 2=Delete
LINTITEMNUMBER INT The number of the item being added/deleted.
ITEM.lintItemNumber
STRDESCRIPTION VARCHAR(100) Description of the item.
STRAPN VARCHAR(20) The barcode scanned to identify the item.
STRBAY VARCHAR(10) The stock bay that the item is being added to/deleted from.
 

Primary Key: LINTTRANSCODE + CTRCODE

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