Home > Technical > Table Definitions > PICKINGHDR

PICKINGHDR

This is the header record for the Consolidated Picking transaction. The item details are stored in PICKINGDTL

Column Type Description
LINTCODE INT Unique number assigned by the system to identify the transaction.
STRTRADECODE VARCHAR(10) The location that will pick the goods.
TRADUNIT.strTradeCode
STRDESCRIPTION VARCHAR(50) Description about the transaction.
STRWHO VARCHAR(20) The user who created the transaction.
DTMWHEN DATETIME The date the transaction was created.
STRSTATUS VARCHAR(20) The current status of the transaction.
DTMSTATUS DATETIME The date the transaction status was changed.
STRAUTHORISEDBY VARCHAR(20) The user who authorised the acceptance of the transaction.
INTCHANGEFLAG INT A number that increments as the transaction is changed.
INTNEWFLAG INT A number that increments when the transaction is added.
INTACCEPTED INT A number that increments as the transaction is accepted.
MEMCOMMENTS TEXT General comments about the transaction.
 

Primary Key: LINTCODE

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)