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 Descriptions
| 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.
|