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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034953910 | MANIFEST_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|