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 Column Description
DATESHIPPED TIMESTAMP
NOT NULL
The date the package shipped.
FIELD1 VARCHAR (254)
NULL
Customizable.
LASTUPDATE TIMESTAMP
NULL
Timestamp of last update.
MANIFESTSTATUS CHARACTER (1)
NOT NULL, DEFAULT 'S'
S=Shipped V=Void. Initial status = S
MANIFEST_ID BIGINT
NOT NULL
Generated unique key.
ORDERS_ID BIGINT
NOT NULL
ORDERS_ID from ORDERS table for which the manifest is performed.
ORDRELEASENUM INTEGER
NOT NULL
Uniquely identifies the release for this order.
PACKAGEID CHARACTER (20)
NULL
Package identifier.
PICKUPRECORDID CHARACTER (20)
NULL
Pickup record identifier.
SETCCURR CHARACTER (3)
NULL
Currency in which the shipment was charged.
SHIPMODE_ID INTEGER
NULL
Shipping provider.
SHIPPINGCOSTS DECIMAL (20,5)
NOT NULL
Shipping costs.
TRACKINGID VARCHAR (40)
NULL
Tracking identifier.
WEIGHT DOUBLE
NULL
The weight of the package.
WEIGHTMEASURE CHARACTER (16)
NULL
The unit of measure of the package weight.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034953910 MANIFEST_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint 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:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable