[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | WSH_CARRIER_SERVICES |
|---|---|
| Object Type: | TABLE |
| Owner: | WSH |
| FND Design Data: |  WSH.WSH_CARRIER_SERVICES
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| WSH_CARRIER_SERVICES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 CARRIER_SERVICE_ID
|
| WSH_CARRIER_SERVICES_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
SHIP_METHOD_CODE
|
| WSH_CARRIER_SERVICES_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CARRIER_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CARRIER_SERVICE_ID | NUMBER | Yes | Primary Key | |
| CARRIER_ID | NUMBER | (38) | Yes | |
| SERVICE_LEVEL | VARCHAR2 | (30) | ||
| MODE_OF_TRANSPORT | VARCHAR2 | (30) | ||
| SL_TIME_UOM | VARCHAR2 | (10) | ||
| MIN_SL_TIME | NUMBER | (38) | ||
| MAX_SL_TIME | NUMBER | (38) | ||
| ENABLED_FLAG | VARCHAR2 | (1) | ||
| WEB_ENABLED | VARCHAR2 | (1) | ||
| SHIP_METHOD_CODE | VARCHAR2 | (30) | Yes | |
| SHIP_METHOD_MEANING | VARCHAR2 | (240) | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ATTRIBUTE15 | VARCHAR2 | (150) | ||
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | (38) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (38) | Yes | |
| LAST_UPDATE_LOGIN | NUMBER | (38) | ||
| PROGRAM_APPLICATION_ID | NUMBER | (38) | ||
| PROGRAM_ID | NUMBER | (38) | ||
| PROGRAM_UPDATE_DATE | DATE | |||
| REQUEST_ID | NUMBER | (38) | ||
| MAX_NUM_STOPS_PERMITTED | NUMBER | Maximum number of stops permitted by Carrier | ||
| MAX_TOTAL_TIME | NUMBER | Maximum total time allowed per Truck Load | ||
| MAX_TOTAL_DISTANCE | NUMBER | Maximum miles allowed per Truck Load | ||
| ALLOW_INTERSPERSE_LOAD | VARCHAR2 | (1) | Does Carrier allow interspersing of pickups and dropoffs | |
| MIN_LAYOVER_TIME | NUMBER | Minimum layover time | ||
| MAX_LAYOVER_TIME | NUMBER | Maximum layover time. Beyond that it will be considered as an additional layover | ||
| MAX_TOTAL_DISTANCE_IN_24HR | NUMBER | Maximum total distance per day | ||
| MAX_DRIVING_TIME_IN_24HR | NUMBER | Maximum driving time per day | ||
| MAX_DUTY_TIME_IN_24HR | NUMBER | Maximum duty time per day | ||
| ALLOW_CONTINUOUS_MOVE | VARCHAR2 | (1) | Does the Carrier allow continuous move | |
| MAX_CM_DISTANCE | NUMBER | Maximum mileage for continuous move | ||
| MAX_CM_TIME | NUMBER | Maximum time for continous move | ||
| MAX_CM_DH_DISTANCE | NUMBER | Maximum deadhead distance allowed in continuous move | ||
| MAX_CM_DH_TIME | NUMBER | Maximum deadhead time allowed in continuous move | ||
| MIN_CM_DISTANCE | NUMBER | Minimum mileage in continuous move. If CM distance is less than this then CM discount is not applied | ||
| MIN_CM_TIME | NUMBER | Minimum time for continuous move | ||
| CM_FREE_DH_MILEAGE | NUMBER | In Continuous Move, Free Dead head Mileage. Default 0 | ||
| CM_FIRST_LOAD_DISCOUNT | VARCHAR2 | (1) | First load discount during the Continuous Move or not. | |
| CM_RATE_VARIANT | VARCHAR2 | (30) | Continuous Move Rating Method: Rate or Discount. By default Discount | |
| MAX_SIZE_WIDTH | NUMBER | Maximum width of parcel | ||
| MAX_SIZE_HEIGHT | NUMBER | Maximum height of parcel | ||
| MAX_SIZE_LENGTH | NUMBER | Maximum length of parcel | ||
| MIN_SIZE_WIDTH | NUMBER | Minimum width of parcel | ||
| MIN_SIZE_HEIGHT | NUMBER | Minimum height of parcel | ||
| MIN_SIZE_LENGTH | NUMBER | Minimum length of parcel | ||
| MAX_OUT_OF_ROUTE | NUMBER | If trip travel distance is longer than the expected distance, then this indicates maximum percentage above expected distance after which extra charge will be applied | ||
| DISTANCE_CALCULATION_METHOD | VARCHAR2 | (30) | Direct Route or full route. By default it is Full Route. | |
| ORIGIN_DSTN_SURCHARGE_LEVEL | VARCHAR2 | (30) | This field specifies the surcharge level like zip code, city, state or country | |
| UNIT_RATE_BASIS | VARCHAR2 | (30) | Unit Rate Basis - weight, volume, container or pallete | |
| DIM_DIMENSIONAL_FACTOR | NUMBER | Shipment / container volume is divided by this factor to obtain the DIM weight calculation. | ||
| DIM_WEIGHT_UOM | VARCHAR2 | (3) | DIM Weight calculation resulting Weight UOM. | |
| DIM_VOLUME_UOM | VARCHAR2 | (3) | Volume UOM on which the DIM weight calculation applies. | |
| DIM_DIMENSION_UOM | VARCHAR2 | (3) | Dimension UOM to be used to calculate package's volume. | |
| DIM_MIN_PACK_VOL | NUMBER | Minimum package volume above which DIM weight applies. | ||
| DEFAULT_VEHICLE_TYPE_ID | NUMBER | Default Vehicle to use for the Service level. | ||
| UPDATE_MOT_SL | VARCHAR2 | (1) | value Y means data needs to be updated with mode of transport and service level; value P means data is being updated; and null value means update has been completed or is not needed. |
Cut, paste (and edit) the following text to query this object:
SELECT CARRIER_SERVICE_ID
, CARRIER_ID
, SERVICE_LEVEL
, MODE_OF_TRANSPORT
, SL_TIME_UOM
, MIN_SL_TIME
, MAX_SL_TIME
, ENABLED_FLAG
, WEB_ENABLED
, SHIP_METHOD_CODE
, SHIP_METHOD_MEANING
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, MAX_NUM_STOPS_PERMITTED
, MAX_TOTAL_TIME
, MAX_TOTAL_DISTANCE
, ALLOW_INTERSPERSE_LOAD
, MIN_LAYOVER_TIME
, MAX_LAYOVER_TIME
, MAX_TOTAL_DISTANCE_IN_24HR
, MAX_DRIVING_TIME_IN_24HR
, MAX_DUTY_TIME_IN_24HR
, ALLOW_CONTINUOUS_MOVE
, MAX_CM_DISTANCE
, MAX_CM_TIME
, MAX_CM_DH_DISTANCE
, MAX_CM_DH_TIME
, MIN_CM_DISTANCE
, MIN_CM_TIME
, CM_FREE_DH_MILEAGE
, CM_FIRST_LOAD_DISCOUNT
, CM_RATE_VARIANT
, MAX_SIZE_WIDTH
, MAX_SIZE_HEIGHT
, MAX_SIZE_LENGTH
, MIN_SIZE_WIDTH
, MIN_SIZE_HEIGHT
, MIN_SIZE_LENGTH
, MAX_OUT_OF_ROUTE
, DISTANCE_CALCULATION_METHOD
, ORIGIN_DSTN_SURCHARGE_LEVEL
, UNIT_RATE_BASIS
, DIM_DIMENSIONAL_FACTOR
, DIM_WEIGHT_UOM
, DIM_VOLUME_UOM
, DIM_DIMENSION_UOM
, DIM_MIN_PACK_VOL
, DEFAULT_VEHICLE_TYPE_ID
, UPDATE_MOT_SL
FROM WSH.WSH_CARRIER_SERVICES;
WSH.WSH_CARRIER_SERVICES does not reference any database object
WSH.WSH_CARRIER_SERVICES is referenced by following:
APPS
WSH_CARRIER_SERVICES
|
|
|
|