UniGroup Registration Download Content

 

The following table represents the contents of a Registration download from UniGroup, including a column listing the record ID, e.g. “AOM,” “ADDR,” etc.  Refer to the UniGroup Download Content section for a complete listing of fields by location in MoversSuite for all UniGroup downloads.

 

Information with solid fill

Only the portion of the download that is visible within the MoversSuite application lists within this content section.

 

Field Location in MoversSuite

Record ID

UniGroup Download Field

UniGroup Registration Download Header

 

 

Shipment Status

AOM

AOM-UVL-STATUS

Name, Address, Phone

 

 

Last Name/Company Name

AOM

DES-N-AOM-NAME-LAST-SHPR

First Name/MI

AOM

DES-N-AOM-NAME-FIRST-SHPR

Note:  For International Orders, the number is based on the estimator’s agency, the estimate number, and estimate year (in the format of NNN-NNNNNNNNNNN-N).  For all other orders, the Estimate Number is comprised of the separating the downloaded number into two parts in the format of NNNN-NNNNNNN.

Estimate Number

AOM

DES-N-AOM-YEAR-EST,

DES-N-AOM-NBR-EST

 

 

 

Transportation Coordinator

AOM

See Personnel Setup section (below) for details

Salesperson

AOM

See Personnel Setup section (below) for details

Moving From

 

 

Address

AOM

DES-N-AOM-ADDR-ORG

 

INTL

DES-N-INTL-ADDR-ORG,

DES-N-INTL-ADDR2-ORG

City

AOM

DES-N-AOM-CITY-ORG

 

INTL

DES-N-INTL-CITY-ORG

State

AOM

DES-N-AOM-ST-ORG

 

INTL

DES-N-INTL-ST-ORG

Country

INTL

DES-N-INTL-CTRY-ORG-ISO

Postal Code

AOM

DES-N-AOM-CODE-ZIP-ORG

 

INTL

DES-N-INTL-CODE-ZIP-ORG

Home Phone

AOM

DES-N-AOM-PH-ORG

 

INTL

DES-N-INTL-PHON-ORG

County Code

AOM

DES-N-AOM-CODE-CNTY-ORG

Email

INTL

DES-N-INTL-E-MAIL-ORG

Moving To

 

 

Address

AOM

DES-N-AOM-ADDR-DEST

 

INTL

DES-N-INTL-ADDR-DELV-DEST ,

DES-N-INTL-ADDR2-DELV-DEST

City

AOM

DES-N-AOM-CITY-DEST

 

INTL

DES-N-INTL-CITY-DELV-DEST

State

AOM

DES-N-AOM-ST-DEST

 

INTL

DES-N-INTL-ST-DELV-DEST

Country

INTL

DES-N-INTL-CTRY-DELV-DEST-ISO

Postal Code

AOM

DES-N-AOM-CODE-ZIP-DEST

 

INTL

DES-N-INTL-CODE-ZIP-DELV-DEST

Home Phone

AOM

DES-N-AOM-PH-DEST

 

INTL

DES-N-INTL-PHON-DELV-DEST

County Code

AOM

DES-N-AOM-CODE-CNTY-DEST

Consignor

 

 

 

Consignor

AOM

DES-N-AOM-CONSIGN-ORG

Contact Name

AOM

DES-N-AOM-CONT-ORG

Phone

AOM

DES-N-AOM-PH-CONT-ORG

Consignee

 

 

 

Consignee

AOM

DES-N-AOM-CONSIGN-DEST

Contact Name

AOM

DES-N-AOM-CONT-DEST

Phone

AOM

DES-N-AOM-PH-CONT-DEST

Move Information

 

 

Range

 

 

Pack Dates (first in spread)

INTL

DES-N-INTL-DATE-PACK-EST

 

REGI

DES-N-REG-DATE-PACK-EARLY

Pack Dates (second in spread)

REGI

DES-N-REG-DATE-PACK-LATE

Load Dates (first in spread)

REGI

DES-N-REG-DATE-LOAD-EARLY

Load Dates Time (first in spread)

REGI

DES-N-REG-TIME-LOAD

Load Dates (second in spread)

REGI

DES-N-REG-DATE-LOAD-LATE

Delivery Dates (first in spread)

REGI

DES-N-REG-DATE-DELV-EARLY

Delivery Dates (second in spread)

REGI

DES-N-REG-DATE-DELV-LATE

Preferred

 

 

Load Dates

INTL

DES-N-INTL-DATE-LOAD-REQ

Delivery Dates

INTL

DES-N-INTL-DATE-DELV-REQ-DEST

Actual

 

 

Pack Dates

INTL

DES-N-INTL-DATE-PACK-ACT

Load Dates

AOM

DES-N-AOM-DATE-LOAD-ACT

Load Dates

INTL

DES-N-INTL-DATE-LOAD-ACT

Delivery Dates

AOM

DES-N-AOM-DATE-DELV-ACT

Delivery Dates

INTL

DES-N-INTL-DATE-DELV-ACT-DEST

