Below is a list of the contents included in the Equus Integration Order Download and the Equus Integration Order Upload.
UPLOAD NOTE: The Equus AssignmentPro field titled SHIPMENT_TYPE specified for the upload is based on whether the order is an International Orders or not. In the case of International Orders, the type specified is based on the Transportation Mode set within the Shipping Information tab, which identifies the order as either an “Air Shipment” or a “Sea Shipment.” For all other orders, the SHIPMENT_TYPE is considered a “Ground Shipment.”
|
MoversSuite Field |
Equus AssignmentPro Field |
|
Order Number |
REFERENCE_NUMBER |
|
Branch |
Maps to a Vendor ID provide by Equus and linked to a Branch defined within XML Interface Setup. |
|
Moving From |
|
|
Address |
DEPARTURE_ADDRESS_LINE_1 |
|
DEPARTURE_ADDRESS_LINE_2 | |
|
DEPARTURE_ADDRESS_LINE_3 | |
|
City |
DEPARTURE_CITY |
|
State |
DEPARTURE_STATE_PROVINCE_CODE |
|
Country |
DEPARTURE_COUNTRY_CODE |
|
County |
|
|
Postal Code |
DEPARTURE_POSTAL_CODE |
|
Moving To - Primary |
|
|
Address |
DESTINATION_ADDRESS_LINE_1 |
|
DESTINATION_ADDRESS_LINE_2 | |
|
DESTINATION_ADDRESS_LINE_3 | |
|
City |
DESTINATION_CITY |
|
State |
DESTINATION_STATE_PROVINCE_CODE |
|
Postal Code |
DESTINATION_COUNTRY_CODE |
|
Country |
DESTINATION_POSTAL_CODE |
|
IMPORTANT: Dates must be in the following chronological order: Survey, Pack, Load, and then Delivery. If the dates assigned to these are not in the correct order, then Atlas will reject the upload, i.e. Delivery date precedes Survey date. First date of any spread must be earlier than the second date of the spread. MoversSuite does this check for you. | |
|
Range |
|
|
Pack Dates (first in spread) |
SCHEDULED_PACK_START_DATE |
|
Pack Dates (second in spread) |
SCHEDULED_PACK_END_DATE |
|
Load Dates (first in spread) |
SCHEDULED_LOAD_DATE |
|
Load Dates (second in spread) |
SCHEDULED_LOAD_END_DATE |
|
Delivery Dates (first in spread) |
SCHEDULED_DELIVERY_DATE |
|
Delivery Dates (second in spread) |
SCHEDULED_DELIVERY_END_DATE |
|
Preferred |
|
|
Pack Dates (first in spread) |
REQUESTED_PACK_DATE |
|
Load Dates (first in spread) |
REQUESTED_LOAD_DATE |
|
Delivery Dates (first in spread) |
REQUESTED_DELIVERY_DATE |
|
Actual |
|
|
Pack Dates (first in spread) |
ACTUAL_PACK_START_DATE |
|
Pack Dates (second in spread) |
ACTUAL_PACK_END_DATE |
|
Load Dates (first in spread) |
ACTUAL_LOAD_DATE |
|
Load Dates (second in spread) |
ACTUAL_LOAD_END_DATE |
|
Delivery Dates (first in spread) |
ACTUAL_DELIVERY_DATE |
|
Delivery Dates (second in spread) |
ACTUAL_DELIVERY_END_DATE |
|
Estimated Weight |
WEIGHT_ESTIMATE (in “Pounds”) |
|
Miles |
DISTANCE_ESTIMATE (in “Miles”) |
|
Storage Requirement |
ESTIMATED_STORAGE Maps to a type defined within Storage Requirement Setup for Equus. |
|
Survey Date |
REQUESTED_SURVEY_DATE |
|
SCHEDULED_SURVEY_DATE | |
|
ACTUAL_SURVEY_DATE | |
|
NOTE: Multiple records may exist for the Origin and Destination types based on the STORAGE_LOCATION (which is either Origin or Destination). | |
|
In Date Estimated |
BEGIN_DATE |
|
In Date Actual |
END_DATE |
|
Out Date Estimated |
BEGIN_DATE |
|
Out Date Actual |
END_DATE |
|
Other Information (Revenue Entry) |
|
|
Estimated Weight |
WEIGHT_ESTIMATE (in “Pounds”) |
|
Billed Weight |
ACTUAL_WEIGHT (in “Pounds”) |
|
Miles |
DISTANCE_ESTIMATE (in “Miles”) |
|
Multiple records per download can appear based on types defined within Note Type Setup for Equus. Current options include the following Subject lines: Equus Special Instructions Equus Order Updated
| |
|
Memo |
SPECIAL_INSTRUCTIONS |