Home > Technical > Table Definitions > STOCKBAYHDR
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 header record for the transaction. STOCKBAYDTL contains the items in the transaction.
|LINTTRANSCODE||INT||A unique, auto-assigned number for the transaction.|
unit these movements are for.
|STRWHO||VARCHAR(20)||The user who created the transaction.|
|DTMWHEN||DATETIME||The date the transaction was created.|
|STRSTATUS||VARCHAR(10)||The status of the transaction. Can be New or Accepted|
|DTMSTATUS||DATETIME||The date the status was changed.|
|STRAUTHORISEDBY||VARCHAR(20)||Not currently used.|
|INTCHANGEFLAG||INT||A number that is incremented when the transaction is changed.|
|INTNEWFLAG||INT||A number that is incremented when the transaction is created.|
|MEMCOMMENT||TEXT||Not currently used.|
Primary Key: LINTTRANSCODE
|Converted from CHM to HTML with chm2web Pro 2.85 (unicode)|