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 Description(s):
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 |
Shipping 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 |
Shipping 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) |
Tracking 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. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031237140 |
MANIFEST_ID |
Primary Key |
I0000364 |
ORDERS_ID+ORDRELEASENUM+MANIFESTSTATUS |
Non-Unique Index |
I0000609 |
SHIPMODE_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | 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 |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.