This table contains pick batch information. A pick batch groups together order releases for their processing as a unit at a FulfillmentCenter (picking inventory for OrderItems, packing them into boxes, and shipping to customer through selected carrier).
Column Description(s):
Column Name | Column Type | Description |
PICKBATCH_ID |
BIGINT NOT NULL |
Unique key. |
LASTUPDATE |
TIMESTAMP |
Timestamp when the pick batch was last updated. |
FFMCENTER_ID |
INTEGER NOT NULL |
FulfillmentCenter for which the pick batch was generated. Foreign key to FFMCENTER. |
MEMBER_ID |
BIGINT |
ID of the user who generated the pick batch. |
PICKSLIPXML |
CLOB |
XML for the pick ticket. |
FIELD1 |
INTEGER |
Customizable. |
FIELD2 |
VARCHAR(254) |
Customizable. |
FIELD3 |
VARCHAR(254) |
Customizable. |
DATE1 |
TIMESTAMP |
Customizable. |
DATE2 |
TIMESTAMP |
Customizable. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031254800 |
PICKBATCH_ID |
Primary Key |
I0000691 |
MEMBER_ID |
Non-Unique Index |
I0000692 |
FFMCENTER_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_586 |
FFMCENTER_ID |
FFMCENTER |
FFMCENTER_ID |
Cascade |
F_587 |
MEMBER_ID |
MEMBER |
MEMBER_ID |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_546 |
PICKBATCH_ID |
ORDRELEASE |
PICKBATCH_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.