SIRVA Field Mappings in MoversSuite

 

SIRVA references all the MoversSuite fields listed in the following table for uploads (U) and downloads (D).  Many of the fields are required and many require a mapping to SIRVA-supported codes (see SIRVA STS Integration Setup and Administration for details). 

 

Reference the following topics for specific data included in each upload or download from SIRVA:

SIRVA Registration Upload Content

SIRVA Download Request Content

SIRVA QPD Download Content

 

 

Field

QPD

QLAB

STS

Name, Address, Phone

U

D

U

D

U

D

Order Number

 

 

 

 

 

 

Last Name/Company Name

 

 

 

 

 

 

First Name/MI

 

 

 

 

 

 

Email (included on STS upload if GBL is sent as well or linked to “GEE” Email Type)

 

 

 

 

 

 

Phone number for “Origin Home” Phone Type

 

 

 

 

 

 

Phone number and extension for “Origin Work” Phone Type

 

 

 

 

 

 

Phone number for “Cell” or “Mobile” Phone Type

 

 

 

 

 

 

Salesperson

 

 

 

 

 

 

Transportation Coordinator

 

 

 

 

 

 

Moving From

 

 

 

 

 

 

Location Type

 

 

 

 

 

 

Address (top two lines)

 

 

 

 

 

 

City

 

 

 

 

 

 

State

 

 

 

 

 

 

Country

 

 

 

 

 

 

Postal Code

 

 

 

 

 

 

Home Phone

 

 

 

 

 

 

County

 

 

 

 

 

 

Moving To - Primary

 

 

 

 

 

 

Location Type

 

 

 

 

 

 

Address (top two lines)

 

 

 

 

 

 

City

 

 

 

 

 

 

State

 

 

 

 

 

 

Country

 

 

 

 

 

 

Postal Code

 

 

 

 

 

 

Home Phone

 

 

 

 

 

 

County

 

 

 

 

 

 

Consignee

 

 

 

 

 

 

 

Contact Name

 

 

 

 

 

 

Contact Phone

 

 

 

 

 

 

Move Information

 

 

 

 

 

 

Range

 

 

 

 

 

 

Pack Dates (dates)

 

 

 

 

 

 

Load Dates (dates, times)

 

 

 

 

 

 

Delivery Dates (dates, times)

 

 

 

 

 

 

Preferred

 

 

 

 

 

 

Load Date (QLAB Lead Download only, QPD: dates, times)

 

 

 

 

 

 

Delivery Date (QLAB Lead Download only, QPD: dates, times)

 

 

 

 

 

 

Actual

 

 

 

 

 

 

Load Date

 

 

 

 

 

 

Delivery Date

 

 

 

 

 

 

Valuation

 

 

 

 

 

 

 

Valuation

 

 

 

 

 

 

Per Pound (included if the valuation Amount is not set)

 

 

 

 

 

 

Amount (if this is set, then the Per Pound is not included)

 

 

 

 

 

 

Automobile

 

 

 

 

 

 

Auto With Shipment

 

 

 

 

 

 

Make

 

 

 

 

 

 

Model

 

 

 

 

 

 

Year

 

 

 

 

 

 

Weight

 

 

 

 

 

 

Length

 

 

 

 

 

 

Width

 

 

 

 

 

 

Height

 

 

 

 

 

 

Self Haul

 

 

 

 

 

 

Request Self Haul

 

 

 

 

 

 

 

 

 

 

 

 

 

Estimated Weight

 

 

 

 

 

 

Hauled Weight

 

 

 

 

 

 

Miles

 

 

 

 

 

 

Cubic Feet

 

 

 

 

 

 

Discounted Linehaul

 

 

 

 

 

 

Type of Move

 

 

 

 

 

 

Commodity

 

 

 

 

 

 

Authority

 

 

 

 

 

 

Service Type

 

 

 

 

 

 

Shipment Type

 

 

 

 

 

 

Packing Type

 

 

 

 

 

 

Preferred Van Request (optional)

 

 

 

 

 

 

Shipping Information

 

 

 

 

 

 

Product Code (Special Services orders only)

 

 

 

 

 

 

Product Type(Special Services orders only)

 

 

 

 

 

 

Extra Stops

 

 

 

 

 

 

The stops added through the Extra Stops option are listed on the report based on their assigned Stop Number with Pickup items followed by Delivery items. Here’s how the Extra Stops sections would display:


Pickup 1
Pickup 2
Pickup 3
Delivery 1
Delivery 2
Delivery 3

 

However, the display order can be customized through the Extra Stops option.

 

 

 

 

 

 