Other

 

 

Assigned On Date

AOM

AOM_ACTUAL_DATE_ASSIGNED

Assigned On Date (time)

AOM

AOM_ASSIGNED_TIME_CODE

Valuation

 

 

 

Valuation

REGI

regi_valuation_rate_indt

regi_valuation_code

Per pound

REGI

regi_valuation_rate_indt

Amount

REGI

regi_valuation_amount

 

 

 

Booked

AOM

DES-N-AOM-DATE-ORG

Hauled Weight

AOM

DES-N-AOM-WGHT-ACTUAL

 

INTL

DES-N-INTL-WGHT-GROS-TOT

 

PRC

DES-N-PRC-WGHT-ORD-TOT

 

REGI

DES-N-REG-WGHT-REG

Miles

AOM

DES-N-AOM-MILES-ACTUAL

 

REGI

DES-N-REG-MILES-REG

Cubic Feet

AOM

DES-N-AOM-CUBE-ACTUAL

 

REGI

DES-N-REG-CUBE-REG

Discounted Linehaul

END

DES-N-END-AMT-LH-FULL

 

PRC

DES-N-PRC-RATE-TRANS-DISC

Commodity

REGI

DES-N-REG-COMMODITY

Extra Stops

 

 

Note: An unlimited number of extra stops will download into MoversSuite.

Stop Type

EXT

DES-N-EXT-CODE-DELV-PICKUP

Stop Number

EXT

DES-N-EXT-NBR-EXTRA (1)

Contact Information

 

 

Name

EXT

DES-N-EXT-CONT-CO

Company

EXT

DES-N-EXT-NAME-CO

Phone

EXT

DES-N-EXT-PH-CO

Address Information

 

 

Address

EXT

DES-N-EXT-ADDR-CO

City

EXT

DES-N-EXT-CITY-CO

State

EXT

DES-N-EXT-ST-CO

Postal Code

EXT

DES-N-EXT-CODE-ZIP-CO

Military/Government

GBL Number

AOM

GBL Number

GBL Number

END

GBL Number

Shipment Information

 

 

Number of Pieces

EQP

DES-N-EQP-NBR-PIECES

Shipment Requirements

 

 

Size of Van

EQP

DES-N-EQP-SIZE-VAN

Decking Required

EQP

DES-N-EQP-DECKING

Number of Straps

EQP

DES-N-EQP-NBR-STRAPS

Flat Floor

EQP

DES-N-EQP-INDT-FLAT-FLOOR

Number of Pads

EQP

DES-N-EQP-NBR-PADS

Team Required

EQP

DES-N-EQP-INDT-TWO-MAN-TEAM

Product Packaging

 

 

Blanked Wrapped

EQP

DES-N-EQP-INDT-BLANKETS

Cartoned

EQP

DES-N-EQP-INDT-CARTONED

Crated

EQP

DES-N-EQP-INDT-CRATED

Bubble Wrapped

EQP

DES-N-EQP-INDT-BUBBLE-WRAP

Skidded

EQP

DES-N-EQP-INDT-SKIDDED

Product Details

 

 

The following information is referenced through the Add Product Information dialog. The Description field is comprised of field labels for each of the other fields sent down. Refer to the Product Details section within the UniGroup Special Services Upload Contents topic for more information.

Of note, if the Description matches the parsing available for products within the Description set within Add Product Information, then other data is set automatically. Therefore, you can set the Description on the UniGroup side in the exact format as the parsed description, e.g. “M:12345 S:AJS-209209528 D:48x24x36 W:125,” then other product fields, such as the Model Number and Serial Number, update automatically upon a download.

Model Number

EQP

Included in Description

Serial Number

EQP

Included in Description

Length

EQP

DES-N-EQP-LENGTH

Width

EQP

DES-N-EQP-WIDTH

Height

EQP

DES-N-EQP-HEIGHT

Weight

EQP

Included in Description

Description

EQP

DES-N-EQP-DESC-NBR-MDL

Agents

 

 

Booking Agent

 

AOM

DES-N-AOM-AGT-BOKR

INTL

DES-N-INTL-AGT-BOKR

Origin Agent

 

AOM

DES-N-AOM-AGT-ORG,

DES-N-AOM-CODE-SUB-AGT-ORG

INTL

DES-N-INTL-AGT-ORG

Destination Agent

 

AOM

DES-N-AOM-AGT-DEST,

DES-N-AOM-CODE-SUB-AGT-DEST

INTL

DES-N-INTL-AGT-DEST

OA Coordinator

AOM

See Personnel Setup section (below) for details

OA

Surveyor

 

AOM

See Personnel Setup section (below) for details

Other Surveyor

AOM

See Personnel Setup section (below) for details

Survey Date

INTL

DES-N-INTL-DATE-SRVY-ACT

Van Line Registration Date

INTL

DES-N-INTL-DATE-REGD

 

REGI

DES-N-REG-DATE-REG

Van Number

REGI

DES-N-REG-NBR-VAN,

