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:

Name	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 (1000000000)	XML for the pick ticket.
FIELD1	INTEGER	Customizable.
FIELD2	VARCHAR (254)	Customizable.
FIELD3	VARCHAR (254)	Customizable.
DATE1	TIMESTAMP	Customizable.
DATE2	TIMESTAMP	Customizable.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	PICKBATCH_ID	Primary Key
I0000691	MEMBER_ID	Non-Unique Index
I0000692	FFMCENTER_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_586	FFMCENTER_ID	FFMCENTER	FFMCENTER_ID	Cascade
F_587	MEMBER_ID	MEMBER	MEMBER_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_546	PICKBATCH_ID	ORDRELEASE	PICKBATCH_ID	Cascade

Related reference
ATP inventory fulfillment data model
ATP inventory orders data model
Order release data model