The following table lists the MoversSuite fields affected by the Pass Thru Connector. This data is arranged by functional area. Refer to Pass Thru Connector Upload Format to view this data in the anticipated format for an upload (JSON/XML).
|
Field |
Pass Thru JSON/XML Specifier |
|
Order Number |
OrderNumber |
|
Shipment Status |
ShipmentStatus |
|
Last Name/Company Name |
LastName |
|
First Name/MI |
FirstName |
|
|
|
|
Phone Numbers |
Phone (ORIGHOME, ORIGWORK, ORIGOTHR, DESTHOME, DESTWORK, DESTOTHR, MOV2HOME, MOV2WORK) |
|
Estimate Number |
EstimateNo |
|
Salesperson |
SalespersonId |
|
Lead Source |
LeadSource |
|
Moving From |
|
|
Address (line 1) |
Address1 (ORIG) |
|
City |
City (ORIG) |
|
State |
State (ORIG) |
|
Country |
Country (ORIG) |
|
Postal Code |
Postal (ORIG) |
|
County |
County (ORIG) |
|
Moving To - Primary |
|
|
Address (line 1) |
Address1 (DEST) |
|
City |
City (DEST) |
|
State |
State (DEST) |
|
Country |
Country (DEST) |
|
Postal Code |
Postal (DEST) |
|
County |
County (DEST) |
|
Moving To - Secondary |
|
|
Address (line 1) |
Address1 (MOV2) |
|
City |
City (MOV2) |
|
State |
State (MOV2) |
|
Country |
Country (MOV2) |
|
Postal Code |
Postal (MOV2) |
|
County |
County (MOV2) |
|
Consignor |
|
|
Consignor |
Consign (ORIG) |
|
Consignee |
|
|
Consignee |
Consign (DEST) |
|
Range |
|
|
Pack Dates |
PackEarly |
|
PackLate | |
|
Load Dates |
LoadEarly |
|
LoadLate | |
|
Load Time |
LoadEarlyTime |
|
LoadLateTime | |
|
Delivery Dates |
DelvEarly |
|
DelvLate | |
|
Delivery Time |
DelvEarlyTime |
|
DelvLateTime | |
|
Preferred |
|
|
Pack Dates |
PackPref |
|
Load Dates |
LoadPref |
|
Delivery Dates |
DelvPref |
|
Actual |
|
|
Pack Dates |
PackActual |
|
Load Dates |
LoadActual |
|
Delivery Dates |
DelvActual |
|
Other |
|
|
Estimated Time of Arrival |
ETA |
|
Assigned On Date |
AssignedOn |
|
Automobile |
|
|
Auto With Shipment |
Automobile.WithShipment |
|
Class |
Automobile.Class |
|
Make |
Automobile.Make |
|
Color |
Automobile.Color |
|
Model |
Automobile.Model |
|
Year |
Automobile.Year |
|
Mileage |
Automobile.Mileage |
|
VIN |
Automobile.Vin |
|
Weight |
Automobile.Weight |
|
Cubic Feet |
Automobile.CubicFt |
|
Self Haul |
|
|
Self Haul (Yes/No) |
SelfhaulIndicator |
|
|
|
|
Estimated Weight |
EstimatedWeight |
|
Hauled Weight |
Weight |
|
Mile |
Miles |
|
Cubic Feet |
CubicFeet |
|
Commodity |
Commodity |
|
Shipment Type |
ShipmentType |
|
Extra Stop Information |
ExtraStop |
|
Booking Agent |
|
|
Agent |
Agent.AgentID (BOOK) |
|
Agent.AgentName (BOOK) | |
|
Agent.VanLineId (BOOK) | |
|
Agent.VanLineName (BOOK) | |
|
Primary Contact |
Agent.ContactName (BOOK) |
|
Phone |
Agent.ContactPhone (BOOK) |
|
|
Agent.ContactEmail (BOOK) |
|
Origin Agent |
|
|
Agent |
Agent.AgentID (ORIG) |
|
Agent.AgentName (ORIG) | |
|
Agent.VanLineId (ORIG) | |
|
Agent.VanLineName (ORIG) | |
|
Primary Contact |
Agent.ContactName (ORIG) |
|
Phone |
Agent.ContactPhone (ORIG) |
|
|
Agent.ContactEmail (ORIG) |
|
Hauling Agent |
|
|
Agent |
Agent.AgentID (HAUL) |
|
Agent.AgentName (HAUL) | |
|
Agent.VanLineId (HAUL) | |
|
Agent.VanLineName (HAUL) | |
|
Primary Contact |
Agent.ContactName (HAUL) |
|
Phone |
Agent.ContactPhone (HAUL) |
|
|
Agent.ContactEmail (HAUL) |
|
Destination Agent |
|
|
Agent |
Agent.AgentID (DEST) |
|
Agent.AgentName (DEST) | |
|
Agent.VanLineId (DEST) | |
|
Agent.VanLineName (DEST) | |
|
Primary Contact |
Agent.ContactName (DEST) |
|
Phone |
Agent.ContactPhone (DEST) |
|
|
Agent.ContactEmail (DEST) |
|
|
|
|
OA Surveyor
|
OaSurveyorId |
|
Agent (SURV) | |
|
Survey Date |
SurveyDate |
|
Survey Start Time |
SurveyStartTime |
|
Survey End Time |
SurveyEndTime |
|
Van Number |
DriverInfo.Van |
|
By |
DriverInfo.Id |
|
DriverInfo.UserId | |
|
DriverInfo.Agent | |
|
DriverInfo.AgentCode | |
|
DriverInfo.FirstName | |
|
DriverInfo.LastName | |
|
DriverInfo.Phone | |
|
DriverInfo.Email | |
|
Origin |
|
|
Authorization |
SitInformation.Authorization (ORIG) |
|
Days |
SitInformation.Days (ORIG) |
|
SIT Expiration |
SitInformation.SitExpiration (ORIG) |
|
In Date Estimated |
SitInformation.DateIntoSitEstimated (ORIG) |
|
In Date Actual |
SitInformation.DateIntoSitActual (ORIG) |
|
Out Date Estimated |
SitInformation.DateOutSitEstimated (ORIG) |
|
Out Date Actual |
SitInformation.DateOutSitActual (ORIG) |
|
Agent |
SitInformation.VanLineID (ORIG) |
|
SIT Weight |
SitInformation.Weight (ORIG) |
|
Destination |
|
|
Authorization |
SitInformation.Authorization (DEST) |
|
Days |
SitInformation.Days (DEST) |
|
SIT Expiration |
SitInformation.SitExpiration (DEST) |
|
In Date Estimated |
SitInformation.DateIntoSitEstimated (DEST) |
|
In Date Actual |
SitInformation.DateIntoSitActual (DEST) |
|
Out Date Estimated |
SitInformation.DateOutSitEstimated (DEST) |
|
Out Date Actual |
SitInformation.DateOutSitActual (DEST) |
|
Agent |
SitInformation.VanLineID (DEST) |
|
SIT Weight |
SitInformation.Weight (DEST) |
|
Payment Information |
|
|
Payment Type |
PayType |
|
Payment Method |
PaymentTypeName |
|
Purchase Order Number |
PoNumber |
|
Rating Information |
|
|
Tariff/Rate |
Tariff |
|
CustomerAgreementNumber (Van Line Code) | |
|
Section |
CustomerSubAgreementNbr |
|
Discount |
DiscountPercentage |
|
Peak Rate Applies |
PeakSeasonIndicator |
|
Estimate Amount |
ChargeEstimate |
|
Payment Information |
|
|
Type |
PayType |
|
Method |
PaymentTypeName |
|
Purchase Order Number |
PoNumber |
|
Other Information |
|
|
Billed Weight |
BilledWeight |
|
CustomerAgreementNumber (Van Line Code) | |
|
Status |
SalesQuote.QuoteStatus |
|
Group |
SalesQuoteGroup |
|
Details |
|
|
Description (Item Code) |
SalesQuoteDetail.IsTransportationCharge |
|
SalesQuoteDetail.ItemCode | |
|
SalesQuoteDetail.Description | |
|
SalesQuoteDetail.ItemCodeMapping | |
|
Rate Type |
SalesQuoteDetail.RateType |
|
Quantity 2 |
SalesQuoteDetail.Quantity |
|
Quantity 1 |
SalesQuoteDetail.Quantity2 |
|
Rate |
SalesQuoteDetail.Rate |
|
Charge |
SalesQuoteDetail.Charge |
|
Note |
SalesQuoteDetail.NoteText |
|
Bill To |
SalesQuoteDetail.ServiceProviderBillToType |
|
Service Provider |
SalesQuoteDetail.ServiceProviderType |
|
SalesQuoteDetail.ServiceProviderName | |
|
SalesQuoteDetail.ServiceProviderCode | |
|
Quoted Charge |
SalesQuoteDetail.VendorQuotedCharge |
|
Actual Charge |
SalesQuoteDetail.VendorActualCharge |
|
PO Number |
SalesQuoteDetail.PoNumber |
|
Invoice Number |
SalesQuoteDetail.InvoiceNumber |
|
Service Date |
SalesQuoteDetail.ServiceDate |
|
General Information |
|
|
GBL Number |
Military.GblNumber |
|
SSN |
Military.SsnNumber |
|
Rank/Grade |
Military.RankGrade |
|
Branch of Service |
Military.BranchOfService |
|
Code of Service |
Military.CodeOfService |
|
Service Order Number |
Military.ServiceOrderNumber |
|
Channel |
Military.Channel |
|
Bases |
|
|
Carrier |
Military.ScacNumber |
|
Origin |
Military.OriginBaseCode |
|
Military.OriginBaseName | |
|
Origin State |
Military.DestinationBaseState |
|
Destination |
Military.DestinationBaseCode |
|
Military.DestinationBaseName | |
|
Destination State |
Military.DestinationBaseState |
|
Score Information |
|
|
CSS Completion Date |
MilitaryScoring.SurveyCompleted |
|
TSP Score |
MilitaryScoring.TspScore |
|
Q4. Quality Of Packing |
MilitaryScoring.PackQuality |
|
Q5. Courtesy of Load Crew |
MilitaryScoring.LoadCourtesy |
|
Q6. Timeliness of Delivery |
MilitaryScoring.PickupTimeliness |
|
Q7. Courtesy of Destination Crew |
MilitaryScoring.DestCourtesy |
|
Q8. Timeliness of Delivery |
MilitaryScoring.DelvryTimeliness |
|
Q9. Overall Satisfaction |
MilitaryScoring.OveralSatisfaction |
|
Notes are created for each included memo segment. | |
|
Date |
OrderMemoDetails.CreatedDate |
|
Type |
OrderMemoDetails.NoteType |
|
Subject |
OrderMemoDetails.NoteSubject |
|
Memo |
OrderMemoDetails.OrderMemoDetails |
|
NoteScope |
OrderMemoDetails.PublicFlag |
|
Vessel/Voyage or Flight Information |
|
|
Vessel/Voyage |
InternationalVoyage.Info |
|
Flight Number | |
|
Origin Port |
InternationalVoyage.OriginPortName |
|
InternationalVoyage.OriginPortCode | |
|
ETD |
InternationalVoyage.EstDeparture |
|
Departure |
InternationalVoyage.ActDeparture |
|
ETA |
InternationalVoyage.EstArrival |
|
Arrival |
InternationalVoyage.ActArrival |
|
Destination Port |
PortName |
|
InternationalVoyage.PortCode | |