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:

NameTypeDescription
MANIFEST_IDBIGINT NOT NULLGenerated unique key.
ORDRELEASENUMINTEGER NOT NULLUniquely identifies the release for this order.
WEIGHTMEASURECHAR (16)The unit of measure of the package weight.
SETCCURRCHAR (3)Currency in which the shipment was charged.
SHIPMODE_IDINTEGERShipping provider.
WEIGHTDOUBLEThe weight of the package.
MANIFESTSTATUSCHAR (1) NOT NULL DEFAULT 'S'S=Shipped V=Void. Initial status = S
SHIPPINGCOSTSDECIMAL (20,5) NOT NULLShipping costs.
DATESHIPPEDTIMESTAMP NOT NULLThe date the package shipped.
FIELD1VARCHAR (254)Customizable.
LASTUPDATETIMESTAMPTimestamp of last update.
PACKAGEIDCHAR (20)Package identifier.
TRACKINGIDVARCHAR (40)Tracking identifier.
PICKUPRECORDIDCHAR (20)Pickup record identifier.
ORDERS_IDBIGINT NOT NULLORDERS_ID from ORDERS table for which the manifest is performed.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>MANIFEST_IDPrimary Key
I0000364ORDERS_ID+ORDRELEASENUM+MANIFESTSTATUSNon-Unique Index
I0000609SHIPMODE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_425WEIGHTMEASUREQTYUNITQTYUNIT_IDCascade
F_426SETCCURRSETCURRSETCCURRCascade
F_427SHIPMODE_IDSHIPMODESHIPMODE_IDCascade
F_428ORDERS_ID+ORDRELEASENUMORDRELEASEORDERS_ID+ORDRELEASENUMCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3475MANIFEST_IDORDITEMCONFMANIFEST_IDCascade