IntelliTrack WMS – Warehouse Management System User Manual

Page 107

Advertising
background image

Chapter 5

Lookups

81

Continue mapping each WMS vUPSShipInfo column name in the
ODBC Tables portion of the form with the corresponding WorldShip
Destination Field. The field relationships are found in

Table 3, “Import

Mapping Guide: WMS ODBC Table to WorldShip Fields,” on page 81

.

When you are finished, the complete mapping will appear in the What
you have mapped so far
section of the form:

TABLE 3.

Import Mapping Guide: WMS ODBC Table to WorldShip Fields

ODBC Tables

Selection

WorldShip Fields

vUPSShipInfo

Alias Column

Name

WorldShip Field Name

vUPSShipInfo

NA

ShipKey (Primary
Key)

NA

vUPSShipInfo

Package

Reference1

Reference 1

vUPSShipInfo

Package

Reference2 Reference

2

vUPSShipInfo

Package

Reference3

Reference 3

vUPSShipInfo

Shipment Information

ServiceType

Service Type

vUPSShipInfo

Ship To

ToCustomerID

Customer ID

vUPSShipInfo

Ship To

ToCompany

Company or Name

vUPSShipInfo

Ship To

ToStreetAddress

Address 1

vUPSShipInfo

Ship To

ToAddress2

Address 2

Advertising