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 |
|
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 | |
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 | |
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)
|