Home > Technical > Table Definitions > PICKINGDTL

PICKINGDTL

Still to be documented

Column Type Description
LINTCODE INT The code of the header to which this item belongs.
CTRCODE INT A unique number to identify the specific record.
LINTITEMNUMBER INT The item that needs to be transferred.
ITEM.lintItemNumber
STRDESCRIPTION VARCHAR(100) The item description.
STRORDERCODE VARCHAR(20) The item's order code.
STRSTORECODE VARCHAR(10) The location that originally requested the item.
TRADUNIT.strTradeCode
DBLCARTONSIZE DECIMAL(19,4) The carton size of the item.
DBLUNITS DECIMAL(19,4) The number of units requested to be picked.
DBLUNITSRECEIVED DECIMAL(19,4) The number of units actually picked.
DBLCARTONS DECIMAL(19,4) The number of cartons requested to be picked.
DBLCARTONSRECEIVED DECIMAL(19,4) The number of cartons actually picked.
STRREFERENCE VARCHAR(20) A reference for this carton.
STRSTATUS VARCHAR(20) Current status of the item. Requested/Picked/Accepted
LINTTRANSFERSENDCODE INT The code of the original Transfer Send from which this item was copied.
TFRSENDHDR.ctrCode
LINTLINKCODE INT Identifies the original Transfer Send item from which this item was copied.
TFRSENDDET.ctrCode
INTGROUPNUM INT Used to identify a set of items. When a transaction is accepted, all affected items are given the same INTGROUPNUM. This allows the details to be extracted for reporting correctly.
 

Primary Key: LINTCODE + CTRCODE

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