This view allows you to access data for an International Orders record.
The following table lists the data available through this view and in the order in which they display. Please refer to the following for field descriptions:
Container/Lift Van/Airbox Information
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 Agent |
Origin Linehaul Agent |
Carrier |
Consolidator |
Customs Agent |
Destination Linehaul Agent |
Destination 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 |
RELATED TOPICS:
Container/Lift Van/Airbox Information