Reference > Database > WebSphere Commerce database tables > M
WebSphere Commerce database table: MANIFEST
One record exists for each manifest (shipment confirmation) produced for an order release. If a release is packaged in two boxes there will be two rows in the manifest table.
Column Name Column Type Description MANIFEST_ID BIGINT NOT NULL Generated unique key. ORDRELEASENUM INTEGER NOT NULL Uniquely identifies the release for this order. WEIGHTMEASURE CHAR(16) The unit of measure of the package weight. SETCCURR CHAR(3) Currency in which the shipment was charged. SHIPMODE_ID INTEGER Ship provider. WEIGHT DOUBLE The weight of the package. MANIFESTSTATUS CHAR(1) NOT NULL DEFAULT 'S' S=Shipped V=Void. Initial status = S SHIPPINGCOSTS DECIMAL (20,5) NOT NULL Ship costs. DATESHIPPED TIMESTAMP NOT NULL The date the package shipped. FIELD1 VARCHAR(254) Customizable. LASTUPDATE TIMESTAMP Timestamp of last update. PACKAGEID CHAR(20) Package identifier. TRACKINGID VARCHAR(40) Track identifier. PICKUPRECORDID CHAR(20) Pickup record identifier. ORDERS_ID BIGINT NOT NULL ORDERS_ID from ORDERS table for which the manifest is performed. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030351770 MANIFEST_ID Primary Key I0000364 ORDERS_ID+ORDRELEASENUM+MANIFESTSTATUS Non-Unique Index I0000609 SHIPMODE_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_428 ORDERS_ID ORDRELEASENUM ORDRELEASE ORDERS_ID Cascade F_425 WEIGHTMEASURE QTYUNIT QTYUNIT_ID Cascade F_426 SETCCURR SETCURR SETCCURR Cascade F_427 SHIPMODE_ID SHIPMODE SHIPMODE_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_3475 MANIFEST_ID ORDITEMCONF MANIFEST_ID Cascade
Related reference
- Quantity unit - references data model
- Order release data model
- ATP inventory fulfillment data model
- ATP inventory orders data model
_vcc_freeselect_bottom_