Shipping Exceptions report
Use this report to determine which releases are missing manifest information.
Options: fulfillment centers
Sorted by: release date, order number, release number
Grouped by: not applicable
Report Column Name | Table Name | Column Name |
---|---|---|
Release Date | ORDERITEMS | TIMERELEASED |
Release Time | ORDERITEMS | TIMERELEASED |
Number of Days Since Release | current date - ORDERITEMS.TIMERELEASED | |
Order Number | ORDERS | ORDERS_ID |
Release Number | ORDRELEASE | ORDRELEASENUM |
Shipping Carrier | SHIPMODE | CARRIER |
Shipping Provider | SHPMODEDSC | DESCRIPTION |
Fulfillment Center | FFMCENTDS | DISPLAYNAME |
Note: The number of days since release is calculated only
by the date, and does not consider time. Therefore, if an order is
released at two minutes before midnight, at midnight, 1 day is considered
to have passed since the order was released.
The date and time are based on the current system time for the machine where WebSphere Commerce Server is installed.