Tips & Techniques: Understand the terms in the table

Situation

This specific issue is identified when in one of the discussions in MOSC, the poster of the discussion was asking what is the meaning of shipping terms used in OM populated from the table WSH_NEW_DELIVERIES. The member wanted to know what each of these fields mean.

INITIAL_PICKUP_DATE

INITIAL_PICKUP_LOCATION

ULTIMATE_DROPOFF_LOCATION

ULTIMATE_DROPOFF_DATE

EARLIEST_PICKUP_DATE

LATEST_PICKUP_DATE

EARLIEST_PICKUP_DATE

EARLIEST_DROPOFF_DATE

The answer was given as below but it is more important on how do we get such needed information in any other cases.

Field	Information
INITIAL_PICKUP_DATE