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

Name	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	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>	MANIFEST_ID	Primary Key
I0000364	ORDERS_ID+ORDRELEASENUM+MANIFESTSTATUS	Non-Unique Index
I0000609	SHIPMODE_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_425	WEIGHTMEASURE	QTYUNIT	QTYUNIT_ID	Cascade
F_426	SETCCURR	SETCURR	SETCCURR	Cascade
F_427	SHIPMODE_ID	SHIPMODE	SHIPMODE_ID	Cascade
F_428	ORDERS_ID+ORDRELEASENUM	ORDRELEASE	ORDERS_ID+ORDRELEASENUM	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_3475	MANIFEST_ID	ORDITEMCONF	MANIFEST_ID	Cascade