This view allows you to access data pertaining to a military move.
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:
|
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 |
|
GBL Number |
|
SSN |
|
Rank Grade |
|
Branch Of Service |
|
Code Of Service |
|
Contract Lot Number |
|
Service Order Number |
|
Base Carrier |
|
Base Ordering |
|
Base Ordering State |
|
Base Origin |
|
Base Origin State |
|
Base Destination |
|
Base Destination State |
|
Date Submitted 1840 |
|
Date Scored 1840 |
|
Score 1840 |
|
Original Weights Date |
|
Original Weights Truck Number |
|
Original Weights Gross |
|
Original Weights Tare |
|
Original Weights Net |
|
Original Weights Pro Gear |
|
Re-Weigh Weights Date |
|
Re-Weight Weights Number |
|
Re-Weigh Weights Gross |
|
Re-Weight Weights Tare |
|
Re-Weigh Weights Net |
|
Re-Weigh Weights Pro Gear |
|
DPM Contract Number |
|
DPM Date Shipment Received |
|
DPM Date Base Notified |
|
DPM Date Shipment Released |
|
DPM Date Paperwork Submitted To Base |
|
Company Revenue |
|
Total Commission Paid |
|
Third Party Expenses |
|
Retained Revenue |
RELATED TOPIC: