WebSphere Commerce database table: PICKBATCH

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 NameColumn TypeDescription
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 NameIndexed Column NamesIndex Type
SQL050212031254800 PICKBATCH_ID Primary Key
I0000691 MEMBER_ID Non-Unique Index
I0000692 FFMCENTER_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_586 FFMCENTER_ID FFMCENTER FFMCENTER_ID Cascade
F_587 MEMBER_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_546 PICKBATCH_ID ORDRELEASE PICKBATCH_ID Cascade

Feedback