Home > Technical > Table Definitions > 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.![]() |
STRDESCRIPTION | VARCHAR(100) | The item description. |
STRORDERCODE | VARCHAR(20) | The item's order code. |
STRSTORECODE | VARCHAR(10) | The
location that originally requested the item.![]() |
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.![]() |
LINTLINKCODE | INT | Identifies
the original Transfer Send item from which this item was
copied.![]() |
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) |