Home > Technical > Table Definitions > 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.
|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|
of the item being added/deleted.
|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)|