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.
Column | Type | Description |
LINTTRANSCODE | INT | A unique, auto-assigned number for the transaction. |
STRTRADECODE | VARCHAR(10) | Trading
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) |