Add Extra Stop

 

 

 

 

 

 

Note:  Extra Stop Information for each Pickup and Delivery is included, along with the Origin and Destination agents from Agents

 

 

 

 

 

 

Contact Information

 

 

 

 

 

 

Name

 

 

 

 

 

 

Phone

 

 

 

 

 

 

County

 

 

 

 

 

 

Address Information

 

 

 

 

 

 

Location Type

 

 

 

 

 

 

Pickup

 

 

 

 

 

 

Delivery

 

 

 

 

 

 

Stop Number

 

 

 

 

 

 

Address Line (top 2 lines)

 

 

 

 

 

 

City

 

 

 

 

 

 

Country (name and code)

 

 

 

 

 

 

State

 

 

 

 

 

 

Postal Code

 

 

 

 

 

 

Other Phone Information

 

 

 

 

 

 

Home Phone

 

 

 

 

 

 

Work Phone

 

 

 

 

 

 

Add Segment

 

 

 

 

 

 

Notes:

At least one segment must be created for download and upload

Specific pairings are required when creating segments within Extra Stops.  For example, a Location Type of “MP” for one Extra Stops record must map to a “MD” stop. 

 

 

 

 

 

 

Number

 

 

 

 

 

 

Estimated Weight

 

 

 

 

 

 

Billed Weight

 

 

 

 

 

 

Estimated Cubic Feet

 

 

 

 

 

 

Billed Cubic Feet

 

 

 

 

 

 

Miles

 

 

 

 

 

 

Load Date Range

 

 

 

 

 

 

Load Time Range

 

 

 

 

 

 

Delivery Date Range

 

 

 

 

 

 

Deliver Time Range

 

 

 

 

 

 

Pack Date Range

 

 

 

 

 

 

Agents

 

 

 

 

 

 

Booking Agent

 

 

 

 

 

 

 

Destination Agent

 

 

 

 

 

 

 

Hauling Agent (self haul only or QPD)

 

 

 

 

 

 

Origin Agent

 

 

 

 

 

 

 

OA

Surveyor

 

 

 

 

 

 

 

Survey Date

 

 

 

 

 

 

Start Time

 

 

 

 

 

 

End Time

 

 

 

 

 

 

Van Line Registration Date

 

 

 

 

 

 

SIT/Recurring Billing

 

 

 

 

 

 

SIT Information > Origin > Stored At (Agent)

 

 

 

 

 

 

SIT Information > Origin/Destination > Stored At (Agent)

 

 

 

 

 

 

SIT Information > Origin/Destination > In Date Estimated

 

 

 

 

 

 

SIT Information > Origin/Destination > Out Date Estimated

 

 

 

 

 

 

Billing Information

 

 

 

 

 

 

Payment Type

 

 

 

 

 

 

Payment Method

 

 

 

 

 

 

Purchase Order Number (unless military order in which case the GBL Number or SSN is used)

 

 

 

 

 

 

National Account > Account Number

 

 

 

 

 

 

National Account > Billing Location Number (Loc Num)

 

 

 

 

 

 

National Account > Memo (see SIRVA Customer Order Memo)

 

 

 

 

 

 

Tariff/Rate

 

 

 

 

 

 

Section (must be a 3-digit number)

 

 

 

 

 

 

Discount

 

 

 

 

 

 

Estimate Amount (optional – can cause an error if specified when not requested for a particular agreement)

 

 

 

 

 

 

Peak Rates Apply

 

 

 

 

 

 

Invoice Requirement

 

 

 

 

 

 

Billing Information (Revenue Entry)

 

 

 

 

 

 

Estimated Weight

 

 

 

 

 

 

Hauled Weight

 

 

 

 

 

 

Billed Weight

 

 

 

 

 

 

Peak Rates Apply

 

 

 

 

 

 

Guarantee Price Information

 

 

 

 

 

 

Maximum Containers/Packing Charge

 

 

 

 

 

 

Credit Per CWT

 

 

 

 

 

 

Description (for each Container and Packing type)

 

 

 

 

 

 

Rate (for each Container and Packing type)

 

 

 

 

 

 

Military/Government

 

 

 

 

 

 

GBL Number

 

 

 

 

 

 

SSN

 

 

 

 

 

 

Bases

 

 

 

 

 

 

Carrier

 

 

 

 

 

 

 

Origin

 

 

 

 

 

 

Destination

 

 

 

 

 

 

Notes

 

 

 

 

 

 

Note:  Multiple notes included in download

 

 

 

 

 

 

Date

 

 

 

 

 

 

Subject