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:

NameTypeDescription
PICKBATCH_IDBIGINT NOT NULLUnique key.
LASTUPDATETIMESTAMPTimestamp when the pick batch was last updated.
FFMCENTER_IDINTEGER NOT NULLFulfillmentCenter for which the pick batch was generated. Foreign key to FFMCENTER.
MEMBER_IDBIGINTID of the user who generated the pick batch.
PICKSLIPXMLCLOB (1000000000)XML for the pick ticket.
FIELD1INTEGERCustomizable.
FIELD2VARCHAR (254)Customizable.
FIELD3VARCHAR (254)Customizable.
DATE1TIMESTAMPCustomizable.
DATE2TIMESTAMPCustomizable.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>PICKBATCH_IDPrimary Key
I0000691MEMBER_IDNon-Unique Index
I0000692FFMCENTER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_586FFMCENTER_IDFFMCENTERFFMCENTER_IDCascade
F_587MEMBER_IDMEMBERMEMBER_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_546PICKBATCH_IDORDRELEASEPICKBATCH_IDCascade