picktask
The table storing details about tasks related to picking inventory items, used in warehouse and fulfillment operations.
Columns
| Name | Type | References | Description |
| externalid | String | A unique identifier for the record assigned by an external system, used for integration or synchronization across platforms. | |
| inventorynumber | String | The unique number assigned to the inventory item, used to track and reference specific products or goods in the system. | |
| item | String | The name or identifier of the item, used to track and manage products, goods, or services within the system. | |
| location | String | The physical or virtual location where the item is stored or located, such as a warehouse, shelf, or section. | |
| memo | String | A brief note or comment associated with the record, often used for internal communication or additional context. | |
| name | Integer | The name or unique identifier associated with the item or record, often used for identification and display purposes in reports or systems. | |
| picker | String | The individual or employee responsible for picking the item, often used in warehouse or inventory management systems. | |
| recommendedbin | String | The recommended bin or storage location for the item, used to optimize storage and retrieval during the picking process. | |
| status | String | The current status of the item or transaction (such as available, out of stock, or in transit), indicating its operational state. | |
| totalpickedquantity | Double | The total quantity of the item that has been picked, used to track progress in the order fulfillment process. | |
| totalremainingquantity | Double | The total quantity of the item that remains to be picked or processed, used to track outstanding quantities. | |
| units | String | The unit of measure (UOM) for the item (such as pieces, kilograms, or liter), used to specify how the item is quantified. | |
| wave | String | The wave or batch associated with the order picking process, used to organize and prioritize multiple orders for fulfillment. |