UniGroup International Data Mapping Setup

This section lists additional setup areas and mapping data that may be required for exchanging data with the UniGroup International system after the UniGroup International Initial Setup.

The following is list of the setup areas that affect UniGroup International, followed by detailed information for each setup:

Auto Class Setup

Auto Make Setup

Carrier Setup (International Orders)

Consolidator Setup

Container Load Type Setup

Container Size Setup

Customs Agent Setup

Customs Inspection Location Setup

Customs Inspection Type Setup

Direction Setup

Lift Van Status Setup

Linehaul Carrier Setup

Note Type Setup

Payment Type Setup

Port Setup

Service Type Setup

Shipment Type Setup

Shipper Phone Type Setup

Transportation Mode Setup

Valuation Declined Reason Setup

Value Type Setup

XML Item Code Setup (possibly Item Code Setup and Service Code Setup as well)

NOTE: Most of the presets for UniGroup International in the following sections are automatically added to your system through the upgrade process. Additional insert scripts are also available to those of you processing UniGroup orders through the International Orders module prior to the implementation of the UniGroup International functionality. These scripts allow you to load in the latest supported codes.

Auto Class Setup

Define Auto Class Setup records for the UniGroup International interface for the following codes to support UniGroup International processes.

Auto Make Setup

Verify Auto Class Setup records for the UniGroup International interface to support UniGroup International processes.

Each make must link to UniGroup International with appropriate External Code. In the example below (Figure 16), the External Code of Cadillac is the supported UniGroup code, which also links to the like-named Auto Make record in MoversSuite.

Figure 17: Auto Make Setup example

Carrier and Consolidator Setup

EWS Group provides a script to insert all carrier and consolidators supported by UniGroup International. External codes are assigned automatically to the UniGroup International interface in the format of a two-character type code followed by a three-character port code, such as AC001 for American Airlines, where AC is the type for air carrier and the 001 is the UniGroup identifier for the company. If you have pre-existing records within either setup, then EWS Group recommends reviewing your entries before running the script.

Verify and manage records through Carrier Setup (International Orders) and Consolidator Setup.

The script is titled InternationalAirOceanCarriersConsolidators.sql and is available through the upgrade process.

Container Load Type Setup

Define Container Load Type Setup records for the UniGroup International interface for the following codes to support UniGroup International processes.

Container Size Setup

Define Container Size Setup records for the UniGroup International interface for the following codes to support UniGroup International processes.

Customs Agent Setup

Verify Customs Agent Setup records for the UniGroup International interface to support UniGroup International processes.

Customs Inspection Location Setup

Define Customs Inspection Location Setup records for the UniGroup International interface for the following codes to support UniGroup International processes.

Customs Inspection Type Setup

Define Customs Inspection Type Setup records for the UniGroup International interface for the following codes to support UniGroup International processes.

Direction Setup

Define Direction Setup records for the UniGroup International interface for the following codes to support UniGroup International processes.

Lift Van Status Setup

Lift van data is not included in the data exchange with the UniGroup International system. However, you can define codes needed to document the status of lift vans.

Linehaul Carrier

Verify Lift Van Status Setup records for the UniGroup International interface to support UniGroup International processes.

EWS Group provides a script to populate this setup with the carriers support by the UniGroup International system.

Note Type Setup

Verify that UniGroup Note Codes supported are defined correctly.

Port Setup

Verify that all supported ports are established on your system. UniGroup International utilizes three-character airline industry codes for all airports. For seaports, the five-character UNLOC code is supported. UNLOC codes include a two-character country code followed by a three-character port code, such as USLAX for the Los Angeles seaport.

EWS Group provides a script titled Post-UniGroupInternationalPorts.sql that is available through the upgrade process that inserts all UniGroup International supported codes with appropriate Port Code and External Codes within Port Setup into your system.  If the script encounters an existing port code for the correct type, either Air or Sea, then a new port code record is not imported. If you have existing Port Code records, then EWS Group recommends that you review your entries (you can compare them to what displays in the script) to verify pre-existing data before running the script.

Service Type Setup

Define Service Type Setup records for the UniGroup International interface for the following codes to support UniGroup International processes.

Shipment Type Setup

Define Shipment Type Setup records for the UniGroup International interface for the following codes to support UniGroup International processes.

Note: If you already integrate with the UniGroup system and have the following External Codes defined for a separate UniGroup interface, then you do not need to enter them a second time for the UniGroup International interface.

Shipper Email Type Setup

Define Shipper Email Type Setup records for the UniGroup International interface for the following codes to support UniGroup International processes.

Note: To support multiple email shipper email addresses, users need to add the “DEFAULT_EMAIL” external code at least.

Shipper Phone Type Setup

Define Shipper Phone Type Setup records for the UniGroup International interface for the following codes to support UniGroup International processes.

Transportation Mode Setup

Define Transportation Mode Setup records for the UniGroup International interface for the following codes to support UniGroup International processes.

Valuation Declined Reason Setup

Define Valuation Declined Reason Setup records for the UniGroup International interface for the following codes to support UniGroup International processes.

Value Type Setup

Define Value Type Setup records for the UniGroup International interface for the following codes to support UniGroup International processes.

XML Item Code Setup

Additional charge and transportation codes supported on by the UniGroup International system (listed in a table below) must be established as XML Item Code Setup records for the UniGroup International interface and the Item Code must link to a Service Code Setup record with a Service Code matching those anticipated by the UniGroup International system. These codes are needed for quotes and revenue associated to the international order.

In the following examples, the BOOKING COMMISSION record links to Service Code of 005, which is the anticipated code for the booking commission, through the Item Code.

Figure 18: XML Item Code Setup

The corresponding Item Code Setup record references Service Code 005, which is established within the Service Code Setup.

Figure 19: Item Code Setup

Figure 20: Service Code Setup

Utilize the following setup areas to create additional charge and transportation codes supported by UniGroup International:

Service Code Setup

Item Code Setup

XML Item Code Setup

Establish XML Item Code Setup records for the following codes supported by UniGroup:

NOTE:

For the Transportation Codes, the Include imported items as Transportation revenue flag must be checked.

For Additional Charges Codes, the Include imported items as Transportation revenue flag must be unchecked. These items are utilized when generating a Quote for the order.