Notes

Use the Order ID reference to connect to related table data.

Orders with a MSS Order Status (see Order Status Setup) of “Cancelled,” “Voided,” or “Will Advise” do not show in this view.

This view requires the vRetainedRevenue Data View.

Fields included in this view

Order ID

Order Number

Shipper Last Name

Shipper First Name

Transportation (Trans) Coordinator

Sales Person

Logistics (Logis) Coordinator

Origin City

Origin State

Origin Zip

Destination City

Destination State

Destination Zip

Weight

Miles

Transport Mode

Direction

Origin Linehaul Agent

Consolidator

Customs Agent

Destination Linehaul Agent

Origin Port

Booking Number

Seaway Bill

Consign BOL

Estimated Pack Date

Actual Pack Date

Estimated Load Date

Actual Load Date

Estimated Ready To Go Date

Actual Ready To Go Date

Estimated Origin Port Arrival Date

Actual Origin Port Arrival Date

Estimated Origin Port Departure Date

Actual Origin Port Departure Date

Estimated Destination Port Arrival Date

Actual Destination Port Arrival Date

Estimated Cleared Customs Date

Actual Cleared Customs Date

Estimated Pickup Destination Port Date

Actual Pickup Destination Port Date

Estimated Arrival At Destination Date

Actual Arrival At Destination Date

Estimated Delivery Date

Actual Delivery Date

OA Papers Received Date

OA Papers Sent Date

Pre Alert Sent Date

Shipping Detail Sent Date

Waybill Sent Date

Documents Printed Date

Delivery Status Sent Date

Brokerage Collected Date

Company Revenue

Total Commission Paid

Third Party Expenses

Retained Revenue