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

Order Branch

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

Job Number (No)

Store Number (No)

Store Name

Store Contact Name

Store City

Store State

Store Zip

All Actions Complete

Labels Printed

Confirmation Contact

Transportation Fee

Truck Number

PO Number

Logistics Order Number (No)

Drop Sequence

Invoice Date

Install Date

POD Date

Company Revenue

Total Commission Paid

Third Party Expenses

Retained Revenue