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 Name Column Type Column Description
DATE1 TIMESTAMP
NULL
Customizable.
DATE2 TIMESTAMP
NULL
Customizable.
FFMCENTER_ID INTEGER
NOT NULL
FulfillmentCenter for which the pick batch was generated. Foreign key to FFMCENTER.
FIELD1 INTEGER
NULL
Customizable.
FIELD2 VARCHAR (254)
NULL
Customizable.
FIELD3 VARCHAR (254)
NULL
Customizable.
LASTUPDATE TIMESTAMP
NULL
Timestamp when the pick batch was last updated.
MEMBER_ID BIGINT
NULL
ID of the user who generated the pick batch.
PICKBATCH_ID BIGINT
NOT NULL
Unique key.
PICKSLIPXML CLOB (1000000000)
NULL
XML for the pick ticket.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035032090 PICKBATCH_ID Primary Key
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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_546 PICKBATCH_ID ORDRELEASE PICKBATCH_ID Cascade