TransVoyant External Mappings

The following TransVoyant External Mappings are supported.

TM Entity Type	TM Entity Column	TransVoyant Field	Notes:
Shipping Location	SHPG_LOC_CD	IATACODE	The IATA Airport Code of the location. If neither an IATA code nor an ICAO code are mapped, it is assumed that the TM Location Code is set as a valid Airport code and job parameters are used to determine whether the code is IATA or ICAO. Note: If the IATA Airport Code is stored as a field on the TM shipping locations in the system (e.g. Equivalent External Code 1), an entity column mapping may be configured instead of a fixed value mapping for each location.
Shipping Location	SHPG_LOC_CD	ICAOCODE	The ICAO Airport Code of the location. If neither an IATA code nor an ICAO code are mapped, it is assumed that the TM Location Code is set as a valid Airport code and job parameters are used to determine whether the code is IATA or ICAO. Note: If the ICAO Airport Code is stored as a field on the TM shipping locations in the system (e.g. Equivalent External Code 1), an entity column mapping may be configured instead of a fixed value mapping for each location.
Shipping Location	SHPG_LOC_CD	UNLOCODE	The UN/LOCODE of the location. If a UN/LOCODE is not mapped, it is assumed that the TM Location Code is set as a valid UN/LOCODE. Note: If the UN/LOCODE is stored as a field on the TM shipping locations in the system (e.g. Equivalent External Code 1), an entity column mapping may be configured instead of a fixed value mapping for each location.

TM Entity Type

TM Entity Column

TransVoyant Field

Notes:

Shipping Location

SHPG_LOC_CD

IATACODE

The IATA Airport Code of the location. If neither an IATA code nor an ICAO code are mapped, it is assumed that the TM Location Code is set as a valid Airport code and job parameters are used to determine whether the code is IATA or ICAO.

Note: If the IATA Airport Code is stored as a field on the TM shipping locations in the system (e.g. Equivalent External Code 1), an entity column mapping may be configured instead of a fixed value mapping for each location.

Shipping Location

SHPG_LOC_CD

ICAOCODE

The ICAO Airport Code of the location. If neither an IATA code nor an ICAO code are mapped, it is assumed that the TM Location Code is set as a valid Airport code and job parameters are used to determine whether the code is IATA or ICAO.

Note: If the ICAO Airport Code is stored as a field on the TM shipping locations in the system (e.g. Equivalent External Code 1), an entity column mapping may be configured instead of a fixed value mapping for each location.

Shipping Location

SHPG_LOC_CD

UNLOCODE

The UN/LOCODE of the location. If a UN/LOCODE is not mapped, it is assumed that the TM Location Code is set as a valid UN/LOCODE.

Note: If the UN/LOCODE is stored as a field on the TM shipping locations in the system (e.g. Equivalent External Code 1), an entity column mapping may be configured instead of a fixed value mapping for each location.