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.
|
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 |
|
| |
Shipment Status |
AOM |
AOM-UVL-STATUS |
|
| |
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 |
|
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 |
|
| |
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 |
|
| |
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 |
GBL Number |
AOM |
GBL Number |
GBL Number |
END |
GBL Number |
|
| |
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 |
|
| |
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 |
|
| |
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 |
|
| |
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 |
|
| |
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 |
|
| |
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) |
|
| |
Tariff/Rate |
REGI |
DES-N-REG-CONTRACT-TARIFF |
|
| |
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 |