Pass Thru Connector Content

 

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

Name, Address, Phone

Order Number

OrderNumber

Shipment Status

ShipmentStatus

Last Name/Company Name

LastName

First Name/MI

FirstName

Email

EMail

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)

Move Information

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 Stops

Extra Stop Information

ExtraStop

Agents

Booking Agent

 

 

Agent

Agent.AgentID (BOOK)

Agent.AgentName (BOOK)

Agent.VanLineId (BOOK)

Agent.VanLineName (BOOK)

Primary Contact

Agent.ContactName (BOOK)

Phone

Agent.ContactPhone (BOOK)

Email

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)

Email

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)

Email

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)

Email

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

SIT/Recurring Billing

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)

Billing Information

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

Billing Information (Revenue Entry)

Payment Information

 

Type

PayType

Method

PaymentTypeName

Purchase Order Number

PoNumber

Other Information

 

Billed Weight

BilledWeight

CustomerAgreementNumber (Van Line Code)

Quote

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

Military/Government

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

Notes are created for each included memo segment.

Date

OrderMemoDetails.CreatedDate

Type

OrderMemoDetails.NoteType

Subject

OrderMemoDetails.NoteSubject

Memo

OrderMemoDetails.OrderMemoDetails

NoteScope

OrderMemoDetails.PublicFlag

Shipping Information

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