1. Tables and Views for SCM
  2. WSH_TRANSIT_TIMES

WSH_TRANSIT_TIMES

This table contains the representation of shipping transit times between an origin and a destination. Each end point of the transit time route may be an internal location, zone, geography, or external location defined in Fusion Applications.

Details

  • Schema: FUSION

  • Object owner: RCS

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

WSH_TRANSIT_TIMES_PK

TRANSIT_TIME_ID

Columns

Name Datatype Length Precision Not-null Comments
TRANSIT_TIME_ID NUMBER 18 Yes Indicates the Unique identifier for shipping transit times between an origin and a destination.
ORIGIN_EXT_LOC_SOURCE VARCHAR2 2 When Supplier Address is selected, the external location source value is "SA". The field is null by default, and all existing records will be upgrade to be null.
DEST_EXT_LOC_SOURCE VARCHAR2 2 When Supplier Address is selected, the external location source value is "SA". The field is null by default, and all existing records will be upgrade to be null.
ORIGIN_EXT_LOC_SOURCE_ID NUMBER Foreign key for any external location not sourced directly from the TCA. For Supplier Address, propose storing the Supplier Address FK from Procurement. This provides access to the Supplier, Supplier Address and Name, and the Party Site.
DEST_EXT_LOC_SOURCE_ID NUMBER Foreign key for any external location not sourced directly from the TCA. For Supplier Address, propose storing the Supplier Address FK from Procurement. This provides access to the Supplier, Supplier Address and Name, and the Party Site.
TRANSIT_TIME_CODE VARCHAR2 500 code for transit times
FROM_ORGANIZATION_ID NUMBER 18 Unique identifier for the ship from organization in the shipment method relationship
TO_ORGANIZATION_ID NUMBER 18 Unique identifier for the ship to organization in the shipment method relationship
ORIGIN_TYPE VARCHAR2 2 Yes Origin Type: LI - Internal location, `LE external Location R - region, Z - zone
DESTINATION_TYPE VARCHAR2 2 Yes Destination Type: LI - Internal location, `LE external Location R - region, Z - zone
FROM_LOCATION_ID NUMBER 18 Unique identifier for the ship from location in the shipment method relationship
TO_LOCATION_ID NUMBER 18 Unique identifier for the ship to location in the shipment method relationship
FROM_REGION_ID NUMBER 18 Origin region or zone identifier
TO_REGION_ID NUMBER 18 Destination region or zone identifier
FROM_ZONE_ID NUMBER 18 Origin zone identifier
TO_ZONE_ID NUMBER 18 Destination zone identifier
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Foreign Keys

Table Foreign Table Foreign Key Column
wsh_transit_time_values wsh_transit_times TRANSIT_TIME_ID

Indexes

Index Uniqueness Tablespace Columns
WSH_TRANSIT_TIMES_U1 Unique Default TRANSIT_TIME_ID
WSH_TRANSIT_TIMES_U2 Unique Default ORIGIN_TYPE, DESTINATION_TYPE, FROM_LOCATION_ID, TO_LOCATION_ID, FROM_REGION_ID, TO_REGION_ID, FROM_ZONE_ID, TO_ZONE_ID