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