Home > Technical > Table Definitions > STOCKBAYHDR

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.
TRADUNIT.strTradeCode
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)