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