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. It picks inventory for OrderItems, packs them into boxes, and ships to customer through selected carrier.
Column Descriptions
| 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.
|
Indexes
| Index Name
| Indexed Column Names
| Index Type |
| SQL060903235229080
| PICKBATCH_ID
| Primary Key
|
| I0000691
| MEMBER_ID
| Non-Unique Index
|
| I0000692
| FFMCENTER_ID
| Non-Unique Index
|
Constraints
| Constraint Name
| Column Names
| Foreign Table Name
| Foreign Column Names
| Constraint Type |
| F_586
| FFMCENTER_ID
| FFMCENTER
| FFMCENTER_ID
| Cascade
|
| F_587
| MEMBER_ID
| MEMBER
| MEMBER_ID
| Cascade
|
| Constraint Name
| Referenced Column Name
| Foreign Table Name
| Foreign Column Names
| Constraint Type |
| F_546
| PICKBATCH_ID
| ORDRELEASE
| PICKBATCH_ID
| Cascade
|
Related reference