SIRVA QPD Download Content

The table below contains a listing of data downloaded from SIRVA QPD into MoversSuite through the SIRVA QPD Integration.

Refer to SIRVA Field Mappings in MoversSuite for modular listing.

SIRVA QPD Download Field	MoversSuite Field
Id	Order Number
LoadDate	Actual > Load Dates in Billing Information
UnloadDate	Actual > Delivery Dates in Billing Information
CamisRegNumber	(input only)
Brand	Order Number (Van Line Identifier – either “AVL” or “NVL”)
ShipperFirstName	First Name/MI in Name, Address, Phone
ShipperLastName	Last Name/Company Name in Name, Address, Phone
ShipperPhoneNumber	Shipper Contact Information > Phone in Name, Address, Phone (Type of “Origin Home”)
ConsigneeLastName	Consignee > Contact Name in Name, Address, Phone
ConsigneeFirstName	Consignee > Contact Name in Name, Address, Phone
ConsigneePhoneNumber	Consignee > Contact Phone in Name, Address, Phone

NationalAccountNumber	National Account > Name in Billing Information
PaymentTypeName	Payment Type in Billing Information (External Code)
PaymentMethodName	Payment Method in Billing Information (External Code)
CustomerAgreementNumber	Tariff/Rate in Billing Information
CustomerSubAgreementNbr	Section in Billing Information
TMOOriginBase	Bases > Origin in Billing Information (Base Code)
TMODestinationBase	Bases > Destination in Billing Information (Base Code)
AgreedLoadFromDate	Range > Load Dates in Billing Information
AgreedLoadToDate
AgreedLoadTimeFromHour
AgreedLoadTimeFromMinute
AgreedLoadTimeToHour
AgreedLoadTimeToMinute
AgreedDeliveryFromDate	Range > Delivery Dates in Billing Information
AgreedDeliveryToDate
AgreedDeliveryTimeFromHour
AgreedDeliveryTimeFromMinute
AgreedDeliveryTimeToHour
AgreedDeliveryTimeToMinute
AgreedPackFromDate	Range > Pack Dates in Billing Information
AgreedPackToDate	Range > Pack Dates in Billing Information
Weight	Other Information > Hauled Weight in Billing Information (Revenue Entry)
WeightEstimate	Other Information > Estimated Weight in Billing Information (Revenue Entry)
WeightActual	Other Information > Hauled Weight in Billing Information (Revenue Entry)
WeightBilledActual	Other Information > Billed Weight in Billing Information (Revenue Entry)
WeightBilledEstimate	Other Information > Billed Weight in Billing Information (Revenue Entry)
CubesActual	Cubic Feet in Move Information
CubesEstimate	Cubic Feet in Move Information
ChargeEstimate	Other Amounts > Total Amount in Billing Information (Revenue Entry)
DiscountPercent	Other Information > Discount in Billing Information (Revenue Entry)
MilesTotalEstimate	Miles in Move Information
PeakSeasonIndicator	Other Information > Peak Rates Apply in Billing Information (Revenue Entry)
SalesPersonID	Salesperson in Name, Address, Phone (User ID)
EstimatorID	OA Surveyor in Agents (User ID)
SelfhaulIndicator	Authority in Name, Address, Phone
SITLocation	SIT Information in SIT/Recurring Billing (Origin or Destination)
InDate	SIT Information > In Date Estimated in SIT/Recurring Billing
OutDate	SIT Information > Out Date Estimated in SIT/Recurring Billing
NearestCity	Stored internally (SysuserLocation table)
NearestState	Stored internally (SysuserLocation table)
DateTime	Stored internally (SysuserLocation table)
Resources
Resources on the order can range from driver, to booking agent, to tractor/trailer. The Type identifies the resource and there can be multiple resources downloaded at a time.
Id	Entity identifier based on Type
Name	Entity name based on Type
Type	The Type determines which record is added/updated. The following are supported: BOOKER Booking Agent in Agents (Agent ID, Name) ORIGINAGENT Origin Agent in Agents (Agent ID, Name) DESTINATIONAGENT Destination Agent in Agents (Agent ID, Name) HAULER Hauling Agent in Agents (Agent ID, Name) DRIVER Personnel Setup (Driver Number, Name) TRACTOR Equipment Setup (Description, Equipment Number) TRAILER Equipment Setup (Description, Equipment Number) SITAgent SIT Information > Stored At in SIT/Recurring Billing (Agent ID/Name, Vendor ID/Name)
Location
Locations on the order include origin and delivery locations along with extra stops. The location and the data set by it is based on the LocationTypeName and multiple locations can be included in a single download.
LocationTypeName	Type determines which record is added/updated. The following are supported: MAINLOAD PICKUP Moving From in Name, Address, Phone MAINLOAD DELIVERY Moving To in Name, Address, Phone EXTRA STOP PICKUP Stop Type (Pickup) in Extra Stops EXTRA STOP DELIVERY Stop Type (Delivery) in Extra Stops STORAGE IN TRANSIT SIT Information > Stored At in SIT/Recurring Billing (Agent set to Origin Agent or Destination Agent)
LocationSiteTypeName	(input only)
LocationAddress1	The address data is set to one of the following based on the LocationTypeName: Moving From in Name, Address, Phone Moving To in Name, Address, Phone Address Information in Add Extra Stop (Pickup or Delivery)
LocationAddress2
LocationCity
LocationStateProvinceCode
LocationPostalCode
LocationCounty
LocationCountryCode
LocationPrimaryContactName	Contact Information > Name in Add Extra Stop (Pickup or Delivery, not set on Moving From or Moving To address)
LocationPrimaryContactPhone1	The phone set on the order is based on Type and can be one of the following: Shipper Contact Information > Phone in Name, Address, Phone (Type of “Destination Home”) Contact Information > Phone in Add Extra Stop (Pickup or Delivery)
LocationPrimaryContactPhone2	The phone set on the order is based on Type and can be one of the following: Shipper Contact Information > Phone in Name, Address, Phone (Type of “Destination Work”) Other Phone Information > Home Phone in Add Extra Stop (Pickup or Delivery)
LocationPrimaryContactPhone3	The phone set on the order is based on Type and can be one of the following: Shipper Contact Information > Phone in Name, Address, Phone (Type of “Destination Other”) Other Phone Information > Work Phone in Add Extra Stop (Pickup or Delivery)