DES-N-REG-NBR-AGT-VAN

SIT/Recurring Billing

 

 

Notes:

A Note is created for each import. The Note Type for the memo is “SIT Information.” The import process automatically creates this Note Type if one does not already exist within Note Type Setup.

SIT data is only updated on subsequent downloads if the particular field was not previously set. For example, if Days is not set on the original download and a second download for the order occurs and Days is set to 7, then the Days field is updated to 7 within MoversSuite.

SIT Type (either “O” for Origin or “D” for Destination)

REGI

regi_stg_in_transit_code

Authorization

REGI

regi_nbr_stor_dest

Days

REGI

regi_sit_nbr_day_auth

SIT In Date (Estimated)

REGI

regi_stg_in_transit_date

SIT Out Date (Estimated)

REGI

regi_sit_date_delv

Stored At (Agent)

REGI

regi_stg_in_transit_agent

Stored At (Agent’s van line affiliation)

REGI

regi_stg_in_subsidiary_code

Billing Information

 

 

Payment Information

 

 

Customer

AOM

DES-N-AOM-NAME-BILL-TO

 

ADDR

DES-N-ADDR-NAME

Bill To Address

ADDR

DES-N-ADDR-STREET1,

DES-N-ADDR-STREET2,

DES-N-ADDR-CITY,

DES-N-ADDR-STATE,

DES-N-ADDR-ZIP-CODE,

DES-N-ADDR-ATTENTION

Note: If the National Account does not exist in MoversSuite then the application will automatically create the account.

National Account

AOM

DES-N-AOM-NBR-ACCT-NATL

 

ADDR

DES-N-ADDR-NBR-ACCT,

DES-N-ADDR-CODE-SUB

Purchase Order Number

AOM

DES-N-AOM-NBR-PO

Tariff/Rate

REGI

DES-N-REG-CONTRACT-TARIFF

Shipping Information

 

 

Transport Mode

INTL

DES-N-INTL-MODE-TRNS

Direction

INTL

DES-N-INTL-CODE-DIR

Origin Port Departure (Estimated)

INTL

DES-N-INTL-DATE-DPRT-ES

Origin Port Departure (Actual)

INTL

DES-N-INTL-DATE-DPRT-ACT

Destination Port Arrival (Estimated)

INTL

DES-N-INTL-DATE-ARRV-EST

Destination Port Arrival (Actual)

INTL

DES-N-INTL-DATE-ARRV-ACT

Cleared Customs (Estimated)

INTL

DES-N-INTL-DATE-CSTM-EST-DEST

Cleared Customs (Actual)

INTL

DES-N-INTL-DATE-CSTM-DEST

Arrival at Destination (Estimated)

INTL

DES-N-INTL-DATE-ARRV-INLD-EST

Arrival at Destination (Actual)

INTL

DES-N-INTL-DATE-ARRV-INLD-ACT

Note and Notes

 

 

Up to 15 individual lines comprise the Memo downloaded from UniGroup.

Memo

SPE

DES-N-SPE-NBR-SEQ (1-15),

DES-N-SPE-INSTRUCTION (1-15)

Order Information (Revenue Entry)

 

 

Tariff/Rate

REGI

DES-N-REG-CONTRACT-TARIFF

Personnel Setup

 

 

Note: For roles listed with Setup Role (below), Employee Interface Mappings can be created through Personnel Setup. The Setup Role needed to so is also listed.

Note: If a person is already set in one of the above fields, then we do not update them on subsequent downloads from Unigroup.

OA Coordinator

      From Agents tab in MoversSuite

      If the Origin Agent on the order is a Sister Agent, then we set the OA Coordinator.

      Setup Role for Interface Mapping: Coor

AOM

<aom_coord_id>

<aom_coord_agency>

OA Surveyor

      From Agents tab in MoversSuite

      If the Origin Agent is a Sister Agent of the order, then we set the OA Surveyor if it is not the same identifier as the Salesperson.

      Setup Role for Interface Mapping: OA Surveyor

AOM

<aom_estimator_id>

<aom_estimator_agency>

Other Surveyor

      From Agents tab in MoversSuite

      If the Origin Agent is not a Sister Agent, then we set the Other Surveyor, provided that the estimator does not match that of the Salesperson.

      Setup Role for Interface Mapping: OA Surveyor

AOM

<aom_estimator_id>

<aom_estimator_agency>

Salesperson

      From Name, Address, Phone tab in MoversSuite

      Salesperson is set if the Booking Agent is a Sister Agent on the order.

      Setup Role for Interface Mapping: Sales

AOM

<aom_salesrep_id>

<aom_salesrep_agency>

Transportation Coordinator

      From Name, Address, Phone tab in MoversSuite

      If the Origin Agent on the order is a Sister Agent, then we set the OA Coordinator.

      Setup Role for Interface Mapping: Coor

AOM

<aom_coord_id>

<aom_coord_agency>

Driver #

REGI

DES-N-REG-NBR-AGT-DRVR